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_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_BASE GetEntity(string alertName)
{
long totalRecords = 0;
IList <CV_PM_ALT_BASE> entities = null;
try
{
AndFilter af = new AndFilter();
MatchingFilter mf = new MatchingFilter();
mf.AddMatching("AlertName", alertName);
af.AddFilter(mf);
entities = _CV_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);
}
//查询登录用户
/// <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 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 PM_ALT_NOTI_GROUP GetEntity(string groupName)
{
long totalRecords = 0;
IList <PM_ALT_NOTI_GROUP> entities = null;
try
{
AndFilter af = new AndFilter();
MatchingFilter mf = new MatchingFilter();
mf.AddMatching("GroupName", groupName);
af.AddFilter(mf);
entities = _PM_ALT_NOTI_GROUPDAO.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_COND GetEntity(Guid conditionID)
{
long totalRecords = 0;
IList <CV_PM_ALT_CRITERION_COND> entities = null;
try
{
AndFilter af = new AndFilter();
MatchingFilter mf = new MatchingFilter();
mf.AddMatching("ConditionID", conditionID);
af.AddFilter(mf);
entities = _CV_PM_ALT_CRITERION_CONDDAO.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);
}
// 通过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);
}
//
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_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_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_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);
}
