BookShop/DAL/BookShop_User.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_User
    /// 主要完成对数据库的基本操作
    ///	2013-09-28 15:32:24
    /// </summary>
    public partial class UserProvider : SqlDB<UserProvider>
    {
        #region Method
        /// <summary>
        /// 数据库表名
        /// </summary>
        private static string tableName = "BookShop_User";
        /// <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 + " (Password,RegTime,LastLoginTime,LastLoginIP,LoginTime,LoginIP,LoginTimes,Status,RealName,Post,UserName,Sex,BirthDay,Point,Email,EmailIsChecked,Phone,Address)values(@Password,@RegTime,@LastLoginTime,@LastLoginIP,@LoginTime,@LoginIP,@LoginTimes,@Status,@RealName,@Post,@UserName,@Sex,@BirthDay,@Point,@Email,@EmailIsChecked,@Phone,@Address)";
        /// <summary>
        /// 数据插入语句
        /// </summary>
        private string count_strsql = "Select Count(*) From " + viewName;
        /// <summary>
        /// 数据更新语句
        /// </summary>
        private string update_strsql = "Update  " + tableName + " Set Password= @Password ,RegTime= @RegTime ,LastLoginTime= @LastLoginTime ,LastLoginIP= @LastLoginIP ,LoginTime= @LoginTime ,LoginIP= @LoginIP ,LoginTimes= @LoginTimes ,Status= @Status ,RealName= @RealName ,Post= @Post ,UserName= @UserName ,Sex= @Sex ,BirthDay= @BirthDay ,Point= @Point ,Email= @Email ,EmailIsChecked= @EmailIsChecked ,Phone= @Phone ,Address= @Address   where UserID=@UserID  ";
        /// <summary>
        /// 数据删除语句(根据主键删除)
        /// </summary>
        private string delete_strsql = "Delete  From " + tableName + "  where UserID=@UserID";


        #region  判断是否存在
        /// <summary>
        /// 根据条件判断是否存在
        /// </summary>
        /// <param name="condition">条件</param>
        /// <returns></returns>