FrmChemDataManage.cs 58 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321
  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.CA06;
  10. using Infragistics.Win.UltraWinGrid;
  11. using Core.Mes.Client.Comm.Tool;
  12. using System.Collections;
  13. using Core.Mes.Client.Comm.Control;
  14. using Infragistics.Win;
  15. namespace Core.StlMes.Client.Lims.Data.PipeAndOutdec
  16. {
  17. //临时标钢修约规则保存在BASE_CHEM_STDSTEEL_SELECT_TEMP表
  18. public partial class FrmChemDataManage : FrmBase
  19. {
  20. private string[] arrId;//数据权限
  21. private string[] plineCodes = { };
  22. public FrmChemDataManage()
  23. {
  24. InitializeComponent();
  25. }
  26. private string[] arrColumnsBase;
  27. protected override void OnLoad(EventArgs e)
  28. {
  29. base.OnLoad(e);
  30. publicUltraGridBase1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
  31. publicUltraGridBase2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
  32. //ultraGrid2.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头
  33. ultraGrid2.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
  34. //ultraGrid3.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
  35. //ultraGrid3.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
  36. //ultraGrid4.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
  37. ultraGrid4.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
  38. //ultraGrid5.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
  39. //ultraGrid5.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
  40. //ultraGrid6.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
  41. //ultraGrid6.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
  42. //ultraGrid8.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头
  43. ///ultraGrid8.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
  44. //ultraGrid9.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
  45. //ultraGrid9.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
  46. //ultraGrid10.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
  47. //ultraGrid10.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
  48. //ultraGrid11.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
  49. //ultraGrid11.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
  50. //ultraGrid12.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
  51. //ultraGrid12.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
  52. }
  53. private void FrmChemDataManage_Load(object sender, EventArgs e)
  54. {
  55. EntityHelper.ShowGridCaption<PipeCheckconsignDetailEntity>(ultraGrid5.DisplayLayout.Bands[0]);
  56. //arrId = this.ValidDataPurviewIds;//获取数据权限
  57. arrId = new string[] { "002001007010" };//化学项目
  58. plineCodes = comm.GetPlineCode(ValidDataPurviewIds, ob);
  59. InitColumns();
  60. //pipeQueryBase1.visbleCom();
  61. //BindInitRow();
  62. }
  63. private void InitColumns()
  64. {
  65. pipeShowBase1.ChangeLabel();
  66. pipeShowBase2.ChangeLabel();
  67. publicUltraGridBase1.PublicUltraGridBaseActive += new EventHandler(publicUltraGridBase1_PublicUltraGridBaseActive);//调用委托事件
  68. publicUltraGridBase2.PublicUltraGridBaseActive += new EventHandler(publicUltraGridBase2_PublicUltraGridBaseActive);
  69. publicUltraGridBase1.InitColumnsPipeBase(new string[] { "CHECK_NO", "SAMPLE_NO" }, true, null);
  70. publicUltraGridBase2.InitColumnsPipeBase(new string[] { "CHECK_NO", "SAMPLE_NO" }, true, null);
  71. arrColumnsBase = new string[] { "CHEM_NAME", "SELECT_STEEL_NO", "STD_STEEL_STD_VALUE", "STD_STEEL_PROCESS_VALUE", "ROUND_VALUE", "PROCESS_VALUE", "AUDIT_VALUE", "QUOTE_VALUE", "STDMIN","STDMAX" };
  72. string[] arrCaptionBase = new string[] { "元素", "选择标钢", "标钢标准值", "标钢实测值", "标钢修约值", "采集值", "处理值", "报出值","元素下限值","元素上限值" };
  73. string[] hiddenBase = new string[] { "STDMIN", "STDMAX" };
  74. PublicPipeAndOutdec.InitColumns(arrColumnsBase, arrCaptionBase, dataTable2);
  75. //PublicPipeAndOutdec.setColumnShowOrHidden(ultraGrid2, hiddenBase, true);
  76. PublicPipeAndOutdec.setOtherColumnReadOnly(ultraGrid2, new string[] { "AUDIT_VALUE" });
  77. PublicPipeAndOutdec.InitColumns(arrColumnsBase, arrCaptionBase, dataTable4);
  78. //PublicPipeAndOutdec.setColumnShowOrHidden(ultraGrid4, hiddenBase, true);
  79. //PublicPipeAndOutdec.setOtherColumnReadOnly(ultraGrid4, new string[] { "AUDIT_VALUE" });
  80. }
  81. void publicUltraGridBase1_PublicUltraGridBaseActive(object sender, EventArgs e)
  82. {
  83. pipeShowBase1.ShowBaseInfo(publicUltraGridBase1.Ur);//获取显示区详细信息
  84. QueryCheckConsignChemDetailInfo();//获取显示区化学详细信息
  85. }
  86. void publicUltraGridBase2_PublicUltraGridBaseActive(object sender, EventArgs e)
  87. {
  88. pipeShowBase2.ShowBaseInfo(publicUltraGridBase2.Ur);//获取显示区详细信息
  89. QueryCheckConsignChemDetailInfo_LOG();//获取显示区化学详细信息
  90. }
  91. /// <summary>
  92. /// 重写基类方法
  93. /// </summary>
  94. /// <param name="sender"></param>
  95. /// <param name="ToolbarKey"></param>
  96. public override void ToolBar_Click(object sender, string ToolbarKey)
  97. {
  98. //新增、修改修约值、审核、删除、退出
  99. switch (ToolbarKey)
  100. {
  101. case "Query":
  102. if (ultraTabControl1.SelectedTab.Index == 0)
  103. {
  104. QueryCheckConsignBase();
  105. }
  106. else if (ultraTabControl1.SelectedTab.Index == 1)
  107. {
  108. QueryCheckConsignBase_LOG();
  109. }
  110. else if (ultraTabControl1.SelectedTab.Index == 2)
  111. {
  112. doQueryChemDetial();
  113. //RepLimsOutdecChemResultQuery();
  114. }
  115. break;
  116. case "Add":
  117. AddChemAuditResult();
  118. break;
  119. case "Update":
  120. UpdateChemAuditResult();
  121. break;
  122. case "Delete":
  123. DeleteChemAuditResult();
  124. break;
  125. case "Select_Temp":
  126. QueryCheckConsignChemDetailInfo_Temp();
  127. break;
  128. case "Check":
  129. CheckIsValid();
  130. break;
  131. case"Audit":
  132. auditHxData();
  133. break;
  134. case "Print":
  135. RepLimsOutdecChemResultQuote();
  136. break;
  137. case "Close":
  138. if (MessageUtil.ShowYesNoAndQuestion("是否确认关闭页面?") == DialogResult.Yes)
  139. {
  140. this.Close();
  141. }
  142. break;
  143. }
  144. }
  145. /// <summary>
  146. /// 查询化学原始记录
  147. /// </summary>
  148. private void doQueryChemDetial()
  149. {
  150. ArrayList al = pipeQueryBase1.GetQueryInfo("45");
  151. List<PipeCheckconsignDetailEntity> listSource = EntityHelper.GetData<PipeCheckconsignDetailEntity>(
  152. "com.steering.lims.data.pipe.FrmChemDataManage.doQueryChemData", new object[] { al }, this.ob);
  153. PipeCheckconsignDetailEntitybindingSource.DataSource = listSource;
  154. }
  155. #region 未处理数据
  156. //查询检验委托加工信息
  157. private void QueryCheckConsignBase()
  158. {
  159. try
  160. {
  161. ArrayList al = pipeQueryBase1.GetQueryInfo("2");
  162. //al.Insert(0, "2");
  163. publicUltraGridBase1.QueryCheckConsignBaseDetail_Distinct("pipe.FrmChemDataManage", al, this.ob, arrId, plineCodes);
  164. if (publicUltraGridBase1.Ur == null || publicUltraGridBase1.Ur.Activated == false)
  165. {
  166. dataTable2.Rows.Clear();
  167. }
  168. }
  169. catch (Exception e)
  170. {
  171. MessageUtil.ShowWarning(e.Message);
  172. return;
  173. }
  174. }
  175. //查询检验委托化学明细信息
  176. private void QueryCheckConsignChemDetailInfo_Temp()
  177. {
  178. try
  179. {
  180. dataTable2.Rows.Clear();
  181. //加入处理元素信息
  182. QueryCheckConsignDetail();
  183. //加入标钢实测值和标准值,需要判断标钢实测值与元素实测值的时间间距不超过限定时间否则无效
  184. QueryChemStdSteelInfo_Temp();
  185. //加入元素实测值
  186. QueryChemProcessResult();
  187. //加入元素标准值
  188. //QueryCheckConsignChemDetail();
  189. }
  190. catch (Exception e)
  191. {
  192. MessageUtil.ShowWarning(e.Message);
  193. return;
  194. }
  195. }
  196. //查询检验委托化学明细信息
  197. private void QueryCheckConsignChemDetailInfo()
  198. {
  199. try
  200. {
  201. dataTable2.Rows.Clear();
  202. //加入处理元素信息
  203. QueryCheckConsignDetail();
  204. //加入标钢实测值和标准值,需要判断标钢实测值与元素实测值的时间间距不超过限定时间否则无效
  205. QueryChemStdSteelInfo();
  206. //加入元素实测值
  207. QueryChemProcessResult();
  208. checkUltraGrid(ultraGrid2);
  209. //加入元素标准值
  210. //QueryCheckConsignChemDetail();
  211. }
  212. catch (Exception e)
  213. {
  214. MessageUtil.ShowWarning(e.Message);
  215. return;
  216. }
  217. }
  218. /// <summary>
  219. /// 检查数据是否满足要求并变色
  220. /// </summary>
  221. private void checkUltraGrid(UltraGrid ug)
  222. {
  223. foreach(UltraGridRow uRow in ug.Rows)
  224. {
  225. string xxflag = "";
  226. string sxflag = "";
  227. int bcIndex = 0;
  228. int xxIndex = 0;
  229. int sxIndex = 0;
  230. if(uRow.Cells["QUOTE_VALUE"].Text.ToString() != "")
  231. {
  232. bcIndex = uRow.Cells["QUOTE_VALUE"].Text.ToString().Length - uRow.Cells["QUOTE_VALUE"].Text.ToString().IndexOf('.') - 1;//报出值小数位数
  233. }
  234. else
  235. {
  236. return;
  237. }
  238. if (uRow.Cells["STDMIN"].Text.ToString() != "")
  239. {
  240. xxflag = "1";
  241. xxIndex = uRow.Cells["STDMIN"].Text.ToString().Length - uRow.Cells["STDMIN"].Text.ToString().IndexOf('.') - 1;//下限值小数位数
  242. }
  243. else
  244. {
  245. xxflag = "0";
  246. }
  247. if (uRow.Cells["STDMAX"].Text.ToString() != "")
  248. {
  249. sxflag = "1";
  250. sxIndex = uRow.Cells["STDMAX"].Text.ToString().Length - uRow.Cells["STDMAX"].Text.ToString().IndexOf('.') - 1;//上限值小数位数
  251. }
  252. else
  253. {
  254. sxflag = "0";
  255. }
  256. if (xxflag == "1" && sxflag == "0")
  257. {
  258. if (bcIndex != xxIndex)
  259. {
  260. uRow.Cells["QUOTE_VALUE"].Appearance.BackColor = Color.Green;
  261. }
  262. }
  263. else if (xxflag == "0" && sxflag == "1")
  264. {
  265. if (bcIndex != sxIndex)
  266. {
  267. uRow.Cells["QUOTE_VALUE"].Appearance.BackColor = Color.Green;
  268. }
  269. }
  270. else if (xxflag == "1" && sxflag == "1")
  271. {
  272. if (bcIndex != sxIndex && bcIndex != xxIndex)
  273. {
  274. uRow.Cells["QUOTE_VALUE"].Appearance.BackColor = Color.Green;
  275. }
  276. }
  277. //判断报出值是否不合
  278. if (uRow.Cells["STDMIN"].Text.ToString() != "" && uRow.Cells["STDMAX"].Text.ToString() != "")
  279. {
  280. if (double.Parse(uRow.Cells["QUOTE_VALUE"].Text.ToString3()) < double.Parse(uRow.Cells["STDMIN"].Text.ToString3()) && double.Parse(uRow.Cells["QUOTE_VALUE"].Text.ToString3()) > double.Parse(uRow.Cells["STDMAX"].Text.ToString3()))
  281. {
  282. uRow.RowSelectorAppearance.BackColor = Color.Red;
  283. }
  284. }
  285. else if (uRow.Cells["STDMIN"].Text.ToString() != "" && uRow.Cells["STDMAX"].Text.ToString() == "")
  286. {
  287. if (double.Parse(uRow.Cells["QUOTE_VALUE"].Text.ToString3()) < double.Parse(uRow.Cells["STDMIN"].Text.ToString3()))
  288. {
  289. uRow.RowSelectorAppearance.BackColor = Color.Red;
  290. }
  291. }
  292. else if (uRow.Cells["STDMIN"].Text.ToString() == "" && uRow.Cells["STDMAX"].Text.ToString() != "")
  293. {
  294. if (double.Parse(uRow.Cells["QUOTE_VALUE"].Text.ToString3()) > double.Parse(uRow.Cells["STDMAX"].Text.ToString3()))
  295. {
  296. uRow.RowSelectorAppearance.BackColor = Color.Red;
  297. }
  298. }
  299. }
  300. }
  301. //查询处理元素信息
  302. private void QueryCheckConsignDetail()
  303. {
  304. string strSAMPLE_NO = publicUltraGridBase1.Ur.Cells["SAMPLE_NO"].Text.Trim();
  305. string strCHECK_NO = publicUltraGridBase1.Ur.Cells["CHECK_NO"].Text.Trim();
  306. //加入处理元素信息
  307. ArrayList alElements = new ArrayList();
  308. alElements.Add(strSAMPLE_NO);
  309. alElements.Add(strSAMPLE_NO);
  310. alElements.Add(strSAMPLE_NO);
  311. alElements.Add(strCHECK_NO);
  312. DataTable dtDetail = PublicServer.GetData("com.steering.lims.data.pipe.FrmChemDataManage.QueryCheckConsignChemDetail",
  313. new Object[] { alElements }, ob);
  314. if (dtDetail == null || dtDetail.Rows.Count == 0)
  315. {
  316. return;
  317. }
  318. DataRow dr;
  319. DataRow[] arrDr;
  320. foreach (string strChem in PublicPipeAndOutdec.chemMin.Split(' '))
  321. {
  322. arrDr = dtDetail.Select("CHEM_NAME = '" + strChem + "'");
  323. if (arrDr.Length > 0)
  324. {
  325. dr = dataTable2.NewRow();
  326. dr["CHEM_NAME"] = strChem;
  327. dr["STDMIN"] = arrDr[0]["STDMIN"];
  328. dr["STDMAX"] = arrDr[0]["STDMAX"];
  329. dr["AUDIT_VALUE"] = arrDr[0]["AUDIT_VALUE"];//C\S要赋值审核值、人工录入
  330. dr["QUOTE_VALUE"] = arrDr[0]["AUDIT_VALUE"];
  331. dataTable2.Rows.Add(dr);
  332. //dr["AUDIT_PROCESS"]
  333. }
  334. }
  335. foreach (UltraGridRow ur in ultraGrid2.Rows)
  336. {
  337. if (ur.Cells["CHEM_NAME"].Text.Trim() == "C" || ur.Cells["CHEM_NAME"].Text.Trim() == "S")
  338. {
  339. ur.Cells["AUDIT_VALUE"].Activation = Activation.AllowEdit;
  340. }
  341. else
  342. {
  343. ur.Cells["AUDIT_VALUE"].Activation = Activation.ActivateOnly;
  344. }
  345. }
  346. PublicPipeAndOutdec.RefreshAndAutoSizeColumns(ultraGrid2, arrColumnsBase, true);
  347. }
  348. //查询标钢修约信息
  349. private void QueryChemStdSteelInfo()
  350. {
  351. string strSTEEL_NO = publicUltraGridBase1.Ur.Cells["STEEL_NO"].Text.Trim().ToUpper();
  352. //加入标钢信息
  353. ArrayList alElements = new ArrayList();
  354. alElements.Add(strSTEEL_NO);
  355. alElements.Add(strSTEEL_NO);
  356. //alElements.Add(txtVALID_TIME.Text.Trim());
  357. DataTable dtStdSteel = PublicServer.GetData("com.steering.lims.data.pipe.FrmChemDataManage.QueryChemStdSteelInfo",
  358. new Object[] { alElements }, ob);
  359. if (dtStdSteel == null || dtStdSteel.Rows.Count == 0)
  360. {
  361. return;
  362. }
  363. string strPro;
  364. string strStd;
  365. foreach (DataRow dr in dataTable2.Rows)
  366. {
  367. foreach (DataRow drStd in dtStdSteel.Rows)
  368. {
  369. //&& drStd["SEL_ANA_" + dr["CHEM_NAME"].ToString().ToUpper()].ToString() == "1"
  370. if (dtStdSteel.Columns.Contains("SEL_ANA_" + dr["CHEM_NAME"].ToString().ToUpper()) == true && drStd["SEL_ANA_" + dr["CHEM_NAME"].ToString().ToUpper()].ToString() == "1")
  371. {
  372. //如果没有修约规则但是有实测值要显示出来
  373. dr["SELECT_STEEL_NO"] = drStd["SELECT_STEEL_NO"].ToString();
  374. strStd = drStd["STD_ANA_" + dr["CHEM_NAME"].ToString().ToUpper()].ToString();//标钢标准值
  375. strPro = drStd["PRO_ANA_" + dr["CHEM_NAME"].ToString().ToUpper()].ToString();//标钢过程值
  376. try
  377. {
  378. dr["STD_STEEL_STD_VALUE"] = strStd;
  379. dr["STD_STEEL_PROCESS_VALUE"] = strPro;
  380. decimal pro = Convert.ToDecimal(strPro != "" ? strPro : "0");
  381. decimal std = Convert.ToDecimal(strStd != "" ? strStd : "0");
  382. if (std == 0 && pro == 0)
  383. {
  384. dr["ROUND_VALUE"] = "";
  385. }
  386. else
  387. {
  388. dr["ROUND_VALUE"] = std - pro;
  389. }
  390. }
  391. catch
  392. {
  393. break;
  394. }
  395. break;
  396. }
  397. else if (dtStdSteel.Columns.Contains("SEL_ANA_" + dr["CHEM_NAME"].ToString().ToUpper()) == true && drStd["SEL_ANA_" + dr["CHEM_NAME"].ToString().ToUpper()].ToString() == "0")
  398. {
  399. strPro = drStd["PRO_ANA_" + dr["CHEM_NAME"].ToString().ToUpper()].ToString();//标钢过程值
  400. dr["STD_STEEL_PROCESS_VALUE"] = strPro;
  401. dr["ROUND_VALUE"] = "";
  402. }
  403. }
  404. }
  405. }
  406. //查询标钢修约信息
  407. private void QueryChemStdSteelInfo_Temp()
  408. {
  409. string strSTEEL_NO = publicUltraGridBase1.Ur.Cells["CHECK_NO"].Text.Trim().ToUpper();
  410. //加入标钢信息
  411. ArrayList alElements = new ArrayList();
  412. alElements.Add(strSTEEL_NO);
  413. DataTable dtStdSteel = PublicServer.GetData("com.steering.lims.data.outdec.FrmOutdecChemDataManage.QueryChemStdSteelInfo_Temp",
  414. new Object[] { alElements }, ob);
  415. if (dtStdSteel == null || dtStdSteel.Rows.Count == 0)
  416. {
  417. return;
  418. }
  419. string strPro;
  420. string strStd;
  421. foreach (DataRow dr in dataTable2.Rows)
  422. {
  423. foreach (DataRow drStd in dtStdSteel.Rows)
  424. {
  425. if (dtStdSteel.Columns.Contains("SEL_ANA_" + dr["CHEM_NAME"].ToString().ToUpper()) == true && drStd["SEL_ANA_" + dr["CHEM_NAME"].ToString().ToUpper()].ToString() == "1")
  426. {
  427. dr["SELECT_STEEL_NO"] = drStd["SELECT_STEEL_NO"].ToString();
  428. strStd = drStd["STD_ANA_" + dr["CHEM_NAME"].ToString().ToUpper()].ToString();//标钢标准值
  429. strPro = drStd["PRO_ANA_" + dr["CHEM_NAME"].ToString().ToUpper()].ToString();//标钢过程值
  430. try
  431. {
  432. dr["STD_STEEL_STD_VALUE"] = strStd;
  433. dr["STD_STEEL_PROCESS_VALUE"] = strPro;
  434. decimal pro = Convert.ToDecimal(strPro != "" ? strPro : "0");
  435. decimal std = Convert.ToDecimal(strStd != "" ? strStd : "0");
  436. if (std == 0 && pro == 0)
  437. {
  438. dr["ROUND_VALUE"] = "";
  439. }
  440. else
  441. {
  442. dr["ROUND_VALUE"] = std - pro;
  443. }
  444. }
  445. catch
  446. {
  447. break;
  448. }
  449. break;
  450. }
  451. }
  452. }
  453. }
  454. //查询化学实测值
  455. private void QueryChemProcessResult()
  456. {
  457. //加入元素实测值
  458. string strSAMPLE_NO = publicUltraGridBase1.Ur.Cells["SAMPLE_NO"].Text.Trim();
  459. string strCHECK_NO = publicUltraGridBase1.Ur.Cells["CHECK_NO"].Text.Trim();
  460. ArrayList alElements = new ArrayList();
  461. alElements.Add(strSAMPLE_NO);
  462. alElements.Add(strSAMPLE_NO);
  463. alElements.Add(strSAMPLE_NO);
  464. alElements.Add(strCHECK_NO);
  465. DataTable dtDetail = PublicServer.GetData("com.steering.lims.data.pipe.FrmChemDataManage.QueryChemProcessResult",
  466. new Object[] { alElements }, ob);
  467. if (dtDetail == null || dtDetail.Rows.Count == 0)
  468. {
  469. return;
  470. }
  471. foreach (DataRow dr in dataTable2.Rows)
  472. {
  473. foreach (DataRow drDetail in dtDetail.Rows)
  474. {
  475. if (dtDetail.Columns.Contains("ANA_" + dr["CHEM_NAME"].ToString().ToUpper()) == true)
  476. {
  477. try
  478. {
  479. decimal round = Convert.ToDecimal(dr["ROUND_VALUE"].ToString() != "" ? dr["ROUND_VALUE"].ToString() : "0");//标钢修约值
  480. string strPro = drDetail["ANA_" + dr["CHEM_NAME"].ToString().ToUpper()].ToString();
  481. decimal process = Convert.ToDecimal(strPro != "" ? strPro : "0");//过程值
  482. dr["PROCESS_VALUE"] = strPro;//加入采集值
  483. if (dr["CHEM_NAME"].ToString() != "C" && dr["CHEM_NAME"].ToString() != "S")//CS结果从CS录入界面传过来
  484. {
  485. if (strPro == "")//采集值为空, 处理值也为空
  486. {
  487. dr["AUDIT_VALUE"] = "";
  488. dr["QUOTE_VALUE"] = "";
  489. }
  490. else
  491. {
  492. //if (dr["CHEM_NAME"].ToString() == "C" || dr["CHEM_NAME"].ToString() == "S")
  493. //{
  494. // dr["AUDIT_VALUE"] = strPro;
  495. // dr["QUOTE_VALUE"] = strPro;
  496. //}
  497. //else
  498. //{
  499. dr["AUDIT_VALUE"] = round + process;
  500. dr["QUOTE_VALUE"] = round + process;
  501. //}
  502. }
  503. }
  504. else
  505. {
  506. if (dr["AUDIT_VALUE"].ToString() == "")
  507. {
  508. dr["AUDIT_VALUE"] = strPro;
  509. dr["QUOTE_VALUE"] = strPro;
  510. }
  511. }
  512. }
  513. catch
  514. {
  515. //continue;
  516. }
  517. }
  518. break;
  519. }
  520. }
  521. }
  522. //检查是否有效
  523. private void CheckIsValid()
  524. {
  525. try
  526. {
  527. //检查修约规则
  528. //先判断是否选择了标钢
  529. ultraGrid2.UpdateData();
  530. foreach (DataRow dr in dataTable2.Rows)
  531. {
  532. if (dr["CHEM_NAME"].ToString() != "C" && dr["CHEM_NAME"].ToString() != "S")
  533. {
  534. if (dr["SELECT_STEEL_NO"].ToString() == "")
  535. {
  536. MessageUtil.ShowTips(dr["CHEM_NAME"].ToString() + "没有对应的修约规则!");
  537. return;
  538. }
  539. if (dr["STD_STEEL_STD_VALUE"].ToString() == "")
  540. {
  541. MessageUtil.ShowTips("标钢" + dr["SELECT_STEEL_NO"].ToString() + "的元素" + dr["CHEM_NAME"].ToString() + "没有维护标准值!");
  542. return;
  543. }
  544. }
  545. //判断元素下含量的界限值是否超标
  546. DataTable ds = PublicServer.GetData("com.steering.lims.data.pipe.FrmChemDataManage.doQueryElementBoundary", new object[] { dr["CHEM_NAME"].ToString(), dr["STD_STEEL_STD_VALUE"].ToString() }, ob);
  547. if (ds.Rows.Count > 0)
  548. {
  549. if (double.Parse(dr["ROUND_VALUE"].ToString()) > double.Parse(ds.Rows[0]["BOUNDARY_VALUE"].ToString()))
  550. {
  551. MessageUtil.ShowTips("元素" + dr["CHEM_NAME"].ToString() + "修约值超出了标钢修约值界限值!");
  552. return;
  553. }
  554. }
  555. else
  556. {
  557. MessageUtil.ShowTips("元素" + dr["CHEM_NAME"].ToString()+"未维护修约值界限值,无法检查!");
  558. return;
  559. }
  560. }
  561. }
  562. catch
  563. {
  564. }
  565. }
  566. //保存审核结果
  567. private void AddChemAuditResult()
  568. {
  569. try
  570. {
  571. if (dataTable2 == null || dataTable2.Rows.Count == 0)
  572. {
  573. return;
  574. }
  575. if (ultraTabControl1.SelectedTab.Index != 0)
  576. {
  577. MessageUtil.ShowWarning("只有在未处理数据页才能进行新增操作!");
  578. return;
  579. }
  580. if (publicUltraGridBase1.Ur == null || publicUltraGridBase1.Ur.Activated == false)
  581. {
  582. MessageUtil.ShowWarning("请选择需要新增的试样信息!");
  583. return;
  584. }
  585. //string strAddChem = CheckIsValid();
  586. //if (strAddChem != "")
  587. //{
  588. // MessageUtil.ShowWarning(strAddChem);
  589. // return;
  590. //}
  591. //先判断状态位
  592. if (MessageUtil.ShowYesNoAndQuestion("是否确认新增?") == DialogResult.Yes)
  593. {
  594. string strTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
  595. string strSAMPLE_NO = publicUltraGridBase1.Ur.Cells["SAMPLE_NO"].Text.Trim();
  596. string strCHECK_NO = publicUltraGridBase1.Ur.Cells["CHECK_NO"].Text.Trim();
  597. ArrayList alAll = new ArrayList();
  598. ArrayList alDetail = new ArrayList();//检验信息详细表list
  599. ArrayList alDetailParams = new ArrayList();//检验信息详细表list
  600. alDetailParams.Add(publicDataCJBase1.StrTemp);
  601. alDetailParams.Add(publicDataCJBase1.StrDevice_No);
  602. alDetailParams.Add(publicDataCJBase1.StrDevice_Name);
  603. alDetailParams.Add(publicDataCJBase1.StrRemark);
  604. alDetailParams.Add(publicDataCJBase1.StrShift == "" ? UserInfo.GetUserOrderText() : publicDataCJBase1.StrShift);//班次
  605. alDetailParams.Add(publicDataCJBase1.StrClass == "" ? UserInfo.GetUserGroupText() : publicDataCJBase1.StrClass);//班组
  606. alDetailParams.Add(UserInfo.GetUserName());//录入人
  607. alDetailParams.Add(strTime);//录入时间
  608. alDetailParams.Add(UserInfo.GetUserName());//审核人
  609. alDetailParams.Add(strTime);//审核时间
  610. alDetailParams.Add("3");//录入标志位改为审核标志位
  611. alDetailParams.Add("2");
  612. alDetailParams.Add("HX");
  613. alDetailParams.Add(strSAMPLE_NO);
  614. alDetailParams.Add(strCHECK_NO);
  615. alDetail.Add(alDetailParams);
  616. ArrayList alProcessResult = new ArrayList();//化学信息list
  617. ArrayList alProcessResultParams = new ArrayList();//化学信息list
  618. ultraGrid2.UpdateData();
  619. foreach (DataRow dr in dataTable2.Rows)
  620. {
  621. alProcessResultParams = new ArrayList();
  622. alProcessResultParams.Add(dr["SELECT_STEEL_NO"].ToString());
  623. alProcessResultParams.Add(dr["STD_STEEL_STD_VALUE"].ToString());
  624. alProcessResultParams.Add(dr["STD_STEEL_PROCESS_VALUE"].ToString());
  625. alProcessResultParams.Add(dr["ROUND_VALUE"].ToString());
  626. alProcessResultParams.Add(dr["PROCESS_VALUE"].ToString());
  627. alProcessResultParams.Add(dr["AUDIT_VALUE"].ToString());
  628. alProcessResultParams.Add(dr["QUOTE_VALUE"].ToString());
  629. alProcessResultParams.Add(dr["CHEM_NAME"].ToString());
  630. alProcessResultParams.Add(strSAMPLE_NO);
  631. alProcessResultParams.Add(strCHECK_NO);
  632. alProcessResult.Add(alProcessResultParams);
  633. }
  634. alAll.Add(alDetail);
  635. alAll.Add(alProcessResult);
  636. PublicServer.SetData("com.steering.lims.data.pipe.FrmChemDataManage.AddChemAuditResult",
  637. new Object[] { alAll }, this.ob);
  638. QueryCheckConsignBase();
  639. //QueryCheckConsignBase_LOG();
  640. PublicPipeAndOutdec.ActiveOperateRow(publicUltraGridBase2.Ug, new string[] { "CHECK_NO", "SAMPLE_NO" }, new string[] { strCHECK_NO, strSAMPLE_NO });
  641. MessageUtil.ShowTips("新增成功!");
  642. }
  643. }
  644. catch (Exception e)
  645. {
  646. MessageUtil.ShowWarning(e.Message);
  647. }
  648. }
  649. /// <summary>
  650. /// 审核
  651. /// </summary>
  652. private void auditHxData()
  653. {
  654. UltraGridRow row = this.publicUltraGridBase2.Ug.ActiveRow;
  655. if (row == null)
  656. {
  657. return;
  658. }
  659. string checkNo = row.Cells["CHECK_NO"].Text.ToString();
  660. string sampleNo = row.Cells["SAMPLE_NO"].Text.ToString();
  661. ArrayList list = new ArrayList();
  662. list.Add(checkNo);
  663. list.Add(sampleNo);
  664. CoreClientParam ccp = new CoreClientParam();
  665. ccp.ServerName = "com.steering.lims.data.pipe.FrmChemDataManage";
  666. ccp.MethodName = "auditHxData";
  667. ccp.ServerParams = new object[] { list };
  668. ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  669. if (ccp.ReturnCode != -1)
  670. {
  671. if (ccp.ReturnInfo.Equals("审核成功!"))
  672. {
  673. QueryCheckConsignBase_LOG();
  674. MessageUtil.ShowTips(ccp.ReturnInfo);
  675. }
  676. else
  677. {
  678. MessageUtil.ShowTips(ccp.ReturnInfo);
  679. }
  680. }
  681. }
  682. private void btnSelect_Temp_Click(object sender, EventArgs e)
  683. {
  684. if (publicUltraGridBase1.Ur == null || publicUltraGridBase1.Ur.Activated == false)
  685. {
  686. MessageUtil.ShowWarning("请选择需要选择临时标钢修约规则的试样信息!");
  687. return;
  688. }
  689. WinBaseChemStdSteelSelect_Temp pc = new WinBaseChemStdSteelSelect_Temp(this.ob);
  690. pc.StrCHECK_NO = publicUltraGridBase1.Ur.Cells["CHECK_NO"].Text.Trim();
  691. pc.StrSAMPLE_NAME = publicUltraGridBase1.Ur.Cells["SAMPLE_NAME"].Text.Trim();
  692. pc.StrSTEEL_NO = publicUltraGridBase1.Ur.Cells["STEEL_GRADE_NO"].Text.Trim();
  693. pc.ShowDialog();
  694. }
  695. #endregion
  696. #region 已处理数据
  697. //查询检验委托加工信息
  698. private void QueryCheckConsignBase_LOG()
  699. {
  700. try
  701. {
  702. ArrayList al = pipeQueryBase1.GetQueryInfo("345");
  703. publicUltraGridBase2.QueryCheckConsignBaseDetail_Distinct("pipe.FrmChemDataManage", al, this.ob, arrId, plineCodes);
  704. if (publicUltraGridBase2.Ur == null || publicUltraGridBase2.Ur.Activated == false)
  705. {
  706. dataTable4.Rows.Clear();
  707. }
  708. }
  709. catch (Exception e)
  710. {
  711. MessageUtil.ShowWarning(e.Message);
  712. return;
  713. }
  714. }
  715. //查询检验委托化学明细信息
  716. private void QueryCheckConsignChemDetailInfo_LOG()
  717. {
  718. try
  719. {
  720. dataTable4.Rows.Clear();
  721. //加入元素实测值
  722. string strSAMPLE_NO = publicUltraGridBase2.Ur.Cells["SAMPLE_NO"].Text.Trim();
  723. string strCHECK_NO = publicUltraGridBase2.Ur.Cells["CHECK_NO"].Text.Trim();
  724. ArrayList alElements = new ArrayList();
  725. alElements.Add(strSAMPLE_NO);
  726. alElements.Add(strSAMPLE_NO);
  727. alElements.Add(strSAMPLE_NO);
  728. alElements.Add(strCHECK_NO);
  729. DataTable dtDetail = PublicServer.GetData("com.steering.lims.data.pipe.FrmChemDataManage.QueryCheckConsignChemDetail",
  730. new Object[] { alElements }, ob);
  731. if (dtDetail == null || dtDetail.Rows.Count == 0)
  732. {
  733. return;
  734. }
  735. DataRow[] arrDr;
  736. foreach (string strChem in PublicPipeAndOutdec.chemMin.Split(' '))
  737. {
  738. arrDr = dtDetail.Select("CHEM_NAME = '" + strChem + "'");
  739. if (arrDr != null && arrDr.Length == 1)
  740. {
  741. dataTable4.ImportRow(arrDr[0]);
  742. }
  743. }
  744. //foreach (UltraGridRow ur in ultraGrid4.Rows)
  745. //{
  746. // if (ur.Cells["CHEM_NAME"].Text.Trim() == "C" || ur.Cells["CHEM_NAME"].Text.Trim() == "S")
  747. // {
  748. // ur.Cells["AUDIT_VALUE"].Activation = Activation.AllowEdit;
  749. // }
  750. // else
  751. // {
  752. // ur.Cells["AUDIT_VALUE"].Activation = Activation.ActivateOnly;
  753. // }
  754. //}
  755. checkUltraGrid(ultraGrid4);
  756. }
  757. catch (Exception e)
  758. {
  759. MessageUtil.ShowWarning(e.Message);
  760. return;
  761. }
  762. }
  763. //修改结果
  764. private void UpdateChemAuditResult()
  765. {
  766. try
  767. {
  768. if (ultraTabControl1.SelectedTab.Index != 1)
  769. {
  770. MessageUtil.ShowWarning("只有在已处理数据页才能进行修改操作!");
  771. return;
  772. }
  773. if (publicUltraGridBase2.Ur == null || publicUltraGridBase2.Ur.Activated == false)
  774. {
  775. MessageUtil.ShowWarning("请选择需要修改的试样信息!");
  776. return;
  777. }
  778. if (dataTable4 == null || dataTable4.Rows.Count == 0)
  779. {
  780. return;
  781. }
  782. //先修改状态位
  783. if (MessageUtil.ShowYesNoAndQuestion("是否确认修改?") == DialogResult.Yes)
  784. {
  785. string strTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
  786. string strSAMPLE_NO = publicUltraGridBase2.Ur.Cells["SAMPLE_NO"].Text.Trim();
  787. string strCHECK_NO = publicUltraGridBase2.Ur.Cells["CHECK_NO"].Text.Trim();
  788. ArrayList alIs = new ArrayList();
  789. alIs.Add(strSAMPLE_NO);
  790. alIs.Add(strCHECK_NO);
  791. ArrayList alAll = new ArrayList();
  792. ArrayList alDetail = new ArrayList();//检验信息详细表list
  793. ArrayList alDetailParams = new ArrayList();//检验信息详细表list
  794. //删除基础信息都置为空
  795. alDetailParams.Add("");
  796. alDetailParams.Add("");
  797. alDetailParams.Add("");
  798. alDetailParams.Add("");
  799. alDetailParams.Add(UserInfo.GetUserGroupText());//班组
  800. alDetailParams.Add(UserInfo.GetUserName());//录入人
  801. alDetailParams.Add(strTime);//录入时间
  802. alDetailParams.Add("4");//录入标志位
  803. alDetailParams.Add("4");
  804. alDetailParams.Add("HX");
  805. alDetailParams.Add(strSAMPLE_NO);
  806. alDetailParams.Add(strCHECK_NO);
  807. alDetail.Add(alDetailParams);
  808. ArrayList alProcessResult = new ArrayList();//化学信息list
  809. ArrayList alProcessResultParams = new ArrayList();//化学信息list
  810. ultraGrid4.UpdateData();
  811. foreach (DataRow dr in dataTable4.Rows)
  812. {
  813. alProcessResultParams = new ArrayList();
  814. alProcessResultParams.Add(dr["SELECT_STEEL_NO"].ToString());
  815. alProcessResultParams.Add(dr["STD_STEEL_STD_VALUE"].ToString());
  816. alProcessResultParams.Add(dr["STD_STEEL_PROCESS_VALUE"].ToString());
  817. alProcessResultParams.Add(dr["ROUND_VALUE"].ToString());
  818. alProcessResultParams.Add(dr["PROCESS_VALUE"].ToString());
  819. alProcessResultParams.Add(dr["AUDIT_VALUE"].ToString());
  820. alProcessResultParams.Add(dr["QUOTE_VALUE"].ToString());
  821. alProcessResultParams.Add(dr["CHEM_NAME"].ToString());
  822. alProcessResultParams.Add(strSAMPLE_NO);
  823. alProcessResultParams.Add(strCHECK_NO);
  824. alProcessResult.Add(alProcessResultParams);
  825. }
  826. alAll.Add(alDetail);
  827. alAll.Add(alProcessResult);
  828. PublicServer.SetData("com.steering.lims.data.pipe.FrmChemDataManage.UpdateChemAuditResult",
  829. new Object[] { alIs, alAll }, this.ob);
  830. QueryCheckConsignBase_LOG();
  831. //QueryCheckConsignBase();
  832. PublicPipeAndOutdec.ActiveOperateRow(publicUltraGridBase2.Ug, new string[] { "CHECK_NO", "SAMPLE_NO" }, new string[] { strCHECK_NO, strSAMPLE_NO });
  833. MessageUtil.ShowTips("修改成功!");
  834. }
  835. }
  836. catch (Exception e)
  837. {
  838. MessageUtil.ShowWarning(e.Message);
  839. }
  840. }
  841. //删除结果
  842. private void DeleteChemAuditResult()
  843. {
  844. try
  845. {
  846. if (ultraTabControl1.SelectedTab.Index != 1)
  847. {
  848. MessageUtil.ShowWarning("只有在已处理数据页才能进行删除操作!");
  849. return;
  850. }
  851. if (publicUltraGridBase2.Ur == null || publicUltraGridBase2.Ur.Activated == false)
  852. {
  853. MessageUtil.ShowWarning("请选择需要删除的试样信息!");
  854. return;
  855. }
  856. if (dataTable4 == null || dataTable4.Rows.Count == 0)
  857. {
  858. return;
  859. }
  860. //先修改状态位
  861. if (MessageUtil.ShowYesNoAndQuestion("是否确认删除?") == DialogResult.Yes)
  862. {
  863. //string strTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
  864. string strSAMPLE_NO = publicUltraGridBase2.Ur.Cells["SAMPLE_NO"].Text.Trim();
  865. string strCHECK_NO = publicUltraGridBase2.Ur.Cells["CHECK_NO"].Text.Trim();
  866. ArrayList alIs = new ArrayList();
  867. alIs.Add(strSAMPLE_NO);
  868. alIs.Add(strCHECK_NO);
  869. ArrayList alAll = new ArrayList();
  870. ArrayList alDetail = new ArrayList();//检验信息详细表list
  871. ArrayList alDetailParams = new ArrayList();//检验信息详细表list
  872. //删除基础信息都置为空
  873. alDetailParams.Add("");
  874. alDetailParams.Add("");
  875. alDetailParams.Add("");
  876. alDetailParams.Add("");
  877. alDetailParams.Add("");
  878. alDetailParams.Add("");//班组
  879. alDetailParams.Add("");//录入人
  880. alDetailParams.Add("");//录入时间
  881. alDetailParams.Add("");//审核人
  882. alDetailParams.Add("");//审核时间
  883. alDetailParams.Add("2");//录入标志位
  884. alDetailParams.Add("3");
  885. alDetailParams.Add("HX");
  886. alDetailParams.Add(strSAMPLE_NO);
  887. alDetailParams.Add(strCHECK_NO);
  888. alDetail.Add(alDetailParams);
  889. ArrayList alProcessResult = new ArrayList();//化学信息list
  890. ArrayList alProcessResultParams = new ArrayList();//化学信息list
  891. ultraGrid4.UpdateData();
  892. foreach (DataRow dr in dataTable4.Rows)
  893. {
  894. alProcessResultParams = new ArrayList();
  895. alProcessResultParams.Add("");
  896. alProcessResultParams.Add("");
  897. alProcessResultParams.Add("");
  898. alProcessResultParams.Add("");
  899. alProcessResultParams.Add("");
  900. alProcessResultParams.Add("");
  901. alProcessResultParams.Add("");
  902. alProcessResultParams.Add(dr["CHEM_NAME"].ToString());
  903. alProcessResultParams.Add(strSAMPLE_NO);
  904. alProcessResultParams.Add(strCHECK_NO);
  905. alProcessResult.Add(alProcessResultParams);
  906. }
  907. alAll.Add(alDetail);
  908. alAll.Add(alProcessResult);
  909. PublicServer.SetData("com.steering.lims.data.pipe.FrmChemDataManage.DeleteChemAuditResult",
  910. new Object[] { alIs, alAll }, this.ob);
  911. QueryCheckConsignBase_LOG();
  912. QueryCheckConsignBase();
  913. PublicPipeAndOutdec.ActiveOperateRow(publicUltraGridBase2.Ug, new string[] { "CHECK_NO", "SAMPLE_NO" }, new string[] { strCHECK_NO, strSAMPLE_NO });
  914. MessageUtil.ShowTips("删除成功!");
  915. }
  916. }
  917. catch (Exception e)
  918. {
  919. MessageUtil.ShowWarning(e.Message);
  920. }
  921. }
  922. #endregion
  923. private void RepLimsOutdecChemResultQuery()
  924. {
  925. try
  926. {
  927. ArrayList arrayList = pipeQueryBase1.GetQueryInfo();
  928. string strurl = "";
  929. //if (ob.MainUrl.StartsWith("http://127.0.0.1"))
  930. //{
  931. // strurl = "http://localhost:8075/webroot/decision/view/report?viewlet=RepLimsOutdecChemResultQuery.cpt&bypagesize=false" + "&START_DATE=" + arrayList[0].ToString() + "&END_DATE=" + arrayList[1].ToString() + "&STEEL_GRADE_NO=" + arrayList[2].ToString() + "&SAMPLE_NAME=" + arrayList[5].ToString() + "&CHECK_NO=" + arrayList[8].ToString();
  932. //}
  933. //else
  934. //{
  935. strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepLimsOutdecChemResultQuery.cpt&bypagesize=false" + "&START_DATE=" + arrayList[0].ToString() + "&END_DATE=" + arrayList[1].ToString() + "&STEEL_GRADE_NO=" + arrayList[2].ToString() + "&SAMPLE_NAME=" + arrayList[5].ToString() + "&CHECK_NO=" + arrayList[8].ToString();
  936. //}
  937. //webBrowser1.Url = new Uri(strurl);
  938. //this.webBrowser1.ScriptErrorsSuppressed = true;//屏蔽脚本错误
  939. }
  940. finally
  941. {
  942. this.Cursor = Cursors.Default;
  943. }
  944. }
  945. private void RepLimsOutdecChemResultQuote()
  946. {
  947. try
  948. {
  949. if (ultraTabControl1.SelectedTab.Index != 1)
  950. {
  951. MessageUtil.ShowTips("只有选择了已处理数据页才能进行打印操作!");
  952. return;
  953. }
  954. this.Cursor = Cursors.WaitCursor;
  955. UltraGridRow ugr = publicUltraGridBase2.Ur;
  956. if (ugr == null)
  957. {
  958. MessageUtil.ShowWarning("请选择您要打印的报告单!");
  959. return;
  960. }
  961. string strCHECK_NO = ugr.Cells["CHECK_NO"].Value.ToString();
  962. string strurl = "";
  963. //if (ob.MainUrl.StartsWith("http://127.0.0.1"))
  964. //{
  965. // strurl = "http://localhost:8075/webroot/decision/view/report?viewlet=RepLimsOutdecChemResultQuote.cpt&bypagesize=false" + "&CHECK_NO=" + strCHECK_NO;
  966. //}
  967. //else
  968. //{
  969. strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepPipeChemAnalysisReport.cpt&bypagesize=false" + "&CHECK_NO=" + strCHECK_NO;
  970. //}
  971. FrmRepExcel fBug = new FrmRepExcel(ob, strurl);
  972. fBug.AutoSize = true;
  973. fBug.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height);
  974. fBug.WindowState = FormWindowState.Maximized;
  975. fBug.Text = "化学成分报告单";
  976. fBug.Show();
  977. }
  978. finally
  979. {
  980. this.Cursor = Cursors.Default;
  981. }
  982. }
  983. private void FrmOutdecChemDataManage_Shown(object sender, EventArgs e)
  984. {
  985. if (toolMenu == null) return;
  986. if (ultraTabControl1.SelectedTab.Index == 0)
  987. {
  988. if (toolMenu.Toolbars[0].Tools.Exists("Add"))
  989. {
  990. toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.True;
  991. }
  992. if (toolMenu.Toolbars[0].Tools.Exists("Update"))
  993. {
  994. this.toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.False;
  995. }
  996. if (toolMenu.Toolbars[0].Tools.Exists("Delete"))
  997. {
  998. toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.False;
  999. }
  1000. if (toolMenu.Toolbars[0].Tools.Exists("UpdateXY"))
  1001. {
  1002. toolMenu.Toolbars[0].Tools["UpdateXY"].InstanceProps.Visible = DefaultableBoolean.False;
  1003. }
  1004. if (toolMenu.Toolbars[0].Tools.Exists("Select_Temp"))
  1005. {
  1006. toolMenu.Toolbars[0].Tools["Select_Temp"].InstanceProps.Visible = DefaultableBoolean.False;
  1007. }
  1008. if (toolMenu.Toolbars[0].Tools.Exists("Check"))
  1009. {
  1010. toolMenu.Toolbars[0].Tools["Check"].InstanceProps.Visible = DefaultableBoolean.True;
  1011. }
  1012. if (toolMenu.Toolbars[0].Tools.Exists("Audit"))
  1013. {
  1014. toolMenu.Toolbars[0].Tools["Audit"].InstanceProps.Visible = DefaultableBoolean.False;
  1015. }
  1016. if (toolMenu.Toolbars[0].Tools.Exists("Print"))
  1017. {
  1018. toolMenu.Toolbars[0].Tools["Print"].InstanceProps.Visible = DefaultableBoolean.False;
  1019. }
  1020. }
  1021. else if (ultraTabControl1.SelectedTab.Index == 1)
  1022. {
  1023. if (toolMenu.Toolbars[0].Tools.Exists("Add"))
  1024. {
  1025. toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.False;
  1026. }
  1027. if (toolMenu.Toolbars[0].Tools.Exists("Update"))
  1028. {
  1029. this.toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.False;
  1030. }
  1031. if (toolMenu.Toolbars[0].Tools.Exists("Delete"))
  1032. {
  1033. toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.True;
  1034. }
  1035. if (toolMenu.Toolbars[0].Tools.Exists("UpdateXY"))
  1036. {
  1037. toolMenu.Toolbars[0].Tools["UpdateXY"].InstanceProps.Visible = DefaultableBoolean.False;
  1038. }
  1039. if (toolMenu.Toolbars[0].Tools.Exists("Select_Temp"))
  1040. {
  1041. toolMenu.Toolbars[0].Tools["Select_Temp"].InstanceProps.Visible = DefaultableBoolean.False;
  1042. }
  1043. if (toolMenu.Toolbars[0].Tools.Exists("Check"))
  1044. {
  1045. toolMenu.Toolbars[0].Tools["Check"].InstanceProps.Visible = DefaultableBoolean.False;
  1046. }
  1047. if (toolMenu.Toolbars[0].Tools.Exists("Print"))
  1048. {
  1049. toolMenu.Toolbars[0].Tools["Print"].InstanceProps.Visible = DefaultableBoolean.True;
  1050. }
  1051. }
  1052. else if (ultraTabControl1.SelectedTab.Index == 2)
  1053. {
  1054. if (toolMenu.Toolbars[0].Tools.Exists("Add"))
  1055. {
  1056. toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.False;
  1057. }
  1058. if (toolMenu.Toolbars[0].Tools.Exists("Update"))
  1059. {
  1060. this.toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.False;
  1061. }
  1062. if (toolMenu.Toolbars[0].Tools.Exists("Delete"))
  1063. {
  1064. toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.False;
  1065. }
  1066. if (toolMenu.Toolbars[0].Tools.Exists("UpdateXY"))
  1067. {
  1068. toolMenu.Toolbars[0].Tools["UpdateXY"].InstanceProps.Visible = DefaultableBoolean.False;
  1069. }
  1070. if (toolMenu.Toolbars[0].Tools.Exists("Select_Temp"))
  1071. {
  1072. toolMenu.Toolbars[0].Tools["Select_Temp"].InstanceProps.Visible = DefaultableBoolean.False;
  1073. }
  1074. if (toolMenu.Toolbars[0].Tools.Exists("Check"))
  1075. {
  1076. toolMenu.Toolbars[0].Tools["Check"].InstanceProps.Visible = DefaultableBoolean.False;
  1077. }
  1078. if (toolMenu.Toolbars[0].Tools.Exists("Print"))
  1079. {
  1080. toolMenu.Toolbars[0].Tools["Print"].InstanceProps.Visible = DefaultableBoolean.False;
  1081. }
  1082. }
  1083. }
  1084. private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
  1085. {
  1086. if (toolMenu == null) return;
  1087. if (ultraTabControl1.SelectedTab.Index == 0)
  1088. {
  1089. if (toolMenu.Toolbars[0].Tools.Exists("Add"))
  1090. {
  1091. toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.True;
  1092. }
  1093. if (toolMenu.Toolbars[0].Tools.Exists("Update"))
  1094. {
  1095. this.toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.False;
  1096. }
  1097. if (toolMenu.Toolbars[0].Tools.Exists("Delete"))
  1098. {
  1099. toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.False;
  1100. }
  1101. if (toolMenu.Toolbars[0].Tools.Exists("UpdateXY"))
  1102. {
  1103. toolMenu.Toolbars[0].Tools["UpdateXY"].InstanceProps.Visible = DefaultableBoolean.False;
  1104. }
  1105. if (toolMenu.Toolbars[0].Tools.Exists("Select_Temp"))
  1106. {
  1107. toolMenu.Toolbars[0].Tools["Select_Temp"].InstanceProps.Visible = DefaultableBoolean.False;
  1108. }
  1109. if (toolMenu.Toolbars[0].Tools.Exists("Check"))
  1110. {
  1111. toolMenu.Toolbars[0].Tools["Check"].InstanceProps.Visible = DefaultableBoolean.True;
  1112. }
  1113. if (toolMenu.Toolbars[0].Tools.Exists("Audit"))
  1114. {
  1115. toolMenu.Toolbars[0].Tools["Audit"].InstanceProps.Visible = DefaultableBoolean.False;
  1116. }
  1117. if (toolMenu.Toolbars[0].Tools.Exists("Print"))
  1118. {
  1119. toolMenu.Toolbars[0].Tools["Print"].InstanceProps.Visible = DefaultableBoolean.False;
  1120. }
  1121. }
  1122. else if (ultraTabControl1.SelectedTab.Index == 1)
  1123. {
  1124. if (toolMenu.Toolbars[0].Tools.Exists("Add"))
  1125. {
  1126. toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.False;
  1127. }
  1128. if (toolMenu.Toolbars[0].Tools.Exists("Update"))
  1129. {
  1130. this.toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.False;
  1131. }
  1132. if (toolMenu.Toolbars[0].Tools.Exists("Delete"))
  1133. {
  1134. toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.True;
  1135. }
  1136. if (toolMenu.Toolbars[0].Tools.Exists("UpdateXY"))
  1137. {
  1138. toolMenu.Toolbars[0].Tools["UpdateXY"].InstanceProps.Visible = DefaultableBoolean.False;
  1139. }
  1140. if (toolMenu.Toolbars[0].Tools.Exists("Select_Temp"))
  1141. {
  1142. toolMenu.Toolbars[0].Tools["Select_Temp"].InstanceProps.Visible = DefaultableBoolean.False;
  1143. }
  1144. if (toolMenu.Toolbars[0].Tools.Exists("Check"))
  1145. {
  1146. toolMenu.Toolbars[0].Tools["Check"].InstanceProps.Visible = DefaultableBoolean.False;
  1147. }
  1148. if (toolMenu.Toolbars[0].Tools.Exists("Audit"))
  1149. {
  1150. toolMenu.Toolbars[0].Tools["Audit"].InstanceProps.Visible = DefaultableBoolean.True;
  1151. }
  1152. if (toolMenu.Toolbars[0].Tools.Exists("Print"))
  1153. {
  1154. toolMenu.Toolbars[0].Tools["Print"].InstanceProps.Visible = DefaultableBoolean.True;
  1155. }
  1156. }
  1157. else if (ultraTabControl1.SelectedTab.Index == 2)
  1158. {
  1159. if (toolMenu.Toolbars[0].Tools.Exists("Add"))
  1160. {
  1161. toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.False;
  1162. }
  1163. if (toolMenu.Toolbars[0].Tools.Exists("Update"))
  1164. {
  1165. this.toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.False;
  1166. }
  1167. if (toolMenu.Toolbars[0].Tools.Exists("Delete"))
  1168. {
  1169. toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.False;
  1170. }
  1171. if (toolMenu.Toolbars[0].Tools.Exists("UpdateXY"))
  1172. {
  1173. toolMenu.Toolbars[0].Tools["UpdateXY"].InstanceProps.Visible = DefaultableBoolean.False;
  1174. }
  1175. if (toolMenu.Toolbars[0].Tools.Exists("Select_Temp"))
  1176. {
  1177. toolMenu.Toolbars[0].Tools["Select_Temp"].InstanceProps.Visible = DefaultableBoolean.False;
  1178. }
  1179. if (toolMenu.Toolbars[0].Tools.Exists("Check"))
  1180. {
  1181. toolMenu.Toolbars[0].Tools["Check"].InstanceProps.Visible = DefaultableBoolean.False;
  1182. }
  1183. if (toolMenu.Toolbars[0].Tools.Exists("Print"))
  1184. {
  1185. toolMenu.Toolbars[0].Tools["Print"].InstanceProps.Visible = DefaultableBoolean.False;
  1186. }
  1187. }
  1188. }
  1189. private void txtVALID_TIME_TextChanged(object sender, EventArgs e)
  1190. {
  1191. //if ((StringUtil.Is_Below_zero(txtVALID_TIME.Text.Trim()) && Double.Parse(txtVALID_TIME.Text.Trim()) > 0) == false)
  1192. //{
  1193. // MessageUtil.ShowTips("有效间隔只能为正数!");
  1194. // txtVALID_TIME.Text = "4";
  1195. // return;
  1196. //}
  1197. }
  1198. }
  1199. }