派生自 MES-WEB-API
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
yangle
2022-03-29 84f084b5b5a4593d4e4e30d2c95b91ca0e0e3384 
 WarM/ÌõÂë´òÓ¡/Sc_ICMOToBarCode.cs


@@ -111,8 +111,21 @@


                MessageBox.Show("没有返回任何结果,请在过滤框中点击【恢复】按钮,尝试再次查询！" + DBUtility.ClsPub.sExeReturnInfo);


                return;


            }


            else 


            {


                grdMain.DataSource = DSet.Tables[0].DefaultView;


                //把当前单据ID å­˜åˆ°ä¸€ä¸ªæŒ‰é’®é‡Œé¢   åˆ·æ–°æ—¶æ¯æ¬¡å­˜ä¸€é


                if (DSet.Tables[0].Rows.Count > 0)


                {


                    txtHMaterID.Tag = DBUtility.ClsPub.isInt(grdMain.Rows[0].Cells["HInterID"].Value);


                }


                else


                {


                    


                }


            }


            //


            grdMain.DataSource = DSet.Tables[0].DefaultView;


            




            //标准装箱


            //for (int i = 0; i < grdMain.SelectedRows.Count; i++)


@@ -482,13 +495,13 @@


        private void Sub_SetReport(string sOpenTmp)


        {


            //判断行数


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


            for (int i = 0; i < grdList.Rows.Count; i++)


            {


                grdMain.Rows[i].Cells[0].Value = "";


                grdList.Rows[i].Cells[0].Value = "";


            }


            for (int i = 0; i < grdMain.SelectedRows.Count; i++)


            for (int i = 0; i < grdList.SelectedRows.Count; i++)


            {


                grdMain.Rows[grdMain.SelectedRows[i].Index].Cells[0].Value = "*";


                grdList.Rows[grdMain.SelectedRows[i].Index].Cells[0].Value = "*";


            }


            //


            Report = new GridppReport();


@@ -529,7 +542,7 @@


            try


            {


                DataTable ds = new DataTable();


                BLL.Utility.FillRecordToReport_Sel(Report, grdMain, ds, Fun_GetCol("选择"));


                BLL.Utility.FillRecordToReport_Sel(Report, grdList, ds, Fun_GetCol("选择"));


            }


            catch (Exception e)


            {


@@ -818,13 +831,24 @@


                //生成一个外箱码


                string sPackStr = "ZXM" + HYear + HPeriod + HDay; //外箱码 å‰ç¼€


                DataSet  DsTM = oCn.RunProcReturn("exec h_p_WMS_GetMaxNo '" + sPackStr + "'", "h_p_WMS_GetMaxNo");    //获取最大流水号                                                                                          //oCn.RunProc("exec h_p_WMS_SetMaxNo '" + sTMNumber + "'");


                Int64 TTM_LSH = ClsPub.isLong(DsTM.Tables[0].Rows[0][0]) + 1;


                string sPackBarCode = sPackStr + LSH.ToString();


                Int64 TTM_LSH = ClsPub.isInt(DsTM.Tables[0].Rows[0][0]) + 1;


                string sPackBarCode = sPackStr + TTM_LSH.ToString();


                oCn.RunProc("exec h_p_WMS_SetMaxNo '" + sPackStr + "'");


                






                //MessageBox.Show("11");


                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 + "'"


                                   + ", '" + sPackBarCode.ToString() + "',1,'','" + sPackBarCode.ToString() + "',0,0,0"


                                   + ",0,1,0,0,0,0,'','')");


                //MessageBox.Show("12");


           


                //1.循环网格，根据 æœ¬æ¬¡æ•°é‡ åˆ—  ç”Ÿæˆ å”¯ä¸€ç 


               


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




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


                {


                    if (DBUtility.ClsPub.isDoule(grdMain.Rows[j].Cells[Fun_GetCol("本次数量")].Value) > 0)


                    {


@@ -836,7 +860,7 @@




                        //HBQty = HBQty + ClsPub.isInt(txtHBQty.Text);


                        HZXQty = DBUtility.ClsPub.isDoule(grdMain.Rows[j].Cells[Fun_GetCol("本次数量")].Value);


                        HDDQty = DBUtility.ClsPub.isDoule(grdMain.Rows[j].Cells[Fun_GetCol("订单数量")].Value);


                        HDDQty = DBUtility.ClsPub.isDoule(grdMain.Rows[j].Cells[Fun_GetCol("生产订单数量")].Value);


                        HICMOBillNo = DBUtility.ClsPub.isStrNull(grdMain.Rows[j].Cells[Fun_GetCol("生产订单号")].Value);




                        HTMNumber = HOrgNumber + HMaterNumber + HYear + HPeriod + HDay;


@@ -932,6 +956,7 @@


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




                        oCn.RunProc("exec h_p_WMS_SetMaxNo '" + HTMNumber + "'");


                        DisplayTM();


                    }


                }


                //2.循环结束后，根据 æœ¬æ¬¡ç”Ÿæˆçš„ ä¸»å†…码，从后台数据库获取 æ¡ç åˆ—表，生成 ç»„托单 å’Œ æ‰˜æ¡ç ï¼Œ ç›´æŽ¥è°ƒç”¨å­˜å‚¨è¿‡ç¨‹ 


@@ -942,9 +967,22 @@












                sPackBarCode = "";


                DataSet DSet = oCn.RunProcReturn("select * from h_v_IF_BarCodeBillList Where HinterID=" + HInterID.ToString() + " and æ¡ç ç±»åž‹ = '托盘条码' order by HItemID", "h_v_IF_BarCodeBillList", ref DBUtility.ClsPub.sExeReturnInfo);


                //生成首行标题


                if (DSet == null)


                {


                    MessageBox.Show("没有返回任何结果,条码不存在！" + DBUtility.ClsPub.sExeReturnInfo);


                    return;


                }


                //


                grdList.DataSource = DSet.Tables[0].DefaultView;


                //冻结


                int FrCol = 0;


                string s = "是";


                DBUtility.Xt_BaseBillFun.DisplayGrid(grdList, this.Name + "grdList", s, FrCol);


                oCn.Commit();


                //DisplayTM();


                MessageBox.Show("条码生成完毕！");


               




@@ -958,9 +996,10 @@




                //


                Display();


               




            }


            catch(Exception e )


            catch (Exception e )


            {


                //回滚事务




@@ -971,6 +1010,7 @@




        private void button4_Click(object sender, EventArgs e)


        {


            


            //根据本箱数量 æ¥ åˆ†é…åˆ° æ¯ä¸ªç”Ÿäº§è®¢å•ä¸Šï¼ˆåˆ†é…æ—¶ è¦è€ƒè™‘ è®¢å•å‰©ä½™æ•°é‡å·²ç»æ˜¯ è´Ÿæ•°çš„情况）


            //1.判断本箱数量 å¿…须大于0


            double HZXQty = 0;//整箱数量


@@ -1461,10 +1501,21 @@


                                        + ",'3710'," + HMaterID1.ToString() + "," + HUnitID.ToString() + "," + HQty2.ToString() + ",0,0,0"


                                        + ", 0,getdate(),'" + HBarCode + "','" + TTM + "',0,0)");




                    DataSet DSet = oCn.RunProcReturn("select * from h_v_IF_BarCodeBillList Where HInterID=" + HInterID.ToString() + " and HBarCode like '%ZXM&' order by HItemID", "h_v_IF_BarCodeBillList", ref DBUtility.ClsPub.sExeReturnInfo);


                    //生成首行标题


                    if (DSet == null)


                    {


                        MessageBox.Show("没有返回任何结果,条码不存在！" + DBUtility.ClsPub.sExeReturnInfo);


                        return;


                    }


                    //


                    grdList.DataSource = DSet.Tables[0].DefaultView;




                    oCn.Commit();


                    MessageBox.Show("条码生成完毕！");


                    //grdSub.RowCount = 0;


                    DisplayTM();


                    //DisplayTM();


                   


                }


                catch (Exception e1)


                {


@@ -1478,7 +1529,8 @@




        private void DisplayTM()


        {


            DataSet DSet = oCn.RunProcReturn("select * from h_v_IF_BarCodeBillList Where HinterID=" + HInterID.ToString() + " order by HItemID", "h_v_IF_BarCodeBillList", ref DBUtility.ClsPub.sExeReturnInfo);


            //HInterID = DBUtility.ClsPub.isInt(txtHMaterID.Tag);


            DataSet DSet = oCn.RunProcReturn("select * from h_v_IF_BarCodeBillList Where HinterID=" + HInterID.ToString() + " and æ¡ç ç±»åž‹ = '托盘条码' order by HItemID", "h_v_IF_BarCodeBillList", ref DBUtility.ClsPub.sExeReturnInfo);


            //生成首行标题


            if (DSet == null)


            {


@@ -1649,19 +1701,32 @@




        private void cmdHSourceID_Click(object sender, EventArgs e)


        {


            DAL.ClsGy_WorkCenter_View oWork = new DAL.ClsGy_WorkCenter_View();


            if (oWork.RefreshView())


            DAL.ClsGy_Source_View oSource = new DAL.ClsGy_Source_View();


            if (oSource.RefreshView())


            {


                this.txtHSourceID.Text = oWork.oModel.HName;


                this.txtHSourceID.Tag = oWork.oModel.HItemID.ToString();


                this.txtHSourceID.Text = oSource.oModel.HName;


                this.txtHSourceID.Tag = oSource.oModel.HItemID.ToString();


                //


                Display();


                //


            }


            else


            {


                this.txtHSourceID.Text = "";


            }




            //DAL.ClsGy_WorkCenter_View oWork = new DAL.ClsGy_WorkCenter_View();


            //if (oWork.RefreshView())


            //{


            //    this.txtHSourceID.Text = oWork.oModel.HName;


            //    this.txtHSourceID.Tag = oWork.oModel.HItemID.ToString();


            //    //


            //    Display();


            //    //


            //}


            //else


            //{


            //    this.txtHSourceID.Text = "";


            //}


        }




        private void cmdHEmpID_Click(object sender, EventArgs e)


@@ -1838,20 +1903,31 @@


        {


            //获取网格第一行HInterID的值


            Int64 HInterID = 0;


            HInterID = DBUtility.ClsPub.isInt(grdMain.Rows[0].Cells[Fun_GetCol("HInterID")].Value);


            HInterID = DBUtility.ClsPub.isInt(txtHMaterID.Tag);


            DataSet DSBefore;


            DSBefore =  SubCn.RunProcReturn("exec h_p_PreviousMater "+ HInterID, "h_p_PreviousMater", ref DBUtility.ClsPub.sExeReturnInfo);


            grdMain.DataSource = DSBefore.Tables[0].DefaultView;


            if (DSBefore.Tables[0].Rows.Count > 0)


            {


                txtHMaterID.Tag = DBUtility.ClsPub.isInt(grdMain.Rows[0].Cells["HInterID"].Value);


            }


            else


            {




            }


        }




        private void button3_Click(object sender, EventArgs e)


        {


            //根据


            Int64 HInterID = 0;


            HInterID = DBUtility.ClsPub.isInt(grdMain.Rows[0].Cells[Fun_GetCol("HInterID")].Value);


            //HInterID = DBUtility.ClsPub.isInt(grdMain.Rows[0].Cells[Fun_GetCol("HInterID")].Value);


            HInterID = DBUtility.ClsPub.isInt(txtHMaterID.Tag);


            DataSet DSBefore;


            DSBefore = SubCn.RunProcReturn("exec h_p_NextMater " + HInterID, "h_p_NextMater", ref DBUtility.ClsPub.sExeReturnInfo);


            grdMain.DataSource = DSBefore.Tables[0].DefaultView;


            txtHMaterID.Tag = DBUtility.ClsPub.isInt(grdMain.Rows[0].Cells["HInterID"].Value);


            txtHMaterID.Text = DBUtility.ClsPub.isStrNull(grdMain.Rows[0].Cells["HInterID"].Value);


        }




        //超额打印