FrmPerformance.cs 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234
  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.Mcp.Control;
  5. using CoreFS.CA06;
  6. using System;
  7. using System.Collections;
  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.VRP.Vrp
  16. {
  17. public partial class FrmPerformance : FrmBase
  18. {
  19. private string plineCode = "";
  20. private string manageNmae = ""; //科室名称
  21. private string stationCode = "";
  22. public FrmPerformance()
  23. {
  24. InitializeComponent();
  25. this.IsLoadUserView = true;
  26. }
  27. private void FrmPerformance_Load(object sender, EventArgs e)
  28. {
  29. //DateTime now = DateTime.Now;
  30. //DateTime dt1 = new DateTime(now.Year, now.Month, 1);//当月第一天
  31. //DateTime dt2 = dt1.AddMonths(1).AddDays(-1);//当月最后一天
  32. //StartTime.Value = DateTime.Parse(dt1.ToString("yyyy-MM-dd") + " 00:00:00");
  33. //EndTime.Value = DateTime.Parse(dt2.ToString("yyyy-MM-dd") + " 23:59:59");
  34. StartTime.Value = DateTime.Parse(DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd 21:00"));
  35. EndTime.Value = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd 20:59"));
  36. manageNmae = UserInfo.GetDepartment();
  37. //plineCode = YdmBaseClass.GetPCode(manageNmae, this.ob);//获取 用户 对应的产线
  38. comm.InitDropPlinePower("E", txt_PlinCode , this.ValidDataPurviewIds, this.ob);
  39. txt_PlinCode.SelectedIndex = 0;
  40. }
  41. public override void ToolBar_Click(object sender, string ToolbarKey)
  42. {
  43. //base.ToolBar_Click(sender, ToolbarKey);
  44. switch (ToolbarKey)
  45. {
  46. case "Query":
  47. DoQuery();
  48. break;
  49. case "Export":
  50. GridHelper.ulGridToExcel(ultraGrid1, "镦拔扩实绩数据统计");
  51. break;
  52. case "Close":
  53. this.Close();
  54. break;
  55. }
  56. }
  57. private void chkTim_CheckedChanged(object sender, EventArgs e)
  58. {
  59. if (chkTim.Checked) { StartTime.Enabled = true; EndTime.Enabled = true; } else { StartTime.Enabled = false; EndTime.Enabled = false; }
  60. if (chkJugeHeatNo.Checked) { txtJugeNo.Enabled = true; } else { txtJugeNo.Enabled = false; }
  61. if (chkLotNo.Checked) { txtLotNo.Enabled = true; } else { txtLotNo.Enabled = false; }
  62. if (chkOrder.Checked) { txtOrder.Enabled = true; }
  63. else
  64. {
  65. txtOrder.Enabled = false;
  66. }
  67. }
  68. private void DoQuery()
  69. {
  70. string judgeNo = "";
  71. string batchNo = "";
  72. string orderNo = "";
  73. if (!CheckQuery()) return;
  74. string staTime = "";
  75. string endTime = "";
  76. if (chkTim.Checked)
  77. {
  78. staTime = StartTime.Value.ToString();
  79. endTime = EndTime.Value.ToString();
  80. }
  81. if (chkLotNo.Checked)
  82. {
  83. batchNo = this.txtLotNo.Text.Trim();
  84. }
  85. if (chkJugeHeatNo.Checked)
  86. {
  87. judgeNo = this.txtJugeNo.Text.Trim();
  88. }
  89. if (chkOrder.Checked)
  90. {
  91. orderNo = this.txtOrder.Text.Trim();
  92. }
  93. ArrayList list = new ArrayList();
  94. list.Add(staTime);
  95. list.Add(endTime);
  96. list.Add(judgeNo);
  97. list.Add(batchNo);
  98. list.Add(orderNo);
  99. DataTable dt1 = ServerHelper.GetData("com.steering.mes.mcp.Report.FrmDBKPerformance.doQuery", new object[] { list, plineCode,stationCode }, ob);
  100. GridHelper.CopyDataToDatatable(ref dt1, ref dataTable1, true);
  101. }
  102. /// <summary>
  103. /// 数据验证
  104. /// </summary>
  105. /// <returns></returns>
  106. private bool CheckQuery()
  107. {
  108. if (DataTimeUtil.JudgeTime(DateTime.Parse(StartTime.Value.ToString()), DateTime.Parse(EndTime.Value.ToString())) == 0)
  109. {
  110. MessageUtil.ShowTips("您所选择的日期区域不对,请重新选择!");
  111. return false;
  112. }
  113. if (this.chkJugeHeatNo.Checked && string.IsNullOrEmpty(this.txtJugeNo.Text.Trim()))
  114. {
  115. MessageUtil.ShowWarning("请输入炉号!");
  116. return false;
  117. }
  118. if (this.chkLotNo.Checked && string.IsNullOrEmpty(this.txtLotNo.Text.Trim()))
  119. {
  120. MessageUtil.ShowWarning("请输入批号!");
  121. return false;
  122. }
  123. if (this.chkOrder.Checked && string.IsNullOrEmpty(this.txtOrder.Text.Trim()))
  124. {
  125. MessageUtil.ShowWarning("请输入合同号!");
  126. return false;
  127. }
  128. return true;
  129. }
  130. private void txt_PlinCode_TextChanged(object sender, EventArgs e)
  131. {
  132. plineCode = txt_PlinCode.SelectedItem.DataValue.ToString();
  133. if (plineCode.Equals("C018"))//720
  134. {
  135. stationCode = "650101";
  136. ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup7"].Hidden = true;//测量点
  137. ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup12"].Hidden = true;//热扩表检
  138. ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup11"].Hidden = true;//镦粗表检
  139. ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup13"].Hidden = true;//冷拔冷轧表检
  140. ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup6"].Hidden = false;//旋扩
  141. ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup8"].Hidden = false;//均整
  142. ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup9"].Hidden = false;//定径
  143. ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup10"].Hidden = false;//旋扩表检
  144. }
  145. else if (plineCode.Equals("C021"))//镦粗
  146. {
  147. stationCode = "650401";
  148. ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup6"].Hidden = true;//旋扩
  149. ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup8"].Hidden = true;//均整
  150. ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup9"].Hidden = true;//定径
  151. ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup10"].Hidden = true;//旋扩表检
  152. ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup12"].Hidden = true;//热扩表检
  153. ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup13"].Hidden = true;//冷拔冷轧表检
  154. ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup7"].Hidden = false;//测量点
  155. ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup11"].Hidden = false;//镦粗表检
  156. }
  157. else if (plineCode.Equals("C014"))//冷拔机组
  158. {
  159. stationCode = "650501";
  160. ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup6"].Hidden = true;//旋扩
  161. ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup8"].Hidden = true;//均整
  162. ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup9"].Hidden = true;//定径
  163. ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup10"].Hidden = true;//旋扩表检
  164. ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup12"].Hidden = true;//热扩表检
  165. ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup11"].Hidden = true;//镦粗表检
  166. ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup7"].Hidden = false;//测量点
  167. ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup13"].Hidden = false;//冷拔冷轧
  168. }
  169. else if (plineCode.Equals("C013"))//冷轧机组
  170. {
  171. stationCode = "650601";
  172. ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup6"].Hidden = true;//旋扩
  173. ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup8"].Hidden = true;//均整
  174. ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup9"].Hidden = true;//定径
  175. ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup10"].Hidden = true;//旋扩表检
  176. ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup12"].Hidden = true;//热扩表检
  177. ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup11"].Hidden = true;//镦粗表检
  178. ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup7"].Hidden = false;//测量点
  179. ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup13"].Hidden = false;//冷拔冷轧
  180. }
  181. else if (plineCode.Equals("C070"))//热扩
  182. {
  183. stationCode = "650701";
  184. ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup6"].Hidden = true;//旋扩
  185. ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup8"].Hidden = true;//均整
  186. ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup9"].Hidden = true;//定径
  187. ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup10"].Hidden = true;//旋扩表检
  188. ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup11"].Hidden = true;//镦粗表检
  189. ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup13"].Hidden = true;//冷拔冷轧表检
  190. ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup7"].Hidden = false;//测量点
  191. ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup12"].Hidden = false;//热扩
  192. }
  193. else if (plineCode.Equals("C067"))//委外镦粗
  194. {
  195. stationCode = "650401";
  196. ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup6"].Hidden = true;//旋扩
  197. ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup8"].Hidden = true;//均整
  198. ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup9"].Hidden = true;//定径
  199. ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup10"].Hidden = true;//旋扩表检
  200. ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup12"].Hidden = true;//镦粗表检
  201. ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup13"].Hidden = true;//冷拔冷轧表检
  202. ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup7"].Hidden = false;//测量点
  203. ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup11"].Hidden = false;//镦粗
  204. }
  205. else if (plineCode.Equals("C080"))//委外冷轧
  206. {
  207. stationCode = "650601";
  208. ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup6"].Hidden = true;//旋扩
  209. ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup8"].Hidden = true;//均整
  210. ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup9"].Hidden = true;//定径
  211. ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup10"].Hidden = true;//旋扩表检
  212. ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup12"].Hidden = true;//热扩表检
  213. ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup11"].Hidden = true;//镦粗表检
  214. ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup7"].Hidden = false;//测量点
  215. ultraGrid1.DisplayLayout.Bands[0].Groups["NewGroup13"].Hidden = false;//冷拔冷轧
  216. }
  217. }
  218. }
  219. }