ClsLoad.cs 3.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Text;
  5. using System.Data;
  6. using Core.Mes.Client.Comm.Server;
  7. using CoreFS.CA06;
  8. using Infragistics.Win;
  9. using System.Collections;
  10. namespace Core.StlMes.Client.YdmPipeManage
  11. {
  12. class ClsLoad
  13. {
  14. /// <summary>
  15. ///基础信息
  16. /// </summary>
  17. /// <param name="df"></param>
  18. /// <param name="ob"></param>
  19. public static DataTable GetValueListDataTable(string pCode, OpeBase ob)
  20. {
  21. DataTable dt = new DataTable();
  22. ArrayList queryList = new ArrayList();
  23. queryList.Add(pCode);
  24. dt = ServerHelper.GetData("com.steering.pss.ydm.base.BaseOperations.queryBaseConfion", new object[] { queryList }, ob);
  25. return dt;
  26. }
  27. public static DataTable GetValueListDataTable(string [] pCode, OpeBase ob)
  28. {
  29. DataTable dt = new DataTable();
  30. ArrayList queryList = new ArrayList();
  31. for (int i = 0; i < pCode.Length; i++)
  32. {
  33. queryList.Add(pCode[i].ToString());
  34. }
  35. dt = ServerHelper.GetData("com.steering.pss.ydm.base.BaseOperations.queryBaseConfion", new object[] { queryList }, ob);
  36. return dt;
  37. }
  38. public static DataTable GetValueListDataTable(OpeBase ob)
  39. {
  40. DataTable dt = new DataTable();
  41. ArrayList queryList = new ArrayList();
  42. dt = ServerHelper.GetData("com.steering.pss.ydm.base.BaseOperations.queryLockFlag", new object[]{"1"}, ob);
  43. return dt;
  44. }
  45. public static DataTable GetValueListDataTableM(OpeBase ob)
  46. {
  47. DataTable dt = new DataTable();
  48. ArrayList queryList = new ArrayList();
  49. dt = ServerHelper.GetData("com.steering.pss.ydm.base.BaseOperations.queryMangeFlag", new object[] { "1" }, ob);
  50. return dt;
  51. }
  52. /// <summary>
  53. /// 根据指定DataTable生成ValueList
  54. /// </summary>
  55. /// <param name="table"></param>
  56. /// <param name="strKey">value</param>
  57. /// <param name="strText">Text</param>
  58. /// <returns></returns>
  59. public static ValueList GeneralValuelist(ref DataTable table, string strKey, string strText)
  60. {
  61. if (table == null || !table.Columns.Contains(strKey) || !table.Columns.Contains(strText))
  62. {
  63. return null;
  64. }
  65. ArrayList alist = new ArrayList();
  66. ValueList vlist = new ValueList();
  67. for (int i = 0; i < table.Rows.Count; i++)
  68. {
  69. try
  70. {
  71. if (!alist.Contains(table.Rows[i][strKey]))
  72. {
  73. alist.Add(table.Rows[i][strKey]);
  74. vlist.ValueListItems.Add(table.Rows[i][strKey], Convert.ToString(table.Rows[i][strText]));
  75. }
  76. }
  77. catch { }
  78. }
  79. return vlist;
  80. }
  81. }
  82. }