PlanExpanLDColdDrawn.cs 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311
  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 PlanExpanLDColdDrawn : 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 PlanExpanLDColdDrawn()
  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]["SPEMANDREL"] = _load.SpeMandrel;
  61. ultraDataSource1.Rows[0]["SPEROLL"] = _load.SpeRoll;
  62. ultraDataSource1.Rows[0]["TRIMNUM"] = _load.TrimNum;
  63. ultraDataSource1.Rows[0]["SENDNUM"] = _load.SendNum;
  64. ultraDataSource1.Rows[0]["UPPOLE"] = _load.UpPole;
  65. ultraDataSource1.Rows[0]["PPOLE"] = _load.PPole;
  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("SPEMANDREL"))
  116. {
  117. Value.SpeMandrel = e.Cell.Value.ToString();
  118. }
  119. if (e.Cell.Column.Key.Equals("SPEROLL"))
  120. {
  121. Value.SpeRoll = e.Cell.Value.ToString();
  122. }
  123. if (e.Cell.Column.Key.Equals("TRIMNUM"))
  124. {
  125. Value.TrimNum = e.Cell.Value.ToString();
  126. }
  127. if (e.Cell.Column.Key.Equals("SENDNUM"))
  128. {
  129. Value.SendNum = e.Cell.Value.ToString();
  130. }
  131. if (e.Cell.Column.Key.Equals("UPPOLE"))
  132. {
  133. Value.UpPole = e.Cell.Value.ToString();
  134. }
  135. if (e.Cell.Column.Key.Equals("PPOLE"))
  136. {
  137. Value.PPole = 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_CellChange(object sender, CellEventArgs e)
  221. {
  222. ultraGrid1.UpdateData();
  223. if (e.Cell.Column.Key.Equals("FAILNUM"))//动这个字段会进下面的内容里
  224. {
  225. if (ultraDataSource1.Rows[0]["FAILNUM"].ToString().Equals(""))
  226. {
  227. ultraDataSource1.Rows[0]["FAILNUM"] = "0";
  228. }
  229. if (ultraDataSource1.Rows[0]["PRONUM"].ToString().Equals(""))
  230. {
  231. ultraDataSource1.Rows[0]["PRONUM"] = "0";
  232. }
  233. double actnum = double.Parse(ultraDataSource1.Rows[0]["FAILNUM"].ToString());
  234. if (actnum > int.Parse(ultraDataSource1.Rows[0]["PRONUM"].ToString()))
  235. {
  236. MessageBox.Show("废品支数不能大于加工支数!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
  237. return;
  238. }
  239. double actwt = 0;
  240. if (!ultraDataSource1.Rows[0]["PROWT"].ToString().Equals("0"))
  241. {
  242. if (num != null && !num.Equals("0"))
  243. {
  244. actwt = double.Parse(ultraDataSource1.Rows[0]["FAILNUM"].ToString()) * (double.Parse(wt)) / (double.Parse(num));
  245. }
  246. }
  247. ultraDataSource1.Rows[0]["FAILWT"] = actwt.ToString("f3");
  248. Value.FailWt = ultraDataSource1.Rows[0]["FAILWT"].ToString();
  249. double failnum = double.Parse(ultraDataSource1.Rows[0]["PRONUM"].ToString()) - double.Parse(ultraDataSource1.Rows[0]["FAILNUM"].ToString());
  250. double failwt = double.Parse(ultraDataSource1.Rows[0]["PROWT"].ToString()) - actwt;
  251. ultraDataSource1.Rows[0]["ACCNUM"] = failnum.ToString();
  252. Value.AccNum = ultraDataSource1.Rows[0]["ACCNUM"].ToString();
  253. ultraDataSource1.Rows[0]["ACCWT"] = failwt.ToString("f3");
  254. Value.AccWt = ultraDataSource1.Rows[0]["ACCWT"].ToString();
  255. }
  256. if (e.Cell.Column.Key.Equals("PRONUM"))//动这个字段会进下面的内容里
  257. {
  258. if (ultraDataSource1.Rows[0]["PRONUM"].ToString().Equals(""))
  259. {
  260. ultraDataSource1.Rows[0]["PRONUM"] = "0";
  261. }
  262. double actwt = 0;
  263. if (!ultraDataSource1.Rows[0]["PRONUM"].ToString().Equals("0"))
  264. {
  265. if (num != null && !num.Equals("0"))
  266. {
  267. actwt = double.Parse(ultraDataSource1.Rows[0]["PRONUM"].ToString()) * (double.Parse(wt)) / (double.Parse(num));
  268. }
  269. }
  270. double actnum = double.Parse(ultraDataSource1.Rows[0]["PRONUM"].ToString());
  271. ultraDataSource1.Rows[0]["PROWT"] = actwt.ToString("f3");
  272. Value.ProWt = ultraDataSource1.Rows[0]["PROWT"].ToString();
  273. //if (piece != null && !piece.Equals(""))
  274. //{
  275. // if (int.Parse(ultraDataSource1.Rows[0]["PRONUM"].ToString()) > int.Parse(piece))
  276. // {
  277. // MessageBox.Show("输入的支数不能超过管号队列合格的支数!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
  278. // ultraDataSource1.Rows[0]["PRONUM"] = num;
  279. // Value.ProNum = ultraDataSource1.Rows[0]["PRONUM"].ToString();
  280. // ultraDataSource1.Rows[0]["PROWT"] = wt;
  281. // Value.ProWt = ultraDataSource1.Rows[0]["PROWT"].ToString();
  282. // ultraDataSource1.Rows[0]["ACCNUM"] = ultraDataSource1.Rows[0]["PRONUM"].ToString();
  283. // Value.ProNum = ultraDataSource1.Rows[0]["ACCNUM"].ToString();
  284. // ultraDataSource1.Rows[0]["ACCWT"] = (double.Parse(ultraDataSource1.Rows[0]["ACCNUM"].ToString()) * (double.Parse(wt)) / (double.Parse(num))).ToString("f3");
  285. // Value.ProWt = ultraDataSource1.Rows[0]["ACCWT"].ToString();
  286. // return;
  287. // }
  288. //}
  289. ultraDataSource1.Rows[0]["ACCNUM"] = ultraDataSource1.Rows[0]["PRONUM"].ToString();
  290. Value.ProNum = ultraDataSource1.Rows[0]["ACCNUM"].ToString();
  291. ultraDataSource1.Rows[0]["ACCWT"] = (double.Parse(ultraDataSource1.Rows[0]["ACCNUM"].ToString()) * (double.Parse(wt)) / (double.Parse(num))).ToString("f3");
  292. Value.ProWt = ultraDataSource1.Rows[0]["ACCWT"].ToString();
  293. }
  294. }
  295. }
  296. }