XinYu_LZMES_Client/Core.LZMes.Client.UIM/UIM05/UIM080010.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.Diagnostics;
using System.Collections;

namespace Core.LZMes.Client.UIM
{
    public partial class UIM080010 : FrmBase
    {
        public UIM080010()
        {
            InitializeComponent();
        }

        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "query":
                    this.DoQuery();
                    break;
                case "export":
                    this.DoExport();
                    break;
                case "Exit":
                    this.Close();
                    break;
            }
        }

        /// <summary>
        /// 查询成品库库存数据
        /// </summary>
        private void DoQuery()
        {
            try
            {
                this.dataSet1.Clear();
                string coilNo = this.textBox9.Text;//钢卷号
                //string starttime = ultraDateTimeEditor2.Value != null ? ultraDateTimeEditor1.DateTime.ToString("yyyyMMdd") : "";
               // string endtime = ultraDateTimeEditor3.Value != null ? ultraDateTimeEditor1.DateTime.ToString("yyyyMMdd") : "";            
                string[] queryParams = new string[] { coilNo};
                List<string[]> list = new List<String[]>();
                list.Add(queryParams);
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "UIM.UIM010232";
                ccp.MethodName = "queryPackList";
                ccp.ServerParams = new object[] {list};
                ccp.SourceDataTable = this.dataSet1.Tables[0];
                this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);

            }


            catch (Exception EX)
            {
                MessageBox.Show(EX.ToString());
            }
        }
        private void DoQuerypack()
        {
            try
            {
                this.dataSet2.Clear();
              //  string coilNo = this.textBox9.Text;//钢卷号
                string coilno1="";
                string[] queryParams = new string[] { coilno1 };
                List<string[]> list = new List<String[]>();
                list.Add(queryParams);
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "UIM.UIM010232";
                ccp.MethodName = "queryPackwaitList";
                ccp.ServerParams = new object[] { list };
                ccp.SourceDataTable = this.dataSet2.Tables[0];
                this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);

            }


            catch (Exception EX)
            {
                MessageBox.Show(EX.ToString());
            }
        }

        private void addpacktime()
        {

            foreach (Infragistics.Win.UltraWinGrid.UltraGridRow ugr in ultraGrid2.Rows)
            {
                if (ugr.Cells["CHK"].Text == "True")
                {   
                    if (this.ultraDateTimeEditor1.Value.ToString()=="")
                        MessageBox.Show("请选择截止时间");
                    string coilno = ugr.Cells["OLD_SAMPL_NO"].Text.ToString();
                    string colsetime = ultraDateTimeEditor1.Value != null ? ultraDateTimeEditor1.DateTime.ToString("yyyyMMdd") : "";         
                    CoreClientParam ccp3 = new CoreClientParam();
                    ccp3.ServerName = "UIB.COM.ComDBSave";
                    ccp3.MethodName = "doXmlSave";
                    ArrayList paramArray1 = new ArrayList();
                    paramArray1.Add("UIM010232_04.UPDATE");
                    paramArray1.Add(colsetime);
                    paramArray1.Add(coilno);
                    ccp3.ServerParams = new object[] { paramArray1 };
                    this.ExecuteNonQuery(ccp3, CoreInvokeType.Internal);
       
                }
            }
            DoQuery();
            DoQuerypack();
        
        }

        private void deletepacktime()
        {

            foreach (Infragistics.Win.UltraWinGrid.UltraGridRow ugr in ultraGrid1.Rows)
            {
                if (ugr.Cells["CHK"].Text == "True")
                {
                    string coilno = ugr.Cells["OLD_SAMPL_NO"].Text.ToString();
                   // string colsetime = ultraDateTimeEditor1.Value != null ? ultraDateTimeEditor1.DateTime.ToString("yyyyMMdd") : "";
                    CoreClientParam ccp = new CoreClientParam();
                    ccp.ServerName = "UIB.COM.ComDBSave";
                    ccp.MethodName = "doXmlSave";
                    ArrayList paramArray = new ArrayList();
                    paramArray.Add("UIM010232_05.UPDATE");
                   // paramArray1.Add(colsetime);
                    paramArray.Add(coilno);
                    ccp.ServerParams = new object[] {paramArray};
                    this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

                }
            }
            DoQuery();
            DoQuerypack();//查询

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

        private void btn_Add_Click(object sender, EventArgs e)
        {
            addpacktime();
        }

        private void btn_Del_Click(object sender, EventArgs e)
        {
            deletepacktime();
        }

        private void UIM080010_Load(object sender, EventArgs e)
        {
            DoQuerypack();
        }


    }
}