XinYu_LZMES_Client/Core.LZMes.Client.QCM/QCM02/QCM0201RZ.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;
using System.Diagnostics;


namespace Core.LZMes.Client.QCM
{
    public partial class QCM0201RZ : 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 QCM0201RZ()
        {
            InitializeComponent();
        }

        private void QCM0201RZ_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();

            //ValueList v3 = new ValueList();
            //v3.ValueListItems.Add("", "");
            //v3.ValueListItems.Add("A", "金相");
            //v3.ValueListItems.Add("B", "重量偏差");
            //v3.ValueListItems.Add("C", "金相&重量偏差");
            //this.ultraGrid1.DisplayLayout.Bands[0].Columns["SEND_MEMO"].ValueList = v3.Clone();
            //this.ultraGrid4.DisplayLayout.Bands[0].Columns["SEND_MEMO"].ValueList = v3.Clone();

            if (!this.checkBox1.Checked)
            {
                this.textBox1.Enabled = false;
                this.BATCH_NO2.Enabled = false;
            }
           // this.DoQuery();

        }
        #endregion

        #region 功能
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    this.DoQuery();
                    break;
                case "Send":
                    this.DoSend();//发送委托
                    break;
                case "SendRZ":
                    this.DoSendRZ();//热轧 组批区间  人工抽样
                    break;
                case "Unsend":
                    this.DoUnsend();//撤销委托
                    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 "DoEject":
                    this.DoEject();//卷板质量异常处理
                    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 "CleanUpMixRoll":
                    this.CleanUpMixRoll();//清空库存组批区间
                    break;
                case "doPrint":
                    this.doPrint();//打印
                    break;
                case "SendJG":
                    this.DoSendJG();//补发激光
                    break;
                case "ForecastRZ":
                    this.DoForecastRZ();//预测换样
                    break;
                case "InExport":
                     this.InExcel();//导出
                    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;
                    //二维码内容
                    //" 子板:" + materialNo +"轧批:" + batchNO + " 钢种:" + steelName + " 规格:" + thck +  " 项目:" + phyNameLbj+ " 序号:" + PRINT_SEQV
                    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;//设置二维码的版本，默认7
                    }
                    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)
        {
           // e.Graphics.TranslateTransform(135, 255);
            //e.Graphics.RotateTransform(90.0F);
            Graphics grfx = e.Graphics;
            
                //grfx.DrawString(v_BATCH_NO, new Font("宋体", 20), Brushes.Black, 125, 366);//打印内容、字体、颜色、X、Y 
                //grfx.DrawImage(image2, 135, 255, 120, 110);//图片、X、Y、宽、高 

                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、宽、高 
            //if (lennum <= 90)
            //{
            //}
            //else
            //{
            //    //grfx.DrawString(v_BATCH_NO, new Font("宋体", 16), Brushes.Black, 125, 370);
            //    //grfx.DrawImage(image2, 120, 250, 140, 120);
            //}

           
        }
        #endregion

        #endregion

        #region 功能方法

        #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(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 修改取样材料号
        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());
                        materialNo.Add(ugr.Cells["OLD_SAMPL_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
            {
                UltraGridRow row = this.ultraGrid1.ActiveRow;
                //if (row == null)
                //{
                //    this.alert("检验委托为空！请选择检验委托数据!!!");
                //    return;
                //}
                //if (!String.IsNullOrEmpty(row.Cells["MIXROLL"].Text.ToString()))
                //{
                //    this.alert("组批区间不为空!!!");
                //    return;
                //}
                Hashtable ht = new Hashtable();
                if(row != null){
                    ht.Add("BATCH_NO", row.Cells["BATCH_NO"].Text.ToString());
                }

                QCM0205 frmRbp = new QCM0205();
                frmRbp.StartPosition = FormStartPosition.CenterScreen;
                frmRbp.ob = this.ob;
                frmRbp.plineCode = "RZ1";
                frmRbp.hashTable = ht;
                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;
                }

                if (!row.Cells["STATUS"].Value.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 = "RZ1";
                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 (!ugr.Cells["STATUS"].Value.ToString().Equals("未发送"))
                    {
                        this.alert("请选择状态为未发送的委托！！！");
                        return;
                    } 
                }
                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;
                    }
                    String status = ugr.Cells["STATUS"].Value.ToString();
                    if (!status.Equals("0") && !status.Equals("未发送") && !String.IsNullOrEmpty(status))
                    {
                        this.alert("当前委托状态不为未发送");
                        return;
                    }
                }
                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")
                    {

                        if (!ugr.Cells["STATUS"].Value.ToString().Equals("未发送"))
                        {
                            this.alert("请选择状态为未发送的委托！！！");
                            return;
                        } 

                        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());//取样编号
                        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 DoQuery()
        {
            try
            {
               if (this.ultraTabControl1.Tabs[2].Selected)
               {
                   DoQueryRZ();//异常取样卷界面
                   return;
               }
                String checkboxVal = "";
                String STARTTIME = "";
                String ENDTIME = "";
                if (this.ultraTabControl1.Tabs[1].Selected)
                {
                    STARTTIME = this.dateTimePicker1.Value.ToString("yyyy-MM-dd");
                    ENDTIME = this.dateTimePicker2.Value.ToString("yyyy-MM-dd");
                }
                else
                {
                     STARTTIME = this.dateTimePicker1.Value.ToString("yyyyMMdd");
                     ENDTIME = this.dateTimePicker2.Value.ToString("yyyyMMdd");
                }
                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 = "";
                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 ROLL_MANA_NO = this.ROLL_MANA_NO.Text.Trim();
                String heatNo = this.selheatNo.Text.Trim();
                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 == "BC2")
                {
                    PLINE_NAME = "棒二线";
                }
                else if (this.CustomInfo == "GX")
                {
                    PLINE_NAME = "高线";
                }
                else if (this.CustomInfo == "GB")
                {
                    PLINE_NAME = "高棒线";
                }
                else if (this.CustomInfo == "RZ")
                {
                    PLINE_NAME = "热轧";
                }
                else if (this.CustomInfo == "LT")
                {
                    PLINE_NAME = "连退";
                }
                else 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 (!string.IsNullOrEmpty(BATCH_NO2))
                {
                    if (string.IsNullOrEmpty(BATCH_NO))
                    {
                        this.alert("请输入轧批号！！！");
                        this.textBox1.Focus();
                        return;
                    }
                }

                //炉号  小框框 是否勾选
                if (this.checkBox2.Checked)
                {
                    checkboxVal = "1";
                    STARTTIME = "";
                    ENDTIME = "";
                }
                else
                {
                    heatNo = "";
                }

                //轧辊单元  小框框 是否勾选
                if (this.checkBox3.Checked)
                {
                    checkboxVal = "1";
                    STARTTIME = "";
                    ENDTIME = "";
                }
                else
                {
                    ROLL_MANA_NO = "";
                }

                CoreClientParam ccp = new CoreClientParam();
                if (this.ultraTabControl1.Tabs[0].Selected) //检验委托
                {
                    this.dataSet1.Clear();
                    ccp.ServerName = "QCM.JHY01.JHY0101.QuerryQltySample";
                    ccp.MethodName = "getQltySampleInfoRZ";
                    ccp.SourceDataTable = this.dataSet1.Tables[0];
                }
                else if (this.ultraTabControl1.Tabs[1].Selected)
                {
                    this.dataSet5.Clear();
                    ccp.ServerName = "QCM.JHY01.JHY0101.QuerryQltySample";
                    ccp.MethodName = "getQltySampleInfoRZ2";
                    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);
                ht.Add("HEAT_NO", heatNo);
                if (this.ultraTabControl1.Tabs[0].Selected)
                {
                    ht.Add("STATUS", "0");
                }
                if (this.ultraTabControl1.Tabs[1].Selected)
                {
                    ht.Add("TAB_NAME", "1");
                }
                ht.Add("STEEL_NAME", STEEL_NAME);
                ht.Add("SMP_CATG", SMP_CATG);
                ht.Add("ROLL_MANA_NO", ROLL_MANA_NO);

                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["OLD_SAMPL_NO"].Value.ToString().Equals(ugr.Cells["MATERIAL_NO"].Value.ToString()))
                        {
                            ugr.Cells["SAMPL_PICK_RY"].Value = null;
                        }
                    }

                    int num = this.ultraGrid1.Rows.Count();
                    if (num <= 0)
                    {
                        this.dataSet3.Clear();
                    }
                    foreach (Infragistics.Win.UltraWinGrid.UltraGridRow ugr in ultraGrid1.Rows)
                    {
                        if (ugr.Cells["MIXFLAG"].Value.ToString().Equals("1"))
                        {
                            ugr.Cells["OLD_SAMPL_NO"].Appearance.BackColor = Color.LightGreen;//钢卷号建议抽样卷
                        }
                    }
                }
                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;
                        }
                    }

                    int num = this.ultraGrid4.Rows.Count();
                    if (num <= 0)
                    {
                        this.dataSet6.Clear();
                    }
                }
               
                //foreach (Infragistics.Win.UltraWinGrid.UltraGridRow ugr in ultraGrid4.Rows)
                //{
                //    if (ugr.Cells["MIXFLAG"].Value.ToString().Equals("1"))
                //    {
                //        ugr.Cells["OLD_SAMPL_NO"].Appearance.BackColor = Color.LightGreen;
                //    }
                //}
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                MessageBox.Show("系统出错，请联系管理人员", "警告");
            }

        }

        private void DoQueryRZ()
        {
            try
            {

                String checkboxVal = "";
                String STARTTIME = "";
                String ENDTIME = "";
                STARTTIME = this.dateTimePicker1.Value.ToString("yyyyMMdd");
                ENDTIME = this.dateTimePicker2.Value.ToString("yyyyMMdd");

                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 = "热轧";
                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 ROLL_MANA_NO = this.ROLL_MANA_NO.Text.Trim();
                String heatNo = this.selheatNo.Text.Trim();
                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.checkBox1.Checked)
                {
                    checkboxVal = "1";
                    STARTTIME = "";
                    ENDTIME = "";
                }
                else
                {
                    BATCH_NO = "";
                    BATCH_NO2 = "";
                }
                if (!string.IsNullOrEmpty(BATCH_NO2))
                {
                    if (string.IsNullOrEmpty(BATCH_NO))
                    {
                        this.alert("请输入轧批号！！！");
                        this.textBox1.Focus();
                        return;
                    }
                }

                //炉号  小框框 是否勾选
                if (this.checkBox2.Checked)
                {
                    checkboxVal = "1";
                    STARTTIME = "";
                    ENDTIME = "";
                }
                else
                {
                    heatNo = "";
                }

                //轧辊单元  小框框 是否勾选
                if (this.checkBox3.Checked)
                {
                    checkboxVal = "1";
                    STARTTIME = "";
                    ENDTIME = "";
                }
                else
                {
                    ROLL_MANA_NO = "";
                }

                CoreClientParam ccp = new CoreClientParam();
                this.dataSet8.Clear();
                ccp.ServerName = "QCM.JHY01.JHY0101.QuerryQltySample";
                ccp.MethodName = "getQCMRZYZ";
                ccp.SourceDataTable = this.dataSet8.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);
                ht.Add("HEAT_NO", heatNo);
                ht.Add("STEEL_NAME", STEEL_NAME);
                ht.Add("SMP_CATG", SMP_CATG);
                ht.Add("ROLL_MANA_NO", ROLL_MANA_NO);

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


                this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);

                if (this.ultraTabControl1.Tabs[2].Selected) 
                {
                    List<UltraGridRow> lists = new List<UltraGridRow>();
                    foreach (UltraGridRow ugr in this.ultraGrid2.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["OLD_SAMPL_NO"].Value.ToString().Equals(ugr.Cells["MATERIAL_NO"].Value.ToString()))
                        {
                            ugr.Cells["SAMPL_PICK_RY"].Value = null;
                        }
                        //if (ugr.Cells["MIXFLAG"].Value.ToString().Equals("1"))
                        //{
                        //    ugr.Cells["OLD_SAMPL_NO"].Appearance.BackColor = Color.LightGreen;
                        //}

                        if (!string.IsNullOrEmpty(ugr.Cells["JHQ_STATUS"].Value.ToString()))
                        {
                        int jhqnum=int.Parse(ugr.Cells["JHQ_STATUS"].Value.ToString());
                        if (12 < jhqnum)
                        {
                            if (jhqnum <= 72)
                            {
                                ugr.Appearance.BackColor = Color.Yellow;
                            }else if (jhqnum > 240)
                            {
                                lists.Add(ugr);
                            }
                        }
                        else if (jhqnum <= 12)
                        {
                            ugr.Appearance.BackColor = Color.Red;
                        }

                        }
                    }
                    for (int i = 0; i < lists.Count; i++)
                    {
                       lists[i].Delete(false);
                    }
                    int num = this.ultraGrid2.Rows.Count();
                    if (num <= 0)
                    {
                        this.dataSet8.Clear();
                    }
                }

            }
            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
            {
               

                CoreClientParam ccp = new CoreClientParam();
                string SPECIMEN_NO = "";
                string fh = "";
                int num = 0;
                String mixroll2 = "0";
                foreach (UltraGridRow ugr in this.ultraGrid1.Rows)
                {
                    string specimeNo = "";
                    if (ugr.Cells["CHK"].Value.ToString().ToLower() == "true")
                    {
                        if (string.IsNullOrEmpty(ugr.Cells["STATUS"].Value.ToString()))
                        {
                            this.alert("委托不存在");
                            return;
                        }

                        if (!ugr.Cells["STATUS"].Value.ToString().Equals("未发送"))
                        {
                            this.alert("请选择状态为未发送的委托！！！");
                            return;
                        } 

                        String mixroll = ugr.Cells["MIXROLL"].Value.ToString();
                        String smpTypeName = ugr.Cells["SMP_TYPE_NAME"].Value.ToString();
                        String txt_DESIGN_KEY = ugr.Cells["DESIGN_KEY"].Value.ToString();
                        String txtDK = txt_DESIGN_KEY.Substring(0, 2);
                        if (!String.IsNullOrEmpty(mixroll) && smpTypeName.Equals("初样") && !"39".Equals(txtDK) && !"49".Equals(txtDK) && !"59".Equals(txtDK))
                        {
                            mixroll2 = "1";
                            this.alert("预测产品，请进行抽样操作！");
                            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;
                        }
                    }
                }
                DoUpdate();//先修改取样材料号
                //if (mixroll2.Equals("1"))
                //{
                //    if (MessageBox.Show("组匹区间不为空！建议使用【预测抽样】按钮,而不是【发送检验委托】按钮,如继续执行【发送检验委托】按钮程序点击【是】，停止则点击【否】", "提示",
                //        MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
                //    {
                //        return;
                //    }

                //}

                ccp.ServerName = "QCM.JHY01.JHY0102.Send2";
                ccp.MethodName = "SendLIMES";
                ccp.ServerParams = new object[] { SPECIMEN_NO, this.UserInfo.GetUserID(), this.UserInfo.GetUserName(), " " };
                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.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 DoSendRZ()
        {
            try
            {
                if (this.CustomInfo != "RZ") {
                    this.alert("只能热轧产线可使用人工抽样按钮！");
                    return;
                }

                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")
                    {
                        String mixroll = ugr.Cells["MIXROLL"].Value.ToString();
                        if (mixroll == null || mixroll.Equals(""))
                        {
                            this.alert("非预测品种，不允许预测抽样");
                            return;
                        }
                        if (!ugr.Cells["STATUS"].Value.ToString().Equals("未发送"))
                        {
                            this.alert("请选择状态为未发送的委托！！！");
                            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;
                        }
                    }
                }
                if(num>=2){
                   this.alert("请勾选一条钢卷号做为预测抽样,预测抽样不可勾选多条数据!!!");
                   return;
                }

                DoUpdate();//先修改取样材料号
                
                String GroupBatch = "1";//组批标识
                ccp.ServerName = "QCM.JHY01.JHY0102.Send2";
                ccp.MethodName = "SendLimesRZ";
                ccp.ServerParams = new object[] { SPECIMEN_NO, this.UserInfo.GetUserID(), this.UserInfo.GetUserName(), GroupBatch,"热轧" };
                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.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;
                }

                String zhyy = "MES撤回";
                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")
                    {
                        String rzEntrustNumber = ugr.Cells["RZ_ENTRUST_NUMBER"].Value.ToString();
                        //判断是否是热轧 预测抽样
                        if (!String.IsNullOrEmpty(rzEntrustNumber))
                        {
                            this.alert("【预测抽样】的委托只能用【撤销抽样】按钮撤销！");
                            return;
                        }
                        String QRZ_SPECIMEN_NO = ugr.Cells["QRZ_SPECIMEN_NO"].Value.ToString();
                        if (!String.IsNullOrEmpty(QRZ_SPECIMEN_NO))
                        {
                            this.alert("轧批号:" + ugr.Cells["BATCH_NO"].Value.ToString() + "为人工选样不可撤销!");
                            return;
                        }
                        String status = ugr.Cells["STATUS"].Value.ToString();
                        if (status.Equals("0") || status.Equals("未发送") || String.IsNullOrEmpty(status))
                        {
                            this.alert("当前委托未发送、不可撤销");
                            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;
                        }
                    }
                }

                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)
                {
                    MessageBox.Show("撤销发送成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.None);//ccp.ReturnInfo "发送成功" ccp.ReturnInfo
                }
                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 DoUnsendRZ()
        {
            try
            {
                //if (!this.ultraTabControl1.SelectedTab.Text.Equals("委托记录"))
                //{
                //    this.alert("请在委托记录中勾选要撤销的人工抽样委托！");
                //    return;
                //}
                if (MessageBox.Show("确认撤销人工抽样?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
                {
                    return;
                }

                UltraGridRow row = ultraGrid1.ActiveRow;
                String oldSamplNo = row.Cells["OLD_SAMPL_NO"].Value.ToString();//钢卷号
                String rzOldSamplNo = row.Cells["RZ_ENTRUST_NUMBER"].Value.ToString();//抽样钢卷号
                if (!oldSamplNo.Equals(rzOldSamplNo) || String.IsNullOrEmpty(rzOldSamplNo))
                {
                    this.alert("请选择预测抽样的钢卷号撤销抽样！预测抽样钢卷号【" + rzOldSamplNo + "】");
                    return;
                }

                String zhyy = "MES撤回热轧预测抽样";
                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")
                    {
                        String status = ugr.Cells["STATUS"].Value.ToString();
                        String QRZ_SPECIMEN_NO = ugr.Cells["QRZ_SPECIMEN_NO"].Value.ToString();
                        if (status.Equals("0") || status.Equals("未发送") || String.IsNullOrEmpty(status))
                        {
                            this.alert("当前委托未发送、不可撤销");
                            return;
                        }
                        else if (!String.IsNullOrEmpty(QRZ_SPECIMEN_NO))
                        {
                            this.alert("轧批号:" + ugr.Cells["BATCH_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;
                        }
                    }
                }
                if (num > 1)
                {
                    this.alert("撤销预测抽样、只能一条预测抽样撤销");
                    return;
                }
                ccp.ServerName = "QCM.JHY01.JHY0102.Send2";
                ccp.MethodName = "CancelLIMESRZ";
                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.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 DoEject()
        {
            QCM0307 frmRbp = new QCM0307();
            frmRbp.StartPosition = FormStartPosition.CenterScreen;
            frmRbp.ob = this.ob;
            frmRbp.ShowDialog();
        }
        #endregion

        #region 清空组批区间
        private void CleanUpMixRoll()
        {
            int num = 0;
            foreach (UltraGridRow ugr in this.ultraGrid1.Rows)
            {
           
                if (ugr.Cells["CHK"].Value.ToString().ToLower() == "true")
                {
                    String mixroll = ugr.Cells["MIXROLL"].Value.ToString();
                    String smpTypeName = ugr.Cells["SMP_TYPE_NAME"].Value.ToString();

                    if (string.IsNullOrEmpty(mixroll))
                    {
                        this.alert("当前轧批组批区间已为空!");
                        return;
                    }

                    if (string.IsNullOrEmpty(ugr.Cells["STATUS"].Value.ToString()))
                    {
                        this.alert("委托不存在!");
                        return;
                    }

                    if (!ugr.Cells["STATUS"].Value.ToString().Equals("未发送"))
                    {
                        this.alert("请选择状态为未发送的委托！！！");
                        return;
                    }

                    num = num + 1;
                }
            }

            if (num != 1)
            {
                this.alert("要勾选委托并且只能勾选一个委托的轧批号!");
                return;
            }

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

            if (!row.Cells["SMP_CATG"].Text.ToString().Equals("材质"))
            {
                this.alert("只有材质数据才可以清空!!!");
                return;
            }
            String batchNo = row.Cells["BATCH_NO"].Text.ToString();
            if (MessageBox.Show("确认清除当前轧批号【" + batchNo + "】组批区间？清空组批区间是按批清空", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
            {
                return;
            }

            String MATERIAL_NO = row.Cells["MATERIAL_NO"].Value.ToString();
            String BATCH_NO = row.Cells["BATCH_NO"].Value.ToString();
            String PLINE_CODE = row.Cells["PLINE_CODE"].Value.ToString();
            String MIXROLL = row.Cells["MIXROLL"].Value.ToString();
            String OLD_SAMPL_NO = row.Cells["OLD_SAMPL_NO"].Value.ToString();
            Hashtable ht = new Hashtable();
            ht.Add("OLD_SAMPL_NO", OLD_SAMPL_NO);
            ht.Add("MATERIAL_NO", MATERIAL_NO);
            ht.Add("BATCH_NO", BATCH_NO);
            ht.Add("MIXROLL", MIXROLL);
            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 = "DoCleanUpMixRoll";
            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 DoSendJG()
        {
            try
            {
                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")
                    {
                        if (string.IsNullOrEmpty(ugr.Cells["PRINT_SEQ"].Value.ToString()))
                        {
                            String OLD_SAMPL_NO = ugr.Cells["OLD_SAMPL_NO"].Value.ToString();
                            this.alert("钢卷号:" + OLD_SAMPL_NO+"未发送,不能使用补发功能,请核实数据!");
                            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;
                        }
                    }
                }
                if (num==0)
                {
                    this.alert("请勾选数据!!!");
                    return;
                }
                Hashtable ht = new Hashtable();
                ht.Add("USER_ID", this.UserInfo.GetUserID());
                ht.Add("USER_NAME", this.UserInfo.GetUserName());

                ccp.ServerName = "QCM.JHY01.JHY0102.Send2";
                ccp.MethodName = "SendJG";
                ccp.ServerParams = new object[] { SPECIMEN_NO, this.UserInfo.GetUserID(), this.UserInfo.GetUserName(), ht };
                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)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                MessageBox.Show("系统出错，请联系管理人员", "警告");
            }
        }
        #endregion

        #region 预测换样
        private void DoForecastRZ()
        {
            try
            {
                int i = 0;
                foreach (UltraGridRow ugr in this.ultraGrid1.Rows)
                {
                    if (ugr.Cells["CHK"].Value.ToString().ToLower() == "true")
                    {
                        i++;
                    }
                }
                if(i==0){
                    this.alert("未勾选数据!");
                    return;
                }else if (i>=2){
                    this.alert("您勾选了多条数据,请勾选一条数据,勾选当前轧辊单元组批区间的抽样钢卷号,红色字体那条!");
                    return;
                }

                UltraGridRow row = this.ultraGrid1.ActiveRow;
                String OLD_SAMPL_NO = row.Cells["OLD_SAMPL_NO"].Value.ToString();//钢卷号
                String ROLL_MANA_NO = row.Cells["ROLL_MANA_NO"].Value.ToString();//轧辊单元
                String MIXROLL = row.Cells["MIXROLL"].Value.ToString();//组批区间
                String RZ_ENTRUST_NUMBER = row.Cells["RZ_ENTRUST_NUMBER"].Value.ToString();//抽样钢卷号
                String BATCH_NO = row.Cells["BATCH_NO"].Value.ToString();//轧批号
                String STATUS = row.Cells["STATUS"].Text.ToString();//状态
                String SAMPL_PICK_RY = row.Cells["SAMPL_PICK_RY"].Value.ToString();//有无取样
                String SPECIMEN_NO = row.Cells["SPECIMEN_NO"].Value.ToString();//取样编号

                if (OLD_SAMPL_NO.Equals(RZ_ENTRUST_NUMBER) && SAMPL_PICK_RY.Equals("R") && STATUS.Equals("已完成"))
                {
                    if (MessageBox.Show("是否确认轧辊单元【" + ROLL_MANA_NO + "】组批区间【" + MIXROLL + "】轧批号【" + BATCH_NO + "】"+
                        "不合格,需从新在组距内钢卷重新挑卷预测抽样",
                        "提示",
                       MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
                    {
                        return;
                    }
                    CoreClientParam ccp = new CoreClientParam();
                    Hashtable ht = new Hashtable();
                    ht.Add("BATCH_NO", BATCH_NO);
                    ht.Add("SPECIMEN_NO", SPECIMEN_NO);
                    ht.Add("USER_ID", this.UserInfo.GetUserID());
                    ht.Add("USER_NAME", this.UserInfo.GetUserName());

                    ccp.ServerName = "QCM.JHY01.JHY0102.UpdateInfo";
                    ccp.MethodName = "doForecastRZ";
                    ccp.ServerParams = new object[] { ht };
                    ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                    if (ccp.ReturnCode != -1)
                    {
                        MessageBox.Show("操作成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.None);//ccp.ReturnInfo "发送成功" ccp.ReturnInfo
                    }
                    this.DoQuery();
                }
                else
                {
                    this.alert("操作失败!请核实当前预测抽样数据!轧辊单元【" + ROLL_MANA_NO + "】组批区间【" + MIXROLL + "】");
                    return;
                }
               
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                MessageBox.Show("系统出错，请联系管理人员", "警告");
            }
        }
        #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;

            String batchNo = this.ultraGrid1.ActiveRow.Cells["BATCH_NO"].Value.ToString();
            String plineCode = this.ultraGrid1.ActiveRow.Cells["PLINE_CODE"].Value.ToString();
            if (string.IsNullOrEmpty(batchNo))
            {
                return;
            }
            if (string.IsNullOrEmpty(plineCode))
            {
                return;
            }
            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)
            {

                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();
                if (String.IsNullOrEmpty(specimen_no) || String.IsNullOrEmpty(smp_no))
                {
                    this.dataSet3.Tables[0].Clear();
                    return;
                }

                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);

                //右下角ord表删除
                //foreach (UltraGridRow ugr2 in this.ultraGrid2.Rows)
                //{
                //    ugr2.Cells["Column1"].Value = ugr2.Cells["THICK"].Value + "*" + ugr2.Cells["WIDTH"].Value + "*" + ugr2.Cells["LENGTH"].Value;
                //}
            }
            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", true);
                this.ToolBarItemEnable(this, "AddWt", true);
                this.ToolBarItemEnable(this, "DelWt", true);
                this.ToolBarItemEnable(this, "DoDelete", true);
                this.ToolBarItemEnable(this, "SendJG", true);
                this.ToolBarItemEnable(this, "doPrint", true);
                this.ToolBarItemEnable(this, "ForecastRZ", true);
                this.button1.Enabled = true;
                this.button2.Enabled = true;
                this.button3.Enabled = true;
                this.button4.Enabled = true;
                this.button8.Enabled = true;
            }

             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", false);
                 this.ToolBarItemEnable(this, "AddWt", false);
                 this.ToolBarItemEnable(this, "DelWt", false);
                 this.ToolBarItemEnable(this, "DoDelete", false);
                 this.ToolBarItemEnable(this, "SendJG", false);
                 this.ToolBarItemEnable(this, "doPrint", true);
                 this.ToolBarItemEnable(this, "ForecastRZ", false);
                 this.button1.Enabled = true;
                 this.button2.Enabled = true;
                 this.button3.Enabled = true;
                 this.button4.Enabled = true;
                 this.button8.Enabled = true;
             }

             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, "AddWt", false);
                 this.ToolBarItemEnable(this, "DelWt", false);
                 this.ToolBarItemEnable(this, "DoDelete", false);
                 this.ToolBarItemEnable(this, "SendJG", false);
                 this.ToolBarItemEnable(this, "doPrint", false);
                 this.ToolBarItemEnable(this, "ForecastRZ", false);
                 this.button1.Enabled = false;
                 this.button2.Enabled = false;
                 this.button3.Enabled = false;
                 this.button4.Enabled = false;
                 this.button8.Enabled = 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();
            if (String.IsNullOrEmpty(specimen_no) )
            {
                this.dataSet6.Tables[0].Clear();
                return;
            }

            this.dataSet6.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.dataSet6.Tables[0];
            this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);


            //右下角ord订单
            //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;
            //}
        }

        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
            {

                if (!this.checkBox1.Checked && !this.checkBox2.Checked && !this.checkBox3.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
            {
                if (!this.checkBox1.Checked && !this.checkBox2.Checked && !this.checkBox3.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.ROLL_MANA_NO.Enabled = true;
            }
            else
            {
                if (!this.checkBox1.Checked && !this.checkBox2.Checked && !this.checkBox3.Checked)
                {
                    this.dateTimePicker1.Enabled = true;
                    this.dateTimePicker2.Enabled = true;
                }
                this.ROLL_MANA_NO.Enabled = false;
            }
        }
        #endregion

        #region 表中的列  值改变触发
        private void ultraGrid1_AfterCellUpdate(object sender, CellEventArgs e)
        {
            Boolean bl = true;
            if (this.CustomInfo == "GX")
            {
                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 抽样按钮
        private void button1_Click(object sender, EventArgs e)
        {
            DoSendRZ();
        }

        private void button2_Click(object sender, EventArgs e)
        {
            DoUnsendRZ();
        }
        #endregion

        #region 发送检验委托按钮
        private void button3_Click(object sender, EventArgs e)
        {
            this.DoSend();//发送委托
        }

        private void button4_Click(object sender, EventArgs e)
        {
            this.DoUnsend();//撤销委托
        }
        #endregion

        #region 人工委托按钮
        private void button8_Click(object sender, EventArgs e)
        {
            this.AddArtificial();//新增人工委托
        }
        #endregion

        #region ultraGrid1 初始化  变色   状态为2 3红色
        private void ultraGrid1_InitializeRow(object sender, InitializeRowEventArgs e)
        {
            String statusl = e.Row.Cells["STATUS"].Value.ToString();
            String OLD_SAMPL_NO = e.Row.Cells["OLD_SAMPL_NO"].Value.ToString();//钢卷号
            String RZ_OLD_SAMPL_NO = e.Row.Cells["RZ_ENTRUST_NUMBER"].Value.ToString();//抽样钢卷号
            String MixRoll =e.Row.Cells["MIXROLL"].Value.ToString();//组批区间 
            String SteelName = e.Row.Cells["STEEL_NAME"].Value.ToString();//牌号
            String Hold = OLD_SAMPL_NO.Substring(OLD_SAMPL_NO.Length - 2);//钢卷号后两位
            String MATERIAL_NO = e.Row.Cells["MATERIAL_NO"].Value.ToString();//取样材料号
            String smpTypeName =  e.Row.Cells["SMP_TYPE_NAME"].Value.ToString();//初样 复样
            String QRZ_SPECIMEN_NO = e.Row.Cells["QRZ_SPECIMEN_NO"].Value.ToString();//人工选样
            String SPECIMEN_NO = e.Row.Cells["SPECIMEN_NO"].Value.ToString();//人工选样
            String SAMPL_PICK_RY = e.Row.Cells["SAMPL_PICK_RY"].Value.ToString();//人工选样
            String SEND_MEMO = e.Row.Cells["SEND_MEMO"].Value.ToString();//发送备注

            //if ((e.Row.Cells["STATUS"].Value.ToString() != "0" && !String.IsNullOrEmpty(MixRoll)) && 
            //    !e.Row.Cells["STATUS"].Value.ToString().Equals("未发送") && !String.IsNullOrEmpty(statusl)
            //    && (SteelName.Equals("Q235B") || SteelName.Equals("Q355B"))
            //    )
            //{
            //    e.Row.Appearance.BackColor = Color.LightGreen;
              
            //}
            //正常委托 状态不等于0 组指区间为空   抽样钢卷号为空
            if (e.Row.Cells["STATUS"].Value.ToString() != "0" &&
             !e.Row.Cells["STATUS"].Value.ToString().Equals("未发送") && !String.IsNullOrEmpty(statusl) &&
                String.IsNullOrEmpty(MixRoll) && String.IsNullOrEmpty(RZ_OLD_SAMPL_NO)
             )
            {
                e.Row.Appearance.BackColor = Color.LightGreen;//浅绿
            }

            if (e.Row.Cells["STATUS"].Value.ToString() != "0" &&
                 !e.Row.Cells["STATUS"].Value.ToString().Equals("未发送") && !String.IsNullOrEmpty(statusl) &&
                    !smpTypeName.Equals("初样") 
                 )
            {
                e.Row.Appearance.BackColor = Color.LightGreen;//浅绿
            }

            //抽样委托  组指区间不为空   抽样钢卷号不为空
            if (!String.IsNullOrEmpty(MixRoll) && !String.IsNullOrEmpty(RZ_OLD_SAMPL_NO))
            {
                e.Row.Appearance.BackColor = Color.LightGreen;//浅绿
            }

            //1、置空变绿色 有委托 再发送
            if(e.Row.Cells["STATUS"].Value.ToString() != "0" &&
             !e.Row.Cells["STATUS"].Value.ToString().Equals("未发送") && !String.IsNullOrEmpty(statusl) &&
                RZ_OLD_SAMPL_NO.Equals(OLD_SAMPL_NO) && MATERIAL_NO.Equals(OLD_SAMPL_NO) && String.IsNullOrEmpty(MixRoll)
                ){
                    e.Row.Appearance.BackColor = Color.LightGreen;//浅绿
               }




            //2、置空变绿色 无委托 再发送
            if (e.Row.Cells["STATUS"].Value.ToString() != "0" &&
             !e.Row.Cells["STATUS"].Value.ToString().Equals("未发送") && !String.IsNullOrEmpty(statusl) &&
                !OLD_SAMPL_NO.Equals(RZ_OLD_SAMPL_NO) && OLD_SAMPL_NO.Equals(MATERIAL_NO) && String.IsNullOrEmpty(MixRoll)
                )
            {
                e.Row.Appearance.BackColor = Color.LightGreen;//浅绿
            }

            //组批区间置空  钢卷号后两位不等于10   组批区间为空   抽样钢卷号不为空   取样材料号不等于钢卷号
            if (!Hold.Equals("10") && String.IsNullOrEmpty(MixRoll) && !String.IsNullOrEmpty(RZ_OLD_SAMPL_NO) &&
                !MATERIAL_NO.Equals(OLD_SAMPL_NO))
            {
                e.Row.Appearance.ForeColor = Color.Blue;//置空从新人工委托 蓝色  //除010其它子板清空组批区间变蓝
                e.Row.Cells["STATUS"].Value = "请人工委托";
            }

            //状态为完  抽样卷不为空  钢卷号和抽样钢卷号不一样   钢卷号等于 取样材料号   组批区间为空
            if ((e.Row.Cells["STATUS"].Value.ToString().Equals("3") || e.Row.Cells["STATUS"].Value.ToString().Equals("已完成")) && 
               !String.IsNullOrEmpty(statusl) && !String.IsNullOrEmpty(RZ_OLD_SAMPL_NO) &&
               !OLD_SAMPL_NO.Equals(RZ_OLD_SAMPL_NO) && OLD_SAMPL_NO.Equals(MATERIAL_NO) && String.IsNullOrEmpty(MixRoll)
               )
            {
                e.Row.Appearance.ForeColor = Color.Blue;//010清空组批区间变蓝
                e.Row.Cells["STATUS"].Value = "请人工委托";
                e.Row.Appearance.BackColor = Color.White;//白色
            }

            if (!String.IsNullOrEmpty(statusl) && !"0".Equals(statusl) && !"未发送".Equals(statusl) && String.IsNullOrEmpty(MixRoll)
                && !String.IsNullOrEmpty(RZ_OLD_SAMPL_NO) && !"预测换样".Equals(SEND_MEMO))
            {
                e.Row.Appearance.ForeColor = Color.Blue;
                e.Row.Cells["STATUS"].Value = "请人工委托";
                e.Row.Appearance.BackColor = Color.White;//白色
            }

            if (OLD_SAMPL_NO.Equals(RZ_OLD_SAMPL_NO))
            {
                e.Row.Appearance.ForeColor = Color.Red;//抽样卷  红色
            }

            if (QRZ_SPECIMEN_NO.Equals(SPECIMEN_NO) && "Y".Equals(SAMPL_PICK_RY))
            {
                e.Row.Appearance.ForeColor = Color.DeepPink;//人工选样
            }
        }

        private void ultraGrid4_InitializeRow(object sender, InitializeRowEventArgs e)
        {
            //String statusl = e.Row.Cells["STATUS"].Value.ToString();
            //String OLD_SAMPL_NO = e.Row.Cells["OLD_SAMPL_NO"].Value.ToString();//钢卷号
            //String RZ_OLD_SAMPL_NO = e.Row.Cells["RZ_ENTRUST_NUMBER"].Value.ToString();//抽样钢卷号

            //if (OLD_SAMPL_NO.Equals(RZ_OLD_SAMPL_NO))
            //{
            //    e.Row.Appearance.ForeColor = Color.Red;
            //}
        }
        #endregion

        #region 导出
        private void InExcel()
        {
            try
            {
                if (this.ultraGrid1.Rows.Count == 0)
                {
                    MessageBox.Show("没有可以导出的数据", "提示");
                    return;
                }

                if (this.saveFileDialog1.ShowDialog(this) == DialogResult.OK)
                {
                    string fName = this.saveFileDialog1.FileName;
                    this.ultraGridExcelExporter1.Export(this.ultraGrid1, fName);
                    Process.Start(fName);
                }

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

        private void button10_Click(object sender, EventArgs e)
        {
            var dataSource = new List<string>();
            Double mySalary = 0;
            Double mySalary1 = 0;
            string SPECIMEN_NO = "";
            string fh = "";
            int num = 0;
            string Znum = "0";
            string Fnum = "0";
            foreach (UltraGridRow ugr in this.ultraGrid1.Rows)
            {
                string specimeNo = "";
                if (ugr.Cells["CHK"].Value.ToString().ToLower() == "true")
                {
                    if (string.IsNullOrEmpty(ugr.Cells["STATUS"].Value.ToString()))
                    {
                        this.alert("委托不存在");
                        return;
                    }

                    if (!ugr.Cells["STATUS"].Value.ToString().Equals("未发送"))
                    {
                        this.alert("请选择状态为未发送的委托！！！");
                        return;
                    }

                    String rollManaNo = ugr.Cells["ROLL_MANA_NO"].Value.ToString();
                    dataSource.Add(rollManaNo);

                    String mixroll = ugr.Cells["MIXROLL"].Value.ToString();
                    String smpTypeName = ugr.Cells["SMP_TYPE_NAME"].Value.ToString();
                    String txt_DESIGN_KEY = ugr.Cells["DESIGN_KEY"].Value.ToString();
                    String txtDK = txt_DESIGN_KEY.Substring(0, 2);
                    if (smpTypeName.Equals("初样"))
                    {
                        Znum = "1";
                    }
                    else if (smpTypeName.Equals("复样"))
                    {
                        Fnum = "1";
                    }
                    if (!String.IsNullOrEmpty(mixroll) && smpTypeName.Equals("初样") && !"39".Equals(txtDK) && !"49".Equals(txtDK) && !"59".Equals(txtDK))
                    {
                        this.alert("预测产品，请进行抽样操作！");
                        return;
                    }

                    //拿取最大规格
                    String THICK = ugr.Cells["THICK"].Value.ToString();
                    mySalary = Double.Parse(THICK);
                    if (mySalary > mySalary1)
                    {
                        mySalary1 = mySalary;
                    }

                    specimeNo = ugr.Cells["SPECIMEN_NO"].Value.ToString();
                    num = num + 1;
                    if (num <= 1)
                    {
                        SPECIMEN_NO = specimeNo;
                        fh = ",";
                    }
                    else
                    {
                        SPECIMEN_NO = SPECIMEN_NO + fh + specimeNo;
                    }
                }
            }

            if (num<=0)
            {
                this.alert("未勾选委托!");
                return;
            }
            if (Znum.Equals("1") && Fnum.Equals("1"))
            {
                this.alert("不能同时勾选初样和复样!");
                return;
            }
            var uniqueData = dataSource.Distinct();
            int unum = 0;
            foreach (var item in uniqueData)
            {
                unum = unum + 1;
            }
            if (unum>=2)
            {
                this.alert("只能勾选同轧辊单元委托!");
                return;
            }
            CoreClientParam ccpSel = new CoreClientParam();
            ccpSel.ServerName = "QCM.JHY01.JHY0101.QuerryQltySample";
            ccpSel.MethodName = "getQltyRZHeatNo";
            ccpSel.ServerParams = new object[] { SPECIMEN_NO };
            ccpSel = this.ExecuteNonQuery(ccpSel, CoreInvokeType.Internal);
            if (ccpSel.ReturnCode == -1)
            {
              return;
            }

            QCM0211 frmRbp = new QCM0211();
            frmRbp.StartPosition = FormStartPosition.CenterScreen;
            frmRbp.ob = this.ob;
            frmRbp.specimenNo = SPECIMEN_NO;
            frmRbp.thick = mySalary1.ToString();
            frmRbp.plineCode = "RZ1";
            frmRbp.ShowDialog();

            this.DoQuery();

        }

        private void button9_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.ultraGrid1.Rows)
                {
                    string specimeNo = "";
                    if (ugr.Cells["CHK"].Value.ToString().ToLower() == "true")
                    {
                        String spno = ugr.Cells["SPECIMEN_NO"].Value.ToString();
                        String QRZ_SPECIMEN_NO = ugr.Cells["QRZ_SPECIMEN_NO"].Value.ToString();
                        if (String.IsNullOrEmpty(QRZ_SPECIMEN_NO) || !spno.Equals(QRZ_SPECIMEN_NO))
                        {
                            this.alert("请勾选正确的人工选样的数据进行撤销选样!");
                            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;
                        }
                    }
                }
                Hashtable ht = new Hashtable();
                ht.Add("ZHYY", zhyy);
                ht.Add("USERID", this.UserInfo.GetUserID().ToString());
                ht.Add("USERNAME", this.UserInfo.GetUserName().ToString());

                ccp.ServerName = "QCM.JHY01.JHY0102.Send2";
                ccp.MethodName = "CancelLimesRZXY";
                ccp.ServerParams = new object[] { SPECIMEN_NO, ht };
                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)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                MessageBox.Show("系统出错，请联系管理人员", "警告");
            }
        }




    }
}