public ResponseCalHelperAdd CalHelperAdd([FromBody] RequestCalHelperAdd request)
{
try
{
CalHelperBLL bll = new CalHelperBLL();
return(bll.CalHelperAdd(request));
}
catch (Exception ex)
{
throw new HttpResponseException(
Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message));
}
}
public ResponseCalHelperAdd CalHelperAdd(RequestCalHelperAdd request)
{
ResponseCalHelperAdd response = new ResponseCalHelperAdd();
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",
new { Title = request.Head.Title, AccountId = user.AccountId }, ts);
if (d.Count() > 0)
{
throw new NormalException("类别名已经存在");
}
request.Head.Id = Guid.NewGuid().ToString("N");
request.Head.AccountId = user.AccountId;
request.Head.IsCustom = 1;
cnn.Insert <TKS_FAS_CaculateHelperItem>(request.Head, 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);
}
ts.Commit();
response.Id = request.Head.Id;
response.IsSuccess = true;
response.Message = "新增成功";
return(response);
}
catch (Exception ex)
{
ts.Rollback();
return(this.DealException(response, ex) as ResponseCalHelperAdd);
}
}
}
