/// <summary>
/// 获取菜单模块树型列表
/// </summary>
/// <param name="systemCode">子系统</param>
/// <param name="isMenu">是否菜单(0/1)</param>
public DataTable GetModuleTree(string systemCode, string isMenu = null)
{
if (string.IsNullOrEmpty(systemCode))
{
systemCode = "Base";
}
//读取选定子系统的菜单模块
var manager = new BaseModuleManager(UserInfo, systemCode + "Module");
// 获取所有数据
var parameters = new List <KeyValuePair <string, object> >();
if (ValidateUtil.IsInt(isMenu))
{
parameters.Add(new KeyValuePair <string, object>(BaseModuleEntity.FieldIsMenu, isMenu));
}
parameters.Add(new KeyValuePair <string, object>(BaseModuleEntity.FieldEnabled, 1));
parameters.Add(new KeyValuePair <string, object>(BaseModuleEntity.FieldDeleted, 0));
//2017.12.20增加默认的HttpRuntime.Cache缓存
var cacheKey = "DataTable." + systemCode + ".ModuleTree." + isMenu;
//var cacheTime = default(TimeSpan);
var cacheTime = TimeSpan.FromMilliseconds(86400000);
return(CacheUtil.Cache <DataTable>(cacheKey, () => manager.GetModuleTree(manager.GetDataTable(parameters, BaseModuleEntity.FieldSortCode)), true, false, cacheTime));
//直接读取数据库
//return manager.GetModuleTree(manager.GetModuleTree(manager.GetDataTable(parameters, BaseModuleEntity.FieldSortCode)));
}
/// <summary>
/// 获取模块列表
/// </summary>
/// <param name="userInfo">用户</param>
/// <returns>数据表</returns>
public DataTable GetDataTable(BaseUserInfo userInfo)
{
// 写入调试信息
#if (DEBUG)
int milliStart = BaseBusinessLogic.StartDebug(userInfo, MethodBase.GetCurrentMethod());
#endif
// 加强安全验证防止未授权匿名调用
#if (!DEBUG)
LogOnService.UserIsLogOn(userInfo);
#endif
DataTable dataTable = new DataTable(BaseModuleEntity.TableName);
using (IDbHelper dbHelper = DbHelperFactory.GetHelper(BaseSystemInfo.UserCenterDbType))
{
try
{
dbHelper.Open(UserCenterDbConnection);
string tableName = BaseModuleEntity.TableName;
if (!string.IsNullOrEmpty(BaseSystemInfo.SystemCode))
{
tableName = BaseSystemInfo.SystemCode + "Module";
}
BaseModuleManager moduleManager = new BaseModuleManager(dbHelper, userInfo, tableName);
dataTable = moduleManager.GetDataTable(
new KeyValuePair <string, object>(BaseModuleEntity.FieldDeletionStateCode, 0)
//, new KeyValuePair<string, object>(BaseModuleEntity.FieldEnabled, 1)
, BaseModuleEntity.FieldSortCode);
dataTable.DefaultView.Sort = BaseModuleEntity.FieldSortCode;
dataTable.TableName = BaseModuleEntity.TableName;
BaseLogManager.Instance.Add(dbHelper, userInfo, this.serviceName, AppMessage.ModuleService_GetDataTable, MethodBase.GetCurrentMethod());
}
catch (Exception ex)
{
BaseExceptionManager.LogException(dbHelper, userInfo, ex);
throw ex;
}
finally
{
dbHelper.Close();
}
}
// 写入调试信息
#if (DEBUG)
BaseBusinessLogic.EndDebug(MethodBase.GetCurrentMethod(), milliStart);
#endif
return(dataTable);
}
/// <summary>
/// 按主键数组获取列表
/// </summary>
/// <param name="userInfo">用户</param>
/// <param name="ids">角色主键</param>
/// <returns>数据表</returns>
public DataTable GetDataTableByIds(BaseUserInfo userInfo, string[] ids)
{
var result = new DataTable(BaseRoleEntity.TableName);
var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod());
ServiceUtil.ProcessUserCenterReadDb(userInfo, parameter, (dbHelper) =>
{
string tableName = userInfo.SystemCode + "Module";
var manager = new BaseModuleManager(dbHelper, userInfo, tableName);
result = manager.GetDataTable(BaseModuleEntity.FieldId, ids, BaseModuleEntity.FieldSortCode);
result.TableName = BaseModuleEntity.TableName;
});
return(result);
}
/// <summary>
/// 获取模块列表
/// </summary>
/// <param name="userInfo">用户</param>
/// <returns>数据表</returns>
public DataTable GetDataTable(BaseUserInfo userInfo)
{
var result = new DataTable(BaseModuleEntity.TableName);
var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod());
ServiceUtil.ProcessUserCenterReadDb(userInfo, parameter, (dbHelper) =>
{
string tableName = userInfo.SystemCode + "Module";
var manager = new BaseModuleManager(dbHelper, userInfo, tableName);
result = manager.GetDataTable(
new KeyValuePair <string, object>(BaseModuleEntity.FieldDeletionStateCode, 0)
//, new KeyValuePair<string, object>(BaseModuleEntity.FieldEnabled, 1)
, BaseModuleEntity.FieldSortCode);
result.DefaultView.Sort = BaseModuleEntity.FieldSortCode;
result.TableName = BaseModuleEntity.TableName;
});
return(result);
}
/// <summary>
/// 按父节点获得列表
/// </summary>
/// <param name="userInfo">用户</param>
/// <param name="parentId">父结点主键</param>
/// <returns>数据表</returns>
public DataTable GetDataTableByParent(BaseUserInfo userInfo, string parentId)
{
var result = new DataTable(BaseModuleEntity.CurrentTableName);
var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod());
ServiceUtil.ProcessUserCenterReadDb(userInfo, parameter, (dbHelper) =>
{
var tableName = userInfo.SystemCode + "Module";
var manager = new BaseModuleManager(dbHelper, userInfo, tableName);
var parameters = new List <KeyValuePair <string, object> >
{
new KeyValuePair <string, object>(BaseModuleEntity.FieldDeleted, 0),
new KeyValuePair <string, object>(BaseModuleEntity.FieldParentId, parentId)
};
result = manager.GetDataTable(parameters, 0, BaseModuleEntity.FieldSortCode);
// result.DefaultView.Sort = BaseModuleEntity.FieldSortCode;
result.TableName = BaseModuleEntity.CurrentTableName;
});
return(result);
}
/// <summary>
/// 获得用户有访问权限的模块
/// </summary>
/// <param name="userInfo">用户</param>
/// <param name="userId">用户主键</param>
/// <returns>数据表</returns>
public DataTable GetModuleDTByUser(BaseUserInfo userInfo, string userId)
{
// 写入调试信息
#if (DEBUG)
int milliStart = BaseBusinessLogic.StartDebug(userInfo, MethodBase.GetCurrentMethod());
#endif
// 加强安全验证防止未授权匿名调用
#if (!DEBUG)
LogOnService.UserIsLogOn(userInfo);
#endif
DataTable dataTable = new DataTable(BaseModuleEntity.TableName);
using (IDbHelper dbHelper = DbHelperFactory.GetHelper(BaseSystemInfo.UserCenterDbType))
{
try
{
dbHelper.Open(UserCenterDbConnection);
string tableName = BaseModuleEntity.TableName;
if (!string.IsNullOrEmpty(BaseSystemInfo.SystemCode))
{
tableName = BaseSystemInfo.SystemCode + "Module";
}
BaseModuleManager moduleManager = new BaseModuleManager(dbHelper, userInfo, tableName);
if (userInfo.IsAdministrator)
{
List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >();
parameters.Add(new KeyValuePair <string, object>(BaseModuleEntity.FieldEnabled, 1));
parameters.Add(new KeyValuePair <string, object>(BaseModuleEntity.FieldDeletionStateCode, 0));
// 有效的，未被删除的显示出来
dataTable = moduleManager.GetDataTable(parameters, BaseModuleEntity.FieldSortCode);
}
else
{
dataTable = moduleManager.GetDataTableByUser(userId);
}
// 若不是员工，有些菜单可以去掉的功能，加在这里
if (string.IsNullOrEmpty(userInfo.StaffId))
{
BaseBusinessLogic.Delete(dataTable, BaseModuleEntity.FieldCode, "FrmStaffAddressEdit");
dataTable.AcceptChanges();
}
dataTable.TableName = BaseModuleEntity.TableName;
BaseLogManager.Instance.Add(dbHelper, userInfo, this.serviceName, AppMessage.PermissionService_GetModuleDTByUser, MethodBase.GetCurrentMethod());
}
catch (Exception ex)
{
BaseExceptionManager.LogException(dbHelper, userInfo, ex);
throw ex;
}
finally
{
dbHelper.Close();
}
}
// 写入调试信息
#if (DEBUG)
BaseBusinessLogic.EndDebug(MethodBase.GetCurrentMethod(), milliStart);
#endif
return(dataTable);
}
