GroupThink.CRM.BLL.Core/DBCommon.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using GroupThink.CRM.Model;
using GroupThink.CRM.Model.Sys;

namespace GroupThink.CRM.BLL.Core
{
    public class DBCommon
    {

        /// <summary>
        /// 获取部门下属用户
        /// </summary>   
        /// <param name="DeptId">部门Id</param>
        /// <param name="UserId">登录用户Id</param>
        /// <returns>是否成功</returns>
        public List<User_Model> GetUserListByDeptId(int DeptId, string UserId)
        {
            using (DBContainer db = new DBContainer())
            {
                try
                {
                    string sql = " UP_GetUserList_ByDeptId @DeptId,@UserId";

                    var args = new System.Data.Common.DbParameter[] {
                    new System.Data.SqlClient.SqlParameter { ParameterName = "@DeptId", Value = DeptId},
                    new System.Data.SqlClient.SqlParameter { ParameterName = "@UserId", Value = UserId}
                 };

                    List<User_Model> list = db.ExecuteStoreQuery<User_Model>(sql, args).ToList();

                    return list;
                }
                catch (Exception ex)
                {
                    ExceptionHander.WriteException(ex);
                    return null;
                }
            }
        }

        /// <summary>
        /// 获取部门下属用户
        /// </summary>   
        /// <param name="DeptId">部门Id</param>
        /// <param name="UserId">登录用户Id</param>
        /// <returns>是否成功</returns>
        public List<string> GetUserIdListByDeptId(int DeptId, string UserId)
        {
            List<User_Model> userList = GetUserListByDeptId(DeptId, UserId);
            List<string> userIdList = new List<string>();

            foreach (User_Model model in userList)
            {
                userIdList.Add(model.UserId);
            }
            return userIdList;
        }