MES_Client/TGMES/Core.StlMes.Client.Lims.Data.PipeAndOutdec/数据管理/钢管实验管理/FrmPdDate.cs

using Core.Mes.Client.Comm.Control;
using Core.Mes.Client.Comm.Server;
using CoreFS.CA06;
using Infragistics.Win.UltraWinGrid;
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 Core.Mes.Client.Comm.Tool;


namespace Core.StlMes.Client.Lims.Data.FrmPdDate.数据管理.钢管实验管理
{
    public partial class FrmPdDate : FrmBase
    {
        public FrmPdDate()
        {
            InitializeComponent();
        }
        protected override void OnLoad(EventArgs e)
        {
            base.OnLoad(e);
            InitColumns();
           
        }
        private void InitColumns()
        {

            DateTime now = DateTime.Now;
            DateTime date = new DateTime(now.Year, now.Month, 1);
            cmbDate.Value = DateTime.Parse(date.ToString("yyyy-MM-dd 07:00"));
            cmbEndDate.Value = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd HH:mm"));

            //加载产线
            DataTable dt = PipeAndOutdec.PublicServer.GetData("com.steering.lims.data.pipe.FrmCheckConsignAdd.queryPlineCode", new object[] { }, ob);
            if (dt != null && dt.Rows.Count > 0)
            {
                ultraPLINE_CODE.DataSource = dt;
                ultraPLINE_CODE.ValueMember = "PLINE_CODE";
                ultraPLINE_CODE.DisplayMember = "PLINE_NAME";

                //ucPlineCode.DataSource = dt;
                //ucPlineCode.ValueMember = "PLINE_CODE_A";
                //ucPlineCode.DisplayMember = "PLINE_NAME";
            }

        }

        //private void ultraGroupBox1_Click(object sender, EventArgs e)
        //{

        //}

        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    doQuery();
                    break;
                case "Export":
                   // ExportData();
                    break;
                case "Close":
                    this.Close();
                    break;
            }
        }
        private void doQuery()
        {
            string date = "";
            string endDate = "";
            string CHECK_NO = "";
            string CONTRACT_NO = "";
            string HEAT_NO = "";
            string PLINE_CODE = "";

            if (chkDate.Checked)
            {
                if (DataTimeUtil.JudgeTime(DateTime.Parse(cmbDate.Value.ToString()), DateTime.Parse(cmbEndDate.Value.ToString())) == 0)
                {
                    MessageUtil.ShowTips("您所选择的日期区域不对,请重新选择！");
                    return;
                }
                else
                {
                    date = cmbDate.Value.ToString();
                    endDate = cmbEndDate.Value.ToString();
                }
            }
            if (chkCHECK_NO.Checked)
            {
                if (ultraCHECK_NO.Text.Trim() == "")
                {
                    CHECK_NO = "";
                }
                else
                {
                    CHECK_NO = ultraCHECK_NO.Value.ToString();
                }
            }
            if (chkCONTRACT_NO.Checked)
            {
                if (ultraCONTRACT_NO.Text.Trim() == "")
                {
                    CONTRACT_NO = "";
                }
                else
                {
                    CONTRACT_NO = ultraCONTRACT_NO.Value.ToString();
                }
            }
            if (chkHEAT_NO.Checked)
            {
                if (ultraHEAT_NO.Text.Trim() == "")
                {
                    HEAT_NO = "";
                }
                else
                {
                    HEAT_NO = ultraHEAT_NO.Value.ToString();
                }
            }

            if (chkPLINE_CODE.Checked)
            {
                if (ultraPLINE_CODE.Text.Trim() == "")
                {
                    PLINE_CODE = "";
                }
                else
                {
                    PLINE_CODE = ultraPLINE_CODE.Value.ToString().Substring(0, 4);
                }
            }

            if (CHECK_NO + CONTRACT_NO + HEAT_NO + PLINE_CODE + date == "")
            {
                MessageBox.Show("请输入查询条件");
                return;
            }
           // WaitingForm2 wf = new WaitingForm2("正在加载,请稍候....");
            DataTable dt = PipeAndOutdec.PublicServer.GetData("com.steering.lims.data.pipe.FrmCheckConsignAdd.queryPdDate", new Object[] { date, endDate, CHECK_NO, CONTRACT_NO, HEAT_NO, PLINE_CODE }, this.ob);
            if (dt == null || dt.Rows.Count == 0)
            {
                MessageBox.Show("没有找到数据，请重新输入查询条件！");
                return;
            }
            GridHelper.CopyDataToDatatable(dt, this.dataTable1, true);
            GridHelper.RefreshAndAutoSize(this.ugMain);
           // wf.Close();
        }
    }


}