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