nothing

zzr99

2022-05-17 76c42727bf5a17e2e520401b7de8108e7aec3a49

 DAL/WMS/ClsGy_BarCodeBill_Ctl.cs

@@ -225,7 +225,7 @@
        }


        //删除条码（未完成）
        //删除条码
        public bool DeleteBill(long sHItemID, string sHBarCode, string CurUserName, ref string sReturn)
        {
            //编辑权限
@@ -236,8 +236,7 @@
            }
            try
            {
                DataSet DS = oCn.RunProcReturn("exec h_p_Gy_BarCodeBill_Delete " + sHItemID + ",'" + sHBarCode + "','" + DBUtility.ClsPub.CurUserName + "','" + DBUtility.ClsPub.ComputerName + "','" + DBUtility.ClsPub.IPAddress + "'", "h_p_Gy_BarCodeBill_Delete", ref DBUtility.ClsPub.sExeReturnInfo);

                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();
@@ -247,36 +246,69 @@
                }
                else
                {
                    sReturn = DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[0]["HRemark"]);
                    //删除失败
                    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;
                }

                //DS = oCn.RunProcReturn("exec h_p_Gy_BarCodeBPrintQty '" + sBarCode + "'", "h_p_Gy_BarCodeBPrintQty", ref DBUtility.ClsPub.sExeReturnInfo);
                //if (DS == null || DS.Tables[0].Rows.Count == 0)
                //{
                //    oCn.CnClose();
                //    oCn.CnDispose();
                //    sReturn = DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[0]["HRemark"]);
                //    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][1]);
                //        return true;
                //    }
                //    else
                //    {
                //        oCn.CnClose();
                //        oCn.CnDispose();
                //        sReturn = "正常！";
                //        return false;
                //    }
                //}
                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)
            {
@@ -289,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);
            }
        }