frmLgElements.cs.svn-base 152 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124212521262127212821292130213121322133213421352136213721382139214021412142214321442145214621472148214921502151215221532154215521562157215821592160216121622163216421652166216721682169217021712172217321742175217621772178217921802181218221832184218521862187218821892190219121922193219421952196219721982199220022012202220322042205220622072208220922102211221222132214221522162217221822192220222122222223222422252226222722282229223022312232223322342235223622372238223922402241224222432244224522462247224822492250225122522253225422552256225722582259226022612262226322642265226622672268226922702271227222732274227522762277227822792280228122822283228422852286228722882289229022912292229322942295229622972298229923002301230223032304230523062307230823092310231123122313231423152316231723182319232023212322232323242325232623272328232923302331233223332334233523362337233823392340234123422343234423452346234723482349235023512352235323542355235623572358235923602361236223632364236523662367236823692370237123722373237423752376237723782379238023812382238323842385238623872388238923902391239223932394239523962397239823992400240124022403240424052406240724082409241024112412241324142415241624172418241924202421242224232424242524262427242824292430243124322433243424352436243724382439244024412442244324442445244624472448244924502451245224532454245524562457245824592460246124622463246424652466246724682469247024712472247324742475247624772478247924802481248224832484248524862487248824892490249124922493249424952496249724982499250025012502250325042505250625072508250925102511251225132514251525162517251825192520252125222523252425252526252725282529253025312532253325342535253625372538253925402541254225432544254525462547254825492550255125522553255425552556255725582559256025612562256325642565256625672568256925702571257225732574257525762577257825792580258125822583258425852586258725882589259025912592259325942595259625972598259926002601260226032604260526062607260826092610261126122613261426152616261726182619262026212622262326242625262626272628262926302631263226332634263526362637263826392640264126422643264426452646264726482649265026512652265326542655265626572658265926602661266226632664266526662667266826692670267126722673267426752676267726782679268026812682268326842685268626872688268926902691269226932694269526962697269826992700270127022703270427052706270727082709271027112712271327142715271627172718271927202721272227232724272527262727272827292730273127322733273427352736273727382739274027412742274327442745274627472748274927502751275227532754275527562757275827592760276127622763276427652766276727682769277027712772277327742775277627772778277927802781278227832784278527862787278827892790279127922793279427952796279727982799280028012802280328042805280628072808280928102811281228132814281528162817281828192820282128222823282428252826282728282829283028312832283328342835283628372838283928402841284228432844284528462847284828492850285128522853285428552856285728582859286028612862286328642865286628672868286928702871287228732874287528762877287828792880288128822883288428852886288728882889289028912892289328942895289628972898289929002901290229032904290529062907290829092910291129122913291429152916291729182919292029212922292329242925292629272928292929302931293229332934293529362937293829392940294129422943294429452946294729482949295029512952295329542955295629572958295929602961296229632964296529662967296829692970297129722973297429752976297729782979298029812982298329842985298629872988298929902991299229932994299529962997299829993000300130023003300430053006300730083009301030113012301330143015301630173018301930203021302230233024302530263027302830293030303130323033303430353036303730383039304030413042304330443045304630473048304930503051305230533054305530563057305830593060306130623063306430653066306730683069307030713072307330743075307630773078307930803081308230833084308530863087308830893090309130923093309430953096309730983099310031013102310331043105310631073108310931103111311231133114311531163117311831193120312131223123312431253126312731283129313031313132313331343135313631373138313931403141314231433144314531463147314831493150315131523153315431553156315731583159316031613162316331643165316631673168316931703171317231733174317531763177317831793180318131823183318431853186318731883189319031913192319331943195319631973198319932003201320232033204320532063207320832093210321132123213321432153216321732183219322032213222322332243225322632273228322932303231323232333234323532363237323832393240324132423243324432453246324732483249325032513252325332543255325632573258325932603261326232633264326532663267326832693270327132723273327432753276327732783279328032813282328332843285328632873288328932903291329232933294329532963297329832993300330133023303330433053306330733083309331033113312331333143315331633173318331933203321332233233324332533263327332833293330333133323333333433353336333733383339334033413342334333443345334633473348334933503351335233533354335533563357335833593360336133623363336433653366336733683369337033713372337333743375337633773378337933803381338233833384338533863387338833893390339133923393339433953396339733983399340034013402340334043405340634073408340934103411341234133414341534163417341834193420342134223423342434253426342734283429343034313432343334343435343634373438343934403441344234433444344534463447344834493450345134523453345434553456345734583459346034613462346334643465346634673468346934703471347234733474347534763477347834793480348134823483348434853486348734883489349034913492349334943495349634973498349935003501350235033504350535063507350835093510351135123513351435153516351735183519352035213522352335243525352635273528352935303531353235333534353535363537353835393540354135423543354435453546354735483549355035513552355335543555355635573558
  1. using System;
  2. using System.IO;
  3. using System.Drawing;
  4. using System.Collections;
  5. using System.Diagnostics;
  6. using System.ComponentModel;
  7. using System.Windows.Forms;
  8. using System.Data;
  9. using System.Threading;
  10. using CoreFS.CA06;
  11. using Infragistics.Win.UltraWinMaskedEdit;
  12. using Infragistics.Win.UltraWinGrid;
  13. using Infragistics.Win;
  14. using System.Collections.Generic;
  15. using Core.Mes.Client.Common;
  16. using Core.LgMes.Client.Comm;
  17. using Core.LgMes.Client.lgClassModel.LgChem;
  18. using Core.LgMes.Client.lgClassModel.SqModel;
  19. using System.Data.OracleClient;
  20. namespace Core.LgMes.Client.LgIntegrationQuery
  21. {
  22. /// <summary>
  23. /// ELEMENTS 的摘要说明。
  24. /// </summary>
  25. public class frmLgElements : Core.Mes.Client.Common.frmStyleBase
  26. {
  27. #region " Construct "
  28. private Infragistics.Win.Misc.UltraGroupBox ultraGroupBox1;
  29. private System.Windows.Forms.Label label1;
  30. private System.Windows.Forms.Label label2;
  31. private System.ComponentModel.IContainer components;
  32. private System.Windows.Forms.Label label3;
  33. private System.Windows.Forms.Panel panel1;
  34. private System.Windows.Forms.Label label4;
  35. private System.Windows.Forms.Label label5;
  36. private System.Windows.Forms.Label label6;
  37. private System.Windows.Forms.TextBox txtPage;
  38. private System.Windows.Forms.Button btn_Up;
  39. private System.Windows.Forms.Button btn_Down;
  40. private System.Windows.Forms.Button button3;
  41. private System.Windows.Forms.Label label7;
  42. private System.Windows.Forms.Label label8;
  43. private System.Windows.Forms.CheckBox chkRefresh;
  44. private System.Windows.Forms.Label label9;
  45. public string StrPost = "0";
  46. private Label label11;
  47. private Label label10;
  48. private Infragistics.Win.UltraWinEditors.UltraDateTimeEditor uldtBeginTime;
  49. private Infragistics.Win.UltraWinEditors.UltraDateTimeEditor uldtEndTime;
  50. private UltraMaskedEdit ultraMaskedEdit2;
  51. private Infragistics.Win.UltraWinGrid.ExcelExport.UltraGridExcelExporter GridExcelExporter;
  52. private Infragistics.Win.UltraWinToolbars.UltraToolbarsManager ultraToolbarsManager1;
  53. private UltraGrid EMGrid;
  54. private Infragistics.Win.UltraWinToolbars.UltraToolbarsDockArea _panel1_Toolbars_Dock_Area_Left;
  55. private Infragistics.Win.UltraWinToolbars.UltraToolbarsDockArea _panel1_Toolbars_Dock_Area_Right;
  56. private Infragistics.Win.UltraWinToolbars.UltraToolbarsDockArea _panel1_Toolbars_Dock_Area_Top;
  57. private Infragistics.Win.UltraWinToolbars.UltraToolbarsDockArea _panel1_Toolbars_Dock_Area_Bottom;
  58. private string m_szEntry = "";
  59. private DataSet dataSet1;
  60. private DataTable dataTable1;
  61. private DataColumn dataColumn7;
  62. private DataColumn dataColumn8;
  63. private DataColumn dataColumn9;
  64. private DataColumn dataColumn84;
  65. private DataColumn dataColumn85;
  66. string[] strERow;
  67. private TextBox txtSteel;
  68. private CheckBox chkGasSample; //化学成份列名
  69. string[] strRowName = new string[] { "C", "Mn", "S", "P", "Si", "Als", "Alt", "N", "Ti", "Nb", "B", "V", "Asn", "Sn", "Cu", "Sb", "O", "H", "Bsol", "SAMPLE_DATE1", "CM", "化验时间" };
  70. bool Isbool = false;
  71. private DataColumn dataColumn1;
  72. private Infragistics.Win.UltraWinEditors.UltraComboEditor cmb_BZ;
  73. private Infragistics.Win.UltraWinEditors.UltraComboEditor cboGW;
  74. private Infragistics.Win.UltraWinEditors.UltraComboEditor comboBox2;
  75. private DataColumn dataColumn2;
  76. private DataColumn dataColumn3;
  77. private Infragistics.Win.UltraWinEditors.UltraPictureBox ultraPictureBox1;
  78. private DataColumn dataColumn4;
  79. private DataColumn dataColumn5;
  80. private DataColumn dataColumn6;
  81. private DataColumn dataColumn10;
  82. private DataColumn dataColumn11;
  83. private Button button1;
  84. private DataColumn dataColumn12;
  85. private DataColumn dataColumn13;
  86. private Infragistics.Win.UltraWinGrid.ExcelExport.UltraGridExcelExporter ultraGridExcelExporter1;
  87. private DataColumn dataColumn14;
  88. private DataColumn dataColumn15;
  89. private Button button2;
  90. private UltraMaskedEdit ultraMaskedEdit1;
  91. public frmLgElements(string szPost)
  92. {
  93. InitializeComponent();
  94. this._devPos = szPost;
  95. }
  96. public frmLgElements()
  97. {
  98. //
  99. // Windows 窗体设计器支持所必需的
  100. //
  101. InitializeComponent();
  102. this._devPos = StrPost;
  103. InitSteel();
  104. }
  105. public frmLgElements(string szEntry, string szLH)
  106. {
  107. InitializeComponent();
  108. this._devPos = StrPost;
  109. this.m_szEntry = szEntry;
  110. this.ultraMaskedEdit1.Text = szLH;
  111. }
  112. /// <summary>
  113. /// 初始化Grind牌号
  114. /// </summary>
  115. private void InitSteel()
  116. {
  117. string strErr = "";
  118. EMGrid.DisplayLayout.ValueLists.Add("SteelCode");
  119. DataSet dsSteel = null;//hengxing (DataSet)ClientCommon._RemotingHelp.ExecuteMethod(
  120. // "lgIntegrationQuery",
  121. // "Core.LgMes.Server.lgIntegrationQuery.LgGeneralInfo",
  122. // "GetSteelInfo", new object[] { "where largeflag='1' order by steelcode " }, out strErr);
  123. if (strErr == "" && dsSteel != null)
  124. {
  125. //初始经Grid牌号字段数据集
  126. for (int i = 0; i < dsSteel.Tables[0].Rows.Count; i++)
  127. {
  128. EMGrid.DisplayLayout.ValueLists["SteelCode"].ValueListItems.Add(dsSteel.Tables[0].Rows[i]["SteelCode"].ToString(), dsSteel.Tables[0].Rows[i]["Steel"].ToString());
  129. }
  130. //绑定单位
  131. EMGrid.DisplayLayout.Bands[0].Columns["计划牌号"].ValueList = EMGrid.DisplayLayout.ValueLists["SteelCode"];
  132. }
  133. }
  134. /// <summary>
  135. /// 清理所有正在使用的资源。
  136. /// </summary>
  137. protected override void Dispose(bool disposing)
  138. {
  139. try
  140. {
  141. if (_getDataThread != null)
  142. _getDataThread.Abort();
  143. }
  144. catch { }
  145. if (disposing)
  146. {
  147. if (components != null)
  148. {
  149. components.Dispose();
  150. }
  151. }
  152. base.Dispose(disposing);
  153. }
  154. #region Windows 窗体设计器生成的代码
  155. /// <summary>
  156. /// 设计器支持所需的方法 - 不要使用代码编辑器修改
  157. /// 此方法的内容。
  158. /// </summary>
  159. private void InitializeComponent()
  160. {
  161. this.components = new System.ComponentModel.Container();
  162. Infragistics.Win.UltraWinEditors.EditorButton editorButton1 = new Infragistics.Win.UltraWinEditors.EditorButton("edit");
  163. Infragistics.Win.UltraWinEditors.EditorButton editorButton2 = new Infragistics.Win.UltraWinEditors.EditorButton("clear");
  164. Infragistics.Win.Appearance appearance1 = new Infragistics.Win.Appearance();
  165. Infragistics.Win.ValueListItem valueListItem1 = new Infragistics.Win.ValueListItem();
  166. Infragistics.Win.ValueListItem valueListItem2 = new Infragistics.Win.ValueListItem();
  167. Infragistics.Win.ValueListItem valueListItem3 = new Infragistics.Win.ValueListItem();
  168. Infragistics.Win.ValueListItem valueListItem4 = new Infragistics.Win.ValueListItem();
  169. Infragistics.Win.ValueListItem valueListItem30 = new Infragistics.Win.ValueListItem();
  170. Infragistics.Win.ValueListItem valueListItem31 = new Infragistics.Win.ValueListItem();
  171. Infragistics.Win.ValueListItem valueListItem5 = new Infragistics.Win.ValueListItem();
  172. Infragistics.Win.Appearance appearance2 = new Infragistics.Win.Appearance();
  173. Infragistics.Win.ValueListItem valueListItem6 = new Infragistics.Win.ValueListItem();
  174. Infragistics.Win.ValueListItem valueListItem7 = new Infragistics.Win.ValueListItem();
  175. Infragistics.Win.ValueListItem valueListItem8 = new Infragistics.Win.ValueListItem();
  176. Infragistics.Win.ValueListItem valueListItem9 = new Infragistics.Win.ValueListItem();
  177. Infragistics.Win.ValueListItem valueListItem28 = new Infragistics.Win.ValueListItem();
  178. Infragistics.Win.ValueListItem valueListItem29 = new Infragistics.Win.ValueListItem();
  179. Infragistics.Win.ValueListItem valueListItem10 = new Infragistics.Win.ValueListItem();
  180. Infragistics.Win.Appearance appearance3 = new Infragistics.Win.Appearance();
  181. Infragistics.Win.ValueListItem valueListItem11 = new Infragistics.Win.ValueListItem();
  182. Infragistics.Win.ValueListItem valueListItem12 = new Infragistics.Win.ValueListItem();
  183. Infragistics.Win.ValueListItem valueListItem13 = new Infragistics.Win.ValueListItem();
  184. Infragistics.Win.ValueListItem valueListItem14 = new Infragistics.Win.ValueListItem();
  185. Infragistics.Win.ValueListItem valueListItem15 = new Infragistics.Win.ValueListItem();
  186. Infragistics.Win.UltraWinEditors.EditorButton editorButton3 = new Infragistics.Win.UltraWinEditors.EditorButton("edit");
  187. Infragistics.Win.UltraWinEditors.EditorButton editorButton4 = new Infragistics.Win.UltraWinEditors.EditorButton("clear");
  188. Infragistics.Win.UltraWinGrid.UltraGridBand ultraGridBand1 = new Infragistics.Win.UltraWinGrid.UltraGridBand("Table1", -1);
  189. Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn1 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("序号");
  190. Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn2 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("熔炼号", -1, null, 0, Infragistics.Win.UltraWinGrid.SortIndicator.Ascending, false);
  191. Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn3 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("计划牌号");
  192. Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn4 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("化验时间");
  193. Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn5 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("JHGZ");
  194. Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn6 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("shiftcode", -1, 7905313);
  195. Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn7 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("Station");
  196. Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn8 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("SumTime");
  197. Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn9 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("JUDGE_STL_GRD");
  198. Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn10 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("JUDGE_RESULT");
  199. Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn11 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("REG_ID");
  200. Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn12 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("JUDGE_SEQ");
  201. Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn13 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("SIMN");
  202. Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn14 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("CM");
  203. Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn15 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("SAMPLE_DATE1");
  204. Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn16 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("SHIFTCODE1");
  205. Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn17 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("REMARK");
  206. Infragistics.Win.Appearance appearance6 = new Infragistics.Win.Appearance();
  207. Infragistics.Win.Appearance appearance7 = new Infragistics.Win.Appearance();
  208. Infragistics.Win.ValueList valueList1 = new Infragistics.Win.ValueList(7905313);
  209. Infragistics.Win.ValueListItem valueListItem16 = new Infragistics.Win.ValueListItem();
  210. Infragistics.Win.ValueListItem valueListItem17 = new Infragistics.Win.ValueListItem();
  211. Infragistics.Win.ValueListItem valueListItem18 = new Infragistics.Win.ValueListItem();
  212. Infragistics.Win.ValueListItem valueListItem19 = new Infragistics.Win.ValueListItem();
  213. Infragistics.Win.ValueListItem valueListItem20 = new Infragistics.Win.ValueListItem();
  214. Infragistics.Win.ValueListItem valueListItem21 = new Infragistics.Win.ValueListItem();
  215. Infragistics.Win.ValueListItem valueListItem22 = new Infragistics.Win.ValueListItem();
  216. Infragistics.Win.ValueListItem valueListItem23 = new Infragistics.Win.ValueListItem();
  217. Infragistics.Win.ValueListItem valueListItem24 = new Infragistics.Win.ValueListItem();
  218. Infragistics.Win.ValueListItem valueListItem25 = new Infragistics.Win.ValueListItem();
  219. Infragistics.Win.ValueListItem valueListItem26 = new Infragistics.Win.ValueListItem();
  220. Infragistics.Win.ValueListItem valueListItem27 = new Infragistics.Win.ValueListItem();
  221. Infragistics.Win.UltraWinToolbars.UltraToolbar ultraToolbar1 = new Infragistics.Win.UltraWinToolbars.UltraToolbar("UltraToolbar1");
  222. Infragistics.Win.UltraWinToolbars.ButtonTool buttonTool1 = new Infragistics.Win.UltraWinToolbars.ButtonTool("query");
  223. Infragistics.Win.UltraWinToolbars.ButtonTool buttonTool2 = new Infragistics.Win.UltraWinToolbars.ButtonTool("set");
  224. Infragistics.Win.UltraWinToolbars.ButtonTool buttonTool3 = new Infragistics.Win.UltraWinToolbars.ButtonTool("excel");
  225. Infragistics.Win.UltraWinToolbars.ButtonTool buttonTool4 = new Infragistics.Win.UltraWinToolbars.ButtonTool("SRow");
  226. Infragistics.Win.UltraWinToolbars.ButtonTool buttonTool5 = new Infragistics.Win.UltraWinToolbars.ButtonTool("Close");
  227. Infragistics.Win.UltraWinToolbars.ButtonTool buttonTool6 = new Infragistics.Win.UltraWinToolbars.ButtonTool("query");
  228. Infragistics.Win.UltraWinToolbars.ButtonTool buttonTool7 = new Infragistics.Win.UltraWinToolbars.ButtonTool("set");
  229. Infragistics.Win.UltraWinToolbars.ButtonTool buttonTool8 = new Infragistics.Win.UltraWinToolbars.ButtonTool("excel");
  230. Infragistics.Win.UltraWinToolbars.ButtonTool buttonTool9 = new Infragistics.Win.UltraWinToolbars.ButtonTool("SRow");
  231. Infragistics.Win.UltraWinToolbars.ButtonTool buttonTool10 = new Infragistics.Win.UltraWinToolbars.ButtonTool("Close");
  232. Infragistics.Win.UltraWinToolbars.ButtonTool buttonTool12 = new Infragistics.Win.UltraWinToolbars.ButtonTool("FlushCeq");
  233. this.ultraGroupBox1 = new Infragistics.Win.Misc.UltraGroupBox();
  234. this.button2 = new System.Windows.Forms.Button();
  235. this.button1 = new System.Windows.Forms.Button();
  236. this.ultraMaskedEdit1 = new Infragistics.Win.UltraWinMaskedEdit.UltraMaskedEdit();
  237. this.comboBox2 = new Infragistics.Win.UltraWinEditors.UltraComboEditor();
  238. this.cboGW = new Infragistics.Win.UltraWinEditors.UltraComboEditor();
  239. this.cmb_BZ = new Infragistics.Win.UltraWinEditors.UltraComboEditor();
  240. this.chkGasSample = new System.Windows.Forms.CheckBox();
  241. this.txtSteel = new System.Windows.Forms.TextBox();
  242. this.ultraMaskedEdit2 = new Infragistics.Win.UltraWinMaskedEdit.UltraMaskedEdit();
  243. this.uldtEndTime = new Infragistics.Win.UltraWinEditors.UltraDateTimeEditor();
  244. this.uldtBeginTime = new Infragistics.Win.UltraWinEditors.UltraDateTimeEditor();
  245. this.label11 = new System.Windows.Forms.Label();
  246. this.label10 = new System.Windows.Forms.Label();
  247. this.label9 = new System.Windows.Forms.Label();
  248. this.chkRefresh = new System.Windows.Forms.CheckBox();
  249. this.label8 = new System.Windows.Forms.Label();
  250. this.label7 = new System.Windows.Forms.Label();
  251. this.button3 = new System.Windows.Forms.Button();
  252. this.btn_Down = new System.Windows.Forms.Button();
  253. this.btn_Up = new System.Windows.Forms.Button();
  254. this.txtPage = new System.Windows.Forms.TextBox();
  255. this.label6 = new System.Windows.Forms.Label();
  256. this.label5 = new System.Windows.Forms.Label();
  257. this.label4 = new System.Windows.Forms.Label();
  258. this.label1 = new System.Windows.Forms.Label();
  259. this.panel1 = new System.Windows.Forms.Panel();
  260. this.EMGrid = new Infragistics.Win.UltraWinGrid.UltraGrid();
  261. this.dataSet1 = new System.Data.DataSet();
  262. this.dataTable1 = new System.Data.DataTable();
  263. this.dataColumn7 = new System.Data.DataColumn();
  264. this.dataColumn8 = new System.Data.DataColumn();
  265. this.dataColumn9 = new System.Data.DataColumn();
  266. this.dataColumn84 = new System.Data.DataColumn();
  267. this.dataColumn85 = new System.Data.DataColumn();
  268. this.dataColumn1 = new System.Data.DataColumn();
  269. this.dataColumn2 = new System.Data.DataColumn();
  270. this.dataColumn3 = new System.Data.DataColumn();
  271. this.dataColumn4 = new System.Data.DataColumn();
  272. this.dataColumn5 = new System.Data.DataColumn();
  273. this.dataColumn6 = new System.Data.DataColumn();
  274. this.dataColumn10 = new System.Data.DataColumn();
  275. this.dataColumn11 = new System.Data.DataColumn();
  276. this.dataColumn12 = new System.Data.DataColumn();
  277. this.dataColumn13 = new System.Data.DataColumn();
  278. this.dataColumn14 = new System.Data.DataColumn();
  279. this.dataColumn15 = new System.Data.DataColumn();
  280. this.ultraPictureBox1 = new Infragistics.Win.UltraWinEditors.UltraPictureBox();
  281. this.label3 = new System.Windows.Forms.Label();
  282. this.label2 = new System.Windows.Forms.Label();
  283. this._panel1_Toolbars_Dock_Area_Left = new Infragistics.Win.UltraWinToolbars.UltraToolbarsDockArea();
  284. this.ultraToolbarsManager1 = new Infragistics.Win.UltraWinToolbars.UltraToolbarsManager(this.components);
  285. this._panel1_Toolbars_Dock_Area_Right = new Infragistics.Win.UltraWinToolbars.UltraToolbarsDockArea();
  286. this._panel1_Toolbars_Dock_Area_Top = new Infragistics.Win.UltraWinToolbars.UltraToolbarsDockArea();
  287. this._panel1_Toolbars_Dock_Area_Bottom = new Infragistics.Win.UltraWinToolbars.UltraToolbarsDockArea();
  288. this.ultraGridExcelExporter1 = new Infragistics.Win.UltraWinGrid.ExcelExport.UltraGridExcelExporter(this.components);
  289. ((System.ComponentModel.ISupportInitialize)(this.ultraGroupBox1)).BeginInit();
  290. this.ultraGroupBox1.SuspendLayout();
  291. ((System.ComponentModel.ISupportInitialize)(this.comboBox2)).BeginInit();
  292. ((System.ComponentModel.ISupportInitialize)(this.cboGW)).BeginInit();
  293. ((System.ComponentModel.ISupportInitialize)(this.cmb_BZ)).BeginInit();
  294. ((System.ComponentModel.ISupportInitialize)(this.uldtEndTime)).BeginInit();
  295. ((System.ComponentModel.ISupportInitialize)(this.uldtBeginTime)).BeginInit();
  296. this.panel1.SuspendLayout();
  297. ((System.ComponentModel.ISupportInitialize)(this.EMGrid)).BeginInit();
  298. ((System.ComponentModel.ISupportInitialize)(this.dataSet1)).BeginInit();
  299. ((System.ComponentModel.ISupportInitialize)(this.dataTable1)).BeginInit();
  300. ((System.ComponentModel.ISupportInitialize)(this.ultraToolbarsManager1)).BeginInit();
  301. this.SuspendLayout();
  302. //
  303. // ultraGroupBox1
  304. //
  305. this.ultraGroupBox1.Controls.Add(this.button2);
  306. this.ultraGroupBox1.Controls.Add(this.button1);
  307. this.ultraGroupBox1.Controls.Add(this.ultraMaskedEdit1);
  308. this.ultraGroupBox1.Controls.Add(this.comboBox2);
  309. this.ultraGroupBox1.Controls.Add(this.cboGW);
  310. this.ultraGroupBox1.Controls.Add(this.cmb_BZ);
  311. this.ultraGroupBox1.Controls.Add(this.chkGasSample);
  312. this.ultraGroupBox1.Controls.Add(this.txtSteel);
  313. this.ultraGroupBox1.Controls.Add(this.ultraMaskedEdit2);
  314. this.ultraGroupBox1.Controls.Add(this.uldtEndTime);
  315. this.ultraGroupBox1.Controls.Add(this.uldtBeginTime);
  316. this.ultraGroupBox1.Controls.Add(this.label11);
  317. this.ultraGroupBox1.Controls.Add(this.label10);
  318. this.ultraGroupBox1.Controls.Add(this.label9);
  319. this.ultraGroupBox1.Controls.Add(this.chkRefresh);
  320. this.ultraGroupBox1.Controls.Add(this.label8);
  321. this.ultraGroupBox1.Controls.Add(this.label7);
  322. this.ultraGroupBox1.Controls.Add(this.button3);
  323. this.ultraGroupBox1.Controls.Add(this.btn_Down);
  324. this.ultraGroupBox1.Controls.Add(this.btn_Up);
  325. this.ultraGroupBox1.Controls.Add(this.txtPage);
  326. this.ultraGroupBox1.Controls.Add(this.label6);
  327. this.ultraGroupBox1.Controls.Add(this.label5);
  328. this.ultraGroupBox1.Controls.Add(this.label4);
  329. this.ultraGroupBox1.Controls.Add(this.label1);
  330. this.ultraGroupBox1.Dock = System.Windows.Forms.DockStyle.Top;
  331. this.ultraGroupBox1.Location = new System.Drawing.Point(0, 26);
  332. this.ultraGroupBox1.Name = "ultraGroupBox1";
  333. this.ultraGroupBox1.Size = new System.Drawing.Size(1021, 71);
  334. this.ultraGroupBox1.TabIndex = 3;
  335. //
  336. // button2
  337. //
  338. this.button2.Location = new System.Drawing.Point(914, 9);
  339. this.button2.Name = "button2";
  340. this.button2.Size = new System.Drawing.Size(75, 23);
  341. this.button2.TabIndex = 289;
  342. this.button2.Text = "保存备注";
  343. this.button2.UseVisualStyleBackColor = true;
  344. this.button2.Click += new System.EventHandler(this.button2_Click);
  345. //
  346. // button1
  347. //
  348. this.button1.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(224)))), ((int)(((byte)(192)))));
  349. this.button1.Location = new System.Drawing.Point(594, 9);
  350. this.button1.Name = "button1";
  351. this.button1.Size = new System.Drawing.Size(70, 50);
  352. this.button1.TabIndex = 288;
  353. this.button1.Text = "生成复合元素";
  354. this.button1.UseVisualStyleBackColor = false;
  355. this.button1.Click += new System.EventHandler(this.button1_Click_1);
  356. //
  357. // ultraMaskedEdit1
  358. //
  359. this.ultraMaskedEdit1.BorderStyle = Infragistics.Win.UIElementBorderStyle.Inset;
  360. editorButton1.Key = "edit";
  361. editorButton1.Text = "";
  362. editorButton2.Key = "clear";
  363. this.ultraMaskedEdit1.ButtonsRight.Add(editorButton1);
  364. this.ultraMaskedEdit1.ButtonsRight.Add(editorButton2);
  365. this.ultraMaskedEdit1.EditAs = Infragistics.Win.UltraWinMaskedEdit.EditAsType.String;
  366. this.ultraMaskedEdit1.Location = new System.Drawing.Point(84, 40);
  367. this.ultraMaskedEdit1.Name = "ultraMaskedEdit1";
  368. this.ultraMaskedEdit1.PromptChar = ' ';
  369. this.ultraMaskedEdit1.Size = new System.Drawing.Size(97, 21);
  370. this.ultraMaskedEdit1.TabIndex = 287;
  371. this.ultraMaskedEdit1.UseFlatMode = Infragistics.Win.DefaultableBoolean.True;
  372. this.ultraMaskedEdit1.EditorButtonClick += new Infragistics.Win.UltraWinEditors.EditorButtonEventHandler(this.EditorButtonClick);
  373. //
  374. // comboBox2
  375. //
  376. appearance1.BorderAlpha = Infragistics.Win.Alpha.UseAlphaLevel;
  377. appearance1.BorderColor = System.Drawing.Color.Black;
  378. this.comboBox2.Appearance = appearance1;
  379. this.comboBox2.BorderStyle = Infragistics.Win.UIElementBorderStyle.Solid;
  380. this.comboBox2.DropDownStyle = Infragistics.Win.DropDownStyle.DropDownList;
  381. this.comboBox2.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
  382. valueListItem1.DataValue = "0";
  383. valueListItem1.DisplayText = "铁水";
  384. valueListItem2.DataValue = "1";
  385. valueListItem2.DisplayText = "转炉";
  386. valueListItem3.DataValue = "2";
  387. valueListItem3.DisplayText = "吹氩站";
  388. valueListItem4.DataValue = "3";
  389. valueListItem4.DisplayText = "精炼炉";
  390. valueListItem30.DataValue = "4";
  391. valueListItem30.DisplayText = "RH炉";
  392. valueListItem31.DataValue = "5";
  393. valueListItem31.DisplayText = "VD炉";
  394. valueListItem5.DataValue = "6";
  395. valueListItem5.DisplayText = "连铸";
  396. this.comboBox2.Items.AddRange(new Infragistics.Win.ValueListItem[] {
  397. valueListItem1,
  398. valueListItem2,
  399. valueListItem3,
  400. valueListItem4,
  401. valueListItem30,
  402. valueListItem31,
  403. valueListItem5});
  404. this.comboBox2.Location = new System.Drawing.Point(470, 9);
  405. this.comboBox2.Name = "comboBox2";
  406. this.comboBox2.Size = new System.Drawing.Size(118, 19);
  407. this.comboBox2.TabIndex = 286;
  408. this.comboBox2.UseFlatMode = Infragistics.Win.DefaultableBoolean.True;
  409. //
  410. // cboGW
  411. //
  412. appearance2.BorderAlpha = Infragistics.Win.Alpha.UseAlphaLevel;
  413. appearance2.BorderColor = System.Drawing.Color.Black;
  414. this.cboGW.Appearance = appearance2;
  415. this.cboGW.BorderStyle = Infragistics.Win.UIElementBorderStyle.Solid;
  416. this.cboGW.DropDownStyle = Infragistics.Win.DropDownStyle.DropDownList;
  417. this.cboGW.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
  418. valueListItem6.DataValue = "0";
  419. valueListItem6.DisplayText = "铁水";
  420. valueListItem7.DataValue = "1";
  421. valueListItem7.DisplayText = "转炉";
  422. valueListItem8.DataValue = "2";
  423. valueListItem8.DisplayText = "吹氩站";
  424. valueListItem9.DataValue = "3";
  425. valueListItem9.DisplayText = "精炼炉";
  426. valueListItem28.DataValue = "4";
  427. valueListItem28.DisplayText = "RH炉";
  428. valueListItem29.DataValue = "5";
  429. valueListItem29.DisplayText = "VD炉";
  430. valueListItem10.DataValue = "6";
  431. valueListItem10.DisplayText = "连铸";
  432. this.cboGW.Items.AddRange(new Infragistics.Win.ValueListItem[] {
  433. valueListItem6,
  434. valueListItem7,
  435. valueListItem8,
  436. valueListItem9,
  437. valueListItem28,
  438. valueListItem29,
  439. valueListItem10});
  440. this.cboGW.Location = new System.Drawing.Point(405, 10);
  441. this.cboGW.Name = "cboGW";
  442. this.cboGW.Size = new System.Drawing.Size(56, 19);
  443. this.cboGW.TabIndex = 285;
  444. this.cboGW.UseFlatMode = Infragistics.Win.DefaultableBoolean.True;
  445. this.cboGW.SelectionChanged += new System.EventHandler(this.cboGW_SelectionChanged);
  446. //
  447. // cmb_BZ
  448. //
  449. appearance3.BorderAlpha = Infragistics.Win.Alpha.UseAlphaLevel;
  450. appearance3.BorderColor = System.Drawing.Color.Black;
  451. this.cmb_BZ.Appearance = appearance3;
  452. this.cmb_BZ.BorderStyle = Infragistics.Win.UIElementBorderStyle.Solid;
  453. this.cmb_BZ.DropDownStyle = Infragistics.Win.DropDownStyle.DropDownList;
  454. this.cmb_BZ.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
  455. valueListItem11.DataValue = "0";
  456. valueListItem11.DisplayText = "全部";
  457. valueListItem12.DataValue = "1";
  458. valueListItem12.DisplayText = "甲班";
  459. valueListItem13.DataValue = "2";
  460. valueListItem13.DisplayText = "乙班";
  461. valueListItem14.DataValue = "3";
  462. valueListItem14.DisplayText = "丙班";
  463. valueListItem15.DataValue = "4";
  464. valueListItem15.DisplayText = "丁班";
  465. this.cmb_BZ.Items.AddRange(new Infragistics.Win.ValueListItem[] {
  466. valueListItem11,
  467. valueListItem12,
  468. valueListItem13,
  469. valueListItem14,
  470. valueListItem15});
  471. this.cmb_BZ.Location = new System.Drawing.Point(405, 41);
  472. this.cmb_BZ.Name = "cmb_BZ";
  473. this.cmb_BZ.Size = new System.Drawing.Size(56, 19);
  474. this.cmb_BZ.TabIndex = 284;
  475. this.cmb_BZ.UseFlatMode = Infragistics.Win.DefaultableBoolean.True;
  476. //
  477. // chkGasSample
  478. //
  479. this.chkGasSample.Font = new System.Drawing.Font("宋体", 10.5F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
  480. this.chkGasSample.Location = new System.Drawing.Point(670, 38);
  481. this.chkGasSample.Name = "chkGasSample";
  482. this.chkGasSample.Size = new System.Drawing.Size(82, 24);
  483. this.chkGasSample.TabIndex = 85;
  484. this.chkGasSample.Text = "气体样";
  485. //
  486. // txtSteel
  487. //
  488. this.txtSteel.Location = new System.Drawing.Point(501, 40);
  489. this.txtSteel.Name = "txtSteel";
  490. this.txtSteel.Size = new System.Drawing.Size(87, 21);
  491. this.txtSteel.TabIndex = 84;
  492. //
  493. // ultraMaskedEdit2
  494. //
  495. this.ultraMaskedEdit2.BorderStyle = Infragistics.Win.UIElementBorderStyle.Inset;
  496. editorButton3.Key = "edit";
  497. editorButton3.Text = "";
  498. editorButton4.Key = "clear";
  499. this.ultraMaskedEdit2.ButtonsRight.Add(editorButton3);
  500. this.ultraMaskedEdit2.ButtonsRight.Add(editorButton4);
  501. this.ultraMaskedEdit2.EditAs = Infragistics.Win.UltraWinMaskedEdit.EditAsType.String;
  502. this.ultraMaskedEdit2.Location = new System.Drawing.Point(214, 40);
  503. this.ultraMaskedEdit2.Name = "ultraMaskedEdit2";
  504. this.ultraMaskedEdit2.PromptChar = ' ';
  505. this.ultraMaskedEdit2.Size = new System.Drawing.Size(111, 21);
  506. this.ultraMaskedEdit2.TabIndex = 83;
  507. this.ultraMaskedEdit2.UseFlatMode = Infragistics.Win.DefaultableBoolean.True;
  508. this.ultraMaskedEdit2.EditorButtonClick += new Infragistics.Win.UltraWinEditors.EditorButtonEventHandler(this.EditorButtonClick);
  509. //
  510. // uldtEndTime
  511. //
  512. this.uldtEndTime.FormatProvider = new System.Globalization.CultureInfo("en-US");
  513. this.uldtEndTime.FormatString = "yyyy-MM-dd HH:mm";
  514. this.uldtEndTime.Location = new System.Drawing.Point(214, 9);
  515. this.uldtEndTime.MaskInput = "yyyy-mm-dd hh:mm";
  516. this.uldtEndTime.Name = "uldtEndTime";
  517. this.uldtEndTime.Size = new System.Drawing.Size(111, 21);
  518. this.uldtEndTime.TabIndex = 80;
  519. //
  520. // uldtBeginTime
  521. //
  522. this.uldtBeginTime.FormatProvider = new System.Globalization.CultureInfo("en-US");
  523. this.uldtBeginTime.FormatString = "yyyy-MM-dd HH:mm";
  524. this.uldtBeginTime.Location = new System.Drawing.Point(84, 9);
  525. this.uldtBeginTime.MaskInput = "yyyy-mm-dd hh:mm";
  526. this.uldtBeginTime.Name = "uldtBeginTime";
  527. this.uldtBeginTime.Size = new System.Drawing.Size(97, 21);
  528. this.uldtBeginTime.TabIndex = 79;
  529. //
  530. // label11
  531. //
  532. this.label11.AutoSize = true;
  533. this.label11.Font = new System.Drawing.Font("宋体", 10.5F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
  534. this.label11.Location = new System.Drawing.Point(189, 43);
  535. this.label11.Name = "label11";
  536. this.label11.Size = new System.Drawing.Size(21, 14);
  537. this.label11.TabIndex = 78;
  538. this.label11.Text = "到";
  539. //
  540. // label10
  541. //
  542. this.label10.AutoSize = true;
  543. this.label10.Font = new System.Drawing.Font("宋体", 10.5F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
  544. this.label10.Location = new System.Drawing.Point(189, 12);
  545. this.label10.Name = "label10";
  546. this.label10.Size = new System.Drawing.Size(21, 14);
  547. this.label10.TabIndex = 77;
  548. this.label10.Text = "到";
  549. //
  550. // label9
  551. //
  552. this.label9.AutoSize = true;
  553. this.label9.Font = new System.Drawing.Font("宋体", 10.5F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
  554. this.label9.Location = new System.Drawing.Point(466, 43);
  555. this.label9.Name = "label9";
  556. this.label9.Size = new System.Drawing.Size(35, 14);
  557. this.label9.TabIndex = 72;
  558. this.label9.Text = "牌号";
  559. //
  560. // chkRefresh
  561. //
  562. this.chkRefresh.Font = new System.Drawing.Font("宋体", 10.5F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
  563. this.chkRefresh.Location = new System.Drawing.Point(670, 7);
  564. this.chkRefresh.Name = "chkRefresh";
  565. this.chkRefresh.Size = new System.Drawing.Size(82, 24);
  566. this.chkRefresh.TabIndex = 71;
  567. this.chkRefresh.Text = "自动刷新";
  568. this.chkRefresh.CheckedChanged += new System.EventHandler(this.chkRefresh_CheckedChanged);
  569. //
  570. // label8
  571. //
  572. this.label8.AutoSize = true;
  573. this.label8.Font = new System.Drawing.Font("宋体", 10.5F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
  574. this.label8.Location = new System.Drawing.Point(335, 43);
  575. this.label8.Name = "label8";
  576. this.label8.Size = new System.Drawing.Size(70, 14);
  577. this.label8.TabIndex = 70;
  578. this.label8.Text = "选择班组:";
  579. //
  580. // label7
  581. //
  582. this.label7.AutoSize = true;
  583. this.label7.Font = new System.Drawing.Font("宋体", 10.5F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
  584. this.label7.Location = new System.Drawing.Point(335, 12);
  585. this.label7.Name = "label7";
  586. this.label7.Size = new System.Drawing.Size(70, 14);
  587. this.label7.TabIndex = 68;
  588. this.label7.Text = "工序位置:";
  589. //
  590. // button3
  591. //
  592. this.button3.Font = new System.Drawing.Font("宋体", 10.5F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
  593. this.button3.Location = new System.Drawing.Point(914, 39);
  594. this.button3.Name = "button3";
  595. this.button3.Size = new System.Drawing.Size(72, 23);
  596. this.button3.TabIndex = 58;
  597. this.button3.Text = "全部显示";
  598. this.button3.UseVisualStyleBackColor = false;
  599. this.button3.Click += new System.EventHandler(this.button3_Click);
  600. //
  601. // btn_Down
  602. //
  603. this.btn_Down.Font = new System.Drawing.Font("宋体", 10.5F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
  604. this.btn_Down.Location = new System.Drawing.Point(866, 39);
  605. this.btn_Down.Name = "btn_Down";
  606. this.btn_Down.Size = new System.Drawing.Size(40, 23);
  607. this.btn_Down.TabIndex = 57;
  608. this.btn_Down.Text = ">>";
  609. this.btn_Down.Click += new System.EventHandler(this.btn_Down_Click);
  610. //
  611. // btn_Up
  612. //
  613. this.btn_Up.Font = new System.Drawing.Font("宋体", 10.5F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
  614. this.btn_Up.Location = new System.Drawing.Point(762, 39);
  615. this.btn_Up.Name = "btn_Up";
  616. this.btn_Up.Size = new System.Drawing.Size(40, 23);
  617. this.btn_Up.TabIndex = 56;
  618. this.btn_Up.Text = "<<";
  619. this.btn_Up.Click += new System.EventHandler(this.btn_Up_Click);
  620. //
  621. // txtPage
  622. //
  623. this.txtPage.Location = new System.Drawing.Point(802, 40);
  624. this.txtPage.Name = "txtPage";
  625. this.txtPage.Size = new System.Drawing.Size(64, 21);
  626. this.txtPage.TabIndex = 55;
  627. this.txtPage.Text = "40";
  628. //
  629. // label6
  630. //
  631. this.label6.AutoSize = true;
  632. this.label6.ForeColor = System.Drawing.Color.Red;
  633. this.label6.Location = new System.Drawing.Point(856, 13);
  634. this.label6.Name = "label6";
  635. this.label6.Size = new System.Drawing.Size(0, 12);
  636. this.label6.TabIndex = 54;
  637. //
  638. // label5
  639. //
  640. this.label5.AutoSize = true;
  641. this.label5.Font = new System.Drawing.Font("宋体", 10.5F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
  642. this.label5.Location = new System.Drawing.Point(760, 12);
  643. this.label5.Name = "label5";
  644. this.label5.Size = new System.Drawing.Size(98, 14);
  645. this.label5.TabIndex = 52;
  646. this.label5.Text = "当前数据显示:";
  647. //
  648. // label4
  649. //
  650. this.label4.AutoSize = true;
  651. this.label4.Font = new System.Drawing.Font("宋体", 10.5F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
  652. this.label4.Location = new System.Drawing.Point(21, 43);
  653. this.label4.Name = "label4";
  654. this.label4.Size = new System.Drawing.Size(63, 14);
  655. this.label4.TabIndex = 48;
  656. this.label4.Text = "熔炼号从";
  657. //
  658. // label1
  659. //
  660. this.label1.AutoSize = true;
  661. this.label1.Font = new System.Drawing.Font("宋体", 10.5F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
  662. this.label1.Location = new System.Drawing.Point(7, 12);
  663. this.label1.Name = "label1";
  664. this.label1.Size = new System.Drawing.Size(77, 14);
  665. this.label1.TabIndex = 15;
  666. this.label1.Text = "化验时间从";
  667. //
  668. // panel1
  669. //
  670. this.panel1.Controls.Add(this.EMGrid);
  671. this.panel1.Controls.Add(this.ultraPictureBox1);
  672. this.panel1.Controls.Add(this.label3);
  673. this.panel1.Controls.Add(this.label2);
  674. this.panel1.Controls.Add(this.ultraGroupBox1);
  675. this.panel1.Controls.Add(this._panel1_Toolbars_Dock_Area_Left);
  676. this.panel1.Controls.Add(this._panel1_Toolbars_Dock_Area_Right);
  677. this.panel1.Controls.Add(this._panel1_Toolbars_Dock_Area_Top);
  678. this.panel1.Controls.Add(this._panel1_Toolbars_Dock_Area_Bottom);
  679. this.panel1.Dock = System.Windows.Forms.DockStyle.Fill;
  680. this.panel1.Location = new System.Drawing.Point(0, 0);
  681. this.panel1.Name = "panel1";
  682. this.panel1.Size = new System.Drawing.Size(1021, 513);
  683. this.panel1.TabIndex = 12;
  684. //
  685. // EMGrid
  686. //
  687. this.EMGrid.DataMember = "Table1";
  688. this.EMGrid.DataSource = this.dataSet1;
  689. ultraGridColumn1.Header.VisiblePosition = 0;
  690. ultraGridColumn1.Hidden = true;
  691. ultraGridColumn1.RowLayoutColumnInfo.OriginX = 0;
  692. ultraGridColumn1.RowLayoutColumnInfo.OriginY = 0;
  693. ultraGridColumn1.RowLayoutColumnInfo.SpanX = 1;
  694. ultraGridColumn1.RowLayoutColumnInfo.SpanY = 1;
  695. ultraGridColumn1.Width = 54;
  696. ultraGridColumn2.Header.Caption = "炉号";
  697. ultraGridColumn2.Header.VisiblePosition = 1;
  698. ultraGridColumn2.RowLayoutColumnInfo.OriginX = 0;
  699. ultraGridColumn2.RowLayoutColumnInfo.OriginY = 0;
  700. ultraGridColumn2.RowLayoutColumnInfo.SpanX = 1;
  701. ultraGridColumn2.RowLayoutColumnInfo.SpanY = 1;
  702. ultraGridColumn2.Width = 179;
  703. ultraGridColumn3.Header.VisiblePosition = 5;
  704. ultraGridColumn3.RowLayoutColumnInfo.OriginX = 4;
  705. ultraGridColumn3.RowLayoutColumnInfo.OriginY = 0;
  706. ultraGridColumn3.RowLayoutColumnInfo.SpanX = 1;
  707. ultraGridColumn3.RowLayoutColumnInfo.SpanY = 1;
  708. ultraGridColumn3.Width = 116;
  709. ultraGridColumn4.Header.VisiblePosition = 6;
  710. ultraGridColumn4.RowLayoutColumnInfo.OriginX = 100;
  711. ultraGridColumn4.RowLayoutColumnInfo.OriginY = 0;
  712. ultraGridColumn4.RowLayoutColumnInfo.SpanX = 1;
  713. ultraGridColumn4.RowLayoutColumnInfo.SpanY = 1;
  714. ultraGridColumn4.Width = 160;
  715. ultraGridColumn5.Header.VisiblePosition = 13;
  716. ultraGridColumn5.Hidden = true;
  717. ultraGridColumn5.RowLayoutColumnInfo.OriginX = 6;
  718. ultraGridColumn5.RowLayoutColumnInfo.OriginY = 0;
  719. ultraGridColumn5.RowLayoutColumnInfo.SpanX = 1;
  720. ultraGridColumn5.RowLayoutColumnInfo.SpanY = 1;
  721. ultraGridColumn6.Header.VisiblePosition = 4;
  722. ultraGridColumn6.RowLayoutColumnInfo.OriginX = 3;
  723. ultraGridColumn6.RowLayoutColumnInfo.OriginY = 0;
  724. ultraGridColumn6.RowLayoutColumnInfo.SpanX = 1;
  725. ultraGridColumn6.RowLayoutColumnInfo.SpanY = 1;
  726. ultraGridColumn6.Width = 53;
  727. ultraGridColumn7.CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
  728. ultraGridColumn7.Header.VisiblePosition = 2;
  729. ultraGridColumn7.RowLayoutColumnInfo.OriginX = 1;
  730. ultraGridColumn7.RowLayoutColumnInfo.OriginY = 0;
  731. ultraGridColumn7.RowLayoutColumnInfo.SpanX = 1;
  732. ultraGridColumn7.RowLayoutColumnInfo.SpanY = 1;
  733. ultraGridColumn7.Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDown;
  734. ultraGridColumn7.Width = 66;
  735. ultraGridColumn8.Header.VisiblePosition = 3;
  736. ultraGridColumn8.RowLayoutColumnInfo.OriginX = 2;
  737. ultraGridColumn8.RowLayoutColumnInfo.OriginY = 0;
  738. ultraGridColumn8.RowLayoutColumnInfo.SpanX = 1;
  739. ultraGridColumn8.RowLayoutColumnInfo.SpanY = 1;
  740. ultraGridColumn8.Width = 40;
  741. ultraGridColumn9.CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
  742. ultraGridColumn9.Header.VisiblePosition = 7;
  743. ultraGridColumn9.RowLayoutColumnInfo.OriginX = 6;
  744. ultraGridColumn9.RowLayoutColumnInfo.OriginY = 0;
  745. ultraGridColumn9.RowLayoutColumnInfo.SpanX = 1;
  746. ultraGridColumn9.RowLayoutColumnInfo.SpanY = 1;
  747. ultraGridColumn10.CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
  748. ultraGridColumn10.Header.VisiblePosition = 8;
  749. ultraGridColumn10.RowLayoutColumnInfo.OriginX = 7;
  750. ultraGridColumn10.RowLayoutColumnInfo.OriginY = 0;
  751. ultraGridColumn10.RowLayoutColumnInfo.SpanX = 1;
  752. ultraGridColumn10.RowLayoutColumnInfo.SpanY = 1;
  753. ultraGridColumn11.CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
  754. ultraGridColumn11.Header.VisiblePosition = 12;
  755. ultraGridColumn11.Hidden = true;
  756. ultraGridColumn11.RowLayoutColumnInfo.OriginX = 13;
  757. ultraGridColumn11.RowLayoutColumnInfo.OriginY = 0;
  758. ultraGridColumn11.RowLayoutColumnInfo.SpanX = 1;
  759. ultraGridColumn11.RowLayoutColumnInfo.SpanY = 1;
  760. ultraGridColumn12.Header.VisiblePosition = 14;
  761. ultraGridColumn12.Hidden = true;
  762. ultraGridColumn12.RowLayoutColumnInfo.OriginX = 13;
  763. ultraGridColumn12.RowLayoutColumnInfo.OriginY = 0;
  764. ultraGridColumn12.RowLayoutColumnInfo.SpanX = 1;
  765. ultraGridColumn12.RowLayoutColumnInfo.SpanY = 1;
  766. ultraGridColumn13.Header.VisiblePosition = 9;
  767. ultraGridColumn13.RowLayoutColumnInfo.OriginX = 8;
  768. ultraGridColumn13.RowLayoutColumnInfo.OriginY = 0;
  769. ultraGridColumn13.RowLayoutColumnInfo.PreferredCellSize = new System.Drawing.Size(70, 0);
  770. ultraGridColumn13.RowLayoutColumnInfo.SpanX = 1;
  771. ultraGridColumn13.RowLayoutColumnInfo.SpanY = 1;
  772. ultraGridColumn14.Header.VisiblePosition = 10;
  773. ultraGridColumn14.Hidden = true;
  774. ultraGridColumn14.RowLayoutColumnInfo.OriginX = 9;
  775. ultraGridColumn14.RowLayoutColumnInfo.OriginY = 0;
  776. ultraGridColumn14.RowLayoutColumnInfo.PreferredCellSize = new System.Drawing.Size(70, 0);
  777. ultraGridColumn14.RowLayoutColumnInfo.PreferredLabelSize = new System.Drawing.Size(30, 0);
  778. ultraGridColumn14.RowLayoutColumnInfo.SpanX = 1;
  779. ultraGridColumn14.RowLayoutColumnInfo.SpanY = 1;
  780. ultraGridColumn15.Header.VisiblePosition = 11;
  781. ultraGridColumn15.Hidden = true;
  782. ultraGridColumn15.RowLayoutColumnInfo.OriginX = 10;
  783. ultraGridColumn15.RowLayoutColumnInfo.OriginY = 0;
  784. ultraGridColumn15.RowLayoutColumnInfo.PreferredCellSize = new System.Drawing.Size(160, 0);
  785. ultraGridColumn15.RowLayoutColumnInfo.SpanX = 1;
  786. ultraGridColumn15.RowLayoutColumnInfo.SpanY = 1;
  787. ultraGridColumn16.Header.Caption = "检测班组";
  788. ultraGridColumn16.Header.VisiblePosition = 15;
  789. ultraGridColumn16.Hidden = true;
  790. ultraGridColumn16.RowLayoutColumnInfo.OriginX = 11;
  791. ultraGridColumn16.RowLayoutColumnInfo.OriginY = 0;
  792. ultraGridColumn16.RowLayoutColumnInfo.SpanX = 1;
  793. ultraGridColumn16.RowLayoutColumnInfo.SpanY = 1;
  794. ultraGridColumn17.Header.Caption = "检测备注";
  795. ultraGridColumn17.Header.VisiblePosition = 16;
  796. ultraGridColumn17.Hidden = true;
  797. ultraGridColumn17.RowLayoutColumnInfo.OriginX = 12;
  798. ultraGridColumn17.RowLayoutColumnInfo.OriginY = 0;
  799. ultraGridColumn17.RowLayoutColumnInfo.SpanX = 1;
  800. ultraGridColumn17.RowLayoutColumnInfo.SpanY = 1;
  801. ultraGridColumn17.Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDown;
  802. ultraGridBand1.Columns.AddRange(new object[] {
  803. ultraGridColumn1,
  804. ultraGridColumn2,
  805. ultraGridColumn3,
  806. ultraGridColumn4,
  807. ultraGridColumn5,
  808. ultraGridColumn6,
  809. ultraGridColumn7,
  810. ultraGridColumn8,
  811. ultraGridColumn9,
  812. ultraGridColumn10,
  813. ultraGridColumn11,
  814. ultraGridColumn12,
  815. ultraGridColumn13,
  816. ultraGridColumn14,
  817. ultraGridColumn15,
  818. ultraGridColumn16,
  819. ultraGridColumn17});
  820. ultraGridBand1.RowLayoutStyle = Infragistics.Win.UltraWinGrid.RowLayoutStyle.ColumnLayout;
  821. this.EMGrid.DisplayLayout.BandsSerializer.Add(ultraGridBand1);
  822. this.EMGrid.DisplayLayout.GroupByBox.Hidden = true;
  823. appearance6.FontData.BoldAsString = "True";
  824. appearance6.FontData.SizeInPoints = 10F;
  825. this.EMGrid.DisplayLayout.Override.CellAppearance = appearance6;
  826. appearance7.FontData.BoldAsString = "True";
  827. this.EMGrid.DisplayLayout.Override.HeaderAppearance = appearance7;
  828. this.EMGrid.DisplayLayout.Override.HeaderClickAction = Infragistics.Win.UltraWinGrid.HeaderClickAction.SortMulti;
  829. this.EMGrid.DisplayLayout.Override.WrapHeaderText = Infragistics.Win.DefaultableBoolean.True;
  830. valueListItem16.DataValue = "11";
  831. valueListItem16.DisplayText = "白-甲";
  832. valueListItem17.DataValue = "12";
  833. valueListItem17.DisplayText = "白-乙";
  834. valueListItem18.DataValue = "13";
  835. valueListItem18.DisplayText = "白-丙";
  836. valueListItem19.DataValue = "14";
  837. valueListItem19.DisplayText = "白-丁";
  838. valueListItem20.DataValue = "21";
  839. valueListItem20.DisplayText = "中-甲";
  840. valueListItem21.DataValue = "22";
  841. valueListItem21.DisplayText = "中-乙";
  842. valueListItem22.DataValue = "23";
  843. valueListItem22.DisplayText = "中-丙";
  844. valueListItem23.DataValue = "24";
  845. valueListItem23.DisplayText = "中-丁";
  846. valueListItem24.DataValue = "31";
  847. valueListItem24.DisplayText = "夜-甲";
  848. valueListItem25.DataValue = "32";
  849. valueListItem25.DisplayText = "夜-乙";
  850. valueListItem26.DataValue = "33";
  851. valueListItem26.DisplayText = "夜-丙";
  852. valueListItem27.DataValue = "34";
  853. valueListItem27.DisplayText = "夜-丁";
  854. valueList1.ValueListItems.AddRange(new Infragistics.Win.ValueListItem[] {
  855. valueListItem16,
  856. valueListItem17,
  857. valueListItem18,
  858. valueListItem19,
  859. valueListItem20,
  860. valueListItem21,
  861. valueListItem22,
  862. valueListItem23,
  863. valueListItem24,
  864. valueListItem25,
  865. valueListItem26,
  866. valueListItem27});
  867. this.EMGrid.DisplayLayout.ValueLists.AddRange(new Infragistics.Win.ValueList[] {
  868. valueList1});
  869. this.EMGrid.Dock = System.Windows.Forms.DockStyle.Fill;
  870. this.EMGrid.Font = new System.Drawing.Font("Tahoma", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
  871. this.EMGrid.Location = new System.Drawing.Point(0, 97);
  872. this.EMGrid.Name = "EMGrid";
  873. this.EMGrid.Size = new System.Drawing.Size(1021, 416);
  874. this.EMGrid.TabIndex = 6;
  875. this.EMGrid.DoubleClickRow += new Infragistics.Win.UltraWinGrid.DoubleClickRowEventHandler(this.EMGrid_DoubleClickRow);
  876. this.EMGrid.Click += new System.EventHandler(this.EMGrid_Click);
  877. //
  878. // dataSet1
  879. //
  880. this.dataSet1.DataSetName = "NewDataSet";
  881. this.dataSet1.Locale = new System.Globalization.CultureInfo("zh-CN");
  882. this.dataSet1.Tables.AddRange(new System.Data.DataTable[] {
  883. this.dataTable1});
  884. //
  885. // dataTable1
  886. //
  887. this.dataTable1.Columns.AddRange(new System.Data.DataColumn[] {
  888. this.dataColumn7,
  889. this.dataColumn8,
  890. this.dataColumn9,
  891. this.dataColumn84,
  892. this.dataColumn85,
  893. this.dataColumn1,
  894. this.dataColumn2,
  895. this.dataColumn3,
  896. this.dataColumn4,
  897. this.dataColumn5,
  898. this.dataColumn6,
  899. this.dataColumn10,
  900. this.dataColumn11,
  901. this.dataColumn12,
  902. this.dataColumn13,
  903. this.dataColumn14,
  904. this.dataColumn15});
  905. this.dataTable1.TableName = "Table1";
  906. //
  907. // dataColumn7
  908. //
  909. this.dataColumn7.ColumnName = "序号";
  910. //
  911. // dataColumn8
  912. //
  913. this.dataColumn8.ColumnName = "熔炼号";
  914. //
  915. // dataColumn9
  916. //
  917. this.dataColumn9.ColumnName = "计划牌号";
  918. //
  919. // dataColumn84
  920. //
  921. this.dataColumn84.ColumnName = "化验时间";
  922. //
  923. // dataColumn85
  924. //
  925. this.dataColumn85.Caption = "牌号编码";
  926. this.dataColumn85.ColumnName = "JHGZ";
  927. //
  928. // dataColumn1
  929. //
  930. this.dataColumn1.Caption = "班别";
  931. this.dataColumn1.ColumnName = "shiftcode";
  932. //
  933. // dataColumn2
  934. //
  935. this.dataColumn2.Caption = "工序";
  936. this.dataColumn2.ColumnName = "Station";
  937. //
  938. // dataColumn3
  939. //
  940. this.dataColumn3.Caption = "次数";
  941. this.dataColumn3.ColumnName = "SumTime";
  942. //
  943. // dataColumn4
  944. //
  945. this.dataColumn4.Caption = "判定牌号";
  946. this.dataColumn4.ColumnName = "JUDGE_STL_GRD";
  947. //
  948. // dataColumn5
  949. //
  950. this.dataColumn5.Caption = "判定结果";
  951. this.dataColumn5.ColumnName = "JUDGE_RESULT";
  952. //
  953. // dataColumn6
  954. //
  955. this.dataColumn6.Caption = "判定人";
  956. this.dataColumn6.ColumnName = "REG_ID";
  957. //
  958. // dataColumn10
  959. //
  960. this.dataColumn10.Caption = "次数";
  961. this.dataColumn10.ColumnName = "JUDGE_SEQ";
  962. //
  963. // dataColumn11
  964. //
  965. this.dataColumn11.Caption = "MN/S";
  966. this.dataColumn11.ColumnName = "SIMN";
  967. //
  968. // dataColumn12
  969. //
  970. this.dataColumn12.Caption = "时间差(分钟)";
  971. this.dataColumn12.ColumnName = "CM";
  972. //
  973. // dataColumn13
  974. //
  975. this.dataColumn13.Caption = "送样时间";
  976. this.dataColumn13.ColumnName = "SAMPLE_DATE1";
  977. //
  978. // dataColumn14
  979. //
  980. this.dataColumn14.Caption = "检查班组";
  981. this.dataColumn14.ColumnName = "SHIFTCODE1";
  982. //
  983. // dataColumn15
  984. //
  985. this.dataColumn15.Caption = "检查备注";
  986. this.dataColumn15.ColumnName = "REMARK";
  987. //
  988. // ultraPictureBox1
  989. //
  990. this.ultraPictureBox1.BorderShadowColor = System.Drawing.Color.Empty;
  991. this.ultraPictureBox1.Location = new System.Drawing.Point(339, 286);
  992. this.ultraPictureBox1.Name = "ultraPictureBox1";
  993. this.ultraPictureBox1.Size = new System.Drawing.Size(100, 50);
  994. this.ultraPictureBox1.TabIndex = 16;
  995. //
  996. // label3
  997. //
  998. this.label3.BackColor = System.Drawing.Color.Blue;
  999. this.label3.ForeColor = System.Drawing.SystemColors.ControlText;
  1000. this.label3.Location = new System.Drawing.Point(564, 271);
  1001. this.label3.Name = "label3";
  1002. this.label3.Size = new System.Drawing.Size(100, 23);
  1003. this.label3.TabIndex = 11;
  1004. this.label3.Text = "label3";
  1005. this.label3.Visible = false;
  1006. //
  1007. // label2
  1008. //
  1009. this.label2.BackColor = System.Drawing.Color.Red;
  1010. this.label2.Location = new System.Drawing.Point(458, 230);
  1011. this.label2.Name = "label2";
  1012. this.label2.Size = new System.Drawing.Size(100, 23);
  1013. this.label2.TabIndex = 6;
  1014. this.label2.Text = "label2";
  1015. this.label2.Visible = false;
  1016. //
  1017. // _panel1_Toolbars_Dock_Area_Left
  1018. //
  1019. this._panel1_Toolbars_Dock_Area_Left.AccessibleRole = System.Windows.Forms.AccessibleRole.Grouping;
  1020. this._panel1_Toolbars_Dock_Area_Left.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(229)))), ((int)(((byte)(229)))), ((int)(((byte)(215)))));
  1021. this._panel1_Toolbars_Dock_Area_Left.DockedPosition = Infragistics.Win.UltraWinToolbars.DockedPosition.Left;
  1022. this._panel1_Toolbars_Dock_Area_Left.ForeColor = System.Drawing.SystemColors.ControlText;
  1023. this._panel1_Toolbars_Dock_Area_Left.Location = new System.Drawing.Point(0, 26);
  1024. this._panel1_Toolbars_Dock_Area_Left.Name = "_panel1_Toolbars_Dock_Area_Left";
  1025. this._panel1_Toolbars_Dock_Area_Left.Size = new System.Drawing.Size(0, 487);
  1026. this._panel1_Toolbars_Dock_Area_Left.ToolbarsManager = this.ultraToolbarsManager1;
  1027. //
  1028. // ultraToolbarsManager1
  1029. //
  1030. this.ultraToolbarsManager1.DesignerFlags = 1;
  1031. this.ultraToolbarsManager1.DockWithinContainer = this.panel1;
  1032. this.ultraToolbarsManager1.LockToolbars = true;
  1033. this.ultraToolbarsManager1.ShowFullMenusDelay = 500;
  1034. this.ultraToolbarsManager1.ShowQuickCustomizeButton = false;
  1035. this.ultraToolbarsManager1.Style = Infragistics.Win.UltraWinToolbars.ToolbarStyle.VisualStudio2005;
  1036. ultraToolbar1.DockedColumn = 0;
  1037. ultraToolbar1.DockedRow = 0;
  1038. buttonTool1.InstanceProps.IsFirstInGroup = true;
  1039. buttonTool2.InstanceProps.IsFirstInGroup = true;
  1040. buttonTool4.InstanceProps.IsFirstInGroup = true;
  1041. buttonTool5.InstanceProps.IsFirstInGroup = true;
  1042. ultraToolbar1.NonInheritedTools.AddRange(new Infragistics.Win.UltraWinToolbars.ToolBase[] {
  1043. buttonTool1,
  1044. buttonTool2,
  1045. buttonTool3,
  1046. buttonTool4,
  1047. buttonTool5});
  1048. ultraToolbar1.Text = "UltraToolbar1";
  1049. this.ultraToolbarsManager1.Toolbars.AddRange(new Infragistics.Win.UltraWinToolbars.UltraToolbar[] {
  1050. ultraToolbar1});
  1051. buttonTool6.SharedPropsInternal.Caption = "查询(&Q)";
  1052. buttonTool6.SharedPropsInternal.DisplayStyle = Infragistics.Win.UltraWinToolbars.ToolDisplayStyle.ImageAndText;
  1053. buttonTool7.SharedPropsInternal.Caption = "设置样点(&S)";
  1054. buttonTool7.SharedPropsInternal.DisplayStyle = Infragistics.Win.UltraWinToolbars.ToolDisplayStyle.ImageAndText;
  1055. buttonTool8.SharedPropsInternal.Caption = "导出(&P)";
  1056. buttonTool8.SharedPropsInternal.DisplayStyle = Infragistics.Win.UltraWinToolbars.ToolDisplayStyle.ImageAndText;
  1057. buttonTool9.SharedPropsInternal.Caption = "设置列(&R)";
  1058. buttonTool9.SharedPropsInternal.DisplayStyle = Infragistics.Win.UltraWinToolbars.ToolDisplayStyle.ImageAndText;
  1059. buttonTool10.SharedPropsInternal.Caption = "关闭(&C)";
  1060. buttonTool10.SharedPropsInternal.DisplayStyle = Infragistics.Win.UltraWinToolbars.ToolDisplayStyle.ImageAndText;
  1061. buttonTool12.SharedPropsInternal.Caption = "刷新复合元素";
  1062. buttonTool12.SharedPropsInternal.DisplayStyle = Infragistics.Win.UltraWinToolbars.ToolDisplayStyle.ImageAndText;
  1063. this.ultraToolbarsManager1.Tools.AddRange(new Infragistics.Win.UltraWinToolbars.ToolBase[] {
  1064. buttonTool6,
  1065. buttonTool7,
  1066. buttonTool8,
  1067. buttonTool9,
  1068. buttonTool10,
  1069. buttonTool12});
  1070. this.ultraToolbarsManager1.Visible = false;
  1071. this.ultraToolbarsManager1.ToolClick += new Infragistics.Win.UltraWinToolbars.ToolClickEventHandler(this.ultraToolbarsManager1_ToolClick);
  1072. //
  1073. // _panel1_Toolbars_Dock_Area_Right
  1074. //
  1075. this._panel1_Toolbars_Dock_Area_Right.AccessibleRole = System.Windows.Forms.AccessibleRole.Grouping;
  1076. this._panel1_Toolbars_Dock_Area_Right.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(229)))), ((int)(((byte)(229)))), ((int)(((byte)(215)))));
  1077. this._panel1_Toolbars_Dock_Area_Right.DockedPosition = Infragistics.Win.UltraWinToolbars.DockedPosition.Right;
  1078. this._panel1_Toolbars_Dock_Area_Right.ForeColor = System.Drawing.SystemColors.ControlText;
  1079. this._panel1_Toolbars_Dock_Area_Right.Location = new System.Drawing.Point(1021, 26);
  1080. this._panel1_Toolbars_Dock_Area_Right.Name = "_panel1_Toolbars_Dock_Area_Right";
  1081. this._panel1_Toolbars_Dock_Area_Right.Size = new System.Drawing.Size(0, 487);
  1082. this._panel1_Toolbars_Dock_Area_Right.ToolbarsManager = this.ultraToolbarsManager1;
  1083. //
  1084. // _panel1_Toolbars_Dock_Area_Top
  1085. //
  1086. this._panel1_Toolbars_Dock_Area_Top.AccessibleRole = System.Windows.Forms.AccessibleRole.Grouping;
  1087. this._panel1_Toolbars_Dock_Area_Top.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(229)))), ((int)(((byte)(229)))), ((int)(((byte)(215)))));
  1088. this._panel1_Toolbars_Dock_Area_Top.DockedPosition = Infragistics.Win.UltraWinToolbars.DockedPosition.Top;
  1089. this._panel1_Toolbars_Dock_Area_Top.ForeColor = System.Drawing.SystemColors.ControlText;
  1090. this._panel1_Toolbars_Dock_Area_Top.Location = new System.Drawing.Point(0, 0);
  1091. this._panel1_Toolbars_Dock_Area_Top.Name = "_panel1_Toolbars_Dock_Area_Top";
  1092. this._panel1_Toolbars_Dock_Area_Top.Size = new System.Drawing.Size(1021, 26);
  1093. this._panel1_Toolbars_Dock_Area_Top.ToolbarsManager = this.ultraToolbarsManager1;
  1094. //
  1095. // _panel1_Toolbars_Dock_Area_Bottom
  1096. //
  1097. this._panel1_Toolbars_Dock_Area_Bottom.AccessibleRole = System.Windows.Forms.AccessibleRole.Grouping;
  1098. this._panel1_Toolbars_Dock_Area_Bottom.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(229)))), ((int)(((byte)(229)))), ((int)(((byte)(215)))));
  1099. this._panel1_Toolbars_Dock_Area_Bottom.DockedPosition = Infragistics.Win.UltraWinToolbars.DockedPosition.Bottom;
  1100. this._panel1_Toolbars_Dock_Area_Bottom.ForeColor = System.Drawing.SystemColors.ControlText;
  1101. this._panel1_Toolbars_Dock_Area_Bottom.Location = new System.Drawing.Point(0, 513);
  1102. this._panel1_Toolbars_Dock_Area_Bottom.Name = "_panel1_Toolbars_Dock_Area_Bottom";
  1103. this._panel1_Toolbars_Dock_Area_Bottom.Size = new System.Drawing.Size(1021, 0);
  1104. this._panel1_Toolbars_Dock_Area_Bottom.ToolbarsManager = this.ultraToolbarsManager1;
  1105. //
  1106. // frmLgElements
  1107. //
  1108. this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 12F);
  1109. this.ClientSize = new System.Drawing.Size(1021, 513);
  1110. this.Controls.Add(this.panel1);
  1111. this.Name = "frmLgElements";
  1112. this.StatusCustomInfo = "F1:用户视图 F2:表格拖选统计";
  1113. this.Text = " ";
  1114. this.Load += new System.EventHandler(this.ELEMENTS_Load);
  1115. ((System.ComponentModel.ISupportInitialize)(this.ultraGroupBox1)).EndInit();
  1116. this.ultraGroupBox1.ResumeLayout(false);
  1117. this.ultraGroupBox1.PerformLayout();
  1118. ((System.ComponentModel.ISupportInitialize)(this.comboBox2)).EndInit();
  1119. ((System.ComponentModel.ISupportInitialize)(this.cboGW)).EndInit();
  1120. ((System.ComponentModel.ISupportInitialize)(this.cmb_BZ)).EndInit();
  1121. ((System.ComponentModel.ISupportInitialize)(this.uldtEndTime)).EndInit();
  1122. ((System.ComponentModel.ISupportInitialize)(this.uldtBeginTime)).EndInit();
  1123. this.panel1.ResumeLayout(false);
  1124. ((System.ComponentModel.ISupportInitialize)(this.EMGrid)).EndInit();
  1125. ((System.ComponentModel.ISupportInitialize)(this.dataSet1)).EndInit();
  1126. ((System.ComponentModel.ISupportInitialize)(this.dataTable1)).EndInit();
  1127. ((System.ComponentModel.ISupportInitialize)(this.ultraToolbarsManager1)).EndInit();
  1128. this.ResumeLayout(false);
  1129. }
  1130. #endregion
  1131. #endregion
  1132. public int sValue(string Svalue, string SCHvalue)
  1133. {
  1134. if (SCHvalue.Length < 1)
  1135. {
  1136. return 0;
  1137. }
  1138. if (Svalue.Length > 0)
  1139. {
  1140. string BValue = "-1";
  1141. string EValue = "-1";
  1142. if (Svalue.IndexOf("~") > 0)
  1143. {
  1144. BValue = Svalue.Substring(0, Svalue.IndexOf("~"));
  1145. EValue = Svalue.Substring(Svalue.IndexOf("~") + 1, Svalue.Length - Svalue.IndexOf("~") - 1);
  1146. if (double.Parse(SCHvalue) >= double.Parse(BValue) && double.Parse(SCHvalue) <= double.Parse(EValue))
  1147. {
  1148. return 0; //正确
  1149. }
  1150. else
  1151. {
  1152. return -1;
  1153. }
  1154. }
  1155. else
  1156. {
  1157. if (Svalue.IndexOf("<=") > -1)
  1158. {
  1159. EValue = Svalue.Substring(Svalue.IndexOf("<=") + 2, Svalue.Length - Svalue.IndexOf("<=") - 2);
  1160. if (double.Parse(SCHvalue) <= double.Parse(EValue))
  1161. {
  1162. return 0; //正确
  1163. }
  1164. else
  1165. {
  1166. return -1;
  1167. }
  1168. }
  1169. else
  1170. {
  1171. if (Svalue.IndexOf("<") > -1 && Svalue.IndexOf("=") == -1)
  1172. {
  1173. EValue = Svalue.Substring(Svalue.IndexOf("<") + 1, Svalue.Length - Svalue.IndexOf("<") - 1);
  1174. if (double.Parse(SCHvalue) < double.Parse(EValue))
  1175. {
  1176. return 0; //正确
  1177. }
  1178. else
  1179. {
  1180. return -1;
  1181. }
  1182. }
  1183. else
  1184. {
  1185. if (Svalue.IndexOf(">=") > -1)
  1186. {
  1187. EValue = Svalue.Substring(Svalue.IndexOf(">=") + 1, Svalue.Length - Svalue.IndexOf(">=") - 1);
  1188. if (double.Parse(SCHvalue) >= double.Parse(EValue))
  1189. {
  1190. return 0; //正确
  1191. }
  1192. else
  1193. {
  1194. return -1;
  1195. }
  1196. }
  1197. else
  1198. {
  1199. if (Svalue.IndexOf(">") > -1 && Svalue.IndexOf("=") == -1)
  1200. {
  1201. EValue = Svalue.Substring(Svalue.IndexOf(">") + 1, Svalue.Length - Svalue.IndexOf(">") - 1);
  1202. if (double.Parse(SCHvalue) > double.Parse(EValue))
  1203. {
  1204. return 0; //正确
  1205. }
  1206. else
  1207. {
  1208. return -1;
  1209. }
  1210. }
  1211. else
  1212. {
  1213. EValue = Svalue;
  1214. try
  1215. {
  1216. if (double.Parse(SCHvalue) == double.Parse(EValue))
  1217. {
  1218. return 0; //正确
  1219. }
  1220. }
  1221. catch { }
  1222. return -1;
  1223. }
  1224. }
  1225. }
  1226. }
  1227. }
  1228. }
  1229. return 0;
  1230. }
  1231. public void GetTAM_StandardElement()/// 查询判定牌号成分
  1232. {
  1233. int intSelectedIndex = cboGW.SelectedIndex; //选择的岗位
  1234. try
  1235. {
  1236. //
  1237. string strForeSmeltingId = "", strSme = "";
  1238. Color tmpC = c1;
  1239. string szJHGZ = "", strErr = "", szWhere = "", szQJ = "", szJYH = "";
  1240. object obj = null;
  1241. DataSet ds = new DataSet();
  1242. for (int j = 0; j < EMGrid.Rows.Count; j++)
  1243. {
  1244. for (int i = 0; i < EMGrid.DisplayLayout.Bands[0].Columns.Count; i++)
  1245. {
  1246. EMGrid.Rows[j].Cells[i].Appearance.ForeColor = Color.Black;
  1247. }
  1248. if (j == 0)
  1249. {
  1250. EMGrid.Rows[j].Appearance.BackColor = tmpC;
  1251. if (intSelectedIndex == 0)
  1252. strForeSmeltingId = EMGrid.Rows[j].Cells[1].Value.ToString().Substring(0, EMGrid.Rows[j].Cells[1].Value.ToString().IndexOf("-"));
  1253. else
  1254. {
  1255. if (EMGrid.Rows[j].Cells[1].Value.ToString().Length >= 10)
  1256. strForeSmeltingId = EMGrid.Rows[j].Cells[1].Value.ToString().Substring(0, 10);
  1257. }
  1258. }
  1259. else
  1260. {
  1261. if (intSelectedIndex == 0)
  1262. strSme = EMGrid.Rows[j].Cells[1].Value.ToString().Substring(0, EMGrid.Rows[j].Cells[1].Value.ToString().IndexOf("-"));
  1263. else
  1264. {
  1265. if (EMGrid.Rows[j].Cells[1].Value.ToString().Length >= 10)
  1266. strSme = EMGrid.Rows[j].Cells[1].Value.ToString().Substring(0, 10);
  1267. }
  1268. if (strForeSmeltingId == strSme)
  1269. {
  1270. tmpC = SetRowBackColor(EMGrid.Rows[j], tmpC, true);
  1271. }
  1272. else
  1273. {
  1274. tmpC = SetRowBackColor(EMGrid.Rows[j], tmpC, false);
  1275. strForeSmeltingId = strSme;
  1276. }
  1277. }
  1278. if (intSelectedIndex == 0)
  1279. continue;
  1280. szJHGZ = EMGrid.Rows[j].Cells["JHGZ"].Value.ToString();
  1281. szJYH = EMGrid.Rows[j].Cells[1].Value.ToString().Substring(0, 10);
  1282. strErr = "";
  1283. string[] ArrayId = new string[strERow.Length + 100]; // 后面加复合元素后,原有的会报错,加100
  1284. szWhere = szJYH; //条件
  1285. string szEleStd = "";
  1286. string szCrfStd = "('L02001','L02005') ";
  1287. int id = 0;
  1288. for (int i = 6; i < EMGrid.DisplayLayout.Bands[0].Columns.Count; i++)
  1289. {
  1290. if (EMGrid.Rows[j].Cells[i].Appearance.ForeColor == Color.Red || EMGrid.Rows[j].Cells[i].Appearance.ForeColor == Color.FromArgb(204, 153, 0))
  1291. EMGrid.Rows[j].Cells[i].Appearance.ForeColor = Color.Black;
  1292. }
  1293. //铁样与转炉样不判定
  1294. if (EMGrid.Rows[j].Cells["Station"].Value.ToString().Contains("转炉") == false)
  1295. {
  1296. //设置要获取的化学成分标准,此处i的值必须与(SetGridRowHidden)要显示的列数一样,否则将无法实现相同炉号显示不同颜色
  1297. for (int i = 13; i < EMGrid.DisplayLayout.Bands[0].Columns.Count; i++)
  1298. {
  1299. if (EMGrid.DisplayLayout.Bands[0].Columns[i].Hidden == false)
  1300. {
  1301. szEleStd = szEleStd + "','" + EMGrid.DisplayLayout.Bands[0].Columns[i].Header.Caption;
  1302. ArrayId[id] = EMGrid.DisplayLayout.Bands[0].Columns[i].Header.Caption;
  1303. id++;
  1304. }
  1305. }
  1306. if (!string.IsNullOrEmpty(szEleStd))
  1307. {
  1308. szEleStd = "('" + szEleStd.Substring(3, szEleStd.Length - 3) + "')";
  1309. ArrayList arry = new ArrayList();
  1310. arry.Add("ChemStandardInfo.select");
  1311. arry.Add(EMGrid.Rows[j].Cells["熔炼号"].Value.ToString());
  1312. CommonClientToServer cctos = new CommonClientToServer();
  1313. cctos.ob = this.ob;
  1314. ds = cctos.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery",
  1315. "doSimpleQuery", arry, out strErr);
  1316. }
  1317. else
  1318. continue;
  1319. if (strErr != "")
  1320. {
  1321. continue;
  1322. }
  1323. else if (ds.Tables[0].Rows.Count > 0)
  1324. {
  1325. //ArrayList ar = ds as ArrayList;
  1326. //DataSet dsStandard = (ar[0] as DataSet);
  1327. if (ds.Tables[0].Rows.Count == 0)
  1328. {
  1329. for (int i = 3; i < 18; i++)
  1330. {
  1331. if (EMGrid.Rows[j].Cells[i].Appearance.ForeColor == Color.Red)
  1332. EMGrid.Rows[j].Cells[i].Appearance.ForeColor = Color.Black;
  1333. }
  1334. continue;
  1335. }
  1336. foreach (DataRow Drow in ds.Tables[0].Rows)
  1337. {
  1338. for (int i = 0; i < ArrayId.Length; i++)
  1339. {
  1340. if (dataSet1.Tables[0].Columns.Contains(Drow["ITEMCODE"].ToString()))
  1341. {
  1342. if (EMGrid.Rows[j].Cells[Drow["ITEMCODE"].ToString()].Value.ToString().Length > 0)
  1343. {
  1344. if (Drow["ITEMCODE"].ToString() == ArrayId[i])
  1345. {
  1346. int reP = 0;
  1347. try
  1348. {
  1349. if (reP == 0)
  1350. {
  1351. if (Drow["STDMIN"].ToString() != "" && Drow["STDMAX"].ToString() != "")
  1352. szQJ = Drow["STDMIN"].ToString() + "~" + Drow["STDMAX"].ToString();
  1353. else if (Drow["STDMIN"].ToString() != "" && Drow["STDMAX"].ToString() == "")
  1354. szQJ = "> " + Drow["STDMIN"].ToString();
  1355. else if (Drow["STDMIN"].ToString() == "" && Drow["STDMAX"].ToString() != "")
  1356. szQJ = "<= " + Drow["STDMAX"].ToString();
  1357. reP = sValue(szQJ, EMGrid.Rows[j].Cells[Drow["ITEMCODE"].ToString()].Value.ToString());
  1358. }
  1359. }
  1360. catch (Exception ex)
  1361. {
  1362. Console.WriteLine(ex.Message);
  1363. }
  1364. if (reP == -1 && Drow["STDSTYLE"].ToString() == "1")
  1365. {
  1366. EMGrid.Rows[j].Cells[Drow["ITEMCODE"].ToString()].Appearance.ForeColor = Color.FromArgb(204, 153, 0);// Color.Yellow;
  1367. }
  1368. else if (reP == -1 && Drow["STDSTYLE"].ToString() == "2" && EMGrid.Rows[j].Cells[Drow["ITEMCODE"].ToString()].Appearance.ForeColor == Color.FromArgb(204, 153, 0))
  1369. {
  1370. EMGrid.Rows[j].Cells[Drow["ITEMCODE"].ToString()].Appearance.ForeColor = Color.Violet;
  1371. }
  1372. else if (reP == -1 && Drow["STDSTYLE"].ToString() == "3" && EMGrid.Rows[j].Cells[Drow["ITEMCODE"].ToString()].Appearance.ForeColor == Color.Violet)
  1373. {
  1374. EMGrid.Rows[j].Cells[Drow["ITEMCODE"].ToString()].Appearance.ForeColor = Color.Red;
  1375. }
  1376. else if (EMGrid.Rows[j].Cells[Drow["ITEMCODE"].ToString()].Appearance.ForeColor != Color.FromArgb(204, 153, 0))
  1377. {
  1378. EMGrid.Rows[j].Cells[Drow["ITEMCODE"].ToString()].Appearance.ForeColor = Color.Black;
  1379. }
  1380. break;
  1381. }
  1382. }
  1383. }
  1384. }
  1385. }
  1386. }
  1387. }
  1388. }
  1389. }
  1390. catch (Exception ex)
  1391. {
  1392. }
  1393. }
  1394. public void GetId(int RowId, Infragistics.Win.UltraWinGrid.UltraGrid GRID)
  1395. {
  1396. int i = RowId;
  1397. if (GRID.Rows[i].Cells[1].Value.ToString().Length > 0)
  1398. {
  1399. if (GRID.Rows[i].Cells[0].Value.ToString().IndexOf("√") < 0)
  1400. {
  1401. GRID.Rows[i].Cells[0].Value = GRID.Rows[i].Cells[0].Value + "√";
  1402. }
  1403. else
  1404. {
  1405. GRID.Rows[i].Cells[0].Value = GRID.Rows[i].Cells[0].Value.ToString().Substring(0, GRID.Rows[i].Cells[0].Value.ToString().IndexOf("√"));
  1406. }
  1407. }
  1408. }
  1409. private string ReturnSteelCodeByHeatNoFromUltraGrid(string heatNo)
  1410. {
  1411. string strSteelCode = "";
  1412. foreach (UltraGridRow ugr in this.EMGrid.Rows)
  1413. {
  1414. if (ugr.Cells["熔炼号"].Value.ToString() == heatNo)
  1415. {
  1416. if (ugr.Cells["JUDGE_STL_GRD"].Value.ToString().Length > 0 && ugr.Cells["熔炼号"].Value.ToString() != ugr.Cells["JUDGE_STL_GRD"].Value.ToString())
  1417. return ugr.Cells["JUDGE_STL_GRD"].Value.ToString();
  1418. }
  1419. }
  1420. return strSteelCode;
  1421. }
  1422. private void EMGrid_DoubleClickRow(object sender, Infragistics.Win.UltraWinGrid.DoubleClickRowEventArgs e)
  1423. {
  1424. GetId(e.Row.Index, EMGrid);
  1425. if (EMGrid.Rows[e.Row.Index].Cells[0].Value.ToString().IndexOf("√") > 0)
  1426. {
  1427. frmLgEleDetail.StrT = "02";
  1428. frmLgEleDetail.StrHic = EMGrid.Rows[e.Row.Index].Cells[1].Text.Trim().ToString();
  1429. string szLH = EMGrid.Rows[e.Row.Index].Cells["熔炼号"].Value.ToString();
  1430. string strJudjeCode = ReturnSteelCodeByHeatNoFromUltraGrid(szLH);
  1431. //string[] szAr = szLH.Split('-');
  1432. //szLH = szAr[0];// + szAr[1];
  1433. if (szLH.Length < 8)
  1434. return;
  1435. // 如果判定牌号有变化,弹出框中显示判定牌号信息
  1436. frmLgEleDetail.strSteelCode = EMGrid.Rows[e.Row.Index].Cells["计划牌号"].Text.Trim();
  1437. frmLgEleDetail.strSteelCodeGrd = strJudjeCode;
  1438. string szJYH = EMGrid.ActiveRow.Cells[1].Value.ToString();
  1439. string szEleStd = "";
  1440. //设置要获取的化学成分标准
  1441. for (int i = 5; i < EMGrid.DisplayLayout.Bands[0].Columns.Count; i++)
  1442. {
  1443. if (EMGrid.DisplayLayout.Bands[0].Columns[i].Hidden == false)
  1444. {
  1445. szEleStd = szEleStd + "','" + EMGrid.DisplayLayout.Bands[0].Columns[i].Header.Caption;
  1446. }
  1447. }
  1448. frmLgEleDetail.szEleStd = szEleStd;
  1449. frmLgEleDetail Azhupi = new frmLgEleDetail(frmLgEleDetail.StrHic, frmLgEleDetail.strSteelCode, szJYH.Substring(9, 1), ob);
  1450. Azhupi.ultrgridRow = EMGrid.ActiveRow;
  1451. Azhupi.ShowDialog(this);
  1452. }
  1453. }
  1454. private void EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
  1455. {
  1456. UltraMaskedEdit ume = (UltraMaskedEdit)sender;
  1457. switch (e.Button.Key)
  1458. {
  1459. case "edit":
  1460. frmNumberWriter frm = new frmNumberWriter();
  1461. frm._strText = ume.Text.Trim();
  1462. frm.Location = GetChildWindowLocation(frm.Size);
  1463. frm.ShowDialog();
  1464. ume.Text = frm._strText;
  1465. break;
  1466. case "clear":
  1467. if (ume.Text.Trim().Length > 0)
  1468. {
  1469. ume.Tag = ume.Text.Trim();
  1470. ume.Text = "";
  1471. }
  1472. else
  1473. {
  1474. if (ume.Tag != null)
  1475. ume.Text = ume.Tag.ToString();
  1476. }
  1477. break;
  1478. }
  1479. }
  1480. /// <summary>
  1481. /// 获取子窗体弹出的位置坐标
  1482. /// </summary>
  1483. /// <param name="ChildWindowSize"></param>
  1484. /// <returns></returns>
  1485. private Point GetChildWindowLocation(Size ChildWindowSize)
  1486. {
  1487. int width = Cursor.Position.X + ChildWindowSize.Width - Screen.PrimaryScreen.Bounds.Width;
  1488. int height = Cursor.Position.Y + ChildWindowSize.Height - Screen.PrimaryScreen.Bounds.Height + 30;
  1489. if (width > 0)
  1490. width = Cursor.Position.X - width;
  1491. else
  1492. width = Cursor.Position.X;
  1493. if (height > 0)
  1494. height = Cursor.Position.Y - height + 10;
  1495. else
  1496. height = Cursor.Position.Y + 10;
  1497. return new Point(width, height);
  1498. }
  1499. #region " Main Code "
  1500. //增加分页显示功能
  1501. private DataSet _dsAll = new DataSet();
  1502. private DataSet _dsSet;
  1503. private int _intBegin = 0;
  1504. private int _intEnd = 40;
  1505. private string _strDuty = "0";
  1506. private string _dvRowFilter = "";
  1507. private string _strWhere1 = "";
  1508. private string _strWhere2 = "";
  1509. private string _szTableName = "";
  1510. public string _devPos = "";
  1511. private Color c1 = Color.PaleGreen;
  1512. private Color c2 = Color.White;
  1513. private void btn_Up_Click(object sender, System.EventArgs e)
  1514. {
  1515. int step = 40;
  1516. try
  1517. {
  1518. step = Convert.ToInt32(this.txtPage.Text.Trim());
  1519. if (step < 1)
  1520. throw new Exception();
  1521. }
  1522. catch
  1523. {
  1524. MessageBox.Show("请输入正确的显示行数!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
  1525. return;
  1526. }
  1527. this.Cursor = Cursors.WaitCursor;
  1528. dataTable1.Clear();
  1529. if (_dsAll.Tables.Count <= 0)
  1530. return;
  1531. int count = _dsAll.Tables[0].DefaultView.Count;
  1532. if (_intBegin < step)
  1533. {
  1534. _intEnd = _intBegin;
  1535. _intBegin = 0;
  1536. }
  1537. else
  1538. {
  1539. _intEnd = _intBegin;
  1540. _intBegin -= step;
  1541. }
  1542. if (_intBegin > 0) this.btn_Up.Enabled = true;
  1543. else btn_Up.Enabled = false;
  1544. if (_intEnd < count) this.btn_Down.Enabled = true;
  1545. else btn_Down.Enabled = false;
  1546. this.label6.Text = String.Format("第 {0} 行到第 {1} 行, 共 {2} 行", _intBegin + 1, _intEnd, count);
  1547. SetEachRowData();
  1548. //数据获取启动线程。执行完后关闭
  1549. Thread t = new Thread(new ThreadStart(DoStandFetchReady));
  1550. t.IsBackground = true;
  1551. t.Start();
  1552. }
  1553. private void DoStandFetchReady()
  1554. {
  1555. GetTAM_StandardElement();
  1556. try
  1557. {
  1558. this.Cursor = Cursors.Default;
  1559. }
  1560. catch { }
  1561. //关闭正在取数据的对话框
  1562. // Invoke(new UpdateUIDelegate(UpdateUI), new object[] { true });
  1563. }
  1564. private void btn_Down_Click(object sender, System.EventArgs e)
  1565. {
  1566. int step = 40;
  1567. try
  1568. {
  1569. step = Convert.ToInt32(this.txtPage.Text.Trim());
  1570. if (step < 1)
  1571. throw new Exception();
  1572. }
  1573. catch
  1574. {
  1575. MessageBox.Show("请输入正确的显示行数!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
  1576. return;
  1577. }
  1578. this.Cursor = Cursors.WaitCursor;
  1579. dataTable1.Clear();
  1580. if (_dsAll.Tables.Count <= 0)
  1581. return;
  1582. int count = _dsAll.Tables[0].DefaultView.Count;
  1583. this._intBegin = this._intEnd;
  1584. this._intEnd += step;
  1585. if (_intEnd > count) _intEnd = count;
  1586. if (_intBegin > 0) this.btn_Up.Enabled = true;
  1587. else btn_Up.Enabled = false;
  1588. if (_intEnd < count) this.btn_Down.Enabled = true;
  1589. else btn_Down.Enabled = false;
  1590. this.label6.Text = String.Format("第 {0} 行到第 {1} 行, 共 {2} 行", _intBegin + 1, _intEnd, count);
  1591. SetEachRowData();
  1592. //数据获取启动线程。执行完后关闭
  1593. Thread t = new Thread(new ThreadStart(DoStandFetchReady));
  1594. t.IsBackground = true;
  1595. t.Start();
  1596. this.Cursor = Cursors.Default;
  1597. }
  1598. private void button3_Click(object sender, System.EventArgs e)
  1599. {
  1600. try
  1601. {
  1602. if (_dsAll == null || _dsAll.Tables.Count <= 0)
  1603. return;
  1604. int count = _dsAll.Tables[0].DefaultView.Count;
  1605. if (this.button3.Text == "全部显示")
  1606. {
  1607. this._intBegin = 0;
  1608. this.button3.Text = "分页显示";
  1609. this.btn_Up.Enabled = false;
  1610. this.btn_Down.Enabled = false;
  1611. if (_intEnd == count)
  1612. return;
  1613. else
  1614. this._intEnd = count;
  1615. }
  1616. else
  1617. {
  1618. int step = 40;
  1619. try
  1620. {
  1621. step = Convert.ToInt32(this.txtPage.Text.Trim());
  1622. if (step < 1)
  1623. throw new Exception();
  1624. }
  1625. catch
  1626. {
  1627. MessageBox.Show("请输入正确的显示行数!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
  1628. return;
  1629. }
  1630. this._intBegin = 0;
  1631. if (step < count)
  1632. {
  1633. this._intEnd = step;
  1634. this.btn_Up.Enabled = false;
  1635. this.btn_Down.Enabled = true;
  1636. }
  1637. else
  1638. {
  1639. this._intEnd = count;
  1640. this.btn_Up.Enabled = false;
  1641. this.btn_Down.Enabled = false;
  1642. this.button3.Text = "全部显示";
  1643. return;
  1644. }
  1645. this.button3.Text = "全部显示";
  1646. }
  1647. this.Cursor = Cursors.WaitCursor;
  1648. if (count == 0)
  1649. {
  1650. this.label6.Text = "无数据";
  1651. this.Cursor = Cursors.Default;
  1652. return;
  1653. }
  1654. else
  1655. this.label6.Text = String.Format("第 {0} 行到第 {1} 行, 共 {2} 行", _intBegin, _intEnd, count);
  1656. button3.Enabled = false;
  1657. SetEachRowData();
  1658. button3.Enabled = true;
  1659. //数据获取启动线程。执行完后关闭
  1660. Thread t = new Thread(new ThreadStart(DoStandFetchReady));
  1661. t.IsBackground = true;
  1662. t.Start();
  1663. }
  1664. catch
  1665. {
  1666. button3.Enabled = true;
  1667. }
  1668. }
  1669. #region " Init "
  1670. // 获取所有复合成分元素列表,并大写
  1671. ArrayList ceqChemList = null;
  1672. private void ELEMENTS_Load(object sender, System.EventArgs e)
  1673. {
  1674. try
  1675. {
  1676. ceqChemList = Core.LgMes.Client.lgBll.LgChemeLementMgt.LgChemeLementMgt.GetAllCeqChemByUpperChar(new ClientParamWithSqlConditionAndOpenBase("", this.ob));
  1677. }
  1678. catch
  1679. {
  1680. }
  1681. this.EMGrid.DisplayLayout.Bands[0].Columns[1].Width = 95;
  1682. this.EMGrid.DisplayLayout.Bands[0].Columns[2].Width = 90;
  1683. this.EMGrid.DisplayLayout.Bands[0].Columns[8].Width = 90;
  1684. this.EMGrid.DisplayLayout.Bands[0].Columns[9].Width = 65;
  1685. this.EMGrid.DisplayLayout.Bands[0].Columns[10].Width = 65;
  1686. label6.Visible = false;
  1687. EMGrid.Font = new System.Drawing.Font("Tahoma", 9F);
  1688. string strErr = "";
  1689. //获取所有化学成份列名
  1690. ArrayList arry = new ArrayList();
  1691. arry.Add("FrmLgElements.select");//此ID为XML文件ID
  1692. CommonClientToServer cctos = new CommonClientToServer();
  1693. cctos.ob = this.ob;
  1694. DataSet dsElements = cctos.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery",
  1695. "doSimpleQuery", arry, out strErr);
  1696. if (strErr == "" && dsElements != null)
  1697. {
  1698. foreach (DataRow dr in dsElements.Tables[0].Rows)
  1699. {
  1700. if (dr["BaseName"].ToString() == "Asn")
  1701. {
  1702. dataTable1.Columns.Add("As", typeof(System.Decimal));
  1703. dataTable1.Columns["As"].Caption = "As";
  1704. }
  1705. else
  1706. {
  1707. dataTable1.Columns.Add(dr["BaseName"].ToString(), typeof(System.Decimal));//添加列
  1708. }
  1709. }
  1710. }
  1711. string strElementsRow = ElementsConfig.GetElementsRow(); //调用函数获取要显示的列名
  1712. strERow = strElementsRow.Split('*');
  1713. _strDuty = Core.LgMes.Client.Comm.CStaticMethod.GetCurrentClass(this.ob).Substring(1, 1);
  1714. GetCurrDuty();
  1715. uldtBeginTime.Value = DateTime.Today.ToString("yyyy-MM-dd") + " 00:00";
  1716. uldtEndTime.Value = DateTime.Today.ToString("yyyy-MM-dd") + " 23:59";
  1717. if (_devPos == "0")
  1718. {
  1719. this.cboGW.SelectedIndex = 1;
  1720. }
  1721. else
  1722. {
  1723. int intIndex = 1;
  1724. switch (_devPos.Substring(0, 3))
  1725. {
  1726. case "HMP":
  1727. intIndex = 0;
  1728. break;
  1729. case "BOF":
  1730. intIndex = 1;
  1731. break;
  1732. case "CAS":
  1733. intIndex = 2;
  1734. break;
  1735. case "LFS":
  1736. intIndex = 3;
  1737. break;
  1738. case "RHS":
  1739. intIndex = 4;
  1740. break;
  1741. case "VDS":
  1742. intIndex = 5;
  1743. break;
  1744. case "CCM":
  1745. intIndex = 6;
  1746. break;
  1747. default:
  1748. break;
  1749. }
  1750. cboGW.SelectedIndex = intIndex;
  1751. }
  1752. this.SetDuty();
  1753. GetDataFromAll();
  1754. StartGetDataThread();
  1755. }
  1756. public delegate void UpdateUIDelegate(bool IsDataLoaded);
  1757. public void GetQualityInfo(string szLH)
  1758. {
  1759. try
  1760. {
  1761. this.ultraMaskedEdit1.Text = szLH;
  1762. _strWhere1 = String.Format(" where lh like '%{0}%' ", this.ultraMaskedEdit1.Text.Trim());
  1763. object obj = null;
  1764. _dsAll = obj as DataSet;
  1765. _dsAll.Tables[0].DefaultView.RowFilter = _dvRowFilter;
  1766. SetDataToGrid();
  1767. }
  1768. catch (Exception ex)
  1769. {
  1770. string Msg = ex.Message;
  1771. }
  1772. }
  1773. /// <summary>
  1774. /// 将数据装载到DATASET
  1775. /// </summary>
  1776. private void SetEachRowData()
  1777. {
  1778. int XH = 0;
  1779. try
  1780. {
  1781. ArrayList deleteCol = new ArrayList();
  1782. foreach (DataColumn dc in dataTable1.Columns)
  1783. {
  1784. if (!_dsAll.Tables[0].Columns.Contains(dc.ColumnName.ToUpper()) && ceqChemList.Contains(dc.ColumnName.ToUpper()))
  1785. {
  1786. deleteCol.Add(dc.ColumnName.ToUpper());
  1787. }
  1788. }
  1789. // 没有的元素需要删除
  1790. foreach (string s in deleteCol)
  1791. {
  1792. if (!"AS".Contains(s))
  1793. {
  1794. dataTable1.Columns.Remove(s);
  1795. }
  1796. }
  1797. DataRow newRow = dataTable1.NewRow();
  1798. DataRow Drow = null;
  1799. dataTable1.Clear();
  1800. int RowId = this._intBegin + 1;
  1801. for (int i = this._intBegin; i < this._intEnd; i++)
  1802. {
  1803. newRow = dataTable1.NewRow();
  1804. Drow = _dsAll.Tables[0].DefaultView[i].Row;
  1805. newRow[0] = RowId++;
  1806. newRow["熔炼号"] = Drow["HEATNO"].ToString();
  1807. newRow["Station"] = CStaticMethod.ChemelementPath(Drow["ASSAYTYPECODE"].ToString());
  1808. string strAs = Drow["ASSAYTYPECODE"].ToString();
  1809. newRow["SumTime"] = strAs.Substring(strAs.Length - 1, 1); //次数
  1810. newRow["计划牌号"] = Drow["gzbm"].ToString();
  1811. if (Drow["ASSAYDATE"].ToString() != "")
  1812. newRow["化验时间"] = Convert.ToDateTime(Drow["ASSAYDATE"]).ToString("yyyy-MM-dd HH:mm:ss");
  1813. newRow["shiftcode"] = Drow["shiftcode"].ToString();
  1814. newRow["JUDGE_SEQ"] = Drow["SIMN"].ToString();//20120109 新增
  1815. if (Drow["CM"] == null)
  1816. {
  1817. newRow["CM"] = "";
  1818. newRow["SAMPLE_DATE1"] = "";
  1819. }
  1820. else
  1821. {
  1822. newRow["CM"] = Drow["CM"].ToString();
  1823. newRow["SAMPLE_DATE1"] = Drow["SAMPLE_DATE1"].ToString();//20120109 新增
  1824. }
  1825. newRow["SAMPLE_DATE1"] = Drow["SAMPLE_DATE1"].ToString();//20120109 新增
  1826. /*foreach (DataRow dr in dtSamplesignal.Tables[0].Rows)//20150401新增
  1827. {
  1828. string Strpos = analysChineseName((dr["STRPOS"].ToString().Substring(0, 3)));
  1829. string str1 = dr["HEATNO"].ToString();
  1830. string str2 = Drow["HEATNO"].ToString();
  1831. string str3 = newRow["Station"].ToString();
  1832. if (dr["HEATNO"].ToString().Contains(Drow["HEATNO"].ToString()) && Strpos.Equals(newRow["Station"]))
  1833. {
  1834. if (Math.Abs(Convert.ToDouble((Convert.ToDateTime(Drow["ASSAYDATE"]) - Convert.ToDateTime(dr["SAMPLE_DATE1"])).TotalMinutes)) < 20)
  1835. {
  1836. double aaa = (Convert.ToDateTime(Drow["ASSAYDATE"]) - Convert.ToDateTime(dr["SAMPLE_DATE1"])).TotalMinutes;
  1837. string sample1 = dr["SAMPLE_DATE1"].ToString();
  1838. string ASSAYDATE = Drow["ASSAYDATE"].ToString();
  1839. if ( (strAs.Substring(strAs.Length - 1, 1) == dr["SAMGPLE_CNT"].ToString()) && (Math.Round((Convert.ToDateTime(Drow["ASSAYDATE"]) - Convert.ToDateTime(dr["SAMPLE_DATE1"])).TotalMinutes, 0)) > 0)
  1840. {
  1841. newRow["CM"] = Math.Round((Convert.ToDateTime(Drow["ASSAYDATE"]) - Convert.ToDateTime(dr["SAMPLE_DATE1"])).TotalMinutes, 2).ToString();//Math.Round(
  1842. newRow["SAMPLE_DATE1"] = Convert.ToDateTime(dr["SAMPLE_DATE1"]).ToString("yyyy-MM-dd HH:mm:ss");
  1843. break;
  1844. }
  1845. }
  1846. }
  1847. }*/
  1848. try
  1849. {
  1850. foreach (DataColumn dc in _dsAll.Tables[0].Columns)
  1851. {
  1852. foreach (DataColumn dc1 in dataTable1.Columns)
  1853. {
  1854. if (dc.ColumnName.ToUpper() == "ASN" && dc1.ColumnName.ToUpper() == "AS")
  1855. {
  1856. if (Drow[dc].ToString() != "")
  1857. newRow["As"] = Drow["Asn"].ToString();
  1858. }
  1859. if (dc1.ColumnName.ToUpper() == dc.ColumnName.ToUpper())
  1860. {
  1861. if (Drow[dc].ToString() != "")
  1862. newRow[dc1] = Drow[dc].ToString();
  1863. if (!Isbool)
  1864. if (newRow["SumTime"].ToString() != "" && Drow["JUDGE_SEQ"].ToString() != "")
  1865. {
  1866. if (strAs.Substring(0, 1) == "G" && Convert.ToInt32(newRow[7]) == Convert.ToInt32(Drow["JUDGE_SEQ"].ToString()))
  1867. {
  1868. newRow["JUDGE_STL_GRD"] = Drow["JUDGE_STL_GRD"].ToString();
  1869. newRow["JUDGE_RESULT"] = Drow["JUDGE_RESULT"].ToString() == "1" ? "合格" : "不合格";
  1870. newRow["REG_ID"] = Drow["REG_ID"].ToString();
  1871. }
  1872. else
  1873. {
  1874. newRow["JUDGE_STL_GRD"] = null;
  1875. newRow["JUDGE_RESULT"] = null;
  1876. newRow["REG_ID"] = null;
  1877. }
  1878. }
  1879. break;
  1880. }
  1881. }
  1882. }
  1883. }
  1884. catch (Exception ex)
  1885. {
  1886. // MessageBox.Show(ex.Message);
  1887. }
  1888. dataTable1.Rows.Add(newRow);
  1889. SetGridRowHidden();
  1890. }
  1891. /*
  1892. * 修改描述:与目标成份偏差及计算连铸和前工序的成份偏差
  1893. * 作者:在datatable 数据填充后再计算
  1894. * 修改日期:20131203
  1895. */
  1896. try
  1897. {
  1898. calculateChemelentDifference();
  1899. }
  1900. catch (Exception ex)
  1901. {
  1902. throw ex;
  1903. }
  1904. }
  1905. catch (Exception ex)
  1906. {
  1907. throw ex;
  1908. }
  1909. }
  1910. /// <summary>
  1911. /// 根据设置隐藏不要显示的列
  1912. /// </summary>
  1913. private void SetGridRowHidden()
  1914. {
  1915. try
  1916. {
  1917. //新增列时,相继修改J的值(新增n列时,j=j+n),否则将不会在界面显示
  1918. for (int j = 17; j < EMGrid.DisplayLayout.Bands[0].Columns.Count; j++)
  1919. {
  1920. if (ceqChemList.Contains(EMGrid.DisplayLayout.Bands[0].Columns[j].Header.Caption.ToUpper()))
  1921. {
  1922. EMGrid.DisplayLayout.Bands[0].Columns[j].Width = 60;
  1923. EMGrid.DisplayLayout.Bands[0].Columns[j].CellActivation = Activation.NoEdit;
  1924. continue;
  1925. }
  1926. EMGrid.DisplayLayout.Bands[0].Columns[j].Hidden = true;
  1927. EMGrid.DisplayLayout.Bands[0].Columns[j].Width = 60;
  1928. EMGrid.DisplayLayout.Bands[0].Columns[j].CellActivation = Activation.NoEdit;
  1929. EMGrid.DisplayLayout.Bands[0].Columns[0].CellActivation = Activation.AllowEdit;
  1930. EMGrid.DisplayLayout.Bands[0].Columns[1].CellActivation = Activation.AllowEdit;
  1931. EMGrid.DisplayLayout.Bands[0].Columns[2].CellActivation = Activation.NoEdit;
  1932. EMGrid.DisplayLayout.Bands[0].Columns[3].CellActivation = Activation.NoEdit;
  1933. EMGrid.DisplayLayout.Bands[0].Columns[4].CellActivation = Activation.NoEdit;
  1934. EMGrid.DisplayLayout.Bands[0].Columns[5].CellActivation = Activation.NoEdit;
  1935. EMGrid.DisplayLayout.Bands[0].Columns[6].CellActivation = Activation.NoEdit;
  1936. EMGrid.DisplayLayout.Bands[0].Columns[7].CellActivation = Activation.NoEdit;
  1937. }
  1938. for (int i = 0; i < strERow.Length; i++)
  1939. {
  1940. if (!string.IsNullOrEmpty(strERow[i]))
  1941. {
  1942. if (strERow[i] == "Asn")
  1943. {
  1944. EMGrid.DisplayLayout.Bands[0].Columns["As"].Hidden = false;
  1945. }
  1946. else
  1947. {
  1948. EMGrid.DisplayLayout.Bands[0].Columns[strERow[i]].Hidden = false;
  1949. }
  1950. }
  1951. }
  1952. for (int j = 0; j < strRowName.Length; j++)
  1953. {
  1954. EMGrid.DisplayLayout.Bands[0].Columns[strRowName[j]].Header.VisiblePosition = j + 14;
  1955. }
  1956. //EMGrid.DisplayLayout.Bands[0].Columns["shiftcode"].Header.VisiblePosition = EMGrid.DisplayLayout.Bands[0].Columns.Count;
  1957. //EMGrid.DisplayLayout.Bands[0].Columns["化验时间"].Header.VisiblePosition = EMGrid.DisplayLayout.Bands[0].Columns.Count;
  1958. //EMGrid.DisplayLayout.Bands[0].Columns["Station"].Header.VisiblePosition = 2;
  1959. //EMGrid.DisplayLayout.Bands[0].Columns["SumTime"].Header.VisiblePosition = 3;
  1960. //EMGrid.DisplayLayout.Bands[0].Columns["计划牌号"].Header.VisiblePosition = 5;
  1961. //EMGrid.DisplayLayout.Bands[0].Columns["JUDGE_STL_GRD"].Header.VisiblePosition = 5;
  1962. //EMGrid.DisplayLayout.Bands[0].Columns["JUDGE_RESULT"].Header.VisiblePosition = 6;
  1963. //EMGrid.DisplayLayout.Bands[0].Columns["REG_ID"].Header.VisiblePosition = 7;
  1964. //EMGrid.DisplayLayout.Bands[0].Columns["SIMN"].Header.VisiblePosition = 8;
  1965. EMGrid.DisplayLayout.Bands[0].Columns["熔炼号"].Header.Fixed = true;
  1966. EMGrid.DisplayLayout.Bands[0].Columns["计划牌号"].Header.Fixed = true;
  1967. EMGrid.DisplayLayout.Bands[0].Columns["Station"].Header.Fixed = true;
  1968. EMGrid.DisplayLayout.Bands[0].Columns["SumTime"].Header.Fixed = true;
  1969. }
  1970. catch
  1971. {
  1972. }
  1973. }
  1974. private void TestDs()
  1975. {
  1976. ClientParamWithSqlConditionAndOpenBase param = new ClientParamWithSqlConditionAndOpenBase();
  1977. param.sqlCondition = "J41-04504A_C102_S";
  1978. param.ob = this.ob;
  1979. //DataSet ds = Core.LgMes.Client.lgBll.LgChemeLementMgt.LgChemeLementMgt.ReturnCeqChemByCheckNo(param);
  1980. }
  1981. private void SetDataToGrid()
  1982. {
  1983. this._intBegin = 0;
  1984. //this._intEnd = Convert.ToInt32(this.txtPage.Text);
  1985. if (_dsAll != null)
  1986. {
  1987. int count = _dsAll.Tables[0].Rows.Count;
  1988. if (count <= _intEnd)
  1989. {
  1990. //_intEnd = count;
  1991. this.btn_Up.Enabled = false;
  1992. this.btn_Down.Enabled = false;
  1993. this.button3.Enabled = false;
  1994. }
  1995. else
  1996. {
  1997. this.btn_Up.Enabled = false;
  1998. this.btn_Down.Enabled = true;
  1999. this.button3.Enabled = true;
  2000. }
  2001. if (count == 0)
  2002. {
  2003. this.label6.Text = "无数据";
  2004. this.EMGrid.Cursor = System.Windows.Forms.Cursors.Arrow;
  2005. }
  2006. else
  2007. this.label6.Text = String.Format("第 1 行到第 {0} 行, 共 {1} 行", _intEnd, count);
  2008. try
  2009. {
  2010. SetEachRowData();
  2011. }
  2012. catch
  2013. {
  2014. }
  2015. GetTAM_StandardElement(); // 取成分割标准对比
  2016. }
  2017. else
  2018. {
  2019. this.label6.Text = "无数据";
  2020. }
  2021. this.EMGrid.Cursor = System.Windows.Forms.Cursors.Arrow;
  2022. }
  2023. #endregion
  2024. #region " ToolBar Event "
  2025. public override void ToolBar_Click(object sender, string ToolbarKey)
  2026. {
  2027. switch (ToolbarKey)
  2028. {
  2029. case "Query":
  2030. this.GetDataFromAll();
  2031. break;
  2032. case "SetSampling": //设置样点
  2033. SetSampling();
  2034. break;
  2035. case "SetRowName": //设置化学成份字段显示
  2036. SetRowName();
  2037. break;
  2038. case "Export":
  2039. if (EMGrid.Rows.Count > 0)
  2040. {
  2041. ExportExcel();
  2042. }
  2043. else
  2044. MessageBox.Show("没有化学成分信息。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  2045. break;
  2046. case "Exit":
  2047. this.Close();
  2048. break;
  2049. default:
  2050. break;
  2051. }
  2052. base.ToolBar_Click(sender, ToolbarKey);
  2053. }
  2054. /// <summary>
  2055. /// 设置化学成份列名
  2056. /// </summary>
  2057. private void SetRowName()
  2058. {
  2059. DataSet dsElements = new DataSet();
  2060. //定义一个ArrayList集合存储变量[参数]值
  2061. ArrayList arry = new ArrayList();
  2062. arry.Add("FrmSetRowName.select");
  2063. //调用服务端方法
  2064. CoreClientParam CCP_Sampling = new CoreClientParam();
  2065. DataTable dt = new DataTable();
  2066. CCP_Sampling.ServerName = "Core.LgMes.Server.Common.ComDBQuery";
  2067. CCP_Sampling.MethodName = "doSimpleQuery";
  2068. CCP_Sampling.ServerParams = new object[] { arry };
  2069. CCP_Sampling.SourceDataTable = dt;
  2070. this.ExecuteQueryToDataTable(CCP_Sampling, CoreInvokeType.Internal);
  2071. if (dt != null)
  2072. {
  2073. if (dt.Rows.Count > 0)
  2074. {
  2075. dt.Rows[0].Table.Columns.Add(new DataColumn("选择", typeof(System.Boolean)));
  2076. foreach (DataRow dr in dt.Rows)
  2077. {
  2078. dr["选择"] = false;
  2079. if (dr["BaseName"].ToString() == "Asn")
  2080. {
  2081. dr["BaseName"] = "As";
  2082. }
  2083. }
  2084. frmConfigElementsRow frm = new frmConfigElementsRow();
  2085. frm.StartPosition = FormStartPosition.CenterScreen;
  2086. frm.WindowState = FormWindowState.Normal;
  2087. dsElements.Tables.Add(dt);
  2088. frm._dsSet = dsElements;
  2089. frm.ShowDialog();
  2090. // 判断是否有设置
  2091. if (frm._setFlag)
  2092. {
  2093. string strElementsRow = ElementsConfig.GetElementsRow(); //调用函数获取要显示的列名
  2094. strERow = strElementsRow.Split('*');
  2095. GetDataFromAll();
  2096. }
  2097. }
  2098. else
  2099. MessageBox.Show("查询失败!!!", "提示");
  2100. }
  2101. }
  2102. /// <summary>
  2103. /// 显示样点
  2104. /// </summary>
  2105. private void SetSampling()
  2106. {
  2107. DataTable dt = new DataTable();
  2108. if (dataSet1 != null)
  2109. {
  2110. _dsSet = new DataSet();
  2111. //定义一个ArrayList集合存储变量[参数]值
  2112. ArrayList arry = new ArrayList();
  2113. arry.Add("FrmSetSamplin.select");//此ID为XML文件ID
  2114. //调用服务端方法
  2115. CoreClientParam CCP_Sampling = new CoreClientParam();
  2116. CCP_Sampling.ServerName = "Core.LgMes.Server.Common.ComDBQuery";
  2117. CCP_Sampling.MethodName = "doSimpleQuery";
  2118. CCP_Sampling.ServerParams = new object[] { arry };
  2119. CCP_Sampling.SourceDataTable = dt;
  2120. this.ExecuteQueryToDataTable(CCP_Sampling, CoreInvokeType.Internal);
  2121. dt.Rows[0].Table.Columns.Add(new DataColumn("工序名", typeof(System.String)));
  2122. dt.Rows[0].Table.Columns.Add(new DataColumn("选择", typeof(System.Boolean)));
  2123. foreach (DataRow dr in dt.Rows)
  2124. {
  2125. string SetColumn = dr["ASSAYTYPECODE"].ToString().Substring(0, 2);
  2126. dr["ASSAYTYPECODE"] = dr["ASSAYTYPECODE"].ToString();
  2127. dr["工序名"] = analysPath(SetColumn, dr["ASSAYTYPECODE"].ToString());
  2128. dr["选择"] = true;
  2129. }
  2130. }
  2131. _dsSet.Tables.Add(dt);
  2132. frmSetSampling frm = new frmSetSampling();
  2133. frm._dsSet = _dsSet;
  2134. frm.ShowDialog();
  2135. if (frm._setFlag)
  2136. {
  2137. _dsSet = frm._dsSet;
  2138. _dsSet.AcceptChanges();
  2139. _dvRowFilter = "";
  2140. foreach (DataRow dr in _dsSet.Tables[0].Rows)
  2141. {
  2142. if (Convert.ToBoolean(dr["选择"]) == true)
  2143. {
  2144. _dvRowFilter += string.Format("or assaytypecode = '{0}' ", dr[0].ToString());
  2145. }
  2146. }
  2147. if (_dvRowFilter.Length > 0)
  2148. {
  2149. _dvRowFilter = _dvRowFilter.Substring(2, _dvRowFilter.Length - 2);
  2150. }
  2151. GetDataFromAll();
  2152. }
  2153. }
  2154. private void ExportExcel()
  2155. {
  2156. try
  2157. {
  2158. string StrfileName = System.Windows.Forms.Application.StartupPath + "\\Report\\成分明细.xls";
  2159. //this.GridExcelExporter.Export(this.EMGrid, StrfileName);
  2160. ultraGridExcelExporter1.Export(EMGrid, StrfileName);
  2161. ProcessStartInfo p = new ProcessStartInfo(StrfileName);
  2162. p.WindowStyle = System.Diagnostics.ProcessWindowStyle.Maximized;
  2163. p.WorkingDirectory = Path.GetDirectoryName(StrfileName);
  2164. Process.Start(p);
  2165. }
  2166. catch (Exception ex)
  2167. {
  2168. MessageBox.Show(ex.Message + "\n处理方法:查看(" + System.Windows.Forms.Application.StartupPath + ")目录下是否有[ Report文件夹 ],如果没有请手动创建!");
  2169. }
  2170. }
  2171. #endregion
  2172. private void HiddCeqColumn()
  2173. {
  2174. bool flag = false;
  2175. try
  2176. {
  2177. foreach (UltraGridColumn col in this.EMGrid.DisplayLayout.Bands[0].Columns)
  2178. {
  2179. flag = false;
  2180. if (!this.ceqChemList.Contains(col.Header.Caption.ToUpper()))
  2181. {
  2182. continue;
  2183. }
  2184. foreach (UltraGridRow ugr in this.EMGrid.Rows)
  2185. {
  2186. if (ugr.Cells[col.Header.Caption].Value.ToString().Length > 0)
  2187. {
  2188. flag = true;
  2189. break;
  2190. }
  2191. }
  2192. this.EMGrid.DisplayLayout.Bands[0].Columns[col.Header.Caption].Hidden = (flag) ? false : true;
  2193. }
  2194. }
  2195. catch
  2196. {
  2197. }
  2198. }
  2199. private void AddCeqToDataTable(ref DataTable dt)
  2200. {
  2201. Hashtable hsCeq = null;
  2202. Hashtable tb = null;
  2203. ClientParamWithSqlConditionAndOpenBase param = new ClientParamWithSqlConditionAndOpenBase();
  2204. param.ob = this.ob;
  2205. if (dt == null || dt.Rows.Count == 0)
  2206. return;
  2207. // 先获取所有的复合成分,减少后续扫描数据库的循环
  2208. DataSet dsChemCeqByHeatno =
  2209. Core.LgMes.Client.lgBll.LgChemeLementMgt.LgChemeLementMgt.GetCeqChem(new ClientParamWithSqlConditionAndOpenBase(string.Format(" and ASSAYDATE >= '{0}' ", this.uldtBeginTime.DateTime.ToString("yyyy-MM-dd HH:mm:ss")), this.ob));
  2210. if (dsChemCeqByHeatno == null || dsChemCeqByHeatno.Tables[0].Rows.Count == 0)
  2211. return;
  2212. foreach (DataRow dr in dt.Rows)
  2213. {
  2214. // g根据炉号和化验时间过滤复合元素,唯一的
  2215. DataView dv = dsChemCeqByHeatno.Tables[0].DefaultView;
  2216. dv.RowFilter = string.Format("HEATNO = '{0}' and ASSAYDATE = '{1}'", dr["HEATNO"].ToString(), dr["ASSAYDATE"].ToString());
  2217. if (dv.Count == 0)
  2218. continue;
  2219. param.param = null;
  2220. param.param = new Object[] { dr["HEATNO"].ToString(), dr["ASSAYDATE"].ToString(), dv.ToTable() };
  2221. tb = Core.LgMes.Client.lgBll.LgChemeLementMgt.LgChemeLementMgt.ReturnCeqChemByHeatNoAndAssDate(param);
  2222. if (tb == null || tb.Count == 0)
  2223. continue;
  2224. // 获取该记录的复合成分列表
  2225. hsCeq = tb[dr["HEATNO"].ToString() + dr["ASSAYDATE"].ToString()] as Hashtable;
  2226. if (hsCeq != null && hsCeq.Count > 0)
  2227. {
  2228. foreach (string s in hsCeq.Keys)
  2229. {
  2230. // 表没有复合成分名称,新增
  2231. if (!dt.Columns.Contains(s))
  2232. {
  2233. dt.Columns.Add(new DataColumn(s, System.Type.GetType("System.String")));
  2234. }
  2235. try
  2236. {
  2237. // 同步新增显示数据的表结构
  2238. if (!this.dataTable1.Columns.Contains(s))
  2239. {
  2240. this.dataTable1.Columns.Add(new DataColumn(s, System.Type.GetType("System.String")));
  2241. }
  2242. }
  2243. catch
  2244. {
  2245. }
  2246. // 赋值
  2247. dr[s] = hsCeq[s].ToString();
  2248. }
  2249. }
  2250. }
  2251. }
  2252. #region " 直接打开界面 或 查询 "
  2253. public void GetDataFromAll()
  2254. {
  2255. EMGrid.DisplayLayout.Bands[0].Columns["REMARK"].ValueList = proc_ValueListRemark();
  2256. List<TBB01_SEQ_INGR> listIngr = null;
  2257. try
  2258. {
  2259. listIngr = Core.LgMes.Client.lgBll.LgChemeLementMgt.LgChemeLementMgt.GetTbb01SeqIngrAll(new ClientParamWithSqlConditionAndOpenBase("", this.ob));
  2260. }
  2261. catch
  2262. {
  2263. }
  2264. string strFindName = "";
  2265. for (int i = 0; i < strERow.Length; i++)
  2266. {
  2267. if (!string.IsNullOrEmpty(strERow[i]))
  2268. {
  2269. if (strERow[i] == "QA2")
  2270. {
  2271. strFindName = strFindName + "," + "round((Nb+V+Ti),2)QA2";
  2272. }
  2273. else if (strERow[i] == "QB2")
  2274. {
  2275. strFindName = strFindName + "," + "round((C+Mn/6+(Cr+V+Mo)/5+(Cu+Ni)/15),2)QB2";
  2276. }
  2277. else if (strERow[i] == "QB3")
  2278. {
  2279. strFindName = strFindName + "," + "round((C+Mn/6+Si/24+Ni/40+Cr/5+Mo/4+V/14),2)QB3";
  2280. }
  2281. else
  2282. {
  2283. strFindName = strFindName + "," + strERow[i];
  2284. }
  2285. }
  2286. }
  2287. try
  2288. {
  2289. if (Convert.ToDateTime(uldtEndTime.Value) < Convert.ToDateTime(uldtBeginTime.Value))
  2290. {
  2291. MessageBox.Show("结束时间必须大于等于开始时间!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
  2292. return;
  2293. }
  2294. GetPost();
  2295. GetDuty();
  2296. if (this.ultraMaskedEdit1.Text.Trim().Length > 0 || this.ultraMaskedEdit2.Text.Trim().Length > 0)
  2297. BuildSQLWithID();
  2298. else
  2299. BuildSQLWithOutID();
  2300. _dsAll = new DataSet();
  2301. //定义一个ArrayList集合存储变量[参数]值
  2302. ArrayList arry = new ArrayList();
  2303. ArrayList sqlList = new ArrayList();
  2304. if (Isbool)
  2305. {
  2306. arry.Add("FrmHMPElements_Query.select");
  2307. }
  2308. else
  2309. {
  2310. arry.Add("FrmLgElements_Query.select");
  2311. }
  2312. sqlList.Add(strFindName);
  2313. //sqlList.Add(_strWhere1);
  2314. //sqlList.Add(_strWhere1);
  2315. sqlList.Add(_szTableName);//表名
  2316. sqlList.Add("J#" + _szTableName);//表名
  2317. sqlList.Add("and ASSAYDATE between to_date('" + this.uldtBeginTime.DateTime.ToString("yyyy-MM-dd HH:mm:ss")
  2318. + "', 'yyyy-mm-dd hh24:mi:ss') and to_date('" + this.uldtEndTime.DateTime.ToString("yyyy-MM-dd HH:mm:ss")
  2319. + "','yyyy-mm-dd hh24:mi:ss')");//时间
  2320. sqlList.Add("and ASSAYDATE between to_date('" + this.uldtBeginTime.DateTime.ToString("yyyy-MM-dd HH:mm:ss")
  2321. + "', 'yyyy-mm-dd hh24:mi:ss') and to_date('" + this.uldtEndTime.DateTime.ToString("yyyy-MM-dd HH:mm:ss")
  2322. + "','yyyy-mm-dd hh24:mi:ss')");
  2323. sqlList.Add(_strWhere2);
  2324. //调用服务端方法
  2325. CoreClientParam CCP_LgEts = new CoreClientParam();
  2326. DataTable dt = new DataTable();
  2327. CCP_LgEts.ServerName = "Core.LgMes.Server.Common.ComDBQuery";
  2328. CCP_LgEts.MethodName = "doQuery";
  2329. CCP_LgEts.ServerParams = new object[] { arry, sqlList };
  2330. CCP_LgEts.SourceDataTable = dt;
  2331. this.ExecuteQueryToDataTable(CCP_LgEts, CoreInvokeType.Internal);
  2332. DataTable dtTemp = dt.Copy();
  2333. //获取炉号
  2334. //dtSamplesignal = this.ObtainSamplesignal(dtTemp);
  2335. // 增加复合元素
  2336. try
  2337. {
  2338. AddCeqToDataTable(ref dt);
  2339. }
  2340. catch
  2341. {
  2342. dt = dtTemp;
  2343. }
  2344. _dsAll.Tables.Add(dt);
  2345. _dsAll.Tables[0].DefaultView.RowFilter = _dvRowFilter;
  2346. DataRow[] row = _dsAll.Tables[0].Select(_dvRowFilter);
  2347. int currrow = row.Length;
  2348. if (currrow < 40)
  2349. {
  2350. this._intEnd = currrow;
  2351. }
  2352. else
  2353. { _intEnd = Convert.ToInt32(this.txtPage.Text.Trim()); }
  2354. // _intEnd = 4000;
  2355. SetDataToGrid();
  2356. }
  2357. catch (Exception ex)
  2358. {
  2359. Debug.WriteLine(ex.Message);
  2360. }
  2361. }
  2362. private ValueList proc_ValueListRemark()
  2363. {
  2364. ValueList vlist = new ValueList();
  2365. try
  2366. {
  2367. vlist.ValueListItems.Add("风动故障", "风动故障");
  2368. vlist.ValueListItems.Add("激发前重磨", "激发前重磨");
  2369. vlist.ValueListItems.Add("激发后重磨", "激发后重磨");
  2370. vlist.ValueListItems.Add("多点激发", "多点激发");
  2371. vlist.ValueListItems.Add("重取样", "重取样");
  2372. vlist.ValueListItems.Add("同时来样", "同时来样");
  2373. vlist.ValueListItems.Add("传输故障", "传输故障");
  2374. vlist.ValueListItems.Add("炉号有误", "炉号有误");
  2375. vlist.ValueListItems.Add("标样校正", "标样校正");
  2376. vlist.ValueListItems.Add("光谱故障", "光谱故障");
  2377. vlist.ValueListItems.Add("其它", "其它");
  2378. }
  2379. catch { }
  2380. return vlist;
  2381. }
  2382. #endregion
  2383. #region " 从作业管理打开界面 "
  2384. public void GetDataFromCurr()
  2385. {
  2386. try
  2387. {
  2388. GetCurrDuty();
  2389. _dsAll = null;
  2390. //定义一个ArrayList集合存储变量[参数]值
  2391. ArrayList arry = new ArrayList();
  2392. arry.Add("frmSysteLog.select");
  2393. //调用服务端方法
  2394. CoreClientParam CCP_SysLog = new CoreClientParam();
  2395. DataTable dt = new DataTable();
  2396. CCP_SysLog.ServerName = "Core.LgMes.Server.Common.ComDBQuery";
  2397. CCP_SysLog.MethodName = "doSimpleQuery";
  2398. CCP_SysLog.ServerParams = new object[] { arry };
  2399. CCP_SysLog.SourceDataTable = dt;
  2400. this.ExecuteQueryToDataTable(CCP_SysLog, CoreInvokeType.Internal);
  2401. _dsAll.Tables[0].DefaultView.RowFilter = _dvRowFilter;
  2402. SetPost();
  2403. SetDuty();
  2404. SetDataToGrid();
  2405. }
  2406. catch { }
  2407. }
  2408. private void GetCurrDuty()
  2409. {
  2410. try
  2411. {
  2412. string strErr = "";
  2413. string strDuty = "";
  2414. ArrayList arry = new ArrayList();
  2415. arry.Add("GetClassCode.query");
  2416. CommonClientToServer cctos = new CommonClientToServer();
  2417. cctos.ob = this.ob;
  2418. DataSet ds = cctos.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery",
  2419. "doSimpleQuery", arry, out strErr);
  2420. strDuty = ds.Tables[0].Rows[0]["mes"].ToString();
  2421. _strDuty = strDuty.Substring(1, 1);
  2422. return;
  2423. }
  2424. catch { }
  2425. _strDuty = "0";
  2426. }
  2427. #endregion
  2428. #region " SQL "
  2429. private void BuildSQLWithOutID()
  2430. {
  2431. string begTime = this.uldtBeginTime.DateTime.ToString("yyyy-MM-dd HH:mm:ss");
  2432. string endTime = this.uldtEndTime.DateTime.ToString("yyyy-MM-dd HH:mm:ss");
  2433. string strStartTime = "";
  2434. string strEndTime = "";
  2435. if (Convert.ToDateTime(uldtBeginTime.Text.Trim()) > Convert.ToDateTime(uldtEndTime.Text.Trim()))
  2436. {
  2437. MessageBox.Show("选择的开始时间不能大于结束时间!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  2438. return;
  2439. }
  2440. else
  2441. {
  2442. strStartTime = this.uldtBeginTime.DateTime.ToString("yyyy-MM-dd HH:mm:ss");
  2443. strEndTime = this.uldtEndTime.DateTime.ToString("yyyy-MM-dd HH:mm:ss");
  2444. }
  2445. if (_devPos.Substring(0, 3) == "HMP" || _devPos.Substring(0, 4) == "SYGW")// 铁水 或者 所有岗位
  2446. {
  2447. _strWhere2 = " where a.hudwid = b.heatno and b.ASSAYDATE between to_date('" + strStartTime + "', 'yyyy-MM-dd hh24:mi:ss') and to_date('" + strEndTime + "', 'yyyy-MM-dd hh24:mi:ss') ";
  2448. Isbool = true;
  2449. }
  2450. else
  2451. {
  2452. _strWhere2 = " where b.HEATNO = a.HEATNO and b.ASSAYDATE between to_date('" + strStartTime + "', 'yyyy-MM-dd hh24:mi:ss') and to_date('" + strEndTime + "', 'yyyy-MM-dd hh24:mi:ss') ";
  2453. Isbool = false;
  2454. }
  2455. string str = this._devPos.Substring(0, 3), szWZ = this._devPos.Substring(3, 2);
  2456. if (this._strDuty != "1" && str != "BOF")
  2457. _strWhere2 += string.Format(" and substr(a.SHIFTCODE,2,1) = '{0}' ", this._strDuty);
  2458. if (str != "HMP" && szWZ != "00" && str != "SYG")
  2459. _strWhere2 += string.Format(" and a.stationcode = '{0}'", szWZ);
  2460. if (txtSteel.Text.Trim() != "")
  2461. str = txtSteel.Text.ToString();
  2462. else
  2463. str = "";
  2464. if (str != "")
  2465. {
  2466. string strSteeAll = "";
  2467. string[] strSteel = str.Split(',');
  2468. for (int i = 0; i < strSteel.Length; i++)
  2469. {
  2470. if (!string.IsNullOrEmpty(strSteel[i]))
  2471. strSteeAll = strSteeAll + "'" + strSteel[i] + "',";
  2472. }
  2473. str = strSteeAll.Substring(0, strSteeAll.Length - 1);
  2474. _strWhere2 += string.Format(" and a.plansteel in ({0})", str);
  2475. }
  2476. //气体样
  2477. if (chkGasSample.Checked)
  2478. {
  2479. _strWhere2 += " and (N>0 or H>0 or O>0) ";
  2480. }
  2481. }
  2482. private void BuildSQLWithID()
  2483. {
  2484. string begTime = this.uldtBeginTime.DateTime.ToString("yyyy-MM-dd HH:mm:ss");
  2485. string endTime = this.uldtEndTime.DateTime.ToString("yyyy-MM-dd HH:mm:ss");
  2486. string strStartTime = "";
  2487. string strEndTime = "";
  2488. if (Convert.ToDateTime(uldtBeginTime.Text.Trim()) > Convert.ToDateTime(uldtEndTime.Text.Trim()))
  2489. {
  2490. MessageBox.Show("选择的开始时间不能大于结束时间!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
  2491. return;
  2492. }
  2493. else
  2494. {
  2495. strStartTime = this.uldtBeginTime.DateTime.ToString("yyyy-MM-dd HH:mm:ss");
  2496. strEndTime = this.uldtEndTime.DateTime.ToString("yyyy-MM-dd HH:mm:ss");
  2497. }
  2498. //熔炼号从
  2499. if (this.ultraMaskedEdit1.Text.Length == 0)
  2500. {
  2501. _strWhere2 = String.Format(" where a.HEATNO like '%{0}%' ", this.ultraMaskedEdit2.Text.Trim());
  2502. }
  2503. else
  2504. {
  2505. if (this.ultraMaskedEdit2.Text.Length == 0)
  2506. {
  2507. _strWhere2 = String.Format(" where a.HEATNO like '%{0}%' ", this.ultraMaskedEdit1.Text.Trim());
  2508. }
  2509. else
  2510. {
  2511. _strWhere2 = String.Format(" where a.HEATNO between '{0}' and '{1}' ", this.ultraMaskedEdit1.Text.Trim(), this.ultraMaskedEdit2.Text.Trim());
  2512. }
  2513. }
  2514. if (_devPos.Substring(0, 3) == "HMP" || _devPos.Substring(0, 4) == "SYGW")
  2515. {
  2516. _strWhere2 += " ";
  2517. Isbool = true;
  2518. }
  2519. else
  2520. {
  2521. Isbool = false;
  2522. _strWhere2 += " and b.HEATNO = a.HEATNO and to_char(b.ASSAYDATE, 'yyyy-MM-dd HH:mm:ss') between '" + strStartTime + "' and '" + strEndTime + "'";
  2523. }
  2524. string str = this._devPos.Substring(0, 3), szWZ = this._devPos.Substring(4, 1);
  2525. if (this._strDuty != "0" && str != "BOF")
  2526. _strWhere2 += string.Format(" and substr(a.SHIFTCODE,2,1) = '{0}' ", this._strDuty);
  2527. if (txtSteel.Text.Trim() != "")
  2528. str = txtSteel.Text.ToString();
  2529. else
  2530. str = "";
  2531. if (str != "")
  2532. {
  2533. string strSteeAll = "";
  2534. string[] strSteel = str.Split(',');
  2535. for (int i = 0; i < strSteel.Length; i++)
  2536. {
  2537. if (!string.IsNullOrEmpty(strSteel[i]))
  2538. strSteeAll = strSteeAll + "'" + strSteel[i] + "',";
  2539. }
  2540. str = strSteeAll.Substring(0, strSteeAll.Length - 1);
  2541. _strWhere2 += string.Format(" and a.plansteel in ({0})", str);
  2542. }
  2543. //气体样
  2544. if (chkGasSample.Checked)
  2545. {
  2546. _strWhere2 += " and (N>0 or H>0 or O>0) ";
  2547. }
  2548. }
  2549. #endregion
  2550. #region " ComboBox Event "
  2551. private object[] GetComboBox2Items(int index)
  2552. {
  2553. switch (index)
  2554. {
  2555. case 1:
  2556. return new object[] { "所有", "1#转炉", "2#转炉", "3#转炉" };
  2557. case 2:
  2558. return new object[] { "所有", "1#吹氩站", "2#吹氩站", "3#吹氩站" };
  2559. case 3:
  2560. return new object[] { "所有", "1#精炼炉", "2#精炼炉" };
  2561. case 4:
  2562. return new object[] { "所有", "1#RH炉" };
  2563. case 5:
  2564. return new object[] { "所有", "1#连铸", "2#连铸", "3#连铸", "4#连铸" };
  2565. default:
  2566. return new object[] { "所有铁水" };
  2567. }
  2568. }
  2569. #endregion
  2570. #region " Common Event "
  2571. private Color SetRowBackColor(UltraGridRow ugr, Color frc, bool ifSame)
  2572. {
  2573. Color c;
  2574. if (ifSame)
  2575. {
  2576. c = frc;
  2577. }
  2578. else
  2579. {
  2580. if (frc == c1)
  2581. c = c2;
  2582. else
  2583. c = c1;
  2584. }
  2585. ugr.Appearance.BackColor = c;
  2586. return c;
  2587. }
  2588. private void SetMaskText()
  2589. {
  2590. try
  2591. {
  2592. this.ultraMaskedEdit1.Text = "";
  2593. this.ultraMaskedEdit2.Text = "";
  2594. if (this._devPos.Substring(0, 3) == "BOF" || this._devPos.Substring(0, 3) == "CAS")
  2595. {
  2596. int count = _dsAll.Tables[0].Rows.Count;
  2597. if (count > 1)
  2598. {
  2599. this.ultraMaskedEdit1.Text = _dsAll.Tables[0].Rows[count - 1]["LH"].ToString();
  2600. this.ultraMaskedEdit2.Text = _dsAll.Tables[0].Rows[0]["LH"].ToString();
  2601. }
  2602. else if (count == 1)
  2603. {
  2604. this.ultraMaskedEdit1.Text = _dsAll.Tables[0].Rows[count - 1]["LH"].ToString();
  2605. }
  2606. }
  2607. }
  2608. catch { }
  2609. }
  2610. private void GetPost()
  2611. {
  2612. this._devPos = "";
  2613. switch (this.cboGW.SelectedIndex)
  2614. {
  2615. case 0:
  2616. this._devPos = "HMP0";
  2617. this._szTableName = "STL_HMP_OPTINFO";
  2618. break;
  2619. case 1:
  2620. this._devPos = "BOF0";
  2621. this._szTableName = "STL_BOF_OPTINFO";
  2622. break;
  2623. case 2:
  2624. this._devPos = "CAS0";
  2625. this._szTableName = "STL_CAS_OPTINFO";
  2626. break;
  2627. case 3:
  2628. this._devPos = "LFS0";
  2629. this._szTableName = "STL_LFS_OPTINFO";
  2630. break;
  2631. case 4:
  2632. this._devPos = "RHS0";
  2633. this._szTableName = "STL_RHS_OPTINFO";
  2634. break;
  2635. case 5:
  2636. this._devPos = "VDS0";
  2637. this._szTableName = "STL_VDS_OPTINFO";
  2638. break;
  2639. case 6:
  2640. this._devPos = "CCM0";
  2641. this._szTableName = "STL_CCM_OPTINFO";
  2642. break;
  2643. default:
  2644. this._devPos = "SYGW"; // 所有岗位
  2645. this._szTableName = "";
  2646. break;
  2647. }
  2648. this._devPos += this.comboBox2.Value.ToString();
  2649. }
  2650. private string GetTableName()
  2651. {
  2652. string szTableName = "";
  2653. switch (_devPos.Substring(0, 3))
  2654. {
  2655. case "HMP":
  2656. szTableName = "STL_HMP_OPTINFO";
  2657. break;
  2658. case "BOF":
  2659. szTableName = "STL_BOF_OPTINFO";
  2660. break;
  2661. case "CAS":
  2662. szTableName = "STL_CAS_OPTINFO";
  2663. break;
  2664. case "LFS":
  2665. szTableName = "STL_LFS_OPTINFO";
  2666. break;
  2667. case "CCM":
  2668. szTableName = "STL_CCM_OPTINFO";
  2669. break;
  2670. default:
  2671. break;
  2672. }
  2673. return szTableName;
  2674. }
  2675. /// <summary>
  2676. /// 设置设备选择框
  2677. /// </summary>
  2678. private void SetPost()
  2679. {
  2680. this._devPos = CurrectDevPos(this._devPos);
  2681. if (_devPos.Length < 5) return;
  2682. switch (_devPos.Substring(0, 3))
  2683. {
  2684. case "HMP":
  2685. this.cboGW.SelectedIndex = 0;
  2686. break;
  2687. case "BOF":
  2688. this.cboGW.SelectedIndex = 1;
  2689. break;
  2690. case "CAS":
  2691. this.cboGW.SelectedIndex = 2;
  2692. break;
  2693. case "LFS":
  2694. this.cboGW.SelectedIndex = 3;
  2695. break;
  2696. case "RHS":
  2697. this.cboGW.SelectedIndex = 4;
  2698. break;
  2699. case "CCM":
  2700. this.cboGW.SelectedIndex = 5;
  2701. break;
  2702. }
  2703. this.comboBox2.SelectedIndex = Convert.ToInt32(_devPos.Substring(4, 1));
  2704. }
  2705. private void GetDuty()
  2706. {
  2707. this._strDuty = this.cmb_BZ.SelectedIndex.ToString();
  2708. }
  2709. /// <summary>
  2710. /// 设置班组下拉框
  2711. /// </summary>
  2712. private void SetDuty()
  2713. {
  2714. try
  2715. {
  2716. this.cmb_BZ.SelectedIndex = Convert.ToInt32(this._strDuty);
  2717. }
  2718. catch { }
  2719. }
  2720. private string CurrectDevPos(string devPos)
  2721. {
  2722. if (devPos.Length < 5) return "";
  2723. if (devPos.Substring(0, 3) == "BOF")
  2724. {
  2725. switch (devPos.Substring(4, 1))
  2726. {
  2727. case "7":
  2728. devPos = devPos.Replace("7", "1");
  2729. break;
  2730. case "8":
  2731. devPos = devPos.Replace("8", "2");
  2732. break;
  2733. case "9":
  2734. devPos = devPos.Replace("9", "3");
  2735. break;
  2736. }
  2737. }
  2738. return devPos;
  2739. }
  2740. #endregion
  2741. #region " Auto Refresh "
  2742. private Thread _getDataThread;
  2743. private bool On_Off_GetDataThread = false;
  2744. private delegate void getDataFromAllDelegate();
  2745. private void StartGetDataThread()
  2746. {
  2747. try
  2748. {
  2749. ThreadStart ts = new ThreadStart(GetDataThread);
  2750. _getDataThread = new Thread(ts);
  2751. _getDataThread.Name = "GetDataThread ";
  2752. _getDataThread.Start();
  2753. }
  2754. catch { }
  2755. }
  2756. private void GetDataThread()
  2757. {
  2758. ReStartGetDataThread:
  2759. while (true)
  2760. {
  2761. if (!this.On_Off_Thread || !On_Off_GetDataThread)
  2762. {
  2763. System.Threading.Thread.Sleep(500);
  2764. continue;
  2765. }
  2766. try
  2767. {
  2768. this.Invoke(new getDataFromAllDelegate(GetDataFromAll));
  2769. System.Threading.Thread.Sleep(3000);
  2770. }
  2771. catch
  2772. { }
  2773. }
  2774. goto ReStartGetDataThread;
  2775. }
  2776. private void chkRefresh_CheckedChanged(object sender, EventArgs e)
  2777. {
  2778. On_Off_GetDataThread = this.chkRefresh.Checked;
  2779. }
  2780. #endregion
  2781. private int nRow = -1;
  2782. private Color c3 = Color.White;
  2783. private bool bColor = false;
  2784. private void EMGrid_Click(object sender, System.EventArgs e)
  2785. {
  2786. if (this.EMGrid.ActiveRow != null)
  2787. {
  2788. foreach (Infragistics.Win.UltraWinGrid.UltraGridRow rw in this.EMGrid.Rows)
  2789. {
  2790. if (rw.Appearance.BackColor == Color.LightBlue)
  2791. rw.Appearance.BackColor = Color.White;
  2792. }
  2793. if (bColor)
  2794. {
  2795. if (nRow < EMGrid.Rows.Count)
  2796. this.EMGrid.Rows[nRow].Appearance.BackColor = c3;
  2797. }
  2798. else
  2799. {
  2800. bColor = true;
  2801. }
  2802. c3 = this.EMGrid.ActiveRow.Appearance.BackColor;
  2803. nRow = this.EMGrid.ActiveRow.Index;
  2804. this.EMGrid.ActiveRow.Appearance.BackColor = Color.LightBlue;
  2805. }
  2806. }
  2807. #endregion
  2808. private void cboGW_SelectionChanged(object sender, EventArgs e)
  2809. {
  2810. comboBox2.Items.Clear();
  2811. int index;
  2812. index = cboGW.SelectedIndex;
  2813. switch (index)
  2814. {
  2815. case 1:
  2816. comboBox2.Items.Add(0, "所有");
  2817. comboBox2.Items.Add(1, "1#转炉");
  2818. comboBox2.Items.Add(2, "2#转炉");
  2819. break;
  2820. case 2:
  2821. comboBox2.Items.Add(0, "所有");
  2822. comboBox2.Items.Add(1, "1#吹氩站");
  2823. comboBox2.Items.Add(2, "2#吹氩站");
  2824. break;
  2825. case 3:
  2826. comboBox2.Items.Add(0, "所有");
  2827. comboBox2.Items.Add(1, "1#精炼炉");
  2828. comboBox2.Items.Add(2, "2#精炼炉");
  2829. break;
  2830. case 4:
  2831. comboBox2.Items.Add(0, "所有");
  2832. comboBox2.Items.Add(1, "RH炉");
  2833. break;
  2834. case 5:
  2835. comboBox2.Items.Add(0, "所有");
  2836. comboBox2.Items.Add(1, "VD炉");
  2837. break;
  2838. case 6:
  2839. comboBox2.Items.Add(0, "所有");
  2840. comboBox2.Items.Add(1, "1#连铸");
  2841. comboBox2.Items.Add(2, "2#连铸");
  2842. comboBox2.Items.Add(3, "3#连铸");
  2843. break;
  2844. default:
  2845. comboBox2.Items.Add(0, "所有铁水");
  2846. break;
  2847. }
  2848. comboBox2.SelectedIndex = 0;
  2849. }
  2850. /// <summary>
  2851. /// 解析作业路线
  2852. /// </summary>
  2853. /// <param name="craftPath">路线代码</param>
  2854. /// <returns></returns>
  2855. public string analysPath(string craftPath, string strPath)
  2856. {
  2857. string path = "", strcPath = "";
  2858. strcPath = strPath;
  2859. try
  2860. {
  2861. string StationCode = craftPath.Substring(0, 2);
  2862. string strCS = "";
  2863. if (strPath.Length < 5)
  2864. {
  2865. strCS = strcPath.Substring(2, 2);
  2866. }
  2867. else if (strPath.Length > 5 && strcPath.Length < 7)
  2868. {
  2869. strCS = strcPath.Substring(2, 4);
  2870. }
  2871. else
  2872. strCS = strcPath.Substring(2, 3);
  2873. switch (StationCode)
  2874. {
  2875. case "B0":
  2876. path = "脱硫" + Convert.ToInt32(strCS) + "次样";
  2877. break;
  2878. case "B1":
  2879. path = "1#脱硫" + Convert.ToInt32(strCS) + "次样";
  2880. break;
  2881. case "B2":
  2882. path = "2#脱硫" + Convert.ToInt32(strCS) + "次样";
  2883. break;
  2884. case "C0":
  2885. path = "转炉" + Convert.ToInt32(strCS) + "次样";
  2886. break;
  2887. case "C1":
  2888. path = "1#转炉" + Convert.ToInt32(strCS) + "次样";
  2889. break;
  2890. case "C2":
  2891. path = "2#转炉" + Convert.ToInt32(strCS) + "次样";
  2892. break;
  2893. case "D0":
  2894. path = "吹氩" + Convert.ToInt32(strCS) + "次样";
  2895. break;
  2896. case "D1":
  2897. path = "1#吹氩" + Convert.ToInt32(strCS) + "次样";
  2898. break;
  2899. case "D2":
  2900. path = "2#吹氩" + Convert.ToInt32(strCS) + "次样";
  2901. break;
  2902. case "DQ":
  2903. path = "CAS前" + Convert.ToInt32(strCS) + "次样";
  2904. break;
  2905. case "DH":
  2906. path = "CAS后" + Convert.ToInt32(strCS) + "次样";
  2907. break;
  2908. case "E0":
  2909. path = "LF炉" + Convert.ToInt32(strCS) + "次样";
  2910. break;
  2911. case "E1":
  2912. path = "1#LF炉" + Convert.ToInt32(strCS) + "次样";
  2913. break;
  2914. case "E2":
  2915. path = "2#LF炉" + Convert.ToInt32(strCS) + "次样";
  2916. break;
  2917. case "F0":
  2918. path = "RH炉" + Convert.ToInt32(strCS) + "次样";
  2919. break;
  2920. case "F1":
  2921. path = "RH炉" + Convert.ToInt32(strCS) + "次样";
  2922. break;
  2923. case "I0":
  2924. path = "VD炉" + Convert.ToInt32(strCS) + "次样";
  2925. break;
  2926. case "I1":
  2927. path = "VD炉" + Convert.ToInt32(strCS) + "次样";
  2928. break;
  2929. case "GP":
  2930. path = "连铸" + Convert.ToInt32(strCS) + "次样"; ;
  2931. break;
  2932. }
  2933. }
  2934. catch
  2935. {
  2936. }
  2937. return path;
  2938. }
  2939. private void ultraToolbarsManager1_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs e)
  2940. {
  2941. }
  2942. /// <summary>
  2943. /// </summary>
  2944. /// <param> </param>
  2945. /// <seealso cref="String">
  2946. /// 计算成份偏差主体</seealso>
  2947. ///
  2948. private void doInitChemelentDifference(string vHeatNo)
  2949. {
  2950. try
  2951. {
  2952. DataTable dt = this.dataTable1;
  2953. DataView dv = new DataView(dt);
  2954. dv.RowFilter = string.Format(" 熔炼号 = '{0}'", vHeatNo);
  2955. DataRow drTemp = null;
  2956. DataRow drSource = null;
  2957. DataRow dr = dt.NewRow();
  2958. if (dv != null && dv.Table.Rows.Count > 0)
  2959. {
  2960. dv.Sort = "化验时间 desc";
  2961. }
  2962. if (dv.ToTable().Rows[0]["Station"].ToString().Contains("连铸") && dv.ToTable().Rows.Count >= 2)
  2963. {
  2964. drSource = dv.ToTable().Rows[0];
  2965. drTemp = dv.ToTable().Rows[1];
  2966. if (drTemp["Station"].ToString().Contains("连铸") && dv.ToTable().Rows.Count >= 3)
  2967. {
  2968. drTemp = dv.ToTable().Rows[2];
  2969. }
  2970. }
  2971. else
  2972. return;
  2973. for (int i = 0; i < drSource.Table.Columns.Count; i++)
  2974. {
  2975. try
  2976. {
  2977. if (Convert.ToDouble(drSource[i].ToString()) > 0)
  2978. {
  2979. dr[i] = Math.Round(Convert.ToDouble(drSource[i].ToString()) - Convert.ToDouble(drTemp[i].ToString()), 4);
  2980. }
  2981. }
  2982. catch
  2983. {
  2984. dr[i] = drSource[i];
  2985. }
  2986. }
  2987. dr["Station"] = "成分偏差";
  2988. dr["SumTime"] = 1;
  2989. dr["shiftcode"] = drSource["shiftcode"];
  2990. //20150401
  2991. dr["CM"] = "";
  2992. dr["SAMPLE_DATE1"] = "";
  2993. System.DateTime dtime = Convert.ToDateTime(dr["化验时间"].ToString());
  2994. dtime.AddMinutes(1);
  2995. dr["化验时间"] = dtime.ToString();
  2996. dt.Rows.Add(dr);
  2997. dt.AcceptChanges();
  2998. }
  2999. catch (Exception ex)
  3000. {
  3001. }
  3002. }
  3003. /// <summary>
  3004. /// </summary>
  3005. /// <param> </param>
  3006. /// <seealso cref="String">
  3007. /// 获取带有连铸信息的所有炉号</seealso>
  3008. /// 返回list
  3009. private ArrayList getHeatNo()
  3010. {
  3011. ArrayList list = new ArrayList();
  3012. foreach (DataRow dr in dataTable1.Rows)
  3013. {
  3014. if (!list.Contains(dr["熔炼号"].ToString()) && dr["Station"].ToString().Contains("连铸"))
  3015. {
  3016. list.Add(dr["熔炼号"].ToString());
  3017. }
  3018. }
  3019. return list;
  3020. }
  3021. /// <summary>
  3022. /// </summary>
  3023. /// <param> </param>
  3024. /// <seealso cref="String">
  3025. /// 计算连铸工序和前道工序的成份偏差</seealso>
  3026. private void calculateChemelentDifference()
  3027. {
  3028. ArrayList list = this.getHeatNo();
  3029. foreach (string s in list)
  3030. {
  3031. this.doInitChemelentDifference(s);
  3032. }
  3033. DataTable tbTemp = new DataTable();
  3034. tbTemp.Merge(this.dataTable1);
  3035. DataView dv = new DataView(tbTemp);
  3036. dv.Sort = "熔炼号 desc,化验时间 asc";
  3037. this.dataTable1.Clear();
  3038. this.dataTable1.Merge(dv.ToTable());
  3039. }
  3040. private void button1_Click(object sender, EventArgs e)
  3041. {
  3042. }
  3043. private void button1_Click_1(object sender, EventArgs e)
  3044. {
  3045. try
  3046. {
  3047. ClientParamWithSqlConditionAndOpenBase param = new ClientParamWithSqlConditionAndOpenBase();
  3048. param.param = new object[] { this.uldtBeginTime.DateTime.ToString("yyyy-MM-dd HH:mm:ss"), this.uldtEndTime.DateTime.ToString("yyyy-MM-dd HH:mm:ss") };
  3049. param.ob = this.ob;
  3050. Core.LgMes.Client.lgBll.LgChemeLementMgt.LgChemeLementMgt.Insert_StlChemelementCeq(param);
  3051. }
  3052. catch
  3053. { }
  3054. }
  3055. #region 20150401 新增送样时间,化验时间差
  3056. private DataSet ObtainSamplesignal(DataTable dtTemp)
  3057. {
  3058. List<string> heatNoList = removeDuplicate(GetColumnStringValueFromDataSourceByColumnName(dtTemp, "HEATNO"));
  3059. string sqlCondition = GetSqlConditionFromHeatNoList(heatNoList);
  3060. DataSet dt = MethodCallService(sqlCondition);
  3061. return dt;
  3062. }
  3063. public DataSet MethodCallService(string sqlCondition)
  3064. {
  3065. DataSet ds = new DataSet();
  3066. string strErr = "";
  3067. string strSql = string.Format(@"select * from (select t.*,row_number() over(partition by heatno,strpos order by sample_date1 desc) rn
  3068. from stl_air_samplesignal t where {0} union all select t.*,row_number() over(partition by heatno,strpos order by sample_date1 desc) rn
  3069. from J#stl_Air_Samplesignal t where {0}) order by rn asc", sqlCondition);
  3070. CommonClientToServer cctos = new CommonClientToServer();
  3071. cctos.ob = this.ob;
  3072. ds = cctos.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBExecute",
  3073. "doSimpleQuery", strSql, out strErr);
  3074. return ds;
  3075. }
  3076. public List<String> GetColumnStringValueFromDataSourceByColumnName(DataTable dsSource, string columnName)
  3077. {
  3078. List<String> list = new List<string>();
  3079. if (dsSource == null || dsSource.Rows.Count == 0 || columnName.Length == 0)
  3080. return list;
  3081. if (!dsSource.Columns.Contains(columnName.ToUpper()))
  3082. return list;
  3083. try
  3084. {
  3085. foreach (DataRow dr in dsSource.Rows)
  3086. {
  3087. try
  3088. {
  3089. list.Add(dr[columnName.ToUpper()].ToString());
  3090. }
  3091. catch
  3092. {
  3093. break;
  3094. }
  3095. }
  3096. }
  3097. catch
  3098. {
  3099. }
  3100. return list;
  3101. }
  3102. private List<string> removeDuplicate(List<string> lists)
  3103. {
  3104. for (int i = 0; i < lists.Count; i++)
  3105. {
  3106. for (int j = lists.Count - 1; j >= 0; j--)
  3107. {
  3108. if (i != j)
  3109. {
  3110. if (lists[i] == lists[j])
  3111. {
  3112. lists.Remove(lists[j]);
  3113. }
  3114. }
  3115. }
  3116. }
  3117. return lists;
  3118. }
  3119. /// <summary>
  3120. /// 拼接查询条件
  3121. /// </summary>
  3122. /// <param name="heatNoList"></param>
  3123. /// <returns></returns>
  3124. private string GetSqlConditionFromHeatNoList(List<string> heatNoList)
  3125. {
  3126. string strSqlHeatno = "";
  3127. string strsqlwhere = "";
  3128. string strsql = "";
  3129. foreach (string heatno in heatNoList)
  3130. {
  3131. strSqlHeatno = "heatno = '" + heatno + "' or ";
  3132. strsqlwhere += strSqlHeatno;
  3133. }
  3134. strsql = strsqlwhere + " 1 = 2";
  3135. return strsql;
  3136. }
  3137. public int Count(DataSet ds)
  3138. {
  3139. try
  3140. {
  3141. return ds.Tables[0].Rows.Count;
  3142. }
  3143. catch
  3144. {
  3145. }
  3146. return 0;
  3147. }
  3148. /// <summary>
  3149. /// 根据岗位号获取工序中文名
  3150. /// </summary>
  3151. /// <param name="_DEVICE_POSITION">岗位编码</param>
  3152. /// <returns>工序中文名</returns>
  3153. public string analysChineseName(string _DEVICE_POSITION)
  3154. {
  3155. string strChineseName = ""; //工序代码
  3156. if (!string.IsNullOrEmpty(_DEVICE_POSITION))
  3157. {
  3158. switch (_DEVICE_POSITION.Substring(0, 3))
  3159. {
  3160. case "HMP":
  3161. strChineseName = "脱硫站";
  3162. break;
  3163. case "BOF":
  3164. strChineseName = "转炉";
  3165. break;
  3166. case "CAS":
  3167. strChineseName = "吹氩站";
  3168. break;
  3169. case "LFS":
  3170. strChineseName = "LF炉";
  3171. break;
  3172. case "RHS":
  3173. strChineseName = "RH炉";
  3174. break;
  3175. case "VDS":
  3176. strChineseName = "VD炉";
  3177. break;
  3178. case "CCM":
  3179. strChineseName = "连铸";
  3180. break;
  3181. default:
  3182. break;
  3183. }
  3184. }
  3185. return strChineseName;
  3186. }
  3187. DataSet dtSamplesignal = null;
  3188. #endregion
  3189. /// <summary>
  3190. /// 检测备注的保存及修改
  3191. /// </summary>
  3192. /// <param name="sender"></param>
  3193. /// <param name="e"></param>
  3194. private void button2_Click(object sender, EventArgs e)
  3195. {
  3196. string strErr = "";
  3197. Infragistics.Win.UltraWinGrid.UltraGridRow aRow = EMGrid.ActiveRow;
  3198. string heatno = aRow.Cells["熔炼号"].Text;
  3199. string remark = aRow.Cells["REMARK"].Text;
  3200. string assaydate = aRow.Cells["化验时间"].Text;
  3201. //OracleConnection conn = new OracleConnection(@"Data Source=EJGZXT;User ID=xgejgzxt;Password=xgejgzxt");//Data Source后面跟你数据库的名字,User ID为用户名,Password为密码
  3202. //conn.Open();
  3203. //string sql = "update stl_chemelement set REMARK='" + remark + "' where HEATNO='" + heatno + "' and ASSAYDATE=to_date('" + assaydate + "','yyyy-MM-dd hh24:mi:ss')";
  3204. //OracleCommand cmd = new OracleCommand(sql, conn);
  3205. //int result = cmd.ExecuteNonQuery();//result接收受影响行数,也就是说result大于0的话表示添加成功
  3206. //conn.Close();
  3207. //cmd.Dispose();
  3208. //if (result>0)
  3209. //-----------------------------------对数据库的操作要写在服务端,因为客户端可能连接不到数据库----------------------------------------------------
  3210. ArrayList arryOver = new ArrayList();
  3211. arryOver.Add("UpdateOREMARKCHEM.select");
  3212. arryOver.Add(remark);
  3213. arryOver.Add(heatno);
  3214. arryOver.Add(assaydate);
  3215. CommonClientToServer cctos = new CommonClientToServer();
  3216. cctos.ob = this.ob;
  3217. DataSet dsobject = cctos.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBSave",
  3218. "doSimpleSave", arryOver, out strErr);
  3219. if (strErr == "")
  3220. {
  3221. MessageBox.Show("保存成功!");
  3222. }
  3223. else
  3224. {
  3225. MessageBox.Show("保存失败!");
  3226. }
  3227. }
  3228. }
  3229. }