using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using CoreFS.CA06; using Core.Mes.Client.Comm.Tool; using Core.Mes.Client.Comm.Control; using System.Collections; using Infragistics.Win.UltraWinGrid; namespace Core.StlMes.Client.Lims.Data.Steer { public partial class FrmSteerChemResultLog : FrmBase { public FrmSteerChemResultLog() { InitializeComponent(); } protected override void OnLoad(EventArgs e) { base.OnLoad(e); ultraGrid1.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False; ultraGrid2.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False; } private void FrmSteerChemResultLog_Load(object sender, EventArgs e) { steerQueryBase1.UpdateControl("操作时间"); InitColumns(); PublicSteer.ColumnsWidth(ultraGrid1, 0, 60); PublicSteer.ColumnsWidth(ultraGrid2, 0, 60); } private void InitColumns() { string[] chemMax = PublicSteer.chemMax.Split(' '); string[] chemMin = PublicSteer.chemMin.Split(' '); string[] arrColumnsBase = new string[] { "OPERATE_TYPE_DESC", "OPERATE_FLAG_DESC", "HEAT_NO", "SAMPLE_NO", "STEEL_NO", "OPERATE_NAME", "OPERATE_TIME" }; string[] arrCaptionBase = new string[] { "操作类型", "操作标志", "炉号", "试样号", "钢号", "操作人", "操作时间" }; PublicSteer.InitColumns(arrColumnsBase, chemMax, arrCaptionBase, chemMin, dataTable1); PublicSteer.setOtherColumnReadOnly(ultraGrid1, null);//可编辑列 } public override void ToolBar_Click(object sender, string ToolbarKey) { //查询、确认、退出 switch (ToolbarKey) { case "Query": QuerySteerChemResultLog(); break; case "Close": if (MessageUtil.ShowYesNoAndQuestion("是否确认关闭页面?") == DialogResult.Yes) { this.Close(); } break; } } private void QuerySteerChemResultLog() { try { ArrayList al = steerQueryBase1.GetQueryInfo(); string[] arr = this.ValidDataPurviewIds;//获取数据权限ID //查询最近十条信息 DataTable dt = PublicServer.GetData("com.steering.lims.data.steer.FrmSteerChemResultLog.QuerySteerChemResultLog", new Object[] { al, arr }, ob); if (dt == null || dt.Rows.Count == 0) { dataTable1.Rows.Clear(); return; } GridHelper.CopyDataToDatatable(dt, dataTable1, true);//把dt复制给dataTable UltraGridColumn[] cols = new UltraGridColumn[] { ultraGrid1.DisplayLayout.Bands[0].Columns["OPERATE_FLAG_DESC"], ultraGrid1.DisplayLayout.Bands[0].Columns["OPERATE_TIME"] }; PublicSteer.RefreshAndAutoSizeColumns(ultraGrid1, cols);//刷新Grid //GridHelper.RefreshAndAutoSize(ultraGrid1);//刷新Grid } catch (Exception e) { MessageUtil.ShowWarning(e.Message); return; } } private void ultraGrid1_AfterRowActivate(object sender, EventArgs e) { try { dataTable2.Rows.Clear(); ArrayList al = new ArrayList(); al.Add(ultraGrid1.ActiveRow.Cells["SAMPLE_NO"].Text.Trim()); al.Add(ultraGrid1.ActiveRow.Cells["HEAT_NO"].Text.Trim()); DataTable dt = PublicServer.GetData("com.steering.lims.data.steer.FrmSteerChemResultLog.QueryChemAuditResultHeatSampleNo", new Object[] { al }, ob); if (dt == null || dt.Rows.Count == 0) { return; } foreach (DataColumn dc in dataTable1.Columns) { if (dc.ColumnName.IndexOf("ANA_") == 0 && ultraGrid1.ActiveRow.Cells[dc.ColumnName].Text.Trim() != "") { DataRow dr = dataTable2.NewRow(); dr["ELEMENTS"] = dc.ColumnName.Substring(4, 1) + dc.ColumnName.Substring(4).ToLower().Remove(0, 1); dr["START_VALUE"] = ultraGrid1.ActiveRow.Cells[dc.ColumnName].Text.Trim(); dr["UPDATE_VALUE"] = dt.Rows[0][dc.ColumnName].ToString().Trim(); dataTable2.Rows.Add(dr); } } foreach (UltraGridRow dr in ultraGrid2.Rows) { if (dr.Cells["START_VALUE"].Text.Trim() != dr.Cells["UPDATE_VALUE"].Text.Trim()) { dr.Appearance.BackColor = Color.LightGray; } } UltraGridColumn[] cols = new UltraGridColumn[] { ultraGrid2.DisplayLayout.Bands[0].Columns["ELEMENTS"] }; PublicSteer.RefreshAndAutoSizeColumns(ultraGrid2, cols);//刷新Grid } catch (Exception ex) { MessageUtil.ShowWarning(ex.Message); return; } } } }