XinYu_LZMES_Client/Core.LZMes.Client.QCM/QCM02/QCM0201ZHB.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using CoreFS.CA06;
using System.Collections;
using Infragistics.Win.UltraWinGrid;
using Infragistics.Win;
using System.Drawing.Printing;
using System.IO;
using System.Drawing.Imaging;
using System.Drawing.Drawing2D;
using ThoughtWorks.QRCode.Codec;

namespace Core.LZMes.Client.QCM
{
    public partial class QCM0201ZHB : FrmBase
    {

        #region 初始化

        //Boolean textboxHasText = false;//判断输入框是否有文本
        private String v_line_no = "";//RZ1-热轧  ZB1-中板线   HB1-厚板线  LT1-连退
        Image image2;//二维码
        private String v_BATCH_NO = "";//轧批号
        private String PRINT_SEQV = "";//打印序号
        private int lennum = 0;//长度

        public QCM0201ZHB()
        {
            InitializeComponent();
        }

        private void QCM0201ZHB_Load(object sender, EventArgs e)
        {
            //获取自定义参数
            if (!this.CustomInfo.Equals(""))
            {
                v_line_no = this.CustomInfo;
            }


            this.ultraGrid1.DisplayLayout.Bands[0].Columns["PHY_NAME_L_bj"].Header.Caption = "检验项目";
            this.ultraGrid4.DisplayLayout.Bands[0].Columns["PHY_NAME_L_bj"].Header.Caption = "检验项目";

           // dateTimePicker1.Value = DateTime.Now.Date.AddDays(-1);
            dateTimePicker2.Value = DateTime.Now.Date.AddDays(1);


            ValueList v = new ValueList();
            v.ValueListItems.Add("1", "是");
            v.ValueListItems.Add("0", "否");
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["ISJUDGE"].ValueList = v.Clone();

            ValueList v1 = new ValueList();
            v1.ValueListItems.Add("0", "订单");
            v1.ValueListItems.Add("1", "人工");
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["ITEM_FLAG"].ValueList = v1.Clone();
            this.ultraGrid6.DisplayLayout.Bands[0].Columns["ITEM_FLAG"].ValueList = v1.Clone();

            v1 = new ValueList();
            v1.ValueListItems.Add("0", "订单");
            v1.ValueListItems.Add("1", "人工复制");
            this.ultraGrid1.DisplayLayout.Bands[0].Columns["ITEM_FLAG"].ValueList = v1.Clone();
            this.ultraGrid4.DisplayLayout.Bands[0].Columns["ITEM_FLAG"].ValueList = v1.Clone();

            ValueList v2 = new ValueList();
            v2.ValueListItems.Add("A", "成分");
            v2.ValueListItems.Add("B", "材质");
            this.ultraGrid1.DisplayLayout.Bands[0].Columns["smp_catg"].ValueList = v2.Clone();
            this.ultraGrid4.DisplayLayout.Bands[0].Columns["smp_catg"].ValueList = v2.Clone();
            this.ultraGrid8.DisplayLayout.Bands[0].Columns["SMP_CATG"].ValueList = v2.Clone();

            ValueList v3 = new ValueList();
            v3.ValueListItems.Add("0", "未发送");
            v3.ValueListItems.Add("1", "已引用");
            v3.ValueListItems.Add("2", "已接收");
            v3.ValueListItems.Add("3", "已完成");
            v3.ValueListItems.Add("7", "确认接收样");
            this.ultraGrid8.DisplayLayout.Bands[0].Columns["STATUS"].ValueList = v3.Clone();

            ValueList v4 = new ValueList();
            v4.ValueListItems.Add("ZB1", "中板线");
            v4.ValueListItems.Add("HB1", "厚板线");
            this.ultraGrid4.DisplayLayout.Bands[0].Columns["PLINE_CODE_LIMS"].ValueList = v4.Clone();

            if ("ZB".Equals(v_line_no))
            {
                this.button3.Enabled = false;
                this.button4.Enabled = false;
                this.ultraGrid1.DisplayLayout.Bands[0].Columns["RZ_MIXROLL"].Hidden = true;
                this.ultraGrid1.DisplayLayout.Bands[0].Columns["RZ_OLD_SAMPL_NO"].Hidden = true;
                this.ultraGrid1.DisplayLayout.Bands[0].Columns["CHEM_INTERNALCONTROL"].Hidden = true;
                this.ultraGrid1.DisplayLayout.Bands[0].Columns["CRAFT_EXECUTE"].Hidden = true;
                this.ultraGrid1.DisplayLayout.Bands[0].Columns["FUNCTION_FUHE"].Hidden = true;
                this.ultraGrid1.DisplayLayout.Bands[0].Columns["SHOULD_SAMPLE"].Hidden = true;
                this.ultraGrid1.DisplayLayout.Bands[0].Columns["STOVE_TIME"].Hidden = true;

                this.ultraGrid4.DisplayLayout.Bands[0].Columns["RZ_MIXROLL"].Hidden = true;
                this.ultraGrid4.DisplayLayout.Bands[0].Columns["RZ_OLD_SAMPL_NO"].Hidden = true;
                this.ultraGrid4.DisplayLayout.Bands[0].Columns["CHEM_INTERNALCONTROL"].Hidden = true;
                this.ultraGrid4.DisplayLayout.Bands[0].Columns["CRAFT_EXECUTE"].Hidden = true;
                this.ultraGrid4.DisplayLayout.Bands[0].Columns["FUNCTION_FUHE"].Hidden = true;
                this.ultraGrid4.DisplayLayout.Bands[0].Columns["SHOULD_SAMPLE"].Hidden = true;
                this.ultraGrid4.DisplayLayout.Bands[0].Columns["STOVE_TIME"].Hidden = true;

                this.ultraGrid7.DisplayLayout.Bands[0].Columns["组批区间"].Hidden = true;
                this.ultraGrid7.DisplayLayout.Bands[0].Columns["成分是否符合"].Hidden = true;
                this.ultraGrid7.DisplayLayout.Bands[0].Columns["工艺是否符合"].Hidden = true;
                this.ultraGrid7.DisplayLayout.Bands[0].Columns["预测性能"].Hidden = true;
                this.ultraGrid7.DisplayLayout.Bands[0].Columns["是否预测抽样"].Hidden = true;
                this.ultraGrid7.DisplayLayout.Bands[0].Columns["加热炉出炉时间"].Hidden = true;
            }

        }
        #endregion

