FrmComBaseProcessRStation.cs 6.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163
  1. using Core.Mes.Client.Comm.Control;
  2. using Core.Mes.Client.Comm.Server;
  3. using CoreFS.CA06;
  4. using Infragistics.Win.UltraWinGrid;
  5. using System;
  6. using System.Collections;
  7. using System.Data;
  8. using System.Windows.Forms;
  9. namespace Core.StlMes.Client.Qcm
  10. {
  11. public partial class FrmComBaseProcessRStation : FrmBase
  12. {
  13. public FrmComBaseProcessRStation()
  14. {
  15. InitializeComponent();
  16. }
  17. int isselect = 0;
  18. public override void ToolBar_Click(object sender, string ToolbarKey)
  19. {
  20. switch (ToolbarKey)
  21. {
  22. case "Query":
  23. InitGrid1();
  24. break;
  25. case "Save":
  26. DoSave();
  27. break;
  28. case "Close":
  29. this.Close();
  30. break;
  31. }
  32. }
  33. private void InitGrid1()
  34. {
  35. DataTable dt = ServerHelper.GetData("com.steering.pss.qcm.CoreComBaseProcessRStation.queryProcess", null, this.ob);
  36. GridHelper.CopyDataToDatatable(ref dt, ref dataTable1, true);
  37. isselect = 0;
  38. }
  39. private void SetGridNoEdit(UltraGrid ug)
  40. {
  41. ug.UpdateData();
  42. foreach (UltraGridRow row in ug.Rows)
  43. {
  44. for (int i = 0; i < row.Cells.Count; i++)
  45. {
  46. if (!row.Cells[i].Column.Key.Equals("CHK") && !row.Cells[i].Column.Key.Equals("MEMO"))
  47. row.Cells[i].Activation = Activation.ActivateOnly;
  48. }
  49. }
  50. }
  51. private void FrmComBaseProcessRStation_Load(object sender, EventArgs e)
  52. {
  53. InitGrid1();
  54. }
  55. private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
  56. {
  57. UltraGridRow ugr = ultraGrid1.ActiveRow;
  58. if (ugr == null)
  59. return;
  60. string processcode = ugr.Cells["PROCESS_CDOE"].Value.ToString(); //工序代码
  61. string processcodec = ugr.Cells["PROCESS_CDOE_C"].Value.ToString(); //二级工序代码
  62. QueryStation(processcode, processcodec);
  63. }
  64. private void QueryStation(string code, string codec)
  65. {
  66. DataTable dt = ServerHelper.GetData("com.steering.pss.qcm.CoreComBaseProcessRStation.queryStation", new Object[] { code, codec }, this.ob);
  67. GridHelper.CopyDataToDatatable(ref dt, ref dataTable2, true);
  68. SetGridNoEdit(ultraGrid2);
  69. }
  70. private void DoSave()
  71. {
  72. ultraGrid2.UpdateData();
  73. if (isselect == 0)
  74. {
  75. MessageBox.Show("您没有做任何的修改!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
  76. return;
  77. }
  78. if (MessageBox.Show("是否确认保存修改?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
  79. {
  80. return;
  81. }
  82. UltraGridRow ugr1 = this.ultraGrid1.ActiveRow;
  83. ArrayList list = new ArrayList();
  84. string processcode = ugr1.Cells["PROCESS_CDOE"].Value.ToString();
  85. string processcodec = ugr1.Cells["PROCESS_CDOE_C"].Value.ToString();
  86. foreach (UltraGridRow row in ultraGrid2.Rows)
  87. {
  88. if (Convert.ToBoolean(row.Cells["CHK"].Value))
  89. {
  90. ArrayList parm = new ArrayList();
  91. string choose = "";
  92. if (row.Cells["CHOOSE"].Value.ToString().ToUpper() == "TRUE")
  93. choose = "1";
  94. else
  95. choose = "0";
  96. string returnresult = "";
  97. if (row.Cells["RETURN_RESULT"].Value.ToString().ToUpper() == "TRUE")
  98. returnresult = "1";
  99. else
  100. returnresult = "0";
  101. string sendplan = "";
  102. if (row.Cells["SEND_CHECKPLAN"].Value.ToString().ToUpper() == "TRUE")
  103. sendplan = "1";
  104. else
  105. sendplan = "0";
  106. parm.Add(row.Cells["STATION_CODE"].Value.ToString());
  107. parm.Add(row.Cells["STATION_DESC"].Value.ToString());
  108. parm.Add(row.Cells["STATION_TYPE"].Value.ToString());
  109. parm.Add(row.Cells["STATION_ID"].Value.ToString());
  110. parm.Add(processcode);
  111. parm.Add(ugr1.Cells["PROCESS_DESC"].Value.ToString());
  112. parm.Add(processcodec);
  113. parm.Add(ugr1.Cells["PROCESS_DESC_C"].Value.ToString());
  114. parm.Add(row.Cells["COST"].Value.ToString());
  115. parm.Add(choose);
  116. parm.Add(returnresult);
  117. parm.Add(sendplan);
  118. parm.Add(row.Cells["MONITOR_LV"].Value.ToString());
  119. parm.Add(row.Cells["MONITOR_LV2"].Value.ToString());
  120. parm.Add(this.UserInfo.GetUserName());
  121. parm.Add(row.Cells["MEMO"].Value.ToString());
  122. list.Add(parm);
  123. }
  124. }
  125. int count = ServerHelper.SetData("com.steering.pss.qcm.CoreComBaseProcessRStation.doSave", new Object[] { list, processcode, processcodec }, this.ob);
  126. if (count > 0)
  127. {
  128. MessageBox.Show("保存成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
  129. InitGrid1();
  130. foreach (UltraGridRow ugr in ultraGrid1.Rows)
  131. {
  132. if (ugr.Cells["PROCESS_CDOE"].Value.ToString().Equals(processcode))
  133. {
  134. ugr.Activate();
  135. break;
  136. }
  137. }
  138. }
  139. }
  140. private void ultraGrid2_CellChange(object sender, CellEventArgs e)
  141. {
  142. ultraGrid2.UpdateData();
  143. if (e.Cell.Column.Key.Equals("CHK"))
  144. isselect += 1;
  145. }
  146. }
  147. }