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.UIN
{
    public partial class UIN070010 : FrmBase
    {
        public UIN070010()
        {
            InitializeComponent();
        }

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

        private void DoQuery()
        {
            string DelToDateFrom = Convert.ToString(Common.FixDBManager.CheckNullStr(this.DelToDateFrom.DateTime.ToString("yyyyMMdd")));
            ArrayList al = new ArrayList();
            switch (Convert.ToString(Common.FixDBManager.CheckNullStr(this.ComboCalNO.Value)))
            {
                case "CJ":
                    al.Add("UIN070010_01.Select");
                    al.Add(DelToDateFrom);
                    al.Add(DelToDateFrom);
                    al.Add(DelToDateFrom);
                    al.Add(DelToDateFrom);
                    al.Add(DelToDateFrom);
                    al.Add(DelToDateFrom);
                    al.Add(DelToDateFrom);
                    al.Add(DelToDateFrom);
                    al.Add(DelToDateFrom);
                    al.Add(DelToDateFrom);
                    al.Add(DelToDateFrom);
                    al.Add(DelToDateFrom);
                    al.Add(DelToDateFrom);
                    al.Add(DelToDateFrom);
                    al.Add(DelToDateFrom);
                    al.Add(DelToDateFrom);
                    al.Add(DelToDateFrom);
                    al.Add(DelToDateFrom);
                    break;
                case "LT":
                    al.Add("UIN070010_02.Select");
                    al.Add(DelToDateFrom);
                    al.Add(DelToDateFrom);
                    al.Add(DelToDateFrom);
                    al.Add(DelToDateFrom);
                    al.Add(DelToDateFrom);
                    al.Add(DelToDateFrom);
                    al.Add(DelToDateFrom);
                    al.Add(DelToDateFrom);
                    al.Add(DelToDateFrom);
                    al.Add(DelToDateFrom);
                    al.Add(DelToDateFrom);
                    al.Add(DelToDateFrom);
                    al.Add(DelToDateFrom);
                    al.Add(DelToDateFrom);
                    al.Add(DelToDateFrom);
                    al.Add(DelToDateFrom);
                    al.Add(DelToDateFrom);
                    al.Add(DelToDateFrom);
                    break;
                case "SZ":
                    al.Add("UIN070010_03.Select");
                    al.Add(DelToDateFrom);
                    al.Add(DelToDateFrom);
                    al.Add(DelToDateFrom);
                    al.Add(DelToDateFrom);
                    al.Add(DelToDateFrom);
                    al.Add(DelToDateFrom);
                    al.Add(DelToDateFrom);
                    al.Add(DelToDateFrom);
                    al.Add(DelToDateFrom);
                    al.Add(DelToDateFrom);
                    al.Add(DelToDateFrom);
                    al.Add(DelToDateFrom);
                    al.Add(DelToDateFrom);
                    al.Add(DelToDateFrom);
                    al.Add(DelToDateFrom);
                    al.Add(DelToDateFrom);
                    al.Add(DelToDateFrom);
                    al.Add(DelToDateFrom);
                    break;
            }
            
            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);

            //Infragistics.Win.UltraWinGrid.RowsCollection rs = this.ultraGrid1.Rows;
            //if (rs.Count > 0)
            //{
            //    for (int i = 0; i < rs.Count; i++)
            //    {
            //        if (rs[i].Cells["ZBMC1"].Text.Trim() == "两率" && rs[i].Cells["ZBMC2"].Text.Trim() == "成材率" && rs[i].Cells["ZBMC3"].Text.Trim() == "不切边")
            //        {
            //            continue;
            //        }
            //        coilNo = coilNo + rs[i].Cells["EXIT_COIL_NO"].Text.Trim() + "|";
            //        //coilCutSEQ = coilCutSEQ + rs[i].Cells["COIL_CUT_SEQ"].Text.Trim() + "|";
            //        enCoilNo = enCoilNo + rs[i].Cells["EN_COIL_NO"].Text.Trim() + "|";
            //        actWgt = actWgt + rs[i].Cells["ACT_WGT"].Text.Trim() + "|";
            //        coilLen = coilLen + rs[i].Cells["COIL_LEN"].Text.Trim() + "|";
            //        coilWth = coilWth + rs[i].Cells["COIL_WTH"].Text.Trim() + "|";
            //        coilThk = coilThk + rs[i].Cells["COIL_THK"].Text.Trim() + "|";
            //        coilIndia = coilIndia + rs[i].Cells["COIL_INDIA"].Text.Trim() + "|";
            //        coilOutdia = coilOutdia + rs[i].Cells["COIL_OUTDIA"].Text.Trim() + "|";
            //        ordno = ordno + rs[i].Cells["ORDNO"].Text.Trim() + "|";
            //        rowCount += 1;
            //    }
            //}
        }
    }
}