App_Code/DAO/Bs_UserDao.cs

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

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

using System;
using System.Data;
using System.Text;
using System.Data.SqlClient;
	/// <summary>
	/// 数据访问类Bs_UserDao。
	/// </summary>
	public class Bs_UserDao
	{
		public Bs_UserDao()
		{}


        /// <summary>
        /// 注册用户
        /// </summary>
        /// <param name="user">用户实体</param>
        public void reg(Bs_User user)
        {
            CSA.DAL.SQLBuilder builder = new CSA.DAL.SQLBuilder();
            builder.TblName = "Bs_User";
            builder.AddData("name", user.Name);
            builder.AddData("realname", user.Name);
            builder.AddData("password",user.Password);
            builder.AddData("email", user.EMail);
            builder.AddData("addtime", DateTime.Now.ToString());
            builder.AddData("Code", "01");
            builder.AddData("Bs_UserGradeCode", "01");
           // builder.AddData("sex",user.Sex);
            builder.AutoInsert();

        }

        /// <summary>
        /// 根据ID获取用户实体
        /// </summary>
        /// <param name="userId"></param>
        /// <returns></returns>
        public DataTable getDtUserByID(int userId)
        {
            string strSql = string.Format("select * from Bs_user where id = '{0}' ", userId);
            return CSA.DAL.DBAccess.getRS(strSql);
        }

        /// <summary>
        /// 获取等级权利
        /// </summary>
        /// <param name="grade">等级代码</param>
        /// <returns></returns>
        public string getgradeinfo(string  grade)
        {
            string content = "";
            DataTable dt = CSA.DAL.DBAccess.getRS("select * from Bs_UserGrade where code='"+grade+"'");
            if (dt.Rows.Count > 0)
            {
                content = dt.Rows[0]["Name"].ToString();
            }
            return content;
        }
        /// <summary>