From 75428309395e709a58e2978c2562e971b7f3f1b4 Mon Sep 17 00:00:00 2001
From: zzr99 <1940172413@qq.com>
Date: 星期三, 23 二月 2022 18:05:34 +0800
Subject: [PATCH] LAYUI版：采购订单、委外订单、收料通知单、退料通知单、销售订单、发货通知单、退货通知单、生产订单、调拨申请单，单据列表的手工同步功能
---
DAL/WMS/ClsGy_BarCodeBill_Ctl.cs | 112 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 112 insertions(+), 0 deletions(-)
diff --git a/DAL/WMS/ClsGy_BarCodeBill_Ctl.cs b/DAL/WMS/ClsGy_BarCodeBill_Ctl.cs
index 84cb48b..9cfa797 100644
--- a/DAL/WMS/ClsGy_BarCodeBill_Ctl.cs
+++ b/DAL/WMS/ClsGy_BarCodeBill_Ctl.cs
@@ -11,6 +11,10 @@
//鍘熶唬鐮� 鐢ㄤ簬 鏇挎崲瀛愰」鐩�
public string HOldNumber;
public Model.ClsGy_BarCodeBill_WMS_Model oModel = new Model.ClsGy_BarCodeBill_WMS_Model();
+ public const string ModRightName = "Gy_BarCodeBillList";
+ public const string ModRightNameEdit = ModRightName + "_Edit"; //鍒犻櫎
+ public const string ModRightNameDelete = ModRightName + "_Delete"; //浣滃簾
+ public const string ModRightNamePrint = ModRightName + "_Print"; //鎵撳嵃
//鏂板
public override bool AddNew()
{
@@ -220,6 +224,114 @@
}
}
+
+ //鍒犻櫎鏉＄爜
+ public bool DeleteBill(long sHItemID, string sHBarCode, string CurUserName, ref string sReturn)
+ {
+ //缂栬緫鏉冮檺
+ if (!DBUtility.ClsPub.Security_Log(ModRightNameEdit, 1, false, CurUserName))
+ {
+ sReturn = "鎮ㄦ病鏈夊垹闄ゆ潈闄愶紒";
+ return true;
+ }
+ try
+ {
+ DataSet DS = oCn.RunProcReturn("exec h_p_Gy_BarCodeBill_Delete " + sHItemID + ",'" + sHBarCode + "','" + CurUserName + "','" + DBUtility.ClsPub.ComputerName + "','" + DBUtility.ClsPub.IPAddress + "'", "h_p_Gy_BarCodeBill_Delete", ref DBUtility.ClsPub.sExeReturnInfo);
+ if (DS == null || DS.Tables[0].Rows.Count <= 0)
+ {
+ oCn.CnClose();
+ oCn.CnDispose();
+ sReturn = "鍒犻櫎鏉＄爜鏃跺彂鐢熼敊璇紒";
+ return true;
+ }
+ else
+ {
+ //鍒犻櫎澶辫触
+ if (DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[0][0]) == "1")
+ {
+ oCn.CnClose();
+ oCn.CnDispose();
+ sReturn = DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[0]["HRemark"]);
+ return true;
+ }
+ else
+ //鍒犻櫎鎴愬姛
+ {
+ oCn.CnClose();
+ oCn.CnDispose();
+ sReturn = DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[0]["HRemark"]);
+ return false;
+ }
+ }
+ }
+ catch (Exception e)
+ {
+ oCn.RollBack();
+ throw (e);
+ }
+ }
+
+ //鎵归噺鍒犻櫎鏉＄爜
+ public bool MulDeleteBill(string sHItemID, string sHBarCode, string CurUserName, ref string sReturn)
+ {
+ //缂栬緫鏉冮檺
+ if (!DBUtility.ClsPub.Security_Log(ModRightNameEdit, 1, false, CurUserName))
+ {
+ sReturn = "鎮ㄦ病鏈夊垹闄ゆ潈闄愶紒";
+ return true;
+ }
+ try
+ {
+ DataSet DS = oCn.RunProcReturn("exec h_p_Gy_BarCodeBill_MulDelete '" + sHItemID + "','" + sHBarCode + "','" + CurUserName + "','" + DBUtility.ClsPub.ComputerName + "','" + DBUtility.ClsPub.IPAddress + "'", "h_p_Gy_BarCodeBill_MulDelete", ref DBUtility.ClsPub.sExeReturnInfo);
+ if (DS == null || DS.Tables[0].Rows.Count <= 0)
+ {
+ oCn.CnClose();
+ oCn.CnDispose();
+ sReturn = "鎵归噺鍒犻櫎鏉＄爜鏃跺彂鐢熼敊璇紒";
+ return true;
+ }
+ else
+ {
+ //鎵归噺鍒犻櫎澶辫触
+ if (DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[0][0]) == "1")
+ {
+ oCn.CnClose();
+ oCn.CnDispose();
+ sReturn = DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[0]["HRemark"]);
+ return true;
+ }
+ else
+ //鎵归噺鍒犻櫎鎴愬姛
+ {
+ oCn.CnClose();
+ oCn.CnDispose();
+ sReturn = DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[0]["HRemark"]);
+ return false;
+ }
+ }
+ }
+ catch (Exception e)
+ {
+ oCn.RollBack();
+ throw (e);
+ }
+ }
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
//鏋勯�犲嚱鏁�
public ClsGy_BarCodeBill_Ctl()
{
--
Gitblit v1.9.1