MES_Client/TGMES/Core.StlMes.Client.Lims.Data.PipeAndOutdec/数据管理/基础信息管理/FrmBaseChemStdSteel.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 System.Collections;
using Core.Mes.Client.Comm.Control;
using Infragistics.Win.UltraWinEditors;
using Infragistics.Win.Misc;
using Infragistics.Win.UltraWinGrid;
using Core.Mes.Client.Comm.Server;

namespace Core.StlMes.Client.Lims.Data.PipeAndOutdec
{
    public partial class FrmBaseChemStdSteel : FrmBase
    {
        private string[] minChem = PublicPipeAndOutdec.chemMin.Split(' ');
        public FrmBaseChemStdSteel()
        {
            InitializeComponent();
        }

        protected override void OnLoad(EventArgs e)
        {
            base.OnLoad(e);
            //ultraGrid5.DisplayLayout.Override.RowSelectorNumberStyle = Infragistics.Win.UltraWinGrid.RowSelectorNumberStyle.Default;
            ultraGrid1.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
            ultraGrid2.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
            ultraGrid3.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
            ultraGrid4.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
            ultraGrid5.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
        }

        private bool isLoad = false;
        private void FrmBaseChemStdSteel_Load(object sender, EventArgs e)
        {
            //试验室等于化学硬度块隐藏
            if (UserInfo.GetDeptid() == "002001007010")
            {
                ultraTabControl1.Tabs[3].Visible = false;
            }
            else if (UserInfo.GetDeptid() == "002001007009")
            {
                ultraTabControl1.Tabs[0].Visible = false;
                ultraTabControl1.Tabs[1].Visible = false;
                ultraTabControl1.Tabs[2].Visible = false;
            }
            InitColumns();
            if (ultraTabControl1.SelectedTab.Index == 0)
            {
                ShowControl();
                ultraExpandableGroupBox2.Visible = false;
            }
            isLoad = true;
        }

        private void InitColumns()
        {
            string[] arrColumnsBase = new string[] { "STD_ID", "STDSTEEL_TYPE", "STDSTEEL_TYPE_DESC", "STDSTEEL_NAME", "STDSTEEL_NO", "SAMPLE_NO", "STEEL_NO", "PRODUCT_TYPE", "PRODUCT_STD", "UNIT", "SAMPLE_COUNT", "ARRIVE_TIME", "SURE_TIME", "VALID_TIME", "SUPPLIER", "FILE_POSITION", "REMARK", "CHECK_NAME", "CHECK_TIME", "CHECK_SHIFT", "CHECK_CLASS" };
            string[] arrCaptionBase = new string[] { "STD_ID", "标物类型", "标物类型", "标物名称", "标物编号", "自编号", "钢号", "类别", "技术标准", "单位", "数量", "进货日期", "定值日期", "有效日期", "研制单位", "证书", "备注", "维护人", "维护时间", "维护班次", "维护班组" };

            PublicPipeAndOutdec.InitColumns(arrColumnsBase, arrCaptionBase, dataTable1, ultraGrid1, new string[] { "STD_ID", "STDSTEEL_TYPE", "STDSTEEL_TYPE_DESC", "STDSTEEL_NAME", "STDSTEEL_NO",  "PRODUCT_TYPE", "PRODUCT_STD", "UNIT", "SAMPLE_COUNT", "ARRIVE_TIME", "SURE_TIME", "VALID_TIME", "SUPPLIER", "FILE_POSITION", "REMARK", "CHECK_SHIFT", "CHECK_CLASS" }, false, null);
            PublicPipeAndOutdec.InitColumns(arrColumnsBase, arrCaptionBase, dataTable2, ultraGrid2, new string[] { "STD_ID", "STDSTEEL_TYPE", "STDSTEEL_TYPE_DESC", "CHECK_SHIFT", "CHECK_CLASS" }, false, null);
            PublicPipeAndOutdec.InitColumns(arrColumnsBase, arrCaptionBase, dataTable3, ultraGrid3, new string[] { "STD_ID", "STDSTEEL_TYPE", "STDSTEEL_TYPE_DESC", "CHECK_SHIFT", "CHECK_CLASS" }, false, null);
            PublicPipeAndOutdec.InitColumns(arrColumnsBase, arrCaptionBase, dataTable5, ultraGrid5, new string[] { "STD_ID", "STDSTEEL_TYPE", "STDSTEEL_TYPE_DESC", "CHECK_SHIFT", "CHECK_CLASS" }, false, null);

            string[] arrColumnsDetail = new string[] { "ITEM_NAME", "STD_VALUE" };
            string[] arrColumnsCaption = new string[] { "项目", "定值" };
            PublicPipeAndOutdec.InitColumns(arrColumnsDetail, arrColumnsCaption, dataTable4, ultraGrid4, null, false, new string[] { "STD_VALUE" });
        }

