Merge branch 'master' of http://101.37.171.70:10101/r/YqnMes

ouyangqing

2021-01-20 11d20b4fb7a3e97c88477f78f1f5393238e2f3a3

 SCM/µ¥¾Ý×ÊÁÏ/Sc_ICMOReportToBarCode.cs

@@ -1,4 +1,4 @@
using System;

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

@@ -68,7 +68,7 @@
            oWeb.Url = SCM.ClsPub1.WEBSURL;

            //

            frmCondition = new frmBillQueryCondition_Base();

            this.Text = ModCaption; 
            this.Text = ModCaption;

            oSumGrid.ogrdMain = grdSub;  //初始化 new

            oSumGrid.oGridsum = grdSum;

            initGrid();

@@ -77,7 +77,7 @@
            cmbFQMB.Items.Add(this.Text);

            cmbFQMB.SelectedIndex = 0;



            if(DBUtility.ClsPub.CurUserName.ToLower()=="admin")

            if (DBUtility.ClsPub.CurUserName.ToLower() == "admin")

            {

                txtHDQQty.ReadOnly = false;

                txtHKSQty.ReadOnly = false;

@@ -114,7 +114,7 @@
        //时间控件

        private void timer1_Tick(object sender, EventArgs e)

        {

            timer1.Enabled=false;

            timer1.Enabled = false;

            Sub_ClearBill();

        }



@@ -122,7 +122,7 @@
        {

            timer2.Enabled = false;

            //

            if (ClsIni.ReadIni("COMINFO", "txtPortName", DBUtility.ClsPub.AppPath + @"/HXERP.ini").Contains("没有找到")==false)

            if (ClsIni.ReadIni("COMINFO", "txtPortName", DBUtility.ClsPub.AppPath + @"/HXERP.ini").Contains("没有找到") == false)

            {

                txtPortName.Text = ClsIni.ReadIni("COMINFO", "txtPortName", DBUtility.ClsPub.AppPath + @"/HXERP.ini");

                txtBaudRate.Text = ClsIni.ReadIni("COMINFO", "txtBaudRate", DBUtility.ClsPub.AppPath + @"/HXERP.ini");

@@ -244,7 +244,7 @@
                txtHSYQty.Text = oTable.Rows[0]["未生成条码数量"].ToString();

                txtHKSQty.Text = lblHNowQty.Text;

                txtHDQQty.Text = lblHNowQty.Text;

                if (DBUtility.ClsPub.isDoule(txtHDQQty.Text) - DBUtility.ClsPub.isDoule(txtHKSQty.Text)>0)

                if (DBUtility.ClsPub.isDoule(txtHDQQty.Text) - DBUtility.ClsPub.isDoule(txtHKSQty.Text) > 0)

                {

                    txtHSJQty.Text = DBUtility.ClsPub.isDoule(DBUtility.ClsPub.isDoule(txtHDQQty.Text) - DBUtility.ClsPub.isDoule(txtHKSQty.Text), 1);

                }

@@ -255,7 +255,7 @@
                DisplayMain();

                //DisplaySub();

            }

            catch(Exception e)

            catch (Exception e)

            {

                MessageBox.Show("读取失败！" + e.Message);

            }

@@ -268,7 +268,7 @@
            string sSql = "";

            string sWhere = "";

            //过滤条件 

            sSql = " exec h_p_Sc_ICMOReportToBarCode_All   '" + HSourceBillTypeID + "'," + HSourceInterID.ToString() + "," + HSourceEntryID.ToString(); 
            sSql = " exec h_p_Sc_ICMOReportToBarCode_All   '" + HSourceBillTypeID + "'," + HSourceInterID.ToString() + "," + HSourceEntryID.ToString();

            //

            DSet = oWeb.getDataSetBySQL(sSql, "h_p_Sc_ICMOReportToBarCode_All", ref DBUtility.ClsPub.sExeReturnInfo);

            //生成首行标题

@@ -278,7 +278,7 @@
                return;

            }

            //

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

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

            {

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

            }

@@ -297,7 +297,7 @@
            ClsPub1.DisplayGrid(grdSub, this.Name + "grdSub", s, FrCol);

            /////////////////////////////

            txtHRelationQty.Text = DBUtility.ClsPub.isDoule(DSet.Tables[2].Rows[0]["关联数量"], 1);

            if(DBUtility.ClsPub.isDoule(txtHSumQty.Text) - DBUtility.ClsPub.isDoule(txtHRelationQty.Text)>=0)

            if (DBUtility.ClsPub.isDoule(txtHSumQty.Text) - DBUtility.ClsPub.isDoule(txtHRelationQty.Text) >= 0)

            {

                txtHSYQty.Text = DBUtility.ClsPub.isDoule(DBUtility.ClsPub.isDoule(txtHSumQty.Text) - DBUtility.ClsPub.isDoule(txtHRelationQty.Text), 1);

            }

@@ -315,7 +315,7 @@
            string sWhere = "";

            //过滤条件 

            sSql = " exec h_p_Sc_ICMOReportToBarCode_Sub   '" + HSourceBillTypeID + "'," + HSourceInterID.ToString() + "," + HSourceEntryID.ToString();

            


            //

            DSet = oWeb.getDataSetBySQL(sSql, "h_p_Sc_ICMOReportToBarCode_Sub", ref DBUtility.ClsPub.sExeReturnInfo);

            //生成首行标题

@@ -347,12 +347,12 @@


        //预览

        int CurRows = 0;

        


        
 


        










        #endregion



@@ -366,11 +366,11 @@
            if (oDept.RefreshView(sWhere))

            {

                this.txtHDeptID.Text = oDept.oModel.HName;

                this.txtHDeptID.Tag = oDept.oModel.HItemID.ToString(); 
                this.txtHDeptID.Tag = oDept.oModel.HItemID.ToString();

            }

            else

            {

                this.txtHDeptID.Text = ""; 
                this.txtHDeptID.Text = "";

            }

        }



