/// <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); }