PipeQueryBaseLab.cs 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387
  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 delegate void EnterHandler();
  15. public partial class PipeQueryBaseLab : UserControl
  16. {
  17. public EnterHandler EnterHandler;
  18. private DataTable dd = null;
  19. OpeBase ob = null;
  20. public PipeQueryBaseLab()
  21. {
  22. InitializeComponent();
  23. }
  24. private void PipeQueryBaseLab_Load(object sender, EventArgs e)
  25. {
  26. //绑定下拉框
  27. // BindCombox();
  28. }
  29. //绑定下拉框
  30. /// <summary>
  31. /// 绑定下拉框
  32. /// </summary>
  33. public void BindComboxNew(string Deptid ,OpeBase obase)
  34. {
  35. ob = obase;
  36. dd = PublicServer.GetData("com.steering.lims.data.base.FrmBaseCheckEquipment.QueryPhyCodeMax", new object[] { Deptid }, ob);
  37. if (dd != null && dd.Rows.Count > 0)
  38. {
  39. ultraQueryPHY_NAME_MAX.DataSource = dd;
  40. ultraQueryPHY_NAME_MAX.ValueMember = "PHY_TYPE";
  41. ultraQueryPHY_NAME_MAX.DisplayMember = "PHY_TYPE";
  42. }
  43. string strPlineNames = string.Join(",", dd.Rows.Cast<DataRow>().Select(a => a["PHY_TYPE"].ToString()).ToArray());
  44. string strPineCodes = string.Join(",", dd.Rows.Cast<DataRow>().Select(a => a["PHY_TYPE"].ToString()).ToArray());
  45. ultraTextEditor1.Text = strPlineNames;
  46. ultraTextEditor1.Tag = strPineCodes;
  47. }
  48. //获取查询条件
  49. /// <summary>
  50. /// 获取查询条件
  51. /// </summary>
  52. /// <returns></returns>
  53. public ArrayList GetQueryInfo()
  54. {
  55. ArrayList arrayList = new ArrayList();
  56. if (chkCONSIGN_TIME.Checked) //时间
  57. {
  58. arrayList.Add(dateBegin.DateTime.ToShortDateString() + " 00:00:00");
  59. arrayList.Add(dateEnd.DateTime.ToShortDateString() + " 23:59:59");
  60. }
  61. else
  62. {
  63. arrayList.Add("0001/01/01 00:00:00");
  64. arrayList.Add("9999/12/31 23:59:59");
  65. }
  66. if (chkCHECK_NO.Checked) //检验编号
  67. {
  68. arrayList.Add(txtQueryCHECK_NO.Text.Trim());
  69. }
  70. else
  71. {
  72. arrayList.Add("");
  73. }
  74. if (chkSAMPLE_NO.Checked) //试样号
  75. {
  76. arrayList.Add(ultraSAMPLE_NO.Text.Trim());
  77. }
  78. else
  79. {
  80. arrayList.Add("");
  81. }
  82. if (chkCONTRACT_NO.Checked) //合同号
  83. {
  84. arrayList.Add(ultraCONTRACT_NO.Text.Trim());
  85. }
  86. else
  87. {
  88. arrayList.Add("");
  89. }
  90. if (chkHEAT_NO.Checked) //炉号
  91. {
  92. arrayList.Add(txtQueryHEAT_NO.Text.Trim());
  93. }
  94. else
  95. {
  96. arrayList.Add("");
  97. }
  98. if (chkSTEEL_GRADE.Checked) //钢级
  99. {
  100. arrayList.Add(ultraQuerySTEEL_GRADE.Text.Trim());
  101. }
  102. else
  103. {
  104. arrayList.Add("");
  105. }
  106. if (chkISPRODUCER.Checked) //监制
  107. {
  108. arrayList.Add(ultraISPRODUCER.Value.ToString());
  109. }
  110. else
  111. {
  112. arrayList.Add("");
  113. }
  114. if (chkPHY_NAME_MAX.Checked) //检验项
  115. {
  116. arrayList.Add(ultraQueryPHY_NAME_MAX.Value.ToString());
  117. }
  118. else
  119. {
  120. arrayList.Add("");
  121. }
  122. if (chkSAMPLE_NO_MIN.Checked) //钢印号
  123. {
  124. arrayList.Add(ultraSAMPLE_NO_MIN.Value.ToString());
  125. }
  126. else
  127. {
  128. arrayList.Add("");
  129. }
  130. if (chkINSERT_FLAG.Checked) //加入
  131. {
  132. arrayList.Add(ultraINSERT_FLAG.Value.ToString());
  133. }
  134. else
  135. {
  136. arrayList.Add("");
  137. }
  138. return arrayList;
  139. }
  140. //获取查询条件
  141. /// <summary>
  142. /// 获取查询条件
  143. /// </summary>
  144. /// <param name="flag"></param>
  145. /// <returns></returns>
  146. public ArrayList GetQueryInfo(string flag)
  147. {
  148. ArrayList arrayList = new ArrayList();
  149. if (chkCONSIGN_TIME.Checked) //时间
  150. {
  151. arrayList.Add(dateBegin.DateTime.ToShortDateString() + " 00:00:00");
  152. arrayList.Add(dateEnd.DateTime.ToShortDateString() + " 23:59:59");
  153. }
  154. else
  155. {
  156. arrayList.Add("0001/01/01 00:00:00");
  157. arrayList.Add("9999/12/31 23:59:59");
  158. }
  159. if (chkCHECK_NO.Checked) //检验编号
  160. {
  161. arrayList.Add(txtQueryCHECK_NO.Text.Trim());
  162. }
  163. else
  164. {
  165. arrayList.Add("");
  166. }
  167. if (chkSAMPLE_NO.Checked) //试样号
  168. {
  169. arrayList.Add(ultraSAMPLE_NO.Text.Trim());
  170. }
  171. else
  172. {
  173. arrayList.Add("");
  174. }
  175. if (chkCONTRACT_NO.Checked) //合同号
  176. {
  177. arrayList.Add(ultraCONTRACT_NO.Text.Trim());
  178. }
  179. else
  180. {
  181. arrayList.Add("");
  182. }
  183. if (chkHEAT_NO.Checked) //炉号
  184. {
  185. arrayList.Add(txtQueryHEAT_NO.Text.Trim());
  186. }
  187. else
  188. {
  189. arrayList.Add("");
  190. }
  191. if (chkSTEEL_GRADE.Checked) //钢级
  192. {
  193. arrayList.Add(ultraQuerySTEEL_GRADE.Text.Trim());
  194. }
  195. else
  196. {
  197. arrayList.Add("");
  198. }
  199. if (chkISPRODUCER.Checked) //监制
  200. {
  201. arrayList.Add(ultraISPRODUCER.Value.ToString());
  202. }
  203. else
  204. {
  205. arrayList.Add("");
  206. }
  207. if (chkPHY_NAME_MAX.Checked) //检验项
  208. {
  209. arrayList.Add(ultraTextEditor1.Tag.ToString().Replace(",", "', '"));
  210. }
  211. else
  212. {
  213. arrayList.Add("");
  214. }
  215. if (chkSAMPLE_NO_MIN.Checked) //钢印号
  216. {
  217. arrayList.Add(ultraSAMPLE_NO_MIN.Value.ToString());
  218. }
  219. else
  220. {
  221. arrayList.Add("");
  222. }
  223. if (chkINSERT_FLAG.Checked) //加入
  224. {
  225. arrayList.Add(ultraINSERT_FLAG.Value.ToString());
  226. }
  227. else
  228. {
  229. arrayList.Add("");
  230. }
  231. arrayList.Add(flag);
  232. return arrayList;
  233. }
  234. //显示控件
  235. /// <summary>
  236. /// 显示控件
  237. /// </summary>
  238. public void ShowControl()
  239. {
  240. chkPHY_NAME_MAX.Visible = true;
  241. ultraQueryPHY_NAME_MAX.Visible = true;
  242. }
  243. //修改控件
  244. /// <summary>
  245. /// 修改控件
  246. /// </summary>
  247. /// <param name="name"></param>
  248. public void UpdateControl(string name)
  249. {
  250. chkCONSIGN_TIME.Text = name;
  251. }
  252. //修改控件
  253. /// <summary>
  254. /// 修改控件
  255. /// </summary>
  256. /// <param name="strName"></param>
  257. //public void UpdateControl(string[] strName)
  258. //{
  259. // if (strName.Length == 4)
  260. // {
  261. // chkCONSIGN_TIME.Text = strName[0];
  262. // chkCHECK_NO.Text = strName[1];
  263. // chkHEAT_NO.Text = strName[2];
  264. // chkSTEEL_GRADE.Text = strName[3];
  265. // }
  266. // ultraQuerySTEEL_GRADE.Clear();
  267. // if (chkSTEEL_GRADE.Text == "班组")
  268. // {
  269. // Infragistics.Win.ValueList valueList = new Infragistics.Win.ValueList();
  270. // valueList.ValueListItems.Add(0, "甲");
  271. // valueList.ValueListItems.Add(1, "已");
  272. // valueList.ValueListItems.Add(2, "丙");
  273. // valueList.ValueListItems.Add(3, "丁");
  274. // ultraQuerySTEEL_GRADE.ValueList = valueList;
  275. // }
  276. //}
  277. private void chkCONSIGN_TIME_CheckedChanged(object sender, EventArgs e)
  278. {
  279. this.dateBegin.Enabled = chkCONSIGN_TIME.Checked;
  280. this.dateEnd.Enabled = chkCONSIGN_TIME.Checked;
  281. }
  282. private void chkCHECK_NO_CheckedChanged(object sender, EventArgs e)
  283. {
  284. txtQueryCHECK_NO.Enabled = chkCHECK_NO.Checked;
  285. }
  286. private void chkHEAT_NO_CheckedChanged(object sender, EventArgs e)
  287. {
  288. txtQueryHEAT_NO.Enabled = chkHEAT_NO.Checked;
  289. }
  290. private void chkSTEEL_GRADE_CheckedChanged(object sender, EventArgs e)
  291. {
  292. ultraQuerySTEEL_GRADE.Enabled = chkSTEEL_GRADE.Checked;
  293. }
  294. private void chkPHY_NAME_MAX_CheckedChanged(object sender, EventArgs e)
  295. {
  296. ultraTextEditor1.Enabled = chkPHY_NAME_MAX.Checked;
  297. }
  298. private void txtQueryCHECK_NO_KeyDown(object sender, KeyEventArgs e)
  299. {
  300. if (e.KeyCode == Keys.Enter)
  301. {
  302. var handler = EnterHandler;
  303. if (handler != null) handler();
  304. txtQueryCHECK_NO.SelectAll();
  305. }
  306. }
  307. private void ultraLabel2_Click(object sender, EventArgs e)
  308. {
  309. }
  310. private void chkSAMPLE_NO_CheckedChanged(object sender, EventArgs e)
  311. {
  312. ultraSAMPLE_NO.Enabled = chkSAMPLE_NO.Checked;
  313. }
  314. private void chkCONTRACT_NO_CheckedChanged(object sender, EventArgs e)
  315. {
  316. ultraCONTRACT_NO.Enabled = chkCONTRACT_NO.Checked;
  317. }
  318. private void chkSTEEL_GRADE_CheckedChanged_1(object sender, EventArgs e)
  319. {
  320. ultraQuerySTEEL_GRADE.Enabled = chkSTEEL_GRADE.Checked;
  321. }
  322. private void chkISPRODUCER_CheckedChanged(object sender, EventArgs e)
  323. {
  324. ultraISPRODUCER.Enabled = chkISPRODUCER.Checked;
  325. }
  326. private void chkSAMPLE_NO_MIN_CheckedChanged(object sender, EventArgs e)
  327. {
  328. ultraSAMPLE_NO_MIN.Enabled = chkSAMPLE_NO_MIN.Checked;
  329. }
  330. private void chkINSERT_FLAG_CheckedChanged(object sender, EventArgs e)
  331. {
  332. ultraINSERT_FLAG.Enabled = chkINSERT_FLAG.Checked;
  333. }
  334. private void ultraTextEditor1_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
  335. {
  336. FrmJyx frm = new FrmJyx(dd, ultraTextEditor1.Tag.ToString2(),ob);
  337. if (frm.ShowDialog() == System.Windows.Forms.DialogResult.OK)
  338. {
  339. ultraTextEditor1.Text = frm.ChoicePlineName;
  340. ultraTextEditor1.Tag = frm.ChoicePlineCode;
  341. }
  342. }
  343. }
  344. }