DAL/LoginDAL.cs

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

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

using Model;
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace DAL
{
    public class LoginDAL
    {
        /// <summary>
        /// 根据用户登录id查询用户相关信息
        /// </summary>
        /// <param name="userId"></param>
        /// <returns>返回LoginModel</returns>
        public static LoginModel GetLoginInfoByUserId(string userId)
        {
            LoginModel lm= new LoginModel();
            string sql=string.Format("select * from [t_login] where UserId='{0}'",userId);
            DataTable dt = MsSqlHelper.ExecuteDataSet(sql).Tables[0];
            if(dt.Rows.Count > 0)
            {
                lm.UserId = dt.Rows[0]["UserId"].ToString();
                lm.UserPwd = dt.Rows[0]["UserPwd"].ToString();
                lm.UserName = dt.Rows[0]["UserName"].ToString();
                lm.UserSex = dt.Rows[0]["UserSex"].ToString();
                lm.UserAdddate = dt.Rows[0]["UserAdddate"].ToString();
                lm.UserRole = dt.Rows[0]["UserRole"].ToString();
                lm.UserTel = dt.Rows[0]["UserTel"].ToString();
                lm.UserState = Convert.ToInt32(dt.Rows[0]["UserState"].ToString());
                if (Convert.ToInt32(dt.Rows[0]["UserState"].ToString()) == 1)
                {
                    lm.UserStateName = "启用";
                }
                else { lm.UserStateName = "禁用"; }
            }
            return lm;
        }
        /// <summary>
        /// 根据用户id和用户姓名查询登录用户信息
        /// </summary>
        /// <param name="UserId"></param>
        /// <param name="UserName"></param>
        /// <returns></returns>
        public static List<LoginModel> GetListByLoginIdLoginName(string userId,string userName)
        {
            List<LoginModel> list=new List<LoginModel>();
            string sql = string.Format("select * from [t_login] where UserId like {0} and UserName like {1}","'%"+ userId + "%'","'%"+ userName + "%'");
            DataTable dt = MsSqlHelper.ExecuteDataSet(sql).Tables[0];
            if(dt.Rows.Count > 0)
            {
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    LoginModel lm = new LoginModel();
                    lm.Id =Convert.ToInt32(dt.Rows[i]["Id"].ToString());
                    lm.UserId = dt.Rows[i]["UserId"].ToString();
                    lm.UserPwd = dt.Rows[i]["UserPwd"].ToString();