外网版桌面端
parent: 488a01bb | 补丁 | 提交 | ignore whitespace
yxj
2023-02-17 4cd6df69db38312c99192ce1f442ff2ce0b68b24 
奇瑞箱条码生成规则修改
1个文件已修改
149 ■■■■■ 已修改文件
SCM/条码打印/Gy_BarCodeBill.cs 149 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 
 SCM/ÌõÂë´òÓ¡/Gy_BarCodeBill.cs


@@ -72,28 +72,29 @@


        public const Int16 HSeOrderBillIDCol = 51;


        public const Int16 HSeOrderBillNoCol = 52;


        public const Int16 HCustomBatchNoCol = 53;


        public const Int16 HWhIDCol = 54;


        public const Int16 HWhNumberCol = 55;


        public const Int16 HWhNameCol = 56;


        public const Int16 HSPIDCol = 57;


        public const Int16 HSPNumberCol = 58;


        public const Int16 HSPNameCol = 59;


        public const Int16 HinitQtyCol = 60;


        public const Int16 HRemarkCol = 61;


        public const Int16 HPinfanBarCodeCol = 62;


        public const Int16 HMTONoCol = 63;


        public const Int16 HColorCol = 64;


        public const Int16 HPressModelCol = 65;


        public const Int16 HJiaYeCol = 66;


        public const Int16 HPackageSizeCol = 67;


        public const Int16 HJQtyCol = 68;


        public const Int16 HMQtyCol = 69;


        public const Int16 HGBBarCodeCol = 70;


        public const Int16 HJiaYeLXCol = 71;


        public const Int16 HJiaYeLCol = 72;


        public const Int16 POOrderBillNoCol = 73;


        public const Int16 HBarCode_PackCol = 74;


        public const Int16 HCustomQty1Col = 75;


        public const Int16 HLayerNumberCol = 54;


        public const Int16 HWhIDCol = 55;


        public const Int16 HWhNumberCol = 56;


        public const Int16 HWhNameCol = 57;


        public const Int16 HSPIDCol = 58;


        public const Int16 HSPNumberCol = 59;


        public const Int16 HSPNameCol = 60;


        public const Int16 HinitQtyCol = 61;


        public const Int16 HRemarkCol = 62;


        public const Int16 HPinfanBarCodeCol = 63;


        public const Int16 HMTONoCol = 64;


        public const Int16 HColorCol = 65;


        public const Int16 HPressModelCol = 66;


        public const Int16 HJiaYeCol = 67;


        public const Int16 HPackageSizeCol = 68;


        public const Int16 HJQtyCol = 69;


        public const Int16 HMQtyCol = 70;


        public const Int16 HGBBarCodeCol = 71;


        public const Int16 HJiaYeLXCol = 72;


        public const Int16 HJiaYeLCol = 73;


        public const Int16 POOrderBillNoCol = 74;


        public const Int16 HBarCode_PackCol = 75;


        public const Int16 HCustomQty1Col = 76;




        public Int16 HSelectCol = 0;


        public Int16 HSno2Col = 1;


