App_Code/User/User.cs

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

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

using System;
using System.Data;
using System.Configuration;

using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;

using CSA.DAL;

namespace BLL.BsUser
{
    /// <summary>
    ///User 的摘要说明
    /// </summary>
    public class User
    {
        public User()
        {
            //
            //TODO: 在此处添加构造函数逻辑
            //
        }

        /// <summary>
        /// 增加一个用户
        /// </summary>
        /// <param name="sql"></param>
        /// <returns></returns>
        public static bool AddUser(string sql)
        {
            return CSA.DAL.DBAccess.ExecuteNonQuery(sql) > 0;
        }

        /// <summary>
        /// 按登录名及密码查询出用户信息
        /// </summary>
        /// <param name="loginName">登录名</param>
        /// <param name="pwd">密码</param>
        /// <returns></returns>
        public static DataRow GetUserByNameAndPwd(string loginName, string pwd)
        {
            string pwd1 = CSA.Security.Encrypt.getMD5(pwd);
            string sql = string.Format("select bs_user.*,bs_usergrade.Name as gradeName,bs_usergrade.discount,bs_usergrade.score " +
                    " from bs_user join bs_usergrade on(bs_user.bs_usergradeCode =bs_usergrade.code) " +
                    " where bs_user.Name = '{0}' and bs_user.password='{1}'", loginName, pwd1);
            DataTable dt = CSA.DAL.DBAccess.getRS(sql);
            if (dt != null && dt.Rows.Count != 0)
                return dt.Rows[0];
            return null;

        }

        /// <summary>
        /// 按名称查询用户
        /// </summary>
        /// <param name="name"></param>