XinYu_LZMES_Client/.svn/pristine/86/86bf5f6d39e062c72c7f79295b3727be1f9d8d76.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;
using System.Diagnostics;
using Infragistics.Win.UltraWinGrid;

namespace Core.LZMes.Client.UIC
{
    public partial class UIC020120 : FrmBase
    {
        public UIC020120()
        {
            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;
            }
        }

        private void DoExport()
        {
            try
            {
                if (this.ultraGrid1.Rows.Count == 0)
                {
                    MessageBox.Show("没有可以导出的数据", "提示");
                    return;
                }
                saveFileDialog1.FileName = "入库品种说明表"+DateTime.Today.ToShortDateString()+"_01";
                saveFileDialog1.Filter = "表格(*.xls)|*.xls";
                if (this.saveFileDialog1.ShowDialog(this) == DialogResult.OK)
                {
                    string fName = this.saveFileDialog1.FileName;
                    this.ultraGridExcelExporter1.Export(ultraGrid1, fName);
                    Process.Start(fName);
                }
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
            }
        }

        private void DoQuery()
        {
            try
            {
                this.dataSet1.Tables[0].Clear();
                ultraTextEditor4.Text = "";
                ultraTextEditor3.Text = "";

                ArrayList al = new ArrayList();

                if (ultraComboEditor2.Value.Equals("连退"))          
                    al.Add("UIC0201120_01.SELECT");//SQL语句的ID
                else
                    al.Add("UIC0201120_02.SELECT");//SQL语句的ID

                    al.Add(this.ultraDateTimeEditor1.DateTime.ToString("yyyyMMdd").Trim());
                    al.Add(this.ultraDateTimeEditor2.DateTime.ToString("yyyyMMdd").Trim());

                    al.Add(this.ultraDateTimeEditor3.DateTime.ToString("yyyyMMddHHmmss").Trim());
                    al.Add(this.ultraDateTimeEditor4.DateTime.ToString("yyyyMMddHHmmss").Trim());

                    al.Add(this.txtOLD_SAMPL_NO1.Text.Trim());
                    al.Add(this.txtOLD_SAMPL_NO2.Text.Trim());

                    al.Add("");
                
                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);

                if (this.ultraGrid1.Rows.Count > 0)
                {
                    int sumNum=0;
                    double sumWeight=0;
                    foreach(UltraGridRow ugr in this.ultraGrid1.Rows)
                    {
                        sumNum += int.Parse(ugr.Cells["COIL_CNT"].Text);
                        sumWeight += double.Parse(ugr.Cells["COIL_WGT"].Text);
                    }

                    ultraTextEditor3.Text = sumNum.ToString();
                    ultraTextEditor4.Text = sumWeight.ToString();
                    
                }
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
            }
        }


        private void ultraCheckEditor1_CheckedChanged(object sender, EventArgs e)
        {
            if (ultraCheckEditor1.Checked)
            {
                ultraGrid1.Rows.Band.Columns["INSTR_COIL_THK"].AllowRowFiltering = Infragistics.Win.DefaultableBoolean.True;
                ultraGrid1.Rows.Band.Columns["INSTR_COIL_WTH"].AllowRowFiltering = Infragistics.Win.DefaultableBoolean.True;
            }
            else
            {
                ultraGrid1.Rows.Band.ColumnFilters["INSTR_COIL_WTH"].FilterConditions.Clear();
                ultraGrid1.Rows.Band.ColumnFilters["INSTR_COIL_THK"].FilterConditions.Clear();

                ultraGrid1.Rows.Band.Columns["INSTR_COIL_THK"].AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
                ultraGrid1.Rows.Band.Columns["INSTR_COIL_WTH"].AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
               
             }
        }

        private void ultraCheckEditor2_CheckedChanged(object sender, EventArgs e)
        {
            if (ultraCheckEditor2.Checked)
            {
                ultraGrid1.Rows.Band.Columns["SPEC_STL_GRD"].AllowRowFiltering = Infragistics.Win.DefaultableBoolean.True;
            }
            else
            {
                ultraGrid1.Rows.Band.ColumnFilters["SPEC_STL_GRD"].FilterConditions.Clear();
                ultraGrid1.Rows.Band.Columns["SPEC_STL_GRD"].AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
            }
        }

        private void ultraCheckEditor3_CheckedChanged(object sender, EventArgs e)
        {
            if (ultraCheckEditor3.Checked)
                ultraGrid1.Rows.Band.Columns["EXTSHAPE_DEC_GRD"].AllowRowFiltering = Infragistics.Win.DefaultableBoolean.True;
            else
            {
                ultraGrid1.Rows.Band.ColumnFilters["EXTSHAPE_DEC_GRD"].FilterConditions.Clear();
                ultraGrid1.Rows.Band.Columns["EXTSHAPE_DEC_GRD"].AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
            }
        }

        private void ultraCheckEditor4_CheckedChanged(object sender, EventArgs e)
        {
            if (ultraCheckEditor4.Checked)
                ultraGrid1.Rows.Band.Columns["ORD_FL"].AllowRowFiltering = Infragistics.Win.DefaultableBoolean.True;
            else
            {
                ultraGrid1.Rows.Band.ColumnFilters["ORD_FL"].FilterConditions.Clear();
                ultraGrid1.Rows.Band.Columns["ORD_FL"].AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
            }
        }
    }
}