@@ -517,19 +517,19 @@
                //    cmdHSaveBill.Enabled = true;

                //    return false;

                //}

                if (DBUtility.ClsPub.isLong(txtHEmpID.Tag) == 0 || DBUtility.ClsPub.isLong(txtHEmpID2.Tag) == 0 ) 
                if (DBUtility.ClsPub.isLong(txtHEmpID.Tag) == 0 || DBUtility.ClsPub.isLong(txtHEmpID2.Tag) == 0)

                {

                    MessageBox.Show("职员1或者职员2没有选择！");

                    cmdHSaveBill.Enabled = true;

                    return false;

                }

                if (DBUtility.ClsPub.isLong(txtHGroupID.Tag) == 0 )

                if (DBUtility.ClsPub.isLong(txtHGroupID.Tag) == 0)

                {

                    MessageBox.Show("班组没有选择！");

                    cmdHSaveBill.Enabled = true;

                    return false;

                }

                




                //根据源单 ç”Ÿæˆæ¡å½¢ç  å¹¶ä¿å­˜å¦‚数据库

                HNumber = DBUtility.ClsPub.isStrNull(txtHMaterName.Tag);

@@ -552,12 +552,10 @@
                else if (sType == "Sample")

                {

                    sTMNumber = HNumber + ";" + DBUtility.ClsPub.isStrNull(txtHBatchNo.Text) + "B";

                    txtHCheckerResult.Text = "";

                }

                else

                {

                    sTMNumber = HNumber + ";" + DBUtility.ClsPub.isStrNull(txtHBatchNo.Text);

                    txtHCheckerResult.Text = "";

                }

                //sTMNumber = HNumber + ";" + DBUtility.ClsPub.isStrNull(txtHBatchNo.Text);



