XinYu_LZMES_Client/Core.LZMes.Client.QCM/QCM03/QCM030726.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 QCM030726 : FrmBase
    {
        private string judge_type = "";//用于区分1检测中心和2轧钢厂
        public QCM030726()
        {
            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()
        {

            if (MessageBox.Show(this, "是否审批不通过？", "删除", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No)
            {
                return;
            }
            List<UltraGridRow> lists = new List<UltraGridRow>();
            foreach (UltraGridRow ugr in this.ultraGrid9.Rows)
            {
                if (ugr.Cells["CHECK"].Text.ToString() == "True")
                {
                    ArrayList al = new ArrayList();
                    string apply_id = ugr.Cells["APPLY_ID"].Value.ToString();
                    string handle_memo = this.textBox2.Text.Trim().ToString();//审批处理备注
                    if (!string.IsNullOrEmpty(handle_memo))
                    {
                        DoUpdate(apply_id, handle_memo);
                    }
                    string username = this.UserInfo.GetUserName();
                    CoreClientParam ccp = new CoreClientParam();
                    ccp.ServerName = "QCM.QCM03.QCM0307.QcmRejudgeApplyServiceImpl";
                    ccp.MethodName = "ApplyBack";
                    ccp.ServerParams = new object[] { username,apply_id };
                    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 DoUpdate(String apply_id, String handle_memo)
        {
            try
            {
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "QCM.QCM03.QCM0307.QcmRejudgeApplyServiceImpl";
                ccp.MethodName = "updatememo";
                ccp.ServerParams = new object[] { apply_id, handle_memo };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                MessageBox.Show("系统出错请联系管理人员", "警告");
            }
        }
        private void Judge()
        {
                    if (this.ultraGrid9.Selected.Rows.Count == 0)
                        this.ultraGrid9.ActiveRow.Selected = true;
                    List<UltraGridRow> lists = new List<UltraGridRow>();
                    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();
                            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 unlock_type_code = "0";
                            string username = this.UserInfo.GetUserName();
                            string lock_id = ugr.Cells["LOCK_ID"].Value.ToString();
                            string apply_id = ugr.Cells["APPLY_ID"].Value.ToString();
                            string handle_memo = this.textBox2.Text.ToString();//审批处理备注
                            al.Add(material);
                            al.Add(lock_seq);
                            al.Add(lock_type_code);
                            al.Add(unlock_type_code);
                            al.Add(username);
                            al.Add(lock_id);
                            al.Add(prodline);
                            al.Add(apply_id);
                            al.Add(handle_memo);
                            CoreClientParam ccp = new CoreClientParam();
                            ccp.ServerName = "QCM.QCM03.QCM0307.QcmRejudgeApplyServiceImpl";
                            ccp.MethodName = "doApplyFx";
                            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 = "";
                string sbatchno = BatchNo.Text.Trim();
                if (BatchNo1.Text.ToString() == "")
                {
                    ebatchno = this.BatchNo.Text.Trim();
                }
                else
                {
                    ebatchno = BatchNo1.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 = "getInformationS";
                    ccp.ServerParams = new object[] { this.dateTimePicker1.Value.ToString("yyyyMMdd"), this.dateTimePicker2.Value.ToString("yyyyMMdd"), sbatchno, ebatchno, orderno, psc, "2", prodline, lock_type_desc };
                }
                else
                {
                    ccp.MethodName = "getInformation2S";
                    ccp.ServerParams = new object[] { this.dateTimePicker1.Value.ToString("yyyyMMdd"), this.dateTimePicker2.Value.ToString("yyyyMMdd"), sbatchno, ebatchno, orderno, psc, "2", prodline, judge_type, lock_type_desc };
                }
                ccp.SourceDataTable = this.dataSet1.Tables[0];
                this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                MessageBox.Show("系统出错，请联系管理人员", "警告");
            }
        }
        private void DoQueryRe()
        {
            try
            {
                this.dataSet2.Clear();
                string ebatchno = "";
                string sbatchno = BatchNo.Text.Trim();
                if (BatchNo1.Text.ToString() == "")
                {
                    ebatchno = this.BatchNo.Text.Trim();
                }
                else
                {
                    ebatchno = BatchNo1.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 = "getAbnormalRecordInfoS";
                    ccp.ServerParams = new object[] { this.dateTimePicker1.Value.ToString("yyyyMMdd"), this.dateTimePicker2.Value.ToString("yyyyMMdd"), sbatchno, ebatchno, orderno, psc, "2", prodline,lock_type_desc };
                }
                else
                {
                    ccp.MethodName = "getAbnormalRecordInfo2S";
                    ccp.ServerParams = new object[] { this.dateTimePicker1.Value.ToString("yyyyMMdd"), this.dateTimePicker2.Value.ToString("yyyyMMdd"), sbatchno, ebatchno, orderno, psc, "2", 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();
        }
        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");
        }

        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";
                }
            }
        }
    }
}