public ResponsePZZUpdate PZZUpdate(RequestPZZUpdate request) { ResponsePZZUpdate response = new ResponsePZZUpdate(); using (cnn = GetConnection()) { var ts = cnn.BeginTransaction(); try { var user = this.UserInfoGet(request.Token, ts); var d = cnn.Query("select * from TKS_FAS_CertificateWord where pzz=@PZZ and id<>@Id", new { PZZ = request.Data.PZZ, Id = request.Data.Id }, ts); if (d.Count() > 0) { throw new NormalException("凭证字已经存在"); } d = cnn.Query("select * from TKS_FAS_CertificateWord where ShowTitle=@ShowTitle and id<>@Id", new { ShowTitle = request.Data.ShowTitle, Id = request.Data.Id }, ts); if (d.Count() > 0) { throw new NormalException("显示名称已经存在"); } if (request.Data.IsDefault == 1) { cnn.Execute("update TKS_FAS_CertificateWord set isDefault=0 where accountId=@AccountId", new { AccountId = user.AccountId }, ts); } string sql = @"update TKS_FAS_CertificateWord set PZZ=@PZZ, ShowTitle=@ShowTitle, IsDefault=@IsDefault where id=@Id"; var r = cnn.Execute(sql, request.Data, ts); if (r == 1) { ts.Commit(); response.IsSuccess = true; response.Message = "更新成功"; return(response); } else { throw new AppException(user.User.UserName, "PZZUpdate", "数据更新异常", r + "行数据被更新"); } } catch (Exception ex) { ts.Rollback(); return(this.DealException(response, ex) as ResponsePZZUpdate); } } }
public ResponsePZZUpdate PZZUpdate([FromBody] RequestPZZUpdate request) { try { PZZBLL bll = new PZZBLL(); return(bll.PZZUpdate(request)); } catch (Exception ex) { throw new HttpResponseException( Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message)); } }