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