| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124212521262127212821292130213121322133213421352136213721382139214021412142214321442145214621472148214921502151215221532154215521562157215821592160216121622163216421652166216721682169217021712172217321742175217621772178217921802181218221832184218521862187218821892190219121922193219421952196219721982199220022012202220322042205220622072208220922102211221222132214221522162217221822192220222122222223222422252226222722282229223022312232223322342235223622372238223922402241224222432244224522462247224822492250225122522253225422552256225722582259226022612262226322642265226622672268226922702271227222732274227522762277227822792280228122822283228422852286228722882289229022912292229322942295229622972298229923002301230223032304230523062307230823092310231123122313231423152316231723182319232023212322232323242325232623272328232923302331233223332334233523362337233823392340234123422343234423452346234723482349235023512352235323542355235623572358235923602361236223632364236523662367236823692370237123722373237423752376237723782379238023812382238323842385238623872388238923902391239223932394239523962397239823992400240124022403240424052406240724082409241024112412241324142415241624172418241924202421242224232424242524262427242824292430243124322433243424352436243724382439244024412442244324442445244624472448244924502451245224532454245524562457245824592460246124622463246424652466246724682469247024712472247324742475247624772478247924802481248224832484248524862487248824892490249124922493249424952496249724982499250025012502250325042505250625072508250925102511251225132514251525162517251825192520252125222523252425252526252725282529253025312532253325342535253625372538253925402541254225432544254525462547254825492550 |
- 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;
- namespace Core.StlMes.Client.Lims.Data.PipeAndOutdec
- {
- //低倍录入界面 各检验大项分Tab页展示
- public partial class FrmOutdecLabMacDataCJAudit : 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 int tabIndex = 0;//保存当前的tab页
- public FrmOutdecLabMacDataCJAudit()
- {
- 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[] { "002001020001" };//低倍项目
- 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();
- //publicUltraGridDataCJBase1_2.in
- publicUltraGridDataCJBase2_1.InitColumnsPhyConfigItems();
- publicUltraGridDataCJBase2_2.InitColumnsOutdecPhyDetail();
- publicUltraGridDataCJBase3_1.InitColumnsPhyConfigItems();
- publicUltraGridDataCJBase3_2.InitColumnsOutdecPhyDetail();
- publicUltraGridDetail1.InitColumnsPipeDetail(new string[] { "PHY_NAME_MAX", "JG_PRINT_COUNT", "FILE_PATH1", "FILE_PATH2", "FILE_PATH3", "FILE_PATH4" }, null, true, this.ob, "0");
- //publicUltraGridDataCJBase4_1.InitColumnsPhyConfigItems();
- //publicUltraGridDataCJBase4_2.InitColumnsOutdecPhyDetail();
- //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();
- publicUltraGridDetail2.InitColumnsPipeDetail(new string[] { "PHY_NAME_MAX", "JG_PRINT_COUNT", "FILE_PATH1", "FILE_PATH2", "FILE_PATH3", "FILE_PATH4" }, null, true, this.ob, "0");
- //publicUltraGridDataCJBase10_1.InitColumnsPhyConfigItems();
- //publicUltraGridDataCJBase10_2.InitColumnsOutdecPhyDetail();
- //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);
- publicUltraGridDetail3.InitColumnsPipeDetail(new string[] { "PHY_NAME_MAX", "JG_PRINT_COUNT", "FILE_PATH1", "FILE_PATH2", "FILE_PATH3", "FILE_PATH4" }, null, true, this.ob, "0");
- //publicUltraGridDataCJBase16_1.InitColumnsPhyConfigItems(null);
- //publicUltraGridDataCJBase16_2.InitColumnsOutdecPhyDetail(null);
- //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);
- publicUltraGridDetail4.InitColumnsPipeDetail(new string[] { "PHY_NAME_MAX", "JG_PRINT_COUNT", "FILE_PATH1", "FILE_PATH2", "FILE_PATH3", "FILE_PATH4" }, null, true, this.ob, "0");
- //publicUltraGridDataCJBase22_1.InitColumnsPhyConfigItems(null);
- //publicUltraGridDataCJBase22_2.InitColumnsOutdecPhyDetail(null);
- //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 "Close":
- if (MessageUtil.ShowYesNoAndQuestion("是否确认关闭页面?") == DialogResult.Yes)
- {
- this.Close();
- }
- break;
- }
- }
- #region 公共方法
- //颜色改变
- private void ChangeColor(DataTable dtPhyMax, Infragistics.Win.UltraWinTabControl.UltraTabControl ultraTabControl)
- {
- //R0023钢管酸浸低倍检验 R0024钢材塔形发纹酸浸检验
- if (dtPhyMax == null || dtPhyMax.Rows.Count == 0) return;
- int i = -1;
- if (PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN = 'R0023'") != null && PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN = 'R0023'").Rows.Count > 0)
- {
- i = i == -1 ? i = 0 : i;
- ultraTabControl.Tabs[0].Appearance.BackColor = Color.GreenYellow;
- }
- if (PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN = 'R0024'") != null && PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN = 'R0024'").Rows.Count > 0)
- {
- i = i == -1 ? i = 1 : i;
- ultraTabControl.Tabs[1].Appearance.BackColor = Color.GreenYellow;
- }
- //if (PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN IN ('R0003','R0004','R0005')") != null && PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN IN ('R0003','R0004','R0005')").Rows.Count > 0)
- //{
- // i = i == -1 ? i = 2 : i;
- // ultraTabControl.Tabs[2].Appearance.BackColor = Color.GreenYellow;//硬度
- //}
- //if (PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN IN ('R0012','R0013')") != null && PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN IN ('R0012','R0013')").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 ('R0023', 'R0024')") != null && PublicPipeAndOutdec.GetSelectDt(dtPhyMax, "PHY_CODE_MIN NOT IN ('R0023', 'R0024')").Rows.Count > 0)
- {
- i = i == -1 ? i = 2 : i;
- ultraTabControl.Tabs[2].Appearance.BackColor = Color.GreenYellow;//其他
- }
- ultraTabControl.SelectedTab = i == -1 ? ultraTabControl.Tabs[0] : ultraTabControl.Tabs[i];
- }
- //赋值
- 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 录入区域
- //查询检验委托基本信息
- 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);
- }
- }
- //查询试验方法项目信息
- 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();
- }
- //赋值
- private void AddPhyDetailItems()
- {
- if (m_dtPhyMax == null || m_dtPhyMax.Rows.Count == 0) return;
- if (ultraTabControl2.SelectedTab.Index == 0)//低倍
- {
- publicUltraGridDataCJBase1_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN = 'R0023'"));//低倍
- publicUltraGridDataCJBase1_2.DataTable.AcceptChanges();
- QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase1_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN = 'R0023'"), splitContainer1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItems, "PHY_CODE_MIN = 'R0023'"));
- }
- else if (ultraTabControl2.SelectedTab.Index == 1)//塔形
- {
- publicUltraGridDataCJBase2_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN = 'R0024'"));//塔形
- publicUltraGridDataCJBase2_2.DataTable.AcceptChanges();
- QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase2_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN = 'R0024'"), splitContainer2, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItems, "PHY_CODE_MIN = 'R0024'"));
- }
- //else if (ultraTabControl2.SelectedTab.Index == 2)
- //{
- // publicUltraGridDataCJBase3_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN IN ('R0003','R0004','R0005')"));//硬度
- // publicUltraGridDataCJBase3_2.DataTable.AcceptChanges();
- // QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase3_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN IN ('R0003','R0004','R0005')"), splitContainer3, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItems, "PHY_CODE_MIN IN ('R0003','R0004','R0005')"));
- //}
- //else if (ultraTabControl2.SelectedTab.Index == 3)//金相
- //{
- // publicUltraGridDataCJBase4_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN IN ('R0012','R0013')"));//金相
- // publicUltraGridDataCJBase4_2.DataTable.AcceptChanges();
- // QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase4_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN IN ('R0012','R0013')"), splitContainer4, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItems, "PHY_CODE_MIN IN ('R0012','R0013')"));
- //}
- //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 == 2)//其他
- {
- publicUltraGridDataCJBase3_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN NOT IN ('R0023', 'R0024')"));
- publicUltraGridDataCJBase3_2.DataTable.AcceptChanges();
- QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase3_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMax, "PHY_CODE_MIN NOT IN ('R0023', 'R0024')"), splitContainer3, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItems, "PHY_CODE_MIN NOT IN ('R0023', 'R0024')"));
- }
- tabIndex = ultraTabControl2.SelectedTab.Index;
- }
- //新增检验委托过程结果JHYGG_PHYLX_PROCESS_RESULT,新增之前先删除表里数据
- 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["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, getCheckConsignDetailArrayList(publicUltraGridDetail1) }, 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();
- }
- 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();
- }
- }
- catch (Exception ex)
- {
- MessageUtil.ShowWarning(ex.Message);
- }
- }
- //赋值
- private void AddPhyDetailItems_Log()
- {
- if (m_dtPhyMaxAdd == null || m_dtPhyMaxAdd.Rows.Count == 0) return;
- if (ultraTabControl3.SelectedTab.Index == 0)
- {
- publicUltraGridDataCJBase7_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN = 'R0023'"));//拉伸
- publicUltraGridDataCJBase7_2.DataTable.AcceptChanges();
- QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase7_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN = 'R0023'"), splitContainer7, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAdd, "PHY_CODE_MIN = 'R0023'"));
- }
- else if (ultraTabControl3.SelectedTab.Index == 1)
- {
- publicUltraGridDataCJBase8_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN = 'R0024'"));//冲击
- publicUltraGridDataCJBase8_2.DataTable.AcceptChanges();
- QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase8_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN = 'R0024'"), splitContainer8, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAdd, "PHY_CODE_MIN = 'R0024'"));
- }
- //else if (ultraTabControl3.SelectedTab.Index == 2)
- //{
- // publicUltraGridDataCJBase9_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN IN ('R0003','R0004','R0005')"));//硬度
- // publicUltraGridDataCJBase9_2.DataTable.AcceptChanges();
- // QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase9_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN IN ('R0003','R0004','R0005')"), splitContainer9, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAdd, "PHY_CODE_MIN IN ('R0003','R0004','R0005')"));
- //}
- //else if (ultraTabControl3.SelectedTab.Index == 3)//金相
- //{
- // publicUltraGridDataCJBase10_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN IN ('R0012','R0013')"));//金相
- // publicUltraGridDataCJBase10_2.DataTable.AcceptChanges();
- // QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase10_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN IN ('R0012','R0013')"), splitContainer10, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAdd, "PHY_CODE_MIN IN ('R0012','R0013')"));
- //}
- //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 == 2)//其他
- {
- publicUltraGridDataCJBase9_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN NOT IN ('R0023', 'R0024')"));
- publicUltraGridDataCJBase9_2.DataTable.AcceptChanges();
- QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase9_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAdd, "PHY_CODE_MIN NOT IN ('R0023', 'R0024')"), splitContainer9, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAdd, "PHY_CODE_MIN NOT IN ('R0023', 'R0024')"));
- }
- tabIndex = ultraTabControl3.SelectedTab.Index;
- }
- //修改检验委托过程结果JHYGG_PHYLX_PROCESS_RESULT
- 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(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, getCheckConsignDetailArrayList(publicUltraGridDetail2) }, 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
- 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(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();
- 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();
- }
- }
- 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;
- if (ultraTabControl4.SelectedTab.Index == 0)
- {
- publicUltraGridDataCJBase13_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN = 'R0023'"));//拉伸
- //publicUltraGridDataCJBase13_2.DataTable.AcceptChanges();
- QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase13_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN = 'R0023'"), splitContainer13, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAudit, "PHY_CODE_MIN = 'R0023'"));
- }
- else if (ultraTabControl4.SelectedTab.Index == 1)
- {
- publicUltraGridDataCJBase14_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN = 'R0024'"));//冲击
- //publicUltraGridDataCJBase14_2.DataTable.AcceptChanges();
- QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase14_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN = 'R0024'"), splitContainer14, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAudit, "PHY_CODE_MIN = 'R0024'"));
- }
- //else if (ultraTabControl4.SelectedTab.Index == 2)
- //{
- // publicUltraGridDataCJBase15_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN IN ('R0003','R0004','R0005')"));//硬度
- // //publicUltraGridDataCJBase15_2.DataTable.AcceptChanges();
- // QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase15_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN IN ('R0003','R0004','R0005')"), splitContainer15, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAudit, "PHY_CODE_MIN IN ('R0003','R0004','R0005')"));
- //}
- //else if (ultraTabControl4.SelectedTab.Index == 3)//金相
- //{
- // publicUltraGridDataCJBase16_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN IN ('R0012','R0013')"));//金相
- // //publicUltraGridDataCJBase16_2.DataTable.AcceptChanges();
- // QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase16_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN IN ('R0012','R0013')"), splitContainer16, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAudit, "PHY_CODE_MIN IN ('R0012','R0013')"));
- //}
- //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 == 2)//其他
- {
- publicUltraGridDataCJBase15_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN NOT IN ('R0023', 'R0024')"));
- //publicUltraGridDataCJBase15_2.DataTable.AcceptChanges();
- QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase15_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAudit, "PHY_CODE_MIN NOT IN ('R0023', 'R0024')"), splitContainer15, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAudit, "PHY_CODE_MIN NOT IN ('R0023', 'R0024')"));
- }
- //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();
- }
- 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();
- 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();
- 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 = 'R0023'"));//拉伸
- //publicUltraGridDataCJBase19_2.DataTable.AcceptChanges();
- QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase19_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN = 'R0023'"), splitContainer19, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAuditAdd, "PHY_CODE_MIN = 'R0023'"));
- }
- else if (ultraTabControl5.SelectedTab.Index == 1)
- {
- publicUltraGridDataCJBase20_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN = 'R0024'"));//冲击
- //publicUltraGridDataCJBase20_2.DataTable.AcceptChanges();
- QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase20_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN = 'R0024'"), splitContainer20, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAuditAdd, "PHY_CODE_MIN = 'R0024'"));
- }
- //else if (ultraTabControl5.SelectedTab.Index == 2)
- //{
- // publicUltraGridDataCJBase21_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN IN ('R0003','R0004','R0005')"));//硬度
- // //publicUltraGridDataCJBase21_2.DataTable.AcceptChanges();
- // QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase21_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN IN ('R0003','R0004','R0005')"), splitContainer21, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAuditAdd, "PHY_CODE_MIN IN ('R0003','R0004','R0005')"));
- //}
- //else if (ultraTabControl5.SelectedTab.Index == 3)//金相
- //{
- // publicUltraGridDataCJBase22_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN IN ('R0012','R0013')"));//金相
- // //publicUltraGridDataCJBase22_2.DataTable.AcceptChanges();
- // QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase22_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN IN ('R0012','R0013')"), splitContainer22, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAuditAdd, "PHY_CODE_MIN IN ('R0012','R0013')"));
- //}
- //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 == 2)//其他
- {
- publicUltraGridDataCJBase21_2.QueryCheckConsignPhyDetail(PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN NOT IN ('R0023', 'R0024')"));
- //publicUltraGridDataCJBase21_2.DataTable.AcceptChanges();
- QueryCheckMethodPhyConfigItems(publicUltraGridDataCJBase21_1, PublicPipeAndOutdec.GetSelectDt(m_dtPhyMaxAuditAdd, "PHY_CODE_MIN NOT IN ('R0023', 'R0024')"), splitContainer21, PublicPipeAndOutdec.GetSelectDt(m_dtPhyItemsAuditAdd, "PHY_CODE_MIN NOT IN ('R0023', 'R0024')"));
- }
- }
- 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();
- }
- 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 FrmOutdecLabMacDataCJAudit_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;
- }
- }
- }
- }
- }
|