using Rhea.Common;
|
using SqlSugar;
|
using System;
|
using System.Collections.Generic;
|
using System.ComponentModel;
|
using System.Linq;
|
using System.Text;
|
using System.Text.RegularExpressions;
|
using System.Threading.Tasks;
|
using Tiger.Model;
|
|
namespace Tiger.IBusiness
|
{
|
/// <summary>
|
/// SqlSugar 扩展方法
|
/// </summary>
|
public static class DbExtension
|
{
|
/// <summary>
|
/// 通过授权查询数据
|
/// </summary>
|
/// <typeparam name="T"></typeparam>
|
/// <param name="queryable"></param>
|
/// <param name="userId"></param>
|
/// <param name="options"></param>
|
/// <returns></returns>
|
public static ISugarQueryable<T> ByAuth<T>(this ISugarQueryable<T> queryable, string userId, DbAuth options) where T : iTableHasAuth, new()
|
{
|
//组织机构授权验证
|
if (options.HasFlag(DbAuth.Org) && !typeof(T).GetProperty("AUTH_ORG").IsNullOrEmpty())
|
{
|
queryable = queryable.Where(q => SqlFunc.Subqueryable<V_USER_ORG>().Where(authorization => authorization.USER_ID == userId && authorization.ORG_CODE == q.AUTH_ORG).Any());
|
}
|
//生产单元授权验证
|
if (options.HasFlag(DbAuth.Prod) && !typeof(T).GetProperty("AUTH_PROD").IsNullOrEmpty())
|
{
|
queryable = queryable.Where(q => SqlFunc.Subqueryable<V_USER_PROD>().Where(authorization => authorization.USER_ID == userId && authorization.PROD_CODE == q.AUTH_PROD).Any());
|
}
|
//仓库单元授权验证
|
if (options.HasFlag(DbAuth.Wh) && !typeof(T).GetProperty("AUTH_WH").IsNullOrEmpty())
|
{
|
queryable = queryable.Where(q => SqlFunc.Subqueryable<V_USER_WH>().Where(authorization => authorization.USER_ID == userId && authorization.WH_CODE == q.AUTH_WH).Any());
|
}
|
|
return queryable;
|
}
|
|
/// <summary>
|
/// 通过授权查询数据
|
/// </summary>
|
/// <typeparam name="T"></typeparam>
|
/// <param name="queryable"></param>
|
/// <param name="options"></param>
|
/// <returns></returns>
|
public static ISugarQueryable<T> ByAuth<T>(this ISugarQueryable<T> queryable, AuthOption options) where T : iTableHasAuth, new()
|
{
|
options.OrgCode = options.OrgCode.IsNullOrEmpty(options.CurOrg);
|
//组织机构授权验证
|
if (!options.OrgCode.IsNullOrEmpty() && !typeof(T).GetProperty("AUTH_ORG").IsNullOrEmpty())
|
{
|
var orgList = options.OrgCode.Split(",", StringSplitOptions.RemoveEmptyEntries);
|
queryable = queryable.Where(q => orgList.Any(authorization => authorization == q.AUTH_ORG));
|
}
|
//生产单元授权验证
|
if (!options.ProdCode.IsNullOrEmpty() && !typeof(T).GetProperty("AUTH_PROD").IsNullOrEmpty())
|
{
|
var prodList = options.ProdCode.Split(",", StringSplitOptions.RemoveEmptyEntries).ToList();
|
queryable = queryable.Where(q => prodList.Any(authorization => authorization == q.AUTH_PROD));
|
}
|
//仓库单元授权验证
|
if (!options.WhCode.IsNullOrEmpty() && !typeof(T).GetProperty("AUTH_WH").IsNullOrEmpty())
|
{
|
var whList = options.WhCode.Split(",", StringSplitOptions.RemoveEmptyEntries).ToList();
|
queryable = queryable.Where(q => whList.Any(authorization => authorization == q.AUTH_WH));
|
}
|
return queryable.ByAuth(options.UserId, options.GetOptions());
|
}
|
|
/// <summary>
|
/// 通过授权查询数据<br/>
|
/// 注意：联表授权查询时，主表的别名必须为q，不然会出错
|
/// </summary>
|
/// <typeparam name="T"></typeparam>
|
/// <typeparam name="T2"></typeparam>
|
/// <param name="queryable"></param>
|
/// <param name="userId"></param>
|
/// <param name="options"></param>
|
/// <returns></returns>
|
public static ISugarQueryable<T, T2> ByAuth<T, T2>(this ISugarQueryable<T,T2> queryable, string userId, DbAuth options) where T : iTableHasAuth, new()
|
{
|
//组织机构授权验证
|
if (options.HasFlag(DbAuth.Org) && !typeof(T).GetProperty("AUTH_ORG").IsNullOrEmpty())
|
{
|
queryable = queryable.Where(q => SqlFunc.Subqueryable<V_USER_ORG>().Where(authorization => authorization.USER_ID == userId && authorization.ORG_CODE == q.AUTH_ORG).Any());
|
}
|
//生产单元授权验证
|
if (options.HasFlag(DbAuth.Prod) && !typeof(T).GetProperty("AUTH_PROD").IsNullOrEmpty())
|
{
|
queryable = queryable.Where(q => SqlFunc.Subqueryable<V_USER_PROD>().Where(authorization => authorization.USER_ID == userId && authorization.PROD_CODE == q.AUTH_PROD).Any());
|
}
|
//仓库单元授权验证
|
if (options.HasFlag(DbAuth.Wh) && !typeof(T).GetProperty("AUTH_WH").IsNullOrEmpty())
|
{
|
queryable = queryable.Where(q => SqlFunc.Subqueryable<V_USER_WH>().Where(authorization => authorization.USER_ID == userId && authorization.WH_CODE == q.AUTH_WH).Any());
|
}
|
|
return queryable;
|
}
|
|
/// <summary>
|
/// 通过授权查询数据<br/>
|
/// 注意：联表授权查询时，主表的别名必须为q，不然会出错
|
/// </summary>
|
/// <typeparam name="T"></typeparam>
|
/// <typeparam name="T2"></typeparam>
|
/// <param name="queryable"></param>
|
/// <param name="options"></param>
|
/// <returns></returns>
|
public static ISugarQueryable<T, T2> ByAuth<T, T2>(this ISugarQueryable<T, T2> queryable, AuthOption options) where T : iTableHasAuth, new()
|
{
|
//组织机构授权验证
|
if (!options.OrgCode.IsNullOrEmpty() && !typeof(T).GetProperty("AUTH_ORG").IsNullOrEmpty())
|
{
|
var orgList = options.OrgCode.Split(",", StringSplitOptions.RemoveEmptyEntries);
|
queryable = queryable.Where(q => orgList.Any(authorization => authorization == q.AUTH_ORG));
|
}
|
//生产单元授权验证
|
if (!options.ProdCode.IsNullOrEmpty() && !typeof(T).GetProperty("AUTH_PROD").IsNullOrEmpty())
|
{
|
var prodList = options.ProdCode.Split(",", StringSplitOptions.RemoveEmptyEntries).ToList();
|
queryable = queryable.Where(q => prodList.Any(authorization => authorization == q.AUTH_PROD));
|
}
|
//仓库单元授权验证
|
if (!options.WhCode.IsNullOrEmpty() && !typeof(T).GetProperty("AUTH_WH").IsNullOrEmpty())
|
{
|
var whList = options.WhCode.Split(",", StringSplitOptions.RemoveEmptyEntries).ToList();
|
queryable = queryable.Where(q => whList.Any(authorization => authorization == q.AUTH_WH));
|
}
|
return queryable.ByAuth(options.UserId, options.GetOptions());
|
}
|
|
/// <summary>
|
/// 通过授权查询数据<br/>
|
/// 注意：联表授权查询时，主表的别名必须为q，不然会出错
|
/// </summary>
|
/// <typeparam name="T"></typeparam>
|
/// <param name="queryable"></param>
|
/// <param name="userId"></param>
|
/// <param name="options"></param>
|
/// <returns></returns>
|
public static ISugarQueryable<T, T2, T3> ByAuth<T, T2, T3>(this ISugarQueryable<T, T2, T3> queryable, string userId, DbAuth options) where T : iTableHasAuth, new()
|
{
|
//组织机构授权验证
|
if (options.HasFlag(DbAuth.Org) && !typeof(T).GetProperty("AUTH_ORG").IsNullOrEmpty())
|
{
|
queryable = queryable.Where(q => SqlFunc.Subqueryable<V_USER_ORG>().Where(authorization => authorization.USER_ID == userId && authorization.ORG_CODE == q.AUTH_ORG).Any());
|
}
|
//生产单元授权验证
|
if (options.HasFlag(DbAuth.Prod) && !typeof(T).GetProperty("AUTH_PROD").IsNullOrEmpty())
|
{
|
queryable = queryable.Where(q => SqlFunc.Subqueryable<V_USER_PROD>().Where(authorization => authorization.USER_ID == userId && authorization.PROD_CODE == q.AUTH_PROD).Any());
|
}
|
//仓库单元授权验证
|
if (options.HasFlag(DbAuth.Wh) && !typeof(T).GetProperty("AUTH_WH").IsNullOrEmpty())
|
{
|
queryable = queryable.Where(q => SqlFunc.Subqueryable<V_USER_WH>().Where(authorization => authorization.USER_ID == userId && authorization.WH_CODE == q.AUTH_WH).Any());
|
}
|
|
return queryable;
|
}
|
|
/// <summary>
|
/// 通过授权查询数据<br/>
|
/// 注意：联表授权查询时，主表的别名必须为q，不然会出错
|
/// </summary>
|
/// <typeparam name="T"></typeparam>
|
/// <param name="queryable"></param>
|
/// <param name="options"></param>
|
/// <returns></returns>
|
public static ISugarQueryable<T, T2, T3> ByAuth<T, T2, T3>(this ISugarQueryable<T, T2, T3> queryable, AuthOption options) where T : iTableHasAuth, new()
|
{
|
//组织机构授权验证
|
if (!options.OrgCode.IsNullOrEmpty() && !typeof(T).GetProperty("AUTH_ORG").IsNullOrEmpty())
|
{
|
var orgList = options.OrgCode.Split(",", StringSplitOptions.RemoveEmptyEntries);
|
queryable = queryable.Where(q => orgList.Any(authorization => authorization == q.AUTH_ORG));
|
}
|
//生产单元授权验证
|
if (!options.ProdCode.IsNullOrEmpty() && !typeof(T).GetProperty("AUTH_PROD").IsNullOrEmpty())
|
{
|
var prodList = options.ProdCode.Split(",", StringSplitOptions.RemoveEmptyEntries).ToList();
|
queryable = queryable.Where(q => prodList.Any(authorization => authorization == q.AUTH_PROD));
|
}
|
//仓库单元授权验证
|
if (!options.WhCode.IsNullOrEmpty() && !typeof(T).GetProperty("AUTH_WH").IsNullOrEmpty())
|
{
|
var whList = options.WhCode.Split(",", StringSplitOptions.RemoveEmptyEntries).ToList();
|
queryable = queryable.Where(q => whList.Any(authorization => authorization == q.AUTH_WH));
|
}
|
return queryable.ByAuth(options.UserId, options.GetOptions());
|
}
|
|
/// <summary>
|
/// 通过授权查询数据<br/>
|
/// 注意：联表授权查询时，主表的别名必须为q，不然会出错
|
/// </summary>
|
/// <typeparam name="T"></typeparam>
|
/// <param name="queryable"></param>
|
/// <param name="userId"></param>
|
/// <param name="options"></param>
|
/// <returns></returns>
|
public static ISugarQueryable<T, T2, T3, T4> ByAuth<T, T2, T3, T4>(this ISugarQueryable<T, T2, T3, T4> queryable, string userId, DbAuth options) where T : iTableHasAuth, new()
|
{
|
//组织机构授权验证
|
if (options.HasFlag(DbAuth.Org) && !typeof(T).GetProperty("AUTH_ORG").IsNullOrEmpty())
|
{
|
queryable = queryable.Where(q => SqlFunc.Subqueryable<V_USER_ORG>().Where(authorization => authorization.USER_ID == userId && authorization.ORG_CODE == q.AUTH_ORG).Any());
|
}
|
//生产单元授权验证
|
if (options.HasFlag(DbAuth.Prod) && !typeof(T).GetProperty("AUTH_PROD").IsNullOrEmpty())
|
{
|
queryable = queryable.Where(q => SqlFunc.Subqueryable<V_USER_PROD>().Where(authorization => authorization.USER_ID == userId && authorization.PROD_CODE == q.AUTH_PROD).Any());
|
}
|
//仓库单元授权验证
|
if (options.HasFlag(DbAuth.Wh) && !typeof(T).GetProperty("AUTH_WH").IsNullOrEmpty())
|
{
|
queryable = queryable.Where(q => SqlFunc.Subqueryable<V_USER_WH>().Where(authorization => authorization.USER_ID == userId && authorization.WH_CODE == q.AUTH_WH).Any());
|
}
|
|
return queryable;
|
}
|
|
/// <summary>
|
/// 通过授权查询数据<br/>
|
/// 注意：联表授权查询时，主表的别名必须为q，不然会出错
|
/// </summary>
|
/// <typeparam name="T"></typeparam>
|
/// <param name="queryable"></param>
|
/// <param name="options"></param>
|
/// <returns></returns>
|
public static ISugarQueryable<T, T2, T3, T4> ByAuth<T, T2, T3, T4>(this ISugarQueryable<T, T2, T3, T4> queryable, AuthOption options) where T : iTableHasAuth, new()
|
{
|
//组织机构授权验证
|
if (!options.OrgCode.IsNullOrEmpty() && !typeof(T).GetProperty("AUTH_ORG").IsNullOrEmpty())
|
{
|
var orgList = options.OrgCode.Split(",", StringSplitOptions.RemoveEmptyEntries);
|
queryable = queryable.Where(q => orgList.Any(authorization => authorization == q.AUTH_ORG));
|
}
|
//生产单元授权验证
|
if (!options.ProdCode.IsNullOrEmpty() && !typeof(T).GetProperty("AUTH_PROD").IsNullOrEmpty())
|
{
|
var prodList = options.ProdCode.Split(",", StringSplitOptions.RemoveEmptyEntries).ToList();
|
queryable = queryable.Where(q => prodList.Any(authorization => authorization == q.AUTH_PROD));
|
}
|
//仓库单元授权验证
|
if (!options.WhCode.IsNullOrEmpty() && !typeof(T).GetProperty("AUTH_WH").IsNullOrEmpty())
|
{
|
var whList = options.WhCode.Split(",", StringSplitOptions.RemoveEmptyEntries).ToList();
|
queryable = queryable.Where(q => whList.Any(authorization => authorization == q.AUTH_WH));
|
}
|
return queryable.ByAuth(options.UserId, options.GetOptions());
|
}
|
|
/// <summary>
|
/// 通过授权查询数据<br/>
|
/// 注意：联表授权查询时，主表的别名必须为q，不然会出错
|
/// </summary>
|
/// <typeparam name="T"></typeparam>
|
/// <param name="queryable"></param>
|
/// <param name="userId"></param>
|
/// <param name="options"></param>
|
/// <returns></returns>
|
public static ISugarQueryable<T, T2, T3, T4, T5> ByAuth<T, T2, T3, T4, T5>(this ISugarQueryable<T, T2, T3, T4, T5> queryable, string userId, DbAuth options) where T : iTableHasAuth, new()
|
{
|
//组织机构授权验证
|
if (options.HasFlag(DbAuth.Org) && !typeof(T).GetProperty("AUTH_ORG").IsNullOrEmpty())
|
{
|
queryable = queryable.Where(q => SqlFunc.Subqueryable<V_USER_ORG>().Where(authorization => authorization.USER_ID == userId && authorization.ORG_CODE == q.AUTH_ORG).Any());
|
}
|
//生产单元授权验证
|
if (options.HasFlag(DbAuth.Prod) && !typeof(T).GetProperty("AUTH_PROD").IsNullOrEmpty())
|
{
|
queryable = queryable.Where(q => SqlFunc.Subqueryable<V_USER_PROD>().Where(authorization => authorization.USER_ID == userId && authorization.PROD_CODE == q.AUTH_PROD).Any());
|
}
|
//仓库单元授权验证
|
if (options.HasFlag(DbAuth.Wh) && !typeof(T).GetProperty("AUTH_WH").IsNullOrEmpty())
|
{
|
queryable = queryable.Where(q => SqlFunc.Subqueryable<V_USER_WH>().Where(authorization => authorization.USER_ID == userId && authorization.WH_CODE == q.AUTH_WH).Any());
|
}
|
|
return queryable;
|
}
|
|
/// <summary>
|
/// 通过授权查询数据<br/>
|
/// 注意：联表授权查询时，主表的别名必须为q，不然会出错
|
/// </summary>
|
/// <typeparam name="T"></typeparam>
|
/// <param name="queryable"></param>
|
/// <param name="options"></param>
|
/// <returns></returns>
|
public static ISugarQueryable<T, T2, T3, T4, T5> ByAuth<T, T2, T3, T4, T5>(this ISugarQueryable<T, T2, T3, T4, T5> queryable, AuthOption options) where T : iTableHasAuth, new()
|
{
|
//组织机构授权验证
|
if (!options.OrgCode.IsNullOrEmpty() && !typeof(T).GetProperty("AUTH_ORG").IsNullOrEmpty())
|
{
|
var orgList = options.OrgCode.Split(",", StringSplitOptions.RemoveEmptyEntries);
|
queryable = queryable.Where(q => orgList.Any(authorization => authorization == q.AUTH_ORG));
|
}
|
//生产单元授权验证
|
if (!options.ProdCode.IsNullOrEmpty() && !typeof(T).GetProperty("AUTH_PROD").IsNullOrEmpty())
|
{
|
var prodList = options.ProdCode.Split(",", StringSplitOptions.RemoveEmptyEntries).ToList();
|
queryable = queryable.Where(q => prodList.Any(authorization => authorization == q.AUTH_PROD));
|
}
|
//仓库单元授权验证
|
if (!options.WhCode.IsNullOrEmpty() && !typeof(T).GetProperty("AUTH_WH").IsNullOrEmpty())
|
{
|
var whList = options.WhCode.Split(",", StringSplitOptions.RemoveEmptyEntries).ToList();
|
queryable = queryable.Where(q => whList.Any(authorization => authorization == q.AUTH_WH));
|
}
|
return queryable.ByAuth(options.UserId, options.GetOptions());
|
}
|
|
/// <summary>
|
/// 通过授权查询数据<br/>
|
/// 注意：联表授权查询时，主表的别名必须为q，不然会出错
|
/// </summary>
|
/// <typeparam name="T"></typeparam>
|
/// <param name="queryable"></param>
|
/// <param name="userId"></param>
|
/// <param name="options"></param>
|
/// <returns></returns>
|
public static ISugarQueryable<T, T2, T3, T4, T5, T6> ByAuth<T, T2, T3, T4, T5, T6>(this ISugarQueryable<T, T2, T3, T4, T5, T6> queryable, string userId, DbAuth options) where T : iTableHasAuth, new()
|
{
|
//组织机构授权验证
|
if (options.HasFlag(DbAuth.Org) && !typeof(T).GetProperty("AUTH_ORG").IsNullOrEmpty())
|
{
|
queryable = queryable.Where(q => SqlFunc.Subqueryable<V_USER_ORG>().Where(authorization => authorization.USER_ID == userId && authorization.ORG_CODE == q.AUTH_ORG).Any());
|
}
|
//生产单元授权验证
|
if (options.HasFlag(DbAuth.Prod) && !typeof(T).GetProperty("AUTH_PROD").IsNullOrEmpty())
|
{
|
queryable = queryable.Where(q => SqlFunc.Subqueryable<V_USER_PROD>().Where(authorization => authorization.USER_ID == userId && authorization.PROD_CODE == q.AUTH_PROD).Any());
|
}
|
//仓库单元授权验证
|
if (options.HasFlag(DbAuth.Wh) && !typeof(T).GetProperty("AUTH_WH").IsNullOrEmpty())
|
{
|
queryable = queryable.Where(q => SqlFunc.Subqueryable<V_USER_WH>().Where(authorization => authorization.USER_ID == userId && authorization.WH_CODE == q.AUTH_WH).Any());
|
}
|
|
return queryable;
|
}
|
|
/// <summary>
|
/// 通过授权查询数据<br/>
|
/// 注意：联表授权查询时，主表的别名必须为q，不然会出错
|
/// </summary>
|
/// <typeparam name="T"></typeparam>
|
/// <param name="queryable"></param>
|
/// <param name="options"></param>
|
/// <returns></returns>
|
public static ISugarQueryable<T, T2, T3, T4, T5, T6> ByAuth<T, T2, T3, T4, T5, T6>(this ISugarQueryable<T, T2, T3, T4, T5, T6> queryable, AuthOption options) where T : iTableHasAuth, new()
|
{
|
//组织机构授权验证
|
if (!options.OrgCode.IsNullOrEmpty() && !typeof(T).GetProperty("AUTH_ORG").IsNullOrEmpty())
|
{
|
var orgList = options.OrgCode.Split(",", StringSplitOptions.RemoveEmptyEntries);
|
queryable = queryable.Where(q => orgList.Any(authorization => authorization == q.AUTH_ORG));
|
}
|
//生产单元授权验证
|
if (!options.ProdCode.IsNullOrEmpty() && !typeof(T).GetProperty("AUTH_PROD").IsNullOrEmpty())
|
{
|
var prodList = options.ProdCode.Split(",", StringSplitOptions.RemoveEmptyEntries).ToList();
|
queryable = queryable.Where(q => prodList.Any(authorization => authorization == q.AUTH_PROD));
|
}
|
//仓库单元授权验证
|
if (!options.WhCode.IsNullOrEmpty() && !typeof(T).GetProperty("AUTH_WH").IsNullOrEmpty())
|
{
|
var whList = options.WhCode.Split(",", StringSplitOptions.RemoveEmptyEntries).ToList();
|
queryable = queryable.Where(q => whList.Any(authorization => authorization == q.AUTH_WH));
|
}
|
return queryable.ByAuth(options.UserId, options.GetOptions());
|
}
|
|
/// <summary>
|
/// 通过授权查询数据<br/>
|
/// 注意：联表授权查询时，主表的别名必须为q，不然会出错
|
/// </summary>
|
/// <typeparam name="T"></typeparam>
|
/// <param name="queryable"></param>
|
/// <param name="userId"></param>
|
/// <param name="options"></param>
|
/// <returns></returns>
|
public static ISugarQueryable<T, T2, T3, T4, T5, T6, T7> ByAuth<T, T2, T3, T4, T5, T6, T7>(this ISugarQueryable<T, T2, T3, T4, T5, T6, T7> queryable, string userId, DbAuth options) where T : iTableHasAuth, new()
|
{
|
//组织机构授权验证
|
if (options.HasFlag(DbAuth.Org) && !typeof(T).GetProperty("AUTH_ORG").IsNullOrEmpty())
|
{
|
queryable = queryable.Where(q => SqlFunc.Subqueryable<V_USER_ORG>().Where(authorization => authorization.USER_ID == userId && authorization.ORG_CODE == q.AUTH_ORG).Any());
|
}
|
//生产单元授权验证
|
if (options.HasFlag(DbAuth.Prod) && !typeof(T).GetProperty("AUTH_PROD").IsNullOrEmpty())
|
{
|
queryable = queryable.Where(q => SqlFunc.Subqueryable<V_USER_PROD>().Where(authorization => authorization.USER_ID == userId && authorization.PROD_CODE == q.AUTH_PROD).Any());
|
}
|
//仓库单元授权验证
|
if (options.HasFlag(DbAuth.Wh) && !typeof(T).GetProperty("AUTH_WH").IsNullOrEmpty())
|
{
|
queryable = queryable.Where(q => SqlFunc.Subqueryable<V_USER_WH>().Where(authorization => authorization.USER_ID == userId && authorization.WH_CODE == q.AUTH_WH).Any());
|
}
|
|
return queryable;
|
}
|
|
/// <summary>
|
/// 通过授权查询数据<br/>
|
/// 注意：联表授权查询时，主表的别名必须为q，不然会出错
|
/// </summary>
|
/// <typeparam name="T"></typeparam>
|
/// <param name="queryable"></param>
|
/// <param name="options"></param>
|
/// <returns></returns>
|
public static ISugarQueryable<T, T2, T3, T4, T5, T6, T7> ByAuth<T, T2, T3, T4, T5, T6, T7>(this ISugarQueryable<T, T2, T3, T4, T5, T6, T7> queryable, AuthOption options) where T : iTableHasAuth, new()
|
{
|
//组织机构授权验证
|
if (!options.OrgCode.IsNullOrEmpty() && !typeof(T).GetProperty("AUTH_ORG").IsNullOrEmpty())
|
{
|
var orgList = options.OrgCode.Split(",", StringSplitOptions.RemoveEmptyEntries);
|
queryable = queryable.Where(q => orgList.Any(authorization => authorization == q.AUTH_ORG));
|
}
|
//生产单元授权验证
|
if (!options.ProdCode.IsNullOrEmpty() && !typeof(T).GetProperty("AUTH_PROD").IsNullOrEmpty())
|
{
|
var prodList = options.ProdCode.Split(",", StringSplitOptions.RemoveEmptyEntries).ToList();
|
queryable = queryable.Where(q => prodList.Any(authorization => authorization == q.AUTH_PROD));
|
}
|
//仓库单元授权验证
|
if (!options.WhCode.IsNullOrEmpty() && !typeof(T).GetProperty("AUTH_WH").IsNullOrEmpty())
|
{
|
var whList = options.WhCode.Split(",", StringSplitOptions.RemoveEmptyEntries).ToList();
|
queryable = queryable.Where(q => whList.Any(authorization => authorization == q.AUTH_WH));
|
}
|
return queryable.ByAuth(options.UserId, options.GetOptions());
|
}
|
|
/// <summary>
|
/// 通过授权查询数据<br/>
|
/// 注意：联表授权查询时，主表的别名必须为q，不然会出错
|
/// </summary>
|
/// <typeparam name="T"></typeparam>
|
/// <param name="queryable"></param>
|
/// <param name="userId"></param>
|
/// <param name="options"></param>
|
/// <returns></returns>
|
public static ISugarQueryable<T, T2, T3, T4, T5, T6, T7, T8> ByAuth<T, T2, T3, T4, T5, T6, T7, T8>(this ISugarQueryable<T, T2, T3, T4, T5, T6, T7, T8> queryable, string userId, DbAuth options) where T : iTableHasAuth, new()
|
{
|
//组织机构授权验证
|
if (options.HasFlag(DbAuth.Org) && !typeof(T).GetProperty("AUTH_ORG").IsNullOrEmpty())
|
{
|
queryable = queryable.Where(q => SqlFunc.Subqueryable<V_USER_ORG>().Where(authorization => authorization.USER_ID == userId && authorization.ORG_CODE == q.AUTH_ORG).Any());
|
}
|
//生产单元授权验证
|
if (options.HasFlag(DbAuth.Prod) && !typeof(T).GetProperty("AUTH_PROD").IsNullOrEmpty())
|
{
|
queryable = queryable.Where(q => SqlFunc.Subqueryable<V_USER_PROD>().Where(authorization => authorization.USER_ID == userId && authorization.PROD_CODE == q.AUTH_PROD).Any());
|
}
|
//仓库单元授权验证
|
if (options.HasFlag(DbAuth.Wh) && !typeof(T).GetProperty("AUTH_WH").IsNullOrEmpty())
|
{
|
queryable = queryable.Where(q => SqlFunc.Subqueryable<V_USER_WH>().Where(authorization => authorization.USER_ID == userId && authorization.WH_CODE == q.AUTH_WH).Any());
|
}
|
|
return queryable;
|
}
|
|
/// <summary>
|
/// 通过授权查询数据<br/>
|
/// 注意：联表授权查询时，主表的别名必须为q，不然会出错
|
/// </summary>
|
/// <typeparam name="T"></typeparam>
|
/// <param name="queryable"></param>
|
/// <param name="options"></param>
|
/// <returns></returns>
|
public static ISugarQueryable<T, T2, T3, T4, T5, T6, T7, T8> ByAuth<T, T2, T3, T4, T5, T6, T7, T8>(this ISugarQueryable<T, T2, T3, T4, T5, T6, T7, T8> queryable, AuthOption options) where T : iTableHasAuth, new()
|
{
|
//组织机构授权验证
|
if (!options.OrgCode.IsNullOrEmpty() && !typeof(T).GetProperty("AUTH_ORG").IsNullOrEmpty())
|
{
|
var orgList = options.OrgCode.Split(",", StringSplitOptions.RemoveEmptyEntries);
|
queryable = queryable.Where(q => orgList.Any(authorization => authorization == q.AUTH_ORG));
|
}
|
//生产单元授权验证
|
if (!options.ProdCode.IsNullOrEmpty() && !typeof(T).GetProperty("AUTH_PROD").IsNullOrEmpty())
|
{
|
var prodList = options.ProdCode.Split(",", StringSplitOptions.RemoveEmptyEntries).ToList();
|
queryable = queryable.Where(q => prodList.Any(authorization => authorization == q.AUTH_PROD));
|
}
|
//仓库单元授权验证
|
if (!options.WhCode.IsNullOrEmpty() && !typeof(T).GetProperty("AUTH_WH").IsNullOrEmpty())
|
{
|
var whList = options.WhCode.Split(",", StringSplitOptions.RemoveEmptyEntries).ToList();
|
queryable = queryable.Where(q => whList.Any(authorization => authorization == q.AUTH_WH));
|
}
|
return queryable.ByAuth(options.UserId, options.GetOptions());
|
}
|
|
/// <summary>
|
/// 通过授权查询数据<br/>
|
/// 注意：联表授权查询时，主表的别名必须为q，不然会出错
|
/// </summary>
|
/// <typeparam name="T"></typeparam>
|
/// <param name="queryable"></param>
|
/// <param name="userId"></param>
|
/// <param name="options"></param>
|
/// <returns></returns>
|
public static ISugarQueryable<T, T2, T3, T4, T5, T6, T7, T8, T9> ByAuth<T, T2, T3, T4, T5, T6, T7, T8, T9>(this ISugarQueryable<T, T2, T3, T4, T5, T6, T7, T8, T9> queryable, string userId, DbAuth options) where T : iTableHasAuth, new()
|
{
|
//组织机构授权验证
|
if (options.HasFlag(DbAuth.Org) && !typeof(T).GetProperty("AUTH_ORG").IsNullOrEmpty())
|
{
|
queryable = queryable.Where(q => SqlFunc.Subqueryable<V_USER_ORG>().Where(authorization => authorization.USER_ID == userId && authorization.ORG_CODE == q.AUTH_ORG).Any());
|
}
|
//生产单元授权验证
|
if (options.HasFlag(DbAuth.Prod) && !typeof(T).GetProperty("AUTH_PROD").IsNullOrEmpty())
|
{
|
queryable = queryable.Where(q => SqlFunc.Subqueryable<V_USER_PROD>().Where(authorization => authorization.USER_ID == userId && authorization.PROD_CODE == q.AUTH_PROD).Any());
|
}
|
//仓库单元授权验证
|
if (options.HasFlag(DbAuth.Wh) && !typeof(T).GetProperty("AUTH_WH").IsNullOrEmpty())
|
{
|
queryable = queryable.Where(q => SqlFunc.Subqueryable<V_USER_WH>().Where(authorization => authorization.USER_ID == userId && authorization.WH_CODE == q.AUTH_WH).Any());
|
}
|
|
return queryable;
|
}
|
|
/// <summary>
|
/// 通过授权查询数据<br/>
|
/// 注意：联表授权查询时，主表的别名必须为q，不然会出错
|
/// </summary>
|
/// <typeparam name="T"></typeparam>
|
/// <param name="queryable"></param>
|
/// <param name="options"></param>
|
/// <returns></returns>
|
public static ISugarQueryable<T, T2, T3, T4, T5, T6, T7, T8, T9> ByAuth<T, T2, T3, T4, T5, T6, T7, T8, T9>(this ISugarQueryable<T, T2, T3, T4, T5, T6, T7, T8, T9> queryable, AuthOption options) where T : iTableHasAuth, new()
|
{
|
//组织机构授权验证
|
if (!options.OrgCode.IsNullOrEmpty() && !typeof(T).GetProperty("AUTH_ORG").IsNullOrEmpty())
|
{
|
var orgList = options.OrgCode.Split(",", StringSplitOptions.RemoveEmptyEntries);
|
queryable = queryable.Where(q => orgList.Any(authorization => authorization == q.AUTH_ORG));
|
}
|
//生产单元授权验证
|
if (!options.ProdCode.IsNullOrEmpty() && !typeof(T).GetProperty("AUTH_PROD").IsNullOrEmpty())
|
{
|
var prodList = options.ProdCode.Split(",", StringSplitOptions.RemoveEmptyEntries).ToList();
|
queryable = queryable.Where(q => prodList.Any(authorization => authorization == q.AUTH_PROD));
|
}
|
//仓库单元授权验证
|
if (!options.WhCode.IsNullOrEmpty() && !typeof(T).GetProperty("AUTH_WH").IsNullOrEmpty())
|
{
|
var whList = options.WhCode.Split(",", StringSplitOptions.RemoveEmptyEntries).ToList();
|
queryable = queryable.Where(q => whList.Any(authorization => authorization == q.AUTH_WH));
|
}
|
return queryable.ByAuth(options.UserId, options.GetOptions());
|
}
|
|
/// <summary>
|
/// 通过授权查询数据<br/>
|
/// 注意：联表授权查询时，主表的别名必须为q，不然会出错
|
/// </summary>
|
/// <typeparam name="T"></typeparam>
|
/// <param name="queryable"></param>
|
/// <param name="userId"></param>
|
/// <param name="options"></param>
|
/// <returns></returns>
|
public static ISugarQueryable<T, T2, T3, T4, T5, T6, T7, T8, T9, T10> ByAuth<T, T2, T3, T4, T5, T6, T7, T8, T9, T10>(this ISugarQueryable<T, T2, T3, T4, T5, T6, T7, T8, T9, T10> queryable, string userId, DbAuth options) where T : iTableHasAuth, new()
|
{
|
//组织机构授权验证
|
if (options.HasFlag(DbAuth.Org) && !typeof(T).GetProperty("AUTH_ORG").IsNullOrEmpty())
|
{
|
queryable = queryable.Where(q => SqlFunc.Subqueryable<V_USER_ORG>().Where(authorization => authorization.USER_ID == userId && authorization.ORG_CODE == q.AUTH_ORG).Any());
|
}
|
//生产单元授权验证
|
if (options.HasFlag(DbAuth.Prod) && !typeof(T).GetProperty("AUTH_PROD").IsNullOrEmpty())
|
{
|
queryable = queryable.Where(q => SqlFunc.Subqueryable<V_USER_PROD>().Where(authorization => authorization.USER_ID == userId && authorization.PROD_CODE == q.AUTH_PROD).Any());
|
}
|
//仓库单元授权验证
|
if (options.HasFlag(DbAuth.Wh) && !typeof(T).GetProperty("AUTH_WH").IsNullOrEmpty())
|
{
|
queryable = queryable.Where(q => SqlFunc.Subqueryable<V_USER_WH>().Where(authorization => authorization.USER_ID == userId && authorization.WH_CODE == q.AUTH_WH).Any());
|
}
|
|
return queryable;
|
}
|
|
/// <summary>
|
/// 通过授权查询数据<br/>
|
/// 注意：联表授权查询时，主表的别名必须为q，不然会出错
|
/// </summary>
|
/// <typeparam name="T"></typeparam>
|
/// <param name="queryable"></param>
|
/// <param name="options"></param>
|
/// <returns></returns>
|
public static ISugarQueryable<T, T2, T3, T4, T5, T6, T7, T8, T9, T10> ByAuth<T, T2, T3, T4, T5, T6, T7, T8, T9, T10>(this ISugarQueryable<T, T2, T3, T4, T5, T6, T7, T8, T9, T10> queryable, AuthOption options) where T : iTableHasAuth, new()
|
{
|
//组织机构授权验证
|
if (!options.OrgCode.IsNullOrEmpty() && !typeof(T).GetProperty("AUTH_ORG").IsNullOrEmpty())
|
{
|
var orgList = options.OrgCode.Split(",", StringSplitOptions.RemoveEmptyEntries);
|
queryable = queryable.Where(q => orgList.Any(authorization => authorization == q.AUTH_ORG));
|
}
|
//生产单元授权验证
|
if (!options.ProdCode.IsNullOrEmpty() && !typeof(T).GetProperty("AUTH_PROD").IsNullOrEmpty())
|
{
|
var prodList = options.ProdCode.Split(",", StringSplitOptions.RemoveEmptyEntries).ToList();
|
queryable = queryable.Where(q => prodList.Any(authorization => authorization == q.AUTH_PROD));
|
}
|
//仓库单元授权验证
|
if (!options.WhCode.IsNullOrEmpty() && !typeof(T).GetProperty("AUTH_WH").IsNullOrEmpty())
|
{
|
var whList = options.WhCode.Split(",", StringSplitOptions.RemoveEmptyEntries).ToList();
|
queryable = queryable.Where(q => whList.Any(authorization => authorization == q.AUTH_WH));
|
}
|
return queryable.ByAuth(options.UserId, options.GetOptions());
|
}
|
|
/// <summary>
|
/// 通过授权查询数据<br/>
|
/// 注意：联表授权查询时，主表的别名必须为q，不然会出错
|
/// </summary>
|
/// <typeparam name="T"></typeparam>
|
/// <param name="queryable"></param>
|
/// <param name="userId"></param>
|
/// <param name="options"></param>
|
/// <returns></returns>
|
public static ISugarQueryable<T, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> ByAuth<T, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>(this ISugarQueryable<T, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> queryable, string userId, DbAuth options) where T : iTableHasAuth, new()
|
{
|
//组织机构授权验证
|
if (options.HasFlag(DbAuth.Org) && !typeof(T).GetProperty("AUTH_ORG").IsNullOrEmpty())
|
{
|
queryable = queryable.Where(q => SqlFunc.Subqueryable<V_USER_ORG>().Where(authorization => authorization.USER_ID == userId && authorization.ORG_CODE == q.AUTH_ORG).Any());
|
}
|
//生产单元授权验证
|
if (options.HasFlag(DbAuth.Prod) && !typeof(T).GetProperty("AUTH_PROD").IsNullOrEmpty())
|
{
|
queryable = queryable.Where(q => SqlFunc.Subqueryable<V_USER_PROD>().Where(authorization => authorization.USER_ID == userId && authorization.PROD_CODE == q.AUTH_PROD).Any());
|
}
|
//仓库单元授权验证
|
if (options.HasFlag(DbAuth.Wh) && !typeof(T).GetProperty("AUTH_WH").IsNullOrEmpty())
|
{
|
queryable = queryable.Where(q => SqlFunc.Subqueryable<V_USER_WH>().Where(authorization => authorization.USER_ID == userId && authorization.WH_CODE == q.AUTH_WH).Any());
|
}
|
|
return queryable;
|
}
|
|
/// <summary>
|
/// 通过授权查询数据<br/>
|
/// 注意：联表授权查询时，主表的别名必须为q，不然会出错
|
/// </summary>
|
/// <typeparam name="T"></typeparam>
|
/// <param name="queryable"></param>
|
/// <param name="options"></param>
|
/// <returns></returns>
|
public static ISugarQueryable<T, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> ByAuth<T, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>(this ISugarQueryable<T, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> queryable, AuthOption options) where T : iTableHasAuth, new()
|
{
|
//组织机构授权验证
|
if (!options.OrgCode.IsNullOrEmpty() && !typeof(T).GetProperty("AUTH_ORG").IsNullOrEmpty())
|
{
|
var orgList = options.OrgCode.Split(",", StringSplitOptions.RemoveEmptyEntries);
|
queryable = queryable.Where(q => orgList.Any(authorization => authorization == q.AUTH_ORG));
|
}
|
//生产单元授权验证
|
if (!options.ProdCode.IsNullOrEmpty() && !typeof(T).GetProperty("AUTH_PROD").IsNullOrEmpty())
|
{
|
var prodList = options.ProdCode.Split(",", StringSplitOptions.RemoveEmptyEntries).ToList();
|
queryable = queryable.Where(q => prodList.Any(authorization => authorization == q.AUTH_PROD));
|
}
|
//仓库单元授权验证
|
if (!options.WhCode.IsNullOrEmpty() && !typeof(T).GetProperty("AUTH_WH").IsNullOrEmpty())
|
{
|
var whList = options.WhCode.Split(",", StringSplitOptions.RemoveEmptyEntries).ToList();
|
queryable = queryable.Where(q => whList.Any(authorization => authorization == q.AUTH_WH));
|
}
|
return queryable.ByAuth(options.UserId, options.GetOptions());
|
}
|
|
/// <summary>
|
/// 通过授权查询数据<br/>
|
/// 注意：联表授权查询时，主表的别名必须为q，不然会出错
|
/// </summary>
|
/// <typeparam name="T"></typeparam>
|
/// <param name="queryable"></param>
|
/// <param name="userId"></param>
|
/// <param name="options"></param>
|
/// <returns></returns>
|
public static ISugarQueryable<T, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> ByAuth<T, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>(this ISugarQueryable<T, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> queryable, string userId, DbAuth options) where T : iTableHasAuth, new()
|
{
|
//组织机构授权验证
|
if (options.HasFlag(DbAuth.Org) && !typeof(T).GetProperty("AUTH_ORG").IsNullOrEmpty())
|
{
|
queryable = queryable.Where(q => SqlFunc.Subqueryable<V_USER_ORG>().Where(authorization => authorization.USER_ID == userId && authorization.ORG_CODE == q.AUTH_ORG).Any());
|
}
|
//生产单元授权验证
|
if (options.HasFlag(DbAuth.Prod) && !typeof(T).GetProperty("AUTH_PROD").IsNullOrEmpty())
|
{
|
queryable = queryable.Where(q => SqlFunc.Subqueryable<V_USER_PROD>().Where(authorization => authorization.USER_ID == userId && authorization.PROD_CODE == q.AUTH_PROD).Any());
|
}
|
//仓库单元授权验证
|
if (options.HasFlag(DbAuth.Wh) && !typeof(T).GetProperty("AUTH_WH").IsNullOrEmpty())
|
{
|
queryable = queryable.Where(q => SqlFunc.Subqueryable<V_USER_WH>().Where(authorization => authorization.USER_ID == userId && authorization.WH_CODE == q.AUTH_WH).Any());
|
}
|
|
return queryable;
|
}
|
|
/// <summary>
|
/// 通过授权查询数据<br/>
|
/// 注意：联表授权查询时，主表的别名必须为q，不然会出错
|
/// </summary>
|
/// <typeparam name="T"></typeparam>
|
/// <param name="queryable"></param>
|
/// <param name="options"></param>
|
/// <returns></returns>
|
public static ISugarQueryable<T, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> ByAuth<T, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>(this ISugarQueryable<T, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> queryable, AuthOption options) where T : iTableHasAuth, new()
|
{
|
//组织机构授权验证
|
if (!options.OrgCode.IsNullOrEmpty() && !typeof(T).GetProperty("AUTH_ORG").IsNullOrEmpty())
|
{
|
var orgList = options.OrgCode.Split(",", StringSplitOptions.RemoveEmptyEntries);
|
queryable = queryable.Where(q => orgList.Any(authorization => authorization == q.AUTH_ORG));
|
}
|
//生产单元授权验证
|
if (!options.ProdCode.IsNullOrEmpty() && !typeof(T).GetProperty("AUTH_PROD").IsNullOrEmpty())
|
{
|
var prodList = options.ProdCode.Split(",", StringSplitOptions.RemoveEmptyEntries).ToList();
|
queryable = queryable.Where(q => prodList.Any(authorization => authorization == q.AUTH_PROD));
|
}
|
//仓库单元授权验证
|
if (!options.WhCode.IsNullOrEmpty() && !typeof(T).GetProperty("AUTH_WH").IsNullOrEmpty())
|
{
|
var whList = options.WhCode.Split(",", StringSplitOptions.RemoveEmptyEntries).ToList();
|
queryable = queryable.Where(q => whList.Any(authorization => authorization == q.AUTH_WH));
|
}
|
return queryable.ByAuth(options.UserId, options.GetOptions());
|
}
|
}//endClass
|
}
|
