PlanReKuo.cs 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267
  1. using System;
  2. using System.Collections.Generic;
  3. using System.ComponentModel;
  4. using System.Drawing;
  5. using System.Data;
  6. using System.Linq;
  7. using System.Text;
  8. using System.Windows.Forms;
  9. using Infragistics.Win;
  10. using Infragistics.Win.UltraWinGrid;
  11. using Infragistics.Win.UltraWinDataSource;
  12. using Core.Mes.Client.Comm.Control;
  13. using com.steering.mes.mcp.entity;
  14. using Core.Mes.Client.Comm.Tool;
  15. namespace Core.StlMes.Client.Mcp.Control
  16. {
  17. public partial class PlanReKuo : UserControl
  18. {
  19. private string num = "";
  20. private string wt = "";
  21. // private InstructionCard _card = new InstructionCard();
  22. private VrpHotexpFaceMEntity _load = new VrpHotexpFaceMEntity();
  23. public VrpHotexpFaceMEntity Value
  24. {
  25. get { return _load; }
  26. set
  27. {
  28. if(value != null)
  29. {
  30. this._load = value;
  31. UpdateData();
  32. }
  33. }
  34. }
  35. private Infragistics.Win.UltraWinGrid.UltraGrid _grid = null;
  36. /// <summary>
  37. /// 编辑区GRID
  38. /// </summary>
  39. public Infragistics.Win.UltraWinGrid.UltraGrid Grid
  40. {
  41. get { return _grid; }
  42. }
  43. public PlanReKuo()
  44. {
  45. InitializeComponent();
  46. GridHelper.InitCardGrid(ultraDataSource1, ultraGrid1);
  47. _grid = this.ultraGrid1;
  48. }
  49. /// <summary>
  50. /// 刷新控件数据显示
  51. /// </summary>
  52. public void UpdateData()
  53. {
  54. if (_load != null)
  55. {
  56. ultraDataSource1.Rows[0]["PRODUCER"] = _load.Producer;
  57. ultraDataSource1.Rows[0]["SIZE_D"] = _load.SizeD;
  58. ultraDataSource1.Rows[0]["SIZE_S"] = _load.SizeS;
  59. ultraDataSource1.Rows[0]["SIZE_W"] = _load.SizeW;
  60. ultraDataSource1.Rows[0]["SIZE_L"] = _load.SizeL;
  61. ultraDataSource1.Rows[0]["PRO_NUM"] = _load.ProNum;
  62. ultraDataSource1.Rows[0]["PRO_WT"] = _load.ProWt;
  63. ultraDataSource1.Rows[0]["ACC_NUM"] = _load.AccNum;
  64. ultraDataSource1.Rows[0]["ACC_WT"] = _load.AccWt;
  65. /* ultraDataSource1.Rows[0]["FAIL_NUM"] = _load.FailNum;
  66. ultraDataSource1.Rows[0]["FAIL_WT"] = _load.FailWt;*/
  67. ultraDataSource1.Rows[0]["FAIL_NUM"] = string.IsNullOrEmpty(_load.FailNum) ? "0" : _load.FailNum;
  68. ultraDataSource1.Rows[0]["FAIL_WT"] = string.IsNullOrEmpty(_load.FailWt) ? "0" : _load.FailWt;
  69. ultraDataSource1.Rows[0]["PRODUCER_TIME"] = _load.ProducerTime;
  70. ultraDataSource1.Rows[0]["LOAD_TIME"] = _load.LoadTime;
  71. ultraDataSource1.Rows[0]["LOAD_SHIFT"] = _load.LoadShift;
  72. ultraDataSource1.Rows[0]["LOAD_GROUP"] = _load.LoadGroup;
  73. ultraDataSource1.Rows[0]["LOAD_USER"] = _load.LoadUser;
  74. num = _load.ProNum;
  75. wt = _load.ProWt;
  76. }
  77. else
  78. {
  79. GridHelper.InitCardGrid(ultraDataSource1,ultraGrid1);
  80. }
  81. this.ultraGrid1.UpdateData();
  82. }
  83. /// <summary>
  84. /// 控件编辑后更新已修改数据
  85. /// </summary>
  86. public void CompleteEdit()
  87. {
  88. ultraGrid1.UpdateData();
  89. }
  90. private void ultraGrid1_AfterCellUpdate(object sender, CellEventArgs e)
  91. {
  92. try
  93. {
  94. if (e.Cell.Column.Key.Equals("PRODUCER"))
  95. {
  96. Value.Producer = e.Cell.Value.ToString();
  97. }
  98. if (e.Cell.Column.Key.Equals("SIZE_D"))
  99. {
  100. Value.SizeD = e.Cell.Value.ToString();
  101. }
  102. if (e.Cell.Column.Key.Equals("SIZE_S"))
  103. {
  104. Value.SizeS = e.Cell.Value.ToString();
  105. }
  106. if (e.Cell.Column.Key.Equals("SIZE_W"))
  107. {
  108. Value.SizeW = e.Cell.Value.ToString();
  109. }
  110. if (e.Cell.Column.Key.Equals("SIZE_L"))
  111. {
  112. Value.SizeL = e.Cell.Value.ToString();
  113. }
  114. if (e.Cell.Column.Key.Equals("PRO_NUM"))
  115. {
  116. Value.ProNum = e.Cell.Value.ToString();
  117. }
  118. if (e.Cell.Column.Key.Equals("PRO_WT"))
  119. {
  120. Value.ProWt = e.Cell.Value.ToString();
  121. }
  122. if (e.Cell.Column.Key.Equals("ACC_NUM"))
  123. {
  124. Value.AccNum = e.Cell.Value.ToString();
  125. }
  126. if (e.Cell.Column.Key.Equals("ACC_WT"))
  127. {
  128. Value.AccWt = e.Cell.Value.ToString();
  129. }
  130. if (e.Cell.Column.Key.Equals("FAIL_NUM"))
  131. {
  132. Value.FailNum = e.Cell.Value.ToString();
  133. }
  134. if (e.Cell.Column.Key.Equals("FAIL_WT"))
  135. {
  136. Value.FailWt = e.Cell.Value.ToString();
  137. }
  138. if (e.Cell.Column.Key.Equals("PRODUCER_TIME"))
  139. {
  140. Value.ProducerTime = e.Cell.Value.ToString();
  141. }
  142. if (e.Cell.Column.Key.Equals("LOAD_TIME"))
  143. {
  144. Value.LoadTime = e.Cell.Value.ToString();
  145. }
  146. if (e.Cell.Column.Key.Equals("LOAD_SHIFT"))
  147. {
  148. Value.LoadShift = e.Cell.Value.ToString();
  149. }
  150. if (e.Cell.Column.Key.Equals("LOAD_GROUP"))
  151. {
  152. Value.LoadGroup = e.Cell.Value.ToString();
  153. }
  154. if (e.Cell.Column.Key.Equals("LOAD_USER"))
  155. {
  156. Value.LoadUser = e.Cell.Value.ToString();
  157. }
  158. }
  159. catch (Exception ex)
  160. {
  161. }
  162. }
  163. /// <summary>
  164. /// 验证格试
  165. /// </summary>
  166. public bool ValidInput1()
  167. {
  168. ultraGrid1.UpdateData();
  169. string TestingNum = ultraDataSource1.Rows[0]["PRO_NUM"].ToString();
  170. string AccNum = ultraDataSource1.Rows[0]["ACC_NUM"].ToString();//合格
  171. string ProNum = ultraDataSource1.Rows[0]["PRO_NUM"].ToString();//作业
  172. string FailNum = ultraDataSource1.Rows[0]["FAIL_NUM"].ToString();//废品
  173. string TestingWt = ultraDataSource1.Rows[0]["PRO_WT"].ToString();
  174. if (!StringUtil.IsInt(TestingNum))
  175. {
  176. MessageBox.Show("作业支数 请输入整数", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
  177. return false;
  178. }
  179. if (!StringUtil.IsDouble(TestingWt))
  180. {
  181. MessageBox.Show("作业重量 请输入重量", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
  182. return false;
  183. }
  184. if (Convert.ToInt32(ProNum) !=
  185. Convert.ToInt32(AccNum == "" ? "0" : AccNum) +
  186. Convert.ToInt32(FailNum == "" ? "0" : FailNum))
  187. {
  188. MessageBox.Show("作业支数 = 合格支数+ 废品支数,请查验 ", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
  189. return false;
  190. }
  191. return true;
  192. }
  193. private void ultraGrid1_CellChange(object sender, CellEventArgs e)
  194. {
  195. ultraGrid1.UpdateData();
  196. if (e.Cell.Column.Key.Equals("FAIL_NUM"))//动这个字段会进下面的内容里
  197. {
  198. if (ultraDataSource1.Rows[0]["FAIL_NUM"].ToString().Equals(""))
  199. {
  200. ultraDataSource1.Rows[0]["FAIL_NUM"] = "0";
  201. }
  202. if (ultraDataSource1.Rows[0]["PRO_NUM"].ToString().Equals(""))
  203. {
  204. ultraDataSource1.Rows[0]["PRO_NUM"] = "0";
  205. }
  206. double actnum = double.Parse(ultraDataSource1.Rows[0]["FAIL_NUM"].ToString());
  207. if (actnum > int.Parse(ultraDataSource1.Rows[0]["PRO_NUM"].ToString()))
  208. {
  209. MessageBox.Show("废品支数不能大于加工支数!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
  210. return;
  211. }
  212. double actwt = 0;
  213. if(!ultraDataSource1.Rows[0]["PRO_WT"].ToString().Equals("0"))
  214. {
  215. if (num != null && !num.Equals("0"))
  216. {
  217. actwt = double.Parse(ultraDataSource1.Rows[0]["FAIL_NUM"].ToString()) * (double.Parse(wt)) / (double.Parse(num));
  218. }
  219. }
  220. ultraDataSource1.Rows[0]["FAIL_WT"] = actwt.ToString("f3");
  221. Value.FailWt = ultraDataSource1.Rows[0]["FAIL_WT"].ToString();
  222. double failnum = double.Parse(ultraDataSource1.Rows[0]["PRO_NUM"].ToString()) - double.Parse(ultraDataSource1.Rows[0]["FAIL_NUM"].ToString());
  223. double failwt = double.Parse(ultraDataSource1.Rows[0]["PRO_WT"].ToString()) - actwt;
  224. ultraDataSource1.Rows[0]["ACC_NUM"] = failnum.ToString();
  225. Value.AccNum = ultraDataSource1.Rows[0]["ACC_NUM"].ToString();
  226. ultraDataSource1.Rows[0]["ACC_WT"] = failwt.ToString("f3");
  227. Value.AccWt = ultraDataSource1.Rows[0]["ACC_WT"].ToString();
  228. }
  229. if (e.Cell.Column.Key.Equals("PRO_NUM"))//动这个字段会进下面的内容里
  230. {
  231. if (ultraDataSource1.Rows[0]["PRO_NUM"].ToString().Equals(""))
  232. {
  233. ultraDataSource1.Rows[0]["PRO_NUM"] = "0";
  234. }
  235. double actwt = 0;
  236. if (!ultraDataSource1.Rows[0]["PRO_NUM"].ToString().Equals("0"))
  237. {
  238. if (num != null && !num.Equals("0"))
  239. {
  240. actwt = double.Parse(ultraDataSource1.Rows[0]["PRO_NUM"].ToString()) * (double.Parse(wt)) / (double.Parse(num));
  241. }
  242. }
  243. double actnum = double.Parse(ultraDataSource1.Rows[0]["PRO_NUM"].ToString());
  244. ultraDataSource1.Rows[0]["PRO_WT"] = actwt.ToString("f3");
  245. Value.ProWt = ultraDataSource1.Rows[0]["PRO_WT"].ToString();
  246. ultraDataSource1.Rows[0]["ACC_NUM"] = ultraDataSource1.Rows[0]["PRO_NUM"].ToString();
  247. Value.AccNum = ultraDataSource1.Rows[0]["ACC_NUM"].ToString();
  248. ultraDataSource1.Rows[0]["ACC_WT"] = ultraDataSource1.Rows[0]["PRO_WT"].ToString();
  249. Value.AccWt = ultraDataSource1.Rows[0]["ACC_WT"].ToString();
  250. ultraDataSource1.Rows[0]["FAIL_NUM"] = "0";
  251. }
  252. }
  253. }
  254. }