From a825c44ff42da28c26c26a17b65dba6c1c896262 Mon Sep 17 00:00:00 2001
From: yusijie <ysj@hz-kingdee.com>
Date: 星期三, 16 十一月 2022 17:03:15 +0800
Subject: [PATCH] 完善修复基础资料列表增删改查功能（物料，仓库，职员，部门，组织，计量单位）
---
DBUtility/业务单据/ClsXt_BaseBill.cs | 11 ++++++-----
1 files changed, 6 insertions(+), 5 deletions(-)
diff --git "a/DBUtility/\344\270\232\345\212\241\345\215\225\346\215\256/ClsXt_BaseBill.cs" "b/DBUtility/\344\270\232\345\212\241\345\215\225\346\215\256/ClsXt_BaseBill.cs"
index 53b2ee58..ce3b7a0 100644
--- "a/DBUtility/\344\270\232\345\212\241\345\215\225\346\215\256/ClsXt_BaseBill.cs"
+++ "b/DBUtility/\344\270\232\345\212\241\345\215\225\346\215\256/ClsXt_BaseBill.cs"
@@ -201,12 +201,12 @@
throw (e);
}
}
- //鍒犻櫎瀛愯〃
+ //淇濆吇璁″垝鍒犻櫎瀛愯〃1
public void DeleteBillSub(Int64 lngBillKey)
{
oCn.RunProc("Delete From " + MvarItemKeySub + " where HInterID=" + lngBillKey.ToString());
}
- //鍒犻櫎瀛愯〃
+ //淇濆吇璁″垝鍒犻櫎瀛愯〃2
public void DeleteBillSub2(Int64 lngBillKey)
{
if (MvarItemKeySub2 != "")
@@ -463,9 +463,10 @@
//鍗曟嵁鍙锋槸鍚﹂噸澶�
public virtual bool IsExistBillNo(ref string sReturn, string sBillNo, ClsPub.Enum_BillStatus oBillStatus, Int64 lngBillKey)
{
+ string sSql = "";
try
{
- string sSql = "";
+
if (oBillStatus == ClsPub.Enum_BillStatus.BillStatus_AddNew)
{
sSql = "Select HInterID from " + MvarItemKey + " where hbilltype='" + BillType + "'and HBillNO ='" + sBillNo + "'";
@@ -486,8 +487,8 @@
}
catch (Exception e)
{
- sReturn = e.Message;
- throw (e);
+ sReturn = e.Message+"sql:"+ sSql;
+ return false;
}
}
#endregion
--
Gitblit v1.9.1