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); } } }