@@ -147,29 +148,30 @@


        public Int16 HSeOrderBillID2Col = 49;


        public Int16 HSeOrderBillNo2Col = 50;


        public Int16 HCustomBatchNo2Col = 51;


        public Int16 HWhID2Col = 52;


        public Int16 HWhNumber2Col = 53;


        public Int16 HWhName2Col = 54;


        public Int16 HSPID2Col = 55;


        public Int16 HSPNumber2Col = 56;


        public Int16 HSPName2Col = 57;


        public Int16 HRemark2Col = 58;


        public Int16 HPinfanBarCode2Col = 59;


        public Int16 HMTONo2Col = 60;


        public Int16 HColor2Col = 61;


        public Int16 HPressModel2Col = 62;


        public Int16 HJiaYe2Col = 63;


        public Int16 HPackageSize2Col = 64;


        public Int16 HJQty2Col = 65;


        public Int16 HMQty2Col = 66;


        public Int16 HMakeDate2Col = 67;


        public Int16 HGBBarCode2Col = 68;


        public Int16 HJiaYeLX2Col = 69;


        public Int16 HJiaYeL2Col = 70;


        public Int16 POOrderBillNo2Col = 71;


        public Int16 HBarCode_Pack2Col = 72;


        public Int16 HCustomQty12Col = 73;


        public Int16 HCusBarCodeCol = 74;


        public Int16 HLayerNumber2Col = 52;


        public Int16 HWhID2Col = 53;


        public Int16 HWhNumber2Col = 54;


        public Int16 HWhName2Col = 55;


        public Int16 HSPID2Col = 56;


        public Int16 HSPNumber2Col = 57;


        public Int16 HSPName2Col = 58;


        public Int16 HRemark2Col = 59;


        public Int16 HPinfanBarCode2Col = 60;


        public Int16 HMTONo2Col = 61;


        public Int16 HColor2Col = 62;


        public Int16 HPressModel2Col = 63;


        public Int16 HJiaYe2Col = 64;


        public Int16 HPackageSize2Col = 65;


        public Int16 HJQty2Col = 66;


        public Int16 HMQty2Col = 67;


        public Int16 HMakeDate2Col = 68;


        public Int16 HGBBarCode2Col = 69;


        public Int16 HJiaYeLX2Col = 70;


        public Int16 HJiaYeL2Col = 71;


        public Int16 POOrderBillNo2Col = 72;


        public Int16 HBarCode_Pack2Col = 73;


        public Int16 HCustomQty12Col = 74;


        public Int16 HCusBarCodeCol = 75;


        //


        public  string ModName = "85";


        public  string ModCaption = "条码生成";


@@ -677,6 +679,17 @@


                            MessageBox.Show(" ç¬¬" + ClsPub.isLong(grdMain.Rows[j].Cells[HSnoCol].Value) + "行，物料：" + ClsPub.isStrNull(grdMain.Rows[j].Cells[HMaterNameCol].Value) + " ï¼Œæœªå¯ç”¨æ‰¹æ¬¡ç®¡ç†ï¼Œä¸å…è®¸æœ‰æ‰¹æ¬¡ï¼");


                            return false;


                        }


                        if (cmbHBarCodeType.Text == "奇瑞条码")


                        {


                            string HCusBatchNo = "";    //客户批次


                            HCusBatchNo = DBUtility.ClsPub.isStrNull(grdMain.Rows[j].Cells[HCustomBatchNoCol].Value);


                            if (HCusBatchNo.Trim() == "")


                            {


                                MessageBox.Show(" ç¬¬" + ClsPub.isLong(grdMain.Rows[j].Cells[HSnoCol].Value) + "行，物料：" + ClsPub.isStrNull(grdMain.Rows[j].Cells[HMaterNameCol].Value) + " ï¼Œå®¢æˆ·æ‰¹æ¬¡å·ä¸å…è®¸ä¸ºç©ºï¼");


                                bc.Enabled = true;


                                return false;


                            }


                        }


                    }




                    ////原控制


@@ -772,6 +785,7 @@


                string LSH2 = "";           //流水号转换成字符


                string sDate = "";          //日期


                string sYear = "";          //å¹´


                string sYear2 = "";         //å¹´


                string sPeriod = "";        //月


                string sDay = "";           //日


                string HBatchNo = "";       //批次


@@ -787,6 +801,8 @@


                string CusTM = "";          //客户条码


                string sCusTMNumber = "";   //客户条码自定义前缀


                int CusTMLSH = 0;           //客户条码流水号


                int HLayerNumber = 0;       //码放层数


                string HLayerNumber2 = "";  //码放层数转换成字符


                DataSet Ds;


                pb1.Value = 0;


                for (int j = 0; j < grdMain.Rows.Count; j++)


@@ -798,6 +814,7 @@


                        HBatchNo = ClsPub.isStrNull(grdMain.Rows[j].Cells[HBatchNoCol].Value);


                        sDate = dtpHDate.Value.ToShortDateString();


                        sYear = ClsPub.isDate(sDate).Year.ToString().Substring(2, 2);


                        sYear2 = ClsPub.isDate(sDate).Year.ToString();


                        sPeriod = "0" + ClsPub.isDate(sDate).Month.ToString();


                        sPeriod = sPeriod.Substring(sPeriod.Length - 2, 2);


                        sDay = "0" + ClsPub.isDate(sDate).Day.ToString();


