| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179218021812182218321842185218621872188218921902191219221932194219521962197219821992200220122022203220422052206220722082209221022112212221322142215221622172218221922202221222222232224222522262227222822292230223122322233223422352236223722382239224022412242224322442245224622472248224922502251225222532254225522562257225822592260226122622263226422652266226722682269227022712272227322742275227622772278227922802281228222832284228522862287228822892290229122922293229422952296229722982299230023012302230323042305230623072308230923102311231223132314231523162317231823192320232123222323232423252326232723282329233023312332233323342335233623372338233923402341234223432344234523462347234823492350235123522353235423552356235723582359236023612362236323642365236623672368236923702371237223732374237523762377237823792380238123822383238423852386238723882389239023912392239323942395239623972398239924002401240224032404240524062407240824092410241124122413241424152416241724182419242024212422242324242425242624272428242924302431243224332434243524362437243824392440244124422443244424452446244724482449245024512452245324542455245624572458245924602461246224632464246524662467246824692470247124722473247424752476247724782479248024812482248324842485248624872488248924902491249224932494249524962497249824992500250125022503250425052506250725082509251025112512251325142515251625172518251925202521252225232524252525262527252825292530253125322533253425352536253725382539254025412542254325442545254625472548254925502551255225532554255525562557255825592560256125622563256425652566256725682569257025712572257325742575257625772578257925802581258225832584258525862587258825892590259125922593259425952596259725982599260026012602260326042605260626072608260926102611261226132614261526162617261826192620262126222623262426252626262726282629263026312632263326342635263626372638263926402641264226432644264526462647264826492650265126522653265426552656265726582659266026612662266326642665266626672668266926702671267226732674267526762677267826792680268126822683268426852686268726882689269026912692269326942695269626972698269927002701270227032704270527062707270827092710271127122713271427152716271727182719272027212722272327242725272627272728272927302731273227332734273527362737273827392740274127422743274427452746274727482749275027512752275327542755275627572758275927602761276227632764276527662767276827692770277127722773277427752776277727782779278027812782278327842785278627872788278927902791279227932794279527962797279827992800280128022803280428052806280728082809281028112812281328142815281628172818281928202821282228232824282528262827282828292830283128322833 |
- using System;
- using System.Collections.Generic;
- using System.ComponentModel;
- using System.Data;
- using System.Drawing;
- using System.Linq;
- using System.Text;
- using System.Windows.Forms;
- using CoreFS.CA06;
- using System.Collections;
- using Core.Mes.Client.Comm.Tool;
- using Infragistics.Win.UltraWinGrid;
- using Core.Mes.Client.Comm.Control;
- using Infragistics.Win;
- using Core.StlMes.Client.Lims.Data.PipeAndOutdec.数据管理.外委实验管理;
- using Core.StlMes.Client.Lims.Data.PipeAndOutdec.封装类.实体类;
- namespace Core.StlMes.Client.Lims.Data.PipeAndOutdec
- {
- //工程录入界面 各检验大项分Tab页展示
- public partial class FrmOutdecLabEngDataCJAudit : FrmBase
- {
- private string[] arrId;//数据权限
- private string[] plineCodes = { };
- private DataTable m_dtPhyMax;//存放所有要检验的项目
- private DataTable m_dtPhyItems;//存放所有要检验的项目试验方法
- private DataTable m_dtPhyMaxAdd;//存放所有已检验的项目
- private DataTable m_dtPhyItemsAdd;//存放所有已检验的项目试验方法
- private DataTable m_dtPhyMaxAudit;
- private DataTable m_dtPhyItemsAudit;
- private DataTable m_dtPhyMaxAuditAdd;
- private DataTable m_dtPhyItemsAuditAdd;
- private string CHECK_NO = "";
- private string SAMPLE_NO = "";
- private string PHY_CODE_MAX = "";
- private int tabIndex = 0;//保存当前的tab页
- public FrmOutdecLabEngDataCJAudit()
- {
- InitializeComponent();
- }
- protected override void OnLoad(EventArgs e)
- {
- base.OnLoad(e);
- //publicUltraGridBase1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头
- //publicUltraGridBase2.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头
- publicUltraGridBase1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
- publicUltraGridBase2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
- publicUltraGridDataCJBase1_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头 拉伸
- publicUltraGridDataCJBase1_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//
- publicUltraGridDataCJBase1_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//
- publicUltraGridDataCJBase2_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头
- publicUltraGridDataCJBase2_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
- publicUltraGridDataCJBase2_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
- publicUltraGridDataCJBase3_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
- publicUltraGridDataCJBase3_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
- publicUltraGridDataCJBase3_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
- publicUltraGridDataCJBase4_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
- publicUltraGridDataCJBase4_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
- publicUltraGridDataCJBase4_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
- //publicUltraGridDataCJBase5_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
- //publicUltraGridDataCJBase5_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
- //publicUltraGridDataCJBase5_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
- //publicUltraGridDataCJBase6_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
- //publicUltraGridDataCJBase6_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
- //publicUltraGridDataCJBase6_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
- publicUltraGridDataCJBase7_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头 拉伸
- publicUltraGridDataCJBase7_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//
- publicUltraGridDataCJBase7_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//
- publicUltraGridDataCJBase8_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头
- publicUltraGridDataCJBase8_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
- publicUltraGridDataCJBase8_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
- publicUltraGridDataCJBase9_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
- publicUltraGridDataCJBase9_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
- publicUltraGridDataCJBase9_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
- publicUltraGridDataCJBase10_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
- publicUltraGridDataCJBase10_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
- publicUltraGridDataCJBase10_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
- //publicUltraGridDataCJBase11_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
- //publicUltraGridDataCJBase11_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
- //publicUltraGridDataCJBase11_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
- //publicUltraGridDataCJBase12_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
- //publicUltraGridDataCJBase12_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
- //publicUltraGridDataCJBase12_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
- publicUltraGridDataCJBase13_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头 拉伸
- publicUltraGridDataCJBase13_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//
- publicUltraGridDataCJBase13_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//
- publicUltraGridDataCJBase14_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头
- publicUltraGridDataCJBase14_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
- publicUltraGridDataCJBase14_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
- publicUltraGridDataCJBase15_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
- publicUltraGridDataCJBase15_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
- publicUltraGridDataCJBase15_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
- publicUltraGridDataCJBase16_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
- publicUltraGridDataCJBase16_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
- publicUltraGridDataCJBase16_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
- //publicUltraGridDataCJBase17_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
- //publicUltraGridDataCJBase17_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
- //publicUltraGridDataCJBase17_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
- //publicUltraGridDataCJBase18_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
- //publicUltraGridDataCJBase18_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
- //publicUltraGridDataCJBase18_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
- ultraGrid1.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
- ultraGrid2.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
- publicUltraGridDataCJBase19_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头 拉伸
- publicUltraGridDataCJBase19_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//
- publicUltraGridDataCJBase19_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//
- publicUltraGridDataCJBase20_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;//不显示行头
- publicUltraGridDataCJBase20_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
- publicUltraGridDataCJBase20_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
- publicUltraGridDataCJBase21_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
- publicUltraGridDataCJBase21_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
- publicUltraGridDataCJBase21_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
- publicUltraGridDataCJBase22_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
- publicUltraGridDataCJBase22_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
- publicUltraGridDataCJBase22_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
- //publicUltraGridDataCJBase23_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
- //publicUltraGridDataCJBase23_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
- //publicUltraGridDataCJBase23_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
- //publicUltraGridDataCJBase24_1.Ug.DisplayLayout.Override.RowSelectors = Infragistics.Win.DefaultableBoolean.False;
- //publicUltraGridDataCJBase24_1.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
- //publicUltraGridDataCJBase24_2.Ug.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
- //ultraGrid2.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
- //ultraGrid2.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
- }
- private void FrmDataCJBase_Load(object sender, EventArgs e)
- {
- //arrId = this.ValidDataPurviewIds;//获取数据权限
- arrId = new string[] { "002001007014" };//工程项目
- plineCodes = comm.GetPlineCode(ValidDataPurviewIds, ob);
- InitColumns();
- publicDataCJBase1.checkNameEnable();
- publicDataCJBase2.checkNameEnable();
- publicDataCJBase3.checkNameEnable();
- publicDataCJBase4.checkNameEnable();
- //publicDataCJBase1.initCheckEqiupment(arrId, this.ob);
- //publicDataCJBase2.initCheckEqiupment(arrId, this.ob);
- //publicDataCJBase3.initCheckEqiupment(arrId, this.ob);
- //publicDataCJBase4.initCheckEqiupment(arrId, this.ob);
- outdecQueryBase1.ShowControl();
- outdecQueryBase1.BindComboxNew(this.UserInfo.GetDeptid(), this.ob);
- }
- private void InitColumns()
- {
- outdecShowBase1.ChangeLabel();
- outdecShowBase2.ChangeLabel();
- outdecQueryBase1.BindComboxNew(this.UserInfo.GetDeptid(), this.ob);
- //未录入
- publicUltraGridBase1.PublicUltraGridBaseActive += new EventHandler(pipeUltraGridBase1_PublicUltraGridBaseActive);//调用委托事件
- publicUltraGridBase1.InitColumnsOutdecBase(new string[] { "CHECK_NO", "SAMPLE_NO" }, true, null);
- //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" };
- //string[] arrCaptionBase = new string[] { "检验编号", "样管号", "炉号", "钢级", "钢号", "技术标准", "合同号", "外径", "壁厚", "委托单位", "委托人", "委托时间", "是否监制", "特殊要求", "标志位", "标志位", "备注" };
- //publicUltraGridBase1.InitColumns(arrColumnsBase, arrCaptionBase);
- //publicUltraGridBase1.setColumnShowOrHidden(new string[] { "CHECK_NO", "SAMPLE_NO", }, true);//显示列
- //publicUltraGridBase1.setOtherColumnReadOnly(null);//可编辑列
- publicUltraGridDataCJBase1_1.InitColumnsPhyConfigItems();
- publicUltraGridDataCJBase1_2.InitColumnsOutdecPhyDetail();
- publicUltraGridDataCJBase2_1.InitColumnsPhyConfigItems();
- publicUltraGridDataCJBase2_2.InitColumnsOutdecPhyDetail();
- publicUltraGridDataCJBase3_1.InitColumnsPhyConfigItems();
- publicUltraGridDataCJBase3_2.InitColumnsOutdecPhyDetail();
- publicUltraGridDataCJBase4_1.InitColumnsPhyConfigItems();
- publicUltraGridDataCJBase4_2.InitColumnsOutdecPhyDetail();
- //publicUltraGridDetail1.InitColumnsPipeDetail(new string[] { "PHY_NAME_MAX", "FILE_PATH1", "FILE_PATH2", "FILE_PATH3", "STEP", "LOAD", "PRESSURE_MEDIUM", "INTERNAL_PRESSURE", "DOGLEG_DEGREE", "HOLD_TIME", "PIN", "BOX", "COMPOUND_TYPE", "COMPOUND_WEIGHT", "MAKE_UP_TORQUE", "TOTAL_TORQUE", "BREAK_OUT_TORQUE", "OBSERVED_RESULT" }, new string[] { "STEP", "LOAD", "PRESSURE_MEDIUM", "INTERNAL_PRESSURE", "DOGLEG_DEGREE", "HOLD_TIME", "PIN", "BOX", "COMPOUND_TYPE", "COMPOUND_WEIGHT", "MAKE_UP_TORQUE", "TOTAL_TORQUE", "BREAK_OUT_TORQUE", "OBSERVED_RESULT" }, true, this.ob, "0");
- //publicUltraGridDataCJBase5_1.InitColumnsPhyConfigItems();
- //publicUltraGridDataCJBase5_2.InitColumnsOutdecPhyDetail();
- //publicUltraGridDataCJBase6_1.InitColumnsPhyConfigItems();
- //publicUltraGridDataCJBase6_2.InitColumnsOutdecPhyDetail();
- //已录入
- publicUltraGridBase2.PublicUltraGridBaseActive += new EventHandler(pipeUltraGridBase2_PublicUltraGridBaseActive);//调用委托事件
- publicUltraGridBase2.InitColumnsOutdecBase(new string[] { "CHECK_NO", "SAMPLE_NO" }, true, null);
- //publicUltraGridBase2.InitColumns(arrColumnsBase, arrCaptionBase);
- //publicUltraGridBase2.setColumnShowOrHidden(new string[] { "CHECK_NO", "SAMPLE_NO", }, true);//显示列
- //publicUltraGridBase2.setOtherColumnReadOnly(new string[] { null });//可编辑列
- publicUltraGridDataCJBase7_1.InitColumnsPhyConfigItems();
- publicUltraGridDataCJBase7_2.InitColumnsOutdecPhyDetail();
- publicUltraGridDataCJBase8_1.InitColumnsPhyConfigItems();
- publicUltraGridDataCJBase8_2.InitColumnsOutdecPhyDetail();
- publicUltraGridDataCJBase9_1.InitColumnsPhyConfigItems();
- publicUltraGridDataCJBase9_2.InitColumnsOutdecPhyDetail();
- publicUltraGridDataCJBase10_1.InitColumnsPhyConfigItems();
- publicUltraGridDataCJBase10_2.InitColumnsOutdecPhyDetail();
- //publicUltraGridDetail2.InitColumnsPipeDetail(new string[] { "PHY_NAME_MAX", "FILE_PATH1", "FILE_PATH2", "FILE_PATH3", "STEP", "LOAD", "PRESSURE_MEDIUM", "INTERNAL_PRESSURE", "DOGLEG_DEGREE", "HOLD_TIME", "PIN", "BOX", "COMPOUND_TYPE", "COMPOUND_WEIGHT", "MAKE_UP_TORQUE", "TOTAL_TORQUE", "BREAK_OUT_TORQUE", "OBSERVED_RESULT" }, new string[] { "STEP", "LOAD", "PRESSURE_MEDIUM", "INTERNAL_PRESSURE", "DOGLEG_DEGREE", "HOLD_TIME", "PIN", "BOX", "COMPOUND_TYPE", "COMPOUND_WEIGHT", "MAKE_UP_TORQUE", "TOTAL_TORQUE", "BREAK_OUT_TORQUE", "OBSERVED_RESULT" }, true, this.ob, "0");
-
- //publicUltraGridDataCJBase11_1.InitColumnsPhyConfigItems();
- //publicUltraGridDataCJBase11_2.InitColumnsOutdecPhyDetail();
- //publicUltraGridDataCJBase12_1.InitColumnsPhyConfigItems();
- //publicUltraGridDataCJBase12_2.InitColumnsOutdecPhyDetail();
- PublicPipeAndOutdec.setColumnShowOrHidden(ultraGrid1, new string[] { "CHK", "CHECK_NO" }, true);
- PublicPipeAndOutdec.setColumnShowOrHidden(ultraGrid1, new string[] { "CHK", "SAMPLE_NO" }, true, 1);//显示列
- PublicPipeAndOutdec.setOtherColumnReadOnly(ultraGrid1, new string[] { "CHK" });//可编辑列
- PublicPipeAndOutdec.setOtherColumnReadOnly(ultraGrid1, new string[] { "CHK" }, 1);
- publicUltraGridDataCJBase13_1.InitColumnsPhyConfigItems(null);
- publicUltraGridDataCJBase13_1.setOtherColumnReadOnly(null);
- publicUltraGridDataCJBase13_2.InitColumnsOutdecPhyDetail(null);
- publicUltraGridDataCJBase13_2.setOtherColumnReadOnly(null);
- publicUltraGridDataCJBase14_1.InitColumnsPhyConfigItems(null);
- publicUltraGridDataCJBase14_1.setOtherColumnReadOnly(null);
- publicUltraGridDataCJBase14_2.InitColumnsOutdecPhyDetail(null);
- publicUltraGridDataCJBase14_2.setOtherColumnReadOnly(null);
- publicUltraGridDataCJBase15_1.InitColumnsPhyConfigItems(null);
- publicUltraGridDataCJBase15_1.setOtherColumnReadOnly(null);
- publicUltraGridDataCJBase15_2.InitColumnsOutdecPhyDetail(null);
- publicUltraGridDataCJBase15_2.setOtherColumnReadOnly(null);
- publicUltraGridDataCJBase16_1.InitColumnsPhyConfigItems(null);
- publicUltraGridDataCJBase16_2.InitColumnsOutdecPhyDetail(null);
- //publicUltraGridDetail3.InitColumnsPipeDetail(new string[] { "PHY_NAME_MAX", "FILE_PATH1", "FILE_PATH2", "FILE_PATH3", "STEP", "LOAD", "PRESSURE_MEDIUM", "INTERNAL_PRESSURE", "DOGLEG_DEGREE", "HOLD_TIME", "PIN", "BOX", "COMPOUND_TYPE", "COMPOUND_WEIGHT", "MAKE_UP_TORQUE", "TOTAL_TORQUE", "BREAK_OUT_TORQUE", "OBSERVED_RESULT" },null, true, this.ob, "1");
-
- //publicUltraGridDataCJBase17_1.InitColumnsPhyConfigItems(null);
- //publicUltraGridDataCJBase17_2.InitColumnsOutdecPhyDetail(null);
- //publicUltraGridDataCJBase18_1.InitColumnsPhyConfigItems(null);
- //publicUltraGridDataCJBase18_2.InitColumnsOutdecPhyDetail(null);
- PublicPipeAndOutdec.setColumnShowOrHidden(ultraGrid2, new string[] { "CHK", "CHECK_NO" }, true);
- PublicPipeAndOutdec.setColumnShowOrHidden(ultraGrid2, new string[] { "CHK", "SAMPLE_NO" }, true, 1);//显示列
- PublicPipeAndOutdec.setOtherColumnReadOnly(ultraGrid2, new string[] { "CHK" });//可编辑列
- PublicPipeAndOutdec.setOtherColumnReadOnly(ultraGrid2, new string[] { "CHK" }, 1);
- publicUltraGridDataCJBase19_1.InitColumnsPhyConfigItems(null);
- publicUltraGridDataCJBase19_2.InitColumnsOutdecPhyDetail(null);
- publicUltraGridDataCJBase20_1.InitColumnsPhyConfigItems(null);
- publicUltraGridDataCJBase20_2.InitColumnsOutdecPhyDetail(null);
- publicUltraGridDataCJBase21_1.InitColumnsPhyConfigItems(null);
- publicUltraGridDataCJBase21_2.InitColumnsOutdecPhyDetail(null);
- publicUltraGridDataCJBase22_1.InitColumnsPhyConfigItems(null);
- publicUltraGridDataCJBase22_2.InitColumnsOutdecPhyDetail(null);
- //publicUltraGridDetail4.InitColumnsPipeDetail(new string[] { "PHY_NAME_MAX", "FILE_PATH1", "FILE_PATH2", "FILE_PATH3", "STEP", "LOAD", "PRESSURE_MEDIUM", "INTERNAL_PRESSURE", "DOGLEG_DEGREE", "HOLD_TIME", "PIN", "BOX", "COMPOUND_TYPE", "COMPOUND_WEIGHT", "MAKE_UP_TORQUE", "TOTAL_TORQUE", "BREAK_OUT_TORQUE", "OBSERVED_RESULT" }, null, true, this.ob, "1");
-
- //publicUltraGridDataCJBase23_1.InitColumnsPhyConfigItems(null);
- //publicUltraGridDataCJBase23_2.InitColumnsOutdecPhyDetail(null);
- //publicUltraGridDataCJBase24_1.InitColumnsPhyConfigItems(null);
- //publicUltraGridDataCJBase24_2.InitColumnsOutdecPhyDetail(null);
- }
- /// <summary>
- /// 重写基类方法
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="ToolbarKey"></param>
- public override void ToolBar_Click(object sender, string ToolbarKey)
- {
- //查询、确认、退出
- switch (ToolbarKey)
- {
- case "Query":
- if (ultraTabControl1.SelectedTab.Index == 0)
- {
- QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase1, "2");
- }
- else if (ultraTabControl1.SelectedTab.Index == 1)
- {
- QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase2, "3456");
- }
- else if (ultraTabControl1.SelectedTab.Index == 2)
- {
- QueryCheckConsignBaseDetail_Distinct(ultraGrid1, "3");
- }
- else if (ultraTabControl1.SelectedTab.Index == 3)
- {
- QueryCheckConsignBaseDetail_Distinct(ultraGrid2, "456");
- }
- break;
- case "Add":
- if (ultraTabControl2.SelectedTab.Index == 0)
- {
- AddCheckConsignProcessResult(publicUltraGridDataCJBase1_2, publicUltraGridDataCJBase1_1);
- }
- else if (ultraTabControl2.SelectedTab.Index == 1)
- {
- AddCheckConsignProcessResult(publicUltraGridDataCJBase2_2, publicUltraGridDataCJBase2_1);
- }
- else if (ultraTabControl2.SelectedTab.Index == 2)
- {
- AddCheckConsignProcessResult(publicUltraGridDataCJBase3_2, publicUltraGridDataCJBase3_1);
- }
- else if (ultraTabControl2.SelectedTab.Index == 3)
- {
- AddCheckConsignProcessResult(publicUltraGridDataCJBase4_2, publicUltraGridDataCJBase4_1);
- }
- //else if (ultraTabControl2.SelectedTab.Index == 4)
- //{
- // AddCheckConsignProcessResult(publicUltraGridDataCJBase5_2, publicUltraGridDataCJBase5_1);
- //}
- //else if (ultraTabControl2.SelectedTab.Index == 5)
- //{
- // AddCheckConsignProcessResult(publicUltraGridDataCJBase6_2, publicUltraGridDataCJBase6_1);
- //}
- break;
- case "Update":
- if (ultraTabControl3.SelectedTab.Index == 0)
- {
- UpdateCheckConsignProcessResult(publicUltraGridDataCJBase7_2, publicUltraGridDataCJBase7_1);
- }
- else if (ultraTabControl3.SelectedTab.Index == 1)
- {
- UpdateCheckConsignProcessResult(publicUltraGridDataCJBase8_2, publicUltraGridDataCJBase8_1);
- }
- else if (ultraTabControl3.SelectedTab.Index == 2)
- {
- UpdateCheckConsignProcessResult(publicUltraGridDataCJBase9_2, publicUltraGridDataCJBase9_1);
- }
- else if (ultraTabControl3.SelectedTab.Index == 3)
- {
- UpdateCheckConsignProcessResult(publicUltraGridDataCJBase10_2, publicUltraGridDataCJBase10_1);
- }
- //else if (ultraTabControl3.SelectedTab.Index == 4)
- //{
- // UpdateCheckConsignProcessResult(publicUltraGridDataCJBase11_2, publicUltraGridDataCJBase11_1);
- //}
- //else if (ultraTabControl3.SelectedTab.Index == 5)
- //{
- // UpdateCheckConsignProcessResult(publicUltraGridDataCJBase12_2, publicUltraGridDataCJBase12_1);
- //}
- //UpdateCheckConsignProcessResult();
- break;
- case "Delete":
- if (ultraTabControl3.SelectedTab.Index == 0)
- {
- DeleteCheckConsignProcessResult(publicUltraGridDataCJBase7_2, publicUltraGridDataCJBase7_1);
- }
- else if (ultraTabControl3.SelectedTab.Index == 1)
- {
- DeleteCheckConsignProcessResult(publicUltraGridDataCJBase8_2, publicUltraGridDataCJBase8_1);
- }
- else if (ultraTabControl3.SelectedTab.Index == 2)
- {
- DeleteCheckConsignProcessResult(publicUltraGridDataCJBase9_2, publicUltraGridDataCJBase9_1);
- }
- else if (ultraTabControl3.SelectedTab.Index == 3)
- {
- DeleteCheckConsignProcessResult(publicUltraGridDataCJBase10_2, publicUltraGridDataCJBase10_1);
- }
- //else if (ultraTabControl3.SelectedTab.Index == 4)
- //{
- // DeleteCheckConsignProcessResult(publicUltraGridDataCJBase11_2, publicUltraGridDataCJBase11_1);
- //}
- //else if (ultraTabControl3.SelectedTab.Index == 5)
- //{
- // DeleteCheckConsignProcessResult(publicUltraGridDataCJBase12_2, publicUltraGridDataCJBase12_1);
- //}
- //DeleteCheckConsignProcessResult();
- break;
- case "Audit":
- AuditCheckConsignDetail();//SingleAuditCheckConsignDetail()
- break;
- case "CancelAudit":
- CancelAuditCheckConsignDetail();//SingleAuditCheckConsignDetail()
- break;
- case "SingleAudit":
- if (ultraTabControl4.SelectedTab.Index == 0)
- {
- SingleAuditCheckConsignDetail(publicUltraGridDataCJBase13_2);
- }
- else if (ultraTabControl4.SelectedTab.Index == 1)
- {
- SingleAuditCheckConsignDetail(publicUltraGridDataCJBase14_2);
- }
- else if (ultraTabControl4.SelectedTab.Index == 2)
- {
- SingleAuditCheckConsignDetail(publicUltraGridDataCJBase15_2);
- }
- else if (ultraTabControl4.SelectedTab.Index == 3)
- {
- SingleAuditCheckConsignDetail(publicUltraGridDataCJBase16_2);
- }
- //else if (ultraTabControl4.SelectedTab.Index == 4)
- //{
- // SingleAuditCheckConsignDetail(publicUltraGridDataCJBase17_2);
- //}
- //else if (ultraTabControl4.SelectedTab.Index == 5)
- //{
- // SingleAuditCheckConsignDetail(publicUltraGridDataCJBase18_2);
- //}
- break;
- case "CancelSingleAudit":
- if (ultraTabControl5.SelectedTab.Index == 0)
- {
- CancelSingleAuditCheckConsignDetail(publicUltraGridDataCJBase19_2);
- }
- else if (ultraTabControl5.SelectedTab.Index == 1)
- {
- CancelSingleAuditCheckConsignDetail(publicUltraGridDataCJBase20_2);
- }
- else if (ultraTabControl5.SelectedTab.Index == 2)
- {
- CancelSingleAuditCheckConsignDetail(publicUltraGridDataCJBase21_2);
- }
- else if (ultraTabControl5.SelectedTab.Index == 3)
- {
- CancelSingleAuditCheckConsignDetail(publicUltraGridDataCJBase22_2);
- }
- //else if (ultraTabControl5.SelectedTab.Index == 4)
- //{
- // CancelSingleAuditCheckConsignDetail(publicUltraGridDataCJBase23_2);
- //}
- //else if (ultraTabControl5.SelectedTab.Index == 5)
- //{
- // CancelSingleAuditCheckConsignDetail(publicUltraGridDataCJBase24_2);
- //}
- break;
- case "SaveParm":
- SaveParm();
- break;
- case "DoPrint":
- doPrint();
- break;
- case "Close":
- if (MessageUtil.ShowYesNoAndQuestion("是否确认关闭页面?") == DialogResult.Yes)
- {
- this.Close();
- }
- break;
- }
- }
- #region 公共方法
- //打印
- /// <summary>
- /// 打印
- /// </summary>
- private void doPrint()
- {
- getugr();
- string strurl = "";
- if (PHY_CODE_MAX.Equals("C0018") || PHY_CODE_MAX.Equals("C0035") || PHY_CODE_MAX.Equals("C0065")) //压溃试验、滑脱试验、爆破试验
- {
- strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepOutdecGCBurst.cpt&op=view&CHECK_NO=" + CHECK_NO + "&SAMPLE_NO=" + SAMPLE_NO;
- }
- else if (PHY_CODE_MAX.Equals("C0064")) //上、卸扣试验
- {
- strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepOutdecGCAntigalling.cpt&op=view&CHECK_NO=" + CHECK_NO + "&SAMPLE_NO=" + SAMPLE_NO;
- }
- else if (PHY_CODE_MAX.Equals("C0036") || PHY_CODE_MAX.Equals("C0037") || PHY_CODE_MAX.Equals("C0066")) //抗内压强度、复合力试验
- {
- strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepOutdecGCCombinedStress.cpt&op=view&CHECK_NO=" + CHECK_NO + "&SAMPLE_NO=" + SAMPLE_NO;
- }
-
- FrmExcel fre = new FrmExcel(this.ob, strurl);
- fre.AutoSize = true;
- fre.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height);
- fre.WindowState = FormWindowState.Maximized;
- fre.Show();
- }
- /// <summary>
- /// 设备信息赋值给实体类
- /// </summary>
- /// <param name="sampleNo"></param>
- /// <param name="checkNo"></param>
- /// <param name="phyCodeMax"></param>
- /// <returns></returns>
- private OutdecCheckconsignDetailEntity getCheckDetal(string checkNo, string sampleNo, string phyCodeMax)
- {
- //设备信息
- ArrayList listDetail = new ArrayList();
- listDetail.Add(sampleNo);
- listDetail.Add(checkNo);
- listDetail.Add(phyCodeMax);
- DataTable dtDetail = PublicServer.GetData("com.steering.lims.data.outdec.FrmOutdecChemDataManage.QueryChemCheckConsignDetail",
- new Object[] { listDetail }, ob);
- OutdecCheckconsignDetailEntity checkDetal = new OutdecCheckconsignDetailEntity();
- if (dtDetail.Rows.Count > 0)
- {
- checkDetal.CheckName = dtDetail.Rows[0]["CHECK_NAME"].ToString();
- checkDetal.CheckTime = dtDetail.Rows[0]["CHECK_TIME"].ToString();
- checkDetal.CheckShift = dtDetail.Rows[0]["CHECK_SHIFT"].ToString();
- checkDetal.CheckClass = dtDetail.Rows[0]["CHECK_CLASS"].ToString();
- checkDetal.DeviceNo = dtDetail.Rows[0]["DEVICE_NO"].ToString();
- checkDetal.DeviceName = dtDetail.Rows[0]["DEVICE_NAME"].ToString();
- checkDetal.CheckTemp = dtDetail.Rows[0]["CHECK_TEMP"].ToString();
- checkDetal.Remark = dtDetail.Rows[0]["REMARK"].ToString();
- checkDetal.AuditName = dtDetail.Rows[0]["AUDIT_NAME"].ToString();
- checkDetal.AuditTime = dtDetail.Rows[0]["AUDIT_TIME"].ToString();
- }
- return checkDetal;
- }
- /// <summary>
- /// 获取激活行UltraGridRow信息
- /// </summary>
- /// <returns></returns>
- private UltraGridRow getugr()
- {
- UltraGridRow ugr = null;
- if (ultraTabControl1.SelectedTab.Index == 0)
- {
- if (ultraTabControl2.SelectedTab.Index == 0)
- {
- ugr = publicUltraGridDataCJBase1_2.Ug.ActiveRow;
- }
- else if (ultraTabControl2.SelectedTab.Index == 1)
- {
- ugr = publicUltraGridDataCJBase2_2.Ug.ActiveRow;
- }
- else if (ultraTabControl2.SelectedTab.Index == 2)
- {
- ugr = publicUltraGridDataCJBase3_2.Ug.ActiveRow;
- }
- else if (ultraTabControl2.SelectedTab.Index == 3)
- {
- ugr = publicUltraGridDataCJBase4_2.Ug.ActiveRow;
- }
- //ugr = publicUltraGridDetail1.Ug.ActiveRow;
- }
- else if (ultraTabControl1.SelectedTab.Index == 1)
- {
- //ugr = publicUltraGridDetail2.Ug.ActiveRow;
- if (ultraTabControl3.SelectedTab.Index == 0)
- {
- ugr = publicUltraGridDataCJBase7_2.Ug.ActiveRow;
- }
- else if (ultraTabControl3.SelectedTab.Index == 1)
- {
- ugr = publicUltraGridDataCJBase8_2.Ug.ActiveRow;
- }
- else if (ultraTabControl3.SelectedTab.Index == 2)
- {
- ugr = publicUltraGridDataCJBase9_2.Ug.ActiveRow;
- }
- else if (ultraTabControl3.SelectedTab.Index == 3)
- {
- ugr = publicUltraGridDataCJBase10_2.Ug.ActiveRow;
- }
- }
- else if (ultraTabControl1.SelectedTab.Index == 2)
- {
- //ugr = publicUltraGridDetail3.Ug.ActiveRow;
- if (ultraTabControl4.SelectedTab.Index == 0)
- {
- ugr = publicUltraGridDataCJBase13_2.Ug.ActiveRow;
- }
- else if (ultraTabControl4.SelectedTab.Index == 1)
- {
- ugr = publicUltraGridDataCJBase14_2.Ug.ActiveRow;
- }
- else if (ultraTabControl4.SelectedTab.Index == 2)
- {
- ugr = publicUltraGridDataCJBase15_2.Ug.ActiveRow;
- }
- else if (ultraTabControl4.SelectedTab.Index == 3)
- {
- ugr = publicUltraGridDataCJBase16_2.Ug.ActiveRow;
- }
- }
- else if (ultraTabControl1.SelectedTab.Index == 3)
- {
- //ugr = publicUltraGridDetail4.Ug.ActiveRow;
- if (ultraTabControl5.SelectedTab.Index == 0)
- {
- ugr = publicUltraGridDataCJBase19_2.Ug.ActiveRow;
- }
- else if (ultraTabControl5.SelectedTab.Index == 1)
- {
- ugr = publicUltraGridDataCJBase20_2.Ug.ActiveRow;
- }
- else if (ultraTabControl5.SelectedTab.Index == 2)
- {
- ugr = publicUltraGridDataCJBase21_2.Ug.ActiveRow;
- }
- else if (ultraTabControl5.SelectedTab.Index == 3)
- {
- ugr = publicUltraGridDataCJBase22_2.Ug.ActiveRow;
- }
- }
- if (ugr != null)
- {
- CHECK_NO = ugr.Cells["CHECK_NO"].Value.ToString();
- SAMPLE_NO = ugr.Cells["SAMPLE_NO"].Value.ToString();
- PHY_CODE_MAX = ugr.Cells["PHY_CODE_MAX"].Value.ToString();
- }
- else
- {
- CHECK_NO = "";
- SAMPLE_NO = "";
- PHY_CODE_MAX = "";
- }
- return ugr;
- }
- /// <summary>
- /// 试验条件
- /// </summary>
- private void SaveParm()
- {
- getugr();
- FrmOutdecLabEngDataParm labDateParm = new FrmOutdecLabEngDataParm(CHECK_NO, SAMPLE_NO, PHY_CODE_MAX, this.ob);
- labDateParm.ShowDialog();
- }
- //颜色改变
- /// <summary>
- /// 颜色改变
- /// </summary>
- /// <param name="dtPhyMax"></param>
- /// <param name="ultraTabControl"></param>
- private void ChangeColor(DataTable dtPhyMax, Infragistics.Win.UltraWinTabControl.UltraTabControl ultraTabControl)
- {
- if (dtPhyMax == null || dtPhyMax.Rows.Count == 0) return;
- int i = -1;
- if (PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN IN ('R0019', 'R0021', 'R0047')") != null && PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN IN ('R0019', 'R0021', 'R0047')").Rows.Count > 0)
- {
- i = i == -1 ? i = 0 : i;
- ultraTabControl.Tabs[0].Appearance.BackColor = Color.GreenYellow;
- }
- if (PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN IN ('R0020', 'R0048')") != null && PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN IN ('R0020', 'R0048')").Rows.Count > 0)
- {
- i = i == -1 ? i = 1 : i;
- ultraTabControl.Tabs[1].Appearance.BackColor = Color.GreenYellow;
- }
- if (PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN = 'R0046'") != null && PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN = 'R0046'").Rows.Count > 0)
- {
- i = i == -1 ? i = 2 : i;
- ultraTabControl.Tabs[2].Appearance.BackColor = Color.GreenYellow;//
- }
- if (PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN NOT IN ('R0019', 'R0020', 'R0021', 'R0046', 'R0047', 'R0048')") != null && PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN NOT IN ('R0019', 'R0020', 'R0021', 'R0046', 'R0047', 'R0048')").Rows.Count > 0)
- {
- i = i == -1 ? i = 3 : i;
- ultraTabControl.Tabs[3].Appearance.BackColor = Color.GreenYellow;//其他
- }
- //if (PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN IN ('R0010')") != null && PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN IN ('R0010')").Rows.Count > 0)
- //{
- // i = i == -1 ? i = 4 : i;
- // ultraTabControl.Tabs[4].Appearance.BackColor = Color.GreenYellow;//工艺
- //}
- //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)
- //{
- // i = i == -1 ? i = 5 : i;
- // ultraTabControl.Tabs[5].Appearance.BackColor = Color.GreenYellow;//其他
- //}
- ultraTabControl.SelectedTab = i == -1 ? ultraTabControl.Tabs[0] : ultraTabControl.Tabs[i];
- }
- //清空颜色、数据
- /// <summary>
- /// 清空颜色、数据
- /// </summary>
- /// <param name="ultraTabControl"></param>
- private void ClearPhyDetailItems(Infragistics.Win.UltraWinTabControl.UltraTabControl ultraTabControl)
- {
- //ultraTabControl.SelectedTab = ultraTabControl.Tabs[0];
- ultraTabControl.Tabs[0].Appearance.BackColor = Control.DefaultBackColor;
- ultraTabControl.Tabs[1].Appearance.BackColor = Control.DefaultBackColor;
- ultraTabControl.Tabs[2].Appearance.BackColor = Control.DefaultBackColor;
- ultraTabControl.Tabs[3].Appearance.BackColor = Control.DefaultBackColor;
- //ultraTabControl.Tabs[4].Appearance.BackColor = Control.DefaultBackColor;
- //ultraTabControl.Tabs[5].Appearance.BackColor = Control.DefaultBackColor;
- if (ultraTabControl == ultraTabControl2)
- {
- publicUltraGridDataCJBase1_1.DataTable.Rows.Clear();
- publicUltraGridDataCJBase2_1.DataTable.Rows.Clear();
- publicUltraGridDataCJBase3_1.DataTable.Rows.Clear();
- publicUltraGridDataCJBase4_1.DataTable.Rows.Clear();
- //publicUltraGridDataCJBase5_1.DataTable.Rows.Clear();
- //publicUltraGridDataCJBase6_1.DataTable.Rows.Clear();
- publicUltraGridDataCJBase1_2.DataTable.Rows.Clear();
- publicUltraGridDataCJBase2_2.DataTable.Rows.Clear();
- publicUltraGridDataCJBase3_2.DataTable.Rows.Clear();
- publicUltraGridDataCJBase4_2.DataTable.Rows.Clear();
- //publicUltraGridDataCJBase5_2.DataTable.Rows.Clear();
- //publicUltraGridDataCJBase6_2.DataTable.Rows.Clear();
- splitContainer1.Panel1Collapsed = true;
- splitContainer2.Panel1Collapsed = true;
- splitContainer3.Panel1Collapsed = true;
- splitContainer4.Panel1Collapsed = true;
- //splitContainer5.Panel1Collapsed = true;
- //splitContainer6.Panel1Collapsed = true;
- }
- else if (ultraTabControl == ultraTabControl3)
- {
- publicUltraGridDataCJBase7_1.DataTable.Rows.Clear();
- publicUltraGridDataCJBase8_1.DataTable.Rows.Clear();
- publicUltraGridDataCJBase9_1.DataTable.Rows.Clear();
- publicUltraGridDataCJBase10_1.DataTable.Rows.Clear();
- //publicUltraGridDataCJBase11_1.DataTable.Rows.Clear();
- //publicUltraGridDataCJBase12_1.DataTable.Rows.Clear();
- publicUltraGridDataCJBase7_2.DataTable.Rows.Clear();
- publicUltraGridDataCJBase8_2.DataTable.Rows.Clear();
- publicUltraGridDataCJBase9_2.DataTable.Rows.Clear();
- publicUltraGridDataCJBase10_2.DataTable.Rows.Clear();
- //publicUltraGridDataCJBase11_2.DataTable.Rows.Clear();
- //publicUltraGridDataCJBase12_2.DataTable.Rows.Clear();
- splitContainer7.Panel1Collapsed = true;
- splitContainer8.Panel1Collapsed = true;
- splitContainer9.Panel1Collapsed = true;
- splitContainer10.Panel1Collapsed = true;
- //splitContainer11.Panel1Collapsed = true;
- //splitContainer12.Panel1Collapsed = true;
- }
- else if (ultraTabControl == ultraTabControl4)
- {
- publicUltraGridDataCJBase13_1.DataTable.Rows.Clear();
- publicUltraGridDataCJBase14_1.DataTable.Rows.Clear();
- publicUltraGridDataCJBase15_1.DataTable.Rows.Clear();
- publicUltraGridDataCJBase16_1.DataTable.Rows.Clear();
- //publicUltraGridDataCJBase17_1.DataTable.Rows.Clear();
- //publicUltraGridDataCJBase18_1.DataTable.Rows.Clear();
- publicUltraGridDataCJBase13_2.DataTable.Rows.Clear();
- publicUltraGridDataCJBase14_2.DataTable.Rows.Clear();
- publicUltraGridDataCJBase15_2.DataTable.Rows.Clear();
- publicUltraGridDataCJBase16_2.DataTable.Rows.Clear();
- //publicUltraGridDataCJBase17_2.DataTable.Rows.Clear();
- //publicUltraGridDataCJBase18_2.DataTable.Rows.Clear();
- splitContainer13.Panel1Collapsed = true;
- splitContainer14.Panel1Collapsed = true;
- splitContainer15.Panel1Collapsed = true;
- splitContainer16.Panel1Collapsed = true;
- //splitContainer17.Panel1Collapsed = true;
- //splitContainer18.Panel1Collapsed = true;
- }
- else if (ultraTabControl == ultraTabControl5)
- {
- publicUltraGridDataCJBase19_1.DataTable.Rows.Clear();
- publicUltraGridDataCJBase20_1.DataTable.Rows.Clear();
- publicUltraGridDataCJBase21_1.DataTable.Rows.Clear();
- publicUltraGridDataCJBase22_1.DataTable.Rows.Clear();
- //publicUltraGridDataCJBase23_1.DataTable.Rows.Clear();
- //publicUltraGridDataCJBase24_1.DataTable.Rows.Clear();
- publicUltraGridDataCJBase19_2.DataTable.Rows.Clear();
- publicUltraGridDataCJBase20_2.DataTable.Rows.Clear();
- publicUltraGridDataCJBase21_2.DataTable.Rows.Clear();
- publicUltraGridDataCJBase22_2.DataTable.Rows.Clear();
- //publicUltraGridDataCJBase23_2.DataTable.Rows.Clear();
- //publicUltraGridDataCJBase24_2.DataTable.Rows.Clear();
- splitContainer19.Panel1Collapsed = true;
- splitContainer20.Panel1Collapsed = true;
- splitContainer21.Panel1Collapsed = true;
- splitContainer22.Panel1Collapsed = true;
- //splitContainer23.Panel1Collapsed = true;
- //splitContainer24.Panel1Collapsed = true;
- }
- }
- #endregion
- #region 录入区域
- //查询检验委托基本信息
- /// <summary>
- /// 查询检验委托基本信息
- /// </summary>
- /// <param name="publicUltraGridBase"></param>
- /// <param name="strFlag"></param>
- private void QueryCheckConsignBaseDetail_Distinct(PublicUltraGridBase publicUltraGridBase, string strFlag)
- {
- try
- {
- //各试验室各检验项目设置权限
- publicUltraGridBase.QueryCheckConsignBaseDetail_Distinct("outdec.PublicOutdecBase", outdecQueryBase1.GetQueryInfo(strFlag), this.ob, arrId, plineCodes);
- if (publicUltraGridBase.Ug.Rows.Count == 0)
- {
- if (publicUltraGridBase == publicUltraGridBase1)
- {
- ClearPhyDetailItems(ultraTabControl2);
- }
- else if (publicUltraGridBase == publicUltraGridBase2)
- {
- ClearPhyDetailItems(ultraTabControl3);
- }
- }
- }
- catch (Exception e)
- {
- MessageUtil.ShowWarning(e.Message);
- }
- }
- //查询试验方法项目信息
- /// <summary>
- /// 查询试验方法项目信息
- /// </summary>
- /// <param name="publicUltraGridDataCJBase"></param>
- /// <param name="dtHide"></param>
- /// <param name="splitContainer"></param>
- /// <param name="dt"></param>
- private void QueryCheckMethodPhyConfigItems(PublicUltraGridDataCJBase publicUltraGridDataCJBase, DataTable dtHide, SplitContainer splitContainer, DataTable dt)
- {
- try
- {
- PublicPipeAndOutdec.ChangeSplit(splitContainer, dt);
- publicUltraGridDataCJBase.HideNullColumn(dtHide, publicUltraGridDataCJBase.Ug);
- publicUltraGridDataCJBase.QueryCheckMethodPhyConfigItems(dt);
- //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
- }
- catch (Exception e)
- {
- MessageUtil.ShowError(e.Message);
- }
- }
- #endregion
- #region 未录入
- void pipeUltraGridBase1_PublicUltraGridBaseActive(object sender, EventArgs e)
- {
- try
- {
- outdecShowBase1.ShowBaseInfo(publicUltraGridBase1.Ur);
- //赋值给全局变量
- UltraGridRow ur = publicUltraGridBase1.Ur;
- ArrayList arrayList = new ArrayList();
- arrayList.Add("2");
- arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());//20160523
- arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
- arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
- arrayList.Add(ur.Cells["CHECK_NO"].Text.Trim());
- if (arrId != null && arrId.Length > 0)
- {
- ClearPhyDetailItems(ultraTabControl2);
- //查询检验项目明细
- DataTable dt = PublicServer.GetData("com.steering.lims.data.outdec.FrmOutdecDataCJBase.QueryCheckConsignDetailPhyDetail", new Object[] { arrayList, arrId }, ob);
- if (dt == null || dt.Rows.Count == 0)
- {
- m_dtPhyMax = null;
- m_dtPhyItems = null;
- return;
- }
- m_dtPhyMax = dt.Copy();
- DataTable dtItems = PublicServer.GetData("com.steering.lims.data.outdec.FrmOutdecDataCJBase.QueryCheckMethodPhyConfigItems",
- new Object[] { arrayList, arrId }, ob);
- if (dtItems == null || dtItems.Rows.Count == 0)
- {
- m_dtPhyItems = null;
- //return;
- }
- else
- {
- m_dtPhyItems = dtItems.Copy();
- }
- ChangeColor(m_dtPhyMax, ultraTabControl2);
- AddPhyDetailItems();
- //ArrayList list = new ArrayList();
- //list.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
- //list.Add(ur.Cells["CHECK_NO"].Text.Trim());
- //list.Add(ur.Cells["DEPT_ID"].Text.Trim());
- //publicUltraGridDetail1.QueryCheckConsignDetailFilePath("outdec.PublicOutdecBase", list, this.ob);
- }
- }
- catch (Exception ex)
- {
- MessageUtil.ShowWarning(ex.Message);
- }
- }
- private void ultraTabControl2_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
- {
- //if (m_dtPhyMax == null || m_dtPhyMax.Rows.Count == 0) return;
- if (toolMenu == null) return;
- AddPhyDetailItems();
- //设备信息
- getugr();
- publicDataCJBase1.ClearAll();
- if (CHECK_NO != "")
- { publicDataCJBase1.UpdateDateForPrama(getCheckDetal(CHECK_NO, SAMPLE_NO, PHY_CODE_MAX)); }
- }
- //未录入赋值
- /// <summary>
- /// 未录入赋值
- /// </summary>
- private void AddPhyDetailItems()
- {
- if (m_dtPhyMax == null || m_dtPhyMax.Rows.Count == 0) return;
- //R0019 抗挤毁强度,R0020 抗内压强度,R0021 连接强度,R0046 上卸扣试验,R0047 爆破,R0048 复合力试验,R0049 摩擦磨损试验
- if (ultraTabControl2.SelectedTab.Index == 0)//压溃(抗挤毁强度),爆破,整管拉伸、滑脱(连接强度)
- {
- publicUltraGridDataCJBase1_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN IN ('R0019', 'R0021', 'R0047')"));
- publicUltraGridDataCJBase1_2.DataTable.AcceptChanges();
- QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase1_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN IN ('R0019', 'R0021', 'R0047')"), splitContainer1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItems, "PHY_CODE_MIN IN ('R0019', 'R0021', 'R0047')"));
- }
- else if (ultraTabControl2.SelectedTab.Index == 1)//复合力,密封、静水压(抗内压强度)
- {
- publicUltraGridDataCJBase2_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN IN ('R0020', 'R0048')"));
- publicUltraGridDataCJBase2_2.DataTable.AcceptChanges();
- QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase2_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN IN ('R0020', 'R0048')"), splitContainer2, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItems, "PHY_CODE_MIN IN ('R0020', 'R0048')"));
- }
- else if (ultraTabControl2.SelectedTab.Index == 2)//上卸扣试验 R0046
- {
- publicUltraGridDataCJBase3_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN = 'R0046'"));
- publicUltraGridDataCJBase3_2.DataTable.AcceptChanges();
- QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase3_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN = 'R0046'"), splitContainer3, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItems, "PHY_CODE_MIN = 'R0046'"));
- }
- else if (ultraTabControl2.SelectedTab.Index == 3)//其他
- {
- publicUltraGridDataCJBase4_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN NOT IN ('R0019', 'R0020', 'R0021', 'R0046', 'R0047', 'R0048')"));
- publicUltraGridDataCJBase4_2.DataTable.AcceptChanges();
- QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase4_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN NOT IN ('R0019', 'R0020', 'R0021', 'R0046', 'R0047', 'R0048')"), splitContainer4, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItems, "PHY_CODE_MIN NOT IN ('R0019', 'R0020', 'R0021', 'R0046', 'R0047', 'R0048')"));
- }
- //else if (ultraTabControl2.SelectedTab.Index == 4)//
- //{
- // publicUltraGridDataCJBase5_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN IN ('R0010')"));//
- // publicUltraGridDataCJBase5_2.DataTable.AcceptChanges();
- // QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase5_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN IN ('R0010')"), splitContainer5, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItems, "PHY_CODE_MIN IN ('R0010')"));
- //}
- //else if (ultraTabControl2.SelectedTab.Index == 5)//其他
- //{
- // publicUltraGridDataCJBase6_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN NOT IN ('R0001', 'R0002','R0003','R0004','R0005','R0010','R0012','R0013')"));
- // publicUltraGridDataCJBase6_2.DataTable.AcceptChanges();
- // 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')"));
- //}
- tabIndex = ultraTabControl2.SelectedTab.Index;
- }
- //新增检验委托过程结果JHYGG_PHYLX_PROCESS_RESULT,新增之前先删除表里数据
- /// <summary>
- /// 新增检验委托过程结果JHYGG_PHYLX_PROCESS_RESULT,新增之前先删除表里数据
- /// </summary>
- /// <param name="publicUltraGridDataCJBase"></param>
- /// <param name="publicUltraGridDataCJBaseItems"></param>
- private void AddCheckConsignProcessResult(PublicUltraGridDataCJBase publicUltraGridDataCJBase, PublicUltraGridDataCJBase publicUltraGridDataCJBaseItems)
- {
- try
- {
- if (ultraTabControl1.SelectedTab.Index != 0)
- {
- MessageUtil.ShowWarning("只有在未录入数据页才能进行新增操作!");
- return;
- }
- if (publicUltraGridBase1.Ur == null || publicUltraGridBase1.Ur.Activated == false)
- {
- MessageUtil.ShowWarning("请选择需要新增的试样信息!");
- return;
- }
- if (publicUltraGridDataCJBase.DataTable == null || publicUltraGridDataCJBase.DataTable.Rows.Count == 0)
- {
- return;
- }
- //bool isNullValue = true;
- publicUltraGridDataCJBase.Ug.UpdateData();
- foreach (DataRow dr in publicUltraGridDataCJBase.DataTable.Rows)
- {
- 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() == "")
- {
- MessageUtil.ShowWarning(dr["PHY_NAME"] + "没有录入任何数据不允许新增!");
- return;
- }
- }
- if (MessageUtil.ShowYesNoAndQuestion("是否确认新增?") == DialogResult.Yes)
- {
- string strCHECK_NO = publicUltraGridBase1.Ur.Cells["CHECK_NO"].Text.Trim();
- string strSAMPLE_NO = publicUltraGridBase1.Ur.Cells["SAMPLE_NO"].Text.Trim();//定位
- ArrayList alAll = new ArrayList();
- ArrayList alPhyItems = new ArrayList();//删除信息详细表list
- ArrayList alDetail = new ArrayList();//检验信息详细表list
- ArrayList alProcessResult = new ArrayList();//化学信息list
- ArrayList alPhyItemsParams = new ArrayList();
- ArrayList alDetailParams = new ArrayList();//检验信息详细表参数list
- ArrayList alProcessResultParams = new ArrayList();//化学信息参数list
- string strTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
- //获取修改明细表参数JHYGG_CHECKCONSIGN_DETAIL
- string row = "";
- foreach (DataRow dr in publicUltraGridDataCJBase.DataTable.Rows)
- {
- if (row.IndexOf(dr["PHY_CODE_MAX"].ToString()) < 0)
- {
- row += dr["PHY_CODE_MAX"].ToString() + " ";
- alDetailParams = new ArrayList();
- alDetailParams.Add(publicDataCJBase1.StrTemp);//温度
- alDetailParams.Add(publicDataCJBase1.StrDevice_No);//设备编码
- alDetailParams.Add(publicDataCJBase1.StrDevice_Name);//设备名称
- alDetailParams.Add(publicDataCJBase1.StrRemark);//备注
- alDetailParams.Add(publicDataCJBase1.StrShift == "" ? UserInfo.GetUserOrderText() : publicDataCJBase1.StrShift);
- alDetailParams.Add(publicDataCJBase1.StrClass == "" ? UserInfo.GetUserGroupText() : publicDataCJBase1.StrClass);//班组
- alDetailParams.Add(publicDataCJBase1.StrName == "" ? UserInfo.GetUserName() : publicDataCJBase1.StrName);//录入人
- alDetailParams.Add(publicDataCJBase1.StrTime == "" ? strTime : publicDataCJBase1.StrTime);//录入时间
- alDetailParams.Add("3");//录入标志位
- alDetailParams.Add("2");
- alDetailParams.Add(dr["PHY_CODE_MAX"].ToString());
- alDetailParams.Add(strSAMPLE_NO);
- alDetailParams.Add(strCHECK_NO);
- alDetail.Add(alDetailParams);
- }
- }
- publicUltraGridDataCJBase.Ug.UpdateData();
- foreach (DataRow dr in publicUltraGridDataCJBase.DataTable.Rows)
- {
- alProcessResultParams = new ArrayList();
- alProcessResultParams.Add(dr["VALUE1"].ToString());
- alProcessResultParams.Add(dr["VALUE2"].ToString());
- alProcessResultParams.Add(dr["VALUE3"].ToString());
- alProcessResultParams.Add(dr["VALUE4"].ToString());
- alProcessResultParams.Add(dr["VALUE5"].ToString());
- alProcessResultParams.Add(dr["VALUE6"].ToString());
- alProcessResultParams.Add(dr["VALUE7"].ToString());
- alProcessResultParams.Add(dr["VALUE8"].ToString());
- alProcessResultParams.Add(dr["VALUE9"].ToString());
- alProcessResultParams.Add(dr["VALUE10"].ToString());
- alProcessResultParams.Add(dr["VALUE11"].ToString());
- alProcessResultParams.Add(dr["VALUE12"].ToString());
- alProcessResultParams.Add(dr["VALUE13"].ToString());
- alProcessResultParams.Add(dr["VALUE14"].ToString());
- alProcessResultParams.Add(dr["VALUE15"].ToString());
- alProcessResultParams.Add(dr["AVERAGE"].ToString());
- alProcessResultParams.Add(dr["PHYDETAIL_ID"].ToString());
- alProcessResult.Add(alProcessResultParams);
- //alDeleteParams = new ArrayList();
- //alDeleteParams.Add(dr["PHYDETAIL_ID"].ToString());
- //alDelete.Add(alDeleteParams);
- }
- if (publicUltraGridDataCJBaseItems.DataTable != null)
- {
- publicUltraGridDataCJBaseItems.Ug.UpdateData();
- foreach (DataRow dr in publicUltraGridDataCJBaseItems.DataTable.Rows)
- {
- alPhyItemsParams = new ArrayList();
- alPhyItemsParams.Add(strCHECK_NO);
- alPhyItemsParams.Add(strSAMPLE_NO);
- alPhyItemsParams.Add(dr["CHECK_METHOD_NO"].ToString());
- alPhyItemsParams.Add(dr["CHECK_METHOD_NAME"].ToString());
- alPhyItemsParams.Add(dr["CHECK_METHOD_ITEMNAME"].ToString());
- alPhyItemsParams.Add(dr["VALUE1"].ToString());
- alPhyItemsParams.Add(dr["VALUE2"].ToString());
- alPhyItemsParams.Add(dr["VALUE3"].ToString());
- alPhyItemsParams.Add(dr["VALUE4"].ToString());
- alPhyItemsParams.Add(dr["VALUE5"].ToString());
- alPhyItemsParams.Add(dr["VALUE6"].ToString());
- alPhyItemsParams.Add(dr["VALUE7"].ToString());
- alPhyItemsParams.Add(dr["VALUE8"].ToString());
- alPhyItemsParams.Add(dr["VALUE9"].ToString());
- alPhyItemsParams.Add(dr["VALUE10"].ToString());
- alPhyItemsParams.Add(dr["VALUE11"].ToString());
- alPhyItemsParams.Add(dr["VALUE12"].ToString());
- alPhyItemsParams.Add(dr["VALUE13"].ToString());
- alPhyItemsParams.Add(dr["VALUE14"].ToString());
- alPhyItemsParams.Add(dr["VALUE15"].ToString());
- alPhyItemsParams.Add("");
- alPhyItems.Add(alPhyItemsParams);
- }
- }
- alAll.Add(alDetail);
- alAll.Add(alProcessResult);
- if (alPhyItems.Count > 0)
- {
- alAll.Add(alPhyItems);
- }
- PublicServer.SetData("com.steering.lims.data.outdec.FrmOutdecDataCJBase.AddCheckConsignProcessResult",
- new Object[] { alAll }, this.ob);
- QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase1, "2");
- QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase2, "3456");
- PublicPipeAndOutdec.ActiveOperateRow(publicUltraGridBase1.Ug, new string[] { "CHECK_NO", "SAMPLE_NO" }, new string[] { strCHECK_NO, strSAMPLE_NO });
- PublicPipeAndOutdec.ActiveOperateRow(publicUltraGridBase2.Ug, new string[] { "CHECK_NO", "SAMPLE_NO" }, new string[] { strCHECK_NO, strSAMPLE_NO });
- publicDataCJBase1.StrRemark = "";
- MessageUtil.ShowTips("新增成功!");
- }
- }
- catch (Exception e)
- {
- MessageUtil.ShowWarning(e.Message);
- }
- }
- private void ultraTabControl2_SelectedTabChanging(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangingEventArgs e)
- {
- int cnt = 0;
- if (tabIndex == 0)
- {
- publicUltraGridDataCJBase1_2.Ug.UpdateData();
- cnt = publicUltraGridDataCJBase1_2.DataTable.Rows.Cast<DataRow>().Where(
- a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
- }
- else if (tabIndex == 1)
- {
- publicUltraGridDataCJBase2_2.Ug.UpdateData();
- cnt = publicUltraGridDataCJBase2_2.DataTable.Rows.Cast<DataRow>().Where(
- a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
- }
- else if (tabIndex == 2)
- {
- publicUltraGridDataCJBase3_2.Ug.UpdateData();
- cnt = publicUltraGridDataCJBase3_2.DataTable.Rows.Cast<DataRow>().Where(
- a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
- }
- else if (tabIndex == 3)
- {
- publicUltraGridDataCJBase4_2.Ug.UpdateData();
- cnt = publicUltraGridDataCJBase4_2.DataTable.Rows.Cast<DataRow>().Where(
- a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
- }
- //else if (tabIndex == 4)
- //{
- // publicUltraGridDataCJBase5_2.Ug.UpdateData();
- // cnt = publicUltraGridDataCJBase5_2.DataTable.Rows.Cast<DataRow>().Where(
- // a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
- //}
- //else if (tabIndex == 5)
- //{
- // publicUltraGridDataCJBase6_2.Ug.UpdateData();
- // cnt = publicUltraGridDataCJBase6_2.DataTable.Rows.Cast<DataRow>().Where(
- // a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
- //}
- if (cnt > 0)
- {
- if (MessageUtil.ShowYesNoAndQuestion("数据有变更您确定要放弃吗?") == System.Windows.Forms.DialogResult.No)
- {
- e.Cancel = true;
- }
- }
- }
- #endregion
- #region 已录入
- private void ultraTabControl3_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
- {
- //if (m_dtPhyMax == null || m_dtPhyMax.Rows.Count == 0) return;
- if (toolMenu == null) return;
- AddPhyDetailItems_Log();
- //设备信息
- getugr();
- publicDataCJBase2.ClearAll();
- if (CHECK_NO != "")
- { publicDataCJBase2.UpdateDateForPrama(getCheckDetal(CHECK_NO, SAMPLE_NO, PHY_CODE_MAX)); }
- }
- void pipeUltraGridBase2_PublicUltraGridBaseActive(object sender, EventArgs e)
- {
- try
- {
- outdecShowBase2.ShowBaseInfo(publicUltraGridBase2.Ur);
- //赋值给全局变量
- UltraGridRow ur = publicUltraGridBase2.Ur;
- ArrayList arrayList = new ArrayList();
- arrayList.Add("345");
- arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());//20160523
- arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
- arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
- arrayList.Add(ur.Cells["CHECK_NO"].Text.Trim());
- if (arrId != null && arrId.Length > 0)
- {
- ClearPhyDetailItems(ultraTabControl3);
- //查询检验项目明细
- DataTable dt = PublicServer.GetData("com.steering.lims.data.outdec.FrmOutdecDataCJBase.QueryCheckConsignDetailPhyDetail", new Object[] { arrayList, arrId }, ob);
- if (dt == null || dt.Rows.Count == 0)
- {
- m_dtPhyMaxAdd = null;
- m_dtPhyItemsAdd = null;
- return;
- }
- m_dtPhyMaxAdd = dt.Copy();
- DataTable dtItems = PublicServer.GetData("com.steering.lims.data.outdec.FrmOutdecDataCJBase.QueryCheckMethodResult",
- new Object[] { arrayList, arrId }, ob);
- if (dtItems == null || dtItems.Rows.Count == 0)
- {
- m_dtPhyItemsAdd = null;
- //return;
- }
- else
- {
- m_dtPhyItemsAdd = dtItems.Copy();
- }
- ChangeColor(m_dtPhyMaxAdd, ultraTabControl3);
- AddPhyDetailItems_Log();
- //设备信息
- getugr();
- publicDataCJBase2.ClearAll();
- if (CHECK_NO != "")
- { publicDataCJBase2.UpdateDateForPrama(getCheckDetal(CHECK_NO, SAMPLE_NO, PHY_CODE_MAX)); }
- }
- }
- catch (Exception ex)
- {
- MessageUtil.ShowWarning(ex.Message);
- }
- }
- //已录入赋值
- /// <summary>
- /// 已录入赋值
- /// </summary>
- private void AddPhyDetailItems_Log()
- {
- if (m_dtPhyMaxAdd == null || m_dtPhyMaxAdd.Rows.Count == 0) return;
- //R0019 抗挤毁强度,R0047 爆破,复合力R0048
- if (ultraTabControl3.SelectedTab.Index == 0)
- {
- publicUltraGridDataCJBase7_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN IN ('R0019', 'R0021', 'R0047')"));
- publicUltraGridDataCJBase7_2.DataTable.AcceptChanges();
- QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase7_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN IN ('R0019', 'R0021', 'R0047')"), splitContainer7, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAdd, "PHY_CODE_MIN IN ('R0019', 'R0021', 'R0047')"));
- }
- else if (ultraTabControl3.SelectedTab.Index == 1)
- {
- publicUltraGridDataCJBase8_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN IN ('R0020', 'R0048')"));//
- publicUltraGridDataCJBase8_2.DataTable.AcceptChanges();
- QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase8_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN IN ('R0020', 'R0048')"), splitContainer8, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAdd, "PHY_CODE_MIN IN ('R0020', 'R0048')"));
- }
- else if (ultraTabControl3.SelectedTab.Index == 2)
- {
- publicUltraGridDataCJBase9_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN = 'R0046'"));//
- publicUltraGridDataCJBase9_2.DataTable.AcceptChanges();
- QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase9_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN = 'R0046'"), splitContainer9, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAdd, "PHY_CODE_MIN = 'R0046'"));
- }
- else if (ultraTabControl3.SelectedTab.Index == 3)//其他
- {
- publicUltraGridDataCJBase10_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN NOT IN ('R0019', 'R0020', 'R0021', 'R0046', 'R0047', 'R0048')"));//
- publicUltraGridDataCJBase10_2.DataTable.AcceptChanges();
- QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase10_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN NOT IN ('R0019', 'R0020', 'R0021', 'R0046', 'R0047', 'R0048')"), splitContainer10, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAdd, "PHY_CODE_MIN NOT IN ('R0019', 'R0020', 'R0021', 'R0046', 'R0047', 'R0048')"));
- }
- //else if (ultraTabControl3.SelectedTab.Index == 4)//
- //{
- // publicUltraGridDataCJBase11_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN IN ('R0010')"));//工艺
- // publicUltraGridDataCJBase11_2.DataTable.AcceptChanges();
- // QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase11_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN IN ('R0010')"), splitContainer11, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAdd, "PHY_CODE_MIN IN ('R0010')"));
- //}
- //else if (ultraTabControl3.SelectedTab.Index == 5)//其他
- //{
- // publicUltraGridDataCJBase12_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN NOT IN ('R0001', 'R0002','R0003','R0004','R0005','R0010','R0012','R0013')"));
- // publicUltraGridDataCJBase12_2.DataTable.AcceptChanges();
- // 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')"));
- //}
- tabIndex = ultraTabControl3.SelectedTab.Index;
- }
- //修改检验委托过程结果JHYGG_PHYLX_PROCESS_RESULT
- /// <summary>
- /// 修改检验委托过程结果JHYGG_PHYLX_PROCESS_RESULT
- /// </summary>
- /// <param name="publicUltraGridDataCJBase"></param>
- /// <param name="publicUltraGridDataCJBaseItems"></param>
- private void UpdateCheckConsignProcessResult(PublicUltraGridDataCJBase publicUltraGridDataCJBase, PublicUltraGridDataCJBase publicUltraGridDataCJBaseItems)
- {
- try
- {
- if (ultraTabControl1.SelectedTab.Index != 1)
- {
- MessageUtil.ShowTips("只有在已录入数据页才能进行修改操作!");
- return;
- }
- if (publicUltraGridBase2.Ur == null || publicUltraGridBase2.Ur.Activated == false)
- {
- MessageUtil.ShowWarning("请选择需要修改的试样信息!");
- return;
- }
- if (publicUltraGridDataCJBase.OldDt == null || publicUltraGridDataCJBase.OldDt.Rows.Count == 0 || publicUltraGridDataCJBase.DataTable == null || publicUltraGridDataCJBase.DataTable.Rows.Count == 0)
- {
- return;
- }
- //if (publicUltraGridBase2.Ur.Cells["FLAG"].Text == "已审核")
- //{
- // MessageUtil.ShowTips("已审核的数据不允许修改!");
- // return;
- //}
- if (MessageUtil.ShowYesNoAndQuestion("是否确认修改?") == DialogResult.Yes)
- {
- string strCHECK_NO = publicUltraGridBase2.Ur.Cells["CHECK_NO"].Text.Trim();
- string strSAMPLE_NO = publicUltraGridBase2.Ur.Cells["SAMPLE_NO"].Text.Trim();//定位
- ArrayList alAll = new ArrayList();
- ArrayList alProcessResult = new ArrayList();//过程信息list新值
- ArrayList alProcessResultLog = new ArrayList();//过程信息list原值
- ArrayList alDeletePhyItems = new ArrayList();
- ArrayList alPhyItems = new ArrayList();
- ArrayList alProcessResultParams = new ArrayList();//过程信息参数list新值
- ArrayList alProcessResultParamsLog = new ArrayList();//过程信息参数list原值
- ArrayList alDeletePhyItemsParams = new ArrayList();
- ArrayList alPhyItemsParams = new ArrayList();
- string strTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
- //用m_OldDt获取原值
- foreach (DataRow dr in publicUltraGridDataCJBase.OldDt.Rows)
- {
- alProcessResultParamsLog = new ArrayList();
- alProcessResultParamsLog.Add(dr["PHYDETAIL_ID"].ToString());
- alProcessResultParamsLog.Add(dr["VALUE1"].ToString());
- alProcessResultParamsLog.Add(dr["VALUE2"].ToString());
- alProcessResultParamsLog.Add(dr["VALUE3"].ToString());
- alProcessResultParamsLog.Add(dr["VALUE4"].ToString());
- alProcessResultParamsLog.Add(dr["VALUE5"].ToString());
- alProcessResultParamsLog.Add(dr["VALUE6"].ToString());
- alProcessResultParamsLog.Add(dr["VALUE7"].ToString());
- alProcessResultParamsLog.Add(dr["VALUE8"].ToString());
- alProcessResultParamsLog.Add(dr["VALUE9"].ToString());
- alProcessResultParamsLog.Add(dr["VALUE10"].ToString());
- alProcessResultParamsLog.Add(dr["VALUE11"].ToString());
- alProcessResultParamsLog.Add(dr["VALUE12"].ToString());
- alProcessResultParamsLog.Add(dr["VALUE13"].ToString());
- alProcessResultParamsLog.Add(dr["VALUE14"].ToString());
- alProcessResultParamsLog.Add(dr["VALUE15"].ToString());
- alProcessResultParamsLog.Add(UserInfo.GetUserName());//操作人
- alProcessResultParamsLog.Add(strTime);//操作时间
- alProcessResultParamsLog.Add("0");
- //alProcessResultParamsLog.Add(txtOPERATE_REMARK.Text.Trim());//操作备注修改
- alProcessResultLog.Add(alProcessResultParamsLog);//插入到JHYGG_PHYRESULT_LOG数据(过程原值)
- }
- string row = "";
- publicUltraGridDataCJBase.Ug.UpdateData();
- foreach (DataRow dr in publicUltraGridDataCJBase.DataTable.Rows)
- {
- if (row.IndexOf(dr["PHY_CODE_MAX"].ToString()) < 0)
- {
- row += ",'" + dr["PHY_CODE_MAX"].ToString() + "'";
- }
- alProcessResultParams = new ArrayList();
- alProcessResultParams.Add(dr["VALUE1"].ToString());
- alProcessResultParams.Add(dr["VALUE2"].ToString());
- alProcessResultParams.Add(dr["VALUE3"].ToString());
- alProcessResultParams.Add(dr["VALUE4"].ToString());
- alProcessResultParams.Add(dr["VALUE5"].ToString());
- alProcessResultParams.Add(dr["VALUE6"].ToString());
- alProcessResultParams.Add(dr["VALUE7"].ToString());
- alProcessResultParams.Add(dr["VALUE8"].ToString());
- alProcessResultParams.Add(dr["VALUE9"].ToString());
- alProcessResultParams.Add(dr["VALUE10"].ToString());
- alProcessResultParams.Add(dr["VALUE11"].ToString());
- alProcessResultParams.Add(dr["VALUE12"].ToString());
- alProcessResultParams.Add(dr["VALUE13"].ToString());
- alProcessResultParams.Add(dr["VALUE14"].ToString());
- alProcessResultParams.Add(dr["VALUE15"].ToString());
- alProcessResultParams.Add(dr["AVERAGE"].ToString());
- //alProcessResultParams.Add(txtREMARK_LOG.Text.Trim());//试验备注
- alProcessResultParams.Add(dr["PHYDETAIL_ID"].ToString());
- alProcessResult.Add(alProcessResultParams);//新值
- }
- if (publicUltraGridDataCJBaseItems.DataTable != null)
- {
- string strMethod = "";
- publicUltraGridDataCJBaseItems.Ug.UpdateData();
- foreach (DataRow dr in publicUltraGridDataCJBaseItems.DataTable.Rows)
- {
- if (strMethod.IndexOf(dr["CHECK_METHOD_NO"].ToString()) < 0)
- {
- strMethod += dr["CHECK_METHOD_NO"].ToString() + " ";
- alDeletePhyItemsParams = new ArrayList();
- alDeletePhyItemsParams.Add(dr["CHECK_METHOD_NO"].ToString());
- alDeletePhyItemsParams.Add(strSAMPLE_NO);
- alDeletePhyItemsParams.Add(strCHECK_NO);
- alDeletePhyItems.Add(alDeletePhyItemsParams);
- }
- alPhyItemsParams = new ArrayList();
- alPhyItemsParams.Add(strCHECK_NO);
- alPhyItemsParams.Add(strSAMPLE_NO);
- alPhyItemsParams.Add(dr["CHECK_METHOD_NO"].ToString());
- alPhyItemsParams.Add(dr["CHECK_METHOD_NAME"].ToString());
- alPhyItemsParams.Add(dr["CHECK_METHOD_ITEMNAME"].ToString());
- alPhyItemsParams.Add(dr["VALUE1"].ToString());
- alPhyItemsParams.Add(dr["VALUE2"].ToString());
- alPhyItemsParams.Add(dr["VALUE3"].ToString());
- alPhyItemsParams.Add(dr["VALUE4"].ToString());
- alPhyItemsParams.Add(dr["VALUE5"].ToString());
- alPhyItemsParams.Add(dr["VALUE6"].ToString());
- alPhyItemsParams.Add(dr["VALUE7"].ToString());
- alPhyItemsParams.Add(dr["VALUE8"].ToString());
- alPhyItemsParams.Add(dr["VALUE9"].ToString());
- alPhyItemsParams.Add(dr["VALUE10"].ToString());
- alPhyItemsParams.Add(dr["VALUE11"].ToString());
- alPhyItemsParams.Add(dr["VALUE12"].ToString());
- alPhyItemsParams.Add(dr["VALUE13"].ToString());
- alPhyItemsParams.Add(dr["VALUE14"].ToString());
- alPhyItemsParams.Add(dr["VALUE15"].ToString());
- alPhyItemsParams.Add("");
- alPhyItems.Add(alPhyItemsParams);
- }
- }
- alAll.Add(alProcessResultLog);//原值
- alAll.Add(alProcessResult);//新值
- if (alDeletePhyItems.Count > 0)
- {
- alAll.Add(alDeletePhyItems);
- }
- if (alPhyItems.Count > 0)
- {
- alAll.Add(alPhyItems);
- }
- row = row.Remove(0, 1);
- ArrayList al = new ArrayList();
- al.Add(strCHECK_NO);
- al.Add(strSAMPLE_NO);
- al.Add(row);
- PublicServer.SetData("com.steering.lims.data.outdec.FrmOutdecDataCJBase.UpdateCheckConsignProcessResult",
- new Object[] { al, alAll }, this.ob);
- QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase2, "3456");
- //QueryCheckConsignBaseDetail_Distinct("2");
- PublicPipeAndOutdec.ActiveOperateRow(publicUltraGridBase2.Ug, new string[] { "CHECK_NO", "SAMPLE_NO" }, new string[] { strCHECK_NO, strSAMPLE_NO });
- MessageUtil.ShowTips("修改成功!");
- }
- }
- catch (Exception e)
- {
- MessageUtil.ShowWarning(e.Message);
- }
- }
- /// <summary>
- /// 将 试验条件 转ArrayList
- /// </summary>
- /// <param name="publicUltraGridDetail"></param>
- /// <returns></returns>
- private ArrayList getCheckConsignDetailArrayList(PublicUltraGridDetail publicUltraGridDetail)
- {
- ArrayList alAll = new ArrayList();
- ArrayList list = new ArrayList();
- foreach (DataRow dr in publicUltraGridDetail.DataTable.Rows)
- {
- list = new ArrayList();
- // "TECHNICAL_STANDARD", "DEGREASING_METHOD", "NACE_PH", "NACE_PH_S", "NACE_PH_F", "NACE_SOLUTION_S", "NACE_SOLUTION_F", "TEST_TEMP", "SPECIMEN_SIZE1", "SPECIMEN_SIZE2", "SPECIMEN_SIZE3", "TEST_DURATION1", "TEST_DURATION2", "TEST_DURATION3", "PSEUDO_STRESS", "PROOF_RING_NO1", "PROOF_RING_NO2", "PROOF_RING_NO3", "YSMIN1", "YSMIN2", "YSMIN3", "ACTUAL_LOAD1", "ACTUAL_LOAD2", "ACTUAL_LOAD3", "ACTUAL_S_YSMIN1", "ACTUAL_S_YSMIN2", "ACTUAL_S_YSMIN3", "ARM_DISPLACEMENT1", "ARM_DISPLACEMENT2", "ARM_DISPLACEMENT3", "CRACK_LENGTH1", "CRACK_LENGTH2", "CRACK_LENGTH3", "NOTE", "STEP", "LOAD", "PRESSURE_MEDIUM", "INTERNAL_PRESSURE", "DOGLEG_DEGREE", "HOLD TIME", "PIN", "BOX", "COMPOUND_TYPE", "COMPOUND_WEIGHT", "MAKE_UP_TORQUE", "TOTAL_TORQUE", "BREAK_OUT_TORQUE", "OBSERVED_RESULT"
- //
- list.Add(dr["TECHNICAL_STANDARD"].ToString()); //技术标准
- list.Add(dr["DEGREASING_METHOD"].ToString()); //试样脱脂方法
- list.Add(dr["NACE_PH"].ToString()); //通入H2S前NACE-A溶液pH值
- list.Add(dr["NACE_PH_S"].ToString()); //试验开始NACE-A溶液pH值
- list.Add(dr["NACE_PH_F"].ToString()); //试验结束NACE-A溶液pH值
- list.Add(dr["NACE_SOLUTION_S"].ToString()); //试验开始NACE-A溶液H2S浓度
- list.Add(dr["NACE_SOLUTION_F"].ToString()); //试验结束NACE-A溶液H2S浓度
- list.Add(dr["TEST_TEMP"].ToString()); //试验温度
- list.Add(dr["SPECIMEN_SIZE1"].ToString()); //试样尺寸1
- list.Add(dr["SPECIMEN_SIZE2"].ToString()); //试样尺寸2
- list.Add(dr["SPECIMEN_SIZE3"].ToString()); //试样尺寸3
- list.Add(dr["TEST_DURATION1"].ToString()); //试验持续时间1
- list.Add(dr["TEST_DURATION2"].ToString()); //试验持续时间2
- list.Add(dr["TEST_DURATION3"].ToString()); //试验持续时间3
- list.Add(dr["PSEUDO_STRESS"].ToString()); //假定应力
- list.Add(dr["PROOF_RING_NO1"].ToString()); //应力环号1
- list.Add(dr["PROOF_RING_NO2"].ToString()); //应力环号2
- list.Add(dr["PROOF_RING_NO3"].ToString()); //应力环号3
- list.Add(dr["YSMIN1"].ToString()); //名义最小屈服强度1
- list.Add(dr["YSMIN2"].ToString()); //名义最小屈服强度2
- list.Add(dr["YSMIN3"].ToString()); //名义最小屈服强度3
- list.Add(dr["ACTUAL_LOAD1"].ToString()); //实际加载挠度1
- list.Add(dr["ACTUAL_LOAD2"].ToString()); //实际加载挠度2
- list.Add(dr["ACTUAL_LOAD3"].ToString()); //实际加载挠度3
- list.Add(dr["ACTUAL_S_YSMIN1"].ToString()); //实际载荷比率1
- list.Add(dr["ACTUAL_S_YSMIN2"].ToString()); //实际载荷比率2
- list.Add(dr["ACTUAL_S_YSMIN3"].ToString()); //实际载荷比率3
- list.Add(dr["ARM_DISPLACEMENT1"].ToString()); //悬壁位移1
- list.Add(dr["ARM_DISPLACEMENT2"].ToString()); //悬壁位移2
- list.Add(dr["ARM_DISPLACEMENT3"].ToString()); //悬壁位移3
- list.Add(dr["CRACK_LENGTH1"].ToString()); //裂纹长度1
- list.Add(dr["CRACK_LENGTH2"].ToString()); //裂纹长度2
- list.Add(dr["CRACK_LENGTH3"].ToString()); //裂纹长度3
- list.Add(dr["NOTE"].ToString()); //备注
- list.Add(dr["STEP"].ToString()); //步骤
- list.Add(dr["LOAD"].ToString()); //载荷(kips)
- list.Add(dr["PRESSURE_MEDIUM"].ToString()); //压力介质
- list.Add(dr["INTERNAL_PRESSURE"].ToString()); //内压力(MPa)
- list.Add(dr["DOGLEG_DEGREE"].ToString()); //狗腿度(°/100ft)
- list.Add(dr["HOLD_TIME"].ToString()); //保持时间(min)
- list.Add(dr["PIN"].ToString()); //外螺纹端
- list.Add(dr["BOX"].ToString()); //内螺纹端
- list.Add(dr["COMPOUND_TYPE"].ToString()); //螺纹脂类型
- list.Add(dr["COMPOUND_WEIGHT"].ToString()); //螺纹脂用量(g)
- list.Add(dr["MAKE_UP_TORQUE"].ToString()); //上扣要求(ft-lb)
- list.Add(dr["TOTAL_TORQUE"].ToString()); //上扣扭矩
- list.Add(dr["BREAK_OUT_TORQUE"].ToString()); //卸扣扭矩(ft-lb)
- list.Add(dr["OBSERVED_RESULT"].ToString()); //螺纹检查
- list.Add(dr["CHECK_NO"].ToString()); //检验编号
- list.Add(dr["SAMPLE_NO"].ToString()); //试样号
- list.Add(dr["PHY_CODE_MAX"].ToString()); //检验项目大类代码PHY_CODE
- alAll.Add(list);
- }
- return alAll;
- }
- //删除检验委托过程结果JHYGG_PHYLX_PROCESS_RESULT
- /// <summary>
- /// 删除检验委托过程结果JHYGG_PHYLX_PROCESS_RESULT
- /// </summary>
- /// <param name="publicUltraGridDataCJBase"></param>
- /// <param name="publicUltraGridDataCJBaseItems"></param>
- private void DeleteCheckConsignProcessResult(PublicUltraGridDataCJBase publicUltraGridDataCJBase, PublicUltraGridDataCJBase publicUltraGridDataCJBaseItems)
- {
- try
- {
- if (ultraTabControl1.SelectedTab.Index != 1)
- {
- MessageUtil.ShowTips("只有在已录入数据页才能进行删除操作!");
- return;
- }
- if (publicUltraGridBase2.Ur == null || publicUltraGridBase2.Ur.Activated == false)
- {
- MessageUtil.ShowWarning("请选择需要删除的试样信息!");
- return;
- }
- if (publicUltraGridDataCJBase.OldDt == null || publicUltraGridDataCJBase.OldDt.Rows.Count == 0 || publicUltraGridDataCJBase.DataTable == null || publicUltraGridDataCJBase.DataTable.Rows.Count == 0)
- {
- return;
- }
- if (MessageUtil.ShowYesNoAndQuestion("是否确认删除?") == DialogResult.Yes)
- {
- string strCHECK_NO = publicUltraGridBase2.Ur.Cells["CHECK_NO"].Text.Trim();
- string strSAMPLE_NO = publicUltraGridBase2.Ur.Cells["SAMPLE_NO"].Text.Trim();//定位
- ArrayList alAll = new ArrayList();
- ArrayList alDetail = new ArrayList();
- ArrayList alProcessResult = new ArrayList();//过程信息list新值
- ArrayList alProcessResultLog = new ArrayList();//过程信息list原值
- ArrayList alPhyItems = new ArrayList();
- ArrayList alDetailParams = new ArrayList();
- ArrayList alProcessResultParams = new ArrayList();//过程信息参数list新值
- ArrayList alProcessResultParamsLog = new ArrayList();//过程信息参数list原值
- ArrayList alPhyItemsParams = new ArrayList();
- string strTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
- foreach (DataRow dr in publicUltraGridDataCJBase.DataTable.Rows)
- {
- alDetailParams = new ArrayList();
- alDetailParams.Add("");
- alDetailParams.Add("");
- alDetailParams.Add("");
- alDetailParams.Add("");
- alDetailParams.Add("");//班次
- alDetailParams.Add("");//班组
- alDetailParams.Add("");//录入人
- alDetailParams.Add("");//录入时间
- alDetailParams.Add("2");//删除之后回到待录入状态
- alDetailParams.Add("3");
- alDetailParams.Add(dr["PHY_CODE_MAX"].ToString());
- alDetailParams.Add(strSAMPLE_NO);
- alDetailParams.Add(strCHECK_NO);
- alDetail.Add(alDetailParams);
- }
- //用m_OldDt获取原值
- foreach (DataRow dr in publicUltraGridDataCJBase.OldDt.Rows)
- {
- alProcessResultParamsLog = new ArrayList();
- alProcessResultParamsLog.Add(dr["PHYDETAIL_ID"].ToString());
- alProcessResultParamsLog.Add(dr["VALUE1"].ToString());
- alProcessResultParamsLog.Add(dr["VALUE2"].ToString());
- alProcessResultParamsLog.Add(dr["VALUE3"].ToString());
- alProcessResultParamsLog.Add(dr["VALUE4"].ToString());
- alProcessResultParamsLog.Add(dr["VALUE5"].ToString());
- alProcessResultParamsLog.Add(dr["VALUE6"].ToString());
- alProcessResultParamsLog.Add(dr["VALUE7"].ToString());
- alProcessResultParamsLog.Add(dr["VALUE8"].ToString());
- alProcessResultParamsLog.Add(dr["VALUE9"].ToString());
- alProcessResultParamsLog.Add(dr["VALUE10"].ToString());
- alProcessResultParamsLog.Add(dr["VALUE11"].ToString());
- alProcessResultParamsLog.Add(dr["VALUE12"].ToString());
- alProcessResultParamsLog.Add(dr["VALUE13"].ToString());
- alProcessResultParamsLog.Add(dr["VALUE14"].ToString());
- alProcessResultParamsLog.Add(dr["VALUE15"].ToString());
- alProcessResultParamsLog.Add(UserInfo.GetUserName());//操作人
- alProcessResultParamsLog.Add(strTime);//操作时间
- alProcessResultParamsLog.Add("1");
- //alProcessResultParamsLog.Add(txtOPERATE_REMARK.Text.Trim());//操作备注修改
- alProcessResultLog.Add(alProcessResultParamsLog);//插入到JHYGG_PHYRESULT_LOG数据(过程原值)
- }
- string row = "";
- publicUltraGridDataCJBase.Ug.UpdateData();//修改原值
- foreach (DataRow dr in publicUltraGridDataCJBase.DataTable.Rows)
- {
- if (row.IndexOf(dr["PHY_CODE_MAX"].ToString()) < 0)
- {
- row += ",'" + dr["PHY_CODE_MAX"].ToString() + "'";
- }
- alProcessResultParams = new ArrayList();
- alProcessResultParams.Add("");
- alProcessResultParams.Add("");
- alProcessResultParams.Add("");
- alProcessResultParams.Add("");
- alProcessResultParams.Add("");
- alProcessResultParams.Add("");
- alProcessResultParams.Add("");
- alProcessResultParams.Add("");
- alProcessResultParams.Add("");
- alProcessResultParams.Add("");
- alProcessResultParams.Add("");
- alProcessResultParams.Add("");
- alProcessResultParams.Add("");
- alProcessResultParams.Add("");
- alProcessResultParams.Add("");
- alProcessResultParams.Add("");
- //alProcessResultParams.Add(txtREMARK_LOG.Text.Trim());//试验备注
- alProcessResultParams.Add(dr["PHYDETAIL_ID"].ToString());
- alProcessResult.Add(alProcessResultParams);//新值
- }
- if (publicUltraGridDataCJBaseItems.DataTable != null)
- {
- string strMethod = "";
- publicUltraGridDataCJBaseItems.Ug.UpdateData();
- foreach (DataRow dr in publicUltraGridDataCJBaseItems.DataTable.Rows)
- {
- if (strMethod.IndexOf(dr["CHECK_METHOD_NO"].ToString()) < 0)
- {
- strMethod += dr["CHECK_METHOD_NO"].ToString() + " ";
- alPhyItemsParams = new ArrayList();
- alPhyItemsParams.Add(dr["CHECK_METHOD_NO"].ToString());
- alPhyItemsParams.Add(strSAMPLE_NO);
- alPhyItemsParams.Add(strCHECK_NO);
- alPhyItems.Add(alPhyItemsParams);
- }
- }
- }
- alAll.Add(alDetail);
- alAll.Add(alProcessResultLog);//原值
- alAll.Add(alProcessResult);
- if (alPhyItems.Count > 0)
- {
- alAll.Add(alPhyItems);
- }
- row = row.Remove(0, 1);
- ArrayList al = new ArrayList();
- al.Add(strCHECK_NO);
- al.Add(strSAMPLE_NO);
- al.Add(row);
- PublicServer.SetData("com.steering.lims.data.outdec.FrmOutdecDataCJBase.DeleteCheckConsignProcessResult",
- new Object[] { al, alAll }, this.ob);
- QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase2, "3456");
- QueryCheckConsignBaseDetail_Distinct(publicUltraGridBase1, "2");
- PublicPipeAndOutdec.ActiveOperateRow(publicUltraGridBase2.Ug, new string[] { "CHECK_NO", "SAMPLE_NO" }, new string[] { strCHECK_NO, strSAMPLE_NO });
- PublicPipeAndOutdec.ActiveOperateRow(publicUltraGridBase1.Ug, new string[] { "CHECK_NO", "SAMPLE_NO" }, new string[] { strCHECK_NO, strSAMPLE_NO });
- MessageUtil.ShowTips("删除成功!");
- }
- }
- catch (Exception e)
- {
- MessageUtil.ShowWarning(e.Message);
- }
- }
- private void ultraTabControl3_SelectedTabChanging(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangingEventArgs e)
- {
- int cnt = 0;
- if (tabIndex == 0)
- {
- publicUltraGridDataCJBase7_2.Ug.UpdateData();
- cnt = publicUltraGridDataCJBase7_2.DataTable.Rows.Cast<DataRow>().Where(
- a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
- }
- else if (tabIndex == 1)
- {
- publicUltraGridDataCJBase8_2.Ug.UpdateData();
- cnt = publicUltraGridDataCJBase8_2.DataTable.Rows.Cast<DataRow>().Where(
- a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
- }
- else if (tabIndex == 2)
- {
- publicUltraGridDataCJBase9_2.Ug.UpdateData();
- cnt = publicUltraGridDataCJBase9_2.DataTable.Rows.Cast<DataRow>().Where(
- a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
- }
- else if (tabIndex == 3)
- {
- publicUltraGridDataCJBase10_2.Ug.UpdateData();
- cnt = publicUltraGridDataCJBase10_2.DataTable.Rows.Cast<DataRow>().Where(
- a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
- }
- //else if (tabIndex == 4)
- //{
- // publicUltraGridDataCJBase11_2.Ug.UpdateData();
- // cnt = publicUltraGridDataCJBase11_2.DataTable.Rows.Cast<DataRow>().Where(
- // a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
- //}
- //else if (tabIndex == 5)
- //{
- // publicUltraGridDataCJBase12_2.Ug.UpdateData();
- // cnt = publicUltraGridDataCJBase12_2.DataTable.Rows.Cast<DataRow>().Where(
- // a => a.RowState == DataRowState.Added || a.RowState == DataRowState.Modified).Count();
- //}
- if (cnt > 0)
- {
- if (MessageUtil.ShowYesNoAndQuestion("数据有变更您确定要放弃吗?") == System.Windows.Forms.DialogResult.No)
- {
- e.Cancel = true;
- }
- }
- }
- #endregion
- #region 审核区域
- //查询检验委托基本信息
- private void QueryCheckConsignBaseDetail_Distinct(UltraGrid ultraGrid, string strFlag)
- {
- try
- {
- ClearPhyDetailItems(ultraGrid == ultraGrid1 ? ultraTabControl4 : ultraTabControl5);//20160523
- if (ultraGrid == ultraGrid1)
- {
- dataTable2.Rows.Clear();
- dataTable1.Rows.Clear();
- }
- else
- {
- dataTable4.Rows.Clear();
- dataTable3.Rows.Clear();
- }
- //各试验室各检验项目设置权限
- DataTable dt = PublicServer.GetData("com.steering.lims.data.outdec.FrmOutdecDataCJBase.QueryCheckConsignBase_Distinct",
- arrId == null ? new Object[] { outdecQueryBase1.GetQueryInfo(strFlag) } : new Object[] { outdecQueryBase1.GetQueryInfo(strFlag), arrId }, ob);
- if (dt == null || dt.Rows.Count == 0)
- {
- //ClearPhyDetailItems(ultraGrid == ultraGrid1 ? ultraTabControl4 : ultraTabControl5);
- return;
- }
- GridHelper.CopyDataToDatatable(dt, ultraGrid == ultraGrid1 ? dataTable1 : dataTable3, true);
- DataTable dtSample = PublicServer.GetData("com.steering.lims.data.outdec.PublicOutdecBase.QueryCheckConsignBaseDetail_Distinct",
- arrId == null ? new Object[] { outdecQueryBase1.GetQueryInfo(strFlag) } : new Object[] { outdecQueryBase1.GetQueryInfo(strFlag), arrId }, ob);
- if (dtSample == null || dtSample.Rows.Count == 0)
- {
- return;
- }
- else
- {
- GridHelper.CopyDataToDatatable(dtSample, ultraGrid == ultraGrid1 ? dataTable2 : dataTable4, true);
- }
- GridHelper.RefreshAndAutoSize(ultraGrid);
- }
- catch (Exception e)
- {
- MessageUtil.ShowWarning(e.Message);
- }
- }
- #endregion
- #region 未审核
- private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
- {
- try
- {
- if (ultraGrid1.ActiveRow.HasParent())
- {
- outdecShowBase3.ShowBaseInfo(ultraGrid1.ActiveRow.ParentRow);
- //赋值给全局变量
- UltraGridRow ur = ultraGrid1.ActiveRow;
- ArrayList arrayList = new ArrayList();
- arrayList.Add("3");
- arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());//20160523
- arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
- arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
- arrayList.Add(ur.Cells["CHECK_NO"].Text.Trim());
- if (arrId != null && arrId.Length > 0)
- {
- ClearPhyDetailItems(ultraTabControl4);
- //查询检验项目明细
- DataTable dt = PublicServer.GetData("com.steering.lims.data.outdec.FrmOutdecDataCJBase.QueryCheckConsignDetailPhyDetail", new Object[] { arrayList, arrId }, ob);
- if (dt == null || dt.Rows.Count == 0)
- {
- m_dtPhyMaxAudit = null;
- m_dtPhyItemsAudit = null;
- return;
- }
- m_dtPhyMaxAudit = dt.Copy();
- //20160523
- DataTable dtItems = PublicServer.GetData("com.steering.lims.data.outdec.FrmOutdecDataCJBase.QueryCheckMethodResult",
- new Object[] { arrayList, arrId }, ob);
- if (dtItems == null || dtItems.Rows.Count == 0)
- {
- m_dtPhyItemsAudit = null;
- //return;
- }
- else
- {
- m_dtPhyItemsAudit = dtItems.Copy();
- }
- ChangeColor(m_dtPhyMaxAudit, ultraTabControl4);
- AddPhyDetailItemsAudit();
- //设备信息
- getugr();
- publicDataCJBase3.ClearAll();
- if (CHECK_NO != "")
- { publicDataCJBase3.UpdateDateForPrama(getCheckDetal(CHECK_NO, SAMPLE_NO, PHY_CODE_MAX)); }
- }
- }
- else
- {
- ultraGrid1.ActiveRow.Expanded = true;
- //ultraGrid1.ActiveRow.ChildBands[0].Rows[0].Activated = true;
- }
- }
- catch (Exception ex)
- {
- MessageUtil.ShowWarning(ex.Message);
- }
- }
- private void AddPhyDetailItemsAudit()
- {
- if (m_dtPhyMaxAudit == null || m_dtPhyMaxAudit.Rows.Count == 0) return;
- //R0019 抗挤毁强度,R0047 爆破,复合力R0048
- if (ultraTabControl4.SelectedTab.Index == 0)//压溃
- {
- publicUltraGridDataCJBase13_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN IN ('R0019', 'R0021', 'R0047')"));//
- //publicUltraGridDataCJBase13_2.DataTable.AcceptChanges();
- QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase13_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN IN ('R0019', 'R0021', 'R0047')"), splitContainer13, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAudit, "PHY_CODE_MIN IN ('R0019', 'R0021', 'R0047')"));
- }
- else if (ultraTabControl4.SelectedTab.Index == 1)
- {
- publicUltraGridDataCJBase14_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN IN ('R0020', 'R0048')"));//
- //publicUltraGridDataCJBase14_2.DataTable.AcceptChanges();
- QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase14_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN IN ('R0020', 'R0048')"), splitContainer14, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAudit, "PHY_CODE_MIN IN ('R0020', 'R0048')"));
- }
- else if (ultraTabControl4.SelectedTab.Index == 2)
- {
- publicUltraGridDataCJBase15_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN = 'R0046'"));//
- //publicUltraGridDataCJBase15_2.DataTable.AcceptChanges();
- QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase15_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN = 'R0046'"), splitContainer15, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAudit, "PHY_CODE_MIN = 'R0046'"));
- }
- else if (ultraTabControl4.SelectedTab.Index == 3)//
- {
- publicUltraGridDataCJBase16_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN NOT IN ('R0019', 'R0020', 'R0021', 'R0046', 'R0047', 'R0048')"));//
- //publicUltraGridDataCJBase16_2.DataTable.AcceptChanges();
- QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase16_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN NOT IN ('R0019', 'R0020', 'R0021', 'R0046', 'R0047', 'R0048')"), splitContainer16, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAudit, "PHY_CODE_MIN NOT IN ('R0019', 'R0020', 'R0021', 'R0046', 'R0047', 'R0048')"));
- }
- //else if (ultraTabControl4.SelectedTab.Index == 4)//
- //{
- // publicUltraGridDataCJBase17_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN IN ('R0010')"));//工艺
- // //publicUltraGridDataCJBase17_2.DataTable.AcceptChanges();
- // QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase17_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN IN ('R0010')"), splitContainer17, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAudit, "PHY_CODE_MIN IN ('R0010')"));
- //}
- //else if (ultraTabControl4.SelectedTab.Index == 5)//
- //{
- // publicUltraGridDataCJBase18_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN NOT IN ('R0001', 'R0002','R0003','R0004','R0005','R0010','R0012','R0013')"));
- // //publicUltraGridDataCJBase18_2.DataTable.AcceptChanges();
- // 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')"));
- //}
- //tabIndex = ultraTabControl4.SelectedTab.Index;
- }
- private void ultraTabControl4_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
- {
- //if (m_dtPhyMax == null || m_dtPhyMax.Rows.Count == 0) return;
- if (toolMenu == null) return;
- AddPhyDetailItemsAudit();
- //设备信息
- getugr();
- publicDataCJBase3.ClearAll();
- if (CHECK_NO != "")
- { publicDataCJBase3.UpdateDateForPrama(getCheckDetal(CHECK_NO, SAMPLE_NO, PHY_CODE_MAX)); }
- }
- private void AuditCheckConsignDetail()
- {
- try
- {
- if (ultraTabControl1.SelectedTab.Index != 2)
- {
- MessageUtil.ShowWarning("只有在未审核数据页才能进行审核操作!");
- return;
- }
- if (ultraGrid1.ActiveRow == null || ultraGrid1.ActiveRow.Activated == false)
- {
- MessageUtil.ShowWarning("请选择需要审核的检验信息!");
- return;
- }
- if (dataTable1 == null || dataTable1.Rows.Count == 0)
- {
- return;
- }
- ultraGrid1.UpdateData();
- DataRow[] arrBase = dataTable2.Select("CHK = 'True'");
- if (arrBase == null || arrBase.Length == 0)
- {
- MessageUtil.ShowTips("请勾选至少一条检验信息!");
- return;
- }
- if (MessageUtil.ShowYesNoAndQuestion("是否确认审核?") == DialogResult.Yes)
- {
- ArrayList alBase = new ArrayList();//存放所有需要更新的基础信息
- ArrayList alBaseParams = new ArrayList();//存放单个基础参数信息
- string user = UserInfo.GetUserName();
- string strDate = DateTime.Now.ToString();
- foreach (DataRow row in arrBase)
- {
- alBaseParams = new ArrayList();//增加要更新的基础标志位信息
- alBaseParams.Add("4");
- alBaseParams.Add(user);//审核人
- alBaseParams.Add(strDate);//审核时间
- alBaseParams.Add("");
- alBaseParams.Add("");//样品备注row["SAMPLE_REMARK"].ToString()
- alBaseParams.Add("3");
- alBaseParams.Add("");//PHY_CODE_MAX
- alBaseParams.Add("");
- alBaseParams.Add("");
- alBaseParams.Add(row["SAMPLE_NO"].ToString());
- alBaseParams.Add(row["CHECK_NO"].ToString());
- alBase.Add(alBaseParams);
- }
- PublicServer.SetData("com.steering.lims.data.outdec.FrmOutdecDataCJBase.AuditCheckConsignDetail",
- new Object[] { alBase }, this.ob);
- QueryCheckConsignBaseDetail_Distinct(ultraGrid1, "3");
- //QueryCheckConsignBaseDetail_Distinct(ultraGrid2, "4");
- //PublicPipeAndOutdec.ActiveOperateRow(ultraGrid1, new string[] { "CHECK_NO" }, new string[] { strCHECK_NO });
- //PublicPipeAndOutdec.ActiveOperateRow(ultraGrid2, new string[] { "CHECK_NO" }, new string[] { strCHECK_NO });
- MessageUtil.ShowTips("审核成功!");
- }
- }
- catch (Exception e)
- {
- MessageUtil.ShowWarning(e.Message);
- }
- }
- private void SingleAuditCheckConsignDetail(PublicUltraGridDataCJBase publicUltraGridDataCJBase)
- {
- try
- {
- if (ultraTabControl1.SelectedTab.Index != 2)
- {
- MessageUtil.ShowWarning("只有在未审核数据页才能进行单项审核操作!");
- return;
- }
- if (ultraGrid1.ActiveRow == null || ultraGrid1.ActiveRow.Activated == false)
- {
- MessageUtil.ShowWarning("请选择需要单项审核的检验信息!");
- return;
- }
- if (dataTable1 == null || dataTable1.Rows.Count == 0)
- {
- return;
- }
- ultraGrid1.UpdateData();
- DataRow[] arrBase = dataTable2.Select("CHK = 'True'");
- if (arrBase == null || arrBase.Length == 0)
- {
- MessageUtil.ShowTips("请勾选至少一条检验信息!");
- return;
- }
- // string row = "";
- //foreach (DataRow dr in publicUltraGridDataCJBase.DataTable.Rows)
- //{
- // if (row.IndexOf(dr["PHY_CODE_MAX"].ToString()) < 0)
- // {
- // row += dr["PHY_CODE_MAX"].ToString() + " ";
- if (MessageUtil.ShowYesNoAndQuestion("是否确认单项审核?") == DialogResult.Yes)
- {
- ArrayList alBase = new ArrayList();//存放所有需要更新的基础信息
- ArrayList alBaseParams = new ArrayList();//存放单个基础参数信息
- string user = UserInfo.GetUserName();
- string strDate = DateTime.Now.ToString();
- string rowSample = "";
- foreach (DataRow dr in publicUltraGridDataCJBase.DataTable.Rows)
- {
- if (rowSample.IndexOf(dr["PHY_CODE_MAX"].ToString()) < 0)
- {
- rowSample += dr["PHY_CODE_MAX"].ToString() + " ";
- }
- }
- foreach (DataRow row in arrBase)
- {
- foreach (string strPHY_CODE_MAX in rowSample.Trim().Split(' '))
- {
- alBaseParams = new ArrayList();//增加要更新的基础标志位信息
- alBaseParams.Add("4");
- alBaseParams.Add(user);//审核人
- alBaseParams.Add(strDate);//审核时间
- alBaseParams.Add("");
- alBaseParams.Add("");//样品备注row["SAMPLE_REMARK"].ToString()
- alBaseParams.Add("3");
- alBaseParams.Add(strPHY_CODE_MAX);//PHY_CODE_MAX
- alBaseParams.Add(strPHY_CODE_MAX);
- alBaseParams.Add(strPHY_CODE_MAX);
- alBaseParams.Add(row["SAMPLE_NO"].ToString());
- alBaseParams.Add(row["CHECK_NO"].ToString());
- alBase.Add(alBaseParams);
- }
- }
- PublicServer.SetData("com.steering.lims.data.outdec.FrmOutdecDataCJBase.AuditCheckConsignDetail",
- new Object[] { alBase }, this.ob);
- QueryCheckConsignBaseDetail_Distinct(ultraGrid1, "3");
- //QueryCheckConsignBaseDetail_Distinct(ultraGrid2, "4");
- //PublicPipeAndOutdec.ActiveOperateRow(ultraGrid1, new string[] { "CHECK_NO" }, new string[] { strCHECK_NO });
- //PublicPipeAndOutdec.ActiveOperateRow(ultraGrid2, new string[] { "CHECK_NO" }, new string[] { strCHECK_NO });
- MessageUtil.ShowTips("单项审核成功!");
- }
- }
- catch (Exception e)
- {
- MessageUtil.ShowWarning(e.Message);
- }
- }
- private void ultraGrid1_CellChange(object sender, CellEventArgs e)
- {
- if (e.Cell.Row.HasChild() && e.Cell.Column.Key == "CHK")
- {
- ultraGrid1.UpdateData();
- if (e.Cell.Value.ToString() == "True")
- {
- foreach (UltraGridRow dr in e.Cell.Row.ChildBands[0].Rows)
- {
- dr.Cells["CHK"].Value = "True";
- }
- }
- else
- {
- foreach (UltraGridRow dr in e.Cell.Row.ChildBands[0].Rows)
- {
- dr.Cells["CHK"].Value = "False";
- }
- }
- }
- }
- #endregion
- #region 已审核
- private void ultraGrid2_AfterRowActivate(object sender, EventArgs e)
- {
- try
- {
- if (ultraGrid2.ActiveRow.HasParent())
- {
- outdecShowBase4.ShowBaseInfo(ultraGrid2.ActiveRow.ParentRow);
- //赋值给全局变量
- UltraGridRow ur = ultraGrid2.ActiveRow;
- ArrayList arrayList = new ArrayList();
- arrayList.Add("4");
- arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());//20160523
- arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
- arrayList.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
- arrayList.Add(ur.Cells["CHECK_NO"].Text.Trim());
- if (arrId != null && arrId.Length > 0)
- {
- ClearPhyDetailItems(ultraTabControl5);
- //查询检验项目明细
- DataTable dt = PublicServer.GetData("com.steering.lims.data.outdec.FrmOutdecDataCJBase.QueryCheckConsignDetailPhyDetail", new Object[] { arrayList, arrId }, ob);
- if (dt == null || dt.Rows.Count == 0)
- {
- m_dtPhyMaxAuditAdd = null;
- m_dtPhyItemsAuditAdd = null;
- return;
- }
- m_dtPhyMaxAuditAdd = dt.Copy();
- //QueryCheckMethodPhyConfigItems20160523
- DataTable dtItems = PublicServer.GetData("com.steering.lims.data.outdec.FrmOutdecDataCJBase.QueryCheckMethodResult",
- new Object[] { arrayList, arrId }, ob);
- if (dtItems == null || dtItems.Rows.Count == 0)
- {
- m_dtPhyItemsAuditAdd = null;
- //return;
- }
- else
- {
- m_dtPhyItemsAuditAdd = dtItems.Copy();
- }
- ChangeColor(m_dtPhyMaxAuditAdd, ultraTabControl5);
- AddPhyDetailItemsAudit_Log();
- //设备信息
- getugr();
- publicDataCJBase4.ClearAll();
- if (CHECK_NO != "")
- { publicDataCJBase4.UpdateDateForPrama(getCheckDetal(CHECK_NO, SAMPLE_NO, PHY_CODE_MAX)); }
- //ArrayList list = new ArrayList();
- //list.Add(ur.Cells["SAMPLE_NO"].Text.Trim());
- //list.Add(ur.Cells["CHECK_NO"].Text.Trim());
- //list.Add(ur.Cells["DEPT_ID"].Text.Trim());
- //publicUltraGridDetail1.QueryCheckConsignDetailFilePath("outdec.PublicOutdecBase", list, this.ob);
- }
- }
- else
- {
- ultraGrid2.ActiveRow.Expanded = true;
- //ultraGrid2.ActiveRow.ChildBands[0].Rows[0].Activated = true;
- }
- }
- catch (Exception ex)
- {
- MessageUtil.ShowWarning(ex.Message);
- }
- }
- private void AddPhyDetailItemsAudit_Log()
- {
- if (m_dtPhyMaxAuditAdd == null || m_dtPhyMaxAuditAdd.Rows.Count == 0) return;
- if (ultraTabControl5.SelectedTab.Index == 0)
- {
- publicUltraGridDataCJBase19_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN IN ('R0019', 'R0021', 'R0047')"));//
- //publicUltraGridDataCJBase19_2.DataTable.AcceptChanges();
- QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase19_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN IN ('R0019', 'R0021', 'R0047')"), splitContainer19, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAuditAdd, "PHY_CODE_MIN IN ('R0019', 'R0021', 'R0047')"));
- }
- else if (ultraTabControl5.SelectedTab.Index == 1)
- {
- publicUltraGridDataCJBase20_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN IN ('R0020', 'R0048')"));//
- //publicUltraGridDataCJBase20_2.DataTable.AcceptChanges();
- QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase20_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN IN ('R0020', 'R0048')"), splitContainer20, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAuditAdd, "PHY_CODE_MIN IN ('R0020', 'R0048')"));
- }
- else if (ultraTabControl5.SelectedTab.Index == 2)
- {
- publicUltraGridDataCJBase21_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN = 'R0046'"));//
- //publicUltraGridDataCJBase21_2.DataTable.AcceptChanges();
- QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase21_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN = 'R0046'"), splitContainer21, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAuditAdd, "PHY_CODE_MIN = 'R0046'"));
- }
- else if (ultraTabControl5.SelectedTab.Index == 3)//
- {
- publicUltraGridDataCJBase22_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN NOT IN ('R0019', 'R0020', 'R0021', 'R0046', 'R0047', 'R0048')"));//
- //publicUltraGridDataCJBase22_2.DataTable.AcceptChanges();
- QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase22_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN NOT IN ('R0019', 'R0020', 'R0021', 'R0046', 'R0047', 'R0048')"), splitContainer22, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAuditAdd, "PHY_CODE_MIN NOT IN ('R0019', 'R0020', 'R0021', 'R0046', 'R0047', 'R0048')"));
- }
- //else if (ultraTabControl5.SelectedTab.Index == 4)//
- //{
- // publicUltraGridDataCJBase23_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN IN ('R0010')"));//工艺
- // //publicUltraGridDataCJBase23_2.DataTable.AcceptChanges();
- // QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase23_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN IN ('R0010')"), splitContainer23, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAuditAdd, "PHY_CODE_MIN IN ('R0010')"));
- //}
- //else if (ultraTabControl5.SelectedTab.Index == 5)//
- //{
- // publicUltraGridDataCJBase24_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN NOT IN ('R0001', 'R0002','R0003','R0004','R0005','R0010','R0012','R0013')"));
- // //publicUltraGridDataCJBase24_2.DataTable.AcceptChanges();
- // 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')"));
- //}
- }
- private void ultraTabControl5_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
- {
- //if (m_dtPhyMax == null || m_dtPhyMax.Rows.Count == 0) return;
- if (toolMenu == null) return;
- AddPhyDetailItemsAudit_Log();
- //设备信息
- getugr();
- publicDataCJBase4.ClearAll();
- if (CHECK_NO != "")
- { publicDataCJBase4.UpdateDateForPrama(getCheckDetal(CHECK_NO, SAMPLE_NO, PHY_CODE_MAX)); }
- }
- private void CancelAuditCheckConsignDetail()
- {
- try
- {
- if (ultraTabControl1.SelectedTab.Index != 3)
- {
- MessageUtil.ShowWarning("只有在已审核数据页才能进行取消审核操作!");
- return;
- }
- if (ultraGrid2.ActiveRow == null || ultraGrid2.ActiveRow.Activated == false)
- {
- MessageUtil.ShowWarning("请选择需要取消审核的检验信息!");
- return;
- }
- if (dataTable3 == null || dataTable3.Rows.Count == 0)
- {
- return;
- }
- ultraGrid2.UpdateData();
- DataRow[] arrBase = dataTable4.Select("CHK = 'True'");
- if (arrBase == null || arrBase.Length == 0)
- {
- MessageUtil.ShowTips("请勾选至少一条检验信息!");
- return;
- }
- //if (MessageUtil.ShowYesNoAndQuestion("是否确认取消审核?") == DialogResult.Yes)
- //{
- WinCancelSampleComfirm pc = new WinCancelSampleComfirm();
- pc.ShowDialog();
- if (pc.DialogResult != DialogResult.OK)
- {
- return;
- }
- string strRemark = pc.StrRemark;
- string user = UserInfo.GetUserName();
- string strDate = DateTime.Now.ToString();
- strRemark = "取消审核由于" + strRemark + "(" + user + " " + strDate + ")";
- string strCHECK_NO = "";
- ArrayList alBase = new ArrayList();//存放所有需要更新的基础信息
- ArrayList alBaseParams = new ArrayList();//存放单个基础参数信息
- foreach (DataRow row in arrBase)
- {
- alBaseParams = new ArrayList();//增加要更新的基础标志位信息
- alBaseParams.Add("3");
- alBaseParams.Add(user);//审核人
- alBaseParams.Add(strDate);//审核时间
- alBaseParams.Add(strRemark);
- alBaseParams.Add(strRemark);//样品备注row["SAMPLE_REMARK"].ToString()
- alBaseParams.Add("4");
- alBaseParams.Add("");//PHY_CODE_MAX
- alBaseParams.Add("");
- alBaseParams.Add("");
- alBaseParams.Add(row["SAMPLE_NO"].ToString());
- alBaseParams.Add(row["CHECK_NO"].ToString());
- if (strCHECK_NO == "")
- {
- strCHECK_NO = row["CHECK_NO"].ToString();
- }
- alBase.Add(alBaseParams);
- }
- PublicServer.SetData("com.steering.lims.data.outdec.FrmOutdecDataCJBase.AuditCheckConsignDetail",
- new Object[] { alBase }, this.ob);
- QueryCheckConsignBaseDetail_Distinct(ultraGrid2, "456");
- QueryCheckConsignBaseDetail_Distinct(ultraGrid1, "3");
- PublicPipeAndOutdec.ActiveOperateRow(ultraGrid2, new string[] { "CHECK_NO" }, new string[] { strCHECK_NO });
- PublicPipeAndOutdec.ActiveOperateRow(ultraGrid1, new string[] { "CHECK_NO" }, new string[] { strCHECK_NO });
- MessageUtil.ShowTips("取消审核成功!");
- //}
- }
- catch (Exception e)
- {
- MessageUtil.ShowWarning(e.Message);
- }
- }
- private void CancelSingleAuditCheckConsignDetail(PublicUltraGridDataCJBase publicUltraGridDataCJBase)
- {
- try
- {
- if (ultraTabControl1.SelectedTab.Index != 3)
- {
- MessageUtil.ShowWarning("只有在已审核数据页才能进行取消单项审核操作!");
- return;
- }
- if (ultraGrid2.ActiveRow == null || ultraGrid2.ActiveRow.Activated == false)
- {
- MessageUtil.ShowWarning("请选择需要取消单项审核的检验信息!");
- return;
- }
- if (dataTable3 == null || dataTable3.Rows.Count == 0)
- {
- return;
- }
- ultraGrid2.UpdateData();
- DataRow[] arrBase = dataTable4.Select("CHK = 'True'");
- if (arrBase == null || arrBase.Length == 0)
- {
- MessageUtil.ShowTips("请勾选至少一条检验信息!");
- return;
- }
- //if (MessageUtil.ShowYesNoAndQuestion("是否确认单项审核?") == DialogResult.Yes)
- //{
- WinCancelSampleComfirm pc = new WinCancelSampleComfirm();
- pc.ShowDialog();
- if (pc.DialogResult != DialogResult.OK)
- {
- return;
- }
- string strRemark = pc.StrRemark;
- string user = UserInfo.GetUserName();
- string strDate = DateTime.Now.ToString();
- strRemark = "取消单项审核由于" + strRemark + "(" + user + " " + strDate + ")";
- ArrayList alBase = new ArrayList();//存放所有需要更新的基础信息
- ArrayList alBaseParams = new ArrayList();//存放单个基础参数信息
- string strCHECK_NO = "";
- string rowSample = "";
- foreach (DataRow dr in publicUltraGridDataCJBase.DataTable.Rows)
- {
- if (rowSample.IndexOf(dr["PHY_CODE_MAX"].ToString()) < 0)
- {
- rowSample += dr["PHY_CODE_MAX"].ToString() + " ";
- }
- }
- foreach (DataRow row in arrBase)
- {
- foreach (string strPHY_CODE_MAX in rowSample.Trim().Split(' '))
- {
- alBaseParams = new ArrayList();//增加要更新的基础标志位信息
- alBaseParams.Add("3");
- alBaseParams.Add(user);//审核人
- alBaseParams.Add(strDate);//审核时间
- alBaseParams.Add(strRemark);
- alBaseParams.Add(strRemark);//样品备注row["SAMPLE_REMARK"].ToString()
- alBaseParams.Add("4");
- alBaseParams.Add(strPHY_CODE_MAX);//PHY_CODE_MAX
- alBaseParams.Add(strPHY_CODE_MAX);
- alBaseParams.Add(strPHY_CODE_MAX);
- alBaseParams.Add(row["SAMPLE_NO"].ToString());
- alBaseParams.Add(row["CHECK_NO"].ToString());
- if (strCHECK_NO == "")
- {
- strCHECK_NO = row["CHECK_NO"].ToString();
- }
- alBase.Add(alBaseParams);
- }
- }
- PublicServer.SetData("com.steering.lims.data.outdec.FrmOutdecDataCJBase.AuditCheckConsignDetail",
- new Object[] { alBase }, this.ob);
- QueryCheckConsignBaseDetail_Distinct(ultraGrid2, "4");
- QueryCheckConsignBaseDetail_Distinct(ultraGrid1, "3");
- PublicPipeAndOutdec.ActiveOperateRow(ultraGrid2, new string[] { "CHECK_NO" }, new string[] { strCHECK_NO });
- PublicPipeAndOutdec.ActiveOperateRow(ultraGrid1, new string[] { "CHECK_NO" }, new string[] { strCHECK_NO });
- MessageUtil.ShowTips("取消单项审核成功!");
- //}
- }
- catch (Exception e)
- {
- MessageUtil.ShowWarning(e.Message);
- }
- }
- private void ultraGrid2_CellChange(object sender, CellEventArgs e)
- {
- if (e.Cell.Row.HasChild() && e.Cell.Column.Key == "CHK")
- {
- ultraGrid2.UpdateData();
- if (e.Cell.Value.ToString() == "True")
- {
- foreach (UltraGridRow dr in e.Cell.Row.ChildBands[0].Rows)
- {
- dr.Cells["CHK"].Value = "True";
- }
- }
- else
- {
- foreach (UltraGridRow dr in e.Cell.Row.ChildBands[0].Rows)
- {
- dr.Cells["CHK"].Value = "False";
- }
- }
- }
- }
- #endregion
- private void FrmOutdecLabMecDataCJAudit_Shown(object sender, EventArgs e)
- {
- if (toolMenu == null) return;
- if (ultraTabControl1.SelectedTab.Index == 0)
- {
- if (toolMenu.Toolbars[0].Tools.Exists("Add"))
- {
- toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.True;
- }
- if (toolMenu.Toolbars[0].Tools.Exists("Update"))
- {
- this.toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.False;
- }
- if (toolMenu.Toolbars[0].Tools.Exists("Delete"))
- {
- toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.False;
- }
- if (toolMenu.Toolbars[0].Tools.Exists("Audit"))
- {
- toolMenu.Toolbars[0].Tools["Audit"].InstanceProps.Visible = DefaultableBoolean.False;
- }
- if (toolMenu.Toolbars[0].Tools.Exists("CancelAudit"))
- {
- toolMenu.Toolbars[0].Tools["CancelAudit"].InstanceProps.Visible = DefaultableBoolean.False;
- }
- if (toolMenu.Toolbars[0].Tools.Exists("SingleAudit"))
- {
- toolMenu.Toolbars[0].Tools["SingleAudit"].InstanceProps.Visible = DefaultableBoolean.False;
- }
- if (toolMenu.Toolbars[0].Tools.Exists("CancelSingleAudit"))
- {
- toolMenu.Toolbars[0].Tools["CancelSingleAudit"].InstanceProps.Visible = DefaultableBoolean.False;
- }
- }
- else if (ultraTabControl1.SelectedTab.Index == 1)
- {
- if (toolMenu.Toolbars[0].Tools.Exists("Add"))
- {
- toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.False;
- }
- if (toolMenu.Toolbars[0].Tools.Exists("Update"))
- {
- this.toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.True;
- }
- if (toolMenu.Toolbars[0].Tools.Exists("Delete"))
- {
- toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.True;
- }
- if (toolMenu.Toolbars[0].Tools.Exists("Audit"))
- {
- toolMenu.Toolbars[0].Tools["Audit"].InstanceProps.Visible = DefaultableBoolean.False;
- }
- if (toolMenu.Toolbars[0].Tools.Exists("CancelAudit"))
- {
- toolMenu.Toolbars[0].Tools["CancelAudit"].InstanceProps.Visible = DefaultableBoolean.False;
- }
- if (toolMenu.Toolbars[0].Tools.Exists("SingleAudit"))
- {
- toolMenu.Toolbars[0].Tools["SingleAudit"].InstanceProps.Visible = DefaultableBoolean.False;
- }
- if (toolMenu.Toolbars[0].Tools.Exists("CancelSingleAudit"))
- {
- toolMenu.Toolbars[0].Tools["CancelSingleAudit"].InstanceProps.Visible = DefaultableBoolean.False;
- }
- }
- else if (ultraTabControl1.SelectedTab.Index == 2)
- {
- if (toolMenu.Toolbars[0].Tools.Exists("Add"))
- {
- toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.False;
- }
- if (toolMenu.Toolbars[0].Tools.Exists("Update"))
- {
- this.toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.False;
- }
- if (toolMenu.Toolbars[0].Tools.Exists("Delete"))
- {
- toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.False;
- }
- if (toolMenu.Toolbars[0].Tools.Exists("Audit"))
- {
- toolMenu.Toolbars[0].Tools["Audit"].InstanceProps.Visible = DefaultableBoolean.True;
- }
- if (toolMenu.Toolbars[0].Tools.Exists("CancelAudit"))
- {
- toolMenu.Toolbars[0].Tools["CancelAudit"].InstanceProps.Visible = DefaultableBoolean.False;
- }
- if (toolMenu.Toolbars[0].Tools.Exists("SingleAudit"))
- {
- toolMenu.Toolbars[0].Tools["SingleAudit"].InstanceProps.Visible = DefaultableBoolean.True;
- }
- if (toolMenu.Toolbars[0].Tools.Exists("CancelSingleAudit"))
- {
- toolMenu.Toolbars[0].Tools["CancelSingleAudit"].InstanceProps.Visible = DefaultableBoolean.False;
- }
- }
- else if (ultraTabControl1.SelectedTab.Index == 3)
- {
- if (toolMenu.Toolbars[0].Tools.Exists("Add"))
- {
- toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.False;
- }
- if (toolMenu.Toolbars[0].Tools.Exists("Update"))
- {
- this.toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.False;
- }
- if (toolMenu.Toolbars[0].Tools.Exists("Delete"))
- {
- toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.False;
- }
- if (toolMenu.Toolbars[0].Tools.Exists("Audit"))
- {
- toolMenu.Toolbars[0].Tools["Audit"].InstanceProps.Visible = DefaultableBoolean.False;
- }
- if (toolMenu.Toolbars[0].Tools.Exists("CancelAudit"))
- {
- toolMenu.Toolbars[0].Tools["CancelAudit"].InstanceProps.Visible = DefaultableBoolean.True;
- }
- if (toolMenu.Toolbars[0].Tools.Exists("SingleAudit"))
- {
- toolMenu.Toolbars[0].Tools["SingleAudit"].InstanceProps.Visible = DefaultableBoolean.False;
- }
- if (toolMenu.Toolbars[0].Tools.Exists("CancelSingleAudit"))
- {
- toolMenu.Toolbars[0].Tools["CancelSingleAudit"].InstanceProps.Visible = DefaultableBoolean.True;
- }
- }
- }
- private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
- {
- if (toolMenu == null) return;
- if (ultraTabControl1.SelectedTab.Index == 0)
- {
- if (toolMenu.Toolbars[0].Tools.Exists("Add"))
- {
- toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.True;
- }
- if (toolMenu.Toolbars[0].Tools.Exists("Update"))
- {
- this.toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.False;
- }
- if (toolMenu.Toolbars[0].Tools.Exists("Delete"))
- {
- toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.False;
- }
- if (toolMenu.Toolbars[0].Tools.Exists("Audit"))
- {
- toolMenu.Toolbars[0].Tools["Audit"].InstanceProps.Visible = DefaultableBoolean.False;
- }
- if (toolMenu.Toolbars[0].Tools.Exists("CancelAudit"))
- {
- toolMenu.Toolbars[0].Tools["CancelAudit"].InstanceProps.Visible = DefaultableBoolean.False;
- }
- if (toolMenu.Toolbars[0].Tools.Exists("SingleAudit"))
- {
- toolMenu.Toolbars[0].Tools["SingleAudit"].InstanceProps.Visible = DefaultableBoolean.False;
- }
- if (toolMenu.Toolbars[0].Tools.Exists("CancelSingleAudit"))
- {
- toolMenu.Toolbars[0].Tools["CancelSingleAudit"].InstanceProps.Visible = DefaultableBoolean.False;
- }
- }
- else if (ultraTabControl1.SelectedTab.Index == 1)
- {
- if (toolMenu.Toolbars[0].Tools.Exists("Add"))
- {
- toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.False;
- }
- if (toolMenu.Toolbars[0].Tools.Exists("Update"))
- {
- this.toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.True;
- }
- if (toolMenu.Toolbars[0].Tools.Exists("Delete"))
- {
- toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.True;
- }
- if (toolMenu.Toolbars[0].Tools.Exists("Audit"))
- {
- toolMenu.Toolbars[0].Tools["Audit"].InstanceProps.Visible = DefaultableBoolean.False;
- }
- if (toolMenu.Toolbars[0].Tools.Exists("CancelAudit"))
- {
- toolMenu.Toolbars[0].Tools["CancelAudit"].InstanceProps.Visible = DefaultableBoolean.False;
- }
- if (toolMenu.Toolbars[0].Tools.Exists("SingleAudit"))
- {
- toolMenu.Toolbars[0].Tools["SingleAudit"].InstanceProps.Visible = DefaultableBoolean.False;
- }
- if (toolMenu.Toolbars[0].Tools.Exists("CancelSingleAudit"))
- {
- toolMenu.Toolbars[0].Tools["CancelSingleAudit"].InstanceProps.Visible = DefaultableBoolean.False;
- }
- }
- else if (ultraTabControl1.SelectedTab.Index == 2)
- {
- if (toolMenu.Toolbars[0].Tools.Exists("Add"))
- {
- toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.False;
- }
- if (toolMenu.Toolbars[0].Tools.Exists("Update"))
- {
- this.toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.False;
- }
- if (toolMenu.Toolbars[0].Tools.Exists("Delete"))
- {
- toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.False;
- }
- if (toolMenu.Toolbars[0].Tools.Exists("Audit"))
- {
- toolMenu.Toolbars[0].Tools["Audit"].InstanceProps.Visible = DefaultableBoolean.True;
- }
- if (toolMenu.Toolbars[0].Tools.Exists("CancelAudit"))
- {
- toolMenu.Toolbars[0].Tools["CancelAudit"].InstanceProps.Visible = DefaultableBoolean.False;
- }
- if (toolMenu.Toolbars[0].Tools.Exists("SingleAudit"))
- {
- toolMenu.Toolbars[0].Tools["SingleAudit"].InstanceProps.Visible = DefaultableBoolean.True;
- }
- if (toolMenu.Toolbars[0].Tools.Exists("CancelSingleAudit"))
- {
- toolMenu.Toolbars[0].Tools["CancelSingleAudit"].InstanceProps.Visible = DefaultableBoolean.False;
- }
- }
- else if (ultraTabControl1.SelectedTab.Index == 3)
- {
- if (toolMenu.Toolbars[0].Tools.Exists("Add"))
- {
- toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.False;
- }
- if (toolMenu.Toolbars[0].Tools.Exists("Update"))
- {
- this.toolMenu.Toolbars[0].Tools["Update"].InstanceProps.Visible = DefaultableBoolean.False;
- }
- if (toolMenu.Toolbars[0].Tools.Exists("Delete"))
- {
- toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.False;
- }
- if (toolMenu.Toolbars[0].Tools.Exists("Audit"))
- {
- toolMenu.Toolbars[0].Tools["Audit"].InstanceProps.Visible = DefaultableBoolean.False;
- }
- if (toolMenu.Toolbars[0].Tools.Exists("CancelAudit"))
- {
- toolMenu.Toolbars[0].Tools["CancelAudit"].InstanceProps.Visible = DefaultableBoolean.True;
- }
- if (toolMenu.Toolbars[0].Tools.Exists("SingleAudit"))
- {
- toolMenu.Toolbars[0].Tools["SingleAudit"].InstanceProps.Visible = DefaultableBoolean.False;
- }
- if (toolMenu.Toolbars[0].Tools.Exists("CancelSingleAudit"))
- {
- toolMenu.Toolbars[0].Tools["CancelSingleAudit"].InstanceProps.Visible = DefaultableBoolean.True;
- }
- }
- }
- }
- }
|