ExaminationDAL/TbUserService.cs

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

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

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

namespace ExaminationDAL
{
    public class TbUserService
    {
        /// <summary>
        /// 用户登录,返回当前用户的身份
        /// </summary>
        /// <param name="user">账号</param>
        /// <param name="pwd">密码</param>
        /// <returns></returns>
        public int Login(string user, string pwd)
        {
            string sql = "select Zt from tbUser where (YhName=@user or Xh=@user) and YhPwd=@pwd";
            SqlParameter[] paras = new SqlParameter[] { 
                    new SqlParameter("@user",user),
                    new SqlParameter("@pwd",pwd)
            };
            return DBHelper.GetScalar(sql, paras);
        }
        /// <summary>
        /// 添加用户(管理员，老师，学员),返回当前添加后的标识符
        /// </summary>
        /// <param name="user"></param>
        /// <returns></returns>
        public int AddUser(TbUser user)
        { 
            string sql = "insert into tbUser(YhName,Xh,YhPwd,Zt)values(@YhName,@Xh,@YhPwd,@Zt);select @@IDENTITY";
            SqlParameter[] paras = new SqlParameter[] { 
                    new SqlParameter("@YhName",user.YhName),
                    new SqlParameter("@Xh",user.Xh),
                    new SqlParameter("@YhPwd",user.YhPwd),
                    new SqlParameter("@Zt",user.Zt)
            };
            return DBHelper.GetScalar(sql, paras);
        }
        /// <summary>
        /// 删除所有学员用户登录信息
        /// </summary>
        /// <returns></returns>
        public int DeleteAllStuUser()
        {
            string sql = "delete from tbUser where Zt=3";
            return DBHelper.ExecuteCommand(sql);
        }
        /// <summary>
        /// 根据ID删除用户信息
        /// </summary>
        /// <param name="id">YhID</param>
        /// <returns></returns>
        public int DeleteStuByID(int id)
        {
            string sql = "delete from tbUser where YhID=@YhID";