PlanExpanQuery.cs 8.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242
  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 PlanExpanQuery : UserControl
  20. {
  21. private string actnum = "";
  22. private string actwt = "";
  23. public string danum = "";
  24. // private InstructionCard _card = new InstructionCard();
  25. private VrpLoadingResultEntity _load = new VrpLoadingResultEntity();
  26. private OpeBase ob;
  27. public OpeBase Ob
  28. {
  29. get { return ob; }
  30. set { ob = value; }
  31. }
  32. private string judNo;
  33. public string JudNo
  34. {
  35. get { return judNo; }
  36. set { judNo = value; }
  37. }
  38. private string plineCode;
  39. public string PlineCode
  40. {
  41. get { return plineCode; }
  42. set { plineCode = value; }
  43. }
  44. private string batchNo;
  45. public string BatchNo
  46. {
  47. get { return batchNo; }
  48. set { batchNo = value; }
  49. }
  50. private string groupNo;
  51. public string GroupNo
  52. {
  53. get { return groupNo; }
  54. set { groupNo = value; }
  55. }
  56. private string jianZhi;
  57. public string JianZhi
  58. {
  59. get { return jianZhi; }
  60. set { jianZhi = value; }
  61. }
  62. public VrpLoadingResultEntity Value
  63. {
  64. get { return _load; }
  65. set
  66. {
  67. if(value != null)
  68. {
  69. this._load = value;
  70. UpdateData();
  71. }
  72. }
  73. }
  74. private Infragistics.Win.UltraWinGrid.UltraGrid _grid = null;
  75. /// <summary>
  76. /// 编辑区GRID
  77. /// </summary>
  78. public Infragistics.Win.UltraWinGrid.UltraGrid Grid
  79. {
  80. get { return _grid; }
  81. }
  82. public PlanExpanQuery()
  83. {
  84. InitializeComponent();
  85. GridHelper.InitCardGrid(ultraDataSource1, ultraGrid1);
  86. _grid = this.ultraGrid1;
  87. }
  88. /// <summary>
  89. /// 刷新控件数据显示
  90. /// </summary>
  91. public void UpdateData()
  92. {
  93. // if (JianZhi.Equals("1"))
  94. // {
  95. // ultraGrid1.DisplayLayout.Bands[0].Columns["Producer"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.AllowEdit;
  96. // }
  97. // else
  98. // {
  99. // ultraGrid1.DisplayLayout.Bands[0].Columns["Producer"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.ActivateOnly;
  100. // }
  101. if (_load != null)
  102. {
  103. ultraDataSource1.Rows[0]["Producer"] = _load.Producer;
  104. ultraDataSource1.Rows[0]["ProducerTime"] = _load.ProducerTime;
  105. ultraDataSource1.Rows[0]["ProNum"] = _load.ProNum;
  106. ultraDataSource1.Rows[0]["ProWt"] = _load.ProWt;
  107. ultraDataSource1.Rows[0]["LoadShift"] = _load.LoadShift;
  108. ultraDataSource1.Rows[0]["LoadGroup"] = _load.LoadGroup;
  109. ultraDataSource1.Rows[0]["LoadUser"] = _load.LoadUser;
  110. ultraDataSource1.Rows[0]["LoadTime"] = _load.LoadTime;
  111. //ultraDataSource1.Rows[0]["OnlineWegit"] = _load.LoadWeghit;
  112. actnum = _load.ProNum;
  113. actwt = _load.ProWt;
  114. }
  115. else
  116. {
  117. GridHelper.InitCardGrid(ultraDataSource1,ultraGrid1);
  118. }
  119. this.ultraGrid1.UpdateData();
  120. ultraGrid1.PerformAction(UltraGridAction.ExitEditMode);
  121. ultraGrid1.PerformAction(UltraGridAction.EnterEditMode);
  122. }
  123. /// <summary>
  124. /// 控件编辑后更新已修改数据
  125. /// </summary>
  126. public void CompleteEdit()
  127. {
  128. ultraGrid1.UpdateData();
  129. }
  130. private void ultraGrid1_AfterCellUpdate(object sender, CellEventArgs e)
  131. {
  132. try
  133. {
  134. if (e.Cell.Column.Key.Equals("ProNum"))
  135. {
  136. Value.ProNum = e.Cell.Value.ToString();
  137. }
  138. if (e.Cell.Column.Key.Equals("LoadUser"))
  139. {
  140. Value.LoadUser = e.Cell.Value.ToString();
  141. }
  142. if (e.Cell.Column.Key.Equals("LoadTime"))
  143. {
  144. Value.LoadTime = e.Cell.Value.ToString();
  145. }
  146. if (e.Cell.Column.Key.Equals("ProWt"))
  147. {
  148. Value.ProWt = e.Cell.Value.ToString();
  149. }
  150. if (e.Cell.Column.Key.Equals("LoadShift"))
  151. {
  152. Value.LoadShift = e.Cell.Value.ToString();
  153. }
  154. if (e.Cell.Column.Key.Equals("LoadGroup"))
  155. {
  156. Value.LoadGroup = e.Cell.Value.ToString();
  157. }
  158. if (e.Cell.Column.Key.Equals("Producer"))
  159. {
  160. Value.Producer = e.Cell.Value.ToString();
  161. }
  162. if (e.Cell.Column.Key.Equals("ProducerTime"))
  163. {
  164. Value.ProducerTime = e.Cell.Value.ToString();
  165. }
  166. }
  167. catch (Exception ex)
  168. {
  169. }
  170. }
  171. /// <summary>
  172. /// 验证格试
  173. /// </summary>
  174. public bool ValidInput1()
  175. {
  176. ultraGrid1.UpdateData();
  177. string TestingNum = ultraDataSource1.Rows[0]["ProNum"].ToString();
  178. string TestingWt = ultraDataSource1.Rows[0]["ProWt"].ToString();
  179. if (!StringUtil.IsInt(TestingNum))
  180. {
  181. MessageBox.Show("上料支数 请输入整数", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
  182. return false;
  183. }
  184. if (!StringUtil.IsDouble(TestingWt))
  185. {
  186. MessageBox.Show("上料重量 请输入重量", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
  187. return false;
  188. }
  189. return true;
  190. }
  191. private void ultraGrid1_CellChange(object sender, CellEventArgs e)
  192. {
  193. ultraGrid1.UpdateData();
  194. if (e.Cell.Column.Key.Equals("ProNum"))
  195. {
  196. if (ultraDataSource1.Rows[0]["ProNum"].ToString().Equals(""))
  197. {
  198. ultraDataSource1.Rows[0]["ProNum"] = "0";
  199. }
  200. DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.Vrp.FrmVrpLoading.getQueryWeight", new object[] { ultraDataSource1.Rows[0]["ProNum"].ToString(), JudNo, BatchNo, GroupNo, PlineCode }, this.Ob);
  201. //double ctwt = double.Parse(ultraDataSource1.Rows[0]["ProNum"].ToString()) * (double.Parse(actwt) / double.Parse(actnum));
  202. //ultraDataSource1.Rows[0]["ProWt"] = ctwt.ToString();
  203. //Value.ProWt = ultraDataSource1.Rows[0]["ProWt"].ToString();
  204. if (dt.Rows.Count > 0)
  205. {
  206. ultraDataSource1.Rows[0]["ProWt"] = dt.Rows[0]["ACT_WEIGHT"].ToString();
  207. Value.ProWt= ultraDataSource1.Rows[0]["ProWt"].ToString();
  208. }
  209. if (Convert.ToInt32(ultraDataSource1.Rows[0]["ProNum"].ToString())>Convert.ToInt32(danum))
  210. {
  211. MessageUtil.ShowTips("上料支数不允许大于待上料支数!");
  212. ultraDataSource1.Rows[0]["ProNum"] = actnum;
  213. Value.ProNum = ultraDataSource1.Rows[0]["ProNum"].ToString();
  214. ultraDataSource1.Rows[0]["ProWt"] = actwt;
  215. Value.ProWt = ultraDataSource1.Rows[0]["ProWt"].ToString();
  216. return;
  217. }
  218. }
  219. }
  220. }
  221. }