FrmOnlineInventory.cs 4.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136
  1. using Core.Mes.Client.Comm.Control;
  2. using Core.Mes.Client.Comm.Server;
  3. using Core.StlMes.Client.ZGMil.Common;
  4. using Core.StlMes.Client.ZGMil.Entity;
  5. using CoreFS.CA06;
  6. using System;
  7. using System.Collections.Generic;
  8. using System.ComponentModel;
  9. using System.Data;
  10. using System.Drawing;
  11. using System.Linq;
  12. using System.Text;
  13. using System.Windows.Forms;
  14. namespace Core.StlMes.Client.ZGMil.Report
  15. {
  16. public partial class FrmOnlineInventory : FrmBase
  17. {
  18. private string departm = "";
  19. private string plineCode = "";
  20. private string[] plineCodes = { };
  21. public FrmOnlineInventory()
  22. {
  23. InitializeComponent();
  24. this.IsLoadUserView = true;
  25. }
  26. /// <summary>
  27. /// 查询条件
  28. /// </summary>
  29. /// <param name="sender"></param>
  30. /// <param name="e"></param>
  31. private void chkDate_CheckedChanged(object sender, EventArgs e)
  32. {
  33. if (chkLotNo.Checked) { uteLotNo.Enabled = true; } else { uteLotNo.Enabled = false; }
  34. if (chkJudgeStoveNo.Checked) { uteJudgeStoveNo.Enabled = true; } else { uteJudgeStoveNo.Enabled = false; }
  35. }
  36. private void FrmOnlineInventory_Load(object sender, EventArgs e)
  37. {
  38. NativeMethodNew na = new NativeMethodNew(this.ob);
  39. departm = UserInfo.GetDepartment();
  40. plineCode = na.GetPCode(departm);//获取 用户 对应的产线
  41. plineCodes = BaseMethod.GetPlineCode(ValidDataPurviewIds, ob);
  42. }
  43. /// <summary>
  44. /// 重写基类方法
  45. /// </summary>
  46. /// <param name="sender"></param>
  47. /// <param name="ToolbarKey"></param>
  48. public override void ToolBar_Click(object sender, string ToolbarKey)
  49. {
  50. switch (ToolbarKey)
  51. {
  52. case "Query":
  53. doQuery();
  54. break;
  55. case "Export":
  56. ExportData();
  57. break;
  58. case "Close":
  59. this.Close();
  60. break;
  61. }
  62. }
  63. /// <summary>
  64. /// 查询
  65. /// </summary>
  66. private void doQuery()
  67. {
  68. //string date = "";
  69. //string endDate = "";
  70. string JudgeStoveNo = "";
  71. string LotNo = "";
  72. //string ContractNo = "";
  73. if (chkJudgeStoveNo.Checked)
  74. {
  75. if (uteJudgeStoveNo.Text.Trim() == "")
  76. {
  77. JudgeStoveNo = "";
  78. }
  79. else
  80. {
  81. JudgeStoveNo = uteJudgeStoveNo.Value.ToString();
  82. }
  83. }
  84. if (chkLotNo.Checked)
  85. {
  86. if (uteLotNo.Text.Trim() == "")
  87. {
  88. LotNo = "";
  89. }
  90. else
  91. {
  92. LotNo = uteLotNo.Value.ToString();
  93. }
  94. }
  95. WaitingForm2 wf = new WaitingForm2("正在加载,请稍候....");
  96. DataTable dt = ServerHelper.GetData("com.steering.mes.zgmil.report.FrmMilDateStatistics.getOnlineInventory", new Object[] { JudgeStoveNo, LotNo, plineCodes }, this.ob);
  97. GridHelper.CopyDataToDatatable(dt, this.dataTable1, true);
  98. GridHelper.RefreshAndAutoSize(this.ultraGrid1);
  99. wf.Close();
  100. }
  101. /// <summary>
  102. /// 导出
  103. /// </summary>
  104. private void ExportData()
  105. {
  106. GridHelper.ulGridToExcel(ultraGrid1, "在线品库存台账");
  107. }
  108. /// <summary>
  109. /// 非250、258、168、460的产线代码都为空
  110. /// </summary>
  111. /// <returns></returns>
  112. private string getPlineCode()
  113. {
  114. if (plineCode.Equals("C008") || plineCode.Equals("C009") || plineCode.Equals("C010") || plineCode.Equals("C017"))
  115. {
  116. return plineCode;
  117. }
  118. else
  119. {
  120. return "";
  121. }
  122. }
  123. }
  124. }