FrmLabMecHardnessDataCJ.cs 82 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564
  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 System.Collections;
  11. using Core.Mes.Client.Comm.Tool;
  12. using Infragistics.Win.UltraWinGrid;
  13. using Core.Mes.Client.Comm.Control;
  14. using Infragistics.Win;
  15. using System.Threading;
  16. namespace Core.StlMes.Client.Lims.Data.PipeAndOutdec
  17. {
  18. //材料力学硬度采集界面
  19. //读取串口数据回报检验项值 第一象限 内中外 平均值,第二象限 内中外 平均值;第三象限 内中外 平均值 第四象限 内中外 平均值 全壁厚
  20. //采集一条数据之后
  21. public partial class FrmLabMecHardnessDataCJ : FrmBase
  22. {
  23. private string[] arrId;//数据权限
  24. private string[] plineCodes = { };
  25. private DataTable m_dtPhyMax;//存放所有要检验的项目
  26. private DataTable m_dtPhyItems;//存放所有要检验的项目试验方法
  27. private DataTable m_dtPhyMaxAdd;//存放所有已检验的项目
  28. private DataTable m_dtPhyItemsAdd;//存放所有已检验的项目试验方法
  29. private int tabIndex = 0;//保存当前的tab页
  30. public FrmLabMecHardnessDataCJ()
  31. {
  32. InitializeComponent();
  33. }
  34. protected override void OnLoad(EventArgs e)
  35. {
  36. base.OnLoad(e);
  37. //publicUltraGridBase1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头
  38. //publicUltraGridBase2.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头
  39. publicUltraGridBase1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
  40. publicUltraGridBase2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
  41. publicUltraGridDataCJBase1_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头 拉伸
  42. publicUltraGridDataCJBase1_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//
  43. publicUltraGridDataCJBase1_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//
  44. publicUltraGridDataCJBase2_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头
  45. publicUltraGridDataCJBase2_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
  46. publicUltraGridDataCJBase2_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
  47. publicUltraGridDataCJBase3_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
  48. publicUltraGridDataCJBase3_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
  49. publicUltraGridDataCJBase3_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
  50. publicUltraGridDataCJBase4_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
  51. publicUltraGridDataCJBase4_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
  52. publicUltraGridDataCJBase4_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
  53. publicUltraGridDataCJBase5_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
  54. publicUltraGridDataCJBase5_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
  55. publicUltraGridDataCJBase5_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
  56. publicUltraGridDataCJBase6_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
  57. publicUltraGridDataCJBase6_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
  58. publicUltraGridDataCJBase6_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
  59. publicUltraGridDataCJBase7_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头 拉伸
  60. publicUltraGridDataCJBase7_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//
  61. publicUltraGridDataCJBase7_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//
  62. publicUltraGridDataCJBase8_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头
  63. publicUltraGridDataCJBase8_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
  64. publicUltraGridDataCJBase8_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
  65. publicUltraGridDataCJBase9_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
  66. publicUltraGridDataCJBase9_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
  67. publicUltraGridDataCJBase9_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
  68. publicUltraGridDataCJBase10_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
  69. publicUltraGridDataCJBase10_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
  70. publicUltraGridDataCJBase10_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
  71. publicUltraGridDataCJBase11_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
  72. publicUltraGridDataCJBase11_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
  73. publicUltraGridDataCJBase11_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
  74. publicUltraGridDataCJBase12_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
  75. publicUltraGridDataCJBase12_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
  76. publicUltraGridDataCJBase12_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
  77. }
  78. private void FrmLabMecHardnessDataCJ_Load(object sender, EventArgs e)
  79. {
  80. //arrId = this.ValidDataPurviewIds;//获取数据权限
  81. arrId = new string[] { "002001007009", "002023003002" };//力学项目
  82. plineCodes = comm.GetPlineCode(ValidDataPurviewIds, ob);
  83. InitColumns();
  84. }
  85. private void InitColumns()
  86. {
  87. ultraTabControl2.SelectedTab = ultraTabControl2.Tabs[2];
  88. ultraTabControl2.Tabs[2].Appearance.BackColor = Color.GreenYellow;
  89. ultraTabControl3.SelectedTab = ultraTabControl3.Tabs[2];
  90. ultraTabControl3.Tabs[2].Appearance.BackColor = Color.GreenYellow;
  91. pipeShowBase1.ChangeLabel();
  92. pipeShowBase2.ChangeLabel();
  93. //未录入
  94. publicUltraGridBase1.PublicUltraGridBaseActive += new EventHandler(pipeUltraGridBase1_PublicUltraGridBaseActive);//调用委托事件
  95. publicUltraGridBase1.InitColumnsOutdecBase(new string[] { "CHECK_NO", "SAMPLE_NO" }, true, null);
  96. publicUltraGridDataCJBase1_1.InitColumnsPhyConfigItems();
  97. publicUltraGridDataCJBase1_2.InitColumnsOutdecPhyDetail();
  98. publicUltraGridDataCJBase2_1.InitColumnsPhyConfigItems();
  99. publicUltraGridDataCJBase2_2.InitColumnsOutdecPhyDetail();
  100. publicUltraGridDataCJBase3_1.InitColumnsPhyConfigItems();
  101. publicUltraGridDataCJBase3_2.InitColumnsOutdecPhyDetail();
  102. publicUltraGridDataCJBase4_1.InitColumnsPhyConfigItems();
  103. publicUltraGridDataCJBase4_2.InitColumnsOutdecPhyDetail();
  104. publicUltraGridDataCJBase5_1.InitColumnsPhyConfigItems();
  105. publicUltraGridDataCJBase5_2.InitColumnsOutdecPhyDetail();
  106. publicUltraGridDataCJBase6_1.InitColumnsPhyConfigItems();
  107. publicUltraGridDataCJBase6_2.InitColumnsOutdecPhyDetail();
  108. //已录入
  109. publicUltraGridBase2.PublicUltraGridBaseActive += new EventHandler(pipeUltraGridBase2_PublicUltraGridBaseActive);//调用委托事件
  110. publicUltraGridBase2.InitColumnsOutdecBase(new string[] { "CHECK_NO", "SAMPLE_NO" }, true, null);
  111. //publicUltraGridBase2.InitColumns(arrColumnsBase, arrCaptionBase);
  112. //publicUltraGridBase2.setColumnShowOrHidden(new string[] { "CHECK_NO", "SAMPLE_NO", }, true);//显示列
  113. //publicUltraGridBase2.setOtherColumnReadOnly(new string[] { null });//可编辑列
  114. publicUltraGridDataCJBase7_1.InitColumnsPhyConfigItems();
  115. publicUltraGridDataCJBase7_2.InitColumnsOutdecPhyDetail();
  116. publicUltraGridDataCJBase8_1.InitColumnsPhyConfigItems();
  117. publicUltraGridDataCJBase8_2.InitColumnsOutdecPhyDetail();
  118. publicUltraGridDataCJBase9_1.InitColumnsPhyConfigItems();
  119. publicUltraGridDataCJBase9_2.InitColumnsOutdecPhyDetail();
  120. publicUltraGridDataCJBase10_1.InitColumnsPhyConfigItems();
  121. publicUltraGridDataCJBase10_2.InitColumnsOutdecPhyDetail();
  122. publicUltraGridDataCJBase11_1.InitColumnsPhyConfigItems();
  123. publicUltraGridDataCJBase11_2.InitColumnsOutdecPhyDetail();
  124. publicUltraGridDataCJBase12_1.InitColumnsPhyConfigItems();
  125. publicUltraGridDataCJBase12_2.InitColumnsOutdecPhyDetail();
  126. }
  127. /// <summary>
  128. /// 重写基类方法
  129. /// </summary>
  130. /// <param name="sender"></param>
  131. /// <param name="ToolbarKey"></param>
  132. public override void ToolBar_Click(object sender, string ToolbarKey)
  133. {
  134. //查询、确认、退出
  135. switch (ToolbarKey)
  136. {
  137. case "Query":
  138. if (ultraTabControl1.SelectedTab.Index == 0)
  139. {
  140. QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase1, "2");
  141. }
  142. else if (ultraTabControl1.SelectedTab.Index == 1)
  143. {
  144. QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase2, "3456");
  145. }
  146. break;
  147. case "Add":
  148. if (ultraTabControl2.SelectedTab.Index == 0)
  149. {
  150. AddCheckConsignProcessResult(publicUltraGridDataCJBase1_2, publicUltraGridDataCJBase1_1);
  151. }
  152. else if (ultraTabControl2.SelectedTab.Index == 1)
  153. {
  154. AddCheckConsignProcessResult(publicUltraGridDataCJBase2_2, publicUltraGridDataCJBase2_1);
  155. }
  156. else if (ultraTabControl2.SelectedTab.Index == 2)
  157. {
  158. AddCheckConsignProcessResult(publicUltraGridDataCJBase3_2, publicUltraGridDataCJBase3_1);
  159. }
  160. else if (ultraTabControl2.SelectedTab.Index == 3)
  161. {
  162. AddCheckConsignProcessResult(publicUltraGridDataCJBase4_2, publicUltraGridDataCJBase4_1);
  163. }
  164. else if (ultraTabControl2.SelectedTab.Index == 4)
  165. {
  166. AddCheckConsignProcessResult(publicUltraGridDataCJBase5_2, publicUltraGridDataCJBase5_1);
  167. }
  168. else if (ultraTabControl2.SelectedTab.Index == 5)
  169. {
  170. AddCheckConsignProcessResult(publicUltraGridDataCJBase6_2, publicUltraGridDataCJBase6_1);
  171. }
  172. break;
  173. case "Update":
  174. if (ultraTabControl3.SelectedTab.Index == 0)
  175. {
  176. UpdateCheckConsignProcessResult(publicUltraGridDataCJBase7_2, publicUltraGridDataCJBase7_1);
  177. }
  178. else if (ultraTabControl3.SelectedTab.Index == 1)
  179. {
  180. UpdateCheckConsignProcessResult(publicUltraGridDataCJBase8_2, publicUltraGridDataCJBase8_1);
  181. }
  182. else if (ultraTabControl3.SelectedTab.Index == 2)
  183. {
  184. UpdateCheckConsignProcessResult(publicUltraGridDataCJBase9_2, publicUltraGridDataCJBase9_1);
  185. }
  186. else if (ultraTabControl3.SelectedTab.Index == 3)
  187. {
  188. UpdateCheckConsignProcessResult(publicUltraGridDataCJBase10_2, publicUltraGridDataCJBase10_1);
  189. }
  190. else if (ultraTabControl3.SelectedTab.Index == 4)
  191. {
  192. UpdateCheckConsignProcessResult(publicUltraGridDataCJBase11_2, publicUltraGridDataCJBase11_1);
  193. }
  194. else if (ultraTabControl3.SelectedTab.Index == 5)
  195. {
  196. UpdateCheckConsignProcessResult(publicUltraGridDataCJBase12_2, publicUltraGridDataCJBase12_1);
  197. }
  198. //UpdateCheckConsignProcessResult();
  199. break;
  200. case "Delete":
  201. if (ultraTabControl3.SelectedTab.Index == 0)
  202. {
  203. DeleteCheckConsignProcessResult(publicUltraGridDataCJBase7_2, publicUltraGridDataCJBase7_1);
  204. }
  205. else if (ultraTabControl3.SelectedTab.Index == 1)
  206. {
  207. DeleteCheckConsignProcessResult(publicUltraGridDataCJBase8_2, publicUltraGridDataCJBase8_1);
  208. }
  209. else if (ultraTabControl3.SelectedTab.Index == 2)
  210. {
  211. DeleteCheckConsignProcessResult(publicUltraGridDataCJBase9_2, publicUltraGridDataCJBase9_1);
  212. }
  213. else if (ultraTabControl3.SelectedTab.Index == 3)
  214. {
  215. DeleteCheckConsignProcessResult(publicUltraGridDataCJBase10_2, publicUltraGridDataCJBase10_1);
  216. }
  217. else if (ultraTabControl3.SelectedTab.Index == 4)
  218. {
  219. DeleteCheckConsignProcessResult(publicUltraGridDataCJBase11_2, publicUltraGridDataCJBase11_1);
  220. }
  221. else if (ultraTabControl3.SelectedTab.Index == 5)
  222. {
  223. DeleteCheckConsignProcessResult(publicUltraGridDataCJBase12_2, publicUltraGridDataCJBase12_1);
  224. }
  225. //DeleteCheckConsignProcessResult();
  226. break;
  227. case "Close":
  228. if (MessageUtil.ShowYesNoAndQuestion("是否确认关闭页面?") == DialogResult.Yes)
  229. {
  230. this.Close();
  231. }
  232. break;
  233. }
  234. }
  235. #region 公共方法
  236. //颜色改变
  237. private void ChangeColor(DataTable dtPhyMax, Infragistics.Win.UltraWinTabControl.UltraTabControl ultraTabControl)
  238. {
  239. if (dtPhyMax == null || dtPhyMax.Rows.Count == 0) return;
  240. int i = -1;
  241. if (PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN = 'R0001'") != null && PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN = 'R0001'").Rows.Count > 0)
  242. {
  243. i = i == -1 ? i = 0 : i;
  244. ultraTabControl.Tabs[0].Appearance.BackColor = Color.GreenYellow;
  245. }
  246. if (PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN = 'R0002'") != null && PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN = 'R0002'").Rows.Count > 0)
  247. {
  248. i = i == -1 ? i = 1 : i;
  249. ultraTabControl.Tabs[1].Appearance.BackColor = Color.GreenYellow;
  250. }
  251. if (PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN IN ('R0003','R0004','R0005')") != null && PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN IN ('R0003','R0004','R0005')").Rows.Count > 0)
  252. {
  253. i = i == -1 ? i = 2 : i;
  254. ultraTabControl.Tabs[2].Appearance.BackColor = Color.GreenYellow;//硬度
  255. }
  256. if (PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN IN ('R0012','R0013')") != null && PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN IN ('R0012','R0013')").Rows.Count > 0)
  257. {
  258. i = i == -1 ? i = 3 : i;
  259. ultraTabControl.Tabs[3].Appearance.BackColor = Color.GreenYellow;//金相
  260. }
  261. if (PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN IN ('R0010')") != null && PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN IN ('R0010')").Rows.Count > 0)
  262. {
  263. i = i == -1 ? i = 4 : i;
  264. ultraTabControl.Tabs[4].Appearance.BackColor = Color.GreenYellow;//工艺
  265. }
  266. if (PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN NOT IN ('R0001', 'R0002','R0003','R0004','R0005','R0010','R0012','R0013')") != null && PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN NOT IN ('R0001', 'R0002','R0003','R0004','R0005','R0010','R0012','R0013')").Rows.Count > 0)
  267. {
  268. i = i == -1 ? i = 5 : i;
  269. ultraTabControl.Tabs[5].Appearance.BackColor = Color.GreenYellow;//其他
  270. }
  271. ultraTabControl.SelectedTab = i == -1 ? ultraTabControl.Tabs[0] : ultraTabControl.Tabs[i];
  272. }
  273. //赋值
  274. private void ClearPhyDetailItems(Infragistics.Win.UltraWinTabControl.UltraTabControl ultraTabControl)
  275. {
  276. //ultraTabControl.SelectedTab = ultraTabControl.Tabs[0];
  277. ultraTabControl.Tabs[0].Appearance.BackColor = Control.DefaultBackColor;
  278. ultraTabControl.Tabs[1].Appearance.BackColor = Control.DefaultBackColor;
  279. ultraTabControl.Tabs[2].Appearance.BackColor = Control.DefaultBackColor;
  280. ultraTabControl.Tabs[3].Appearance.BackColor = Control.DefaultBackColor;
  281. ultraTabControl.Tabs[4].Appearance.BackColor = Control.DefaultBackColor;
  282. ultraTabControl.Tabs[5].Appearance.BackColor = Control.DefaultBackColor;
  283. if (ultraTabControl == ultraTabControl2)
  284. {
  285. publicUltraGridDataCJBase1_1.DataTable.Rows.Clear();
  286. publicUltraGridDataCJBase2_1.DataTable.Rows.Clear();
  287. publicUltraGridDataCJBase3_1.DataTable.Rows.Clear();
  288. publicUltraGridDataCJBase4_1.DataTable.Rows.Clear();
  289. publicUltraGridDataCJBase5_1.DataTable.Rows.Clear();
  290. publicUltraGridDataCJBase6_1.DataTable.Rows.Clear();
  291. publicUltraGridDataCJBase1_2.DataTable.Rows.Clear();
  292. publicUltraGridDataCJBase2_2.DataTable.Rows.Clear();
  293. publicUltraGridDataCJBase3_2.DataTable.Rows.Clear();
  294. publicUltraGridDataCJBase4_2.DataTable.Rows.Clear();
  295. publicUltraGridDataCJBase5_2.DataTable.Rows.Clear();
  296. publicUltraGridDataCJBase6_2.DataTable.Rows.Clear();
  297. splitContainer1.Panel1Collapsed = true;
  298. splitContainer2.Panel1Collapsed = true;
  299. splitContainer3.Panel1Collapsed = true;
  300. splitContainer4.Panel1Collapsed = true;
  301. splitContainer5.Panel1Collapsed = true;
  302. splitContainer6.Panel1Collapsed = true;
  303. }
  304. else if (ultraTabControl == ultraTabControl3)
  305. {
  306. publicUltraGridDataCJBase7_1.DataTable.Rows.Clear();
  307. publicUltraGridDataCJBase8_1.DataTable.Rows.Clear();
  308. publicUltraGridDataCJBase9_1.DataTable.Rows.Clear();
  309. publicUltraGridDataCJBase10_1.DataTable.Rows.Clear();
  310. publicUltraGridDataCJBase11_1.DataTable.Rows.Clear();
  311. publicUltraGridDataCJBase12_1.DataTable.Rows.Clear();
  312. publicUltraGridDataCJBase7_2.DataTable.Rows.Clear();
  313. publicUltraGridDataCJBase8_2.DataTable.Rows.Clear();
  314. publicUltraGridDataCJBase9_2.DataTable.Rows.Clear();
  315. publicUltraGridDataCJBase10_2.DataTable.Rows.Clear();
  316. publicUltraGridDataCJBase11_2.DataTable.Rows.Clear();
  317. publicUltraGridDataCJBase12_2.DataTable.Rows.Clear();
  318. splitContainer7.Panel1Collapsed = true;
  319. splitContainer8.Panel1Collapsed = true;
  320. splitContainer9.Panel1Collapsed = true;
  321. splitContainer10.Panel1Collapsed = true;
  322. splitContainer11.Panel1Collapsed = true;
  323. splitContainer12.Panel1Collapsed = true;
  324. }
  325. }
  326. #endregion
  327. #region 录入区域
  328. //查询检验委托基本信息
  329. private void QueryCheckConsignBaseDetail_Distinct(PublicUltraGridBase publicUltraGridBase, string strFlag)
  330. {
  331. try
  332. {
  333. //各试验室各检验项目设置权限
  334. publicUltraGridBase.QueryCheckConsignBaseDetail_Distinct("pipe.FrmDataCJBase", pipeQueryBase1.GetQueryInfo(strFlag), this.ob, arrId, plineCodes);
  335. if (publicUltraGridBase.Ug.Rows.Count == 0)
  336. {
  337. if (publicUltraGridBase == publicUltraGridBase1)
  338. {
  339. publicUltraGridBase1.DataTable.Rows.Clear();
  340. publicUltraGridDataCJBase3_1.DataTable.Rows.Clear();
  341. publicUltraGridDataCJBase3_2.DataTable.Rows.Clear();
  342. //ClearPhyDetailItems(ultraTabControl2);
  343. }
  344. else if (publicUltraGridBase == publicUltraGridBase2)
  345. {
  346. publicUltraGridBase2.DataTable.Rows.Clear();
  347. publicUltraGridDataCJBase9_1.DataTable.Rows.Clear();
  348. publicUltraGridDataCJBase9_2.DataTable.Rows.Clear();
  349. //ClearPhyDetailItems(ultraTabControl3);
  350. }
  351. }
  352. }
  353. catch (Exception e)
  354. {
  355. MessageUtil.ShowWarning(e.Message);
  356. }
  357. }
  358. //查询试验方法项目信息
  359. private void QueryCheckMethodPhyConfigItems(PublicUltraGridDataCJBase publicUltraGridDataCJBase, DataTable dtHide, SplitContainer splitContainer, DataTable dt)
  360. {
  361. try
  362. {
  363. PublicPipeAndOutdec.ChangeSplit(splitContainer, dt);
  364. publicUltraGridDataCJBase.HideNullColumn(dtHide, publicUltraGridDataCJBase.Ug);
  365. publicUltraGridDataCJBase.QueryCheckMethodPhyConfigItems(dt);
  366. //PublicPipeAndOutdec.RefreshAndAutoSizeColumns(publicUltraGridDataCJBase.Ug, new string[] { "VALUE1", "VALUE2", "VALUE3", "VALUE4", "VALUE5", "VALUE6", "VALUE7", "VALUE8", "VALUE9", "VALUE4", "VALUE5", "VALUE6", "VALUE7", "VALUE8", "VALUE9", "VALUE10", "VALUE11", "VALUE12", "VALUE13", "VALUE14", "VALUE15" }, false);//刷新Grid
  367. }
  368. catch (Exception e)
  369. {
  370. MessageUtil.ShowError(e.Message);
  371. }
  372. }
  373. #endregion
  374. #region 未录入
  375. void pipeUltraGridBase1_PublicUltraGridBaseActive(object sender, EventArgs e)
  376. {
  377. try
  378. {
  379. pipeShowBase1.ShowBaseInfo(publicUltraGridBase1.Ur);
  380. //赋值给全局变量
  381. UltraGridRow ur = publicUltraGridBase1.Ur;
  382. ArrayList arrayList = new ArrayList();
  383. arrayList.Add("2");
  384. arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());//20160523
  385. arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
  386. arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
  387. arrayList.Add(ur.Cells["CHECK_NO"].Text.Trim());
  388. if (arrId != null && arrId.Length > 0)
  389. {
  390. //ClearPhyDetailItems(ultraTabControl2);20160830
  391. //查询检验项目明细
  392. DataTable dt = PublicServer.GetData("com.steering.lims.data.pipe.FrmDataCJBase.QueryCheckConsignDetailPhyDetail", new Object[] { arrayList, arrId }, ob);
  393. if (dt == null || dt.Rows.Count == 0)
  394. {
  395. m_dtPhyMax = null;
  396. m_dtPhyItems = null;
  397. return;
  398. }
  399. m_dtPhyMax = dt.Copy();
  400. DataTable dtItems = PublicServer.GetData("com.steering.lims.data.pipe.FrmDataCJBase.QueryCheckMethodPhyConfigItems",
  401. new Object[] { arrayList, arrId }, ob);
  402. if (dtItems == null || dtItems.Rows.Count == 0)
  403. {
  404. m_dtPhyItems = null;
  405. //return;
  406. }
  407. else
  408. {
  409. m_dtPhyItems = dtItems.Copy();
  410. }
  411. //ChangeColor(m_dtPhyMax, ultraTabControl2);
  412. AddPhyDetailItems();
  413. }
  414. }
  415. catch (Exception ex)
  416. {
  417. MessageUtil.ShowWarning(ex.Message);
  418. }
  419. }
  420. private void ultraTabControl2_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
  421. {
  422. //if (m_dtPhyMax == null || m_dtPhyMax.Rows.Count == 0) return;
  423. if (toolMenu == null) return;
  424. AddPhyDetailItems();
  425. }
  426. //赋值
  427. private void AddPhyDetailItems()
  428. {
  429. //ultraTabControl2.SelectedTab = ultraTabControl2.Tabs[2];
  430. if (m_dtPhyMax == null || m_dtPhyMax.Rows.Count == 0) return;
  431. if (ultraTabControl2.SelectedTab.Index == 0)
  432. {
  433. publicUltraGridDataCJBase1_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN = 'R0001'"));//拉伸
  434. publicUltraGridDataCJBase1_2.DataTable.AcceptChanges();
  435. QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase1_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN = 'R0001'"), splitContainer1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItems, "PHY_CODE_MIN = 'R0001'"));
  436. }
  437. else if (ultraTabControl2.SelectedTab.Index == 1)
  438. {
  439. publicUltraGridDataCJBase2_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN = 'R0002'"));//冲击
  440. publicUltraGridDataCJBase2_2.DataTable.AcceptChanges();
  441. QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase2_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN = 'R0002'"), splitContainer2, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItems, "PHY_CODE_MIN = 'R0002'"));
  442. }
  443. else if (ultraTabControl2.SelectedTab.Index == 2)
  444. {
  445. publicUltraGridDataCJBase3_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN IN ('R0003','R0004','R0005')"));//硬度
  446. publicUltraGridDataCJBase3_2.DataTable.AcceptChanges();
  447. QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase3_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN IN ('R0003','R0004','R0005')"), splitContainer3, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItems, "PHY_CODE_MIN IN ('R0003','R0004','R0005')"));
  448. }
  449. else if (ultraTabControl2.SelectedTab.Index == 3)//金相
  450. {
  451. publicUltraGridDataCJBase4_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN IN ('R0012','R0013')"));//金相
  452. publicUltraGridDataCJBase4_2.DataTable.AcceptChanges();
  453. QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase4_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN IN ('R0012','R0013')"), splitContainer4, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItems, "PHY_CODE_MIN IN ('R0012','R0013')"));
  454. }
  455. else if (ultraTabControl2.SelectedTab.Index == 4)//工艺
  456. {
  457. publicUltraGridDataCJBase5_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN IN ('R0010')"));//工艺
  458. publicUltraGridDataCJBase5_2.DataTable.AcceptChanges();
  459. QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase5_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN IN ('R0010')"), splitContainer5, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItems, "PHY_CODE_MIN IN ('R0010')"));
  460. }
  461. else if (ultraTabControl2.SelectedTab.Index == 5)//其他
  462. {
  463. publicUltraGridDataCJBase6_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN NOT IN ('R0001', 'R0002','R0003','R0004','R0005','R0010','R0012','R0013')"));
  464. publicUltraGridDataCJBase6_2.DataTable.AcceptChanges();
  465. QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase6_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN NOT IN ('R0001', 'R0002','R0003','R0004','R0005','R0010','R0012','R0013')"), splitContainer6, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItems, "PHY_CODE_MIN NOT IN ('R0001', 'R0002','R0003','R0004','R0005','R0010','R0012','R0013')"));
  466. }
  467. tabIndex = ultraTabControl2.SelectedTab.Index;
  468. }
  469. //新增检验委托过程结果JHYGG_PHYLX_PROCESS_RESULT,新增之前先删除表里数据
  470. private void AddCheckConsignProcessResult(PublicUltraGridDataCJBase publicUltraGridDataCJBase, PublicUltraGridDataCJBase publicUltraGridDataCJBaseItems)
  471. {
  472. try
  473. {
  474. if (ultraTabControl1.SelectedTab.Index != 0)
  475. {
  476. MessageUtil.ShowWarning("只有在未录入数据页才能进行新增操作!");
  477. return;
  478. }
  479. if (publicUltraGridBase1.Ur == null || publicUltraGridBase1.Ur.Activated == false)
  480. {
  481. MessageUtil.ShowWarning("请选择需要新增的试样信息!");
  482. return;
  483. }
  484. if (publicUltraGridDataCJBase.DataTable == null || publicUltraGridDataCJBase.DataTable.Rows.Count == 0)
  485. {
  486. return;
  487. }
  488. //bool isNullValue = true;
  489. publicUltraGridDataCJBase.Ug.UpdateData();
  490. foreach (DataRow dr in publicUltraGridDataCJBase.DataTable.Rows)
  491. {
  492. if (dr["VALUE1"].ToString() == "" && dr["VALUE2"].ToString() == "" && dr["VALUE3"].ToString() == "" && dr["VALUE4"].ToString() == "" && dr["VALUE5"].ToString() == "" && dr["VALUE6"].ToString() == "" && dr["VALUE7"].ToString() == "" && dr["VALUE8"].ToString() == "" && dr["VALUE9"].ToString() == "")
  493. {
  494. MessageUtil.ShowWarning(dr["PHY_NAME"] + "没有录入任何数据不允许新增!");
  495. return;
  496. }
  497. }
  498. if (MessageUtil.ShowYesNoAndQuestion("是否确认新增?") == DialogResult.Yes)
  499. {
  500. string strCHECK_NO = publicUltraGridBase1.Ur.Cells["CHECK_NO"].Text.Trim();
  501. string strSAMPLE_NO = publicUltraGridBase1.Ur.Cells["SAMPLE_NO"].Text.Trim();//定位
  502. ArrayList alAll = new ArrayList();
  503. ArrayList alPhyItems = new ArrayList();//删除信息详细表list
  504. ArrayList alDetail = new ArrayList();//检验信息详细表list
  505. ArrayList alProcessResult = new ArrayList();//化学信息list
  506. ArrayList alPhyItemsParams = new ArrayList();
  507. ArrayList alDetailParams = new ArrayList();//检验信息详细表参数list
  508. ArrayList alProcessResultParams = new ArrayList();//化学信息参数list
  509. string strTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
  510. //获取修改明细表参数JHYGG_CHECKCONSIGN_DETAIL
  511. string row = "";
  512. foreach (DataRow dr in publicUltraGridDataCJBase.DataTable.Rows)
  513. {
  514. if (row.IndexOf(dr["PHY_CODE_MAX"].ToString()) < 0)
  515. {
  516. row += dr["PHY_CODE_MAX"].ToString() + " ";
  517. alDetailParams = new ArrayList();
  518. alDetailParams.Add(publicDataCJBase1.StrTemp);//温度
  519. alDetailParams.Add(publicDataCJBase1.StrDevice_No);//设备编码
  520. alDetailParams.Add(publicDataCJBase1.StrDevice_Name);//设备名称
  521. alDetailParams.Add(publicDataCJBase1.StrRemark);//备注
  522. alDetailParams.Add(publicDataCJBase1.StrShift == "" ? UserInfo.GetUserOrderText() : publicDataCJBase1.StrShift);
  523. alDetailParams.Add(publicDataCJBase1.StrClass == "" ? UserInfo.GetUserGroupText() : publicDataCJBase1.StrClass);//班组
  524. alDetailParams.Add(publicDataCJBase1.StrName == "" ? UserInfo.GetUserName() : publicDataCJBase1.StrName);//录入人
  525. alDetailParams.Add(strTime);//录入时间
  526. alDetailParams.Add("3");//录入标志位
  527. alDetailParams.Add("2");
  528. alDetailParams.Add(dr["PHY_CODE_MAX"].ToString());
  529. alDetailParams.Add(strSAMPLE_NO);
  530. alDetailParams.Add(strCHECK_NO);
  531. alDetail.Add(alDetailParams);
  532. }
  533. }
  534. publicUltraGridDataCJBase.Ug.UpdateData();
  535. foreach (DataRow dr in publicUltraGridDataCJBase.DataTable.Rows)
  536. {
  537. alProcessResultParams = new ArrayList();
  538. alProcessResultParams.Add(dr["VALUE1"].ToString());
  539. alProcessResultParams.Add(dr["VALUE2"].ToString());
  540. alProcessResultParams.Add(dr["VALUE3"].ToString());
  541. alProcessResultParams.Add(dr["VALUE4"].ToString());
  542. alProcessResultParams.Add(dr["VALUE5"].ToString());
  543. alProcessResultParams.Add(dr["VALUE6"].ToString());
  544. alProcessResultParams.Add(dr["VALUE7"].ToString());
  545. alProcessResultParams.Add(dr["VALUE8"].ToString());
  546. alProcessResultParams.Add(dr["VALUE9"].ToString());
  547. alProcessResultParams.Add(dr["VALUE10"].ToString());
  548. alProcessResultParams.Add(dr["VALUE11"].ToString());
  549. alProcessResultParams.Add(dr["VALUE12"].ToString());
  550. alProcessResultParams.Add(dr["VALUE13"].ToString());
  551. alProcessResultParams.Add(dr["VALUE14"].ToString());
  552. alProcessResultParams.Add(dr["VALUE15"].ToString());
  553. alProcessResultParams.Add(dr["PHYDETAIL_ID"].ToString());
  554. alProcessResult.Add(alProcessResultParams);
  555. //alDeleteParams = new ArrayList();
  556. //alDeleteParams.Add(dr["PHYDETAIL_ID"].ToString());
  557. //alDelete.Add(alDeleteParams);
  558. }
  559. if (publicUltraGridDataCJBaseItems.DataTable != null)
  560. {
  561. publicUltraGridDataCJBaseItems.Ug.UpdateData();
  562. foreach (DataRow dr in publicUltraGridDataCJBaseItems.DataTable.Rows)
  563. {
  564. alPhyItemsParams = new ArrayList();
  565. alPhyItemsParams.Add(strCHECK_NO);
  566. alPhyItemsParams.Add(strSAMPLE_NO);
  567. alPhyItemsParams.Add(dr["CHECK_METHOD_NO"].ToString());
  568. alPhyItemsParams.Add(dr["CHECK_METHOD_NAME"].ToString());
  569. alPhyItemsParams.Add(dr["CHECK_METHOD_ITEMNAME"].ToString());
  570. alPhyItemsParams.Add(dr["VALUE1"].ToString());
  571. alPhyItemsParams.Add(dr["VALUE2"].ToString());
  572. alPhyItemsParams.Add(dr["VALUE3"].ToString());
  573. alPhyItemsParams.Add(dr["VALUE4"].ToString());
  574. alPhyItemsParams.Add(dr["VALUE5"].ToString());
  575. alPhyItemsParams.Add(dr["VALUE6"].ToString());
  576. alPhyItemsParams.Add(dr["VALUE7"].ToString());
  577. alPhyItemsParams.Add(dr["VALUE8"].ToString());
  578. alPhyItemsParams.Add(dr["VALUE9"].ToString());
  579. alPhyItemsParams.Add(dr["VALUE10"].ToString());
  580. alPhyItemsParams.Add(dr["VALUE11"].ToString());
  581. alPhyItemsParams.Add(dr["VALUE12"].ToString());
  582. alPhyItemsParams.Add(dr["VALUE13"].ToString());
  583. alPhyItemsParams.Add(dr["VALUE14"].ToString());
  584. alPhyItemsParams.Add(dr["VALUE15"].ToString());
  585. alPhyItemsParams.Add("");
  586. alPhyItems.Add(alPhyItemsParams);
  587. }
  588. }
  589. alAll.Add(alDetail);
  590. alAll.Add(alProcessResult);
  591. if (alPhyItems.Count > 0)
  592. {
  593. alAll.Add(alPhyItems);
  594. }
  595. PublicServer.SetData("com.steering.lims.data.pipe.FrmDataCJBase.AddCheckConsignProcessResult",
  596. new Object[] { alAll }, this.ob);
  597. QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase1, "2");
  598. QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase2, "3456");
  599. PublicPipeAndOutdec.ActiveOperateRow(publicUltraGridBase1.Ug, new string[] { "CHECK_NO", "SAMPLE_NO" }, new string[] { strCHECK_NO, strSAMPLE_NO });
  600. PublicPipeAndOutdec.ActiveOperateRow(publicUltraGridBase2.Ug, new string[] { "CHECK_NO", "SAMPLE_NO" }, new string[] { strCHECK_NO, strSAMPLE_NO });
  601. publicDataCJBase1.StrRemark = "";
  602. MessageUtil.ShowTips("新增成功!");
  603. }
  604. }
  605. catch (Exception e)
  606. {
  607. MessageUtil.ShowWarning(e.Message);
  608. }
  609. }
  610. private void ultraTabControl2_SelectedTabChanging(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangingEventArgs e)
  611. {
  612. int cnt = 0;
  613. if (tabIndex == 0)
  614. {
  615. publicUltraGridDataCJBase1_2.Ug.UpdateData();
  616. cnt = publicUltraGridDataCJBase1_2.DataTable.Rows.Cast<DataRow>().Where(
  617. a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
  618. }
  619. else if (tabIndex == 1)
  620. {
  621. publicUltraGridDataCJBase2_2.Ug.UpdateData();
  622. cnt = publicUltraGridDataCJBase2_2.DataTable.Rows.Cast<DataRow>().Where(
  623. a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
  624. }
  625. else if (tabIndex == 2)
  626. {
  627. publicUltraGridDataCJBase3_2.Ug.UpdateData();
  628. cnt = publicUltraGridDataCJBase3_2.DataTable.Rows.Cast<DataRow>().Where(
  629. a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
  630. }
  631. else if (tabIndex == 3)
  632. {
  633. publicUltraGridDataCJBase4_2.Ug.UpdateData();
  634. cnt = publicUltraGridDataCJBase4_2.DataTable.Rows.Cast<DataRow>().Where(
  635. a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
  636. }
  637. else if (tabIndex == 4)
  638. {
  639. publicUltraGridDataCJBase5_2.Ug.UpdateData();
  640. cnt = publicUltraGridDataCJBase5_2.DataTable.Rows.Cast<DataRow>().Where(
  641. a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
  642. }
  643. else if (tabIndex == 5)
  644. {
  645. publicUltraGridDataCJBase6_2.Ug.UpdateData();
  646. cnt = publicUltraGridDataCJBase6_2.DataTable.Rows.Cast<DataRow>().Where(
  647. a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
  648. }
  649. if (cnt > 0)
  650. {
  651. if (MessageUtil.ShowYesNoAndQuestion("数据有变更您确定要放弃吗?") == System.Windows.Forms.DialogResult.No)
  652. {
  653. e.Cancel = true;
  654. }
  655. }
  656. }
  657. #endregion
  658. #region 已录入
  659. private void ultraTabControl3_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
  660. {
  661. //if (m_dtPhyMax == null || m_dtPhyMax.Rows.Count == 0) return;
  662. if (toolMenu == null) return;
  663. AddPhyDetailItems_Log();
  664. }
  665. void pipeUltraGridBase2_PublicUltraGridBaseActive(object sender, EventArgs e)
  666. {
  667. try
  668. {
  669. pipeShowBase2.ShowBaseInfo(publicUltraGridBase2.Ur);
  670. //赋值给全局变量
  671. UltraGridRow ur = publicUltraGridBase2.Ur;
  672. ArrayList arrayList = new ArrayList();
  673. arrayList.Add("345");
  674. arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());//20160523
  675. arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
  676. arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
  677. arrayList.Add(ur.Cells["CHECK_NO"].Text.Trim());
  678. if (arrId != null && arrId.Length > 0)
  679. {
  680. //ClearPhyDetailItems(ultraTabControl3);
  681. //查询检验项目明细
  682. DataTable dt = PublicServer.GetData("com.steering.lims.data.pipe.FrmDataCJBase.QueryCheckConsignDetailPhyDetail", new Object[] { arrayList, arrId }, ob);
  683. if (dt == null || dt.Rows.Count == 0)
  684. {
  685. m_dtPhyMaxAdd = null;
  686. m_dtPhyItemsAdd = null;
  687. return;
  688. }
  689. m_dtPhyMaxAdd = dt.Copy();
  690. DataTable dtItems = PublicServer.GetData("com.steering.lims.data.pipe.FrmDataCJBase.QueryCheckMethodResult",
  691. new Object[] { arrayList, arrId }, ob);
  692. if (dtItems == null || dtItems.Rows.Count == 0)
  693. {
  694. m_dtPhyItemsAdd = null;
  695. //return;
  696. }
  697. else
  698. {
  699. m_dtPhyItemsAdd = dtItems.Copy();
  700. }
  701. //ChangeColor(m_dtPhyMaxAdd, ultraTabControl3);
  702. AddPhyDetailItems_Log();
  703. }
  704. }
  705. catch (Exception ex)
  706. {
  707. MessageUtil.ShowWarning(ex.Message);
  708. }
  709. }
  710. //赋值
  711. private void AddPhyDetailItems_Log()
  712. {
  713. //ultraTabControl3.SelectedTab = ultraTabControl3.Tabs[2];
  714. if (m_dtPhyMaxAdd == null || m_dtPhyMaxAdd.Rows.Count == 0) return;
  715. if (ultraTabControl3.SelectedTab.Index == 0)
  716. {
  717. publicUltraGridDataCJBase7_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN = 'R0001'"));//拉伸
  718. publicUltraGridDataCJBase7_2.DataTable.AcceptChanges();
  719. QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase7_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN = 'R0001'"), splitContainer7, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAdd, "PHY_CODE_MIN = 'R0001'"));
  720. }
  721. else if (ultraTabControl3.SelectedTab.Index == 1)
  722. {
  723. publicUltraGridDataCJBase8_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN = 'R0002'"));//冲击
  724. publicUltraGridDataCJBase8_2.DataTable.AcceptChanges();
  725. QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase8_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN = 'R0002'"), splitContainer8, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAdd, "PHY_CODE_MIN = 'R0002'"));
  726. }
  727. else if (ultraTabControl3.SelectedTab.Index == 2)
  728. {
  729. publicUltraGridDataCJBase9_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN IN ('R0003','R0004','R0005')"));//硬度
  730. publicUltraGridDataCJBase9_2.DataTable.AcceptChanges();
  731. QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase9_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN IN ('R0003','R0004','R0005')"), splitContainer9, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAdd, "PHY_CODE_MIN IN ('R0003','R0004','R0005')"));
  732. }
  733. else if (ultraTabControl3.SelectedTab.Index == 3)//金相
  734. {
  735. publicUltraGridDataCJBase10_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN IN ('R0012','R0013')"));//金相
  736. publicUltraGridDataCJBase10_2.DataTable.AcceptChanges();
  737. QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase10_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN IN ('R0012','R0013')"), splitContainer10, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAdd, "PHY_CODE_MIN IN ('R0012','R0013')"));
  738. }
  739. else if (ultraTabControl3.SelectedTab.Index == 4)//工艺
  740. {
  741. publicUltraGridDataCJBase11_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN IN ('R0010')"));//工艺
  742. publicUltraGridDataCJBase11_2.DataTable.AcceptChanges();
  743. QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase11_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN IN ('R0010')"), splitContainer11, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAdd, "PHY_CODE_MIN IN ('R0010')"));
  744. }
  745. else if (ultraTabControl3.SelectedTab.Index == 5)//其他
  746. {
  747. publicUltraGridDataCJBase12_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN NOT IN ('R0001', 'R0002','R0003','R0004','R0005','R0010','R0012','R0013')"));
  748. publicUltraGridDataCJBase12_2.DataTable.AcceptChanges();
  749. QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase12_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN NOT IN ('R0001', 'R0002','R0003','R0004','R0005','R0010','R0012','R0013')"), splitContainer12, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAdd, "PHY_CODE_MIN NOT IN ('R0001', 'R0002','R0003','R0004','R0005','R0010','R0012','R0013')"));
  750. }
  751. tabIndex = ultraTabControl3.SelectedTab.Index;
  752. }
  753. //修改检验委托过程结果JHYGG_PHYLX_PROCESS_RESULT
  754. private void UpdateCheckConsignProcessResult(PublicUltraGridDataCJBase publicUltraGridDataCJBase, PublicUltraGridDataCJBase publicUltraGridDataCJBaseItems)
  755. {
  756. try
  757. {
  758. if (ultraTabControl1.SelectedTab.Index != 1)
  759. {
  760. MessageUtil.ShowTips("只有在已录入数据页才能进行修改操作!");
  761. return;
  762. }
  763. if (publicUltraGridBase2.Ur == null || publicUltraGridBase2.Ur.Activated == false)
  764. {
  765. MessageUtil.ShowWarning("请选择需要修改的试样信息!");
  766. return;
  767. }
  768. if (publicUltraGridDataCJBase.OldDt == null || publicUltraGridDataCJBase.OldDt.Rows.Count == 0 || publicUltraGridDataCJBase.DataTable == null || publicUltraGridDataCJBase.DataTable.Rows.Count == 0)
  769. {
  770. return;
  771. }
  772. //if (publicUltraGridBase2.Ur.Cells["FLAG"].Text == "已审核")
  773. //{
  774. // MessageUtil.ShowTips("已审核的数据不允许修改!");
  775. // return;
  776. //}
  777. if (MessageUtil.ShowYesNoAndQuestion("是否确认修改?") == DialogResult.Yes)
  778. {
  779. string strCHECK_NO = publicUltraGridBase2.Ur.Cells["CHECK_NO"].Text.Trim();
  780. string strSAMPLE_NO = publicUltraGridBase2.Ur.Cells["SAMPLE_NO"].Text.Trim();//定位
  781. ArrayList alAll = new ArrayList();
  782. ArrayList alProcessResult = new ArrayList();//过程信息list新值
  783. ArrayList alProcessResultLog = new ArrayList();//过程信息list原值
  784. ArrayList alDeletePhyItems = new ArrayList();
  785. ArrayList alPhyItems = new ArrayList();
  786. ArrayList alProcessResultParams = new ArrayList();//过程信息参数list新值
  787. ArrayList alProcessResultParamsLog = new ArrayList();//过程信息参数list原值
  788. ArrayList alDeletePhyItemsParams = new ArrayList();
  789. ArrayList alPhyItemsParams = new ArrayList();
  790. string strTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
  791. //用m_OldDt获取原值
  792. foreach (DataRow dr in publicUltraGridDataCJBase.OldDt.Rows)
  793. {
  794. alProcessResultParamsLog = new ArrayList();
  795. alProcessResultParamsLog.Add(dr["PHYDETAIL_ID"].ToString());
  796. alProcessResultParamsLog.Add(dr["VALUE1"].ToString());
  797. alProcessResultParamsLog.Add(dr["VALUE2"].ToString());
  798. alProcessResultParamsLog.Add(dr["VALUE3"].ToString());
  799. alProcessResultParamsLog.Add(dr["VALUE4"].ToString());
  800. alProcessResultParamsLog.Add(dr["VALUE5"].ToString());
  801. alProcessResultParamsLog.Add(dr["VALUE6"].ToString());
  802. alProcessResultParamsLog.Add(dr["VALUE7"].ToString());
  803. alProcessResultParamsLog.Add(dr["VALUE8"].ToString());
  804. alProcessResultParamsLog.Add(dr["VALUE9"].ToString());
  805. alProcessResultParamsLog.Add(dr["VALUE10"].ToString());
  806. alProcessResultParamsLog.Add(dr["VALUE11"].ToString());
  807. alProcessResultParamsLog.Add(dr["VALUE12"].ToString());
  808. alProcessResultParamsLog.Add(dr["VALUE13"].ToString());
  809. alProcessResultParamsLog.Add(dr["VALUE14"].ToString());
  810. alProcessResultParamsLog.Add(dr["VALUE15"].ToString());
  811. alProcessResultParamsLog.Add(UserInfo.GetUserName());//操作人
  812. alProcessResultParamsLog.Add(strTime);//操作时间
  813. alProcessResultParamsLog.Add("0");
  814. //alProcessResultParamsLog.Add(txtOPERATE_REMARK.Text.Trim());//操作备注修改
  815. alProcessResultLog.Add(alProcessResultParamsLog);//插入到JHYGG_PHYRESULT_LOG数据(过程原值)
  816. }
  817. string row = "";
  818. publicUltraGridDataCJBase.Ug.UpdateData();
  819. foreach (DataRow dr in publicUltraGridDataCJBase.DataTable.Rows)
  820. {
  821. if (row.IndexOf(dr["PHY_CODE_MAX"].ToString()) < 0)
  822. {
  823. row += ",'" + dr["PHY_CODE_MAX"].ToString() + "'";
  824. }
  825. alProcessResultParams = new ArrayList();
  826. alProcessResultParams.Add(dr["VALUE1"].ToString());
  827. alProcessResultParams.Add(dr["VALUE2"].ToString());
  828. alProcessResultParams.Add(dr["VALUE3"].ToString());
  829. alProcessResultParams.Add(dr["VALUE4"].ToString());
  830. alProcessResultParams.Add(dr["VALUE5"].ToString());
  831. alProcessResultParams.Add(dr["VALUE6"].ToString());
  832. alProcessResultParams.Add(dr["VALUE7"].ToString());
  833. alProcessResultParams.Add(dr["VALUE8"].ToString());
  834. alProcessResultParams.Add(dr["VALUE9"].ToString());
  835. alProcessResultParams.Add(dr["VALUE10"].ToString());
  836. alProcessResultParams.Add(dr["VALUE11"].ToString());
  837. alProcessResultParams.Add(dr["VALUE12"].ToString());
  838. alProcessResultParams.Add(dr["VALUE13"].ToString());
  839. alProcessResultParams.Add(dr["VALUE14"].ToString());
  840. alProcessResultParams.Add(dr["VALUE15"].ToString());
  841. //alProcessResultParams.Add(txtREMARK_LOG.Text.Trim());//试验备注
  842. alProcessResultParams.Add(dr["PHYDETAIL_ID"].ToString());
  843. alProcessResult.Add(alProcessResultParams);//新值
  844. }
  845. if (publicUltraGridDataCJBaseItems.DataTable != null)
  846. {
  847. string strMethod = "";
  848. publicUltraGridDataCJBaseItems.Ug.UpdateData();
  849. foreach (DataRow dr in publicUltraGridDataCJBaseItems.DataTable.Rows)
  850. {
  851. if (strMethod.IndexOf(dr["CHECK_METHOD_NO"].ToString()) < 0)
  852. {
  853. strMethod += dr["CHECK_METHOD_NO"].ToString() + " ";
  854. alDeletePhyItemsParams = new ArrayList();
  855. alDeletePhyItemsParams.Add(dr["CHECK_METHOD_NO"].ToString());
  856. alDeletePhyItemsParams.Add(strSAMPLE_NO);
  857. alDeletePhyItemsParams.Add(strCHECK_NO);
  858. alDeletePhyItems.Add(alDeletePhyItemsParams);
  859. }
  860. alPhyItemsParams = new ArrayList();
  861. alPhyItemsParams.Add(strCHECK_NO);
  862. alPhyItemsParams.Add(strSAMPLE_NO);
  863. alPhyItemsParams.Add(dr["CHECK_METHOD_NO"].ToString());
  864. alPhyItemsParams.Add(dr["CHECK_METHOD_NAME"].ToString());
  865. alPhyItemsParams.Add(dr["CHECK_METHOD_ITEMNAME"].ToString());
  866. alPhyItemsParams.Add(dr["VALUE1"].ToString());
  867. alPhyItemsParams.Add(dr["VALUE2"].ToString());
  868. alPhyItemsParams.Add(dr["VALUE3"].ToString());
  869. alPhyItemsParams.Add(dr["VALUE4"].ToString());
  870. alPhyItemsParams.Add(dr["VALUE5"].ToString());
  871. alPhyItemsParams.Add(dr["VALUE6"].ToString());
  872. alPhyItemsParams.Add(dr["VALUE7"].ToString());
  873. alPhyItemsParams.Add(dr["VALUE8"].ToString());
  874. alPhyItemsParams.Add(dr["VALUE9"].ToString());
  875. alPhyItemsParams.Add(dr["VALUE10"].ToString());
  876. alPhyItemsParams.Add(dr["VALUE11"].ToString());
  877. alPhyItemsParams.Add(dr["VALUE12"].ToString());
  878. alPhyItemsParams.Add(dr["VALUE13"].ToString());
  879. alPhyItemsParams.Add(dr["VALUE14"].ToString());
  880. alPhyItemsParams.Add(dr["VALUE15"].ToString());
  881. alPhyItemsParams.Add("");
  882. alPhyItems.Add(alPhyItemsParams);
  883. }
  884. }
  885. alAll.Add(alProcessResultLog);//原值
  886. alAll.Add(alProcessResult);//新值
  887. if (alDeletePhyItems.Count > 0)
  888. {
  889. alAll.Add(alDeletePhyItems);
  890. }
  891. if (alPhyItems.Count > 0)
  892. {
  893. alAll.Add(alPhyItems);
  894. }
  895. row = row.Remove(0, 1);
  896. ArrayList al = new ArrayList();
  897. al.Add(strCHECK_NO);
  898. al.Add(strSAMPLE_NO);
  899. al.Add(row);
  900. PublicServer.SetData("com.steering.lims.data.pipe.FrmDataCJBase.UpdateCheckConsignProcessResult",
  901. new Object[] { al, alAll }, this.ob);
  902. QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase2, "3456");
  903. //QueryCheckConsignBaseDetail_Distinct("2");
  904. PublicPipeAndOutdec.ActiveOperateRow(publicUltraGridBase2.Ug, new string[] { "CHECK_NO", "SAMPLE_NO" }, new string[] { strCHECK_NO, strSAMPLE_NO });
  905. MessageUtil.ShowTips("修改成功!");
  906. }
  907. }
  908. catch (Exception e)
  909. {
  910. MessageUtil.ShowWarning(e.Message);
  911. }
  912. }
  913. //删除检验委托过程结果JHYGG_PHYLX_PROCESS_RESULT
  914. private void DeleteCheckConsignProcessResult(PublicUltraGridDataCJBase publicUltraGridDataCJBase, PublicUltraGridDataCJBase publicUltraGridDataCJBaseItems)
  915. {
  916. try
  917. {
  918. if (ultraTabControl1.SelectedTab.Index != 1)
  919. {
  920. MessageUtil.ShowTips("只有在已录入数据页才能进行删除操作!");
  921. return;
  922. }
  923. if (publicUltraGridBase2.Ur == null || publicUltraGridBase2.Ur.Activated == false)
  924. {
  925. MessageUtil.ShowWarning("请选择需要删除的试样信息!");
  926. return;
  927. }
  928. if (publicUltraGridDataCJBase.OldDt == null || publicUltraGridDataCJBase.OldDt.Rows.Count == 0 || publicUltraGridDataCJBase.DataTable == null || publicUltraGridDataCJBase.DataTable.Rows.Count == 0)
  929. {
  930. return;
  931. }
  932. if (MessageUtil.ShowYesNoAndQuestion("是否确认删除?") == DialogResult.Yes)
  933. {
  934. string strCHECK_NO = publicUltraGridBase2.Ur.Cells["CHECK_NO"].Text.Trim();
  935. string strSAMPLE_NO = publicUltraGridBase2.Ur.Cells["SAMPLE_NO"].Text.Trim();//定位
  936. ArrayList alAll = new ArrayList();
  937. ArrayList alDetail = new ArrayList();
  938. ArrayList alProcessResult = new ArrayList();//过程信息list新值
  939. ArrayList alProcessResultLog = new ArrayList();//过程信息list原值
  940. ArrayList alPhyItems = new ArrayList();
  941. ArrayList alDetailParams = new ArrayList();
  942. ArrayList alProcessResultParams = new ArrayList();//过程信息参数list新值
  943. ArrayList alProcessResultParamsLog = new ArrayList();//过程信息参数list原值
  944. ArrayList alPhyItemsParams = new ArrayList();
  945. string strTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
  946. foreach (DataRow dr in publicUltraGridDataCJBase.DataTable.Rows)
  947. {
  948. alDetailParams = new ArrayList();
  949. alDetailParams.Add("");
  950. alDetailParams.Add("");
  951. alDetailParams.Add("");
  952. alDetailParams.Add("");
  953. alDetailParams.Add("");//班次
  954. alDetailParams.Add("");//班组
  955. alDetailParams.Add("");//录入人
  956. alDetailParams.Add("");//录入时间
  957. alDetailParams.Add("2");//删除之后回到待录入状态
  958. alDetailParams.Add("3");
  959. alDetailParams.Add(dr["PHY_CODE_MAX"].ToString());
  960. alDetailParams.Add(strSAMPLE_NO);
  961. alDetailParams.Add(strCHECK_NO);
  962. alDetail.Add(alDetailParams);
  963. }
  964. //用m_OldDt获取原值
  965. foreach (DataRow dr in publicUltraGridDataCJBase.OldDt.Rows)
  966. {
  967. alProcessResultParamsLog = new ArrayList();
  968. alProcessResultParamsLog.Add(dr["VALUE1"].ToString());
  969. alProcessResultParamsLog.Add(dr["VALUE2"].ToString());
  970. alProcessResultParamsLog.Add(dr["VALUE3"].ToString());
  971. alProcessResultParamsLog.Add(dr["VALUE4"].ToString());
  972. alProcessResultParamsLog.Add(dr["VALUE5"].ToString());
  973. alProcessResultParamsLog.Add(dr["VALUE6"].ToString());
  974. alProcessResultParamsLog.Add(dr["VALUE7"].ToString());
  975. alProcessResultParamsLog.Add(dr["VALUE8"].ToString());
  976. alProcessResultParamsLog.Add(dr["VALUE9"].ToString());
  977. alProcessResultParamsLog.Add(dr["VALUE10"].ToString());
  978. alProcessResultParamsLog.Add(dr["VALUE11"].ToString());
  979. alProcessResultParamsLog.Add(dr["VALUE12"].ToString());
  980. alProcessResultParamsLog.Add(dr["VALUE13"].ToString());
  981. alProcessResultParamsLog.Add(dr["VALUE14"].ToString());
  982. alProcessResultParamsLog.Add(dr["VALUE15"].ToString());
  983. alProcessResultParamsLog.Add(UserInfo.GetUserName());//操作人
  984. alProcessResultParamsLog.Add(strTime);//操作时间
  985. alProcessResultParamsLog.Add("1");
  986. alProcessResultParamsLog.Add(dr["PHYDETAIL_ID"].ToString());
  987. //alProcessResultParamsLog.Add(txtOPERATE_REMARK.Text.Trim());//操作备注修改
  988. alProcessResultLog.Add(alProcessResultParamsLog);//插入到JHYGG_PHYRESULT_LOG数据(过程原值)
  989. }
  990. string row = "";
  991. publicUltraGridDataCJBase.Ug.UpdateData();//修改原值
  992. foreach (DataRow dr in publicUltraGridDataCJBase.DataTable.Rows)
  993. {
  994. if (row.IndexOf(dr["PHY_CODE_MAX"].ToString()) < 0)
  995. {
  996. row += ",'" + dr["PHY_CODE_MAX"].ToString() + "'";
  997. }
  998. alProcessResultParams = new ArrayList();
  999. alProcessResultParams.Add("");
  1000. alProcessResultParams.Add("");
  1001. alProcessResultParams.Add("");
  1002. alProcessResultParams.Add("");
  1003. alProcessResultParams.Add("");
  1004. alProcessResultParams.Add("");
  1005. alProcessResultParams.Add("");
  1006. alProcessResultParams.Add("");
  1007. alProcessResultParams.Add("");
  1008. alProcessResultParams.Add("");
  1009. alProcessResultParams.Add("");
  1010. alProcessResultParams.Add("");
  1011. alProcessResultParams.Add("");
  1012. alProcessResultParams.Add("");
  1013. alProcessResultParams.Add("");
  1014. //alProcessResultParams.Add(txtREMARK_LOG.Text.Trim());//试验备注
  1015. alProcessResultParams.Add(dr["PHYDETAIL_ID"].ToString());
  1016. alProcessResult.Add(alProcessResultParams);//新值
  1017. }
  1018. if (publicUltraGridDataCJBaseItems.DataTable != null)
  1019. {
  1020. string strMethod = "";
  1021. publicUltraGridDataCJBaseItems.Ug.UpdateData();
  1022. foreach (DataRow dr in publicUltraGridDataCJBaseItems.DataTable.Rows)
  1023. {
  1024. if (strMethod.IndexOf(dr["CHECK_METHOD_NO"].ToString()) < 0)
  1025. {
  1026. strMethod += dr["CHECK_METHOD_NO"].ToString() + " ";
  1027. alPhyItemsParams = new ArrayList();
  1028. alPhyItemsParams.Add(dr["CHECK_METHOD_NO"].ToString());
  1029. alPhyItemsParams.Add(strSAMPLE_NO);
  1030. alPhyItemsParams.Add(strCHECK_NO);
  1031. alPhyItems.Add(alPhyItemsParams);
  1032. }
  1033. }
  1034. }
  1035. alAll.Add(alDetail);
  1036. alAll.Add(alProcessResultLog);//原值
  1037. alAll.Add(alProcessResult);
  1038. if (alPhyItems.Count > 0)
  1039. {
  1040. alAll.Add(alPhyItems);
  1041. }
  1042. row = row.Remove(0, 1);
  1043. ArrayList al = new ArrayList();
  1044. al.Add(strCHECK_NO);
  1045. al.Add(strSAMPLE_NO);
  1046. al.Add(row);
  1047. PublicServer.SetData("com.steering.lims.data.pipe.FrmDataCJBase.DeleteCheckConsignProcessResult",
  1048. new Object[] { al, alAll }, this.ob);
  1049. QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase2, "3456");
  1050. QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase1, "2");
  1051. PublicPipeAndOutdec.ActiveOperateRow(publicUltraGridBase2.Ug, new string[] { "CHECK_NO", "SAMPLE_NO" }, new string[] { strCHECK_NO, strSAMPLE_NO });
  1052. PublicPipeAndOutdec.ActiveOperateRow(publicUltraGridBase1.Ug, new string[] { "CHECK_NO", "SAMPLE_NO" }, new string[] { strCHECK_NO, strSAMPLE_NO });
  1053. MessageUtil.ShowTips("删除成功!");
  1054. }
  1055. }
  1056. catch (Exception e)
  1057. {
  1058. MessageUtil.ShowWarning(e.Message);
  1059. }
  1060. }
  1061. private void ultraTabControl3_SelectedTabChanging(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangingEventArgs e)
  1062. {
  1063. int cnt = 0;
  1064. if (tabIndex == 0)
  1065. {
  1066. publicUltraGridDataCJBase7_2.Ug.UpdateData();
  1067. cnt = publicUltraGridDataCJBase7_2.DataTable.Rows.Cast<DataRow>().Where(
  1068. a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
  1069. }
  1070. else if (tabIndex == 1)
  1071. {
  1072. publicUltraGridDataCJBase8_2.Ug.UpdateData();
  1073. cnt = publicUltraGridDataCJBase8_2.DataTable.Rows.Cast<DataRow>().Where(
  1074. a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
  1075. }
  1076. else if (tabIndex == 2)
  1077. {
  1078. publicUltraGridDataCJBase9_2.Ug.UpdateData();
  1079. cnt = publicUltraGridDataCJBase9_2.DataTable.Rows.Cast<DataRow>().Where(
  1080. a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
  1081. }
  1082. else if (tabIndex == 3)
  1083. {
  1084. publicUltraGridDataCJBase10_2.Ug.UpdateData();
  1085. cnt = publicUltraGridDataCJBase10_2.DataTable.Rows.Cast<DataRow>().Where(
  1086. a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
  1087. }
  1088. else if (tabIndex == 4)
  1089. {
  1090. publicUltraGridDataCJBase11_2.Ug.UpdateData();
  1091. cnt = publicUltraGridDataCJBase11_2.DataTable.Rows.Cast<DataRow>().Where(
  1092. a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
  1093. }
  1094. else if (tabIndex == 5)
  1095. {
  1096. publicUltraGridDataCJBase12_2.Ug.UpdateData();
  1097. cnt = publicUltraGridDataCJBase12_2.DataTable.Rows.Cast<DataRow>().Where(
  1098. a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
  1099. }
  1100. if (cnt > 0)
  1101. {
  1102. if (MessageUtil.ShowYesNoAndQuestion("数据有变更您确定要放弃吗?") == System.Windows.Forms.DialogResult.No)
  1103. {
  1104. e.Cancel = true;
  1105. }
  1106. }
  1107. }
  1108. #endregion
  1109. private void FrmLabMecHardnessDataCJ_Shown(object sender, EventArgs e)
  1110. {
  1111. if (toolMenu == null) return;
  1112. if (ultraTabControl1.SelectedTab.Index == 0)
  1113. {
  1114. if (toolMenu.Toolbars[0].Tools.Exists("Add"))
  1115. {
  1116. toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.True;
  1117. }
  1118. if (toolMenu.Toolbars[0].Tools.Exists("Update"))
  1119. {
  1120. this.toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.False;
  1121. }
  1122. if (toolMenu.Toolbars[0].Tools.Exists("Delete"))
  1123. {
  1124. toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.False;
  1125. }
  1126. if (toolMenu.Toolbars[0].Tools.Exists("Audit"))
  1127. {
  1128. toolMenu.Toolbars[0].Tools["Audit"].InstanceProps.Visible = DefaultableBoolean.False;
  1129. }
  1130. if (toolMenu.Toolbars[0].Tools.Exists("CancelAudit"))
  1131. {
  1132. toolMenu.Toolbars[0].Tools["CancelAudit"].InstanceProps.Visible = DefaultableBoolean.False;
  1133. }
  1134. if (toolMenu.Toolbars[0].Tools.Exists("SingleAudit"))
  1135. {
  1136. toolMenu.Toolbars[0].Tools["SingleAudit"].InstanceProps.Visible = DefaultableBoolean.False;
  1137. }
  1138. if (toolMenu.Toolbars[0].Tools.Exists("CancelSingleAudit"))
  1139. {
  1140. toolMenu.Toolbars[0].Tools["CancelSingleAudit"].InstanceProps.Visible = DefaultableBoolean.False;
  1141. }
  1142. }
  1143. else if (ultraTabControl1.SelectedTab.Index == 1)
  1144. {
  1145. if (toolMenu.Toolbars[0].Tools.Exists("Add"))
  1146. {
  1147. toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.False;
  1148. }
  1149. if (toolMenu.Toolbars[0].Tools.Exists("Update"))
  1150. {
  1151. this.toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.True;
  1152. }
  1153. if (toolMenu.Toolbars[0].Tools.Exists("Delete"))
  1154. {
  1155. toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.True;
  1156. }
  1157. if (toolMenu.Toolbars[0].Tools.Exists("Audit"))
  1158. {
  1159. toolMenu.Toolbars[0].Tools["Audit"].InstanceProps.Visible = DefaultableBoolean.False;
  1160. }
  1161. if (toolMenu.Toolbars[0].Tools.Exists("CancelAudit"))
  1162. {
  1163. toolMenu.Toolbars[0].Tools["CancelAudit"].InstanceProps.Visible = DefaultableBoolean.False;
  1164. }
  1165. if (toolMenu.Toolbars[0].Tools.Exists("SingleAudit"))
  1166. {
  1167. toolMenu.Toolbars[0].Tools["SingleAudit"].InstanceProps.Visible = DefaultableBoolean.False;
  1168. }
  1169. if (toolMenu.Toolbars[0].Tools.Exists("CancelSingleAudit"))
  1170. {
  1171. toolMenu.Toolbars[0].Tools["CancelSingleAudit"].InstanceProps.Visible = DefaultableBoolean.False;
  1172. }
  1173. }
  1174. else if (ultraTabControl1.SelectedTab.Index == 2)
  1175. {
  1176. if (toolMenu.Toolbars[0].Tools.Exists("Add"))
  1177. {
  1178. toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.False;
  1179. }
  1180. if (toolMenu.Toolbars[0].Tools.Exists("Update"))
  1181. {
  1182. this.toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.False;
  1183. }
  1184. if (toolMenu.Toolbars[0].Tools.Exists("Delete"))
  1185. {
  1186. toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.False;
  1187. }
  1188. if (toolMenu.Toolbars[0].Tools.Exists("Audit"))
  1189. {
  1190. toolMenu.Toolbars[0].Tools["Audit"].InstanceProps.Visible = DefaultableBoolean.True;
  1191. }
  1192. if (toolMenu.Toolbars[0].Tools.Exists("CancelAudit"))
  1193. {
  1194. toolMenu.Toolbars[0].Tools["CancelAudit"].InstanceProps.Visible = DefaultableBoolean.False;
  1195. }
  1196. if (toolMenu.Toolbars[0].Tools.Exists("SingleAudit"))
  1197. {
  1198. toolMenu.Toolbars[0].Tools["SingleAudit"].InstanceProps.Visible = DefaultableBoolean.True;
  1199. }
  1200. if (toolMenu.Toolbars[0].Tools.Exists("CancelSingleAudit"))
  1201. {
  1202. toolMenu.Toolbars[0].Tools["CancelSingleAudit"].InstanceProps.Visible = DefaultableBoolean.False;
  1203. }
  1204. }
  1205. else if (ultraTabControl1.SelectedTab.Index == 3)
  1206. {
  1207. if (toolMenu.Toolbars[0].Tools.Exists("Add"))
  1208. {
  1209. toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.False;
  1210. }
  1211. if (toolMenu.Toolbars[0].Tools.Exists("Update"))
  1212. {
  1213. this.toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.False;
  1214. }
  1215. if (toolMenu.Toolbars[0].Tools.Exists("Delete"))
  1216. {
  1217. toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.False;
  1218. }
  1219. if (toolMenu.Toolbars[0].Tools.Exists("Audit"))
  1220. {
  1221. toolMenu.Toolbars[0].Tools["Audit"].InstanceProps.Visible = DefaultableBoolean.False;
  1222. }
  1223. if (toolMenu.Toolbars[0].Tools.Exists("CancelAudit"))
  1224. {
  1225. toolMenu.Toolbars[0].Tools["CancelAudit"].InstanceProps.Visible = DefaultableBoolean.True;
  1226. }
  1227. if (toolMenu.Toolbars[0].Tools.Exists("SingleAudit"))
  1228. {
  1229. toolMenu.Toolbars[0].Tools["SingleAudit"].InstanceProps.Visible = DefaultableBoolean.False;
  1230. }
  1231. if (toolMenu.Toolbars[0].Tools.Exists("CancelSingleAudit"))
  1232. {
  1233. toolMenu.Toolbars[0].Tools["CancelSingleAudit"].InstanceProps.Visible = DefaultableBoolean.True;
  1234. }
  1235. }
  1236. }
  1237. private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
  1238. {
  1239. if (toolMenu == null) return;
  1240. if (ultraTabControl1.SelectedTab.Index == 0)
  1241. {
  1242. if (toolMenu.Toolbars[0].Tools.Exists("Add"))
  1243. {
  1244. toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.True;
  1245. }
  1246. if (toolMenu.Toolbars[0].Tools.Exists("Update"))
  1247. {
  1248. this.toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.False;
  1249. }
  1250. if (toolMenu.Toolbars[0].Tools.Exists("Delete"))
  1251. {
  1252. toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.False;
  1253. }
  1254. if (toolMenu.Toolbars[0].Tools.Exists("Audit"))
  1255. {
  1256. toolMenu.Toolbars[0].Tools["Audit"].InstanceProps.Visible = DefaultableBoolean.False;
  1257. }
  1258. if (toolMenu.Toolbars[0].Tools.Exists("CancelAudit"))
  1259. {
  1260. toolMenu.Toolbars[0].Tools["CancelAudit"].InstanceProps.Visible = DefaultableBoolean.False;
  1261. }
  1262. if (toolMenu.Toolbars[0].Tools.Exists("SingleAudit"))
  1263. {
  1264. toolMenu.Toolbars[0].Tools["SingleAudit"].InstanceProps.Visible = DefaultableBoolean.False;
  1265. }
  1266. if (toolMenu.Toolbars[0].Tools.Exists("CancelSingleAudit"))
  1267. {
  1268. toolMenu.Toolbars[0].Tools["CancelSingleAudit"].InstanceProps.Visible = DefaultableBoolean.False;
  1269. }
  1270. }
  1271. else if (ultraTabControl1.SelectedTab.Index == 1)
  1272. {
  1273. if (toolMenu.Toolbars[0].Tools.Exists("Add"))
  1274. {
  1275. toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.False;
  1276. }
  1277. if (toolMenu.Toolbars[0].Tools.Exists("Update"))
  1278. {
  1279. this.toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.True;
  1280. }
  1281. if (toolMenu.Toolbars[0].Tools.Exists("Delete"))
  1282. {
  1283. toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.True;
  1284. }
  1285. if (toolMenu.Toolbars[0].Tools.Exists("Audit"))
  1286. {
  1287. toolMenu.Toolbars[0].Tools["Audit"].InstanceProps.Visible = DefaultableBoolean.False;
  1288. }
  1289. if (toolMenu.Toolbars[0].Tools.Exists("CancelAudit"))
  1290. {
  1291. toolMenu.Toolbars[0].Tools["CancelAudit"].InstanceProps.Visible = DefaultableBoolean.False;
  1292. }
  1293. if (toolMenu.Toolbars[0].Tools.Exists("SingleAudit"))
  1294. {
  1295. toolMenu.Toolbars[0].Tools["SingleAudit"].InstanceProps.Visible = DefaultableBoolean.False;
  1296. }
  1297. if (toolMenu.Toolbars[0].Tools.Exists("CancelSingleAudit"))
  1298. {
  1299. toolMenu.Toolbars[0].Tools["CancelSingleAudit"].InstanceProps.Visible = DefaultableBoolean.False;
  1300. }
  1301. }
  1302. else if (ultraTabControl1.SelectedTab.Index == 2)
  1303. {
  1304. if (toolMenu.Toolbars[0].Tools.Exists("Add"))
  1305. {
  1306. toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.False;
  1307. }
  1308. if (toolMenu.Toolbars[0].Tools.Exists("Update"))
  1309. {
  1310. this.toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.False;
  1311. }
  1312. if (toolMenu.Toolbars[0].Tools.Exists("Delete"))
  1313. {
  1314. toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.False;
  1315. }
  1316. if (toolMenu.Toolbars[0].Tools.Exists("Audit"))
  1317. {
  1318. toolMenu.Toolbars[0].Tools["Audit"].InstanceProps.Visible = DefaultableBoolean.True;
  1319. }
  1320. if (toolMenu.Toolbars[0].Tools.Exists("CancelAudit"))
  1321. {
  1322. toolMenu.Toolbars[0].Tools["CancelAudit"].InstanceProps.Visible = DefaultableBoolean.False;
  1323. }
  1324. if (toolMenu.Toolbars[0].Tools.Exists("SingleAudit"))
  1325. {
  1326. toolMenu.Toolbars[0].Tools["SingleAudit"].InstanceProps.Visible = DefaultableBoolean.True;
  1327. }
  1328. if (toolMenu.Toolbars[0].Tools.Exists("CancelSingleAudit"))
  1329. {
  1330. toolMenu.Toolbars[0].Tools["CancelSingleAudit"].InstanceProps.Visible = DefaultableBoolean.False;
  1331. }
  1332. }
  1333. else if (ultraTabControl1.SelectedTab.Index == 3)
  1334. {
  1335. if (toolMenu.Toolbars[0].Tools.Exists("Add"))
  1336. {
  1337. toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.False;
  1338. }
  1339. if (toolMenu.Toolbars[0].Tools.Exists("Update"))
  1340. {
  1341. this.toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.False;
  1342. }
  1343. if (toolMenu.Toolbars[0].Tools.Exists("Delete"))
  1344. {
  1345. toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.False;
  1346. }
  1347. if (toolMenu.Toolbars[0].Tools.Exists("Audit"))
  1348. {
  1349. toolMenu.Toolbars[0].Tools["Audit"].InstanceProps.Visible = DefaultableBoolean.False;
  1350. }
  1351. if (toolMenu.Toolbars[0].Tools.Exists("CancelAudit"))
  1352. {
  1353. toolMenu.Toolbars[0].Tools["CancelAudit"].InstanceProps.Visible = DefaultableBoolean.True;
  1354. }
  1355. if (toolMenu.Toolbars[0].Tools.Exists("SingleAudit"))
  1356. {
  1357. toolMenu.Toolbars[0].Tools["SingleAudit"].InstanceProps.Visible = DefaultableBoolean.False;
  1358. }
  1359. if (toolMenu.Toolbars[0].Tools.Exists("CancelSingleAudit"))
  1360. {
  1361. toolMenu.Toolbars[0].Tools["CancelSingleAudit"].InstanceProps.Visible = DefaultableBoolean.True;
  1362. }
  1363. }
  1364. }
  1365. //线程扫描串口数据
  1366. public void MainThread()
  1367. {
  1368. //判断串口对应的采集仪器类型
  1369. while (true)
  1370. {
  1371. try
  1372. {
  1373. }
  1374. catch (Exception ex)
  1375. {
  1376. Thread.Sleep(10000);
  1377. }
  1378. }
  1379. }
  1380. }
  1381. }