frmLgEleDetail.cs 37 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800
  1. using System;
  2. using System.Drawing;
  3. using System.Collections;
  4. using System.ComponentModel;
  5. using System.Windows.Forms;
  6. using System.Data;
  7. using CoreFS.CA06;
  8. using Infragistics.Win;
  9. using Infragistics.Win.UltraWinGrid;
  10. using Core.StlMes.Client.LgCommon;
  11. namespace Core.StlMes.Client.LgIntegrationQuery
  12. {
  13. /// <summary>
  14. /// ElementsForm 的摘要说明。
  15. /// </summary>
  16. public class frmLgEleDetail : frmStyleBase
  17. {
  18. OpeBase ob = null;
  19. private System.Data.DataSet dataSet1;
  20. private System.Data.DataTable dataTable1;
  21. private System.Data.DataColumn dataColumn1;
  22. private System.Data.DataColumn dataColumn2;
  23. private System.ComponentModel.IContainer components;
  24. private DataColumn dataColumn5;
  25. private DataColumn dataColumn6;
  26. private DataColumn dataColumn3;
  27. private DataColumn dataColumn7;
  28. private DataColumn dataColumn8;
  29. private DataColumn dataColumn10;
  30. private DataColumn dataColumn11;
  31. private DataColumn dataColumn12;
  32. private DataColumn dataColumn4;
  33. private DataColumn dataColumn9;
  34. private DataColumn dataColumn13; //化学成分标准列名
  35. public static string strSteelCode = "";
  36. private Panel panel1;
  37. private Label label1;
  38. private Label label2;
  39. private Label label4;
  40. private Label label3;
  41. private Label label7;
  42. private Label label10;
  43. private Label label9;
  44. private UltraGrid ultraGrid1;
  45. private string strOrderno = "";
  46. private Hashtable tabChement;
  47. private string strHeatNo = "";
  48. private Label label6;
  49. private Label label8;
  50. public Infragistics.Win.UltraWinGrid.UltraGridRow ultrgridRow;
  51. //public string Hic
  52. //{
  53. // get
  54. // {
  55. // return StrHic;
  56. // }
  57. // set
  58. // {
  59. // StrHic = value;
  60. // }
  61. //}
  62. //public string Bzhi
  63. //{
  64. // get
  65. // {
  66. // return StrT;
  67. // }
  68. // set
  69. // {
  70. // StrT = value;
  71. // }
  72. //}
  73. public frmLgEleDetail(string heatno, OpeBase oba)
  74. {
  75. //
  76. // Windows 窗体设计器支持所必需的
  77. //
  78. InitializeComponent();
  79. strHeatNo = heatno;
  80. ob = oba;
  81. }
  82. /// <summary>
  83. /// 清理所有正在使用的资源。
  84. /// </summary>
  85. protected override void Dispose(bool disposing)
  86. {
  87. if (disposing)
  88. {
  89. if (components != null)
  90. {
  91. components.Dispose();
  92. }
  93. }
  94. base.Dispose(disposing);
  95. }
  96. #region Windows 窗体设计器生成的代码
  97. /// <summary>
  98. /// 设计器支持所需的方法 - 不要使用代码编辑器修改
  99. /// 此方法的内容。
  100. /// </summary>
  101. private void InitializeComponent()
  102. {
  103. Infragistics.Win.Appearance appearance13 = new Infragistics.Win.Appearance();
  104. Infragistics.Win.UltraWinGrid.UltraGridBand ultraGridBand1 = new Infragistics.Win.UltraWinGrid.UltraGridBand("Table1", -1);
  105. Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn1 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("ID");
  106. Infragistics.Win.Appearance appearance1 = new Infragistics.Win.Appearance();
  107. Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn2 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("Element");
  108. Infragistics.Win.Appearance appearance2 = new Infragistics.Win.Appearance();
  109. Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn3 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("内控标准");
  110. Infragistics.Win.Appearance appearance3 = new Infragistics.Win.Appearance();
  111. Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn4 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("NSTDMIN");
  112. Infragistics.Win.Appearance appearance4 = new Infragistics.Win.Appearance();
  113. Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn5 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("NSTDMAX");
  114. Infragistics.Win.Appearance appearance5 = new Infragistics.Win.Appearance();
  115. Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn6 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("TSTDMIN");
  116. Infragistics.Win.Appearance appearance6 = new Infragistics.Win.Appearance();
  117. Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn7 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("TSTDMAX");
  118. Infragistics.Win.Appearance appearance7 = new Infragistics.Win.Appearance();
  119. Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn8 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("放行标准");
  120. Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn9 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("FSTDMIN");
  121. Infragistics.Win.Appearance appearance8 = new Infragistics.Win.Appearance();
  122. Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn10 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("FSTDMAX");
  123. Infragistics.Win.Appearance appearance9 = new Infragistics.Win.Appearance();
  124. Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn11 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("特殊要求");
  125. Infragistics.Win.Appearance appearance10 = new Infragistics.Win.Appearance();
  126. Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn12 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("STD");
  127. Infragistics.Win.Appearance appearance11 = new Infragistics.Win.Appearance();
  128. Infragistics.Win.UltraWinGrid.UltraGridColumn ultraGridColumn13 = new Infragistics.Win.UltraWinGrid.UltraGridColumn("ResVaule");
  129. Infragistics.Win.Appearance appearance12 = new Infragistics.Win.Appearance();
  130. System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(frmLgEleDetail));
  131. this.dataSet1 = new System.Data.DataSet();
  132. this.dataTable1 = new System.Data.DataTable();
  133. this.dataColumn1 = new System.Data.DataColumn();
  134. this.dataColumn2 = new System.Data.DataColumn();
  135. this.dataColumn5 = new System.Data.DataColumn();
  136. this.dataColumn6 = new System.Data.DataColumn();
  137. this.dataColumn3 = new System.Data.DataColumn();
  138. this.dataColumn7 = new System.Data.DataColumn();
  139. this.dataColumn8 = new System.Data.DataColumn();
  140. this.dataColumn10 = new System.Data.DataColumn();
  141. this.dataColumn11 = new System.Data.DataColumn();
  142. this.dataColumn12 = new System.Data.DataColumn();
  143. this.dataColumn4 = new System.Data.DataColumn();
  144. this.dataColumn9 = new System.Data.DataColumn();
  145. this.dataColumn13 = new System.Data.DataColumn();
  146. this.ultraGrid1 = new Infragistics.Win.UltraWinGrid.UltraGrid();
  147. this.panel1 = new System.Windows.Forms.Panel();
  148. this.label7 = new System.Windows.Forms.Label();
  149. this.label10 = new System.Windows.Forms.Label();
  150. this.label9 = new System.Windows.Forms.Label();
  151. this.label8 = new System.Windows.Forms.Label();
  152. this.label6 = new System.Windows.Forms.Label();
  153. this.label3 = new System.Windows.Forms.Label();
  154. this.label2 = new System.Windows.Forms.Label();
  155. this.label1 = new System.Windows.Forms.Label();
  156. this.label4 = new System.Windows.Forms.Label();
  157. ((System.ComponentModel.ISupportInitialize)(this.dataSet1)).BeginInit();
  158. ((System.ComponentModel.ISupportInitialize)(this.dataTable1)).BeginInit();
  159. ((System.ComponentModel.ISupportInitialize)(this.ultraGrid1)).BeginInit();
  160. this.panel1.SuspendLayout();
  161. this.SuspendLayout();
  162. //
  163. // dataSet1
  164. //
  165. this.dataSet1.DataSetName = "NewDataSet";
  166. this.dataSet1.Locale = new System.Globalization.CultureInfo("zh-CN");
  167. this.dataSet1.Tables.AddRange(new System.Data.DataTable[] {
  168. this.dataTable1});
  169. //
  170. // dataTable1
  171. //
  172. this.dataTable1.Columns.AddRange(new System.Data.DataColumn[] {
  173. this.dataColumn1,
  174. this.dataColumn2,
  175. this.dataColumn5,
  176. this.dataColumn6,
  177. this.dataColumn3,
  178. this.dataColumn7,
  179. this.dataColumn8,
  180. this.dataColumn10,
  181. this.dataColumn11,
  182. this.dataColumn12,
  183. this.dataColumn4,
  184. this.dataColumn9,
  185. this.dataColumn13});
  186. this.dataTable1.TableName = "Table1";
  187. //
  188. // dataColumn1
  189. //
  190. this.dataColumn1.Caption = "序号";
  191. this.dataColumn1.ColumnName = "ID";
  192. //
  193. // dataColumn2
  194. //
  195. this.dataColumn2.Caption = "成分代码";
  196. this.dataColumn2.ColumnName = "Element";
  197. //
  198. // dataColumn5
  199. //
  200. this.dataColumn5.Caption = "内控标准";
  201. this.dataColumn5.ColumnName = "内控标准";
  202. //
  203. // dataColumn6
  204. //
  205. this.dataColumn6.Caption = "最小值";
  206. this.dataColumn6.ColumnName = "NSTDMIN";
  207. //
  208. // dataColumn3
  209. //
  210. this.dataColumn3.Caption = "最大值";
  211. this.dataColumn3.ColumnName = "NSTDMAX";
  212. //
  213. // dataColumn7
  214. //
  215. this.dataColumn7.Caption = "最小值";
  216. this.dataColumn7.ColumnName = "TSTDMIN";
  217. //
  218. // dataColumn8
  219. //
  220. this.dataColumn8.Caption = "最大值";
  221. this.dataColumn8.ColumnName = "TSTDMAX";
  222. //
  223. // dataColumn10
  224. //
  225. this.dataColumn10.ColumnName = "放行标准";
  226. //
  227. // dataColumn11
  228. //
  229. this.dataColumn11.Caption = "最小值";
  230. this.dataColumn11.ColumnName = "FSTDMIN";
  231. //
  232. // dataColumn12
  233. //
  234. this.dataColumn12.Caption = "最大值";
  235. this.dataColumn12.ColumnName = "FSTDMAX";
  236. //
  237. // dataColumn4
  238. //
  239. this.dataColumn4.ColumnName = "特殊要求";
  240. //
  241. // dataColumn9
  242. //
  243. this.dataColumn9.Caption = "目标值";
  244. this.dataColumn9.ColumnName = "STD";
  245. //
  246. // dataColumn13
  247. //
  248. this.dataColumn13.Caption = "实绩值";
  249. this.dataColumn13.ColumnName = "ResVaule";
  250. //
  251. // ultraGrid1
  252. //
  253. this.ultraGrid1.DataMember = "Table1";
  254. this.ultraGrid1.DataSource = this.dataSet1;
  255. appearance13.BackGradientStyle = Infragistics.Win.GradientStyle.None;
  256. this.ultraGrid1.DisplayLayout.Appearance = appearance13;
  257. ultraGridColumn1.CellActivation = Infragistics.Win.UltraWinGrid.Activation.ActivateOnly;
  258. appearance1.TextHAlignAsString = "Center";
  259. appearance1.TextVAlignAsString = "Middle";
  260. ultraGridColumn1.CellAppearance = appearance1;
  261. ultraGridColumn1.Header.VisiblePosition = 0;
  262. ultraGridColumn1.Hidden = true;
  263. ultraGridColumn1.RowLayoutColumnInfo.OriginX = 0;
  264. ultraGridColumn1.RowLayoutColumnInfo.OriginY = 0;
  265. ultraGridColumn1.RowLayoutColumnInfo.PreferredCellSize = new System.Drawing.Size(34, 0);
  266. ultraGridColumn1.RowLayoutColumnInfo.PreferredLabelSize = new System.Drawing.Size(0, 48);
  267. ultraGridColumn1.RowLayoutColumnInfo.SpanX = 1;
  268. ultraGridColumn1.RowLayoutColumnInfo.SpanY = 4;
  269. ultraGridColumn2.CellActivation = Infragistics.Win.UltraWinGrid.Activation.ActivateOnly;
  270. appearance2.TextHAlignAsString = "Center";
  271. appearance2.TextVAlignAsString = "Middle";
  272. ultraGridColumn2.CellAppearance = appearance2;
  273. ultraGridColumn2.Header.VisiblePosition = 1;
  274. ultraGridColumn2.RowLayoutColumnInfo.OriginX = 0;
  275. ultraGridColumn2.RowLayoutColumnInfo.OriginY = 0;
  276. ultraGridColumn2.RowLayoutColumnInfo.PreferredCellSize = new System.Drawing.Size(53, 0);
  277. ultraGridColumn2.RowLayoutColumnInfo.PreferredLabelSize = new System.Drawing.Size(0, 48);
  278. ultraGridColumn2.RowLayoutColumnInfo.SpanX = 1;
  279. ultraGridColumn2.RowLayoutColumnInfo.SpanY = 4;
  280. ultraGridColumn3.CellActivation = Infragistics.Win.UltraWinGrid.Activation.ActivateOnly;
  281. appearance3.TextHAlignAsString = "Center";
  282. appearance3.TextVAlignAsString = "Middle";
  283. ultraGridColumn3.CellAppearance = appearance3;
  284. ultraGridColumn3.Header.VisiblePosition = 2;
  285. ultraGridColumn3.RowLayoutColumnInfo.LabelPosition = Infragistics.Win.UltraWinGrid.LabelPosition.LabelOnly;
  286. ultraGridColumn3.RowLayoutColumnInfo.OriginX = 2;
  287. ultraGridColumn3.RowLayoutColumnInfo.OriginY = 0;
  288. ultraGridColumn3.RowLayoutColumnInfo.PreferredCellSize = new System.Drawing.Size(120, 0);
  289. ultraGridColumn3.RowLayoutColumnInfo.SpanX = 2;
  290. ultraGridColumn3.RowLayoutColumnInfo.SpanY = 2;
  291. ultraGridColumn4.CellActivation = Infragistics.Win.UltraWinGrid.Activation.ActivateOnly;
  292. appearance4.TextHAlignAsString = "Center";
  293. appearance4.TextVAlignAsString = "Middle";
  294. ultraGridColumn4.CellAppearance = appearance4;
  295. ultraGridColumn4.Header.VisiblePosition = 3;
  296. ultraGridColumn4.RowLayoutColumnInfo.OriginX = 2;
  297. ultraGridColumn4.RowLayoutColumnInfo.OriginY = 2;
  298. ultraGridColumn4.RowLayoutColumnInfo.PreferredCellSize = new System.Drawing.Size(52, 0);
  299. ultraGridColumn4.RowLayoutColumnInfo.SpanX = 1;
  300. ultraGridColumn4.RowLayoutColumnInfo.SpanY = 2;
  301. ultraGridColumn5.CellActivation = Infragistics.Win.UltraWinGrid.Activation.ActivateOnly;
  302. appearance5.TextHAlignAsString = "Center";
  303. appearance5.TextVAlignAsString = "Middle";
  304. ultraGridColumn5.CellAppearance = appearance5;
  305. ultraGridColumn5.Header.VisiblePosition = 4;
  306. ultraGridColumn5.RowLayoutColumnInfo.OriginX = 3;
  307. ultraGridColumn5.RowLayoutColumnInfo.OriginY = 2;
  308. ultraGridColumn5.RowLayoutColumnInfo.PreferredCellSize = new System.Drawing.Size(68, 0);
  309. ultraGridColumn5.RowLayoutColumnInfo.SpanX = 1;
  310. ultraGridColumn5.RowLayoutColumnInfo.SpanY = 2;
  311. ultraGridColumn6.CellActivation = Infragistics.Win.UltraWinGrid.Activation.ActivateOnly;
  312. appearance6.TextHAlignAsString = "Center";
  313. appearance6.TextVAlignAsString = "Middle";
  314. ultraGridColumn6.CellAppearance = appearance6;
  315. ultraGridColumn6.Header.VisiblePosition = 5;
  316. ultraGridColumn6.RowLayoutColumnInfo.OriginX = 6;
  317. ultraGridColumn6.RowLayoutColumnInfo.OriginY = 2;
  318. ultraGridColumn6.RowLayoutColumnInfo.PreferredCellSize = new System.Drawing.Size(59, 0);
  319. ultraGridColumn6.RowLayoutColumnInfo.SpanX = 1;
  320. ultraGridColumn6.RowLayoutColumnInfo.SpanY = 2;
  321. ultraGridColumn7.CellActivation = Infragistics.Win.UltraWinGrid.Activation.ActivateOnly;
  322. appearance7.TextHAlignAsString = "Center";
  323. appearance7.TextVAlignAsString = "Middle";
  324. ultraGridColumn7.CellAppearance = appearance7;
  325. ultraGridColumn7.Header.VisiblePosition = 6;
  326. ultraGridColumn7.RowLayoutColumnInfo.OriginX = 8;
  327. ultraGridColumn7.RowLayoutColumnInfo.OriginY = 2;
  328. ultraGridColumn7.RowLayoutColumnInfo.PreferredCellSize = new System.Drawing.Size(69, 0);
  329. ultraGridColumn7.RowLayoutColumnInfo.SpanX = 2;
  330. ultraGridColumn7.RowLayoutColumnInfo.SpanY = 2;
  331. ultraGridColumn8.CellActivation = Infragistics.Win.UltraWinGrid.Activation.ActivateOnly;
  332. ultraGridColumn8.Header.VisiblePosition = 7;
  333. ultraGridColumn8.Hidden = true;
  334. ultraGridColumn8.RowLayoutColumnInfo.LabelPosition = Infragistics.Win.UltraWinGrid.LabelPosition.LabelOnly;
  335. ultraGridColumn9.CellActivation = Infragistics.Win.UltraWinGrid.Activation.ActivateOnly;
  336. appearance8.TextHAlignAsString = "Center";
  337. appearance8.TextVAlignAsString = "Middle";
  338. ultraGridColumn9.CellAppearance = appearance8;
  339. ultraGridColumn9.Header.VisiblePosition = 8;
  340. ultraGridColumn9.Hidden = true;
  341. ultraGridColumn9.RowLayoutColumnInfo.OriginX = 4;
  342. ultraGridColumn9.RowLayoutColumnInfo.OriginY = 2;
  343. ultraGridColumn9.RowLayoutColumnInfo.PreferredCellSize = new System.Drawing.Size(56, 0);
  344. ultraGridColumn9.RowLayoutColumnInfo.SpanX = 1;
  345. ultraGridColumn9.RowLayoutColumnInfo.SpanY = 2;
  346. ultraGridColumn10.CellActivation = Infragistics.Win.UltraWinGrid.Activation.ActivateOnly;
  347. appearance9.TextHAlignAsString = "Center";
  348. appearance9.TextVAlignAsString = "Middle";
  349. ultraGridColumn10.CellAppearance = appearance9;
  350. ultraGridColumn10.Header.VisiblePosition = 9;
  351. ultraGridColumn10.Hidden = true;
  352. ultraGridColumn10.RowLayoutColumnInfo.OriginX = 5;
  353. ultraGridColumn10.RowLayoutColumnInfo.OriginY = 2;
  354. ultraGridColumn10.RowLayoutColumnInfo.PreferredCellSize = new System.Drawing.Size(53, 0);
  355. ultraGridColumn10.RowLayoutColumnInfo.SpanX = 1;
  356. ultraGridColumn10.RowLayoutColumnInfo.SpanY = 2;
  357. ultraGridColumn11.CellActivation = Infragistics.Win.UltraWinGrid.Activation.ActivateOnly;
  358. appearance10.TextHAlignAsString = "Center";
  359. appearance10.TextVAlignAsString = "Middle";
  360. ultraGridColumn11.CellAppearance = appearance10;
  361. ultraGridColumn11.Header.VisiblePosition = 10;
  362. ultraGridColumn11.RowLayoutColumnInfo.LabelPosition = Infragistics.Win.UltraWinGrid.LabelPosition.LabelOnly;
  363. ultraGridColumn11.RowLayoutColumnInfo.OriginX = 6;
  364. ultraGridColumn11.RowLayoutColumnInfo.OriginY = 0;
  365. ultraGridColumn11.RowLayoutColumnInfo.PreferredCellSize = new System.Drawing.Size(128, 0);
  366. ultraGridColumn11.RowLayoutColumnInfo.SpanX = 4;
  367. ultraGridColumn11.RowLayoutColumnInfo.SpanY = 2;
  368. ultraGridColumn12.CellActivation = Infragistics.Win.UltraWinGrid.Activation.ActivateOnly;
  369. appearance11.TextHAlignAsString = "Center";
  370. appearance11.TextVAlignAsString = "Middle";
  371. ultraGridColumn12.CellAppearance = appearance11;
  372. ultraGridColumn12.Header.VisiblePosition = 11;
  373. ultraGridColumn12.Hidden = true;
  374. ultraGridColumn12.RowLayoutColumnInfo.OriginX = 1;
  375. ultraGridColumn12.RowLayoutColumnInfo.OriginY = 0;
  376. ultraGridColumn12.RowLayoutColumnInfo.PreferredCellSize = new System.Drawing.Size(53, 0);
  377. ultraGridColumn12.RowLayoutColumnInfo.PreferredLabelSize = new System.Drawing.Size(0, 48);
  378. ultraGridColumn12.RowLayoutColumnInfo.SpanX = 1;
  379. ultraGridColumn12.RowLayoutColumnInfo.SpanY = 4;
  380. ultraGridColumn13.CellActivation = Infragistics.Win.UltraWinGrid.Activation.ActivateOnly;
  381. appearance12.TextHAlignAsString = "Center";
  382. appearance12.TextVAlignAsString = "Middle";
  383. ultraGridColumn13.CellAppearance = appearance12;
  384. ultraGridColumn13.Header.VisiblePosition = 12;
  385. ultraGridColumn13.RowLayoutColumnInfo.OriginX = 10;
  386. ultraGridColumn13.RowLayoutColumnInfo.OriginY = 0;
  387. ultraGridColumn13.RowLayoutColumnInfo.PreferredCellSize = new System.Drawing.Size(70, 0);
  388. ultraGridColumn13.RowLayoutColumnInfo.PreferredLabelSize = new System.Drawing.Size(0, 48);
  389. ultraGridColumn13.RowLayoutColumnInfo.SpanX = 1;
  390. ultraGridColumn13.RowLayoutColumnInfo.SpanY = 4;
  391. ultraGridBand1.Columns.AddRange(new object[] {
  392. ultraGridColumn1,
  393. ultraGridColumn2,
  394. ultraGridColumn3,
  395. ultraGridColumn4,
  396. ultraGridColumn5,
  397. ultraGridColumn6,
  398. ultraGridColumn7,
  399. ultraGridColumn8,
  400. ultraGridColumn9,
  401. ultraGridColumn10,
  402. ultraGridColumn11,
  403. ultraGridColumn12,
  404. ultraGridColumn13});
  405. ultraGridBand1.RowLayoutStyle = Infragistics.Win.UltraWinGrid.RowLayoutStyle.ColumnLayout;
  406. this.ultraGrid1.DisplayLayout.BandsSerializer.Add(ultraGridBand1);
  407. this.ultraGrid1.Dock = System.Windows.Forms.DockStyle.Fill;
  408. this.ultraGrid1.Font = new System.Drawing.Font("宋体", 10.5F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
  409. this.ultraGrid1.Location = new System.Drawing.Point(0, 0);
  410. this.ultraGrid1.Name = "ultraGrid1";
  411. this.ultraGrid1.Size = new System.Drawing.Size(411, 407);
  412. this.ultraGrid1.TabIndex = 6;
  413. //
  414. // panel1
  415. //
  416. this.panel1.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(158)))), ((int)(((byte)(191)))), ((int)(((byte)(231)))));
  417. this.panel1.Controls.Add(this.label7);
  418. this.panel1.Controls.Add(this.label10);
  419. this.panel1.Controls.Add(this.label9);
  420. this.panel1.Controls.Add(this.label8);
  421. this.panel1.Controls.Add(this.label6);
  422. this.panel1.Controls.Add(this.label3);
  423. this.panel1.Controls.Add(this.label2);
  424. this.panel1.Controls.Add(this.label1);
  425. this.panel1.Controls.Add(this.label4);
  426. this.panel1.Dock = System.Windows.Forms.DockStyle.Bottom;
  427. this.panel1.Location = new System.Drawing.Point(0, 407);
  428. this.panel1.Name = "panel1";
  429. this.panel1.Size = new System.Drawing.Size(411, 50);
  430. this.panel1.TabIndex = 7;
  431. //
  432. // label7
  433. //
  434. this.label7.AutoSize = true;
  435. this.label7.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
  436. this.label7.ForeColor = System.Drawing.Color.Violet;
  437. this.label7.Location = new System.Drawing.Point(330, 10);
  438. this.label7.Name = "label7";
  439. this.label7.Size = new System.Drawing.Size(47, 12);
  440. this.label7.TabIndex = 5;
  441. this.label7.Text = "0.0230";
  442. //
  443. // label10
  444. //
  445. this.label10.AutoSize = true;
  446. this.label10.Location = new System.Drawing.Point(276, 29);
  447. this.label10.Name = "label10";
  448. this.label10.Size = new System.Drawing.Size(29, 12);
  449. this.label10.TabIndex = 8;
  450. this.label10.Text = ")。";
  451. //
  452. // label9
  453. //
  454. this.label9.AutoSize = true;
  455. this.label9.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
  456. this.label9.ForeColor = System.Drawing.Color.Red;
  457. this.label9.Location = new System.Drawing.Point(229, 29);
  458. this.label9.Name = "label9";
  459. this.label9.Size = new System.Drawing.Size(47, 12);
  460. this.label9.TabIndex = 7;
  461. this.label9.Text = "0.0230";
  462. //
  463. // label8
  464. //
  465. this.label8.AutoSize = true;
  466. this.label8.Location = new System.Drawing.Point(47, 29);
  467. this.label8.Name = "label8";
  468. this.label8.Size = new System.Drawing.Size(185, 12);
  469. this.label8.TabIndex = 6;
  470. this.label8.Text = "超出特殊要求,不满足任何标准(";
  471. //
  472. // label6
  473. //
  474. this.label6.AutoSize = true;
  475. this.label6.Location = new System.Drawing.Point(373, 10);
  476. this.label6.Name = "label6";
  477. this.label6.Size = new System.Drawing.Size(17, 12);
  478. this.label6.TabIndex = 4;
  479. this.label6.Text = ")";
  480. //
  481. // label3
  482. //
  483. this.label3.AutoSize = true;
  484. this.label3.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
  485. this.label3.Location = new System.Drawing.Point(131, 10);
  486. this.label3.Name = "label3";
  487. this.label3.Size = new System.Drawing.Size(47, 12);
  488. this.label3.TabIndex = 1;
  489. this.label3.Text = "0.0230";
  490. //
  491. // label2
  492. //
  493. this.label2.AutoSize = true;
  494. this.label2.Location = new System.Drawing.Point(47, 10);
  495. this.label2.Name = "label2";
  496. this.label2.Size = new System.Drawing.Size(89, 12);
  497. this.label2.TabIndex = 1;
  498. this.label2.Text = "满足内控标准(";
  499. //
  500. // label1
  501. //
  502. this.label1.AutoSize = true;
  503. this.label1.Location = new System.Drawing.Point(7, 10);
  504. this.label1.Name = "label1";
  505. this.label1.Size = new System.Drawing.Size(41, 12);
  506. this.label1.TabIndex = 0;
  507. this.label1.Text = "说明:";
  508. //
  509. // label4
  510. //
  511. this.label4.AutoSize = true;
  512. this.label4.Location = new System.Drawing.Point(174, 10);
  513. this.label4.Name = "label4";
  514. this.label4.Size = new System.Drawing.Size(161, 12);
  515. this.label4.TabIndex = 2;
  516. this.label4.Text = "),超出内控满足特殊要求(";
  517. //
  518. // frmLgEleDetail
  519. //
  520. this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 12F);
  521. this.ClientSize = new System.Drawing.Size(411, 457);
  522. this.Controls.Add(this.ultraGrid1);
  523. this.Controls.Add(this.panel1);
  524. this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedDialog;
  525. this.Icon = ((System.Drawing.Icon)(resources.GetObject("$this.Icon")));
  526. this.MaximizeBox = false;
  527. this.MinimizeBox = false;
  528. this.Name = "frmLgEleDetail";
  529. this.SizeGripStyle = System.Windows.Forms.SizeGripStyle.Show;
  530. this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
  531. this.Text = "成分标准详细信息";
  532. this.Load += new System.EventHandler(this.ElementsForm_Load);
  533. ((System.ComponentModel.ISupportInitialize)(this.dataSet1)).EndInit();
  534. ((System.ComponentModel.ISupportInitialize)(this.dataTable1)).EndInit();
  535. ((System.ComponentModel.ISupportInitialize)(this.ultraGrid1)).EndInit();
  536. this.panel1.ResumeLayout(false);
  537. this.panel1.PerformLayout();
  538. this.ResumeLayout(false);
  539. }
  540. #endregion
  541. private void ElementsForm_Load(object sender, System.EventArgs e)
  542. {
  543. GetElementCode();
  544. GetOrderno();
  545. InitGrid();
  546. GetStandardElement();
  547. SetValueColor();
  548. }
  549. /// <summary>
  550. /// 获取元素和实际值
  551. /// </summary>
  552. public void InitGrid()
  553. {
  554. try
  555. {
  556. int intIndex = 0;
  557. foreach (Infragistics.Win.UltraWinGrid.UltraGridCell ultraGc in ultrgridRow.Cells)
  558. {
  559. foreach (Infragistics.Win.UltraWinGrid.UltraGridRow ultragr in ultraGrid1.Rows)
  560. {
  561. if (ultraGc.Column.ToString().ToUpper() == ultragr.Cells["Element"].Value.ToString().ToUpper())
  562. {
  563. ultragr.Cells["ResVaule"].Value = ultraGc.Value.ToString();
  564. ultragr.Cells["ResVaule"].Appearance.ForeColor = ultraGc.Appearance.ForeColor;
  565. string DD = ultraGc.Appearance.ForeColor.ToString();
  566. }
  567. }
  568. if (ultraGc.Column.Index > 12 && ultraGc.Column.Hidden == false)
  569. {
  570. DataRow dr1 = dataSet1.Tables[0].NewRow();
  571. dr1["Element"] = ultraGc.Column.Header.Caption;
  572. dr1["ResVaule"] = ultraGc.Value.ToString();
  573. dataSet1.Tables[0].Rows.Add(dr1);
  574. ultraGrid1.Rows[intIndex].Cells["ResVaule"].Appearance.ForeColor = ultraGc.Appearance.ForeColor;
  575. intIndex = intIndex + 1;
  576. }
  577. }
  578. DataRow dr = dataSet1.Tables[0].NewRow();
  579. dr["Element"] = ultrgridRow.Cells[12].Column.Header.Caption;
  580. dr["ResVaule"] = ultrgridRow.Cells[12].Value.ToString();
  581. dataSet1.Tables[0].Rows.Add(dr);
  582. ultraGrid1.Rows[intIndex].Cells["ResVaule"].Appearance.ForeColor = ultrgridRow.Cells[12].Appearance.ForeColor;
  583. }
  584. catch { }
  585. }
  586. /// <summary>
  587. /// 查询元素的编码
  588. /// </summary>
  589. public void GetElementCode()
  590. {
  591. try
  592. {
  593. string strErr = "";
  594. ArrayList arry = new ArrayList();
  595. arry.Add("BaseInfoChement.select");
  596. arry.Add("1005"); //复合元素
  597. arry.Add("1006"); //单一元素
  598. CommonClientToServer ccs = new CommonClientToServer();
  599. ccs.ob = this.ob;
  600. DataSet ds = ccs.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery", "doSimpleQuery", arry, out strErr);
  601. tabChement = new Hashtable();
  602. string strCode="";
  603. string strName="";
  604. if (ds.Tables[0].Rows.Count > 0)
  605. {
  606. for(int i=0;i<ds.Tables[0].Rows.Count;i++)
  607. {
  608. strCode=ds.Tables[0].Rows[i]["BASECODE"].ToString();
  609. strName = ds.Tables[0].Rows[i]["BASENAME"].ToString();
  610. tabChement.Add(strCode, strName);
  611. }
  612. }
  613. }
  614. catch { }
  615. }
  616. /// <summary>
  617. /// 根据炉号查询生产订单号
  618. /// </summary>
  619. public void GetOrderno()
  620. {
  621. try
  622. {
  623. string strErr = "";
  624. ArrayList arry = new ArrayList();
  625. arry.Add("IntentOrderno.select");
  626. arry.Add(strHeatNo); //炉号
  627. CommonClientToServer ccs = new CommonClientToServer();
  628. ccs.ob = this.ob;
  629. DataSet ds = ccs.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery", "doSimpleQuery", arry, out strErr);
  630. if (ds.Tables[0].Rows.Count > 0)
  631. {
  632. strOrderno = ds.Tables[0].Rows[0][0].ToString();
  633. }
  634. }
  635. catch { }
  636. }
  637. /// <summary>
  638. /// 根据生产订单号查询标准成分
  639. /// </summary>
  640. public void GetStandardElement()
  641. {
  642. try
  643. {
  644. string strErr = "", temp = "";
  645. string stritem="";
  646. if (strOrderno == "") return;
  647. ArrayList arry = new ArrayList();
  648. arry.Add("ChemStandardInfo.select");
  649. arry.Add(strOrderno);
  650. CommonClientToServer cctos = new CommonClientToServer();
  651. cctos.ob = this.ob;
  652. DataSet ds = cctos.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery",
  653. "doSimpleQuery", arry, out strErr);
  654. if (strErr == "" && ds.Tables[0].Rows.Count > 0)
  655. {
  656. foreach (DataRow Dr in ds.Tables[0].Rows)
  657. {
  658. foreach (DataRow dr in dataSet1.Tables[0].Rows)
  659. {
  660. stritem=Dr["ITEM"].ToString();
  661. if (tabChement.Contains(stritem))
  662. {
  663. if (tabChement[stritem].ToString().ToUpper() == dr["Element"].ToString().ToUpper())
  664. {
  665. if (Dr["STDSTYLE"].ToString() == "内控")
  666. {
  667. dr["NSTDMIN"] = Dr["MINVALUE"].ToString();
  668. dr["NSTDMAX"] = Dr["MAXVALUE"].ToString();
  669. }
  670. if (Dr["STDSTYLE"].ToString() == "客户")
  671. {
  672. dr["TSTDMIN"] = Dr["MINVALUE"].ToString();
  673. dr["TSTDMAX"] = Dr["MAXVALUE"].ToString();
  674. }
  675. }
  676. //else
  677. //{
  678. // DataRow dr1 = dataSet1.Tables[0].NewRow();
  679. // dr1["Element"] = tabChement[stritem].ToString().ToString();
  680. // dr1["STD"] = Dr["STD"].ToString();
  681. // dr1["TSTDMIN"] = Dr["MINVALUE"].ToString();
  682. // dr1["TSTDMAX"] = Dr["MAXVALUE"].ToString();
  683. // dataSet1.Tables[0].Rows.Add(dr1);
  684. //}
  685. }
  686. }
  687. }
  688. }
  689. }
  690. catch { }
  691. }
  692. public void SetValueColor()
  693. {
  694. try
  695. {
  696. for (int i = 0; i < ultraGrid1.Rows.Count; i++)
  697. {
  698. bool flag1 = false;
  699. bool flag2 = false;
  700. string v_resvalue = ultraGrid1.Rows[i].Cells["ResVaule"].Value.ToString();
  701. string v_nstdmin = ultraGrid1.Rows[i].Cells["NSTDMIN"].Value.ToString();
  702. string v_nstdmax = ultraGrid1.Rows[i].Cells["NSTDMAX"].Value.ToString();
  703. flag1 = CompareValue(v_resvalue, v_nstdmin, v_nstdmax);
  704. string v_tstdmin = ultraGrid1.Rows[i].Cells["TSTDMIN"].Value.ToString();
  705. string v_tstdmax = ultraGrid1.Rows[i].Cells["TSTDMAX"].Value.ToString();
  706. if (v_tstdmin == "" && v_tstdmax == "")
  707. {
  708. if (!flag1)
  709. {
  710. ultraGrid1.Rows[i].Cells["ResVaule"].Appearance.ForeColor = Color.Red;
  711. continue;
  712. }
  713. }
  714. flag2 = CompareValue(v_resvalue, v_tstdmin, v_tstdmax);
  715. if (!flag1 && flag2)
  716. {
  717. ultraGrid1.Rows[i].Cells["ResVaule"].Appearance.ForeColor = Color.Violet;
  718. }
  719. if (!flag1 && !flag2)
  720. {
  721. ultraGrid1.Rows[i].Cells["ResVaule"].Appearance.ForeColor = Color.Red;
  722. }
  723. }
  724. }
  725. catch { }
  726. }
  727. public bool CompareValue(string v_value,string v_min,string v_max)
  728. {
  729. try
  730. {
  731. bool flag = false;
  732. double value = Convert.ToDouble(v_value == "" ? "0" : v_value);
  733. double min = Convert.ToDouble(v_min == "" ? "0" : v_min);
  734. double max = Convert.ToDouble(v_max == "" ? "0" : v_max);
  735. if (value != 0)
  736. {
  737. if (min == 0 && max != 0)
  738. {
  739. if (value <= max)
  740. {
  741. flag = true;
  742. }
  743. }
  744. if (min != 0 && max == 0)
  745. {
  746. if (value >= min)
  747. {
  748. flag = true;
  749. }
  750. }
  751. if (min != 0 && max != 0)
  752. {
  753. if (value >= min && value <= max)
  754. {
  755. flag = true;
  756. }
  757. }
  758. if (min == 0 && max == 0)
  759. {
  760. flag = true;
  761. }
  762. }
  763. return flag;
  764. }
  765. catch { return false; }
  766. }
  767. private void ultraGrid1_InitializeLayout(object sender, Infragistics.Win.UltraWinGrid.InitializeLayoutEventArgs e)
  768. {
  769. ultraGrid1.DisplayLayout.Bands[0].Columns[0].Width = 30;
  770. ultraGrid1.DisplayLayout.Bands[0].Columns[1].Width = 40;
  771. ultraGrid1.DisplayLayout.Bands[0].Columns[2].Width = 120;
  772. }
  773. }
  774. }