XinYu_LZMES_Client/Core.LZMes.Client.QCM/QCM03/QCM030723.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 Core.LZMes.Client.QCM.QCM03;
using System.Diagnostics;
using Infragistics.Win.UltraWinEditors;
using Infragistics.Win;

namespace Core.LZMes.Client.QCM
{
    public partial class QCM030723 : FrmBase
    {
        private string judge_type = "";//用于区分1检测中心和2轧钢厂
        public QCM030723()
        {
            InitializeComponent();
        }

        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    this.DoQuery();
                    break;
                case "Exit":
                    this.Close();
                    break;
                case "Unlock":
                    this.Judge();
                    break;
                case "Export":
                    this.DoExport();
                    break;
                case "CancelFy":
                    CancelFy();
                    break;
            }
        }
        private void CancelFy()
        {
            UltraGridRow ugr = this.ultraGrid2.ActiveRow;
            if (ugr == null)
            {
                MessageBox.Show("请选择数据！");
                return;
            }
            string batch_no = ugr.Cells["BATCH_NO"].Value.ToString();
            if (MessageBox.Show(this, "是否对" + batch_no + "取消复样操作？", "删除", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No)
            {
                return;
            }
            QCM030607 frm = new QCM030607();
            string remark = "";
            if (frm.ShowDialog() == DialogResult.OK)
            {
                remark = frm._memo;
                if (remark == "")
                {
                    MessageBox.Show("请录入备注信息！");
                    return;
                }
                string material_no = ugr.Cells["MATERIAL_NO"].Value.ToString();
                string lock_seq = ugr.Cells["LOCK_SEQ"].Value.ToString();
                string username = this.UserInfo.GetUserName();
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "QCM.QCM03.QCM0307.QcmRejudgeApplyServiceImpl";
                ccp.MethodName = "CancelFy";
                ccp.ServerParams = new object[] { batch_no, material_no, lock_seq, username, remark };
                this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                if (ccp.ReturnCode == -1)
                {
                    return;
                }
                MessageBox.Show("取消复样成功！");
                DoQuery();
            }
        }
        private void Judge()
        {
                    if (this.ultraGrid9.Selected.Rows.Count == 0)
                        this.ultraGrid9.ActiveRow.Selected = true;
                    List<UltraGridRow> lists = new List<UltraGridRow>();

                    if (comboBox1.Text.Trim().ToString() == "")
                    {
                        MessageBox.Show("请选择异常材处置放向！");
                        return;
                    }

                    if (comboBox1.Text.Trim().ToString() == "放行")
                    {
                        if (MessageBox.Show(this, "是否放行处置？", "删除", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No)
                        {
                            return;
                        }
                    }
                    else if (comboBox1.Text.Trim().ToString() == "复样")
                    {
                        if (MessageBox.Show(this, "是否复样处置？", "删除", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No)
                        {
                            return;
                        }
                    }
                    else if (comboBox1.Text.Trim().ToString() == "修磨")
                    {
                        if (MessageBox.Show(this, "是否修磨处置？", "删除", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No)
                        {
                            return;
                        }
                    }
                    else if (comboBox1.Text.Trim().ToString() == "改尺")
                    {
                        if (MessageBox.Show(this, "是否改尺处置？", "删除", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No)
                        {
                            return;
                        }
                    }
                    else if (comboBox1.Text.Trim().ToString() == "判次")
                    {
                        if (MessageBox.Show(this, "是否判次处置？", "删除", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No)
                        {
                            return;
                        }
                    }
                    else if (comboBox1.Text.Trim().ToString() == "判废")
                    {
                        if (MessageBox.Show(this, "是否判废处置？", "删除", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No)
                        {
                            return;
                        }
                    }
                    else if (comboBox1.Text.Trim().ToString() == "脱单")
                    {
                        if (MessageBox.Show(this, "是否脱单处置？", "删除", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No)
                        {
                            return;
                        }
                    }
                    else if (comboBox1.Text.Trim().ToString() == "件件取样")
                    {
                        if (MessageBox.Show(this, "是否件件取样处置？", "删除", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No)
                        {
                            return;
                        }
                    }
                    else if (comboBox1.Text.Trim().ToString() == "解除")
                    {
                        if (MessageBox.Show(this, "是否解除处置？", "删除", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No)
                        {
                            return;
                        }
                    }
                    else if (comboBox1.Text.Trim().ToString() == "待判")
                    {
                        if (MessageBox.Show(this, "是否待判处置？", "删除", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No)
                        {
                            return;
                        }
                    }
                    else if (comboBox1.Text.Trim().ToString() == "改判")
                    {
                        if (textBox3.Text.ToString() == "")
                        {
                            MessageBox.Show("请选择改判订单!");
                            return;
                        }
                        if (MessageBox.Show(this, "是否改判处置？", "删除", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No)
                        {
                            return;
                        }
                    }
                    foreach (UltraGridRow ugr in this.ultraGrid9.Rows)
                    {
                        if (ugr.Cells["CHECK"].Text.ToString() == "True")
                        {
                            ArrayList al = new ArrayList();
                            if (comboBox1.Text.Trim().ToString() != "改判")
                            {
                                string material = ugr.Cells["MATERIAL_NO"].Value.ToString();
                                string lock_seq = ugr.Cells["LOCK_SEQ"].Value.ToString();
                                string lock_type_code = ugr.Cells["LOCK_TYPE_CODE"].Value.ToString();
                                string prodline = ugr.Cells["PLINE_CODE"].Value.ToString();
                                string lock_memo = ugr.Cells["LOCK_MEMO"].Value.ToString();//封锁原因
                                string unlock_type_code = "";
                                if (lock_type_code == "C" || lock_type_code == "P")
                                {
                                    if (comboBox1.Text.Trim().ToString() == "放行")
                                    {
                                        unlock_type_code = "0";
                                    }
                                    else if (comboBox1.Text.Trim().ToString() == "复样")
                                    {
                                        unlock_type_code = "1";
                                    }
                                    else if (comboBox1.Text.Trim().ToString() == "判次")
                                    {
                                        unlock_type_code = "4";
                                    }
                                    else if (comboBox1.Text.Trim().ToString() == "判废")
                                    {
                                        unlock_type_code = "5";
                                    }
                                    else if (comboBox1.Text.Trim().ToString() == "脱单")
                                    {
                                        unlock_type_code = "6";
                                    }
                                    else if (comboBox1.Text.Trim().ToString() == "件件取样")
                                    {
                                        unlock_type_code = "8";
                                    }
                                    else if (comboBox1.Text.Trim().ToString() == "解除")
                                    {
                                        unlock_type_code = "9";
                                    }
                                    else if (comboBox1.Text.Trim().ToString() == "待判")
                                    {
                                        unlock_type_code = "10";
                                    }
                                    string unlock_memo = ultraComboEditor1.Text.Trim().ToString();
                                    string bh_combobox = this.comboBox4.Text.Trim().ToString();
                                    if (comboBox1.Text.Trim().ToString() == "放行" && (lock_type_code == "P" || lock_type_code == "C"))
                                    {
                                        if (string.IsNullOrEmpty(unlock_memo) || string.IsNullOrEmpty(bh_combobox))
                                        {
                                            this.alert("请选择审理人员及不合格品审理类型!");
                                            return;
                                        }
                                    }
                                    string username = this.UserInfo.GetUserName() + 'Y';
                                    string lock_id = ugr.Cells["LOCK_ID"].Value.ToString();
                                    al.Add(material);
                                    al.Add(lock_seq);
                                    al.Add(lock_type_code);
                                    al.Add(unlock_type_code);
                                    al.Add(unlock_memo);
                                    al.Add(username);
                                    al.Add(lock_id);
                                    if (ultraCombo1.Text.ToString() == "")
                                    { al.Add(""); }
                                    else
                                    {
                                        al.Add(ultraCombo1.Value.ToString());
                                    }
                                    al.Add(prodline);
                                    al.Add(this.comboBox4.Text.ToString());
                                    if (comboBox1.Text.Trim().ToString() == "放行" && lock_type_code == "P" &&
                                             prodline.Equals("YT1") && lock_memo.Contains("粗糙度"))
                                    {
                                        CoreClientParam ccp = new CoreClientParam();
                                        ccp.ServerName = "QCM.QCM03.QCM0307.QcmRejudgeApplyServiceImpl";
                                        ccp.MethodName = "doInformationSure";
                                        ccp.ServerParams = new object[] { al };
                                        ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                                        if (ccp.ReturnCode == -1)
                                        {
                                            return;
                                        }
                                        lists.Add(ugr);
                                    }else if (comboBox1.Text.Trim().ToString() == "放行" && (lock_type_code == "P"|| lock_type_code == "C"))
                                    {
                                        lists.Add(ugr);
                                        String status = ugr.Cells["STATUS"].Text.Trim().ToString();
                                        if ("已申请".Equals(status))
                                        {
                                            continue;
                                        }
                                        CoreClientParam ccp = new CoreClientParam();
                                        ccp.ServerName = "QCM.QCM03.QCM0307.QcmRejudgeApplyServiceImpl";
                                        ccp.MethodName = "LockingApply";
                                        ccp.ServerParams = new object[] { al };
                                        ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                                        if (ccp.ReturnCode == -1)
                                        {
                                            return;
                                        }
                                    }
                                    else
                                    {
                                        CoreClientParam ccp = new CoreClientParam();
                                        ccp.ServerName = "QCM.QCM03.QCM0307.QcmRejudgeApplyServiceImpl";
                                        ccp.MethodName = "doInformationSure";
                                        ccp.ServerParams = new object[] { al };
                                        ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                                        if (ccp.ReturnCode == -1)
                                        {
                                            return;
                                        }
                                        lists.Add(ugr);
                                    }
                                }
                                else
                                {
                                    if (comboBox1.Text.Trim().ToString() == "放行")
                                    {
                                        unlock_type_code = "0";
                                    }
                                    else if (comboBox1.Text.Trim().ToString() == "修磨")
                                    {
                                        unlock_type_code = "2";
                                    }
                                    else if (comboBox1.Text.Trim().ToString() == "改尺")
                                    {
                                        unlock_type_code = "3";
                                    }
                                    else if (comboBox1.Text.Trim().ToString() == "判次")
                                    {
                                        unlock_type_code = "4";
                                    }
                                    else if (comboBox1.Text.Trim().ToString() == "判废")
                                    {
                                        unlock_type_code = "5";
                                    }
                                    else if (comboBox1.Text.Trim().ToString() == "脱单")
                                    {
                                        unlock_type_code = "6";
                                    }
                                    else if (comboBox1.Text.Trim().ToString() == "解除")
                                    {
                                        unlock_type_code = "9";
                                    }
                                    else if (comboBox1.Text.Trim().ToString() == "待判")
                                    {
                                        unlock_type_code = "10";
                                    }
                                    string unlock_memo = this.ultraComboEditor1.Text.Trim().ToString();
                                    string username = this.UserInfo.GetUserName();
                                    string lock_id = ugr.Cells["LOCK_ID"].Value.ToString();
                                    al.Add(material);
                                    al.Add(lock_seq);
                                    al.Add(lock_type_code);
                                    al.Add(unlock_type_code);
                                    al.Add(unlock_memo);
                                    al.Add(username);
                                    al.Add(lock_id);
                                    if (ultraCombo1.Text.ToString() == "")
                                    { al.Add(""); }
                                    else
                                    {
                                        al.Add(ultraCombo1.Value.ToString());
                                    }
                                    al.Add(this.comboBox4.Text.ToString());
                                    CoreClientParam ccp = new CoreClientParam();
                                    ccp.ServerName = "QCM.QCM03.QCM0307.QcmRejudgeApplyServiceImpl";
                                    ccp.MethodName = "doInformationSureH";
                                    ccp.ServerParams = new object[] { al };
                                    ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                                    if (ccp.ReturnCode == -1)
                                    {
                                        return;
                                    }
                                    lists.Add(ugr);
                                }
                            }
                            else
                            {
                                string material = ugr.Cells["MATERIAL_NO"].Value.ToString();
                                string lock_seq = ugr.Cells["LOCK_SEQ"].Value.ToString();
                                string lock_type_code = ugr.Cells["LOCK_TYPE_CODE"].Value.ToString();
                                string unlock_type_code = "7";
                                string unlock_memo = ultraComboEditor1.Text.Trim().ToString();
                                string username = this.UserInfo.GetUserName();
                                string lock_id = ugr.Cells["LOCK_ID"].Value.ToString();
                                al.Add(material);
                                al.Add(lock_seq);
                                al.Add(lock_type_code);
                                al.Add(unlock_type_code);
                                al.Add(unlock_memo);
                                al.Add(username);
                                al.Add(lock_id);
                                al.Add(textBox3.Text.ToString());
                                if (ultraCombo1.Text.ToString() == "")
                                { al.Add(""); }
                                else
                                {
                                    al.Add(ultraCombo1.Value.ToString());
                                }
                                al.Add(txt_gp_tradeno.Text.ToString());
                                al.Add(this.comboBox4.Text.ToString());
                                CoreClientParam ccp = new CoreClientParam();
                                ccp.ServerName = "QCM.QCM03.QCM0307.QcmRejudgeApplyServiceImpl";
                                ccp.MethodName = "doInformationGp";
                                ccp.ServerParams = new object[] { al };
                                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                                if (ccp.ReturnCode == -1)
                                {
                                    return;
                                }
                                lists.Add(ugr);
                            }
                        }
                    }
                    for (int i = 0; i < lists.Count; i++)
                    {
                        lists[i].Delete(false);
                    }
                    MessageBox.Show("异常处置成功！");
        }
        private void DoQuery()
        {
            if (this.ultraTabControl1.Tabs[0].Selected) //待判信息
            {
                DoQueryMe();
            }
            if (this.ultraTabControl1.Tabs[1].Selected) //判定记录
            {
                DoQueryRe();
            }

        }
        private void DoQueryMe()
        {
            try
            {
                this.dataSet1.Clear();
                this.dataSet8.Clear();
                string ebatchno = comboBox5.Text.Trim().ToString();
                string sbatchno = BatchNo.Text.Trim();
                string orderno = this.OrderNo.Text.Trim();
                string psc = this.PscDesc.Text.Trim();
                string prodline = this.comboBox3.Text.ToString();
                string lock_type_desc = this.comboBox2.Text.ToString();
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "QCM.QCM03.QCM0307.QcmRejudgeApplyServiceImpl";
                if (String.IsNullOrEmpty(judge_type))
                {
                    ccp.MethodName = "getInformationJ";
                    ccp.ServerParams = new object[] { this.dateTimePicker1.Value.ToString("yyyyMMdd"), this.dateTimePicker2.Value.ToString("yyyyMMdd"), sbatchno, ebatchno, orderno, psc, "5", prodline, lock_type_desc };
                }
                else
                {
                    ccp.MethodName = "getInformation2J";
                    ccp.ServerParams = new object[] { this.dateTimePicker1.Value.ToString("yyyyMMdd"), this.dateTimePicker2.Value.ToString("yyyyMMdd"), sbatchno, ebatchno, orderno, psc, "5", prodline, judge_type, lock_type_desc };
                }
                ccp.SourceDataTable = this.dataSet1.Tables[0];
                this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
                ccp = new CoreClientParam();
                ccp.ServerName = "QCM.QCM03.QCM0305.QcmJudgeSurfaceServiceImpl";
                ccp.MethodName = "findFlawDataJ";
                ccp.ServerParams = new object[] { prodline };
                ccp.SourceDataTable = this.dataSet8.Tables[0];
                this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
                this.ultraCombo1.DataSource = ccp.SourceDataTable;
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                MessageBox.Show("系统出错，请联系管理人员", "警告");
            }
        }
        private void DoQueryRe()
        {
            try
            {
                this.dataSet2.Clear();
                string ebatchno = comboBox5.Text.Trim().ToString();
                string sbatchno = BatchNo.Text.Trim();
                string orderno = this.OrderNo.Text.Trim();
                string psc = this.PscDesc.Text.Trim();
                string prodline = this.comboBox3.Text.ToString();
                string lock_type_desc = this.comboBox2.Text.ToString();
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "QCM.QCM03.QCM0307.QcmRejudgeApplyServiceImpl";
                if (String.IsNullOrEmpty(judge_type))
                {
                    ccp.MethodName = "getAbnormalRecordInfoJ";
                    ccp.ServerParams = new object[] { this.dateTimePicker1.Value.ToString("yyyyMMdd"), this.dateTimePicker2.Value.ToString("yyyyMMdd"), sbatchno, ebatchno, orderno, psc, "5", prodline,lock_type_desc };
                }
                else
                {
                    ccp.MethodName = "getAbnormalRecordInfo2J";
                    ccp.ServerParams = new object[] { this.dateTimePicker1.Value.ToString("yyyyMMdd"), this.dateTimePicker2.Value.ToString("yyyyMMdd"), sbatchno, ebatchno, orderno, psc, "5", prodline, judge_type, lock_type_desc };
                }
                ccp.SourceDataTable = this.dataSet2.Tables[0];
                this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
                foreach (UltraGridRow ugrs in this.ultraGrid2.Rows)
                {
                    if (ugrs.Cells["UNLOCK_TYPE_DESC"].Text.ToString().Contains("复样"))
                    {
                        ugrs.Appearance.BackColor = Color.Pink;
                    }
                }
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                MessageBox.Show("系统出错，请联系管理人员", "警告");
            }
        }

        private void label1_Click(object sender, EventArgs e)
        {

        }

        private void panel4_Paint(object sender, PaintEventArgs e)
        {

        }

        private void panel2_Paint(object sender, PaintEventArgs e)
        {

        }
        private void DoQueryC()
        {
            try
            {
                UltraGridRow ugr = this.ultraGrid9.ActiveRow;
                if (ugr == null)
                    return;
                this.dataSet4.Clear();
                string design_key = ugr.Cells["design_key"].Value.ToString();
                string smp_no = ugr.Cells["smp_no"].Value.ToString();
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "QCM.QCM03.QCM0301.QcmJhyElementsServiceImpl";
                ccp.MethodName = "GetChemeInfo";
                ccp.ServerParams = new object[] { design_key, smp_no};
                ccp.SourceDataTable = this.dataSet4.Tables[0];
                this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); 
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                MessageBox.Show("系统出错，请联系管理人员", "警告");
            }

        }

        private void ultraGrid9_DoubleClickCell(object sender, DoubleClickCellEventArgs e)
        {
            UltraGridRow ugr = e.Cell.Row;
            string lock_id = ugr.Cells["LOCK_ID"].Value.ToString();
            if (ugr.Cells["LOCK_TYPE_CODE"].Value.ToString() == "F")
            {

                QCM030705 dlg = new QCM030705();
                dlg.lock_id = lock_id;
                dlg.ob = this.ob;
                dlg.ShowDialog();
            }
            else if (ugr.Cells["LOCK_TYPE_CODE"].Value.ToString() == "D")
            {
                QCM030704 dlg = new QCM030704();
                dlg.lock_id = lock_id;
                dlg.ob = this.ob;
                dlg.ShowDialog();
            }
            else if (ugr.Cells["LOCK_TYPE_CODE"].Value.ToString() == "C")
            {
                QCM030701 dlg = new QCM030701();
                dlg.lock_id = lock_id;
                dlg.ob = this.ob;
                dlg.ShowDialog();
            }
            else if (ugr.Cells["LOCK_TYPE_CODE"].Value.ToString() == "P")
            {
                QCM030702 dlg = new QCM030702();
                dlg.lock_id = lock_id;
                dlg.ob = this.ob;
                dlg.ShowDialog();
            }
            else if (ugr.Cells["LOCK_TYPE_CODE"].Value.ToString() == "S")
            {
                QCM030716 dlg = new QCM030716();
                dlg.lock_id = lock_id;
                dlg.ob = this.ob;
                dlg.ShowDialog();
            }


        }

        private void button1_Click(object sender, EventArgs e)
        {
            UltraGridRow ugr = this.ultraGrid9.ActiveRow;
            if (ugr == null)
                return;
            string material_no = ugr.Cells["MATERIAL_NO"].Text.ToString();
            string std_code = ugr.Cells["STD_CODE"].Text.ToString();
            string steel_code = ugr.Cells["STEEL_CODE"].Text.ToString();
            string delivery_state_code = ugr.Cells["DELIVERY_STATE_DESC"].Text.ToString();
            string thick = ugr.Cells["THICK"].Text.ToString();
            string PSC = ugr.Cells["PSC"].Text.ToString();
            string WIDTH = ugr.Cells["WIDTH"].Text.ToString();
            string LENGTH = ugr.Cells["LENGTH"].Text.ToString();
            string PRODLINE = ugr.Cells["PLINE_CODE"].Text.ToString();
            QCM030709 dlg = new QCM030709();
            dlg.MATERIAL_NO = material_no;
            dlg.STD_CODE = std_code;
            dlg.STEELCODE = steel_code;
            dlg.DELIVERY_STATE_CODE = delivery_state_code;
            dlg.HEIGHT = thick;
            dlg.PSC = PSC;
            dlg.WIDTH = WIDTH;
            dlg.LENGTH = LENGTH;
            dlg.PROD_LINE = PRODLINE;
            dlg.ob = this.ob;
            dlg.ShowDialog();
            this.textBox3.Text = dlg.orderno;
            this.txt_gp_tradeno.Text = dlg.gp_tradeno;
        }
        public static bool SetUltraComboEditor(ref UltraComboEditor cbEdt, ref ValueList vlist, bool bNull)
        {
            if (cbEdt == null || vlist == null)
                return false;

            cbEdt.Items.Clear();

            if (bNull)
                cbEdt.Items.Add(null, "");

            for (int i = 0; i < vlist.ValueListItems.Count; i++)
            {
                try
                {
                    cbEdt.Items.Add(vlist.ValueListItems[i].DataValue, vlist.ValueListItems[i].DisplayText);
                }
                catch { }
            }

            return true;
        }
        public static ValueList GeneralValuelist(ref DataTable table, string strKey, string strText)
        {
            if (table == null || !table.Columns.Contains(strKey) || !table.Columns.Contains(strText))
                return null;
            ArrayList alist = new ArrayList();
            ValueList vlist = new ValueList();
            for (int i = 0; i < table.Rows.Count; i++)
            {
                try
                {
                    if (!alist.Contains(table.Rows[i][strKey]))
                    {
                        alist.Add(table.Rows[i][strKey]);
                        vlist.ValueListItems.Add(table.Rows[i][strKey], Convert.ToString(table.Rows[i][strText]));
                    }
                }
                catch { }
            }
            return vlist;
        }
        private void QCM0307_Load(object sender, EventArgs e)
        {
            this.comboBox3.SelectedIndex = 0;
            this.ultraGrid9.DisplayLayout.Override.FilterUIType = FilterUIType.HeaderIcons;
            this.ultraGrid2.DisplayLayout.Override.FilterUIType = FilterUIType.HeaderIcons;
            this.dateTimePicker1.Value = System.DateTime.Now.AddDays(-7);
            judge_type = String.IsNullOrEmpty(this.CustomInfo) ? "" : this.CustomInfo;
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "QCM.QCM01.QCM0106.QueryDefect";
            ccp.MethodName = "QueryMemo";
            ccp.ServerParams = new object[] { "JB1" };
            ccp = this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
            DataTable table2 = ccp.SourceDataTable;
            ValueList valueList2 = GeneralValuelist(ref table2, "MEMO_CODE", "MEMO");
            ClsControlPack.SetUltraComboEditor(ref ultraComboEditor1, ref valueList2, false);
        }

        private void ultraGrid2_DoubleClickCell(object sender, DoubleClickCellEventArgs e)
        {
            UltraGridRow ugr = e.Cell.Row;
            string lock_id = ugr.Cells["LOCK_ID"].Value.ToString();
            if (ugr.Cells["LOCK_TYPE_CODE"].Value.ToString() == "F")
            {

                QCM030705 dlg = new QCM030705();
                dlg.lock_id = lock_id;
                dlg.ob = this.ob;
                dlg.ShowDialog();
            }
            else if (ugr.Cells["LOCK_TYPE_CODE"].Value.ToString() == "D")
            {
                QCM030704 dlg = new QCM030704();
                dlg.lock_id = lock_id;
                dlg.ob = this.ob;
                dlg.ShowDialog();
            }
            else if (ugr.Cells["LOCK_TYPE_CODE"].Value.ToString() == "C")
            {
                QCM030701 dlg = new QCM030701();
                dlg.lock_id = lock_id;
                dlg.ob = this.ob;
                dlg.ShowDialog();
            }
            else if (ugr.Cells["LOCK_TYPE_CODE"].Value.ToString() == "P")
            {
                QCM030702 dlg = new QCM030702();
                dlg.lock_id = lock_id;
                dlg.ob = this.ob;
                dlg.ShowDialog();
            }
            else if (ugr.Cells["LOCK_TYPE_CODE"].Value.ToString() == "S")
            {
                QCM030703 dlg = new QCM030703();
                dlg.lock_id = lock_id;
                dlg.ob = this.ob;
                dlg.ShowDialog();
            }
        }

        private void ultraTabControl1_Click(object sender, EventArgs e)
        {
            if (this.ultraTabControl1.Tabs[1].Selected) //判定记录
            {
                this.label9.Text = "处置时间";
            }
            if (this.ultraTabControl1.Tabs[0].Selected) //判定记录
            {
                this.label9.Text = "封锁时间";
            }
        }

        private void DoExport()
        {
            if (this.ultraTabControl1.Tabs[0].Selected) //待判信息
            {
                try
                {
                    if (this.ultraGrid9.Rows.Count == 0)
                    {
                        MessageBox.Show("没有可以导出的数据", "提示");
                        return;
                    }

                    if (this.saveFileDialog1.ShowDialog(this) == DialogResult.OK)
                    {
                        string fName = this.saveFileDialog1.FileName;
                        this.ultraGridExcelExporter1.Export(this.ultraGrid9, fName);
                        Process.Start(fName);
                    }
                }
                catch (Exception ex)
                {
                    System.Diagnostics.Debug.WriteLine(ex.ToString());
                }
            }
            if (this.ultraTabControl1.Tabs[1].Selected) //判定记录
            {
                try
                {
                    if (this.ultraGrid2.Rows.Count == 0)
                    {
                        MessageBox.Show("没有可以导出的数据", "提示");
                        return;
                    }

                    if (this.saveFileDialog1.ShowDialog(this) == DialogResult.OK)
                    {
                        string fName = this.saveFileDialog1.FileName;
                        this.ultraGridExcelExporter1.Export(this.ultraGrid2, fName);
                        Process.Start(fName);
                    }
                }
                catch (Exception ex)
                {
                    System.Diagnostics.Debug.WriteLine(ex.ToString());
                }
            }
        }

        private void label11_Click(object sender, EventArgs e)
        {
            //获取勾选的批次
            ultraGrid9.UpdateData();
            DataRow[] rows = dataTable1.Copy().Select("CHECK = 'True'");
            if (this.ultraGrid9.Rows.Count == 0 || rows.Length == 0)
            {
                return;
            }
            DataRow[] rows2 = rows.CopyToDataTable().Select("BATCH_NO = '" + rows[0]["BATCH_NO"].ToString() + "'");
            if (rows2.Length != rows.Length)
            {
                MessageBox.Show("选择了多个批次信息！");
                return;
            }
            foreach (UltraGridRow ugr in this.ultraGrid9.Rows)
            {
                if (ugr.Cells["BATCH_NO"].Text.ToString() == rows[0]["BATCH_NO"].ToString())
                {
                    ugr.Cells["CHECK"].Value = "True";
                }
            }
        }

        private void checkBox2_CheckedChanged(object sender, EventArgs e)
        {
            foreach (UltraGridRow ugr in this.ultraGrid9.Rows.Where(p => p.IsFilteredOut == false).ToList())
            {
                if (checkBox2.Checked)
                {
                    ugr.Cells["CHECK"].Value = "True";
                }
                else
                {
                    ugr.Cells["CHECK"].Value = "False";
                }
            }
        }
    }
}