public ResponseModel CommmitFeedback(FeedbackRequestParams feedbackParams) { //校验参数是否为空 ResponseModel checkResult; var result = CheckRequestParamIsNull(feedbackParams, out checkResult); return(!result ? checkResult : FunctionReturn(_feedbackService.CommmitFeedback(GetUserContext(), feedbackParams))); }
/// <summary> /// 更新后台系统统计信息 /// </summary> /// <returns></returns> public bool UpdateSysAccountInfo(UserContext userContext, FeedbackRequestParams feedbackRequestParams) { var columnName = string.Empty; switch ((FeedbackTypeEnum)feedbackRequestParams.FeedbackType) { case FeedbackTypeEnum.TelephoneFeedback: columnName = "feedbackTel"; break; case FeedbackTypeEnum.QqFeedback: columnName = "feedbackQQ"; break; } var strSql = new StringBuilder(); strSql.Append(" if(EXISTS(select * from Sys_Account where accid=@accountId)) "); strSql.Append(" begin "); strSql.Append(" update Sys_Account "); strSql.Append(" set " + columnName + "= @updateValue "); strSql.Append(" where accid=@accountId;"); strSql.Append(" end "); strSql.Append(" else "); strSql.Append(" begin "); strSql.Append(" insert into Sys_Account (accid," + columnName + ") "); strSql.Append(" values(@accountId,@updateValue); "); strSql.Append(" end "); var sqlParams = new { accountId = userContext.AccId, updateValue = feedbackRequestParams.FeedbackTelPhone }; var dapperParam = new DynamicParameters(sqlParams); var sqlQuery = new SqlQuery(strSql.ToString(), dapperParam); var insertResult = _sysAccountDapperRepository.FindAll(sqlQuery); return(insertResult != null && insertResult.Any()); }
/// <summary> /// 提交反馈 /// </summary> /// <param name="userContext"></param> /// <param name="feedbackParams"></param> /// <returns></returns> public ResponseModel CommmitFeedback(UserContext userContext, FeedbackRequestParams feedbackParams) { //1.判断反馈是否低于10分钟,低于10分钟则不允许提交 var checkLessThanTenMinutesResult = CheckCommitFeedbackIsLessThanTenMinutes(userContext); if (checkLessThanTenMinutesResult) { return(new ResponseModel { Code = (int)ErrorCodeEnum.FeedbackLessThanTenMinutes }); } //2.插入反馈记录 SysTaskDaily insertFeedbackModel; var iResult = InsertFeedbacks(userContext, feedbackParams, out insertFeedbackModel); //3.后台系统统计信息 if (!iResult) { return(new ResponseModel { Code = (int)ErrorCodeEnum.FeedbackFail }); } //3.1异常处理后台统计消息 if (!string.IsNullOrEmpty(feedbackParams.FeedbackTelPhone)) { Task.Run(() => { UpdateSysAccountInfo(userContext, feedbackParams); }); } return(new ResponseModel { Code = (int)ErrorCodeEnum.Success, Data = insertFeedbackModel }); }
/// <summary> /// 插入反馈记录 /// </summary> /// <param name="userContext"></param> /// <param name="feedbackRequestParams"></param> /// <param name="sysTaskDaily"></param> /// <returns></returns> public bool InsertFeedbacks(UserContext userContext, FeedbackRequestParams feedbackRequestParams, out SysTaskDaily sysTaskDaily) { //1.获取反馈备注 var remark = GetFeedbackRemark((FeedbackTypeEnum)feedbackRequestParams.FeedbackType); sysTaskDaily = new SysTaskDaily { Accountid = userContext.AccId, Content = feedbackRequestParams.Suggestion, OperateTime = DateTime.Now.AddHours(2), Level = 9, Status = 0, InsertTime = DateTime.Now, InsertName = userContext.OperaterName, LoginUid = userContext.UserId, Remark = remark, Source = remark }; //2.插入反馈记录 return(_sysTaskDailyDapperRepository.Insert(sysTaskDaily)); }