结课作业-副本

1、Hebei Normal University of Science & Technology专业：信息管理与信息系统13 学号： 08111301 信息系统开发工具结课作业 题 目： 网上支付通 院（系、部）：工商管理学院信息管理与信息系统 学 生 姓 名： 指 导 教 师： 2015年 12月 31日 网上支付通使用说明书1. 项目功能介绍： 根据本学期信息系统开发工具课程结课要求，我设计实现了一个网上支付通客户端。本系统主要实现以下目标： (1)系统采用人机交互的方式，界面美观友好，信息查询灵活、方便，数据存储安全可靠。(2)申请账号，客户申请个人账号进行登录。(3)登陆账号，根据申请账

2、号填写的信息进行登录。(4)充值，用户给个人账户进行充值。(5)好友转账，填写好友的账号信息进行转账。 (6)注销，用户在账户余额未零的时候可以进行注销删除自己的账号信息。 （7）查询，可以查询此账号进行的所有操作。2、 主窗体设计 本应用程序共包含申请账号窗体、账号登陆窗体、操作主窗体、充值提现窗体、查询窗体、转账窗体的设计。2.1申请账号窗体登录窗体的界面设计如图2.1所示。图2.1 申请账号界面该窗体所用控件及其所用属性：(1) Label控件：Name、Text、BackColor；(2) Textbox 控件：Name、Text；(3) Button控件：Name；(4) From控

3、件：Name、StartPosition（CenterScreen）、BackgroundImage、BackColor。2.2账号登陆窗体账号登陆窗体的界面设计如图2.2所示。图2.2 登陆界面该窗体所用控件及其所用属性：(1) Button控件：Name、BackColor；(2) Groupbox控件：Size、Name、BackColor；(3) Textbox 控件：Name、Text；(4) From窗体：Name、Text、StartPosition（CenterScreen）、BackgroundImage。2.3操作窗体操作窗体界面设计如图2.3所示。图2.3 操作窗体界面该

4、窗体所用控件及其所用属性：(1) Button控件：Name、Text；(2) Label控件：Name、Text、BackColor；(3) Groupbox控件：Size、Name、BackColor；(4) From控件：Name、Text、StartPosition（CenterScreen）、BackgroundImage。2.4充值提现窗体充值提现的界面设计如图2.4所示。图2.41 充值界面图2.42 提现界面该窗体所用控件及其所用属性：(1) Button控件：Name、Size、StartPosition、Text；(2) Text控件：Name、Enabled、Lines、

5、Location、Size、TabIndex。；(3) Label控件：Name、Location、Size、TabIndex、Text；(4) From控件：Name、AutoScaleMode、FormBorderStyle、Icon、Size、StartPositon、Text2.5查询窗体查询窗体的界面设计如图2.5所示。图2.5 查询界面该窗体所用控件及其所用属性：(1) Button控件：Name、Location、Size、TabIndex、Text、UseVisualStyleBackColor；(2) Form控件：Name、AutoScaleMode、Size、StartP

6、osition、StartPosition、Text；(3) Label控件：Name、AutoSize、Location、Size、TabIndex、Text；(4) TextBox控件：Name、Lines、Location、Size、TabIndex。(5) ComboBox控件：Name、FormattingEnabled、Items、Location、Size、TabIndex；(6) DategridView控件：Name、AutoScaleMode、Size2.6转账窗体转账窗体的界面设计如图2.6所示。图2.6 转账窗体界面该窗体所用控件及其所用属性：(1) Button控件：

