修改了生产汇报单扫描条码方法

ch

2022-03-14 7ce5df49becfd770e719e5bc3d078389ea35d0f9

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

@@ -37,6 +37,10 @@
        public string sDlgWhere = "";  //外窗体递入
        public DBUtility.ClsPub.Enum_BillStatus BillStatus;
        public Int64 HInterID = 0;
        public const string ModName1 = "3783";
        public Int64 HInterID_TTM = 0;
        public string HBillNo_TTM = "";
        ClsCN SubCn = new ClsCN();
        //
        private void initGrid()
        {
@@ -46,7 +50,6 @@

        private void Display()
        {
            ClsCN SubCn = new ClsCN();
            DataSet DSet;
            string sSql = "";
            string sFastSQL = "";
@@ -57,6 +60,9 @@
            //}
            string HICMOBillNo = "";
            HICMOBillNo = txtHICMOBillNo.Text.Trim().ToString();
            //销售订单号
            string HSeOrderBillNo = "";
            HICMOBillNo = txtHSeOrderBillNo.Text.Trim().ToString();
            //物料
            //if (txtHMaterID.Text.Trim() != "")
            //{
@@ -87,8 +93,8 @@
            //{
            //    sFastSQL = sFastSQL + " and æ—¥æœŸ<='" + dtpHEndDate.Value.ToShortDateString() + "'";
            //}
            string HEndDate = "";
            HEndDate = dtpHEndDate.Value.ToShortDateString();
            //string HEndDate = "";
            //HEndDate = dtpHEndDate.Value.ToShortDateString();
            //if (sFastSQL.Trim() == "")
            //{
            //    MessageBox.Show("没有输入条件!");
@@ -98,7 +104,7 @@
            //过滤条件

            //
            DSet = SubCn.RunProcReturn("exec h_p_KSTMSC '" + HICMOBillNo + "' , '" + HMaterName + "' , '" + HSourceName + "' ,'" + HEmpName + "' ,'" + HBeginDate + "', '" + HEndDate + "'", "h_p_KSTMSC", ref DBUtility.ClsPub.sExeReturnInfo);
            DSet = SubCn.RunProcReturn("exec h_p_KSTMSC '" + HSeOrderBillNo + "' ,'" + HICMOBillNo + "' , '" + HMaterName + "' , '" + HSourceName + "' ,'" + HEmpName + "' ,'" + HBeginDate + "'", "h_p_KSTMSC", ref DBUtility.ClsPub.sExeReturnInfo);
            //生成首行标题
            if (DSet == null)
            {
@@ -755,7 +761,149 @@
            Display();
        }

        string TTM = "";            //托条码
        string HTTMNumber = "";
        string HICMOBillNo = "";    //生产订单号
        int TLSH = 0;
        string TLSH2 = "";
        string HOrgNumber = "";



        private void button4_Click(object sender, EventArgs e)
        {
            //1.获取界面上面整箱数量框输入的数量 èµ‹å€¼ç»™å˜é‡  å¹¶åˆ·æ–°ç½‘æ ¼
            double HBarCodeQty = 0;
            double HZXQty = 0;
            HZXQty = ClsPub.isDoule(txtHZXQty.Text);
            if (HZXQty ==0)
            {
                MessageBox.Show("请输入整箱数量！");
                return;
            }
            Display();
            //2.获取网格选中行物料ID
            //int a = grdMain.CurrentRow.Index;
            //long HMaterID = 0;
            ////HMaterID = DBUtility.ClsPub.isLong(grdMain.Rows[a].Cells[Fun_GetCol("HMaterID")].Value);
            //    if (HMaterID == 0)
            //    {
            //        MessageBox.Show("没有选中任何记录！");
            //        return;
            //    }
            //3.定义是否组托的变量
            int Mul = 0;
            //4.根据单据类型获取本次条码主内码HInterID
            HInterID = DBUtility.ClsPub.CreateBillID_Prod(ModName, ref DBUtility.ClsPub.sExeReturnInfo);
            for (int i = 0; i < grdMain.Rows.Count; i++)
            {

                //获取网格里面每一行订单对应的订单数量
                double HDDQty = 0;
                HDDQty = DBUtility.ClsPub.isDoule(grdMain.Rows[grdMain.Rows[i].Index].Cells[Fun_GetCol("订单数量")].Value);


                //获取当前系统登陆组织代码
                HOrgNumber = ClsPub.HOrgNumber;

              


                //自动匹配逻辑  åˆ¤æ–­è®¢å•æ•°é‡æ˜¯å¦å¤§äºŽæ•´ç®±æ•°é‡   å¦‚果订单数量大于整箱数量  ç›´æŽ¥ç”Ÿæˆå”¯ä¸€ç 
                //如果订单数量小于整箱数量  åˆ™å¾ªçŽ¯ç”Ÿæˆå”¯ä¸€ç    ç”Ÿæˆå¯¹åº”的托条码
                    if (HDDQty >= HZXQty)
                    {
                        HBarCodeQty = HZXQty;
                        this.Sub_SaveBill_TTM();
                        Display();
                        Mul = Mul + 1;
                        break;
                    }
                    else if(HDDQty < HZXQty)
                    {
                        HBarCodeQty = HDDQty;
                        HZXQty = HZXQty - HDDQty;
                        this.Sub_SaveBill_TTM();
                        Mul = Mul + 1;
                        continue;
                    }

                //如果Mul>1 æ–°å¢žç»„托单主表
              
            }

            if (Mul > 1)
            {
                //HICMOBillNo = DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[Fun_GetCol("生产订单号")].Value);
                DataSet DS1;
                HTTMNumber = HOrgNumber + HICMOBillNo;
                DS1 = oCn.RunProcReturn("exec h_p_WMS_GetMaxNo '" + HTTMNumber + "'", "h_p_WMS_GetMaxNo");    //获取最大流水号
                TLSH = ClsPub.isInt(DS1.Tables[0].Rows[0][0]);
                TLSH2 = TLSH.ToString();
                TTM = HTTMNumber + TLSH2;
                HInterID_TTM = DBUtility.ClsPub.CreateBillID_Prod(ModName1, ref DBUtility.ClsPub.sExeReturnInfo);
                HBillNo_TTM = DBUtility.ClsPub.CreateBillCode_Prod(ModName1, ref DBUtility.ClsPub.sExeReturnInfo, true);//得到新单号

                string HDate = "";
                string HYear = "";
                string HPeriod = "";
                string HDay = "";
                HDate = DateTime.Now.ToShortDateString();
                HYear = ClsPub.isDate(HDate).Year.ToString().Substring(2, 2);
                HPeriod = "0" + ClsPub.isDate(HDate).Month.ToString();
                HPeriod = HPeriod.Substring(HPeriod.Length - 2, 2);
                HDay = "0" + ClsPub.isDate(HDate).Day.ToString();
                HDay = HDay.Substring(HDay.Length - 2, 2);

                oCn.RunProc("insert into Sc_PackUnionBillMain (HYear,HPeriod,HBillType,HInterID,HDate" +
                                   ",HBillNo,HBillStatus,HICMOBillNo,HBarCode_Pack,HMaterID,HUnitID,HWeight" +
                                   ",HPWeight,HProdOrgID,HDeptID,HEmpID,HSNum,HPackNum,HBarCode_Cus,HBatchNo " +
                                   ") values ("
                                   + HYear + "," + HPeriod + ",'3783'," + HInterID_TTM + ",'" + HDate + "'"
                                   + ", " + HBillNo_TTM.ToString() + ",1,''," + TTM.ToString() + ",0,0,0"
                                   + ",0,1,0,0,0,0,'','')");
            }


            //3.先判断物料是否一致  å¦‚果一致开始循环网格
            for (int i = 0; i < grdMain.Rows.Count; i++)
            {
                //long HGrdMaterID = 0;
                //HGrdMaterID = DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.Rows[i].Index].Cells[Fun_GetCol("HMaterID")].Value);
                //if (HGrdMaterID == HMaterID)
                //{
                //    double HDDQty = 0;
                //    HDDQty = DBUtility.ClsPub.isDoule(grdMain.Rows[grdMain.Rows[i].Index].Cells[Fun_GetCol("订单数量")].Value);
                //    //如果循环的该行记录的订单数量已经大于等于本次装箱数量  åˆ™ç›´æŽ¥ç”Ÿæˆå”¯ä¸€ç   å¹¶ä¸”刷新网格  åˆ·æ–°æ¡ç ä¿¡æ¯é¡µ
                //    if (HDDQty >= HZXQty)
                //    {
                //        double HBarCodeQty = 0;
                //        HBarCodeQty = HZXQty;
                //        this.Sub_SaveBill();
                //        Display();
                //    }
                //    //如果改行记录订单数量小于本次装箱数量 åˆ™ç»§ç»­å¾ªçŽ¯  èµ°ç”Ÿæˆæ‰˜æ¡ç æ–¹æ³•
                //    else  
                //    {
                //        //查出符合条件的选中这条数量跟装箱数量的差异值
                //        double HCYQty = 0;
                //        HCYQty = HZXQty - DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.Rows[i].Index].Cells[Fun_GetCol("订单数量")].Value);

                //    }

                //}
                //else
                //{
                   
                //}
            }



           
        }

        private void Sub_SaveBill()
        {
            HInterID = DBUtility.ClsPub.CreateBillID_Prod(ModName, ref DBUtility.ClsPub.sExeReturnInfo);
            string HMaterNumber = "";
@@ -769,18 +917,18 @@
            DataSet Ds;
            int LSH = 0;                //流水号
            string LSH2 = "";           //流水号转换成字符
            double HSumQty = 0;         //产品数量
            double HMinQty = 0;         //最小包装数
            double HZXQty = 0;         //装箱数量
            double HDDQty = 0;         //订单数量
            double HBQty = 0;         //箱数
            int k = 0;
            int n = 0;                  //同一批生成条码中的第几条
            string WeiShu = "";         //尾数
            int LSHlen = 6;             //流水号长度
            string TM = "";             //条码
            for (int j = 0; j < grdMain.SelectedRows.Count; j++)
            for (int j = 0; j < grdMain.Rows.Count; j++)
            {
                HMaterNumber = DBUtility.ClsPub.isStrNull(grdMain.Rows[grdMain.SelectedRows[j].Index].Cells[Fun_GetCol("物料代码")].Value);
                HBatchNo = DBUtility.ClsPub.isStrNull(grdMain.Rows[grdMain.SelectedRows[j].Index].Cells[Fun_GetCol("批次")].Value);
                HMaterNumber = DBUtility.ClsPub.isStrNull(grdMain.Rows[j].Cells[Fun_GetCol("物料代码")].Value);
                HBatchNo = DBUtility.ClsPub.isStrNull(grdMain.Rows[j].Cells[Fun_GetCol("批次")].Value);
                HDate = DateTime.Now.ToShortDateString();
                HYear = ClsPub.isDate(HDate).Year.ToString().Substring(2, 2);
                HPeriod = "0" + ClsPub.isDate(HDate).Month.ToString();
@@ -788,23 +936,11 @@
                HDay = "0" + ClsPub.isDate(HDate).Day.ToString();
                HDay = HDay.Substring(HDay.Length - 2, 2);
                HOrgNumber = ClsPub.HOrgNumber;
                //箱数列=数量/最小包装数
                //double sMoney = 0;
                //if ((DBUtility.ClsPub.isLong(grdMain.SelectedRows[j].Cells[Fun_GetCol("HMiniQty")].Value) == 0))
                //{
                //    sMoney = 0;
                //}
                //else
                //{
                //    sMoney = ClsPub.isDoule(grdMain.SelectedRows[j].Cells[Fun_GetCol("HQty")].Value) / ClsPub.isDoule(grdMain.SelectedRows[j].Cells[Fun_GetCol("HMiniQty")].Value);
                //}
                //sMoney = Math.Ceiling(sMoney);
                //grdMain.SelectedRows[j].Cells[Fun_GetCol("HBQty")].Value = sMoney;


                HBQty = HBQty + ClsPub.isInt(txtHBQty.Text);
                HMinQty = ClsPub.isDoule(txtHMiniQty.Text);
                HSumQty = ClsPub.isDoule(txtHICMOQty.Text);
                //HBQty = HBQty + ClsPub.isInt(txtHBQty.Text);
                HZXQty = ClsPub.isDoule(txtHZXQty.Text);
                HDDQty = DBUtility.ClsPub.isDoule(grdMain.Rows[j].Cells[Fun_GetCol("订单数量")].Value);


                if (cmbHBarCodeType.Text == "唯一条码")
@@ -818,27 +954,7 @@
                    TM = HOrgNumber + HMaterNumber + HBatchNo;
                }
                n = 0;
                for (int i = k; i < HBQty; i++)
                {
                    if (HSumQty - HMinQty > 0)
                    {
                        WeiShu = "";
                        HSumQty = HSumQty - HMinQty;
                    }
                    else
                    {
                        if (HSumQty == HMinQty)
                        {
                            WeiShu = "";
                        }
                        else
                        {
                            WeiShu = "尾数";
                        }
                        HMinQty = HSumQty;
                    }
                    //
                    LSH = LSH + 1;
                   
                    LSH2 = LSH.ToString();
                    while (LSH2.Length < LSHlen)  //如果流水号小于6位数前面补0
                    {
@@ -857,7 +973,7 @@
                    string HWei = "";      //尾数
                    string HBarCode = "";
                    string HBarCodeType = "";
                    Int64 HMaterID = 0;
                    Int64 HMaterID1 = 0;
                    Int64 HAuxPropID = 0;
                    Int64 HUnitID = 0;
                    double HQty2 = 0;
@@ -891,14 +1007,14 @@
                        HWei = WeiShu;
                        HBarCode = TM;
                        HBarCodeType = ClsPub.isStrNull(cmbHBarCodeType.Text);
                        HMaterID = ClsPub.isLong(grdMain.SelectedRows[j].Cells[Fun_GetCol("HMaterID")].Value);
                        HMaterID1 = ClsPub.isLong(grdMain.Rows[j].Cells[Fun_GetCol("HMaterID")].Value);
                        HAuxPropID = 0;
                        HUnitID = 0;
                        HQty2 = HMinQty;
                        HBatchNo2 = ClsPub.isStrNull(grdMain.SelectedRows[j].Cells[Fun_GetCol("批次")].Value);
                        HQty2 = HZXQty;
                        HBatchNo2 = ClsPub.isStrNull(grdMain.Rows[j].Cells[Fun_GetCol("批次")].Value);
                        HSourceInterID = 0;
                        HSourceEntryID = 0;
                        HSourceBillNo = ClsPub.isStrNull(grdMain.SelectedRows[j].Cells[Fun_GetCol("生产订单号")].Value);
                        HSourceBillNo = ClsPub.isStrNull(grdMain.Rows[j].Cells[Fun_GetCol("生产订单号")].Value);
                        HSourceBillType = "3710";
                        HBarcodeQtys = 0;
                        HBarcodeNo = 0;
@@ -907,13 +1023,13 @@
                        HWhID = 0;
                        HSPID = 0;
                        HRemark = "";
                        HMaterName = ClsPub.isStrNull(grdMain.SelectedRows[j].Cells[Fun_GetCol("物料名称")].Value);
                        HMaterModel = ClsPub.isStrNull(grdMain.SelectedRows[j].Cells[Fun_GetCol("规格型号")].Value);
                        HMaterName = ClsPub.isStrNull(grdMain.Rows[j].Cells[Fun_GetCol("物料名称")].Value);
                        HMaterModel = ClsPub.isStrNull(grdMain.Rows[j].Cells[Fun_GetCol("规格型号")].Value);
                        HPinfan = "";
                        HMTONo = "";
                        HCusID = 0;
                        HCusType = "";
                        HEndDate = ClsPub.isDate(grdMain.SelectedRows[j].Cells[Fun_GetCol("日期")].Value);
                        HEndDate = ClsPub.isDate(grdMain.Rows[j].Cells[Fun_GetCol("日期")].Value);
                        HWorkLineName = "";
                        HSeOrderBillNo = "";
                        HInnerBillNo = "";
@@ -925,7 +1041,7 @@
                                            ",HSTOCKORGID,HOWNERID,HSeOrderBillNo,HInterID " +
                                            ",HMaterName,HMaterModel,HPinfan,HAuxPropID,HMTONo,HInnerBillNo " +
                                            ") values ("
                                            + "'" + HBarCode + "','" + HBarCodeType + "'," + HMaterID.ToString() + "," + HUnitID.ToString() + "," + HQty2.ToString()
                                            + "'" + HBarCode + "','" + HBarCodeType + "'," + HMaterID1.ToString() + "," + HUnitID.ToString() + "," + HQty2.ToString()
                                            + ",'" + HBatchNo2 + "'," + HSupID.ToString() + "," + HGroupID.ToString() + ",'" + ClsPub.CurUserName + "',getdate()," + HPrintQty.ToString() + "," + HQty2.ToString()
                                            + ", " + HSourceInterID.ToString() + "," + HSourceEntryID.ToString() + ",'" + HSourceBillNo + "','" + HSourceBillType + "','" + HWei + "'"
                                            + ", " + HBarcodeQtys.ToString() + "," + HBarcodeNo.ToString() + "," + HDeptID.ToString() + "," + HWhID.ToString() + "," + HSPID.ToString() + ",'" + HRemark + "'"
@@ -943,10 +1059,181 @@
                        oCn.RollBack();
                        MessageBox.Show("条码生成失败！" + e1.Message);
                    }
            }
        }



        private void Sub_SaveBill_TTM()
        {
            HInterID = DBUtility.ClsPub.CreateBillID_Prod(ModName, ref DBUtility.ClsPub.sExeReturnInfo);
            HInterID_TTM = DBUtility.ClsPub.CreateBillID_Prod(ModName1, ref DBUtility.ClsPub.sExeReturnInfo);
            HBillNo_TTM = DBUtility.ClsPub.CreateBillCode_Prod(ModName1, ref DBUtility.ClsPub.sExeReturnInfo, true);//得到新单号
            string HMaterNumber = "";
            string HBatchNo = "";
            string HDate = "";
            string HYear = "";
            string HPeriod = "";
            string HDay = "";
            string HTMNumber = "";
            string HOrgNumber = "";
            DataSet Ds;
            int LSH = 0;                //流水号
            string LSH2 = "";           //流水号转换成字符
            double HZXQty = 0;         //装箱数量
            double HDDQty = 0;         //订单数量
            double HBQty = 0;         //箱数
            int k = 0;
            int n = 0;                  //同一批生成条码中的第几条
            string WeiShu = "";         //尾数
            int LSHlen = 6;             //流水号长度
            string TM = "";             //条码
            for (int j = 0; j < grdMain.Rows.Count; j++)
            {
                HMaterNumber = DBUtility.ClsPub.isStrNull(grdMain.Rows[j].Cells[Fun_GetCol("物料代码")].Value);
                HBatchNo = DBUtility.ClsPub.isStrNull(grdMain.Rows[j].Cells[Fun_GetCol("批次")].Value);
                HDate = DateTime.Now.ToShortDateString();
                HYear = ClsPub.isDate(HDate).Year.ToString().Substring(2, 2);
                HPeriod = "0" + ClsPub.isDate(HDate).Month.ToString();
                HPeriod = HPeriod.Substring(HPeriod.Length - 2, 2);
                HDay = "0" + ClsPub.isDate(HDate).Day.ToString();
                HDay = HDay.Substring(HDay.Length - 2, 2);
                HOrgNumber = ClsPub.HOrgNumber;


                //HBQty = HBQty + ClsPub.isInt(txtHBQty.Text);
                HZXQty = ClsPub.isDoule(txtHZXQty.Text);
                HDDQty = DBUtility.ClsPub.isDoule(grdMain.Rows[j].Cells[Fun_GetCol("订单数量")].Value);
                HICMOBillNo = DBUtility.ClsPub.isStrNull(grdMain.Rows[j].Cells[Fun_GetCol("生产订单号")].Value);

                if (cmbHBarCodeType.Text == "唯一条码")
                {
                    HTMNumber = HOrgNumber + HMaterNumber + HYear + HPeriod + HDay;
                    Ds = oCn.RunProcReturn("exec h_p_WMS_GetMaxNo '" + HTMNumber + "'", "h_p_WMS_GetMaxNo");    //获取最大流水号
                    LSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]);
                }
                else if (cmbHBarCodeType.Text == "批次条码")
                {
                    TM = HOrgNumber + HMaterNumber + HBatchNo;
                }
             

                n = 0;

                LSH2 = LSH.ToString();
                while (LSH2.Length < LSHlen)  //如果流水号小于6位数前面补0
                {
                    LSH2 = "0" + LSH2;
                }
                if (cmbHBarCodeType.Text == "唯一条码")
                {
                    //条码编号 = æ¡ç å‰ç¼€ + æµæ°´å·
                    TM = HTMNumber + LSH2;
                }
                if (TM.Trim() == "")
                {
                    MessageBox.Show("条形码不能为空，不能生成条码！");
                    return;
                }
                string HWei = "";      //尾数
                string HBarCode = "";
                string HBarCodeType = "";
                Int64 HMaterID1 = 0;
                Int64 HAuxPropID = 0;
                Int64 HUnitID = 0;
                double HQty2 = 0;
                string HBatchNo2 = "";
                Int64 HSupID = 0;
                Int64 HGroupID = 0;
                int HPrintQty = 0;
                Int64 HSourceInterID = 0;
                Int64 HSourceEntryID = 0;
                string HSourceBillNo = "";
                string HSourceBillType = "";
                Int64 HBarcodeNo = 0;       //托号
                Int64 HBarcodeQtys = 0;     //总托数
                Int64 HDeptID = 0;
                Int64 HWhID = 0;
                Int64 HSPID = 0;
                string HRemark = "";
                string HMaterName = "";
                string HMaterModel = "";
                string HPinfan = "";
                string HMTONo = "";
                Int64 HCusID = 0;
                string HCusType = "";
                DateTime HEndDate;
                string HWorkLineName = "";
                string HSeOrderBillNo = "";
                string HInnerBillNo = "";
                try
                {
                    oCn.BeginTran();
                    HWei = WeiShu;
                    HBarCode = TM;
                    HBarCodeType = ClsPub.isStrNull(cmbHBarCodeType.Text);
                    HMaterID1 = ClsPub.isLong(grdMain.Rows[j].Cells[Fun_GetCol("HMaterID")].Value);
                    HAuxPropID = 0;
                    HUnitID = 0;
                    HQty2 = HZXQty;
                    HBatchNo2 = ClsPub.isStrNull(grdMain.Rows[j].Cells[Fun_GetCol("批次")].Value);
                    HSourceInterID = 0;
                    HSourceEntryID = 0;
                    HSourceBillNo = ClsPub.isStrNull(grdMain.Rows[j].Cells[Fun_GetCol("生产订单号")].Value);
                    HSourceBillType = "3710";
                    HBarcodeQtys = 0;
                    HBarcodeNo = 0;
                    HSupID = 0;
                    HDeptID = 0;
                    HWhID = 0;
                    HSPID = 0;
                    HRemark = "";
                    HMaterName = ClsPub.isStrNull(grdMain.Rows[j].Cells[Fun_GetCol("物料名称")].Value);
                    HMaterModel = ClsPub.isStrNull(grdMain.Rows[j].Cells[Fun_GetCol("规格型号")].Value);
                    HPinfan = "";
                    HMTONo = "";
                    HCusID = 0;
                    HCusType = "";
                    HEndDate = ClsPub.isDate(grdMain.Rows[j].Cells[Fun_GetCol("日期")].Value);
                    HWorkLineName = "";
                    HSeOrderBillNo = "";
                    HInnerBillNo = "";
                    oCn.RunProc("insert into Gy_BarCodeBill (HBarCode,HBarCodeType,HMaterID,HUnitID,HQty" +
                                        ",HBatchNo,HSupID,HGroupID,HMaker,HMakeDate,HPrintQty,HinitQty" +
                                        ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HEndQty " +
                                        ",HBarcodeQtys,HBarcodeNo,HDeptID,HWhID,HSPID,HRemark " +
                                        ",HCusID,HCusType,HEndDate,HWorkLineName,HBarCodeDate " +
                                        ",HSTOCKORGID,HOWNERID,HSeOrderBillNo,HInterID " +
                                        ",HMaterName,HMaterModel,HPinfan,HAuxPropID,HMTONo,HInnerBillNo " +
                                        ") values ("
                                        + "'" + HBarCode + "','" + HBarCodeType + "'," + HMaterID1.ToString() + "," + HUnitID.ToString() + "," + HQty2.ToString()
                                        + ",'" + HBatchNo2 + "'," + HSupID.ToString() + "," + HGroupID.ToString() + ",'" + ClsPub.CurUserName + "',getdate()," + HPrintQty.ToString() + "," + HQty2.ToString()
                                        + ", " + HSourceInterID.ToString() + "," + HSourceEntryID.ToString() + ",'" + HSourceBillNo + "','" + HSourceBillType + "','" + HWei + "'"
                                        + ", " + HBarcodeQtys.ToString() + "," + HBarcodeNo.ToString() + "," + HDeptID.ToString() + "," + HWhID.ToString() + "," + HSPID.ToString() + ",'" + HRemark + "'"
                                        + ", " + HCusID.ToString() + ",'" + HCusType + "','" + HEndDate.ToShortDateString() + "','" + HWorkLineName + "','" + HDate + "'"
                                        + ", " + ClsPub.HOrgID.ToString() + "," + ClsPub.HOrgID.ToString() + ",'" + HSeOrderBillNo + "'," + HInterID.ToString()
                                        + ",'" + HMaterName + "','" + HMaterModel + "','" + HPinfan + "'," + HAuxPropID.ToString() + ",'" + HMTONo + "','" + HInnerBillNo + "')");
                    oCn.RunProc("insert into Sc_PackUnionBillSub (HInterID,HEntryID,HSourceInterID,HSourceEntryID,HSourceBillNo" +
                                        ",HSourceBillType,HMaterID,HUnitID,HQty,HSourceID,HEquipID,HGroupID" +
                                        ",HWorkerID,HScanDate,HBarCode,HBarCode_Pack,HStatus,HICMOEntryID " +
                                        ") values ("
                                        +  HInterID_TTM + "," + j + ",0,0,''"
                                        + ",'3710'," + HMaterID1.ToString() + "," + HUnitID.ToString() + "," + HQty2.ToString() + ",0,0,0"
                                        + ", 0,getdate(),'" + HBarCode + "','" + TTM + "',0,0)");

                    oCn.Commit();
                    MessageBox.Show("条码生成完毕！");
                    //grdSub.RowCount = 0;
                    DisplayTM();
                }
                catch (Exception e1)
                {
                    oCn.RollBack();
                    MessageBox.Show("条码生成失败！" + e1.Message);
                }
            }
        }



        private void DisplayTM()
