MES_Client/TGMES/Core.StlMes.Client.Lims.Data.Steer/数据管理/炼钢实验管理/FrmSteerChemResultLog.cs

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;
            }
        }
    }
}