XinYu_LZMES_Client/Core.LZMes.Client.QCM/QCM02/QCM0211.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 Newtonsoft.Json;
using Newtonsoft.Json.Linq;

using Infragistics.Win;
using System.Diagnostics;



namespace Core.LZMes.Client.QCM
{
    public partial class QCM0211 : FrmBase
    {
        #region 初始变量
        public string specimenNo = "";//取样编号
        public string plineCode = "";//产线
        public string thick = "";//规格
        #endregion

        #region 初始化
        public QCM0211()
        {
            InitializeComponent();
        }

        //初始化的时候加载列
        private void QCM0211_Load(object sender, EventArgs e)
        {
            ValueList v1 = new ValueList();
            v1.ValueListItems.Add("0", "初样");
            v1.ValueListItems.Add("1", "复样");
            v1.ValueListItems.Add("3", "件件取样");
            this.ultraGrid1.DisplayLayout.Bands[0].Columns["SMP_TYPE_CODE"].ValueList = v1.Clone();

            DoQuery();

        }

        #endregion

        #region 功能
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    //this.DoQuery();
                    break;
                case "Add":
                    //this.DoAdd();
                    break;
            }
        }

        #region 查询

        private void DoQuery()
        {
            try
            {
                this.dataSet2.Clear();
                //查询数据库里的数据
                CoreClientParam ccp = new CoreClientParam();
                DataTable datatable = new DataTable();
                ccp.ServerName = "QCM.JHY01.JHY0101.QuerryQltySample";
                ccp.MethodName = "getQltyRZSpecimenNo";
                ccp.SourceDataTable = this.dataSet2.Tables[0];
                ccp.ServerParams = new object[] { specimenNo, plineCode, thick };
                this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
              
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                MessageBox.Show("系统出错，请联系管理人员", "警告");

            }

        }
        #endregion

        #region 新增
        private void button2_Click(object sender, EventArgs e)
        {
            this.DoAdd();
        }
        private void DoAdd()
        {
            try
            {

                string SPECIMEN_NO = "";
                string MATERIAL_NO = "";
                string fh = "";
                int num = 0;
                string SMP_TYPE_CODE = "";
                foreach (UltraGridRow ugr in this.ultraGrid1.Rows)
                {
                    string specimeNo = "";
                    string materialNo = "";
                    if (ugr.Cells["check"].Value.ToString().ToLower() == "true")
                    {
                        specimeNo = ugr.Cells["SPECIMEN_NO"].Value.ToString();
                        materialNo = ugr.Cells["OLD_SAMPL_NO"].Value.ToString();
                        SMP_TYPE_CODE = ugr.Cells["SMP_TYPE_CODE"].Value.ToString();
                        num = num + 1;
                        if (num <= 1)
                        {
                            SPECIMEN_NO = specimeNo;
                            MATERIAL_NO = materialNo;
                            fh = ",";
                        }
                        else
                        {
                            SPECIMEN_NO = SPECIMEN_NO + fh + specimeNo;
                            MATERIAL_NO = MATERIAL_NO + fh + materialNo;
                        }
                    }
                }
                if ("0".Equals(SMP_TYPE_CODE))
                {
                    if (num>=2)
                    {
                    this.alert("人工选样初样只能选一个!");
                    return;
                    }
                }
                else if ("1".Equals(SMP_TYPE_CODE))
                {
                    if (num >= 3)
                    {
                        this.alert("人工选样复样最多只能选择两个样!");
                        return;
                    }
                }

                Hashtable ht = new Hashtable();
                ht.Add("SMP_TYPE_CODE", SMP_TYPE_CODE);
                ht.Add("SPECIMEN_NO", SPECIMEN_NO);
                ht.Add("MATERIAL_NO", MATERIAL_NO);
                ht.Add("USERID", this.UserInfo.GetUserID().ToString());
                ht.Add("USERNAME", this.UserInfo.GetUserName().ToString());

                //查询数据库里的数据
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "QCM.JHY01.JHY0102.Send2";
                ccp.MethodName = "SendLimesRZXY";
                ccp.ServerParams = new object[] { ht, specimenNo };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                if (ccp.ReturnCode != -1)
                {
                    MessageBox.Show("选样发送成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.None);
                    this.Close();
                }
               

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

        #endregion

        #region 其它事件
        private void ultraGrid1_AfterHeaderCheckStateChanged(object sender, AfterHeaderCheckStateChangedEventArgs e)
        {
            ultraGrid1.UpdateData();
        }

        private void ultraGrid1_CellChange(object sender, CellEventArgs e)
        {
            ultraGrid1.UpdateData();
        }
        #endregion


   



   


    }
}