XinYu_LZMES_Client/Core.LZMes.Client.UIN/UIN07/UIN070020.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;

namespace Core.LZMes.Client.UIN
{
    public partial class UIN070020 : FrmBase
    {
        public UIN070020()
        {
            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 OLD_SAMPL_NO1 = Convert.ToString(Common.FixDBManager.CheckNullStr(this.OLD_SAMPL_NO1.Text));
            string OLD_SAMPL_NO2 = Convert.ToString(Common.FixDBManager.CheckNullStr(this.OLD_SAMPL_NO2.Text));
            string OLD_SAMPL_NO3 = Convert.ToString(Common.FixDBManager.CheckNullStr(this.OLD_SAMPL_NO3.Text));
            string OLD_SAMPL_NO4 = Convert.ToString(Common.FixDBManager.CheckNullStr(this.OLD_SAMPL_NO4.Text));

            string ORDNO1 = Convert.ToString(Common.FixDBManager.CheckNullStr(this.ORDNO1.Text));
            string ORDNO2 = Convert.ToString(Common.FixDBManager.CheckNullStr(this.ORDNO2.Text));
            string ORDNO3 = Convert.ToString(Common.FixDBManager.CheckNullStr(this.ORDNO3.Text));
            string ORDNO4 = Convert.ToString(Common.FixDBManager.CheckNullStr(this.ORDNO4.Text));

            string MILL_DTIME2_FR = Convert.ToString(Common.FixDBManager.CheckNullStr(this.MILL_DTIME2_FR.DateTime.ToString("yyyyMMdd")));
            string MILL_DTIME3_FR = Convert.ToString(Common.FixDBManager.CheckNullStr(this.MILL_DTIME3_FR.DateTime.ToString("yyyyMMdd")));
            string MILL_DTIME4_FR = Convert.ToString(Common.FixDBManager.CheckNullStr(this.MILL_DTIME4_FR.DateTime.ToString("yyyyMMdd")));

            string MILL_DTIME2_EN = Convert.ToString(Common.FixDBManager.CheckNullStr(this.MILL_DTIME2_EN.DateTime.ToString("yyyyMMdd")));
            string MILL_DTIME3_EN = Convert.ToString(Common.FixDBManager.CheckNullStr(this.MILL_DTIME3_EN.DateTime.ToString("yyyyMMdd")));
            string MILL_DTIME4_EN = Convert.ToString(Common.FixDBManager.CheckNullStr(this.MILL_DTIME4_EN.DateTime.ToString("yyyyMMdd")));

            string YARD_ENTRY_DTIME1_ST = Convert.ToString(Common.FixDBManager.CheckNullStr(this.YARD_ENTRY_DTIME1_ST.DateTime.ToString("yyyyMMdd")));
            string YARD_ENTRY_DTIME2_ST = Convert.ToString(Common.FixDBManager.CheckNullStr(this.YARD_ENTRY_DTIME2_ST.DateTime.ToString("yyyyMMdd")));
            string YARD_ENTRY_DTIME3_ST = Convert.ToString(Common.FixDBManager.CheckNullStr(this.YARD_ENTRY_DTIME3_ST.DateTime.ToString("yyyyMMdd")));
            string YARD_ENTRY_DTIME4_ST = Convert.ToString(Common.FixDBManager.CheckNullStr(this.YARD_ENTRY_DTIME4_ST.DateTime.ToString("yyyyMMdd")));

            string YARD_ENTRY_DTIME1_EN = Convert.ToString(Common.FixDBManager.CheckNullStr(this.YARD_ENTRY_DTIME1_EN.DateTime.ToString("yyyyMMdd")));
            string YARD_ENTRY_DTIME2_EN = Convert.ToString(Common.FixDBManager.CheckNullStr(this.YARD_ENTRY_DTIME2_EN.DateTime.ToString("yyyyMMdd")));
            string YARD_ENTRY_DTIME3_EN = Convert.ToString(Common.FixDBManager.CheckNullStr(this.YARD_ENTRY_DTIME3_EN.DateTime.ToString("yyyyMMdd")));
            string YARD_ENTRY_DTIME4_EN = Convert.ToString(Common.FixDBManager.CheckNullStr(this.YARD_ENTRY_DTIME4_EN.DateTime.ToString("yyyyMMdd")));
                   
            string YARD_EXIT_DTIME1_FR = Convert.ToString(Common.FixDBManager.CheckNullStr(this.YARD_EXIT_DTIME1_FR.DateTime.ToString("yyyyMMdd")));
            string YARD_EXIT_DTIME2_FR = Convert.ToString(Common.FixDBManager.CheckNullStr(this.YARD_EXIT_DTIME2_FR.DateTime.ToString("yyyyMMdd")));
            string YARD_EXIT_DTIME3_FR = Convert.ToString(Common.FixDBManager.CheckNullStr(this.YARD_EXIT_DTIME3_FR.DateTime.ToString("yyyyMMdd")));
            string YARD_EXIT_DTIME4_FR = Convert.ToString(Common.FixDBManager.CheckNullStr(this.YARD_EXIT_DTIME4_FR.DateTime.ToString("yyyyMMdd")));
                   
            string YARD_EXIT_DTIME1_EN = Convert.ToString(Common.FixDBManager.CheckNullStr(this.YARD_EXIT_DTIME1_EN.DateTime.ToString("yyyyMMdd")));
            string YARD_EXIT_DTIME2_EN = Convert.ToString(Common.FixDBManager.CheckNullStr(this.YARD_EXIT_DTIME2_EN.DateTime.ToString("yyyyMMdd")));
            string YARD_EXIT_DTIME3_EN = Convert.ToString(Common.FixDBManager.CheckNullStr(this.YARD_EXIT_DTIME3_EN.DateTime.ToString("yyyyMMdd")));
            string YARD_EXIT_DTIME4_EN = Convert.ToString(Common.FixDBManager.CheckNullStr(this.YARD_EXIT_DTIME4_EN.DateTime.ToString("yyyyMMdd")));
            /*
            if (OLD_SAMPL_NO1.Equals("") && OLD_SAMPL_NO2.Equals("") && OLD_SAMPL_NO3.Equals("") && OLD_SAMPL_NO4.Equals(""))
            {
                System.Windows.Forms.MessageBox.Show("查询条件不能全部为空！");
                return;
            }*/
            if (int.Parse(MILL_DTIME2_EN) - int.Parse(MILL_DTIME2_FR) > 7 |
                int.Parse(MILL_DTIME3_EN) - int.Parse(MILL_DTIME3_FR) > 7 |
                int.Parse(MILL_DTIME4_EN) - int.Parse(MILL_DTIME4_FR) > 7 |

                int.Parse(YARD_ENTRY_DTIME1_EN) - int.Parse(YARD_ENTRY_DTIME1_ST) > 7 |
                int.Parse(YARD_ENTRY_DTIME2_EN) - int.Parse(YARD_ENTRY_DTIME2_ST) > 7 |
                int.Parse(YARD_ENTRY_DTIME3_EN) - int.Parse(YARD_ENTRY_DTIME3_ST) > 7 |
                int.Parse(YARD_ENTRY_DTIME4_EN) - int.Parse(YARD_ENTRY_DTIME4_ST) > 7 |

                int.Parse(YARD_EXIT_DTIME1_EN) - int.Parse(YARD_EXIT_DTIME1_FR) > 7 |
                int.Parse(YARD_EXIT_DTIME2_EN) - int.Parse(YARD_EXIT_DTIME2_FR) > 7 |
                int.Parse(YARD_EXIT_DTIME3_EN) - int.Parse(YARD_EXIT_DTIME3_FR) > 7 |
                int.Parse(YARD_EXIT_DTIME4_EN) - int.Parse(YARD_EXIT_DTIME4_FR) > 7 
                )
            {
                System.Windows.Forms.MessageBox.Show("查询时间跨度太大，不能超过一周！");
                return;
            }
            if (MILL_DTIME2_FR.Equals("17530101")) { MILL_DTIME2_FR = ""; }
            if (MILL_DTIME3_FR.Equals("17530101")) { MILL_DTIME3_FR = ""; }
            if (MILL_DTIME4_FR.Equals("17530101")) { MILL_DTIME4_FR = ""; }

            if (MILL_DTIME2_EN.Equals("17530101")) { MILL_DTIME2_EN = ""; }
            if (MILL_DTIME3_EN.Equals("17530101")) { MILL_DTIME3_EN = ""; }
            if (MILL_DTIME4_EN.Equals("17530101")) { MILL_DTIME4_EN = ""; }

            if (YARD_ENTRY_DTIME1_ST.Equals("17530101")) { YARD_ENTRY_DTIME1_ST = ""; }
            if (YARD_ENTRY_DTIME2_ST.Equals("17530101")) { YARD_ENTRY_DTIME2_ST = ""; }
            if (YARD_ENTRY_DTIME3_ST.Equals("17530101")) { YARD_ENTRY_DTIME3_ST = ""; }
            if (YARD_ENTRY_DTIME4_ST.Equals("17530101")) { YARD_ENTRY_DTIME4_ST = ""; }

            if (YARD_ENTRY_DTIME1_EN.Equals("17530101")) { YARD_ENTRY_DTIME1_EN = ""; }
            if (YARD_ENTRY_DTIME2_EN.Equals("17530101")) { YARD_ENTRY_DTIME2_EN = ""; }
            if (YARD_ENTRY_DTIME3_EN.Equals("17530101")) { YARD_ENTRY_DTIME3_EN = ""; }
            if (YARD_ENTRY_DTIME4_EN.Equals("17530101")) { YARD_ENTRY_DTIME4_EN = ""; }

            if (YARD_EXIT_DTIME1_FR.Equals("17530101")) { YARD_EXIT_DTIME1_FR = ""; }
            if (YARD_EXIT_DTIME2_FR.Equals("17530101")) { YARD_EXIT_DTIME2_FR = ""; }
            if (YARD_EXIT_DTIME3_FR.Equals("17530101")) { YARD_EXIT_DTIME3_FR = ""; }
            if (YARD_EXIT_DTIME4_FR.Equals("17530101")) { YARD_EXIT_DTIME4_FR = ""; }

            if (YARD_EXIT_DTIME1_EN.Equals("17530101")) { YARD_EXIT_DTIME1_EN = ""; }
            if (YARD_EXIT_DTIME2_EN.Equals("17530101")) { YARD_EXIT_DTIME2_EN = ""; }
            if (YARD_EXIT_DTIME3_EN.Equals("17530101")) { YARD_EXIT_DTIME3_EN = ""; }
            if (YARD_EXIT_DTIME4_EN.Equals("17530101")) { YARD_EXIT_DTIME4_EN = ""; }
            ArrayList al = new ArrayList();
            al.Add("UIN070020_01.Select");
            al.Add(OLD_SAMPL_NO1);
            al.Add(OLD_SAMPL_NO2);
            al.Add(OLD_SAMPL_NO3);
            al.Add(OLD_SAMPL_NO4);

            al.Add(ORDNO1);
            al.Add(ORDNO2);
            al.Add(ORDNO3);
            al.Add(ORDNO4);

            al.Add(MILL_DTIME2_FR);
            al.Add(MILL_DTIME2_EN);
            //al.Add(MILL_DTIME2_EN);
            al.Add(MILL_DTIME3_FR);
            al.Add(MILL_DTIME3_EN);
            //al.Add(MILL_DTIME3_EN);
            al.Add(MILL_DTIME4_FR);
            al.Add(MILL_DTIME4_EN);
            //al.Add(MILL_DTIME4_EN);

            al.Add(YARD_ENTRY_DTIME1_ST);
            al.Add(YARD_ENTRY_DTIME1_EN);
            //al.Add(YARD_ENTRY_DTIME1_EN);
            al.Add(YARD_ENTRY_DTIME2_ST);
            al.Add(YARD_ENTRY_DTIME2_EN);
            //al.Add(YARD_ENTRY_DTIME2_EN);
            al.Add(YARD_ENTRY_DTIME3_ST);
            al.Add(YARD_ENTRY_DTIME3_EN);
            //al.Add(YARD_ENTRY_DTIME3_EN);
            al.Add(YARD_ENTRY_DTIME4_ST);
            al.Add(YARD_ENTRY_DTIME4_EN);
            //al.Add(YARD_ENTRY_DTIME4_EN);

            al.Add(YARD_EXIT_DTIME1_FR);
            al.Add(YARD_EXIT_DTIME1_EN);
            //al.Add(YARD_EXIT_DTIME1_EN);
            al.Add(YARD_EXIT_DTIME2_FR);
            al.Add(YARD_EXIT_DTIME2_EN);
            //al.Add(YARD_EXIT_DTIME2_EN);
            al.Add(YARD_EXIT_DTIME3_FR);
            al.Add(YARD_EXIT_DTIME3_EN);
            //al.Add(YARD_EXIT_DTIME3_EN);
            al.Add(YARD_EXIT_DTIME4_FR);
            al.Add(YARD_EXIT_DTIME4_EN);
            //al.Add(YARD_EXIT_DTIME4_EN);
            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;
            //    }
            //}
        }
    }
}