雅琪诺MES智能条码管理系统
zgq
2021-01-20 c9d3e78b9afb5693df5026fcec064767eb1ed801
Merge branch 'master' of http://101.37.171.70:10101/r/YqnMes
5个文件已修改
607 ■■■■■ 已修改文件
SCM/单据资料/Sc_ICMOReportToBarCode.cs 553 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
SCM/单据资料/Sc_ICMOReportToBarCode.designer.cs 29 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
SCM/单据资料/Sc_ICMOReportToBarCode.resx 16 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
SCM/条码打印/Gy_BarCodeBill.cs 5 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
SCM/生产管理/Gy_BadReasonList.resx 4 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
SCM/µ¥¾Ý×ÊÁÏ/Sc_ICMOReportToBarCode.cs
@@ -1,3 +1,4 @@
<<<<<<< HEAD
using System;
using System.Collections.Generic;
using System.ComponentModel;
@@ -539,6 +540,549 @@
                sPeriod = "0" + ClsPub.isDate(sDate).Month.ToString();
                sPeriod = sPeriod.Substring(sPeriod.Length - 2, 2);
                sDay = "0" + ClsPub.isDate(sDate).Day.ToString();
=======
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using gregn6Lib;
using Pub_Class;
using System.Threading;
using System.IO.Ports;
namespace SCM
{
    public partial class Sc_ICMOReportToBarCode : Form
    {
        public Sc_ICMOReportToBarCode()
        {
            InitializeComponent();
        }
        public frmBillQueryCondition_Base frmCondition;
        public string ModCaption = "成品分切在线检验";
        public string ModName = "Sc_ICMOReportToBarCode";
        public string HSourceBillTypeID = "";   //单据类型
        public string HSourceBillType = "";     //单据类型名称
        public string HSourceBillNo = "";
        public Int64 HSourceInterID = 0;
        public Int64 HSourceEntryID = 0;
        public int HTMCol = 0;
        public int HMaterIDCol = 1;
        Pub_Class.ClsGridListSum oSumGrid = new Pub_Class.ClsGridListSum();
        public Int32 iTopRow = 0;//画横线
        SCM.WMSWeb.WebService1 oWeb = new SCM.WMSWeb.WebService1();
        //
        #region  å›ºå®šä»£ç 
        //清空界面
        public void Sub_ClearBill()
        {
            //清空界面控件 for æŽ§ä»¶
            foreach (Control ct in gbUp.Controls)
            {
                switch (ct.GetType().Name)
                {
                    case "ComboBox":
                        ((ComboBox)ct).SelectedIndex = 0;
                        break;
                    case "TextBox":
                        ((TextBox)ct).Text = "";
                        break;
                    case "DateTimePicker":
                        ((DateTimePicker)ct).Value = DateTime.Today;
                        break;
                    default:
                        break;
                }
            }
            //
            txtHMaker.Text = ClsPub.CurUserName;
            initGrid();
        }
        private void Sc_ICMOReportToBarCode_Load(object sender, EventArgs e)
        {
            //设置动态URL
            oWeb.Url = SCM.ClsPub1.WEBSURL;
            //
            frmCondition = new frmBillQueryCondition_Base();
            this.Text = ModCaption;
            oSumGrid.ogrdMain = grdSub;  //初始化 new
            oSumGrid.oGridsum = grdSum;
            initGrid();
            //cmbHBillType.SelectedIndex = 0;
            //cmbHSourceBillType.SelectedIndex = 0;
            cmbFQMB.Items.Add(this.Text);
            cmbFQMB.SelectedIndex = 0;
            if(DBUtility.ClsPub.CurUserName.ToLower()=="admin")
            {
                txtHDQQty.ReadOnly = false;
                txtHKSQty.ReadOnly = false;
            }
        }
        //初始化网格
        private void initGrid()
        {
            ClsPub1.initGridList(grdMain, this.Name);
            ClsPub1.initGridList(grdSub, this.Name + "grdSub");
            ClsPub1.initGridFst(grdEmp, this.Name + "grdEmp");
            grdMain.RowTemplate.Height = 30;
            grdMain.RowTemplate.MinimumHeight = 30;
            grdMain.RowsDefaultCellStyle.Font = new Font("宋体", 15);
            grdMain.ReadOnly = true;
            grdSub.RowTemplate.Height = 30;
            grdSub.RowTemplate.MinimumHeight = 30;
            grdSub.RowsDefaultCellStyle.Font = new Font("宋体", 15);
            grdSub.ReadOnly = true;
            grdEmp.RowTemplate.Height = 30;
            grdEmp.RowTemplate.MinimumHeight = 30;
            grdEmp.RowsDefaultCellStyle.Font = new Font("宋体", 15);
            grdEmp.ReadOnly = false;
            //DBUtility.Xt_BaseBillFun.initGridList(grdMain, this.Name);
            //DBUtility.Xt_BaseBillFun.initGridList(grdSub, this.Name + "grdSub");
            DBUtility.Xt_BaseBillFun.GetGrid(grdMain, this.Name);
            DBUtility.Xt_BaseBillFun.GetGrid(grdSub, this.Name + "grdSub");
            DBUtility.Xt_BaseBillFun.GetGrid(grdEmp, this.Name + "grdEmp");
        }
        //时间控件
        private void timer1_Tick(object sender, EventArgs e)
        {
            timer1.Enabled=false;
            Sub_ClearBill();
        }
        private void timer2_Tick(object sender, EventArgs e)
        {
            timer2.Enabled = 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");
                cmbParity.Text = ClsIni.ReadIni("COMINFO", "cmbParity", DBUtility.ClsPub.AppPath + @"/HXERP.ini");
                txtDataBits.Text = ClsIni.ReadIni("COMINFO", "txtDataBits", DBUtility.ClsPub.AppPath + @"/HXERP.ini");
                cmbStopBits.Text = ClsIni.ReadIni("COMINFO", "cmbStopBits", DBUtility.ClsPub.AppPath + @"/HXERP.ini");
                txtHSend0.Text = ClsIni.ReadIni("COMINFO", "txtHSend0", DBUtility.ClsPub.AppPath + @"/HXERP.ini");
                txtHSend.Text = ClsIni.ReadIni("COMINFO", "txtHSend", DBUtility.ClsPub.AppPath + @"/HXERP.ini");
                txtHSourceID.Text = ClsIni.ReadIni("COMINFO", "txtHSourceID", DBUtility.ClsPub.AppPath + @"/HXERP.ini");
                txtHSourceID.Tag = ClsIni.ReadIni("COMINFO", "txtHSourceIDTag", DBUtility.ClsPub.AppPath + @"/HXERP.ini");
                this.Text = this.Text + "-" + txtHSourceID.Text;
            }
            //初始化串口
            ComDevice = new SerialPort();
            ComDevice.DataReceived += new SerialDataReceivedEventHandler(Com_DataReceived);//绑定事件
            string[] PortNames = SerialPort.GetPortNames();
            //打开串口
            OpenCom();
        }
        //退出
        private void tc_Click(object sender, EventArgs e)
        {
            this.Close();
        }
        private void grdMain_Paint(object sender, PaintEventArgs e)
        {
            GraphicsGrid();
        }
        private void GraphicsGrid()
        {
            //画底线
            DBUtility.Xt_BaseBillFun.GraphicsGrid(grdMain);
            //画横线
            DBUtility.Xt_BaseBillFun.GraphicsRowGrid(grdMain, iTopRow, iTopRow + 50, Fun_GetCol("hmainid"));
        }
        private Int32 Fun_GetCol(string sCol)
        {
            return DBUtility.Xt_BaseBillFun.Fun_GetCol(sCol, grdMain);
        }
        //保存列宽
        private void bclk_Click(object sender, EventArgs e)
        {
            DBUtility.Xt_BaseBillFun.SaveGrid(grdMain, this.Name);
            DBUtility.Xt_BaseBillFun.SaveGrid(grdSub, this.Name + "grdSub");
            DBUtility.Xt_BaseBillFun.SaveGrid(grdEmp, this.Name + "grdEmp");
        }
        //默认列宽
        private void mrlk_Click(object sender, EventArgs e)
        {
            DBUtility.Xt_BaseBillFun.DefaultGridView(grdMain, this.Name);
            DBUtility.Xt_BaseBillFun.DefaultGridView(grdSub, this.Name + "grdSub");
            DBUtility.Xt_BaseBillFun.DefaultGridView(grdEmp, this.Name + "grdEmp");
        }
        #endregion
        #region è¿”回源单信息
        private void xd_Click(object sender, EventArgs e)
        {
        }
        private void Display(string SourceBillType, Int64 HSourceBillInterID, Int64 HSourceBillEntryID)
        {
            DataSet Ds;
            //生产订单
            if (SourceBillType == "生产订单")
            {
                //得到信息
                Ds = oWeb.getDataSetBySQL("select * from h_v_IFCLD_ICMOList where hmainid=" + HSourceBillInterID + " and hsubid=" + HSourceBillEntryID, "h_v_IFCLD_ICMOList", ref DBUtility.ClsPub.sExeReturnInfo);
                //写入信息
                Sub_WriteInForm(Ds.Tables[0], 0);
            }
            //收料通知单
            if (SourceBillType == "收料通知单")
            {
                //得到信息
                Ds = oWeb.getDataSetBySQL("select * from h_v_IF_POInStockList where hmainid=" + HSourceBillInterID + " and hsubid=" + HSourceBillEntryID, "h_v_IF_POInStockList", ref DBUtility.ClsPub.sExeReturnInfo);
                //写入信息
                Sub_WriteInForm(Ds.Tables[0], 0);
            }
            //生产汇报单
            if (SourceBillType == "生产汇报单")
            {
                //得到信息
                Ds = oWeb.getDataSetBySQL("select * from h_v_IF_ICMOReportBillList where hmainid=" + HSourceBillInterID + " and hsubid=" + HSourceBillEntryID, "h_v_IF_POInStockList", ref DBUtility.ClsPub.sExeReturnInfo);
                //写入信息
                Sub_WriteInForm(Ds.Tables[0], 0);
            }
        }
        //根据TABLE写入界面
        private void Sub_WriteInForm(DataTable oTable, int i)
        {
            try
            {
                txtHSourceBillNo.Text = oTable.Rows[0]["单据号"].ToString();
                txtHMaterNumber.Text = oTable.Rows[0]["物料代码"].ToString();
                txtHOldMaterNumber.Text = oTable.Rows[0]["旧物料编码"].ToString();
                txtHMaterNumber.Tag = oTable.Rows[0]["HMaterID"].ToString();
                txtHMaterName.Text = oTable.Rows[0]["物料名称"].ToString();
                txtHMaterName.Tag = oTable.Rows[0]["HMaterID"].ToString();
                txtHMaterModel.Text = oTable.Rows[0]["规格型号"].ToString();
                txtHUnitName.Text = oTable.Rows[0]["计量单位"].ToString();
                txtHUnitName.Tag = oTable.Rows[0]["HUnitID"].ToString();
                txtHBatchNo.Text = oTable.Rows[0]["批次"].ToString();
                txtHSumQty.Text = oTable.Rows[0]["数量"].ToString();
                txtHRelationQty.Text = oTable.Rows[0]["已生成条码数量"].ToString();
                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)
                {
                    txtHSJQty.Text = DBUtility.ClsPub.isDoule(DBUtility.ClsPub.isDoule(txtHDQQty.Text) - DBUtility.ClsPub.isDoule(txtHKSQty.Text), 1);
                }
                else
                {
                    txtHSJQty.Text = "0";
                }
                DisplayMain();
                //DisplaySub();
            }
            catch(Exception e)
            {
                MessageBox.Show("读取失败!" + e.Message);
            }
        }
        private void DisplayMain()
        {
            DataSet DSet;
            string sSql = "";
            string sWhere = "";
            //过滤条件
            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);
            //生成首行标题
            if (DSet == null)
            {
                MessageBox.Show("没有返回任何结果,尝试再次查询!" + DBUtility.ClsPub.sExeReturnInfo);
                return;
            }
            //
            if (DSet.Tables[0].Rows.Count>0)
            {
                grdMain.DataSource = DSet.Tables[0].DefaultView;
            }
            //冻结
            int FrCol = DBUtility.ClsPub.isInt(0);
            string s = "是";
            ClsPub1.DisplayGrid(grdMain, this.Name, s, FrCol);
            //画线
            //Total();
            ///////////////////////////////////////////
            if (DSet.Tables[1].Rows.Count > 0)
            {
                grdSub.DataSource = DSet.Tables[1].DefaultView;
            }
            //冻结
            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)
            {
                txtHSYQty.Text = DBUtility.ClsPub.isDoule(DBUtility.ClsPub.isDoule(txtHSumQty.Text) - DBUtility.ClsPub.isDoule(txtHRelationQty.Text), 1);
            }
            else
            {
                txtHSYQty.Text = "0";
            }
            //////////////////////////
        }
        private void DisplaySub()
        {
            DataSet DSet;
            string sSql = "";
            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);
            //生成首行标题
            if (DSet == null)
            {
                MessageBox.Show("没有返回任何结果,尝试再次查询!" + DBUtility.ClsPub.sExeReturnInfo);
                return;
            }
            //
            grdSub.DataSource = DSet.Tables[0].DefaultView;
            //冻结
            int FrCol = DBUtility.ClsPub.isInt(0);
            string s = "是";
            ClsPub1.DisplayGrid(grdSub, this.Name + "grdSub", s, FrCol);
            //画线
            //Total();
        }
        #endregion
        #region  //打印设置
        GridppReport Report;
        string sBarCode = "";
        //预览
        int CurRows = 0;
        #endregion
        #region ç•Œé¢æŽ§ä»¶å¤„理
        private void cmdHDeptID_Click(object sender, EventArgs e)
        {
            SCM.ClsIF_Department_View oDept = new SCM.ClsIF_Department_View();
            string sWhere = "";
            if (oDept.RefreshView(sWhere))
            {
                this.txtHDeptID.Text = oDept.oModel.HName;
                this.txtHDeptID.Tag = oDept.oModel.HItemID.ToString();
            }
            else
            {
                this.txtHDeptID.Text = "";
            }
        }
        private void txtHDeptID_TextChanged(object sender, EventArgs e)
        {
            BLL.ClsPub_BLL.Sub_ClearText(txtHDeptID);
        }
        #endregion
        //选择源单
        private void cmdHSourceBillNo_Click(object sender, EventArgs e)
        {
            Gy_SourceBillList_Touch oGy_SourceBillList_Touch = new Gy_SourceBillList_Touch();
            oGy_SourceBillList_Touch.HSourceBillType = HSourceBillType;//类型名称
            oGy_SourceBillList_Touch.ShowDialog();
            if (oGy_SourceBillList_Touch.OKTag == 1)
            {
                //根据选中的源单内码和子内码,返回相应信息
                HSourceEntryID = oGy_SourceBillList_Touch.HSelEntryID;
                HSourceInterID = oGy_SourceBillList_Touch.HSelInterID;
                HSourceBillTypeID = oGy_SourceBillList_Touch.HSourceBillTypeID;
                HSourceBillNo = oGy_SourceBillList_Touch.HSourceBillNo;
                Display(HSourceBillType, oGy_SourceBillList_Touch.HSelInterID, oGy_SourceBillList_Touch.HSelEntryID);
            }
            else
            {
                HSourceEntryID = 0;
                HSourceInterID = 0;
                HSourceBillTypeID = "";
                HSourceBillNo = "";
            }
        }
        //
        private void cmdCancel_Click(object sender, EventArgs e)
        {
            CloseCom();
            this.Close();
        }
        private void label19_Click(object sender, EventArgs e)
        {
        }
        public bool SaveBill(string sType)
        {
            try
            {
                int LSHlen = 2;             //流水号长度
                int SumLen = 10;            //总长度
                string TM = "";             //条码
                string HNumber = "";        //物料代码
                double HSumQty = 0;         //产品数量
                double HMinQty = 0;         //最小包装数
                int HBQty = 0;              //箱数
                double HQty = 0;            //数量
                string WeiShu = "";         //尾数
                int LSH = 0;                //流水号
                string LSH2 = "";           //流水号转换成字符
                string sDate = "";          //日期
                string sYear = "";          //å¹´
                string sPeriod = "";        //月
                string sDay = "";           //日
                string HBatchNo = "";       //批次
                int k = 0;
                int n = 0;                  //同一批生成条码中的第几条
                string sTMNumber = "";      //条码自定义前缀
                DataSet Ds;
                //
                string HWei = "";      //尾数
                HBarCode = "";
                string HBarCodeType = "";
                Int64 HMaterID = 0;
                Int64 HAuxPropID = 0;
                Int64 HUnitID = 0;
                double HQty2 = 0;
                string HBatchNo2 = "";
                Int64 HSupID = 0;
                Int64 HGroupID = 0;
                int HPrintQty = 0;
                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 = "";
                DateTime HBeginDate;
                string HSeOrderBillNo = "";
                string HJiaYe2 = "";
                string HPressModel = "";
                string HCusModel = "";
                string HMaterialModel = "";
                string HColor = "";
                string HLogo = "";
                string HPackageSize = "";
                double HMaterialJQty = 0;
                double HMaterialMQty = 0;
                string HCustomBatchNo = "";
                string HGBBarCode = "";
                string POOrderBillNo = "";
                //
                cmdHSaveBill.Enabled = false;
                //判断是否存在 æºå•信息;
                if (HSourceInterID <= 0 || HSourceEntryID <= 0 || DBUtility.ClsPub.isLong(txtHMaterName.Tag) <= 0 || DBUtility.ClsPub.isLong(txtHUnitName.Tag) <= 0)//判断是否有源单
                {
                    MessageBox.Show("没有选单!");
                    cmdHSaveBill.Enabled = true;
                    return false;
                }
                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); //实际米数= å½“前米数-开始米数
                    lblHRelQty.Text = txtHSJQty.Text;
                }
                else
                {
                    if (MessageBox.Show("当前米数小于开始米数,是否确定要清零开始米数", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
                    {
                        txtHKSQty.Text = "0";
                        txtHSJQty.Text = DBUtility.ClsPub.isDoule(DBUtility.ClsPub.isDoule(txtHDQQty.Text), 1); //实际米数= å½“前米数-开始米数
                        lblHRelQty.Text = txtHSJQty.Text;
                    }
                }
                if (DBUtility.ClsPub.isDoule(txtHSJQty.Text) <= 0)
                {
                    MessageBox.Show("当前数量不能小于等于0!");
                    cmdHSaveBill.Enabled = true;
                    return false;
                }
                //if (DBUtility.ClsPub.isDoule(txtHSYQty.Text) <= 0)
                //{
                //    MessageBox.Show("剩余数量已经为0,不能在裁切!");
                //    cmdHSaveBill.Enabled = true;
                //    return false;
                //}
                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 )
                {
                    MessageBox.Show("班组没有选择!");
                    cmdHSaveBill.Enabled = true;
                    return false;
                }
                //根据源单 ç”Ÿæˆæ¡å½¢ç  å¹¶ä¿å­˜å¦‚数据库
                HNumber = DBUtility.ClsPub.isStrNull(txtHMaterName.Tag);
                HBatchNo = DBUtility.ClsPub.isStrNull(txtHBatchNo.Text);
                sDate = dtpHDate.Value.ToShortDateString();
                sYear = ClsPub.isDate(sDate).Year.ToString().Substring(2, 2);
                sPeriod = "0" + ClsPub.isDate(sDate).Month.ToString();
                sPeriod = sPeriod.Substring(sPeriod.Length - 2, 2);
                sDay = "0" + ClsPub.isDate(sDate).Day.ToString();
>>>>>>> parent of d95a654 (nothing)
                sDay = sDay.Substring(sDay.Length - 2, 2);
                //条码前缀 = ç»„织代码 + ç‰©æ–™å†…码 + å¹´ + æœˆ + æ—¥
@@ -552,12 +1096,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);
@@ -683,7 +1225,7 @@
                            + ",'" + 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 + "')";
                            + ",'" + HMaterName + "','" + HMaterModel + "','" + HPinfan + "'," + HAuxPropID.ToString() + ",'" + HMTONo + "','"+ txtHReasonList.Text + "','"+ HRemark + "')";
                oWeb.getRunProc(sSQLMul, ref DBUtility.ClsPub.sExeReturnInfo);
                
