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