using com.steering.mes.mcp.entity; using Core.Mes.Client.Comm.Control; using Core.Mes.Client.Comm.Server; using Core.Mes.Client.Comm.Tool; using Core.StlMes.Client.Mcp.Control; 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.Mcp.Treatment.Report { public partial class FrmHlstrReport : FrmBase { private string SlGx = "";//工序代码 private string SlGxname = "";//工序名称 private string departm = ""; private string plineCode = ""; private string[] plineCodes = new string[] { }; public FrmHlstrReport() { InitializeComponent(); this.IsLoadUserView = true; } public override void ToolBar_Click(object sender, string ToolbarKey) { switch (ToolbarKey) { case "DoQuery": QuerySinglePlan(); break; case "Export": GridHelper.ulGridToExcel(ultraGrid4, "热处理热矫台账"); break; case "DoClose": this.Close(); break; } } /// /// 台账查询 /// private void QuerySinglePlan() { string startTim = ""; string endTim = ""; string shift = ""; //班次 string group = ""; //班组 #region if (this.chkOrder.Checked && this.cmbOrder.Text.Trim() != "") { shift = this.cmbOrder.Value.ToString(); } if (chkTim.Checked) { if (DateTime.Parse(RegStartTime.Value.ToString()) > DateTime.Parse(RegEndTime.Value.ToString())) { MessageUtil.ShowTips("选择时间区间错误,请重新选择!"); return; } else { startTim = this.RegStartTime.Value.ToString("yyyy-MM-dd HH:mm:ss"); endTim = this.RegEndTime.Value.ToString("yyyy-MM-dd HH:mm:ss"); } } if (this.chkGroup.Checked && this.cmbGroup.Text.Trim() != "") { group = this.cmbGroup.Value.ToString(); } #endregion DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.Report.FrmRclReport.doQueryHlatrResult", new object[] { shift, group, plineCode == "" ? plineCodes : new string[] { plineCode }, startTim, endTim }, this.ob); GridHelper.CopyDataToDatatable(ref dt, ref dataTable1, true); } private void FrmHlstrReport_Load(object sender, EventArgs e) { RegStartTime.Value = DateTime.Parse(DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd 21:00")); RegEndTime.Value = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd 20:59")); departm = UserInfo.GetDepartment(); //plineCode = YdmBaseClass.GetPCode(departm, this.ob);//获取 用户 对应的产线 plineCodes= comm.InitDropPlineCodePower("F", txt_PlinCode, this.ValidDataPurviewIds, this.ob); txt_PlinCode.SelectedIndex = 0; YdmBaseClass.SetComboItemHeight(cmbOrder); YdmBaseClass.SetComboItemHeight(cmbGroup); //获取工序 DataTable dt2 = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryGX", new object[] { "600206" }, this.ob); if (dt2.Rows.Count > 0) { SlGx = dt2.Rows[0]["BASECODE"].ToString(); SlGxname = dt2.Rows[0]["BASENAME"].ToString(); } QuerySinglePlan(); } private void chkStarts_CheckedChanged(object sender, EventArgs e) { if (chkTim.Checked) { RegStartTime.Enabled = true; RegEndTime.Enabled = true; } else { RegStartTime.Enabled = false; RegEndTime.Enabled = false; } if (chkOrder.Checked) { cmbOrder.Enabled = true; } else { cmbOrder.Enabled = false; } if (chkGroup.Checked) { cmbGroup.Enabled = true; } else { cmbGroup.Enabled = false; } } private void txt_PlinCode_TextChanged(object sender, EventArgs e) { plineCode = txt_PlinCode.SelectedItem.DataValue.ToString(); } } }