        #region 功能
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    this.DoQuery();
                    break;
                case "Send":
                    this.DoSend();
                    break;
                case "Unsend":
                    this.DoUnsend();//撤销委托
                    break;
                case "Unsend19":
                    this.DoUnsend19();//撤销19委托
                    break;
                case "Add":
                    this.AddBasePhy();//新增检验项
                    break;
                case "AddArtificial":
                    this.AddArtificial();//新增人工委托
                    break;
                case "Update":
                    this.DoUpdate();//修改取样材料号
                    break;
                case "AddWt":
                    this.DoAddWt();//新增复制单条委托
                    break;
                case "DelWt":
                    this.DoDelWt();//撤销复制单条委托
                    break;
                case "DoDelete":
                    this.DoDelete();//删除委托
                    break;
                case "UpBatchNo":
                    this.DoUpBatchNo();//复样 修改轧批号 (一炉5个轧批  1 2 3 4 5  取1号轧批委托 夹杂不合格  复  2 3轧批)
                    break;
                case "UpRefBatchNo":
                    this.DoUpRefBatchNo();//初样  修改指定的按炉引用 (一炉5个轧批 1 2 3 4 5 系统默认为 1  但是现场实际取的是3 所以要人工修改)
                    break;
                case "DoQuote":
                    //this.DoQuote();//引用实绩 
                   this.DoQuoteKY();
                    break;
                case "AllUpdate":
                    this.DoAllUpdate();//修改  全部修改的方法
                    break;
                case "InExport":      // 导出
                    ClsControlPack.ExportDataWithSaveDialog2(ref ultraGrid7, this.Text);
                   // ClsControlPack.ExportDataWithSaveDialog2(ref ultraGrid4, this.Text);
                   // this.inExport();
                    break;
                case "DoProcessNo":
                    this.DoProcessNo();//调整热处理号
                    break;
                case "doPrint":
                    this.doPrint();//打印
                    break;
            }
        }

        #region 打印
        private void doPrint()
        {
            RowsCollection rowsCollection = this.ultraGrid1.Rows;
            if (this.ultraTabControl1.Tabs[0].Selected) //检验委托
            {
                rowsCollection = this.ultraGrid1.Rows;
            }
            else if (this.ultraTabControl1.Tabs[1].Selected)
            {
                rowsCollection = this.ultraGrid4.Rows;
            }

            foreach (UltraGridRow ugr in rowsCollection)
            {
                if (ugr.Cells["CHK"].Value.ToString().ToLower() == "true")
                {
                    String specimenNo = ugr.Cells["SPECIMEN_NO"].Value.ToString();//取样编号
                    String materialNo = ugr.Cells["MATERIAL_NO"].Value.ToString();//子板号
                    String batchNO = ugr.Cells["BATCH_NO"].Value.ToString();//轧批号
                    String steelName = ugr.Cells["STEEL_NAME"].Value.ToString();//钢种
                    String thck = ugr.Cells["THICK"].Value.ToString();//规格
                    String phyNameLbj = ugr.Cells["PHY_NAME_L_bj"].Value.ToString();//项目
                    String STATUS = ugr.Cells["STATUS"].Value.ToString();//发送状态
                    String PRINT_SEQ = ugr.Cells["PRINT_SEQ"].Value.ToString();//打印序号
                    if (STATUS.Equals("未发送"))
                    {
                        this.alert("当前委托还未发送!请先发送委托");
                        return;
                    }
                    if (string.IsNullOrEmpty(specimenNo))
                    {
                        this.alert("未找到相应委托数据!请核实!!!");
                        return;
                    }
                    if (string.IsNullOrEmpty(PRINT_SEQ))
                    {
                        PRINT_SEQ = "1";
                    }
                    v_BATCH_NO = materialNo;//轧批号 batchNO  换成子板号240126
                    PRINT_SEQV = PRINT_SEQ;
                    //二维码内容
                    String qrCodeContent = specimenNo;

                    QRCodeEncoder qrCodeEncoder = new QRCodeEncoder();
                    qrCodeEncoder.QRCodeEncodeMode = QRCodeEncoder.ENCODE_MODE.BYTE;//二维码编码格式
                    int num = qrCodeContent.Length;
                    lennum = num;
                    if (num <= 90)
                    {
                        qrCodeEncoder.QRCodeScale = 5;
                        qrCodeEncoder.QRCodeVersion = 2;
                    }
                    else
                    {
                        qrCodeEncoder.QRCodeScale = 6;//二维码大小比例4
                        qrCodeEncoder.QRCodeVersion = 14;//设置二维码的版本，默认7 该值影响二维码最高数据容量 7大致对应40个汉字长度，内容超出择需提升该数值
                    }
                    //设置错误校验级别，默认中等，二维码被遮挡住一部分实际上也是能扫出内容的，这个效验级别的意思就是
                    //当遮挡部分最大占整体多少时仍然可以被扫出来，M大概在20%左右，H为30%，级别越高相应的数据容量会缩小
                    qrCodeEncoder.QRCodeErrorCorrect = QRCodeEncoder.ERROR_CORRECTION.M;
                    System.Drawing.Image image = qrCodeEncoder.Encode(qrCodeContent, Encoding.UTF8);//生成二维码图片  第一个参数打印内容
                    image2 = image;
                    string FilePath = @"C:\二维码";
                    if (!Directory.Exists(FilePath))
                    {
                        Directory.CreateDirectory(FilePath);//判断是否有相应文件夹
                    }

                    PrintDocument printDocument = new PrintDocument();
                    printDocument.PrinterSettings.PrinterName = "Deli DL-888T";//打印机名
                    printDocument.PrintPage += new PrintPageEventHandler(pdt_PrintPage);//设置字体
                    try
                    {
                        if (!printDocument.PrinterSettings.IsValid)
                        {
                            MessageBox.Show("打印设置无效！", "出错", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                            return;
                        }
                        printDocument.Print();
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show("打印过程出现异常！\n" + ex.Message, "出错", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                    }
                    finally
                    {
                        printDocument.Dispose();
                    }

                    //增加打印标识
                    CoreClientParam ccp = new CoreClientParam();
                    ccp.ServerName = "QCM.JHY01.JHY0102.UpdateInfo";
                    ccp.MethodName = "doPrintLog";
                    ccp.ServerParams = new object[] { specimenNo };
                    ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

                    //保存二维码
                    //FilePath = @"C:\二维码\" + batchNO + "二维码.jpg";
                    //System.IO.FileStream fs = new System.IO.FileStream(FilePath, System.IO.FileMode.Create, System.IO.FileAccess.Write, System.IO.FileShare.None);
                    //image.Save(fs, System.Drawing.Imaging.ImageFormat.Jpeg);
                    //fs.Close();
                    image.Dispose();
                }
            }
        }
        void pdt_PrintPage(object sender, PrintPageEventArgs e)
        {
            Graphics grfx = e.Graphics;
            grfx.DrawString(PRINT_SEQV, new Font("宋体", 15), Brushes.Black, 22, 70);//打印内容、字体、颜色、X、Y 
            grfx.DrawString(v_BATCH_NO, new Font("宋体", 14), Brushes.Black, 68, 130);//打印内容、字体、颜色、X、Y 
            grfx.DrawImage(image2, 70, 15, 120, 110);//图片、X、Y、宽、高 

        }
        #endregion

        #endregion

        #region 功能方法

        #region 调整热处理号
        private void DoProcessNo()
        {
            String tabstr = "1";
            RowsCollection rowsCollection = this.ultraGrid1.Rows;
            if (this.ultraTabControl1.Tabs[0].Selected) //检验委托
            {
                rowsCollection = this.ultraGrid1.Rows;
                tabstr = "1";
            }
            else if (this.ultraTabControl1.Tabs[1].Selected)
            {
                rowsCollection = this.ultraGrid4.Rows;
                tabstr = "2";
            }

            foreach (UltraGridRow ugr in rowsCollection)
            {
                if (ugr.Cells["CHK"].Value.ToString().ToLower() == "true")
                {
                    String PROCESS_NOS = ugr.Cells["PROCESS_NOS"].Value.ToString();//热处理号
                    String RCL_STATE = ugr.Cells["RCL_STATE"].Value.ToString();//库存热处理号
                    String SPECIMEN_NO = ugr.Cells["SPECIMEN_NO"].Value.ToString();//取样编号
                    String MATERIAL_NO = ugr.Cells["MATERIAL_NO"].Value.ToString();
                    String BATCH_NO = ugr.Cells["BATCH_NO"].Value.ToString();
                    String SMP_NO = ugr.Cells["SMP_NO"].Value.ToString();
                    String PLINE_CODE = ugr.Cells["PLINE_CODE"].Value.ToString();
                    String userName = this.UserInfo.GetUserName().ToString();

                    if (RCL_STATE.Contains("G"))
                    {
                    if (!PROCESS_NOS.Equals(RCL_STATE))
                    {
                        this.alert(MATERIAL_NO + "实时库存热处理号为:[" + RCL_STATE + "]请调整为正确的送样热处理号!");
                        return;
                    }
                    }

                    Hashtable ht = new Hashtable();
                    ht.Add("PROCESS_NOS", PROCESS_NOS);
                    ht.Add("SPECIMEN_NO", SPECIMEN_NO);
                    ht.Add("MATERIAL_NO", MATERIAL_NO);
                    ht.Add("BATCH_NO", BATCH_NO);
                    ht.Add("SMP_NO", SMP_NO);
                    ht.Add("PLINE_CODE", PLINE_CODE);
                    ht.Add("USER_NAME", userName);
                    CoreClientParam ccp = new CoreClientParam();
                    ccp.ServerName = "QCM.JHY01.JHY0102.UpdateInfo";
                    ccp.MethodName = "doProcessNos";
                    ccp.ServerParams = new object[] { ht };
                    ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                    if (ccp.ReturnCode == -1)
                    {
                        return;
                    }
                }
            }

            MessageBox.Show("调整热处理号成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.None);
            this.DoQuery();
        }
        #endregion

        #region 导出
        private void inExport()
        {
            try
            {
                String checkboxVal = "";
                String STARTTIME = this.dateTimePicker1.Value.ToString("yyyy-MM-dd");
                String ENDTIME = this.dateTimePicker2.Value.ToString("yyyy-MM-dd");
                String BATCH_NO = this.textBox1.Text.Trim();
                String BATCH_NO2 = this.BATCH_NO2.Text.Trim();
                String VALIDFLAG = "1";
                String CERT_INST_NAME = this.textBox2.Text.Trim();//认证机构
                String PLINE_NAME = this.PLINE_NAME.Text.Trim();
                String PLINE_CODE = v_line_no;
                String STEEL_NAME = this.txt_steel_name.Text.Trim();
                String SMP_CATG = this.cbx_smp_catg.Text.Trim();
                String heatNo = this.selheatNo.Text.Trim();
                String DESIGNKEY = this.sel_design_key.Text.Trim();

                String SAMPLE_DELIVERY_TIME = this.SAMPLE_DELIVERY_TIME2.Text.Trim();//查询  送样时间点
                String sdtime = this.dateTimePicker4.Text.ToString();
                SAMPLE_DELIVERY_TIME = sdtime + " " + SAMPLE_DELIVERY_TIME;//送样时间点

                if (PLINE_NAME.Equals("全部"))
                {
                    PLINE_NAME = "";
                }
                if (CERT_INST_NAME.Equals("全部"))
                {
                    CERT_INST_NAME = "";
                }
                if (SMP_CATG.Equals("全部"))
                {
                    SMP_CATG = "";
                }
                else if (SMP_CATG.Equals("成分"))
                {
                    SMP_CATG = "A";
                }
                else
                {
                    SMP_CATG = "B";
                }


                if (this.CustomInfo == "HB")
                {
                    PLINE_NAME = "厚板线";
                }
                else if (this.CustomInfo == "ZB")
                {
                    PLINE_NAME = "中板线";
                }


                //轧批号  小框框 是否勾选
                if (this.checkBox1.Checked)
                {
                    checkboxVal = "1";
                    STARTTIME = "";
                    ENDTIME = "";
                }
                else
                {
                    BATCH_NO = "";
                    BATCH_NO2 = "";
                }
                if (this.checkBox2.Checked)
                {
                    STARTTIME = "";
                    ENDTIME = "";
                }
                else
                {
                    heatNo = "";
                }
                if (this.checkBox3.Checked)
                {
                    //STARTTIME = "";
                    //ENDTIME = "";
                }
                else
                {
                    DESIGNKEY = "";
                }
                if (!this.checkBox4.Checked)
                {
                    SAMPLE_DELIVERY_TIME = "";
                }
                String checkbokTxtL = "F";//同轧批合并委托
                if (this.checkBox6.Checked)
                {
                    checkbokTxtL = "T";
                }

                Hashtable ht = new Hashtable();
                ht.Add("BATCH_NO", BATCH_NO);
                ht.Add("BATCH_NO2", BATCH_NO2);
                ht.Add("STARTTIME", STARTTIME);
                ht.Add("ENDTIME", ENDTIME);
                ht.Add("VALIDFLAG", VALIDFLAG);
                ht.Add("CERT_INST_NAME", CERT_INST_NAME);
                ht.Add("PLINE_NAME", PLINE_NAME);
                ht.Add("PLINE_CODE", PLINE_CODE);
                ht.Add("checkboxVal", checkboxVal);
                if (this.ultraTabControl1.Tabs[0].Selected)
                {
                    ht.Add("STATUS", "0");
                }
                if (this.ultraTabControl1.Tabs[1].Selected || this.ultraTabControl1.Tabs[2].Selected)
                {
                    ht.Add("TAB_NAME", "1");
                }
                ht.Add("STEEL_NAME", STEEL_NAME);
                ht.Add("SMP_CATG", SMP_CATG);
                ht.Add("HEAT_NO", heatNo);
                ht.Add("DESIGN_KEY", DESIGNKEY);
                ht.Add("SAMPLE_DELIVERY_TIME", SAMPLE_DELIVERY_TIME);
                ht.Add("CHECKBOKTXTL", checkbokTxtL);

                String PLINE_NAME2 = "导出数据";
                if (this.CustomInfo == "HB")
                {
                    PLINE_NAME2 = "厚板线导出";
                }
                else if (this.CustomInfo == "ZB")
                {
                    PLINE_NAME2 = "中板线导出";
                }
                
                this.dataSet8.Clear();
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "QCM.JHY01.JHY0101.QuerryQltySample";
                ccp.MethodName = "ZHBQueryExcel";
                ccp.ServerParams = new object[] {ht};
                ccp.SourceDataTable = this.dataSet8.Tables[0];

                this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
              //  ClsControlPack.RefreshAndAutoSize(ultraGrid7);
                foreach (UltraGridRow ugr in this.ultraGrid7.Rows)
                {
                    string specimen_no = ugr.Cells["取样编号"].Value.ToString();
                    if (!string.IsNullOrEmpty(specimen_no))
                    {
                        CoreClientParam ccp2 = new CoreClientParam();
                        ccp2.ServerName = "QCM.JHY01.JHY0101.QuerryQltySample";
                        ccp2.MethodName = "getQltySampleItemNew2";
                        ccp2.ServerParams = new object[] { specimen_no };
                        ccp2.SourceDataTable = this.dataSet8.Tables[1];

                        ultraGrid7.BeginUpdate();
                      //重绘控件直到endupdate 不会每次就重绘控件 避免闪烁
                        for (int idx = this.dataTable9.Rows.Count - 1; idx >= 0; idx--)
                        {
                            if (Convert.ToString(this.dataTable9.Rows[idx]["取样编号"]) == specimen_no)
                               this.dataTable9.Rows[idx].Delete();
                        }
                        this.dataTable9.AcceptChanges();
                        this.ExecuteQueryToDataTable(ccp2, CoreInvokeType.Internal);
                        ultraGrid7.EndUpdate();
                    }
                }
                
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                MessageBox.Show("系统出错，请联系管理人员", "警告");
            }
        }
        #endregion

        #region 全部修改
        private void DoAllUpdate()
        {
            if (this.ultraTabControl1.Tabs[0].Selected) //检验委托
            {
                UltraGridRow row = this.ultraGrid1.ActiveRow;
                String type = row.Cells["SMP_TYPE_CODE"].Value.ToString();
                if (type.Equals("0"))
                {
                    //初样修改 夹杂按炉已不用这个按钮了
                   // DoUpRefBatchNo();
                }
                else if (type.Equals("1"))
                {
                    //复样修改
                    DoUpBatchNo();
                }

            }
            else if (this.ultraTabControl1.Tabs[1].Selected)
            {
                //委托记录
                //修改热处理号  取样材料号
                doAllUpdate();
            }
        }
        #endregion

        #region 初样 修改取样轧批号按炉初样比如：夹杂
        private void DoUpRefBatchNo()
        {
            try
            {
                CoreClientParam ccp = new CoreClientParam();
                ArrayList smpNo = new ArrayList();//试样号
                ArrayList specimenNo = new ArrayList();//取样编号
                ArrayList batchNo = new ArrayList();//轧批号
                ArrayList heatnNo = new ArrayList();//炉号
                ArrayList materialNo = new ArrayList();//取样材料号
                ArrayList send_memo = new ArrayList();//发送备注
                ArrayList inspectionLot = new ArrayList();//检验号
                ArrayList plineCode = new ArrayList();
                foreach (UltraGridRow ugr in this.ultraGrid1.Rows)
                {
                    if (ugr.Cells["CHK"].Value.ToString().ToLower() == "true")
                    {
                        if (!ugr.Cells["SMP_TYPE_CODE"].Value.ToString().Equals("0") || !ugr.Cells["FREQ_CODE"].Value.ToString().Equals("D"))
                        {
                            this.alert("修改初样取样轧批号按钮是用来修改【初样】【按炉取样】的轧批,请谨慎操作!");
                            return;
                        }
                        smpNo.Add(ugr.Cells["SMP_NO"].Value.ToString());
                        specimenNo.Add(ugr.Cells["SPECIMEN_NO"].Value.ToString());
                        batchNo.Add(ugr.Cells["BATCH_NO"].Value.ToString());
                        heatnNo.Add(ugr.Cells["HEAT_NO"].Value.ToString());
                        materialNo.Add(ugr.Cells["MATERIAL_NO"].Value.ToString());
                        send_memo.Add(ugr.Cells["SEND_MEMO"].Value.ToString());
                        inspectionLot.Add(ugr.Cells["INSPECTION_LOT"].Value.ToString());
                        plineCode.Add(ugr.Cells["PLINE_CODE"].Value.ToString());
                    }
                }
                ccp.ServerName = "QCM.JHY01.JHY0102.UpdateInfo";
                ccp.MethodName = "DoUpRefBatchNo";
                ccp.ServerParams = new object[] { smpNo, specimenNo, batchNo, heatnNo, materialNo, send_memo, inspectionLot, plineCode };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                if (ccp.ReturnCode != -1)
                {
                    MessageBox.Show("修改成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.None);
                    this.DoQuery();
                }
                
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                MessageBox.Show("系统出错【初样修改轧批号】，请联系管理人员", "警告");
            }
        }
        #endregion

        #region 复样 修改轧批号
        private void DoUpBatchNo()
        {
            try
            {
                CoreClientParam ccp = new CoreClientParam();
                ArrayList smpNo = new ArrayList();//试样号
                ArrayList specimenNo = new ArrayList();//取样编号
                ArrayList batchNo = new ArrayList();//轧批号
                ArrayList materialNo = new ArrayList();//取样材料号
                ArrayList send_memo = new ArrayList();//发送备注
                ArrayList inspectionLot = new ArrayList();//检验号
                ArrayList plineCode = new ArrayList();
                foreach (UltraGridRow ugr in this.ultraGrid1.Rows)
                {
                    if (ugr.Cells["CHK"].Value.ToString().ToLower() == "true")
                    {
                        if ((!ugr.Cells["SMP_TYPE_CODE"].Value.ToString().Equals("1") && !ugr.Cells["SMP_TYPE_CODE"].Value.ToString().Equals("3"))  || !ugr.Cells["FREQ_CODE"].Value.ToString().Equals("D"))
                        {
                            this.alert("修改复样轧批号按钮是用来修改【复样】【按炉取样】的轧批,请谨慎操作!");
                            return;
                        }
                        smpNo.Add(ugr.Cells["SMP_NO"].Value.ToString());
                        specimenNo.Add(ugr.Cells["SPECIMEN_NO"].Value.ToString());
                        batchNo.Add(ugr.Cells["BATCH_NO"].Value.ToString());
                        materialNo.Add(ugr.Cells["MATERIAL_NO"].Value.ToString());
                        send_memo.Add(this.UserInfo.GetUserName().ToString());//ugr.Cells["SEND_MEMO"].Value.ToString()
                        inspectionLot.Add(ugr.Cells["INSPECTION_LOT"].Value.ToString());
                        plineCode.Add(ugr.Cells["PLINE_CODE"].Value.ToString());
                    }
                }
                ccp.ServerName = "QCM.JHY01.JHY0102.UpdateInfo";
                ccp.MethodName = "updateBatchNo";
                ccp.ServerParams = new object[] { smpNo, specimenNo, batchNo, materialNo, send_memo, inspectionLot, plineCode };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                if (ccp.ReturnCode != -1)
                {
                    MessageBox.Show("修改成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.None);
                    this.DoQuery();
                }
                
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                MessageBox.Show("系统出错【复样修改轧批号】，请联系管理人员", "警告");
            }
        }
        #endregion

        #region 修改热处理号  取样材料号
        public void doAllUpdate()
        {
            UltraGridRow row = this.ultraGrid4.ActiveRow;
            String PROCESS_NOS = row.Cells["PROCESS_NOS"].Value.ToString().Trim();
            String MATERIAL_NO = row.Cells["MATERIAL_NO"].Value.ToString();
            String BATCH_NO = row.Cells["BATCH_NO"].Value.ToString();
            String SPECIMEN_NO = row.Cells["SPECIMEN_NO"].Value.ToString();
            String SMP_NO = row.Cells["SMP_NO"].Value.ToString();
            String PLINE_CODE = row.Cells["PLINE_CODE"].Value.ToString();
            Hashtable ht = new Hashtable();
            ht.Add("PROCESS_NOS", PROCESS_NOS);
            ht.Add("MATERIAL_NO", MATERIAL_NO);
            ht.Add("BATCH_NO", BATCH_NO);
            ht.Add("SPECIMEN_NO", SPECIMEN_NO);
            ht.Add("SMP_NO", SMP_NO);
            ht.Add("PLINE_CODE", PLINE_CODE);
            ht.Add("USER_NAME", this.UserInfo.GetUserName().ToString());
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "QCM.JHY01.JHY0102.UpdateInfo";
            ccp.MethodName = "doAllUpdate";
            ccp.ServerParams = new object[] { ht };
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode == -1)
            {
                return;
            }
            MessageBox.Show("修改成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.None);
            this.DoQuery();
        }
        #endregion

        #region 修改取样材料号
        private void DoUpdate()
        {
            try
            {
               // String plineCode = this.CustomInfo;
                CoreClientParam ccp = new CoreClientParam();
                ArrayList smpNo = new ArrayList();//试样号
                ArrayList specimenNo = new ArrayList();//取样编号
                ArrayList batchNo = new ArrayList();//轧批号
                ArrayList materialNo = new ArrayList();//取样材料号
                ArrayList send_memo = new ArrayList();//发送备注
                ArrayList inspectionLot = new ArrayList();//检验号
                ArrayList plineCode = new ArrayList();
                foreach (UltraGridRow ugr in this.ultraGrid1.Rows)
                {
                    if (ugr.Cells["CHK"].Value.ToString().ToLower() == "true")
                    {
                        smpNo.Add(ugr.Cells["SMP_NO"].Value.ToString());
                        specimenNo.Add(ugr.Cells["SPECIMEN_NO"].Value.ToString());
                        batchNo.Add(ugr.Cells["BATCH_NO"].Value.ToString());
                        if (string.IsNullOrEmpty(ugr.Cells["MATERIAL_NO"].Value.ToString()))
                        {
                            this.alert("取样材料号不能为空！！！！");
                            return;
                        }
                        materialNo.Add(ugr.Cells["MATERIAL_NO"].Value.ToString());
                        send_memo.Add(ugr.Cells["SEND_MEMO"].Value.ToString());
                        inspectionLot.Add(ugr.Cells["INSPECTION_LOT"].Value.ToString());
                        plineCode.Add(ugr.Cells["PLINE_CODE"].Value.ToString());
                    }
                }
                ccp.ServerName = "QCM.JHY01.JHY0102.UpdateInfo";
                ccp.MethodName = "updateMaterialNo";
                ccp.ServerParams = new object[] { smpNo, specimenNo, batchNo, materialNo, send_memo, inspectionLot, plineCode };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                MessageBox.Show("系统出错【修改取样材料号】，请联系管理人员", "警告");
            }
        }
        #endregion

        #region 新增人工委托
        private void AddArtificial()
        {
            try
            {
                QCM0205ZHB frmRbp = new QCM0205ZHB();
                frmRbp.StartPosition = FormStartPosition.CenterScreen;
                frmRbp.ob = this.ob;
                if(v_line_no.Equals("ZB")){
                frmRbp.plineCode = "ZB1";
                }else if(v_line_no.Equals("HB")){
                frmRbp.plineCode = "HB1";
                }
                frmRbp.ShowDialog();
                this.DoQuery();
            }
            catch (Exception ex)
            {
                MessageBox.Show("操作过程出现异常！\n" + ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
            }
        }
        #endregion

        #region 新增检验项
        private void AddBasePhy()
        {
            try
            {
                UltraGridRow row = this.ultraGrid1.ActiveRow;
                if (row == null)
                {
                    this.alert("检验委托为空！请选择检验委托数据!!!");
                    return;
                }

                if (!row.Cells["SMP_CATG"].Text.ToString().Equals("材质"))
                {
                    this.alert("只有材质数据才可以新增检验项!!!");
                    return;
                }

                QCM0204 frmRbp = new QCM0204();
                frmRbp.StartPosition = FormStartPosition.CenterScreen;
                frmRbp.ob = this.ob;
                frmRbp.specimenNo = row.Cells["SPECIMEN_NO"].Value.ToString();
                frmRbp.smpNo = row.Cells["SMP_NO"].Value.ToString();
                frmRbp.plineCode = "ZHB";
                frmRbp.ShowDialog();

                this.DoQueryPrg(row);//右下角
            }
            catch (Exception ex)
            {
                MessageBox.Show("操作过程出现异常！\n" + ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
            }
        }
        #endregion

        #region 新增复制单条委托
        private void DoAddWt()
        {
            try
            {
                int num = 0;
                foreach (UltraGridRow ugr in this.ultraGrid1.Rows)
                {
                    if (ugr.Cells["CHK"].Value.ToString().ToLower() == "true")
                    {
                        num = num + 1;
                    }
                }
                if (num > 1)
                {
                    this.alert("只能单条复制！为防止数据差错谢谢配合【谨慎复制】");
                    return;
                }

                UltraGridRow row = this.ultraGrid1.ActiveRow;
                if (row == null)
                {
                    this.alert("检验委托为空！请选择检验委托数据!!!");
                    return;
                }

                String batchNo = row.Cells["BATCH_NO"].Value.ToString();//轧批号
                String designKey = row.Cells["DESIGN_KEY"].Value.ToString();//订单号
                String smpNo = row.Cells["SMP_NO"].Value.ToString();//试样号
                String specimenNo = row.Cells["SPECIMEN_NO"].Value.ToString();//取样编号
                String smpTypeName = row.Cells["SMP_TYPE_NAME"].Value.ToString();//取样类型

                if (MessageBox.Show("轧批号【" + batchNo + "】，确认复制当前委托一条?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
                {
                    return;
                }
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "QCM.JHY01.JHY0102.UpdateInfo";
                if (smpTypeName.Equals("初样"))
                {
                    ccp.MethodName = "DoAddWtZy";
                }
                else if (smpTypeName.Equals("复样"))
                {
                    ccp.MethodName = "DoAddWtFy";
                }
                ccp.ServerParams = new object[] { batchNo, designKey, smpNo, specimenNo, this.UserInfo.GetUserName() };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                if (ccp.ReturnCode != -1)
                {
                    MessageBox.Show("复制委托成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.None);
                }
                this.DoQuery();
            }
            catch (Exception ex)
            {
                MessageBox.Show("操作过程出现异常！\n" + ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
            }
        }
        #endregion

        #region 撤销复制单条委托
        private void DoDelWt()
        {
            try
            {
                int num = 0;
                foreach (UltraGridRow ugr in this.ultraGrid1.Rows)
                {
                    if (ugr.Cells["CHK"].Value.ToString().ToLower() == "true")
                    {
                        num = num + 1;
                    }
                }
                if (num > 1)
                {
                    this.alert("只能单条删除！为防止数据差错谢谢配合【谨慎删除】");
                    return;
                }
                UltraGridRow row = this.ultraGrid1.ActiveRow;
                if (row == null)
                {
                    this.alert("检验委托为空！请选择检验委托数据!!!");
                    return;
                }

                String batchNo = row.Cells["BATCH_NO"].Value.ToString();//轧批号
                String designKey = row.Cells["DESIGN_KEY"].Value.ToString();//订单号
                String smpNo = row.Cells["SMP_NO"].Value.ToString();//试样号
                String specimenNo = row.Cells["SPECIMEN_NO"].Value.ToString();//取样编号
                String smpTypeName = row.Cells["SMP_TYPE_NAME"].Value.ToString();//取样类型
                String item_flag = row.Cells["ITEM_FLAG"].Value.ToString();//项目来源(0-订单,1-人工）

                if (MessageBox.Show("轧批号【" + batchNo + "】，确认撤销当前委托?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
                {
                    return;
                }
                if (!item_flag.Equals("1"))
                {
                    this.alert("只能撤销人工复制委托");
                    return;
                }
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "QCM.JHY01.JHY0102.UpdateInfo";
                if (smpTypeName.Equals("初样"))
                {
                    ccp.MethodName = "DoDelWtZy";
                }
                else if (smpTypeName.Equals("复样"))
                {
                    ccp.MethodName = "DoDelWtFy";
                }
                ccp.ServerParams = new object[] { batchNo, designKey, smpNo, specimenNo };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                if (ccp.ReturnCode != -1)
                {
                    MessageBox.Show("撤销复制委托成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.None);//ccp.ReturnInfo "发送成功" ccp.ReturnInfo
                }
                this.DoQuery();
            }
            catch (Exception ex)
            {
                MessageBox.Show("操作过程出现异常！\n" + ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
            }
        }
        #endregion

        #region 删除委托
        private void DoDelete()
        {
            try
            {
                UltraGridRow row = this.ultraGrid1.ActiveRow;
                if (row == null)
                {
                    this.alert("检验委托为空！请选择检验委托数据!!!");
                    return;
                }
                String batchNoViw = row.Cells["BATCH_NO"].Value.ToString();//轧批号

                ArrayList batchNo = new ArrayList();//轧批号
                ArrayList designKey = new ArrayList();//订单号
                ArrayList smpNo = new ArrayList();//试样号
                ArrayList specimenNo = new ArrayList();//取样编号
                ArrayList smpTypeName = new ArrayList();//取样类型

                foreach (UltraGridRow ugr in this.ultraGrid1.Rows)
                {
                    if (ugr.Cells["CHK"].Value.ToString().ToLower() == "true")
                    {
                        batchNo.Add(ugr.Cells["BATCH_NO"].Value.ToString());//轧批号
                        designKey.Add(ugr.Cells["DESIGN_KEY"].Value.ToString());//订单号
                        smpNo.Add(ugr.Cells["SMP_NO"].Value.ToString());//试样号
                        specimenNo.Add(ugr.Cells["SPECIMEN_NO"].Value.ToString());//取样编号
                       
                        if (ugr.Cells["SMP_TYPE_NAME"].Value.ToString().Contains("模拟焊后"))
                        {
                            smpTypeName.Add("初样");//取样类型
                        }
                        else
                        {
                            smpTypeName.Add(ugr.Cells["SMP_TYPE_NAME"].Value.ToString());//取样类型
                        }
                        if (ugr.Cells["SMP_TYPE_CODE"].Value.ToString().Equals("3"))
                        {
                            this.alert("件件取样暂时不支持删除！！！");
                            return;
                        }
                    }
                }


                if (MessageBox.Show("确认删除轧批号【" + batchNoViw + "】委托?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
                {
                    return;
                }

                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "QCM.JHY01.JHY0102.UpdateInfo";
                ccp.MethodName = "DoDelete";
                ccp.ServerParams = new object[] { batchNo, designKey, smpNo, specimenNo, smpTypeName, this.UserInfo.GetUserName() };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                if (ccp.ReturnCode != -1)
                {
                    MessageBox.Show("删除委托成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.None);
                }
                this.DoQuery();
            }
            catch (Exception ex)
            {
                MessageBox.Show("操作过程出现异常！\n" + ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
            }
        }
        #endregion

        #region 人工引用界面
        private void DoQuoteKY()
        {
            try
            {
                UltraGridRow row = this.ultraGrid1.ActiveRow;
                if (row == null)
                {
                    this.alert("检验委托为空！请选择检验委托数据!!!");
                    return;
                }

                if (!row.Cells["SMP_CATG"].Text.ToString().Equals("材质"))
                {
                    this.alert("只有材质数据才可以引用!!!");
                    return;
                }

                if (row.Cells["FREQ_CODE"].Value.ToString().Equals("D"))
                {
                    this.alert("夹杂不能使用当前按钮!");
                    return;
                }
                String PLINE_CODE = row.Cells["PLINE_CODE"].Value.ToString();
                String txt_DESIGN_KEY = row.Cells["DESIGN_KEY"].Value.ToString();
                String txtDK = txt_DESIGN_KEY.Substring(0, 2);
                 String SMP_TYPE_CODE = row.Cells["SMP_TYPE_CODE"].Value.ToString();
                // if ("ZB1".Equals(PLINE_CODE) && "1".Equals(SMP_TYPE_CODE))
                //{
                //     //复样引用
                //    foreach (UltraGridRow ugr in this.ultraGrid1.Rows)
                //    {
                //        if (ugr.Cells["CHK"].Value.ToString().ToLower() == "true")
                //        {
                //            if (ugr.Cells["FREQ_CODE"].Value.ToString().Equals("D"))
                //            {
                //                this.alert("夹杂不能使用当前按钮！！！");
                //                return;
                //            }
                //            if (ugr.Cells["PLINE_CODE"].Value.ToString().Equals("ZB1") && ugr.Cells["SMP_TYPE_CODE"].Value.ToString().Equals("1"))
                //            {
                //                Hashtable ht = new Hashtable();
                //                ht.Add("HEAT_NO", ugr.Cells["HEAT_NO"].Value.ToString());
                //                ht.Add("BATCH_NO", ugr.Cells["BATCH_NO"].Value.ToString());
                //                ht.Add("SMP_NO", ugr.Cells["SMP_NO"].Value.ToString());
                //                ht.Add("SPECIMEN_NO", ugr.Cells["SPECIMEN_NO"].Value.ToString());
                //                ht.Add("FREQ_CODE", ugr.Cells["FREQ_CODE"].Value.ToString());
                //                ht.Add("PLINE_CODE", ugr.Cells["PLINE_CODE"].Value.ToString());
                //                ht.Add("SMP_TYPE_CODE", ugr.Cells["SMP_TYPE_CODE"].Value.ToString());
                //                ht.Add("SEND_ID", this.UserInfo.GetUserID());
                //                ht.Add("CREATE_NAME", this.UserInfo.GetUserName());
                //                ht.Add("THICK", ugr.Cells["THICK"].Value.ToString());
                //                ht.Add("DESIGN_KEY", ugr.Cells["DESIGN_KEY"].Value.ToString());
                //                CoreClientParam ccp = new CoreClientParam();
                //                ccp.ServerName = "QCM.JHY01.JHY0102.UpdateInfo";
                //                ccp.MethodName = "DoQuoteBatchNo";
                //                ccp.ServerParams = new object[] { ht };
                //                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                //            }
                //        }
                //    }
                //    this.DoQuery();
                //    return;
                //}

                int num = 0;
                foreach (UltraGridRow ugr in this.ultraGrid1.Rows)
                {
                    if (ugr.Cells["CHK"].Value.ToString().ToLower() == "true")
                    {
                        if (ugr.Cells["FREQ_CODE"].Value.ToString().Equals("D"))
                        {
                            this.alert("夹杂不能使用当前按钮！！！");
                            return;
                        }
                        String CERT_INST_CODE = ugr.Cells["CERT_INST_CODE"].Value.ToString();
                        if (CERT_INST_CODE.Equals("IC005"))//美国船级社
                        {
                            String CERT_INST_NAME = ugr.Cells["CERT_INST_NAME"].Value.ToString();
                            this.alert("【"+CERT_INST_NAME+"】认证机构不能引用!请核实数据");
                            return;
                        }
                        num = num + 1;
                    }
                }
                if (num!=1)
                {
                    this.alert("要勾选委托并且只能勾选一条引用!");
                    return;
                }
                String zbstr = "0";
                if ("ZB1".Equals(PLINE_CODE))
                {
                    CoreClientParam ccp2 = new CoreClientParam();
                    ccp2.ServerName = "QCM.JHY01.JHY0101.QuerryQltySample";//调用java地址
                    ccp2.MethodName = "getDuplicateSample";//调用的方法 
                    ccp2.ServerParams = new object[] { row.Cells["BATCH_NO"].Value.ToString(), PLINE_CODE, row.Cells["INSPECTION_LOT"].Value.ToString() };
                    ccp2.SourceDataTable = this.dataSet9.Tables[0];
                    this.ExecuteQueryToDataTable(ccp2, CoreInvokeType.Internal);
                    for (int i = 0; i < ccp2.SourceDataTable.Rows.Count; i++)
                    {
                       String count= ccp2.SourceDataTable.Rows[i]["COUNT"].ToString();
                       if (!"".Equals(count) && count!=null && !count.Equals("0"))
                       {
                           zbstr = "1";
                        }
                    }
                }


                if ("19".Equals(txtDK))
                {
                    this.DoQuote();
                }
                else if ("ZB1".Equals(PLINE_CODE) && zbstr.Equals("0"))
                {
                   this.DoQuote();
                }
                else { 
                QCM0206 frmRbp = new QCM0206();
                frmRbp.StartPosition = FormStartPosition.CenterScreen;
                frmRbp.ob = this.ob;
                frmRbp.specimenNo = row.Cells["SPECIMEN_NO"].Value.ToString();
                frmRbp.smpNo = row.Cells["SMP_NO"].Value.ToString();
                frmRbp.batchNo = row.Cells["BATCH_NO"].Value.ToString();
                frmRbp.designKey = row.Cells["DESIGN_KEY"].Value.ToString();
                frmRbp.steelCode = row.Cells["STEEL_NAME"].Value.ToString();
                frmRbp.thick = row.Cells["THICK"].Value.ToString();
                frmRbp.ShowDialog();
                this.DoQuery();
                }
              
            }
            catch (Exception ex)
            {
                MessageBox.Show("操作过程出现异常！\n" + ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
            }
        }
        #endregion

        #region 查询
        private void DoQuery()
        {
            try
            {
                //导出
                if (this.ultraTabControl1.Tabs[2].Selected)
                {
                    inExport();
                    return;
                }

                //LIMS退回轧批
                if (this.ultraTabControl1.Tabs[3].Selected)
                {
                    inLIMSQuery();
                    return;
                }

                String RZ_MIXROLL = "";
                String checkboxVal = "";
                String STARTTIME = this.dateTimePicker1.Value.ToString("yyyy-MM-dd");
                String ENDTIME = this.dateTimePicker2.Value.ToString("yyyy-MM-dd");
                String BATCH_NO = this.textBox1.Text.Trim();
                String BATCH_NO2 = this.BATCH_NO2.Text.Trim();
                String VALIDFLAG = "1";
                String CERT_INST_NAME = this.textBox2.Text.Trim();//认证机构
                String PLINE_NAME = this.PLINE_NAME.Text.Trim();
                String PLINE_CODE = v_line_no;
                String STEEL_NAME = this.txt_steel_name.Text.Trim();
                String SMP_CATG = this.cbx_smp_catg.Text.Trim();
                String heatNo = this.selheatNo.Text.Trim();
                String DESIGNKEY = this.sel_design_key.Text.Trim();

                String SAMPLE_DELIVERY_TIME = this.SAMPLE_DELIVERY_TIME2.Text.Trim();//查询  送样时间点
                String sdtime = this.dateTimePicker4.Text.ToString();
                SAMPLE_DELIVERY_TIME = sdtime + " " + SAMPLE_DELIVERY_TIME;//送样时间点

                if (PLINE_NAME.Equals("全部"))
                {
                    PLINE_NAME = "";
                }
                if (CERT_INST_NAME.Equals("全部"))
                {
                    CERT_INST_NAME = "";
                }
                if (SMP_CATG.Equals("全部"))
                {
                    SMP_CATG = "";
                }
                else if (SMP_CATG.Equals("成分"))
                {
                    SMP_CATG = "A";
                }
                else
                {
                    SMP_CATG = "B";
                }


                if (this.CustomInfo == "HB")
                {
                    PLINE_NAME = "厚板线";
                }
                else if (this.CustomInfo == "ZB")
                {
                    PLINE_NAME = "中板线";
                }


                //轧批号  小框框 是否勾选
                if (this.checkBox1.Checked)
                {
                    checkboxVal = "1";
                    STARTTIME = "";
                    ENDTIME = "";
                    if (string.IsNullOrEmpty(BATCH_NO))
                    {
                        this.alert("请输入轧批号！！！");
                        this.textBox1.Focus();
                        return;
                    }
                }
                else
                {
                    BATCH_NO = "";
                    BATCH_NO2 = "";
                }
                if (this.checkBox2.Checked)
                {
                    STARTTIME = "";
                    ENDTIME = "";
                }
                else
                {
                    heatNo = "";
                }
                if (this.checkBox3.Checked)
                {
                    //STARTTIME = "";
                    //ENDTIME = "";
                }
                else
                {
                    DESIGNKEY = "";
                }

                if (this.checkBox5.Checked)
                {
                    STARTTIME = "";
                    ENDTIME = "";
                    RZ_MIXROLL = this.textBox3.Text.Trim();
                }

                if (!string.IsNullOrEmpty(BATCH_NO2))
                {
                    if (string.IsNullOrEmpty(BATCH_NO))
                    {
                        this.alert("请输入轧批号！！！");
                        this.textBox1.Focus();
                        return;
                    }
                }
                if (!this.checkBox4.Checked)
                {
                    SAMPLE_DELIVERY_TIME = "";
                }
               
                CoreClientParam ccp = new CoreClientParam();
                if (this.ultraTabControl1.Tabs[0].Selected) //检验委托
                {
                    this.dataSet1.Clear();
                    ccp.ServerName = "QCM.JHY01.JHY0101.QuerryQltySample";
                    ccp.MethodName = "getQltySampleInfoZHB";
                    ccp.SourceDataTable = this.dataSet1.Tables[0];
                }
                else if (this.ultraTabControl1.Tabs[1].Selected)
                {
                    this.dataSet5.Clear();
                    ccp.ServerName = "QCM.JHY01.JHY0101.QuerryQltySample";
                    ccp.MethodName = "getQltySampleInfoZHB";
                    ccp.SourceDataTable = this.dataSet5.Tables[0];
                }
                Hashtable ht = new Hashtable();
                ht.Add("BATCH_NO", BATCH_NO);
                ht.Add("BATCH_NO2", BATCH_NO2);
                ht.Add("STARTTIME", STARTTIME);
                ht.Add("ENDTIME", ENDTIME);
                ht.Add("VALIDFLAG", VALIDFLAG);
                ht.Add("CERT_INST_NAME", CERT_INST_NAME);
                ht.Add("PLINE_NAME", PLINE_NAME);
                ht.Add("PLINE_CODE", PLINE_CODE);
                ht.Add("checkboxVal", checkboxVal);
                if (this.ultraTabControl1.Tabs[0].Selected)
                {
                    ht.Add("STATUS", "0");
                }
                if (this.ultraTabControl1.SelectedTab.Text.Equals("委托记录"))
                {
                    ht.Add("TAB_NAME", "1");
                }
                ht.Add("STEEL_NAME", STEEL_NAME);
                ht.Add("SMP_CATG", SMP_CATG);
                ht.Add("HEAT_NO", heatNo);
                ht.Add("DESIGN_KEY", DESIGNKEY);
                ht.Add("SAMPLE_DELIVERY_TIME", SAMPLE_DELIVERY_TIME);
                ht.Add("RZ_MIXROLL", RZ_MIXROLL);
                String checkbokTxtL = "F";//同轧批合并委托
                if (this.checkBox6.Checked)
                {
                    if (this.ultraTabControl1.Tabs[1].Selected) { checkbokTxtL = "T"; }
                }
                ht.Add("CHECKBOKTXTL", checkbokTxtL);
                

                ccp.ServerParams = new object[] { ht };

                this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
                if (this.ultraTabControl1.Tabs[0].Selected) //检验委托
                {
                    foreach (UltraGridRow ugr in this.ultraGrid1.Rows)
                    {

                        switch (ugr.Cells["STATUS"].Text.ToString())
                        {
                            case "0":
                                ugr.Cells["STATUS"].Value = "未发送";
                                break;
                            case "1":
                                ugr.Cells["STATUS"].Value = "已引用";
                                break;
                            case "2":
                                ugr.Cells["STATUS"].Value = "已接收";
                                break;
                            case "3":
                                ugr.Cells["STATUS"].Value = "已完成";
                                break;
                            case "4":
                                ugr.Cells["STATUS"].Value = "检化验系统退回";
                                break;
                            case "5":
                                ugr.Cells["STATUS"].Value = "重判";
                                break;
                            case "7":
                                ugr.Cells["STATUS"].Value = "确认接收样";
                                break;

                        }

                        if (ugr.Cells["SMP_TYPE_NAME"].Value.ToString() == "复样")
                        {
                            ugr.Cells["SMP_TYPE_NAME"].Appearance.ForeColor = Color.Red;
                        }
                        if (ugr.Cells["SMP_LOCATION"].Value.ToString().Contains("一次模拟焊后"))
                        {
                            if (ugr.Cells["SMP_LOCATION"].Value.ToString().Contains("一次模拟焊后")
                                && (ugr.Cells["SMP_TYPE_NAME"].Value.ToString() == "复样" || ugr.Cells["SMP_TYPE_NAME"].Value.ToString() == "卷卷取样"
                                     || ugr.Cells["SMP_TYPE_NAME"].Value.ToString() == "按母板取样"))
                            {
                                ugr.Cells["SMP_TYPE_NAME"].Value = "一次模拟焊后" + ugr.Cells["SMP_TYPE_NAME"].Value.ToString();
                            }
                            else
                            {
                                ugr.Cells["SMP_TYPE_NAME"].Value = "一次模拟焊后";
                            } 
                        }
                        else if (ugr.Cells["SMP_LOCATION"].Value.ToString().Contains("二次模拟焊后"))
                        {
                            if (ugr.Cells["SMP_LOCATION"].Value.ToString().Contains("二次模拟焊后")
                                && (ugr.Cells["SMP_TYPE_NAME"].Value.ToString() == "复样" || ugr.Cells["SMP_TYPE_NAME"].Value.ToString() == "卷卷取样"
                                     || ugr.Cells["SMP_TYPE_NAME"].Value.ToString() == "按母板取样"))
                            {
                                ugr.Cells["SMP_TYPE_NAME"].Value = "二次模拟焊后" + ugr.Cells["SMP_TYPE_NAME"].Value.ToString();
                            }
                            else
                            {
                                ugr.Cells["SMP_TYPE_NAME"].Value = "二次模拟焊后";
                            }
                        }
                        else if (ugr.Cells["SMP_LOCATION"].Value.ToString().Contains("三次模拟焊后"))
                        {
                            if (ugr.Cells["SMP_LOCATION"].Value.ToString().Contains("三次模拟焊后")
                               && (ugr.Cells["SMP_TYPE_NAME"].Value.ToString() == "复样" || ugr.Cells["SMP_TYPE_NAME"].Value.ToString() == "卷卷取样"
                                    || ugr.Cells["SMP_TYPE_NAME"].Value.ToString() == "按母板取样"))
                            {
                                ugr.Cells["SMP_TYPE_NAME"].Value = "三次模拟焊后" + ugr.Cells["SMP_TYPE_NAME"].Value.ToString();
                            }
                            else
                            {
                                ugr.Cells["SMP_TYPE_NAME"].Value = "三次模拟焊后";
                            }
                        }
                        else if (ugr.Cells["SMP_LOCATION"].Value.ToString().Contains("四次模拟焊后"))
                        {
                            if (ugr.Cells["SMP_LOCATION"].Value.ToString().Contains("四次模拟焊后")
                               && (ugr.Cells["SMP_TYPE_NAME"].Value.ToString() == "复样" || ugr.Cells["SMP_TYPE_NAME"].Value.ToString() == "卷卷取样"
                                    || ugr.Cells["SMP_TYPE_NAME"].Value.ToString() == "按母板取样"))
                            {
                                ugr.Cells["SMP_TYPE_NAME"].Value = "四次模拟焊后" + ugr.Cells["SMP_TYPE_NAME"].Value.ToString();
                            }
                            else
                            {
                                ugr.Cells["SMP_TYPE_NAME"].Value = "四次模拟焊后";
                            }
                        }

                        if (ugr.Cells["SMP_CATG"].Value.ToString().Equals("A"))
                        {
                            ugr.Appearance.BackColor = Color.Aqua;
                        }

                    }
                }
                else if (this.ultraTabControl1.Tabs[1].Selected)
                {
                    foreach (UltraGridRow ugr in this.ultraGrid4.Rows)
                    {

                        switch (ugr.Cells["STATUS"].Text.ToString())
                        {
                            case "0":
                                ugr.Cells["STATUS"].Value = "未发送";
                                break;
                            case "1":
                                ugr.Cells["STATUS"].Value = "已引用";
                                break;
                            case "2":
                                ugr.Cells["STATUS"].Value = "已接收";
                                break;
                            case "3":
                                ugr.Cells["STATUS"].Value = "已完成";
                                break;
                            case "4":
                                ugr.Cells["STATUS"].Value = "检化验系统退回";
                                break;
                            case "5":
                                ugr.Cells["STATUS"].Value = "重判";
                                break;
                            case "7":
                                ugr.Cells["STATUS"].Value = "确认接收样";
                                break;

                        }

                        if (ugr.Cells["SMP_TYPE_NAME"].Value.ToString() == "复样")
                        {
                            ugr.Cells["SMP_TYPE_NAME"].Appearance.ForeColor = Color.Red;
                        }

                        if (ugr.Cells["SMP_LOCATION"].Value.ToString().Contains("一次模拟焊后"))
                        {
                            if (ugr.Cells["SMP_LOCATION"].Value.ToString().Contains("一次模拟焊后")
                                && (ugr.Cells["SMP_TYPE_NAME"].Value.ToString() == "复样" || ugr.Cells["SMP_TYPE_NAME"].Value.ToString() == "卷卷取样"
                                     || ugr.Cells["SMP_TYPE_NAME"].Value.ToString() == "按母板取样"))
                            {
                                ugr.Cells["SMP_TYPE_NAME"].Value = "一次模拟焊后" + ugr.Cells["SMP_TYPE_NAME"].Value.ToString();
                            }
                            else
                            {
                                ugr.Cells["SMP_TYPE_NAME"].Value = "一次模拟焊后";
                            }
                        }
                        else if (ugr.Cells["SMP_LOCATION"].Value.ToString().Contains("二次模拟焊后"))
                        {
                            if (ugr.Cells["SMP_LOCATION"].Value.ToString().Contains("二次模拟焊后")
                                && (ugr.Cells["SMP_TYPE_NAME"].Value.ToString() == "复样" || ugr.Cells["SMP_TYPE_NAME"].Value.ToString() == "卷卷取样"
                                     || ugr.Cells["SMP_TYPE_NAME"].Value.ToString() == "按母板取样"))
                            {
                                ugr.Cells["SMP_TYPE_NAME"].Value = "二次模拟焊后" + ugr.Cells["SMP_TYPE_NAME"].Value.ToString();
                            }
                            else
                            {
                                ugr.Cells["SMP_TYPE_NAME"].Value = "二次模拟焊后";
                            }
                        }
                        else if (ugr.Cells["SMP_LOCATION"].Value.ToString().Contains("三次模拟焊后"))
                        {
                            if (ugr.Cells["SMP_LOCATION"].Value.ToString().Contains("三次模拟焊后")
                               && (ugr.Cells["SMP_TYPE_NAME"].Value.ToString() == "复样" || ugr.Cells["SMP_TYPE_NAME"].Value.ToString() == "卷卷取样"
                                    || ugr.Cells["SMP_TYPE_NAME"].Value.ToString() == "按母板取样"))
                            {
                                ugr.Cells["SMP_TYPE_NAME"].Value = "三次模拟焊后" + ugr.Cells["SMP_TYPE_NAME"].Value.ToString();
                            }
                            else
                            {
                                ugr.Cells["SMP_TYPE_NAME"].Value = "三次模拟焊后";
                            }
                        }
                        else if (ugr.Cells["SMP_LOCATION"].Value.ToString().Contains("四次模拟焊后"))
                        {
                            if (ugr.Cells["SMP_LOCATION"].Value.ToString().Contains("四次模拟焊后")
                               && (ugr.Cells["SMP_TYPE_NAME"].Value.ToString() == "复样" || ugr.Cells["SMP_TYPE_NAME"].Value.ToString() == "卷卷取样"
                                    || ugr.Cells["SMP_TYPE_NAME"].Value.ToString() == "按母板取样"))
                            {
                                ugr.Cells["SMP_TYPE_NAME"].Value = "四次模拟焊后" + ugr.Cells["SMP_TYPE_NAME"].Value.ToString();
                            }
                            else
                            {
                                ugr.Cells["SMP_TYPE_NAME"].Value = "四次模拟焊后";
                            }
                        }
                        if (!String.IsNullOrEmpty(ugr.Cells["ZHB_SPECIMEN_NO"].Value.ToString()))
                        {
                            ugr.Appearance.BackColor = Color.LightGreen;
                        }

                        if (ugr.Cells["SMP_CATG"].Value.ToString().Equals("A"))
                        {
                            ugr.Appearance.BackColor = Color.Aqua;
                        }

                        if (ugr.Cells["FREQ_CODE"].Value.ToString().Equals("D") && String.IsNullOrEmpty(ugr.Cells["QUOTE_CONSIGN_NO"].Value.ToString())
                            && ugr.Cells["SMP_TYPE_CODE"].Value.ToString().Equals("0"))
                        {
                            ugr.Appearance.BackColor = Color.Red;
                        }

                    }

                }
               
      

                int num = 0;
                if (this.ultraTabControl1.Tabs[0].Selected) //检验委托
                {
                    num = this.ultraGrid1.Rows.Count();
                    if (num <= 0)
                    {
                        this.dataSet2.Clear();
                        this.dataSet3.Clear();
                    }
                }
                else if (this.ultraTabControl1.Tabs[1].Selected)
                {
                    num = this.ultraGrid4.Rows.Count();
                    if (num <= 0)
                    {
                        this.dataSet6.Clear();
                        this.dataSet7.Clear();
                    }
                }
                
              
               // ClsControlPack.RefreshAndAutoSize(ultraGrid1);
               // ClsControlPack.RefreshAndAutoSize(ultraGrid4);
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                MessageBox.Show("系统出错，请联系管理人员", "警告");
            }

        }

        private void inLIMSQuery()
        {
            try
            {
                String checkboxVal = "";
                String STARTTIME = this.dateTimePicker1.Value.ToString("yyyy-MM-dd");
                String ENDTIME = this.dateTimePicker2.Value.ToString("yyyy-MM-dd");
                String BATCH_NO = this.textBox1.Text.Trim();
                String BATCH_NO2 = this.BATCH_NO2.Text.Trim();
                String VALIDFLAG = "1";
                String CERT_INST_NAME = this.textBox2.Text.Trim();//认证机构
                String PLINE_NAME = this.PLINE_NAME.Text.Trim();
                String PLINE_CODE = v_line_no;
                String STEEL_NAME = this.txt_steel_name.Text.Trim();
                String SMP_CATG = this.cbx_smp_catg.Text.Trim();
                String heatNo = this.selheatNo.Text.Trim();
                String DESIGNKEY = this.sel_design_key.Text.Trim();
                String SAMPLE_DELIVERY_TIME = this.SAMPLE_DELIVERY_TIME2.Text.Trim();//查询  送样时间点
                String sdtime = this.dateTimePicker4.Text.ToString();
                SAMPLE_DELIVERY_TIME = sdtime + " " + SAMPLE_DELIVERY_TIME;//送样时间点

                if (PLINE_NAME.Equals("全部"))
                {
                    PLINE_NAME = "";
                }
                if (CERT_INST_NAME.Equals("全部"))
                {
                    CERT_INST_NAME = "";
                }
                if (SMP_CATG.Equals("全部"))
                {
                    SMP_CATG = "";
                }
                else if (SMP_CATG.Equals("成分"))
                {
                    SMP_CATG = "A";
                }
                else
                {
                    SMP_CATG = "B";
                }


                if (this.CustomInfo == "HB")
                {
                    PLINE_NAME = "厚板线";
                }
                else if (this.CustomInfo == "ZB")
                {
                    PLINE_NAME = "中板线";
                }


                //轧批号  小框框 是否勾选
                if (this.checkBox1.Checked)
                {
                    checkboxVal = "1";
                    STARTTIME = "";
                    ENDTIME = "";
                }
                else
                {
                    BATCH_NO = "";
                    BATCH_NO2 = "";
                }
                if (this.checkBox2.Checked)
                {
                    STARTTIME = "";
                    ENDTIME = "";
                }
                else
                {
                    heatNo = "";
                }
                if (this.checkBox3.Checked)
                {
                    //STARTTIME = "";
                    //ENDTIME = "";
                }
                else
                {
                    DESIGNKEY = "";
                }
                if (!this.checkBox4.Checked)
                {
                    SAMPLE_DELIVERY_TIME = "";
                }

                Hashtable ht = new Hashtable();
                ht.Add("BATCH_NO", BATCH_NO);
                ht.Add("BATCH_NO2", BATCH_NO2);
                ht.Add("STARTTIME", STARTTIME);
                ht.Add("ENDTIME", ENDTIME);
                ht.Add("VALIDFLAG", VALIDFLAG);
                ht.Add("CERT_INST_NAME", CERT_INST_NAME);
                ht.Add("PLINE_NAME", PLINE_NAME);
                ht.Add("PLINE_CODE", PLINE_CODE);
                ht.Add("checkboxVal", checkboxVal);
                ht.Add("STATUS", "0");
                ht.Add("STEEL_NAME", STEEL_NAME);
                ht.Add("SMP_CATG", SMP_CATG);
                ht.Add("HEAT_NO", heatNo);
                ht.Add("DESIGN_KEY", DESIGNKEY);
                ht.Add("SAMPLE_DELIVERY_TIME", SAMPLE_DELIVERY_TIME);

                CoreClientParam ccp = new CoreClientParam();
                this.dataSet10.Clear();
                ccp.ServerName = "QCM.JHY01.JHY0102.QuerryJhyQtly";
                ccp.MethodName = "ZHBQueryLims";
                ccp.SourceDataTable = this.dataSet10.Tables[0];
                ccp.ServerParams = new object[] { ht };
                this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);

            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                MessageBox.Show("系统出错，请联系管理人员", "警告");
            }
        }
        #endregion

        #region 查找检验项目
        private void DoQueryPrg(UltraGridRow ugr)
        {
            try
            {
                this.dataSet3.Clear();
                String specimen_no = ugr.Cells["SPECIMEN_NO"].Value.ToString();

                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "QCM.JHY01.JHY0101.QuerryQltySample";
                ccp.MethodName = "getQltySampleItem";
                ccp.ServerParams = new object[] { specimen_no };
                ccp.SourceDataTable = this.dataSet3.Tables[0];
                this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);


            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                MessageBox.Show("系统出错，请联系管理人员", "警告");
            }


        }
        #endregion

        #region 查询订单信息
        private void DoQueryOrder(UltraGridRow ugr)
        {
            try
            {
                this.dataSet2.Clear();

                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "QCM.JHY01.JHY0101.QuerryQltySample";
                ccp.MethodName = "getQltySampleOrd";
                ccp.ServerParams = new object[] { ugr.Cells["SMP_NO"].Text.ToString() };
                ccp.SourceDataTable = this.dataSet2.Tables[0];
                this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);

                foreach (UltraGridRow ugr2 in this.ultraGrid2.Rows)
                {
                    ugr2.Cells["Column1"].Value = ugr2.Cells["THICK"].Value + "*" + ugr2.Cells["WIDTH"].Value + "*" + ugr2.Cells["LENGTH"].Value;
                }

            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                MessageBox.Show("系统出错，请联系管理人员", "警告");
            }

        }
        #endregion

        #region 发送检验委托
        private void DoSend()
        {
            try
            {
                String sdeltime = this.SAMPLE_DELIVERY_TIME.Text.Trim().ToString();

                if (!sdeltime.Equals("24:00:00"))
                {
                     String strDocond =  DoCondition();//委托人员限制
                     if ("0".Equals(strDocond))
                     {
                         return;
                     }
                  
                //当前时间小于送样时间15分钟，不能选择当前送样时间发送委托
                //送样时间小于当前时间，不能选择肖妆送样时间发送委托
                String sdtime0 = this.dateTimePicker3.Text.ToString();
                String sampleDeliveryTime0 = this.SAMPLE_DELIVERY_TIME.Text.ToString();
                String dbtime = sdtime0 + " " + sampleDeliveryTime0;//送样时间点
                DateTime historyTime = Convert.ToDateTime(dbtime);//转换日期格式
                System.DateTime currentTime = new System.DateTime();
                currentTime = System.DateTime.Now;//系统时间

                TimeSpan ts = historyTime - currentTime;
                double getHours = ts.TotalMinutes;

                //产品名称
                String PROD_NAME = "";
                 UltraGridRow rowp = this.ultraGrid1.ActiveRow;
                 if (rowp != null)
                 {
                     PROD_NAME = rowp.Cells["PROD_NAME"].Text.ToString();
                 }
                 if (!PROD_NAME.Contains("模具"))
                 {
                    if (getHours <= -1)
                    {
                        this.alert("送样时间截点不能小于当前系统时间截点,请选择一个大于当前系统时间截点并且不能小于15分钟的送样时间截点,谢谢!");
                        return;
                    }
                    else if (getHours <= 15)
                    {
                        this.alert("当前系统时间截点小于送样时间截点15分钟,不能在当前送样时间点进行委托,请选择另一个送样时间点,谢谢!");
                        return;
                    }
                   }
                  }

                //判断是否有合并的委托
                String spNoSel = "";
                string fh1 = "";
                int num1 = 0;
                foreach (UltraGridRow ugr in this.ultraGrid1.Rows)
                {
                    if (ugr.Cells["CHK"].Value.ToString().ToLower() == "true")
                    {
                        String specimeNoSel = ugr.Cells["SPECIMEN_NO"].Value.ToString();
                        num1 = num1 + 1;
                        if (num1 <= 1)
                        {
                            spNoSel = specimeNoSel;
                            fh1 = ",";
                        }
                        else
                        {
                            spNoSel = spNoSel + fh1 + specimeNoSel;
                        }
                    }
                }
                
                CoreClientParam ccpSel = new CoreClientParam();
                ccpSel.ServerName = "QCM.JHY01.JHY0102.QuerryJhyQtly";
                ccpSel.MethodName = "Sel_ZHB_HB";
                ccpSel.ServerParams = new object[] { spNoSel };
                ccpSel = this.ExecuteNonQuery(ccpSel, CoreInvokeType.Internal);
                if (ccpSel.ReturnCode == -1)
                {
                    if (MessageBox.Show("是否继续发送委托?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
                    {
                        return;
                    }
                }
         
                DoUpdate();//先修改取样材料号
                String sampleDeliveryTime = this.SAMPLE_DELIVERY_TIME.Text.ToString();
                if (!sampleDeliveryTime.Equals("03:00:00") && !sampleDeliveryTime.Equals("06:30:00") && !sampleDeliveryTime.Equals("10:30:00") &&
                    !sampleDeliveryTime.Equals("11:00:00") && !sampleDeliveryTime.Equals("15:00:00") && !sampleDeliveryTime.Equals("17:30:00") &&
                    !sampleDeliveryTime.Equals("18:00:00") && !sampleDeliveryTime.Equals("20:30:00") && !sampleDeliveryTime.Equals("21:00:00") &&
                    !sampleDeliveryTime.Equals("06:00:00") && !sampleDeliveryTime.Equals("24:00:00"))
                {
                    this.alert("请在下拉框中选择正确的时间点不要手动更改时间点格式,当前时间点格式【"+ sampleDeliveryTime+"】不在规定时间格式中!");
                    return;
                }
                String sdtime = this.dateTimePicker3.Text.ToString();
                if (String.IsNullOrEmpty(sampleDeliveryTime) || String.IsNullOrEmpty(sdtime))
                {
                    this.alert("请选择送样时间点！");
                    return;
                }
                //DateTime dt = DateTime.Now;
                //String sdtime = string.Format("{0:yyyy-MM-dd}", dt);
                sampleDeliveryTime = sdtime + " " + sampleDeliveryTime;//送样时间点
               
                List<UltraGridRow> lists = new List<UltraGridRow>();
                CoreClientParam ccp = new CoreClientParam();
                string SPECIMEN_NO = "";
                string fh = "";
                int num = 0;
                string dnum = "0";
                foreach (UltraGridRow ugr in this.ultraGrid1.Rows)
                {
                    string specimeNo = "";
                    if (ugr.Cells["CHK"].Value.ToString().ToLower() == "true")
                    {
                        if (string.IsNullOrEmpty(ugr.Cells["MATERIAL_NO"].Value.ToString()))
                        {
                            return;
                        }
                        specimeNo = ugr.Cells["SPECIMEN_NO"].Value.ToString();
                        num = num + 1;
                        if (num <= 1)
                        {
                            SPECIMEN_NO = specimeNo;
                            fh = ",";
                        }
                        else
                        {
                            SPECIMEN_NO = SPECIMEN_NO + fh + specimeNo;
                        }
                        lists.Add(ugr);
                        if (ugr.Cells["FREQ_CODE"].Value.ToString().Equals("D"))
                        {
                            dnum = "1";
                        }
                    }
                }

                ccp.ServerName = "QCM.JHY01.JHY0102.Send2";
                ccp.MethodName = "SendLIMES";
                ccp.ServerParams = new object[] { SPECIMEN_NO, this.UserInfo.GetUserID(), this.UserInfo.GetUserName(), sampleDeliveryTime };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                if (ccp.ReturnCode != -1)
                {
                    for (int i = 0; i < lists.Count; i++)
                    {
                        lists[i].Delete(false);
                    }
                    MessageBox.Show("发送成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.None);//ccp.ReturnInfo "发送成功" ccp.ReturnInfo
                }
                //夹杂按炉
                if ("1".Equals(dnum))
                {
                   this.DoQuery();
                }
                int conut = this.ultraGrid1.Rows.Count();
                if (conut <= 0)
                {
                    this.dataSet2.Clear();
                    this.dataSet3.Clear();
                }
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                MessageBox.Show("系统出错，请联系管理人员", "警告");
            }
        }
        #endregion

        #region 撤销检验委托
        private void DoUnsend()
        {
            try
            {
                if (MessageBox.Show("确认撤销发送?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
                {
                    return;
                }
                List<UltraGridRow> lists = new List<UltraGridRow>();
                String zhyy = "MES撤回";
                CoreClientParam ccp = new CoreClientParam();
                string SPECIMEN_NO = "";
                string fh = "";
                int num = 0;
                int numy = 0;
                int numzhb = 0;
                string dnum = "0";
                foreach (UltraGridRow ugr in this.ultraGrid4.Rows)
                {
                    string specimeNo = "";
                    if (ugr.Cells["CHK"].Value.ToString().ToLower() == "true")
                    {
                        specimeNo = ugr.Cells["SPECIMEN_NO"].Value.ToString();
                        String status = ugr.Cells["STATUS"].Value.ToString();
                        if ("7".Equals(status) || "确认接收样".Equals(status))
                        {
                            this.alert("该委托样品已接收, 不允许撤回, 请联系LIMS实验室退回");
                            return;
                        }
                        String zhbsno = ugr.Cells["ZHB_SPECIMEN_NO"].Value.ToString();
                        if ("1".Equals(status) || "已引用".Equals(status))
                        {
                            numy = 1;
                        }
                        if (!String.IsNullOrEmpty(zhbsno))
                        {
                            numzhb = 1;
                        }

                        num = num + 1;
                        if (num <= 1)
                        {
                            SPECIMEN_NO = specimeNo;
                            fh = ",";
                        }
                        else
                        {
                            SPECIMEN_NO = SPECIMEN_NO + fh + specimeNo;
                        }
                        lists.Add(ugr);

                        if (ugr.Cells["FREQ_CODE"].Value.ToString().Equals("D"))
                        {
                            dnum = "1";
                        }
                    }
                }
                if (numy == 1)
                {
                    this.alert("不能撤销引用的轧批号！！！");
                    return;
                }
                if (numzhb == 1)
                {
                    this.alert("合并委托撤销请点击【撤销同批合并发送】按钮!");
                    return;
                }
                ccp.ServerName = "QCM.JHY01.JHY0102.Send2";
                ccp.MethodName = "CancelLIMES";
                ccp.ServerParams = new object[] { SPECIMEN_NO, this.UserInfo.GetUserName(), zhyy };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                if (ccp.ReturnCode != -1)
                {
                    for (int i = 0; i < lists.Count; i++)
                    {
                        lists[i].Delete(false);
                    }
                    MessageBox.Show("撤销发送成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.None);//ccp.ReturnInfo "发送成功" ccp.ReturnInfo
                }
                //夹杂按炉
                if ("1".Equals(dnum))
                {
                    this.DoQuery();
                }
                int conut = this.ultraGrid4.Rows.Count();
                if (conut <= 0)
                {
                    this.dataSet6.Clear();
                    this.dataSet7.Clear();
                }
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                MessageBox.Show("系统出错，请联系管理人员", "警告");
            }
        }
        #endregion

        #region 撤销检验委托19
        private void DoUnsend19()
        {
            try
            {
                if (MessageBox.Show("确认撤销19订单?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
                {
                    return;
                }
                List<UltraGridRow> lists = new List<UltraGridRow>();
                String zhyy = "MES撤回";
                CoreClientParam ccp = new CoreClientParam();
                string SPECIMEN_NO = "";
                string fh = "";
                int num = 0;
                int num19 = 0;
                foreach (UltraGridRow ugr in this.ultraGrid4.Rows)
                {
                    string specimeNo = "";
                    if (ugr.Cells["CHK"].Value.ToString().ToLower() == "true")
                    {
                        specimeNo = ugr.Cells["SPECIMEN_NO"].Value.ToString();
                       String designKey = ugr.Cells["DESIGN_KEY"].Value.ToString();
                        designKey=designKey.Substring(0, 2);
                        if (!"19".Equals(designKey))
                        {
                            num19 = 1;
                        }
                        num = num + 1;
                        if (num <= 1)
                        {
                            SPECIMEN_NO = specimeNo;
                            fh = ",";
                        }
                        else
                        {
                            SPECIMEN_NO = SPECIMEN_NO + fh + specimeNo;
                        }
                        lists.Add(ugr);
                    }
                }
                if (num19==1)
                {
                    this.alert("撤销19订单按钮只能撤销19订单！！！");
                    return;
                }
                ccp.ServerName = "QCM.JHY01.JHY0102.Send2";
                ccp.MethodName = "CancelLIMES19";
                ccp.ServerParams = new object[] { SPECIMEN_NO, this.UserInfo.GetUserName(), zhyy };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                if (ccp.ReturnCode != -1)
                {
                    for (int i = 0; i < lists.Count; i++)
                    {
                        lists[i].Delete(false);
                    }
                    MessageBox.Show("撤销19订单成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.None);//ccp.ReturnInfo "发送成功" ccp.ReturnInfo
                }
                //this.DoQuery();
                int conut = this.ultraGrid4.Rows.Count();
                if (conut <= 0)
                {
                    this.dataSet6.Clear();
                    this.dataSet7.Clear();
                }
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                MessageBox.Show("系统出错，请联系管理人员", "警告");
            }
        }
        #endregion

        #region 同轧批牌号合并发送按钮
        private void button1_Click(object sender, EventArgs e)
        {
            try
            {
                String sdeltime = this.SAMPLE_DELIVERY_TIME.Text.Trim().ToString();
                if (!sdeltime.Equals("24:00:00"))
                {
                    String strDocond = DoCondition();//委托人员限制
                    if ("0".Equals(strDocond))
                    {
                        return;
                    }
                    //当前时间小于送样时间15分钟，不能选择当前送样时间发送委托
                    //送样时间小于当前时间，不能选择肖妆送样时间发送委托
                    String sdtime0 = this.dateTimePicker3.Text.ToString();
                    String sampleDeliveryTime0 = this.SAMPLE_DELIVERY_TIME.Text.ToString();
                    String dbtime = sdtime0 + " " + sampleDeliveryTime0;//送样时间点
                    DateTime historyTime = Convert.ToDateTime(dbtime);//转换日期格式
                    System.DateTime currentTime = new System.DateTime();
                    currentTime = System.DateTime.Now;//系统时间

                    TimeSpan ts = historyTime - currentTime;
                    double getHours = ts.TotalMinutes;
                    if (getHours <= -1)
                    {
                        this.alert("送样时间截点不能小于当前系统时间截点,请选择一个大于当前系统时间截点并且不能小于15分钟的送样时间截点,谢谢!");
                        return;
                    }
                    else if (getHours <= 15)
                    {
                        this.alert("当前系统时间截点小于送样时间截点15分钟,不能在当前送样时间点进行委托,请选择另一个送样时间点,谢谢!");
                        return;
                    }
                }
               // DoUpdate();//先修改取样材料号
                String sampleDeliveryTime = this.SAMPLE_DELIVERY_TIME.Text.ToString();
                if (!sampleDeliveryTime.Equals("03:00:00") && !sampleDeliveryTime.Equals("06:00:00") && !sampleDeliveryTime.Equals("10:30:00") &&
                     !sampleDeliveryTime.Equals("11:00:00") && !sampleDeliveryTime.Equals("15:00:00") && !sampleDeliveryTime.Equals("17:30:00") &&
                     !sampleDeliveryTime.Equals("18:00:00") && !sampleDeliveryTime.Equals("20:30:00") && !sampleDeliveryTime.Equals("21:00:00") &&
                     !sampleDeliveryTime.Equals("06:30:00") && !sampleDeliveryTime.Equals("24:00:00") )
                {
                    this.alert("请在下拉框中选择正确的时间点不要手动更改时间点格式,当前时间点格式【" + sampleDeliveryTime + "】不在规定时间格式中!");
                    return;
                }
                String sdtime = this.dateTimePicker3.Text.ToString();
                if (String.IsNullOrEmpty(sampleDeliveryTime) || String.IsNullOrEmpty(sdtime))
                {
                    this.alert("请选择送样时间点！");
                    return;
                }
                //DateTime dt = DateTime.Now;
                //String sdtime = string.Format("{0:yyyy-MM-dd}", dt);
                sampleDeliveryTime = sdtime + " " + sampleDeliveryTime;//送样时间点

                CoreClientParam ccp = new CoreClientParam();
                string SPECIMEN_NO = "";
                string BATCH_NO = ""; 
                string fh = "";
                int num = 0;
                foreach (UltraGridRow ugr in this.ultraGrid1.Rows)
                {
                    string specimeNo = "";
                    if (ugr.Cells["CHK"].Value.ToString().ToLower() == "true")
                    {
                        specimeNo = ugr.Cells["SPECIMEN_NO"].Value.ToString();
                        BATCH_NO = ugr.Cells["BATCH_NO"].Value.ToString();
                        num = num + 1;
                        if (num <= 1)
                        {
                            SPECIMEN_NO = specimeNo;
                            fh = ",";
                        }
                        else
                        {
                            SPECIMEN_NO = SPECIMEN_NO + fh + specimeNo;
                        }
                    }
                }
                if (num>=2)
                {
                    this.alert("只允许对一个牌号打勾[勾选一条委托即可,无需勾选多条委托]");
                    return;
                }

                //主题：关于DNV性能引用 技术中心李娇丽提出   申报时间2024-10-28 11:06:27
                //2024年挪威船级社年审提出，低等级不能引用高等级性能，因为低等级的冲击未进行试验，没有试验原始记录，挪威船级社DNV需要在冲击温度相同的情况下才能引用性能。 
                if ("".Equals(BATCH_NO))
                {
                    this.alert("请勾选委托!");
                    return;
                }
                Hashtable ht = new Hashtable();
                ht.Add("BATCH_NO", BATCH_NO);
                CoreClientParam ccpSel = new CoreClientParam();
                ccpSel.ServerName = "QCM.JHY01.JHY0102.QuerryJhyQtly";
                ccpSel.MethodName = "getZHBDNV";
                ccpSel.ServerParams = new object[] { ht };
                ccpSel = this.ExecuteNonQuery(ccpSel, CoreInvokeType.Internal);
                if (ccpSel.ReturnCode == -1)
                {
                        return;
                }

                ccp.ServerName = "QCM.JHY01.JHY0102.Send2";
                ccp.MethodName = "ZHBmergeSendLIMES";
                ccp.ServerParams = new object[] { SPECIMEN_NO, this.UserInfo.GetUserID(), this.UserInfo.GetUserName(), sampleDeliveryTime };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                if (ccp.ReturnCode != -1)
                {
                    MessageBox.Show("合并发送成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.None);
                }
                this.DoQuery();
                int conut = this.ultraGrid1.Rows.Count();
                if (conut <= 0)
                {
                    this.dataSet2.Clear();
                    this.dataSet3.Clear();
                }
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                MessageBox.Show("系统出错，请联系管理人员", "警告");
            }
        }
        #endregion

        #region 撤销合并同批发送委托
        private void button2_Click(object sender, EventArgs e)
        {
            try
            {
                if (MessageBox.Show("确认撤销同批合并发送委托?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
                {
                    return;
                }
                String zhyy = "MES撤回";
                CoreClientParam ccp = new CoreClientParam();
                string SPECIMEN_NO = "";
                string fh = "";
                int num = 0;
                int numy = 0;
                foreach (UltraGridRow ugr in this.ultraGrid4.Rows)
                {
                    string specimeNo = "";
                    if (ugr.Cells["CHK"].Value.ToString().ToLower() == "true")
                    {
                        specimeNo = ugr.Cells["ZHB_SPECIMEN_NO"].Value.ToString();//合并取样编号
                        if (String.IsNullOrEmpty(specimeNo))
                        {
                            this.alert("【撤销同批合并发送】按钮只能撤销合并委托!");
                              return;
                        }
                        String status = ugr.Cells["STATUS"].Value.ToString();
                        if ("7".Equals(status) || "确认接收样".Equals(status))
                        {
                            this.alert("该委托样品已接收, 不允许撤回, 请联系系统管理员");
                            return;
                        }
                        String quoteConsignNo = ugr.Cells["QUOTE_CONSIGN_NO"].Value.ToString();
                        if ("1".Equals(status) || !String.IsNullOrEmpty(quoteConsignNo))
                        {
                            numy = 1;
                        }
                        num = num + 1;
                        if (num <= 1)
                        {
                            SPECIMEN_NO = specimeNo;
                            fh = ",";
                        }
                        else
                        {
                            SPECIMEN_NO = SPECIMEN_NO + fh + specimeNo;
                        }
                    }
                }
                if (numy == 1)
                {
                    this.alert("不能撤销引用的轧批号！！！");
                    return;
                }
                ccp.ServerName = "QCM.JHY01.JHY0102.Send2";
                ccp.MethodName = "ZHBCancelLIMES";
                ccp.ServerParams = new object[] { SPECIMEN_NO, this.UserInfo.GetUserName(), zhyy };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                if (ccp.ReturnCode != -1)
                {
                    MessageBox.Show("撤销同批合并发送成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.None);//ccp.ReturnInfo "发送成功" ccp.ReturnInfo
                }
                this.DoQuery();
                int conut = this.ultraGrid4.Rows.Count();
                if (conut <= 0)
                {
                    this.dataSet6.Clear();
                    this.dataSet7.Clear();
                }
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                MessageBox.Show("系统出错，请联系管理人员", "警告");
            }
        }
        #endregion

        #region 引用实绩
        private void DoQuote()
        {

            UltraGridRow row = this.ultraGrid1.ActiveRow;
            if (row == null)
            {
                this.alert("检验委托为空！请选择检验委托数据!!!");
                return;
            }
            if (MessageBox.Show("轧批号【" + row.Cells["BATCH_NO"].Value.ToString() + "】，确认引用?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
            {
                return;
            }
            if (!String.IsNullOrEmpty(row.Cells["QUOTE_MEMO"].Value.ToString()))
            {
                this.alert("已引用不可重复引用!!!");
                return;
            }
            String DESIGN_KEY = row.Cells["DESIGN_KEY"].Value.ToString();
            String HEAT_NO = row.Cells["HEAT_NO"].Value.ToString();
            String BATCH_NO = row.Cells["BATCH_NO"].Value.ToString();
            String SMP_NO = row.Cells["SMP_NO"].Value.ToString();
            String SPECIMEN_NO = row.Cells["SPECIMEN_NO"].Value.ToString();
            String FREQ_CODE = row.Cells["FREQ_CODE"].Value.ToString();
            String PLINE_CODE = row.Cells["PLINE_CODE"].Value.ToString();
            String SMP_TYPE_CODE = row.Cells["SMP_TYPE_CODE"].Value.ToString();
            String THICK = row.Cells["THICK"].Value.ToString();
            String STEEL_NAME = row.Cells["STEEL_NAME"].Value.ToString();
            Hashtable ht = new Hashtable();
            ht.Add("HEAT_NO", HEAT_NO);
            ht.Add("BATCH_NO", BATCH_NO);
            ht.Add("SMP_NO", SMP_NO);
            ht.Add("SPECIMEN_NO", SPECIMEN_NO);
            ht.Add("FREQ_CODE", FREQ_CODE);
            ht.Add("PLINE_CODE", PLINE_CODE);
            ht.Add("SMP_TYPE_CODE", SMP_TYPE_CODE);
            ht.Add("SEND_ID", this.UserInfo.GetUserID());
            ht.Add("CREATE_NAME", this.UserInfo.GetUserName());
            ht.Add("THICK", THICK);
            ht.Add("DESIGN_KEY", DESIGN_KEY);
            ht.Add("STEEL_NAME", STEEL_NAME);

            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "QCM.JHY01.JHY0102.UpdateInfo";
            ccp.MethodName = "DoQuoteBatchNo";
            ccp.ServerParams = new object[] { ht };
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                MessageBox.Show("引用成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.None);
            }
            this.DoQuery();
        }

        #endregion

        #region 预测抽样
        private void button3_Click(object sender, EventArgs e)
        {
            try
            {
                 String sdeltime = this.SAMPLE_DELIVERY_TIME.Text.Trim().ToString();
                 if (!sdeltime.Equals("24:00:00"))
                 {
                     //当前时间小于送样时间15分钟，不能选择当前送样时间发送委托
                     //送样时间小于当前时间，不能选择肖妆送样时间发送委托
                     String sdtime0 = this.dateTimePicker3.Text.ToString();
                     String sampleDeliveryTime0 = this.SAMPLE_DELIVERY_TIME.Text.ToString();
                     String dbtime = sdtime0 + " " + sampleDeliveryTime0;//送样时间点
                     DateTime historyTime = Convert.ToDateTime(dbtime);//转换日期格式
                     System.DateTime currentTime = new System.DateTime();
                     currentTime = System.DateTime.Now;//系统时间

                     TimeSpan ts = historyTime - currentTime;
                     double getHours = ts.TotalMinutes;
                     if (getHours <= -1)
                     {
                         this.alert("送样时间截点不能小于当前系统时间截点,请选择一个大于当前系统时间截点并且不能小于15分钟的送样时间截点,谢谢!");
                         return;
                     }
                     else if (getHours <= 15)
                     {
                         this.alert("当前系统时间截点小于送样时间截点15分钟,不能在当前送样时间点进行委托,请选择另一个送样时间点,谢谢!");
                         return;
                     }
                 }
                // DoUpdate();//先修改取样材料号
                String sampleDeliveryTime = this.SAMPLE_DELIVERY_TIME.Text.ToString();
                if (!sampleDeliveryTime.Equals("03:00:00") && !sampleDeliveryTime.Equals("06:00:00") && !sampleDeliveryTime.Equals("10:30:00") &&
                     !sampleDeliveryTime.Equals("11:00:00") && !sampleDeliveryTime.Equals("15:00:00") && !sampleDeliveryTime.Equals("17:30:00") &&
                     !sampleDeliveryTime.Equals("18:00:00") && !sampleDeliveryTime.Equals("20:30:00") && !sampleDeliveryTime.Equals("21:00:00") &&
                    !sampleDeliveryTime.Equals("06:30:00") && !sampleDeliveryTime.Equals("24:00:00") )
                {
                    this.alert("请在下拉框中选择正确的时间点不要手动更改时间点格式,当前时间点格式【" + sampleDeliveryTime + "】不在规定时间格式中!");
                    return;
                }
                String sdtime = this.dateTimePicker3.Text.ToString();
                if (String.IsNullOrEmpty(sampleDeliveryTime) || String.IsNullOrEmpty(sdtime))
                {
                    this.alert("请选择送样时间点！");
                    return;
                }
                sampleDeliveryTime = sdtime + " " + sampleDeliveryTime;//送样时间点

                CoreClientParam ccp = new CoreClientParam();
                string SPECIMEN_NO = "";
                string fh = "";
                int num = 0;
                foreach (UltraGridRow ugr in this.ultraGrid1.Rows)
                {
                    string specimeNo = "";
                    if (ugr.Cells["CHK"].Value.ToString().ToLower() == "true")
                    {
                        specimeNo = ugr.Cells["SPECIMEN_NO"].Value.ToString();
                        num = num + 1;
                        if (num <= 1)
                        {
                            SPECIMEN_NO = specimeNo;
                            fh = ",";
                        }
                        else
                        {
                            SPECIMEN_NO = SPECIMEN_NO + fh + specimeNo;
                        }
                    }
                }

                ccp.ServerName = "QCM.JHY01.JHY0102.Send2";
                ccp.MethodName = "ZHBYuCeSample";
                ccp.ServerParams = new object[] { SPECIMEN_NO, this.UserInfo.GetUserID(), this.UserInfo.GetUserName(), sampleDeliveryTime };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                if (ccp.ReturnCode != -1)
                {
                    MessageBox.Show("预测成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.None);
                }
                this.DoQuery();
                int conut = this.ultraGrid1.Rows.Count();
                if (conut <= 0)
                {
                    this.dataSet2.Clear();
                    this.dataSet3.Clear();
                }
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                MessageBox.Show("系统出错，请联系管理人员", "警告");
            }
        }
        #endregion

        #region 撤销预测抽样
        private void button4_Click(object sender, EventArgs e)
        {
            try
            {
                if (MessageBox.Show("确认撤销发送?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
                {
                    return;
                }
         
                String zhyy = "MES撤回";
                CoreClientParam ccp = new CoreClientParam();
                string SPECIMEN_NO = "";
                string fh = "";
                int num = 0;
                foreach (UltraGridRow ugr in this.ultraGrid4.Rows)
                {
                    string specimeNo = "";
                    if (ugr.Cells["CHK"].Value.ToString().ToLower() == "true")
                    {
                        specimeNo = ugr.Cells["SPECIMEN_NO"].Value.ToString();//取样编号
                        String status = ugr.Cells["STATUS"].Value.ToString();//状态
                        if ("7".Equals(status) || "确认接收样".Equals(status))
                        {
                            this.alert("该委托样品已接收, 不允许撤回, 请联系系统管理员");
                            return;
                        }
                        String zhbsno = ugr.Cells["RZ_OLD_SAMPL_NO"].Value.ToString();//抽样取样编号
                        String RZ_MIXROLL = ugr.Cells["RZ_MIXROLL"].Value.ToString();//组批区间
                        if (String.IsNullOrEmpty(RZ_MIXROLL) || !specimeNo.Equals(zhbsno)  )
                        {
                            this.alert("【撤销抽样】按钮只能撤销预测抽样委托!");
                            return;
                        }

                        num = num + 1;
                        if (num <= 1)
                        {
                            SPECIMEN_NO = specimeNo;
                            fh = ",";
                        }
                        else
                        {
                            SPECIMEN_NO = SPECIMEN_NO + fh + specimeNo;
                        }
                    }
                }
                ccp.ServerName = "QCM.JHY01.JHY0102.Send2";
                ccp.MethodName = "CancelZHBYuCeSample";
                ccp.ServerParams = new object[] { SPECIMEN_NO, this.UserInfo.GetUserName(), zhyy };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                if (ccp.ReturnCode != -1)
                {
                    MessageBox.Show("撤销预测抽样成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.None);//ccp.ReturnInfo "发送成功" ccp.ReturnInfo
                }
                this.DoQuery();
                int conut = this.ultraGrid4.Rows.Count();
                if (conut <= 0)
                {
                    this.dataSet6.Clear();
                    this.dataSet7.Clear();
                }
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                MessageBox.Show("系统出错，请联系管理人员", "警告");
            }
        }
        #endregion

        #region 条件
        private String DoCondition()
        {
            try
            {
               String userid=this.UserInfo.GetUserID();//员工ID
               String stime = this.SAMPLE_DELIVERY_TIME.Text.ToString();//送样时间点
               //厚板操作员 userid.Equals("X16962") ||  userid.Equals("X16961") || 
               if (userid.Equals("X16975") || userid.Equals("X16984") || userid.Equals("X16972") || userid.Equals("X16968") ||
                   userid.Equals("X16965") || userid.Equals("X16978") || userid.Equals("X16964") || userid.Equals("X16981") || userid.Equals("X17002") ||
                   userid.Equals("X16989") || userid.Equals("X16995") || userid.Equals("X16986") || userid.Equals("X16982") || userid.Equals("X16976") ||
                   userid.Equals("X17022") || userid.Equals("X16999") || userid.Equals("X16979") || userid.Equals("X16966") || userid.Equals("X17008") ||
                   userid.Equals("X16941") || userid.Equals("X16988") || userid.Equals("X16994") || userid.Equals("X16993") || userid.Equals("X16969") ||
                   userid.Equals("X17003") || userid.Equals("X16997") || userid.Equals("X16987") || userid.Equals("X16998") || userid.Equals("X16973"))
               {
                   if (!stime.Equals("06:30:00") && !stime.Equals("10:30:00") && !stime.Equals("17:30:00") && !stime.Equals("20:30:00"))
                   {
                       this.alert("选择的送样时间点错误!无法发送委托！您是厚板操作员请您选择厚板送样时间点！");
                       return "0";
                   }
               }
               else if (userid.Equals("X17020") || userid.Equals("X17019") || userid.Equals("X17038") || userid.Equals("X17028") ||
                  userid.Equals("X17044") || userid.Equals("X17036") || userid.Equals("X17034") || userid.Equals("X17009") || userid.Equals("X17011") ||
                  userid.Equals("X17047") || userid.Equals("X17039") || userid.Equals("X17030") || userid.Equals("X17026") || userid.Equals("X17010") ||
                  userid.Equals("X17037") || userid.Equals("X17040") || userid.Equals("X17045") || userid.Equals("X17033") || userid.Equals("X17041") ||
                  userid.Equals("X17014") || userid.Equals("X17021") || userid.Equals("X17027") || userid.Equals("X17052") || userid.Equals("X17012") ||
                  userid.Equals("X17017") || userid.Equals("X17018") || userid.Equals("X17032") || userid.Equals("X17053"))
               {
                   //中板操作员
                   if (!stime.Equals("03:00:00") && !stime.Equals("06:00:00") && !stime.Equals("11:00:00") && !stime.Equals("15:00:00") &&
                        !stime.Equals("18:00:00") && !stime.Equals("21:00:00"))
                   {
                       this.alert("选择的送样时间点错误!无法发送委托！您是中板操作员请您选择中板送样时间点！");
                       return "0";
                   }
               }
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                MessageBox.Show("系统出错，请联系管理人员", "警告");
            }
            return "1";
        }
        #endregion

        #endregion

        #region 其它事件
        #region 查询下拉框  取样材料号 轧批号
        private void ultraGrid1_AfterCellActivate(object sender, EventArgs e)
        {
            //this.dataSet4.Clear();
            //String heatNo = this.ultraGrid1.ActiveRow.Cells["HEAT_NO"].Value.ToString();
            //CoreClientParam ccp2 = new CoreClientParam();
            //ccp2.ServerName = "QCM.JHY01.JHY0101.QuerryQltySample";//调用java地址
            //ccp2.MethodName = "getBatchNo";//调用的方法
            //ccp2.ServerParams = new object[] { heatNo };
            //ccp2.SourceDataTable = this.dataSet4.Tables[0];
            //this.ExecuteQueryToDataTable(ccp2, CoreInvokeType.Internal);
            //ValueList VDEFECT_DESC2 = new ValueList();
            //for (int i = 0; i < ccp2.SourceDataTable.Rows.Count; i++)
            //{
            //    VDEFECT_DESC2.ValueListItems.Add(ccp2.SourceDataTable.Rows[i]["BATCH_NO"].ToString(), ccp2.SourceDataTable.Rows[i]["BATCH_NO"].ToString());
            //}
            //this.ultraGrid1.DisplayLayout.Bands[0].Columns["BATCH_NO"].ValueList = VDEFECT_DESC2;

            this.dataSet4.Clear();
            String batchNo = this.ultraGrid1.ActiveRow.Cells["BATCH_NO"].Value.ToString();
            String plineCode = this.ultraGrid1.ActiveRow.Cells["PLINE_CODE"].Value.ToString();
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "QCM.JHY01.JHY0101.QuerryQltySample";//调用java地址
            ccp.MethodName = "getBilletId";//调用的方法
            ccp.ServerParams = new object[] { batchNo, plineCode };
            ccp.SourceDataTable = this.dataSet4.Tables[0];
            this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
            ValueList VDEFECT_DESC = new ValueList();
            for (int i = 0; i < ccp.SourceDataTable.Rows.Count; i++)
            {
                VDEFECT_DESC.ValueListItems.Add(ccp.SourceDataTable.Rows[i]["MATERIAL_NO"].ToString(), ccp.SourceDataTable.Rows[i]["MATERIAL_NO"].ToString());
            }
            this.ultraGrid1.DisplayLayout.Bands[0].Columns["MATERIAL_NO"].ValueList = VDEFECT_DESC;

        }
        #endregion
        private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
        {
            int num = this.ultraGrid1.Rows.Count();
            if (num >= 1)
            {
                // this.DoQueryPrg(this.ultraGrid1.ActiveRow);//右下角
                //  this.DoQueryOrder(this.ultraGrid1.ActiveRow);//左下角

                this.dataSet4.Clear();
                String heatNo = this.ultraGrid1.ActiveRow.Cells["HEAT_NO"].Value.ToString();
                String plineCode = this.ultraGrid1.ActiveRow.Cells["PLINE_CODE"].Value.ToString();
                String batchNo = this.ultraGrid1.ActiveRow.Cells["BATCH_NO"].Value.ToString();
                String freqCode = this.ultraGrid1.ActiveRow.Cells["FREQ_CODE"].Value.ToString();
                if (freqCode.Equals("D"))
                {
                CoreClientParam ccp2 = new CoreClientParam();
                ccp2.ServerName = "QCM.JHY01.JHY0101.QuerryQltySample";//调用java地址
                ccp2.MethodName = "getBatchNo";//调用的方法
                ccp2.ServerParams = new object[] { heatNo, plineCode };
                ccp2.SourceDataTable = this.dataSet4.Tables[0];
                this.ExecuteQueryToDataTable(ccp2, CoreInvokeType.Internal);
                ValueList VDEFECT_DESC2 = new ValueList();
                for (int i = 0; i < ccp2.SourceDataTable.Rows.Count; i++)
                {
                    VDEFECT_DESC2.ValueListItems.Add(ccp2.SourceDataTable.Rows[i]["BATCH_NO"].ToString(), ccp2.SourceDataTable.Rows[i]["BATCH_NO"].ToString());
                }
                this.ultraGrid1.DisplayLayout.Bands[0].Columns["BATCH_NO"].ValueList = VDEFECT_DESC2;
                }

                Infragistics.Win.UltraWinGrid.UltraGrid uGrid = (Infragistics.Win.UltraWinGrid.UltraGrid)sender;
                string specimen_no = uGrid.ActiveRow.Cells["SPECIMEN_NO"].Text.Trim();
                string smp_no = uGrid.ActiveRow.Cells["SMP_NO"].Text.Trim();


                this.dataSet3.Tables[0].Clear();
                this.dataSet2.Tables[0].Clear();

                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "QCM.JHY01.JHY0101.QuerryQltySample";
                ccp.MethodName = "getQltySampleItemNew";
                ccp.ServerParams = new object[] { specimen_no };
                ccp.SourceDataTable = this.dataSet3.Tables[0];
                this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);



                CoreClientParam ccp1 = new CoreClientParam();
                ccp1.ServerName = "QCM.JHY01.JHY0101.QuerryQltySample";
                ccp1.MethodName = "getQltySampleOrdNew";
                ccp1.ServerParams = new object[] { smp_no };
                ccp1.SourceDataTable = this.dataSet2.Tables[0];
                this.ExecuteQueryToDataTable(ccp1, CoreInvokeType.Internal);

                //foreach (UltraGridRow ugr2 in this.ultraGrid2.Rows)
                //{
                //    ugr2.Cells["Column1"].Value = ugr2.Cells["THICK"].Value + "*" + ugr2.Cells["WIDTH"].Value + "*" + ugr2.Cells["LENGTH"].Value;
                //}

                this.dataSet4.Clear();
                CoreClientParam ccp3 = new CoreClientParam();
                ccp3.ServerName = "QCM.JHY01.JHY0101.QuerryQltySample";//调用java地址
                ccp3.MethodName = "getProcessNo";//调用的方法
                ccp3.ServerParams = new object[] { batchNo, plineCode };
                ccp3.SourceDataTable = this.dataSet4.Tables[0];
                this.ExecuteQueryToDataTable(ccp3, CoreInvokeType.Internal);
                ValueList VDEFECT_DESC3 = new ValueList();
                for (int i = 0; i < ccp3.SourceDataTable.Rows.Count; i++)
                {
                    VDEFECT_DESC3.ValueListItems.Add(ccp3.SourceDataTable.Rows[i]["RCL_STATE"].ToString(), ccp3.SourceDataTable.Rows[i]["RCL_STATE"].ToString());
                }
                this.ultraGrid1.DisplayLayout.Bands[0].Columns["PROCESS_NOS"].ValueList = VDEFECT_DESC3;
               
            }
            else
            {
                this.dataSet2.Clear();
                this.dataSet3.Clear();
            }

        }

        #region  选择tab 显示相应按钮
        private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
        {
            if (this.ultraTabControl1.SelectedTab.Index == 0)
            {
                this.ToolBarItemEnable(this, "Send", true);
                this.ToolBarItemEnable(this, "Add", true);
                this.ToolBarItemEnable(this, "AddArtificial", true);
                this.ToolBarItemEnable(this, "Unsend", false);
                this.ToolBarItemEnable(this, "Unsend19", false);
                this.ToolBarItemEnable(this, "AddWt", true);
                this.ToolBarItemEnable(this, "DelWt", true);
                this.ToolBarItemEnable(this, "DoDelete", true);
                this.ToolBarItemEnable(this, "UpBatchNo", true);
                this.ToolBarItemEnable(this, "UpRefBatchNo", true);
                this.ToolBarItemEnable(this, "DoQuote", true);
                this.ToolBarItemEnable(this, "AllUpdate", true);
                this.ToolBarItemEnable(this, "InExport", false);
                this.ToolBarItemEnable(this, "DoProcessNo", true);
                this.ToolBarItemEnable(this, "doPrint", false);
               // this.DoQuery();
            }
            else if (this.ultraTabControl1.SelectedTab.Index == 1)
            {
                this.ToolBarItemEnable(this, "Send", false);
                this.ToolBarItemEnable(this, "Add", false);
                this.ToolBarItemEnable(this, "AddArtificial", false);
                this.ToolBarItemEnable(this, "Unsend", true);
                this.ToolBarItemEnable(this, "Unsend19", true);
                this.ToolBarItemEnable(this, "AddWt", false);
                this.ToolBarItemEnable(this, "DelWt", false);
                this.ToolBarItemEnable(this, "DoDelete", false);
                this.ToolBarItemEnable(this, "UpBatchNo", false);
                this.ToolBarItemEnable(this, "UpRefBatchNo", false);
                this.ToolBarItemEnable(this, "DoQuote", false);
                this.ToolBarItemEnable(this, "AllUpdate", false);
                this.ToolBarItemEnable(this, "InExport", false);
                this.ToolBarItemEnable(this, "DoProcessNo", true);
                this.ToolBarItemEnable(this, "doPrint", true);
               // this.DoQuery();
            }
            else if (this.ultraTabControl1.SelectedTab.Index == 2)
            {
                this.ToolBarItemEnable(this, "Send", false);
                this.ToolBarItemEnable(this, "Add", false);
                this.ToolBarItemEnable(this, "AddArtificial", false);
                this.ToolBarItemEnable(this, "Unsend", false);
                this.ToolBarItemEnable(this, "Unsend19", false);
                this.ToolBarItemEnable(this, "AddWt", false);
                this.ToolBarItemEnable(this, "DelWt", false);
                this.ToolBarItemEnable(this, "DoDelete", false);
                this.ToolBarItemEnable(this, "UpBatchNo", false);
                this.ToolBarItemEnable(this, "UpRefBatchNo", false);
                this.ToolBarItemEnable(this, "DoQuote", false);
                this.ToolBarItemEnable(this, "AllUpdate", false);
                this.ToolBarItemEnable(this, "InExport", true);
                this.ToolBarItemEnable(this, "DoProcessNo", false);
                this.ToolBarItemEnable(this, "doPrint", false);
            }
            else if (this.ultraTabControl1.SelectedTab.Index == 3)
            {
                this.ToolBarItemEnable(this, "Send", false);
                this.ToolBarItemEnable(this, "Add", false);
                this.ToolBarItemEnable(this, "AddArtificial", false);
                this.ToolBarItemEnable(this, "Unsend", false);
                this.ToolBarItemEnable(this, "Unsend19", false);
                this.ToolBarItemEnable(this, "AddWt", false);
                this.ToolBarItemEnable(this, "DelWt", false);
                this.ToolBarItemEnable(this, "DoDelete", false);
                this.ToolBarItemEnable(this, "UpBatchNo", false);
                this.ToolBarItemEnable(this, "UpRefBatchNo", false);
                this.ToolBarItemEnable(this, "DoQuote", false);
                this.ToolBarItemEnable(this, "AllUpdate", false);
                this.ToolBarItemEnable(this, "InExport", false);
                this.ToolBarItemEnable(this, "DoProcessNo", false);
                this.ToolBarItemEnable(this, "doPrint", false);
            }

        }
        #endregion
        private void ultraGrid4_AfterRowActivate(object sender, EventArgs e)
        {
            // this.DoQueryPrg(this.ultraGrid4.ActiveRow);
            // this.DoQueryOrder(this.ultraGrid4.ActiveRow);
            Infragistics.Win.UltraWinGrid.UltraGrid uGrid = (Infragistics.Win.UltraWinGrid.UltraGrid)sender;
            string specimen_no = uGrid.ActiveRow.Cells["SPECIMEN_NO"].Text.Trim();
            string smp_no = uGrid.ActiveRow.Cells["SMP_NO"].Text.Trim();


            this.dataSet6.Tables[0].Clear();
            this.dataSet7.Tables[0].Clear();

            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "QCM.JHY01.JHY0101.QuerryQltySample";
            ccp.MethodName = "getQltySampleItemNew";
            ccp.ServerParams = new object[] { specimen_no };
            ccp.SourceDataTable = this.dataSet7.Tables[0];
            this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);



            CoreClientParam ccp1 = new CoreClientParam();
            ccp1.ServerName = "QCM.JHY01.JHY0101.QuerryQltySample";
            ccp1.MethodName = "getQltySampleOrdNew";
            ccp1.ServerParams = new object[] { smp_no };
            ccp1.SourceDataTable = this.dataSet6.Tables[0];
            this.ExecuteQueryToDataTable(ccp1, CoreInvokeType.Internal);

            //foreach (UltraGridRow ugr2 in this.ultraGrid2.Rows)
            //{
            //    ugr2.Cells["Column1"].Value = ugr2.Cells["THICK"].Value + "*" + ugr2.Cells["WIDTH"].Value + "*" + ugr2.Cells["LENGTH"].Value;
            //}
        }

        private void ultraGrid1_CellChange(object sender, CellEventArgs e)
        {
            ultraGrid1.UpdateData();
        }

        private void ultraGrid1_AfterHeaderCheckStateChanged(object sender, AfterHeaderCheckStateChangedEventArgs e)
        {
            ultraGrid1.UpdateData();
        }

        private void ultraGrid4_AfterHeaderCheckStateChanged(object sender, AfterHeaderCheckStateChangedEventArgs e)
        {
            ultraGrid4.UpdateData();
        }

        private void ultraGrid4_CellChange(object sender, CellEventArgs e)
        {
            ultraGrid4.UpdateData();
        }
        #endregion

        #region 右下角  删除 名称
        private void ultraGrid3_InitializeRow(object sender, InitializeRowEventArgs e)
        {
            e.Row.Cells["deletebol"].Value = "删除";
        }
        #endregion

        #region 右下角  删除
        private void ultraGrid3_ClickCellButton(object sender, CellEventArgs e)
        {
            ultraGrid3.UpdateData();
            if (e.Cell.Column.Key == "deletebol")
            {
                if (MessageBox.Show("确定要删除这一项目？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Asterisk) == DialogResult.No)
                {
                    return;
                }

                try
                {
                    CoreClientParam ccp = new CoreClientParam();
                    String seq = "";//检验项目流水号
                    String specimenNo = "";//取样编号

                    UltraGridRow row = ultraGrid3.ActiveRow;
                    if (!row.Cells["ITEM_FLAG"].Value.ToString().Equals("1"))
                    {
                        MessageBox.Show("不能删除系统生成的项目，只能删除人工生成的项目！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                        return;
                    }
                    seq = row.Cells["SEQ"].Value.ToString();
                    specimenNo = row.Cells["SPECIMEN_NO"].Value.ToString();

                    ccp.ServerName = "QCM.JHY01.JHY0102.UpdateInfo";
                    ccp.MethodName = "deleteInfo";
                    ccp.ServerParams = new object[] { seq, specimenNo };
                    ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                    if (ccp.ReturnCode != -1)
                    {
                        MessageBox.Show(ccp.ReturnInfo, "提示", MessageBoxButtons.OK, MessageBoxIcon.None);
                    }
                    this.DoQueryPrg(this.ultraGrid1.ActiveRow);
                }
                catch (Exception ex)
                {
                    System.Diagnostics.Debug.WriteLine(ex.ToString());
                    MessageBox.Show("系统出错，请联系管理人员", "警告");
                }

            }
        }
        #endregion

        #region 轧批号框勾选触发
        private void checkBox1_Click(object sender, EventArgs e)
        {
            if (this.checkBox1.Checked)
            {
                this.dateTimePicker1.Enabled = false;
                this.dateTimePicker2.Enabled = false;
                this.textBox1.Enabled = true;
                this.BATCH_NO2.Enabled = true;
            }
            else
            {//&& !this.checkBox3.Checked
                if (!this.checkBox1.Checked && !this.checkBox2.Checked  && !this.checkBox5.Checked)
                {
                this.dateTimePicker1.Enabled = true;
                this.dateTimePicker2.Enabled = true;
                }
                this.textBox1.Enabled = false;
                this.BATCH_NO2.Enabled = false;
            }
        }

        private void checkBox2_Click(object sender, EventArgs e)
        {
            if (this.checkBox2.Checked)
            {
                this.dateTimePicker1.Enabled = false;
                this.dateTimePicker2.Enabled = false;
                this.selheatNo.Enabled = true;
            }
            else
            {//&& !this.checkBox3.Checked
                if (!this.checkBox1.Checked && !this.checkBox2.Checked  && !this.checkBox5.Checked)
                {
                    this.dateTimePicker1.Enabled = true;
                    this.dateTimePicker2.Enabled = true;
                }
                this.selheatNo.Enabled = false;
            }
        }

        private void checkBox3_Click(object sender, EventArgs e)
        {
            if (this.checkBox3.Checked)
            {
                //this.dateTimePicker1.Enabled = false;
                //this.dateTimePicker2.Enabled = false;
                this.sel_design_key.Enabled = true;
            }
            else
            {
                //if (!this.checkBox1.Checked && !this.checkBox2.Checked && !this.checkBox3.Checked)
                //{
                //    this.dateTimePicker1.Enabled = true;
                //    this.dateTimePicker2.Enabled = true;
                //}
                this.sel_design_key.Enabled = false;
            }
        }

        private void checkBox4_Click(object sender, EventArgs e)
        {
            if (this.checkBox4.Checked)
            {
                this.SAMPLE_DELIVERY_TIME2.Enabled = true;
                this.dateTimePicker4.Enabled = true;
            }
            else
            {
                this.SAMPLE_DELIVERY_TIME2.Enabled = false;
                this.dateTimePicker4.Enabled = false;
            }
        }
        private void checkBox5_Click(object sender, EventArgs e)
        {
            if (this.checkBox5.Checked)
            {
                this.dateTimePicker1.Enabled = false;
                this.dateTimePicker2.Enabled = false;
                this.textBox3.Enabled = true;
            }
            else
            {//&& !this.checkBox3.Checked
                if (!this.checkBox1.Checked && !this.checkBox2.Checked  && !this.checkBox5.Checked)
                {
                    this.dateTimePicker1.Enabled = true;
                    this.dateTimePicker2.Enabled = true;
                }
                this.textBox3.Enabled = false;
            }
        }

        #endregion


        #region 子板号 热处理号
        private void ultraGrid4_AfterCellActivate(object sender, EventArgs e)
        {
            this.dataSet4.Clear();
            String batchNo = this.ultraGrid4.ActiveRow.Cells["BATCH_NO"].Value.ToString();
            String plineCode = this.ultraGrid4.ActiveRow.Cells["PLINE_CODE"].Value.ToString(); 
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "QCM.JHY01.JHY0101.QuerryQltySample";//调用java地址
            ccp.MethodName = "getBilletId";//调用的方法
            ccp.ServerParams = new object[] { batchNo, plineCode };
            ccp.SourceDataTable = this.dataSet4.Tables[0];
            this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
            ValueList VDEFECT_DESC = new ValueList();
            for (int i = 0; i < ccp.SourceDataTable.Rows.Count; i++)
            {
                VDEFECT_DESC.ValueListItems.Add(ccp.SourceDataTable.Rows[i]["MATERIAL_NO"].ToString(), ccp.SourceDataTable.Rows[i]["MATERIAL_NO"].ToString());
            }
            this.ultraGrid4.DisplayLayout.Bands[0].Columns["MATERIAL_NO"].ValueList = VDEFECT_DESC;

           
            this.dataSet4.Clear();
            CoreClientParam ccp2 = new CoreClientParam();
            ccp2.ServerName = "QCM.JHY01.JHY0101.QuerryQltySample";//调用java地址
            ccp2.MethodName = "getProcessNo";//调用的方法
            ccp2.ServerParams = new object[] { batchNo, plineCode };
            ccp2.SourceDataTable = this.dataSet4.Tables[0];
            this.ExecuteQueryToDataTable(ccp2, CoreInvokeType.Internal);
            ValueList VDEFECT_DESC2 = new ValueList();
            for (int i = 0; i < ccp2.SourceDataTable.Rows.Count; i++)
            {
                VDEFECT_DESC2.ValueListItems.Add(ccp2.SourceDataTable.Rows[i]["RCL_STATE"].ToString(), ccp2.SourceDataTable.Rows[i]["RCL_STATE"].ToString());
            }
            this.ultraGrid4.DisplayLayout.Bands[0].Columns["PROCESS_NOS"].ValueList = VDEFECT_DESC2;
            
        }
        #endregion


        #region 颜色

        private void ultraGrid4_InitializeRow(object sender, InitializeRowEventArgs e)
        {
            //预测抽样
            //if (!String.IsNullOrEmpty(e.Row.Cells["RZ_OLD_SAMPL_NO"].Value.ToString()))
            //{
            //    e.Row.Appearance.BackColor = Color.FromArgb(128, 255, 255);//浅蓝色
            //}
            if (e.Row.Cells["SHOULD_SAMPLE"].Value.ToString().Equals("Y") || e.Row.Cells["SHOULD_SAMPLE"].Value.ToString().Contains("Y(抽样)"))
            {
                e.Row.Appearance.BackColor = Color.FromArgb(128, 255, 255);//浅蓝色
            }
            if (e.Row.Cells["RZ_OLD_SAMPL_NO"].Value.ToString().Equals(e.Row.Cells["SPECIMEN_NO"].Value.ToString()))
            {
                e.Row.Appearance.ForeColor = Color.Red;
            }

            //LAR送样
            if (!String.IsNullOrEmpty(e.Row.Cells["SPECIAL_QUOTE_MEMO"].Value.ToString()) && e.Row.Cells["STEEL_NAME"].Value.ToString().Contains("LRA"))
            {
                e.Row.Appearance.BackColor = Color.LightGoldenrodYellow;//黄色
            }

        }

        private void ultraGrid1_InitializeRow(object sender, InitializeRowEventArgs e)
        {
            //LAR送样
            if (!String.IsNullOrEmpty(e.Row.Cells["SPECIAL_QUOTE_MEMO"].Value.ToString()) && e.Row.Cells["STEEL_NAME"].Value.ToString().Contains("LRA"))
            {
                e.Row.Appearance.BackColor = Color.LightGoldenrodYellow;//黄色
            }

            //性能预测
            if (e.Row.Cells["SHOULD_SAMPLE"].Value.ToString().Equals("Y") || e.Row.Cells["SHOULD_SAMPLE"].Value.ToString().Contains("Y(抽样)"))
            {
                e.Row.Appearance.BackColor = Color.FromArgb(128, 255, 255);//浅蓝色
            }

            if (e.Row.Cells["SHOULD_SAMPLE"].Value.ToString().Contains("Y(抽样)"))
            {
                e.Row.Appearance.ForeColor = Color.Red;
            }
        }

        private void ultraGrid8_InitializeRow(object sender, InitializeRowEventArgs e)
        {
            //LIMS退回轧批
            if (!e.Row.Cells["STATUS"].Text.ToString().Equals("未发送"))
            {
                e.Row.Appearance.BackColor = Color.LightGreen;//浅绿
            }
        }
        #endregion

   

        //private void ultraGrid7_AfterRowExpanded(object sender, RowEventArgs e)
        //{
        //    try{
        //        if (e.Row == null)
        //            return;

        //        if (e.Row.Band.Index == 0 && !e.Row.HasParent())
        //        {
        //            string specimen_no = Convert.ToString(e.Row.Cells["取样编号"].Value);
        //            if (!string.IsNullOrEmpty(specimen_no))
        //            {
        //                CoreClientParam ccp = new CoreClientParam();
        //                ccp.ServerName = "QCM.JHY01.JHY0101.QuerryQltySample";
        //                ccp.MethodName = "getQltySampleItemNew2";
        //                ccp.ServerParams = new object[] { specimen_no };
        //                ccp.SourceDataTable = this.dataSet8.Tables[1];

        //                ultraGrid7.BeginUpdate();
        //                //重绘控件直到endupdate 不会每次就重绘控件 避免闪烁
        //                for (int idx = this.dataTable9.Rows.Count - 1; idx >= 0; idx--)
        //                {
        //                    if (Convert.ToString(this.dataTable9.Rows[idx]["取样编号"]) == specimen_no)
        //                        this.dataTable9.Rows[idx].Delete();
        //                }
        //                this.dataTable9.AcceptChanges();
        //                this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
        //                // ClsControlPack.RefreshAndAutoSize(ultraGrid7);
        //                ultraGrid7.EndUpdate();
        //            }
        //        }
        //     }
        //    catch (Exception ex)
        //    {
        //        System.Diagnostics.Debug.WriteLine(ex.ToString());
        //        MessageBox.Show("系统出错，请联系管理人员", "警告");
        //    }
        //}



        #region 表中的列  值改变触发
        //private void ultraGrid1_AfterCellUpdate(object sender, CellEventArgs e)
        //{
        //    Boolean bl = true;
        //    if (this.CustomInfo == "GX" || this.CustomInfo == "BC2" || this.CustomInfo == "GB")
        //    {
        //        UltraGridRow row = this.ultraGrid1.ActiveRow;
        //        if (row == null || "".Equals(row))
        //        {
        //            return;
        //        }
        //        String sendMemoValeu = row.Cells["SEND_MEMO"].Value.ToString();
        //        if (sendMemoValeu.Equals("A") || sendMemoValeu.Equals("B") || sendMemoValeu.Equals("C"))
        //        {
        //            String BATCH_NO = row.Cells["BATCH_NO"].Value.ToString();
        //            String SPECIMEN_NO = row.Cells["SPECIMEN_NO"].Value.ToString();
        //            String phyname = row.Cells["PHY_NAME_L_bj"].Value.ToString();
        //            String sendMemo = row.Cells["SEND_MEMO"].Text.ToString();
        //            //金相
        //            if (sendMemoValeu.Equals("A"))
        //            {
        //                if (phyname.Contains(sendMemo))
        //                {
        //                    bl = false;
        //                }
        //                if (bl)
        //                {
        //                    this.alert("轧批号【" + BATCH_NO + "】取样编号【" + SPECIMEN_NO + "】不包含：【" + sendMemo + "】");
        //                }
        //            }
        //            //重量偏差
        //            if (sendMemoValeu.Equals("B"))
        //            {
        //                if (phyname.Contains("其他"))
        //                {
        //                    bl = false;
        //                }
        //                if (bl)
        //                {
        //                    this.alert("轧批号【" + BATCH_NO + "】取样编号【" + SPECIMEN_NO + "】不包含：【" + sendMemo + "】");
        //                }
        //            }
        //            //金相&重量偏差
        //            if (sendMemoValeu.Equals("C"))
        //            {
        //                if (phyname.Contains("其他") && phyname.Contains("金相"))
        //                {
        //                    bl = false;
        //                }
        //                if (bl)
        //                {
        //                    this.alert("轧批号【" + BATCH_NO + "】取样编号【" + SPECIMEN_NO + "】需包含：【" + sendMemo + "】两个项目,请检查是否包含！！！");
        //                }
        //            }

        //        }
        //    }



        //}
        #endregion

        #region 轧批号
        //textbox获得焦点
        //private void textBox1_Enter(object sender, EventArgs e)
        //{
        //    if (textboxHasText == false) {
        //        this.textBox1.Text = "";
        //        this.BATCH_NO2.Text = "";
        //    }
        //    this.textBox1.ForeColor = Color.Black;
        //    this.BATCH_NO2.ForeColor = Color.Black;
        //}
        //textbox获得焦点
        //private void textBox1_Leave(object sender, EventArgs e)
        //{
        //    if (textBox1.Text == "")
        //    {
        //        textBox1.Text = "输入轧批号后四位";
        //        textBox1.ForeColor = Color.LightGray;

        //        this.BATCH_NO2.Text = "输入轧批号后四位";
        //        this.BATCH_NO2.ForeColor = Color.LightGray;
        //        textboxHasText = false;
        //    }
        //    else
        //        textboxHasText = true;
        //}



        #endregion




    }
}