admin.cs

大话设计大话设计模式所有源代码模式所有源代码大话设计模式所有源代码

using System;
using System.Data;
using System.Data.SqlClient;

namespace TBLibrary.Shop.Users
{
	/// <summary>
	/// Admin 的摘要说明。
	/// </summary>
	public class Admin : TBLibrary.Shop.DbBase.Base
	{
		public Admin()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
		/// <summary>
		/// 管理员登陆
		/// </summary>
		/// <param name="adminName"></param>
		/// <param name="password"></param>
		/// <returns></returns>		
		public static int AdminLogin(string adminName,string password)
		{
			strSQL = "Select Id From Admin Where adminName='"+adminName+"'"
				+"And password = '"+TBLibrary.Shop.Functions.Functions.Encrypt(password,1)+"'";
			try
			{
				//bool login;
				int i = (int)EexecuteSqlValue(strSQL);			
				//LoginTimes(name);
				return i;
				
			}
			catch//(Exception ex)
			{
				//throw new Exception(ex.Message);
				return -1;
			}
		}
		/// <summary>
		/// 添加新的后台用户
		/// </summary>
		/// <param name="adminName"></param>
		/// <param name="password"></param>
		/// <param name="email"></param>
		public static void AddAdmin(string adminName,string password,string email,int GroupId)
		{
			
			string strSQL = "Insert Into Admin(adminName,password,email,GroupID) values"+
				"('"+adminName+"','"+TBLibrary.Shop.Functions.Functions.Encrypt(password,1)+"','"+email+"','"+GroupId+"')";
			
			if(!IsExist(adminName))
			{
				try
				{
					ExecuteSql(strSQL);
				}
				catch
				{
					//throw new Exception(ex.Message);
					throw new Exception("Register is failed");				
					
				}				
			}
			else
			{
				throw new Exception("管理员已存在了");
			}
		}
		/// <summary>
		/// 检测是否存在
		/// </summary>
		/// <param name="name"></param>
		/// <returns></returns>
		public static bool IsExist(string name)
		{
			strSQL = "Select Id from Admin where AdminName Like '"+name+"'";
			try
			{
				EexecuteSqlValue(strSQL);
				return true;
			}
			catch
			{
				return false;
			}
		}
		/// <summary>
		/// 获取管理员信息
		/// </summary>
		/// <returns></returns>
		public static DataView GetAdminMessage()
		{
			string strSQL = "Select Admin.ID,Admin.AdminName,Admin.EMail,AdminGroup.GroupName From Admin,AdminGroup Where Admin.GroupID = AdminGroup.ID";
			DataSet ds = new DataSet();
			ds = ExecuteSqlDs(strSQL);
			return ds.Tables[0].DefaultView;			
		}
		/// <summary>
		/// 
		/// </summary>
		/// <param name="id"></param>
		public static void DeleteAdmin(int id)
		{
			string strSQL = "Delete From Admin Where ID="+id;
			try
			{
				ExecuteSql(strSQL);
				//return true;
			}
			catch(Exception ex)
			{
				//return false;
				throw new Exception(ex.Message);
			}
		}
		/// <summary>
		/// 更新资料
		/// </summary>
		/// <param name="name"></param>
		/// <param name="eMail"></param>
		/// <param name="id"></param>
		public static void UpdateAdmin(string name,string eMail,int id,int groupId)
		{
			string strSQL ="Update Admin Set AdminName = '"+name+"',EMail ='"+eMail+"',GroupId = '"+groupId+"'"
				+"Where id ="+id;
			try
			{
				ExecuteSql(strSQL);
			}
			catch(Exception ex)
			{
				throw new Exception(ex.Message);
				//throw new Exception("更新失败");
			}
		}		
	}
}