public void SerializerAndFilter() { JsonSerializer jsonSerializer = new JsonSerializer(); AndFilter andFilter = new AndFilter(); andFilter.AddFilter(new TermFilter("term1", "value1")); andFilter.AddFilter(new ExistsFilter("field")); string jsonString = jsonSerializer.Serialize(andFilter); Console.WriteLine(jsonString); }
public IList <CV_PM_WECHAT_NOTI> GetEntities(CV_PM_WECHAT_NOTI entity) { long totalRecords = 0; IList <CV_PM_WECHAT_NOTI> entities = new List <CV_PM_WECHAT_NOTI>(); try { AndFilter af = new AndFilter(); MatchingFilter mf = new MatchingFilter(); if (entity.AlertID != null) { mf.AddMatching("AlertID", entity.AlertID); } af.AddFilter(mf); entities = cV_PM_WECHAT_NOTIDAO.Find(0, -1, af, null, out totalRecords); } catch (Exception ex) { ExceptionPolicy.HandleException(ex, ExceptionPolicy.BusinessLogicDefaultPolicy); } return(entities); }
public IList <Plat_util_CodeDetail> GetByCodeBase(string codeBaseCode) { long totalRecords = 0; IList <Plat_util_CodeDetail> entities = null; try { AndFilter af = new AndFilter(); MatchingFilter mf = new MatchingFilter(); mf.AddMatching("CodeBaseCode", codeBaseCode); af.AddFilter(mf); Sort sort = new Sort(); sort.OrderBy("MySequence", Sort.Direction.ASC); entities = plat_util_CodeDetailDAO.Find(0, -1, af, sort, out totalRecords); } catch (Exception ex) { ExceptionPolicy.HandleException(ex, ExceptionPolicy.BusinessLogicDefaultPolicy); } return(entities); }
public CV_PM_ALT_ELEMENT GetEntity(Guid alertID, string column) { long totalRecords = 0; IList <CV_PM_ALT_ELEMENT> entities = null; try { AndFilter af = new AndFilter(); MatchingFilter mf = new MatchingFilter(); mf.AddMatching("AlertID", alertID); mf.AddMatching("ElementColumn", column); af.AddFilter(mf); entities = _CV_PM_ALT_ELEMENTDAO.Find(0, -1, af, null, out totalRecords); if (entities.Count > 0) { return(entities[0]); } } catch (Exception ex) { ExceptionPolicy.HandleException(ex, ExceptionPolicy.BusinessLogicDefaultPolicy); } return(null); }
public Plat_util_CodeDetail GetEntity(string codeBaseCode, string codeDetailValue) { long totalRecords = 0; IList <Plat_util_CodeDetail> entities = null; try { AndFilter af = new AndFilter(); MatchingFilter mf = new MatchingFilter(); mf.AddMatching("CodeBaseCode", codeBaseCode); mf.AddMatching("CodeDetailValue", codeDetailValue); af.AddFilter(mf); entities = plat_util_CodeDetailDAO.Find(0, -1, af, null, out totalRecords); if (entities.Count > 0) { return(entities[0]); } } catch (Exception ex) { ExceptionPolicy.HandleException(ex, ExceptionPolicy.BusinessLogicDefaultPolicy); } return(null); }
private IList <PM_WECHAT_DEPARTMENT> GetEntities(PM_WECHAT_DEPARTMENT entity) { long totalRecords = 0; IList <PM_WECHAT_DEPARTMENT> entities = new List <PM_WECHAT_DEPARTMENT>(); try { AndFilter af = new AndFilter(); MatchingFilter mf = new MatchingFilter(); if (entity.ID != null) { mf.AddMatching("ID", entity.ID); } af.AddFilter(mf); entities = PM_WECHAT_DEPARTMENTDAO.Find(0, -1, af, null, out totalRecords); } catch (Exception ex) { ExceptionPolicy.HandleException(ex, ExceptionPolicy.BusinessLogicDefaultPolicy); } return(entities); }
public IList <CV_PM_ALT_BASE> GetDataList(Dictionary <string, object> filter) { if (filter == null || filter.Count <= 0) { return(this.GetEntities()); } // long totalRecords = 0; IList <CV_PM_ALT_BASE> entities = null; try { AndFilter af = new AndFilter(); MatchingFilter mf = new MatchingFilter(); foreach (string key in filter.Keys) { mf.AddMatching(key, filter[key]); } af.AddFilter(mf); Sort sort = new Sort(); sort.OrderBy("AlertName", Sort.Direction.ASC); entities = _CV_PM_ALT_BASEDAO.Find(0, -1, af, sort, out totalRecords); } catch (Exception ex) { ExceptionPolicy.HandleException(ex, ExceptionPolicy.BusinessLogicDefaultPolicy); } return(entities); }
public CV_PM_ALT_BASE GetEntity(Guid alertID) { long totalRecords = 0; IList <CV_PM_ALT_BASE> entities = null; try { AndFilter af = new AndFilter(); MatchingFilter mf = new MatchingFilter(); mf.AddMatching("AlertID", alertID); af.AddFilter(mf); Sort sort = new Sort(); sort.OrderBy("AlertName", Sort.Direction.ASC); entities = _CV_PM_ALT_BASEDAO.Find(0, -1, af, sort, out totalRecords); if (entities.Count > 0) { return(entities[0]); } } catch (Exception ex) { ExceptionPolicy.HandleException(ex, ExceptionPolicy.BusinessLogicDefaultPolicy); } return(null); }
// public CV_PM_ALT_CRITERION GetEntity(Guid criterionID) { long totalRecords = 0; IList <CV_PM_ALT_CRITERION> entities = null; try { AndFilter af = new AndFilter(); MatchingFilter mf = new MatchingFilter(); mf.AddMatching("CriterionID", criterionID); af.AddFilter(mf); entities = _CV_PM_ALT_CRITERIONDAO.Find(0, -1, af, null, out totalRecords); if (entities.Count > 0) { return(entities[0]); } } catch (Exception ex) { ExceptionPolicy.HandleException(ex, ExceptionPolicy.BusinessLogicDefaultPolicy); } return(null); }
public IList <PM_ALT_MESSAGE> GetEntities(string MsgSubject, int sentCnt) { long totalRecords = 0; IList <PM_ALT_MESSAGE> entities = null; try { AndFilter af = new AndFilter(); MatchingFilter mf = new MatchingFilter(); if (!string.IsNullOrEmpty(MsgSubject)) { mf.AddMatching("MsgSubject", MsgSubject); } mf.AddMatching("SentCnt", sentCnt); af.AddFilter(mf); Sort sort = new Sort(); sort.OrderBy("MsgPK", Sort.Direction.ASC); entities = _PM_ALT_MESSAGEDAO.Find(0, -1, af, sort, out totalRecords); } catch (Exception ex) { ExceptionPolicy.HandleException(ex, ExceptionPolicy.BusinessLogicDefaultPolicy); } return(entities); }
public IList <CV_PM_ALT_CRITERION> GetActiveEntitiesByAlert(Guid alertID) { long totalRecords = 0; IList <CV_PM_ALT_CRITERION> entities = null; try { AndFilter af = new AndFilter(); MatchingFilter mf = new MatchingFilter(); mf.AddMatching("AlertID", alertID); mf.AddMatching("IsActive", true); af.AddFilter(mf); Sort sort = new Sort(); sort.OrderBy("Sequence", Sort.Direction.ASC); entities = _CV_PM_ALT_CRITERIONDAO.Find(0, -1, af, sort, out totalRecords); } catch (Exception ex) { ExceptionPolicy.HandleException(ex, ExceptionPolicy.BusinessLogicDefaultPolicy); } return(entities); }
//查询登录用户 /// <summary> /// 通过DepartmentGuid获取用户的信息 /// </summary> /// <param name="departmentGuid">部门主键</param> /// <returns>返回列表</returns> public IList <CV_PM_WECHAT_USER_DEPARTMENT> GetUsersByDepartmentGuid(Guid departmentGuid) { long totalRecords = 0; IList <CV_PM_WECHAT_USER_DEPARTMENT> entities = new List <CV_PM_WECHAT_USER_DEPARTMENT>(); try { AndFilter af = new AndFilter(); MatchingFilter mf = new MatchingFilter(); if (departmentGuid != null) { mf.AddMatching("DepartmentGuid", departmentGuid); } af.AddFilter(mf); entities = cV_PM_WECHAT_USER_DEPARTMENTDAO.Find(0, -1, af, null, out totalRecords); } catch (Exception ex) { ExceptionPolicy.HandleException(ex, ExceptionPolicy.BusinessLogicDefaultPolicy); } return(entities); }
// public PM_ALT_EVENT_TYPE GetEntity(string typeName) { long totalRecords = 0; IList <PM_ALT_EVENT_TYPE> entities = null; try { AndFilter af = new AndFilter(); MatchingFilter mf = new MatchingFilter(); mf.AddMatching("EventTypeName", typeName); af.AddFilter(mf); entities = _PM_ALT_EVENT_TYPEDAO.Find(0, -1, af, null, out totalRecords); if (entities.Count > 0) { return(entities[0]); } } catch (Exception ex) { ExceptionPolicy.HandleException(ex, ExceptionPolicy.BusinessLogicDefaultPolicy); } return(null); }
public PM_ALT_BASE GetEntityByID(string alertID) { long totalRecords = 0; IList <PM_ALT_BASE> entities = null; try { AndFilter af = new AndFilter(); MatchingFilter mf = new MatchingFilter(); mf.AddMatching("AlertID", alertID); mf.AddMatching("RowDeleted", false); af.AddFilter(mf); entities = _PM_ALT_BASEDAO.Find(0, -1, af, null, out totalRecords); if (entities.Count > 0) { return(entities[0]); } } catch (Exception ex) { ExceptionPolicy.HandleException(ex, ExceptionPolicy.BusinessLogicDefaultPolicy); } return(null); }
// public CV_PM_ALT_NOTI_GROUP_DETAIL GetEntity(Guid groupDtlID) { long totalRecords = 0; IList <CV_PM_ALT_NOTI_GROUP_DETAIL> entities = null; try { AndFilter af = new AndFilter(); MatchingFilter mf = new MatchingFilter(); mf.AddMatching("NotiGroupDetailID", groupDtlID); af.AddFilter(mf); entities = _CV_PM_ALT_NOTI_GROUP_DETAILDAO.Find(0, -1, af, null, out totalRecords); if (entities.Count > 0) { return(entities[0]); } } catch (Exception ex) { ExceptionPolicy.HandleException(ex, ExceptionPolicy.BusinessLogicDefaultPolicy); } return(null); }
private IFilter CreateFilter(CV_PM_ALT_LOGQueryParam qp) { ArgumentValidator.CheckForNullArgument(qp, "CV_PM_ALT_LOGQueryParam"); AndFilter af = new AndFilter(); MatchingFilter mf = new MatchingFilter(); if (!qp.IsDefaultValue("AlertAlias")) { mf.AddMatching("AlertAlias", qp.AlertAlias); } if (!qp.IsDefaultValue("LogTitle")) { mf.AddLike("LogTitle", qp.LogTitle); } if (!qp.IsDefaultValue("LogContent")) { mf.AddLike("LogContent", qp.LogContent); } if (!qp.IsDefaultValue("RespondedBy")) { mf.AddMatching("RespondedBy", qp.RespondedBy); } if (!qp.IsDefaultValue("IsClosed")) { mf.AddMatching("IsClosed", qp.IsClosed.Value); } if (!qp.IsDefaultValue("Z_RespondedOnBegin")) { mf.AddGreatEqualThan("RespondedOn", qp.Z_RespondedOnBegin.Value); } if (!qp.IsDefaultValue("Z_RespondedOnEnd")) { mf.AddLessEqualThan("RespondedOn", qp.Z_RespondedOnEnd.Value); } af.AddFilter(mf); return(af); }
// 获得当前用户同级部门的用户 public IList <CV_PM_WECHAT_USER_DEPARTMENT> GetUserDepartmentbyparentId(int parentID) { long totalRecords = 0; IList <CV_PM_WECHAT_USER_DEPARTMENT> entities = null; AndFilter af = new AndFilter(); MatchingFilter mf = new MatchingFilter(); mf.AddGreatThan("ParentID", parentID); af.AddFilter(mf); Sort sort = new Sort(); sort.OrderBy("UserGuid", Sort.Direction.ASC); entities = cV_PM_WECHAT_USER_DEPARTMENTDAO.Find(0, -1, af, sort, out totalRecords); return(entities); }
// 获得当前同级部门 public IList <CV_PM_WECHAT_DEPARTMENT> GetSameLevelDepartment(int parentID) { long totalRecords = 0; IList <CV_PM_WECHAT_DEPARTMENT> entities = null; AndFilter af = new AndFilter(); MatchingFilter mf = new MatchingFilter(); mf.AddGreatEqualThan("ParentID", parentID); //if (Guid.Empty != DepartmentGuid) // mf.AddMatching("DepartmentGuid", DepartmentGuid); af.AddFilter(mf); Sort sort = new Sort(); sort.OrderBy("DepartmentGuid", Sort.Direction.ASC); entities = cV_PM_WECHAT_DEPARTMENTDAO.Find(0, -1, af, sort, out totalRecords); return(entities); }
public IList <CV_PM_EMAIL_NOTI> GetEntity(string alertName) { long totalRecords = 0; IList <CV_PM_EMAIL_NOTI> entities = null; try { AndFilter af = new AndFilter(); MatchingFilter mf = new MatchingFilter(); mf.AddMatching("AlertID", alertName); af.AddFilter(mf); entities = cV_PM_EMAIL_NOTIDAO.Find(0, -1, af, null, out totalRecords); } catch (Exception ex) { ExceptionPolicy.HandleException(ex, ExceptionPolicy.BusinessLogicDefaultPolicy); } return(entities); }
/// <summary> /// 获取所有预警 /// </summary> /// <returns></returns> public IList <PM_ALT_BASE> GetAllEntities() { long totalRecords = 0; IList <PM_ALT_BASE> entities = null; try { AndFilter af = new AndFilter(); MatchingFilter mf = new MatchingFilter(); mf.AddMatching("RowDeleted", false); af.AddFilter(mf); entities = _PM_ALT_BASEDAO.Find(0, -1, af, null, out totalRecords); } catch (Exception ex) { ExceptionPolicy.HandleException(ex, ExceptionPolicy.BusinessLogicDefaultPolicy); } return(entities); }
// 通过userID获取用户部门的信息 public IList <CV_PM_WECHAT_USER_DEPARTMENT> GetUserDepartmentbyuserID(CV_PM_WECHAT_USER_DEPARTMENT qp) { long totalRecords = 0; IList <CV_PM_WECHAT_USER_DEPARTMENT> entities = null; AndFilter af = new AndFilter(); MatchingFilter mf = new MatchingFilter(); if (!string.IsNullOrEmpty(qp.UserID)) { mf.AddMatching("UserID", qp.UserID); } af.AddFilter(mf); Sort sort = new Sort(); sort.OrderBy("UserGuid", Sort.Direction.ASC); entities = cV_PM_WECHAT_USER_DEPARTMENTDAO.Find(0, -1, af, sort, out totalRecords); return(entities); }
private IFilter CreateFilter(CV_PM_ALT_EVENT_LOGQueryParam qp) { ArgumentValidator.CheckForNullArgument(qp, "CV_PM_ALT_EVENT_LOGQueryParam"); AndFilter af = new AndFilter(); MatchingFilter mf = new MatchingFilter(); if (!qp.IsDefaultValue("CreatedOn")) { mf.AddGreatEqualThan("CreatedOn", qp.CreatedOn.Value.Date); mf.AddLessThan("CreatedOn", qp.CreatedOn.Value.Date.AddDays(1)); } if (!qp.IsDefaultValue("EventTypeID")) { mf.AddMatching("EventTypeID", qp.EventTypeID); } if (!qp.IsDefaultValue("EventTypeName")) { mf.AddMatching("EventTypeName", qp.EventTypeName); } if (!qp.IsDefaultValue("IsFinished")) { mf.AddMatching("IsFinished", qp.IsFinished); } if (!qp.IsDefaultValue("CreatedBy")) { mf.AddMatching("CreatedBy", qp.CreatedBy); } // af.AddFilter(mf); // return(af); }
// public IList <CV_PM_ALT_USER> GetEntities() { long totalRecords = 0; IList <CV_PM_ALT_USER> entities = null; try { AndFilter af = new AndFilter(); MatchingFilter mf = new MatchingFilter(); mf.AddMatching("IsActiveEmployee", true); af.AddFilter(mf); Sort sort = new Sort(); sort.OrderBy("EmployeeCode", Sort.Direction.ASC); entities = _CV_PM_ALT_USERDAO.Find(0, -1, af, sort, out totalRecords); } catch (Exception ex) { ExceptionPolicy.HandleException(ex, ExceptionPolicy.BusinessLogicDefaultPolicy); } return(entities); }
// public IList <PM_ALT_MESSAGE> GetEntitiesToSend() { long totalRecords = 0; IList <PM_ALT_MESSAGE> entities = null; try { AndFilter af = new AndFilter(); MatchingFilter mf = new MatchingFilter(); mf.AddLessThan("SentCnt", 1); af.AddFilter(mf); Sort sort = new Sort(); sort.OrderBy("ModifiedOn", Sort.Direction.ASC); entities = _PM_ALT_MESSAGEDAO.Find(0, -1, af, sort, out totalRecords); } catch (Exception ex) { ExceptionPolicy.HandleException(ex, ExceptionPolicy.BusinessLogicDefaultPolicy); } return(entities); }
// public IList <CV_PM_ALT_EVENT_TYPE_GRP> GetEntities(Guid eventTypeID) { long totalRecords = 0; IList <CV_PM_ALT_EVENT_TYPE_GRP> entities = null; try { AndFilter af = new AndFilter(); MatchingFilter mf = new MatchingFilter(); mf.AddMatching("EventTypeID", eventTypeID); af.AddFilter(mf); Sort sort = new Sort(); sort.OrderBy("GroupName", Sort.Direction.ASC); entities = _CV_PM_ALT_EVENT_TYPE_GRPDAO.Find(0, -1, af, sort, out totalRecords); } catch (Exception ex) { ExceptionPolicy.HandleException(ex, ExceptionPolicy.BusinessLogicDefaultPolicy); } return(entities); }
public IList <CV_PM_ALT_NOTI_GROUP_DETAIL> GetEntitiesByGroup(Guid groupID) { long totalRecords = 0; IList <CV_PM_ALT_NOTI_GROUP_DETAIL> entities = null; try { AndFilter af = new AndFilter(); MatchingFilter mf = new MatchingFilter(); mf.AddMatching("NotiGroupID", groupID); af.AddFilter(mf); Sort sort = new Sort(); sort.OrderBy("MemberID", Sort.Direction.ASC); entities = _CV_PM_ALT_NOTI_GROUP_DETAILDAO.Find(0, -1, af, sort, out totalRecords); } catch (Exception ex) { ExceptionPolicy.HandleException(ex, ExceptionPolicy.BusinessLogicDefaultPolicy); } return(entities); }
public IList <CV_PM_WECHAT_USER_DEPARTMENT> GetUserFromDep(string departmentID) { long totalRecords = 0; IList <CV_PM_WECHAT_USER_DEPARTMENT> entities = null; try { Sort sort = new Sort(); sort.OrderBy("Order", Sort.Direction.ASC); AndFilter af = new AndFilter(); MatchingFilter mf = new MatchingFilter(); mf.AddMatching("DepartmentID", departmentID); af.AddFilter(mf); entities = cV_PM_WECHAT_USER_DEPARTMENTDAO.Find(0, -1, af, null, out totalRecords); } catch (Exception ex) { ExceptionPolicy.HandleException(ex, ExceptionPolicy.BusinessLogicDefaultPolicy); } return(entities); }
public IList <CV_PM_ALT_BASE> GetEntities(CV_PM_ALT_BASE entity) { long totalRecords = 0; IList <CV_PM_ALT_BASE> entities = null; try { AndFilter af = new AndFilter(); MatchingFilter mf = new MatchingFilter(); if (!string.IsNullOrEmpty(entity.Category)) { mf.AddLike("Category", entity.Category); } if (!string.IsNullOrEmpty(entity.AlertName)) { mf.AddLike("AlertName", entity.AlertName); } if (!string.IsNullOrEmpty(entity.AlertAlias)) { mf.AddLike("AlertAlias", entity.AlertAlias); } if (!string.IsNullOrEmpty(entity.AlertDesc)) { mf.AddLike("AlertDesc", entity.AlertDesc); } if (!string.IsNullOrEmpty(entity.AlertContent)) { mf.AddLike("AlertContent", entity.AlertContent); } if (entity.AlertType.HasValue && entity.AlertType != 0) { mf.AddMatching("AlertType", entity.AlertType); } if (!string.IsNullOrEmpty(entity.Format)) { mf.AddMatching("Format", entity.Format); } if (!string.IsNullOrEmpty(entity.AlertObject)) { mf.AddMatching("AlertObject", entity.AlertObject); } if (!string.IsNullOrEmpty(entity.PreProcedure)) { mf.AddMatching("PreProcedure", entity.PreProcedure); } if (!string.IsNullOrEmpty(entity.PostProcedure)) { mf.AddMatching("PostProcedure", entity.PostProcedure); } if (entity.AlertInterval.HasValue && entity.AlertInterval != 0) { mf.AddMatching("AlertInterval", entity.Category); } if (!string.IsNullOrEmpty(entity.AlertTimePoints)) { mf.AddMatching("AlertTimePoints", entity.AlertTimePoints); } //if (entity.LastAlertedTime.HasValue) //{ // mf.AddMatching("LastAlertedTime", entity.LastAlertedTime); //} if (entity.IsActive.HasValue) { mf.AddMatching("IsActive", entity.IsActive); } if (entity.RowDeleted.HasValue) { mf.AddMatching("RowDeleted", entity.RowDeleted); } if (!string.IsNullOrEmpty(entity.CreatedBy)) { mf.AddMatching("CreatedBy", entity.CreatedBy); } //if (entity.CreatedOn.HasValue) //{ // mf.AddMatching("CreatedOn", entity.CreatedOn); //} if (!string.IsNullOrEmpty(entity.ModifiedBy)) { mf.AddMatching("ModifiedBy", entity.ModifiedBy); } //if (entity.ModifiedOn.HasValue) //{ // mf.AddMatching("ModifiedOn", entity.ModifiedOn); //} af.AddFilter(mf); Sort sort = new Sort(); sort.OrderBy("AlertName", Sort.Direction.ASC); entities = _CV_PM_ALT_BASEDAO.Find(0, -1, af, sort, out totalRecords); } catch (Exception ex) { ExceptionPolicy.HandleException(ex, ExceptionPolicy.BusinessLogicDefaultPolicy); } return(entities); }