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(); } } }