XinYu_LZMES_Client/Core.LZMes.Client.QCM/QCM02/QCM0207.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 System.Collections;
using CoreFS.CA06;
using Infragistics.Win.UltraWinGrid;
using Infragistics.Win;
using Newtonsoft.Json;
using Newtonsoft.Json.Linq;

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

        public QCM0207()
        {
            InitializeComponent();
        }

        private void QCM0207_Load(object sender, EventArgs e)
        {
            ValueList v1 = new ValueList();
            v1.ValueListItems.Add("0", "未发送");
            v1.ValueListItems.Add("1", "已引用");
            v1.ValueListItems.Add("2", "已接收");
            v1.ValueListItems.Add("3", "已完成");
            v1.ValueListItems.Add("7", "LIMS确认接收");
            this.ultraGrid1.DisplayLayout.Bands[0].Columns["STATUS"].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();

            ValueList v3 = new ValueList();
            v3.ValueListItems.Add("RZ1", "热轧");
            v3.ValueListItems.Add("LT1", "连退");
            v3.ValueListItems.Add("GX1", "高棒");
            v3.ValueListItems.Add("BC2", "棒二");
            v3.ValueListItems.Add("GX2", "二线厂");
            v3.ValueListItems.Add("HB1", "厚板");
            v3.ValueListItems.Add("ZB1", "中板");
            v3.ValueListItems.Add("YT1", "优特钢");
            this.ultraGrid3.DisplayLayout.Bands[0].Columns["PROD_LINE"].ValueList = v3.Clone();
        }

        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    this.DoQuery();
                    break;
                case "InExport":    
                    break;
            }
        }

        #region 查询按钮
        private void button1_Click(object sender, EventArgs e)
        {
            this.DoQuery();
        }
        #endregion

        #region 删除按钮
        private void button2_Click(object sender, EventArgs e)
        {
            this.DoDel();
        }
        #endregion

        #region 全选
        private void checkBox2_CheckedChanged(object sender, EventArgs e)
        {
            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";
                }
            }

        }
        #endregion

        #region 查询
        private void DoQuery()
        {
            try
            {
                String B_DK = "";
                String B_DESIGN_KEY = "";
                String B_BATCH_NO = "";
                if (!String.IsNullOrEmpty(this.txt_dk.Text.ToString()))
                {
                    B_DK = this.txt_dk.Text.ToString();
                }
                else
                {
                    B_DK = "全部";
                }
                if (!String.IsNullOrEmpty(this.txt_design_key.Text.ToString()))
                {
                    B_DESIGN_KEY = this.txt_design_key.Text.ToString();
                }
                else
                {
                    B_DESIGN_KEY = "全部";
                }
                if (!String.IsNullOrEmpty(this.txt_batch_no.Text.ToString()))
                {
                    B_BATCH_NO = this.txt_batch_no.Text.ToString();
                }
                else
                {
                    B_BATCH_NO = "全部";
                }

                if (B_DK.Equals("全部") && B_DESIGN_KEY.Equals("全部") && B_BATCH_NO.Equals("全部"))
                {
                    this.alert("请输入查询的订单号");
                    return;
                }
                Hashtable ht = new Hashtable();
                ht.Add("B_DK", B_DK);//合同号
                ht.Add("DESIGN_KEY", B_DESIGN_KEY);//订单号
                ht.Add("BATCH_NO", B_BATCH_NO);//轧批号
              
                CoreClientParam ccp = new CoreClientParam();
                if (this.TabControl.SelectedIndex == 0) //检验委托
                {
                this.dataSet2.Clear();
                ccp.ServerName = "QCM.JHY01.JHY0102.QuerryJhyQtly";
                ccp.MethodName = "getConsignD";
                ccp.SourceDataTable = this.dataSet2.Tables[0];
                }
                else
                {
                    this.dataSet3.Clear();
                    ccp.ServerName = "QCM.JHY01.JHY0102.QuerryJhyQtly";
                    ccp.MethodName = "getConsignDLog";
                    ccp.SourceDataTable = this.dataSet3.Tables[0];
                }
                ccp.ServerParams = new object[] { ht };
                this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
                ClsControlPack.RefreshAndAutoSize(ultraGrid1);
            }
            catch (Exception ex)
            {

                System.Diagnostics.Debug.WriteLine(ex.ToString());
                MessageBox.Show("查询异常！", "警告");
            }
        }
        #endregion

        #region 删除
        private void DoDel()
        {
             String memo = this.txt_memo.Text.ToString().Trim();
             if (string.IsNullOrEmpty(memo))
             {
                 this.alert("请输入删除原因!");
                 return;
              }
            foreach (UltraGridRow ugr in this.ultraGrid1.Rows)
            {
                if (ugr.Cells["check"].Value.ToString().ToLower() == "true")
                {
                    String DESIGN_KEY = ugr.Cells["DESIGN_KEY"].Value.ToString();
                    String BATCH_NO = ugr.Cells["BATCH_NO"].Value.ToString();
                    String SMP_NO = ugr.Cells["SMP_NO"].Value.ToString();
                    String SPECIMEN_NO = ugr.Cells["SPECIMEN_NO"].Value.ToString();
                    String QUOTE_CONSIGN_NO = ugr.Cells["QUOTE_CONSIGN_NO"].Value.ToString();
                    String FREQ_CODE = ugr.Cells["FREQ_CODE"].Value.ToString();
                    String STATUS = ugr.Cells["STATUS"].Value.ToString();
                    String JUDGE_RESULT_CODE = ugr.Cells["JUDGE_RESULT_CODE"].Value.ToString();
                    if (!STATUS.Equals("0") && (JUDGE_RESULT_CODE.Equals("1") || JUDGE_RESULT_CODE.Equals("2")))
                    {
                        this.alert("订单号【" + DESIGN_KEY + "】轧批号【" + BATCH_NO + "】试样号【" + SMP_NO + "】已材质判定请撤销材质判定!");
                        return;
                    }

                    if (!STATUS.Equals("0") && !FREQ_CODE.Equals("D"))
                    {
                        this.alert("订单号【" + DESIGN_KEY + "】轧批号【" + BATCH_NO + "】取样编号【" + SPECIMEN_NO + "】已下发委托未撤回!请核实数据!");
                        return;
                    }

                    if (!STATUS.Equals("0") && FREQ_CODE.Equals("D") && string.IsNullOrEmpty(QUOTE_CONSIGN_NO))
                    {
                        this.alert("订单号【" + DESIGN_KEY + "】轧批号【" + BATCH_NO + "】取样编号【" + SPECIMEN_NO + "】送样夹杂已下发委托未撤回!请核实数据!");
                        return;
                    }
                }
            }

           
            foreach (UltraGridRow ugr in this.ultraGrid1.Rows)
            {
                if (ugr.Cells["check"].Value.ToString().ToLower() == "true")
                {
                    String DESIGN_KEY = ugr.Cells["DESIGN_KEY"].Value.ToString();
                    String BATCH_NO = ugr.Cells["BATCH_NO"].Value.ToString();
                    String SMP_NO = ugr.Cells["SMP_NO"].Value.ToString();
                    String SPECIMEN_NO = ugr.Cells["SPECIMEN_NO"].Value.ToString();
                    String QUOTE_CONSIGN_NO = ugr.Cells["QUOTE_CONSIGN_NO"].Value.ToString();
                    String FREQ_CODE = ugr.Cells["FREQ_CODE"].Value.ToString();
                    String STATUS = ugr.Cells["STATUS"].Value.ToString();
                    String MATERIAL_NO = ugr.Cells["MATERIAL_NO"].Value.ToString();
                    String PLINE_CODE = ugr.Cells["PLINE_CODE"].Value.ToString();
                
                    Hashtable hb = new Hashtable();
                    hb.Add("DESIGN_KEY", DESIGN_KEY);
                    hb.Add("BATCH_NO", BATCH_NO);
                    hb.Add("SMP_NO", SMP_NO);
                    hb.Add("SPECIMEN_NO", SPECIMEN_NO);
                    hb.Add("QUOTE_CONSIGN_NO", QUOTE_CONSIGN_NO);
                    hb.Add("FREQ_CODE", FREQ_CODE);
                    hb.Add("STATUS", STATUS);
                    hb.Add("MATERIAL_NO", MATERIAL_NO);
                    hb.Add("PLINE_CODE", PLINE_CODE);
                    hb.Add("USER_NAME", this.UserInfo.GetUserName());
                    hb.Add("MEMO", memo);

                    CoreClientParam ccp = new CoreClientParam();
                    ccp.ServerName = "QCM.JHY01.JHY0102.UpdateInfo";
                    ccp.MethodName = "doDelAllWT";
                    ccp.ServerParams = new object[] { hb };
                    ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

                }
            }
            this.alert("删除成功");
            this.DoQuery();
        }
        #endregion


    }
}