/// <summary> /// 添加参数设置 /// </summary> /// <param name="userInfo">用户</param> /// <param name="tableName">表名</param> /// <param name="categoryCode">类别编号</param> /// <param name="parameterId">参数主键</param> /// <param name="parameterCode">编码</param> /// <param name="parameterContent">参数内容</param> /// <returns>主键</returns> public string AddParameter(BaseUserInfo userInfo, string tableName, string categoryCode, string parameterId, string parameterCode, string parameterContent) { string result = string.Empty; var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessUserCenterWriteDb(userInfo, parameter, (dbHelper) => { var manager = new BaseParameterManager(dbHelper, userInfo, tableName); result = manager.AddParameter(tableName, categoryCode, parameterId, parameterCode, parameterContent); }); return(result); }
/// <summary> /// 清除用户权限范围 /// </summary> /// <param name="userInfo">用户</param> /// <param name="userId">主键</param> /// <returns>数据表</returns> public int ClearUserPermissionScope(BaseUserInfo userInfo, string userId, string permissionCode) { int result = 0; var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessUserCenterWriteDb(userInfo, parameter, (dbHelper) => { string tableName = userInfo.SystemCode + "PermissionScope"; var manager = new BaseUserScopeManager(dbHelper, userInfo, tableName); result = manager.ClearUserPermissionScope(userInfo.SystemCode, userId, permissionCode); }); return(result); }
/// <summary> /// 获取用户的某个权限域的用户范围 /// </summary> /// <param name="userInfo">用户</param> /// <param name="systemCode">系统编号</param> /// <param name="userId">用户主键</param> /// <param name="permissionCode">权限编号</param> /// <returns>主键数组</returns> public string[] GetUserScopeRoleIds(BaseUserInfo userInfo, string systemCode, string userId, string permissionCode) { string[] result = null; var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessUserCenterReadDb(userInfo, parameter, (dbHelper) => { string tableName = systemCode + "PermissionScope"; var manager = new BaseUserScopeManager(dbHelper, userInfo, tableName); result = manager.GetRoleIds(systemCode, userId, permissionCode); }); return(result); }
/// <summary> /// 获取记录 /// </summary> /// <param name="userInfo">用户</param> /// <returns>数据表</returns> public DataTable GetSystemParameter(BaseUserInfo userInfo) { var result = new DataTable(BaseParameterEntity.TableName); var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessUserCenterReadDb(userInfo, parameter, (dbHelper) => { var manager = new BaseParameterManager(dbHelper, userInfo, "SystemParameter"); result = manager.GetSystemParameter(); result.TableName = BaseParameterEntity.TableName; }); return(result); }
/// <summary> /// 获取角色主键数组 /// </summary> /// <param name="userInfo">用户</param> /// <param name="result">操作权限主键</param> /// <returns>主键数组</returns> public string[] GetRoleIdsByPermission(BaseUserInfo userInfo, string permissionId) { string[] result = null; var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessUserCenterReadDb(userInfo, parameter, (dbHelper) => { var manager = new BaseRolePermissionManager(dbHelper, userInfo); result = manager.GetRoleIds(userInfo.SystemCode, permissionId); // BaseLogManager.Instance.Add(result, this.serviceName, MethodBase.GetCurrentMethod()); }); return(result); }
/// <summary> /// 查询组织机构 /// </summary> /// <param name="userInfo">用户</param> /// <param name="organizeId">组织机构</param> /// <param name="searchValue">查询</param> /// <returns>数据表</returns> public DataTable Search(BaseUserInfo userInfo, string organizeId, string searchValue) { var dt = new DataTable(BaseDepartmentEntity.TableName); var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessUserCenterReadDb(userInfo, parameter, (dbHelper) => { // 获得组织机构列表 var manager = new BaseDepartmentManager(dbHelper, userInfo); // dt = manager.Search(string.Empty, searchValue); dt.DefaultView.Sort = BaseDepartmentEntity.FieldSortCode; dt.TableName = BaseDepartmentEntity.TableName; }); return(dt); }
/// <summary> /// 按角色获取用户 /// </summary> /// <param name="userInfo">用户</param> /// <param name="roleIds">角色主键</param> /// <returns>数据表</returns> public DataTable GetDataTableByRole(BaseUserInfo userInfo, string[] roleIds) { var dt = new DataTable(BaseRoleEntity.CurrentTableName); var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessUserCenterReadDb(userInfo, parameter, (dbHelper) => { var manager = new BaseOrganizationManager(dbHelper, userInfo); dt = manager.GetDataTableByRole(userInfo.SystemCode, roleIds); dt.TableName = BaseOrganizationEntity.CurrentTableName; dt.DefaultView.Sort = BaseOrganizationEntity.FieldSortCode; }); return(dt); }
/// <summary> /// 获取工作流主键 /// </summary> /// <param name="userInfo">用户信息</param> /// <param name="categoryCode">类型编号</param> /// <param name="objectId">单据主键</param> /// <returns></returns> public string GetCurrentId(BaseUserInfo userInfo, string categoryCode, string objectId) { string currentId = string.Empty; var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessWorkFlowDb(userInfo, parameter, (dbHelper) => { var workFlowCurrentManager = new BaseWorkFlowCurrentManager(dbHelper, userInfo); currentId = workFlowCurrentManager.GetCurrentId(categoryCode, objectId); // BaseWorkFlowCurrentEntity workFlowCurrentEntity = workFlowCurrentManager.GetObject(currentId); // workFlowCurrentEntity.ActivityId; // workFlowCurrentEntity.ActivityFullName; }); return(currentId); }
/// <summary> /// 按分页获取监控列表 /// </summary> /// <param name="userInfo">用户信息</param> /// <param name="pageSize">每页记录数</param> /// <param name="pageIndex">第几页</param> /// <param name="recordCount">总记录数</param> /// <param name="categoryCode">类型</param> /// <param name="searchValue">查找内容</param> /// <returns></returns> public DataTable GetMonitorDTByPage(BaseUserInfo userInfo, int pageSize, int pageIndex, out int recordCount, string categoryCode = null, string searchValue = null, bool unfinishedOnly = true) { DataTable dt = null; int myrecordCount = 0; var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessWorkFlowDb(userInfo, parameter, (dbHelper) => { var workFlowCurrentManager = new BaseWorkFlowCurrentManager(dbHelper, userInfo); dt = workFlowCurrentManager.GetMonitorDTByPage(pageSize, pageIndex, out myrecordCount, categoryCode, searchValue, unfinishedOnly); dt.TableName = BaseWorkFlowCurrentEntity.TableName; }); recordCount = myrecordCount; return(dt); }
/// <summary> /// 批量删除数据 /// </summary> /// <param name="userInfo">用户</param> /// <param name="ids">主键数组</param> /// <returns>影响行数</returns> public int BatchDelete(BaseUserInfo userInfo, string[] ids) { int result = 0; var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessUserCenterWriteDb(userInfo, parameter, (dbHelper) => { var manager = new BaseOrganizeManager(dbHelper, userInfo); result = manager.Delete(ids); // 把公司文件夹也删除了 BaseFolderManager folderManager = new BaseFolderManager(dbHelper, userInfo); result = folderManager.Delete(ids); }); return(result); }
/// <summary> /// 按某个权限域获取角色列表 /// </summary> /// <param name="userInfo">用户</param> /// <param name="systemCode">系统编号</param> /// <param name="userId">用户主键</param> /// <param name="permissionCode">数据权限编号</param> /// <returns>数据表</returns> public DataTable GetRoleDTByPermission(BaseUserInfo userInfo, string systemCode, string userId, string permissionCode) { var result = new DataTable(BaseRoleEntity.CurrentTableName); var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessUserCenterReadDb(userInfo, parameter, (dbHelper) => { // 获得角色列表 var permissionScopeManager = new BasePermissionScopeManager(dbHelper, userInfo); result = permissionScopeManager.GetRoleDt(systemCode, userInfo.Id.ToString(), permissionCode, true); result.TableName = BaseRoleEntity.CurrentTableName; }); return(result); }
/// <summary> /// 批量移动数据 /// </summary> /// <param name="userInfo">用户</param> /// <param name="ids">组织机构主键数组</param> /// <param name="organizationId">父结点主键</param> /// <returns>影响行数</returns> public int BatchMoveTo(BaseUserInfo userInfo, string[] ids, string organizationId) { var result = 0; var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessUserCenterWriteDb(userInfo, parameter, (dbHelper) => { var manager = new BaseStaffManager(dbHelper, userInfo); for (var i = 0; i < ids.Length; i++) { result += manager.SetProperty(ids[i], new KeyValuePair <string, object>(BaseStaffEntity.FieldDepartmentId, organizationId)); } }); return(result); }
/// <summary> /// 获取父级下属员工 /// </summary> /// <param name="userInfo"></param> /// <param name="organizationId"></param> /// <returns></returns> public DataTable GetParentChildrenStaffs(BaseUserInfo userInfo, string organizationId) { var dt = new DataTable(BaseStaffEntity.CurrentTableName); var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessUserCenterWriteDb(userInfo, parameter, (dbHelper) => { // 获得组织机构列表 var manager = new BaseStaffManager(dbHelper, userInfo); dt = manager.GetParentChildrenStaffs(organizationId); dt.DefaultView.Sort = BaseStaffEntity.FieldSortCode; dt.TableName = BaseStaffEntity.CurrentTableName; }); return(dt); }
/// <summary> /// 批量删除 /// </summary> /// <param name="userInfo">用户</param> /// <param name="ids">文件主键数组</param> /// <returns>影响行数</returns> public int BatchDelete(BaseUserInfo userInfo, string[] ids) { int result = 0; var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessUserCenterReadDb(userInfo, parameter, (dbHelper) => { var manager = new BaseFileManager(dbHelper, userInfo); for (int i = 0; i < ids.Length; i++) { result += manager.Delete(ids[i]); } }); return(result); }
/// <summary> /// 获取用户授权权限列表 /// </summary> /// <param name="userInfo">用户</param> /// <param name="userId">用户主键</param> /// <param name="permissionCode">权限编码</param> /// <returns>主键数组</returns> public string[] GetUserScopePermissionIds(BaseUserInfo userInfo, string userId, string permissionCode) { string[] result = null; var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessUserCenterReadDb(userInfo, parameter, (dbHelper) => { var tableName = userInfo.SystemCode + "PermissionScope"; var manager = new BaseUserScopeManager(dbHelper, userInfo, tableName); result = manager.GetPermissionIds(userInfo.SystemCode, userId, permissionCode); // BaseLogManager.Instance.Add(result, this.serviceName, MethodBase.GetCurrentMethod()); }); return(result); }
/// <summary> /// 按角色名获取角色列表 /// </summary> /// <param name="userInfo">用户</param> /// <param name="organizeId">角色名</param> /// <returns>数据表</returns> public DataTable GetDataTableByRoleName(BaseUserInfo userInfo, string roleName) { var dt = new DataTable(BaseRoleEntity.TableName); var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessUserCenterReadDb(userInfo, parameter, (dbHelper) => { string tableName = userInfo.SystemCode + "Role"; // 获得角色列表 var manager = new BaseRoleManager(dbHelper, userInfo, tableName); dt = manager.GetDataTableByName(roleName); dt.TableName = BaseRoleEntity.TableName; }); return(dt); }
/// <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 + "Role"; var manager = new BaseRoleManager(dbHelper, userInfo, tableName); result = manager.GetDataTable(BaseRoleEntity.FieldId, ids, BaseRoleEntity.FieldSortCode); result.TableName = BaseRoleEntity.TableName; }); return(result); }
public DataTable GetDataTableByParent(BaseUserInfo userInfo, string id) { var dt = new DataTable(BaseOrganizeEntity.TableName); var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessUserCenterReadDb(userInfo, parameter, (dbHelper) => { // 获得文件夹列表 BaseFolderManager folderManager = new BaseFolderManager(dbHelper, userInfo); dt = folderManager.GetDataTableByParent(id); dt.TableName = BaseFolderEntity.TableName; }); return(dt); }
/// <summary> /// 获取公司列表 /// </summary> /// <param name="userInfo">用户</param> /// <param name="organizeId">组织机构主键</param> /// <returns>数据表</returns> public DataTable GetCompanyDT(BaseUserInfo userInfo, string organizeId) { var dt = new DataTable(BaseOrganizeEntity.TableName); var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessUserCenterReadDb(userInfo, parameter, (dbHelper) => { // 获得组织机构列表 var manager = new BaseOrganizeManager(dbHelper, userInfo); dt = manager.GetCompanyDT(organizeId); dt.DefaultView.Sort = BaseOrganizeEntity.FieldSortCode; dt.TableName = BaseOrganizeEntity.TableName; }); return(dt); }
/// <summary> /// 按主键获取用户数据 /// </summary> /// <param name="userInfo">用户</param> /// <param name="ids">主键数组</param> /// <returns>数据表</returns> public DataTable GetDataTableByIds(BaseUserInfo userInfo, string[] ids) { var result = new DataTable(BaseUserEntity.TableName); var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessUserCenterReadDb(userInfo, parameter, (dbHelper) => { var userManager = new BaseUserManager(dbHelper, userInfo); result = userManager.GetDataTable(ids); result.TableName = BaseUserEntity.TableName; result.DefaultView.Sort = BaseUserEntity.FieldSortCode; }); return(result); }
/// <summary> /// 更新 /// </summary> /// <param name="userInfo">用户</param> /// <param name="tableName">表名</param> /// <param name="entity">实体</param> /// <returns>影响行数</returns> public int Update(BaseUserInfo userInfo, string tableName, BaseParameterEntity entity) { var result = 0; var returnCode = string.Empty; var returnMessage = string.Empty; var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessUserCenterWriteDb(userInfo, parameter, (dbHelper) => { var manager = new BaseParameterManager(dbHelper, userInfo, tableName); result = manager.Update(entity); }); return(result); }
/// <summary> /// 查询用户 /// </summary> /// <param name="userInfo">用户</param> /// <param name="search">查询</param> /// <param name="auditStates">有效</param> /// <param name="roleIds">用户角色</param> /// <returns>数据表</returns> public DataTable Search(BaseUserInfo userInfo, string searchValue, string auditStates, string[] roleIds) { var result = new DataTable(BaseUserEntity.TableName); var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessUserCenterReadDb(userInfo, parameter, (dbHelper) => { var userManager = new BaseUserManager(dbHelper, userInfo); userManager.ShowUserLogOnInfo = false; result = userManager.Search(userInfo.SystemCode, string.Empty, searchValue, roleIds, null, auditStates, string.Empty); result.TableName = BaseUserEntity.TableName; }); return(result); }
/// <summary> /// 获取审核历史明细 /// </summary> /// <param name="userInfo">用户</param> /// <param name="categoryId">单据分类主键</param> /// <param name="objectId">单据主键</param> /// <returns>数据权限</returns> public DataTable GetAuditDetailDT(BaseUserInfo userInfo, string categoryId, string objectId) { DataTable dt = null; var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessWorkFlowDb(userInfo, parameter, (dbHelper) => { var workFlowCurrentManager = new BaseWorkFlowCurrentManager(dbHelper, userInfo); string[] ids = workFlowCurrentManager.GetIds(new KeyValuePair <string, object>(BaseWorkFlowCurrentEntity.FieldCategoryCode, categoryId), new KeyValuePair <string, object>(BaseWorkFlowCurrentEntity.FieldObjectId, objectId)); var workFlowHistoryManager = new BaseWorkFlowHistoryManager(dbHelper, userInfo); dt = workFlowHistoryManager.GetDataTable(BaseWorkFlowHistoryEntity.FieldCurrentFlowId, ids, BaseWorkFlowHistoryEntity.FieldCreateOn); dt.TableName = BaseWorkFlowCurrentEntity.TableName; }); return(dt); }
/// <summary> /// 单个删除 /// </summary> /// <param name="userInfo">用户</param> /// <param name="id">主键</param> /// <returns>影响行数</returns> public int Delete(BaseUserInfo userInfo, string id) { int result = 0; var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessUserCenterWriteDb(userInfo, parameter, (dbHelper) => { var userManager = new BaseUserManager(dbHelper, userInfo); result = userManager.Delete(id); // 用户已经被删除的员工的UserId设置为Null,说白了,是需要整理数据 userManager.CheckUserStaff(); }); return(result); }
/// <summary> /// 批量移动数据 /// </summary> /// <param name="userInfo">用户</param> /// <param name="tableName">目标表</param> /// <param name="ids">编码主键数组</param> /// <param name="targetId">目标主键</param> /// <returns>影响行数</returns> public int BatchMoveTo(BaseUserInfo userInfo, string tableName, string[] ids, string targetId) { int result = 0; var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessBusinessDb(userInfo, parameter, (dbHelper) => { var manager = new BaseItemsManager(dbHelper, userInfo, tableName); for (int i = 0; i < ids.Length; i++) { result += manager.SetProperty(ids[i], new KeyValuePair <string, object>(BaseItemsEntity.FieldParentId, targetId)); } }); return(result); }
/// <summary> /// 按公司按角色获取用户 /// </summary> /// <param name="userInfo">用户</param> /// <param name="systemCode">系统编号</param> /// <param name="companyId">公司主键</param> /// <param name="roleId">角色主键</param> /// <returns>数据表</returns> public DataTable GetDataTableByCompanyByRole(BaseUserInfo userInfo, string systemCode, string companyId, string roleId) { var result = new DataTable(BaseUserEntity.CurrentTableName); var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessUserCenterReadDb(userInfo, parameter, (dbHelper) => { var userManager = new BaseUserManager(dbHelper, userInfo); result = userManager.GetDataTableByCompanyByRole(systemCode, companyId, roleId); result.TableName = BaseUserEntity.CurrentTableName; // dt.DefaultView.Sort = BaseUserEntity.FieldSortCode; }); return(result); }
/// <summary> /// 获取部门列表 /// </summary> /// <param name="userInfo">用户</param> /// <param name="parameters">参数</param> /// <returns>数据表</returns> public DataTable GetDataTable(BaseUserInfo userInfo, List <KeyValuePair <string, object> > parameters) { var dt = new DataTable(BaseDepartmentEntity.TableName); var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessUserCenterReadDb(userInfo, parameter, (dbHelper) => { // 获得组织机构列表 var manager = new BaseDepartmentManager(dbHelper, userInfo); dt = manager.GetDataTable(parameters, BaseDepartmentEntity.FieldSortCode); dt.DefaultView.Sort = BaseDepartmentEntity.FieldSortCode; dt.TableName = BaseDepartmentEntity.TableName; }); return(dt); }
/// <summary> /// 批量保存权限 /// </summary> /// <param name="userInfo">用户</param> /// <param name="result">数据表</param> /// <returns>数据表</returns> public int BatchSave(BaseUserInfo userInfo, DataTable dt) { int result = 0; var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessWorkFlowDb(userInfo, parameter, (dbHelper) => { var workFlowManager = new BaseWorkFlowProcessManager(dbHelper, userInfo); result = workFlowManager.BatchSave(dt); // this.StatusMessage = workFlowManager.StatusMessage; // this.StatusCode = workFlowManager.StatusCode; // ReturnDataTable = workFlowManager.GetDataTable(); }); return(result); }
/// <summary> /// 批量移动数据 /// </summary> /// <param name="userInfo">用户</param> /// <param name="ids">主键数组</param> /// <param name="parentId">父节点主键</param> /// <returns>影响行数</returns> public int BatchMoveTo(BaseUserInfo userInfo, string[] organizeIds, string parentId) { int result = 0; var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessUserCenterWriteDb(userInfo, parameter, (dbHelper) => { var manager = new BaseDepartmentManager(dbHelper, userInfo); for (int i = 0; i < organizeIds.Length; i++) { result += manager.MoveTo(organizeIds[i], parentId); } }); return(result); }
/// <summary> /// 获得列表 /// </summary> /// <param name="userInfo">用户</param> /// <param name="parentId">父亲节点主键</param> /// <returns>数据表</returns> public DataTable GetErrorDataTable(BaseUserInfo userInfo, string parentId) { var dt = new DataTable(BaseOrganizationEntity.CurrentTableName); var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessUserCenterReadDb(userInfo, parameter, (dbHelper) => { // 这里可以缓存起来,提高效率 var manager = new BaseOrganizationManager(dbHelper, userInfo); dt = manager.GetErrorDataTable(parentId); dt.DefaultView.Sort = BaseOrganizationEntity.FieldSortCode; dt.TableName = BaseOrganizationEntity.CurrentTableName; }); return(dt); }