FrmColdDrawnReport.cs 5.2 KB

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