From f1e01b3972fe8dbe3e823c519bf1317d1c524a02 Mon Sep 17 00:00:00 2001
From: duhe <226547893@qq.com>
Date: 星期三, 28 二月 2024 16:31:25 +0800
Subject: [PATCH] （已完成-普通）删除客户时，若客户存在关联的销售订单、销售出库单、生产订单，报错修改。
---
WebAPI/Controllers/Sc_PckSplitBillController.cs | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/WebAPI/Controllers/Sc_PckSplitBillController.cs b/WebAPI/Controllers/Sc_PckSplitBillController.cs
index b90657a..9cdd59d 100644
--- a/WebAPI/Controllers/Sc_PckSplitBillController.cs
+++ b/WebAPI/Controllers/Sc_PckSplitBillController.cs
@@ -374,7 +374,7 @@
{
try
{
- string sql1 = string.Format(@"select * from h_v_Kf_ICStockBillList where HBillType='1204' " + sWhere);
+ string sql1 = string.Format(@"select * from h_v_Kf_ICStockBillList where 1=1 " + sWhere);
DataSet ds=oCn.RunProcReturn(sql1, "h_v_Kf_ICStockBillList");
if (ds.Tables[0].Rows.Count == 0 || ds == null)
{
--
Gitblit v1.9.1