XinYu_LG2MES/ClientSolution/Core.LgMes.Client.lgIntegrationQuery/frmSteelCode.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Collections;
using System.IO;
using System.Diagnostics;

using Infragistics.Win.UltraWinGrid;
using CoreFS.CA06;
using Core.Mes.Client.Common;

namespace Core.LgMes.Client.LgIntegrationQuery
{
    public partial class frmSteelCode : frmStyleBase
    {
        private bool bAddNow, bEditNow, bDelNow;                       //是否在进行新增、修改或者删除操作
        private UltraGridRow currRow = null;
       // private CallingMessage par;
        private string strReturn = "ExecuteCommand_Return", strNonReturn = "ExecuteCommand_NonReturn";

        public frmSteelCode()
        {
            InitializeComponent();
        }

        private void frmSteelCode_Load(object sender, EventArgs e)
        {
            proc_Init();
            proc_BindData();
            proc_Query("");

            proc_SetToolbarButtons();
        }

        private void proc_Init()
        {
            try
            {
                //hengxing
                //par = new CallingMessage();
                //par.ServerName = "Report";
                //par.AssemblyName = "Core.LgMes.Server.Report";
                //par.ClassName = "Core.LgMes.Server.Report.reportMethod";
            }
            catch (Exception ex)
            {
                MessageBox.Show("初始化失败！\r\n" + ex.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
                if (MessageBox.Show("点击［是］将重新初始化，强烈建议执行此操作！", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
                {
                    proc_Init();
                }
            }
        }

        private void proc_SetToolbarButtons()
        {
            try
            {
                ultraToolbarsManager1.Toolbars[0].Tools["QUERY"].SharedProps.Enabled = !(bAddNow || bEditNow || bDelNow);
                ultraToolbarsManager1.Toolbars[0].Tools["NEW"].SharedProps.Enabled = !(bAddNow || bEditNow || bDelNow);
                ultraToolbarsManager1.Toolbars[0].Tools["MODIFY"].SharedProps.Enabled = (!(bAddNow || bEditNow || bDelNow) && (ultraGrid1.ActiveRow != null));
                ultraToolbarsManager1.Toolbars[0].Tools["DEL"].SharedProps.Enabled = (!(bAddNow || bEditNow || bDelNow) && (ultraGrid1.ActiveRow != null));
                ultraToolbarsManager1.Toolbars[0].Tools["EXPORT"].SharedProps.Enabled = (!(bAddNow || bEditNow || bDelNow) && ultraGrid1.Rows.Count > 0);

                ultraToolbarsManager1.Toolbars[0].Tools["SAVE"].SharedProps.Enabled = (bAddNow || bEditNow);
                ultraToolbarsManager1.Toolbars[0].Tools["CANCEL"].SharedProps.Enabled = (bAddNow || bEditNow);

                ultraToolbarsManager1.Toolbars[0].Tools["SAVE"].SharedProps.Visible = (bAddNow || bEditNow);
                ultraToolbarsManager1.Toolbars[0].Tools["CANCEL"].SharedProps.Visible = (bAddNow || bEditNow);
            }
            catch { }
        }

        private void proc_SetUltraGridReadOnly(Infragistics.Win.UltraWinGrid.UltraGridBase ultGrid)
        {
            foreach (UltraGridRow row in ultGrid.Rows)
            {
                row.Activation = Activation.NoEdit;
            }
        }

        private void proc_setCellReadOnly(UltraGridRow row, bool bReadOnly)
        {
            try
            {
                if (row == null)
                    return;

                if (bReadOnly)
                {
                    row.Activation = Activation.NoEdit;
                    row.Cells["STEELCODE"].CancelUpdate();
                    row.Cells["STEELNAME"].CancelUpdate();
                }
                else
                {
                    row.Activation = Activation.AllowEdit;

                    row.Cells["STEELCODE"].Activation = Activation.AllowEdit;
                    row.Cells["STEELNAME"].Activation = Activation.AllowEdit;
                    row.Cells["RECORDER"].Activation = Activation.NoEdit;
                    row.Cells["OPTDATE"].Activation = Activation.NoEdit;
                }                
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        private void cbxCode_CheckedChanged(object sender, EventArgs e)
        {
            cbbCode.Enabled = cbxCode.Checked;
            if (!cbxCode.Checked)
            {
                cbbCode.Text = "";
            }
        }

        private void cbxName_CheckedChanged(object sender, EventArgs e)
        {
            cbbName.Enabled = cbxName.Checked;
            if (!cbxName.Checked)
            {
                cbbName.Text = "";
            }
        }

        private void proc_BindData()
        {
            Cursor oldCursor = this.Cursor;
            this.Cursor = Cursors.WaitCursor;
            try
            {
                string strErr = "";
                string strSql = "select STEELCODE STEELCODE, STEELNAME STEELNAME from BSA_ISTEELCODE order by STEELNAME";

               //hengxing
                //par.MethodName = strReturn;
                //par.args = new object[] { strSql };

                DataSet ds = null;//hengxing ClientCommon._RemotingHelp.ExecuteMethod(par, out strErr) as DataSet;

                if (strErr != "" || !(ds != null && ds.Tables.Count > 0))
                {
                    MessageBox.Show("查询条件加载失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    if (MessageBox.Show("是否重新加载查询条件？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
                        proc_BindData();
                    return;
                }

                DataView dvCode = ds.Tables[0].DefaultView;
                DataView dvName = ds.Tables[0].Copy().DefaultView;

                dvCode.Sort = "STEELCODE";
                dvName.Sort = "STEELNAME";

                cbbCode.DataSource = dvCode;  
                cbbCode.DisplayMember = "STEELCODE";
                cbbCode.SelectedIndex = -1;

                cbbName.DataSource = dvName;
                cbbName.DisplayMember = "STEELNAME";
                cbbName.SelectedIndex = -1;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                this.Cursor = oldCursor;
            }
        }

        private void proc_Query(string strCode)
        {
            Cursor oldCursor = this.Cursor;
            this.Cursor = Cursors.WaitCursor;
            try
            {
                string strWhere = "where 1 = 1";

                if (cbxCode.Checked && cbbCode.Text.Trim().Length > 0)
                {
                    strWhere += " and STEELCODE = '" + cbbCode.Text.Trim() + "'";
                }

                if (cbxName.Checked && cbbName.Text.Trim().Length > 0)
                {
                    strWhere += " and STEELNAME = '" + cbbName.Text.Trim() + "'";
                }

                string strErr = "";
                string strSql = "select STEELCODE STEELCODE, STEELNAME STEELNAME, "
                    + "RECORDER RECORDER, to_char(OPTDATE,'yyyy-MM-dd HH24:mi:ss') OPTDATE "
                    + "from BSA_ISTEELCODE " + strWhere + " order by STEELNAME";

                //hengxing
                //par.MethodName = strReturn;
                //par.args = new object[] { strSql };

                DataSet ds = null;//hengxing ClientCommon._RemotingHelp.ExecuteMethod(par, out strErr) as DataSet;

                if (strErr != "" || !(ds != null && ds.Tables.Count > 0))
                {
                    MessageBox.Show("钢种信息加载失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    if (MessageBox.Show("是否重新加载钢种信息？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
                        proc_Query(strCode);
                    return;
                }

                if (ds != null && ds.Tables.Count > 0)
                {
                    this.dataTable1.Rows.Clear();

                    DataRow dr;
                    for (int iRow = 0; iRow < ds.Tables[0].Rows.Count; iRow++)
                    {
                        dr = this.dataTable1.NewRow();
                        for (int jCol = 0; jCol < ds.Tables[0].Columns.Count; jCol++)
                        {
                            dr[ds.Tables[0].Columns[jCol].ColumnName] = Convert.ToString(ds.Tables[0].Rows[iRow][jCol]);

                        }
                        this.dataTable1.Rows.Add(dr);
                    }
                    ultraGrid1.UpdateData();
                }

                this.proc_SetUltraGridReadOnly(ultraGrid1);

                if (ultraGrid1.Rows.Count > 0)
                {
                    ultraGrid1.ActiveCell = ultraGrid1.Rows[0].Cells["STEELCODE"];
                    ultraGrid1.Rows[0].Cells["STEELCODE"].Selected = false;
                }

                if (strCode.Trim().Length == 0) return;

                string str = "";
                for (int i = 0; i < ultraGrid1.Rows.Count; i++)
                {
                    str = Convert.ToString(ultraGrid1.Rows[i].Cells["STEELCODE"].Value);
                    if (str == strCode)
                    {
                        ultraGrid1.ActiveCell = ultraGrid1.Rows[i].Cells["STEELCODE"];
                        ultraGrid1.Rows[i].Cells["STEELCODE"].Selected = false;
                        return;
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                this.Cursor = oldCursor;
            }
        }

        private void proc_Add()
        {
            try
            {
                if (currRow == null) return;

                ultraGrid1.UpdateData();

                string strCode = currRow.Cells["STEELCODE"].Text.Trim();
                string strName = currRow.Cells["STEELNAME"].Text.Trim();

                if (strCode.Length == 0)
                {
                    MessageBox.Show("请输入钢种代码！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    ultraGrid1.ActiveCell = currRow.Cells["STEELCODE"];
                    currRow.Cells["STEELCODE"].Selected = false;
                    return;
                }

                if (strName.Length == 0)
                {
                    MessageBox.Show("请输入钢种名称！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    ultraGrid1.ActiveCell = currRow.Cells["STEELNAME"];
                    currRow.Cells["STEELNAME"].Selected = false;
                    return;
                }

                string strErr = "";
                string strSql = "select count(1) from BSA_ISTEELCODE where STEELCODE = '" + strCode + "'";

                //hengxing
                //par.MethodName = strReturn;
                //par.args = new object[] { strSql };

                DataSet ds = null;//hengxing ClientCommon._RemotingHelp.ExecuteMethod(par, out strErr) as DataSet;

                if (strErr != "" || !(ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0))
                {
                    MessageBox.Show("新增钢种代码［" + strCode + "/" + strName + "］失败！\r\n" + strErr, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }

                int iCnt = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
                if (iCnt > 0)
                {
                    MessageBox.Show("钢种代码［" + strCode + "］重复，请重新输入！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    ultraGrid1.ActiveCell = currRow.Cells["STEELCODE"];
                    currRow.Cells["STEELCODE"].Selected = false;
                    return;
                }

                strErr = "";
                strSql = "select count(1) from BSA_ISTEELCODE where STEELNAME = '" + strName + "'";

                //hengxing
                //par.MethodName = strReturn;
                //par.args = new object[] { strSql };

                ds = null;//hengxing ClientCommon._RemotingHelp.ExecuteMethod(par, out strErr) as DataSet;

                if (strErr != "" || !(ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0))
                {
                    MessageBox.Show("新增钢种代码［" + strCode + "/" + strName + "］失败！\r\n" + strErr, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }

                iCnt = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
                if (iCnt > 0)
                {
                    MessageBox.Show("钢种名称［" + strName + "］重复，请重新输入！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    ultraGrid1.ActiveCell = currRow.Cells["STEELNAME"];
                    currRow.Cells["STEELNAME"].Selected = false;
                    return;
                }

                strErr = "";
                strSql = "insert into BSA_ISTEELCODE (STEELCODE, STEELNAME, RECORDER, OPTDATE) values "
                    + "('" + strCode + "', '" + strName + "', '" + this.UserInfo.GetUserName() + "', sysdate)";

                //hengxing
                //par.MethodName = strNonReturn;
                //par.args = new object[] { strSql };

                //ClientCommon._RemotingHelp.ExecuteMethod(par, out strErr);

                if (!(strErr == null || strErr == ""))
                {
                    MessageBox.Show("新增钢种代码［" + strCode + "/" + strName + "］失败！\r\n" + strErr, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }

                this.proc_setCellReadOnly(currRow, true);                
                this.proc_Query(strCode);
                currRow = null;
                bAddNow = false;
                this.proc_SetToolbarButtons();
                MessageBox.Show("新增钢种代码［" + strCode + "/" + strName + "］成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        private void proc_Edit()
        {
            try
            {
                if (currRow == null) return;

                ultraGrid1.UpdateData();

                string strOldCode = Convert.ToString(currRow.Cells["STEELCODE"].Tag);
                string strOldName = Convert.ToString(currRow.Cells["STEELNAME"].Tag);
                string strCode = currRow.Cells["STEELCODE"].Text.Trim();
                string strName = currRow.Cells["STEELNAME"].Text.Trim();

                if (strCode.Length == 0)
                {
                    MessageBox.Show("请输入钢种代码！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    ultraGrid1.ActiveCell = currRow.Cells["STEELCODE"];
                    currRow.Cells["STEELCODE"].Selected = false;
                    return;
                }

                if (strName.Length == 0)
                {
                    MessageBox.Show("请输入钢种名称！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    ultraGrid1.ActiveCell = currRow.Cells["STEELNAME"];
                    currRow.Cells["STEELNAME"].Selected = false;
                    return;
                }

                string strErr = "";
                string strSql = "select count(1) from BSA_ISTEELCODE "
                    + "where STEELCODE = '" + strCode + "' and STEELCODE <> '" + strOldCode + "'";

                //par.MethodName = strReturn;
                //par.args = new object[] { strSql };

                DataSet ds = null;//hengxing ClientCommon._RemotingHelp.ExecuteMethod(par, out strErr) as DataSet;

                if (strErr != "" || !(ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0))
                {
                    MessageBox.Show("钢种代码［" + strOldCode + "/" + strOldName + "］信息修改失败！\r\n" + strErr, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }

                int iCnt = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
                if (iCnt > 0)
                {
                    MessageBox.Show("钢种代码［" + strCode + "］重复，请重新输入！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    ultraGrid1.ActiveCell = currRow.Cells["STEELCODE"];
                    currRow.Cells["STEELCODE"].Selected = false;
                    return;
                }

                strErr = "";
                strSql = "select count(1) from BSA_ISTEELCODE "
                    + "where STEELNAME = '" + strName + "' and STEELCODE <> '" + strOldCode + "'";
                //hengxing
                //par.MethodName = strReturn;
                //par.args = new object[] { strSql };

                ds = null;//hengxing ClientCommon._RemotingHelp.ExecuteMethod(par, out strErr) as DataSet;
                    
                if (strErr != "" || !(ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0))
                {
                    MessageBox.Show("钢种代码［" + strOldCode + "/" + strOldName + "］信息修改失败！\r\n" + strErr, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }

                iCnt = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
                if (iCnt > 0)
                {
                    MessageBox.Show("钢种名称［" + strName + "］重复，请重新输入！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    ultraGrid1.ActiveCell = currRow.Cells["STEELNAME"];
                    currRow.Cells["STEELNAME"].Selected = false;
                    return;
                }

                strErr = "";
                strSql = "update BSA_ISTEELCODE set "
                    + "STEELCODE = '" + strCode + "', STEELNAME = '" + strName + "', "
                    + "RECORDER = '" + this.UserInfo.GetUserName() + "', OPTDATE = sysdate "
                    + "where STEELCODE = '" + strOldCode + "'";

                //hengxing
                //par.MethodName = strNonReturn;
                //par.args = new object[] { strSql };

                //ClientCommon._RemotingHelp.ExecuteMethod(par, out strErr);

                if (!(strErr == null || strErr == ""))
                {
                    MessageBox.Show("钢种代码［" + strOldCode + "/" + strOldName + "］信息修改失败！\r\n" + strErr, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }

                this.proc_setCellReadOnly(currRow, true);
                this.proc_Query(strCode);
                currRow = null;
                bEditNow = false;
                this.proc_SetToolbarButtons();
                MessageBox.Show("钢种代码［" + strOldCode + "/" + strOldName + "］信息修改成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        private void proc_Delete()
        {
            try
            {
                if (ultraGrid1.Rows.Count <= 0) return;

                if (ultraGrid1.ActiveRow == null)
                {
                    MessageBox.Show("请选择要删除的钢种代码！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    return;
                }

                UltraGridRow row = ultraGrid1.ActiveRow;

                string strCode = Convert.ToString(row.Cells["STEELCODE"].Value);
                string strName = Convert.ToString(row.Cells["STEELNAME"].Value);

                if (MessageBox.Show("确定要删除钢种代码［" + strCode + "/" + strName + "］信息吗？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
                    return;

                string strErr = "";
                string strSql = "select count(1) from BSA_ISTEELCODE where STEELCODE = '" + strCode + "' and STEELNAME = '" + strName + "'";

                //hengxing
                //par.MethodName = strReturn;
                //par.args = new object[] { strSql };

                DataSet ds = null;//hengxing ClientCommon._RemotingHelp.ExecuteMethod(par, out strErr) as DataSet;

                if (strErr != "" || !(ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0))
                {
                    MessageBox.Show("钢种代码［" + strCode + "/" + strName + "］信息删除失败！\r\n" + strErr, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }

                int iCnt = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
                if (iCnt == 0)
                {
                    MessageBox.Show("不存在钢种代码［" + strCode + "/" + strName + "］信息！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    proc_Query("");
                    return;
                }

                strErr = "";
                strSql = "delete from BSA_ISTEELCODE where STEELCODE = '" + strCode + "' and STEELNAME = '" + strName + "'";

                //hengxing
                //par.MethodName = strNonReturn;
                //par.args = new object[] { strSql };

                //ClientCommon._RemotingHelp.ExecuteMethod(par, out strErr);

                if (!(strErr == null || strErr == ""))
                {
                    MessageBox.Show("钢种代码［" + strCode + "/" + strName + "］信息删除失败！\r\n" + strErr, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }

                this.proc_Query("");
                MessageBox.Show("钢种代码［" + strCode + "/" + strName + "］信息删除成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        private void ultraToolbarsManager1_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs e)
        {
            switch (e.Tool.Key)
            {
                case "QUERY":
                    {
                        if (bAddNow || bEditNow || bDelNow)
                            return;
                        proc_Query("");
                        proc_SetToolbarButtons();
                        break;
                    }
                case "NEW":
                    {
                        if (bAddNow || bEditNow || bDelNow)
                            return;
                        currRow = this.ultraGrid1.DisplayLayout.Bands[0].AddNew();
                        this.proc_setCellReadOnly(currRow, false);
                        ultraGrid1.ActiveCell = currRow.Cells["STEELCODE"];
                        currRow.Cells["STEELCODE"].Selected = false;
                        bAddNow = true;
                        this.proc_SetToolbarButtons();
                        break;
                    }
                case "MODIFY":
                    {
                        if (ultraGrid1.ActiveRow == null || (bAddNow || bEditNow || bDelNow))
                            return;
                        currRow = ultraGrid1.ActiveRow;
                        this.proc_setCellReadOnly(currRow, false);
                        ultraGrid1.ActiveCell = currRow.Cells["STEELCODE"];
                        currRow.Cells["STEELCODE"].Selected = false;
                        currRow.Cells["STEELCODE"].Tag = currRow.Cells["STEELCODE"].Value;
                        currRow.Cells["STEELNAME"].Tag = currRow.Cells["STEELNAME"].Value;
                        bEditNow = true;
                        this.proc_SetToolbarButtons();
                        break;
                    }
                case "DEL":
                    {
                        if (ultraGrid1.ActiveRow == null || (bAddNow || bEditNow || bDelNow))
                            return;
                        bDelNow = true;
                        this.proc_SetToolbarButtons();
                        proc_Delete();
                        bDelNow = false;
                        this.proc_SetToolbarButtons();
                        break;
                    }
                case "SAVE":
                    {
                        if (bAddNow)
                        {
                            proc_Add();
                        }
                        else if (bEditNow)
                        {
                            proc_Edit();
                        }
                        break;
                    }
                case "CANCEL":
                    {
                        if (!(bAddNow || bEditNow)) return;
                        string strOpt = " ［" + (bAddNow ? "新增" : (bEditNow ? "修改" : "")) + "］";
                        if (MessageBox.Show("确定要取消" + strOpt + "操作吗？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
                            return;
                        if (bAddNow)
                        {
                            currRow.Delete(false);
                            currRow = null;
                            if (ultraGrid1.Rows.Count > 0)
                            {
                                ultraGrid1.ActiveCell = ultraGrid1.Rows[ultraGrid1.Rows.Count - 1].Cells["STEELCODE"];
                                ultraGrid1.Rows[ultraGrid1.Rows.Count - 1].Cells["STEELCODE"].Selected = false;
                            }
                            bAddNow = false;
                        }
                        else if (bEditNow)
                        {
                            this.proc_setCellReadOnly(currRow, true);
                            currRow.Cells["STEELCODE"].Value = currRow.Cells["STEELCODE"].Tag;
                            currRow.Cells["STEELNAME"].Value = currRow.Cells["STEELNAME"].Tag;
                            ultraGrid1.ActiveCell = currRow.Cells["STEELCODE"];
                            currRow.Cells["STEELCODE"].Selected = false;
                            currRow = null;
                            bEditNow = false;
                        }
                        this.proc_SetToolbarButtons();
                        break;
                    }
                case "EXPORT":
                    {
                        if ((bAddNow || bEditNow || bDelNow) || ultraGrid1.Rows.Count <= 0)
                            return;

                        bool bInstalled = (Type.GetTypeFromProgID("Excel.Application") != null);
                        if (!bInstalled)
                        {
                            MessageBox.Show("系统没有安装EXCEL组件，无法导出数据！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                            return;
                        }

                        string strFileName = Application.StartupPath + "\\Report\\钢种代码.xls";
                        ultraGridExcelExporter1.Export(ultraGrid1, strFileName);

                        ProcessStartInfo p = new ProcessStartInfo(strFileName);
                        p.WorkingDirectory = Path.GetDirectoryName(strFileName);
                        Process.Start(p);
                        break;
                    }
                case "CLOSE":
                    {
                        this.Close();
                        break;
                    }
            }
        }

        private void frmSteelCode_FormClosing(object sender, FormClosingEventArgs e)
        {
            try
            {
                if (bAddNow)
                {
                    if (MessageBox.Show("［新增］操作尚未完成，确定要关闭吗？", "提示", MessageBoxButtons.OKCancel,
                        MessageBoxIcon.Question) == DialogResult.Cancel)
                        e.Cancel = true;
                    else
                    {
                        bAddNow = false;
                        e.Cancel = false;
                    }
                }
                else if (bEditNow)
                {
                    if (MessageBox.Show("［修改］操作尚未完成，确定要关闭吗？", "提示", MessageBoxButtons.OKCancel,
                        MessageBoxIcon.Question) == DialogResult.Cancel)
                        e.Cancel = true;
                    else
                    {
                        bEditNow = false;
                        e.Cancel = false;
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
    }
}