/// <summary> /// 更新优惠券审核记录 /// </summary> /// <param name="request"></param> /// <param name="cancellationToken"></param> /// <returns></returns> public async Task <int> UpdateCouponGetRuleAuditAsync(GetCouponRuleAuditModel request, CancellationToken cancellationToken) { GetCouponRuleAuditEntity entity = ObjectMapper.ConvertTo <GetCouponRuleAuditModel, GetCouponRuleAuditEntity>(request); int pkid = await _ICouponGetRuleAuditRepository.UpdateAsync(entity, cancellationToken).ConfigureAwait(false) ? entity.PKID : 0; return(pkid); }
/// <summary> /// 创建优惠券领取规则记录 /// </summary> /// <param name="request"></param> /// <param name="cancellationToken"></param> /// <returns></returns> public async Task <int> CreateCouponGetRuleAsync(CreateCouponGetRuleAuditRequest request, CancellationToken cancellationToken) { try { GetCouponRuleAuditEntity entity = ObjectMapper.ConvertTo <CreateCouponGetRuleAuditRequest, GetCouponRuleAuditEntity>(request); var pkid = await _ICouponGetRuleAuditRepository.CreateAsync(entity, cancellationToken).ConfigureAwait(false); return(pkid); } catch (Exception ex) { _logger.Error($"CreateCouponGetRuleAuditAsync Exception {JsonConvert.SerializeObject(request)}", ex); return(0); } }
/// <summary> /// Create 优惠券审核记录 /// </summary> /// <param name="entity"></param> /// <param name="cancellationToken"></param> /// <returns></returns> public async ValueTask <int> CreateAsync(GetCouponRuleAuditEntity entity, CancellationToken cancellationToken) { #region sql string sql = $@"INSERT INTO {DBName} ([GetCouponRulePKID] ,[RuleID] ,[Description] ,[PromtionName] ,Discount ,Minmoney ,[AllowChanel] ,[Term] ,[ValiStartDate] ,[ValiEndDate] ,[Quantity] ,[GetQuantity] ,[SingleQuantity] ,[DXStartDate] ,[DXEndDate] ,[GetRuleGUID] ,[Channel] ,[SupportUserRange] ,[DetailShowStartDate] ,[DetailShowEndDate] ,[DepartmentId] ,[IntentionId] ,[Creater] ,[DepartmentName] ,[IntentionName] ,[CouponType] ,[DeadLineDate] ,[IsPush] ,[PushSetting] ,[BusinessLineId] ,[BusinessLineName] ,[RemindQuantity] ,[RemindEmails] ,[Applicant] ,[Auditor] ,[AuditDateTime] ,[AuditStatus] ,[AuditMessage] ,[WorkOrderId] ,[CreateDateTime] ,[LastUpdateDateTime] ) VALUES ( @GetCouponRulePKID ,@RuleID ,@Description ,@PromtionName ,@Discount ,@Minmoney ,@AllowChanel ,@Term ,@ValiStartDate ,@ValiEndDate ,@Quantity ,@GetQuantity ,@SingleQuantity ,@DXStartDate ,@DXEndDate ,@GetRuleGUID ,@Channel ,@SupportUserRange ,@DetailShowStartDate ,@DetailShowEndDate ,@DepartmentId ,@IntentionId ,@Creater ,@DepartmentName ,@IntentionName ,@CouponType ,@DeadLineDate ,@IsPush ,@PushSetting ,@BusinessLineId ,@BusinessLineName ,@RemindQuantity ,@RemindEmails ,@Applicant ,@Auditor ,getdate() ,@AuditStatus ,@AuditMessage ,@WorkOrderId ,getdate() ,getdate() ); select SCOPE_IDENTITY();"; //返回pkid #endregion using (var dbHelper = _factory.CreateDbHelper("Activity", false)) { using (var cmd = new SqlCommand(sql)) { cmd.CommandType = CommandType.Text; cmd.Parameters.Add(new SqlParameter("@GetCouponRulePKID", entity.GetCouponRulePKID)); cmd.Parameters.Add(new SqlParameter("@RuleID", entity.RuleID)); cmd.Parameters.Add(new SqlParameter("@Description", entity.Description ?? "")); cmd.Parameters.Add(new SqlParameter("@PromtionName", entity.PromtionName ?? "")); cmd.Parameters.Add(new SqlParameter("@Discount", entity.Discount)); cmd.Parameters.Add(new SqlParameter("@Minmoney", entity.Minmoney)); cmd.Parameters.Add(new SqlParameter("@AllowChanel", entity.AllowChanel)); cmd.Parameters.Add(new SqlParameter("@Term", entity.Term)); cmd.Parameters.Add(new SqlParameter("@ValiStartDate", entity.ValiStartDate)); cmd.Parameters.Add(new SqlParameter("@ValiEndDate", entity.ValiEndDate)); cmd.Parameters.Add(new SqlParameter("@Quantity", entity.Quantity)); cmd.Parameters.Add(new SqlParameter("@GetQuantity", entity.GetQuantity)); cmd.Parameters.Add(new SqlParameter("@SingleQuantity", entity.SingleQuantity)); cmd.Parameters.Add(new SqlParameter("@DXStartDate", entity.DXStartDate)); cmd.Parameters.Add(new SqlParameter("@DXEndDate", entity.DXEndDate)); cmd.Parameters.Add(new SqlParameter("@GetRuleGUID", entity.GetRuleGUID)); cmd.Parameters.Add(new SqlParameter("@Channel", entity.Channel ?? "")); cmd.Parameters.Add(new SqlParameter("@SupportUserRange", entity.SupportUserRange)); cmd.Parameters.Add(new SqlParameter("@DetailShowStartDate", entity.DetailShowStartDate)); cmd.Parameters.Add(new SqlParameter("@DetailShowEndDate", entity.DetailShowEndDate)); cmd.Parameters.Add(new SqlParameter("@DepartmentId", entity.DepartmentId)); cmd.Parameters.Add(new SqlParameter("@IntentionId", entity.IntentionId)); cmd.Parameters.Add(new SqlParameter("@Creater", entity.Creater ?? "")); cmd.Parameters.Add(new SqlParameter("@DepartmentName", entity.DepartmentName ?? "")); cmd.Parameters.Add(new SqlParameter("@IntentionName", entity.IntentionName ?? "")); cmd.Parameters.Add(new SqlParameter("@CouponType", entity.CouponType)); cmd.Parameters.Add(new SqlParameter("@DeadLineDate", entity.DeadLineDate)); cmd.Parameters.Add(new SqlParameter("@IsPush", entity.IsPush)); cmd.Parameters.Add(new SqlParameter("@PushSetting", entity.PushSetting ?? "")); cmd.Parameters.Add(new SqlParameter("@BusinessLineId", entity.BusinessLineId)); cmd.Parameters.Add(new SqlParameter("@BusinessLineName", entity.BusinessLineName ?? "")); cmd.Parameters.Add(new SqlParameter("@RemindQuantity", entity.RemindQuantity)); cmd.Parameters.Add(new SqlParameter("@RemindEmails", entity.RemindEmails ?? "")); cmd.Parameters.Add(new SqlParameter("@Applicant", entity.Applicant ?? "")); cmd.Parameters.Add(new SqlParameter("@Auditor", entity.Auditor ?? "")); //cmd.Parameters.Add(new SqlParameter("@AuditDateTime", entity.AuditDateTime)); cmd.Parameters.Add(new SqlParameter("@AuditStatus", entity.AuditStatus)); cmd.Parameters.Add(new SqlParameter("@AuditMessage", entity.AuditMessage ?? "")); cmd.Parameters.Add(new SqlParameter("@WorkOrderId", entity.WorkOrderId)); try { var temp = await dbHelper.ExecuteScalarAsync(cmd, cancellationToken).ConfigureAwait(false); return(Convert.ToInt32(temp)); } catch (Exception ex) { _logger.Error($"CouponGetRuleAuditRepository CreateAsyncException = {JsonConvert.SerializeObject(ex)} & entity= {JsonConvert.SerializeObject(entity)}", ex); return(0); } } } }
/// <summary> /// Update 优惠券审核记录 /// </summary> /// <param name="entity"></param> /// <param name="cancellationToken"></param> /// <returns></returns> public async ValueTask <bool> UpdateAsync(GetCouponRuleAuditEntity entity, CancellationToken cancellationToken) { #region sql string sql = $@"UPDATE {DBName} SET [GetCouponRulePKID] = @GetCouponRulePKID ,[RuleID] = @RuleID ,[Description] = @Description ,[PromtionName] = @PromtionName ,[Discount] = @Discount ,[Minmoney] = @Minmoney ,[AllowChanel] = @AllowChanel ,[Term] = @Term ,[ValiStartDate] = @ValiStartDate ,[ValiEndDate] = @ValiEndDate ,[Quantity] = @Quantity ,[GetQuantity] = @GetQuantity ,[SingleQuantity] = @SingleQuantity ,[DXStartDate] = @DXStartDate ,[DXEndDate] = @DXEndDate ,[GetRuleGUID] = @GetRuleGUID ,[Channel] = @Channel ,[SupportUserRange] = @SupportUserRange ,[DetailShowStartDate] = @DetailShowStartDate ,[DetailShowEndDate] = @DetailShowEndDate ,[DepartmentId] = @DepartmentId ,[IntentionId] = @IntentionId ,[Creater] = @Creater ,[DepartmentName] = @DepartmentName ,[IntentionName] = @IntentionName ,[CouponType] = @CouponType ,[DeadLineDate] = @DeadLineDate ,[IsPush] = @IsPush ,[PushSetting] = @PushSetting ,[BusinessLineId] = @BusinessLineId ,[BusinessLineName] = @BusinessLineName ,[RemindQuantity] = @RemindQuantity ,[RemindEmails] = @RemindEmails ,[Applicant] = @Applicant ,[Auditor] = @Auditor ,[AuditDateTime] = @AuditDateTime ,[AuditStatus] = @AuditStatus ,[AuditMessage] = @AuditMessage ,[WorkOrderId] = @WorkOrderId ,[LastUpdateDateTime] = getdate() where PKID =@PKID ;"; #endregion using (var dbHelper = _factory.CreateDbHelper("Activity", false)) { using (var cmd = new SqlCommand(sql)) { cmd.CommandType = CommandType.Text; cmd.Parameters.Add(new SqlParameter("@PKID", entity.PKID)); cmd.Parameters.Add(new SqlParameter("@GetCouponRulePKID", entity.GetCouponRulePKID)); cmd.Parameters.Add(new SqlParameter("@RuleID", entity.RuleID)); cmd.Parameters.Add(new SqlParameter("@Description", entity.Description)); cmd.Parameters.Add(new SqlParameter("@PromtionName", entity.PromtionName)); cmd.Parameters.Add(new SqlParameter("@Discount", entity.Discount)); cmd.Parameters.Add(new SqlParameter("@Minmoney", entity.Minmoney)); cmd.Parameters.Add(new SqlParameter("@AllowChanel", entity.AllowChanel)); cmd.Parameters.Add(new SqlParameter("@Term", entity.Term)); cmd.Parameters.Add(new SqlParameter("@ValiStartDate", entity.ValiStartDate)); cmd.Parameters.Add(new SqlParameter("@ValiEndDate", entity.ValiEndDate)); cmd.Parameters.Add(new SqlParameter("@Quantity", entity.Quantity)); cmd.Parameters.Add(new SqlParameter("@GetQuantity", entity.GetQuantity)); cmd.Parameters.Add(new SqlParameter("@SingleQuantity", entity.SingleQuantity)); cmd.Parameters.Add(new SqlParameter("@DXStartDate", entity.DXStartDate)); cmd.Parameters.Add(new SqlParameter("@DXEndDate", entity.DXEndDate)); cmd.Parameters.Add(new SqlParameter("@GetRuleGUID", entity.GetRuleGUID)); cmd.Parameters.Add(new SqlParameter("@Channel", entity.Channel)); cmd.Parameters.Add(new SqlParameter("@SupportUserRange", entity.SupportUserRange)); cmd.Parameters.Add(new SqlParameter("@DetailShowStartDate", entity.DetailShowStartDate)); cmd.Parameters.Add(new SqlParameter("@DetailShowEndDate", entity.DetailShowEndDate)); cmd.Parameters.Add(new SqlParameter("@DepartmentId", entity.DepartmentId)); cmd.Parameters.Add(new SqlParameter("@IntentionId", entity.IntentionId)); cmd.Parameters.Add(new SqlParameter("@Creater", entity.Creater)); cmd.Parameters.Add(new SqlParameter("@DepartmentName", entity.DepartmentName)); cmd.Parameters.Add(new SqlParameter("@IntentionName", entity.IntentionName)); cmd.Parameters.Add(new SqlParameter("@CouponType", entity.CouponType)); cmd.Parameters.Add(new SqlParameter("@DeadLineDate", entity.DeadLineDate)); cmd.Parameters.Add(new SqlParameter("@IsPush", entity.IsPush)); cmd.Parameters.Add(new SqlParameter("@PushSetting", entity.PushSetting)); cmd.Parameters.Add(new SqlParameter("@BusinessLineId", entity.BusinessLineId)); cmd.Parameters.Add(new SqlParameter("@BusinessLineName", entity.BusinessLineName)); cmd.Parameters.Add(new SqlParameter("@RemindQuantity", entity.RemindQuantity)); cmd.Parameters.Add(new SqlParameter("@RemindEmails", entity.RemindEmails)); cmd.Parameters.Add(new SqlParameter("@Applicant", entity.Applicant)); cmd.Parameters.Add(new SqlParameter("@Auditor", entity.Auditor)); cmd.Parameters.Add(new SqlParameter("@AuditDateTime", entity.AuditDateTime)); cmd.Parameters.Add(new SqlParameter("@AuditStatus", entity.AuditStatus)); cmd.Parameters.Add(new SqlParameter("@AuditMessage", entity.AuditMessage ?? "")); cmd.Parameters.Add(new SqlParameter("@WorkOrderId", entity.WorkOrderId)); var result = (await dbHelper.ExecuteNonQueryAsync(cmd, cancellationToken).ConfigureAwait(false)); return(result > 0); } } }