FrmAppearReport.cs 4.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115
  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. namespace Core.StlMes.Client.Mcp.Treatment.Report
  16. {
  17. public partial class FrmAppearReport : FrmBase
  18. {
  19. private string SlGx = "";//工序代码
  20. private string SlGxname = "";//工序名称
  21. private string departm = "";
  22. private string plineCode = "";
  23. private string[] plineCodes = new string[]{};
  24. public FrmAppearReport()
  25. {
  26. InitializeComponent();
  27. this.IsLoadUserView = true;
  28. }
  29. public override void ToolBar_Click(object sender, string ToolbarKey)
  30. {
  31. switch (ToolbarKey)
  32. {
  33. case "DoQuery":
  34. QuerySinglePlan();//外观检验
  35. break;
  36. case "Export":
  37. GridHelper.ulGridToExcel(ultraGrid4, "热处理外观检验台账");
  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. //查询冷拔冷轧实绩
  77. DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.Report.FrmRclReport.doQueryAppResult", new object[] { shift, group, plineCode == "" ? plineCodes : new string[] { plineCode }, startTim, endTim }, this.ob);
  78. GridHelper.CopyDataToDatatable(ref dt, ref dataTable1, true);
  79. }
  80. private void FrmAppearReport_Load(object sender, EventArgs e)
  81. {
  82. RegStartTime.Value = DateTime.Parse(DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd 21:00"));
  83. RegEndTime.Value = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd 20:59"));
  84. departm = UserInfo.GetDepartment();
  85. //plineCode = YdmBaseClass.GetPCode(departm, this.ob);//获取 用户 对应的产线
  86. plineCodes= comm.InitDropPlineCodePower("F", txt_PlinCode, this.ValidDataPurviewIds, this.ob);
  87. txt_PlinCode.SelectedIndex = 0;
  88. YdmBaseClass.SetComboItemHeight(cmbOrder);
  89. YdmBaseClass.SetComboItemHeight(cmbGroup);
  90. //获取工序
  91. DataTable dt2 = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryGX", new object[] { "600208" }, this.ob);
  92. if (dt2.Rows.Count > 0)
  93. {
  94. SlGx = dt2.Rows[0]["BASECODE"].ToString();
  95. SlGxname = dt2.Rows[0]["BASENAME"].ToString();
  96. }
  97. QuerySinglePlan();
  98. }
  99. private void chkStarts_CheckedChanged(object sender, EventArgs e)
  100. {
  101. if (chkTim.Checked) { RegStartTime.Enabled = true; RegEndTime.Enabled = true; } else { RegStartTime.Enabled = false; RegEndTime.Enabled = false; }
  102. if (chkOrder.Checked) { cmbOrder.Enabled = true; } else { cmbOrder.Enabled = false; }
  103. if (chkGroup.Checked) { cmbGroup.Enabled = true; } else { cmbGroup.Enabled = false; }
  104. }
  105. private void txt_PlinCode_TextChanged(object sender, EventArgs e)
  106. {
  107. plineCode = txt_PlinCode.SelectedItem.DataValue.ToString();
  108. }
  109. }
  110. }