public ResponseCalHelperUpdate CalHelperUpdate(RequestCalHelperUpdate request)
{
ResponseCalHelperUpdate response = new ResponseCalHelperUpdate();
using (cnn = GetConnection())
{
var ts = cnn.BeginTransaction();
try
{
var user = this.UserInfoGet(request.Token, ts);
var d = cnn.Query(@"select * from TKS_FAS_CaculateHelperItem
where title=@Title and accountId=@AccountId and id<>@Id",
new { Title = request.Head.Title, AccountId = user.AccountId, Id = request.Head.Id }, ts);
if (d.Count() > 0)
{
throw new NormalException("类别名已经存在");
}
string sql = @"update TKS_FAS_CaculateHelperItem set
title=@Title
where id=@Id";
var r = cnn.Execute(sql, request.Head, ts);
cnn.Execute("delete from TKS_FAS_CustomColDes where parentId=@ParentId",
new { ParentId = request.Head.Id }, ts);
foreach (var item in request.CustomDes)
{
item.Id = Guid.NewGuid().ToString("N");
item.AccountId = user.AccountId;
item.ParentId = request.Head.Id;
cnn.Insert <TKS_FAS_CustomColDes>(item, ts);
}
if (r == 1)
{
ts.Commit();
response.IsSuccess = true;
response.Message = "更新成功";
return(response);
}
else
{
throw new AppException(user.User.UserName, "CalHelperUpdate", "数据更新异常", r + "行数据被更新");
}
}
catch (Exception ex)
{
ts.Rollback();
return(this.DealException(response, ex) as ResponseCalHelperUpdate);
}
}
}
public ResponseCalHelperUpdate CalHelperUpdate([FromBody] RequestCalHelperUpdate request)
{
try
{
CalHelperBLL bll = new CalHelperBLL();
return(bll.CalHelperUpdate(request));
}
catch (Exception ex)
{
throw new HttpResponseException(
Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message));
}
}
