public ResponseInvoiceDelete InvoiceDelete([FromBody] RequestInvoiceDelete request)
{
try
{
InvoiceBLL bll = new InvoiceBLL();
return(bll.InvoiceDelete(request));
}
catch (Exception ex)
{
throw new HttpResponseException(
Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message));
}
}
public ResponseInvoiceDelete WX_BasicDataDelete(RequestInvoiceDelete request)
{
ResponseInvoiceDelete response = new ResponseInvoiceDelete();
using (cnn = GetConnection())
{
var ts = cnn.BeginTransaction();
try
{
string sql = @"select * from TKS_FAS_Invoice where BasicDataId=@BasicDataId";
var data = cnn.Query <TKS_FAS_Invoice>(sql, new
{
BasicDataId = request.Id
}, ts).ToList();
if (data.Count > 0)
{
ts.Commit();
response.IsSuccess = false;
response.Message = "已经被发票使用，无法删除";
}
else
{
cnn.Execute("delete from TKS_FAS_BasicData where id=@Id", new { Id = request.Id }, ts);
ts.Commit();
response.IsSuccess = true;
response.Message = "删除成功";
}
return(response);
}
catch (Exception ex)
{
ts.Rollback();
return(this.DealException(response, ex) as ResponseInvoiceDelete);
}
}
}
