DB/Users.cs

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

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

using System;
using System.Data;
using System.Data.SqlClient;
using System.Collections.Generic;
using System.Web;
using System.Web.UI.WebControls;
using System.Web.UI;
using COCOWO.COMP;

namespace COCOWO.DB
{
    public class Users :SqlDataBase
    {
        string strSql = null;
        /// <summary>
        /// 验证用户名是否存在
        /// </summary>
        /// <param name="username">用户名</param>
        /// <returns></returns>
        public bool Vld_UserName(string username)
        {
            strSql = "SELECT COUNT(User_Id) FROM Users WHERE User_Name='" + username + "'";
            string str = RunSqlReturn(strSql);
            return (Equals(RunSqlReturn(strSql), "0")) ? true:false;                
        }

        /// <summary>
        /// 验证用户登录信息
        /// </summary>
        /// <param name="username">用户名</param>
        /// <param name="password">密码</param>
        /// <returns></returns>
        public DataView Vld_User(string username, string password)
        {
            var op = StringUtil.EncryptPassword(password, "MD5");
            string strSql = "SELECT Top 1 mem_Name,stat_title,stat_Code,stat_attSize,stat_attType FROM V_blog_member WHERE mem_Name='" + username + "' AND mem_Password='" + StringUtil.EncryptPassword(password, "MD5") + "'";//StringUtil.EncryptPassword(password, "MD5")
            return GetDv(strSql);
        }

        /// <summary>
        /// 验证后台登录信息
        /// </summary>
        /// <param name="password">密码</param>
        /// <returns></returns>
        public DataView Vld_Admin(string username, string password)
        {
            string strSql = "SELECT Top 1 mem_Name FROM blog_member WHERE mem_Name='" + username + "' AND mem_hashKey='" + StringUtil.EncryptPassword(password, "MD5") + "'";//StringUtil.EncryptPassword(password, "MD5")
            return GetDv(strSql);
        }

        /// <summary>
        /// 用户登录
        /// </summary>
        /// <param name="strUserName">用户名</param>
        /// <param name="strPassWord">密码</param>
        /// <param name="day">保存登录信息天数</param>
        /// <param name="ip">IP地址</param>
        public void VldUserLogin(string strUserName, string strPassWord, int day)
        {
            DataView mydv = Vld_User(StringUtil.InputText(strUserName, 10), StringUtil.InputText(strPassWord, 20));