XinYu_LZMES_Client/Core.LZMes.Client.QCM/QCM01/QCM0103.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 QCM0103 : FrmBase
    {
        public QCM0103()
        {
            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
            {
                this.dataSet1.Tables[0].Clear();
                string tolName = this.textBox1.Text.Trim(); //公差项目描述

                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "QCM.QCM01.QCM0103.QueryTol";
                ccp.MethodName = "Query";
                ccp.ServerParams = new object[] { tolName };
                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 (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.UserInfo.GetUserID());    //创建人ID
                al.Add(this.UserInfo.GetUserName());    //创建人

                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "QCM.QCM01.QCM0103.addTol";
                ccp.MethodName = "add";
                ccp.ServerParams = new object[] { al };
                this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
               // if (0 != ccp.ReturnCode) return;
                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 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 tolName = ugr.Cells["TOL_CODE"].Value.ToString();

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

                ArrayList al = new ArrayList();
                
                al.Add(this.textBox3.Text.Trim()); //公差项目描述
                al.Add(this.textBox4.Text.Trim()); //缺陷分类描述
                al.Add(this.textBox5.Text.Trim());    //备注
                al.Add(this.UserInfo.GetUserID());    //修改人ID
                al.Add(this.UserInfo.GetUserName());    //修改人
                al.Add(tolName); //公差项目代码

                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "QCM.QCM01.QCM0103.SaveTol";
                ccp.MethodName = "Save";
                ccp.ServerParams = new object[] { al };
                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[0].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 tolName = ugr.Cells["TOL_CODE"].Value.ToString();

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

                ArrayList al = new ArrayList();
                al.Add(tolName);    //公差项目代码
                al.Add(this.UserInfo.GetUserID());    //删除人ID
                al.Add(this.UserInfo.GetUserName());//删除人

                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "QCM.QCM01.QCM0103.removeTol";
                ccp.MethodName = "remove";
                ccp.ServerParams = new object[] { al };
                this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);


                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["TOL_CODE"].Value.ToString();
            this.textBox3.Text = this.ultraGrid1.ActiveRow.Cells["TOL_NAME"].Value.ToString();
            this.textBox4.Text = this.ultraGrid1.ActiveRow.Cells["DEFECT_TYPE_DESC"].Value.ToString();
            this.textBox5.Text = this.ultraGrid1.ActiveRow.Cells["MEMO"].Value.ToString();
            
        }
    }
}