FrmOffLineReport.cs 6.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162
  1. using System;
  2. using System.Collections;
  3. using System.Collections.Generic;
  4. using System.Drawing;
  5. using System.Linq;
  6. using System.Windows.Forms;
  7. using Core.Mes.Client.Comm.Control;
  8. using Core.Mes.Client.Comm.Tool;
  9. using Core.StlMes.Client.Mcp.Treatment.Entity;
  10. using CoreFS.CA06;
  11. namespace Core.StlMes.Client.Mcp.Treatment.Report
  12. {
  13. public partial class FrmOffLineReport : FrmBase
  14. {
  15. private string plineCode = "";
  16. private string[] plineCodes = {};
  17. public FrmOffLineReport()
  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. QuerySinglePlan();
  28. break;
  29. case "DoClose":
  30. Close();
  31. break;
  32. case "Export":
  33. GridHelper.ulGridToExcel(ultraGrid1, "热处理离线台账");
  34. break;
  35. }
  36. }
  37. /// <summary>
  38. /// 台账查询
  39. /// </summary>
  40. private void QuerySinglePlan()
  41. {
  42. var startTime = "";
  43. var endTime = "";
  44. var judgeNo = "";
  45. var batchNo = "";
  46. var gx = "";
  47. if (chkTim.Checked)
  48. if (DateTime.Parse(RegStartTime.Value.ToString()) > DateTime.Parse(RegEndTime.Value.ToString()))
  49. {
  50. MessageUtil.ShowTips("选择时间区间错误,请重新选择!");
  51. return;
  52. }
  53. else
  54. {
  55. startTime = RegStartTime.Value.ToString("yyyy-MM-dd HH:mm:ss");
  56. endTime = RegEndTime.Value.ToString("yyyy-MM-dd HH:mm:ss");
  57. }
  58. else if (!chkJugeHeatNo.Checked)
  59. if (MessageUtil.ShowYesNoAndQuestion("未加时间条件,查询时间可能比较长,请确定是否继续查询?") == DialogResult.No) return;
  60. if (chkJugeHeatNo.Checked)
  61. judgeNo = txtJugeNo.Text.Trim();
  62. if (chkBatch.Checked)
  63. batchNo = txtBatch.Text.Trim();
  64. var list = new ArrayList();
  65. list.Add(startTime);
  66. list.Add(endTime);
  67. list.Add(judgeNo);
  68. list.Add(batchNo);
  69. list.Add(gx);
  70. list.Add(uceType.SelectedItem.DataValue.ToString());
  71. List<HttOfflineResultEntityNew> listSource = EntityHelper.GetData<HttOfflineResultEntityNew>(
  72. "com.steering.mes.mcp.Report.FrmRclReport.doQueryOffLine", new object[] { list, new string[]{ultraCheckEditor1.Checked?"1":"0", ultraCheckEditor2.Checked?"1":"0",ultraCheckEditor3.Checked?"1":"0",ultraCheckEditor4.Checked?"1":"0"}
  73. ,plineCode == "" ? plineCodes : new string[] { plineCode } }, ob);
  74. List<HttGroupResultEntity> listGroup = EntityHelper.GetData<HttGroupResultEntity>(
  75. "com.steering.mes.mcp.heatTreatment.FrmHttDownLineManage.doQueryOffGroupDetail",
  76. new object[] {listSource.Select(p => p.GroupId).Distinct().ToArray()}, ob);
  77. listSource.ForEach(
  78. p => p.listGroup = listGroup.Where(q => q.GroupId == p.GroupId).OrderBy(q => q.GroupXh).ToList());
  79. HttOfflineResultEntitybindingSource.DataSource = listSource;
  80. comm.RefreshAndAutoSize(ultraGrid1,new string[]{"StdName"});
  81. }
  82. private void FrmWatergageReport_Load(object sender, EventArgs e)
  83. {
  84. RegStartTime.Value = DateTime.Parse(DateTime.Now.AddDays(1 - DateTime.Now.Day).AddDays(-1).ToString("yyyy-MM-dd 21:00"));
  85. RegEndTime.Value = DateTime.Parse(DateTime.Now.AddDays(1 - DateTime.Now.Day).AddMonths(1).AddDays(-1).ToString("yyyy-MM-dd 20:59"));
  86. plineCodes = comm.InitDropPlineCodePower("F", txt_PlinCode, ValidDataPurviewIds, ob);
  87. txt_PlinCode.SelectedIndex = 0;
  88. EntityHelper.ShowGridCaption<HttOfflineResultEntityNew>(ultraGrid1.DisplayLayout.Bands[0]);
  89. EntityHelper.ShowGridCaption<HttGroupResultEntity>(ultraGrid1.DisplayLayout.Bands[1]);
  90. uceType.SelectedIndex = 0;
  91. QuerySinglePlan();
  92. }
  93. private void chkStarts_CheckedChanged(object sender, EventArgs e)
  94. {
  95. if (chkTim.Checked)
  96. {
  97. RegStartTime.Enabled = true;
  98. RegEndTime.Enabled = true;
  99. }
  100. else
  101. {
  102. RegStartTime.Enabled = false;
  103. RegEndTime.Enabled = false;
  104. }
  105. if (chkJugeHeatNo.Checked) txtJugeNo.Enabled = true;
  106. else txtJugeNo.Enabled = false;
  107. if (chkBatch.Checked) txtBatch.Enabled = true;
  108. else txtBatch.Enabled = false;
  109. }
  110. private void txt_PlinCode_TextChanged(object sender, EventArgs e)
  111. {
  112. plineCode = txt_PlinCode.SelectedItem.DataValue.ToString();
  113. }
  114. private void ultraGrid1_InitializeRow(object sender, Infragistics.Win.UltraWinGrid.InitializeRowEventArgs e)
  115. {
  116. HttOfflineResultEntityNew list = e.Row.ListObject as HttOfflineResultEntityNew;
  117. if(list==null) return;
  118. if (list.GroupLog == "1")
  119. {
  120. e.Row.Cells["GroupLog"].Appearance.BackColor = Color.LightGreen;
  121. }
  122. if ((list.OfflineNum ?? 0) - (list.GroupNum ?? 0) - (list.ReNum ?? 0) - (list.SubcontractNum ?? 0) + (list.SubcontractcompleteNum ?? 0) <= 0)
  123. {
  124. if ((list.SubcontractNum ?? 0) > 0 && (list.SubcontractcompleteNum ?? 0) == 0 &&
  125. (list.HbFpNum ?? 0) == 0)
  126. {
  127. e.Row.Cells["JudgeStoveNo"].Appearance.BackColor = Color.Khaki;
  128. }
  129. else if((list.GroupNum??0)>0)
  130. {
  131. e.Row.Cells["JudgeStoveNo"].Appearance.BackColor = Color.DarkGray;
  132. }
  133. else
  134. {
  135. e.Row.Cells["JudgeStoveNo"].Appearance.BackColor = Color.LightGray;
  136. }
  137. }
  138. }
  139. }
  140. }