using System; using System.Linq; using System.Windows.Forms; 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; namespace Core.StlMes.Client.Mcp.Mch.Report { public partial class FrmMeasureDetailsReport : FrmBase { private string plineCode = ""; private string[] plineCodes = {}; public FrmMeasureDetailsReport() { InitializeComponent(); IsLoadUserView = true; } public override void ToolBar_Click(object sender, string ToolbarKey) { switch (ToolbarKey) { case "DoQuery": Query(); break; case "Export": GridHelper.ulGridToExcel(CrackDetectGrid, "测量点明细"); break; case "DoClose": Close(); break; case "ChangePline": ChangePline(); break; } } private void Query() { var Message = ""; var wf = new WaitingForm2("正在查询,请稍候...."); try { Cursor = Cursors.WaitCursor; QuerySinglePlan(); GridHelper.RefreshAndAutoSizeExceptColumns(CrackDetectGrid, "ReportPath"); } catch (Exception ex) { if (ex.Message.ToString2() != "") Message = ex.Message; } finally { wf.Close(); Cursor = Cursors.Default; } if (!string.IsNullOrWhiteSpace(Message)) MessageBox.Show(Message); } /// /// 测量点明细查询 /// private void QuerySinglePlan() { var startTim = ""; var endTim = ""; var shift = ""; //班次 var group = ""; //班组 var OrderNo = ""; var JudgeStoveNo = ""; var BatchNo = ""; #region if (chkOrder.Checked && (cmbOrder.Text.Trim() != "")) shift = cmbOrder.Value.ToString(); if (chkTim.Checked) { if (DateTime.Parse(RegStartTime.Value.ToString()) > DateTime.Parse(RegEndTime.Value.ToString())) { MessageUtil.ShowTips("选择时间区间错误,请重新选择!"); return; } startTim = RegStartTime.Value.ToString("yyyy-MM-dd HH:mm:ss"); endTim = RegEndTime.Value.ToString("yyyy-MM-dd HH:mm:ss"); } if (chkGroup.Checked && (cmbGroup.Text.Trim() != "")) group = cmbGroup.Value.ToString(); if (chkOrderNo.Checked) OrderNo = txtOrderNo.Text; if (chkJudgeStove.Checked) JudgeStoveNo = txtJudgeStove.Text; if (chkBatchNo.Checked) BatchNo = txtBatchNo.Text; #endregion var dt = ServerHelper.GetData("com.steering.mes.mcp.Mch.FrmJgxReport.doQueryMeasureDetailsResult", new object[] { shift, group, chkPlineCode.Checked && !string.IsNullOrWhiteSpace(plineCode) ? new[] {plineCode} : plineCodes, startTim, endTim, OrderNo, JudgeStoveNo, BatchNo, chkShow.Checked ? "1" : "0", chkFlag.Checked ? "1" : "0" }, ob); GridHelper.CopyDataToDatatable(ref dt, ref dataTable1, true); GridHelper.RefreshAndAutoSize(CrackDetectGrid); //mchMeasureResultEntityBindingSource.DataSource = EntityHelper.GetData( // "com.steering.mes.mcp.Mch.FrmJgxReport.doQueryMeasureResult", // new object[] { shift, group, plineCode == "" ? plineCodes : new[] { plineCode }, startTim, endTim, OrderNo, JudgeStoveNo }, // ob); //GridHelper.RefreshAndAutoSize(CrackDetectGrid); } private void FrmMeasureDetailsReport_Load(object sender, EventArgs e) { plineCodes = comm.InitDropPlineCodePower("G", txt_PlinCode, ValidDataPurviewIds, ob); if ((plineCodes.Length > 1) && ((plineCodes[1] == "C038") || (plineCodes[1] == "C039") || (plineCodes[1] == "C049") || (plineCodes[1] == "C050") || (plineCodes[1] == "C051") || (plineCodes[1] == "C057"))) { RegStartTime.Value = DateTime.Parse(DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd 20:00")); RegEndTime.Value = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd 19:59")); } else { 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")); } txt_PlinCode.SelectedIndex = 0; YdmBaseClass.SetComboItemHeight(cmbOrder); YdmBaseClass.SetComboItemHeight(cmbGroup); EntityHelper.ShowGridCaption(CrackDetectGrid.DisplayLayout.Bands[0]); QuerySinglePlan(); } private void chkStarts_CheckedChanged(object sender, EventArgs e) { if (chkTim.Checked) { RegStartTime.Enabled = true; RegEndTime.Enabled = true; RegStartTime.Visible = true; RegEndTime.Visible = true; label1.Visible = true; } else { RegStartTime.Enabled = false; RegEndTime.Enabled = false; RegStartTime.Visible = false; RegEndTime.Visible = false; label1.Visible = false; } cmbOrder.Enabled = chkOrder.Checked; cmbGroup.Enabled = chkGroup.Checked; txtOrderNo.Enabled = chkOrderNo.Checked; txtJudgeStove.Enabled = chkJudgeStove.Checked; txtBatchNo.Enabled = chkBatchNo.Checked; cmbOrder.Visible = chkOrder.Checked; cmbGroup.Visible = chkGroup.Checked; txtOrderNo.Visible = chkOrderNo.Checked; txtJudgeStove.Visible = chkJudgeStove.Checked; txtBatchNo.Visible = chkBatchNo.Checked; txt_PlinCode.Visible = chkPlineCode.Checked; } private void txt_PlinCode_TextChanged(object sender, EventArgs e) { plineCode = txt_PlinCode.SelectedItem.DataValue.ToString(); } private void ChangePline() { CrackDetectGrid.UpdateData(); var ids = CrackDetectGrid.Rows.Where(p => (bool) p.Cells["CHK"].Value) . Select(p => p.Cells["KEY_ID"].Value.ToString2()).Distinct().ToArray(); var FrmPlineChoose = new FrmPlineChoose(ob, ids); if (FrmPlineChoose.ShowDialog() == DialogResult.OK) Query(); } } }