@@ -774,7 +1316,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);
@@ -1277,8 +1818,6 @@
            {
                txtHReasonList.Text = "";
                txtHReasonList.Text = oGy_BadReasonList.txtHBadReason.Text;
                txtHCheckerResult.Text = "";
                txtHCheckerResult.Text = oGy_BadReasonList.txtHBadReason.Text;
                if (SaveBadReasonBill())
                {
                    MessageBox.Show("保存不良原因成功!");
@@ -1411,8 +1950,6 @@
            {
                txtHReasonList.Text = "";
                txtHReasonList.Text = oGy_BadReasonList.txtHBadReason.Text;
                txtHCheckerResult.Text = "";
                txtHCheckerResult.Text = oGy_BadReasonList.txtHBadReason.Text;
                oGy_BadReasonList = null;
                if (SaveBill("SaveDown"))
                {
SCM/µ¥¾Ý×ÊÁÏ/Sc_ICMOReportToBarCode.designer.cs
@@ -155,8 +155,6 @@
            this.label12 = new System.Windows.Forms.Label();
            this.button4 = new System.Windows.Forms.Button();
            this.timer3 = new System.Windows.Forms.Timer(this.components);
            this.txtHCheckerResult = new System.Windows.Forms.TextBox();
            this.label33 = new System.Windows.Forms.Label();
            this.Tool.SuspendLayout();
            ((System.ComponentModel.ISupportInitialize)(this.grdPrint)).BeginInit();
            ((System.ComponentModel.ISupportInitialize)(this.grdSum)).BeginInit();
@@ -168,7 +166,6 @@
            ((System.ComponentModel.ISupportInitialize)(this.grdEmp)).BeginInit();
            this.groupBox4.SuspendLayout();
            this.panel1.SuspendLayout();
            ((System.ComponentModel.ISupportInitialize)(this.splitContainer1)).BeginInit();
            this.splitContainer1.Panel1.SuspendLayout();
            this.splitContainer1.Panel2.SuspendLayout();
            this.splitContainer1.SuspendLayout();
@@ -893,8 +890,6 @@
            // tabPage4
            // 
            this.tabPage4.BackColor = System.Drawing.Color.Lavender;
            this.tabPage4.Controls.Add(this.label33);
            this.tabPage4.Controls.Add(this.txtHCheckerResult);
            this.tabPage4.Controls.Add(this.label15);
            this.tabPage4.Controls.Add(this.cmbHOrgID);
            this.tabPage4.Controls.Add(this.label3);
@@ -1667,27 +1662,6 @@
            this.timer3.Interval = 300;
            this.timer3.Tick += new System.EventHandler(this.timer3_Tick);
            // 
            // txtHCheckerResult
            //
            this.txtHCheckerResult.Font = new System.Drawing.Font("宋体", 15F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
            this.txtHCheckerResult.ImeMode = System.Windows.Forms.ImeMode.NoControl;
            this.txtHCheckerResult.Location = new System.Drawing.Point(795, 96);
            this.txtHCheckerResult.Name = "txtHCheckerResult";
            this.txtHCheckerResult.ReadOnly = true;
            this.txtHCheckerResult.Size = new System.Drawing.Size(166, 30);
            this.txtHCheckerResult.TabIndex = 151;
            //
            // label33
            //
            this.label33.AutoSize = true;
            this.label33.Font = new System.Drawing.Font("宋体", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
            this.label33.ForeColor = System.Drawing.Color.Black;
            this.label33.Location = new System.Drawing.Point(714, 102);
            this.label33.Name = "label33";
            this.label33.Size = new System.Drawing.Size(72, 16);
            this.label33.TabIndex = 152;
            this.label33.Text = "不良清单";
            //
            // Sc_ICMOReportToBarCode
            // 
            this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 12F);
@@ -1724,7 +1698,6 @@
            this.panel1.ResumeLayout(false);
            this.splitContainer1.Panel1.ResumeLayout(false);
            this.splitContainer1.Panel2.ResumeLayout(false);
            ((System.ComponentModel.ISupportInitialize)(this.splitContainer1)).EndInit();
            this.splitContainer1.ResumeLayout(false);
            this.tabControl1.ResumeLayout(false);
            this.tabPage1.ResumeLayout(false);
@@ -1869,7 +1842,5 @@
        private System.Windows.Forms.TextBox txtHEmpID3;
        private System.Windows.Forms.Button cmdZero;
        private System.Windows.Forms.Button cmdSaveAndDown2;
        private System.Windows.Forms.Label label33;
        private System.Windows.Forms.TextBox txtHCheckerResult;
    }
}
SCM/µ¥¾Ý×ÊÁÏ/Sc_ICMOReportToBarCode.resx
@@ -112,15 +112,15 @@
    <value>2.0</value>
  </resheader>
  <resheader name="reader">
    <value>System.Resources.ResXResourceReader, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>
    <value>System.Resources.ResXResourceReader, System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>
  </resheader>
  <resheader name="writer">
    <value>System.Resources.ResXResourceWriter, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>
    <value>System.Resources.ResXResourceWriter, System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>
  </resheader>
  <metadata name="Tool.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
  <metadata name="Tool.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
    <value>17, 17</value>
  </metadata>
  <assembly alias="System.Drawing" name="System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
  <assembly alias="System.Drawing" name="System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
  <data name="Tool.BackgroundImage" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64">
    <value>
        /9j/4AAQSkZJRgABAQEASABIAAD/4QSARXhpZgAATU0AKgAAAAgABwESAAMAAAABAAEAAAEaAAUAAAAB
@@ -387,10 +387,10 @@
        AAAASUVORK5CYII=
</value>
  </data>
  <metadata name="timer1.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
  <metadata name="timer1.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
    <value>102, 16</value>
  </metadata>
  <metadata name="timer2.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
  <metadata name="timer2.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
    <value>191, 16</value>
  </metadata>
  <data name="cmdHEmp3.Image" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64">
@@ -718,10 +718,10 @@
        FIYcEAA7
</value>
  </data>
  <metadata name="timer3.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
  <metadata name="timer3.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
    <value>292, 16</value>
  </metadata>
  <metadata name="$this.TrayHeight" type="System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
  <metadata name="$this.TrayHeight" type="System.Int32, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
    <value>39</value>
  </metadata>
</root>
SCM/ÌõÂë´òÓ¡/Gy_BarCodeBill.cs
@@ -92,7 +92,6 @@
        public const Int16 HJiaYeLXCol = 71;
        public const Int16 HJiaYeLCol = 72;
        public const Int16 POOrderBillNoCol = 73;
        public const Int16 HMaker = 74;
        public Int16 HSelectCol = 0;
        public Int16 HSno2Col = 1;
@@ -1538,7 +1537,7 @@
        {
            grdMain.RowCount = 0;
            grdSub.RowCount = 0;
            grdMain.ColumnCount = 75;                       //总列数
            grdMain.ColumnCount = 74;                       //总列数
            ClsPub1.initGridFst(grdMain, this.Name);
            grdMain.Columns[HSnoCol].HeaderText = "序号";
            grdMain.Columns[HMainIDCol].HeaderText = "源单主ID";
@@ -1606,7 +1605,6 @@
            grdMain.Columns[HJiaYeLXCol].HeaderText = "制冷液类型";
            grdMain.Columns[HJiaYeLCol].HeaderText = "加液量";
            grdMain.Columns[POOrderBillNoCol].HeaderText = "采购订单号";
            grdMain.Columns[HMaker].HeaderText = "制单人";
            ////
            //格式化    éšè—åˆ—
            grdMain.Columns[HTagCol].Visible = false;
@@ -2617,7 +2615,6 @@
            grdMain.Rows[i].Cells[HRemarkCol].Value = oTable.Rows[0]["备注"].ToString();
            grdMain.Rows[i].Cells[HMTONoCol].Value = oTable.Rows[0]["计划跟踪号"].ToString();
            grdMain.Rows[i].Cells[HMinQtyCol].Value = oTable.Rows[0]["最小包装数"].ToString();
            grdMain.Rows[i].Cells[HMaker].Value = ClsPub.CurUserName;
            if (CampanyName == "圣龙") //系统参数  å®¢æˆ·å®šåˆ¶åŒ–名称
            {
SCM/Éú²ú¹ÜÀí/Gy_BadReasonList.resx
@@ -112,9 +112,9 @@
    <value>2.0</value>
  </resheader>
  <resheader name="reader">
    <value>System.Resources.ResXResourceReader, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>
    <value>System.Resources.ResXResourceReader, System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>
  </resheader>
  <resheader name="writer">
    <value>System.Resources.ResXResourceWriter, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>
    <value>System.Resources.ResXResourceWriter, System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>
  </resheader>
</root>