@@ -1580,8 +1597,8 @@


                            HModel = DBUtility.ClsPub.isStrNull(grdMain.Rows[j].Cells[HMaterModelCol].Value);


                            HCusNumber = "8DP";     //供应商代码固定为8DP


                            HCusBatchNo = DBUtility.ClsPub.isStrNull(grdMain.Rows[j].Cells[HCustomBatchNoCol].Value);


                            //客户条码前缀 = 10#规格型号$+11#供应商代码$


                            sCusTMNumber = "10#" + HModel + "$11#" + HCusNumber + "$";


                            //客户条码前缀 = 10#规格型号$+11#供应商代码$+20#包装日期$


                            sCusTMNumber = "10#" + HModel + "$11#" + HCusNumber + "$20#" + sYear2 + sPeriod + sDay + "$";


                            Ds = oWeb.getDataSetBySQL("exec h_p_WMS_GetMaxNo  '" + sCusTMNumber + "'", "h_p_WMS_GetMaxNo", ref DBUtility.ClsPub.sExeReturnInfo);//获取最大流水号


                            CusTMLSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]);


                        }


@@ -1654,16 +1671,18 @@


                                //条码编号 = æ¡ç å‰ç¼€ + æµæ°´å·


                                TM = sTMNumber + LSH2;




                                //客户条码前缀 = 10#规格型号$+11#供应商代码$


                                //客户条码 = å®¢æˆ·æ¡ç å‰ç¼€+17#最小包装数量$+18#供应商批次$+流水号


                                CusTMLSH = CusTMLSH + 1;


                                CusTM = sCusTMNumber + "17#"+ HMinQty+ "$18#"+ HCusBatchNo+ "$"+ CusTMLSH;


                                if (HCusBatchNo.Trim() == "")


                                //客户条码 = 10#规格型号$+11#供应商代码$+17#最小包装数量$+18#供应商批次$+19#码放层数$+20#包装日期+31#流水号$


                                HLayerNumber = DBUtility.ClsPub.isInt(grdMain.Rows[j].Cells[HLayerNumberCol].Value);


                                if(HLayerNumber==0)


                                {


                                    MessageBox.Show("客户批次号不允许为空！");


                                    bc.Enabled = true;


                                    return;


                                    HLayerNumber2 = "";


                                }


                                else


                                {


                                    HLayerNumber2 = HLayerNumber.ToString();


                                }


                                CusTMLSH = CusTMLSH + 1;


                                CusTM = "10#" + HModel + "$11#" + HCusNumber + "$17#" + HMinQty+ "$18#"+ HCusBatchNo + "$19#" + HLayerNumber2 + "$20#" + sYear2 + sPeriod + sDay + "$31#" + CusTMLSH + "$";


                            }




                            if (CampanyName == "韩电" && cmbHBarCodeType.Text != "箱发条码") //系统参数  å®¢æˆ·å®šåˆ¶åŒ–名称


@@ -1767,6 +1786,7 @@


                            grdSub.Rows[i].Cells[HBarCode_Pack2Col].Value = grdMain.Rows[j].Cells[HBarCode_PackCol].Value;


                            grdSub.Rows[i].Cells[HCustomQty12Col].Value = ClsPub.isLong(txtHCaseNo.Text) + i;


                            grdSub.Rows[i].Cells[HCusBarCodeCol].Value = CusTM;


                            grdSub.Rows[i].Cells[HLayerNumber2Col].Value = grdMain.Rows[j].Cells[HLayerNumberCol].Value;


                            k = k + 1;


                            n = n + 1;


                            //oWeb.getRunProc("exec h_p_WMS_SetMaxNo '" + sTMNumber + "'", ref DBUtility.ClsPub.sExeReturnInfo);


