From d734833a8520aad070ea4ad9fe7f768c2effe7f1 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期四, 09 二月 2023 21:54:51 +0800
Subject: [PATCH] 采购订单删除判断是否生成到货单
---
VueWebApi/DLL/DAL/PurchaseOrderDAL.cs | 12 ++++++++++++
1 files changed, 12 insertions(+), 0 deletions(-)
diff --git a/VueWebApi/DLL/DAL/PurchaseOrderDAL.cs b/VueWebApi/DLL/DAL/PurchaseOrderDAL.cs
index 5c688df..b18c257 100644
--- a/VueWebApi/DLL/DAL/PurchaseOrderDAL.cs
+++ b/VueWebApi/DLL/DAL/PurchaseOrderDAL.cs
@@ -138,6 +138,18 @@
var dynamicParams = new DynamicParameters();
try
{
+ //鍒ゆ柇鏄惁鐢熸垚浜嗛噰璐埌璐у崟
+ sql = @"select * from T_PurchaseArrivalOrder where hsourcebillno=@po";
+ dynamicParams.Add("@po", po);
+ var data = DapperHelper.selectdata(sql, dynamicParams);
+ if (data.Rows.Count > 0)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = "褰撳墠閲囪喘璁㈠崟宸茬敓鎴愬埌璐у崟!";
+ mes.data = null;
+ return mes;
+ }
//鍒犻櫎閲囪喘璁㈠崟涓昏〃
sql = @"delete T_PurchaseOrder where ordercode=@po";
list.Add(new { str = sql, parm = new { po = po } });
--
Gitblit v1.9.3