PlanExpanLBColdDrawn.cs 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323
  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 PlanExpanLBColdDrawn : UserControl
  18. {
  19. private string num = "";
  20. private string wt = "";
  21. // private InstructionCard _card = new InstructionCard();
  22. private VrpColdDrawnResultEntity _load = new VrpColdDrawnResultEntity();
  23. public VrpColdDrawnResultEntity 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 PlanExpanLBColdDrawn()
  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]["SIZDIMATER"] = _load.SizDimater;
  58. ultraDataSource1.Rows[0]["SIZHEIGHT"] = _load.SizHeight;
  59. ultraDataSource1.Rows[0]["ROLLSPEED"] = _load.RollSpeed;
  60. ultraDataSource1.Rows[0]["ACTLEN"] = _load.ActLen;
  61. ultraDataSource1.Rows[0]["NHEIGHT"] = _load.NHeight;
  62. ultraDataSource1.Rows[0]["NDIMATER"] = _load.NDimater;
  63. ultraDataSource1.Rows[0]["TECTIM"] = _load.TecTim;
  64. ultraDataSource1.Rows[0]["WDIMATER"] = _load.WDimater;
  65. ultraDataSource1.Rows[0]["WHEIGHT"] = _load.WHeight;
  66. ultraDataSource1.Rows[0]["PRONUM"] = _load.ProNum;
  67. ultraDataSource1.Rows[0]["PROWT"] = _load.ProWt;
  68. ultraDataSource1.Rows[0]["ACCNUM"] = _load.AccNum;
  69. ultraDataSource1.Rows[0]["ACCWT"] = _load.AccWt;
  70. ultraDataSource1.Rows[0]["ACCLEN"] = _load.AccLen;
  71. ultraDataSource1.Rows[0]["FAILNUM"] = string.IsNullOrEmpty(_load.FailNum) ? "0" : _load.FailNum;
  72. ultraDataSource1.Rows[0]["FAILWT"] = string.IsNullOrEmpty(_load.FailWt) ? "0" : _load.FailWt;
  73. ultraDataSource1.Rows[0]["FAILREASON"] = _load.FailReason;
  74. ultraDataSource1.Rows[0]["PRODUCERTIME"] = _load.ProducerTime;
  75. ultraDataSource1.Rows[0]["LOADTIME"] = _load.LoadTime;
  76. ultraDataSource1.Rows[0]["LOADSHIFT"] = _load.LoadShift;
  77. ultraDataSource1.Rows[0]["LOADGROUP"] = _load.LoadGroup;
  78. ultraDataSource1.Rows[0]["LOADUSER"] = _load.LoadUser;
  79. num = _load.ProNum;
  80. wt = _load.ProWt;
  81. }
  82. else
  83. {
  84. GridHelper.InitCardGrid(ultraDataSource1,ultraGrid1);
  85. }
  86. this.ultraGrid1.UpdateData();
  87. }
  88. /// <summary>
  89. /// 控件编辑后更新已修改数据
  90. /// </summary>
  91. public void CompleteEdit()
  92. {
  93. ultraGrid1.UpdateData();
  94. }
  95. private void ultraGrid1_AfterCellUpdate(object sender, CellEventArgs e)
  96. {
  97. try
  98. {
  99. if (e.Cell.Column.Key.Equals("PRODUCER"))
  100. {
  101. Value.Producer = e.Cell.Value.ToString();
  102. }
  103. if (e.Cell.Column.Key.Equals("SIZDIMATER"))
  104. {
  105. Value.SizDimater = e.Cell.Value.ToString();
  106. }
  107. if (e.Cell.Column.Key.Equals("SIZHEIGHT"))
  108. {
  109. Value.SizHeight = e.Cell.Value.ToString();
  110. }
  111. if (e.Cell.Column.Key.Equals("ROLLSPEED"))
  112. {
  113. Value.RollSpeed = e.Cell.Value.ToString();
  114. }
  115. if (e.Cell.Column.Key.Equals("ACTLEN"))
  116. {
  117. Value.ActLen = e.Cell.Value.ToString();
  118. }
  119. if (e.Cell.Column.Key.Equals("NHEIGHT"))
  120. {
  121. Value.NHeight = e.Cell.Value.ToString();
  122. }
  123. if (e.Cell.Column.Key.Equals("NDIMATER"))
  124. {
  125. Value.NDimater = e.Cell.Value.ToString();
  126. }
  127. if (e.Cell.Column.Key.Equals("TECTIM"))
  128. {
  129. Value.TecTim = e.Cell.Value.ToString();
  130. }
  131. if (e.Cell.Column.Key.Equals("WDIMATER"))
  132. {
  133. Value.WDimater = e.Cell.Value.ToString();
  134. }
  135. if (e.Cell.Column.Key.Equals("WHEIGHT"))
  136. {
  137. Value.WHeight = e.Cell.Value.ToString();
  138. }
  139. if (e.Cell.Column.Key.Equals("PRONUM"))
  140. {
  141. Value.ProNum = e.Cell.Value.ToString();
  142. }
  143. if (e.Cell.Column.Key.Equals("PROWT"))
  144. {
  145. Value.ProWt = e.Cell.Value.ToString();
  146. }
  147. if (e.Cell.Column.Key.Equals("ACCNUM"))
  148. {
  149. Value.AccNum = e.Cell.Value.ToString();
  150. }
  151. if (e.Cell.Column.Key.Equals("ACCWT"))
  152. {
  153. Value.AccWt = e.Cell.Value.ToString();
  154. }
  155. if (e.Cell.Column.Key.Equals("ACCLEN"))
  156. {
  157. Value.AccLen = e.Cell.Value.ToString();
  158. }
  159. if (e.Cell.Column.Key.Equals("FAILNUM"))
  160. {
  161. Value.FailNum = e.Cell.Value.ToString();
  162. }
  163. if (e.Cell.Column.Key.Equals("FAILWT"))
  164. {
  165. Value.FailWt = e.Cell.Value.ToString();
  166. }
  167. if (e.Cell.Column.Key.Equals("FAILREASON"))
  168. {
  169. Value.FailReason = e.Cell.Value.ToString();
  170. }
  171. if (e.Cell.Column.Key.Equals("PRODUCERTIME"))
  172. {
  173. Value.ProducerTime = e.Cell.Value.ToString();
  174. }
  175. if (e.Cell.Column.Key.Equals("LOADTIME"))
  176. {
  177. Value.LoadTime = e.Cell.Value.ToString();
  178. }
  179. if (e.Cell.Column.Key.Equals("LOADSHIFT"))
  180. {
  181. Value.LoadShift = e.Cell.Value.ToString();
  182. }
  183. if (e.Cell.Column.Key.Equals("LOADGROUP"))
  184. {
  185. Value.LoadGroup = e.Cell.Value.ToString();
  186. }
  187. if (e.Cell.Column.Key.Equals("LOADUSER"))
  188. {
  189. Value.LoadUser = e.Cell.Value.ToString();
  190. }
  191. }
  192. catch (Exception ex)
  193. {
  194. }
  195. }
  196. /// <summary>
  197. /// 验证格试
  198. /// </summary>
  199. public bool ValidInput1()
  200. {
  201. ultraGrid1.UpdateData();
  202. string TestingNum = ultraDataSource1.Rows[0]["ProNum"].ToString();
  203. string AccNum = ultraDataSource1.Rows[0]["ACCNUM"].ToString();//合格
  204. string ProNum = ultraDataSource1.Rows[0]["PRONUM"].ToString();//作业
  205. string FailNum = ultraDataSource1.Rows[0]["FAILNUM"].ToString();//废品
  206. if (!StringUtil.IsInt(TestingNum))
  207. {
  208. MessageBox.Show("合格支数 请输入整数", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
  209. return false;
  210. }
  211. if (Convert.ToInt32(ProNum) !=
  212. Convert.ToInt32(AccNum == "" ? "0" : AccNum) +
  213. Convert.ToInt32(FailNum == "" ? "0" : FailNum))
  214. {
  215. MessageBox.Show("作业支数 = 合格支数+ 废品支数,请查验 ", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
  216. return false;
  217. }
  218. return true;
  219. }
  220. private void ultraGrid1_InitializeLayout(object sender, InitializeLayoutEventArgs e)
  221. {
  222. }
  223. private void ultraDataSource1_CellDataRequested(object sender, CellDataRequestedEventArgs e)
  224. {
  225. }
  226. private void ultraGrid1_CellChange(object sender, CellEventArgs e)
  227. {
  228. ultraGrid1.UpdateData();
  229. if (e.Cell.Column.Key.Equals("FAILNUM"))//动这个字段会进下面的内容里
  230. {
  231. if (ultraDataSource1.Rows[0]["FAILNUM"].ToString().Equals(""))
  232. {
  233. ultraDataSource1.Rows[0]["FAILNUM"] = "0";
  234. }
  235. if (ultraDataSource1.Rows[0]["PRONUM"].ToString().Equals(""))
  236. {
  237. ultraDataSource1.Rows[0]["PRONUM"] = "0";
  238. }
  239. double actnum = double.Parse(ultraDataSource1.Rows[0]["FAILNUM"].ToString());
  240. if (actnum > int.Parse(ultraDataSource1.Rows[0]["PRONUM"].ToString()))
  241. {
  242. MessageBox.Show("废品支数不能大于加工支数!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
  243. return;
  244. }
  245. double actwt = 0;
  246. if (!ultraDataSource1.Rows[0]["PROWT"].ToString().Equals("0"))
  247. {
  248. if (num != null && !num.Equals("0"))
  249. {
  250. actwt = double.Parse(ultraDataSource1.Rows[0]["FAILNUM"].ToString()) * (double.Parse(wt)) / (double.Parse(num));
  251. }
  252. }
  253. ultraDataSource1.Rows[0]["FAILWT"] = actwt.ToString("f3");
  254. Value.FailWt = actwt.ToString();
  255. double failnum = double.Parse(ultraDataSource1.Rows[0]["PRONUM"].ToString()) - double.Parse(ultraDataSource1.Rows[0]["FAILNUM"].ToString());
  256. double failwt = double.Parse(ultraDataSource1.Rows[0]["PROWT"].ToString()) - actwt;
  257. ultraDataSource1.Rows[0]["ACCNUM"] = failnum.ToString();
  258. Value.AccNum = ultraDataSource1.Rows[0]["ACCNUM"].ToString();
  259. ultraDataSource1.Rows[0]["ACCWT"] = failwt.ToString("f3");
  260. Value.AccWt = ultraDataSource1.Rows[0]["ACCWT"].ToString();
  261. }
  262. if (e.Cell.Column.Key.Equals("PRONUM"))//动这个字段会进下面的内容里
  263. {
  264. if (ultraDataSource1.Rows[0]["PRONUM"].ToString().Equals(""))
  265. {
  266. ultraDataSource1.Rows[0]["PRONUM"] = "0";
  267. }
  268. double actwt = 0;
  269. if (!ultraDataSource1.Rows[0]["PRONUM"].ToString().Equals("0"))
  270. {
  271. if (num != null && !num.Equals("0"))
  272. {
  273. actwt = double.Parse(ultraDataSource1.Rows[0]["PRONUM"].ToString()) * (double.Parse(wt)) / (double.Parse(num));
  274. }
  275. }
  276. double actnum = double.Parse(ultraDataSource1.Rows[0]["PRONUM"].ToString());
  277. ultraDataSource1.Rows[0]["PROWT"] = actwt.ToString("f3");
  278. Value.ProWt = ultraDataSource1.Rows[0]["PROWT"].ToString();
  279. //if (piece != null && !piece.Equals(""))
  280. //{
  281. // if (int.Parse(ultraDataSource1.Rows[0]["PRONUM"].ToString()) > int.Parse(piece))
  282. // {
  283. // MessageBox.Show("输入的支数不能超过管号队列合格的支数!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
  284. // ultraDataSource1.Rows[0]["PRONUM"] = num;
  285. // Value.ProNum = ultraDataSource1.Rows[0]["PRONUM"].ToString();
  286. // ultraDataSource1.Rows[0]["PROWT"] = wt;
  287. // Value.ProWt = ultraDataSource1.Rows[0]["PROWT"].ToString();
  288. // ultraDataSource1.Rows[0]["ACCNUM"] = ultraDataSource1.Rows[0]["PRONUM"].ToString();
  289. // Value.ProNum = ultraDataSource1.Rows[0]["ACCNUM"].ToString();
  290. // ultraDataSource1.Rows[0]["ACCWT"] = (double.Parse(ultraDataSource1.Rows[0]["ACCNUM"].ToString()) * (double.Parse(wt)) / (double.Parse(num))).ToString("f3");
  291. // Value.ProWt = ultraDataSource1.Rows[0]["ACCWT"].ToString();
  292. // return;
  293. // }
  294. //}
  295. ultraDataSource1.Rows[0]["ACCNUM"] = ultraDataSource1.Rows[0]["PRONUM"].ToString();
  296. Value.ProNum = ultraDataSource1.Rows[0]["ACCNUM"].ToString();
  297. ultraDataSource1.Rows[0]["ACCWT"] = (double.Parse(ultraDataSource1.Rows[0]["ACCNUM"].ToString()) * (double.Parse(wt)) / (double.Parse(num))).ToString("f3");
  298. Value.ProWt = ultraDataSource1.Rows[0]["ACCWT"].ToString();
  299. }
  300. }
  301. }
  302. }