public ResponseBBtplDelete BBtplDelete(RequestBBtplDelete request)
{
ResponseBBtplDelete response = new ResponseBBtplDelete();
using (cnn = GetConnection())
{
var ts = cnn.BeginTransaction();
try
{
string sql = @" delete from TKS_FAS_ReportTPL where id=@Id";
cnn.Execute(sql, request.Data, ts);
sql = "delete from TKS_FAS_ReportDetailTPL where parentId=@ParentId";
cnn.Execute(sql, new { ParentId = request.Data.Id }, ts);
sql = "delete from TKS_FAS_Formula where ReportTPLId=@ReportTPLId";
cnn.Execute(sql, new { ReportTPLId = request.Data.Id }, ts);
ts.Commit();
response.IsSuccess = true;
response.Message = "删除成功";
return(response);
}
catch (Exception ex)
{
ts.Rollback();
return(this.DealException(response, ex) as ResponseBBtplDelete);
}
}
}
public ResponseBBtplDelete BBtplDelete([FromBody] RequestBBtplDelete request)
{
try
{
ReportTplBLL bll = new ReportTplBLL();
return(bll.BBtplDelete(request));
}
catch (Exception ex)
{
throw new HttpResponseException(
Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message));
}
}