@@ -682,11 +680,11 @@
                            + ",'" + HPressModel + "','" + HCusModel + "','" + HMaterialModel + "','" + HColor + "','" + sDate + "'"

                            + ",'" + HLogo + "','" + HPackageSize + "'," + HMaterialJQty.ToString() + "," + HMaterialMQty.ToString() + ",'" + HCustomBatchNo + "'"

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

                            + ",'" + POOrderBillNo + "'" + "," + DBUtility.ClsPub.isLong(txtHSourceID.Tag) 
                            + ",'" + HMaterName + "','" + HMaterModel + "','" + HPinfan + "'," + HAuxPropID.ToString() + ",'" + HMTONo + "','" + txtHReasonList.Text + "','"+ HRemark + "')";

                            + ",'" + POOrderBillNo + "'" + "," + DBUtility.ClsPub.isLong(txtHSourceID.Tag)

                            + ",'" + HMaterName + "','" + HMaterModel + "','" + HPinfan + "'," + HAuxPropID.ToString() + ",'" + HMTONo + "','" + txtHReasonList.Text + "','" + HRemark + "')";

                oWeb.getRunProc(sSQLMul, ref DBUtility.ClsPub.sExeReturnInfo);



                


                //刷新界面

                DisplayMain();

                //DisplaySub();  

@@ -700,7 +698,7 @@
                {

                    Report.Print(false);

                }

                


                Thread.Sleep(500);



                if (HSourceBillType != "生产汇报单")

