PlanExpanLGColdDrawn.cs 13 KB

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