凯贝华三内外箱条码生成规则修改

yxj

2026-04-15 456f7f40e0479592f7ce5b339d46a85b911f6064

凯贝华三内外箱条码生成规则修改

 WarM/ÌõÂë´òÓ¡/Gy_CusBarCodeBill_KaiBei_HuaSan.cs

@@ -674,20 +674,28 @@
                {
                    if (ClsPub.isLong(grdMain.Rows[j].Cells[HMaterIDCol].Value) != 0)
                    {
                        HCusModelName = ClsPub.isStrNull(grdMain.Rows[j].Cells[HCusModelNameCol].Value);            // å®¢æˆ·æ–™å·
                        HMaterModel = DBUtility.ClsPub.isStrNull(grdMain.Rows[j].Cells[HMaterModelCol].Value);      //物料规格型号
                        HMaterNumber = DBUtility.ClsPub.isStrNull(grdMain.Rows[j].Cells[HMaterNumberCol].Value);    // ç‰©æ–™ä»£ç 
                        HCode3 = HMaterNumber.Substring(HMaterNumber.Length - 2, 2);  //版本  å–物料代码后两位
                        HCustom3 = ClsPub.isStrNull(grdMain.Rows[j].Cells[HCustom3Col].Value);                      // ç•Œé¢ä¸Šè¾“å…¥   MPN

                        //界面上MPN值输入为/的，版本取物料代码后两位，不为/的则为改制，取00
                        if (HCustom3!="/")
                        {
                            HCode3 = "00";
                        }

                        if (cmbHCusName.Text.Contains("紫光华智"))
                        {
                            //条码前缀 = ç‰©æ–™è§„格型号+供应商代码（固定'151003'）+年月日（YYMMDD）
                            sTMNumber = HMaterModel + "151003" + sYear + sPeriod2 + sDay;
                            sTMNumber = HCusModelName + "151003" + sYear + sPeriod2 + sDay;
                        }
                        //新华三、东方通信、统合
                        else
                        {
                            //条码前缀 = ç‰©æ–™è§„格型号+供应商代码（固定'151091'）+年月日（YYMMDD）
                            sTMNumber = HMaterModel + "151091" + sYear + sPeriod2 + sDay;
                            sTMNumber = HCusModelName + "151091" + sYear + sPeriod2 + sDay;
                        }

                        Ds = oCn.RunProcReturn("exec h_p_WMS_GetMaxNo '" + sTMNumber + "'", "h_p_WMS_GetMaxNo");    //获取最大流水号
@@ -742,7 +750,6 @@
                            HAuxPropID = ClsPub.isLong(grdMain.Rows[j].Cells[HAuxPropIDCol].Value);
                            HQty = HMinQty;
                            HCusID = ClsPub.isLong(cmbHCusName.SelectedValue);
                            HCusModelName = ClsPub.isStrNull(grdMain.Rows[j].Cells[HCusModelNameCol].Value);
                            HCusModel = ClsPub.isStrNull(grdMain.Rows[j].Cells[HCusModelCol].Value);
                            HGiveAwayFlag = ClsPub.isBool(grdMain.Rows[j].Cells[HGiveAwayFlagCol].Value);
                            HISKFPERIOD = ClsPub.isBool(grdMain.Rows[j].Cells[HISKFPERIODCol].Value);
@@ -762,7 +769,6 @@
                            sHBaNo = ClsPub.isStrNull(grdMain.Rows[j].Cells[HBaNoCol].Value);                        // ç•Œé¢ä¸Šè¾“入的批次位
                            HCustom1 = ClsPub.isStrNull(grdMain.Rows[j].Cells[HCustom1Col].Value);                   // ç•Œé¢ä¸Šè¾“å…¥
                            HCustom2 = ClsPub.isStrNull(grdMain.Rows[j].Cells[HCustom2Col].Value);                   // ç•Œé¢ä¸Šè¾“å…¥
                            HCustom3 = ClsPub.isStrNull(grdMain.Rows[j].Cells[HCustom3Col].Value);                   // ç•Œé¢ä¸Šè¾“å…¥

                            //版本号HCode3、产品代码HCustom1、料号HCustom2、MPNHCustom3、销售订单号HInnerBillNo、规格型号HSupNumber
                            oCn.RunProc("insert into Gy_BarCodeBill_Cus" +
@@ -806,28 +812,36 @@
                {
                    if (ClsPub.isLong(grdMain.Rows[j].Cells[HMaterIDCol].Value) != 0)
                    {
                        HCusModelName = ClsPub.isStrNull(grdMain.Rows[j].Cells[HCusModelNameCol].Value);            // å®¢æˆ·æ–™å·
                        HMaterModel = DBUtility.ClsPub.isStrNull(grdMain.Rows[j].Cells[HMaterModelCol].Value);      //物料规格型号
                        HMaterNumber = DBUtility.ClsPub.isStrNull(grdMain.Rows[j].Cells[HMaterNumberCol].Value);    // ç‰©æ–™ä»£ç 
                        HCode3 = HMaterNumber.Substring(HMaterNumber.Length - 2, 2);                    //版本  å–物料代码后两位
                        HInnerBillNo = ClsPub.isStrNull(grdMain.Rows[j].Cells[HInnerBillNoCol].Value);  //销售订单号
                        HCustom3 = ClsPub.isStrNull(grdMain.Rows[j].Cells[HCustom3Col].Value);          // ç•Œé¢ä¸Šè¾“å…¥   MPN

                        //界面上MPN值输入为/的，版本取物料代码后两位，不为/的则为改制，取0
                        if (HCustom3 != "/")
                        {
                            HCode3 = "0";
                        }

                        //获取最大流水号
                        if (cmbHCusName.Text.Contains("东方通信"))
                        {
                            //条码前缀 = 2位固定码（'09'） + CPN客户编码（规格型号）+ 2位预留码（固定'01'）+ 5位年年月日日（YYMDD） + 3位09码流水号（固定'001'） + ä¾›åº”商代码（固定'105652'）
                            sWTMNumber = "09" + HMaterModel + "01" + sYear + sPeriod + sDay + "001105652";
                            sWTMNumber = "09" + HCusModelName + "01" + sYear + sPeriod + sDay + "001105652";
                        }
                        //紫光华智
                        else if (cmbHCusName.Text.Contains("紫光华智"))
                        {
                            //条码前缀 = 2位固定码（'09'） + CPN客户编码（规格型号）+ 2位预留码（固定'01'）+ 5位年年月日日（YYMDD） + 3位09码流水号（固定'001'） + ä¾›åº”商代码（固定'151003'）
                            sWTMNumber = "09" + HMaterModel + "01" + sYear + sPeriod + sDay + "001151003";
                            sWTMNumber = "09" + HCusModelName + "01" + sYear + sPeriod + sDay + "001151003";
                        }
                        //新华三、统合
                        else
                        {
                            //条码前缀 = 2位固定码（'09'） + CPN客户编码（规格型号）+ 2位预留码（固定'01'）+ 5位年年月日日（YYMDD） + 3位09码流水号（固定'001'） + ä¾›åº”商代码（固定'151091'）
                            sWTMNumber = "09" + HMaterModel + "01" + sYear + sPeriod + sDay + "001151091";
                            sWTMNumber = "09" + HCusModelName + "01" + sYear + sPeriod + sDay + "001151091";
                        }
                        Ds = oCn.RunProcReturn("exec h_p_WMS_GetMaxNo '" + sWTMNumber + "'", "h_p_WMS_GetMaxNo");    //获取最大流水号
                        LWSH = ClsPub.isLong(Ds.Tables[0].Rows[0][0]);
@@ -882,7 +896,6 @@
                            HAuxPropID = ClsPub.isLong(grdMain.Rows[j].Cells[HAuxPropIDCol].Value);
                            HQty = HWMinQty;
                            HCusID = ClsPub.isLong(cmbHCusName.SelectedValue);
                            HCusModelName = ClsPub.isStrNull(grdMain.Rows[j].Cells[HCusModelNameCol].Value);
                            HCusModel = ClsPub.isStrNull(grdMain.Rows[j].Cells[HCusModelCol].Value);
                            HGiveAwayFlag = ClsPub.isBool(grdMain.Rows[j].Cells[HGiveAwayFlagCol].Value);
                            HISKFPERIOD = ClsPub.isBool(grdMain.Rows[j].Cells[HISKFPERIODCol].Value);
@@ -902,7 +915,6 @@
                            sHBaNo = ClsPub.isStrNull(grdMain.Rows[j].Cells[HBaNoCol].Value);                        // ç•Œé¢ä¸Šè¾“入的批次位
                            HCustom1 = ClsPub.isStrNull(grdMain.Rows[j].Cells[HCustom1Col].Value);                   // ç•Œé¢ä¸Šè¾“å…¥
                            HCustom2 = ClsPub.isStrNull(grdMain.Rows[j].Cells[HCustom2Col].Value);                   // ç•Œé¢ä¸Šè¾“å…¥
                            HCustom3 = ClsPub.isStrNull(grdMain.Rows[j].Cells[HCustom3Col].Value);                   // ç•Œé¢ä¸Šè¾“å…¥

                            //版本号HCode3、产品代码HCustom1、料号HCustom2、MPNHCustom3、销售订单号HInnerBillNo、规格型号HSupNumber
                            oCn.RunProc("insert into Gy_BarCodeBill_Cus" +
@@ -958,7 +970,7 @@
        private void Display()
        {
            //刷新内箱码列表
            DataSet DSet = oCn.RunProcReturn("select * from h_v_Gy_BarCodeBill_CusList where HInterID=" + HInterID.ToString() + " and (条码类型 in ('新华三内箱码','东方通信内箱码','统合内箱码','紫光华智内箱码') order by HItemID", "h_v_Gy_BarCodeBill_CusList", ref DBUtility.ClsPub.sExeReturnInfo);
            DataSet DSet = oCn.RunProcReturn("select * from h_v_Gy_BarCodeBill_CusList where HInterID=" + HInterID.ToString() + " and æ¡ç ç±»åž‹ in ('新华三内箱码','东方通信内箱码','统合内箱码','紫光华智内箱码') order by HItemID", "h_v_Gy_BarCodeBill_CusList", ref DBUtility.ClsPub.sExeReturnInfo);
            //生成首行标题
            if (DSet == null)
            {
@@ -969,7 +981,7 @@
            grdSub.DataSource = DSet.Tables[0].DefaultView;

            //刷新外箱码列表
            DataSet DWSet = oCn.RunProcReturn("select * from h_v_Gy_BarCodeBill_CusList where HInterID=" + HInterID.ToString() + " and (条码类型 in ('新华三外箱码','东方通信外箱码','统合外箱码','紫光华智外箱码') order by HItemID", "h_v_Gy_BarCodeBill_CusList", ref DBUtility.ClsPub.sExeReturnInfo);
            DataSet DWSet = oCn.RunProcReturn("select * from h_v_Gy_BarCodeBill_CusList where HInterID=" + HInterID.ToString() + " and æ¡ç ç±»åž‹ in ('新华三外箱码','东方通信外箱码','统合外箱码','紫光华智外箱码') order by HItemID", "h_v_Gy_BarCodeBill_CusList", ref DBUtility.ClsPub.sExeReturnInfo);
            //生成首行标题
            if (DWSet == null)
            {