using Core.Mes.Client.Comm.Control; using Core.Mes.Client.Comm.Tool; using Core.StlMes.Client.Mcp.Mch; using Core.StlMes.Client.YdmBcPipeManage.Entity; using CoreFS.CA06; 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; namespace Core.StlMes.Client.YdmBcPipeManage { public partial class FrmCrmOrderProduce : FrmBase { public FrmCrmOrderProduce() { InitializeComponent(); } protected override void OnLoad(EventArgs e) { base.OnLoad(e); EntityHelper.ShowGridCaption(ultraGrid1.DisplayLayout.Bands[0]); comm.RefreshAndAutoSize(ultraGrid1); } private void ChkOrderNo_CheckedChanged(object sender, EventArgs e) { this.OrderNoText.Enabled = ChkOrderNo.Checked; } public override void ToolBar_Click(object sender, string ToolbarKey) { switch (ToolbarKey) { case "Query": doQuery(); break; case "Export": doExport(); break; case "Close": this.Close(); break; } } /// /// 查询 /// public void doQuery() { string starttime = ""; string endtime = ""; string orderno = ""; if(ChkTime.Checked){ if (DateTime.Parse(this.StartTime.Value.ToString()) > DateTime.Parse(this.EndTime.Value.ToString())) { MessageUtil.ShowTips("开始时间不能大于结束时间!"); return; } else { starttime = StartTime.DateTime.ToString("yyyy-MM-dd") + " 00:00:00"; endtime = EndTime.DateTime.ToString("yyyy-MM-dd") + " 23:59:59"; } } if (ChkOrderNo.Checked) { orderno = OrderNoText.Text.ToString(); } if (!ChkTime.Checked && !ChkOrderNo.Checked) { MessageUtil.ShowTips("请选择至少一个筛选条件!"); return; } TimeSpan ts1 = new TimeSpan(DateTime.ParseExact(StartTime.DateTime.ToString("yyyy-MM-dd"), "yyyy-MM-dd", System.Globalization.CultureInfo.CurrentCulture).Ticks); TimeSpan ts2 = new TimeSpan(DateTime.ParseExact(EndTime.DateTime.ToString("yyyy-MM-dd"), "yyyy-MM-dd", System.Globalization.CultureInfo.CurrentCulture).Ticks); if (ts2.Subtract(ts1).Days > 30) { MessageUtil.ShowTips("最大查询30天的数据!"); return; } List listSource = EntityHelper.GetData( "com.steering.pss.crm.server.CrmOrderProduceServer.Query", new object[] { starttime, endtime , orderno }, this.ob); crmOrderProduceEntityBindingSource.DataSource = listSource; } /// /// 导出 /// public void doExport() { string title = ""; title += "生产进度信息"; GridHelper.ulGridToExcel(ultraGrid1, title); } } }