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

namespace CB.Data.SqlServer
{
    class TrendToolManage : Repository<TrendToolInfo>, ITrendToolService
    {
        public TrendToolManage(string interfaceId)
            : base(interfaceId)
        {
        }
        public override bool Save(TrendToolInfo entity)
        {
            SqlParameter[] para = new SqlParameter[] {
                 new SqlParameter("@ID",entity.Id)
                ,new SqlParameter("@ToolName", entity.ToolName)
                //,new SqlParameter("@ToolType",entity.ToolType)
                ,new SqlParameter("@Title",entity.Title)
                 ,new SqlParameter("@Remark",entity.Remark)
                 ,new SqlParameter("@PageID",entity.PageID)
                 ,new SqlParameter("@ParentID",entity.ParentID)
                 ,new SqlParameter("@ItemValue",entity.ItemValue)
                 ,new SqlParameter("@FilterCodeType",entity.FilterCodeType)
                 ,new SqlParameter("@ItemCount",entity.ItemCount)
                 ,new SqlParameter("@IndexStart",entity.IndexStart)
                 ,new SqlParameter("@IndexEnd",entity.IndexEnd)
                 ,new SqlParameter("@TemplateHTML",entity.TemplateHTML)
                 ,new SqlParameter("@HTML",entity.HTML)
                 ,new SqlParameter("@STATUS",entity.Status)
                 ,new SqlParameter("@FilterFunEnum",entity.FilterFunEnum)
                 ,new SqlParameter("@IsSaveData",entity.IsSaveData)
                 ,new SqlParameter("@ToolOrder",entity.ToolOrder)
            };
            return TypeConverter.ObjectToInt(DbHelper.ExecuteScalar(InterfaceId,CommandType.StoredProcedure, "usp_TrendTool_Save", para)) > 0 ? true : false;
        }

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

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

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

        }

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

        public override IList<TrendToolInfo> ToList(TrendToolInfo entity)
        {
            SqlParameter[] parameters = new SqlParameter[] { 
                  new SqlParameter("@Id", entity.Id)
                , new SqlParameter("@PageID", entity.PageID)
                , new SqlParameter("@ParentID", entity.ParentID)
                , new SqlParameter("@Status", entity.Status)
            };

            using (DataTable dt = DbHelper.ExecuteDatatable(InterfaceId,CommandType.StoredProcedure, "usp_TrendTool_List_Select", parameters))
            {
                List<TrendToolInfo> lists = new List<TrendToolInfo>();
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    lists.Add(LoadEntity(dt.Rows[i]));
                }
                return lists;
            }
        }

        public IList<TrendToolInfo> ChildToList(TrendToolInfo entity)
        {
            SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@Id", entity.Id) };
            using (DataTable dt = DbHelper.ExecuteDatatable(InterfaceId,CommandType.StoredProcedure, "usp_TrendTool_ChildList_Select", parameters))
            {
                List<TrendToolInfo> lists = new List<TrendToolInfo>();
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    lists.Add(LoadEntity(dt.Rows[i]));
                }
                return lists;
            }
        }

        public override IList<TrendToolInfo> ToPaging(TrendToolInfo entity, int pageSize, int pageIndex, out int recordCount)
        {
            throw new NotImplementedException();
        }
        
        protected override TrendToolInfo LoadEntity(IDataReader reader)
        {
            return new TrendToolInfo
            {
                Id = TypeConverter.ObjectToInt(reader["Id"]),
                ToolName = reader["ToolName"].ToString(),
                //ToolType = TypeConverter.StringToEnum<ToolType>(reader["ToolType"].ToString()),
                Title = reader["Title"].ToString(),
                Remark = reader["Remark"].ToString(),
                PageID = TypeConverter.StrToInt(reader["PageID"].ToString()),
                ParentID = TypeConverter.StrToInt(reader["ParentID"].ToString()),
                ItemValue = reader["ItemValue"].ToString(),
                FilterCodeType = TypeConverter.StringToEnum<FilterCodeType>(reader["FilterCodeType"].ToString()),
                ItemCount = TypeConverter.StrToInt(reader["ItemCount"].ToString()),
                IndexStart = TypeConverter.StrToInt(reader["IndexStart"].ToString(),-1),
                IndexEnd = TypeConverter.StrToInt(reader["IndexEnd"].ToString(), -1),
                TemplateHTML = reader["TemplateHTML"].ToString(),
                HTML = reader["HTML"].ToString(),
                Status = TypeConverter.StringToEnum<FilterStatus>(reader["Status"].ToString()),
                FilterFunEnum = TypeConverter.StringToEnum<FilterType>(reader["FilterFunEnum"].ToString()),
                IsSaveData = TypeConverter.StrToBool(reader["IsSaveData"].ToString(), false),
                CreateTime = TypeConverter.StrToDateTime(reader["CreateTime"].ToString()),
                LastUpdate = TypeConverter.StrToDateTime(reader["LastUpdate"].ToString()),
                ToolOrder = TypeConverter.StrToInt(reader["ToolOrder"].ToString()),
            };
        }
        /// <summary>
        /// 数据转换实体
        /// </summary>
        /// <param name="dr"></param>
        /// <returns></returns>
        protected override TrendToolInfo LoadEntity(DataRow dr)
        {
            return new TrendToolInfo
            {
                Id = TypeConverter.ObjectToInt(dr["Id"]),
                ToolName = dr["ToolName"].ToString(),
                //ToolType = TypeConverter.StringToEnum<ToolType>(dr["ToolType"].ToString()),
                Title = dr["Title"].ToString(),
                Remark = dr["Remark"].ToString(),
                PageID = TypeConverter.StrToInt(dr["PageID"].ToString()),
                ParentID = TypeConverter.StrToInt(dr["ParentID"].ToString()),
                ItemValue = dr["ItemValue"].ToString(),
                FilterCodeType = TypeConverter.StringToEnum<FilterCodeType>(dr["FilterCodeType"].ToString()),
                ItemCount = TypeConverter.StrToInt(dr["ItemCount"].ToString()),
                IndexStart = TypeConverter.StrToInt(dr["IndexStart"].ToString(), -1),
                IndexEnd = TypeConverter.StrToInt(dr["IndexEnd"].ToString(), -1),
                TemplateHTML = dr["TemplateHTML"].ToString(),
                HTML = dr["HTML"].ToString(),
                Status = TypeConverter.StringToEnum<FilterStatus>(dr["Status"].ToString()),
                FilterFunEnum = TypeConverter.StringToEnum<FilterType>(dr["FilterFunEnum"].ToString()),
                IsSaveData = TypeConverter.StrToBool(dr["IsSaveData"].ToString(), false),
                CreateTime = TypeConverter.StrToDateTime(dr["CreateTime"].ToString()),
                LastUpdate = TypeConverter.StrToDateTime(dr["LastUpdate"].ToString()),
                ToolOrder = TypeConverter.StrToInt(dr["ToolOrder"].ToString()),
            };
        }
    }
}