XinYu_LZMES_Client/.svn/pristine/30/304c0a211a7a9948d90268fa1b1bb56f9722d77e.svn-base

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.UIB
{
    public partial class UIB100101 : FrmBase
    {
        public UIB100101()
        {
            InitializeComponent();
        }

        string msQltyCD = null;
        string msDataCD = null;
        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("UIB100101_01.SELECT");
                al.Add(this.comboBox1.SelectedValue.ToString());

                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "UIB.JHY.JHYComQuery";
                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 (this.UserInfo.GetUserID() != "1"
                //    && this.UserInfo.GetUserID() != "zw"
                //    && this.UserInfo.GetUserID() != "lyb"
                //    && this.UserInfo.GetUserID() != "jc190") { MessageBox.Show("无修改权限！禁止修改！", "提示"); return; }

                if (MessageBox.Show("确定保存？", "提示", MessageBoxButtons.OKCancel) == DialogResult.Cancel)
                    return;
                
                ArrayList list = null;
                ArrayList al = new ArrayList();
                foreach (UltraGridRow ugr in this.ultraGrid1.Rows)
                {
                    if (ugr.Cells["CHK"].Text == "True")
                    {
                        list = new ArrayList();
                        if (ugr.Cells["QLTY_CD_2_TP"].Text != "")//更新
                        {
                            list.Add("UIB100101_01.UPDATE");
                            list.Add(ugr.Cells["QLTY_CD_2"].Value.ToString());
                            list.Add(ugr.Cells["QLTY_OPE_CD"].Text.Trim());
                            list.Add(ugr.Cells["QLTY_OPE_CFNM"].Text.Trim());
                            list.Add(ugr.Cells["COMP_CAL"].Text.Trim());
                            list.Add(ugr.Cells["QLTY_OPE_GRP"].Text.Trim());
                            list.Add(ugr.Cells["QLTY_DIS_SEQ"].Text.Trim());
                            list.Add(ugr.Cells["QLTY_DIS_LEN"].Text.Trim());
                            list.Add(ugr.Cells["CRCT_REG"].Text.Trim());
                            list.Add(ugr.Cells["OTHER_OPE_CD1"].Text.Trim());
                            list.Add(ugr.Cells["OTHER_OPE_CD2"].Text.Trim());
                            list.Add(ugr.Cells["OTHER_OPE_CD3"].Text.Trim());
                            list.Add(ugr.Cells["OTHER_OPE_CD4"].Text.Trim());
                            list.Add(ugr.Cells["MS_RMK"].Text.Trim());
                            list.Add(ugr.Cells["EDIT_TP"].Text.Trim());
                            list.Add(ugr.Cells["EDIT_TP"].Text.Trim());

                            list.Add(ugr.Cells["QLTY_CD_2_TP"].Value.ToString());
                            list.Add(ugr.Cells["QLTY_OPE_CD_TP"].Text.Trim());
                            
                        }
                            
                        else
                        {
                            list.Add("UIB100101_01.INSERT");
                            list.Add(ugr.Cells["QLTY_CD_2"].Value.ToString());
                            list.Add(ugr.Cells["QLTY_OPE_CD"].Text.Trim());
                            list.Add(ugr.Cells["QLTY_OPE_CFNM"].Text.Trim());
                            list.Add(ugr.Cells["COMP_CAL"].Text.Trim());
                            list.Add(ugr.Cells["QLTY_OPE_GRP"].Text.Trim());
                            list.Add(ugr.Cells["QLTY_DIS_SEQ"].Text.Trim());
                            list.Add(ugr.Cells["QLTY_DIS_LEN"].Text.Trim());
                            list.Add(ugr.Cells["CRCT_REG"].Text.Trim());
                            list.Add(ugr.Cells["OTHER_OPE_CD1"].Text.Trim());
                            list.Add(ugr.Cells["OTHER_OPE_CD2"].Text.Trim());
                            list.Add(ugr.Cells["OTHER_OPE_CD3"].Text.Trim());
                            list.Add(ugr.Cells["OTHER_OPE_CD4"].Text.Trim());
                            list.Add(ugr.Cells["MS_RMK"].Text.Trim());
                            list.Add(ugr.Cells["EDIT_TP"].Text.Trim());
                        }
                        al.Add(list);
                        if (al.Count == 0) return;
                        CoreClientParam ccp = new CoreClientParam();
                        ccp.ServerName = "UIB.JHY.JHYComSave";
                        ccp.MethodName = "doSimpleSave";
                        ccp.ServerParams = new object[] { al };
                        ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);        
                    }
                }
                this.DoQuery();
            }
            catch (Exception ex)
            {
                MessageBox.Show("操作异常" , "提示");
            }
            ;
        }

        public void DoDelete()
        {
            //if (this.UserInfo.GetUserID() != "1"
            //        && this.UserInfo.GetUserID() != "zw"
            //        && this.UserInfo.GetUserID() != "lyb"
            //        && this.UserInfo.GetUserID() != "jc190") { MessageBox.Show("无修改权限！禁止修改！", "提示"); return; }

            try
            {
                if (MessageBox.Show("确定删除？", "提示", MessageBoxButtons.OKCancel) == DialogResult.Cancel)
                    return;
                ArrayList al = new ArrayList();
                foreach (UltraGridRow ugr in this.ultraGrid1.Rows)
                {
                    if (ugr.Cells["CHK"].Text == "True")
                    {
                        ArrayList list = new ArrayList();
                        list.Add("UIB100101_01.DELETE");
                        list.Add(ugr.Cells["QLTY_CD_2"].Value.ToString());
                        list.Add(ugr.Cells["QLTY_OPE_CD"].Text.Trim());
                        al.Add(list);
                    }
                }
                if (al.Count == 0) return;
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "UIB.JHY.JHYComSave";
                ccp.MethodName = "doSimpleSave";
                ccp.ServerParams = new object[] { al };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                this.DoQuery();
            }
            catch (Exception ex)
            {
                MessageBox.Show("操作异常" , "提示");
            }
        }

        public void PageInit()
        {
            try
            {
                ArrayList alt = new ArrayList();
                alt.Add("UIB100101_01.INITSELECT");

                this.dataSet1.Tables[1].Clear();
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "UIB.JHY.JHYComQuery";
                ccp.MethodName = "doSimpleQuery";
                ccp.ServerParams = new object[] { alt };
                ccp.SourceDataTable = this.dataSet1.Tables[1];
                this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
            }
        }

        private void ultraGrid1_MouseDown(object sender, MouseEventArgs e)
        {

        }

        private void UIB100101_Load(object sender, EventArgs e)
        {
            PageInit();
            this.ultraCombo1.Text = "ALL";
        }

    }
}