XinYu_LZMES_Client/Core.LZMes.Client.UIB/B01/UIB010303.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using Infragistics.Win.UltraWinGrid;
using System.Collections;
using System.Windows.Forms;
using CoreFS.CA06;

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

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

        public void DoQuery()
        {
            try
            {
                this.dataSet1.Tables[0].Clear();

                ArrayList al = new ArrayList();
                al.Add("UIB010303_01.INITSELECT");
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "UIB.COM.ComDBQuery";
                ccp.MethodName = "doSimpleQuery";
                ccp.ServerParams = new object[] { al };
                ccp.SourceDataTable = this.dataSet1.Tables[0];
                this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
            }catch(Exception ex)
            {
            }
        }

        public void DoSave()
        {
            try
            {
                if (MessageBox.Show("确定保存？", "提示", MessageBoxButtons.OKCancel) == DialogResult.Cancel)
                    return;
                ArrayList al = new ArrayList();
                ArrayList list = null;
                foreach (UltraGridRow ugr in this.ultraGrid1.Rows)
                {
                    if (ugr.Cells["CHK"].Text == "True")
                    {
                        list = new ArrayList();
                        if (ugr.Cells["EXTSHAPE_CD_1"].Text == "")//插入
                        {
                            list.Add("UIB010303_01.INSERT");
                            list.Add(ugr.Cells["EXTSHAPE_CD"].Text.ToString());
                            list.Add(ugr.Cells["MIAN_DESC"].Text.ToString());
                            list.Add(ugr.Cells["CE_DESC"].Text.ToString());
                            list.Add(ugr.Cells["TOU_DESC"].Text.ToString());
                            list.Add(ugr.Cells["DAXIAO_DESC"].Text.ToString());
                            list.Add(ugr.Cells["DUOSHAO_DESC"].Text.ToString());
                            list.Add(ugr.Cells["SHOUGAN_DESC"].Text.ToString());
                            list.Add(ugr.Cells["SHIJUE_DESC"].Text.ToString());
                            list.Add(ugr.Cells["QITA_DESC"].Text.ToString());
                            list.Add(ugr.Cells["RMK_DESC"].Text.ToString());
                            list.Add(this.UserInfo.GetUserName());
                        }
                        else//更新
                        {
                            list.Add("UIB010303_01.UPDATE");
                            list.Add(ugr.Cells["EXTSHAPE_CD"].Text.ToString());
                            list.Add(ugr.Cells["MIAN_DESC"].Text.ToString());
                            list.Add(ugr.Cells["CE_DESC"].Text.ToString());
                            list.Add(ugr.Cells["TOU_DESC"].Text.ToString());
                            list.Add(ugr.Cells["DAXIAO_DESC"].Text.ToString());
                            list.Add(ugr.Cells["DUOSHAO_DESC"].Text.ToString());
                            list.Add(ugr.Cells["SHOUGAN_DESC"].Text.ToString());
                            list.Add(ugr.Cells["SHIJUE_DESC"].Text.ToString());
                            list.Add(ugr.Cells["QITA_DESC"].Text.ToString());
                            list.Add(ugr.Cells["RMK_DESC"].Text.ToString());
                            list.Add(this.UserInfo.GetUserName());
                            list.Add(ugr.Cells["EXTSHAPE_CD_1"].Text.ToString());
                        }
                        al.Add(list);
                    }
                }
                if (al.Count == 0) return;
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "UIB.COM.ComDBSave";
                ccp.MethodName = "doXmlSave";
                ccp.ServerParams = new object[] { al };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                this.DoQuery();
            }
            catch (Exception ex)
            {
            }
        }

        public void DoDelete()
        {
            try
            {
                if (MessageBox.Show("确定删除？", "提示", MessageBoxButtons.OKCancel) == DialogResult.Cancel)
                    return;
                ArrayList al = new ArrayList();
                ArrayList list = null;
                foreach (UltraGridRow ugr in this.ultraGrid1.Rows)
                {
                    if (ugr.Cells["CHK"].Text == "True")
                    {
                        list = new ArrayList();
                        list.Add("UIB010303_01.DELETE");
                        list.Add(ugr.Cells["EXTSHAPE_CD_1"].Text.ToString());
                        al.Add(list);
                    }
                }

                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "UIB.COM.ComDBSave";
                ccp.MethodName = "doXmlSave";
                ccp.ServerParams = new object[] { al };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                this.DoQuery();
            }
            catch (Exception ex)
            {
            }
        }
    }
}