DAL/DalUser.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using MODEL;
namespace DAL
{
    public class DalUser
    {
        /// <summary>
        /// 登录
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public static Boolean CheckLogin(ModelUser model)
        {
            SqlDataReader reader = Dal.SqlHelpers.ExecuteGetReader(CommandType.Text, "select * from mis_users where USER_NAME='" + model.USER_NAME + "' and USER_PASSWORD='" + model.USER_PASSWORD + "' and STATUS=1");
            if (reader.Read())
            {
                return true;
            }
            else
            {
                return false;
            }
        }
        /// <summary>
        /// 添加用户
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public static Boolean AddUser(ModelUser model)
        {
            try
            {
                int i = Dal.SqlHelpers.ExecuteNonQuery(CommandType.Text, "insert into mis_users (USER_NAME,USER_PASSWORD,STATUS) values('" + model.USER_NAME + "','" + model.USER_PASSWORD + "','"+model.STAUTS+"')");
                if (i > 0)
                {
                    return true;
                }
                else
                {
                    return false;
                }
            }
            catch
            {
                throw;
            }
        }
        /// <summary>
        /// 删除用户
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public static Boolean DeleteUser(ModelUser model)
        {
            try