using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using CB.Entity;
using CB.Interface.Infrastructure;
using System.Data.SqlClient;
using System.Data;
using CB.Common;

namespace CB.Data.SqlServer
{
    public class TrendToolTemplateManage : Repository<TrendToolTemplateInfo>, ITrendToolTemplateService
    {
        public TrendToolTemplateManage(string interfaceId)
            : base(interfaceId)
        {
        }
        public override bool Save(TrendToolTemplateInfo entity)
        {
            throw new NotImplementedException();
        }

        public override bool Update(TrendToolTemplateInfo entity)
        {
            throw new NotImplementedException();
        }

        public override bool Delete(int Id)
        {
            throw new NotImplementedException();
        }

        public override TrendToolTemplateInfo Get<TKey>(TKey key)
        {
            SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@ID", key) };
            using (DataTable dt = DbHelper.ExecuteDatatable(InterfaceId,CommandType.StoredProcedure, "usp_TrendToolTemplate_Select", parameters))
            {
                TrendToolTemplateInfo list = new TrendToolTemplateInfo();
                if (dt != null && dt.Rows.Count > 0)
                {
                    DataRow dr = dt.Rows[0];
                    list = LoadEntity(dr);
                }
                return list;
            }
        }

        public override IList<TrendToolTemplateInfo> ToList()
        {
            SqlParameter[] parameters = new SqlParameter[] { };
            using (DataTable dt = DbHelper.ExecuteDatatable(InterfaceId,CommandType.StoredProcedure, "usp_TrendToolTemplate_List_Select", parameters))
            {
                List<TrendToolTemplateInfo> lists = new List<TrendToolTemplateInfo>();
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    lists.Add(LoadEntity(dt.Rows[i]));
                }
                return lists;
            }
        }

        public override IList<TrendToolTemplateInfo> ToList(TrendToolTemplateInfo entity)
        {
            throw new NotImplementedException();
        }

        public override IList<TrendToolTemplateInfo> ToPaging(TrendToolTemplateInfo entity, int pageSize, int pageIndex, out int recordCount)
        {
            throw new NotImplementedException();
        }
        protected override TrendToolTemplateInfo LoadEntity(DataRow dr)
        {
            return new TrendToolTemplateInfo
            {
                Id = TypeConverter.ObjectToInt(dr["id"]),
                TemplateName = dr["TemplateName"].ToString(),
                TemplateHTML = dr["TemplateHTML"].ToString()
            };
        }
        protected override TrendToolTemplateInfo LoadEntity(IDataReader dr)
        {
            return new TrendToolTemplateInfo
            {
                Id = TypeConverter.ObjectToInt(dr["id"]),
                TemplateName = dr["TemplateName"].ToString(),
                TemplateHTML = dr["TemplateHTML"].ToString()
            };
        }
    }
}