MES_Client/TGMES/Core.StlMes.Client.Lims.Data.PipeAndOutdec/数据管理/设备采集管理/FrmChemDataCollect.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 Infragistics.Win.UltraWinGrid;
using Infragistics.Win;
using System.Collections;

namespace Core.StlMes.Client.Lims.Data.PipeAndOutdec
{
    public partial class FrmChemDataCollect : FrmBase
    {
        public FrmChemDataCollect()
        {
            InitializeComponent();
        }

        private string strTime = "";

        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;
            ultraGrid3.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;//不默认加载筛选条件框
        }

        private void FrmChemDataCollect_Load(object sender, EventArgs e)
        {
            pipeQueryBase1.UpdateControl(new string[] { "试验时间", "检验编号", "样号", "班组" });
            InitColumns();
            PublicPipeAndOutdec.ColumnsWidth(ultraGrid1, 0, 60);
            PublicPipeAndOutdec.ColumnsWidth(ultraGrid2, 0, 60);
            PublicPipeAndOutdec.ColumnsWidth(ultraGrid3, 0, 60);
            //GridHelper.RefreshAndAutoSize(ultraGrid2);//自适应

            timer1.Enabled = true;
        }

        private void InitColumns()
        {
            string[] chemMax = PublicPipeAndOutdec.chemMax.Split(' ');
            string[] chemMin = PublicPipeAndOutdec.chemMin.Split(' ');

            // "HEAT_NO", "STEEL_NO", "炉号", "钢号",
            string[] arrColumnsBase = new string[] { "CHK", "CHECK_NO", "SAMPLE_NO", "CHECK_NAME", "CHECK_TIME", "CHECK_SHIFT", "CHECK_CLASS" };
            string[] arrCaptionBase = new string[] { "选择", "检验编号", "样管号", "录入人", "录入时间", "班次", "班组" };

            PublicPipeAndOutdec.InitColumns(arrColumnsBase, chemMax, arrCaptionBase, chemMin, dataTable1);
            PublicPipeAndOutdec.InitColumns(arrColumnsBase, chemMax, arrCaptionBase, chemMin, dataTable2);
            PublicPipeAndOutdec.InitColumns(arrColumnsBase, chemMax, arrCaptionBase, chemMin, dataTable3);

            PublicPipeAndOutdec.setColumnShowOrHidden(ultraGrid1, new string[] { "CHK" }, false);
            PublicPipeAndOutdec.setColumnShowOrHidden(ultraGrid2, new string[] { "CHK" }, false);

            PublicPipeAndOutdec.setOtherColumnReadOnly(ultraGrid1, null);//可编辑列
            PublicPipeAndOutdec.setOtherColumnReadOnly(ultraGrid2, null);//可编辑列
        }

        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            //查询、确认、退出
            switch (ToolbarKey)
            {
                case "Query":
                    if (ultraTabControl1.SelectedTab.Index == 0)
                    {
                        //QueryChemAuditResult_Collect();//查询采集信息
                    }
                    else if (ultraTabControl1.SelectedTab.Index == 1)
                    {
                        QueryChemAuditResult_Hand();
                    }
                    break;
                case "Add":
                    AddChemAuditResult();
                    break;
                case "Update":
                    //UpdateChemAuditResult();
                    break;
                case "Audit":
                    //CancelUpdateCheckConsignDetail();
                    break;
                case "Close":
                    if (MessageUtil.ShowYesNoAndQuestion("是否确认关闭页面？") == DialogResult.Yes)
                    {
                        this.Close();
                    }
                    break;
            }
        }

        private void QueryChemAuditResult_Collect()
        {
            try
            {

                //string[] arr = this.ValidDataPurviewIds;//获取数据权限ID

                //查询最近十条信息
                DataTable dt = PublicServer.GetData("com.steering.lims.data.device.FrmChemDataCollect.QueryChemAuditResult_Collect",
                new Object[] { }, ob);
                if (dt == null || dt.Rows.Count == 0)
                {
                    dataTable1.Rows.Clear();
                    dataTable2.Rows.Clear();
                    return;
                }
                GridHelper.CopyDataToDatatable(dt, dataTable1, true);//把dt复制给dataTable

                PublicPipeAndOutdec.RefreshAndAutoSizeColumns(ultraGrid1, new string[] { "CHECK_NO", "SAMPLE_NO", "CHECK_TIME" }, true);//刷新Grid

            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        //查询手工录入数据
        private void QueryChemAuditResult_Hand()
        {
            try
            {
                ArrayList arrayList = pipeQueryBase1.GetQueryInfo();

                DataTable dt = PublicServer.GetData("com.steering.lims.data.device.FrmChemDataCollect.QueryChemAuditResult_Hand",
                new Object[] { arrayList }, ob);//加入权限
                if (dt == null || dt.Rows.Count == 0)
                {
                    dataTable3.Rows.Clear();

                    return;
                }
                GridHelper.CopyDataToDatatable(dt, dataTable3, true);//把dt复制给dataTable

            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        //点击ultraGrid1，ultraGrid2查询出同检验编号的数据
        private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
        {
            try
            {
                string strHEAT_NO = ultraGrid1.ActiveRow.Cells["CHECK_NO"].Text.Trim();

                ArrayList al = new ArrayList();
                al.Add(strHEAT_NO);

                DataTable dt = PublicServer.GetData("com.steering.lims.data.device.FrmChemDataCollect.QueryChemAuditResultHeatNo",
                            new Object[] { al }, ob);

                GridHelper.CopyDataToDatatable(dt, dataTable2, true);//把dt复制给dataTable

                PublicPipeAndOutdec.RefreshAndAutoSizeColumns(ultraGrid1, new string[] { "CHECK_NO", "SAMPLE_NO", "CHECK_TIME" },true);//刷新Grid
            }
            catch (Exception ex)
            {
                MessageUtil.ShowWarning(ex.Message);
                return;
            }
        }

        #region 人工录入
        //修改熔炼数据
        private void AddChemAuditResult()
        {
            try
            {
                ultraGrid3.UpdateData();
                if (dataTable3 == null || dataTable3.Rows.Count == 0 || ultraGrid3.ActiveRow == null || ultraGrid3.ActiveRow.Activated == false)
                {
                    MessageUtil.ShowWarning("请录入需要新增的数据！");
                    return;
                }

                if (ultraTabControl1.SelectedTab.Index != 1)
                {
                    MessageUtil.ShowWarning("只有选择了人工录入页才能进行新增操作！");
                    return;
                }

                ArrayList al = new ArrayList();
                al.Add(ultraGrid3.ActiveRow.Cells["SAMPLE_NO"].Text.Trim());
                al.Add(ultraGrid3.ActiveRow.Cells["CHECK_NO"].Text.Trim());

                PublicServer.GetDataTips("com.steering.lims.data.device.FrmChemDataCollect.QueryChemAuditResultTipsIsHave",
new Object[] { al, "1", "此检验编号和样管号已经存在请重新录入！" }, ob);//判定数据库是否有同样的是否能新增

                if (MessageUtil.ShowYesNoAndQuestion("是否确认新增？") == DialogResult.Yes)
                {
                    string strSqlParm = "INSERT INTO PIPEOUTDEC_CHEM_PROCESS_RESULT(";
                    string strSqlValue = "VALUES(";
                    foreach (DataColumn dc in dataTable3.Columns)
                    {
                        if (dc.ColumnName == "CHK")
                        {
                            continue;
                        }
                        strSqlParm += dc.ColumnName + ",";

                        if (dc.ColumnName == "CHECK_TIME")
                        {
                            strSqlValue += "SYSDATE,";
                            continue;
                        }

                        strSqlValue += "'";
                        if (dc.ColumnName == "CHECK_NAME")
                        {
                            strSqlValue += UserInfo.GetUserName();
                        }
                        else if (dc.ColumnName == "CHECK_SHIFT")
                        {
                            strSqlValue += UserInfo.GetUserOrderText();
                        }
                        else if (dc.ColumnName == "CHECK_CLASS")
                        {
                            strSqlValue += UserInfo.GetUserName();
                        }
                        else
                        {
                            strSqlValue += ultraGrid3.ActiveRow.Cells[dc.ColumnName].Text.Trim();
                        }
                        strSqlValue += "',";
                    }
                    strSqlParm += "DATA_TYPE";
                    strSqlValue += "1";

                    strSqlParm += ")";
                    strSqlValue += ")";

                    PublicServer.SetData("com.steering.lims.data.device.FrmChemDataCollect.AddChemAuditResult",
                            new Object[] { strSqlParm + strSqlValue }, this.ob);

                    QueryChemAuditResult_Hand();

                    PublicPipeAndOutdec.ActiveOperateRow(ultraGrid3, new string[] { "SAMPLE_NO", "CHECK_NO" }, al.ToArray());

                    MessageUtil.ShowTips("新增成功！");
                }
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
        {
            if (toolMenu == null) return;
            if (ultraTabControl1.SelectedTab.Index == 0)
            {
                if (toolMenu.Toolbars[0].Tools.Exists("Query"))
                {
                    toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Add"))
                {
                    this.toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.False;
                }
            }
            else if (ultraTabControl1.SelectedTab.Index == 1)
            {
                if (toolMenu.Toolbars[0].Tools.Exists("Query"))
                {
                    toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Add"))
                {
                    this.toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.True;
                }
            }
        }
        #endregion

        private void timer1_Tick(object sender, EventArgs e)
        {
            try
            {
                if (ultraTabControl1.SelectedTab.Index == 0)
                {
                    DataTable dt = PublicServer.GetData("com.steering.lims.data.device.FrmChemDataCollect.QueryChemAuditResult_First",
                                new Object[] { }, ob);

                    if (strTime != dt.Rows[0]["CHECK_TIME"].ToString())
                    {
                        strTime = dt.Rows[0]["CHECK_TIME"].ToString();
                        QueryChemAuditResult_Collect();
                    }
                }
            }
            //catch (Exception ex)
            catch
            {
                //MessageUtil.ShowWarning(ex.Message);
                //return;
            }
        }
    }
}