@@ -1860,6 +1880,7 @@


                long HCustomQty1 = 0;


                string HCusBarCode = "";


                string HBarCodeStatus = "";


                Int64 sHLayerNumber = 0;     //码放层数




                string[] sSQLMul = new string[grdSub.Rows.Count];




@@ -1941,6 +1962,7 @@


                        HBarCode_Pack = ClsPub.isStrNull(grdSub.Rows[i].Cells[HBarCode_Pack2Col].Value);


                        HCustomQty1 = ClsPub.isLong(grdSub.Rows[i].Cells[HCustomQty12Col].Value); //箱号（森楷）


                        HCusBarCode = ClsPub.isStrNull(grdSub.Rows[i].Cells[HCusBarCodeCol].Value);


                        sHLayerNumber = ClsPub.isLong(grdSub.Rows[i].Cells[HLayerNumber2Col].Value);


                        sSQLMul[mm] = "insert into Gy_BarCodeBill (HBarCode,HBarCodeType,HMaterID,HUnitID,HQty" +


                                    ",HBatchNo,HSupID,HGroupID,HMaker,HMakeDate,HPrintQty,HinitQty" +


                                    ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HEndQty " +


@@ -1951,7 +1973,7 @@


                                    ",HSTOCKORGID,HOWNERID,HBeginDate,HSeOrderBillNo,HGBBarCode " +


                                    ",POOrderBillNo,HInterID,HInitSourceEntryID,HBarCode_Pack " +


                                    ",HMaterName,HMaterModel,HPinfan,HAuxPropID,HMTONo " +


                                    ",HCustomQty1,HCusBarCode,HBarCodeStatus " +


                                    ",HCustomQty1,HLayerNumber,HCusBarCode,HBarCodeStatus " +


                                    ") values ("


                                    + "'" + HBarCode + "','" + HBarCodeType + "'," + HMaterID.ToString() + "," + HUnitID.ToString() + "," + HQty2.ToString()


                                    + ",'" + HBatchNo2 + "'," + HSupID.ToString() + "," + HGroupID.ToString() + ",'" + ClsPub.CurUserName + "',getdate()," + HPrintQty.ToString() + "," + HQty2.ToString()


@@ -1963,7 +1985,7 @@


                                    + ", " + HOrgID.ToString() + "," + HOrgID.ToString() + ",'" + HBeginDate.ToShortDateString() + "','" + HSeOrderBillNo + "','" + HGBBarCode + "'"


                                    + ",'" + POOrderBillNo + "'," + HInterID.ToString() + "," + HSourceEntryID.ToString() + ",'" + HBarCode_Pack + "'"


                                    + ",'" + HMaterName + "','" + HMaterModel + "','" + HPinfan + "'," + HAuxPropID.ToString() + ",'" + HMTONo + "'"


                                    + ", " + HCustomQty1.ToString() + ",'" + HCusBarCode + "','" + HBarCodeStatus + "')";


                                    + ", " + HCustomQty1.ToString() + "," + sHLayerNumber.ToString() + ",'" + HCusBarCode + "','" + HBarCodeStatus + "')";


                        //oCn.RunProc("exec setLSH '" + ClsPub.GetServerDate(0) + "'");


                        mm = mm + 1;


                        Application.DoEvents();


