DAL/Admin/GZXX_Admin.cs

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

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

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Text;
using DBUtility;

namespace DAL.Admin
{
    public class GZXX_Admin
    {
        public bool UpdateLocked(Model.Admin.GZXX_Admin model) 
        {
            string sql = "update GZXX_Admin set Locked = @Locked where LoginName = @LoginName";
            SqlParameter[] param = new SqlParameter[] { 
                new SqlParameter("@Locked",SqlDbType.Int),
                new SqlParameter("@LoginName",SqlDbType.VarChar)
            };
            param[0].Value = model.Locked;
            param[1].Value = model.LoginName;
            if (DbHelperSQL.ExecuteSql(sql, param) > 0) { return true; }
            else { return false; }
        }

        public bool UpdatePassWord(Model.Admin.GZXX_Admin model) 
        {
            string sql = "update GZXX_Admin set PassWord = @PassWord where LoginName = @LoginName";
            SqlParameter[] param = new SqlParameter[] { 
                new SqlParameter("@PassWord",SqlDbType.VarChar),
                new SqlParameter("@LoginName",SqlDbType.VarChar)
            };
            param[0].Value = model.PassWord;
            param[1].Value = model.LoginName;
            if (DbHelperSQL.ExecuteSql(sql, param) > 0) { return true; }
            else { return false; }
        }

        public bool UpdateLoginInfo(Model.Admin.GZXX_Admin model) 
        {
            string sql = "update GZXX_Admin set LastLoginIP=@LastLoginIP,LastLoginTime=getdate() where LoginName = @LoginName";
            SqlParameter[] param = new SqlParameter[] { 
            new SqlParameter("@LastLoginIP",SqlDbType.VarChar),
            new SqlParameter("@LoginName",SqlDbType.VarChar)
            };
            param[0].Value = model.LastLoginIP;
            param[1].Value = model.LoginName;
            if (DbHelperSQL.ExecuteSql(sql, param) > 0) { return true; }
            else { return false; }
        }

        public bool CheckLogin(string LoginName, string PassWord) 
        {
            string sql = "select * from GZXX_Admin where LoginName = @LoginName and PassWord = @PassWord ";
            SqlParameter[] param = new SqlParameter[] { 
            new SqlParameter("@LoginName",SqlDbType.VarChar),
            new SqlParameter("@PassWord",SqlDbType.VarChar)
            };
            param[0].Value = LoginName;
            param[1].Value = PassWord;
            if (DbHelperSQL.Exists(sql, param))