FrmSteerONHDataCJ.cs 27 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644
  1. using System;
  2. using System.Collections.Generic;
  3. using System.ComponentModel;
  4. using System.Data;
  5. using System.Drawing;
  6. using System.Linq;
  7. using System.Text;
  8. using System.Windows.Forms;
  9. using CoreFS.CA03;
  10. using CoreFS.CA04;
  11. using CoreFS.CA06;
  12. using System.Collections;
  13. using Infragistics.Win.UltraWinGrid;
  14. using Core.Mes.Client.Comm.Server;
  15. using Core.Mes.Client.Comm.Control;
  16. using Core.Mes.Client.Comm.Tool;
  17. using Infragistics.Win;
  18. namespace Core.StlMes.Client.Lims.Data.Steer
  19. {
  20. public partial class FrmSteerONHDataCJ : FrmBase
  21. {
  22. private string[] arrId;//权限
  23. public FrmSteerONHDataCJ()
  24. {
  25. InitializeComponent();
  26. }
  27. protected override void OnLoad(EventArgs e)
  28. {
  29. base.OnLoad(e);
  30. ultraGrid1.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
  31. ultraGrid2.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
  32. ultraGrid3.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
  33. }
  34. private void FrmSteerONHDataCJ_Load(object sender, EventArgs e)
  35. {
  36. arrId = this.ValidDataPurviewIds;//获取数据权限
  37. InitColumns();
  38. PublicSteer.ColumnsWidth(ultraGrid2, 0, 60);
  39. PublicSteer.ColumnsWidth(ultraGrid3, 0, 60);
  40. BindComBox();
  41. }
  42. private void InitColumns()
  43. {
  44. //"O2 (ppm)", "N2 (%)", "H2 (ppm)"
  45. string[] arrColumnsBase = new string[] { "ID", "HEAT_NO", "SAMPLE_NO", "STEEL_NO", "ANA_O", "ANA_N", "ANA_H", "ONH_CHECK_NAME", "ONH_CHECK_TIME", "ONH_CHECK_SHIFT", "ONH_CHECK_CLASS", "ONH_ONH_CHECK_TEMP", "ONH_DEVICE_NO", "ONH_DEVICE_NAME" };
  46. string[] arrCaptionBase = new string[] { "ID", "炉号", "试样号", "钢号", "O", "N", "H", "录入人", "录入时间", "班次", "班组", "环境温度", "设备编码", "设备名称" };
  47. PublicSteer.InitColumns(arrColumnsBase, arrCaptionBase, dataTable1);
  48. PublicSteer.InitColumns(arrColumnsBase, arrCaptionBase, dataTable2);
  49. PublicSteer.InitColumns(arrColumnsBase, arrCaptionBase, dataTable3);
  50. PublicSteer.setColumnShowOrHidden(ultraGrid1, new string[] { "HEAT_NO", "SAMPLE_NO" }, true);
  51. PublicSteer.setColumnShowOrHidden(ultraGrid2, new string[] { "ID" }, false);
  52. PublicSteer.setColumnShowOrHidden(ultraGrid3, new string[] { "ID" }, false);
  53. PublicSteer.setOtherColumnReadOnly(ultraGrid1, null);//可编辑列
  54. PublicSteer.setOtherColumnReadOnly(ultraGrid2, null);//可编辑列
  55. PublicSteer.setOtherColumnReadOnly(ultraGrid2, new string[] { "ANA_O", "ANA_N", "ANA_H" });//可编辑列
  56. }
  57. //绑定下拉框
  58. private void BindComBox()
  59. {
  60. Infragistics.Win.ValueList valueListNo = new Infragistics.Win.ValueList();
  61. Infragistics.Win.ValueList valueListName = new Infragistics.Win.ValueList();
  62. if (UserInfo.GetDeptid() == "002001020001" || UserInfo.GetDepartment() == "一快分")
  63. {
  64. valueListNo.ValueListItems.Add("2234070413");
  65. valueListNo.ValueListItems.Add("3178");
  66. valueListName.ValueListItems.Add("ELTRA ONH 2000");
  67. valueListName.ValueListItems.Add("TCH600 ONH联测仪");
  68. }
  69. else
  70. {
  71. }
  72. ultraONH_DEVICE_NO.ValueList = valueListNo;
  73. ultraONH_DEVICE_NAME.ValueList = valueListName;
  74. }
  75. /// <summary>
  76. /// 重写基类方法
  77. /// </summary>
  78. /// <param name="sender"></param>
  79. /// <param name="ToolbarKey"></param>
  80. public override void ToolBar_Click(object sender, string ToolbarKey)
  81. {
  82. switch (ToolbarKey)
  83. {
  84. case "Query":
  85. if (ultraTabControl1.SelectedTab.Index == 0)
  86. {
  87. QueryChemAuditResultCheck();
  88. }
  89. else if (ultraTabControl1.SelectedTab.Index == 1)
  90. {
  91. QueryChemAuditResult();
  92. }
  93. break;
  94. case "Add":
  95. AddChemAuditResultONH();
  96. break;
  97. case "Update":
  98. UpdateChemAuditResultONH();
  99. break;
  100. case "Delete":
  101. DeleteChemAuditResultONH();
  102. break;
  103. case "Audit":
  104. //AuditChemAuditResultONH();
  105. break;
  106. case "Close":
  107. if (MessageUtil.ShowYesNoAndQuestion("是否确认关闭页面?") == DialogResult.Yes)
  108. {
  109. this.Close();
  110. }
  111. break;
  112. }
  113. }
  114. private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
  115. {
  116. if (toolMenu == null) return;
  117. if (ultraTabControl1.SelectedTab.Index == 0)
  118. {
  119. if (toolMenu.Toolbars[0].Tools.Exists("Add"))
  120. {
  121. this.toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.True;
  122. }
  123. if (toolMenu.Toolbars[0].Tools.Exists("Update"))
  124. {
  125. this.toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.False;
  126. }
  127. if (toolMenu.Toolbars[0].Tools.Exists("Delete"))
  128. {
  129. this.toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.False;
  130. }
  131. }
  132. else if (ultraTabControl1.SelectedTab.Index == 1)
  133. {
  134. if (toolMenu.Toolbars[0].Tools.Exists("Add"))
  135. {
  136. this.toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.False;
  137. }
  138. if (toolMenu.Toolbars[0].Tools.Exists("Update"))
  139. {
  140. this.toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.True;
  141. }
  142. if (toolMenu.Toolbars[0].Tools.Exists("Delete"))
  143. {
  144. this.toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.True;
  145. }
  146. }
  147. }
  148. //查询需要录入的信息
  149. private void QueryChemAuditResultCheck()
  150. {
  151. try
  152. {
  153. ArrayList arrayList = steerQueryBase1.GetQueryInfo();
  154. DataTable dt = PublicServer.GetData("com.steering.lims.data.steer.FrmSteerONHDataCJ.QueryChemAuditResultCheck",
  155. new Object[] { arrayList, arrId }, ob);
  156. if (dt == null || dt.Rows.Count == 0)
  157. {
  158. ClearData();
  159. dataTable1.Rows.Clear();
  160. return;
  161. }
  162. GridHelper.CopyDataToDatatable(dt, dataTable1, true);//把dt复制给dataTable
  163. GridHelper.RefreshAndAutoSize(ultraGrid1);//刷新Grid
  164. }
  165. catch (Exception e)
  166. {
  167. MessageUtil.ShowWarning(e.Message);
  168. return;
  169. }
  170. }
  171. //查询需要显示的信息
  172. private void QueryChemAuditResultShow()
  173. {
  174. try
  175. {
  176. DataTable dt = PublicServer.GetData("com.steering.lims.data.steer.FrmSteerONHDataCJ.QueryChemAuditResultShow",
  177. new Object[] { arrId }, ob);
  178. GridHelper.CopyDataToDatatable(dt, dataTable2, true);//把dt复制给dataTable
  179. UltraGridColumn[] cols = new UltraGridColumn[] { ultraGrid2.DisplayLayout.Bands[0].Columns["ONH_CHECK_TIME"] };
  180. PublicSteer.RefreshAndAutoSizeColumns(ultraGrid2, cols);//刷新Grid
  181. //GridHelper.RefreshAndAutoSize(ultraGrid2);//刷新Grid
  182. }
  183. catch (Exception e)
  184. {
  185. MessageUtil.ShowWarning(e.Message);
  186. return;
  187. }
  188. }
  189. //查询已经录入的信息
  190. private void QueryChemAuditResult()
  191. {
  192. try
  193. {
  194. ArrayList arrayList = steerQueryBase1.GetQueryInfo();
  195. DataTable dt = PublicServer.GetData("com.steering.lims.data.steer.FrmSteerONHDataCJ.QueryChemAuditResult",
  196. new Object[] { arrayList, arrId }, ob);
  197. GridHelper.CopyDataToDatatable(dt, dataTable3, true);//把dt复制给dataTable
  198. UltraGridColumn[] cols = new UltraGridColumn[] { ultraGrid3.DisplayLayout.Bands[0].Columns["ONH_CHECK_TIME"] };
  199. PublicSteer.RefreshAndAutoSizeColumns(ultraGrid3, cols);//刷新Grid
  200. //GridHelper.RefreshAndAutoSize(ultraGrid3);//刷新Grid
  201. }
  202. catch (Exception e)
  203. {
  204. MessageUtil.ShowWarning(e.Message);
  205. return;
  206. }
  207. }
  208. //保存ONH需要录入的信息
  209. private void AddChemAuditResultONH()
  210. {
  211. try
  212. {
  213. if (dataTable1 == null || dataTable1.Rows.Count == 0 || ultraGrid1.ActiveRow.Activated == false || txtHEAT_NO.Text == "")
  214. {
  215. MessageUtil.ShowWarning("请选择需要新增的试样信息!");
  216. return;
  217. }
  218. if (ultraTabControl1.SelectedTab.Index != 0)
  219. {
  220. MessageUtil.ShowWarning("只有选择了未录入数据页才能进行新增操作!");
  221. return;
  222. }
  223. if (txtANA_O.Text.Trim() == "" && txtANA_N.Text.Trim() == "" && txtANA_H.Text.Trim() == "")
  224. {
  225. MessageUtil.ShowWarning("ONH结果不能同时为空!");
  226. return;
  227. }
  228. //double sum = (txtANA_O.Text.Trim() == "" ? 0 : Double.Parse(txtANA_O.Text.Trim())) + (txtANA_N.Text.Trim() == "" ? 0 : Double.Parse(txtANA_N.Text.Trim())) + (txtANA_H.Text.Trim() == "" ? 0 : Double.Parse(txtANA_H.Text.Trim()));
  229. //if (sum >= 100)
  230. //{
  231. // MessageUtil.ShowWarning("ONH含量总数不能大于等于100!");
  232. // return;
  233. //}
  234. if (MessageUtil.ShowYesNoAndQuestion("是否确认新增?") == DialogResult.Yes)
  235. {
  236. string strSAMPLE_NO = txtSAMPLE_NO.Text.Trim();
  237. string strHEAT_NO = txtHEAT_NO.Text.Trim();
  238. ArrayList alDelete = new ArrayList();
  239. alDelete.Add(strSAMPLE_NO);
  240. alDelete.Add(strHEAT_NO);
  241. // PublicServer.GetDataTips("com.steering.lims.data.steer.FrmSteerDataCollect.QueryChemAuditResultTips",
  242. //new Object[] { alDelete, "11", "质保部已判定不能新增!" }, ob);//判定状态位是否能修改暂时用
  243. // PublicServer.SetData("com.steering.lims.data.steer.FrmSteerDataCollect.DeleteZBResult",
  244. //new Object[] { alDelete }, this.ob);
  245. DataTable dt = PublicServer.GetData("com.steering.lims.data.steer.FrmSteerONHDataCJ.QueryChemAuditResultIsHave",
  246. new Object[] { new object[] { strSAMPLE_NO, strHEAT_NO } }, ob);//判断数据库是否有数据
  247. ArrayList arrayList = new ArrayList();
  248. if (dt.Rows.Count == 0)
  249. {
  250. arrayList.Add(strHEAT_NO);//炉号
  251. arrayList.Add(strSAMPLE_NO);//试样号
  252. arrayList.Add(txtSTEEL_NO.Text.Trim());//钢号
  253. arrayList.Add(UserInfo.GetDeptid());//部门ID
  254. arrayList.Add(UserInfo.GetDepartment());//部门名称
  255. arrayList.Add(ultraONH_CHECK_NAME.Text.Trim() == "" ? UserInfo.GetUserName() : ultraONH_CHECK_NAME.Text.Trim());//试验人
  256. //arrayList.Add(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));//时间
  257. arrayList.Add(ultraONH_CHECK_SHIFT.Text.Trim() == "" ? UserInfo.GetUserOrderText() : ultraONH_CHECK_SHIFT.Text.Trim());//班次
  258. //arrayList.Add(ultraONH_CHECK_CLASS.Text.Trim() == "" ? UserInfo.GetUserName() : ultraONH_CHECK_CLASS.Text.Trim());//班组
  259. arrayList.Add(ultraONH_CHECK_CLASS.Text.Trim());//班组
  260. arrayList.Add(txtONH_CHECK_TEMP.Text.Trim());//温度
  261. arrayList.Add(ultraONH_DEVICE_NO.Text.Trim());//设备编码
  262. arrayList.Add(ultraONH_DEVICE_NAME.Text.Trim());//设备名称
  263. arrayList.Add(PublicSteer.SavePoint(txtANA_O.Text.Trim(), 4));//O
  264. arrayList.Add(PublicSteer.SavePoint(txtANA_N.Text.Trim(), 4));//N
  265. arrayList.Add(PublicSteer.SavePoint(txtANA_H.Text.Trim(), 5));//H
  266. PublicServer.SetData("com.steering.lims.data.steer.FrmSteerONHDataCJ.AddChemAuditResult",
  267. new Object[] { arrayList }, ob);
  268. }
  269. else
  270. {
  271. arrayList.Add(ultraONH_CHECK_NAME.Text.Trim() == "" ? UserInfo.GetUserName() : ultraONH_CHECK_NAME.Text.Trim());//试验人
  272. //arrayList.Add(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));//时间
  273. arrayList.Add(ultraONH_CHECK_SHIFT.Text.Trim() == "" ? UserInfo.GetUserOrderText() : ultraONH_CHECK_SHIFT.Text.Trim());//班次
  274. arrayList.Add(ultraONH_CHECK_CLASS.Text.Trim());//班组
  275. arrayList.Add(txtONH_CHECK_TEMP.Text.Trim());//温度
  276. arrayList.Add(ultraONH_DEVICE_NO.Text.Trim());//设备编码
  277. arrayList.Add(ultraONH_DEVICE_NAME.Text.Trim());//设备名称
  278. arrayList.Add(PublicSteer.SavePoint(txtANA_O.Text.Trim(), 4));//O
  279. arrayList.Add(PublicSteer.SavePoint(txtANA_N.Text.Trim(), 4));//N
  280. arrayList.Add(PublicSteer.SavePoint(txtANA_H.Text.Trim(), 5));//H
  281. arrayList.Add(strSAMPLE_NO);//试样号
  282. arrayList.Add(strHEAT_NO);//炉号
  283. arrayList.Add(ultraGrid1.ActiveRow.Cells["ID"].Text.Trim());
  284. PublicServer.SetData("com.steering.lims.data.steer.FrmSteerONHDataCJ.AddChemAuditResultONH",
  285. new Object[] { arrayList }, ob);
  286. }
  287. //20160324修改先保存到检化验数据库再删除SQL server
  288. // PublicServer.SetData("com.steering.lims.data.steer.FrmSteerDataCollect.DeleteZBResult",
  289. //new Object[] { alDelete }, this.ob);
  290. QueryChemAuditResultCheck();
  291. QueryChemAuditResultShow();//显示15条数据
  292. //QueryChemAuditResult();
  293. PublicSteer.ActiveOperateRow(ultraGrid2, new string[] { "HEAT_NO", "SAMPLE_NO" }, new string[] { strHEAT_NO, strSAMPLE_NO });
  294. MessageUtil.ShowTips("新增成功!");
  295. }
  296. }
  297. catch (Exception e)
  298. {
  299. MessageUtil.ShowWarning(e.Message);
  300. return;
  301. }
  302. }
  303. //修改ONH需要录入的信息
  304. private void UpdateChemAuditResultONH()
  305. {
  306. try
  307. {
  308. if (dataTable3 == null || dataTable3.Rows.Count == 0 || ultraGrid3.ActiveRow.Activated == false)
  309. {
  310. MessageUtil.ShowWarning("请选择需要修改的试样信息!");
  311. return;
  312. }
  313. if (ultraTabControl1.SelectedTab.Index != 1)
  314. {
  315. MessageUtil.ShowWarning("只有选择了已录入数据页才能进行修改操作!");
  316. return;
  317. }
  318. ultraGrid3.Update();
  319. string strANA_O_Log = PublicSteer.SavePoint(ultraGrid3.ActiveRow.Cells["ANA_O"].Text.Trim(), 4);
  320. string strANA_N_Log = PublicSteer.SavePoint(ultraGrid3.ActiveRow.Cells["ANA_N"].Text.Trim(), 4);
  321. string strANA_H_Log = PublicSteer.SavePoint(ultraGrid3.ActiveRow.Cells["ANA_H"].Text.Trim(), 5);
  322. //判断是否符合规则
  323. //double sum = (strANA_O_Log == "" ? 0 : Double.Parse(strANA_O_Log)) + (strANA_N_Log == "" ? 0 : Double.Parse(strANA_N_Log)) + (strANA_H_Log == "" ? 0 : Double.Parse(strANA_H_Log));
  324. //if (sum >= 100)
  325. //{
  326. // MessageUtil.ShowWarning("ONH含量总数不能大于等于100!");
  327. // return;
  328. //}
  329. if (MessageUtil.ShowYesNoAndQuestion("是否确认修改?") == DialogResult.Yes)
  330. {
  331. string strSAMPLE_NO = ultraGrid3.ActiveRow.Cells["SAMPLE_NO"].Text.Trim();
  332. string strHEAT_NO = ultraGrid3.ActiveRow.Cells["HEAT_NO"].Text.Trim();
  333. ArrayList arrayList = new ArrayList();
  334. arrayList.Add(strANA_O_Log);//O
  335. arrayList.Add(strANA_N_Log);//N
  336. arrayList.Add(strANA_H_Log);//H
  337. arrayList.Add(strSAMPLE_NO);//试样号
  338. arrayList.Add(strHEAT_NO);//炉号
  339. arrayList.Add(ultraGrid3.ActiveRow.Cells["ID"].Text.Trim());//ID
  340. ArrayList alOperate = new ArrayList();
  341. alOperate.Add(UserInfo.GetUserName());//操作人
  342. alOperate.Add("1");//操作类型
  343. alOperate.Add("0");
  344. alOperate.Add(strSAMPLE_NO);
  345. alOperate.Add(strHEAT_NO);
  346. alOperate.Add(ultraGrid3.ActiveRow.Cells["ID"].Text.Trim());
  347. ArrayList alDelete = new ArrayList();
  348. alDelete.Add(strSAMPLE_NO);
  349. alDelete.Add(strHEAT_NO);
  350. // PublicServer.GetDataTips("com.steering.lims.data.steer.FrmSteerDataCollect.QueryChemAuditResultTips",
  351. //new Object[] { alDelete, "11", "质保部已判定不能修改!" }, ob);//判定状态位是否能修改暂时用 20151228
  352. // PublicServer.SetData("com.steering.lims.data.steer.FrmSteerDataCollect.DeleteZBResult",
  353. //new Object[] { alDelete }, this.ob);//删除质保数据
  354. PublicServer.SetData("com.steering.lims.data.steer.FrmSteerONHDataCJ.UpdateChemAuditResultONH",
  355. new Object[] { arrayList, alOperate }, ob);
  356. //20160324修改先保存到检化验数据库再删除SQL server
  357. // PublicServer.SetData("com.steering.lims.data.steer.FrmSteerDataCollect.DeleteZBResult",
  358. //new Object[] { alDelete }, this.ob);//删除质保数据
  359. //QueryChemAuditResultCheck();
  360. QueryChemAuditResult();
  361. PublicSteer.ActiveOperateRow(ultraGrid3, new string[] { "HEAT_NO", "SAMPLE_NO" }, new string[] { strHEAT_NO, strSAMPLE_NO });
  362. MessageUtil.ShowTips("修改成功!");
  363. }
  364. }
  365. catch (Exception e)
  366. {
  367. MessageUtil.ShowWarning(e.Message);
  368. return;
  369. }
  370. }
  371. //修改ONH需要录入的信息
  372. private void DeleteChemAuditResultONH()
  373. {
  374. try
  375. {
  376. if (dataTable3 == null || dataTable3.Rows.Count == 0 || ultraGrid3.ActiveRow.Activated == false)
  377. {
  378. MessageUtil.ShowWarning("请选择需要删除的试样信息!");
  379. return;
  380. }
  381. if (ultraTabControl1.SelectedTab.Index != 1)
  382. {
  383. MessageUtil.ShowWarning("只有选择了已录入数据页才能进行删除操作!");
  384. return;
  385. }
  386. if (MessageUtil.ShowYesNoAndQuestion("是否确认删除?") == DialogResult.Yes)
  387. {
  388. string strSAMPLE_NO = ultraGrid3.ActiveRow.Cells["SAMPLE_NO"].Text.Trim();
  389. string strHEAT_NO = ultraGrid3.ActiveRow.Cells["HEAT_NO"].Text.Trim();
  390. ArrayList arrayList = new ArrayList();
  391. arrayList.Add(strSAMPLE_NO);//试样号
  392. arrayList.Add(strHEAT_NO);//炉号
  393. arrayList.Add(ultraGrid3.ActiveRow.Cells["ID"].Text.Trim());
  394. ArrayList alOperate = new ArrayList();
  395. alOperate.Add(UserInfo.GetUserName());//操作人
  396. alOperate.Add("1");//操作类型
  397. alOperate.Add("1");
  398. alOperate.Add(strSAMPLE_NO);
  399. alOperate.Add(strHEAT_NO);
  400. alOperate.Add(ultraGrid3.ActiveRow.Cells["ID"].Text.Trim());
  401. ArrayList alDelete = new ArrayList();
  402. alDelete.Add(strSAMPLE_NO);
  403. alDelete.Add(strHEAT_NO);
  404. // PublicServer.GetDataTips("com.steering.lims.data.steer.FrmSteerDataCollect.QueryChemAuditResultTips",
  405. //new Object[] { alDelete, "11", "质保部已判定不能删除!" }, ob);//判定状态位是否能修改暂时用
  406. // PublicServer.SetData("com.steering.lims.data.steer.FrmSteerDataCollect.DeleteZBResult",
  407. //new Object[] { alDelete }, this.ob);
  408. PublicServer.SetData("com.steering.lims.data.steer.FrmSteerONHDataCJ.DeleteChemAuditResultONH",
  409. new Object[] { arrayList, alOperate }, ob);
  410. //20160324修改先保存到检化验数据库再删除SQL server
  411. // PublicServer.SetData("com.steering.lims.data.steer.FrmSteerDataCollect.DeleteZBResult",
  412. //new Object[] { alDelete }, this.ob);//删除质保数据
  413. QueryChemAuditResult();
  414. QueryChemAuditResultCheck();
  415. PublicSteer.ActiveOperateRow(ultraGrid1, new string[] { "HEAT_NO", "SAMPLE_NO" }, new string[] { strHEAT_NO, strSAMPLE_NO });
  416. MessageUtil.ShowTips("删除成功!");
  417. }
  418. }
  419. catch (Exception e)
  420. {
  421. MessageUtil.ShowWarning(e.Message);
  422. return;
  423. }
  424. }
  425. //清空数据
  426. private void ClearData()
  427. {
  428. txtHEAT_NO.ReadOnly = true;
  429. txtSAMPLE_NO.ReadOnly = true;
  430. txtSTEEL_NO.ReadOnly = true;
  431. txtHEAT_NO.Text = "";
  432. txtSAMPLE_NO.Text = "";
  433. txtSTEEL_NO.Text = "";
  434. txtANA_O.Text = "";
  435. txtANA_N.Text = "";
  436. txtANA_H.Text = "";
  437. }
  438. private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
  439. {
  440. ClearData();
  441. //PublicSteer.ShowBaseInfo(ultraGrid1.ActiveRow, panel5);
  442. txtHEAT_NO.Text = ultraGrid1.ActiveRow.Cells["HEAT_NO"].Text.Trim();
  443. txtSAMPLE_NO.Text = ultraGrid1.ActiveRow.Cells["SAMPLE_NO"].Text.Trim();
  444. txtSTEEL_NO.Text = ultraGrid1.ActiveRow.Cells["STEEL_NO"].Text.Trim();
  445. }
  446. private void txtANA_O_TextChanged(object sender, EventArgs e)
  447. {
  448. if (txtANA_O.Text.Trim() != "")
  449. {
  450. if (StringUtil.IsDouble(txtANA_O.Text.Trim()) == false)
  451. {
  452. MessageUtil.ShowWarning("请输入数值!");
  453. txtANA_O.Text = "";
  454. return;
  455. }
  456. else
  457. {
  458. double a = Double.Parse(txtANA_O.Text.Trim());
  459. if (a < 0 || a >= 100)
  460. {
  461. MessageUtil.ShowWarning("请输入大于等于0且小于100的数值!");
  462. txtANA_O.Text = "";
  463. return;
  464. }
  465. }
  466. }
  467. }
  468. private void txtANA_O_Leave(object sender, EventArgs e)
  469. {
  470. }
  471. private void txtANA_N_TextChanged(object sender, EventArgs e)
  472. {
  473. if (txtANA_N.Text.Trim() != "")
  474. {
  475. if (StringUtil.IsDouble(txtANA_N.Text.Trim()) == false)
  476. {
  477. MessageUtil.ShowWarning("请输入数值!");
  478. txtANA_N.Text = "";
  479. return;
  480. }
  481. else
  482. {
  483. double a = Double.Parse(txtANA_N.Text.Trim());
  484. if (a < 0 || a >= 100)
  485. {
  486. MessageUtil.ShowWarning("请输入大于等于0且小于100的数值!");
  487. txtANA_N.Text = "";
  488. return;
  489. }
  490. }
  491. }
  492. }
  493. private void txtANA_N_Leave(object sender, EventArgs e)
  494. {
  495. }
  496. private void txtANA_H_TextChanged(object sender, EventArgs e)
  497. {
  498. if (txtANA_H.Text.Trim() != "")
  499. {
  500. if (StringUtil.IsDouble(txtANA_H.Text.Trim()) == false)
  501. {
  502. MessageUtil.ShowWarning("请输入数值!");
  503. txtANA_H.Text = "";
  504. return;
  505. }
  506. else
  507. {
  508. double a = Double.Parse(txtANA_H.Text.Trim());
  509. if (a < 0 || a >= 100)
  510. {
  511. MessageUtil.ShowWarning("请输入大于等于0且小于100的数值!");
  512. txtANA_H.Text = "";
  513. return;
  514. }
  515. }
  516. }
  517. }
  518. private void txtANA_H_Leave(object sender, EventArgs e)
  519. {
  520. }
  521. private void ultraGrid3_CellChange(object sender, CellEventArgs e)
  522. {
  523. if (e.Cell.Text.Trim() != "")
  524. {
  525. if (StringUtil.IsDouble(e.Cell.Text) == false)
  526. {
  527. MessageUtil.ShowWarning("请输入数值!");
  528. e.Cell.Value = "";
  529. return;
  530. }
  531. else if (Double.Parse(e.Cell.Text) < 0 || Double.Parse(e.Cell.Text) >= 100)
  532. {
  533. MessageUtil.ShowWarning("请输入大于等于0且小于100的数值!");
  534. e.Cell.Value = "";
  535. return;
  536. }
  537. }
  538. }
  539. private void btInsert_Click(object sender, EventArgs e)
  540. {
  541. txtHEAT_NO.ReadOnly = false;
  542. txtSAMPLE_NO.ReadOnly = false;
  543. txtSTEEL_NO.ReadOnly = false;
  544. }
  545. }
  546. }