XinYu_LZMES_Client/Core.LZMes.Client.QCM/QCM01/QCM0104.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 QCM0104 : FrmBase
    {
        public QCM0104()
        {
            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 deteName = this.textBox1.Text.Trim(); //探伤项目描述

                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "QCM.QCM01.QCM0104.QueryDete";
                ccp.MethodName = "Query";
                ccp.ServerParams = new object[] { deteName };
                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.QCM0104.addDete";
                ccp.MethodName = "add";
                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());
            }

        }

        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 deteName = ugr.Cells["DETECTION_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(deteName);      //探伤代码


                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "QCM.QCM01.QCM0104.SaveDete";
                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[0].ToString();
                DoQuery();
                MessageBox.Show("修改成功！");
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
            }
        }

        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 deteName = ugr.Cells["DETECTION_CODE"].Value.ToString();

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


                ArrayList al = new ArrayList();
                al.Add(deteName);    //探伤代码
                al.Add(this.UserInfo.GetUserID());    //删除人ID
                al.Add(this.UserInfo.GetUserName());//删除人

                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "QCM.QCM01.QCM0104.removeDete";
                ccp.MethodName = "remove";
                ccp.ServerParams = new object[] { al };
                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());
            }
        }

        private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
        {
            this.textBox2.Text = this.ultraGrid1.ActiveRow.Cells["DETECTION_CODE"].Value.ToString();
            this.textBox3.Text = this.ultraGrid1.ActiveRow.Cells["DETECTION_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();

        }
    }
}