XinYu_LZMES_Client/.svn/pristine/ec/ece95c2f760b61fc2c8967d2ad65c529624555a9.svn-base

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;

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

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

        /// <summary>
        /// 查询原料库库存数据
        /// </summary>
        private void DoQuery()
        {
               try
                {
                   
                    this.dataSet1.Tables[0].Clear();
                    string startTime = this.ultraDateTimeEditor1.Value != null ? ultraDateTimeEditor1.DateTime.ToString("yyyyMMdd") : "";//入库开始时间
                    string endTime = this.ultraDateTimeEditor2.Value != null ? ultraDateTimeEditor2.DateTime.ToString("yyyyMMdd") : "";//入库结束时间

                    ArrayList al = new ArrayList();
              

                    if (this.ultraComboEditor1.Value.ToString() == "0")
                        {
                            al.Add("UIM070040_01.SELECT");
                            al.Add(startTime);
                            al.Add(startTime);
                            al.Add(startTime);
                        }
                    else if (this.ultraComboEditor1.Value.ToString() == "1")
                    {
                        al.Add("UIM070040_02.SELECT");
                        al.Add(startTime);
                        al.Add(endTime);
                        al.Add(startTime);
                        al.Add(endTime);
                        al.Add(startTime);
                        al.Add(endTime);
                    }
                    else if (this.ultraComboEditor1.Value.ToString() == "2")
                    {
                        al.Add("UIM070040_03.SELECT");
                        al.Add(startTime);
                        al.Add(endTime);
                        al.Add(startTime);
                        al.Add(endTime);
                      
                    }
                    else if (this.ultraComboEditor1.Value.ToString() == "3")
                    {
                        al.Add("UIM070040_04.SELECT");
                        al.Add(startTime);
                        al.Add(endTime);
                        al.Add(startTime);
                        al.Add(endTime);
                      
                    }
                    else if (this.ultraComboEditor1.Value.ToString() == "4")
                    {
                        al.Add("UIM070040_05.SELECT");
                        al.Add(startTime);
                        al.Add(endTime);
                        al.Add(startTime);
                        al.Add(endTime);
                        al.Add(startTime);
                        al.Add(endTime);

                    }

                
                      
                    this.dataSet1.Tables[0].Clear();
                    CoreClientParam ccp = new CoreClientParam();
                    ccp.ServerName = "UIB.COM.ComDBQuery";
                    ccp.MethodName = "doSimpleQuery";
                    ccp.ServerParams = new object[] { al };
                    ccp.SourceDataTable = this.dataSet1.Tables[0];
                    this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);

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

        /// <summary>
        /// 导出EXCEL
        /// </summary>
        private void Export()
        {
            try
            {
                if (this.saveFileDialog1.ShowDialog(this) == DialogResult.OK)
                {
                    string fileName = this.saveFileDialog1.FileName;
                    this.ultraGridExcelExporter1.Export(ultraGrid1, fileName);
                    System.Diagnostics.Process.Start(fileName);
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
        }


 

        private void UIM070040_Load(object sender, EventArgs e)
        {
            this.ultraComboEditor1.Text= "期初库存查询";
          
        }

        private void DoSave()
        {
            Infragistics.Win.UltraWinGrid.RowsCollection rs = null;
            ArrayList list = new ArrayList();
            string[] param = null;

            CoreClientParam ccp = new CoreClientParam();
            rs = this.ultraGrid1.Rows;
            for (int i = 0; i < rs.Count; i++)
            {
                if ("TRUE".Equals(rs[i].Cells["CHK"].Text.ToUpperInvariant()))
                {
                    param = new string[2];
                    param[0] = rs[i].Cells["LZBZ"].Text.ToString().Trim();
                    param[1] = rs[i].Cells["OLD_SAMPL_NO"].Value.ToString().Trim();

                    list.Add(param);
                }
            }
            ccp.ServerName = "UIM.UIM070040";
            ccp.MethodName = "addLzbz";
            ccp.ServerParams = new Object[] { list };
            this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
        }

        private void ultraGrid1_DoubleClickRow(object sender, Infragistics.Win.UltraWinGrid.DoubleClickRowEventArgs e)
        {
            try
            {
                if (this.ultraGrid1.ActiveRow != null)
                {
                    string COIL_NO = Convert.ToString(Common.FixDBManager.CheckNullStr(this.ultraGrid1.ActiveRow.Cells["H_COIL_NO"].Value));
                    UIM010081C frm = new UIM010081C();
                    frm.ob = this.ob;
                    frm.Condition = COIL_NO;
                    frm.ShowDialog();

                    //Core.LZMes.Client.UIB.UIB010301 frm = new Core.LZMes.Client.UIB.UIB010301();
                    //frm.ob = this.ob;
                    //frm.OrderNO = Common.FixDBManager.CheckNullStr(this.ugrd_RollPlan.ActiveRow.Cells["ORD_NO"].Value);
                    //frm.OrderSEQ = Common.FixDBManager.CheckNullStr(this.ugrd_RollPlan.ActiveRow.Cells["ORD_SEQ"].Value); ;
                    //frm.ShowDialog();
                }
            }
            catch (System.Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
            }
        }
    }
}