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