register.cs

一个web电子商务系统（我的毕业设计）

using System;
using System.Data.SqlClient;
using System.Data;
using System.Text;
using System.Collections;

namespace Data.BLL
{
	public class Register
	{
		SqlConnection con;

		public Register()
		{
			con=new SqlConnection("server=127.0.0.1;database=BOOKSHOP;user id=sa;password=;");
		}

		/// <summary>
		/// 获得数据模型
		/// </summary>
		/// <param name="cUserID">表主键</param>
		/// <returns></returns>
		public Data.Model.Register getModel(string cUserID)
		{
			con.Open();

			StringBuilder strSql=new StringBuilder();//实例化一个字符串容器

			strSql.AppendFormat("select * from Register where cUserID='{0}'",cUserID);//向字符容器里添加一条 SQL 语句

			SqlDataAdapter adapter=new SqlDataAdapter(strSql.ToString(),con);
			DataSet ds=new DataSet();
			DataTable dt=new DataTable();
			adapter.Fill(ds,"Register");
			dt=ds.Tables["Register"];

			Data.Model.Register model=new Data.Model.Register();//实例化此数据表的模型

			if(dt.Rows.Count>0)
			{//有数据则向模型里存入数据
				model.cUserID=dt.Rows[0]["cUserID"].ToString();
				model.cPassword=dt.Rows[0]["cPassword"].ToString();
				model.cSex=dt.Rows[0]["cSex"].ToString();
				model.iAge=int.Parse(dt.Rows[0]["iAge"].ToString());
				model.cEmail=dt.Rows[0]["cEmail"].ToString();
				model.cDegreeNo=dt.Rows[0]["cDegreeNo"].ToString();
				model.cAddress=dt.Rows[0]["cAddress"].ToString();
				model.cUserName=dt.Rows[0]["cUserName"].ToString();
				model.cPhone=dt.Rows[0]["cPhone"].ToString();
			}
			con.Close();

			return model;
		}

		/// <summary>
		/// 添加数据行
		/// </summary>
		/// <param name="model">要添加表的模型</param>
		public bool add(Data.Model.Register model)
		{
			StringBuilder strSql=new StringBuilder();

			strSql.Append("insert into Register values(");
			strSql.AppendFormat("'{0}',",model.cUserID);
			strSql.AppendFormat("'{0}',",model.cPassword);
			strSql.AppendFormat("'{0}',",model.cSex);
			strSql.AppendFormat("{0},",model.iAge);
			strSql.AppendFormat("'{0}',",model.cEmail);
			strSql.AppendFormat("'{0}',",model.cDegreeNo);
			strSql.AppendFormat("'{0}',",model.cAddress);
			strSql.AppendFormat("'{0}',",model.cUserName);
			strSql.AppendFormat("'{0}')",model.cPhone);

			return this.Execute(strSql.ToString());//调用执行SQL命令的函数并返回结果true or false
		}

		/// <summary>
		/// 删除数据表行
		/// </summary>
		/// <param name="cUserID">数据表主键</param>
		public bool delete(string cUserID)
		{
			StringBuilder strSql=new StringBuilder();

			strSql.AppendFormat("delete Register where cUserID='{0}'",cUserID);

			return this.Execute(strSql.ToString());//调用执行SQL命令的函数并返回结果true or false
		}

		/// <summary>
		/// 更新数据表行
		/// </summary>
		/// <param name="model">要更新表模型</param>
		public bool update(Data.Model.Register model)
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("update Register set ");
			strSql.AppendFormat("cPassword='{0}'",model.cPassword);
			strSql.AppendFormat(",cSex='{0}'",model.cSex);
			strSql.AppendFormat(",iAge={0}",model.iAge);
			strSql.AppendFormat(",cEmail='{0}'",model.cEmail);
			strSql.AppendFormat(",cDegreeNo='{0}'",model.cDegreeNo);
			strSql.AppendFormat(",cAddress='{0}'",model.cAddress);
			strSql.AppendFormat(",cUserName='{0}'",model.cUserName);
			strSql.AppendFormat(",cPhone='{0}'",model.cPhone);
			strSql.AppendFormat(" where cUserID='{0}'",model.cUserID);

			return this.Execute(strSql.ToString());//调用执行SQL命令的函数并返回结果true or false
		}

		/// <summary>
		/// 执行SQL语句
		/// </summary>
		/// <param name="strSql">SQL语句</param>
		/// <returns></returns>
		public bool Execute(string strSql)
		{
			bool b=false;

			SqlCommand command=new SqlCommand(strSql.ToString(),con);

			try
			{
				con.Open();
				command.ExecuteNonQuery();
				con.Close();
				b=true;
			}
			catch(Exception e)
			{
			}
			finally
			{
				con.Close();
			}

			return b;
		}

		/// <summary>
		///得到用户所有的主键
		/// </summary>
		/// <returns></returns>
		public ArrayList getPrimaryKeyList()
		{
			con.Open();
			StringBuilder strSql=new StringBuilder();//实例化一个字符串容器

			strSql.Append("select cUserID from Register");

			SqlCommand command=new SqlCommand(strSql.ToString(),con);
			SqlDataReader read=command.ExecuteReader();

			ArrayList listuser=new ArrayList();

			while(read.Read())
			{
				listuser.Add(read[0].ToString());//将数据加入数组列表里
			}

			con.Close();

			return listuser;
		}

		public static bool check(string user,string password)
		{
			if(user.Trim().Length==0||password.Trim().Length==0)
			{
				return false;
			}
			Data.Model.Register model=new Data.Model.Register();
			Data.BLL.Register bll=new Register();
			model=bll.getModel(user);

			if(password.Equals(model.cPassword.ToString().Trim()))
			{
				return true;
			}
			else
			{
				return false;
			}
		}
	}
}