public ResponseTPLMUpdate TPLMUpdate2([FromBody] RequestTPLMUpdate request) { try { TPLMBLL bll = new TPLMBLL(); return(bll.TPLMUpdate(request)); } catch (Exception ex) { throw new HttpResponseException( Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message)); } }
/// <summary> /// 综合模板更新(无需选择账套) /// </summary> /// <param name="request"></param> /// <returns></returns> public ResponseTPLMUpdate TPLMUpdate(RequestTPLMUpdate request) { ResponseTPLMUpdate response = new ResponseTPLMUpdate(); using (cnn = GetConnection()) { var ts = cnn.BeginTransaction(); try { var user = this.UserInfoGetButAccount(request.Token, ts); string sql = @" delete from TKS_FAS_DocTPL where id=@Id"; cnn.Execute(sql, request.Head, ts); sql = "delete from TKS_FAS_DocDetailTPL where parentId=@ParentId"; cnn.Execute(sql, new { ParentId = request.Head.Id }, ts); request.Head.Id = request.Head.Id; var id = Add(new RequestTPLMAdd { Type = request.Type, Token = request.Token, Head = request.Head, Detail = request.Detail }, ts, user); ts.Commit(); response.IsSuccess = true; response.Id = id; response.Message = "更新成功"; return(response); } catch (Exception ex) { ts.Rollback(); return(this.DealException(response, ex) as ResponseTPLMUpdate); } } }