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

namespace Core.LZMes.Client.QCM
{
    public partial class QCM0309 : FrmBase
    {
        private string judge_type = "";//用于区分1检测中心和2轧钢厂
        public QCM0309()
        {
            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.cancel_fb();
                    break;
                case "Export":
                    this.DoExport();
                    break;
                case "CancelFy":
                    CancelFy();
                    break;
            }
        }
        private void CancelFy()
        {
            
        }
       
        private void DoQuery()
        {
            if (this.ultraTabControl1.Tabs[0].Selected) //待判信息
            {
                DoQueryMe();
            }
            if (this.ultraTabControl1.Tabs[1].Selected) //判定记录
            {
                DoQueryRe();
            }

        }
        private void DoQueryMe()
        {
            try
            {
                this.dataSet1.Clear();
                string starttime = "";
                string endtime = "";
                string ebatchno = "";
                string sbatchno = BatchNo.Text.Trim();                
                if (BatchNo.Text.ToString() == "")
                {
                    starttime = this.dateTimePicker1.Value.ToString("yyyyMMdd");
                    endtime = this.dateTimePicker2.Value.AddDays(1).ToString("yyyyMMdd");
                }

                if (BatchNo1.Text.ToString() == "")
                {
                    ebatchno = this.BatchNo.Text.Trim();                  
                        
                }
                else
                {
                    ebatchno = BatchNo1.Text.Trim();
                }
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "QCM.QCM03.QCM0303.QcmJudgeMeasureServiceImpl";
                ccp.MethodName = "doQueryMaterialDetailsRZFB";
                ccp.ServerParams = new object[] { starttime, endtime, sbatchno, ebatchno };
                ccp.SourceDataTable = this.dataSet1.Tables[0];
                this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
                /*CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "QCM.QCM03.QCM0303.QcmJudgeMeasureServiceImpl";
                ccp.MethodName = "doQueryMaterialDetailsRZFB";
                ccp.ServerParams = new object[] { starttime, endtime, sbatchno, ebatchno };
                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 starttime = "";
                string endtime = "";
                string ebatchno = "";
                string sbatchno = BatchNo.Text.Trim();                
                if (BatchNo.Text.ToString() == "")
                {
                    starttime = this.dateTimePicker1.Value.ToString("yyyyMMdd");
                    endtime = this.dateTimePicker2.Value.AddDays(1).ToString("yyyyMMdd");
                }

                if (BatchNo1.Text.ToString() == "")
                {
                    ebatchno = this.BatchNo.Text.Trim();                  
                        
                }
                else
                {
                    ebatchno = BatchNo1.Text.Trim();
                }
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "QCM.QCM03.QCM0303.QcmJudgeMeasureServiceImpl";
                ccp.MethodName = "doQueryMaterialDetailsRZFBJL";
                ccp.ServerParams = new object[] { starttime, endtime, sbatchno, ebatchno };
                ccp.SourceDataTable = this.dataSet2.Tables[0];
                this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                MessageBox.Show("系统出错，请联系管理人员", "警告");
            }
        }
        private void cancel_fb()
        {
            try
            {
                List<UltraGridRow> lists = new List<UltraGridRow>();
                foreach (UltraGridRow ugr in ultraGrid9.Rows)
                {
                    if (ugr.Cells["CHECK"].Text.ToString() == "True")
                    {
                        if (ugr.Cells["DLIV_DIRNO"].Value.ToString() != "")
                        {
                            MessageBox.Show(ugr.Cells["MATERIAL_NO"].Value.ToString() + "卷已有货运指示号，不可进行解除封闭操作！");
                            return;
                        }
                        CoreClientParam ccp = new CoreClientParam();
                        ccp.ServerName = "QCM.QCM03.QCM0303.QcmJudgeMeasureServiceImpl";
                        ccp.MethodName = "coiljudge_status_call_commit";
                        ccp.ServerParams = new object[] { "RZ1"
			                                            , ugr.Cells["MATERIAL_NO"].Value.ToString()
			                                            , ""
			                                            , ""
			                                            , ""
			                                            , ""
			                                            , ""
			                                            , "N"
			                                            ,"",""};
                        ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                        if (ccp.ReturnCode == -1)
                        {
                            return;
                        }
                        string remark = "取消封闭";
                        CoreClientParam ccp1 = new CoreClientParam();
                        ccp1.ServerName = "QCM.QCM03.QCM0303.QcmJudgeMeasureServiceImpl";
                        ccp1.MethodName = "RZ_Record1";
                        ccp1.ServerParams = new object[] { ugr.Cells["MATERIAL_NO"].Value.ToString(), this.UserInfo.GetUserName().ToString(), remark,"" };
                        ccp1 = this.ExecuteNonQuery(ccp1, CoreInvokeType.Internal);
                        if (ccp1.ReturnCode == -1)
                        {
                            return;
                        }
                        lists.Add(ugr);
                    }
                }
                for (int i = 0; i < lists.Count; i++)
                {
                    lists[i].Delete(false);
                }
                //DoQuery();
                MessageBox.Show("解除封闭成功！");
            }
            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()
        {
            
            

        }

        private void ultraGrid9_DoubleClickCell(object sender, DoubleClickCellEventArgs e)
        {
            


        }

        private void button1_Click(object sender, EventArgs e)
        {
            
        }
        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 QCM0309_Load(object sender, EventArgs e)
        {
            
        }

        private void ultraGrid2_DoubleClickCell(object sender, DoubleClickCellEventArgs e)
        {
            
        }

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

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