/// <summary> /// 客户专享活动配置新增 /// </summary> /// <param name="conn"></param> /// <param name="customerExclusiveSettingModel">实体</param> /// <returns></returns> public static int InsertCustomerExclusiveSetting(SqlConnection conn, CustomerExclusiveSettingModel customerExclusiveSettingModel) { const string sqlInsertCustomerExclusiveSettin = @"INSERT INTO Activity.[dbo].[CustomerExclusiveSetting] ([ActivityExclusiveId] ,[OrderChannel] ,[LargeCustomersID] ,[LargeCustomersName] ,[EventLink] ,[ActivityId] ,[ImageUrl] ,[BusinessHotline] ,[IsEnable] ,[IsDelete] ,[CreateTime] ,[CreateBy]) VALUES (@ActivityExclusiveId ,@OrderChannel ,@LargeCustomersID ,@LargeCustomersName ,@EventLink ,@ActivityId ,@ImageUrl ,@BusinessHotline ,@IsEnable ,0 ,GETDATE() ,@CreateBy)"; return(conn.Execute(sqlInsertCustomerExclusiveSettin, customerExclusiveSettingModel, commandType: CommandType.Text)); }
/// <summary> /// 客户专享活动配置修改 /// </summary> /// <param name="customerExclusiveSettingModel"></param> /// <param name="user"></param> /// <returns></returns> public static int UpdateCustomerExclusiveSetting(CustomerExclusiveSettingModel customerExclusiveSettingModel, string user) { int result = 0; if (customerExclusiveSettingModel != null) { customerExclusiveSettingModel.UpdateBy = user; using (var conn = ProcessConnection.OpenGungnir) { var current = DalCustomerExclusiveSetting.SelectCustomerExclusive(conn, customerExclusiveSettingModel.ActivityId, customerExclusiveSettingModel.PKID).ToList(); if (current != null && current.Count() == 1) { result = -9; } else { var customerModel = DalCustomerExclusiveSetting.SelectCustomerExclusive(conn, customerExclusiveSettingModel.PKID).ToList(); if (customerModel != null && customerModel.Count() == 1) { var rows = DalCustomerExclusiveSetting.UpdateCustomerExclusiveSetting(conn, customerExclusiveSettingModel); result = rows == 1 ? 1 : 0; if (result == 1) { var log = new { ObjectId = customerExclusiveSettingModel.PKID, Source = "CustomerExclusiveSetting", ObjectType = "UpdateCustomerExclusiveSetting", BeforeValue = JsonConvert.SerializeObject(customerModel), AfterValue = JsonConvert.SerializeObject(customerExclusiveSettingModel), Remark = "客户专享活动配置修改", IsDeleted = 0, CreateDateTime = DateTime.Now, Creator = user }; LoggerManager.InsertLog("CustomerSetting", log); ActivityService.RefreshRedisCacheCustomerSetting(customerExclusiveSettingModel.ActivityExclusiveId); } } } } } return(result); }
public JsonResult InsertCustomerExclusiveSetting(CustomerExclusiveSettingModel customerExclusiveSettingModel) { int result = CustomersActivityManager.InsertCustomerExclusiveSetting(customerExclusiveSettingModel, User.Identity.Name); string message = "新增成功"; if (result == -9) { message = "限时抢购活动ID已经存在,请从新输入!"; } else if (result == 0) { message = "新增失败"; } return(Json(new { success = result == 1, msg = message })); }
/// <summary> /// 客户专享活动配置编辑 /// </summary> /// <param name="conn"></param> /// <param name="customerExclusiveSettingModel">实体</param> /// <returns></returns> public static int UpdateCustomerExclusiveSetting(SqlConnection conn, CustomerExclusiveSettingModel customerExclusiveSettingModel) { const string sqlUpdateCustomerExclusiveSettin = @"UPDATE Activity.[dbo].[CustomerExclusiveSetting] WITH(ROWLOCK) SET [OrderChannel] = @OrderChannel ,[LargeCustomersID] = @LargeCustomersID ,[LargeCustomersName] = @LargeCustomersName ,[EventLink] = @EventLink ,[ActivityId] = @ActivityId ,[ImageUrl] = @ImageUrl ,[BusinessHotline] = @BusinessHotline ,[IsEnable] =@IsEnable ,[IsDelete] = 0 ,[CreateTime] = GETDATE() WHERE PKID =@PKID"; return(conn.Execute(sqlUpdateCustomerExclusiveSettin, customerExclusiveSettingModel, commandType: CommandType.Text)); }
/// <summary> /// 客户专享活动配置新增 /// </summary> /// <param name="customerExclusiveSettingModel"></param> /// <param name="user"></param> /// <returns></returns> public static int InsertCustomerExclusiveSetting(CustomerExclusiveSettingModel customerExclusiveSettingModel, string user) { int result = 0; if (customerExclusiveSettingModel != null) { string guid = "" + System.Guid.NewGuid(); customerExclusiveSettingModel.ActivityExclusiveId = SecurityHelper.Hash(guid); customerExclusiveSettingModel.CreateBy = user; using (var conn = ProcessConnection.OpenGungnir) { var current = DalCustomerExclusiveSetting.SelectCustomerExclusive(conn, customerExclusiveSettingModel.ActivityId).ToList(); if (current != null && current.Count() == 1) { result = -9; } else { var rows = DalCustomerExclusiveSetting.InsertCustomerExclusiveSetting(conn, customerExclusiveSettingModel); result = rows == 1 ? 1 : 0; if (result == 1) { var log = new { ObjectId = DalCustomerExclusiveSetting.GetCustomerExclusiveSettingMaxPkId(conn), Source = "CustomerExclusiveSetting", ObjectType = "InsertCustomerExclusiveSetting", BeforeValue = "", AfterValue = JsonConvert.SerializeObject(customerExclusiveSettingModel), Remark = "客户专享活动配置新增", CreateDateTime = DateTime.Now, IsDeleted = 0, Creator = user }; LoggerManager.InsertLog("CustomerSetting", log); ActivityService.RefreshRedisCacheCustomerSetting(customerExclusiveSettingModel.ActivityExclusiveId); } } } } return(result); }