form1.cs

SDbAnyWhere开发框架快速入门For C# .Net

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;
        //声明和服务器方法进行数据交互的类
        public static SDbAnyWhere.SDbAnyWhereDataClient DataClient; 
        public Form1()
        {
            InitializeComponent();
            //创建连接类
            RemoteCon = new SDbAnyWhere.SDbAnyWhereConnection();
            //创建数据交互,方法调用类
            DataClient = new SDbAnyWhere.SDbAnyWhereDataClient();
            //设置连接类的连接IP地址
            RemoteCon.RemoteIp = "192.168.1.66";
            //设置连接类的连接端口(这里是TCP端口)
            RemoteCon.RemotePort = 88;
            //设置连接类的连接方式[True是保持连接,False是每次和服务器交互的时候都要进行连接,执行完毕方法方会后断开]
            RemoteCon.KeepConnection = true;
            //设置方法调用类的连接类
            DataClient.RemoteConnection = RemoteCon;
        }

        private void button1_Click(object sender, EventArgs e)
        {
            //判断是否录入了学员编号
            if(textBox1.ToString().Length==0)
            {
                MessageBox.Show("学员编号不能够为空！");
                textBox1.Focus();
                return;
            }
            //清除参数
            DataClient.ClearParamters();
            //设置调用模块名
            DataClient.ModuleName = "DataSelect";
            //设置调用函数名
            DataClient.FunctionName = "SelectCode";
            //设置该函数所需要的参数
            DataClient.SetParameter("Stu_Code", this.textBox1.Text);           
            try
            {
                //执行调用
                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;
                }
                //调用成功，显示查询到的学员数据
                //创建Form2实例
                Form2 fm=new Form2();
                //显示学员编号
                fm.textBox1.Text = this.textBox1.Text;
                //声明变量，为的是从DataClient中获取查询的数据
                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
            {
                //调用失败，显示失败信息
                MessageBox.Show("查询失败："+DataClient.ExecResultText);
            }
        }

        private void button2_Click(object sender, EventArgs e)
        {
            //判断是否录入了学员姓名
            if (textBox2.ToString().Length == 0)
            {
                MessageBox.Show("学员姓名不能够为空！");
                textBox1.Focus();
                return;
            }
            //清除参数
            DataClient.ClearParamters();
            //设置调用模块名
            DataClient.ModuleName = "DataSelect";
            //设置调用函数名
            DataClient.FunctionName = "SelectName";
            //设置该函数所需要的参数
            DataClient.SetParameter("Stu_Name", this.textBox2.Text);
            try
            {
                //执行调用
                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;
                }
                //调用成功，显示查询到的学员数据
                //创建Form2实例
                Form2 fm = new Form2();
                //显示学员编号
                fm.textBox1.Text = Stu_Code; ;
                //声明变量，为的是从DataClient中获取查询的数据
                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
            {
                //调用失败，显示失败信息
                MessageBox.Show("查询失败：" + DataClient.ExecResultText);
            }
        }

        private void menuItem1_Click(object sender, EventArgs e)
        {
            if (MessageBox.Show("确定要关闭测试程序吗？", "关闭提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes)
            {
                Application.Exit();
            }            
        }
    }
}