7、Name、Location、Size、TabIndex、Text；(2) From控件：Name、Font、Icon、Size、StartPosition、Text；(3) Label控件：Name、AutoSize、Location、Size、TabIndex、Text；(4) TextBox控件：Name、Enabled。3、 数据库设计3.1账号管理表如图3.1所示：表3.1 dbo_banktable3.2查询表如图3.2所示：表3.2 dbo_SelectMoney4、 核心功能代码4.1申请账号： private void button2_Click(object sender,

8、System.EventArgs e)/取消 this.Close(); private void button1_Click(object sender, System.EventArgs e)/确定 if (this.textBox1.Text.Equals()=false & this.textBox2.Text.Equals()=false) Dao dao = new Dao(); if (dao.YNadd(this.textBox1.Text) Bean bean = new Bean(); bean.accounts = textBox1.Text; bean.pass = t

9、extBox2.Text; = textBox3.Text; bean.card = textBox4.Text; bean.money = float.Parse(textBox5.Text); bool boo = dao.Adduesr(bean); if (boo) MessageBox.Show(申请成功|rn您的账号?: + bean.accounts） this.Close(); else MessageBox.Show(此帐号已存在！?); else MessageBox.Show(不能为空?！?); private void Form2_Load(obje

10、ct sender, System.EventArgs e) this.timer1.Start(); private void textBox4_KeyPress(object sender, System.Windows.Forms.KeyPressEventArgs e) e.Handled=e.KeyChar9; if(e.KeyChar=(char)8) e.Handled=false; private void textBox5_KeyPress(object sender, System.Windows.Forms.KeyPressEventArgs e) e.Handled=e

11、.KeyChar9; if(e.KeyChar=(char)8) e.Handled=false; private void timer1_Tick(object sender, EventArgs e) Dao bao = new Dao(); bao.timer = this.timer1; bao.ff = this; bao.change(); 4.2登陆static void Main() Application.Run(new Form1();private void button3_Click(object sender, System.EventArgs e)/申请Form2

12、form2=new Form2();form2.ShowDialog();this.textBox1.Text=;this.textBox2.Text=;private void button6_Click(object sender, System.EventArgs e)/登录string name=this.textBox1.Text;string pass=this.textBox2.Text;Dao dao=new Dao();bool boo=dao.GetEnter(name,pass);if(boo)groupBox2.Visible=true;label6.Text=name

13、;label4.Text=dao.GetMoney(name).ToString();groupBox2.Text=name+ 欢?迎您?;button1.Enabled=true;button5.Enabled=true;button4.Enabled=true;button2.Enabled=true; button9.Enabled = true;button3.Enabled=false;elseMessageBox.Show(密码或用户名错误);this.textBox2.Text=;private void button7_Click(object sender, System.E

14、ventArgs e)/清?空?this.textBox1.Text=;this.textBox2.Text=;private void button8_Click(object sender, System.EventArgs e)/退出groupBox2.Visible=false;this.textBox1.Text=;this.textBox2.Text=;button1.Enabled=false;button5.Enabled=false;button4.Enabled=false;button2.Enabled=false;button3.Enabled=true; button

15、9.Enabled = false;4.3操作 private void button5_Click(object sender, System.EventArgs e)/销户if(this.label4.Text.Equals(0)string name=label6.Text;Dao dao=new Dao();if(MessageBox.Show(确?定要癮销户吗e？?,销户,MessageBoxButtons.YesNo,MessageBoxIcon.Warning).ToString()=Yes)bool boo=dao.delete(name);if(boo)groupBox2.V

16、isible=false;this.textBox1.Text=;this.textBox2.Text=;button1.Enabled=false;button5.Enabled=false;button4.Enabled=false;button2.Enabled=false;button3.Enabled=true;elseMessageBox.Show(账号余额为才能销户); private void Form1_Load(object sender, System.EventArgs e) timer.Start(); private void Form1_Closed(object

17、 sender, System.EventArgs e)Thread.CurrentThread.Abort();private void showMe(object sender, System.EventArgs e)Dao dao=new Dao();label4.Text=dao.GetMoney(this.label6.Text).ToString();private void button4_Click(object sender, System.EventArgs e)/存款Form3 form3=new Form3(this.label6.Text);form3.Closed

18、+= new System.EventHandler(this.showMe);form3.ShowDialog();private void button2_Click(object sender, System.EventArgs e)/取款Form4 form4=new Form4(this.label6.Text);form4.Closed +=new System.EventHandler(this.showMe);form4.ShowDialog(); private void timer_Tick(object sender, EventArgs e) Dao bao = new

19、 Dao(); bao.timer = this.timer; bao.ff = this; bao.change(); private void button1_Click(object sender, EventArgs e)/查询 Form5 form5 = new Form5(this.label6.Text); form5.ShowDialog(); private void button9_Click(object sender, EventArgs e)/转羇帐 Form6 form6 = new Form6(this.label6.Text); form6.Closed +=

20、new System.EventHandler(this.showMe); form6.ShowDialog(); private void Form1_MouseDown(object sender, MouseEventArgs e)/得到窗体坐 if(e.Button=MouseButtons.Left) po = new Point(-e.X,-e.Y); this.boo = true; private void Form1_MouseMove(object sender, MouseEventArgs e)/Mouse 经过窗体 if(boo) Point poo = Contro

21、l.MousePosition; poo.Offset(this.po.X,this.po.Y); this.Location = poo; private void Form1_MouseUp(object sender, MouseEventArgs e) this.boo = false; 4.4充值提现4.41充值protected override void Dispose( bool disposing )if( disposing )if(components != null)components.Dispose();base.Dispose( disposing );priva

22、te void button1_Click(object sender, System.EventArgs e)/确?定Dao dao=new Dao();float flo=float.Parse(this.textBox1.Text);bool boo=dao.update(this.la,flo);if(boo) dao.AddSelect(la,flo); MessageBox.Show(您充?入?了? +this.textBox1.Text+ 元a);this.Close(); private void textBox1_KeyPress(object sender, System.

23、Windows.Forms.KeyPressEventArgs e) e.Handled = e.KeyChar 9; if (e.KeyChar = (char)8) e.Handled = false; private void button2_Click(object sender, EventArgs e)/取?消? this.Close(); 4.42提现protected override void Dispose( bool disposing )if( disposing )if(components != null)components.Dispose();base.Disp

24、ose( disposing );private void button1_Click(object sender, System.EventArgs e)/确定Dao dao=new Dao();if(dao.GetMoney(name)float.Parse(this.textBox1.Text)MessageBox.Show(余额不足！?);elsefloat flo=float.Parse(this.textBox1.Text);bool boo=dao.updatee(,flo);if(boo) dao.AddSelect1(name,flo); MessageBo

25、x.Show(您提现?+this.textBox1.Text+元a);this.Close();private void textBox1_KeyPress(object sender, System.Windows.Forms.KeyPressEventArgs e)/建盘输入事件e.Handled=e.KeyChar9;if(e.KeyChar=(char)8)e.Handled=false; private void button2_Click(object sender, EventArgs e)/取?消? this.Close(); 4.5操作查询 public partial cl

26、ass Form5 : Form Dao dao = new Dao(); private string _name; SqlConnection con; SqlDataAdapter Ada; DataSet dst; SqlParameter par = new SqlParameter(); public Form5(string name) InitializeComponent(); this._name = name; private void Form5_Load(object sender, EventArgs e) ArrayList lis = dao.SelectYea

27、r(this._name); foreach(int ss in lis) boBox1.Items.Add(ss); this.label4.Text = this._name; private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) this.button1.Enabled = false; this.label4.Text = this._name; ArrayList liss = new ArrayList(); liss = dao.SelectMonth(this._name,int.Pars

28、e(boBox1.Text); boBox2.Items.Clear(); foreach(int oo in liss) boBox2.Items.Add(oo); boBox2.Enabled = true; private void button1_Click(object sender, EventArgs e)/查询 Dao dao=new Dao(); this.con = dao.getCon(); dst = new DataSet(); this.Ada = new SqlDataAdapter(Select fetchMoney as 取款金额,depositMoney a

29、s 存款金额,TransferName as 转帐帐户,TransferMoney as 转帐金额 from SelectMoney where uname= + this.label4.Text + and timeYear= + boBox1.Text + and timeDiana= + boBox2.Text + and timeDay= + boBox3.Text + , con); this.Ada.Fill(this.dst, SelectMoney); this.dataGridView1.DataSource = this.dst.Tables0.DefaultView; p

30、rivate void button3_Click(object sender, EventArgs e)/退出 this.Close(); private void comboBox2_SelectedIndexChanged(object sender, EventArgs e)/选择月 Dao dao = new Dao(); ArrayList list = new ArrayList(); list = dao.SelectDay(this.label4.Text,int.Parse(boBox1.Text),int.Parse(boBox2.Text); boBox3.Items.

31、Clear(); foreach(int oo in list) boBox3.Items.Add(oo); boBox3.Enabled = true; private void comboBox3_SelectedIndexChanged(object sender, EventArgs e)/选择日 if (boBox1.Text.Equals() | boBox2.Text.Equals() | boBox3.Text.Equals() this.button1.Enabled = false; else this.button1.Enabled = true; 4.6转账 publi

32、c partial class Form6 : Form string _name; public Form6(string name) InitializeComponent(); this._name = name; private void Form6_Load(object sender, EventArgs e) textBox3.Text = this._name; Dao dao=new Dao(); this.textBox4.Text = dao.GetMoney(this._name).ToString(); private void textBox2_KeyPress(o

33、bject sender, KeyPressEventArgs e) e.Handled = e.KeyChar 9; if (e.KeyChar = (char)8) e.Handled = false; private void button2_Click(object sender, EventArgs e)/确定 Dao dao=new Dao(); if (dao.BoolName(this.textBox1.Text) float foo= dao.GetMoney(this.textBox3.Text); if(foofloat.Parse(this.textBox2.Text)

34、 MessageBox.Show(您的余额不足转帐金额); return; bool boo=dao.TransferMoney(this.textBox3.Text,this.textBox1.Text,float.Parse(this.textBox2.Text); if(boo) dao.AddTransfer(this.textBox3.Text,this.textBox1.Text,float.Parse(this.textBox2.Text); MessageBox.Show(转帐成功|); this.Close(); else MessageBox.Show(转帐户名有误); private void button3_Click(object sender, EventArgs e)/取消 this.Close(); 5、运行结果5.1申请账号：(1)点击运行后，点击申