public ResponsePZZAdd PZZAdd([FromBody] RequestPZZAdd request) { try { PZZBLL bll = new PZZBLL(); return(bll.PZZAdd(request)); } catch (Exception ex) { throw new HttpResponseException( Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message)); } }
public ResponsePZZAdd PZZAdd(RequestPZZAdd request) { ResponsePZZAdd response = new ResponsePZZAdd(); 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", new { PZZ = request.Data.PZZ }, ts); if (d.Count() > 0) { throw new NormalException("凭证字已经存在"); } d = cnn.Query("select * from TKS_FAS_CertificateWord where ShowTitle=@ShowTitle", new { ShowTitle = request.Data.ShowTitle }, 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); } request.Data.Id = Guid.NewGuid().ToString("N"); request.Data.AccountId = user.AccountId; cnn.Insert <TKS_FAS_CertificateWord>(request.Data, ts); ts.Commit(); response.Id = request.Data.Id; response.IsSuccess = true; response.Message = "新增成功"; return(response); } catch (Exception ex) { ts.Rollback(); return(this.DealException(response, ex) as ResponsePZZAdd); } } }