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 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);
}
//查询登录用户
/// <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 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 <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 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 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);
}
//
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);
}
//
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 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 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 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 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 Pb.Filter ConvertToPBFilter()
{
var internalFilter = new Pb.WhileMatchFilter
{
Filter = MatchingFilter.ConvertToPBFilter()
};
var filter = new Pb.Filter
{
Name = Name,
SerializedFilter = internalFilter.ToByteString()
};
return(filter);
}
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);
}
/// <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);
}
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);
}
// 通过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_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 <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_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 <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 CV_PM_ALT_LOG GetEntity(long logPK)
{
long totalRecords = 0;
IList <CV_PM_ALT_LOG> entities = null;
try
{
AndFilter af = new AndFilter();
MatchingFilter mf = new MatchingFilter();
mf.AddMatching("LogPK", logPK);
entities = _CV_PM_ALT_LOGDAO.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 <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);
}
