PlanMeasuringQuery.cs 10 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265
  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. using CoreFS.CA06;
  16. using Core.Mes.Client.Comm.Server;
  17. namespace Core.StlMes.Client.Mcp.Control
  18. {
  19. public partial class PlanMeasuringQuery : UserControl
  20. {
  21. private string num = "";
  22. private string wt = "";
  23. // private InstructionCard _card = new InstructionCard();
  24. private VrpMeasuringResultEntity _load = new VrpMeasuringResultEntity();
  25. private OpeBase ob;
  26. public OpeBase Ob
  27. {
  28. get { return ob; }
  29. set { ob = value; }
  30. }
  31. public VrpMeasuringResultEntity Value
  32. {
  33. get { return _load; }
  34. set
  35. {
  36. if(value != null)
  37. {
  38. this._load = value;
  39. UpdateData();
  40. }
  41. }
  42. }
  43. private Infragistics.Win.UltraWinGrid.UltraGrid _grid = null;
  44. /// <summary>
  45. /// 编辑区GRID
  46. /// </summary>
  47. public Infragistics.Win.UltraWinGrid.UltraGrid Grid
  48. {
  49. get { return _grid; }
  50. }
  51. public PlanMeasuringQuery()
  52. {
  53. InitializeComponent();
  54. GridHelper.InitCardGrid(ultraDataSource1, ultraGrid1);
  55. _grid = this.ultraGrid1;
  56. }
  57. /// <summary>
  58. /// 刷新控件数据显示
  59. /// </summary>
  60. public void UpdateData()
  61. {
  62. if (_load != null)
  63. {
  64. ultraDataSource1.Rows[0]["Producer"] = _load.Producer;
  65. ultraDataSource1.Rows[0]["ProducerTime"] = _load.ProducerTime;
  66. ultraDataSource1.Rows[0]["ProNum"] = _load.ProNum;
  67. ultraDataSource1.Rows[0]["ProWt"] = _load.ProWt;
  68. ultraDataSource1.Rows[0]["LoadShift"] = _load.LoadShift;
  69. ultraDataSource1.Rows[0]["LoadGroup"] = _load.LoadGroup;
  70. ultraDataSource1.Rows[0]["LoadUser"] = _load.LoadUser;
  71. ultraDataSource1.Rows[0]["CreateTime"] = _load.LoadTime;
  72. ultraDataSource1.Rows[0]["AccNum"] = _load.AccNum;
  73. ultraDataSource1.Rows[0]["AccWt"] = _load.AccWt;
  74. ultraDataSource1.Rows[0]["FailNum"] = string.IsNullOrEmpty(_load.FailNum) ? "0" : _load.FailNum;
  75. ultraDataSource1.Rows[0]["FailWt"] = string.IsNullOrEmpty(_load.FailWt) ? "0" : _load.FailWt;
  76. ultraDataSource1.Rows[0]["FailReason"] = _load.FailReason;
  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("ProNum"))
  98. {
  99. Value.ProNum = e.Cell.Value.ToString();
  100. }
  101. if (e.Cell.Column.Key.Equals("LoadUser"))
  102. {
  103. Value.LoadUser = e.Cell.Value.ToString();
  104. }
  105. if (e.Cell.Column.Key.Equals("CreateTime"))
  106. {
  107. Value.LoadTime = e.Cell.Value.ToString();
  108. }
  109. if (e.Cell.Column.Key.Equals("ProWt"))
  110. {
  111. Value.ProWt = e.Cell.Value.ToString();
  112. }
  113. if (e.Cell.Column.Key.Equals("LoadShift"))
  114. {
  115. Value.LoadShift = e.Cell.Value.ToString();
  116. }
  117. if (e.Cell.Column.Key.Equals("LoadGroup"))
  118. {
  119. Value.LoadGroup = e.Cell.Value.ToString();
  120. }
  121. if (e.Cell.Column.Key.Equals("Producer"))
  122. {
  123. Value.Producer = e.Cell.Value.ToString();
  124. }
  125. if (e.Cell.Column.Key.Equals("ProducerTime"))
  126. {
  127. Value.ProducerTime = e.Cell.Value.ToString();
  128. }
  129. if (e.Cell.Column.Key.Equals("AccNum"))
  130. {
  131. Value.AccNum = e.Cell.Value.ToString();
  132. }
  133. if (e.Cell.Column.Key.Equals("AccWt"))
  134. {
  135. Value.AccWt = e.Cell.Value.ToString();
  136. }
  137. if (e.Cell.Column.Key.Equals("FailNum"))
  138. {
  139. Value.FailNum = e.Cell.Value.ToString();
  140. }
  141. if (e.Cell.Column.Key.Equals("FailWt"))
  142. {
  143. Value.FailWt = e.Cell.Value.ToString();
  144. }
  145. if (e.Cell.Column.Key.Equals("FailReason"))
  146. {
  147. Value.FailReason = e.Cell.Value.ToString();
  148. }
  149. }
  150. catch (Exception ex)
  151. {
  152. }
  153. }
  154. /// <summary>
  155. /// 验证格试
  156. /// </summary>
  157. public bool ValidInput1()
  158. {
  159. ultraGrid1.UpdateData();
  160. string TestingNum = ultraDataSource1.Rows[0]["ProNum"].ToString();
  161. string TestingWt = ultraDataSource1.Rows[0]["ProWt"].ToString();
  162. if (!StringUtil.IsInt(TestingNum))
  163. {
  164. MessageBox.Show("合格支数 请输入整数", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
  165. return false;
  166. }
  167. if (!StringUtil.IsDouble(TestingWt))
  168. {
  169. MessageBox.Show("合格重量 请输入重量", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
  170. return false;
  171. }
  172. return true;
  173. }
  174. public void LoadData()
  175. {
  176. DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.coup.CoupCutService.getCutResultFp", new object[] { "6508" }, this.ob);
  177. cmbFaReason.DataSource = dt;
  178. cmbFaReason.ValueMember = "BASENAME";
  179. YdmBaseClass.SetComboItemHeight(cmbFaReason);
  180. }
  181. private void ultraGrid1_CellChange(object sender, CellEventArgs e)
  182. {
  183. if (e.Cell.Column.Key.Equals("FailNum"))//动这个字段会进下面的内容里
  184. {
  185. if (ultraDataSource1.Rows[0]["FailNum"].ToString().Equals(""))
  186. {
  187. ultraDataSource1.Rows[0]["FailNum"] = "0";
  188. }
  189. if (ultraDataSource1.Rows[0]["ProNum"].ToString().Equals(""))
  190. {
  191. ultraDataSource1.Rows[0]["ProNum"] = "0";
  192. }
  193. this.ultraGrid1.UpdateData();
  194. double actnum = double.Parse(ultraDataSource1.Rows[0]["FailNum"].ToString());
  195. if(actnum>int.Parse(ultraDataSource1.Rows[0]["ProNum"].ToString()))
  196. {
  197. MessageBox.Show("废品支数不能大于加工支数!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
  198. return;
  199. }
  200. double actwt = 0;
  201. if (!ultraDataSource1.Rows[0]["ProWt"].ToString().Equals("0"))
  202. {
  203. if (num != null && !num.Equals("0"))
  204. {
  205. actwt = double.Parse(ultraDataSource1.Rows[0]["FailNum"].ToString()) * (double.Parse(wt)) / (double.Parse(num));
  206. }
  207. }
  208. ultraDataSource1.Rows[0]["FailWt"] = actwt.ToString("f3");
  209. Value.FailWt = ultraDataSource1.Rows[0]["FailWt"].ToString();
  210. double failnum = double.Parse(ultraDataSource1.Rows[0]["ProNum"].ToString()) - double.Parse(ultraDataSource1.Rows[0]["FailNum"].ToString());
  211. double failwt = double.Parse(ultraDataSource1.Rows[0]["ProWt"].ToString()) - actwt;
  212. ultraDataSource1.Rows[0]["AccNum"] = failnum.ToString();
  213. Value.AccNum = ultraDataSource1.Rows[0]["AccNum"].ToString();
  214. ultraDataSource1.Rows[0]["AccWt"] = failwt.ToString("f3");
  215. Value.AccWt = ultraDataSource1.Rows[0]["AccWt"].ToString();
  216. //double faillen = failnum * (double.Parse(ultraDataSource1.Rows[0]["PRO_LEN"].ToString())) / (double.Parse(ultraDataSource1.Rows[0]["ProNum"].ToString()));
  217. // ultraDataSource1.Rows[0]["FAIL_LEN"] = faillen;
  218. //Value.FailLen = faillen.ToString();
  219. }
  220. if (e.Cell.Column.Key.Equals("ProNum"))//动这个字段会进下面的内容里
  221. {
  222. if (ultraDataSource1.Rows[0]["ProNum"].ToString().Equals(""))
  223. {
  224. ultraDataSource1.Rows[0]["ProNum"] = "0";
  225. }
  226. this.ultraGrid1.UpdateData();
  227. double actwt = 0;
  228. if (!ultraDataSource1.Rows[0]["ProNum"].ToString().Equals("0"))
  229. {
  230. if(num!=null&&!num.Equals("0"))
  231. {
  232. actwt = double.Parse(ultraDataSource1.Rows[0]["ProNum"].ToString()) * (double.Parse(wt)) / (double.Parse(num));
  233. }
  234. }
  235. double actnum = double.Parse(ultraDataSource1.Rows[0]["ProNum"].ToString());
  236. ultraDataSource1.Rows[0]["ProWt"] = actwt.ToString("f3");
  237. Value.ProWt =ultraDataSource1.Rows[0]["ProWt"].ToString();
  238. ultraDataSource1.Rows[0]["AccNum"] = ultraDataSource1.Rows[0]["ProNum"].ToString();
  239. Value.AccNum = ultraDataSource1.Rows[0]["AccNum"].ToString();
  240. ultraDataSource1.Rows[0]["AccWt"] = ultraDataSource1.Rows[0]["ProWt"].ToString();
  241. Value.AccWt = ultraDataSource1.Rows[0]["AccWt"].ToString();
  242. ultraDataSource1.Rows[0]["FailNum"] = "0";
  243. }
  244. }
  245. }
  246. }