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.Control; using Core.Mes.Client.Comm.Server; using Core.Mes.Client.Comm.Tool; using Core.StlMes.Client.LgCommon; using CoreFS.CA06; using Infragistics.Win.UltraWinGrid; namespace Core.StlMes.Client.LgResMgt { public partial class frmPlanQuery : FrmBase { public frmPlanQuery() { InitializeComponent(); } private DataTable dtData; protected override void OnLoad(EventArgs e) { base.OnLoad(e); var vlistGradeCode = ClsBusinessPack.GetValuelistSteel(ob); uceGrade.ValueList = vlistGradeCode; ClsBusinessPack.InitDropPlinePower("A", uceEafLine, this.ob); dateBegintime.Value = DateTime.Now; dateEndtime.Value = DateTime.Now; if (uceEafLine.Items.Count > 0) uceEafLine.SelectedIndex = 0; } public override void ToolBar_Click(object sender, string toolbarKey) { switch (toolbarKey) { case "Query": //查询 RefreshData(); break; case "Export": DoExport(); break; case "Print": DoPrint(); break; case "Close": //关闭 Close(); break; } } private void DoExport() { GridHelper.ulGridToExcel(ugPlan, "炼钢生产计划"); } private void DoPrint() { try { string strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepLgPlan.cpt&op=view&EF_PLINE_CODE={2}&GRADECODE={4}&JUDGE_STOVE_NO={3}&ORDER_NO={5}&PRO_MONTH1={0}&PRO_MONTH2={1}"; strurl = string.Format(strurl, ((DateTime) dateBegintime.Value).ToString("yyyyMMdd"), ((DateTime) dateEndtime.Value).ToString("yyyyMMdd"), ucEafLine.Checked && uceEafLine.SelectedIndex >= 0 ? uceEafLine.SelectedItem.DataValue.ToString() : "", ucJudgeStove.Checked ? txtStoveNo.Text : "", chcGrade.Checked && uceGrade.SelectedIndex >= 0 ? uceGrade.SelectedItem.DataValue.ToString() : "", uceOrder.Checked ? txtOrder.Text : "" ); FrmRepExcel fBug = new FrmRepExcel(ob, strurl) { AutoSize = true, MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height), Text = "炼钢生产计划打印" }; fBug.ShowDialog(); } catch (Exception ex) { MessageBox.Show("打印出错:" + ex.Message); } } private void RefreshData() { dtData = ServerHelper.GetData("Core.LgMes.Server.LgDeviceManager.PlanQuery.GetPlan", new object[] { ((DateTime)dateBegintime.Value).ToString("yyyyMMdd"), ((DateTime)dateEndtime.Value).ToString("yyyyMMdd"), ucEafLine.Checked && uceEafLine.SelectedIndex>=0 ? uceEafLine.SelectedItem.DataValue.ToString():"", ucJudgeStove.Checked ? txtStoveNo.Text :"", chcGrade.Checked && uceGrade.SelectedIndex>=0 ? uceGrade.SelectedItem.DataValue.ToString():"", uceOrder.Checked ? txtOrder.Text :"" }, ob); bindingSource1.DataSource = dtData; ugPlan.UpdateData(); ugPlan.Refresh(); foreach (UltraGridColumn ugc in ugPlan.DisplayLayout.Bands[0].Columns) { ugc.SortIndicator = SortIndicator.Disabled; ugc.CellActivation = Activation.ActivateOnly; ugc.PerformAutoResize(PerformAutoSizeType.AllRowsInBand); } //GridHelper.CopyDataToDatatable(dt, dtData, true); //ugPlan.DataSource = dt; } private void ugPlan_InitializeRow(object sender, InitializeRowEventArgs e) { if (dtData.Rows[e.Row.Index]["分切"].ToString() != "1") { e.Row.Appearance.BackColor = Color.LightBlue; } } } }