RepMilGodownData.cs 5.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182
  1. using Core.Mes.Client.Comm.Control;
  2. using Core.Mes.Client.Comm.Server;
  3. using Core.Mes.Client.Comm.Tool;
  4. using Core.StlMes.Client.ZGMil.Common;
  5. using Core.StlMes.Client.ZGMil.Entity;
  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.ZGMil.Report
  16. {
  17. public partial class RepMilGodownData : FrmBase
  18. {
  19. private string departm = "";
  20. private string deptid = "";
  21. private string plineCode = "";
  22. private string[] plineCodes = { };
  23. public RepMilGodownData()
  24. {
  25. InitializeComponent();
  26. this.IsLoadUserView = true;
  27. }
  28. private void RepMilGodownData_Load(object sender, EventArgs e)
  29. {
  30. cmbDate.Value = DateTime.Parse(DateTime.Today.ToString());
  31. NativeMethodNew na = new NativeMethodNew(this.ob);
  32. departm = UserInfo.GetDepartment();
  33. deptid = UserInfo.GetDeptid();
  34. plineCode = na.GetPCode(departm);//获取 用户 对应的产线
  35. plineCodes = BaseMethod.GetPlineCode(ValidDataPurviewIds, ob);
  36. DateTime now = DateTime.Now;
  37. DateTime date = new DateTime(now.Year, now.Month, 1);
  38. cmbDate.Value = DateTime.Parse(date.ToString("yyyy-MM-dd HH:mm:ss"));
  39. cmbEndDate.Value = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
  40. }
  41. /// <summary>
  42. /// 非250、258、168、460的产线代码都为空
  43. /// </summary>
  44. /// <returns></returns>
  45. private string getPlineCode()
  46. {
  47. if (plineCode.Equals("C008") || plineCode.Equals("C009") || plineCode.Equals("C010") || plineCode.Equals("C017"))
  48. {
  49. return plineCode;
  50. }
  51. else
  52. {
  53. return "";
  54. }
  55. }
  56. /// <summary>
  57. /// 重写基类方法
  58. /// </summary>
  59. /// <param name="sender"></param>
  60. /// <param name="ToolbarKey"></param>
  61. public override void ToolBar_Click(object sender, string ToolbarKey)
  62. {
  63. switch (ToolbarKey)
  64. {
  65. case "Query":
  66. doQuery();
  67. break;
  68. case "Export":
  69. ExportData();
  70. break;
  71. case "Close":
  72. this.Close();
  73. break;
  74. }
  75. }
  76. /// <summary>
  77. /// 导出
  78. /// </summary>
  79. private void ExportData()
  80. {
  81. GridHelper.ulGridToExcel(ultraGrid1, "入库单信息");
  82. }
  83. /// <summary>
  84. /// 查询
  85. /// </summary>
  86. private void doQuery()
  87. {
  88. string date = "";
  89. string endDate = "";
  90. string JudgeStoveNo = "";
  91. string LotNo = "";
  92. string contractNo = "";
  93. if (chkDate.Checked)
  94. {
  95. if (DataTimeUtil.JudgeTime(DateTime.Parse(cmbDate.Value.ToString()), DateTime.Parse(cmbEndDate.Value.ToString())) == 0)
  96. {
  97. MessageUtil.ShowTips("您所选择的日期区域不对,请重新选择!");
  98. return;
  99. }
  100. else
  101. {
  102. date = cmbDate.Value.ToString();
  103. endDate = cmbEndDate.Value.ToString();
  104. }
  105. }
  106. if (chkJudgeStoveNo.Checked)
  107. {
  108. if (uteJudgeStoveNo.Text.Trim() == "")
  109. {
  110. JudgeStoveNo = "";
  111. }
  112. else
  113. {
  114. JudgeStoveNo = uteJudgeStoveNo.Text.ToString();
  115. }
  116. }
  117. if (chkLotNo.Checked)
  118. {
  119. if (uteLotNo.Text.Trim() == "")
  120. {
  121. LotNo = "";
  122. }
  123. else
  124. {
  125. LotNo = uteLotNo.Value.ToString();
  126. }
  127. }
  128. if (ContractNo.Checked)
  129. {
  130. if (uteContractNo.Text.Trim() == "")
  131. {
  132. contractNo = "";
  133. }
  134. else
  135. {
  136. contractNo = uteContractNo.Value.ToString();
  137. }
  138. }
  139. WaitingForm2 wf = new WaitingForm2("正在加载,请稍候....");
  140. DataTable dt = ServerHelper.GetData("com.steering.mes.zgmil.report.FrmMilDateStatistics.getMilGodownData", new Object[] { date, endDate, JudgeStoveNo, LotNo, contractNo, plineCodes, deptid }, this.ob);
  141. GridHelper.CopyDataToDatatable(dt, this.dataTable1, true);
  142. GridHelper.RefreshAndAutoSize(this.ultraGrid1);
  143. wf.Close();
  144. }
  145. /// <summary>
  146. /// 查询条件
  147. /// </summary>
  148. /// <param name="sender"></param>
  149. /// <param name="e"></param>
  150. private void chkDate_CheckedChanged(object sender, EventArgs e)
  151. {
  152. if (chkDate.Checked)
  153. {
  154. cmbDate.Enabled = true;
  155. cmbEndDate.Enabled = true;
  156. }
  157. else { cmbDate.Enabled = false; cmbEndDate.Enabled = false; }
  158. if (chkLotNo.Checked) { uteLotNo.Enabled = true; } else { uteLotNo.Enabled = false; }
  159. if (chkJudgeStoveNo.Checked) { uteJudgeStoveNo.Enabled = true; } else { uteJudgeStoveNo.Enabled = false; }
  160. if (ContractNo.Checked) { uteContractNo.Enabled = true; } else { uteContractNo.Enabled = false; }
  161. }
  162. }
  163. }