public ResponseCustomDataAdd CustomDataAdd([FromBody] RequestCustomDataAdd request)
{
try
{
CustomDataBLL bll = new CustomDataBLL();
return(bll.CustomDataAdd(request));
}
catch (Exception ex)
{
throw new HttpResponseException(
Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message));
}
}
public ResponseCustomDataAdd CustomDataAdd(RequestCustomDataAdd request)
{
ResponseCustomDataAdd response = new ResponseCustomDataAdd();
using (cnn = GetConnection())
{
var ts = cnn.BeginTransaction();
try
{
Dictionary <string, string> saveData = List2Dic(request.Data);
var user = this.UserInfoGet(request.Token, ts);
var item = cnn.QueryFirst <Max_CaculateHelperDetailCode>(
@"select isnull(max(code),0) Code from TKS_FAS_CaculateHelperDetail
where accountId=@AccountId and parentId=@ParentId", new
{
AccountId = user.AccountId,
ParentId = request.Head.Id
}, ts);
saveData["Code"] = (item.Code + 1).ToString().PadLeft(3, '0');
#region code ,name verification
//var d = cnn.Query(@"select * from TKS_FAS_CaculateHelperDetail
// where code=@Code and accountId=@AccountId and parentId=@ParentId",
// new
// {
// Code = saveData["Code"],
// AccountId = user.AccountId,
// ParentId = request.Head.Id//item id
// }, ts);
//if (d.Count() > 0)
//{
// throw new NormalException("编码已经存在");
//}
var d = cnn.Query(@"select * from TKS_FAS_CaculateHelperDetail
where name=@Name and accountId=@AccountId and parentId=@ParentId",
new
{
Name = saveData["Name"],
AccountId = user.AccountId,
ParentId = request.Head.Id//item id
}, ts);
if (d.Count() > 0)
{
throw new NormalException("名称已经存在");
}
#endregion
TKS_FAS_CaculateHelperDetail detail = new TKS_FAS_CaculateHelperDetail();
detail = LoadByDic(saveData);
detail.ParentId = request.Head.Id;
detail.AccountId = user.AccountId;
cnn.Insert <TKS_FAS_CaculateHelperDetail>(detail, 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 ResponseCustomDataAdd);
}
}
}
