public static List<Notice> GetNoticeListByCatalog(UserInfo User, int Catalog)
{
LogWriter.WriteLog("NoticeService.GetNoticeListByCatalog:UserName="******",Catalog=" + Catalog.ToString());
IList<PN_Notice> notices = null;
string condition = "PN_Notice.ToAllStaff='Y' AND IsDelete ='N' AND PN_Notice.ApproveFlag=1";
condition += " AND MCS_SYS.dbo.UF_Spilt2('MCS_OA.dbo.PN_Notice',ExtPropertys,'Catalog')='" + Catalog.ToString() + "'";
condition += " AND (PN_Notice.ToAllOrganizeCity='Y' OR PN_Notice.ID IN (SELECT NoticeID FROM PN_ToOrganizeCity WHERE OrganizeCity=" + User.OrganizeCity.ToString() + "))";
notices = PN_NoticeBLL.GetModelList(condition);
if (notices == null) return null;
List<Notice> lists = new List<Notice>(notices.Count);
foreach (PN_Notice item in notices.OrderByDescending(p => p.InsertTime))
{
Notice n = new Notice(item);
n.HasRead = PN_HasReadUserBLL.IsRead(n.ID, User.UserName);
lists.Add(n);
}
return lists;
}
/// <summary>
/// 获取通知列表
/// </summary>
/// <param name="AuthKey"></param>
/// <returns></returns>
public static List<Notice> GetMyNoticeList(UserInfo User)
{
LogWriter.WriteLog("NoticeService.GetMyNoticeList:UserName="******"PN_Notice.ToAllStaff='Y' AND IsDelete ='N' AND PN_Notice.ApproveFlag=1";
condition += " AND (PN_Notice.ToAllOrganizeCity='Y' OR PN_Notice.ID IN (SELECT NoticeID FROM PN_ToOrganizeCity WHERE OrganizeCity=" + User.OrganizeCity.ToString() + "))";
notices = PN_NoticeBLL.GetModelList(condition);
}
if (notices == null) return null;
List<Notice> lists = new List<Notice>(notices.Count);
foreach (PN_Notice item in notices.OrderByDescending(p => p.InsertTime))
{
Notice n = new Notice(item);
n.HasRead = PN_HasReadUserBLL.IsRead(n.ID, User.UserName);
lists.Add(n);
}
return lists;
}
