XinYu_LZMES_Client/Core.LZMes.Client.QCM/QCM01/QCM0101.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 System.Collections;
using Infragistics.Win.UltraWinGrid;

namespace Core.LZMes.Client.QCM
{
    public partial class QCM0101 : FrmBase
    {
        public QCM0101()
        {
            InitializeComponent();
        }

        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    this.DoQuery();
                    break;
                case "Add":
                    this.DoAdd();
                    break;
                case "Update":
                    this.DoUpdate();
                    break;
                case "Delete":
                    this.DoDelete();
                    break;
            }
        }

        private void DoQuery()
        {
            //查询
            try
            {
                
                CoreClientParam ccp = new CoreClientParam();
                this.dataSet1.Tables[0].Clear();
                string chemName = this.textBox1.Text.Trim();

                ccp = new CoreClientParam();
                ccp.ServerName = "QCM.QCM01.QCM0101.QueryChem";
                ccp.MethodName = "Query";
                ccp.ServerParams = new object[] { chemName };
                //ccp.IfShowErrMsg = false;
                ccp.SourceDataTable = this.dataSet1.Tables[0];
                this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);

            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
            }


        }

        private void DoAdd()
        {
            //新增
            try
            {
                if (this.UserInfo.GetUserGroup() == 0 + "")
                {
                    MessageBox.Show("常白班人员禁止对数据进行操作", "警告");
                    return;
                }
                if ("" == this.textBox2.Text )
                {
                    MessageBox.Show("化学元素代码不能为空！", "警告");
                    this.textBox2.Focus();
                    return;
                }
                if ("" == this.textBox3.Text)
                {
                    MessageBox.Show("化学元素名称不能为空！", "警告");
                    this.textBox3.Focus();
                    return;
                }
                if ("" == this.textBox4.Text)
                {
                    MessageBox.Show("化学元素类型不能为空！", "警告");
                    this.textBox4.Focus();
                    return;
                }
                if ("" == this.textBox7.Text)
                {
                    MessageBox.Show("化学元素类型不能为空！", "警告");
                    this.textBox7.Focus();
                    return;
                }

                if (MessageBox.Show("确认保存？", "提示", MessageBoxButtons.OKCancel) == DialogResult.Cancel)
                    return;

                ArrayList al = new ArrayList();
                al.Add(this.textBox2.Text.Trim());//化学元素代码
                al.Add(this.textBox3.Text.Trim());//化学元素名称
                al.Add(this.textBox4.Text.Trim());//化学元素类型
                al.Add(this.textBox5.Text.Trim());//复合元素计算公式
                al.Add(this.textBox7.Text.Trim());//缺陷类型
                al.Add(this.textBox6.Text.Trim());//备注
                al.Add(this.UserInfo.GetUserID()); // 创建人ID
                al.Add(this.UserInfo.GetUserName());// 创建人

                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "QCM.QCM01.QCM0101.addChem";
                ccp.MethodName = "add";
                ccp.ServerParams = new object[] { al };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                if (0 != ccp.ReturnCode) return;

                if ("1" != ccp.ReturnObject.ToString())  // 1是受到影响的行数，即默认为1，后台返回其他消息时 就会改变ReturnObject的值
                {
                    MessageBox.Show(ccp.ReturnObject.ToString(), "警告");
                    return;
                }

                this.textBox1.Text = "";
                DoQuery();
                MessageBox.Show("创建成功！");

            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                MessageBox.Show("系统发生异常，请与管理员联系", "提示");

            }
        }

        private void DoUpdate()
        {
            //更新
            try
            {
                
                if (this.UserInfo.GetUserGroup() == 0 + "")
                {
                    MessageBox.Show("常白班人员禁止对数据进行操作", "警告");
                    return;
                }

                if (this.ultraGrid1.Selected.Rows.Count == 0)
                {
                    MessageBox.Show("请选择要修改的数据！");
                    return;
                }
                //选择一行数据
                UltraGridRow ugr = this.ultraGrid1.ActiveRow;
                string chemCode = ugr.Cells["CHEM_CODE"].Value.ToString();

                if (MessageBox.Show("确认修改？", "提示", MessageBoxButtons.OKCancel) == DialogResult.Cancel)
                    return;

                ArrayList al = new ArrayList();
                al.Add(chemCode); //化学元素代码
                al.Add(this.textBox3.Text.Trim()); //化学元素名称
                al.Add(this.textBox4.Text.Trim()); // 化学元素类型
                al.Add(this.textBox5.Text.Trim()); //复合元素计算公式
                al.Add(this.textBox7.Text.Trim()); // 缺陷类型
                al.Add(this.textBox6.Text.Trim());    //备注
                al.Add(this.UserInfo.GetUserID());  //修改人ID
                al.Add(this.UserInfo.GetUserName());//修改人名字
                

                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "QCM.QCM01.QCM0101.SaveChem";
                ccp.MethodName = "Save";
                ccp.ServerParams = new object[] { al };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                if (0 != ccp.ReturnCode) return;
                if ("1" != ccp.ReturnObject.ToString())
                {
                    MessageBox.Show(ccp.ReturnObject.ToString(), "警告");
                    return;
                }
             
                this.textBox1.Text = al[1].ToString();
                DoQuery();
                MessageBox.Show("修改成功");


            }
            catch(Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                MessageBox.Show("系统发生异常，请与管理员联系", "提示");
            }

        }
        private void DoDelete()
        {
            //删除
            try
            {
                if (this.UserInfo.GetUserGroup() == 0 + "")
                {
                    MessageBox.Show("常白班人员禁止对数据进行操作", "警告");
                    return;
                }
                if (this.ultraGrid1.ActiveRow.Cells.Count == 0)
                {
                    MessageBox.Show("请选择要修改的数据！");
                    return;
                }
                //选择一行数据
                UltraGridRow ugr = this.ultraGrid1.ActiveRow;
                string chemCode = ugr.Cells["CHEM_CODE"].Value.ToString();

                if (MessageBox.Show(this, "是否确认删除？", "删除", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No)
                {
                    return;
                }

                string deleteID = this.UserInfo.GetUserID();    //删除人ID
                string deleteName = this.UserInfo.GetUserName();//删除人

                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "QCM.QCM01.QCM0101.removeChem";
                ccp.MethodName = "remove";
                ccp.ServerParams = new object[] { chemCode ,deleteID,deleteName};
                this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                if ("1" != ccp.ReturnObject.ToString())
                {
                    MessageBox.Show(ccp.ReturnObject.ToString(), "警告");
                    return;
                }

                DoQuery();
                MessageBox.Show("删除成功！");

            }
            catch(Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                MessageBox.Show("系统发生异常，请与管理员联系", "提示");
            }
        }

        private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
        {
            this.textBox2.Text = this.ultraGrid1.ActiveRow.Cells["CHEM_CODE"].Value.ToString();
            this.textBox3.Text = this.ultraGrid1.ActiveRow.Cells["CHEM_NAME"].Value.ToString();
            this.textBox4.Text = this.ultraGrid1.ActiveRow.Cells["CHEM_TYPE"].Value.ToString();
            this.textBox5.Text = this.ultraGrid1.ActiveRow.Cells["CHEM_FORMULA"].Value.ToString();
            this.textBox6.Text = this.ultraGrid1.ActiveRow.Cells["MEMO"].Value.ToString();
        }

    }
}