        /// <summary>
        /// 重写基类方法
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="ToolbarKey"></param>
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            //新增修改删除退出
            switch (ToolbarKey)
            {
                case "Query":
                    if (ultraTabControl1.SelectedTab.Index == 0)
                    {
                        QueryChemStdSteelBase();
                    }
                    else if (ultraTabControl1.SelectedTab.Index == 1)
                    {
                        QueryChemStdSteelBaseManage(ultraGrid2, dataTable2, "1");
                    }
                    else if (ultraTabControl1.SelectedTab.Index == 2)
                    {
                        QueryChemStdSteelBaseManage(ultraGrid3, dataTable3, "2");
                    }
                    else if (ultraTabControl1.SelectedTab.Index == 3)
                    {
                        QueryChemStdSteelBaseManage(ultraGrid5, dataTable5, "3");
                    }
                    break;
                //case "Refresh":
                //    BindStdSteelData();
                //    break;
                case "Add":
                    if (ultraTabControl1.SelectedTab.Index == 0)
                    {
                        SaveChemStdSteelInfo();
                    }
                    else if (ultraTabControl1.SelectedTab.Index == 1)
                    {
                        SaveChemStdSteelInfoManage(ultraGrid2, dataTable2);
                    }
                    else if (ultraTabControl1.SelectedTab.Index == 2)
                    {
                        SaveChemStdSteelInfoManage(ultraGrid3, dataTable3);
                    }
                    else if (ultraTabControl1.SelectedTab.Index == 3)
                    {
                        SaveChemStdSteelInfoManage(ultraGrid5, dataTable5);
                    }
                    break;
                case "Update":
                    if (ultraTabControl1.SelectedTab.Index == 0)
                    {
                        UpdateChemStdSteelInfo();
                    }
                    else if (ultraTabControl1.SelectedTab.Index == 1)
                    {
                        UpdateChemStdSteelInfoManage(ultraGrid2, dataTable2);
                    }
                    else if (ultraTabControl1.SelectedTab.Index == 2)
                    {
                        UpdateChemStdSteelInfoManage(ultraGrid3, dataTable3);
                    }
                    else if (ultraTabControl1.SelectedTab.Index == 3)
                    {
                        UpdateChemStdSteelInfoManage(ultraGrid5, dataTable5);
                    }
                    break;
                case "Delete":
                    if (ultraTabControl1.SelectedTab.Index == 0)
                    {
                        DeleteChemStdSteelInfo();
                    }
                    else if (ultraTabControl1.SelectedTab.Index == 1)
                    {
                        DeleteChemStdSteelInfoManage(ultraGrid2, dataTable2);
                    }
                    else if (ultraTabControl1.SelectedTab.Index == 2)
                    {
                        DeleteChemStdSteelInfoManage(ultraGrid3, dataTable3);
                    }
                    else if (ultraTabControl1.SelectedTab.Index == 3)
                    {
                        DeleteChemStdSteelInfoManage(ultraGrid5, dataTable5);
                    }
                    break;
                case "Clear":
                    if (MessageUtil.ShowYesNoAndQuestion("是否确认清空？") == DialogResult.Yes)
                    {
                        //ClearChemStdSteelInfo();
                    }
                    break;
                case "Close":
                    if (MessageUtil.ShowYesNoAndQuestion("是否确认关闭页面？") == DialogResult.Yes)
                    {
                        this.Close();
                    }
                    break;
            }
        }

