Test.cs 3.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118
  1. using System;
  2. using System.Collections.Generic;
  3. using System.ComponentModel;
  4. using System.Data;
  5. using System.Drawing;
  6. using System.Linq;
  7. using System.Text;
  8. using System.Windows.Forms;
  9. using Core.Mes.Client.Comm;
  10. using CoreFS.CA06;
  11. using Core.Mes.Client.Comm.Server;
  12. using System.Collections;
  13. using Core.Mes.Client.Comm.Control;
  14. using Core.Mes.Client.Comm.Tool;
  15. namespace Core.StlMes.Client.Qcm
  16. {
  17. public partial class Test : FrmBase
  18. {
  19. public Test()
  20. {
  21. InitializeComponent();
  22. }
  23. public override void ToolBar_Click(object sender, string ToolbarKey)
  24. {
  25. base.ToolBar_Click(sender, ToolbarKey);
  26. switch (ToolbarKey)
  27. {
  28. case "Query":
  29. Query();
  30. break;
  31. case "Update":
  32. Update();
  33. break;
  34. case "Update2":
  35. Update2();
  36. break;
  37. case "Update3":
  38. Update3();
  39. break;
  40. }
  41. }
  42. private void Query()
  43. {
  44. ArrayList list = new ArrayList();
  45. list.Add(txtName2.Text.Trim());
  46. list.Add(txtName2.Text.Trim());
  47. list.Add(txtName2.Text.Trim());
  48. DataTable dt = ServerHelper.GetData("com.steering.pss.qcm.Test.query", new object[] { list }, ob);
  49. GridHelper.CopyDataToDatatable(dt, this.dataTable1, true);
  50. GridHelper.RefreshAndAutoSize(ultraGrid1);
  51. }
  52. private void Update()
  53. {
  54. if (MessageUtil.ShowYesNoAndQuestion("是否确认修改?") == DialogResult.No)
  55. {
  56. return;
  57. }
  58. ArrayList list = new ArrayList();
  59. list.Add(txtName.Text.Trim());
  60. list.Add(dtTime.Value.ToString("yyyy-MM-dd HH:mm:ss"));
  61. list.Add(ultraGrid1.ActiveRow.Cells["CODE"].Value.ToString());
  62. ServerHelper.SetData("com.steering.pss.qcm.Test.update", new object[] { list }, ob);
  63. MessageUtil.ShowTips("修改成功!");
  64. Query();
  65. }
  66. private void Update2()
  67. {
  68. if (MessageUtil.ShowYesNoAndQuestion("是否确认修改?") == DialogResult.No)
  69. {
  70. return;
  71. }
  72. ArrayList list = new ArrayList();
  73. for (int i = 0; i < ultraGrid1.Rows.Count; i++)
  74. {
  75. if (ultraGrid1.Rows[i].Selected == false) continue;
  76. ArrayList listSub = new ArrayList();
  77. listSub.Add(txtName.Text.Trim());
  78. listSub.Add(dtTime.Value.ToString("yyyy-MM-dd HH:mm:ss"));
  79. listSub.Add(ultraGrid1.Rows[i].Cells["CODE"].Value.ToString());
  80. list.Add(listSub);
  81. }
  82. ServerHelper.SetData("com.steering.pss.qcm.Test.update2", new object[] { list }, ob);
  83. MessageUtil.ShowTips("修改成功!");
  84. Query();
  85. }
  86. private void Update3()
  87. {
  88. if (MessageUtil.ShowYesNoAndQuestion("是否确认修改?") == DialogResult.No)
  89. {
  90. return;
  91. }
  92. ArrayList list = new ArrayList();
  93. list.Add(txtName.Text.Trim());
  94. list.Add(dtTime.Value.ToString("yyyy-MM-dd HH:mm:ss"));
  95. list.Add(ultraGrid1.ActiveRow.Cells["CODE"].Value.ToString());
  96. ArrayList list2 = new ArrayList();
  97. list2.Add("DD");
  98. list2.Add(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
  99. list2.Add("004");
  100. ServerHelper.SetData("com.steering.pss.qcm.Test.update3", new object[]{ list, list2 }, ob);
  101. MessageUtil.ShowTips("修改成功!");
  102. Query();
  103. }
  104. private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
  105. {
  106. txtName.Text = ultraGrid1.ActiveRow.Cells["NAME"].Value.ToString();
  107. dtTime.Value = DateTime.Parse(ultraGrid1.ActiveRow.Cells["TIME"].Value.ToString());
  108. }
  109. }
  110. }