Dao/UserRoleRepository.cs

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

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

using Domain;
using IDao;
using Entity.Common;
using System;
using System.Collections.Generic;
using System.Globalization;
using System.Linq;
using System.Text;
using Common;
using PWMIS.DataMap.Entity;
using System.Data;
using System.Data.SqlClient;
using PWMIS.DataProvider.Data;
using PWMIS.DataProvider.Adapter;

namespace Dao
{
    /// <summary>
    /// 用户角色关系表 仓储
    /// </summary>
    public class UserRoleRepository : Repository<UserRoleMdl>, IUserRoleRepository
    {
        public void InsertUserRole(UserRoleMdl mol)
        {
            OQL q = new OQL(mol);
            OQL query = q.Insert(mol.Role_ID, mol.User_ID).End;
            PWMIS.DataProvider.Data.AdoHelper db = PWMIS.DataProvider.Adapter.MyDB.GetDBHelper();
            int result = EntityQuery<UserRoleMdl>.ExecuteOql(query, db);
            if (result <= 0)
                throw new ArgumentException("SQL语句执行失败.");
        }

        /// <summary>
        /// 动态获取用户角色
        /// </summary>
        /// <param name="option"></param>
        /// <returns></returns>
        public List<UserRoleMdl> GetDynamicList(CommonQueryOption option)
        {
            UserRoleMdl mol = new UserRoleMdl();
            OQL q = new OQL(mol);
            OQLCompareFunc cmpFun = cmp =>
            {
                OQLCompare cmpResult = new OQLCompare(q);
                cmpResult = cmp.Comparer(mol.ID, OQLCompare.CompareType.NotEqual, 0);
                if (!string.IsNullOrEmpty(option._Name))
                    cmpResult = cmpResult & cmp.Comparer(mol.User_ID, "=", option._UserID);
                if (!string.IsNullOrEmpty(option._Status))
                    cmpResult = cmpResult & cmp.Comparer(mol.Role_ID, "=", option._ID.ToValue<int>());
                return cmpResult;
            };
            var query = q.Select().Where(cmpFun).END;
            var lstMol = EntityQuery<UserRoleMdl>.QueryList(query).ToList();
            return lstMol;
        }

        /// <summary>
        /// 获取员工角色CODE
        /// </summary>
        /// <param name="userid"></param>