/// <summary> /// 依主键数组得到数据 /// </summary> /// <param name="userInfo">用户</param> /// <param name="ids">主鍵</param> /// <returns>DataTable</returns> public DataTable GetDTByIds(UserInfo userInfo, string[] ids) { var dataTable = new DataTable(PiOrganizeTable.TableName); var parameter = ParameterUtil.CreateWithMessage(userInfo, MethodBase.GetCurrentMethod(), this.serviceName, RDIFrameworkMessage.OrganizeService_GetDTByIds); ServiceUtil.ProcessRDIReadDb(userInfo, parameter, dbProvider => { var manager = new PiOrganizeManager(dbProvider, userInfo); dataTable = manager.GetDT(PiOrganizeTable.FieldId, ids, PiOrganizeTable.FieldSortCode); dataTable.TableName = PiOrganizeTable.TableName; }); return(dataTable); }
/// <summary> /// 依据相应条件获取数据 /// </summary> /// <param name="userInfo">用户</param> /// <param name="names">字段</param> /// <param name="values">值</param> /// <returns>DataTable</returns> public DataTable GetDTByValues(UserInfo userInfo, string[] names, object[] values) { var dataTable = new DataTable(PiOrganizeTable.TableName); var parameter = ParameterUtil.CreateWithLog(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessRDIReadDb(userInfo, parameter, dbProvider => { var manager = new PiOrganizeManager(dbProvider, userInfo); dataTable = manager.GetDT(names, values); dataTable.TableName = PiOrganizeTable.TableName; }); return(dataTable); }
/// <summary> /// 按父节点获取列表 /// </summary> /// <param name="userInfo">用户</param> /// <param name="parentId">父节点</param> /// <returns>数据表</returns> public DataTable GetDTByParent(UserInfo userInfo, string parentId) { var dataTable = new DataTable(PiOrganizeTable.TableName); var parameter = ParameterUtil.CreateWithMessage(userInfo, MethodBase.GetCurrentMethod(), this.serviceName, RDIFrameworkMessage.OrganizeService_GetDTByParent); ServiceUtil.ProcessRDIReadDb(userInfo, parameter, dbProvider => { var organizeManager = new PiOrganizeManager(dbProvider, userInfo); dataTable = organizeManager.GetDT(PiOrganizeTable.FieldParentId, parentId, PiOrganizeTable.FieldDeleteMark, 0, PiOrganizeTable.FieldSortCode); dataTable.DefaultView.Sort = PiOrganizeTable.FieldSortCode; dataTable.TableName = PiOrganizeTable.TableName; }); return(dataTable); }