public static void IsPosibleDelete(long oid) { QueryConditions conditions = new QueryConditions { WorkReportCategory = WorkReportCategoryInfo.New(oid), }; }
public static WorkReportResourceList GetByCategoryList(long oidCategory, List <long> oidExpedients, bool clustered, bool childs = true) { QueryConditions conditions = new QueryConditions { OidList = oidExpedients, WorkReportCategory = (oidCategory != 0) ? WorkReportCategoryInfo.New(oidCategory) : null, Orders = new OrderList() }; conditions.Orders.NewOrder("CategoryMax", ListSortDirection.Ascending, typeof(WorkReportCategory)); if (clustered) { conditions.Groups = new GroupList(); conditions.Groups.NewGroup("OidCategory", typeof(WorkReportResource)); } return(GetList(WorkReportResource.SELECT_BY_EXPEDIENTS(conditions, false), childs)); }
public static WorkReportResourceList GetByCategoryList(long oidCategory, long oidExpedient, bool clustered, bool childs = true) { QueryConditions conditions = new QueryConditions { Expedient = (oidExpedient != 0) ? ExpedientInfo.New(oidExpedient) : null, WorkReportCategory = (oidCategory != 0) ? WorkReportCategoryInfo.New(oidCategory) : null, Orders = new OrderList() }; conditions.Orders.NewOrder("CategoryMax", ListSortDirection.Ascending, typeof(WorkReportCategory)); if (clustered) { conditions.Groups = new GroupList(); conditions.Groups.NewGroup("OidCategory", typeof(WorkReportResource)); } return(GetList(SELECT(conditions), childs)); }
internal static string SELECT(long oid, bool lockTable) { return(SELECT(new QueryConditions { WorkReportCategory = WorkReportCategoryInfo.New(oid) }, lockTable)); }