FrmMeasureDetailsReport.cs 7.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208
  1. using System;
  2. using System.Linq;
  3. using System.Windows.Forms;
  4. using com.steering.mes.mcp.entity;
  5. using Core.Mes.Client.Comm.Control;
  6. using Core.Mes.Client.Comm.Server;
  7. using Core.Mes.Client.Comm.Tool;
  8. using Core.StlMes.Client.Mcp.Control;
  9. using CoreFS.CA06;
  10. using Core.StlMes.Client.Mcp.Mch.Report;
  11. namespace Core.StlMes.Client.Mcp.Mch.Mcms
  12. {
  13. public partial class FrmMeasureDetailsReport : FrmBase
  14. {
  15. private string plineCode = "";
  16. private string[] plineCodes = {};
  17. public FrmMeasureDetailsReport()
  18. {
  19. InitializeComponent();
  20. IsLoadUserView = true;
  21. }
  22. public override void ToolBar_Click(object sender, string ToolbarKey)
  23. {
  24. switch (ToolbarKey)
  25. {
  26. case "DoQuery":
  27. Query();
  28. break;
  29. case "Export":
  30. GridHelper.ulGridToExcel(CrackDetectGrid, "测量点明细");
  31. break;
  32. case "DoClose":
  33. Close();
  34. break;
  35. case "ChangePline":
  36. ChangePline();
  37. break;
  38. }
  39. }
  40. private void Query()
  41. {
  42. var Message = "";
  43. var wf = new WaitingForm2("正在查询,请稍候....");
  44. try
  45. {
  46. Cursor = Cursors.WaitCursor;
  47. QuerySinglePlan();
  48. GridHelper.RefreshAndAutoSizeExceptColumns(CrackDetectGrid, "ReportPath");
  49. }
  50. catch (Exception ex)
  51. {
  52. if (ex.Message.ToString2() != "")
  53. Message = ex.Message;
  54. }
  55. finally
  56. {
  57. wf.Close();
  58. Cursor = Cursors.Default;
  59. }
  60. if (!string.IsNullOrWhiteSpace(Message))
  61. MessageBox.Show(Message);
  62. }
  63. /// <summary>
  64. /// 测量点明细查询
  65. /// </summary>
  66. private void QuerySinglePlan()
  67. {
  68. var startTim = "";
  69. var endTim = "";
  70. var shift = ""; //班次
  71. var group = ""; //班组
  72. var OrderNo = "";
  73. var JudgeStoveNo = "";
  74. var BatchNo = "";
  75. #region
  76. if (chkOrder.Checked && (cmbOrder.Text.Trim() != ""))
  77. shift = cmbOrder.Value.ToString();
  78. if (chkTim.Checked)
  79. {
  80. if (DateTime.Parse(RegStartTime.Value.ToString()) > DateTime.Parse(RegEndTime.Value.ToString()))
  81. {
  82. MessageUtil.ShowTips("选择时间区间错误,请重新选择!");
  83. return;
  84. }
  85. startTim = RegStartTime.Value.ToString("yyyy-MM-dd HH:mm:ss");
  86. endTim = RegEndTime.Value.ToString("yyyy-MM-dd HH:mm:ss");
  87. }
  88. if (chkGroup.Checked && (cmbGroup.Text.Trim() != ""))
  89. group = cmbGroup.Value.ToString();
  90. if (chkOrderNo.Checked)
  91. OrderNo = txtOrderNo.Text;
  92. if (chkJudgeStove.Checked)
  93. JudgeStoveNo = txtJudgeStove.Text;
  94. if (chkBatchNo.Checked)
  95. BatchNo = txtBatchNo.Text;
  96. #endregion
  97. var dt = ServerHelper.GetData("com.steering.mes.mcp.Mch.FrmJgxReport.doQueryMeasureDetailsResultzb",
  98. new object[]
  99. {
  100. shift, group,
  101. chkPlineCode.Checked && !string.IsNullOrWhiteSpace(plineCode) ? new[] {plineCode} : plineCodes,
  102. startTim, endTim, OrderNo, JudgeStoveNo, BatchNo, chkShow.Checked ? "1" : "0",
  103. chkFlag.Checked ? "1" : "0"
  104. }, ob);
  105. GridHelper.CopyDataToDatatable(ref dt, ref dataTable1, true);
  106. GridHelper.RefreshAndAutoSize(CrackDetectGrid);
  107. //mchMeasureResultEntityBindingSource.DataSource = EntityHelper.GetData<MchMeasureResultEntity>(
  108. // "com.steering.mes.mcp.Mch.FrmJgxReport.doQueryMeasureResult",
  109. // new object[] { shift, group, plineCode == "" ? plineCodes : new[] { plineCode }, startTim, endTim, OrderNo, JudgeStoveNo },
  110. // ob);
  111. //GridHelper.RefreshAndAutoSize(CrackDetectGrid);
  112. }
  113. private void FrmMeasureDetailsReport_Load(object sender, EventArgs e)
  114. {
  115. plineCodes = comm.InitDropPlineCodePower("G", txt_PlinCode, ValidDataPurviewIds, ob);
  116. if ((plineCodes.Length > 1) &&
  117. ((plineCodes[1] == "C038") || (plineCodes[1] == "C039") || (plineCodes[1] == "C049") ||
  118. (plineCodes[1] == "C050") ||
  119. (plineCodes[1] == "C051") || (plineCodes[1] == "C057")))
  120. {
  121. RegStartTime.Value = DateTime.Parse(DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd 20:00"));
  122. RegEndTime.Value = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd 19:59"));
  123. }
  124. else
  125. {
  126. RegStartTime.Value = DateTime.Parse(DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd 21:00"));
  127. RegEndTime.Value = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd 20:59"));
  128. }
  129. txt_PlinCode.SelectedIndex = 0;
  130. YdmBaseClass.SetComboItemHeight(cmbOrder);
  131. YdmBaseClass.SetComboItemHeight(cmbGroup);
  132. EntityHelper.ShowGridCaption<MchMeasureResultEntity>(CrackDetectGrid.DisplayLayout.Bands[0]);
  133. QuerySinglePlan();
  134. }
  135. private void chkStarts_CheckedChanged(object sender, EventArgs e)
  136. {
  137. if (chkTim.Checked)
  138. {
  139. RegStartTime.Enabled = true;
  140. RegEndTime.Enabled = true;
  141. RegStartTime.Visible = true;
  142. RegEndTime.Visible = true;
  143. label1.Visible = true;
  144. }
  145. else
  146. {
  147. RegStartTime.Enabled = false;
  148. RegEndTime.Enabled = false;
  149. RegStartTime.Visible = false;
  150. RegEndTime.Visible = false;
  151. label1.Visible = false;
  152. }
  153. cmbOrder.Enabled = chkOrder.Checked;
  154. cmbGroup.Enabled = chkGroup.Checked;
  155. txtOrderNo.Enabled = chkOrderNo.Checked;
  156. txtJudgeStove.Enabled = chkJudgeStove.Checked;
  157. txtBatchNo.Enabled = chkBatchNo.Checked;
  158. cmbOrder.Visible = chkOrder.Checked;
  159. cmbGroup.Visible = chkGroup.Checked;
  160. txtOrderNo.Visible = chkOrderNo.Checked;
  161. txtJudgeStove.Visible = chkJudgeStove.Checked;
  162. txtBatchNo.Visible = chkBatchNo.Checked;
  163. txt_PlinCode.Visible = chkPlineCode.Checked;
  164. }
  165. private void txt_PlinCode_TextChanged(object sender, EventArgs e)
  166. {
  167. plineCode = txt_PlinCode.SelectedItem.DataValue.ToString();
  168. }
  169. private void ChangePline()
  170. {
  171. CrackDetectGrid.UpdateData();
  172. var ids = CrackDetectGrid.Rows.Where(p => (bool) p.Cells["CHK"].Value)
  173. .
  174. Select(p => p.Cells["KEY_ID"].Value.ToString2()).Distinct().ToArray();
  175. var FrmPlineChoose = new FrmPlineChoose(ob, ids);
  176. if (FrmPlineChoose.ShowDialog() == DialogResult.OK)
  177. Query();
  178. }
  179. }
  180. }