/// <summary>
/// 按部门获取部门用户,包括子部门的用户
/// </summary>
/// <param name="departmentId">部门主键</param>
/// <param name="searchKey">关键字</param>
/// <returns>数据表</returns>
public DataTable SearchByDepartment(string departmentId, string searchKey)
{
var sql = "SELECT " + BaseUserEntity.CurrentTableName + ".* "
+ " FROM " + BaseUserEntity.CurrentTableName;
sql += " WHERE (" + BaseUserEntity.CurrentTableName + "." + BaseUserEntity.FieldDeleted + " = 0 ";
sql += " AND " + BaseUserEntity.CurrentTableName + "." + BaseUserEntity.FieldEnabled + " = 1 ) ";
if (!string.IsNullOrEmpty(departmentId))
{
/*
* 用非递归调用的建议方法
* sql += " AND " + BaseUserEntity.CurrentTableName + "." + BaseUserEntity.FieldDepartmentId
+ " IN ( SELECT " + BaseOrganizationEntity.FieldId
+ " FROM " + BaseOrganizationEntity.CurrentTableName
+ " WHERE " + BaseOrganizationEntity.FieldId + " = " + departmentId + " OR " + BaseOrganizationEntity.FieldParentId + " = " + departmentId + ")";
*/
var organizationManager = new BaseOrganizationManager(DbHelper, UserInfo);
var organizationIds = organizationManager.GetChildrensId(BaseOrganizationEntity.FieldId, departmentId, BaseOrganizationEntity.FieldParentId);
if (organizationIds != null && organizationIds.Length > 0)
{
sql += " AND (" + BaseUserEntity.CurrentTableName + "." + BaseUserEntity.FieldCompanyId + " IN (" + StringUtil.ArrayToList(organizationIds) + ")"
+ " OR " + BaseUserEntity.CurrentTableName + "." + BaseUserEntity.FieldDepartmentId + " IN (" + StringUtil.ArrayToList(organizationIds) + ")"
+ " OR " + BaseUserEntity.CurrentTableName + "." + BaseUserEntity.FieldWorkgroupId + " IN (" + StringUtil.ArrayToList(organizationIds) + "))";
}
}
var dbParameters = new List <IDbDataParameter>();
searchKey = searchKey.Trim();
if (!string.IsNullOrEmpty(searchKey))
{
sql += " AND (" + BaseUserEntity.FieldUserName + " LIKE " + DbHelper.GetParameter(BaseUserEntity.FieldUserName);
sql += " OR " + BaseUserEntity.FieldCode + " LIKE " + DbHelper.GetParameter(BaseUserEntity.FieldCode);
sql += " OR " + BaseUserEntity.FieldRealName + " LIKE " + DbHelper.GetParameter(BaseUserEntity.FieldRealName);
sql += " OR " + BaseUserEntity.FieldDepartmentName + " LIKE " + DbHelper.GetParameter(BaseUserEntity.FieldDepartmentName) + ")";
if (searchKey.IndexOf("%") < 0)
{
searchKey = "%" + searchKey + "%";
}
dbParameters.Add(DbHelper.MakeParameter(BaseUserEntity.FieldUserName, searchKey));
dbParameters.Add(DbHelper.MakeParameter(BaseUserEntity.FieldCode, searchKey));
dbParameters.Add(DbHelper.MakeParameter(BaseUserEntity.FieldRealName, searchKey));
dbParameters.Add(DbHelper.MakeParameter(BaseUserEntity.FieldDepartmentName, searchKey));
}
sql += " ORDER BY " + BaseUserEntity.CurrentTableName + "." + BaseUserEntity.FieldSortCode;
return(DbHelper.Fill(sql, dbParameters.ToArray()));
}
/// <summary>
/// 获取下级的用户表
/// </summary>
/// <param name="organizationId"></param>
/// <returns></returns>
public DataTable GetChildrenUserDataTable(string organizationId)
{
string[] organizationIds = null;
var organizationManager = new BaseOrganizationManager(DbHelper, UserInfo);
switch (DbHelper.CurrentDbType)
{
case CurrentDbType.Access:
case CurrentDbType.SqlServer:
var organizationCode = organizationManager.GetCodeById(organizationId);
organizationIds = organizationManager.GetChildrensIdByCode(BaseOrganizationEntity.FieldCode, organizationCode);
break;
case CurrentDbType.Oracle:
organizationIds = organizationManager.GetChildrensId(BaseOrganizationEntity.FieldId, organizationId, BaseOrganizationEntity.FieldParentId);
break;
}
return(GetDataTableByOrganizations(organizationIds));
}
/// <summary>
/// 按条件分页高级查询(带记录状态Enabled和删除状态Deleted)
/// </summary>
/// <param name="systemCode">系统编码</param>
/// <param name="organizationId">查看公司主键</param>
/// <param name="userId">查看用户主键</param>
/// <param name="roleId">角色编号</param>
/// <param name="roleIdExcluded">排除角色编号</param>
/// <param name="moduleId">模块菜单编号</param>
/// <param name="moduleIdExcluded">排除模块菜单编号</param>
/// <param name="showInvisible">是否显示隐藏</param>
/// <param name="disabledUserOnly">仅显示禁用</param>
/// <param name="startTime">开始时间</param>
/// <param name="endTime">结束时间</param>
/// <param name="searchKey">查询关键字</param>
/// <param name="recordCount">记录数</param>
/// <param name="pageNo">当前页</param>
/// <param name="pageSize">每页显示</param>
/// <param name="sortExpression">排序字段</param>
/// <param name="sortDirection">排序方向</param>
/// <param name="showDisabled">是否显示无效记录</param>
/// <param name="showDeleted">是否显示已删除记录</param>
/// <returns>数据表</returns>
public DataTable GetDataTableByPage(string systemCode, string organizationId, string userId, string roleId, string roleIdExcluded, string moduleId, string moduleIdExcluded, bool showInvisible, bool disabledUserOnly, string startTime, string endTime, string searchKey, out int recordCount, int pageNo = 1, int pageSize = 20, string sortExpression = "CreateTime", string sortDirection = "DESC", bool showDisabled = true, bool showDeleted = true)
{
//用户表名
var tableNameUser = BaseUserEntity.CurrentTableName;
//用户登录表名
var tableNameUserLogon = BaseUserLogonEntity.CurrentTableName;
var sb = Pool.StringBuilder.Get().Append(" 1 = 1");
//只显示已锁定用户
if (disabledUserOnly)
{
sb.Append(" AND " + BaseUserEntity.FieldEnabled + " = 0 ");
//已锁定
showDisabled = true;
//未删除
showDeleted = false;
}
//是否显示无效记录
if (!showDisabled)
{
sb.Append(" AND " + BaseUserEntity.FieldEnabled + " = 1 ");
}
//是否显示已删除记录
if (!showDeleted)
{
sb.Append(" AND " + BaseUserEntity.FieldDeleted + " = 0 ");
}
if (ValidateUtil.IsInt(organizationId) && int.Parse(organizationId) > 0)
{
//只选择当前
//sb.Append(" AND (" + BaseUserEntity.FieldCompanyId + " = " + organizationId + ")";
//只选择当前和下一级
//sb.Append(" AND " + BaseUserEntity.FieldDepartmentId
// + " IN ( SELECT " + BaseOrganizationEntity.FieldId
// + " FROM " + BaseOrganizationEntity.CurrentTableName
// + " WHERE " + BaseOrganizationEntity.FieldId + " = " + organizationId + " OR " + BaseOrganizationEntity.FieldParentId + " = " + organizationId + ")";
//所有下级的都列出来
var organizationManager = new BaseOrganizationManager(UserInfo);
var ids = organizationManager.GetChildrensId(BaseOrganizationEntity.FieldId, organizationId, BaseOrganizationEntity.FieldParentId);
if (ids != null && ids.Length > 0)
{
sb.Append(" AND (" + BaseUserEntity.FieldCompanyId + " IN (" + StringUtil.ArrayToList(ids) + ")"
+ " OR " + BaseUserEntity.FieldSubCompanyId + " IN (" + StringUtil.ArrayToList(ids) + ")"
+ " OR " + BaseUserEntity.FieldDepartmentId + " IN (" + StringUtil.ArrayToList(ids) + ")"
+ " OR " + BaseUserEntity.FieldSubDepartmentId + " IN (" + StringUtil.ArrayToList(ids) + ")"
+ " OR " + BaseUserEntity.FieldWorkgroupId + " IN (" + StringUtil.ArrayToList(ids) + "))");
}
}
//if (ValidateUtil.IsInt(departmentId))
//{
// sb.Append(" AND " + BaseUserEntity.FieldDepartmentId + " = " + departmentId;
//}
if (ValidateUtil.IsInt(userId))
{
// sb.Append(" AND UserId = " + userId);
}
//是否显示已隐藏记录
if (!showInvisible)
{
sb.Append(" AND " + BaseUserEntity.FieldIsVisible + " = 1 ");
}
//角色
var tableNameUserRole = UserInfo.SystemCode + "UserRole";
if (!string.IsNullOrEmpty(systemCode))
{
tableNameUserRole = systemCode + "UserRole";
}
//指定角色
if (ValidateUtil.IsInt(roleId))
{
sb.Append(" AND ( " + BaseUserEntity.FieldId + " IN ");
sb.Append(" (SELECT DISTINCT " + BaseUserRoleEntity.FieldUserId);
sb.Append(" FROM " + tableNameUserRole);
sb.Append(" WHERE " + BaseUserRoleEntity.FieldRoleId + " = '" + roleId + "'");
sb.Append(" AND " + BaseUserRoleEntity.FieldEnabled + " = 1");
sb.Append(" AND " + BaseUserRoleEntity.FieldDeleted + " = 0)) ");
}
//排除指定角色
if (ValidateUtil.IsInt(roleIdExcluded))
{
sb.Append(" AND ( " + BaseUserEntity.FieldId + " NOT IN ");
sb.Append(" (SELECT DISTINCT " + BaseUserRoleEntity.FieldUserId);
sb.Append(" FROM " + tableNameUserRole);
sb.Append(" WHERE " + BaseUserRoleEntity.FieldRoleId + " = '" + roleIdExcluded + "'");
sb.Append(" AND " + BaseUserRoleEntity.FieldEnabled + " = 1");
sb.Append(" AND " + BaseUserRoleEntity.FieldDeleted + " = 0)) ");
}
//用户菜单模块表
var tableNamePermission = UserInfo.SystemCode + "Permission";
if (!string.IsNullOrEmpty(systemCode))
{
tableNamePermission = systemCode + "Permission";
}
//指定的菜单模块
if (ValidateUtil.IsInt(moduleId))
{
sb.Append(" AND ( " + BaseUserEntity.FieldId + " IN ");
sb.Append(" (SELECT DISTINCT " + BasePermissionEntity.FieldResourceId);
sb.Append(" FROM " + tableNamePermission);
sb.Append(" WHERE " + BasePermissionEntity.FieldPermissionId + " = '" + moduleId + "'");
sb.Append(" AND " + BasePermissionEntity.FieldResourceCategory + " = '" + BaseUserEntity.CurrentTableName + "' ");
sb.Append(" AND " + BasePermissionEntity.FieldEnabled + " = 1");
sb.Append(" AND " + BasePermissionEntity.FieldDeleted + " = 0)) ");
}
//排除指定菜单模块
if (ValidateUtil.IsInt(moduleIdExcluded))
{
sb.Append(" AND ( " + BaseUserEntity.FieldId + " NOT IN ");
sb.Append(" (SELECT DISTINCT " + BasePermissionEntity.FieldResourceId);
sb.Append(" FROM " + tableNamePermission);
sb.Append(" WHERE " + BasePermissionEntity.FieldPermissionId + " = '" + moduleIdExcluded + "'");
sb.Append(" AND " + BasePermissionEntity.FieldResourceCategory + " = '" + BaseUserEntity.CurrentTableName + "' ");
sb.Append(" AND " + BasePermissionEntity.FieldEnabled + " = 1");
sb.Append(" AND " + BasePermissionEntity.FieldDeleted + " = 0)) ");
}
//关键词
if (!string.IsNullOrEmpty(searchKey))
{
searchKey = StringUtil.GetLikeSearchKey(dbHelper.SqlSafe(searchKey));
sb.Append(" AND (" + BaseUserEntity.FieldRealName + " LIKE N'%" + searchKey + "%'");
sb.Append(" OR " + BaseUserEntity.FieldUserName + " LIKE N'%" + searchKey + "%'");
sb.Append(" OR " + BaseUserEntity.FieldNickName + " LIKE N'%" + searchKey + "%'");
sb.Append(" OR " + BaseUserEntity.FieldCompanyName + " LIKE N'%" + searchKey + "%'");
sb.Append(" OR " + BaseUserEntity.FieldSubCompanyName + " LIKE N'%" + searchKey + "%'");
sb.Append(" OR " + BaseUserEntity.FieldDepartmentName + " LIKE N'%" + searchKey + "%'");
sb.Append(" OR " + BaseUserEntity.FieldSubDepartmentName + " LIKE N'%" + searchKey + "%'");
sb.Append(" OR " + BaseUserEntity.FieldWorkgroupName + " LIKE N'%" + searchKey + "%'");
sb.Append(" OR " + BaseUserEntity.FieldCode + " LIKE N'%" + searchKey + "%'");
sb.Append(" OR " + BaseUserEntity.FieldDescription + " LIKE N'%" + searchKey + "%'");
sb.Append(" OR " + BaseUserEntity.FieldQuickQuery + " LIKE N'%" + searchKey + "%'");
sb.Append(" OR " + BaseUserEntity.FieldSimpleSpelling + " LIKE N'%" + searchKey + "%')");
}
if (ValidateUtil.IsDateTime(startTime))
{
sb.Append(" AND " + BaseUserEntity.FieldCreateTime + " >= '" + startTime + "'");
}
if (ValidateUtil.IsDateTime(endTime))
{
sb.Append(" AND " + BaseUserEntity.FieldCreateTime + " <= DATEADD(s,-1,DATEADD(d,1,'" + endTime + "'))");
}
sb.Replace(" 1 = 1 AND ", "");
//重新构造viewName
var viewName = string.Empty;
viewName = "SELECT DISTINCT " + tableNameUser + "." + BaseUserEntity.FieldId;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldUserFrom;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldUserName;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldRealName;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldNickName;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldCode;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldIdCard;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldQuickQuery;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldSimpleSpelling;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldCompanyId;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldCompanyName;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldSubCompanyId;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldSubCompanyName;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldDepartmentId;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldDepartmentName;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldSubDepartmentId;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldSubDepartmentName;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldWorkgroupId;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldWorkgroupName;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldWorkCategory;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldSecurityLevel;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldTitle;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldDuty;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldLang;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldGender;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldBirthday;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldScore;
//viewName += "," + tableNameUser + "." + BaseUserEntity.FieldFans;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldHomeAddress;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldSignature;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldTheme;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldIsStaff;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldIsVisible;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldProvince;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldCity;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldDistrict;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldAuditStatus;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldEnabled;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldDeleted;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldSortCode;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldDescription;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldIsAdministrator;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldIsCheckBalance;
//用户表
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldCreateTime;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldCreateUserId;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldCreateBy;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldUpdateTime;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldUpdateUserId;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldUpdateBy;
//用户登录表
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldAllowStartTime;
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldAllowEndTime;
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldLockStartTime;
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldLockEndTime;
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldFirstVisitTime;
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldPreviousVisitTime;
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldLastVisitTime;
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldChangePasswordTime;
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldLogonCount;
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldConcurrentUser;
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldUserOnline;
//不从用户登录表读取这些字段，从用户表读取即可
//viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldCreateTime;
//viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldCreateUserId;
//viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldCreateBy;
//viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldUpdateTime;
//viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldUpdateUserId;
//viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldUpdateBy;
viewName += " FROM " + tableNameUser + " INNER JOIN " + tableNameUserLogon;
viewName += " ON " + tableNameUser + "." + BaseUserEntity.FieldId + " = " + tableNameUserLogon + "." + BaseUserLogonEntity.FieldUserId;
//指定角色，就读取相应的UserRole授权日期
if (ValidateUtil.IsInt(roleId))
{
viewName = "SELECT DISTINCT " + tableNameUser + "." + BaseUserEntity.FieldId;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldUserFrom;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldUserName;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldRealName;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldNickName;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldCode;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldIdCard;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldQuickQuery;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldSimpleSpelling;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldCompanyId;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldCompanyName;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldSubCompanyId;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldSubCompanyName;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldDepartmentId;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldDepartmentName;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldSubDepartmentId;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldSubDepartmentName;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldWorkgroupId;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldWorkgroupName;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldWorkCategory;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldSecurityLevel;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldTitle;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldDuty;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldLang;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldGender;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldBirthday;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldScore;
//viewName += "," + tableNameUser + "." + BaseUserEntity.FieldFans;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldHomeAddress;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldSignature;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldTheme;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldIsStaff;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldIsVisible;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldProvince;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldCity;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldDistrict;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldAuditStatus;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldEnabled;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldDeleted;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldSortCode;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldDescription;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldIsAdministrator;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldIsCheckBalance;
//用户登录表
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldAllowStartTime;
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldAllowEndTime;
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldLockStartTime;
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldLockEndTime;
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldFirstVisitTime;
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldPreviousVisitTime;
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldLastVisitTime;
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldChangePasswordTime;
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldLogonCount;
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldConcurrentUser;
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldUserOnline;
//授权日期
viewName += "," + tableNameUserRole + "." + BaseUserRoleEntity.FieldCreateTime;
viewName += "," + tableNameUserRole + "." + BaseUserRoleEntity.FieldCreateUserId;
viewName += "," + tableNameUserRole + "." + BaseUserRoleEntity.FieldCreateBy;
viewName += "," + tableNameUserRole + "." + BaseUserRoleEntity.FieldUpdateTime;
viewName += "," + tableNameUserRole + "." + BaseUserRoleEntity.FieldUpdateUserId;
viewName += "," + tableNameUserRole + "." + BaseUserRoleEntity.FieldUpdateBy;
viewName += " FROM " + tableNameUser + " INNER JOIN " + tableNameUserRole;
viewName += " ON " + tableNameUser + "." + BaseUserEntity.FieldId + " = " + tableNameUserRole + "." + BaseUserRoleEntity.FieldUserId;
viewName += " INNER JOIN " + tableNameUserLogon;
viewName += " ON " + tableNameUser + "." + BaseUserEntity.FieldId + " = " + tableNameUserLogon + "." + BaseUserLogonEntity.FieldUserId;
viewName += " WHERE (" + tableNameUserRole + "." + BaseUserRoleEntity.FieldRoleId + " = " + roleId + ")";
}
//指定菜单模块，就读取相应的Permission授权日期
else if (ValidateUtil.IsInt(moduleId))
{
viewName = "SELECT DISTINCT " + tableNameUser + "." + BaseUserEntity.FieldId;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldUserFrom;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldUserName;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldRealName;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldNickName;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldCode;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldIdCard;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldQuickQuery;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldSimpleSpelling;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldCompanyId;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldCompanyName;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldSubCompanyId;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldSubCompanyName;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldDepartmentId;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldDepartmentName;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldSubDepartmentId;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldSubDepartmentName;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldWorkgroupId;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldWorkgroupName;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldWorkCategory;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldSecurityLevel;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldTitle;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldDuty;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldLang;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldGender;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldBirthday;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldScore;
//viewName += "," + tableNameUser + "." + BaseUserEntity.FieldFans;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldHomeAddress;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldSignature;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldTheme;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldIsStaff;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldIsVisible;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldProvince;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldCity;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldDistrict;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldAuditStatus;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldEnabled;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldDeleted;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldSortCode;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldDescription;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldIsAdministrator;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldIsCheckBalance;
//用户登录表
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldAllowStartTime;
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldAllowEndTime;
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldLockStartTime;
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldLockEndTime;
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldFirstVisitTime;
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldPreviousVisitTime;
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldLastVisitTime;
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldChangePasswordTime;
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldLogonCount;
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldConcurrentUser;
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldUserOnline;
//授权日期
viewName += "," + tableNamePermission + "." + BasePermissionEntity.FieldCreateTime;
viewName += "," + tableNamePermission + "." + BasePermissionEntity.FieldCreateUserId;
viewName += "," + tableNamePermission + "." + BasePermissionEntity.FieldCreateBy;
viewName += "," + tableNamePermission + "." + BasePermissionEntity.FieldUpdateTime;
viewName += "," + tableNamePermission + "." + BasePermissionEntity.FieldUpdateUserId;
viewName += "," + tableNamePermission + "." + BasePermissionEntity.FieldUpdateBy;
viewName += " FROM " + tableNameUser + " INNER JOIN " + tableNamePermission;
viewName += " ON " + tableNameUser + "." + BaseUserEntity.FieldId + " = " + tableNamePermission + "." + BasePermissionEntity.FieldResourceId;
viewName += " INNER JOIN " + tableNameUserLogon;
viewName += " ON " + tableNameUser + "." + BaseUserEntity.FieldId + " = " + tableNameUserLogon + "." + BaseUserLogonEntity.FieldUserId;
viewName += " WHERE (" + tableNamePermission + "." + BasePermissionEntity.FieldResourceCategory + " = '" + tableNameUser + "')";
viewName += " AND (" + tableNamePermission + "." + BasePermissionEntity.FieldPermissionId + " = " + moduleId + ")";
}
//从视图读取
if (!string.IsNullOrEmpty(viewName))
{
tableNameUser = viewName;
}
return(GetDataTableByPage(out recordCount, pageNo, pageSize, sortExpression, sortDirection, tableNameUser, sb.Put(), null, "*"));
}