DAL/user.cs

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

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

using System;
using System.Collections.Generic;

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

namespace DAL
{
    public  class  user
    {
        //注册会员
        public int insert(Model.user aa)
        {
            StringBuilder sql = new StringBuilder();
            sql.Append("insert into [user] ( _username,_pwd,_email,_qq,_msn,_safequestion,_safepwd ) values(@username,@pwd,@email,@qq,@msn,@safeque,@safepwd)");
            SqlParameter[] par ={
                                    new SqlParameter("@username",SqlDbType.VarChar,50),
                                    new SqlParameter ("@pwd",SqlDbType .VarChar,50),
                                    new SqlParameter ("@email",SqlDbType .VarChar,50),
                                    new SqlParameter ("@qq",SqlDbType .VarChar,50),
                                    new SqlParameter ("@msn",SqlDbType .VarChar,50),
                                    new SqlParameter ("@safeque",SqlDbType .VarChar,150),
                                    new SqlParameter ("@safepwd",SqlDbType .VarChar,150)
                                };
            par[0].Value = aa.username;
            par[1].Value = Common.DESEncrypt.Encrypt(aa.pwd);
            par[2].Value = aa.email;
            par[3].Value = aa.qq;
            par[4].Value = aa.msn;
            par[5].Value = aa.safequestion;
            par[6].Value = aa.safepwd;

            return Common.DbHelperSQL.ExecuteSql(sql.ToString(),par);
        }
        //判断该用户邮箱是否存在
        public DataSet  pan(Model.user aa)
        {
            StringBuilder sql = new StringBuilder();
            sql.Append("select _userid from [user] where _email=@email");
            SqlParameter[] par ={
                                    new SqlParameter("@email",SqlDbType.VarChar,50)
                                };
            par[0].Value = aa.email;
            return Common.DbHelperSQL.Query(sql.ToString(),par);
        }
        public SqlDataReader dd(Model.user aa)
        {
            StringBuilder sql = new StringBuilder();
            sql.Append("select _userid from [user] where _email=@email");
            SqlParameter[] par ={
                                    new SqlParameter("@email",SqlDbType.VarChar,50)
                                };
            par[0].Value = aa.email;
            return Common.DbHelperSQL.ExecuteReader(sql.ToString(),par);
        }
    
        //读取会员信息
        public SqlDataReader seleus(Model.user aa)
        {