manager.cs

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

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

namespace Data.BLL
{
	/// <summary>
	/// Manager 的摘要说明。
	/// </summary>
	/// 

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

		/// <summary>
		/// 从数据库中取出数据，放入model模型里
		/// </summary>
		/// <param name="cManagerID"></param>
		/// <returns></returns>
		public Data.Model.Manager getModel(string cManagerID)
		{
			con.Open();

			StringBuilder strsql=new StringBuilder();//实例化字符串容器
			strsql.AppendFormat("select * from Manager where cManagerID='{0}'",cManagerID);//格式化SQL命令

			SqlDataAdapter adapter=new SqlDataAdapter(strsql.ToString(),con);//实例化数据适配器
			DataSet ds=new DataSet();//实例化数据集
			DataTable dt=new DataTable();//实例化数据表
			adapter.Fill(ds,"Manager");//填充数据适配器
			dt=ds.Tables["Manager"];//用数据集里面的数据来填充数据表

			Data.Model.Manager model=new Data.Model.Manager();

			if(dt.Rows.Count>0)//如果有数据得到  那么就继续往下执行
			{
				model.cManagerID=dt.Rows[0]["cManagerID"].ToString();
				model.cPassword=dt.Rows[0]["cPassword"].ToString();
				model.cEmail=dt.Rows[0]["cEmail"].ToString();
				model.cManagerName=dt.Rows[0]["cManagerName"].ToString();
				model.cPhone=dt.Rows[0]["cPhone"].ToString();
				model.cZip=dt.Rows[0]["cZip"].ToString();//本段代码是把输出的数据存储到model模型里
			}
			con.Close();

			return model;
		}


		/// <summary>
		/// 对数据表格Manager进行添加记录
		/// </summary>
		/// <param name="model"></param>
		public bool add(Data.Model.Manager model)
		{
			StringBuilder strSql=new StringBuilder();//实例化字符串容器

			strSql.AppendFormat("insert into Manager values(");
			strSql.AppendFormat("'{0}',",model.cManagerID);
			strSql.AppendFormat("'{0}',",model.cPassword);
			strSql.AppendFormat("'{0}',",model.cEmail);
			strSql.AppendFormat("'{0}',",model.cManagerName);
			strSql.AppendFormat("'{0}',",model.cPhone);
			strSql.AppendFormat("'{0}')",model.cZip);//本段代码是对插入数据进行格式化

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


		/// <summary>
		/// 删除数据表Manager的记录
		/// </summary>
		/// <param name="cManagerID"></param>
		public bool delete(string cManagerID)
		{
			StringBuilder strSql=new StringBuilder();//实例化字符串容器

			strSql.AppendFormat("delete Manager where cManagerID='{0}'",cManagerID);

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


		/// <summary>
		/// 对数据表Manager的字段进行更新操作
		/// </summary>
		/// <param name="model"></param>
		public bool update(Data.Model.Manager model)
		{
			StringBuilder strSql=new StringBuilder();//实例化字符串容器

			strSql.AppendFormat("update Manager set ");
			strSql.AppendFormat("cPassword='{0}',",model.cPassword);
			strSql.AppendFormat("cEmail='{0}',",model.cEmail);
			strSql.AppendFormat("cManagerName='{0}',",model.cManagerName);
			strSql.AppendFormat("cPhone='{0}',",model.cPhone);
			strSql.AppendFormat("cZip='{0}'",model.cZip);
			strSql.AppendFormat(" where cManagerID='{0}'",model.cManagerID);//本段代码对要更新的数据存储到已经格式化的Model里面

			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;
		}

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

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

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

			strSql.Append("select cManagerID from Manager");

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

			ArrayList list=new ArrayList();

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

			con.Close();

			return list;
		}
	}
}