/// <summary>
/// 修改商家分组
/// danny-20150506
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateBusinessGroup(BusinessGroupModel model)
{
string sql = @"UPDATE [BusinessGroup]
SET Name=@Name,
StrategyId=@StrategyId,
UpdateBy=@UpdateBy,
UpdateTime=getdate()
OUTPUT DELETED.Name,
DELETED.StrategyId,
getdate(),
Inserted.UpdateBy,
@Remark
INTO BusinessGroupLog
(Name,
StrategyId,
InsertTime,
OptName,
Remark)
WHERE Id=@Id; ";
IDbParameters parm = DbHelper.CreateDbParameters();
parm.AddWithValue("@Id", model.Id);
parm.AddWithValue("@Name", model.Name);
parm.AddWithValue("@StrategyId", model.StrategyId);
parm.AddWithValue("@UpdateBy", model.UpdateBy);
parm.AddWithValue("@Remark", "修改商家分组信息");
return(DbHelper.ExecuteNonQuery(SuperMan_Write, sql, parm) > 0 ? true : false);
}
/// <summary>
/// 添加商家分组
/// danny-20150506
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int AddBusinessGroup(BusinessGroupModel model)
{
string sql = @"INSERT INTO [BusinessGroup]
(
[Name]
,[StrategyId]
,[CreateBy]
,[CreateTime]
,[UpdateBy]
)
OUTPUT Inserted.Name,
Inserted.StrategyId,
getdate(),
Inserted.CreateBy,
@Remark
INTO BusinessGroupLog
(Name,
StrategyId,
InsertTime,
OptName,
Remark)
VALUES
(@Name
,@StrategyId
,@CreateBy
,getdate()
,@CreateBy
); SELECT IDENT_CURRENT('BusinessGroup') --SELECT @@IDENTITY ";
IDbParameters parm = DbHelper.CreateDbParameters();
parm.AddWithValue("@Name", model.Name);
parm.AddWithValue("@StrategyId", model.StrategyId);
parm.AddWithValue("@CreateBy", model.CreateBy);
parm.AddWithValue("@Remark", "添加商家分组信息");
return(ParseHelper.ToInt(DbHelper.ExecuteScalar(SuperMan_Write, sql, parm)));
}
/// <summary>
/// 添加商家分组
/// danny-20150506
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool ModifySubsidyFormulaMode(GlobalConfigModel globalConfigModel)
{
using (IUnitOfWork tran = EdsUtilOfWorkFactory.GetUnitOfWorkOfEDS())
{
if (globalConfigModel.GroupId == 0) //新增
{
BusinessGroupModel businessGroupModel = new BusinessGroupModel()
{
Name = globalConfigModel.GroupName,
StrategyId = globalConfigModel.StrategyId,
CreateBy = globalConfigModel.OptName
};
globalConfigModel.GroupId = businessGroupDao.AddBusinessGroup(businessGroupModel);
if (globalConfigModel.GroupId > 0)
{
var r = businessGroupDao.CopyGlobalConfigMode(globalConfigModel.GroupId, globalConfigModel.OptName);
}
}
else //修改
{
BusinessGroupModel businessGroupModel = new BusinessGroupModel()
{
Id = globalConfigModel.GroupId,
Name = globalConfigModel.GroupName,
StrategyId = globalConfigModel.StrategyId,
UpdateBy = globalConfigModel.OptName
};
businessGroupDao.UpdateBusinessGroup(businessGroupModel);
}
#region 动态时间补贴
Ets.Model.Common.GlobalConfig globalConfig = new Ets.Model.Common.GlobalConfig()
{
KeyName = "IsStarTimeSubsidies",
Value = globalConfigModel.IsStarTimeSubsidies,
GroupId = globalConfigModel.GroupId,
StrategyId = globalConfigModel.StrategyId,
OptName = globalConfigModel.OptName
};
businessGroupDao.UpdateGlobalConfig(globalConfig);
#endregion
#region 跨店时间奖励
globalConfig.KeyName = "IsStartOverStoreSubsidies";
globalConfig.Value = globalConfigModel.IsStartOverStoreSubsidies;
businessGroupDao.UpdateGlobalConfig(globalConfig);
#endregion
#region 补贴策略
switch (globalConfigModel.StrategyId) //使用switch-case开关语句，根据按键次数执行相应分支
{
case 0: //普通补贴
globalConfig.KeyName = "CommonCommissionRatio";
globalConfig.Value = globalConfigModel.CommonCommissionRatio;
businessGroupDao.UpdateGlobalConfig(globalConfig);
globalConfig.KeyName = "CommonSiteSubsidies";
globalConfig.Value = globalConfigModel.CommonSiteSubsidies;
businessGroupDao.UpdateGlobalConfig(globalConfig);
break;
case 1: //时间段补贴
globalConfig.KeyName = "TimeSpanCommissionRatio";
globalConfig.Value = globalConfigModel.TimeSpanCommissionRatio;
businessGroupDao.UpdateGlobalConfig(globalConfig);
globalConfig.KeyName = "TimeSpanInPrice";
globalConfig.Value = globalConfigModel.TimeSpanInPrice;
businessGroupDao.UpdateGlobalConfig(globalConfig);
globalConfig.KeyName = "TimeSpanOutPrice";
globalConfig.Value = globalConfigModel.TimeSpanOutPrice;
businessGroupDao.UpdateGlobalConfig(globalConfig);
break;
case 2: //保本补贴
globalConfig.KeyName = "CommissionRatio";
globalConfig.Value = globalConfigModel.CommissionRatio;
businessGroupDao.UpdateGlobalConfig(globalConfig);
globalConfig.KeyName = "SiteSubsidies";
globalConfig.Value = globalConfigModel.SiteSubsidies;
businessGroupDao.UpdateGlobalConfig(globalConfig);
break;
case 3: //满金额补贴
globalConfig.KeyName = "PriceCommissionRatio";
globalConfig.Value = globalConfigModel.PriceCommissionRatio;
businessGroupDao.UpdateGlobalConfig(globalConfig);
globalConfig.KeyName = "PriceSiteSubsidies";
globalConfig.Value = globalConfigModel.PriceSiteSubsidies;
businessGroupDao.UpdateGlobalConfig(globalConfig);
break;
}
#endregion
DeleteGlobalConfigRedisByGroupId(globalConfigModel.GroupId);
tran.Complete();
}
return(true);
}
