public ResponseCalHelperGet CalHelperGet([FromBody] RequestCalHelperGet request) { try { CalHelperBLL bll = new CalHelperBLL(); return(bll.CalHelperGet(request)); } catch (Exception ex) { throw new HttpResponseException( Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message)); } }
public ResponseCalHelperGet CalHelperGet(RequestCalHelperGet request) { ResponseCalHelperGet response = new ResponseCalHelperGet(); using (cnn = GetConnection()) { var ts = cnn.BeginTransaction(); try { //辅助核算类别是否被使用 var ass = cnn.Query("select * from TKS_FAS_SubjectAss where code=@Code", new { Code = request.Data.Id }, ts).ToList(); if (ass.Count() > 0) { response.IsUse = 1; } else { response.IsUse = 0; } var head = cnn.QuerySingle <TKS_FAS_CaculateHelperItem>("select * from TKS_FAS_CaculateHelperItem where id=@Id", new { Id = request.Data.Id }, ts); var customDes = cnn.Query <TKS_FAS_CustomColDes>("select * from TKS_FAS_CustomColDes where parentId=@ParentId", new { ParentId = request.Data.Id }, ts).ToList(); ts.Commit(); response.IsSuccess = true; response.Message = "加载完毕"; response.Head = head; response.CustomDes = customDes; return(response); } catch (Exception ex) { ts.Rollback(); return(this.DealException(response, ex) as ResponseCalHelperGet); } } }