public IQueryable <Document> Build(ObjectContext context) { var defRepo = new DocDefRepository(UserId); if (DocDefId == Guid.Empty) { DocDefId = defRepo.DocDefByName(DocDefName).Id; } var descIds = defRepo.GetDocDefDescendant(DocDefId).ToList(); return(from doc in ((cissaEntities)context).Documents where descIds.Contains(doc.Def_Id ?? Guid.Empty) && (doc.Deleted == null || doc.Deleted == false) select doc); }
public DocDef GetDocDef() { var defRepo = new DocDefRepository(UserId); DocDef docDef; if (DocDefId == Guid.Empty) { docDef = defRepo.DocDefByName(DocDefName); DocDefId = docDef.Id; } else { docDef = defRepo.DocDefById(DocDefId); } return(docDef); }
/// <summary> /// Метод для очищения кэша /// </summary> public void ClearCache() { DocRepository.DocCache.Clear(); // DocDefRepository.DocDefCache.Clear(); DocDefRepository.DocDefDescendantCache.Clear(); /*lock(DocDefRepository.DocDefNameCacheLock) * DocDefRepository.DocDefNameCache.Clear();*/ // DocDefRepository.ClearDocDefNameCache(); // lock(DocDefRepository.TypeDefCacheLock) //DocDefRepository.TypeDefCache.Clear(); // DocDefRepository.ClearTypeDefCache(); DocDefRepository.ClearCaches(); UserRepository.UserInfoCache.Clear(); UserRepository.UserOrgCache.Clear(); OrgRepository.OrgInfoCache.Clear(); OrgRepository.OrgTypeInfoCache.Clear(); OrgRepository.OrgPositionInfoCache.Clear(); OrgRepository.OrganizationListCache.Clear(); /*FormRepository.DetailFormCache.Clear(); * FormRepository.TableFormCache.Clear();*/ FormRepository.ClearCaches(); // WorkflowRepository.ActivityCache.Clear(); // WorkflowRepository.ProcessCache.Clear(); // lock (WorkflowRepository.WorkflowProcessStartActivityLock) // WorkflowRepository.ProcessStartActivities.Clear(); // WorkflowRepository.GateCache.Clear(); // WorkflowRepository.GateRefCache.Clear(); WorkflowRepository.ClearCaches(); PermissionRepository.ObjectDefPermissionCache.Clear(); PermissionRepository.UserPermissionCache.Clear(); PermissionRepository.OrgPositionPermissionCache.Clear(); PermissionRepository.OrgUnitPermissionCache.Clear(); PermissionRepository.RoleListCache.Clear(); EnumRepository.EnumDefCache.Clear(); LanguageRepository.ClearCache(); DocStateRepository.DocStateTypeCache.Clear(); // lock (ScriptManager.ScriptLoadLock) ScriptManager.ClearCaches(); DocumentTableMapRepository.ClearMaps(); // lock (QueryRepository.QueryDefCacheLock) QueryRepository.QueryDefCache.Clear(); }
public DocDef GetDocDef(QueryDef def) { using (var defRepo = new DocDefRepository(DataContext, def.UserId)) { DocDef docDef; if (def.Source != null && def.DocDefId == Guid.Empty) { docDef = defRepo.DocDefByName(def.DocDefName); def.Source.DocDefId = docDef.Id; } else { docDef = defRepo.DocDefById(def.DocDefId); } return(docDef); } }
public override IQueryable <Document> Build(DocDef docDef, ObjectContext context, Guid userId) { var em = (cissaEntities)context; var source = BuildSource(docDef, context, userId); if (docDef.Attributes == null) { var defRepo = new DocDefRepository(userId); docDef = defRepo.DocDefById(docDef.Id); } var attr = docDef.Attributes.First(a => String.Compare(a.Name, AttributeName, true) == 0); if (Conditions.Count == 0) { if (attr.Type.Id == (short)CissaDataType.Text) { var text = Value != null?Value.ToString() : ""; switch (Condition) { case ConditionOperation.Equal: return(source.Intersect( em.Text_Attributes.Include("Documents") .Where(a => a.Def_Id == attr.Id && a.Value == text && a.Expired >= MaxDate) .Select(a => a.Document))); case ConditionOperation.NotEqual: return(source.Intersect( em.Text_Attributes.Include("Documents") .Where(a => a.Def_Id == attr.Id && a.Value != text && a.Expired >= MaxDate) .Select(a => a.Document))); case ConditionOperation.Contains: return(source.Intersect( em.Text_Attributes.Include("Documents") .Where(a => a.Def_Id == attr.Id && a.Value.Contains(text) && a.Expired >= MaxDate) .Select(a => a.Document))); case ConditionOperation.IsNull: return(source.Intersect( em.Text_Attributes.Include("Documents") .Where(a => a.Def_Id == attr.Id && a.Value == null && a.Expired >= MaxDate) .Select(a => a.Document))); default: throw new ApplicationException("Cannot apply operator for Text attribute"); } } if (attr.Type.Id == (short)CissaDataType.Int) { var val = Value != null?Convert.ToInt32(Value) : 0; switch (Condition) { case ConditionOperation.Equal: return(source.Intersect( em.Int_Attributes.Include("Documents") .Where(a => a.Def_Id == attr.Id && a.Value == val && a.Expired >= MaxDate) .Select(a => a.Document))); case ConditionOperation.NotEqual: return(source.Intersect( em.Int_Attributes.Include("Documents") .Where(a => a.Def_Id == attr.Id && a.Value != val && a.Expired >= MaxDate) .Select(a => a.Document))); case ConditionOperation.GreatEqual: return(source.Intersect( em.Int_Attributes.Include("Documents") .Where(a => a.Def_Id == attr.Id && a.Value >= val && a.Expired >= MaxDate) .Select(a => a.Document))); case ConditionOperation.GreatThen: return(source.Intersect( em.Int_Attributes.Include("Documents") .Where(a => a.Def_Id == attr.Id && a.Value > val && a.Expired >= MaxDate) .Select(a => a.Document))); case ConditionOperation.LessEqual: return(source.Intersect( em.Int_Attributes.Include("Documents") .Where(a => a.Def_Id == attr.Id && a.Value <= val && a.Expired >= MaxDate) .Select(a => a.Document))); case ConditionOperation.LessThen: return(source.Intersect( em.Int_Attributes.Include("Documents") .Where(a => a.Def_Id == attr.Id && a.Value < val && a.Expired >= MaxDate) .Select(a => a.Document))); case ConditionOperation.IsNotNull: return(source.Intersect( em.Int_Attributes.Include("Documents") .Where(a => a.Def_Id == attr.Id && a.Expired >= MaxDate) .Select(a => a.Document))); default: throw new ApplicationException("Cannot apply operator for Int attribute"); } } if (attr.Type.Id == (short)CissaDataType.Float) { var val = Value != null?Convert.ToDouble(Value) : 0; switch (Condition) { case ConditionOperation.Equal: return(source.Intersect( em.Float_Attributes.Include("Documents") .Where(a => a.Def_Id == attr.Id && a.Value == val && a.Expired >= MaxDate) .Select(a => a.Document))); case ConditionOperation.NotEqual: return(source.Intersect( em.Float_Attributes.Include("Documents") .Where(a => a.Def_Id == attr.Id && a.Value != val && a.Expired >= MaxDate) .Select(a => a.Document))); case ConditionOperation.GreatEqual: return(source.Intersect( em.Float_Attributes.Include("Documents") .Where(a => a.Def_Id == attr.Id && a.Value >= val && a.Expired >= MaxDate) .Select(a => a.Document))); case ConditionOperation.GreatThen: return(source.Intersect( em.Float_Attributes.Include("Documents") .Where(a => a.Def_Id == attr.Id && a.Value > val && a.Expired >= MaxDate) .Select(a => a.Document))); case ConditionOperation.LessEqual: return(source.Intersect( em.Float_Attributes.Include("Documents") .Where(a => a.Def_Id == attr.Id && a.Value <= val && a.Expired >= MaxDate) .Select(a => a.Document))); case ConditionOperation.LessThen: return(source.Intersect( em.Float_Attributes.Include("Documents") .Where(a => a.Def_Id == attr.Id && a.Value < val && a.Expired >= MaxDate) .Select(a => a.Document))); case ConditionOperation.IsNotNull: return(source.Intersect( em.Float_Attributes.Include("Documents") .Where(a => a.Def_Id == attr.Id && a.Expired >= MaxDate) .Select(a => a.Document))); default: throw new ApplicationException("Cannot apply operator for Float attribute"); } } if (attr.Type.Id == (short)CissaDataType.Currency) { var val = Value != null?Convert.ToDecimal(Value) : 0; switch (Condition) { case ConditionOperation.Equal: return(source.Intersect( em.Currency_Attributes.Include("Documents") .Where(a => a.Def_Id == attr.Id && a.Value == val && a.Expired >= MaxDate) .Select(a => a.Document))); case ConditionOperation.NotEqual: return(source.Intersect( em.Currency_Attributes.Include("Documents") .Where(a => a.Def_Id == attr.Id && a.Value != val && a.Expired >= MaxDate) .Select(a => a.Document))); case ConditionOperation.GreatEqual: return(source.Intersect( em.Currency_Attributes.Include("Documents") .Where(a => a.Def_Id == attr.Id && a.Value >= val && a.Expired >= MaxDate) .Select(a => a.Document))); case ConditionOperation.GreatThen: return(source.Intersect( em.Currency_Attributes.Include("Documents") .Where(a => a.Def_Id == attr.Id && a.Value > val && a.Expired >= MaxDate) .Select(a => a.Document))); case ConditionOperation.LessEqual: return(source.Intersect( em.Currency_Attributes.Include("Documents") .Where(a => a.Def_Id == attr.Id && a.Value <= val && a.Expired >= MaxDate) .Select(a => a.Document))); case ConditionOperation.LessThen: return(source.Intersect( em.Currency_Attributes.Include("Documents") .Where(a => a.Def_Id == attr.Id && a.Value < val && a.Expired >= MaxDate) .Select(a => a.Document))); case ConditionOperation.IsNotNull: return(source.Intersect( em.Currency_Attributes.Include("Documents") .Where(a => a.Def_Id == attr.Id && a.Expired >= MaxDate) .Select(a => a.Document))); default: throw new ApplicationException("Cannot apply operator for Currency attribute"); } } if (attr.Type.Id == (short)CissaDataType.DateTime) { var val = Value != null?Convert.ToDateTime(Value) : DateTime.MinValue; switch (Condition) { case ConditionOperation.Equal: return(source.Intersect( em.Date_Time_Attributes.Include("Documents") .Where(a => a.Def_Id == attr.Id && a.Value == val && a.Expired >= MaxDate) .Select(a => a.Document))); case ConditionOperation.NotEqual: return(source.Intersect( em.Date_Time_Attributes.Include("Documents") .Where(a => a.Def_Id == attr.Id && a.Value != val && a.Expired >= MaxDate) .Select(a => a.Document))); case ConditionOperation.GreatEqual: return(source.Intersect( em.Date_Time_Attributes.Include("Documents") .Where(a => a.Def_Id == attr.Id && a.Value >= val && a.Expired >= MaxDate) .Select(a => a.Document))); case ConditionOperation.GreatThen: return(source.Intersect( em.Date_Time_Attributes.Include("Documents") .Where(a => a.Def_Id == attr.Id && a.Value > val && a.Expired >= MaxDate) .Select(a => a.Document))); case ConditionOperation.LessEqual: return(source.Intersect( em.Date_Time_Attributes.Include("Documents") .Where(a => a.Def_Id == attr.Id && a.Value <= val && a.Expired >= MaxDate) .Select(a => a.Document))); case ConditionOperation.LessThen: return(source.Intersect( em.Date_Time_Attributes.Include("Documents") .Where(a => a.Def_Id == attr.Id && a.Value < val && a.Expired >= MaxDate) .Select(a => a.Document))); case ConditionOperation.IsNotNull: return(source.Intersect( em.Date_Time_Attributes.Include("Documents") .Where(a => a.Def_Id == attr.Id && a.Expired >= MaxDate) .Select(a => a.Document))); default: throw new ApplicationException("Cannot apply operator for DateTime attribute"); } } if (attr.Type.Id == (short)CissaDataType.Bool) { var val = Value != null?Convert.ToBoolean(Value) : false; switch (Condition) { case ConditionOperation.Equal: return(source.Intersect( em.Boolean_Attributes.Include("Documents") .Where(a => a.Def_Id == attr.Id && a.Value == val && a.Expired >= MaxDate) .Select(a => a.Document))); case ConditionOperation.NotEqual: return(source.Intersect( em.Boolean_Attributes.Include("Documents") .Where(a => a.Def_Id == attr.Id && a.Value != val && a.Expired >= MaxDate) .Select(a => a.Document))); case ConditionOperation.IsNotNull: return(source.Intersect( em.Boolean_Attributes.Include("Documents") .Where(a => a.Def_Id == attr.Id && a.Expired >= MaxDate) .Select(a => a.Document))); default: throw new ApplicationException("Cannot apply operator for Bool attribute"); } } if (attr.Type.Id == (short)CissaDataType.Enum) { var val = Value != null?Value.ToString() : ""; Guid enumId; if (!Guid.TryParse(val, out enumId)) { var enumRepo = new EnumRepository(); enumId = enumRepo.GetEnumValueId(attr.EnumDefType.Id, val); } switch (Condition) { case ConditionOperation.Equal: return(source.Intersect( em.Enum_Attributes.Include("Documents") .Where(a => a.Def_Id == attr.Id && a.Value == enumId && a.Expired >= MaxDate) .Select(a => a.Document))); case ConditionOperation.NotEqual: return(source.Intersect( em.Enum_Attributes.Include("Documents") .Where(a => a.Def_Id == attr.Id && a.Value != enumId && a.Expired >= MaxDate) .Select(a => a.Document))); case ConditionOperation.IsNotNull: return(source.Intersect( em.Enum_Attributes.Include("Documents") .Where(a => a.Def_Id == attr.Id && a.Expired >= MaxDate) .Select(a => a.Document))); default: throw new ApplicationException("Cannot apply operator for Enum attribute"); } } if (attr.Type.Id == (short)CissaDataType.Doc) { var val = Value != null?Value.ToString() : ""; var docId = Guid.Empty; var hasDocId = Guid.TryParse(val, out docId); if (Condition == ConditionOperation.Is) { DocDef isDocDef = null; var defRepo = new DocDefRepository(); isDocDef = hasDocId ? defRepo.DocDefById(docId) : defRepo.DocDefByName(val); var descendants = defRepo.GetDocDefDescendant(isDocDef.Id); var docs = em.Documents.Where( d => d.Def_Id != null && descendants.Contains(d.Def_Id ?? Guid.Empty) && (d.Deleted == null || d.Deleted == false)).Select(d => d.Id); return(source.Intersect( em.Document_Attributes.Include("Documents") .Where(a => a.Def_Id == attr.Id && docs.Contains(a.Value) && a.Expired >= MaxDate) .Select(a => a.Document))); } if (!hasDocId) { throw new ApplicationException("Invalid argument type for Document attribute"); } switch (Condition) { case ConditionOperation.Equal: return(source.Intersect( em.Document_Attributes.Include("Documents") .Where(a => a.Def_Id == attr.Id && a.Value == docId && a.Expired >= MaxDate) .Select(a => a.Document))); case ConditionOperation.NotEqual: return(source.Intersect( em.Document_Attributes.Include("Documents") .Where(a => a.Def_Id == attr.Id && a.Value != docId && a.Expired >= MaxDate) .Select(a => a.Document))); case ConditionOperation.IsNotNull: return(source.Intersect( em.Document_Attributes.Include("Documents") .Where(a => a.Def_Id == attr.Id && a.Expired >= MaxDate) .Select(a => a.Document))); default: throw new ApplicationException("Cannot apply operator for Document attribute"); } } throw new ApplicationException("Не могу сформировать запрос. Данный тип не поддерживается!"); } if (attr.Type.Id != (short)CissaDataType.Doc && attr.Type.Id != (short)CissaDataType.DocList) { throw new ApplicationException("Ошибка в запросе! Атрибут не является документным."); } foreach (var condition in Conditions) { var sq = condition.Build(attr.DocDefType, context, userId); var sub = attr.Type.Id == (short)CissaDataType.DocList ? em.DocumentList_Attributes.Include("Documents") .Where(a => sq.Select(d => d.Id).Contains(a.Value) && a.Expired >= MaxDate) .Select(a => a.Document) : em.Document_Attributes.Include("Documents") .Where(a => sq.Select(d => d.Id).Contains(a.Value) && a.Expired >= MaxDate) .Select(a => a.Document); source = source.Intersect(sub); } return(source); }