@@ -2034,7 +2056,7 @@


        {


            grdMain.RowCount = 0;


            grdSub.RowCount = 0;


            grdMain.ColumnCount = 76;                       //总列数


            grdMain.ColumnCount = 77;                       //总列数


            ClsPub1.initGridFst(grdMain, this.Name);


            grdMain.Columns[HSnoCol].HeaderText = "序号";


            grdMain.Columns[HMainIDCol].HeaderText = "源单主ID";


@@ -2103,6 +2125,7 @@


            grdMain.Columns[HJiaYeLCol].HeaderText = "加液量";


            grdMain.Columns[POOrderBillNoCol].HeaderText = "采购订单号";


            grdMain.Columns[HBarCode_PackCol].HeaderText = "托条码编号";


            grdMain.Columns[HLayerNumberCol].HeaderText = "码放层数";


            ////


            //格式化    éšè—åˆ—


            grdMain.Columns[HTagCol].Visible = false;


@@ -2171,6 +2194,7 @@


            grdMain.Columns[POOrderBillNoCol].Visible = false;


            grdMain.Columns[HBarCode_PackCol].Visible = false;


            grdMain.Columns[HCustomQty1Col].Visible = false;


            grdMain.Columns[HLayerNumberCol].Visible = false;




            if (CampanyName == "韩电") //系统参数  å®¢æˆ·å®šåˆ¶åŒ–名称


            {


@@ -2212,6 +2236,7 @@


                grdMain.Columns[HAuxPropNumberCol].Visible = true;


                grdMain.Columns[HAuxPropNameCol].Visible = true;


                grdMain.Columns[HCustomBatchNoCol].Visible = true;


                grdMain.Columns[HLayerNumberCol].Visible = true;


            }


            else if (CampanyName == "圣龙") //系统参数  å®¢æˆ·å®šåˆ¶åŒ–名称


            {


@@ -2245,6 +2270,7 @@


                                    "," + HPressModelCol.ToString() +


                                    "," + HGBBarCodeCol.ToString() +


                                    "," + HCustomBatchNoCol.ToString() +


                                    "," + HLayerNumberCol.ToString() +


                                    "," + HRemarkCol.ToString();


            //设置合计列


            string sTotalCol = HQtyCol.ToString();


@@ -2253,7 +2279,7 @@


            ClsPub1.initGridLast(sAllowCol, sTotalCol, oSumGrid);


            //----------------------------




            grdSub.ColumnCount = 75;                       //总列数


            grdSub.ColumnCount = 76;                       //总列数


            ClsPub1.initGridFst(grdSub, this.Name);


            grdSub.Columns[HSelectCol].HeaderText = "选择";


            grdSub.Columns[HTMCol].HeaderText = "条码编号";


@@ -2327,6 +2353,7 @@


            grdSub.Columns[POOrderBillNo2Col].HeaderText = "采购订单号";


            grdSub.Columns[HBarCode_Pack2Col].HeaderText = "托条码编号";


            grdSub.Columns[HCusBarCodeCol].HeaderText = "客户条码";


            grdSub.Columns[HLayerNumber2Col].HeaderText = "码放层数";




            //格式化    éšè—åˆ—


            grdSub.Columns[HBarCodeType2Col].Visible = false;


@@ -2394,6 +2421,7 @@


            grdSub.Columns[HBarCode_Pack2Col].Visible = false;


            grdSub.Columns[HCustomQty12Col].Visible = false;


            grdSub.Columns[HCusBarCodeCol].Visible = false;


            grdSub.Columns[HLayerNumber2Col].Visible = false;




            if (CampanyName == "韩电") //系统参数  å®¢æˆ·å®šåˆ¶åŒ–名称


            {


@@ -2437,6 +2465,7 @@


                grdSub.Columns[HAuxPropName2Col].Visible = true;


                grdSub.Columns[HCustomBatchNo2Col].Visible = true;


                grdSub.Columns[HCusBarCodeCol].Visible = true;


                grdSub.Columns[HLayerNumber2Col].Visible = true;


            }


            else if (CampanyName == "圣龙") //系统参数  å®¢æˆ·å®šåˆ¶åŒ–名称


            {


@@ -3186,6 +3215,7 @@


                                "," + HSupNumberCol.ToString() +


                                "," + POOrderBillNoCol.ToString() +


                                "," + HCustomBatchNoCol.ToString() +


                                "," + HLayerNumberCol.ToString() +


                                "," + HMinQtyCol.ToString();


                }


                grdMain.Columns[HBillNoCol].ReadOnly = true;


@@ -3273,6 +3303,7 @@


                                "," + HPressModelCol.ToString() +


                                "," + HGBBarCodeCol.ToString() +


                                "," + HCustomBatchNoCol.ToString() +


                                "," + HLayerNumberCol.ToString() +


                                "," + HMinQtyCol.ToString();


            }


            grdMain.Columns[HBillNoCol].ReadOnly = true;