@@ -733,7 +731,7 @@
        private void Sub_SetReport(string sOpenTmp)

        {

            //判断行数

 


            Report = new GridppReport();

            Report.LoadFromFile(DBUtility.ClsPub.AppPath + @"\" + sOpenTmp + ".grf");  //here .

            Report.BeforePostRecord += new _IGridppReportEvents_BeforePostRecordEventHandler(ReportBeforePostRecord);

@@ -774,7 +772,6 @@
                Report.FieldByName("组员").AsString = ClsPub.isStrNull(txtHEmpID.Text) + ";" + ClsPub.isStrNull(txtHEmpID2.Text) + ";" + ClsPub.isStrNull(txtHEmpID3.Text);

                Report.FieldByName("数量").AsString = ClsPub.isStrNull(txtHSJQty.Text);

                Report.FieldByName("旧物料编码").AsString = ClsPub.isStrNull(txtHOldMaterNumber.Text);

                Report.FieldByName("不良原因").AsString = ClsPub.isStrNull(txtHCheckerResult.Text);

                //Report.FieldByName("源单单号").AsString = ClsPub.isStrNull(grdSub.Rows[CurRows].Cells[HSourceBillNoCol].Value);

                //Report.FieldByName("销售订单号").AsString = ClsPub.isStrNull(grdSub.Rows[CurRows].Cells[HSeOrderBillNo2Col].Value);

                //Report.FieldByName("生产车间").AsString = ClsPub.isStrNull(grdSub.Rows[CurRows].Cells[HDeptName2Col].Value);

@@ -839,7 +836,7 @@
        {

            if (!ComDevice.IsOpen)

            {

                


                try

                {

                    ComDevice.PortName = txtPortName.Text;

@@ -864,7 +861,7 @@
                        default:

                            break;

                    }

                  


                    ComDevice.DataBits = int.Parse(txtDataBits.Text);

                    switch (cmbStopBits.SelectedItem.ToString())

                    {

@@ -883,14 +880,14 @@
                        default:

                            break;

                    }

                    
                    ComDevice.Open(); 


                    ComDevice.Open();

                    lblComStatus.Text = "串口状态：开启";

                    timer3.Enabled = true;

                }

                catch (Exception ex)

                {

                    MessageBox.Show("打开串口失败！" + ex.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); 
                    MessageBox.Show("打开串口失败！" + ex.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);

                    return;

                }

            }

@@ -931,19 +928,19 @@
        {

            if (!ComDevice.IsOpen)

            {

                 


            }

            else

            {

                try

                {

                    ComDevice.Close(); 
                    ComDevice.Close();

                    lblComStatus.Text = "串口状态：关闭";

                    timer3.Enabled = false;

                }

                catch (Exception ex)

                {

                    MessageBox.Show(ex.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); 
                    MessageBox.Show(ex.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);

                    return;

                }

            }

@@ -952,7 +949,7 @@
        //设备清零

        private void cmdHSetZero_Click(object sender, EventArgs e)

        {

            cmdHSetZero.Enabled=false;

            cmdHSetZero.Enabled = false;

            byte[] sendData = strToHexByte(txtHSend0.Text);

            SendData(sendData);

            txtHSJQty.Text = "0";

@@ -980,13 +977,13 @@
        }





         /// <summary>

        /// <summary>

        /// å‘送数据

        /// </summary>

        /// <param name="sender"></param>

        /// <param name="data"></param>

        public bool SendData(byte[] data)

        { 
        {

            if (ComDevice.IsOpen)

            {

                try

@@ -996,7 +993,7 @@
                }

                catch (Exception ex)

                {

                    MessageBox.Show(ex.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); 
                    MessageBox.Show(ex.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);

                }

                finally

                {

@@ -1005,7 +1002,7 @@
            }

            else

            {

                MessageBox.Show("串口未打开", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); 
                MessageBox.Show("串口未打开", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);

            }

            return false;

        }

@@ -1066,7 +1063,7 @@
        //            {

        //                newStr = strArr[4];

        //            }

                  


        //        }

        //        if (string.IsNullOrEmpty(newStr))

        //        {

@@ -1137,7 +1134,7 @@
                if (strArr[4] != "00")

                {

                    char[] bw = strArr[4].ToCharArray();

                    if(bw[0]=='0')

                    if (bw[0] == '0')

                    {

                        newStr = bw[1].ToString();

                    }

@@ -1145,7 +1142,7 @@
                    {

                        newStr = strArr[4];

                    }

                    


                }

                if (string.IsNullOrEmpty(newStr))

                {

@@ -1163,12 +1160,12 @@
                {

                    newStr += strArr[5];

                }

                if (strArr[6] != "00"&&newStr=="00")

                if (strArr[6] != "00" && newStr == "00")

                {

                    //newStr = $"0.{strArr[6]}";

                    newStr = "0." + strArr[6];

                }

                if(strArr[6]!="00"&&newStr!="00")

                if (strArr[6] != "00" && newStr != "00")

                {

                    //newStr += $".{strArr[6]}";

                    newStr = newStr + "." + strArr[6];

@@ -1181,7 +1178,7 @@




            //将当前数   åŽ˜ç±³ è½¬åŒ–为 ç±³

            double NewQty = DBUtility.ClsPub.isDoule(newStr) ;

            double NewQty = DBUtility.ClsPub.isDoule(newStr);

            if (NewQty <= 0)

            {

                newStr = "0";

@@ -1199,12 +1196,12 @@
                lblHRelQty.Text = txtHSJQty.Text;

            }

            else

            { 
            {

                txtHSJQty.Text = DBUtility.ClsPub.isDoule(DBUtility.ClsPub.isDoule(txtHDQQty.Text), 1); //实际米数= å½“前米数-开始米数

                lblHRelQty.Text = txtHSJQty.Text; 
                lblHRelQty.Text = txtHSJQty.Text;

            }

        }

        


        //删除选中的行数

        private void btnFQSH_Click(object sender, EventArgs e)

        {

@@ -1233,10 +1230,10 @@
                    if (lngBillKey == 0)

                        return;

                    try

                    { 
                    {

                        oWeb.getRunProc("Delete from Gy_BarCodeBill where HItemID=" + lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo);

                        oWeb.getRunProc("insert into System_log values(GETDATE(),'" + DBUtility.ClsPub.CurUserName + "','" + DBUtility.ClsPub.CurUserName + "','删除条码：" + DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[i].Cells[Fun_GetCol("条形码")].Value) + "' ,'WMS系统','','删除')", ref DBUtility.ClsPub.sExeReturnInfo);

       


                    }

                    catch (Exception e)

                    {

@@ -1257,7 +1254,7 @@
        }



        private void cmdHSaveInfo_Click(object sender, EventArgs e)

        { 
        {

            ClsIni.WriteIni("COMINFO", "txtPortName", DBUtility.ClsPub.isStrNull(txtPortName.Text), DBUtility.ClsPub.AppPath + @"/HXERP.ini");

            ClsIni.WriteIni("COMINFO", "txtBaudRate", DBUtility.ClsPub.isStrNull(txtBaudRate.Text), DBUtility.ClsPub.AppPath + @"/HXERP.ini");

            ClsIni.WriteIni("COMINFO", "cmbParity", DBUtility.ClsPub.isStrNull(cmbParity.Text), DBUtility.ClsPub.AppPath + @"/HXERP.ini");

@@ -1266,7 +1263,7 @@
            ClsIni.WriteIni("COMINFO", "txtHSend0", DBUtility.ClsPub.isStrNull(txtHSend0.Text), DBUtility.ClsPub.AppPath + @"/HXERP.ini");

            ClsIni.WriteIni("COMINFO", "txtHSend", DBUtility.ClsPub.isStrNull(txtHSend.Text), DBUtility.ClsPub.AppPath + @"/HXERP.ini");

            ClsIni.WriteIni("COMINFO", "txtHSourceID", DBUtility.ClsPub.isStrNull(txtHSourceID.Text), DBUtility.ClsPub.AppPath + @"/HXERP.ini");

            ClsIni.WriteIni("COMINFO", "txtHSourceIDTag", DBUtility.ClsPub.isStrNull(txtHSourceID.Tag), DBUtility.ClsPub.AppPath + @"/HXERP.ini"); 
            ClsIni.WriteIni("COMINFO", "txtHSourceIDTag", DBUtility.ClsPub.isStrNull(txtHSourceID.Tag), DBUtility.ClsPub.AppPath + @"/HXERP.ini");

        }



        private void btnBLHB_Click(object sender, EventArgs e)

@@ -1277,8 +1274,6 @@
            {

                txtHReasonList.Text = "";

                txtHReasonList.Text = oGy_BadReasonList.txtHBadReason.Text;

                txtHCheckerResult.Text = "";

                txtHCheckerResult.Text = oGy_BadReasonList.txtHBadReason.Text;

                if (SaveBadReasonBill())

                {

                    MessageBox.Show("保存不良原因成功！");

@@ -1381,7 +1376,7 @@
                txtHReasonList.Text = "";

                return false;

            }

            catch(Exception e1)

            catch (Exception e1)

            {

                MessageBox.Show(e1.Message);

                return false;

@@ -1411,8 +1406,6 @@
            {

                txtHReasonList.Text = "";

                txtHReasonList.Text = oGy_BadReasonList.txtHBadReason.Text;

                txtHCheckerResult.Text = "";

                txtHCheckerResult.Text = oGy_BadReasonList.txtHBadReason.Text;

                oGy_BadReasonList = null;

                if (SaveBill("SaveDown"))

                {

@@ -1428,12 +1421,12 @@
                    MessageBox.Show("保存不良原因失败！" + DBUtility.ClsPub.sExeReturnInfo);

                }

            }

            


        }



        private void cmdHGroupID_Click(object sender, EventArgs e)

        {

            SCM.ClsIF_Group_View oGroup= new SCM.ClsIF_Group_View();

            SCM.ClsIF_Group_View oGroup = new SCM.ClsIF_Group_View();

            string sWhere = "";

            if (oGroup.RefreshView(sWhere))

            {