MES_Client/TGMES/Core.StlMes.Client.LgIntegrationQuery/frmCheSteel.cs

using System;
using System.Collections.Generic;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using CoreFS.CA06;
using Core.StlMes.Client.LgCommon;
using Infragistics.Win.UltraWinGrid;

namespace Core.StlMes.Client.LgIntegrationQuery
{
    public partial class frmCheSteel : frmStyleBase
    {

        public frmCheSteel()
        {
            InitializeComponent();
        }

        private void frmCheSteel_Load(object sender, EventArgs e)
        {
            getAllSteel();
            getDetail();
        }

        //成分检验牌号查询 
        /// <summary>
        ///成分检验牌号查询 
        /// </summary>
        private void getDetail()
        {
            try
            {
                string strErr = "";
                ArrayList arry = new ArrayList();
                arry.Add("frmChementSteel.Select");//此ID为XML文件ID  
                CommonClientToServer cctos = new CommonClientToServer();
                cctos.ob = this.ob;
                DataSet ds = cctos.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery",
                                            "doSimpleQuery", arry, out strErr);
                ultraDataSource1.Rows.Clear();
                if (strErr == "" && ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
                {
                    for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                    { 
                        DataRow dr=ds.Tables[0].Rows[i];
                        this.ultraDataSource1.Rows.Add(new object[]{
                        dr["ID"].ToString(),
                        dr["CODE"].ToString(),
                        dr["STEEL"].ToString(),
                        dr["RECORDER"].ToString(),
                        dr["INPUTTIME"].ToString(),
                        dr["MEMO"].ToString()
                        });
                    }
                }
                //PublicMethod.RefreshAndAutoSize(ultraGrid1);
            }
            catch { }
        }

        // 获取所有牌号
        /// <summary>
        /// 获取所有牌号
        /// </summary>
        private void getAllSteel()
        {
            try
            {
                string strErr = "";
                cmbSteel.Items.Clear();
                ArrayList arry = new ArrayList();
                arry.Add("ElementsSteel1.Query");//此ID为XML文件ID
                CommonClientToServer cctos = new CommonClientToServer();
                cctos.ob = this.ob;
                DataSet ds = cctos.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery",
                                            "doSimpleQuery", arry, out strErr);
                if (strErr == "" && ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
                {
                    for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                    {
                        DataRow dr = ds.Tables[0].Rows[i];
                        cmbSteel.Items.Add(dr["STEELCODE"].ToString(),dr["STEEL"].ToString());
                    }
                }
            }
            catch { }
        }

