?using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;

namespace MyFirstSDbAnyWhereDemo
{
    public partial class Form1 : Form
    {
        //聲明公共類
        //聲明連接遠程服務器的類
        public static SDbAnyWhere.SDbAnyWhereConnection RemoteCon;
        //聲明和服務器方法進行數(shù)據(jù)交互的類
        public static SDbAnyWhere.SDbAnyWhereDataClient DataClient; 
        public Form1()
        {
            InitializeComponent();
            //創(chuàng)建連接類
            RemoteCon = new SDbAnyWhere.SDbAnyWhereConnection();
            //創(chuàng)建數(shù)據(jù)交互,方法調(diào)用類
            DataClient = new SDbAnyWhere.SDbAnyWhereDataClient();
            //設置連接類的連接IP地址
            RemoteCon.RemoteIp = "192.168.1.66";
            //設置連接類的連接端口(這里是TCP端口)
            RemoteCon.RemotePort = 88;
            //設置連接類的連接方式[True是保持連接,False是每次和服務器交互的時候都要進行連接,執(zhí)行完畢方法方會后斷開]
            RemoteCon.KeepConnection = true;
            //設置方法調(diào)用類的連接類
            DataClient.RemoteConnection = RemoteCon;
        }

        private void button1_Click(object sender, EventArgs e)
        {
            //判斷是否錄入了學員編號
            if(textBox1.ToString().Length==0)
            {
                MessageBox.Show("學員編號不能夠為空！");
                textBox1.Focus();
                return;
            }
            //清除參數(shù)
            DataClient.ClearParamters();
            //設置調(diào)用模塊名
            DataClient.ModuleName = "DataSelect";
            //設置調(diào)用函數(shù)名
            DataClient.FunctionName = "SelectCode";
            //設置該函數(shù)所需要的參數(shù)
            DataClient.SetParameter("Stu_Code", this.textBox1.Text);           
            try
            {
                //執(zhí)行調(diào)用
                DataClient.Execute();
            }
            catch (Exception pe)
            {                
                MessageBox.Show(pe.Message);
            }
            if (DataClient.ExecSuccess)
            {
                //判斷是否查詢到信息
                String Stu_Code;
                DataClient.GetParameter("Stu_Code", out Stu_Code);
                if (Stu_Code == "")
                {
                    MessageBox.Show("不存在編號為："+this.textBox1.Text+" 的學員。");
                    this.textBox1.Focus();
                    return;
                }
                //調(diào)用成功，顯示查詢到的學員數(shù)據(jù)
                //創(chuàng)建Form2實例
                Form2 fm=new Form2();
                //顯示學員編號
                fm.textBox1.Text = this.textBox1.Text;
                //聲明變量，為的是從DataClient中獲取查詢的數(shù)據(jù)
                String Stu_Info;
                //獲取學員姓名
                DataClient.GetParameter("Stu_Name",out Stu_Info);
                //顯示學員姓名
                fm.textBox2.Text = Stu_Info;

                //獲取學員性別
                DataClient.GetParameter("Stu_Sex", out Stu_Info);
                //顯示學員性別
                fm.textBox3.Text = Stu_Info;

                //獲取學員年齡
                DataClient.GetParameter("Stu_Age", out Stu_Info);
                //顯示學員年齡
                fm.textBox4.Text = Stu_Info;

                //獲取學員地址
                DataClient.GetParameter("Stu_Address", out Stu_Info);
                //顯示學員地址
                fm.textBox5.Text = Stu_Info;

                //獲取學員電話
                DataClient.GetParameter("Stu_Phone", out Stu_Info);
                //顯示學員電話
                fm.textBox6.Text = Stu_Info;

                //獲取學員Email
                DataClient.GetParameter("Stu_Email", out Stu_Info);
                //顯示學員Email
                fm.textBox7.Text = Stu_Info;
                //顯示窗口
                fm.ShowDialog();
            }
            else
            {
                //調(diào)用失敗，顯示失敗信息
                MessageBox.Show("查詢失敗："+DataClient.ExecResultText);
            }
        }

        private void button2_Click(object sender, EventArgs e)
        {
            //判斷是否錄入了學員姓名
            if (textBox2.ToString().Length == 0)
            {
                MessageBox.Show("學員姓名不能夠為空！");
                textBox1.Focus();
                return;
            }
            //清除參數(shù)
            DataClient.ClearParamters();
            //設置調(diào)用模塊名
            DataClient.ModuleName = "DataSelect";
            //設置調(diào)用函數(shù)名
            DataClient.FunctionName = "SelectName";
            //設置該函數(shù)所需要的參數(shù)
            DataClient.SetParameter("Stu_Name", this.textBox2.Text);
            try
            {
                //執(zhí)行調(diào)用
                DataClient.Execute();
            }
            catch (Exception pe)
            {
                MessageBox.Show(pe.Message);
            }
            if (DataClient.ExecSuccess)
            {
                //判斷是否查詢到信息
                String Stu_Code;
                DataClient.GetParameter("Stu_Code", out Stu_Code);
                if (Stu_Code == "")
                {
                    MessageBox.Show("不存在姓名為：" + this.textBox2.Text + " 的學員。");
                    this.textBox2.Focus();
                    return;
                }
                //調(diào)用成功，顯示查詢到的學員數(shù)據(jù)
                //創(chuàng)建Form2實例
                Form2 fm = new Form2();
                //顯示學員編號
                fm.textBox1.Text = Stu_Code; ;
                //聲明變量，為的是從DataClient中獲取查詢的數(shù)據(jù)
                String Stu_Info;
                //獲取學員姓名
                DataClient.GetParameter("Stu_Name", out Stu_Info);
                //顯示學員姓名
                fm.textBox2.Text = Stu_Info;

                //獲取學員性別
                DataClient.GetParameter("Stu_Sex", out Stu_Info);
                //顯示學員性別
                fm.textBox3.Text = Stu_Info;

                //獲取學員年齡
                DataClient.GetParameter("Stu_Age", out Stu_Info);
                //顯示學員年齡
                fm.textBox4.Text = Stu_Info;

                //獲取學員地址
                DataClient.GetParameter("Stu_Address", out Stu_Info);
                //顯示學員地址
                fm.textBox5.Text = Stu_Info;

                //獲取學員電話
                DataClient.GetParameter("Stu_Phone", out Stu_Info);
                //顯示學員電話
                fm.textBox6.Text = Stu_Info;

                //獲取學員Email
                DataClient.GetParameter("Stu_Email", out Stu_Info);
                //顯示學員Email
                fm.textBox7.Text = Stu_Info;
                //顯示窗口
                fm.ShowDialog();
            }
            else
            {
                //調(diào)用失敗，顯示失敗信息
                MessageBox.Show("查詢失敗：" + DataClient.ExecResultText);
            }
        }

        private void menuItem1_Click(object sender, EventArgs e)
        {
            if (MessageBox.Show("確定要關(guān)閉測試程序嗎？", "關(guān)閉提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes)
            {
                Application.Exit();
            }            
        }
    }
}