using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using CY.IDAL;
using System.Data.SqlClient;
using System.Data;
using CY.Infrastructure.DESEncrypt;
using CY.Infrastructure.Common;
using CY.Infrastructure.Query;
using CY.Model;

namespace CY.SQLDAL
{
    public class Promotion_IncomeRuleDAL : IPromotion_IncomeRuleDAL
    {
        private Database _dataBase = null;

        /// <summary>
        /// 实例化page对象的属性
        /// </summary>
        public Promotion_IncomeRuleDAL()
        {
            _dataBase = new Database();
        }

        public Promotion_IncomeRuleDAL(Database database)
        {
            _dataBase = database;
        }

        /// <summary>
        /// 新增
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool InserModel(Infrastructure.Domain.IAggregateRoot model)
        {
            Model.Promotion_IncomeRule trueModel = model as Model.Promotion_IncomeRule;
            if (trueModel == null)
            {
                return false;
            }
            IList<SqlParameter> sqlParms = new List<SqlParameter>()
            {
                    new SqlParameter("@SourceTypeId",trueModel.SourceTypeId),
					new SqlParameter("@PopularizeScore",trueModel.PopularizeScore){SqlDbType=SqlDbType.SmallMoney},
					new SqlParameter("@PopularizeNoteMoney",trueModel.PopularizeNoteMoney){SqlDbType=SqlDbType.SmallMoney},
					new SqlParameter("@SuperiorScore",trueModel.SuperiorScore){SqlDbType=SqlDbType.SmallMoney},
					new SqlParameter("@SuperiorNoteMoney",trueModel.SuperiorNoteMoney){SqlDbType=SqlDbType.SmallMoney},
					new SqlParameter("@IsRatio",trueModel.IsRatio),
					new SqlParameter("@DeputyDistrictRevenue",trueModel.DeputyDistrictRevenue){SqlDbType=SqlDbType.SmallMoney},
					new SqlParameter("@DeputyCityRevenue",trueModel.DeputyCityRevenue){SqlDbType=SqlDbType.SmallMoney},
                    new SqlParameter("@LastUpdateTime",trueModel.LastUpdateTime),
                    new SqlParameter("@Operator",trueModel.Operator),
					new SqlParameter("@Remark",trueModel.Remark) 
            };
            try
            {
                _dataBase.Query("sp_Promotion_IncomeRule_Insert", CommandType.StoredProcedure, sqlParms.ToArray<SqlParameter>());
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return true;
        }

        /// <summary>
        /// 修改
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool UpdateModel(Infrastructure.Domain.IAggregateRoot model)
        {
            Model.Promotion_IncomeRule trueModel = model as Model.Promotion_IncomeRule;
            if (trueModel == null)
            {
                return false;
            }
            IList<SqlParameter> sqlParms = new List<SqlParameter>()
                   {new SqlParameter("@Keyid",trueModel.Keyid),
                    new SqlParameter("@SourceTypeId",trueModel.SourceTypeId),
					new SqlParameter("@PopularizeScore",trueModel.PopularizeScore){SqlDbType=SqlDbType.SmallMoney},
					new SqlParameter("@PopularizeNoteMoney",trueModel.PopularizeNoteMoney){SqlDbType=SqlDbType.SmallMoney},
					new SqlParameter("@SuperiorScore",trueModel.SuperiorScore){SqlDbType=SqlDbType.SmallMoney},
					new SqlParameter("@SuperiorNoteMoney",trueModel.SuperiorNoteMoney){SqlDbType=SqlDbType.SmallMoney},
					new SqlParameter("@IsRatio",trueModel.IsRatio),
					new SqlParameter("@DeputyDistrictRevenue",trueModel.DeputyDistrictRevenue){SqlDbType=SqlDbType.SmallMoney},
					new SqlParameter("@DeputyCityRevenue",trueModel.DeputyCityRevenue){SqlDbType=SqlDbType.SmallMoney},
			          new SqlParameter("@LastUpdateTime",trueModel.LastUpdateTime){SqlDbType=SqlDbType.DateTime},
					new SqlParameter("@Operator",trueModel.Operator),
					new SqlParameter("@Remark",trueModel.Remark) 
            };
            try
            {
                _dataBase.Query("sp_Promotion_IncomeRule_Update", CommandType.StoredProcedure, sqlParms.ToArray<SqlParameter>());
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return true;
        }

        /// <summary>
        /// 删除
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public bool DeleteModel(Infrastructure.Domain.IAggregateRoot model)
        {
            Model.Promotion_IncomeRule trueModel = model as Model.Promotion_IncomeRule;
            if (trueModel == null)
            {
                return false;
            }
            IList<SqlParameter> sqlParms = new List<SqlParameter>()
            {
                new SqlParameter("@Keyid",trueModel.Keyid)
            };
            try
            {
                _dataBase.Query("sp_Promotion_IncomeRule_DeleteRow", CommandType.StoredProcedure, sqlParms.ToArray<SqlParameter>());
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return true;
        }

        /// <summary>
        /// 查询全部收益规则
        /// </summary>
        /// <returns></returns>
        public IEnumerable<Model.Promotion_IncomeRule> SelectAllIncomeRule(Pagination pa)
        {
            string selectTarget = "a.Name as SourceTypeName,b.*";
            string fromSouce = "Promotion_IncomeRule as b   inner join  Sys_Dictionary as  a on(a.Keyid = b.SourceTypeId)";
            return _dataBase.SelectModelPage<Promotion_IncomeRule>(pa, selectTarget, fromSouce, "b.Remark ASC");

        }

        /// <summary>
        /// 查询单个收益规则
        /// </summary>
        /// <param name="Keyid"></param>
        /// <returns></returns>
        public Promotion_IncomeRule GetSingleModel(string Keyid)
        {

            string selectTarget = "a.Name as SourceTypeName,b.*";

            string fromSouce = "Promotion_IncomeRule as b   inner join  Sys_Dictionary as  a on( b.Keyid='" + Keyid + "' and a.Keyid = b.SourceTypeId)";
            IList<Promotion_IncomeRule> m_Promotion_IncomeRule = _dataBase.SelectModel<Promotion_IncomeRule>(selectTarget, fromSouce);
            if (m_Promotion_IncomeRule == null || m_Promotion_IncomeRule.Count == 0)
            {
                return null;
            }
            else
            {
                return m_Promotion_IncomeRule[0];
            }
        }

        /// <summary>
        /// <para>通过来源类型查询单个收益规则</para> 
        /// <para>36 买家会员注册费</para> 
        /// <para>393 个人网店注册费</para> 
        /// <para>89 印刷厂商注册费</para> 
        /// <para>391 登录</para> 
        /// <para>38 发布印刷需求</para> 
        /// <para>292 发布需求信息</para> 
        /// <para>86 账户充值</para> 
        /// <para>87 印刷订单</para> 
        /// <para>88 纸张订单</para> 
        /// <para>90 杂志广告费</para> 
        /// <para>392 网站广告费</para> 
        /// <para>91 管理软件费</para> 
        /// <para>92 办公家具订单</para> 
        ///<para> 93 办公电脑设备订单</para> 
        /// <para>94 办公文具订单</para> 
        /// <para>95 其他商城订单</para> 
        /// <para>96 发布求职简历</para> 
        /// <para>290 发布秒杀业务</para> 
        /// <para>291 发布特价信息</para> 
        /// </summary>
        /// <param name="SourceTypeId"></param>
        /// <returns></returns>
        public Promotion_IncomeRule GetModelBySourceTypeId(int? SourceTypeId)
        {

            string selectTarget = "a.Name as SourceTypeName,b.*";

            string fromSouce = "Promotion_IncomeRule as b   inner join  Sys_Dictionary as  a on( b.SourceTypeId='" + SourceTypeId + "' and a.Keyid = b.SourceTypeId)";
            IList<Promotion_IncomeRule> m_Promotion_IncomeRule = _dataBase.SelectModel<Promotion_IncomeRule>(selectTarget, fromSouce);
            if (m_Promotion_IncomeRule == null || m_Promotion_IncomeRule.Count == 0)
            {
                return null;
            }
            else
            {
                return m_Promotion_IncomeRule[0];
            }
        }
    }
}