From dfd0831df7b8245b7af6b6be28efd18b29fab17d Mon Sep 17 00:00:00 2001
From: zzr99 <1940172413@qq.com>
Date: 星期三, 19 一月 2022 18:02:51 +0800
Subject: [PATCH] 条码拆码+工时单+器具权限

---
 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