XinYu_LZMES_Client/Core.LZMes.Client.QCM/QCM04/QCM0404.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 Newtonsoft.Json;

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

        #region 窗体初始化
        public QCM0404()
        {
            InitializeComponent();
        }

        private void QCM0404_Load(object sender, EventArgs e)
        {
            dateTimePicker1.Value = DateTime.Now.Date.AddDays(-1);
            dateTimePicker2.Value = DateTime.Now.Date.AddDays(1);

            //检测中心是否合格
            ValueList v1 = new ValueList();
            v1.ValueListItems.Add("0", "否");
            v1.ValueListItems.Add("1", "是");
            ultraGrid1.DisplayLayout.Bands[0].Columns["MATWITNE"].ValueList = v1.Clone();
            ultraGrid5.DisplayLayout.Bands[0].Columns["MATWITNE"].ValueList = v1.Clone();
        }
        #endregion

        #region 功能
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    this.DoQuery();//查询
                    break;
                case "Add":
                    this.DoAdd();//认证申报
                    break;
                case "UnAdd":
                    this.DoUnAdd();//撤销认证申报
                    break;
                case "Excel":
                    ClsControlPack.ExportDataWithSaveDialog2(ref ultraGrid5, this.Text);
                    break;
           
            }
        }

        #endregion

        #region 功能事件
        #region 查询
        private void DoQuery()
        {
            try
            {
                String STARTTIME = this.dateTimePicker1.Value.ToString("yyyy-MM-dd");
                String ENDTIME = this.dateTimePicker2.Value.ToString("yyyy-MM-dd");
                String CERT_INST_NAME = this.textBox2.Text.Trim();//认证机构
                if (CERT_INST_NAME.Equals("全部"))
                {
                    CERT_INST_NAME = "";
                }
                String BATCH_NO = this.textBox1.Text.Trim();//轧批号
                String DESIGN_KEY = this.textBox4.Text.Trim();//销售订单号
                String STEEL_CODE = this.textBox3.Text.Trim();//牌号
                String radio = "全部";
                if (radio1.Checked)
                {
                    radio = "全部";
                }
                else if (radio2.Checked)
                {
                    radio = "1";
                }
                else if (radio3.Checked)
                {
                    radio = "0";
                }
                if (this.checkBox1.Checked)
                {
                    STARTTIME = "";
                    ENDTIME = "";
                }
                else
                {
                    BATCH_NO = "";
                }
                String PLINENAME = "全部";
                if (this.PLINE_NAME.Text.ToString().Trim().Equals("中板线"))
                {
                    PLINENAME = "ZB1";
                }
                else if (this.PLINE_NAME.Text.ToString().Trim().Equals("厚板线"))
                {
                    PLINENAME = "HB1";
                }

                Hashtable ht = new Hashtable();
                ht.Add("STARTTIME", STARTTIME);
                ht.Add("ENDTIME", ENDTIME);
                ht.Add("CERT_INST_NAME", CERT_INST_NAME);
                ht.Add("BATCH_NO", BATCH_NO);
                ht.Add("DESIGN_KEY", DESIGN_KEY);
                ht.Add("STEEL_CODE", STEEL_CODE);
                ht.Add("RADIO", radio);
                ht.Add("PLINENAME", PLINENAME);

                CoreClientParam ccp = new CoreClientParam();
                if (this.ultraTabControl1.Tabs[0].Selected) //委托信息
                {
                    this.dataSet1.Clear();
                    ccp.ServerName = "QCM.JHY01.JHY0103.QuerryThirdInfo";
                    ccp.MethodName = "getMatWitneD";
                    ccp.SourceDataTable = this.dataSet1.Tables[0];

                }else if (this.ultraTabControl1.Tabs[1].Selected) //申报委托记录
                {
                    this.dataSet2.Clear();
                    ccp.ServerName = "QCM.JHY01.JHY0103.QuerryThirdInfo";
                    ccp.MethodName = "getQcmMatWitneD";
                    ccp.SourceDataTable = this.dataSet2.Tables[0];
                }
                ccp.ServerParams = new object[] { ht };
                this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);

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

        #region 认证申报
        private void DoAdd()
        {
             try
            {
            List<UltraGridRow> lists = new List<UltraGridRow>();
            CoreClientParam ccp = new CoreClientParam();
            string SPECIMEN_NO = "";
            string fh = "";
            int num = 0;
            foreach (UltraGridRow ugr in this.ultraGrid1.Rows)
            {
                string specimeNo = "";
                if (ugr.Cells["CHECK"].Value.ToString().ToLower() == "true")
                {
                    String matwitne = ugr.Cells["MATWITNE"].Value.ToString();
                    if (matwitne.Equals("0"))
                    {
                        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;
                    }
                    lists.Add(ugr);
                }
            }

            ccp.ServerName = "QCM.JHY01.JHY0103.AddThirdInfo";
            ccp.MethodName = "addMatWitneD";
            ccp.ServerParams = new object[] { SPECIMEN_NO, this.UserInfo.GetUserID(), this.UserInfo.GetUserName() };
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                for (int i = 0; i < lists.Count; i++)
                {
                    lists[i].Delete(false);
                }
                MessageBox.Show("申报第三方见证委托成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.None);//ccp.ReturnInfo "发送成功" ccp.ReturnInfo
            }
            }
             catch (Exception ex)
             {
                 System.Diagnostics.Debug.WriteLine(ex.ToString());
                 MessageBox.Show("系统出错，请联系管理人员", "警告");
             }
        }
        #endregion

        #region 撤销认证申报
        private void DoUnAdd()
        {
            try
            {
                if (MessageBox.Show("确认撤销申报?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
                {
                    return;
                }

          
               if (this.ultraTabControl1.Tabs[1].Selected)
                {
                    foreach (UltraGridRow ugr in this.ultraGrid5.Rows)
                    {
                        if (ugr.Cells["CHECK"].Value.ToString().ToLower() == "true")
                        {
                            string SPECIMEN_NO = ugr.Cells["SPECIMEN_NO"].Value.ToString();
                            string BATCH_NO = ugr.Cells["BATCH_NO"].Value.ToString();
                            string MATERIAL_NO = ugr.Cells["MATERIAL_NO"].Value.ToString();
                            string PLINE_CODE = ugr.Cells["PLINE_CODE"].Value.ToString();
                            Hashtable ht = new Hashtable();
                            ht.Add("SPECIMEN_NO", SPECIMEN_NO);
                            ht.Add("USER_ID", this.UserInfo.GetUserID());
                            ht.Add("USER_NAME", this.UserInfo.GetUserName());
                            ht.Add("BATCH_NO", BATCH_NO);
                            ht.Add("MATERIAL_NO", MATERIAL_NO);
                            ht.Add("PLINE_CODE", PLINE_CODE);

                            CoreClientParam ccp = new CoreClientParam();
                            ccp.ServerName = "QCM.JHY01.JHY0103.DeleteMaterialInfo";
                            ccp.MethodName = "DoDelMatWitne";
                            ccp.ServerParams = new object[] { ht };
                            this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
                            if (ccp.ReturnCode == -1)
                            {
                                return;
                            }
                        }
                    }
                }
                this.DoQuery();
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                MessageBox.Show("系统出错，请联系管理人员", "警告");
            }
        }
        #endregion

        #endregion

        #region 其它事件

        #region 更新
        private void ultraGrid1_AfterHeaderCheckStateChanged(object sender, AfterHeaderCheckStateChangedEventArgs e)
        {
            ultraGrid1.UpdateData();
        }
        private void ultraGrid1_CellChange(object sender, CellEventArgs e)
        {
            ultraGrid1.UpdateData();

        }
        private void ultraGrid5_AfterHeaderCheckStateChanged(object sender, AfterHeaderCheckStateChangedEventArgs e)
        {
            ultraGrid5.UpdateData();
        }
        private void ultraGrid5_CellChange(object sender, CellEventArgs e)
        {
            ultraGrid5.UpdateData();
        }
        #endregion

        #endregion

        #region 按钮是否显示
        private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
        {
            if (this.ultraTabControl1.Tabs[0].Selected)
            {
                this.ToolBarItemEnable(this, "Add", true);
                this.ToolBarItemEnable(this, "UnAdd", false);
                this.ToolBarItemEnable(this, "Excel", false);
                checkBox2.Checked = false;
            }else if (this.ultraTabControl1.Tabs[1].Selected)
            {
                this.ToolBarItemEnable(this, "Add", false);
                this.ToolBarItemEnable(this, "UnAdd", true);
                this.ToolBarItemEnable(this, "Excel", true);
                checkBox2.Checked = false;
                
            }
           
        }
        #endregion

        private void checkBox1_Click(object sender, EventArgs e)
        {
            if (this.checkBox1.Checked)
            {
                this.dateTimePicker1.Enabled = false;
                this.dateTimePicker2.Enabled = false;
                this.textBox1.Enabled = true;
            }
            else
            {
                this.dateTimePicker1.Enabled = true;
                this.dateTimePicker2.Enabled = true;
                this.textBox1.Enabled = false;
            }
        }

        #region 全选
        private void checkBox2_CheckedChanged(object sender, EventArgs e)
        {
            if (this.ultraTabControl1.Tabs[0].Selected) //待申报
            {
                foreach (UltraGridRow ugr in this.ultraGrid1.Rows.Where(p => p.IsFilteredOut == false).ToList())
                {
                    if (checkBox2.Checked)
                    {
                        ugr.Cells["check"].Value = "True";
                    }
                    else
                    {
                        ugr.Cells["check"].Value = "False";
                    }
                }
            }
            else if (this.ultraTabControl1.Tabs[3].Selected) //申报记录
            {
                foreach (UltraGridRow ugr in this.ultraGrid5.Rows.Where(p => p.IsFilteredOut == false).ToList())
                {
                    if (checkBox2.Checked)
                    {
                        ugr.Cells["check"].Value = "True";
                    }
                    else
                    {
                        ugr.Cells["check"].Value = "False";
                    }
                }
            }

        }
        #endregion



    }
}