FrmLoadingReport.cs 5.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135
  1. using com.steering.mes.mcp.entity;
  2. using Core.Mes.Client.Comm.Control;
  3. using Core.Mes.Client.Comm.Server;
  4. using Core.Mes.Client.Comm.Tool;
  5. using Core.StlMes.Client.Mcp.Control;
  6. using CoreFS.CA06;
  7. using System;
  8. using System.Collections.Generic;
  9. using System.ComponentModel;
  10. using System.Data;
  11. using System.Drawing;
  12. using System.Linq;
  13. using System.Text;
  14. using System.Windows.Forms;
  15. using Core.StlMes.Client.Mcp.VRP.Vrp;
  16. namespace Core.StlMes.Client.Mcp.VRP.Report
  17. {
  18. public partial class FrmLoadingReport : FrmBase
  19. {
  20. private string SlGx = "";//上料工序
  21. private string SlGxname = "";
  22. private string departm = "";
  23. private string plineCode = "";
  24. public FrmLoadingReport()
  25. {
  26. InitializeComponent();
  27. }
  28. public override void ToolBar_Click(object sender, string ToolbarKey)
  29. {
  30. //base.ToolBar_Click(sender, ToolbarKey);
  31. switch (ToolbarKey)
  32. {
  33. case "DoQuery":
  34. QuerySinglePlan();//上料台账查询
  35. break;
  36. case "Export":
  37. GridHelper.ulGridToExcel(ultraGridLoad, "镦拔扩上料报表");
  38. break;
  39. case "DoClose":
  40. this.Close();
  41. break;
  42. }
  43. }
  44. /// <summary>
  45. /// 上料台账查询
  46. /// </summary>
  47. private void QuerySinglePlan()
  48. {
  49. string startTim = "";
  50. string endTim = "";
  51. string shift = ""; //班次
  52. string group = ""; //班组
  53. #region
  54. if (this.chkOrder.Checked && this.cmbOrder.Text.Trim() != "")
  55. {
  56. shift = this.cmbOrder.Value.ToString();
  57. }
  58. if (chkTim.Checked)
  59. {
  60. if (DateTime.Parse(RegStartTime.Value.ToString()) > DateTime.Parse(RegEndTime.Value.ToString()))
  61. {
  62. MessageUtil.ShowTips("选择时间区间错误,请重新选择!");
  63. return;
  64. }
  65. else
  66. {
  67. startTim = this.RegStartTime.Value.ToString("yyyy-MM-dd HH:mm:ss");
  68. endTim = this.RegEndTime.Value.ToString("yyyy-MM-dd HH:mm:ss");
  69. }
  70. }
  71. if (this.chkGroup.Checked && this.cmbGroup.Text.Trim() != "")
  72. {
  73. group = this.cmbGroup.Value.ToString();
  74. }
  75. #endregion
  76. VrpLoadingResultEntity plan = new VrpLoadingResultEntity();
  77. plan.LoadShift = shift;//班次
  78. plan.LoadGroup = group;//班组
  79. //查询上料实绩
  80. DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.Report.FrmLoadingReport.doQueryInfoResult", new object[] { plan,plineCode, startTim, endTim }, this.ob);
  81. GridHelper.CopyDataToDatatable(ref dt, ref dtLoadRecord, true);
  82. }
  83. private void FrmLoadingReport_Load(object sender, EventArgs e)
  84. {
  85. RegStartTime.Value = DateTime.Parse(DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd 21:00"));
  86. RegEndTime.Value = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd 20:59"));
  87. departm = UserInfo.GetDepartment();
  88. //plineCode = YdmBaseClass.GetPCode(departm, this.ob);//获取 用户 对应的产线
  89. comm.InitDropPlinePower("E", txt_PlinCode, this.ValidDataPurviewIds, this.ob);
  90. txt_PlinCode.SelectedIndex = 0;
  91. //if (plineCode == "C018")
  92. //{
  93. // code = "650101";
  94. //}
  95. //else if (plineCode == "C021")
  96. //{
  97. // code = "650401";
  98. //}
  99. //else if (plineCode == "C014")
  100. //{
  101. // code = "650501";
  102. //}
  103. //else if (plineCode == "C013")
  104. //{
  105. // code = "650601";
  106. //}
  107. //else if (plineCode == "C070")
  108. //{
  109. // code = "650701";
  110. //}
  111. //获取工序
  112. DataTable dt2 = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryGX", new object[] { plineCode }, this.ob);
  113. if (dt2.Rows.Count > 0)
  114. {
  115. SlGx = dt2.Rows[0]["BASECODE"].ToString();
  116. SlGxname = dt2.Rows[0]["BASENAME"].ToString();
  117. }
  118. QuerySinglePlan();
  119. }
  120. private void chkStarts_CheckedChanged(object sender, EventArgs e)
  121. {
  122. if (chkTim.Checked) { RegStartTime.Enabled = true; } else { RegStartTime.Enabled = false; }
  123. if (chkTim.Checked) { RegEndTime.Enabled = true; } else { RegEndTime.Enabled = false; }
  124. if (chkOrder.Checked) { cmbOrder.Enabled = true; } else { cmbOrder.Enabled = false; }
  125. if (chkGroup.Checked) { cmbGroup.Enabled = true; } else { cmbGroup.Enabled = false; }
  126. }
  127. private void txt_PlinCode_TextChanged(object sender, EventArgs e)
  128. {
  129. plineCode = txt_PlinCode.SelectedItem.DataValue.ToString();
  130. }
  131. }
  132. }