        private void QueryChemStdSteelBase()
        {
            try
            {

                DataTable dt = PublicServer.GetData("com.steering.lims.data.base.FrmBaseChemStdSteel.QueryChemStdSteelInfo",
                            new Object[] { }, ob);

                if (dt == null || dt.Rows.Count == 0)
                {
                    ClearValue();
                    //dataTable4.Rows.Clear();
                    dataTable1.Rows.Clear();
                    MessageUtil.ShowTips("没有维护光谱标钢基础数据！");
                    return;
                }

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

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

        private void QueryChemStdSteelDetail()
        {
            try
            {
                if (ultraGrid1.ActiveRow != null)
                {
                    ArrayList arrayList = new ArrayList();
                    arrayList.Add("0");
                    arrayList.Add(ultraGrid1.ActiveRow.Cells["SAMPLE_NO"].Text.Trim());
                    arrayList.Add(ultraGrid1.ActiveRow.Cells["STEEL_NO"].Text.Trim());
                    arrayList.Add(ultraGrid1.ActiveRow.Cells["STEEL_NO"].Text.Trim());
                    arrayList.Add(ultraGrid1.ActiveRow.Cells["STEEL_NO"].Text.Trim());

                    DataTable dt = PublicServer.GetData("com.steering.lims.data.base.FrmBaseChemStdSteel.QueryChemStdSteelDetail",
                new Object[] { arrayList }, ob);

                    if (dt == null || dt.Rows.Count == 0)
                    {
                        //dataTable4.Rows.Clear();
                        foreach(DataRow dr in dataTable4.Rows)
                        {
                            dr["STD_VALUE"] = "";
                        }
                        //MessageUtil.ShowTips("找不到标钢明细数据！");
                        return;
                    }
                    foreach (DataRow dr in dataTable4.Rows)
                    {
                        if (dt.Columns.Contains("ANA_" + dr["ITEM_NAME"].ToString().ToUpper()) && dt.Rows[0]["ANA_" + dr["ITEM_NAME"].ToString().ToUpper()].ToString() != "")
                        {
                            dr["STD_VALUE"] = dt.Rows[0]["ANA_" + dr["ITEM_NAME"].ToString().ToUpper()].ToString();
                        }
                        else
                        {
                            dr["STD_VALUE"] = "";
                        }
                    }
                }
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        //保存标钢信息
        private void SaveChemStdSteelInfo()
        {
            try
            {

                ultraGrid4.UpdateData();
                string strSAMPLE_NO = txtSAMPLE_NO.Text.Trim();

                if (strSAMPLE_NO == "")
                {
                    MessageUtil.ShowWarning("试样号不能为空！");
                    return;
                }
                if (MessageUtil.ShowYesNoAndQuestion("是否确认新增？") == DialogResult.Yes)
                {
                    string condition = "INSERT INTO BASE_CHEM_STDSTEEL_INFO(STDSTEEL_TYPE,STDSTEEL_NAME,STDSTEEL_NO,SAMPLE_NO,STEEL_NO,SURE_TIME,VALID_TIME,REMARK,CHECK_NAME,CHECK_TIME";
                    string value = ") VALUES('0','" + txtSTDSTEEL_NAME.Text.Trim() + "','" + txtSTDSTEEL_NO.Text.Trim() + "','" + strSAMPLE_NO + "','" + txtSTEEL_NO.Text.Trim() + "',TO_DATE('" + SURE_TIME.Text.Trim() + "','YYYY-MM-DD'),TO_DATE('" + VALID_TIME.Text.Trim() + "','YYYY-MM-DD'),'" + txtREMARK.Text.Trim() + "','" + UserInfo.GetUserName() + "',SYSDATE";

                    foreach (DataRow dr in dataTable4.Rows)
                    {
                        condition += ",ANA_" + dr["ITEM_NAME"].ToString().ToUpper();
                        value += ",'" + dr["STD_VALUE"] + "'";
                    }

                    //                PublicServer.SetData("com.steering.lims.data.base.FrmBaseChemStdSteel.DeleteChemStdSteelInfo",
                    //new Object[] { al }, this.ob);

                    //先删除再保存
                    PublicServer.SetData("com.steering.lims.data.base.FrmBaseChemStdSteel.SaveChemStdSteelInfo",
    new Object[] { strSAMPLE_NO, condition + value + ")" }, this.ob);

                    QueryChemStdSteelBase();
                    PublicPipeAndOutdec.ActiveOperateRow(ultraGrid1, "SAMPLE_NO", strSAMPLE_NO);//定位保存的行

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

        private void UpdateChemStdSteelInfo()
        {
            if (ultraGrid1.ActiveRow != null)
            {
                string strSAMPLE_NO = txtSAMPLE_NO.Text.Trim();

                if (strSAMPLE_NO != ultraGrid1.ActiveRow.Cells["SAMPLE_NO"].Text.Trim())
                {
                    MessageUtil.ShowWarning("自编号不能修改！");
                    return;
                }

                if (strSAMPLE_NO == "")
                {
                    MessageUtil.ShowWarning("自编号不能为空！");
                    return;
                }

                if (MessageUtil.ShowYesNoAndQuestion("是否确认修改？") == DialogResult.Yes)
                {
                    ultraGrid4.UpdateData();
                    string condition = "INSERT INTO BASE_CHEM_STDSTEEL_INFO(STDSTEEL_TYPE,STDSTEEL_NAME,STDSTEEL_NO,SAMPLE_NO,STEEL_NO,SURE_TIME,VALID_TIME,REMARK,CHECK_NAME,CHECK_TIME";
                    string value = ") VALUES('0','" + txtSTDSTEEL_NAME.Text.Trim() + "','" + txtSTDSTEEL_NO.Text.Trim() + "','" + strSAMPLE_NO + "','" + txtSTEEL_NO.Text.Trim() + "',TO_DATE('" + SURE_TIME.Text.Trim() + "','YYYY-MM-DD'),TO_DATE('" + VALID_TIME.Text.Trim() + "','YYYY-MM-DD'),'" + txtREMARK.Text.Trim() + "','" + UserInfo.GetUserName() + "',SYSDATE";

                    foreach (DataRow dr in dataTable4.Rows)
                    {
                        condition += ",ANA_" + dr["ITEM_NAME"].ToString().ToUpper();
                        value += ",'" + dr["STD_VALUE"] + "'";
                    }

                    //先删除再保存
                    PublicServer.SetData("com.steering.lims.data.base.FrmBaseChemStdSteel.UpdateChemStdSteelInfo",
    new Object[] { strSAMPLE_NO, condition + value + ")" }, this.ob);

                    QueryChemStdSteelBase();
                    PublicPipeAndOutdec.ActiveOperateRow(ultraGrid1, "SAMPLE_NO", strSAMPLE_NO);//定位保存的行

                    MessageUtil.ShowTips("修改成功！");
                }
            }
        }

        //删除标钢信息
        private void DeleteChemStdSteelInfo()
        {
            try
            {
                if (ultraGrid1.ActiveRow != null)
                {
                    if (MessageUtil.ShowYesNoAndQuestion("是否确认删除？") == DialogResult.Yes)
                    {
                        ArrayList arrayList = new ArrayList();
                        arrayList.Add(ultraGrid1.ActiveRow.Cells["SAMPLE_NO"].Text.Trim());
                        arrayList.Add(ultraGrid1.ActiveRow.Cells["STEEL_NO"].Text.Trim());
                        arrayList.Add(ultraGrid1.ActiveRow.Cells["STEEL_NO"].Text.Trim());
                        arrayList.Add(ultraGrid1.ActiveRow.Cells["STEEL_NO"].Text.Trim());

                        PublicServer.SetData("com.steering.lims.data.base.FrmBaseChemStdSteel.DeleteChemStdSteelInfo",
                new Object[] { arrayList }, this.ob);

                        //ClearChemStdSteelInfo();
                        QueryChemStdSteelBase();
                        MessageUtil.ShowTips("删除成功！");
                    }
                }
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        private void ShowControl()
        {
            dataTable4.Rows.Clear();
            //string[] minChem = PublicPipeAndOutdec.chemMin.Split(' ');
            DataRow dr = dataTable4.NewRow();
            for (int i = 0; i < minChem.Length; i++)
            {
                dr = dataTable4.NewRow();
                dr["ITEM_NAME"] = minChem[i];
                dataTable4.Rows.Add(dr);
            }

            PublicPipeAndOutdec.RefreshAndAutoSizeColumns(ultraGrid4, new string[] { "STD_VALUE" }, false);
            //GridHelper.RefreshAndAutoSize(ultraGrid4);
        }

        private void QueryChemStdSteelBaseManage(UltraGrid ultraGrid, DataTable dataTable, string flag)
        {
            try
            {
                ArrayList arrayList = new ArrayList();
                arrayList.Add(flag);
                DataTable dt = PublicServer.GetData("com.steering.lims.data.base.FrmBaseChemStdSteel.QueryChemStdSteelBaseManage",
                            new Object[] { arrayList }, ob);

                if (dt == null || dt.Rows.Count == 0)
                {
                    ClearValue();
                    dataTable4.Rows.Clear();
                    dataTable.Rows.Clear();
                    MessageUtil.ShowTips("没有维护此类标准物质！");
                    return;
                }

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

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

        private void QueryChemStdSteelDetailManage(UltraGrid ultraGrid)
        {
            try
            {
                if (ultraGrid.ActiveRow != null)
                {
                    ArrayList arrayList = new ArrayList();
                    arrayList.Add(ultraGrid.ActiveRow.Cells["STD_ID"].Text.Trim());

                    DataTable dt = PublicServer.GetData("com.steering.lims.data.base.FrmBaseChemStdSteel.QueryChemStdSteelDetailManage",
                new Object[] { arrayList }, ob);

                    if (dt == null || dt.Rows.Count == 0)
                    {
                        dataTable4.Rows.Clear();
                        //MessageUtil.ShowTips("找不到标钢明细数据！");
                        return;
                    }
                    GridHelper.CopyDataToDatatable(dt, dataTable4, true);//把dt复制给dataTable1

                    PublicPipeAndOutdec.RefreshAndAutoSizeColumns(ultraGrid4, new string[] { "STD_VALUE" }, false);
                    //GridHelper.RefreshAndAutoSize(ultraGrid4);
                }
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        //保存标钢信息
        private void SaveChemStdSteelInfoManage(UltraGrid ultraGrid, DataTable dataTable)
        {
            try
            {
                string strSAMPLE_NO = txtSAMPLE_NO.Text.Trim();

                if (strSAMPLE_NO == "")
                {
                    MessageUtil.ShowWarning("自编号不能为空！");
                    return;
                }

                if (MessageUtil.ShowYesNoAndQuestion("是否确认新增？") == DialogResult.Yes)
                {
                    ArrayList arrayList = new ArrayList();
                    arrayList.Add(ultraSTDSTEEL_TYPE.Value.ToString());
                    arrayList.Add(txtSTDSTEEL_NAME.Text.Trim());
                    arrayList.Add(txtSTDSTEEL_NO.Text.Trim());
                    arrayList.Add(strSAMPLE_NO);
                    arrayList.Add(txtSTEEL_NO.Text.Trim());

                    arrayList.Add(txtPRODUCT_TYPE.Text.Trim());
                    arrayList.Add(txtPRODUCT_STD.Text.Trim());
                    arrayList.Add(txtUNIT.Text.Trim());
                    arrayList.Add(txtSAMPLE_COUNT.Text.Trim());
                    arrayList.Add(ARRIVE_TIME.Text.Trim());

                    arrayList.Add(SURE_TIME.Text.Trim());
                    arrayList.Add(VALID_TIME.Text.Trim());
                    arrayList.Add(txtSUPPLIER.Text.Trim());
                    //arrayList.Add("");
                    arrayList.Add(txtREMARK.Text.Trim());
                    arrayList.Add(UserInfo.GetUserName());
                    arrayList.Add(UserInfo.GetUserOrderText());
                    arrayList.Add(UserInfo.GetUserGroupText());

                    //先删除再保存
                    PublicServer.SetData("com.steering.lims.data.base.FrmBaseChemStdSteel.AddChemStdSteelInfoManage",
    new Object[] { strSAMPLE_NO, arrayList }, this.ob);

                    QueryChemStdSteelBaseManage(ultraGrid, dataTable, ultraSTDSTEEL_TYPE.Value.ToString());

                    PublicPipeAndOutdec.ActiveOperateRow(ultraGrid, "SAMPLE_NO", strSAMPLE_NO);//定位保存的行

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

        private void UpdateChemStdSteelInfoManage(UltraGrid ultraGrid, DataTable dataTable)
        {
            try
            {
                if (ultraGrid.ActiveRow != null)
                {
                    string strSAMPLE_NO = txtSAMPLE_NO.Text.Trim();

                    if (strSAMPLE_NO != ultraGrid.ActiveRow.Cells["SAMPLE_NO"].Text.Trim())
                    {
                        MessageUtil.ShowWarning("自编号不能修改！");
                        return;
                    }

                    if (strSAMPLE_NO == "")
                    {
                        MessageUtil.ShowWarning("自编号不能为空！");
                        return;
                    }

                    if (MessageUtil.ShowYesNoAndQuestion("是否确认修改？") == DialogResult.Yes)
                    {
                        ArrayList arrayList = new ArrayList();
                        arrayList.Add(ultraSTDSTEEL_TYPE.Value.ToString());
                        arrayList.Add(txtSTDSTEEL_NAME.Text.Trim());
                        arrayList.Add(txtSTDSTEEL_NO.Text.Trim());
                        arrayList.Add(strSAMPLE_NO);
                        arrayList.Add(txtSTEEL_NO.Text.Trim());

                        arrayList.Add(txtPRODUCT_TYPE.Text.Trim());
                        arrayList.Add(txtPRODUCT_STD.Text.Trim());
                        arrayList.Add(txtUNIT.Text.Trim());
                        arrayList.Add(txtSAMPLE_COUNT.Text.Trim());
                        arrayList.Add(ARRIVE_TIME.Text.Trim());

                        arrayList.Add(SURE_TIME.Text.Trim());
                        arrayList.Add(VALID_TIME.Text.Trim());
                        arrayList.Add(txtSUPPLIER.Text.Trim());
                        //arrayList.Add("");
                        arrayList.Add(txtREMARK.Text.Trim());
                        arrayList.Add(UserInfo.GetUserName());
                        arrayList.Add(UserInfo.GetUserOrderText());
                        arrayList.Add(UserInfo.GetUserGroupText());

                        arrayList.Add(ultraGrid.ActiveRow.Cells["STD_ID"].Text.Trim());

                        //先删除再保存
                        PublicServer.SetData("com.steering.lims.data.base.FrmBaseChemStdSteel.UpdateChemStdSteelInfoManage",
        new Object[] { arrayList }, this.ob);

                        QueryChemStdSteelBaseManage(ultraGrid, dataTable, ultraSTDSTEEL_TYPE.Value.ToString());

                        PublicPipeAndOutdec.ActiveOperateRow(ultraGrid, "SAMPLE_NO", strSAMPLE_NO);//定位保存的行

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

        //删除标钢信息
        private void DeleteChemStdSteelInfoManage(UltraGrid ultraGrid, DataTable dataTable)
        {
            try
            {
                if (ultraGrid.ActiveRow != null)
                {
                    if (MessageUtil.ShowYesNoAndQuestion("是否确认删除？") == DialogResult.Yes)
                    {
                        ArrayList arrayList = new ArrayList();
                        arrayList.Add(ultraGrid.ActiveRow.Cells["STD_ID"].Text.Trim());
                        arrayList.Add("");
                        arrayList.Add("");
                        arrayList.Add("");
                        //先删除再保存
                        PublicServer.SetData("com.steering.lims.data.base.FrmBaseChemStdSteel.DeleteChemStdSteelInfoManage",
        new Object[] { arrayList }, this.ob);

                        QueryChemStdSteelBaseManage(ultraGrid, dataTable, ultraSTDSTEEL_TYPE.Value.ToString());

                        //PublicPipeAndOutdec.ActiveOperateRow(ultraGrid4, "ITEM_NAME", strITEM_NAME);//定位保存的行

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

        private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
        {
            ultraSTDSTEEL_TYPE.Value = ultraTabControl1.SelectedTab.Index;

            if (isLoad)
            {
                if (ultraTabControl1.SelectedTab.Index == 0)
                {
                    QueryChemStdSteelBase();

                    ShowControl();

                    ultraExpandableGroupBox2.Visible = false;
                }
                else if (ultraTabControl1.SelectedTab.Index == 1)
                {
                    QueryChemStdSteelBaseManage(ultraGrid2, dataTable2, "1");
                }
                else if (ultraTabControl1.SelectedTab.Index == 2)
                {
                    QueryChemStdSteelBaseManage(ultraGrid3, dataTable3, "2");
                }
                else if (ultraTabControl1.SelectedTab.Index == 3)
                {
                    QueryChemStdSteelBaseManage(ultraGrid5, dataTable5, "3");
                }
            }
        }

        private void setValue(UltraGrid ultraGrid)
        {
            //ultraSTDSTEEL_TYPE.Value = ultraGrid.ActiveRow.Cells["STDSTEEL_TYPE"].Text.Trim();
            txtSTDSTEEL_NAME.Text = ultraGrid.ActiveRow.Cells["STDSTEEL_NAME"].Text.Trim();
            txtSTDSTEEL_NO.Text = ultraGrid.ActiveRow.Cells["STDSTEEL_NO"].Text.Trim();
            txtSAMPLE_NO.Text = ultraGrid.ActiveRow.Cells["SAMPLE_NO"].Text.Trim();
            txtSTEEL_NO.Text = ultraGrid.ActiveRow.Cells["STEEL_NO"].Text.Trim();

            txtPRODUCT_STD.Text = ultraGrid.ActiveRow.Cells["PRODUCT_STD"].Text.Trim();
            txtPRODUCT_TYPE.Text = ultraGrid.ActiveRow.Cells["PRODUCT_TYPE"].Text.Trim();
            txtUNIT.Text = ultraGrid.ActiveRow.Cells["UNIT"].Text.Trim();
            txtSAMPLE_COUNT.Text = ultraGrid.ActiveRow.Cells["SAMPLE_COUNT"].Text.Trim();
            ARRIVE_TIME.Text = ultraGrid.ActiveRow.Cells["ARRIVE_TIME"].Text.Trim();

            SURE_TIME.Text = ultraGrid.ActiveRow.Cells["SURE_TIME"].Text.Trim();
            VALID_TIME.Text = ultraGrid.ActiveRow.Cells["VALID_TIME"].Text.Trim();
            txtSUPPLIER.Text = ultraGrid.ActiveRow.Cells["SUPPLIER"].Text.Trim();
            txtCER_BOOK.Text = ultraGrid.ActiveRow.Cells["FILE_POSITION"].Text.Trim();
            txtREMARK.Text = ultraGrid.ActiveRow.Cells["REMARK"].Text.Trim();
        }

        private void ClearValue()
        {
            txtSTDSTEEL_NAME.Text = "";
            txtSTDSTEEL_NO.Text = "";
            txtSAMPLE_NO.Text = "";
            txtSTEEL_NO.Text = "";
            txtPRODUCT_STD.Text = "";
            txtPRODUCT_TYPE.Text = "";
            txtUNIT.Text = "";
            txtSAMPLE_COUNT.Text = "";
            ARRIVE_TIME.Value = DateTime.Now;
            SURE_TIME.Value = DateTime.Now;
            VALID_TIME.Value = DateTime.Now;
            txtSUPPLIER.Text = "";
            txtCER_BOOK.Text = "";
            txtREMARK.Text = "";
        }

        private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
        {
            QueryChemStdSteelDetail();
            setValue(ultraGrid1);
        }

        private void ultraGrid2_AfterRowActivate(object sender, EventArgs e)
        {
            QueryChemStdSteelDetailManage(ultraGrid2);
            setValue(ultraGrid2);
        }

        private void ultraGrid3_AfterRowActivate(object sender, EventArgs e)
        {
            QueryChemStdSteelDetailManage(ultraGrid3);
            setValue(ultraGrid3);
        }

        private void ultraGrid4_AfterRowActivate(object sender, EventArgs e)
        {
            txtITEM_NAME.Text = ultraGrid4.ActiveRow.Cells["ITEM_NAME"].Text.Trim();
            txtSTD_VALUE.Text = ultraGrid4.ActiveRow.Cells["STD_VALUE"].Text.Trim();
        }

        private void ultraToolbarsManager1_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs e)
        {
            if (ultraTabControl1.SelectedTab.Index != 0)
            {
                switch (e.Tool.Key)
                {
                    case "AddItem":
                        if (ultraTabControl1.SelectedTab.Index == 1)
                        {
                            AddCheckMethodPhyItems(ultraGrid2);
                        }
                        else if (ultraTabControl1.SelectedTab.Index == 2)
                        {
                            AddCheckMethodPhyItems(ultraGrid3);
                        }
                        break;
                    case "UpdateItem":
                        if (ultraTabControl1.SelectedTab.Index == 1)
                        {
                            UpdateCheckMethodPhyItems(ultraGrid2);
                        }
                        else if (ultraTabControl1.SelectedTab.Index == 2)
                        {
                            UpdateCheckMethodPhyItems(ultraGrid3);
                        }
                        break;
                    case "DeleteItem":
                        if (ultraTabControl1.SelectedTab.Index == 1)
                        {
                            DeleteCheckMethodPhyItems(ultraGrid2);
                        }
                        else if (ultraTabControl1.SelectedTab.Index == 2)
                        {
                            DeleteCheckMethodPhyItems(ultraGrid3);
                        }
                        break;
                }
            }
        }

        //增加试验方法项目信息
        private void AddCheckMethodPhyItems(UltraGrid ultraGrid)
        {
            try
            {
                if (ultraGrid.ActiveRow != null)
                {
                    string strITEM_NAME = txtITEM_NAME.Text.Trim();
                    if (strITEM_NAME == "")
                    {
                        MessageUtil.ShowWarning("项目名称不能为空！");
                        return;
                    }

                    string strSTD_VALUE = txtSTD_VALUE.Text.Trim();
                    if (strSTD_VALUE == "")
                    {
                        MessageUtil.ShowWarning("定值不能为空！");
                        return;
                    }

                    //if (MessageUtil.ShowYesNoAndQuestion("是否确认新增？") == DialogResult.Yes)
                    //{
                    string strSTD_ID = ultraGrid.ActiveRow.Cells["STD_ID"].Text.Trim();
                    ArrayList arrayList = new ArrayList();
                    arrayList.Add(strSTD_ID);
                    arrayList.Add("");
                    arrayList.Add(strITEM_NAME);
                    arrayList.Add(strSTD_VALUE);
                    arrayList.Add("");

                    //先删除再保存
                    PublicServer.SetData("com.steering.lims.data.base.FrmBaseChemStdSteel.AddCheckMethodPhyItems",
    new Object[] { strSTD_ID, strITEM_NAME, arrayList }, this.ob);

                    QueryChemStdSteelDetailManage(ultraGrid);

                    PublicPipeAndOutdec.ActiveOperateRow(ultraGrid4, "ITEM_NAME", strITEM_NAME);//定位保存的行

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

        private void UpdateCheckMethodPhyItems(UltraGrid ultraGrid)
        {
            try
            {
                if (ultraGrid.ActiveRow != null && ultraGrid4.ActiveRow != null)
                {
                    if (txtITEM_NAME.Text.Trim() != ultraGrid4.ActiveRow.Cells["ITEM_NAME"].Text.Trim())
                    {
                        MessageUtil.ShowWarning("项目名称不能修改！");
                        return;
                    }

                    string strITEM_NAME = txtITEM_NAME.Text.Trim();
                    if (strITEM_NAME == "")
                    {
                        MessageUtil.ShowWarning("项目名称不能为空！");
                        return;
                    }

                    string strSTD_VALUE = txtSTD_VALUE.Text.Trim();
                    if (strSTD_VALUE == "")
                    {
                        MessageUtil.ShowWarning("定值不能为空！");
                        return;
                    }

                    //if (MessageUtil.ShowYesNoAndQuestion("是否确认修改？") == DialogResult.Yes)
                    //{
                    string strSTD_ID = ultraGrid.ActiveRow.Cells["STD_ID"].Text.Trim();
                    ArrayList arrayList = new ArrayList();
                    arrayList.Add("");
                    arrayList.Add(strSTD_VALUE);
                    arrayList.Add("");
                    arrayList.Add(strSTD_ID);
                    arrayList.Add(strITEM_NAME);

                    //先删除再保存
                    PublicServer.SetData("com.steering.lims.data.base.FrmBaseChemStdSteel.UpdateCheckMethodPhyItems",
    new Object[] { arrayList }, this.ob);

                    QueryChemStdSteelDetailManage(ultraGrid);

                    PublicPipeAndOutdec.ActiveOperateRow(ultraGrid4, "ITEM_NAME", strITEM_NAME);//定位保存的行

                    MessageUtil.ShowTips("修改成功！");

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

        private void DeleteCheckMethodPhyItems(UltraGrid ultraGrid)
        {
            try
            {
                if (ultraGrid.ActiveRow != null && ultraGrid4.ActiveRow != null)
                {
                    //if (MessageUtil.ShowYesNoAndQuestion("是否确认删除？") == DialogResult.Yes)
                    //{
                    ArrayList arrayList = new ArrayList();
                    arrayList.Add(ultraGrid.ActiveRow.Cells["STD_ID"].Text.Trim());
                    arrayList.Add(ultraGrid4.ActiveRow.Cells["ITEM_NAME"].Text.Trim());
                    arrayList.Add(ultraGrid4.ActiveRow.Cells["ITEM_NAME"].Text.Trim());
                    arrayList.Add(ultraGrid4.ActiveRow.Cells["ITEM_NAME"].Text.Trim());
                    //先删除再保存
                    PublicServer.SetData("com.steering.lims.data.base.FrmBaseChemStdSteel.DeleteCheckMethodPhyItems",
    new Object[] { arrayList }, this.ob);

                    QueryChemStdSteelDetailManage(ultraGrid);

                    //PublicPipeAndOutdec.ActiveOperateRow(ultraGrid4, "ITEM_NAME", strITEM_NAME);//定位保存的行

                    MessageUtil.ShowTips("删除成功！");
                    //}
                }
            }
            catch (Exception e)
            {
                MessageUtil.ShowWarning(e.Message);
                return;
            }
        }

        private void View_Click(object sender, EventArgs e)
        {
            if (txtCER_BOOK.Text == "")
            {
                MessageUtil.ShowWarning("请先上传再查看！");
                return;
            }
            UltraGridRow ur = null;
            string strTableName = "BASE_CHEM_STDSTEEL_MANAGE";
            if (ultraTabControl1.SelectedTab.Index == 0)
            {
                ur = ultraGrid1.ActiveRow;
                strTableName = "BASE_CHEM_STDSTEEL_INFO";
            }
            else if (ultraTabControl1.SelectedTab.Index == 1)
            {
                ur = ultraGrid2.ActiveRow;
            }
            else if (ultraTabControl1.SelectedTab.Index == 2)
            {
                ur = ultraGrid3.ActiveRow;
            }

            if (ur == null)
            {
                MessageUtil.ShowWarning("请选择一条需要查看上传文件的记录！");
                return;
            }
            string strId = ur.Cells["STD_ID"].Text.Trim();
            string path = "Lims/data/base/" + this.Name + "/" + ur.Cells["SAMPLE_NO"].Text.Trim() + "/";
            if (PublicPipeAndOutdec.ViewFilePosition(this.ob, path) == false)
            {
                PublicPipeAndOutdec.UpdateFilePosition(strTableName, "", "STD_ID", strId, this.ob);//更改数据库存储路径
                if (ultraTabControl1.SelectedTab.Index == 0)
                {
                    QueryChemStdSteelBase();
                    PublicPipeAndOutdec.ActiveOperateRow(ultraGrid1, "STD_ID", strId);//定位保存的行
                }
                else if (ultraTabControl1.SelectedTab.Index == 1)
                {
                    QueryChemStdSteelBaseManage(ultraGrid2, dataTable2, ultraSTDSTEEL_TYPE.Value.ToString());

                    PublicPipeAndOutdec.ActiveOperateRow(ultraGrid2, "STD_ID", strId);//定位保存的行
                }
                else if (ultraTabControl1.SelectedTab.Index == 2)
                {
                    QueryChemStdSteelBaseManage(ultraGrid3, dataTable3, ultraSTDSTEEL_TYPE.Value.ToString());

                    PublicPipeAndOutdec.ActiveOperateRow(ultraGrid3, "STD_ID", strId);//定位保存的行
                }
            }
        }

        private void Upload_Click(object sender, EventArgs e)
        {
            //if (txtCER_BOOK.Text != "")
            //{
            //    MessageUtil.ShowWarning("该记录已存在一份文件，请删除后再重新上传！");
            //    return;
            //}

            UltraGridRow ur = null;
            string strTableName = "BASE_CHEM_STDSTEEL_MANAGE";
            if (ultraTabControl1.SelectedTab.Index == 0)
            {
                ur = ultraGrid1.ActiveRow;
                strTableName = "BASE_CHEM_STDSTEEL_INFO";
            }
            else if (ultraTabControl1.SelectedTab.Index == 1)
            {
                ur = ultraGrid2.ActiveRow;
            }
            else if (ultraTabControl1.SelectedTab.Index == 2)
            {
                ur = ultraGrid3.ActiveRow;
            }

            if (ur == null)
            {
                MessageUtil.ShowWarning("请选择一条需要上传文件的记录！");
                return;
            }
            string strId = ur.Cells["STD_ID"].Text.Trim();
            string path = "Lims/data/base/" + this.Name + "/" + ur.Cells["SAMPLE_NO"].Text.Trim() + "/";
            if (PublicPipeAndOutdec.UploadFilePosition(this.ob, path))
            {
                PublicPipeAndOutdec.UpdateFilePosition(strTableName, path, "STD_ID", strId, this.ob);//更改数据库存储路径
                if (ultraTabControl1.SelectedTab.Index == 0)
                {
                    QueryChemStdSteelBase();
                    PublicPipeAndOutdec.ActiveOperateRow(ultraGrid1, "STD_ID", strId);//定位保存的行
                }
                else if (ultraTabControl1.SelectedTab.Index == 1)
                {
                    QueryChemStdSteelBaseManage(ultraGrid2, dataTable2, ultraSTDSTEEL_TYPE.Value.ToString());

                    PublicPipeAndOutdec.ActiveOperateRow(ultraGrid2, "STD_ID", strId);//定位保存的行
                }
                else if (ultraTabControl1.SelectedTab.Index == 2)
                {
                    QueryChemStdSteelBaseManage(ultraGrid3, dataTable3, ultraSTDSTEEL_TYPE.Value.ToString());

                    PublicPipeAndOutdec.ActiveOperateRow(ultraGrid3, "STD_ID", strId);//定位保存的行
                }
            }
        }

        private void ultraGrid5_AfterRowActivate(object sender, EventArgs e)
        {
            QueryChemStdSteelDetailManage(ultraGrid5);
            setValue(ultraGrid5);
        }

        private void txtUNIT_ValueChanged(object sender, EventArgs e)
        {

        }

        private void ultraLabel3_Click(object sender, EventArgs e)
        {

        }

        private void ultraLabel1_Click(object sender, EventArgs e)
        {

        }

        private void txtPRODUCT_TYPE_ValueChanged(object sender, EventArgs e)
        {

        }
    }
}