HH.BiDaoDian.Solution/BiDaoDian.BLL/UserBLL.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using BiDaoDian.Model;
using System.Data;
using Common;
using DataBaseHelper;

namespace BiDaoDian.BLL
{
    public class UserBLL
    {
        Class_SqlDataBaseHelperService sqlHelper = new Class_SqlDataBaseHelperService();
        /// <summary>
        /// 根据sql条件查询用户，返回一个list列表
        /// </summary>
        /// <param name="sqlCondition">sql条件</param>
        /// <returns>如果查询到则返回list列表，如果查不到则返回null</returns>
        public List<UserModel> GetAllUsers()
        {
            List<UserModel> list = new List<UserModel>();
            string sql = "select * from Users ";
            DataTable dt = sqlHelper.UnlinkSingleTableQuery(sql);
            if (dt.Rows.Count > 0)
            {
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    UserModel model = new UserModel();
                    model.UserNo = StringExtension.ToInt(dt.Rows[i]["UserNo"].ToString());
                    model.UserRole = StringExtension.ToInt(dt.Rows[i]["UserRole"].ToString());
                    model.UserGroupId = StringExtension.ToInt(dt.Rows[i]["UserGroupId"].ToString());
                    model.TelTypeId = StringExtension.ToInt(dt.Rows[i]["TelTypeId"].ToString());
                    model.SexualityId = StringExtension.ToInt(dt.Rows[i]["SexualityId"].ToString());
                    model.PassWord = StringExtension.ToNotNullString(dt.Rows[i]["PassWord"].ToString());
                    model.Human_name = StringExtension.ToNotNullString(dt.Rows[i]["Human_name"].ToString());
                    model.DigtialPassId = StringExtension.ToInt(dt.Rows[i]["DigtialPassId"].ToString());
                    model.DepartmentNo = StringExtension.ToInt(dt.Rows[i]["DepartmentNo"].ToString());
                    model.BirthDay = StringExtension.ToDateTime(dt.Rows[i]["BirthDay"].ToString());
                    model.Alias = StringExtension.ToNotNullString(dt.Rows[i]["Alias"].ToString());
                    list.Add(model);
                }
                return list;
            }
            return null;
        }
        /// <summary>
        /// 根据UserNo查询用户，返回一个用户模型
        /// </summary>
        /// <param name="sqlCondition">传入的UserNo</param>
        /// <returns>如果查询到则返回一个用户模型，如果查不到则返回null</returns>
        public UserModel GetOneUserByUserNo(int userNo)
        {
            string sql = string.Format("select * from Users where UserNo={0}",userNo);
            DataTable dt = sqlHelper.UnlinkSingleTableQuery(sql);
            if (dt.Rows.Count > 0)
            {
                UserModel model = new UserModel();
                model.UserNo = StringExtension.ToInt(dt.Rows[0]["UserNo"].ToString());
                model.UserRole = StringExtension.ToInt(dt.Rows[0]["UserRole"].ToString());