FrmLabMecDataCJAudit.cs 123 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124212521262127212821292130213121322133213421352136213721382139214021412142214321442145214621472148214921502151215221532154215521562157215821592160216121622163216421652166216721682169217021712172217321742175217621772178217921802181218221832184218521862187218821892190219121922193219421952196219721982199220022012202220322042205220622072208220922102211221222132214221522162217221822192220222122222223222422252226222722282229223022312232223322342235223622372238223922402241224222432244224522462247224822492250225122522253225422552256225722582259226022612262226322642265226622672268226922702271227222732274227522762277227822792280228122822283228422852286228722882289229022912292229322942295229622972298229923002301230223032304230523062307230823092310231123122313231423152316231723182319232023212322232323242325232623272328232923302331233223332334233523362337233823392340234123422343234423452346234723482349235023512352235323542355235623572358235923602361236223632364236523662367236823692370237123722373
  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. namespace Core.StlMes.Client.Lims.Data.PipeAndOutdec
  16. {
  17. //材料力学录入界面 各检验大项分Tab页展示
  18. public partial class FrmLabMecDataCJAudit : FrmBase
  19. {
  20. private string[] arrId;//数据权限
  21. private string[] plineCodes = { };
  22. private DataTable m_dtPhyMax;//存放所有要检验的项目
  23. private DataTable m_dtPhyItems;//存放所有要检验的项目试验方法
  24. private DataTable m_dtPhyMaxAdd;//存放所有已检验的项目
  25. private DataTable m_dtPhyItemsAdd;//存放所有已检验的项目试验方法
  26. private DataTable m_dtPhyMaxAudit;
  27. private DataTable m_dtPhyItemsAudit;
  28. private DataTable m_dtPhyMaxAuditAdd;
  29. private DataTable m_dtPhyItemsAuditAdd;
  30. private int tabIndex = 0;//保存当前的tab页
  31. public FrmLabMecDataCJAudit()
  32. {
  33. InitializeComponent();
  34. }
  35. protected override void OnLoad(EventArgs e)
  36. {
  37. base.OnLoad(e);
  38. //publicUltraGridBase1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头
  39. //publicUltraGridBase2.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头
  40. publicUltraGridBase1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
  41. publicUltraGridBase2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
  42. publicUltraGridDataCJBase1_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头 拉伸
  43. publicUltraGridDataCJBase1_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//
  44. publicUltraGridDataCJBase1_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//
  45. publicUltraGridDataCJBase2_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头
  46. publicUltraGridDataCJBase2_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
  47. publicUltraGridDataCJBase2_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
  48. publicUltraGridDataCJBase3_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
  49. publicUltraGridDataCJBase3_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
  50. publicUltraGridDataCJBase3_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
  51. publicUltraGridDataCJBase4_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
  52. publicUltraGridDataCJBase4_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
  53. publicUltraGridDataCJBase4_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
  54. publicUltraGridDataCJBase5_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
  55. publicUltraGridDataCJBase5_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
  56. publicUltraGridDataCJBase5_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
  57. publicUltraGridDataCJBase6_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
  58. publicUltraGridDataCJBase6_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
  59. publicUltraGridDataCJBase6_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
  60. publicUltraGridDataCJBase7_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头 拉伸
  61. publicUltraGridDataCJBase7_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//
  62. publicUltraGridDataCJBase7_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//
  63. publicUltraGridDataCJBase8_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头
  64. publicUltraGridDataCJBase8_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
  65. publicUltraGridDataCJBase8_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
  66. publicUltraGridDataCJBase9_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
  67. publicUltraGridDataCJBase9_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
  68. publicUltraGridDataCJBase9_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
  69. publicUltraGridDataCJBase10_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
  70. publicUltraGridDataCJBase10_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
  71. publicUltraGridDataCJBase10_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
  72. publicUltraGridDataCJBase11_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
  73. publicUltraGridDataCJBase11_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
  74. publicUltraGridDataCJBase11_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
  75. publicUltraGridDataCJBase12_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
  76. publicUltraGridDataCJBase12_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
  77. publicUltraGridDataCJBase12_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
  78. publicUltraGridDataCJBase13_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头 拉伸
  79. publicUltraGridDataCJBase13_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//
  80. publicUltraGridDataCJBase13_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//
  81. publicUltraGridDataCJBase14_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头
  82. publicUltraGridDataCJBase14_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
  83. publicUltraGridDataCJBase14_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
  84. publicUltraGridDataCJBase15_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
  85. publicUltraGridDataCJBase15_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
  86. publicUltraGridDataCJBase15_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
  87. publicUltraGridDataCJBase16_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
  88. publicUltraGridDataCJBase16_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
  89. publicUltraGridDataCJBase16_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
  90. publicUltraGridDataCJBase17_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
  91. publicUltraGridDataCJBase17_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
  92. publicUltraGridDataCJBase17_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
  93. publicUltraGridDataCJBase18_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
  94. publicUltraGridDataCJBase18_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
  95. publicUltraGridDataCJBase18_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
  96. ultraGrid1.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
  97. ultraGrid2.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
  98. publicUltraGridDataCJBase19_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头 拉伸
  99. publicUltraGridDataCJBase19_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//
  100. publicUltraGridDataCJBase19_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//
  101. publicUltraGridDataCJBase20_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头
  102. publicUltraGridDataCJBase20_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
  103. publicUltraGridDataCJBase20_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
  104. publicUltraGridDataCJBase21_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
  105. publicUltraGridDataCJBase21_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
  106. publicUltraGridDataCJBase21_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
  107. publicUltraGridDataCJBase22_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
  108. publicUltraGridDataCJBase22_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
  109. publicUltraGridDataCJBase22_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
  110. publicUltraGridDataCJBase23_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
  111. publicUltraGridDataCJBase23_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
  112. publicUltraGridDataCJBase23_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
  113. publicUltraGridDataCJBase24_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
  114. publicUltraGridDataCJBase24_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
  115. publicUltraGridDataCJBase24_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
  116. //ultraGrid2.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
  117. //ultraGrid2.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
  118. }
  119. private void FrmDataCJBase_Load(object sender, EventArgs e)
  120. {
  121. //arrId = this.ValidDataPurviewIds;//获取数据权限
  122. arrId = new string[] { "002001007009" };//力学项目
  123. plineCodes = comm.GetPlineCode(ValidDataPurviewIds, ob);
  124. InitColumns();
  125. }
  126. private void InitColumns()
  127. {
  128. pipeShowBase1.ChangeLabel();
  129. pipeShowBase2.ChangeLabel();
  130. //未录入
  131. publicUltraGridBase1.PublicUltraGridBaseActive += new EventHandler(pipeUltraGridBase1_PublicUltraGridBaseActive);//调用委托事件
  132. publicUltraGridBase1.InitColumnsPipeBase(new string[] { "CHECK_NO", "SAMPLE_NO" }, true, null);
  133. //string[] arrColumnsBase = new string[] { "CHECK_NO", "SAMPLE_NO", "HEAT_NO", "STEEL_GRADE", "STEEL_NO", "PRODUCT_STD", "CONTRACT_NO", "DIMATER", "HEIGHT", "CONSIGN_DEPT", "CONSIGN_NAME", "CONSIGN_TIME", "ISPRODUCER", "SPEC_REQ", "FLAG", "FLAG_DESC", "REMARK" };
  134. //string[] arrCaptionBase = new string[] { "检验编号", "样管号", "炉号", "钢级", "钢号", "技术标准", "合同号", "外径", "壁厚", "委托单位", "委托人", "委托时间", "是否监制", "特殊要求", "标志位", "标志位", "备注" };
  135. //publicUltraGridBase1.InitColumns(arrColumnsBase, arrCaptionBase);
  136. //publicUltraGridBase1.setColumnShowOrHidden(new string[] { "CHECK_NO", "SAMPLE_NO", }, true);//显示列
  137. //publicUltraGridBase1.setOtherColumnReadOnly(null);//可编辑列
  138. publicUltraGridDataCJBase1_1.InitColumnsPhyConfigItems();
  139. publicUltraGridDataCJBase1_2.InitColumnsPhyDetail();
  140. publicUltraGridDataCJBase2_1.InitColumnsPhyConfigItems();
  141. publicUltraGridDataCJBase2_2.InitColumnsPhyDetail();
  142. publicUltraGridDataCJBase3_1.InitColumnsPhyConfigItems();
  143. publicUltraGridDataCJBase3_2.InitColumnsPhyDetail();
  144. publicUltraGridDataCJBase4_1.InitColumnsPhyConfigItems();
  145. publicUltraGridDataCJBase4_2.InitColumnsPhyDetail();
  146. publicUltraGridDataCJBase5_1.InitColumnsPhyConfigItems();
  147. publicUltraGridDataCJBase5_2.InitColumnsPhyDetail();
  148. publicUltraGridDataCJBase6_1.InitColumnsPhyConfigItems();
  149. publicUltraGridDataCJBase6_2.InitColumnsPhyDetail();
  150. //已录入
  151. publicUltraGridBase2.PublicUltraGridBaseActive += new EventHandler(pipeUltraGridBase2_PublicUltraGridBaseActive);//调用委托事件
  152. publicUltraGridBase2.InitColumnsPipeBase(new string[] { "CHECK_NO", "SAMPLE_NO" }, true, null);
  153. //publicUltraGridBase2.InitColumns(arrColumnsBase, arrCaptionBase);
  154. //publicUltraGridBase2.setColumnShowOrHidden(new string[] { "CHECK_NO", "SAMPLE_NO", }, true);//显示列
  155. //publicUltraGridBase2.setOtherColumnReadOnly(new string[] { null });//可编辑列
  156. publicUltraGridDataCJBase7_1.InitColumnsPhyConfigItems();
  157. publicUltraGridDataCJBase7_2.InitColumnsPhyDetail();
  158. publicUltraGridDataCJBase8_1.InitColumnsPhyConfigItems();
  159. publicUltraGridDataCJBase8_2.InitColumnsPhyDetail();
  160. publicUltraGridDataCJBase9_1.InitColumnsPhyConfigItems();
  161. publicUltraGridDataCJBase9_2.InitColumnsPhyDetail();
  162. publicUltraGridDataCJBase10_1.InitColumnsPhyConfigItems();
  163. publicUltraGridDataCJBase10_2.InitColumnsPhyDetail();
  164. publicUltraGridDataCJBase11_1.InitColumnsPhyConfigItems();
  165. publicUltraGridDataCJBase11_2.InitColumnsPhyDetail();
  166. publicUltraGridDataCJBase12_1.InitColumnsPhyConfigItems();
  167. publicUltraGridDataCJBase12_2.InitColumnsPhyDetail();
  168. PublicPipeAndOutdec.setColumnShowOrHidden(ultraGrid1, new string[] { "CHK", "CHECK_NO" }, true);
  169. PublicPipeAndOutdec.setColumnShowOrHidden(ultraGrid1, new string[] { "CHK", "SAMPLE_NO" }, true, 1);//显示列
  170. PublicPipeAndOutdec.setOtherColumnReadOnly(ultraGrid1, new string[] { "CHK" });//可编辑列
  171. PublicPipeAndOutdec.setOtherColumnReadOnly(ultraGrid1, new string[] { "CHK" }, 1);
  172. publicUltraGridDataCJBase13_1.InitColumnsPhyConfigItems(null);
  173. publicUltraGridDataCJBase13_1.setOtherColumnReadOnly(null);
  174. publicUltraGridDataCJBase13_2.InitColumnsPhyDetail(null);
  175. publicUltraGridDataCJBase13_2.setOtherColumnReadOnly(null);
  176. publicUltraGridDataCJBase14_1.InitColumnsPhyConfigItems(null);
  177. publicUltraGridDataCJBase14_1.setOtherColumnReadOnly(null);
  178. publicUltraGridDataCJBase14_2.InitColumnsPhyDetail(null);
  179. publicUltraGridDataCJBase14_2.setOtherColumnReadOnly(null);
  180. publicUltraGridDataCJBase15_1.InitColumnsPhyConfigItems(null);
  181. publicUltraGridDataCJBase15_1.setOtherColumnReadOnly(null);
  182. publicUltraGridDataCJBase15_2.InitColumnsPhyDetail(null);
  183. publicUltraGridDataCJBase15_2.setOtherColumnReadOnly(null);
  184. publicUltraGridDataCJBase16_1.InitColumnsPhyConfigItems(null);
  185. publicUltraGridDataCJBase16_2.InitColumnsPhyDetail(null);
  186. publicUltraGridDataCJBase17_1.InitColumnsPhyConfigItems(null);
  187. publicUltraGridDataCJBase17_2.InitColumnsPhyDetail(null);
  188. publicUltraGridDataCJBase18_1.InitColumnsPhyConfigItems(null);
  189. publicUltraGridDataCJBase18_2.InitColumnsPhyDetail(null);
  190. PublicPipeAndOutdec.setColumnShowOrHidden(ultraGrid2, new string[] { "CHK", "CHECK_NO" }, true);
  191. PublicPipeAndOutdec.setColumnShowOrHidden(ultraGrid2, new string[] { "CHK", "SAMPLE_NO" }, true, 1);//显示列
  192. PublicPipeAndOutdec.setOtherColumnReadOnly(ultraGrid2, new string[] { "CHK" });//可编辑列
  193. PublicPipeAndOutdec.setOtherColumnReadOnly(ultraGrid2, new string[] { "CHK" }, 1);
  194. publicUltraGridDataCJBase19_1.InitColumnsPhyConfigItems(null);
  195. publicUltraGridDataCJBase19_2.InitColumnsPhyDetail(null);
  196. publicUltraGridDataCJBase20_1.InitColumnsPhyConfigItems(null);
  197. publicUltraGridDataCJBase20_2.InitColumnsPhyDetail(null);
  198. publicUltraGridDataCJBase21_1.InitColumnsPhyConfigItems(null);
  199. publicUltraGridDataCJBase21_2.InitColumnsPhyDetail(null);
  200. publicUltraGridDataCJBase22_1.InitColumnsPhyConfigItems(null);
  201. publicUltraGridDataCJBase22_2.InitColumnsPhyDetail(null);
  202. publicUltraGridDataCJBase23_1.InitColumnsPhyConfigItems(null);
  203. publicUltraGridDataCJBase23_2.InitColumnsPhyDetail(null);
  204. publicUltraGridDataCJBase24_1.InitColumnsPhyConfigItems(null);
  205. publicUltraGridDataCJBase24_2.InitColumnsPhyDetail(null);
  206. }
  207. /// <summary>
  208. /// 重写基类方法
  209. /// </summary>
  210. /// <param name="sender"></param>
  211. /// <param name="ToolbarKey"></param>
  212. public override void ToolBar_Click(object sender, string ToolbarKey)
  213. {
  214. //查询、确认、退出
  215. switch (ToolbarKey)
  216. {
  217. case "Query":
  218. if (ultraTabControl1.SelectedTab.Index == 0)
  219. {
  220. QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase1, "2");
  221. }
  222. else if (ultraTabControl1.SelectedTab.Index == 1)
  223. {
  224. QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase2, "3456");
  225. }
  226. else if (ultraTabControl1.SelectedTab.Index == 2)
  227. {
  228. QueryCheckConsignBaseDetail_Distinct(ultraGrid1, "3");
  229. }
  230. else if (ultraTabControl1.SelectedTab.Index == 3)
  231. {
  232. QueryCheckConsignBaseDetail_Distinct(ultraGrid2, "456");
  233. }
  234. break;
  235. case "Add":
  236. if (ultraTabControl2.SelectedTab.Index == 0)
  237. {
  238. AddCheckConsignProcessResult(publicUltraGridDataCJBase1_2, publicUltraGridDataCJBase1_1);
  239. }
  240. else if (ultraTabControl2.SelectedTab.Index == 1)
  241. {
  242. AddCheckConsignProcessResult(publicUltraGridDataCJBase2_2, publicUltraGridDataCJBase2_1);
  243. }
  244. else if (ultraTabControl2.SelectedTab.Index == 2)
  245. {
  246. AddCheckConsignProcessResult(publicUltraGridDataCJBase3_2, publicUltraGridDataCJBase3_1);
  247. }
  248. else if (ultraTabControl2.SelectedTab.Index == 3)
  249. {
  250. AddCheckConsignProcessResult(publicUltraGridDataCJBase4_2, publicUltraGridDataCJBase4_1);
  251. }
  252. else if (ultraTabControl2.SelectedTab.Index == 4)
  253. {
  254. AddCheckConsignProcessResult(publicUltraGridDataCJBase5_2, publicUltraGridDataCJBase5_1);
  255. }
  256. else if (ultraTabControl2.SelectedTab.Index == 5)
  257. {
  258. AddCheckConsignProcessResult(publicUltraGridDataCJBase6_2, publicUltraGridDataCJBase6_1);
  259. }
  260. break;
  261. case "Update":
  262. if (ultraTabControl3.SelectedTab.Index == 0)
  263. {
  264. UpdateCheckConsignProcessResult(publicUltraGridDataCJBase7_2, publicUltraGridDataCJBase7_1);
  265. }
  266. else if (ultraTabControl3.SelectedTab.Index == 1)
  267. {
  268. UpdateCheckConsignProcessResult(publicUltraGridDataCJBase8_2, publicUltraGridDataCJBase8_1);
  269. }
  270. else if (ultraTabControl3.SelectedTab.Index == 2)
  271. {
  272. UpdateCheckConsignProcessResult(publicUltraGridDataCJBase9_2, publicUltraGridDataCJBase9_1);
  273. }
  274. else if (ultraTabControl3.SelectedTab.Index == 3)
  275. {
  276. UpdateCheckConsignProcessResult(publicUltraGridDataCJBase10_2, publicUltraGridDataCJBase10_1);
  277. }
  278. else if (ultraTabControl3.SelectedTab.Index == 4)
  279. {
  280. UpdateCheckConsignProcessResult(publicUltraGridDataCJBase11_2, publicUltraGridDataCJBase11_1);
  281. }
  282. else if (ultraTabControl3.SelectedTab.Index == 5)
  283. {
  284. UpdateCheckConsignProcessResult(publicUltraGridDataCJBase12_2, publicUltraGridDataCJBase12_1);
  285. }
  286. //UpdateCheckConsignProcessResult();
  287. break;
  288. case "Delete":
  289. if (ultraTabControl3.SelectedTab.Index == 0)
  290. {
  291. DeleteCheckConsignProcessResult(publicUltraGridDataCJBase7_2, publicUltraGridDataCJBase7_1);
  292. }
  293. else if (ultraTabControl3.SelectedTab.Index == 1)
  294. {
  295. DeleteCheckConsignProcessResult(publicUltraGridDataCJBase8_2, publicUltraGridDataCJBase8_1);
  296. }
  297. else if (ultraTabControl3.SelectedTab.Index == 2)
  298. {
  299. DeleteCheckConsignProcessResult(publicUltraGridDataCJBase9_2, publicUltraGridDataCJBase9_1);
  300. }
  301. else if (ultraTabControl3.SelectedTab.Index == 3)
  302. {
  303. DeleteCheckConsignProcessResult(publicUltraGridDataCJBase10_2, publicUltraGridDataCJBase10_1);
  304. }
  305. else if (ultraTabControl3.SelectedTab.Index == 4)
  306. {
  307. DeleteCheckConsignProcessResult(publicUltraGridDataCJBase11_2, publicUltraGridDataCJBase11_1);
  308. }
  309. else if (ultraTabControl3.SelectedTab.Index == 5)
  310. {
  311. DeleteCheckConsignProcessResult(publicUltraGridDataCJBase12_2, publicUltraGridDataCJBase12_1);
  312. }
  313. //DeleteCheckConsignProcessResult();
  314. break;
  315. case "Audit":
  316. AuditCheckConsignDetail();//SingleAuditCheckConsignDetail()
  317. break;
  318. case "CancelAudit":
  319. CancelAuditCheckConsignDetail();//SingleAuditCheckConsignDetail()
  320. break;
  321. case "SingleAudit":
  322. if (ultraTabControl4.SelectedTab.Index == 0)
  323. {
  324. SingleAuditCheckConsignDetail(publicUltraGridDataCJBase13_2);
  325. }
  326. else if (ultraTabControl4.SelectedTab.Index == 1)
  327. {
  328. SingleAuditCheckConsignDetail(publicUltraGridDataCJBase14_2);
  329. }
  330. else if (ultraTabControl4.SelectedTab.Index == 2)
  331. {
  332. SingleAuditCheckConsignDetail(publicUltraGridDataCJBase15_2);
  333. }
  334. else if (ultraTabControl4.SelectedTab.Index == 3)
  335. {
  336. SingleAuditCheckConsignDetail(publicUltraGridDataCJBase16_2);
  337. }
  338. else if (ultraTabControl4.SelectedTab.Index == 4)
  339. {
  340. SingleAuditCheckConsignDetail(publicUltraGridDataCJBase17_2);
  341. }
  342. else if (ultraTabControl4.SelectedTab.Index == 5)
  343. {
  344. SingleAuditCheckConsignDetail(publicUltraGridDataCJBase18_2);
  345. }
  346. break;
  347. case "CancelSingleAudit":
  348. if (ultraTabControl5.SelectedTab.Index == 0)
  349. {
  350. CancelSingleAuditCheckConsignDetail(publicUltraGridDataCJBase19_2);
  351. }
  352. else if (ultraTabControl5.SelectedTab.Index == 1)
  353. {
  354. CancelSingleAuditCheckConsignDetail(publicUltraGridDataCJBase20_2);
  355. }
  356. else if (ultraTabControl5.SelectedTab.Index == 2)
  357. {
  358. CancelSingleAuditCheckConsignDetail(publicUltraGridDataCJBase21_2);
  359. }
  360. else if (ultraTabControl5.SelectedTab.Index == 3)
  361. {
  362. CancelSingleAuditCheckConsignDetail(publicUltraGridDataCJBase22_2);
  363. }
  364. else if (ultraTabControl5.SelectedTab.Index == 4)
  365. {
  366. CancelSingleAuditCheckConsignDetail(publicUltraGridDataCJBase23_2);
  367. }
  368. else if (ultraTabControl5.SelectedTab.Index == 5)
  369. {
  370. CancelSingleAuditCheckConsignDetail(publicUltraGridDataCJBase24_2);
  371. }
  372. break;
  373. case "Close":
  374. if (MessageUtil.ShowYesNoAndQuestion("是否确认关闭页面?") == DialogResult.Yes)
  375. {
  376. this.Close();
  377. }
  378. break;
  379. }
  380. }
  381. #region 公共方法
  382. //颜色改变
  383. private void ChangeColor(DataTable dtPhyMax, Infragistics.Win.UltraWinTabControl.UltraTabControl ultraTabControl)
  384. {
  385. if (dtPhyMax == null || dtPhyMax.Rows.Count == 0) return;
  386. int i = -1;
  387. if (PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN = 'R0001'") != null && PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN = 'R0001'").Rows.Count > 0)
  388. {
  389. i = i == -1 ? i = 0 : i;
  390. ultraTabControl.Tabs[0].Appearance.BackColor = Color.GreenYellow;
  391. }
  392. if (PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN = 'R0002'") != null && PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN = 'R0002'").Rows.Count > 0)
  393. {
  394. i = i == -1 ? i = 1 : i;
  395. ultraTabControl.Tabs[1].Appearance.BackColor = Color.GreenYellow;
  396. }
  397. 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)
  398. {
  399. i = i == -1 ? i = 2 : i;
  400. ultraTabControl.Tabs[2].Appearance.BackColor = Color.GreenYellow;//硬度
  401. }
  402. if (PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN IN ('R0012','R0013')") != null && PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN IN ('R0012','R0013')").Rows.Count > 0)
  403. {
  404. i = i == -1 ? i = 3 : i;
  405. ultraTabControl.Tabs[3].Appearance.BackColor = Color.GreenYellow;//金相
  406. }
  407. if (PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN IN ('R0010')") != null && PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN IN ('R0010')").Rows.Count > 0)
  408. {
  409. i = i == -1 ? i = 4 : i;
  410. ultraTabControl.Tabs[4].Appearance.BackColor = Color.GreenYellow;//工艺
  411. }
  412. 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)
  413. {
  414. i = i == -1 ? i = 5 : i;
  415. ultraTabControl.Tabs[5].Appearance.BackColor = Color.GreenYellow;//其他
  416. }
  417. ultraTabControl.SelectedTab = i == -1 ? ultraTabControl.Tabs[0] : ultraTabControl.Tabs[i];
  418. }
  419. //赋值
  420. private void ClearPhyDetailItems(Infragistics.Win.UltraWinTabControl.UltraTabControl ultraTabControl)
  421. {
  422. //ultraTabControl.SelectedTab = ultraTabControl.Tabs[0];
  423. ultraTabControl.Tabs[0].Appearance.BackColor = Control.DefaultBackColor;
  424. ultraTabControl.Tabs[1].Appearance.BackColor = Control.DefaultBackColor;
  425. ultraTabControl.Tabs[2].Appearance.BackColor = Control.DefaultBackColor;
  426. ultraTabControl.Tabs[3].Appearance.BackColor = Control.DefaultBackColor;
  427. ultraTabControl.Tabs[4].Appearance.BackColor = Control.DefaultBackColor;
  428. ultraTabControl.Tabs[5].Appearance.BackColor = Control.DefaultBackColor;
  429. if (ultraTabControl == ultraTabControl2)
  430. {
  431. publicUltraGridDataCJBase1_1.DataTable.Rows.Clear();
  432. publicUltraGridDataCJBase2_1.DataTable.Rows.Clear();
  433. publicUltraGridDataCJBase3_1.DataTable.Rows.Clear();
  434. publicUltraGridDataCJBase4_1.DataTable.Rows.Clear();
  435. publicUltraGridDataCJBase5_1.DataTable.Rows.Clear();
  436. publicUltraGridDataCJBase6_1.DataTable.Rows.Clear();
  437. publicUltraGridDataCJBase1_2.DataTable.Rows.Clear();
  438. publicUltraGridDataCJBase2_2.DataTable.Rows.Clear();
  439. publicUltraGridDataCJBase3_2.DataTable.Rows.Clear();
  440. publicUltraGridDataCJBase4_2.DataTable.Rows.Clear();
  441. publicUltraGridDataCJBase5_2.DataTable.Rows.Clear();
  442. publicUltraGridDataCJBase6_2.DataTable.Rows.Clear();
  443. splitContainer1.Panel1Collapsed = true;
  444. splitContainer2.Panel1Collapsed = true;
  445. splitContainer3.Panel1Collapsed = true;
  446. splitContainer4.Panel1Collapsed = true;
  447. splitContainer5.Panel1Collapsed = true;
  448. splitContainer6.Panel1Collapsed = true;
  449. }
  450. else if (ultraTabControl == ultraTabControl3)
  451. {
  452. publicUltraGridDataCJBase7_1.DataTable.Rows.Clear();
  453. publicUltraGridDataCJBase8_1.DataTable.Rows.Clear();
  454. publicUltraGridDataCJBase9_1.DataTable.Rows.Clear();
  455. publicUltraGridDataCJBase10_1.DataTable.Rows.Clear();
  456. publicUltraGridDataCJBase11_1.DataTable.Rows.Clear();
  457. publicUltraGridDataCJBase12_1.DataTable.Rows.Clear();
  458. publicUltraGridDataCJBase7_2.DataTable.Rows.Clear();
  459. publicUltraGridDataCJBase8_2.DataTable.Rows.Clear();
  460. publicUltraGridDataCJBase9_2.DataTable.Rows.Clear();
  461. publicUltraGridDataCJBase10_2.DataTable.Rows.Clear();
  462. publicUltraGridDataCJBase11_2.DataTable.Rows.Clear();
  463. publicUltraGridDataCJBase12_2.DataTable.Rows.Clear();
  464. splitContainer7.Panel1Collapsed = true;
  465. splitContainer8.Panel1Collapsed = true;
  466. splitContainer9.Panel1Collapsed = true;
  467. splitContainer10.Panel1Collapsed = true;
  468. splitContainer11.Panel1Collapsed = true;
  469. splitContainer12.Panel1Collapsed = true;
  470. }
  471. else if (ultraTabControl == ultraTabControl4)
  472. {
  473. publicUltraGridDataCJBase13_1.DataTable.Rows.Clear();
  474. publicUltraGridDataCJBase14_1.DataTable.Rows.Clear();
  475. publicUltraGridDataCJBase15_1.DataTable.Rows.Clear();
  476. publicUltraGridDataCJBase16_1.DataTable.Rows.Clear();
  477. publicUltraGridDataCJBase17_1.DataTable.Rows.Clear();
  478. publicUltraGridDataCJBase18_1.DataTable.Rows.Clear();
  479. publicUltraGridDataCJBase13_2.DataTable.Rows.Clear();
  480. publicUltraGridDataCJBase14_2.DataTable.Rows.Clear();
  481. publicUltraGridDataCJBase15_2.DataTable.Rows.Clear();
  482. publicUltraGridDataCJBase16_2.DataTable.Rows.Clear();
  483. publicUltraGridDataCJBase17_2.DataTable.Rows.Clear();
  484. publicUltraGridDataCJBase18_2.DataTable.Rows.Clear();
  485. splitContainer13.Panel1Collapsed = true;
  486. splitContainer14.Panel1Collapsed = true;
  487. splitContainer15.Panel1Collapsed = true;
  488. splitContainer16.Panel1Collapsed = true;
  489. splitContainer17.Panel1Collapsed = true;
  490. splitContainer18.Panel1Collapsed = true;
  491. }
  492. else if (ultraTabControl == ultraTabControl5)
  493. {
  494. publicUltraGridDataCJBase19_1.DataTable.Rows.Clear();
  495. publicUltraGridDataCJBase20_1.DataTable.Rows.Clear();
  496. publicUltraGridDataCJBase21_1.DataTable.Rows.Clear();
  497. publicUltraGridDataCJBase22_1.DataTable.Rows.Clear();
  498. publicUltraGridDataCJBase23_1.DataTable.Rows.Clear();
  499. publicUltraGridDataCJBase24_1.DataTable.Rows.Clear();
  500. publicUltraGridDataCJBase19_2.DataTable.Rows.Clear();
  501. publicUltraGridDataCJBase20_2.DataTable.Rows.Clear();
  502. publicUltraGridDataCJBase21_2.DataTable.Rows.Clear();
  503. publicUltraGridDataCJBase22_2.DataTable.Rows.Clear();
  504. publicUltraGridDataCJBase23_2.DataTable.Rows.Clear();
  505. publicUltraGridDataCJBase24_2.DataTable.Rows.Clear();
  506. splitContainer19.Panel1Collapsed = true;
  507. splitContainer20.Panel1Collapsed = true;
  508. splitContainer21.Panel1Collapsed = true;
  509. splitContainer22.Panel1Collapsed = true;
  510. splitContainer23.Panel1Collapsed = true;
  511. splitContainer24.Panel1Collapsed = true;
  512. }
  513. }
  514. #endregion
  515. #region 录入区域
  516. //查询检验委托基本信息
  517. private void QueryCheckConsignBaseDetail_Distinct(PublicUltraGridBase publicUltraGridBase, string strFlag)
  518. {
  519. try
  520. {
  521. //各试验室各检验项目设置权限
  522. publicUltraGridBase.QueryCheckConsignBaseDetail_Distinct("pipe.PublicPipeBase", pipeQueryBase1.GetQueryInfo(strFlag), this.ob, arrId, plineCodes);
  523. if (publicUltraGridBase.Ug.Rows.Count == 0)
  524. {
  525. if (publicUltraGridBase == publicUltraGridBase1)
  526. {
  527. ClearPhyDetailItems(ultraTabControl2);
  528. }
  529. else if (publicUltraGridBase == publicUltraGridBase2)
  530. {
  531. ClearPhyDetailItems(ultraTabControl3);
  532. }
  533. }
  534. }
  535. catch (Exception e)
  536. {
  537. MessageUtil.ShowWarning(e.Message);
  538. }
  539. }
  540. //查询试验方法项目信息
  541. private void QueryCheckMethodPhyConfigItems(PublicUltraGridDataCJBase publicUltraGridDataCJBase, DataTable dtHide, SplitContainer splitContainer, DataTable dt)
  542. {
  543. try
  544. {
  545. PublicPipeAndOutdec.ChangeSplit(splitContainer, dt);
  546. publicUltraGridDataCJBase.HideNullColumn(dtHide, publicUltraGridDataCJBase.Ug);
  547. publicUltraGridDataCJBase.QueryCheckMethodPhyConfigItems(dt);
  548. //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
  549. }
  550. catch (Exception e)
  551. {
  552. MessageUtil.ShowError(e.Message);
  553. }
  554. }
  555. #endregion
  556. #region 未录入
  557. void pipeUltraGridBase1_PublicUltraGridBaseActive(object sender, EventArgs e)
  558. {
  559. try
  560. {
  561. pipeShowBase1.ShowBaseInfo(publicUltraGridBase1.Ur);
  562. //赋值给全局变量
  563. UltraGridRow ur = publicUltraGridBase1.Ur;
  564. ArrayList arrayList = new ArrayList();
  565. arrayList.Add("2");
  566. arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());//20160523
  567. arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
  568. arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
  569. arrayList.Add(ur.Cells["CHECK_NO"].Text.Trim());
  570. if (arrId != null && arrId.Length > 0)
  571. {
  572. ClearPhyDetailItems(ultraTabControl2);
  573. //查询检验项目明细
  574. DataTable dt = PublicServer.GetData("com.steering.lims.data.pipe.FrmDataCJBase.QueryCheckConsignDetailPhyDetail", new Object[] { arrayList, arrId }, ob);
  575. if (dt == null || dt.Rows.Count == 0)
  576. {
  577. m_dtPhyMax = null;
  578. m_dtPhyItems = null;
  579. return;
  580. }
  581. m_dtPhyMax = dt.Copy();
  582. DataTable dtItems = PublicServer.GetData("com.steering.lims.data.pipe.FrmDataCJBase.QueryCheckMethodPhyConfigItems",
  583. new Object[] { arrayList, arrId }, ob);
  584. if (dtItems == null || dtItems.Rows.Count == 0)
  585. {
  586. m_dtPhyItems = null;
  587. //return;
  588. }
  589. else
  590. {
  591. m_dtPhyItems = dtItems.Copy();
  592. }
  593. ChangeColor(m_dtPhyMax, ultraTabControl2);
  594. AddPhyDetailItems();
  595. }
  596. }
  597. catch (Exception ex)
  598. {
  599. MessageUtil.ShowWarning(ex.Message);
  600. }
  601. }
  602. private void ultraTabControl2_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
  603. {
  604. //if (m_dtPhyMax == null || m_dtPhyMax.Rows.Count == 0) return;
  605. if (toolMenu == null) return;
  606. AddPhyDetailItems();
  607. }
  608. //赋值
  609. private void AddPhyDetailItems()
  610. {
  611. if (m_dtPhyMax == null || m_dtPhyMax.Rows.Count == 0) return;
  612. if (ultraTabControl2.SelectedTab.Index == 0)
  613. {
  614. publicUltraGridDataCJBase1_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN = 'R0001'"));//拉伸
  615. publicUltraGridDataCJBase1_2.DataTable.AcceptChanges();
  616. QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase1_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN = 'R0001'"), splitContainer1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItems, "PHY_CODE_MIN = 'R0001'"));
  617. }
  618. else if (ultraTabControl2.SelectedTab.Index == 1)
  619. {
  620. publicUltraGridDataCJBase2_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN = 'R0002'"));//冲击
  621. publicUltraGridDataCJBase2_2.DataTable.AcceptChanges();
  622. QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase2_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN = 'R0002'"), splitContainer2, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItems, "PHY_CODE_MIN = 'R0002'"));
  623. }
  624. else if (ultraTabControl2.SelectedTab.Index == 2)
  625. {
  626. publicUltraGridDataCJBase3_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN IN ('R0003','R0004','R0005')"));//硬度
  627. publicUltraGridDataCJBase3_2.DataTable.AcceptChanges();
  628. 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')"));
  629. }
  630. else if (ultraTabControl2.SelectedTab.Index == 3)//金相
  631. {
  632. publicUltraGridDataCJBase4_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN IN ('R0012','R0013')"));//金相
  633. publicUltraGridDataCJBase4_2.DataTable.AcceptChanges();
  634. QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase4_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN IN ('R0012','R0013')"), splitContainer4, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItems, "PHY_CODE_MIN IN ('R0012','R0013')"));
  635. }
  636. else if (ultraTabControl2.SelectedTab.Index == 4)//工艺
  637. {
  638. publicUltraGridDataCJBase5_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN IN ('R0010')"));//工艺
  639. publicUltraGridDataCJBase5_2.DataTable.AcceptChanges();
  640. QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase5_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN IN ('R0010')"), splitContainer5, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItems, "PHY_CODE_MIN IN ('R0010')"));
  641. }
  642. else if (ultraTabControl2.SelectedTab.Index == 5)//其他
  643. {
  644. publicUltraGridDataCJBase6_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN NOT IN ('R0001', 'R0002','R0003','R0004','R0005','R0010','R0012','R0013')"));
  645. publicUltraGridDataCJBase6_2.DataTable.AcceptChanges();
  646. 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')"));
  647. }
  648. tabIndex = ultraTabControl2.SelectedTab.Index;
  649. }
  650. //新增检验委托过程结果JHYGG_PHYLX_PROCESS_RESULT,新增之前先删除表里数据
  651. private void AddCheckConsignProcessResult(PublicUltraGridDataCJBase publicUltraGridDataCJBase, PublicUltraGridDataCJBase publicUltraGridDataCJBaseItems)
  652. {
  653. try
  654. {
  655. if (ultraTabControl1.SelectedTab.Index != 0)
  656. {
  657. MessageUtil.ShowWarning("只有在未录入数据页才能进行新增操作!");
  658. return;
  659. }
  660. if (publicUltraGridBase1.Ur == null || publicUltraGridBase1.Ur.Activated == false)
  661. {
  662. MessageUtil.ShowWarning("请选择需要新增的试样信息!");
  663. return;
  664. }
  665. if (publicUltraGridDataCJBase.DataTable == null || publicUltraGridDataCJBase.DataTable.Rows.Count == 0)
  666. {
  667. return;
  668. }
  669. //bool isNullValue = true;
  670. publicUltraGridDataCJBase.Ug.UpdateData();
  671. foreach (DataRow dr in publicUltraGridDataCJBase.DataTable.Rows)
  672. {
  673. 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() == "")
  674. {
  675. MessageUtil.ShowWarning(dr["PHY_NAME"] + "没有录入任何数据不允许新增!");
  676. return;
  677. }
  678. }
  679. if (MessageUtil.ShowYesNoAndQuestion("是否确认新增?") == DialogResult.Yes)
  680. {
  681. string strCHECK_NO = publicUltraGridBase1.Ur.Cells["CHECK_NO"].Text.Trim();
  682. string strSAMPLE_NO = publicUltraGridBase1.Ur.Cells["SAMPLE_NO"].Text.Trim();//定位
  683. ArrayList alAll = new ArrayList();
  684. ArrayList alPhyItems = new ArrayList();//删除信息详细表list
  685. ArrayList alDetail = new ArrayList();//检验信息详细表list
  686. ArrayList alProcessResult = new ArrayList();//化学信息list
  687. ArrayList alPhyItemsParams = new ArrayList();
  688. ArrayList alDetailParams = new ArrayList();//检验信息详细表参数list
  689. ArrayList alProcessResultParams = new ArrayList();//化学信息参数list
  690. string strTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
  691. //获取修改明细表参数JHYGG_CHECKCONSIGN_DETAIL
  692. string row = "";
  693. foreach (DataRow dr in publicUltraGridDataCJBase.DataTable.Rows)
  694. {
  695. if (row.IndexOf(dr["PHY_CODE_MAX"].ToString()) < 0)
  696. {
  697. row += dr["PHY_CODE_MAX"].ToString() + " ";
  698. alDetailParams = new ArrayList();
  699. //alDetailParams.Add(txtCHECK_TEMP.Text.Trim());
  700. //alDetailParams.Add(ultraDEVICE_NO.Text.Trim());
  701. //alDetailParams.Add(ultraDEVICE_NAME.Text.Trim());
  702. //alDetailParams.Add(txtREMARK.Text.Trim());
  703. alDetailParams.Add("");
  704. alDetailParams.Add("");
  705. alDetailParams.Add("");
  706. alDetailParams.Add("");
  707. alDetailParams.Add(UserInfo.GetUserGroupText());//班组
  708. alDetailParams.Add(UserInfo.GetUserName());//录入人
  709. alDetailParams.Add(strTime);//录入时间
  710. alDetailParams.Add("3");//录入标志位
  711. alDetailParams.Add("2");
  712. alDetailParams.Add(dr["PHY_CODE_MAX"].ToString());
  713. alDetailParams.Add(strSAMPLE_NO);
  714. alDetailParams.Add(strCHECK_NO);
  715. alDetail.Add(alDetailParams);
  716. }
  717. }
  718. publicUltraGridDataCJBase.Ug.UpdateData();
  719. foreach (DataRow dr in publicUltraGridDataCJBase.DataTable.Rows)
  720. {
  721. alProcessResultParams = new ArrayList();
  722. alProcessResultParams.Add(dr["VALUE1"].ToString());
  723. alProcessResultParams.Add(dr["VALUE2"].ToString());
  724. alProcessResultParams.Add(dr["VALUE3"].ToString());
  725. alProcessResultParams.Add(dr["VALUE4"].ToString());
  726. alProcessResultParams.Add(dr["VALUE5"].ToString());
  727. alProcessResultParams.Add(dr["VALUE6"].ToString());
  728. alProcessResultParams.Add(dr["VALUE7"].ToString());
  729. alProcessResultParams.Add(dr["VALUE8"].ToString());
  730. alProcessResultParams.Add(dr["VALUE9"].ToString());
  731. alProcessResultParams.Add(dr["VALUE10"].ToString());
  732. alProcessResultParams.Add(dr["VALUE11"].ToString());
  733. alProcessResultParams.Add(dr["VALUE12"].ToString());
  734. alProcessResultParams.Add(dr["VALUE13"].ToString());
  735. alProcessResultParams.Add(dr["VALUE14"].ToString());
  736. alProcessResultParams.Add(dr["VALUE15"].ToString());
  737. alProcessResultParams.Add(dr["PHYDETAIL_ID"].ToString());
  738. alProcessResult.Add(alProcessResultParams);
  739. //alDeleteParams = new ArrayList();
  740. //alDeleteParams.Add(dr["PHYDETAIL_ID"].ToString());
  741. //alDelete.Add(alDeleteParams);
  742. }
  743. if (publicUltraGridDataCJBaseItems.DataTable != null)
  744. {
  745. publicUltraGridDataCJBaseItems.Ug.UpdateData();
  746. foreach (DataRow dr in publicUltraGridDataCJBaseItems.DataTable.Rows)
  747. {
  748. alPhyItemsParams = new ArrayList();
  749. alPhyItemsParams.Add(strCHECK_NO);
  750. alPhyItemsParams.Add(strSAMPLE_NO);
  751. alPhyItemsParams.Add(dr["CHECK_METHOD_NO"].ToString());
  752. alPhyItemsParams.Add(dr["CHECK_METHOD_NAME"].ToString());
  753. alPhyItemsParams.Add(dr["CHECK_METHOD_ITEMNAME"].ToString());
  754. alPhyItemsParams.Add(dr["VALUE1"].ToString());
  755. alPhyItemsParams.Add(dr["VALUE2"].ToString());
  756. alPhyItemsParams.Add(dr["VALUE3"].ToString());
  757. alPhyItemsParams.Add(dr["VALUE4"].ToString());
  758. alPhyItemsParams.Add(dr["VALUE5"].ToString());
  759. alPhyItemsParams.Add(dr["VALUE6"].ToString());
  760. alPhyItemsParams.Add(dr["VALUE7"].ToString());
  761. alPhyItemsParams.Add(dr["VALUE8"].ToString());
  762. alPhyItemsParams.Add(dr["VALUE9"].ToString());
  763. alPhyItemsParams.Add(dr["VALUE10"].ToString());
  764. alPhyItemsParams.Add(dr["VALUE11"].ToString());
  765. alPhyItemsParams.Add(dr["VALUE12"].ToString());
  766. alPhyItemsParams.Add(dr["VALUE13"].ToString());
  767. alPhyItemsParams.Add(dr["VALUE14"].ToString());
  768. alPhyItemsParams.Add(dr["VALUE15"].ToString());
  769. alPhyItemsParams.Add("");
  770. alPhyItems.Add(alPhyItemsParams);
  771. }
  772. }
  773. alAll.Add(alDetail);
  774. alAll.Add(alProcessResult);
  775. if (alPhyItems.Count > 0)
  776. {
  777. alAll.Add(alPhyItems);
  778. }
  779. PublicServer.SetData("com.steering.lims.data.pipe.FrmDataCJBase.AddCheckConsignProcessResult",
  780. new Object[] { alAll }, this.ob);
  781. QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase1, "2");
  782. QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase2, "3456");
  783. PublicPipeAndOutdec.ActiveOperateRow(publicUltraGridBase1.Ug, new string[] { "CHECK_NO", "SAMPLE_NO" }, new string[] { strCHECK_NO, strSAMPLE_NO });
  784. PublicPipeAndOutdec.ActiveOperateRow(publicUltraGridBase2.Ug, new string[] { "CHECK_NO", "SAMPLE_NO" }, new string[] { strCHECK_NO, strSAMPLE_NO });
  785. MessageUtil.ShowTips("新增成功!");
  786. }
  787. }
  788. catch (Exception e)
  789. {
  790. MessageUtil.ShowWarning(e.Message);
  791. }
  792. }
  793. private void ultraTabControl2_SelectedTabChanging(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangingEventArgs e)
  794. {
  795. int cnt = 0;
  796. if (tabIndex == 0)
  797. {
  798. publicUltraGridDataCJBase1_2.Ug.UpdateData();
  799. cnt = publicUltraGridDataCJBase1_2.DataTable.Rows.Cast<DataRow>().Where(
  800. a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
  801. }
  802. else if (tabIndex == 1)
  803. {
  804. publicUltraGridDataCJBase2_2.Ug.UpdateData();
  805. cnt = publicUltraGridDataCJBase2_2.DataTable.Rows.Cast<DataRow>().Where(
  806. a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
  807. }
  808. else if (tabIndex == 2)
  809. {
  810. publicUltraGridDataCJBase3_2.Ug.UpdateData();
  811. cnt = publicUltraGridDataCJBase3_2.DataTable.Rows.Cast<DataRow>().Where(
  812. a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
  813. }
  814. else if (tabIndex == 3)
  815. {
  816. publicUltraGridDataCJBase4_2.Ug.UpdateData();
  817. cnt = publicUltraGridDataCJBase4_2.DataTable.Rows.Cast<DataRow>().Where(
  818. a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
  819. }
  820. else if (tabIndex == 4)
  821. {
  822. publicUltraGridDataCJBase5_2.Ug.UpdateData();
  823. cnt = publicUltraGridDataCJBase5_2.DataTable.Rows.Cast<DataRow>().Where(
  824. a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
  825. }
  826. else if (tabIndex == 5)
  827. {
  828. publicUltraGridDataCJBase6_2.Ug.UpdateData();
  829. cnt = publicUltraGridDataCJBase6_2.DataTable.Rows.Cast<DataRow>().Where(
  830. a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
  831. }
  832. if (cnt > 0)
  833. {
  834. if (MessageUtil.ShowYesNoAndQuestion("数据有变更您确定要放弃吗?") == System.Windows.Forms.DialogResult.No)
  835. {
  836. e.Cancel = true;
  837. }
  838. }
  839. }
  840. #endregion
  841. #region 已录入
  842. private void ultraTabControl3_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
  843. {
  844. //if (m_dtPhyMax == null || m_dtPhyMax.Rows.Count == 0) return;
  845. if (toolMenu == null) return;
  846. AddPhyDetailItems_Log();
  847. }
  848. void pipeUltraGridBase2_PublicUltraGridBaseActive(object sender, EventArgs e)
  849. {
  850. try
  851. {
  852. pipeShowBase2.ShowBaseInfo(publicUltraGridBase2.Ur);
  853. //赋值给全局变量
  854. UltraGridRow ur = publicUltraGridBase2.Ur;
  855. ArrayList arrayList = new ArrayList();
  856. arrayList.Add("345");
  857. arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());//20160523
  858. arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
  859. arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
  860. arrayList.Add(ur.Cells["CHECK_NO"].Text.Trim());
  861. if (arrId != null && arrId.Length > 0)
  862. {
  863. ClearPhyDetailItems(ultraTabControl3);
  864. //查询检验项目明细
  865. DataTable dt = PublicServer.GetData("com.steering.lims.data.pipe.FrmDataCJBase.QueryCheckConsignDetailPhyDetail", new Object[] { arrayList, arrId }, ob);
  866. if (dt == null || dt.Rows.Count == 0)
  867. {
  868. m_dtPhyMaxAdd = null;
  869. m_dtPhyItemsAdd = null;
  870. return;
  871. }
  872. m_dtPhyMaxAdd = dt.Copy();
  873. DataTable dtItems = PublicServer.GetData("com.steering.lims.data.pipe.FrmDataCJBase.QueryCheckMethodResult",
  874. new Object[] { arrayList, arrId }, ob);
  875. if (dtItems == null || dtItems.Rows.Count == 0)
  876. {
  877. m_dtPhyItemsAdd = null;
  878. //return;
  879. }
  880. else
  881. {
  882. m_dtPhyItemsAdd = dtItems.Copy();
  883. }
  884. ChangeColor(m_dtPhyMaxAdd, ultraTabControl3);
  885. AddPhyDetailItems_Log();
  886. }
  887. }
  888. catch (Exception ex)
  889. {
  890. MessageUtil.ShowWarning(ex.Message);
  891. }
  892. }
  893. //赋值
  894. private void AddPhyDetailItems_Log()
  895. {
  896. if (m_dtPhyMaxAdd == null || m_dtPhyMaxAdd.Rows.Count == 0) return;
  897. if (ultraTabControl3.SelectedTab.Index == 0)
  898. {
  899. publicUltraGridDataCJBase7_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN = 'R0001'"));//拉伸
  900. publicUltraGridDataCJBase7_2.DataTable.AcceptChanges();
  901. QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase7_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN = 'R0001'"), splitContainer7, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAdd, "PHY_CODE_MIN = 'R0001'"));
  902. }
  903. else if (ultraTabControl3.SelectedTab.Index == 1)
  904. {
  905. publicUltraGridDataCJBase8_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN = 'R0002'"));//冲击
  906. publicUltraGridDataCJBase8_2.DataTable.AcceptChanges();
  907. QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase8_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN = 'R0002'"), splitContainer8, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAdd, "PHY_CODE_MIN = 'R0002'"));
  908. }
  909. else if (ultraTabControl3.SelectedTab.Index == 2)
  910. {
  911. publicUltraGridDataCJBase9_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN IN ('R0003','R0004','R0005')"));//硬度
  912. publicUltraGridDataCJBase9_2.DataTable.AcceptChanges();
  913. 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')"));
  914. }
  915. else if (ultraTabControl3.SelectedTab.Index == 3)//金相
  916. {
  917. publicUltraGridDataCJBase10_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN IN ('R0012','R0013')"));//金相
  918. publicUltraGridDataCJBase10_2.DataTable.AcceptChanges();
  919. QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase10_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN IN ('R0012','R0013')"), splitContainer10, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAdd, "PHY_CODE_MIN IN ('R0012','R0013')"));
  920. }
  921. else if (ultraTabControl3.SelectedTab.Index == 4)//工艺
  922. {
  923. publicUltraGridDataCJBase11_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN IN ('R0010')"));//工艺
  924. publicUltraGridDataCJBase11_2.DataTable.AcceptChanges();
  925. QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase11_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN IN ('R0010')"), splitContainer11, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAdd, "PHY_CODE_MIN IN ('R0010')"));
  926. }
  927. else if (ultraTabControl3.SelectedTab.Index == 5)//其他
  928. {
  929. publicUltraGridDataCJBase12_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN NOT IN ('R0001', 'R0002','R0003','R0004','R0005','R0010','R0012','R0013')"));
  930. publicUltraGridDataCJBase12_2.DataTable.AcceptChanges();
  931. 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')"));
  932. }
  933. tabIndex = ultraTabControl3.SelectedTab.Index;
  934. }
  935. //修改检验委托过程结果JHYGG_PHYLX_PROCESS_RESULT
  936. private void UpdateCheckConsignProcessResult(PublicUltraGridDataCJBase publicUltraGridDataCJBase, PublicUltraGridDataCJBase publicUltraGridDataCJBaseItems)
  937. {
  938. try
  939. {
  940. if (ultraTabControl1.SelectedTab.Index != 1)
  941. {
  942. MessageUtil.ShowTips("只有在已录入数据页才能进行修改操作!");
  943. return;
  944. }
  945. if (publicUltraGridBase2.Ur == null || publicUltraGridBase2.Ur.Activated == false)
  946. {
  947. MessageUtil.ShowWarning("请选择需要修改的试样信息!");
  948. return;
  949. }
  950. if (publicUltraGridDataCJBase.OldDt == null || publicUltraGridDataCJBase.OldDt.Rows.Count == 0 || publicUltraGridDataCJBase.DataTable == null || publicUltraGridDataCJBase.DataTable.Rows.Count == 0)
  951. {
  952. return;
  953. }
  954. //if (publicUltraGridBase2.Ur.Cells["FLAG"].Text == "已审核")
  955. //{
  956. // MessageUtil.ShowTips("已审核的数据不允许修改!");
  957. // return;
  958. //}
  959. if (MessageUtil.ShowYesNoAndQuestion("是否确认修改?") == DialogResult.Yes)
  960. {
  961. string strCHECK_NO = publicUltraGridBase2.Ur.Cells["CHECK_NO"].Text.Trim();
  962. string strSAMPLE_NO = publicUltraGridBase2.Ur.Cells["SAMPLE_NO"].Text.Trim();//定位
  963. ArrayList alAll = new ArrayList();
  964. ArrayList alProcessResult = new ArrayList();//过程信息list新值
  965. ArrayList alProcessResultLog = new ArrayList();//过程信息list原值
  966. ArrayList alDeletePhyItems = new ArrayList();
  967. ArrayList alPhyItems = new ArrayList();
  968. ArrayList alProcessResultParams = new ArrayList();//过程信息参数list新值
  969. ArrayList alProcessResultParamsLog = new ArrayList();//过程信息参数list原值
  970. ArrayList alDeletePhyItemsParams = new ArrayList();
  971. ArrayList alPhyItemsParams = new ArrayList();
  972. string strTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
  973. //用m_OldDt获取原值
  974. foreach (DataRow dr in publicUltraGridDataCJBase.OldDt.Rows)
  975. {
  976. alProcessResultParamsLog = new ArrayList();
  977. alProcessResultParamsLog.Add(dr["PHYDETAIL_ID"].ToString());
  978. alProcessResultParamsLog.Add(dr["VALUE1"].ToString());
  979. alProcessResultParamsLog.Add(dr["VALUE2"].ToString());
  980. alProcessResultParamsLog.Add(dr["VALUE3"].ToString());
  981. alProcessResultParamsLog.Add(dr["VALUE4"].ToString());
  982. alProcessResultParamsLog.Add(dr["VALUE5"].ToString());
  983. alProcessResultParamsLog.Add(dr["VALUE6"].ToString());
  984. alProcessResultParamsLog.Add(dr["VALUE7"].ToString());
  985. alProcessResultParamsLog.Add(dr["VALUE8"].ToString());
  986. alProcessResultParamsLog.Add(dr["VALUE9"].ToString());
  987. alProcessResultParamsLog.Add(dr["VALUE10"].ToString());
  988. alProcessResultParamsLog.Add(dr["VALUE11"].ToString());
  989. alProcessResultParamsLog.Add(dr["VALUE12"].ToString());
  990. alProcessResultParamsLog.Add(dr["VALUE13"].ToString());
  991. alProcessResultParamsLog.Add(dr["VALUE14"].ToString());
  992. alProcessResultParamsLog.Add(dr["VALUE15"].ToString());
  993. alProcessResultParamsLog.Add(UserInfo.GetUserName());//操作人
  994. alProcessResultParamsLog.Add(strTime);//操作时间
  995. alProcessResultParamsLog.Add("0");
  996. //alProcessResultParamsLog.Add(txtOPERATE_REMARK.Text.Trim());//操作备注修改
  997. alProcessResultLog.Add(alProcessResultParamsLog);//插入到JHYGG_PHYRESULT_LOG数据(过程原值)
  998. }
  999. string row = "";
  1000. publicUltraGridDataCJBase.Ug.UpdateData();
  1001. foreach (DataRow dr in publicUltraGridDataCJBase.DataTable.Rows)
  1002. {
  1003. if (row.IndexOf(dr["PHY_CODE_MAX"].ToString()) < 0)
  1004. {
  1005. row += ",'" + dr["PHY_CODE_MAX"].ToString() + "'";
  1006. }
  1007. alProcessResultParams = new ArrayList();
  1008. alProcessResultParams.Add(dr["VALUE1"].ToString());
  1009. alProcessResultParams.Add(dr["VALUE2"].ToString());
  1010. alProcessResultParams.Add(dr["VALUE3"].ToString());
  1011. alProcessResultParams.Add(dr["VALUE4"].ToString());
  1012. alProcessResultParams.Add(dr["VALUE5"].ToString());
  1013. alProcessResultParams.Add(dr["VALUE6"].ToString());
  1014. alProcessResultParams.Add(dr["VALUE7"].ToString());
  1015. alProcessResultParams.Add(dr["VALUE8"].ToString());
  1016. alProcessResultParams.Add(dr["VALUE9"].ToString());
  1017. alProcessResultParams.Add(dr["VALUE10"].ToString());
  1018. alProcessResultParams.Add(dr["VALUE11"].ToString());
  1019. alProcessResultParams.Add(dr["VALUE12"].ToString());
  1020. alProcessResultParams.Add(dr["VALUE13"].ToString());
  1021. alProcessResultParams.Add(dr["VALUE14"].ToString());
  1022. alProcessResultParams.Add(dr["VALUE15"].ToString());
  1023. //alProcessResultParams.Add(txtREMARK_LOG.Text.Trim());//试验备注
  1024. alProcessResultParams.Add(dr["PHYDETAIL_ID"].ToString());
  1025. alProcessResult.Add(alProcessResultParams);//新值
  1026. }
  1027. if (publicUltraGridDataCJBaseItems.DataTable != null)
  1028. {
  1029. string strMethod = "";
  1030. publicUltraGridDataCJBaseItems.Ug.UpdateData();
  1031. foreach (DataRow dr in publicUltraGridDataCJBaseItems.DataTable.Rows)
  1032. {
  1033. if (strMethod.IndexOf(dr["CHECK_METHOD_NO"].ToString()) < 0)
  1034. {
  1035. strMethod += dr["CHECK_METHOD_NO"].ToString() + " ";
  1036. alDeletePhyItemsParams = new ArrayList();
  1037. alDeletePhyItemsParams.Add(dr["CHECK_METHOD_NO"].ToString());
  1038. alDeletePhyItemsParams.Add(strSAMPLE_NO);
  1039. alDeletePhyItemsParams.Add(strCHECK_NO);
  1040. alDeletePhyItems.Add(alDeletePhyItemsParams);
  1041. }
  1042. alPhyItemsParams = new ArrayList();
  1043. alPhyItemsParams.Add(strCHECK_NO);
  1044. alPhyItemsParams.Add(strSAMPLE_NO);
  1045. alPhyItemsParams.Add(dr["CHECK_METHOD_NO"].ToString());
  1046. alPhyItemsParams.Add(dr["CHECK_METHOD_NAME"].ToString());
  1047. alPhyItemsParams.Add(dr["CHECK_METHOD_ITEMNAME"].ToString());
  1048. alPhyItemsParams.Add(dr["VALUE1"].ToString());
  1049. alPhyItemsParams.Add(dr["VALUE2"].ToString());
  1050. alPhyItemsParams.Add(dr["VALUE3"].ToString());
  1051. alPhyItemsParams.Add(dr["VALUE4"].ToString());
  1052. alPhyItemsParams.Add(dr["VALUE5"].ToString());
  1053. alPhyItemsParams.Add(dr["VALUE6"].ToString());
  1054. alPhyItemsParams.Add(dr["VALUE7"].ToString());
  1055. alPhyItemsParams.Add(dr["VALUE8"].ToString());
  1056. alPhyItemsParams.Add(dr["VALUE9"].ToString());
  1057. alPhyItemsParams.Add(dr["VALUE10"].ToString());
  1058. alPhyItemsParams.Add(dr["VALUE11"].ToString());
  1059. alPhyItemsParams.Add(dr["VALUE12"].ToString());
  1060. alPhyItemsParams.Add(dr["VALUE13"].ToString());
  1061. alPhyItemsParams.Add(dr["VALUE14"].ToString());
  1062. alPhyItemsParams.Add(dr["VALUE15"].ToString());
  1063. alPhyItemsParams.Add("");
  1064. alPhyItems.Add(alPhyItemsParams);
  1065. }
  1066. }
  1067. alAll.Add(alProcessResultLog);//原值
  1068. alAll.Add(alProcessResult);//新值
  1069. if (alDeletePhyItems.Count > 0)
  1070. {
  1071. alAll.Add(alDeletePhyItems);
  1072. }
  1073. if (alPhyItems.Count > 0)
  1074. {
  1075. alAll.Add(alPhyItems);
  1076. }
  1077. row = row.Remove(0, 1);
  1078. ArrayList al = new ArrayList();
  1079. al.Add(strCHECK_NO);
  1080. al.Add(strSAMPLE_NO);
  1081. al.Add(row);
  1082. PublicServer.SetData("com.steering.lims.data.pipe.FrmDataCJBase.UpdateCheckConsignProcessResult",
  1083. new Object[] { al, alAll }, this.ob);
  1084. QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase2, "3456");
  1085. //QueryCheckConsignBaseDetail_Distinct("2");
  1086. PublicPipeAndOutdec.ActiveOperateRow(publicUltraGridBase2.Ug, new string[] { "CHECK_NO", "SAMPLE_NO" }, new string[] { strCHECK_NO, strSAMPLE_NO });
  1087. MessageUtil.ShowTips("修改成功!");
  1088. }
  1089. }
  1090. catch (Exception e)
  1091. {
  1092. MessageUtil.ShowWarning(e.Message);
  1093. }
  1094. }
  1095. //删除检验委托过程结果JHYGG_PHYLX_PROCESS_RESULT
  1096. private void DeleteCheckConsignProcessResult(PublicUltraGridDataCJBase publicUltraGridDataCJBase, PublicUltraGridDataCJBase publicUltraGridDataCJBaseItems)
  1097. {
  1098. try
  1099. {
  1100. if (ultraTabControl1.SelectedTab.Index != 1)
  1101. {
  1102. MessageUtil.ShowTips("只有在已录入数据页才能进行删除操作!");
  1103. return;
  1104. }
  1105. if (publicUltraGridBase2.Ur == null || publicUltraGridBase2.Ur.Activated == false)
  1106. {
  1107. MessageUtil.ShowWarning("请选择需要删除的试样信息!");
  1108. return;
  1109. }
  1110. if (publicUltraGridDataCJBase.OldDt == null || publicUltraGridDataCJBase.OldDt.Rows.Count == 0 || publicUltraGridDataCJBase.DataTable == null || publicUltraGridDataCJBase.DataTable.Rows.Count == 0)
  1111. {
  1112. return;
  1113. }
  1114. if (MessageUtil.ShowYesNoAndQuestion("是否确认删除?") == DialogResult.Yes)
  1115. {
  1116. string strCHECK_NO = publicUltraGridBase2.Ur.Cells["CHECK_NO"].Text.Trim();
  1117. string strSAMPLE_NO = publicUltraGridBase2.Ur.Cells["SAMPLE_NO"].Text.Trim();//定位
  1118. ArrayList alAll = new ArrayList();
  1119. ArrayList alDetail = new ArrayList();
  1120. ArrayList alProcessResult = new ArrayList();//过程信息list新值
  1121. ArrayList alProcessResultLog = new ArrayList();//过程信息list原值
  1122. ArrayList alPhyItems = new ArrayList();
  1123. ArrayList alDetailParams = new ArrayList();
  1124. ArrayList alProcessResultParams = new ArrayList();//过程信息参数list新值
  1125. ArrayList alProcessResultParamsLog = new ArrayList();//过程信息参数list原值
  1126. ArrayList alPhyItemsParams = new ArrayList();
  1127. string strTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
  1128. foreach (DataRow dr in publicUltraGridDataCJBase.DataTable.Rows)
  1129. {
  1130. alDetailParams = new ArrayList();
  1131. alDetailParams.Add("");
  1132. alDetailParams.Add("");
  1133. alDetailParams.Add("");
  1134. alDetailParams.Add("");
  1135. alDetailParams.Add("");//班组
  1136. alDetailParams.Add("");//录入人
  1137. alDetailParams.Add("");//录入时间
  1138. alDetailParams.Add("2");//删除之后回到待录入状态
  1139. alDetailParams.Add("3");
  1140. alDetailParams.Add(dr["PHY_CODE_MAX"].ToString());
  1141. alDetailParams.Add(strSAMPLE_NO);
  1142. alDetailParams.Add(strCHECK_NO);
  1143. alDetail.Add(alDetailParams);
  1144. }
  1145. //用m_OldDt获取原值
  1146. foreach (DataRow dr in publicUltraGridDataCJBase.OldDt.Rows)
  1147. {
  1148. alProcessResultParamsLog = new ArrayList();
  1149. alProcessResultParamsLog.Add(dr["VALUE1"].ToString());
  1150. alProcessResultParamsLog.Add(dr["VALUE2"].ToString());
  1151. alProcessResultParamsLog.Add(dr["VALUE3"].ToString());
  1152. alProcessResultParamsLog.Add(dr["VALUE4"].ToString());
  1153. alProcessResultParamsLog.Add(dr["VALUE5"].ToString());
  1154. alProcessResultParamsLog.Add(dr["VALUE6"].ToString());
  1155. alProcessResultParamsLog.Add(dr["VALUE7"].ToString());
  1156. alProcessResultParamsLog.Add(dr["VALUE8"].ToString());
  1157. alProcessResultParamsLog.Add(dr["VALUE9"].ToString());
  1158. alProcessResultParamsLog.Add(dr["VALUE10"].ToString());
  1159. alProcessResultParamsLog.Add(dr["VALUE11"].ToString());
  1160. alProcessResultParamsLog.Add(dr["VALUE12"].ToString());
  1161. alProcessResultParamsLog.Add(dr["VALUE13"].ToString());
  1162. alProcessResultParamsLog.Add(dr["VALUE14"].ToString());
  1163. alProcessResultParamsLog.Add(dr["VALUE15"].ToString());
  1164. alProcessResultParamsLog.Add(UserInfo.GetUserName());//操作人
  1165. alProcessResultParamsLog.Add(strTime);//操作时间
  1166. alProcessResultParamsLog.Add("1");
  1167. alProcessResultParamsLog.Add(dr["PHYDETAIL_ID"].ToString());
  1168. //alProcessResultParamsLog.Add(txtOPERATE_REMARK.Text.Trim());//操作备注修改
  1169. alProcessResultLog.Add(alProcessResultParamsLog);//插入到JHYGG_PHYRESULT_LOG数据(过程原值)
  1170. }
  1171. string row = "";
  1172. publicUltraGridDataCJBase.Ug.UpdateData();//修改原值
  1173. foreach (DataRow dr in publicUltraGridDataCJBase.DataTable.Rows)
  1174. {
  1175. if (row.IndexOf(dr["PHY_CODE_MAX"].ToString()) < 0)
  1176. {
  1177. row += ",'" + dr["PHY_CODE_MAX"].ToString() + "'";
  1178. }
  1179. alProcessResultParams = new ArrayList();
  1180. alProcessResultParams.Add("");
  1181. alProcessResultParams.Add("");
  1182. alProcessResultParams.Add("");
  1183. alProcessResultParams.Add("");
  1184. alProcessResultParams.Add("");
  1185. alProcessResultParams.Add("");
  1186. alProcessResultParams.Add("");
  1187. alProcessResultParams.Add("");
  1188. alProcessResultParams.Add("");
  1189. alProcessResultParams.Add("");
  1190. alProcessResultParams.Add("");
  1191. alProcessResultParams.Add("");
  1192. alProcessResultParams.Add("");
  1193. alProcessResultParams.Add("");
  1194. alProcessResultParams.Add("");
  1195. //alProcessResultParams.Add(txtREMARK_LOG.Text.Trim());//试验备注
  1196. alProcessResultParams.Add(dr["PHYDETAIL_ID"].ToString());
  1197. alProcessResult.Add(alProcessResultParams);//新值
  1198. }
  1199. if (publicUltraGridDataCJBaseItems.DataTable != null)
  1200. {
  1201. string strMethod = "";
  1202. publicUltraGridDataCJBaseItems.Ug.UpdateData();
  1203. foreach (DataRow dr in publicUltraGridDataCJBaseItems.DataTable.Rows)
  1204. {
  1205. if (strMethod.IndexOf(dr["CHECK_METHOD_NO"].ToString()) < 0)
  1206. {
  1207. strMethod += dr["CHECK_METHOD_NO"].ToString() + " ";
  1208. alPhyItemsParams = new ArrayList();
  1209. alPhyItemsParams.Add(dr["CHECK_METHOD_NO"].ToString());
  1210. alPhyItemsParams.Add(strSAMPLE_NO);
  1211. alPhyItemsParams.Add(strCHECK_NO);
  1212. alPhyItems.Add(alPhyItemsParams);
  1213. }
  1214. }
  1215. }
  1216. alAll.Add(alDetail);
  1217. alAll.Add(alProcessResultLog);//原值
  1218. alAll.Add(alProcessResult);
  1219. if (alPhyItems.Count > 0)
  1220. {
  1221. alAll.Add(alPhyItems);
  1222. }
  1223. row = row.Remove(0, 1);
  1224. ArrayList al = new ArrayList();
  1225. al.Add(strCHECK_NO);
  1226. al.Add(strSAMPLE_NO);
  1227. al.Add(row);
  1228. PublicServer.SetData("com.steering.lims.data.pipe.FrmDataCJBase.DeleteCheckConsignProcessResult",
  1229. new Object[] { al, alAll }, this.ob);
  1230. QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase2, "3456");
  1231. QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase1, "2");
  1232. PublicPipeAndOutdec.ActiveOperateRow(publicUltraGridBase2.Ug, new string[] { "CHECK_NO", "SAMPLE_NO" }, new string[] { strCHECK_NO, strSAMPLE_NO });
  1233. PublicPipeAndOutdec.ActiveOperateRow(publicUltraGridBase1.Ug, new string[] { "CHECK_NO", "SAMPLE_NO" }, new string[] { strCHECK_NO, strSAMPLE_NO });
  1234. MessageUtil.ShowTips("删除成功!");
  1235. }
  1236. }
  1237. catch (Exception e)
  1238. {
  1239. MessageUtil.ShowWarning(e.Message);
  1240. }
  1241. }
  1242. private void ultraTabControl3_SelectedTabChanging(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangingEventArgs e)
  1243. {
  1244. int cnt = 0;
  1245. if (tabIndex == 0)
  1246. {
  1247. publicUltraGridDataCJBase7_2.Ug.UpdateData();
  1248. cnt = publicUltraGridDataCJBase7_2.DataTable.Rows.Cast<DataRow>().Where(
  1249. a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
  1250. }
  1251. else if (tabIndex == 1)
  1252. {
  1253. publicUltraGridDataCJBase8_2.Ug.UpdateData();
  1254. cnt = publicUltraGridDataCJBase8_2.DataTable.Rows.Cast<DataRow>().Where(
  1255. a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
  1256. }
  1257. else if (tabIndex == 2)
  1258. {
  1259. publicUltraGridDataCJBase9_2.Ug.UpdateData();
  1260. cnt = publicUltraGridDataCJBase9_2.DataTable.Rows.Cast<DataRow>().Where(
  1261. a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
  1262. }
  1263. else if (tabIndex == 3)
  1264. {
  1265. publicUltraGridDataCJBase10_2.Ug.UpdateData();
  1266. cnt = publicUltraGridDataCJBase10_2.DataTable.Rows.Cast<DataRow>().Where(
  1267. a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
  1268. }
  1269. else if (tabIndex == 4)
  1270. {
  1271. publicUltraGridDataCJBase11_2.Ug.UpdateData();
  1272. cnt = publicUltraGridDataCJBase11_2.DataTable.Rows.Cast<DataRow>().Where(
  1273. a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
  1274. }
  1275. else if (tabIndex == 5)
  1276. {
  1277. publicUltraGridDataCJBase12_2.Ug.UpdateData();
  1278. cnt = publicUltraGridDataCJBase12_2.DataTable.Rows.Cast<DataRow>().Where(
  1279. a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
  1280. }
  1281. if (cnt > 0)
  1282. {
  1283. if (MessageUtil.ShowYesNoAndQuestion("数据有变更您确定要放弃吗?") == System.Windows.Forms.DialogResult.No)
  1284. {
  1285. e.Cancel = true;
  1286. }
  1287. }
  1288. }
  1289. #endregion
  1290. #region 审核区域
  1291. //查询检验委托基本信息
  1292. private void QueryCheckConsignBaseDetail_Distinct(UltraGrid ultraGrid, string strFlag)
  1293. {
  1294. try
  1295. {
  1296. ClearPhyDetailItems(ultraGrid == ultraGrid1 ? ultraTabControl4 : ultraTabControl5);//20160523
  1297. if (ultraGrid == ultraGrid1)
  1298. {
  1299. dataTable2.Rows.Clear();
  1300. dataTable1.Rows.Clear();
  1301. }
  1302. else
  1303. {
  1304. dataTable4.Rows.Clear();
  1305. dataTable3.Rows.Clear();
  1306. }
  1307. //各试验室各检验项目设置权限
  1308. DataTable dt = PublicServer.GetData("com.steering.lims.data.pipe.FrmDataCJBase.QueryCheckConsignBase_Distinct",
  1309. arrId == null ? new Object[] { pipeQueryBase1.GetQueryInfo(strFlag) } : new Object[] { pipeQueryBase1.GetQueryInfo(strFlag), arrId }, ob);
  1310. if (dt == null || dt.Rows.Count == 0)
  1311. {
  1312. //ClearPhyDetailItems(ultraGrid == ultraGrid1 ? ultraTabControl4 : ultraTabControl5);
  1313. return;
  1314. }
  1315. GridHelper.CopyDataToDatatable(dt, ultraGrid == ultraGrid1 ? dataTable1 : dataTable3, true);
  1316. DataTable dtSample = PublicServer.GetData("com.steering.lims.data.pipe.PublicPipeBase.QueryCheckConsignBaseDetail_Distinct",
  1317. arrId == null ? new Object[] { pipeQueryBase1.GetQueryInfo(strFlag) } : new Object[] { pipeQueryBase1.GetQueryInfo(strFlag), arrId }, ob);
  1318. if (dtSample == null || dtSample.Rows.Count == 0)
  1319. {
  1320. return;
  1321. }
  1322. else
  1323. {
  1324. GridHelper.CopyDataToDatatable(dtSample, ultraGrid == ultraGrid1 ? dataTable2 : dataTable4, true);
  1325. }
  1326. GridHelper.RefreshAndAutoSize(ultraGrid);
  1327. }
  1328. catch (Exception e)
  1329. {
  1330. MessageUtil.ShowWarning(e.Message);
  1331. }
  1332. }
  1333. #endregion
  1334. #region 未审核
  1335. private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
  1336. {
  1337. try
  1338. {
  1339. if (ultraGrid1.ActiveRow.HasParent())
  1340. {
  1341. pipeShowBase3.ShowBaseInfo(ultraGrid1.ActiveRow.ParentRow);
  1342. //赋值给全局变量
  1343. UltraGridRow ur = ultraGrid1.ActiveRow;
  1344. ArrayList arrayList = new ArrayList();
  1345. arrayList.Add("3");
  1346. arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());//20160523
  1347. arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
  1348. arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
  1349. arrayList.Add(ur.Cells["CHECK_NO"].Text.Trim());
  1350. if (arrId != null && arrId.Length > 0)
  1351. {
  1352. ClearPhyDetailItems(ultraTabControl4);
  1353. //查询检验项目明细
  1354. DataTable dt = PublicServer.GetData("com.steering.lims.data.pipe.FrmDataCJBase.QueryCheckConsignDetailPhyDetail", new Object[] { arrayList, arrId }, ob);
  1355. if (dt == null || dt.Rows.Count == 0)
  1356. {
  1357. m_dtPhyMaxAudit = null;
  1358. m_dtPhyItemsAudit = null;
  1359. return;
  1360. }
  1361. m_dtPhyMaxAudit = dt.Copy();
  1362. //QueryCheckMethodPhyConfigItems
  1363. DataTable dtItems = PublicServer.GetData("com.steering.lims.data.pipe.FrmDataCJBase.QueryCheckMethodResult",
  1364. new Object[] { arrayList, arrId }, ob);
  1365. if (dtItems == null || dtItems.Rows.Count == 0)
  1366. {
  1367. m_dtPhyItemsAudit = null;
  1368. //return;
  1369. }
  1370. else
  1371. {
  1372. m_dtPhyItemsAudit = dtItems.Copy();
  1373. }
  1374. ChangeColor(m_dtPhyMaxAudit, ultraTabControl4);
  1375. AddPhyDetailItemsAudit();
  1376. }
  1377. }
  1378. else
  1379. {
  1380. ultraGrid1.ActiveRow.Expanded = true;
  1381. //ultraGrid1.ActiveRow.ChildBands[0].Rows[0].Activated = true;
  1382. }
  1383. }
  1384. catch (Exception ex)
  1385. {
  1386. MessageUtil.ShowWarning(ex.Message);
  1387. }
  1388. }
  1389. private void AddPhyDetailItemsAudit()
  1390. {
  1391. if (m_dtPhyMaxAudit == null || m_dtPhyMaxAudit.Rows.Count == 0) return;
  1392. if (ultraTabControl4.SelectedTab.Index == 0)
  1393. {
  1394. publicUltraGridDataCJBase13_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN = 'R0001'"));//拉伸
  1395. //publicUltraGridDataCJBase13_2.DataTable.AcceptChanges();
  1396. QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase13_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN = 'R0001'"), splitContainer13, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAudit, "PHY_CODE_MIN = 'R0001'"));
  1397. }
  1398. else if (ultraTabControl4.SelectedTab.Index == 1)
  1399. {
  1400. publicUltraGridDataCJBase14_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN = 'R0002'"));//冲击
  1401. //publicUltraGridDataCJBase14_2.DataTable.AcceptChanges();
  1402. QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase14_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN = 'R0002'"), splitContainer14, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAudit, "PHY_CODE_MIN = 'R0002'"));
  1403. }
  1404. else if (ultraTabControl4.SelectedTab.Index == 2)
  1405. {
  1406. publicUltraGridDataCJBase15_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN IN ('R0003','R0004','R0005')"));//硬度
  1407. //publicUltraGridDataCJBase15_2.DataTable.AcceptChanges();
  1408. QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase15_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN IN ('R0003','R0004','R0005')"), splitContainer15, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAudit, "PHY_CODE_MIN IN ('R0003','R0004','R0005')"));
  1409. }
  1410. else if (ultraTabControl4.SelectedTab.Index == 3)//金相
  1411. {
  1412. publicUltraGridDataCJBase16_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN IN ('R0012','R0013')"));//金相
  1413. //publicUltraGridDataCJBase16_2.DataTable.AcceptChanges();
  1414. QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase16_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN IN ('R0012','R0013')"), splitContainer16, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAudit, "PHY_CODE_MIN IN ('R0012','R0013')"));
  1415. }
  1416. else if (ultraTabControl4.SelectedTab.Index == 4)//工艺
  1417. {
  1418. publicUltraGridDataCJBase17_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN IN ('R0010')"));//工艺
  1419. //publicUltraGridDataCJBase17_2.DataTable.AcceptChanges();
  1420. QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase17_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN IN ('R0010')"), splitContainer17, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAudit, "PHY_CODE_MIN IN ('R0010')"));
  1421. }
  1422. else if (ultraTabControl4.SelectedTab.Index == 5)//其他
  1423. {
  1424. publicUltraGridDataCJBase18_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN NOT IN ('R0001', 'R0002','R0003','R0004','R0005','R0010','R0012','R0013')"));
  1425. //publicUltraGridDataCJBase18_2.DataTable.AcceptChanges();
  1426. QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase18_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN NOT IN ('R0001', 'R0002','R0003','R0004','R0005','R0010','R0012','R0013')"), splitContainer18, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAudit, "PHY_CODE_MIN NOT IN ('R0001', 'R0002','R0003','R0004','R0005','R0010','R0012','R0013')"));
  1427. }
  1428. //tabIndex = ultraTabControl4.SelectedTab.Index;
  1429. }
  1430. private void ultraTabControl4_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
  1431. {
  1432. //if (m_dtPhyMax == null || m_dtPhyMax.Rows.Count == 0) return;
  1433. if (toolMenu == null) return;
  1434. AddPhyDetailItemsAudit();
  1435. }
  1436. private void AuditCheckConsignDetail()
  1437. {
  1438. try
  1439. {
  1440. if (ultraTabControl1.SelectedTab.Index != 2)
  1441. {
  1442. MessageUtil.ShowWarning("只有在未审核数据页才能进行审核操作!");
  1443. return;
  1444. }
  1445. if (ultraGrid1.ActiveRow == null || ultraGrid1.ActiveRow.Activated == false)
  1446. {
  1447. MessageUtil.ShowWarning("请选择需要审核的检验信息!");
  1448. return;
  1449. }
  1450. if (dataTable1 == null || dataTable1.Rows.Count == 0)
  1451. {
  1452. return;
  1453. }
  1454. ultraGrid1.UpdateData();
  1455. DataRow[] arrBase = dataTable2.Select("CHK = 'True'");
  1456. if (arrBase == null || arrBase.Length == 0)
  1457. {
  1458. MessageUtil.ShowTips("请勾选至少一条检验信息!");
  1459. return;
  1460. }
  1461. if (MessageUtil.ShowYesNoAndQuestion("是否确认审核?") == DialogResult.Yes)
  1462. {
  1463. ArrayList alBase = new ArrayList();//存放所有需要更新的基础信息
  1464. ArrayList alBaseParams = new ArrayList();//存放单个基础参数信息
  1465. string user = UserInfo.GetUserName();
  1466. string strDate = DateTime.Now.ToString();
  1467. foreach (DataRow row in arrBase)
  1468. {
  1469. alBaseParams = new ArrayList();//增加要更新的基础标志位信息
  1470. alBaseParams.Add("4");
  1471. alBaseParams.Add(user);//审核人
  1472. alBaseParams.Add(strDate);//审核时间
  1473. alBaseParams.Add("");
  1474. alBaseParams.Add("");//样品备注row["SAMPLE_REMARK"].ToString()
  1475. alBaseParams.Add("3");
  1476. alBaseParams.Add("");//PHY_CODE_MAX
  1477. alBaseParams.Add("");
  1478. alBaseParams.Add("");
  1479. alBaseParams.Add(row["SAMPLE_NO"].ToString());
  1480. alBaseParams.Add(row["CHECK_NO"].ToString());
  1481. alBase.Add(alBaseParams);
  1482. }
  1483. PublicServer.SetData("com.steering.lims.data.pipe.FrmDataCJBase.AuditCheckConsignDetail",
  1484. new Object[] { alBase }, this.ob);
  1485. QueryCheckConsignBaseDetail_Distinct(ultraGrid1, "3");
  1486. //QueryCheckConsignBaseDetail_Distinct(ultraGrid2, "4");
  1487. //PublicPipeAndOutdec.ActiveOperateRow(ultraGrid1, new string[] { "CHECK_NO" }, new string[] { strCHECK_NO });
  1488. //PublicPipeAndOutdec.ActiveOperateRow(ultraGrid2, new string[] { "CHECK_NO" }, new string[] { strCHECK_NO });
  1489. MessageUtil.ShowTips("审核成功!");
  1490. }
  1491. }
  1492. catch (Exception e)
  1493. {
  1494. MessageUtil.ShowWarning(e.Message);
  1495. }
  1496. }
  1497. private void SingleAuditCheckConsignDetail(PublicUltraGridDataCJBase publicUltraGridDataCJBase)
  1498. {
  1499. try
  1500. {
  1501. if (ultraTabControl1.SelectedTab.Index != 2)
  1502. {
  1503. MessageUtil.ShowWarning("只有在未审核数据页才能进行单项审核操作!");
  1504. return;
  1505. }
  1506. if (ultraGrid1.ActiveRow == null || ultraGrid1.ActiveRow.Activated == false)
  1507. {
  1508. MessageUtil.ShowWarning("请选择需要单项审核的检验信息!");
  1509. return;
  1510. }
  1511. if (dataTable1 == null || dataTable1.Rows.Count == 0)
  1512. {
  1513. return;
  1514. }
  1515. ultraGrid1.UpdateData();
  1516. DataRow[] arrBase = dataTable2.Select("CHK = 'True'");
  1517. if (arrBase == null || arrBase.Length == 0)
  1518. {
  1519. MessageUtil.ShowTips("请勾选至少一条检验信息!");
  1520. return;
  1521. }
  1522. // string row = "";
  1523. //foreach (DataRow dr in publicUltraGridDataCJBase.DataTable.Rows)
  1524. //{
  1525. // if (row.IndexOf(dr["PHY_CODE_MAX"].ToString()) < 0)
  1526. // {
  1527. // row += dr["PHY_CODE_MAX"].ToString() + " ";
  1528. if (MessageUtil.ShowYesNoAndQuestion("是否确认单项审核?") == DialogResult.Yes)
  1529. {
  1530. ArrayList alBase = new ArrayList();//存放所有需要更新的基础信息
  1531. ArrayList alBaseParams = new ArrayList();//存放单个基础参数信息
  1532. string user = UserInfo.GetUserName();
  1533. string strDate = DateTime.Now.ToString();
  1534. string rowSample = "";
  1535. foreach (DataRow dr in publicUltraGridDataCJBase.DataTable.Rows)
  1536. {
  1537. if (rowSample.IndexOf(dr["PHY_CODE_MAX"].ToString()) < 0)
  1538. {
  1539. rowSample += dr["PHY_CODE_MAX"].ToString() + " ";
  1540. }
  1541. }
  1542. foreach (DataRow row in arrBase)
  1543. {
  1544. foreach (string strPHY_CODE_MAX in rowSample.Trim().Split(' '))
  1545. {
  1546. alBaseParams = new ArrayList();//增加要更新的基础标志位信息
  1547. alBaseParams.Add("4");
  1548. alBaseParams.Add(user);//审核人
  1549. alBaseParams.Add(strDate);//审核时间
  1550. alBaseParams.Add("");
  1551. alBaseParams.Add("");//样品备注row["SAMPLE_REMARK"].ToString()
  1552. alBaseParams.Add("3");
  1553. alBaseParams.Add(strPHY_CODE_MAX);//PHY_CODE_MAX
  1554. alBaseParams.Add(strPHY_CODE_MAX);
  1555. alBaseParams.Add(strPHY_CODE_MAX);
  1556. alBaseParams.Add(row["SAMPLE_NO"].ToString());
  1557. alBaseParams.Add(row["CHECK_NO"].ToString());
  1558. alBase.Add(alBaseParams);
  1559. }
  1560. }
  1561. PublicServer.SetData("com.steering.lims.data.pipe.FrmDataCJBase.AuditCheckConsignDetail",
  1562. new Object[] { alBase }, this.ob);
  1563. QueryCheckConsignBaseDetail_Distinct(ultraGrid1, "3");
  1564. //QueryCheckConsignBaseDetail_Distinct(ultraGrid2, "4");
  1565. //PublicPipeAndOutdec.ActiveOperateRow(ultraGrid1, new string[] { "CHECK_NO" }, new string[] { strCHECK_NO });
  1566. //PublicPipeAndOutdec.ActiveOperateRow(ultraGrid2, new string[] { "CHECK_NO" }, new string[] { strCHECK_NO });
  1567. MessageUtil.ShowTips("单项审核成功!");
  1568. }
  1569. }
  1570. catch (Exception e)
  1571. {
  1572. MessageUtil.ShowWarning(e.Message);
  1573. }
  1574. }
  1575. private void ultraGrid1_CellChange(object sender, CellEventArgs e)
  1576. {
  1577. if (e.Cell.Row.HasChild() && e.Cell.Column.Key == "CHK")
  1578. {
  1579. ultraGrid1.UpdateData();
  1580. if (e.Cell.Value.ToString() == "True")
  1581. {
  1582. foreach (UltraGridRow dr in e.Cell.Row.ChildBands[0].Rows)
  1583. {
  1584. dr.Cells["CHK"].Value = "True";
  1585. }
  1586. }
  1587. else
  1588. {
  1589. foreach (UltraGridRow dr in e.Cell.Row.ChildBands[0].Rows)
  1590. {
  1591. dr.Cells["CHK"].Value = "False";
  1592. }
  1593. }
  1594. }
  1595. }
  1596. #endregion
  1597. #region 已审核
  1598. private void ultraGrid2_AfterRowActivate(object sender, EventArgs e)
  1599. {
  1600. try
  1601. {
  1602. if (ultraGrid2.ActiveRow.HasParent())
  1603. {
  1604. pipeShowBase4.ShowBaseInfo(ultraGrid2.ActiveRow.ParentRow);
  1605. //赋值给全局变量
  1606. UltraGridRow ur = ultraGrid2.ActiveRow;
  1607. ArrayList arrayList = new ArrayList();
  1608. arrayList.Add("456");
  1609. arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());//20160523
  1610. arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
  1611. arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
  1612. arrayList.Add(ur.Cells["CHECK_NO"].Text.Trim());
  1613. if (arrId != null && arrId.Length > 0)
  1614. {
  1615. ClearPhyDetailItems(ultraTabControl5);
  1616. //查询检验项目明细
  1617. DataTable dt = PublicServer.GetData("com.steering.lims.data.pipe.FrmDataCJBase.QueryCheckConsignDetailPhyDetail", new Object[] { arrayList, arrId }, ob);
  1618. if (dt == null || dt.Rows.Count == 0)
  1619. {
  1620. m_dtPhyMaxAuditAdd = null;
  1621. m_dtPhyItemsAuditAdd = null;
  1622. return;
  1623. }
  1624. m_dtPhyMaxAuditAdd = dt.Copy();
  1625. DataTable dtItems = PublicServer.GetData("com.steering.lims.data.pipe.FrmDataCJBase.QueryCheckMethodResult",
  1626. new Object[] { arrayList, arrId }, ob);
  1627. if (dtItems == null || dtItems.Rows.Count == 0)
  1628. {
  1629. m_dtPhyItemsAuditAdd = null;
  1630. //return;
  1631. }
  1632. else
  1633. {
  1634. m_dtPhyItemsAuditAdd = dtItems.Copy();
  1635. }
  1636. ChangeColor(m_dtPhyMaxAuditAdd, ultraTabControl5);
  1637. AddPhyDetailItemsAudit_Log();
  1638. }
  1639. }
  1640. else
  1641. {
  1642. ultraGrid2.ActiveRow.Expanded = true;
  1643. //ultraGrid2.ActiveRow.ChildBands[0].Rows[0].Activated = true;
  1644. }
  1645. }
  1646. catch (Exception ex)
  1647. {
  1648. MessageUtil.ShowWarning(ex.Message);
  1649. }
  1650. }
  1651. private void AddPhyDetailItemsAudit_Log()
  1652. {
  1653. if (m_dtPhyMaxAuditAdd == null || m_dtPhyMaxAuditAdd.Rows.Count == 0) return;
  1654. if (ultraTabControl5.SelectedTab.Index == 0)
  1655. {
  1656. publicUltraGridDataCJBase19_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN = 'R0001'"));//拉伸
  1657. //publicUltraGridDataCJBase19_2.DataTable.AcceptChanges();
  1658. QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase19_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN = 'R0001'"), splitContainer19, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAuditAdd, "PHY_CODE_MIN = 'R0001'"));
  1659. }
  1660. else if (ultraTabControl5.SelectedTab.Index == 1)
  1661. {
  1662. publicUltraGridDataCJBase20_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN = 'R0002'"));//冲击
  1663. //publicUltraGridDataCJBase20_2.DataTable.AcceptChanges();
  1664. QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase20_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN = 'R0002'"), splitContainer20, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAuditAdd, "PHY_CODE_MIN = 'R0002'"));
  1665. }
  1666. else if (ultraTabControl5.SelectedTab.Index == 2)
  1667. {
  1668. publicUltraGridDataCJBase21_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN IN ('R0003','R0004','R0005')"));//硬度
  1669. //publicUltraGridDataCJBase21_2.DataTable.AcceptChanges();
  1670. QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase21_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN IN ('R0003','R0004','R0005')"), splitContainer21, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAuditAdd, "PHY_CODE_MIN IN ('R0003','R0004','R0005')"));
  1671. }
  1672. else if (ultraTabControl5.SelectedTab.Index == 3)//金相
  1673. {
  1674. publicUltraGridDataCJBase22_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN IN ('R0012','R0013')"));//金相
  1675. //publicUltraGridDataCJBase22_2.DataTable.AcceptChanges();
  1676. QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase22_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN IN ('R0012','R0013')"), splitContainer22, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAuditAdd, "PHY_CODE_MIN IN ('R0012','R0013')"));
  1677. }
  1678. else if (ultraTabControl5.SelectedTab.Index == 4)//工艺
  1679. {
  1680. publicUltraGridDataCJBase23_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN IN ('R0010')"));//工艺
  1681. //publicUltraGridDataCJBase23_2.DataTable.AcceptChanges();
  1682. QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase23_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN IN ('R0010')"), splitContainer23, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAuditAdd, "PHY_CODE_MIN IN ('R0010')"));
  1683. }
  1684. else if (ultraTabControl5.SelectedTab.Index == 5)//其他
  1685. {
  1686. publicUltraGridDataCJBase24_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN NOT IN ('R0001', 'R0002','R0003','R0004','R0005','R0010','R0012','R0013')"));
  1687. //publicUltraGridDataCJBase24_2.DataTable.AcceptChanges();
  1688. QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase24_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN NOT IN ('R0001', 'R0002','R0003','R0004','R0005','R0010','R0012','R0013')"), splitContainer24, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAuditAdd, "PHY_CODE_MIN NOT IN ('R0001', 'R0002','R0003','R0004','R0005','R0010','R0012','R0013')"));
  1689. }
  1690. }
  1691. private void ultraTabControl5_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
  1692. {
  1693. //if (m_dtPhyMax == null || m_dtPhyMax.Rows.Count == 0) return;
  1694. if (toolMenu == null) return;
  1695. AddPhyDetailItemsAudit_Log();
  1696. }
  1697. private void CancelAuditCheckConsignDetail()
  1698. {
  1699. try
  1700. {
  1701. if (ultraTabControl1.SelectedTab.Index != 3)
  1702. {
  1703. MessageUtil.ShowWarning("只有在已审核数据页才能进行取消审核操作!");
  1704. return;
  1705. }
  1706. if (ultraGrid2.ActiveRow == null || ultraGrid2.ActiveRow.Activated == false)
  1707. {
  1708. MessageUtil.ShowWarning("请选择需要取消审核的检验信息!");
  1709. return;
  1710. }
  1711. if (dataTable3 == null || dataTable3.Rows.Count == 0)
  1712. {
  1713. return;
  1714. }
  1715. ultraGrid2.UpdateData();
  1716. DataRow[] arrBase = dataTable4.Select("CHK = 'True'");
  1717. if (arrBase == null || arrBase.Length == 0)
  1718. {
  1719. MessageUtil.ShowTips("请勾选至少一条检验信息!");
  1720. return;
  1721. }
  1722. //if (MessageUtil.ShowYesNoAndQuestion("是否确认取消审核?") == DialogResult.Yes)
  1723. //{
  1724. WinCancelSampleComfirm pc = new WinCancelSampleComfirm();
  1725. pc.ShowDialog();
  1726. if (pc.DialogResult != DialogResult.OK)
  1727. {
  1728. return;
  1729. }
  1730. string strRemark = pc.StrRemark;
  1731. string user = UserInfo.GetUserName();
  1732. string strDate = DateTime.Now.ToString();
  1733. strRemark = "取消审核由于" + strRemark + "(" + user + " " + strDate + ")";
  1734. string strCHECK_NO = "";
  1735. ArrayList alBase = new ArrayList();//存放所有需要更新的基础信息
  1736. ArrayList alBaseParams = new ArrayList();//存放单个基础参数信息
  1737. foreach (DataRow row in arrBase)
  1738. {
  1739. alBaseParams = new ArrayList();//增加要更新的基础标志位信息
  1740. alBaseParams.Add("3");
  1741. alBaseParams.Add(user);//审核人
  1742. alBaseParams.Add(strDate);//审核时间
  1743. alBaseParams.Add(strRemark);
  1744. alBaseParams.Add(strRemark);//样品备注row["SAMPLE_REMARK"].ToString()
  1745. alBaseParams.Add("4");
  1746. alBaseParams.Add("");//PHY_CODE_MAX
  1747. alBaseParams.Add("");
  1748. alBaseParams.Add("");
  1749. alBaseParams.Add(row["SAMPLE_NO"].ToString());
  1750. alBaseParams.Add(row["CHECK_NO"].ToString());
  1751. if (strCHECK_NO == "")
  1752. {
  1753. strCHECK_NO = row["CHECK_NO"].ToString();
  1754. }
  1755. alBase.Add(alBaseParams);
  1756. }
  1757. PublicServer.SetData("com.steering.lims.data.pipe.FrmDataCJBase.AuditCheckConsignDetail",
  1758. new Object[] { alBase }, this.ob);
  1759. QueryCheckConsignBaseDetail_Distinct(ultraGrid2, "456");
  1760. QueryCheckConsignBaseDetail_Distinct(ultraGrid1, "3");
  1761. PublicPipeAndOutdec.ActiveOperateRow(ultraGrid2, new string[] { "CHECK_NO" }, new string[] { strCHECK_NO });
  1762. PublicPipeAndOutdec.ActiveOperateRow(ultraGrid1, new string[] { "CHECK_NO" }, new string[] { strCHECK_NO });
  1763. MessageUtil.ShowTips("取消审核成功!");
  1764. //}
  1765. }
  1766. catch (Exception e)
  1767. {
  1768. MessageUtil.ShowWarning(e.Message);
  1769. }
  1770. }
  1771. private void CancelSingleAuditCheckConsignDetail(PublicUltraGridDataCJBase publicUltraGridDataCJBase)
  1772. {
  1773. try
  1774. {
  1775. if (ultraTabControl1.SelectedTab.Index != 3)
  1776. {
  1777. MessageUtil.ShowWarning("只有在已审核数据页才能进行取消单项审核操作!");
  1778. return;
  1779. }
  1780. if (ultraGrid2.ActiveRow == null || ultraGrid2.ActiveRow.Activated == false)
  1781. {
  1782. MessageUtil.ShowWarning("请选择需要取消单项审核的检验信息!");
  1783. return;
  1784. }
  1785. if (dataTable3 == null || dataTable3.Rows.Count == 0)
  1786. {
  1787. return;
  1788. }
  1789. ultraGrid2.UpdateData();
  1790. DataRow[] arrBase = dataTable4.Select("CHK = 'True'");
  1791. if (arrBase == null || arrBase.Length == 0)
  1792. {
  1793. MessageUtil.ShowTips("请勾选至少一条检验信息!");
  1794. return;
  1795. }
  1796. //if (MessageUtil.ShowYesNoAndQuestion("是否确认单项审核?") == DialogResult.Yes)
  1797. //{
  1798. WinCancelSampleComfirm pc = new WinCancelSampleComfirm();
  1799. pc.ShowDialog();
  1800. if (pc.DialogResult != DialogResult.OK)
  1801. {
  1802. return;
  1803. }
  1804. string strRemark = pc.StrRemark;
  1805. string user = UserInfo.GetUserName();
  1806. string strDate = DateTime.Now.ToString();
  1807. strRemark = "取消单项审核由于" + strRemark + "(" + user + " " + strDate + ")";
  1808. ArrayList alBase = new ArrayList();//存放所有需要更新的基础信息
  1809. ArrayList alBaseParams = new ArrayList();//存放单个基础参数信息
  1810. string strCHECK_NO = "";
  1811. string rowSample = "";
  1812. foreach (DataRow dr in publicUltraGridDataCJBase.DataTable.Rows)
  1813. {
  1814. if (rowSample.IndexOf(dr["PHY_CODE_MAX"].ToString()) < 0)
  1815. {
  1816. rowSample += dr["PHY_CODE_MAX"].ToString() + " ";
  1817. }
  1818. }
  1819. foreach (DataRow row in arrBase)
  1820. {
  1821. foreach (string strPHY_CODE_MAX in rowSample.Trim().Split(' '))
  1822. {
  1823. alBaseParams = new ArrayList();//增加要更新的基础标志位信息
  1824. alBaseParams.Add("3");
  1825. alBaseParams.Add(user);//审核人
  1826. alBaseParams.Add(strDate);//审核时间
  1827. alBaseParams.Add(strRemark);
  1828. alBaseParams.Add(strRemark);//样品备注row["SAMPLE_REMARK"].ToString()
  1829. alBaseParams.Add("4");
  1830. alBaseParams.Add(strPHY_CODE_MAX);//PHY_CODE_MAX
  1831. alBaseParams.Add(strPHY_CODE_MAX);
  1832. alBaseParams.Add(strPHY_CODE_MAX);
  1833. alBaseParams.Add(row["SAMPLE_NO"].ToString());
  1834. alBaseParams.Add(row["CHECK_NO"].ToString());
  1835. if (strCHECK_NO == "")
  1836. {
  1837. strCHECK_NO = row["CHECK_NO"].ToString();
  1838. }
  1839. alBase.Add(alBaseParams);
  1840. }
  1841. }
  1842. PublicServer.SetData("com.steering.lims.data.pipe.FrmDataCJBase.AuditCheckConsignDetail",
  1843. new Object[] { alBase }, this.ob);
  1844. QueryCheckConsignBaseDetail_Distinct(ultraGrid2, "4");
  1845. QueryCheckConsignBaseDetail_Distinct(ultraGrid1, "3");
  1846. PublicPipeAndOutdec.ActiveOperateRow(ultraGrid2, new string[] { "CHECK_NO" }, new string[] { strCHECK_NO });
  1847. PublicPipeAndOutdec.ActiveOperateRow(ultraGrid1, new string[] { "CHECK_NO" }, new string[] { strCHECK_NO });
  1848. MessageUtil.ShowTips("取消单项审核成功!");
  1849. //}
  1850. }
  1851. catch (Exception e)
  1852. {
  1853. MessageUtil.ShowWarning(e.Message);
  1854. }
  1855. }
  1856. private void ultraGrid2_CellChange(object sender, CellEventArgs e)
  1857. {
  1858. if (e.Cell.Row.HasChild() && e.Cell.Column.Key == "CHK")
  1859. {
  1860. ultraGrid2.UpdateData();
  1861. if (e.Cell.Value.ToString() == "True")
  1862. {
  1863. foreach (UltraGridRow dr in e.Cell.Row.ChildBands[0].Rows)
  1864. {
  1865. dr.Cells["CHK"].Value = "True";
  1866. }
  1867. }
  1868. else
  1869. {
  1870. foreach (UltraGridRow dr in e.Cell.Row.ChildBands[0].Rows)
  1871. {
  1872. dr.Cells["CHK"].Value = "False";
  1873. }
  1874. }
  1875. }
  1876. }
  1877. #endregion
  1878. private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
  1879. {
  1880. if (toolMenu == null) return;
  1881. if (ultraTabControl1.SelectedTab.Index == 0)
  1882. {
  1883. if (toolMenu.Toolbars[0].Tools.Exists("Query"))
  1884. {
  1885. toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.True;
  1886. }
  1887. if (toolMenu.Toolbars[0].Tools.Exists("Add"))
  1888. {
  1889. this.toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.True;
  1890. }
  1891. if (toolMenu.Toolbars[0].Tools.Exists("Update"))
  1892. {
  1893. toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.False;
  1894. }
  1895. if (toolMenu.Toolbars[0].Tools.Exists("Delete"))
  1896. {
  1897. toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.False;
  1898. }
  1899. if (toolMenu.Toolbars[0].Tools.Exists("Audit"))
  1900. {
  1901. toolMenu.Toolbars[0].Tools["Audit"].InstanceProps.Visible = DefaultableBoolean.False;
  1902. }
  1903. if (toolMenu.Toolbars[0].Tools.Exists("CancelAudit"))
  1904. {
  1905. toolMenu.Toolbars[0].Tools["CancelAudit"].InstanceProps.Visible = DefaultableBoolean.False;
  1906. }
  1907. if (toolMenu.Toolbars[0].Tools.Exists("SingleAudit"))
  1908. {
  1909. toolMenu.Toolbars[0].Tools["SingleAudit"].InstanceProps.Visible = DefaultableBoolean.False;
  1910. }
  1911. if (toolMenu.Toolbars[0].Tools.Exists("CancelSingleAudit"))
  1912. {
  1913. toolMenu.Toolbars[0].Tools["CancelSingleAudit"].InstanceProps.Visible = DefaultableBoolean.False;
  1914. }
  1915. }
  1916. else if (ultraTabControl1.SelectedTab.Index == 1)
  1917. {
  1918. if (toolMenu.Toolbars[0].Tools.Exists("Query"))
  1919. {
  1920. toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.True;
  1921. }
  1922. if (toolMenu.Toolbars[0].Tools.Exists("Add"))
  1923. {
  1924. this.toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.False;
  1925. }
  1926. if (toolMenu.Toolbars[0].Tools.Exists("Update"))
  1927. {
  1928. toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.True;
  1929. }
  1930. if (toolMenu.Toolbars[0].Tools.Exists("Delete"))
  1931. {
  1932. toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.True;
  1933. }
  1934. if (toolMenu.Toolbars[0].Tools.Exists("Audit"))
  1935. {
  1936. toolMenu.Toolbars[0].Tools["Audit"].InstanceProps.Visible = DefaultableBoolean.False;
  1937. }
  1938. if (toolMenu.Toolbars[0].Tools.Exists("CancelAudit"))
  1939. {
  1940. toolMenu.Toolbars[0].Tools["CancelAudit"].InstanceProps.Visible = DefaultableBoolean.False;
  1941. }
  1942. if (toolMenu.Toolbars[0].Tools.Exists("SingleAudit"))
  1943. {
  1944. toolMenu.Toolbars[0].Tools["SingleAudit"].InstanceProps.Visible = DefaultableBoolean.False;
  1945. }
  1946. if (toolMenu.Toolbars[0].Tools.Exists("CancelSingleAudit"))
  1947. {
  1948. toolMenu.Toolbars[0].Tools["CancelSingleAudit"].InstanceProps.Visible = DefaultableBoolean.False;
  1949. }
  1950. }
  1951. else if (ultraTabControl1.SelectedTab.Index == 2)
  1952. {
  1953. if (toolMenu.Toolbars[0].Tools.Exists("Query"))
  1954. {
  1955. toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.True;
  1956. }
  1957. if (toolMenu.Toolbars[0].Tools.Exists("Add"))
  1958. {
  1959. this.toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.False;
  1960. }
  1961. if (toolMenu.Toolbars[0].Tools.Exists("Update"))
  1962. {
  1963. toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.False;
  1964. }
  1965. if (toolMenu.Toolbars[0].Tools.Exists("Delete"))
  1966. {
  1967. toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.False;
  1968. }
  1969. if (toolMenu.Toolbars[0].Tools.Exists("Audit"))
  1970. {
  1971. toolMenu.Toolbars[0].Tools["Audit"].InstanceProps.Visible = DefaultableBoolean.True;
  1972. }
  1973. if (toolMenu.Toolbars[0].Tools.Exists("CancelAudit"))
  1974. {
  1975. toolMenu.Toolbars[0].Tools["CancelAudit"].InstanceProps.Visible = DefaultableBoolean.False;
  1976. }
  1977. if (toolMenu.Toolbars[0].Tools.Exists("SingleAudit"))
  1978. {
  1979. toolMenu.Toolbars[0].Tools["SingleAudit"].InstanceProps.Visible = DefaultableBoolean.True;
  1980. }
  1981. if (toolMenu.Toolbars[0].Tools.Exists("CancelSingleAudit"))
  1982. {
  1983. toolMenu.Toolbars[0].Tools["CancelSingleAudit"].InstanceProps.Visible = DefaultableBoolean.False;
  1984. }
  1985. }
  1986. else if (ultraTabControl1.SelectedTab.Index == 3)
  1987. {
  1988. if (toolMenu.Toolbars[0].Tools.Exists("Query"))
  1989. {
  1990. toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.True;
  1991. }
  1992. if (toolMenu.Toolbars[0].Tools.Exists("Add"))
  1993. {
  1994. this.toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.False;
  1995. }
  1996. if (toolMenu.Toolbars[0].Tools.Exists("Update"))
  1997. {
  1998. toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.False;
  1999. }
  2000. if (toolMenu.Toolbars[0].Tools.Exists("Delete"))
  2001. {
  2002. toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.False;
  2003. }
  2004. if (toolMenu.Toolbars[0].Tools.Exists("Audit"))
  2005. {
  2006. toolMenu.Toolbars[0].Tools["Audit"].InstanceProps.Visible = DefaultableBoolean.False;
  2007. }
  2008. if (toolMenu.Toolbars[0].Tools.Exists("CancelAudit"))
  2009. {
  2010. toolMenu.Toolbars[0].Tools["CancelAudit"].InstanceProps.Visible = DefaultableBoolean.True;
  2011. }
  2012. if (toolMenu.Toolbars[0].Tools.Exists("SingleAudit"))
  2013. {
  2014. toolMenu.Toolbars[0].Tools["SingleAudit"].InstanceProps.Visible = DefaultableBoolean.False;
  2015. }
  2016. if (toolMenu.Toolbars[0].Tools.Exists("CancelSingleAudit"))
  2017. {
  2018. toolMenu.Toolbars[0].Tools["CancelSingleAudit"].InstanceProps.Visible = DefaultableBoolean.True;
  2019. }
  2020. }
  2021. }
  2022. private void FrmLabMecDataCJAudit_Shown(object sender, EventArgs e)
  2023. {
  2024. if (toolMenu == null) return;
  2025. if (toolMenu.Toolbars[0].Tools.Exists("Query"))
  2026. {
  2027. toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.True;
  2028. }
  2029. if (toolMenu.Toolbars[0].Tools.Exists("Add"))
  2030. {
  2031. this.toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.True;
  2032. }
  2033. if (toolMenu.Toolbars[0].Tools.Exists("Update"))
  2034. {
  2035. toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.False;
  2036. }
  2037. if (toolMenu.Toolbars[0].Tools.Exists("Delete"))
  2038. {
  2039. toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.False;
  2040. }
  2041. if (toolMenu.Toolbars[0].Tools.Exists("Audit"))
  2042. {
  2043. toolMenu.Toolbars[0].Tools["Audit"].InstanceProps.Visible = DefaultableBoolean.False;
  2044. }
  2045. if (toolMenu.Toolbars[0].Tools.Exists("CancelAudit"))
  2046. {
  2047. toolMenu.Toolbars[0].Tools["CancelAudit"].InstanceProps.Visible = DefaultableBoolean.False;
  2048. }
  2049. if (toolMenu.Toolbars[0].Tools.Exists("SingleAudit"))
  2050. {
  2051. toolMenu.Toolbars[0].Tools["SingleAudit"].InstanceProps.Visible = DefaultableBoolean.False;
  2052. }
  2053. if (toolMenu.Toolbars[0].Tools.Exists("CancelSingleAudit"))
  2054. {
  2055. toolMenu.Toolbars[0].Tools["CancelSingleAudit"].InstanceProps.Visible = DefaultableBoolean.False;
  2056. }
  2057. }
  2058. }
  2059. }