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];
|
}
|
}
|
}
|
}
|
