C#课程设计—自动取款机模拟软件设计(3)

decimal jine = Convert.ToDecimal(dr[2]); string wo = Convert.ToString(dr[1]);

decimal sqje = Convert.ToDecimal(maskedTextBox1.Text); dr.Close(); if (jine > sqje) {

MessageBox.Show("正在操作，请稍侯……"); decimal leftmoney = jine - sqje;

string ssql = "Update userinfo set yue = '" + leftmoney + "' where yonghu ='" + Form1.lockID + "'";

SqlCommand ccmd = new SqlCommand(ssql, conn);

int i = ccmd.ExecuteNonQuery(); if (i == 1) {

string sqql = "select * from userinfo where yonghu='" + maskedTextBox2.Text.Trim() + "'";

SqlCommand cmdd = new SqlCommand(sqql, conn); SqlDataReader drr = cmdd.ExecuteReader(); if (drr.Read()) {

decimal je = Convert.ToDecimal(drr[2]); string presentname = wo;

string cardid = "'" + Form1.lockID + "'"; decimal change = sqje;

string time = Convert.ToString(DateTime.Now); je = je + sqje; drr.Close();

string sqql1 = "Update userinfo set yue='" + je + "'where yonghu='" + maskedTextBox2.Text.Trim() + "'";

SqlCommand cmmdd = new SqlCommand(sqql1, conn); int n = cmmdd.ExecuteNonQuery(); if (n == 1) {

MessageBox.Show("转账成功！"); maskedTextBox2.Text = "";

C#课程设计—自动取款机模拟软件设计,附软件界面截图、程序源代码和数据库设计,仅供学习使用。

maskedTextBox1.Text = ""; } else {

MessageBox.Show("转账失败！"); maskedTextBox2.Text = ""; maskedTextBox1.Text = ""; }

} else {

MessageBox.Show("操作失败，请重试！", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else

{ } } else {

MessageBox.Show("您的余额不足，请重新输入金额！"); maskedTextBox1.Text = ""; } }

private void button1_Click(object sender, EventArgs e) {

maskedTextBox1.Text = ""; }

private void button2_Click(object sender, EventArgs e) {

Form2 frm = new Form2(); frm.Show(); this.Hide(); }

private void Form5_Load(object sender, EventArgs e) { }

private void label2_Click(object sender, EventArgs e) { } } }

C#课程设计—自动取款机模拟软件设计,附软件界面截图、程序源代码和数据库设计,仅供学习使用。

(7)交费窗体：通过该界面用户可以自行交费，其界面如图2-8所示：

图2-8 交费窗口 代码如下：

namespace Windowasd {

public partial class Form6 : Form {

public Form6() {

InitializeComponent(); }

private void maskedTextBox1_MaskInputRejected(object sender, MaskInputRejectedEventArgs e) { }

private void button1_Click(object sender, EventArgs e) {

Form2 frm = new Form2(); frm.Show(); this.Hide(); }

private void button2_Click(object sender, EventArgs e) {

maskedTextBox1.Text = "";