@@ -1122,11 +1409,11 @@

        private void cmdHSourceID_Click(object sender, EventArgs e)
        {
            DAL.ClsGy_Source_View oSource = new DAL.ClsGy_Source_View();
            if (oSource.RefreshView())
            DAL.ClsGy_WorkCenter_View oWork = new DAL.ClsGy_WorkCenter_View();
            if (oWork.RefreshView())
            {
                this.txtHSourceID.Text = oSource.oModel.HName;
                this.txtHSourceID.Tag = oSource.oModel.HItemID.ToString();
                this.txtHSourceID.Text = oWork.oModel.HName;
                this.txtHSourceID.Tag = oWork.oModel.HItemID.ToString();
            }
            else
            {
@@ -1197,9 +1484,9 @@

            for (int i = 0; i < grdMain.SelectedRows.Count; i++)
            {
                txtHICMOQty.Text = DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[i].Cells[Fun_GetCol("订单数量")].Value);
                txtHZXQty.Text = DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[i].Cells[Fun_GetCol("订单数量")].Value);
            }
            HICMOQty = DBUtility.ClsPub.isDoule(txtHICMOQty.Text.Trim());
            HICMOQty = DBUtility.ClsPub.isDoule(txtHZXQty.Text.Trim());
            HMiniQty = DBUtility.ClsPub.isDoule(txtHMiniQty.Text.Trim());
            if (HMiniQty == 0)
            {
@@ -1293,7 +1580,7 @@
            txtHEmpID.Text = "";
            txtHICMOBillNo.Text = "";
            txtHICMOBillNo1.Text = "";
            txtHICMOQty.Text = "";
            txtHZXQty.Text = "";
            txtHMaterID.Text = "";
            txtHMaterID1.Text = "";
            txtHMiniQty.Text = "";
@@ -1303,5 +1590,30 @@
            grdSub.DataSource = null;
            grdMain.DataSource = null;
        }

        private void button2_Click(object sender, EventArgs e)
        {
            //获取网格第一行HInterID的值
            Int64 HInterID = 0;
            HInterID = DBUtility.ClsPub.isInt(grdMain.Rows[0].Cells[Fun_GetCol("HInterID")].Value);
            DataSet DSBefore;
            DSBefore =  SubCn.RunProcReturn("exec h_p_PreviousMater "+ HInterID, "h_p_PreviousMater", ref DBUtility.ClsPub.sExeReturnInfo);
            grdMain.DataSource = DSBefore.Tables[0].DefaultView;
        }

        private void button3_Click(object sender, EventArgs e)
        {
            //根据
            Int64 HInterID = 0;
            HInterID = DBUtility.ClsPub.isInt(grdMain.Rows[0].Cells[Fun_GetCol("HInterID")].Value);
            DataSet DSBefore;
            DSBefore = SubCn.RunProcReturn("exec h_p_NextMater " + HInterID, "h_p_NextMater", ref DBUtility.ClsPub.sExeReturnInfo);
            grdMain.DataSource = DSBefore.Tables[0].DefaultView;
        }

        private void button7_Click(object sender, EventArgs e)
        {
            
        }
    }
}