trainbank.cs

主要用C#写的代码

using System;
using System.Data;
using System.Text;
using DataAccess;
using BusinessRule.Table;
using BusinessRule.Tables;
using BusinessRule.TablesBusiness;
using System.Data.SqlClient;
using BusinessRule.TablesBusines;



namespace BusinessRule.TablesBusiness
{
	/// <summary>
	/// TrainBank 的摘要说明。
	/// </summary>
	public class TrainBank
	{
		DataAccessInfo info=new DataAccessInfo();

        /// <summary>
        /// 通过卡号和密码查询用户
        /// </summary>
        /// <returns></returns>
		public int LoginTorF(BankClass bank)
		{
            DataSet ds=new DataSet();
			string sql=String.Format("select count(*) from bank where bankid='{0}' and bankpw='{1}'",bank.Bnakid,bank.Bankpw);

			//调用DataAccessInfo类的方法，查询用户是否存在
			int returnNum = info.GetScalarBySql( sql );

			return returnNum;
		}

		/// <summary>
		/// 交易
		/// </summary>
		/// <param name="price">票价</param>
		/// <returns>成功返回1 失败返回0</returns>
		public int JiaoYi(double price,string id)
		{
			
            string sql=String.Format("update bank set bankmoney=bankmoney-{0} where bankid='{1}'",price,id);
			int returnNum=info.ExecuteSQL(sql);

			return returnNum;
		}
		/// <summary>
		/// 查询余额
		/// </summary>
		/// <param name="price">票价</param>
		/// <returns>成功返回1 失败返回0</returns>
		public double JiaoYiMingXi(string bankid)
		{
			
            string sql=String.Format("select bankmoney from bank where bankid='{0}' ",bankid);
			double returnNum=info.GetScalarSql(sql);

			return returnNum;
		}
	}
}