APCGC_CBS.DAL/Admin/DAUserInfo.cs

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

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

using APCGC_CBS.Common;
using APCGC_CBS.DAL.DataAccess;
using APCGC_CBS.Models.Admin;
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace APCGC_CBS.DAL.Admin
{
    public class DALUserInfo
    {
        /// <summary>
        /// 登陆
        /// </summary>
        /// <param name="name"></param>
        /// <param name="pwd"></param>
        /// <returns></returns>
        public DataTable UserLogin(string name, string pwd)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("SELECT * FROM Sys_UserInfo AS sui WHERE  ");
            strSql.Append("sui.LoginName=@User_Account ");
            strSql.Append("AND sui.[Password]=@User_Pwd ");
            strSql.Append("AND sui.[Status]=0 ");
            SqlParameter[] para = new SqlParameter[]
			{
				new SqlParameter("@User_Account", name),
				new SqlParameter("@User_Pwd",DEncrypt.Encrypt(pwd))
			};
            return DbHelperSQL.Query(strSql.ToString(), para).Tables[0];
        }

        public bool UpdatePassword(long name, string pwd)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("UPDATE Sys_UserInfo SET  [Password] =@User_Pwd WHERE [User_ID]= @User_Account"); 
            SqlParameter[] para = new SqlParameter[]
			{
				new SqlParameter("@User_Account", name),
				new SqlParameter("@User_Pwd",pwd)
			};
            int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), para);
            return rows > 0;
        }

        public bool UpdateIsCgPwd(int UserID, bool IsCgPwd)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("UPDATE Sys_UserInfo SET IsChangePassword = @IsChangePassword WHERE [USER_ID] = @USER_ID");
            SqlParameter[] para = new SqlParameter[]
			{
				new SqlParameter("@IsChangePassword", IsCgPwd),
				new SqlParameter("@USER_ID",UserID)
			};
            int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), para);
            return rows > 0;