public ResponseNodeUpdate NodeUpdate([FromBody] RequestNodeUpdate request) { try { NodeBLL bll = new NodeBLL(); return(bll.NodeUpdate(request)); } catch (Exception ex) { throw new HttpResponseException( Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message)); } }
public ResponseNodeUpdate NodeUpdate(RequestNodeUpdate request) { ResponseNodeUpdate response = new ResponseNodeUpdate(); using (cnn = GetConnection()) { var ts = cnn.BeginTransaction(); try { var user = UserInfoGetButAccount(request.Token, ts); var Node = cnn.Query <TKS_FAS_Node>("select * from tks_fas_Node where name=@Name and id<>@Id", new { Name = request.Data.Name , Id = request.Data.Id }, ts); if (Node.Count() > 0) { throw new NormalException("机构名已经存在"); } Node = cnn.Query <TKS_FAS_Node>("select * from tks_fas_Node where CreditCode=@CreditCode and id<>@Id", new { CreditCode = request.Data.CreditCode , Id = request.Data.Id }, ts); if (Node.Count() > 0) { throw new NormalException("信用代码已经存在"); } request.Data.UpdateDate = DateTime.Now; request.Data.UpdateUser = user.User.UserName; string sql = @"update tks_fas_Node set name=@Name, memo=@Memo, CreditCode=@CreditCode, type=@Type, updateUser=@UpdateUser, updateDate=@UpdateDate where id=@Id"; var r = cnn.Execute(sql, request.Data, ts); if (r == 1) { ts.Commit(); response.IsSuccess = true; response.Message = "更新成功"; return(response); } else { ts.Rollback(); return(this.DealException(response, new AppException("user", "NodeUpdate", "数据更新异常", r + "行数据被更新")) as ResponseNodeUpdate); } } catch (Exception ex) { ts.Rollback(); return(this.DealException(response, ex) as ResponseNodeUpdate); } } }