XinYu_LZMES_Client/Core.LZMes.Client.UIB/B01/UIB010370.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 Infragistics.Win.UltraWinGrid;
using CoreFS.CA06;
using System.Collections;

namespace Core.LZMes.Client.UIB
{
    public partial class UIB010370 : FrmBase
    {
        public UIB010370()
        {
            InitializeComponent();
        }
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    this.DoQuery();
                    break;
                case "Save":
                    this.DoSave();
                    break;

            }
        }

        private void DoQuery()
        {
            this.dataSet1.Tables[0].Clear();
            ArrayList list = new ArrayList();
            list.Add("UIB030370_01.SELECT");

            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "UIB.COM.ComDBQuery";
            ccp.MethodName = "doSimpleQuery";
            ccp.ServerParams = new object[] { list };
            ccp.SourceDataTable = this.dataSet1.Tables[0];
            this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
            Console.WriteLine(this.dataSet1.Tables[0].ToString());

        }

        private void DoSave()
        {
            try
            {
                string ord_no = string.Empty;
                string ord_seq = string.Empty;
                string stl = string.Empty;
                string thk = string.Empty;
                string wth = string.Empty;
                string regID= this.UserInfo.GetUserName(); ;

                Hashtable paramHsmp = new Hashtable();
               this.ultraGrid1.UpdateData();
                      
               Infragistics.Win.UltraWinGrid.RowsCollection rs = this.ultraGrid1.Rows;
                        if (rs.Count > 0)
                        {
                            for (int i = 0; i < rs.Count; i++)
                            {
                                if (rs[i].Cells["CHK"].Text.Trim() == "FALSE")
                                {
                                    continue;
                                }
                                else
                                {
                                    paramHsmp = new Hashtable();
                                    ord_no = rs[i].Cells["ORD_NO"].Text;
                                    ord_seq = rs[i].Cells["ORD_SEQ"].Text;
                                    stl = rs[i].Cells["C_SPEC_STL_GRD"].Text;
                                    thk = rs[i].Cells["C_ORD_THK"].Text;
                                    wth = rs[i].Cells["C_ORD_WTH"].Text;
                                    

                                    paramHsmp.Add("i1", ord_no);
                                    paramHsmp.Add("i2", ord_seq);
                                    paramHsmp.Add("i3", stl);
                                    paramHsmp.Add("i4", thk);
                                    paramHsmp.Add("i5", wth);
                                    paramHsmp.Add("i6", regID);
                                    paramHsmp.Add("o7", "");

                                    CoreClientParam ccp = new CoreClientParam();
                                    ccp.ServerName = "UIB.COM.ComDBProcedure";
                                    ccp.MethodName = "doXmlProcedure";
                                    ccp.ServerParams = new Object[] { "UIB010370_01.CALL", paramHsmp };
                                    this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                                    //提示
                                    //ArrayList all = ccp.ReturnObject as ArrayList;
                                    //if (all[0].ToString() != "YY")//确认是否存在问题
                                    //{
                                    //    MessageBox.Show(all[0].ToString(), "提示");
                                    //    return;
                                    //}

                                }

                            }
                        this.DoQuery();
    
                }

            }
            catch (Exception Ey)
            {
                MessageBox.Show(Ey.ToString());
            }

        }

    }
}