From caf31525f29e659cca49dd6e35b5f13e8e0496d7 Mon Sep 17 00:00:00 2001
From: zzr99 <1940172413@qq.com>
Date: 星期一, 28 三月 2022 17:20:05 +0800
Subject: [PATCH] Merge branch 'master' of http://101.37.171.70:10101/r/MES-WEB-API
---
DAL/WMS/ClsGy_BarCodeBill_Ctl.cs | 88 ++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 88 insertions(+), 0 deletions(-)
diff --git a/DAL/WMS/ClsGy_BarCodeBill_Ctl.cs b/DAL/WMS/ClsGy_BarCodeBill_Ctl.cs
index 9cfa797..260ac0b 100644
--- a/DAL/WMS/ClsGy_BarCodeBill_Ctl.cs
+++ b/DAL/WMS/ClsGy_BarCodeBill_Ctl.cs
@@ -321,7 +321,95 @@
+ //鏉＄爜鐢熸垚妯″潡璋冪敤 鏉＄爜鎵撳嵃鍓嶏紝鏉＄爜鎵撳嵃娆℃暟鎺у埗锛堟槸鍚﹁秴杩囧厑璁稿彲鎵撳嵃娆℃暟锛�
+ public bool Set_CheckPrintQty_SD(Int64 HInterID, long PrintQty, ref string sReturn)
+ {
+ DataSet DS;
+ string sBarCode = "";
+ DS = oCn.RunProcReturn("select stuff((select ','+HBarCode from Gy_BarCodeBill with(nolock) where HPrintQty >=" + PrintQty + " and HBarCodeType = '鍞竴鏉＄爜' and HInterID = " + HInterID + " for xml path('')),1,1,'')", "Gy_BarCodeBill");
+ if (DS == null || DS.Tables[0].Rows.Count == 0)
+ {
+ sReturn = "姝ｅ父锛�";
+ return false;
+ }
+ else
+ {
+ sBarCode = DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[0][0]);
+ if (sBarCode == "")
+ {
+ sReturn = "姝ｅ父锛�";
+ return false;
+ }
+ else
+ {
+ sReturn = "鏉＄爜缂栧彿锛�" + DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[0][0]) + "锛屽凡鎵撳嵃" + PrintQty + " 娆★紝涓嶅厑璁稿啀娆￠瑙堟墦鍗帮紒";
+ return true;
+ }
+ }
+ }
+ //鏉＄爜妗ｆ鍒楄〃妯″潡璋冪敤 鏉＄爜鎵撳嵃鍓嶏紝鏉＄爜鎵撳嵃娆℃暟鎺у埗锛堟槸鍚﹁秴杩囧厑璁稿彲鎵撳嵃娆℃暟锛�
+ public bool Set_CheckPrintQty(string sBarCodeItemID,long PrintQty, ref string sReturn)
+ {
+ DataSet DS;
+ string sBarCode = "";
+ DS = oCn.RunProcReturn("select stuff((select ','+HBarCode from Gy_BarCodeBill with(nolock) where HPrintQty >=" + PrintQty + " and HBarCodeType = '鍞竴鏉＄爜' and HItemID in (" + sBarCodeItemID + ") for xml path('')),1,1,'')", "Gy_BarCodeBill");
+ if (DS == null || DS.Tables[0].Rows.Count == 0)
+ {
+ sReturn = "姝ｅ父锛�";
+ return false;
+ }
+ else
+ {
+ sBarCode = DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[0][0]);
+ if (sBarCode == "")
+ {
+ sReturn = "姝ｅ父锛�";
+ return false;
+ }
+ else
+ {
+ sReturn = "鏉＄爜缂栧彿锛�" + DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[0][0]) + "锛屽凡鎵撳嵃" + PrintQty + " 娆★紝涓嶅厑璁稿啀娆￠瑙堟墦鍗帮紒";
+ return true;
+ }
+ }
+ }
+
+ //鏉＄爜鐢熸垚妯″潡璋冪敤 鏉＄爜鎵撳嵃鍚庯紝鏇存柊鏉＄爜鎵撳嵃娆℃暟
+ public bool Set_UpdatePrintQty_SD(Int64 HInterID)
+ {
+ try
+ {
+ oCn.BeginTran();
+ //鏇存柊 鏉＄爜鎵撳嵃娆℃暟
+ oCn.RunProc("update Gy_BarCodeBill set HPrintQty=isnull(HPrintQty,0)+1 where HInterID = " + HInterID, ref DBUtility.ClsPub.sExeReturnInfo);
+ oCn.Commit();
+ return true;
+ }
+ catch (Exception e)
+ {
+ oCn.RollBack();
+ throw (e);
+ }
+ }
+
+ //鏉＄爜妗ｆ鍒楄〃妯″潡璋冪敤 鏉＄爜鎵撳嵃鍚庯紝鏇存柊鏉＄爜鎵撳嵃娆℃暟
+ public bool Set_UpdatePrintQty(string sBarCodeItemID)
+ {
+ try
+ {
+ oCn.BeginTran();
+ //鏇存柊 鏉＄爜鎵撳嵃娆℃暟
+ oCn.RunProc("update Gy_BarCodeBill set HPrintQty=isnull(HPrintQty,0)+1 where HItemID in (" + sBarCodeItemID + ")", ref DBUtility.ClsPub.sExeReturnInfo);
+ oCn.Commit();
+ return true;
+ }
+ catch (Exception e)
+ {
+ oCn.RollBack();
+ throw (e);
+ }
+ }
--
Gitblit v1.9.1