BookShop/DAL/BookShop_Admin.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

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

using BookShop.Model;
using CTL.Common;
using CTL.Data;

namespace BookShop.Data
{
	/// <summary>
    ///	管理员信息表
    ///	数据层实例化接口类 BookShop_Admin
    /// 主要完成对数据库的基本操作
    ///	2013-07-22 20:53:16
	/// </summary>
	public partial class AdminProvider: SqlDB<AdminProvider>
	{
		/// <summary>
        /// 数据库表名
        /// </summary>
		private static string tableName="BookShop_Admin";
		/// <summary>
        /// 数据库视图名
        /// </summary>
        private static string viewName=tableName;
        /// <summary>
        /// 数据查询语句(查询全部数据)
        /// </summary>
        private string select_strsql="Select * from "+viewName;
        
        
        /// <summary>
        /// 数据插入语句
        /// </summary>
        private string insert_strsql="Insert into "+tableName+" (AdminName,Password,GroupID,LastLoginTime,LastLoginIP,LoginTime,LoginIP,LoginTimes,Status,CreateTime)values(@AdminName,@Password,@GroupID,@LastLoginTime,@LastLoginIP,@LoginTime,@LoginIP,@LoginTimes,@Status,@CreateTime)";
        /// <summary>
        /// 数据插入语句
        /// </summary>
        private string count_strsql="Select Count(*) From "+viewName;        
        /// <summary>
        /// 数据更新语句
        /// </summary>
        private string update_strsql="Update  "+tableName+" Set AdminName= @AdminName ,Password= @Password ,GroupID= @GroupID ,LastLoginTime= @LastLoginTime ,LastLoginIP= @LastLoginIP ,LoginTime= @LoginTime ,LoginIP= @LoginIP ,LoginTimes= @LoginTimes ,Status= @Status ,CreateTime= @CreateTime   where AdminID=@AdminID  ";
        /// <summary>
        /// 数据删除语句(根据主键删除)
        /// </summary>
        private string delete_strsql="Delete  From "+tableName+"  where AdminID=@AdminID";
		
        
        #region  判断是否存在
		/// <summary>
        /// 根据条件判断是否存在
        /// </summary>
        /// <param name="condition">条件</param>
        /// <returns></returns>
		public bool ExistAdmin(string condition)