DotNet.Business/DataAccess/Manager/BaseOrganizeManager.Role.cs

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

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

//-----------------------------------------------------------------
// All Rights Reserved , Copyright (C) 2014 , Hairihan TECH, Ltd. 
//-----------------------------------------------------------------

using System;
using System.Data;
using System.Data.Common;
using System.Collections.Generic;
using System.Configuration;
using System.Linq;

namespace DotNet.Business
{
    using DotNet.Utilities;

    /// <summary>
    /// BaseOrganizeManager（程序OK）
    /// 组织机构、部门表
    ///
    /// 修改记录
    ///     
    ///		2014.04.15 版本：1.0 JiRiGaLa	有些思想进行了改进。
    ///
    /// <author>
    ///		<name>JiRiGaLa</name>
    ///		<date>2014.04.15</date>
    /// </author>
    /// </summary>
    public partial class BaseOrganizeManager : BaseManager //, IBaseOrganizeManager
    {
        #region public string[] GetOrganizeIdsInRole(string roleId) 按角色主键获得组织机构主键数组
        /// <summary>
        /// 按角色主键获得组织机构主键数组
        /// </summary>
        /// <param name="roleId">角色主键</param>
        /// <returns>主键数组</returns>
        public string[] GetOrganizeIdsInRole(string roleId)
        {
            string tableName = UserInfo.SystemCode + "RoleOrganize";

            // 需要显示未被删除的用户
            string sqlQuery = "SELECT OrganizeId FROM " + tableName + " WHERE (RoleId = " + roleId + ") "
                              + " AND (OrganizeId IN (SELECT Id FROM BaseOrganize WHERE (DeletionStateCode = 0))) AND (DeletionStateCode = 0) ";
            var dt = DbHelper.Fill(sqlQuery);
            return BaseBusinessLogic.FieldToArray(dt, BaseRoleOrganizeEntity.FieldOrganizeId).Distinct<string>().Where(t => !string.IsNullOrEmpty(t)).ToArray();
        }
        #endregion

        string GetSqlQueryByRole(string[] roleIds)
        {
            string tableNameRoleOrganize = UserInfo.SystemCode + "RoleOrganize";

            string sqlQuery = "SELECT * FROM " + BaseOrganizeEntity.TableName
                            + " WHERE " + BaseOrganizeEntity.FieldEnabled + " = 1 "
                            + "       AND " + BaseOrganizeEntity.FieldDeletionStateCode + "= 0 "
                            + "       AND ( " + BaseOrganizeEntity.FieldId + " IN "
                            + "           (SELECT  " + BaseRoleOrganizeEntity.FieldOrganizeId
                            + "              FROM " + tableNameRoleOrganize
                            + "             WHERE " + BaseRoleOrganizeEntity.FieldRoleId + " IN (" + string.Join(",", roleIds) + ")"
                            + "               AND " + BaseRoleOrganizeEntity.FieldEnabled + " = 1"