using System;


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

namespace CB.Data.SqlServer
{
    public class TrendToolItemCssConfigManage : Repository<TrendToolItemCssConfigInfo>, ITrendToolItemCssConfigService
    {
        public TrendToolItemCssConfigManage(string interfaceId)
            : base(interfaceId)
        {
        }
        public override bool Save(TrendToolItemCssConfigInfo entity)
        {
            SqlParameter[] para = new SqlParameter[] {
                 new SqlParameter("@FilterCssID",entity.FilterCssID)
                ,new SqlParameter("@ItemID",entity.ItemID)
                ,new SqlParameter("@ElementClass",entity.ElementClass)
                ,new SqlParameter("@OtherHTML",entity.OtherHTML)
                ,new SqlParameter("@ControlNameID",entity.ControlNameID)
            };
            return TypeConverter.ObjectToInt(DbHelper.ExecuteScalar(InterfaceId,CommandType.StoredProcedure, "usp_TrendToolItemCssConfig_update", para)) > 0 ? true : false;
        }

        public override bool Update(TrendToolItemCssConfigInfo entity)
        {
            SqlParameter[] para = new SqlParameter[] {
                 new SqlParameter("@FilterCssID",entity.FilterCssID)
                ,new SqlParameter("@ItemID",entity.ItemID)
                ,new SqlParameter("@ElementClass",entity.ElementClass)
                ,new SqlParameter("@OtherHTML",entity.OtherHTML)
                ,new SqlParameter("@ControlNameID",entity.ControlNameID)
            };
            return TypeConverter.ObjectToInt(DbHelper.ExecuteScalar(InterfaceId,CommandType.StoredProcedure, "usp_TrendToolItemCssConfig_update", para)) > 0 ? true : false;
        }

        public override bool Delete(int Id)
        {
            SqlParameter[] para = new SqlParameter[] {
                 new SqlParameter("@FilterCssID",Id)
                  ,new SqlParameter("@ItemID",null)
            };
            return TypeConverter.ObjectToInt(DbHelper.ExecuteScalar(InterfaceId,CommandType.StoredProcedure, "usp_TrendToolItemCssConfig_del", para)) > 0 ? true : false;
        }
        public bool Delete(TrendToolItemCssConfigInfo Entity)
        {
            SqlParameter[] para = new SqlParameter[] {
                 new SqlParameter("@FilterCssID",Entity.FilterCssID)
                 ,new SqlParameter("@ItemID",Entity.ItemID)
            };
            return TypeConverter.ObjectToInt(DbHelper.ExecuteScalar(InterfaceId,CommandType.StoredProcedure, "usp_TrendToolItemCssConfig_del", para)) > 0 ? true : false;
        }

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

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

        public override IList<TrendToolItemCssConfigInfo> ToPaging(TrendToolItemCssConfigInfo entity, int pageSize, int pageIndex, out int recordCount)
        {
            throw new NotImplementedException();
        }

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

                }
                return list;
            }
        }
        public TrendToolItemCssConfigInfo Get(TrendToolItemCssConfigInfo entity)
        {
            SqlParameter[] parameters = new SqlParameter[] {  new SqlParameter("@FilterCssID",  entity.FilterCssID),
            new SqlParameter("@itemID", entity.ItemID) };
            using (DataTable dt = DbHelper.ExecuteDatatable(InterfaceId,CommandType.StoredProcedure, "usp_TrendToolItemCssConfig_Select", parameters))
            {
                TrendToolItemCssConfigInfo list = new TrendToolItemCssConfigInfo();
                if (dt != null && dt.Rows.Count > 0)
                {
                    DataRow dr = dt.Rows[0];
                    list = LoadEntity(dr);

                }
                return list;
            }
        }
        /// <summary>
        /// 将数据转换成TrendToolItemCssConfigInfo对象
        /// </summary>
        /// <param name="dr"></param>
        /// <returns></returns>
        protected override TrendToolItemCssConfigInfo LoadEntity(DataRow dr)
        {
            return new TrendToolItemCssConfigInfo
            {
                Id = TypeConverter.ObjectToInt(dr["FilterCssID"]),
                FilterCssID = TypeConverter.ObjectToInt(dr["FilterCssID"]),
                ItemID = TypeConverter.ObjectToInt(dr["ItemID"]),
                ElementClass = dr["ElementClass"].ToString(),
                OtherHTML = dr["OtherHTML"].ToString(),
                ControlNameID = dr["ControlNameID"].ToString()
            };
        }
    }
}