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; using Core.StlMes.Client.Mcp.VRP.Vrp; namespace Core.StlMes.Client.Mcp.VRP.Report { public partial class FrmPierCoSurInspeReport : FrmBase { private string SlGx = "";//墩粗工序 private string SlGxname = ""; private string departm = ""; private string plineCode = ""; public FrmPierCoSurInspeReport() { InitializeComponent(); } public override void ToolBar_Click(object sender, string ToolbarKey) { //base.ToolBar_Click(sender, ToolbarKey); switch (ToolbarKey) { case "DoQuery": QuerySinglePlan();//墩粗台账查询 break; case "Export": GridHelper.ulGridToExcel(ultraGrid2, "镦拔扩墩粗报表"); 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 VrpJumpingupFaceMEntity plan = new VrpJumpingupFaceMEntity(); plan.LoadShift = shift;//班次 plan.LoadGroup = group;//班组 //查询墩粗实绩 DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.Report.FrmPierCoSurInspeReport.doQueryInfoResult", new object[] { plan, plineCode, startTim, endTim }, this.ob); GridHelper.CopyDataToDatatable(ref dt, ref dtLoadRecord, true); } private void FrmPierCoSurInspeReport_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);//获取 用户 对应的产线 comm.InitDropPlinePower("E", txt_PlinCode, this.ValidDataPurviewIds, this.ob); txt_PlinCode.SelectedIndex = 0; //获取工序 DataTable dt2 = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryGX", new object[] { plineCode }, 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; } else { RegStartTime.Enabled = false; } if (chkTim.Checked) { RegEndTime.Enabled = true; } else { 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(); } } }