?? bank.cs
字號:
using System;
using System.Data.SqlClient;
using System.Data;
using System.Web.Security;
namespace WebApplication2
{
/// <summary>
/// Bank 的摘要說明。
/// </summary>
public class Bank
{
string account;
string username;
string money;
string password;
#region 屬性的定義
/// <summary>
/// 帳戶
/// </summary>
public string Account
{
get{return account;}
set{account=value;}
}
/// <summary>
/// 用戶名
/// </summary>
public string Username
{
get{return username;}
set{username=value;}
}
/// <summary>
/// 金錢
/// </summary>
public string Money
{
get{return money;}
set{money=value;}
}
/// <summary>
/// 密碼
/// </summary>
public string Password
{
get{return password;}
set{password=value;}
}
#endregion
public Bank()
{
//
// TODO: 在此處添加構造函數邏輯
//
}
/// <summary>
/// 判斷是否存在該用戶
/// </summary>
public bool judge(string account)
{
SqlConnection con=DB.createCon();
SqlCommand cmd=new SqlCommand("select count(*) from bank where account='"+account+"'",con);
con.Open();
int i=Convert.ToInt32(cmd.ExecuteScalar());
if(i>0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 判斷用戶的密碼是否正確
/// </summary>
public bool check(string account,string password)
{
if(this.judge(account))
{
SqlConnection con=DB.createCon();
SqlCommand cmd=new SqlCommand("select count(*) from bank where password='"+password+"' and account='"+account+"'",con);
con.Open();
int i=Convert.ToInt32(cmd.ExecuteScalar());
if(i>0)
{
return true;
}
else
{
return false;
}
}
else
{
return false;
}
}
/// <summary>
/// 修改密碼
/// </summary>
public bool UpdataPassword(string Account,string Newpassword)
{
SqlConnection con=DB.createCon();
SqlCommand cmd=new SqlCommand("update bank set password='"+Newpassword+"' where account='"+Account+"'",con);
con.Open();
int i=cmd.ExecuteNonQuery();
if(i>0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 注冊用戶
/// </summary>
public bool insertUser()
{
SqlConnection con=DB.createCon();
con.Open();
SqlCommand cmd=new SqlCommand("insert into bank values(@account,@username,@money,@password)",con);
SqlParameter para;
para=new SqlParameter("@account",SqlDbType.VarChar,10);
para.Value=this.account;
cmd.Parameters.Add(para);
para=new SqlParameter("@username",SqlDbType.VarChar,10);
para.Value=this.username;
cmd.Parameters.Add(para);
para=new SqlParameter("@money",SqlDbType.BigInt,8);
para.Value=this.money;
cmd.Parameters.Add(para);
para=new SqlParameter("@password",SqlDbType.VarChar,10);
para.Value=this.password;
cmd.Parameters.Add(para);
int i=cmd.ExecuteNonQuery();
if(i>0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 用戶存款
/// </summary>
public bool Deposit(string Account,int MoneyCount)
{
SqlConnection con=DB.createCon();
con.Open();
SqlCommand cmd=new SqlCommand("update bank set money=money+"+MoneyCount.ToString()+" where account='"+Account+"'",con);
if(cmd.ExecuteNonQuery()>0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 用戶取款
/// </summary>
public bool FetchMoney(string Account,int MoneyCount)
{
SqlConnection con=DB.createCon();
con.Open();
SqlCommand cmd=new SqlCommand("update bank set money=money-"+MoneyCount.ToString()+" where account='"+Account+"'",con);
if(cmd.ExecuteNonQuery()>0)
{
return true;
}
else
{
return false;
}
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -