PublicUltraGridChemDetail.cs 8.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256
  1. using System;
  2. using System.Collections.Generic;
  3. using System.ComponentModel;
  4. using System.Drawing;
  5. using System.Data;
  6. using System.Linq;
  7. using System.Text;
  8. using System.Windows.Forms;
  9. using Infragistics.Win.UltraWinGrid;
  10. using System.Collections;
  11. using CoreFS.CA06;
  12. using Core.Mes.Client.Comm.Control;
  13. using Core.Mes.Client.Comm.Server;
  14. using Core.Mes.Client.Comm.Tool;
  15. //化学元素详细信息显示Grid
  16. namespace Core.StlMes.Client.Lims.Data.PipeAndOutdec
  17. {
  18. public partial class PublicUltraGridChemDetail : UserControl
  19. {
  20. public event EventHandler PublicUltraGridChemDetailActive;
  21. //private DataTable dataTable;
  22. public DataTable DataTable
  23. {
  24. get { return dataTable1; }
  25. set { dataTable1 = value; }
  26. }
  27. //private UltraGrid ug;
  28. public UltraGrid Ug
  29. {
  30. get { return ultraGrid1; }
  31. set { ultraGrid1 = value; }
  32. }
  33. private UltraGridRow ur;
  34. public UltraGridRow Ur
  35. {
  36. get { return ur; }
  37. set { ur = value; }
  38. }
  39. public PublicUltraGridChemDetail()
  40. {
  41. InitializeComponent();
  42. }
  43. private void PublicUltraGridDetail_Load(object sender, EventArgs e)
  44. {
  45. string[] arrColumns = PublicPipeAndOutdec.chemMax.Split(' ');
  46. string[] arrCaption = PublicPipeAndOutdec.chemMin.Split(' ');
  47. InitColumns(arrColumns, arrCaption);
  48. }
  49. //初始化列
  50. /// <summary>
  51. /// 初始化列
  52. /// </summary>
  53. /// <param name="arrColumns"></param>
  54. /// <param name="arrCaption"></param>
  55. private void InitColumns(string[] arrColumns, string[] arrCaption)
  56. {
  57. DataColumn dc;
  58. for (int i = 0; i < arrColumns.Length; i++)
  59. {
  60. try
  61. {
  62. dc = new DataColumn(arrColumns[i]);
  63. dc.Caption = arrCaption[i];
  64. dataTable1.Columns.Add(dc);
  65. //dc.DataType = typeof(bool);
  66. //dc.DefaultValue = "False";
  67. }
  68. catch
  69. {
  70. continue;
  71. }
  72. }
  73. UltraGridColumn[] cols = new UltraGridColumn[] { ultraGrid1.DisplayLayout.Bands[0].Columns["SAMPLE_NO"] };
  74. GridHelper.RefreshAndAutoSizeExceptColumns(ultraGrid1, cols);
  75. }
  76. private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
  77. {
  78. if (PublicUltraGridChemDetailActive != null)
  79. {
  80. ur = ultraGrid1.ActiveRow;
  81. PublicUltraGridChemDetailActive(sender, e);//调用委托事件
  82. }
  83. }
  84. private void ultraGrid1_CellChange(object sender, CellEventArgs e)
  85. {
  86. if (ultraGrid1.Rows.Count > 1 && e.Cell.Row.Index == 0 && PublicPipeAndOutdec.chemMax.IndexOf(e.Cell.Column.Key) >= 0)//HC 2015-07-30
  87. {
  88. ultraGrid1.Update();
  89. for (int i = 1; i < ultraGrid1.Rows.Count; i++)
  90. {
  91. ultraGrid1.Rows[i].Cells[e.Cell.Column.Key].Value = ultraGrid1.Rows[0].Cells[e.Cell.Column.Key].Text.Trim();
  92. }
  93. }
  94. }
  95. //查询检验委托明细信息
  96. /// <summary>
  97. /// 查询检验委托明细信息
  98. /// </summary>
  99. /// <param name="path"></param>
  100. /// <param name="arrayList"></param>
  101. /// <param name="ob"></param>
  102. public void QueryCheckConsignChemDetail(string path, ArrayList arrayList, OpeBase ob)
  103. {
  104. dataTable1.Rows.Clear();
  105. DataTable dt = PublicServer.GetData("com.steering.lims.data." + path + ".QueryCheckConsignChemDetail",
  106. new Object[] { arrayList }, ob);
  107. if (dt == null || dt.Rows.Count == 0)
  108. {
  109. return;
  110. }
  111. string rowChem = "";//存放所有样管号判断是否有重复样管号
  112. DataRow newDrChem = dataTable1.NewRow();
  113. foreach (DataRow dr in dt.Rows)
  114. {
  115. if (rowChem.IndexOf(dr["SAMPLE_NO"].ToString()) < 0)//判断化学是否有重复样管号,有则不增加行只增加对应的列
  116. {
  117. rowChem += dr["SAMPLE_NO"].ToString() + " ";
  118. newDrChem = dataTable1.NewRow();
  119. newDrChem["SAMPLE_NO"] = dr["SAMPLE_NO"].ToString();
  120. if (dataTable1.Columns.Contains("ANA_" + dr["CHEM_NAME"].ToString().ToUpper()))
  121. {
  122. newDrChem["ANA_" + dr["CHEM_NAME"].ToString().ToUpper()] = "√";
  123. }
  124. if (dr["CHEM_NAME"].ToString().ToUpper() == "ALT")
  125. {
  126. newDrChem["ANA_" + "AL"] = "√";
  127. }
  128. dataTable1.Rows.Add(newDrChem);
  129. }
  130. else
  131. {
  132. if (dataTable1.Columns.Contains("ANA_" + dr["CHEM_NAME"].ToString().ToUpper()))
  133. {
  134. newDrChem["ANA_" + dr["CHEM_NAME"].ToString().ToUpper()] = "√";
  135. }
  136. if (dr["CHEM_NAME"].ToString().ToUpper() == "ALT")
  137. {
  138. newDrChem["ANA_" + "AL"] = "√";
  139. }
  140. }
  141. }
  142. //GridHelper.RefreshAndAutoSize(ultraGrid1);//刷新Grid
  143. }
  144. //获取勾选的元素
  145. /// <summary>
  146. /// 获取勾选的元素
  147. /// </summary>
  148. /// <returns></returns>
  149. public ArrayList GetCheckChem()
  150. {
  151. ArrayList al = new ArrayList();
  152. string chemONH = "";
  153. string chemItems = "";
  154. //string[] arrchem = new string[2];
  155. ArrayList alchem = new ArrayList();
  156. ultraGrid1.UpdateData();
  157. foreach (DataRow dr in dataTable1.Rows)
  158. {
  159. chemONH = "";
  160. chemItems = "";
  161. foreach (DataColumn dc in dataTable1.Columns)
  162. {
  163. if (dr[dc.ColumnName].ToString() == "√")
  164. {
  165. if ("ONH".IndexOf(dc.Caption) >= 0)
  166. {
  167. chemONH += dc.Caption + " ";
  168. }
  169. else
  170. {
  171. chemItems += dc.Caption + " ";
  172. }
  173. }
  174. }
  175. alchem.Add(chemItems);
  176. alchem.Add(chemONH);
  177. al.Add(alchem);
  178. //al.Add(arrchem);
  179. }
  180. return al;
  181. }
  182. public ArrayList GetOutdecCheckChem()
  183. {
  184. //ArrayList al = new ArrayList();
  185. string chemItems = "";
  186. ArrayList alchem = new ArrayList();
  187. ultraGrid1.UpdateData();
  188. foreach (DataRow dr in dataTable1.Rows)
  189. {
  190. chemItems = "";
  191. foreach (DataColumn dc in dataTable1.Columns)
  192. {
  193. if (dr[dc.ColumnName].ToString() == "√")
  194. {
  195. chemItems += dc.Caption + " ";
  196. }
  197. }
  198. alchem.Add(chemItems);
  199. //al.Add(alchem);
  200. }
  201. return alchem;
  202. }
  203. private void ultraGrid1_ClickCell(object sender, ClickCellEventArgs e)
  204. {
  205. if (PublicPipeAndOutdec.chemMax.IndexOf(e.Cell.Column.Key) >= 0)
  206. {
  207. if (e.Cell.Text.Trim() == "")
  208. {
  209. e.Cell.Value = "√";
  210. }
  211. else
  212. {
  213. e.Cell.Value = "";
  214. }
  215. if (ultraGrid1.Rows.Count > 1 && e.Cell.Row.Index == 0)//HC 2015-07-30
  216. {
  217. ultraGrid1.Update();
  218. for (int i = 1; i < ultraGrid1.Rows.Count; i++)
  219. {
  220. ultraGrid1.Rows[i].Cells[e.Cell.Column.Key].Value = ultraGrid1.Rows[0].Cells[e.Cell.Column.Key].Text.Trim();
  221. }
  222. }
  223. }
  224. }
  225. }
  226. }