        //  新增成分检验牌号
        /// <summary>
        /// 新增成分检验牌号
        /// </summary>
        private void proc_Add()
        {
            try
            {
              
                if (txtCode.Text.ToString() == "")
                {
                    MessageBox.Show("编号不能为空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                    txtCode.Focus();
                    return;
                }

                if (cmbSteel.Text.ToString() == "")
                {
                    MessageBox.Show("牌号不能为空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                    cmbSteel.Focus();
                    return;
                }

                string strErr = "";
                string strSqlID = "frmChementSteel_Add";
                object[] sArgs = new object[4];
                sArgs[0] = txtCode.Text.Trim();                    //编号
                sArgs[1] = cmbSteel.Text.Trim();                   //牌号
                sArgs[2] = this.UserInfo.GetUserName();            //操作人
                sArgs[3] = txtReason.Text.Trim();                  //备注
                try
                {
                    CommonClientToServer ccTs = new CommonClientToServer();
                    ccTs.ob = ob;
                    string strRCode = ccTs.ExecuteProcedureFunctions("Core.LgMes.Server.Common.ComDBProcedure",
                                                    "ExecProcWithCollParam", strSqlID, sArgs, out strErr);
                    if (strErr != "")
                    {
                      //  MessageBox.Show(strErr, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                        return;
                    }
                    else
                    {
                        getDetail();
                        MessageBox.Show("新增成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                    }
                }
                catch { }
            }
            catch { }
        }

        // 修改成分检验牌号
        /// <summary>
        /// 修改成分检验牌号
        /// </summary>
        private void proc_Edit()
        {
            try
            {
                if (ultraGrid1.Rows.Count == 0)
                {
                    MessageBox.Show("没有可修改的信息！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                    return;
                }
                if (ultraGrid1.ActiveRow == null)
                {
                    MessageBox.Show("请选择要修改的信息！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                    return;
                }
                if (txtCode.Text.ToString() == "")
                {
                    MessageBox.Show("编号不能为空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                    txtCode.Focus();
                    return;
                }

                if (cmbSteel.Text.ToString() == "")
                {
                    MessageBox.Show("牌号不能为空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                    cmbSteel.Focus();
                    return;
                }

                string strErr = "";
                string strSqlID = "frmChementSteel_Edit";
                object[] sArgs = new object[5];
                sArgs[0] = txtCode.Text.Trim();                    //编号
                sArgs[1] = cmbSteel.Text.Trim();                   //牌号
                sArgs[2] = this.UserInfo.GetUserName();            //操作人
                sArgs[3] = txtReason.Text.Trim();                  //备注
                sArgs[4] = ultraGrid1.ActiveRow.Cells["ID"].Value.ToString(); //ID
                try
                {
                    CommonClientToServer ccTs = new CommonClientToServer();
                    ccTs.ob = ob;
                    string strRCode = ccTs.ExecuteProcedureFunctions("Core.LgMes.Server.Common.ComDBProcedure",
                                                    "ExecProcWithCollParam", strSqlID, sArgs, out strErr);
                    if (strErr != "")
                    {
                    //    MessageBox.Show(strErr, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                        return;
                    }
                    else
                    {
                        getDetail();
                        MessageBox.Show("修改成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                    }
                }
                catch { }
            }
            catch { }
        }

        // 删除成分检验牌号
        /// <summary>
        /// 删除成分检验牌号
        /// </summary>
        private void proc_Del()
        {
            try
            {
                if (ultraGrid1.Rows.Count == 0)
                {
                    MessageBox.Show("没有可删除的信息！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                    return;
                }
                if (ultraGrid1.ActiveRow == null)
                {
                    MessageBox.Show("请选择要删除的信息！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                    return;
                }
                DialogResult dr = MessageBox.Show("是否确认删除信息？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
                if (dr == DialogResult.No) return;
                string ID = ultraGrid1.ActiveRow.Cells["ID"].Value.ToString().Trim();
                string strErr = "";
                string strSqlID = "frmChementSteel_Delete";
                object[] sArgs = new object[2];
                sArgs[0] = ID;                    //ID
                sArgs[1] = this.UserInfo.GetUserName();                    //操作人
                try
                {
                    CommonClientToServer ccTs = new CommonClientToServer();
                    ccTs.ob = ob;
                    string strRCode = ccTs.ExecuteProcedureFunctions("Core.LgMes.Server.Common.ComDBProcedure",
                                                    "ExecProcWithCollParam", strSqlID, sArgs, out strErr);
                    if (strErr != "")
                    {
                  //      MessageBox.Show("删除失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                        return;
                    }
                    else
                    {
                        getDetail();
                        MessageBox.Show("删除成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                    }
                }
                catch { }
            }
            catch { }
        }

        // 系统功能
        /// <summary>
        /// 系统功能
        /// </summary>
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    getDetail();
                    break;
                case "Add":
                    proc_Add();
                    break;
                case "Update":
                    proc_Edit();
                    break;
                case "Delete":
                    proc_Del();
                    break;
                case "Exit":
                    this.Close();
                    break;
                default:
                    break;
            }
        }

        private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
        {
            try
            {
                txtCode.Text = ultraGrid1.ActiveRow.Cells["CODE"].Value.ToString().Trim();
                cmbSteel.Text = ultraGrid1.ActiveRow.Cells["STEEL"].Value.ToString().Trim();
                txtReason.Text = ultraGrid1.ActiveRow.Cells["MEMO"].Value.ToString().Trim();
            }
            catch { }
        }




    }
}