FrmProcessBasics.cs 28 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764
  1. using Core.Mes.Client.Comm;
  2. using Core.Mes.Client.Comm.Control;
  3. using Core.Mes.Client.Comm.Server;
  4. using Core.Mes.Client.Comm.Tool;
  5. using CoreFS.CA06;
  6. using Infragistics.Win.UltraWinGrid;
  7. using System;
  8. using System.Collections;
  9. using System.Data;
  10. using System.Drawing;
  11. using System.Windows.Forms;
  12. namespace Core.StlMes.Client.Qcm
  13. {
  14. public partial class FrmProcessBasics : FrmBase
  15. {
  16. public FrmProcessBasics()
  17. {
  18. InitializeComponent();
  19. ExceptionHelper.RegistException();
  20. }
  21. private void FrmProcessBasics_Load(object sender, EventArgs e)
  22. {
  23. LoadProcess1Data();
  24. LoadProcessStyle();
  25. }
  26. private void LoadProcess1Data()
  27. {
  28. DataTable dt = ServerHelper.GetData("com.steering.pss.qcm.CoreProcessBasics.loadProcess1Data",
  29. new object[] { }, ob);
  30. cmbProcess1.DataSource = dt;
  31. cmbProcess1.DisplayMember = "PROCESS_DESC";
  32. cmbProcess1.ValueMember = "PROCESS_CODE";
  33. }
  34. private void LoadProcessStyle()
  35. {
  36. DataTable dt = ServerHelper.GetData("com.steering.pss.qcm.CoreProcessBasics.loadProcessStyle",
  37. new object[] { }, ob);
  38. ultraComboEditor1.DataSource = dt;
  39. ultraComboEditor1.DisplayMember = "BASENAME";
  40. ultraComboEditor1.ValueMember = "BASECODE";
  41. }
  42. /// <summary>
  43. /// 重写基类方法
  44. /// </summary>
  45. /// <param name="sender"></param>
  46. /// <param name="ToolbarKey"></param>
  47. public override void ToolBar_Click(object sender, string ToolbarKey)
  48. {
  49. switch (ToolbarKey)
  50. {
  51. case "doQuery":
  52. if (ultraTabControl1.SelectedTab.Key == "PROCESS1")
  53. {
  54. doQuery();
  55. }
  56. else
  57. {
  58. QueryProcess2Data();
  59. }
  60. break;
  61. case "doAdd":
  62. if (ultraTabControl1.SelectedTab.Key == "PROCESS1")
  63. {
  64. doAdd();
  65. }
  66. else
  67. {
  68. InsertProcess2Data();
  69. }
  70. break;
  71. case "doModify":
  72. if (ultraTabControl1.SelectedTab.Key == "PROCESS1")
  73. {
  74. doModify();
  75. }
  76. else
  77. {
  78. UpdateProcess2();
  79. }
  80. break;
  81. case "doDelete":
  82. if (ultraTabControl1.SelectedTab.Key == "PROCESS1")
  83. {
  84. this.doDeleteOrResume(true);
  85. }
  86. else
  87. {
  88. DeleteOrResumeProcess2(true);
  89. }
  90. break;
  91. case "doResume":
  92. if (ultraTabControl1.SelectedTab.Key == "PROCESS1")
  93. {
  94. this.doDeleteOrResume(false);
  95. }
  96. else
  97. {
  98. DeleteOrResumeProcess2(false);
  99. }
  100. break;
  101. case "Export":
  102. if (ultraTabControl1.SelectedTab.Key == "PROCESS1")
  103. {
  104. Export();
  105. }
  106. else
  107. {
  108. Export2();
  109. }
  110. break;
  111. case "Refresh":
  112. LoadProcess1Data();
  113. LoadProcessStyle();
  114. break;
  115. case "Close":
  116. this.Close();
  117. break;
  118. }
  119. }
  120. private void Export()
  121. {
  122. GridHelper.ulGridToExcel(ultraGrid2, "一级工序");
  123. }
  124. private void Export2()
  125. {
  126. GridHelper.ulGridToExcel(ultraGrid1, "二级级工序");
  127. }
  128. private void QueryProcess2Data()
  129. {
  130. ArrayList list = new ArrayList();
  131. list.Add(chkValid.Checked ? "0" : "");
  132. list.Add(txtTitleName.Text.Trim());
  133. DataTable dt = ServerHelper.GetData("com.steering.pss.qcm.CoreProcessBasics.queryProcess2Data",
  134. new object[] { list }, ob);
  135. GridHelper.CopyDataToDatatable(ref dt, ref dataTable3, true);
  136. GridHelper.RefreshAndAutoSize(ultraGrid1);
  137. }
  138. private string GetMaxProcess2Code()
  139. {
  140. DataTable dt = null;
  141. try
  142. {
  143. dt = ServerHelper.GetData("com.steering.pss.qcm.CoreProcessBasics.getMaxProcess2Code",
  144. new object[] { }, ob);
  145. }
  146. catch
  147. {
  148. }
  149. string maxCode = "";
  150. if (dt == null)
  151. {
  152. return "B001";
  153. }
  154. else
  155. {
  156. if (dt.Rows[0][0].ToString() == "")
  157. {
  158. return "B001";
  159. }
  160. else
  161. {
  162. int intMaxCode = int.Parse(dt.Rows[0][0].ToString().Substring(1)) + 1;
  163. maxCode = dt.Rows[0][0].ToString().Substring(0, 1) + intMaxCode.ToString().PadLeft(3, '0');
  164. return maxCode;
  165. }
  166. }
  167. }
  168. private void InsertProcess2Data()
  169. {
  170. string process_Code_C = GetMaxProcess2Code();
  171. if (ValidInput2(process_Code_C, txtProcess2.Text.Trim()) == false)
  172. {
  173. return;
  174. }
  175. if (MessageUtil.ShowYesNoAndQuestion("是否确认新增数据?") == DialogResult.No)
  176. {
  177. return;
  178. }
  179. ArrayList list = new ArrayList();
  180. list.Add(process_Code_C);
  181. list.Add(txtProcess2.Text.Trim());
  182. list.Add(cmbProcess1.SelectedValue.ToString());
  183. list.Add(cmbProcess1.Text.Trim());
  184. string process2Id = numSequence1.Text + numSequence2.Value.ToString().PadLeft(2, '0');
  185. list.Add(process2Id);
  186. list.Add(UserInfo.GetUserName());
  187. list.Add(txtMemo2.Text.Trim());
  188. list.Add(ultraComboEditor1.Value.ToString());
  189. list.Add(ultraNumericEditor10.Value.ToString2());
  190. list.Add(ultraNumericEditor7.Value.ToString2());
  191. list.Add(ultraNumericEditor8.Value.ToString2());
  192. list.Add(ultraNumericEditor9.Value.ToString2());
  193. list.Add(ultraNumericEditor6.Value.ToString2());
  194. list.Add(ultraNumericEditor5.Value.ToString2());
  195. ServerHelper.SetData("com.steering.pss.qcm.CoreProcessBasics.insertProcess2Data",
  196. new object[] { list }, ob);
  197. MessageUtil.ShowTips("新增数据成功!");
  198. QueryProcess2Data();
  199. MoveToSelectedRow2(process_Code_C);
  200. }
  201. private bool ValidInput2(string process_Code_C, string process_Desc_C)
  202. {
  203. if (cmbProcess1.SelectedValue == null)
  204. {
  205. MessageUtil.ShowWarning("请选择以及工序!");
  206. cmbProcess1.Focus();
  207. return false;
  208. }
  209. if (txtProcess2.Text.Trim() == "")
  210. {
  211. MessageUtil.ShowWarning("请输入二级工序!");
  212. txtProcess2.Focus();
  213. return false;
  214. }
  215. else if (IsExistProcess2(process_Code_C, process_Desc_C))
  216. {
  217. MessageUtil.ShowWarning("系统已经存在该二级工序-[" + process_Desc_C + "]!");
  218. txtProcess2.Focus();
  219. return false;
  220. }
  221. string process2Id = numSequence1.Text + numSequence2.Value.ToString();
  222. if (numSequence2.Value.ToString() == "")
  223. {
  224. MessageUtil.ShowWarning("请输入顺序号");
  225. numSequence2.Focus();
  226. return false;
  227. }
  228. else
  229. {
  230. if (process2Id != ultraGrid1.GetActiveRowValue("PROCESS_ID_C") && IsExistProcess2Id(process2Id))
  231. {
  232. MessageUtil.ShowWarning("系统已经存在该工序顺序号-[" + process2Id + "]!");
  233. numSequence2.Focus();
  234. return false;
  235. }
  236. }
  237. if (ultraComboEditor1.SelectedItem == null)
  238. {
  239. MessageUtil.ShowWarning("选择二级工序分类");
  240. ultraComboEditor1.Focus();
  241. return false;
  242. }
  243. return true;
  244. }
  245. private bool IsExistProcess2(string process_Code_C, string process_Desc_C)
  246. {
  247. try
  248. {
  249. DataTable dt = ServerHelper.GetData("com.steering.pss.qcm.CoreProcessBasics.isExistProcess2",
  250. new object[] { process_Code_C, process_Desc_C }, ob);
  251. if (dt != null && dt.Rows[0][0].ToString() != "0")
  252. {
  253. return true;
  254. }
  255. }
  256. catch { };
  257. return false;
  258. }
  259. private bool IsExistProcess1(string process_Code, string process_Desc)
  260. {
  261. try
  262. {
  263. DataTable dt = ServerHelper.GetData("com.steering.pss.qcm.CoreProcessBasics.isExistProcess1",
  264. new object[] { process_Code, process_Desc }, ob);
  265. if (dt != null && dt.Rows[0][0].ToString() != "0")
  266. {
  267. return true;
  268. }
  269. }
  270. catch { };
  271. return false;
  272. }
  273. private bool IsExistProcess2Id(string process2Id)
  274. {
  275. ArrayList list = new ArrayList();
  276. list.Add(process2Id);
  277. try
  278. {
  279. DataTable dt = ServerHelper.GetData("com.steering.pss.qcm.CoreProcessBasics.isExistProcess2Id",
  280. new object[] { list }, ob);
  281. if (dt != null && dt.Rows[0][0].ToString() != "0")
  282. {
  283. return true;
  284. }
  285. }
  286. catch { };
  287. return false;
  288. }
  289. private void UpdateProcess2()
  290. {
  291. if (ultraGrid1.ActiveRow == null)
  292. {
  293. MessageBox.Show("请选择一条记录后再修改!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
  294. return;
  295. }
  296. string process_Code_C = ultraGrid1.ActiveRow.Cells["PROCESS_CDOE_C"].Value.ToString();
  297. if (ValidInput2(process_Code_C, txtProcess2.Text.Trim()) == false)
  298. {
  299. return;
  300. }
  301. if (MessageUtil.ShowYesNoAndQuestion("是否确认修改选择的数据?") == DialogResult.No)
  302. {
  303. return;
  304. }
  305. ArrayList list = new ArrayList();
  306. list.Add(txtProcess2.Text.Trim());
  307. list.Add(cmbProcess1.SelectedValue.ToString());
  308. list.Add(cmbProcess1.Text.Trim());
  309. string process2Id = numSequence1.Text + numSequence2.Value.ToString().PadLeft(2, '0');
  310. list.Add(process2Id);
  311. list.Add(UserInfo.GetUserName());
  312. list.Add(txtMemo2.Text.Trim());
  313. list.Add(ultraComboEditor1.Value.ToString());
  314. list.Add(ultraNumericEditor10.Value.ToString2());
  315. list.Add(ultraNumericEditor7.Value.ToString2());
  316. list.Add(ultraNumericEditor8.Value.ToString2());
  317. list.Add(ultraNumericEditor9.Value.ToString2());
  318. list.Add(ultraNumericEditor6.Value.ToString2());
  319. list.Add(ultraNumericEditor5.Value.ToString2());
  320. list.Add(process_Code_C);
  321. try
  322. {
  323. ServerHelper.SetData("com.steering.pss.qcm.CoreProcessBasics.updateProcess2",
  324. new object[] { list }, ob);
  325. }
  326. catch (MESException ex)
  327. {
  328. return;
  329. }
  330. MessageUtil.ShowTips("修改数据成功!");
  331. QueryProcess2Data();
  332. MoveToSelectedRow2(process_Code_C);
  333. }
  334. private void MoveToSelectedRow2(string process_Code_C)
  335. {
  336. UltraGridRow[] rows = GridHelper.GetRowsWithKey(ultraGrid1,
  337. new string[] { "PROCESS_CDOE_C" }, new string[] { process_Code_C });
  338. if (rows.Length > 0)
  339. {
  340. rows[0].Activate();
  341. }
  342. }
  343. /// <summary>
  344. /// 检验非空项
  345. /// </summary>
  346. /// <returns></returns>
  347. private bool ValidInput(string process_Code, string process_Desc)
  348. {
  349. if (string.IsNullOrEmpty(txtName.Text.Trim()))
  350. {
  351. MessageUtil.ShowWarning("请输入工序描述!");
  352. txtName.Focus();
  353. return false;
  354. }
  355. else if (IsExistProcess1(process_Code, process_Desc))
  356. {
  357. MessageUtil.ShowWarning("系统已存在该工序描述-[" + process_Desc + "]!");
  358. txtName.Focus();
  359. return false;
  360. }
  361. if (numMinute_Product.Value == null || numMinute_Product.Text == "")
  362. {
  363. MessageUtil.ShowWarning("请输入生产时间-自炼!");
  364. numMinute_Product.Focus();
  365. return false;
  366. }
  367. if (numMinute_Waite.Value == null || numMinute_Waite.Text == "")
  368. {
  369. MessageUtil.ShowWarning("请输入等待时间-自炼!");
  370. numMinute_Waite.Focus();
  371. return false;
  372. }
  373. if (ultraNumericEditor1.Value == null || ultraNumericEditor1.Text == "")
  374. {
  375. MessageUtil.ShowWarning("请输入生产时间-外购!");
  376. ultraNumericEditor1.Focus();
  377. return false;
  378. }
  379. if (ultraNumericEditor2.Value == null || ultraNumericEditor2.Text == "")
  380. {
  381. MessageUtil.ShowWarning("请输入等待时间-外购!");
  382. ultraNumericEditor2.Focus();
  383. return false;
  384. }
  385. if (ultraNumericEditor3.Value == null || ultraNumericEditor3.Text == "")
  386. {
  387. MessageUtil.ShowWarning("请输入批量等待时间-自炼!");
  388. ultraNumericEditor3.Focus();
  389. return false;
  390. }
  391. if (ultraNumericEditor4.Value == null || ultraNumericEditor4.Text == "")
  392. {
  393. MessageUtil.ShowWarning("请输入批量等待时间-外购!");
  394. ultraNumericEditor4.Focus();
  395. return false;
  396. }
  397. if (numICount.Value.ToString() == "")
  398. {
  399. MessageUtil.ShowWarning("请输入工序循环次数!");
  400. numICount.Focus();
  401. return false;
  402. }
  403. return true;
  404. }
  405. /// <summary>
  406. /// 新增
  407. /// </summary>
  408. private void doAdd()
  409. {
  410. string modelCode = GetMaxProcess1Code();
  411. if (ValidInput(modelCode, txtName.Text.Trim()))
  412. {
  413. if (MessageUtil.ShowYesNoAndQuestion("是否确认新增数据?") == DialogResult.No)
  414. {
  415. return;
  416. }
  417. try
  418. {
  419. ArrayList parm = new ArrayList();
  420. if (modelCode.ToCharArray()[0] > 'Z')
  421. {
  422. MessageUtil.ShowError("已超出一级工序代码范围(A-Z), 新增失败!");
  423. return;
  424. }
  425. parm.Add(modelCode);
  426. parm.Add(txtName.Text.Trim());
  427. parm.Add("A");
  428. parm.Add(numProcess_Id.Value == null ? "0" : numProcess_Id.Value.ToString());
  429. parm.Add(cmbCOST.Value == null ? "0" : cmbCOST.Value.ToString());
  430. parm.Add(numMinute_Product.Value.ToString());
  431. parm.Add(numMinute_Waite.Value.ToString());
  432. parm.Add(numICount.Value.ToString());
  433. parm.Add(this.UserInfo.GetUserName());
  434. parm.Add(txtMemo.Text.Trim());
  435. parm.Add(ultraNumericEditor1.Value.ToString());
  436. parm.Add(ultraNumericEditor2.Value.ToString());
  437. parm.Add(ultraNumericEditor3.Value.ToString());
  438. parm.Add(ultraNumericEditor4.Value.ToString());
  439. ServerHelper.SetData("com.steering.pss.qcm.CoreProcessBasics.doAdd",
  440. new object[] { parm }, ob);
  441. doQuery();
  442. MoveToSelectedRow(modelCode);
  443. }
  444. catch
  445. {
  446. return;
  447. }
  448. MessageUtil.ShowTips("新增数据成功!");
  449. LoadProcess1Data();
  450. }
  451. }
  452. private string GetMaxProcess1Code()
  453. {
  454. DataTable dt = ServerHelper.GetData("com.steering.pss.qcm.CoreProcessBasics.getMaxProcess1Code",
  455. new object[] { }, ob);
  456. if (dt == null)
  457. {
  458. return "A";
  459. }
  460. else if (dt != null)
  461. {
  462. if (dt.Rows[0][0].ToString() == "")
  463. {
  464. return "A";
  465. }
  466. else
  467. {
  468. string maxCode = dt.Rows[0][0].ToString();
  469. maxCode = ((char)((int)maxCode.ToCharArray()[0] + 1)).ToString();
  470. return maxCode;
  471. }
  472. }
  473. return "A";
  474. }
  475. private void MoveToSelectedRow(string modelCode)
  476. {
  477. UltraGridRow row = null;
  478. for (int i = 0; i < ultraGrid2.Rows.Count; i++)
  479. {
  480. row = ultraGrid2.Rows[i];
  481. if (row.Cells["PROCESS_CODE"].Value.ToString().Equals(modelCode))
  482. {
  483. row.Activate();
  484. break;
  485. }
  486. }
  487. }
  488. /// <summary>
  489. /// 修改
  490. /// </summary>
  491. private void doModify()
  492. {
  493. if (ultraGrid2.ActiveRow == null)
  494. {
  495. MessageUtil.ShowWarning("请选择需要修改的数据!");
  496. return;
  497. }
  498. string modelCode = ultraGrid2.ActiveRow.Cells["PROCESS_CODE"].Value.ToString();
  499. if (ValidInput(modelCode, txtName.Text.Trim()))
  500. {
  501. //确认修改吗?
  502. if (MessageUtil.ShowYesNoAndQuestion("是否修改选中的数据?") == DialogResult.No)
  503. {
  504. return;
  505. }
  506. ArrayList parm = new ArrayList();
  507. parm.Add(txtName.Text.Trim());
  508. parm.Add("A");
  509. parm.Add(numProcess_Id.Value == null ? "0" : numProcess_Id.Value.ToString());
  510. parm.Add(cmbCOST.Value == null ? "0" : cmbCOST.Value.ToString());
  511. parm.Add(numMinute_Product.Value == null ? "0" : numMinute_Product.Value.ToString());
  512. parm.Add(numMinute_Waite.Value == null ? "0" : numMinute_Waite.Value.ToString());
  513. parm.Add(numICount.Value == null ? "0" : numICount.Value.ToString());
  514. parm.Add(this.UserInfo.GetUserName());
  515. parm.Add(txtMemo.Text.Trim());
  516. parm.Add(ultraNumericEditor1.Value.ToString());
  517. parm.Add(ultraNumericEditor2.Value.ToString());
  518. parm.Add(ultraNumericEditor3.Value.ToString());
  519. parm.Add(ultraNumericEditor4.Value.ToString());
  520. parm.Add(modelCode);
  521. try
  522. {
  523. ServerHelper.SetData("com.steering.pss.qcm.CoreProcessBasics.doModify",
  524. new object[] { parm }, ob);
  525. }
  526. catch
  527. {
  528. return;
  529. }
  530. MessageUtil.ShowTips("修改数据成功!");
  531. doQuery();
  532. MoveToSelectedRow(modelCode);
  533. LoadProcess1Data();
  534. }
  535. }
  536. /// <summary>
  537. /// 查询
  538. /// </summary>
  539. private void doQuery()
  540. {
  541. bool validFlag = chkValid.Checked;
  542. string titleName = txtTitleName.Text.Trim();
  543. DataTable dt = null;
  544. try
  545. {
  546. dt = ServerHelper.GetData("com.steering.pss.qcm.CoreProcessBasics.getLineList", new Object[] { validFlag, titleName }, this.ob);
  547. }
  548. catch
  549. {
  550. return;
  551. }
  552. GridHelper.CopyDataToDatatable(ref dt, ref this.dataTable1, true);
  553. UltraGridColumn[] col = new UltraGridColumn[] { ultraGrid2.DisplayLayout.Bands[0].Columns["MINUTE_PRODUCT"],
  554. ultraGrid2.DisplayLayout.Bands[0].Columns["MINUTE_WAITE"],ultraGrid2.DisplayLayout.Bands[0].Columns["MINUTE_PRODUCT_OUT"],
  555. ultraGrid2.DisplayLayout.Bands[0].Columns["MINUTE_WAITE_OUT"],ultraGrid2.DisplayLayout.Bands[0].Columns["BATCH_WAITE"],
  556. ultraGrid2.DisplayLayout.Bands[0].Columns["BATCH_WAITE_OUT"]};
  557. GridHelper.RefreshAndAutoSizeExceptColumns(ultraGrid2, col);
  558. }
  559. /// <summary>
  560. /// GRID ROW激活时信息带至编辑区
  561. /// </summary>
  562. /// <param name="sender"></param>
  563. /// <param name="e"></param>
  564. private void ultraGrid2_AfterRowActivate(object sender, EventArgs e)
  565. {
  566. Infragistics.Win.UltraWinGrid.UltraGridRow row = ultraGrid2.ActiveRow;
  567. if (row != null)
  568. {
  569. txtName.Text = row.Cells["PROCESS_DESC"].Value.ToString();
  570. cmbCOST.Value = row.Cells["COST"].Value == DBNull.Value ? 0 : decimal.Parse(row.Cells["COST"].Value.ToString());
  571. numMinute_Product.Value = row.Cells["MINUTE_PRODUCT"].Value.ToString();
  572. numMinute_Waite.Value = row.Cells["MINUTE_WAITE"].Value.ToString();
  573. numICount.Value = int.Parse(row.Cells["ICOUNT"].Value.ToString());
  574. numProcess_Id.Value = row.Cells["PROCESS_ID"].Value == null ? 0 : int.Parse(row.Cells["PROCESS_ID"].Value.ToString());
  575. txtMemo.Text = row.Cells["MEMO"].Value.ToString();
  576. ultraNumericEditor1.Value = row.Cells["MINUTE_PRODUCT_OUT"].Value.ToString();
  577. ultraNumericEditor2.Value = row.Cells["MINUTE_WAITE_OUT"].Value.ToString();
  578. ultraNumericEditor3.Value = row.Cells["BATCH_WAITE"].Value.ToString();
  579. ultraNumericEditor4.Value = row.Cells["BATCH_WAITE_OUT"].Value.ToString();
  580. }
  581. }
  582. /// <summary>
  583. /// 删除或恢复
  584. /// </summary>
  585. /// <param name="isDelete">true删除 false恢复</param>
  586. private void doDeleteOrResume(bool isDelete)
  587. {
  588. if (ultraGrid2.ActiveRow == null)
  589. {
  590. MessageUtil.ShowWarning("请选择需要" + (isDelete ? "作废" : "恢复") + "的数据!");
  591. return;
  592. }
  593. ArrayList param = new ArrayList();
  594. string processCode = ultraGrid2.ActiveRow.Cells["PROCESS_CODE"].Value.ToString();
  595. param.Add(processCode);
  596. if (param.Count > 0 && MessageBox.Show("是否确认" + (isDelete ? "作废" : "恢复") + "选择的数据?", "提示",
  597. MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes)
  598. {
  599. try
  600. {
  601. int count = ServerHelper.SetData("com.steering.pss.qcm.CoreProcessBasics.deleteLineInfo", new Object[] { param, UserInfo.GetUserName(), isDelete }, this.ob);
  602. if (count > 0)
  603. {
  604. doQuery();
  605. MoveToSelectedRow(processCode);
  606. }
  607. }
  608. catch
  609. {
  610. }
  611. MessageUtil.ShowTips((isDelete ? "作废" : "恢复") + "数据成功!");
  612. }
  613. }
  614. private void DeleteOrResumeProcess2(bool isDelete)
  615. {
  616. if (ultraGrid1.ActiveRow == null)
  617. {
  618. MessageBox.Show("请选择需要" + (isDelete ? "作废" : "恢复") + "的数据!", "提示",
  619. MessageBoxButtons.OK, MessageBoxIcon.Warning);
  620. return;
  621. }
  622. if (MessageUtil.ShowYesNoAndQuestion("是否确定" + (isDelete ? "作废" : "恢复") + "选择的数据?")
  623. == DialogResult.No)
  624. {
  625. return;
  626. }
  627. string process_Code_C = ultraGrid1.ActiveRow.Cells["PROCESS_CDOE_C"].Value.ToString();
  628. ArrayList list = new ArrayList();
  629. list.Add(isDelete ? "0" : "1");
  630. list.Add(UserInfo.GetUserName());
  631. list.Add(process_Code_C);
  632. try
  633. {
  634. ServerHelper.SetData("com.steering.pss.qcm.CoreProcessBasics.deleteOrResumeProcess2",
  635. new object[] { list }, ob);
  636. }
  637. catch
  638. {
  639. return;
  640. }
  641. MessageUtil.ShowTips((isDelete ? "作废" : "恢复") + "数据成功!");
  642. QueryProcess2Data();
  643. MoveToSelectedRow2(process_Code_C);
  644. }
  645. private void ultraGrid2_InitializeRow(object sender, InitializeRowEventArgs e)
  646. {
  647. if (e.Row.Cells["VALIDFLAG"].Value.ToString() == "0")
  648. {
  649. e.Row.Appearance.ForeColor = Color.Red;
  650. }
  651. else
  652. {
  653. e.Row.Appearance.ForeColor = Color.Black;
  654. }
  655. }
  656. private void ultraGrid1_InitializeRow(object sender, InitializeRowEventArgs e)
  657. {
  658. if (e.Row.Cells["VALIDFLAG"].Value.ToString() == "0")
  659. {
  660. e.Row.Appearance.ForeColor = Color.Red;
  661. }
  662. else
  663. {
  664. e.Row.Appearance.ForeColor = Color.Black;
  665. }
  666. }
  667. private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
  668. {
  669. if (ultraGrid1.ActiveRow == null)
  670. return;
  671. cmbProcess1.SelectedValue = ultraGrid1.ActiveRow.Cells["PROCESS_CDOE"].Value.ToString();
  672. txtProcess2.Text = ultraGrid1.ActiveRow.Cells["PROCESS_DESC_C"].Value.ToString();
  673. txtMemo2.Text = ultraGrid1.ActiveRow.Cells["MEMO"].Value.ToString();
  674. string processId = ultraGrid1.GetActiveRowValue("PROCESS_ID_C");
  675. numSequence2.Value = processId == "" ? "0" : processId.Substring(1, processId.Length - 1);
  676. ultraComboEditor1.Text = ultraGrid1.ActiveRow.Cells["PROCESS_STYLE"].Value.ToString();
  677. ultraNumericEditor10.Value = ultraGrid1.GetActiveRowValue("MINUTE_PRODUCT");
  678. ultraNumericEditor7.Value = ultraGrid1.GetActiveRowValue("MINUTE_WAITE");
  679. ultraNumericEditor8.Value = ultraGrid1.GetActiveRowValue("BATCH_WAITE");
  680. ultraNumericEditor9.Value = ultraGrid1.GetActiveRowValue("MINUTE_PRODUCT_OUT");
  681. ultraNumericEditor6.Value = ultraGrid1.GetActiveRowValue("MINUTE_WAITE_OUT");
  682. ultraNumericEditor5.Value = ultraGrid1.GetActiveRowValue("BATCH_WAITE_OUT");
  683. }
  684. private void cmbProcess1_SelectedIndexChanged(object sender, EventArgs e)
  685. {
  686. }
  687. private void cmbProcess1_SelectedValueChanged(object sender, EventArgs e)
  688. {
  689. if (cmbProcess1.SelectedItem != null)
  690. {
  691. numSequence1.Text = cmbProcess1.SelectedValue.ToString();
  692. //if (cmbProcess1.SelectedValue.ToString() == "F")
  693. //{
  694. // ultraLabel2.Visible = true;
  695. // ultraComboEditor1.Visible = true;
  696. //}
  697. //else
  698. //{
  699. // ultraLabel2.Visible = false;
  700. // ultraComboEditor1.Visible = false;
  701. //}
  702. }
  703. }
  704. }
  705. }