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