特斯拉条码生成规则修改

yxj

2023-09-05 2669ba50e5d9a8b0f9a29507138a5bf12394a0f7

特斯拉条码生成规则修改

 SCM/¹«ÓÃÀà/ClsPub1.cs

@@ -24,7 +24,7 @@
        //public static string WEBSURL = "http://120.195.29.36:1230/WEBS-WMS/WebService1.asmx";         //江苏龙亨
        //public static string WEBSURL = "http://60.191.27.141:8090/WEBS-WMS/WebService1.asmx";         //森楷
        //public static string WEBSURL = "http://192.168.63.195/WEBS-WMS/WebService1.asmx";
        //public static string WEBSURL = "http://192.168.63.20/WEBS-WMS/WebService1.asmx";              //公司台式机
        //public static string WEBSURL = "http://192.168.110.51/WEBS-WMS/WebService1.asmx";              //公司台式机
        //public static string WEBSURL = "http://192.168.0.107/WEBS-WMS/WebService1.asmx";              //家

        //public static string WEBSURL = "http://47.96.97.237/WEBS-WMS/WebService1.asmx";              //公司服务器

 SCM/ÌõÂë´òÓ¡/Gy_BarCodeBill_TeSiLa.cs

@@ -635,6 +635,8 @@
                string NewModel = "";       //物料规格型号(字符串中去除‘-’，截取‘（）’前字符串)
                string CusTM = "";          //客户条码
                string TeSiLaTM = "";       //特斯拉条码
                string sTeSiLaTMNumber = "";    //特斯拉条码自定义前缀
                int TeSiLaTMLSH = 0;        //特斯拉条码流水号
                string TeSiLaTMZS = "";     //特斯拉条码张数
                string TeSiLaTMDate = "";   //特斯拉条码生成日期
                string HProduceDate = "";   //生产日期
@@ -663,6 +665,11 @@
                            sTMNumber = HOrgNumber + HItemID + sYear + sPeriod + sDay;
                            Ds = oWeb.getDataSetBySQL("exec h_p_WMS_GetMaxNo  '" + sTMNumber + "'", "h_p_WMS_GetMaxNo", ref DBUtility.ClsPub.sExeReturnInfo);//获取最大流水号
                            LSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]);

                            //特斯拉条码前缀 = ç»„织代码 + ç‰©æ–™å†…码
                            sTeSiLaTMNumber = HOrgNumber + HItemID;
                            DataSet TeSiLaDs = oWeb.getDataSetBySQL("exec h_p_WMS_GetMaxNo  '" + sTeSiLaTMNumber + "'", "h_p_WMS_GetMaxNo", ref DBUtility.ClsPub.sExeReturnInfo);//获取最大流水号
                            TeSiLaTMLSH = ClsPub.isInt(TeSiLaDs.Tables[0].Rows[0][0]);

                            //获取规格型号
                            HModel = DBUtility.ClsPub.isStrNull(grdMain.Rows[j].Cells[HMaterModelCol].Value);
@@ -830,8 +837,10 @@
                                {
                                    sQty2 = "0" + sQty2;
                                }

                                //获取条码张数，转换成36进制，不足3位数前面补0
                                TeSiLaTMZS = ConvertToBase(HBQty, 36);
                                TeSiLaTMLSH = TeSiLaTMLSH + 1;
                                TeSiLaTMZS = ConvertToBase(TeSiLaTMLSH, 36);
                                while (TeSiLaTMZS.Length < 3)
                                {
                                    TeSiLaTMZS = "0" + TeSiLaTMZS;
@@ -944,6 +953,16 @@
                            MessageBox.Show("条码生成失败,批量生成流水号失败！");
                            return;
                        }
                        if (cmbHBarCodeType.Text == "特斯拉客户条码")
                        {
                            string[] sSQLTeSiLaNoMul = new string[1];
                            sSQLTeSiLaNoMul[0] = " exec h_p_WMS_SetMaxNo_QTY '" + sTeSiLaTMNumber + "'," + nn.ToString() + " ";
                            if (oWeb.getRunProcByMul_Back(sSQLTeSiLaNoMul, ref DBUtility.ClsPub.sExeReturnInfo) == false)
                            {
                                MessageBox.Show("条码生成失败,批量生成特斯拉客户条码流水号失败！");
                                return;
                            }
                        }
                    }
                }