/// <summary> /// 按主键数组获取列表 /// </summary> /// <param name="userInfo">用户</param> /// <param name="ids">组织机构主键</param> /// <returns>数据表</returns> public DataTable GetDataTableByIds(BaseUserInfo userInfo, string[] ids) { 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(BaseDepartmentEntity.FieldId, ids, BaseDepartmentEntity.FieldSortCode); dt.TableName = BaseDepartmentEntity.TableName; }); return(dt); }
/// <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="parentId">父节点</param> /// <returns>数据表</returns> public DataTable GetDataTableByParent(BaseUserInfo userInfo, string parentId) { var dt = new DataTable(BaseDepartmentEntity.TableName); var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessUserCenterReadDb(userInfo, parameter, (dbHelper) => { // 这里可以缓存起来,提高效率 var manager = new BaseDepartmentManager(dbHelper, userInfo); // 这里是条件字段 List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >(); parameters.Add(new KeyValuePair <string, object>(BaseDepartmentEntity.FieldParentId, parentId)); parameters.Add(new KeyValuePair <string, object>(BaseDepartmentEntity.FieldEnabled, 1)); parameters.Add(new KeyValuePair <string, object>(BaseDepartmentEntity.FieldDeletionStateCode, 0)); // 获取列表,指定排序字段 dt = manager.GetDataTable(parameters, BaseDepartmentEntity.FieldSortCode); dt.DefaultView.Sort = BaseDepartmentEntity.FieldSortCode; dt.TableName = BaseDepartmentEntity.TableName; }); return(dt); }