bank.cs

银行自动取款机系统的源代码

			Update(cmdString,conn);
			conn.Close();
			return true;
		}
		//利用卡号进行存款，成功，返回真；否则，返回假
		public bool DepositByCardNo(string CardNo,decimal amount)
		{
			string AccountNo=QueryAccountNo(CardNo);
			if(AccountNo=="error")
				return false;
			else
				return DepositByAccountNo(AccountNo,amount);
		}
		//验证卡号的口令是否正确。正确，返回真；否则，返回假
		public bool VerifyCardNo(string CardNo,string pwd)
		{
			bool result;
			string cmdString="select * from Card where CardNo='"+
				CardNo+"' and password='"+pwd+"'";
			SqlConnection conn=GetConnection();
			conn.Open();
			SqlDataReader reader=GetDataReader(cmdString,conn);
			if(reader.Read())
				result=true;
			else
				result=false;
			reader.Close();
			conn.Close();
			return result;
		}
		//验证帐号的口令是否正确。正确，返回真；否则，返回假
		public bool VerifyAccountNo(string AccountNo,string pwd)
		{
			bool result;
			string cmdString="select * from Account where AccountNo='"+
				AccountNo+"' and password='"+pwd+"'";
			SqlConnection conn=GetConnection();
			conn.Open();
			SqlDataReader reader=GetDataReader(cmdString,conn);
			if(reader.Read())
				result=true;
			else
				result=false;
			reader.Close();
			conn.Close();
			return result;
		}
		//修改帐号口令。成功，返回真；否则，返回假
		public bool UpdateAccountPassword(string AccountNo,string pwd)
		{
			if(!AccountNoExists(AccountNo))
				return false;
			string cmdString="update Account set password='"+pwd+"' where AccountNo='"+
				AccountNo+"'";
			SqlConnection conn=GetConnection();
			conn.Open();
			Update(cmdString,conn);
			conn.Close();
			return true;
		}
		//修改卡号口令。成功，返回真；否则，返回假
		public bool UpdateCardPassword(string CardNo,string pwd)
		{
			if(QueryAccountNo(CardNo)=="error")
				return false;
			string cmdString="update Card set password='"+pwd+"' where CardNo='"+
				CardNo+"'";
			SqlConnection conn=GetConnection();
			conn.Open();
			Update(cmdString,conn);
			conn.Close();
			return true;
		}
		//获取所有的客户
		public ArrayList GetAllCustomers()
		{
			ArrayList list=new ArrayList();
			SqlConnection conn=GetConnection();
			conn.Open();
			string cmdString="select CustomerID from Customer";
			SqlDataReader reader=GetDataReader(cmdString,conn);
			while(reader.Read())
			{
				list.Add(reader.GetString(0));
			}
			reader.Close();
			conn.Close();
			return list;
		}
		//注册新客户。成功，返回真；否则，返回假
		public bool CreateCustomer(string CustomerID,string Name,string Gender,DateTime Birthday,
			string Address,string Phone)
		{
			ArrayList list=GetAllCustomers();
			//判断客户是否存在。存在返回假；否则，加入，返回真
			if(list.Contains(CustomerID))
				return false;
			string cmdString="insert into Customer values('"+CustomerID+"'";
			if(Name!=null)
			{
				cmdString+=",'"+Name+"'";
			}
			else
			{
				cmdString+=",null";
			}
			if(Gender!=null)
			{
				cmdString+=",'"+Gender+"'";
			}
			else
			{
				cmdString+=",null";
			}
			if(Birthday==DateTime.MinValue)
			{
				cmdString+=",null";
			}
			else
			{
				cmdString+=",'"+Birthday+"'";
			}
			if(Address!=null)
			{
				cmdString+=",'"+Address+"'";
			}
			else
			{
				cmdString+=",null";
			}
			if(Phone!=null)
			{
				cmdString+=",'"+Phone+"'";
			}
			else
			{
				cmdString+=",null";
			}
			cmdString+=")";
			SqlConnection conn=GetConnection();
			conn.Open();
			SqlCommand comm=new SqlCommand(cmdString,conn);
			comm.ExecuteNonQuery();
			conn.Close();
			return true;
		}
		//注销正在已经存在的客户
		public void DeleteCustomer(string CustomerID)
		{
			string cmdString="delete from Customer where CustomerID='"+CustomerID+"'";
			SqlConnection conn=GetConnection();
			conn.Open();
			SqlCommand comm=new SqlCommand(cmdString,conn);
			comm.ExecuteNonQuery();
			conn.Close();
		}
		//获取同一客户的所有帐号
		public ArrayList GetAllAccountsByCustomerID(string CustomerID)
		{
			ArrayList list=new ArrayList();
			string cmdString="select AccountNo from Account where CustomerID='"+
				CustomerID+"'";
			SqlConnection conn=GetConnection();
			conn.Open();
			SqlDataReader reader=GetDataReader(cmdString,conn);
			while(reader.Read())
			{
				list.Add(reader.GetString(0));
			}
			reader.Close();
			conn.Close();
			return list;
		}
		//获取所有的帐号
		public ArrayList GetAllAccounts()
		{
			ArrayList list=new ArrayList();
			SqlConnection conn=GetConnection();
			conn.Open();
			string cmdString="select AccountNo from Account";
			SqlDataReader reader=GetDataReader(cmdString,conn);
			while(reader.Read())
			{
				list.Add(reader.GetString(0));
			}
			reader.Close();
			conn.Close();
			return list;
		}
		//开户。成功，返回真；否则，返回假
		public bool CreateAccount(string AccountNo,string CustomerID,string password,decimal Balance)
		{
			ArrayList list=GetAllAccounts();
			//判断帐号是否已经存在。存在返回假；否则，加入，返回真
			if(list.Contains(AccountNo))
				return false;
			string cmdString="insert into Account values('"+
				AccountNo+"','"+CustomerID+"',"+Balance+",'"+password+"'";
			DateTime StartTime=DateTime.Today;
			cmdString+=",'"+StartTime+"')";
			SqlConnection conn=GetConnection();
			conn.Open();
			SqlCommand comm=new SqlCommand(cmdString,conn);
			comm.ExecuteNonQuery();
			conn.Close();
			return true;
		}
		//消去正在使用的帐号
		public void DeleteAccount(string AccountNo)
		{
			string cmdString="delete from Account where AccountNo='"+AccountNo+"'";
			SqlConnection conn=GetConnection();
			conn.Open();
			SqlCommand comm=new SqlCommand(cmdString,conn);
			comm.ExecuteNonQuery();
			conn.Close();
		}
		//获取同一帐号的所有卡号
		public ArrayList GetAllCardsByAccountNo(string AccountNo)
		{
			ArrayList list=new ArrayList();
			string cmdString="select CardNo from Card where AccountNo='"+
				AccountNo+"'";
			SqlConnection conn=GetConnection();
			conn.Open();
			SqlDataReader reader=GetDataReader(cmdString,conn);
			while(reader.Read())
			{
				list.Add(reader.GetString(0));
			}
			reader.Close();
			conn.Close();
			return list;
		}
		//获取所有的卡号
		public ArrayList GetAllCards()
		{
			ArrayList list=new ArrayList();
			SqlConnection conn=GetConnection();
			conn.Open();
			string cmdString="select CardNo from Card";
			SqlDataReader reader=GetDataReader(cmdString,conn);
			while(reader.Read())
			{
				list.Add(reader.GetString(0));
			}
			reader.Close();
			conn.Close();
			return list;
		}
		//办卡。成功，返回真；否则，返回假
		public bool CreateCard(string CardNo,string AccountNo,string Password)
		{
			ArrayList list=GetAllCards();
			//判断卡号是否存在。存在，返回假；否则，返回真
			if(list.Contains(CardNo))
				return false;
			string cmdString="insert into Card values('"+CardNo+"','"+
				AccountNo+"','"+Password+"')";
			SqlConnection conn=GetConnection();
			conn.Open();
			SqlCommand comm=new SqlCommand(cmdString,conn);
			comm.ExecuteNonQuery();
			conn.Close();
			return true;
		}
		//消去正在使用的卡
		public void DeleteCard(string CardNo)
		{
			string cmdString="delete from Card where CardNo='"+CardNo+"'";
			SqlConnection conn=GetConnection();
			conn.Open();
			SqlCommand comm=new SqlCommand(cmdString,conn);
			comm.ExecuteNonQuery();
			conn.Close();
		}
	}
}