FrmInLibrary.cs 34 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769
  1. using com.steering.mes.mcp.entity;
  2. using Core.Mes.Client.Comm.Control;
  3. using Core.Mes.Client.Comm.Server;
  4. using Core.Mes.Client.Comm.Tool;
  5. using Core.StlMes.Client.Mcp.CollarMaterial;
  6. using Core.StlMes.Client.Mcp.Common;
  7. using Core.StlMes.Client.Mcp.Control;
  8. using Core.StlMes.Client.Mcp.Entity;
  9. using CoreFS.CA06;
  10. using Infragistics.Win;
  11. using Infragistics.Win.UltraWinGrid;
  12. using System;
  13. using System.Collections;
  14. using System.Collections.Generic;
  15. using System.ComponentModel;
  16. using System.Data;
  17. using System.Drawing;
  18. using System.Linq;
  19. using System.Text;
  20. using System.Windows.Forms;
  21. namespace Core.StlMes.Client.Mcp.Coupling
  22. {
  23. public partial class FrmInLibrary : FrmBase
  24. {
  25. private string departm = "";//获取部门ID
  26. private string[] plineCode = null;//获取产线代码
  27. private string cutGx = "";//交库工序
  28. public FrmInLibrary()
  29. {
  30. InitializeComponent();
  31. this.IsLoadUserView = true;
  32. }
  33. private void FrmInLibrary_Load(object sender, EventArgs e)
  34. {
  35. departm = UserInfo.GetDeptid();
  36. plineCode = McpBaseHelper.GetPCodePline(departm, this.ob);
  37. //获取交库工序
  38. DataTable dt2 = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryGX", new object[] { "700313" }, this.ob);
  39. if (dt2.Rows.Count > 0)
  40. {
  41. cutGx = dt2.Rows[0]["BASECODE"].ToString();
  42. }
  43. PipeManageClass.BindComBaseInfo(cmbStroage, this.ob);
  44. EntityHelper.ShowGridCaption<PlnOrderJgEntity>(ultraGrid2.DisplayLayout.Bands[0]);
  45. }
  46. public override void ToolBar_Click(object sender, string ToolbarKey)
  47. {
  48. switch (ToolbarKey)
  49. {
  50. case "DoQuery":
  51. QuerySinglePlan();//查询计划
  52. break;
  53. //case "MatQuery":
  54. // DoMatQuery();//材料查询
  55. // break;
  56. case "DoSave":
  57. DoSave();
  58. break;
  59. case "DoUpdate":
  60. DoUpdate();//库位修改
  61. break;
  62. case "DoDelete":
  63. DoDelete();
  64. break;
  65. case "DoBeside"://结炉
  66. DoBeside();
  67. break;
  68. case "UndoBeside"://撤销结炉
  69. UndoBeside();
  70. break;
  71. case "DoApply"://申请判定
  72. DoApply();
  73. break;
  74. case "UndoApply"://撤销申请
  75. UndoApply();
  76. break;
  77. case "DoClose":
  78. this.Close();
  79. break;
  80. }
  81. }
  82. /// <summary>
  83. /// 申请判定
  84. /// </summary>
  85. private void DoApply()
  86. {
  87. string piece = "";
  88. ultraGrid3.UpdateData();
  89. UltraGridRow row = ultraGrid1.ActiveRow;
  90. if (row == null) return;
  91. UltraGridRow urg = ultraGrid3.ActiveRow;
  92. if (urg == null) { MessageUtil.ShowTips("无交库信息!"); return; }
  93. int addCount = 0;
  94. ArrayList list = new ArrayList();
  95. string time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
  96. foreach (UltraGridRow uRow in ultraGrid3.Rows)
  97. {
  98. if (Convert.ToBoolean(uRow.Cells["CHK"].Text) == true)
  99. {
  100. addCount += 1;
  101. ArrayList list1 = new ArrayList();
  102. list1.Add(uRow.Cells["DEAL_ORDE"].Value.ToString());
  103. list1.Add(uRow.Cells["WO_ID"].Value.ToString());
  104. list1.Add(uRow.Cells["ZY_PLAN_ID"].Value.ToString());
  105. list1.Add(uRow.Cells["JUDGE_STOVE_NO"].Value.ToString());
  106. list1.Add(uRow.Cells["BATCH_NO"].Value.ToString());
  107. list1.Add(this.UserInfo.GetUserName());
  108. list1.Add(uRow.Cells["PIECES"].Value.ToString());
  109. list1.Add(time);
  110. list1.Add(uRow.Cells["PLINE_CODE"].Text.ToString());
  111. list.Add(list1);
  112. if (uRow.Cells["PIECES"].Value.ToString()=="")
  113. {
  114. uRow.Cells["PIECES"].Value = "0";
  115. }
  116. piece = uRow.Cells["PIECES"].Value.ToString();
  117. }
  118. }
  119. if (addCount == 0)
  120. {
  121. MessageUtil.ShowTips("请选择要申请判定的交库信息!");
  122. return;
  123. }
  124. else
  125. {
  126. if (piece != row.Cells["SJ_NUM"].Text.ToString())
  127. {
  128. MessageUtil.ShowTips("申请判定支数不等于实绩产出支数,无法申请判定!");
  129. return;
  130. }
  131. }
  132. if (MessageUtil.ShowYesNoAndQuestion("是否申请判定?") == DialogResult.No)
  133. {
  134. return;
  135. }
  136. CoreClientParam ccp = new CoreClientParam();
  137. try
  138. {
  139. this.Cursor = Cursors.WaitCursor; //控制鼠标的样式为等待
  140. if (Constant.WaitingForm == null)
  141. {
  142. Constant.WaitingForm = new WaitingForm();
  143. }
  144. Constant.WaitingForm.ShowToUser = true;
  145. Constant.WaitingForm.Show();
  146. Constant.WaitingForm.Update();
  147. ccp.ServerName = "com.steering.mes.mcp.coup.FrmInLibrary";
  148. ccp.MethodName = "doApplyResult";
  149. ccp.ServerParams = new object[] { list };
  150. ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  151. this.Cursor = Cursors.Default;
  152. Constant.WaitingForm.ShowToUser = false;
  153. Constant.WaitingForm.Close();
  154. Constant.WaitingForm = null;
  155. }
  156. catch (Exception ex)
  157. {
  158. this.Cursor = Cursors.Default;
  159. Constant.WaitingForm.ShowToUser = false;
  160. Constant.WaitingForm.Close();
  161. Constant.WaitingForm = null;
  162. }
  163. if (ccp.ReturnCode == -1) return;
  164. MessageUtil.ShowTips(ccp.ReturnInfo);
  165. if (ccp.ReturnInfo.Equals("申请判定成功!"))
  166. {
  167. QuerySinglePlan();
  168. }
  169. }
  170. /// <summary>
  171. /// 撤销判定
  172. /// </summary>
  173. private void UndoApply() {
  174. ultraGrid3.UpdateData();
  175. UltraGridRow urg = ultraGrid3.ActiveRow;
  176. if (urg == null) { MessageUtil.ShowTips("无交库信息!"); return; }
  177. int addCount = 0;
  178. ArrayList list = new ArrayList();
  179. foreach (UltraGridRow uRow in ultraGrid3.Rows)
  180. {
  181. if (Convert.ToBoolean(uRow.Cells["CHK"].Text) == true)
  182. {
  183. addCount += 1;
  184. ArrayList list1 = new ArrayList();
  185. list1.Add(uRow.Cells["DEAL_ORDE"].Value.ToString());
  186. list1.Add(uRow.Cells["WO_ID"].Value.ToString());
  187. list1.Add(uRow.Cells["ZY_PLAN_ID"].Value.ToString());
  188. list1.Add(uRow.Cells["JUDGE_STOVE_NO"].Value.ToString());
  189. list1.Add(uRow.Cells["BATCH_NO"].Value.ToString());
  190. list1.Add(this.UserInfo.GetUserName());
  191. list1.Add(uRow.Cells["PIECES"].Value.ToString());
  192. list1.Add(uRow.Cells["PLINE_CODE"].Text.ToString());
  193. list.Add(list1);
  194. }
  195. }
  196. if (addCount == 0) { MessageUtil.ShowTips("请选择要撤销判定的交库信息!"); return; }
  197. if (MessageUtil.ShowYesNoAndQuestion("是否撤销判定?") == DialogResult.No)
  198. {
  199. return;
  200. }
  201. CoreClientParam ccp = new CoreClientParam();
  202. try
  203. {
  204. this.Cursor = Cursors.WaitCursor; //控制鼠标的样式为等待
  205. if (Constant.WaitingForm == null)
  206. {
  207. Constant.WaitingForm = new WaitingForm();
  208. }
  209. Constant.WaitingForm.ShowToUser = true;
  210. Constant.WaitingForm.Show();
  211. Constant.WaitingForm.Update();
  212. ccp.ServerName = "com.steering.mes.mcp.coup.FrmInLibrary";
  213. ccp.MethodName = "undoApplyResult";
  214. ccp.ServerParams = new object[] { list };
  215. ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  216. this.Cursor = Cursors.Default;
  217. Constant.WaitingForm.ShowToUser = false;
  218. Constant.WaitingForm.Close();
  219. Constant.WaitingForm = null;
  220. }
  221. catch (Exception ex)
  222. {
  223. this.Cursor = Cursors.Default;
  224. Constant.WaitingForm.ShowToUser = false;
  225. Constant.WaitingForm.Close();
  226. Constant.WaitingForm = null;
  227. }
  228. if (ccp.ReturnCode == -1) return;
  229. MessageUtil.ShowTips(ccp.ReturnInfo);
  230. if (ccp.ReturnInfo.Equals("撤销判定成功!"))
  231. {
  232. QuerySinglePlan();
  233. }
  234. }
  235. /// <summary>
  236. /// 库位修改
  237. /// </summary>
  238. private void DoUpdate()
  239. {
  240. ultraGrid3.UpdateData();
  241. UltraGridRow urg = ultraGrid3.ActiveRow;
  242. if (urg == null) { MessageUtil.ShowTips("无库存信息!"); return; }
  243. int addCount = 0;
  244. ArrayList list = new ArrayList();
  245. string date = DateTime.Now.ToString();
  246. foreach (UltraGridRow uRow in ultraGrid3.Rows)
  247. {
  248. if (Convert.ToBoolean(uRow.Cells["CHK"].Text) == true)
  249. {
  250. addCount += 1;
  251. if (uRow.Cells["KEP_NO"].Text.Trim() == "")
  252. {
  253. MessageUtil.ShowTips("框号不能为空!");
  254. return;
  255. }
  256. if (uRow.Cells["STORAGE_NO"].Text.Trim() == "")
  257. {
  258. MessageUtil.ShowTips("库位不能空!");
  259. return;
  260. }
  261. ArrayList list1 = new ArrayList();
  262. list1.Add(uRow.Cells["MAT_NO"].Value.ToString());
  263. list1.Add(uRow.Cells["ZY_PLAN_ID"].Value.ToString());
  264. list1.Add(uRow.Cells["RESULT_NO"].Value.ToString());
  265. list1.Add(uRow.Cells["KEP_NO"].Value.ToString());
  266. list1.Add(uRow.Cells["STORAGE_NO"].Value.ToString());
  267. list1.Add(this.UserInfo.GetUserName());
  268. list1.Add(date);
  269. list.Add(list1);
  270. }
  271. }
  272. if (addCount == 0) { MessageUtil.ShowTips("请选择接箍库存信息!"); return; }
  273. if (MessageUtil.ShowYesNoAndQuestion("是否修改位置?") == DialogResult.No)
  274. {
  275. return;
  276. }
  277. CoreClientParam ccp = new CoreClientParam();
  278. try
  279. {
  280. this.Cursor = Cursors.WaitCursor; //控制鼠标的样式为等待
  281. if (Constant.WaitingForm == null)
  282. {
  283. Constant.WaitingForm = new WaitingForm();
  284. }
  285. Constant.WaitingForm.ShowToUser = true;
  286. Constant.WaitingForm.Show();
  287. Constant.WaitingForm.Update();
  288. ccp.ServerName = "com.steering.mes.mcp.coup.FrmInLibrary";
  289. ccp.MethodName = "updateLibraryResult";
  290. ccp.ServerParams = new object[] { list};
  291. ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  292. this.Cursor = Cursors.Default;
  293. Constant.WaitingForm.ShowToUser = false;
  294. Constant.WaitingForm.Close();
  295. Constant.WaitingForm = null;
  296. }
  297. catch (Exception ex)
  298. {
  299. this.Cursor = Cursors.Default;
  300. Constant.WaitingForm.ShowToUser = false;
  301. Constant.WaitingForm.Close();
  302. Constant.WaitingForm = null;
  303. }
  304. if (ccp.ReturnCode == -1) return;
  305. MessageUtil.ShowTips(ccp.ReturnInfo);
  306. if (ccp.ReturnInfo.Equals("修改位置成功!"))
  307. {
  308. QuerySinglePlan();
  309. }
  310. }
  311. /// <summary>
  312. /// 材料查询
  313. /// </summary>
  314. private void DoMatQuery()
  315. {
  316. string woId = "";
  317. string judgeStoveNo = "";
  318. string plnNo = "";
  319. #region 条件
  320. if (chkwoId.Checked && string.IsNullOrEmpty(txtWoId.Text.Trim()))
  321. {
  322. MessageUtil.ShowTips("请输入工单号!");
  323. return;
  324. }
  325. else
  326. {
  327. woId = txtWoId.Text.ToString().Trim();
  328. }
  329. if (chkPlnNo.Checked && string.IsNullOrEmpty(txtPlnNo.Text.Trim()))
  330. {
  331. MessageUtil.ShowTips("请输入炉次计划号!");
  332. return;
  333. }
  334. else
  335. {
  336. plnNo = txtPlnNo.Text.ToString().Trim();
  337. }
  338. if (chkJuNo.Checked && string.IsNullOrEmpty(txtJudgeStoveNO.Text.Trim()))
  339. {
  340. MessageUtil.ShowTips("请输入炉号!");
  341. return;
  342. }
  343. else
  344. {
  345. judgeStoveNo = txtJudgeStoveNO.Text.ToString().Trim();
  346. }
  347. #endregion
  348. ArrayList list = new ArrayList();
  349. list.Add(woId);
  350. list.Add(plnNo);
  351. list.Add(judgeStoveNo);
  352. DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.coup.FrmInLibrary.doQueryMatNo", new object[] { list, plineCode[0].ToString() }, this.ob);
  353. GridHelper.CopyDataToDatatable(ref dt, ref dateMat, true);
  354. }
  355. private void QuerySinglePlan()
  356. {
  357. string woId = "";
  358. string judgeStoveNo = "";
  359. string plnNo = "";
  360. #region 条件
  361. if (chkwoId.Checked && string.IsNullOrEmpty(txtWoId.Text.Trim()))
  362. {
  363. MessageUtil.ShowTips("请输入工单号!");
  364. return;
  365. }
  366. else
  367. {
  368. woId = txtWoId.Text.ToString().Trim();
  369. }
  370. if (chkPlnNo.Checked && string.IsNullOrEmpty(txtPlnNo.Text.Trim()))
  371. {
  372. MessageUtil.ShowTips("请输入炉次计划号!");
  373. return;
  374. }
  375. else
  376. {
  377. plnNo = txtPlnNo.Text.ToString().Trim();
  378. }
  379. if (chkJuNo.Checked && string.IsNullOrEmpty(txtJudgeStoveNO.Text.Trim()))
  380. {
  381. MessageUtil.ShowTips("请输入炉号!");
  382. return;
  383. }
  384. else
  385. {
  386. judgeStoveNo = txtJudgeStoveNO.Text.ToString().Trim();
  387. }
  388. #endregion
  389. ArrayList list = new ArrayList();
  390. list.Add(woId);
  391. list.Add(plnNo);
  392. list.Add(judgeStoveNo);
  393. DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.coup.FrmInLibrary.doQueryZygNo", new object[] { list,plineCode[0].ToString() }, this.ob);
  394. GridHelper.CopyDataToDatatable(ref dt, ref dataTable3, true);
  395. //DataTable dt1 = ServerHelper.GetData("com.steering.mes.mcp.coup.FrmInLibrary.doQueryMatNo", new object[] { list, plineCode[0].ToString() }, this.ob);
  396. //GridHelper.CopyDataToDatatable(ref dt1, ref dataTable2, true);
  397. }
  398. /// <summary>
  399. /// 编辑区Gird
  400. /// </summary>
  401. /// <param name="sender"></param>
  402. /// <param name="e"></param>
  403. private void ultraGrid1_CellChange(object sender, Infragistics.Win.UltraWinGrid.CellEventArgs e)
  404. {
  405. UltraGridRow row = ultraGrid1.ActiveRow;
  406. if (row == null) return;
  407. ultraGrid1.UpdateData();
  408. if (e.Cell.Column.Key.Equals("FAIL_CUT_NUM"))
  409. {
  410. if(e.Cell.Row.Cells["FAIL_CUT_NUM"].Text.ToString().Trim()=="")
  411. {
  412. e.Cell.Row.Cells["FAIL_CUT_NUM"].Value = "0";
  413. }
  414. if (double.Parse(e.Cell.Row.Cells["FAIL_CUT_NUM"].Value.ToString()) > double.Parse(e.Cell.Row.Cells["PLAN_JG_NUM"].Value.ToString()))
  415. {
  416. MessageUtil.ShowTips("废品个数不能大于计划个数!");
  417. e.Cell.Row.Cells["FAIL_CUT_NUM"].Value = e.Cell.Row.Cells["PLAN_JG_NUM"].Value.ToString();
  418. return;
  419. }
  420. e.Cell.Row.Cells["LL_NUM"].Value = double.Parse(e.Cell.Row.Cells["PLAN_JG_NUM"].Value.ToString()) - double.Parse(e.Cell.Row.Cells["FAIL_CUT_NUM"].Value.ToString());
  421. e.Cell.Row.Cells["CLC_NUM"].Value = double.Parse(e.Cell.Row.Cells["PLAN_JG_NUM"].Value.ToString()) - double.Parse(e.Cell.Row.Cells["FAIL_CUT_NUM"].Value.ToString()) - double.Parse(e.Cell.Row.Cells["SJ_NUM"].Value.ToString());
  422. }
  423. if (e.Cell.Column.Key.Equals("SPRAY_COUNT"))
  424. {
  425. if (e.Cell.Row.Cells["SPRAY_COUNT"].Text.ToString().Trim() == "")
  426. {
  427. e.Cell.Row.Cells["SPRAY_COUNT"].Value = "0";
  428. }
  429. if (double.Parse(e.Cell.Row.Cells["SPRAY_COUNT"].Value.ToString()) > double.Parse(e.Cell.Row.Cells["SJ_NUM"].Value.ToString()))
  430. {
  431. MessageUtil.ShowTips("实际入库个数不能大于实际产出个数!");
  432. e.Cell.Row.Cells["SPRAY_COUNT"].Value = e.Cell.Row.Cells["SJ_NUM"].Value.ToString();
  433. return;
  434. }
  435. e.Cell.Row.Cells["SJ_NUM1"].Value = double.Parse(e.Cell.Row.Cells["SJ_NUM"].Value.ToString()) - double.Parse(e.Cell.Row.Cells["SPRAY_COUNT"].Value.ToString());
  436. }
  437. }
  438. private void DoSave()
  439. {
  440. ultraGrid1.UpdateData();
  441. UltraGridRow urg = ultraGrid1.ActiveRow;
  442. if (urg == null)return;
  443. int addCount = 0;
  444. ArrayList list = new ArrayList();
  445. foreach (UltraGridRow uRow in ultraGrid1.Rows)
  446. {
  447. if (Convert.ToBoolean(uRow.Cells["CHK"].Text) == true)
  448. {
  449. addCount += 1;
  450. //产量差
  451. if (uRow.Cells["CLC_NUM"].Value.ToString() != "0")
  452. {
  453. MessageUtil.ShowTips("您选择的工单产量不平!");
  454. return;
  455. }
  456. int fallNum = int.Parse(urg.Cells["FAIL_CUT_NUM"].Value.ToString()) - int.Parse(urg.Cells["FAIL_CUT_NUM1"].Value.ToString());
  457. ArrayList pram = new ArrayList();
  458. pram.Add(urg.Cells["ZY_PLAN_ID"].Text.ToString());
  459. pram.Add(urg.Cells["PLINE_CODE"].Text.ToString());
  460. pram.Add(urg.Cells["WO_ID"].Text.ToString());
  461. pram.Add(urg.Cells["SJ_NUM"].Text.ToString());
  462. pram.Add(urg.Cells["FAIL_CUT_NUM"].Text.ToString());
  463. pram.Add(this.UserInfo.GetUserName());
  464. pram.Add(this.UserInfo.GetUserOrder());
  465. pram.Add(this.UserInfo.GetUserGroup());
  466. pram.Add(urg.Cells["SPRAY_COUNT"].Text.ToString());
  467. list.Add(pram);
  468. }
  469. }
  470. if (addCount == 0) { MessageUtil.ShowTips("请选择要交库工单信息!"); return; }
  471. if (MessageUtil.ShowYesNoAndQuestion("是否交库?") == DialogResult.No)
  472. {
  473. return;
  474. }
  475. CoreClientParam ccp = new CoreClientParam();
  476. try
  477. {
  478. this.Cursor = Cursors.WaitCursor; //控制鼠标的样式为等待
  479. if (Constant.WaitingForm == null)
  480. {
  481. Constant.WaitingForm = new WaitingForm();
  482. }
  483. Constant.WaitingForm.ShowToUser = true;
  484. Constant.WaitingForm.Show();
  485. Constant.WaitingForm.Update();
  486. ccp.ServerName = "com.steering.mes.mcp.coup.FrmInLibrary";
  487. ccp.MethodName = "addLibraryResult";
  488. ccp.ServerParams = new object[] { list, cutGx, urg.Cells["WO_ID"].Text.ToString() };
  489. ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  490. this.Cursor = Cursors.Default;
  491. Constant.WaitingForm.ShowToUser = false;
  492. Constant.WaitingForm.Close();
  493. Constant.WaitingForm = null;
  494. }
  495. catch (Exception ex)
  496. {
  497. this.Cursor = Cursors.Default;
  498. Constant.WaitingForm.ShowToUser = false;
  499. Constant.WaitingForm.Close();
  500. Constant.WaitingForm = null;
  501. }
  502. if (ccp.ReturnCode == -1) return;
  503. MessageUtil.ShowTips(ccp.ReturnInfo);
  504. if (ccp.ReturnInfo.Equals("交库成功!"))
  505. {
  506. QuerySinglePlan();
  507. DataTable dt = new DataTable();
  508. GridHelper.CopyDataToDatatable(ref dt, ref dataTable1, true);
  509. }
  510. }
  511. /// <summary>
  512. /// ultraGrid2 触发事件
  513. /// </summary>
  514. /// <param name="sender"></param>
  515. /// <param name="e"></param>
  516. //private void ultraGrid2_AfterRowActivate(object sender, EventArgs e)
  517. //{
  518. // UltraGridRow row = ultraGrid1.ActiveRow;
  519. // if (row == null)
  520. // {
  521. // //List<CouplingComInfoEntity> listSource = new List<Entity.CouplingComInfoEntity>();
  522. // //CouplingComInfoEntity.DataSource = listSource;
  523. // //GridHelper.RefreshAndAutoSize(ultraGrid3);
  524. // }
  525. // else
  526. // {
  527. // //List<CouplingComInfoEntity> listSource = EntityHelper.GetData<CouplingComInfoEntity>
  528. // // ("com.steering.mes.mcp.coup.FrmInLibrary.doQueryInfoResult", new object[] { row.Cells["ZY_PLAN_ID"].Text.ToString(), row.Cells["WO_ID"].Text.ToString() }, this.ob);
  529. // //CouplingComInfoEntity.DataSource = listSource;
  530. // //GridHelper.RefreshAndAutoSize(ultraGrid3);
  531. // }
  532. //}
  533. /// <summary>
  534. /// 删除交库实绩
  535. /// </summary>
  536. private void DoDelete()
  537. {
  538. ultraGrid3.UpdateData();
  539. UltraGridRow urg = ultraGrid3.ActiveRow;
  540. if (urg == null) { MessageUtil.ShowTips("无交库信息!"); return; }
  541. int addCount = 0;
  542. ArrayList list = new ArrayList();
  543. foreach (UltraGridRow uRow in ultraGrid3.Rows)
  544. {
  545. if (Convert.ToBoolean(uRow.Cells["CHK"].Text) == true)
  546. {
  547. addCount += 1;
  548. ArrayList list1 = new ArrayList();
  549. list1.Add(uRow.Cells["DEAL_ORDE"].Value.ToString());
  550. list1.Add(uRow.Cells["WO_ID"].Value.ToString());
  551. list1.Add(uRow.Cells["ZY_PLAN_ID"].Value.ToString());
  552. list1.Add(uRow.Cells["JUDGE_STOVE_NO"].Value.ToString());
  553. list1.Add(uRow.Cells["BATCH_NO"].Value.ToString());
  554. list1.Add(this.UserInfo.GetUserName());
  555. list1.Add(this.UserInfo.GetUserOrder());
  556. list1.Add(this.UserInfo.GetUserGroup());
  557. list1.Add(cutGx);
  558. list1.Add(uRow.Cells["PIECES"].Value.ToString());
  559. list1.Add(uRow.Cells["RESULT_NO"].Value.ToString());
  560. list.Add(list1);
  561. }
  562. }
  563. if (addCount == 0) { MessageUtil.ShowTips("请选择要删除的交库信息!"); return; }
  564. if (MessageUtil.ShowYesNoAndQuestion("是否删除交库信息?") == DialogResult.No)
  565. {
  566. return;
  567. }
  568. CoreClientParam ccp = new CoreClientParam();
  569. try
  570. {
  571. this.Cursor = Cursors.WaitCursor; //控制鼠标的样式为等待
  572. if (Constant.WaitingForm == null)
  573. {
  574. Constant.WaitingForm = new WaitingForm();
  575. }
  576. Constant.WaitingForm.ShowToUser = true;
  577. Constant.WaitingForm.Show();
  578. Constant.WaitingForm.Update();
  579. ccp.ServerName = "com.steering.mes.mcp.coup.FrmInLibrary";
  580. ccp.MethodName = "deleteLibraryResult";
  581. ccp.ServerParams = new object[] { list };
  582. ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  583. this.Cursor = Cursors.Default;
  584. Constant.WaitingForm.ShowToUser = false;
  585. Constant.WaitingForm.Close();
  586. Constant.WaitingForm = null;
  587. }
  588. catch (Exception ex)
  589. {
  590. this.Cursor = Cursors.Default;
  591. Constant.WaitingForm.ShowToUser = false;
  592. Constant.WaitingForm.Close();
  593. Constant.WaitingForm = null;
  594. }
  595. if (ccp.ReturnCode == -1) return;
  596. MessageUtil.ShowTips(ccp.ReturnInfo);
  597. if (ccp.ReturnInfo.Equals("撤销交库成功!"))
  598. {
  599. QuerySinglePlan();
  600. }
  601. }
  602. /// <summary>
  603. /// 结炉
  604. /// </summary>
  605. private void DoBeside()
  606. {
  607. UltraGridRow uRow = this.ultraGrid1.ActiveRow;
  608. if (uRow == null)
  609. {
  610. MessageUtil.ShowTips("请选择需要结炉的工单号!");
  611. return;
  612. }
  613. int proNum = 0;
  614. string planNum = uRow.Cells["PLAN_JG_NUM"].Value.ToString();
  615. string inNum = uRow.Cells["SPRAY_COUNT"].Value.ToString();
  616. if (planNum == null || planNum.Equals(""))
  617. {
  618. planNum = "0";
  619. }
  620. if(inNum==null||inNum.Equals(""))
  621. {
  622. inNum = "0";
  623. }
  624. proNum = Convert.ToInt32(planNum);
  625. string zYgNo = uRow.Cells["ZY_PLAN_ID"].Value.ToString();
  626. string woId = uRow.Cells["WO_ID"].Value.ToString();
  627. ArrayList list = new ArrayList();
  628. list.Add(zYgNo);
  629. list.Add(woId);
  630. list.Add(cutGx);
  631. list.Add(proNum.ToString());
  632. if (MessageUtil.ShowYesNoAndQuestion("是否结炉?") == DialogResult.No)
  633. {
  634. return;
  635. }
  636. CoreClientParam ccp = new CoreClientParam();
  637. ccp.ServerName = "com.steering.mes.mcp.coup.FrmInLibrary";
  638. ccp.MethodName = "doBeside";
  639. ccp.ServerParams = new object[] { list };
  640. ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  641. if (ccp.ReturnCode != -1)
  642. {
  643. MessageUtil.ShowTips(ccp.ReturnInfo);
  644. if (ccp.ReturnInfo.Equals("结炉成功!"))
  645. {
  646. QuerySinglePlan();
  647. }
  648. }
  649. }
  650. /// <summary>
  651. /// 撤销结炉
  652. /// </summary>
  653. private void UndoBeside()
  654. {
  655. UltraGridRow uRow = this.ultraGrid1.ActiveRow;
  656. if (uRow == null)
  657. {
  658. MessageUtil.ShowTips("请选择需要撤销结炉的工单号!");
  659. return;
  660. }
  661. string zYgNo = uRow.Cells["ZY_PLAN_ID"].Value.ToString();
  662. string woId = uRow.Cells["WO_ID"].Value.ToString();
  663. ArrayList list = new ArrayList();
  664. list.Add(zYgNo);
  665. list.Add(woId);
  666. list.Add(cutGx);
  667. if (MessageUtil.ShowYesNoAndQuestion("是否撤销结炉?") == DialogResult.No)
  668. {
  669. return;
  670. }
  671. CoreClientParam ccp = new CoreClientParam();
  672. ccp.ServerName = "com.steering.mes.mcp.coup.FrmInLibrary";
  673. ccp.MethodName = "undoBeside";
  674. ccp.ServerParams = new object[] { list };
  675. ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  676. if (ccp.ReturnCode != -1)
  677. {
  678. MessageUtil.ShowTips(ccp.ReturnInfo);
  679. if (ccp.ReturnInfo.Equals("撤销结炉成功!"))
  680. {
  681. QuerySinglePlan();
  682. }
  683. }
  684. }
  685. private void chkStarts_CheckedChanged(object sender, EventArgs e)
  686. {
  687. if (chkJuNo.Checked) { txtJudgeStoveNO.Enabled = true; } else { txtJudgeStoveNO.Enabled = false; }
  688. if (chkPlnNo.Checked) { txtPlnNo.Enabled = true; } else { txtPlnNo.Enabled = false; }
  689. if (chkwoId.Checked) { txtWoId.Enabled = true; } else { txtWoId.Enabled = false; }
  690. }
  691. private void FrmInLibrary_Shown(object sender, EventArgs e)
  692. {
  693. if (toolMenu.Toolbars[0].Tools.Exists("DoQuery")) { toolMenu.Toolbars[0].Tools["DoQuery"].InstanceProps.Visible = DefaultableBoolean.True; }
  694. if (toolMenu.Toolbars[0].Tools.Exists("MatQuery")) { toolMenu.Toolbars[0].Tools["MatQuery"].InstanceProps.Visible = DefaultableBoolean.False; }
  695. if (toolMenu.Toolbars[0].Tools.Exists("DoSave")) { toolMenu.Toolbars[0].Tools["DoSave"].InstanceProps.Visible = DefaultableBoolean.True; }
  696. if (toolMenu.Toolbars[0].Tools.Exists("DoUpdate")) { toolMenu.Toolbars[0].Tools["DoUpdate"].InstanceProps.Visible = DefaultableBoolean.False; }
  697. if (toolMenu.Toolbars[0].Tools.Exists("DoDelete")) { toolMenu.Toolbars[0].Tools["DoDelete"].InstanceProps.Visible = DefaultableBoolean.True; }
  698. if (toolMenu.Toolbars[0].Tools.Exists("DoBeside")) { toolMenu.Toolbars[0].Tools["DoBeside"].InstanceProps.Visible = DefaultableBoolean.True; }
  699. if (toolMenu.Toolbars[0].Tools.Exists("UndoBeside")) { toolMenu.Toolbars[0].Tools["UndoBeside"].InstanceProps.Visible = DefaultableBoolean.True; }
  700. }
  701. private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
  702. {
  703. if (toolMenu == null) return;
  704. if (e.Tab.TabControl.SelectedTab.Key.Equals("0"))
  705. {
  706. if (toolMenu.Toolbars[0].Tools.Exists("DoQuery")) { toolMenu.Toolbars[0].Tools["DoQuery"].InstanceProps.Visible = DefaultableBoolean.True; }
  707. if (toolMenu.Toolbars[0].Tools.Exists("MatQuery")) { toolMenu.Toolbars[0].Tools["MatQuery"].InstanceProps.Visible = DefaultableBoolean.False; }
  708. if (toolMenu.Toolbars[0].Tools.Exists("DoSave")) { toolMenu.Toolbars[0].Tools["DoSave"].InstanceProps.Visible = DefaultableBoolean.True; }
  709. if (toolMenu.Toolbars[0].Tools.Exists("DoUpdate")) { toolMenu.Toolbars[0].Tools["DoUpdate"].InstanceProps.Visible = DefaultableBoolean.False; }
  710. if (toolMenu.Toolbars[0].Tools.Exists("DoDelete")) { toolMenu.Toolbars[0].Tools["DoDelete"].InstanceProps.Visible = DefaultableBoolean.True; }
  711. if (toolMenu.Toolbars[0].Tools.Exists("DoBeside")) { toolMenu.Toolbars[0].Tools["DoBeside"].InstanceProps.Visible = DefaultableBoolean.True; }
  712. if (toolMenu.Toolbars[0].Tools.Exists("UndoBeside")) { toolMenu.Toolbars[0].Tools["UndoBeside"].InstanceProps.Visible = DefaultableBoolean.True; }
  713. }
  714. else
  715. {
  716. if (toolMenu.Toolbars[0].Tools.Exists("DoQuery")) { toolMenu.Toolbars[0].Tools["DoQuery"].InstanceProps.Visible = DefaultableBoolean.False; }
  717. if (toolMenu.Toolbars[0].Tools.Exists("MatQuery")) { toolMenu.Toolbars[0].Tools["MatQuery"].InstanceProps.Visible = DefaultableBoolean.True; }
  718. if (toolMenu.Toolbars[0].Tools.Exists("DoSave")) { toolMenu.Toolbars[0].Tools["DoSave"].InstanceProps.Visible = DefaultableBoolean.False; }
  719. if (toolMenu.Toolbars[0].Tools.Exists("DoUpdate")) { toolMenu.Toolbars[0].Tools["DoUpdate"].InstanceProps.Visible = DefaultableBoolean.True; }
  720. if (toolMenu.Toolbars[0].Tools.Exists("DoDelete")) { toolMenu.Toolbars[0].Tools["DoDelete"].InstanceProps.Visible = DefaultableBoolean.False; }
  721. if (toolMenu.Toolbars[0].Tools.Exists("DoBeside")) { toolMenu.Toolbars[0].Tools["DoBeside"].InstanceProps.Visible = DefaultableBoolean.False; }
  722. if (toolMenu.Toolbars[0].Tools.Exists("UndoBeside")) { toolMenu.Toolbars[0].Tools["UndoBeside"].InstanceProps.Visible = DefaultableBoolean.False; }
  723. }
  724. }
  725. private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
  726. {
  727. string woid = "";
  728. string orderAll = "";
  729. UltraGridRow urg = ultraGrid1.ActiveRow;
  730. if (urg != null)
  731. {
  732. woid = urg.Cells["WO_ID"].Text.ToString();
  733. orderAll = urg.Cells["JG_ORDERNO_ALL"].Text.ToString();
  734. // urg.Cells["SJ_NUM1"].Value = urg.Cells["SJ_NUM"].Text.ToString();
  735. }
  736. if (urg.Cells["SPRAY_COUNT"].Text.ToString().Trim() == "")
  737. {
  738. urg.Cells["SPRAY_COUNT"].Value = "0";
  739. }
  740. DataTable dt1 = ServerHelper.GetData("com.steering.mes.mcp.coup.FrmInLibrary.doQueryMatNo", new object[] { woid, urg.Cells["PLINE_CODE"].Text.ToString() }, this.ob);
  741. GridHelper.CopyDataToDatatable(ref dt1, ref dataTable2, true);
  742. if(dt1.Rows.Count>0)
  743. {
  744. urg.Cells["SPRAY_COUNT"].Value = dt1.Rows[0]["PIECES"].ToString();
  745. //urg.Cells["SJ_NUM1"].Value = double.Parse(urg.Cells["SJ_NUM"].Value.ToString()) - double.Parse(urg.Cells["SPRAY_COUNT"].Value.ToString());
  746. }
  747. string jgOrder = "";
  748. List<PlnOrderJgEntity> listSource = EntityHelper.GetData<PlnOrderJgEntity>(
  749. "com.steering.mes.mcp.coup.FrmInLibrary.QueryPlnOrderJg", new object[] { orderAll }, this.ob);
  750. PlnOrderJgbindingSource.DataSource = listSource;
  751. }
  752. }
  753. }