ClsLoad.cs 7.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Text;
  5. using CoreFS.CA06;
  6. using System.Data;
  7. using System.Collections;
  8. using Infragistics.Win;
  9. using Core.Mes.Client.Comm.Server;
  10. namespace Core.StlMes.Client.YdmBcPipeManage
  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.ydm.bc.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.ydm.bc.BaseOperations.queryBaseConfion", new object[] { queryList }, ob);
  36. return dt;
  37. }
  38. /// <summary>
  39. /// 根据指定DataTable生成ValueList
  40. /// </summary>
  41. /// <param name="table"></param>
  42. /// <param name="strKey">value</param>
  43. /// <param name="strText">Text</param>
  44. /// <returns></returns>
  45. public static ValueList GeneralValuelist(ref DataTable table, string strKey, string strText)
  46. {
  47. if (table == null || !table.Columns.Contains(strKey) || !table.Columns.Contains(strText))
  48. {
  49. return null;
  50. }
  51. ArrayList alist = new ArrayList();
  52. ValueList vlist = new ValueList();
  53. for (int i = 0; i < table.Rows.Count; i++)
  54. {
  55. try
  56. {
  57. if (!alist.Contains(table.Rows[i][strKey]))
  58. {
  59. alist.Add(table.Rows[i][strKey]);
  60. vlist.ValueListItems.Add(table.Rows[i][strKey], Convert.ToString(table.Rows[i][strText]));
  61. }
  62. }
  63. catch { }
  64. }
  65. return vlist;
  66. }
  67. /// <summary>
  68. /// 通过科室查找对应的部门
  69. /// </summary>
  70. /// <param name="sectionName">科室ID</param>
  71. /// <param name="ob"></param>
  72. /// <returns>部门名称</returns>
  73. public static string GetDepartBySectionId1(string sectionId, OpeBase ob)
  74. {
  75. DataTable dt = ServerHelper.GetData("com.steering.mes.SendRecive.FrmFilpOutStorage.getDeptBySection", new object[] { sectionId }, ob);
  76. if (dt.Rows.Count > 0)
  77. {
  78. return dt.Rows[0]["DEPARTNAME"].ToString();
  79. }
  80. else
  81. {
  82. return "";
  83. }
  84. }
  85. /// <summary>
  86. /// 通过科室查找对应的部门
  87. /// </summary>
  88. /// <param name="sectionName">科室ID</param>
  89. /// <param name="ob"></param>
  90. /// <returns>部门名称</returns>
  91. public static string GetDepartBySectionId(string sectionId, OpeBase ob)
  92. {
  93. DataTable dt = ServerHelper.GetData("com.steering.ydm.bc.ComLgValidDataPurviewIds.getDeptBySection", new object[] { sectionId }, ob);
  94. if (dt.Rows.Count > 0)
  95. {
  96. return dt.Rows[0]["DEPARTNAME"].ToString();
  97. }
  98. else
  99. {
  100. return "";
  101. }
  102. }
  103. /// <summary>
  104. /// 通过科室查找对应的部门
  105. /// </summary>
  106. /// <param name="sectionName">科室ID</param>
  107. /// <param name="ob"></param>
  108. /// <returns>部门ID</returns>
  109. public static string GetDepartIdBySectionId(string sectionId, OpeBase ob)
  110. {
  111. DataTable dt = ServerHelper.GetData("com.steering.ydm.bc.ComLgValidDataPurviewIds.getDeptBySection", new object[] { sectionId }, ob);
  112. if (dt.Rows.Count > 0)
  113. {
  114. return dt.Rows[0]["DEPARTID"].ToString();
  115. }
  116. else
  117. {
  118. return "";
  119. }
  120. }
  121. /// <summary>
  122. /// 通过科室查找对应的部门
  123. /// </summary>
  124. /// <param name="sectionName">科室ID</param>
  125. /// <param name="ob"></param>
  126. /// <returns>部门ID</returns>
  127. public static string GetDepartIdBySectionId1(string sectionId, OpeBase ob)
  128. {
  129. DataTable dt = ServerHelper.GetData("com.steering.mes.SendRecive.FrmFilpOutStorage.getDeptBySection", new object[] { sectionId }, ob);
  130. if (dt.Rows.Count > 0)
  131. {
  132. return dt.Rows[0]["DEPARTID"].ToString();
  133. }
  134. else
  135. {
  136. return "";
  137. }
  138. }
  139. /// <summary>
  140. /// 将T1 实体的参数复制给 T2 ,不能处理多层次
  141. /// </summary>
  142. /// <typeparam name="T1"></typeparam>
  143. /// <typeparam name="T2"></typeparam>
  144. /// <param name="a"></param>
  145. /// <param name="b"></param>
  146. public static void CopyModel<T1, T2>(T1 a, T2 b)
  147. {
  148. System.Reflection.PropertyInfo[] cfgItemProperties = a.GetType().GetProperties(System.Reflection.BindingFlags.Instance | System.Reflection.BindingFlags.Public);
  149. foreach (System.Reflection.PropertyInfo item in cfgItemProperties)
  150. {
  151. string name = item.Name;
  152. object value = item.GetValue(a, null);
  153. //string 或 值属性,且value 不为 null
  154. if ((item.PropertyType.IsValueType || item.PropertyType.Name.StartsWith("String")) && value != null && !string.IsNullOrEmpty(value.ToString()))
  155. {
  156. #region 在MODEL2中查找是否有此参数名,有则赋值
  157. System.Reflection.PropertyInfo[] list2 = b.GetType().GetProperties(System.Reflection.BindingFlags.Instance | System.Reflection.BindingFlags.Public);
  158. foreach (System.Reflection.PropertyInfo i2 in list2)
  159. {
  160. //两者 PropertyType.Name 要相等
  161. if (item.Name == i2.Name && item.PropertyType.Name == i2.PropertyType.Name)
  162. {
  163. i2.SetValue(b, value, null);
  164. }
  165. }
  166. #endregion
  167. }
  168. }
  169. }
  170. /// <summary>
  171. /// 获取作业类型信息
  172. /// </summary>
  173. /// <param name="sortCode">快速索引码,参数数组</param>
  174. /// <param name="ob">界面OB对象</param>
  175. /// <returns></returns>
  176. //public static DataTable getComTypeInfo(string sortCode, OpeBase ob)
  177. //{
  178. // return ServerHelper.GetData("com.steering.pss.ydm.pipemanage.PipeManageClassInfo.queryType", new object[] { sortCode }, ob);
  179. //}
  180. }
  181. }