OutdecQueryBase.cs 7.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252
  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 System.Collections;
  10. using CoreFS.CA06;
  11. //查询区域框
  12. namespace Core.StlMes.Client.Lims.Data.PipeAndOutdec
  13. {
  14. public partial class OutdecQueryBase : UserControl
  15. {
  16. public OutdecQueryBase()
  17. {
  18. InitializeComponent();
  19. }
  20. private void OutdecQueryBase_Load(object sender, EventArgs e)
  21. {
  22. //绑定下拉框
  23. BindCombox();
  24. }
  25. //绑定下拉框
  26. /// <summary>
  27. /// 绑定下拉框
  28. /// </summary>
  29. private void BindCombox()
  30. {
  31. }
  32. //绑定下拉框
  33. /// <summary>
  34. /// 绑定下拉框
  35. /// </summary>
  36. public void BindComboxNew(string Deptid, OpeBase ob)
  37. {
  38. //检验项
  39. DataTable dd = PublicServer.GetData("com.steering.lims.data.base.FrmBaseCheckEquipment.QueryPhyCodeMax", new object[] { Deptid }, ob);
  40. if (dd != null && dd.Rows.Count > 0)
  41. {
  42. ultraQueryPHY_NAME_MAX.DataSource = dd;
  43. ultraQueryPHY_NAME_MAX.ValueMember = "PHY_CODE";
  44. ultraQueryPHY_NAME_MAX.DisplayMember = "PHY_TYPE";
  45. }
  46. //加载应力环号
  47. DataTable dt = PublicServer.GetData("com.steering.lims.data.pipe.FrmLabDateParm.QueryProofRingNo", new object[] { }, ob);
  48. if (dt != null && dt.Rows.Count > 0)
  49. {
  50. ultraPROOF_RING_NO.DataSource = dt;
  51. ultraPROOF_RING_NO.ValueMember = "PROOF_RING_NO";
  52. ultraPROOF_RING_NO.DisplayMember = "PROOF_RING_NO";
  53. }
  54. }
  55. //获取查询条件
  56. /// <summary>
  57. /// 获取查询条件
  58. /// </summary>
  59. /// <returns></returns>
  60. public ArrayList GetQueryInfo()
  61. {
  62. ArrayList arrayList = new ArrayList();
  63. if (chkCONSIGN_TIME.Checked)
  64. {
  65. arrayList.Add(dateBegin.DateTime.ToShortDateString() + " 00:00:00");
  66. arrayList.Add(dateEnd.DateTime.ToShortDateString() + " 23:59:59");
  67. }
  68. else
  69. {
  70. arrayList.Add("0001/01/01 00:00:00");
  71. arrayList.Add("9999/12/31 23:59:59");
  72. }
  73. if (chkSTEEL_GRADE_NO.Checked)
  74. {
  75. arrayList.Add(ultraQuerySTEEL_GRADE_NO.Text.Trim());
  76. arrayList.Add(ultraQuerySTEEL_GRADE_NO.Text.Trim());
  77. arrayList.Add(ultraQuerySTEEL_GRADE_NO.Text.Trim());//试样名称
  78. }
  79. else
  80. {
  81. arrayList.Add("");
  82. arrayList.Add("");
  83. arrayList.Add("");
  84. }
  85. if (chkSAMPLE_NAME.Checked)
  86. {
  87. arrayList.Add(txtQuerySAMPLE_NAME.Text.Trim());
  88. arrayList.Add(txtQuerySAMPLE_NAME.Text.Trim());
  89. arrayList.Add(txtQuerySAMPLE_NAME.Text.Trim());
  90. }
  91. else
  92. {
  93. arrayList.Add("");
  94. arrayList.Add("");
  95. arrayList.Add("");
  96. }
  97. if (chkCHECK_NO.Checked)
  98. {
  99. arrayList.Add(txtQueryCHECK_NO.Text.Trim());
  100. }
  101. else
  102. {
  103. arrayList.Add("");
  104. }
  105. return arrayList;
  106. }
  107. //获取查询条件
  108. /// <summary>
  109. /// 获取查询条件
  110. /// </summary>
  111. /// <param name="flag"></param>
  112. /// <returns></returns>
  113. public ArrayList GetQueryInfo(string flag)
  114. {
  115. ArrayList arrayList = new ArrayList();
  116. arrayList.Add(flag);
  117. if (chkCONSIGN_TIME.Checked)
  118. {
  119. arrayList.Add(dateBegin.DateTime.ToShortDateString() + " 00:00:00");
  120. arrayList.Add(dateEnd.DateTime.ToShortDateString() + " 23:59:59");
  121. }
  122. else
  123. {
  124. arrayList.Add("0001/01/01 00:00:00");
  125. arrayList.Add("9999/12/31 23:59:59");
  126. }
  127. if (chkSTEEL_GRADE_NO.Checked)
  128. {
  129. arrayList.Add(ultraQuerySTEEL_GRADE_NO.Text.Trim());
  130. arrayList.Add(ultraQuerySTEEL_GRADE_NO.Text.Trim());
  131. arrayList.Add(ultraQuerySTEEL_GRADE_NO.Text.Trim());//试样名称
  132. }
  133. else
  134. {
  135. arrayList.Add("");
  136. arrayList.Add("");
  137. arrayList.Add("");
  138. }
  139. if (chkSAMPLE_NAME.Checked)
  140. {
  141. arrayList.Add(txtQuerySAMPLE_NAME.Text.Trim());
  142. arrayList.Add(txtQuerySAMPLE_NAME.Text.Trim());
  143. arrayList.Add(txtQuerySAMPLE_NAME.Text.Trim());
  144. }
  145. else
  146. {
  147. arrayList.Add("");
  148. arrayList.Add("");
  149. arrayList.Add("");
  150. }
  151. if (ultraQueryPHY_NAME_MAX.Visible)
  152. {
  153. if (chkPHY_NAME_MAX.Checked)
  154. {
  155. arrayList.Add(ultraQueryPHY_NAME_MAX.Value.ToString());
  156. arrayList.Add(ultraQueryPHY_NAME_MAX.Value.ToString());
  157. }
  158. else
  159. {
  160. arrayList.Add("");
  161. arrayList.Add("");
  162. }
  163. }
  164. if (chkCHECK_NO.Checked)
  165. {
  166. arrayList.Add(txtQueryCHECK_NO.Text.Trim());
  167. }
  168. else
  169. {
  170. arrayList.Add("");
  171. }
  172. if (ultraPROOF_RING_NO.Visible)
  173. {
  174. if (chkPROOF_RING_NO.Checked)
  175. {
  176. arrayList.Add(ultraPROOF_RING_NO.Text.ToString());
  177. arrayList.Add(ultraPROOF_RING_NO.Text.ToString());
  178. arrayList.Add(ultraPROOF_RING_NO.Text.ToString());
  179. }
  180. else
  181. {
  182. arrayList.Add("");
  183. arrayList.Add("");
  184. arrayList.Add("");
  185. }
  186. }
  187. return arrayList;
  188. }
  189. //显示控件
  190. /// <summary>
  191. /// 显示控件(检验项)
  192. /// </summary>
  193. public void ShowControl()
  194. {
  195. chkPHY_NAME_MAX.Visible = true;
  196. ultraQueryPHY_NAME_MAX.Visible = true;
  197. }
  198. /// <summary>
  199. /// 显示控件(应力环)
  200. /// </summary>
  201. public void ShowControlProofRingNo()
  202. {
  203. chkPROOF_RING_NO.Visible = true;
  204. ultraPROOF_RING_NO.Visible = true;
  205. }
  206. private void chkCHECK_NO_CheckedChanged(object sender, EventArgs e)
  207. {
  208. txtQueryCHECK_NO.Enabled = chkCHECK_NO.Checked;
  209. }
  210. private void chkSAMPLE_NAME_CheckedChanged(object sender, EventArgs e)
  211. {
  212. txtQuerySAMPLE_NAME.Enabled = chkSAMPLE_NAME.Checked;
  213. }
  214. private void chkSTEEL_GRADE_NO_CheckedChanged(object sender, EventArgs e)
  215. {
  216. ultraQuerySTEEL_GRADE_NO.Enabled = chkSTEEL_GRADE_NO.Checked;
  217. }
  218. private void chkPHY_NAME_MAX_CheckedChanged(object sender, EventArgs e)
  219. {
  220. ultraQueryPHY_NAME_MAX.Enabled = chkPHY_NAME_MAX.Checked;
  221. }
  222. private void chkCONSIGN_TIME_CheckedChanged(object sender, EventArgs e)
  223. {
  224. this.dateBegin.Enabled = chkCONSIGN_TIME.Checked;
  225. this.dateEnd.Enabled = chkCONSIGN_TIME.Checked;
  226. }
  227. private void chkFLAG_CheckedChanged(object sender, EventArgs e)
  228. {
  229. ultraPROOF_RING_NO.Enabled = chkPROOF_RING_NO.Checked;
  230. }
  231. }
  232. }