/// <summary> /// 根据接收类型获得公告通知信息列表 /// </summary> /// <param name="NoticeType">消息类型</param> /// <param name="CompanyId">公司编号</param> /// <param name="Type">接收类型</param> /// <param name="PageSize">页面数据总记录数</param> /// <param name="PageIndex">当前页数</param> /// <param name="RecordCount">每页显示的记录数</param> /// <returns></returns> public IList <Model.GovStructure.MGovNotice> GetGovNoticeList(string NoticeType, string CompanyId, EyouSoft.Model.EnumType.GovStructure.ItemType Type, int PageSize, int PageIndex, ref int RecordCount) { IList <Model.GovStructure.MGovNotice> list = null; if (!string.IsNullOrEmpty(CompanyId)) { list = new List <Model.GovStructure.MGovNotice>(); return(dal.GetGovNoticeList(NoticeType, CompanyId, Type, ItemType, PageSize, PageIndex, ref RecordCount)); } return(list); }
/// <summary> /// 根据接收类型获得公告通知信息列表 /// </summary> /// <param name="NoticeType">消息类型</param> /// <param name="CompanyId">公司编号</param> /// <param name="Type">接收类型</param> /// <param name="ItemType">附件类型</param> /// <param name="PageSize">页面数据总记录数</param> /// <param name="PageIndex">当前页数</param> /// <param name="RecordCount">每页显示的记录数</param> /// <returns></returns> public IList <Model.GovStructure.MGovNotice> GetGovNoticeList(string NoticeType, string CompanyId, EyouSoft.Model.EnumType.GovStructure.ItemType Type, EyouSoft.Model.EnumType.ComStructure.AttachItemType ItemType, int PageSize, int PageIndex, ref int RecordCount) { IList <EyouSoft.Model.GovStructure.MGovNotice> ResultList = null; string tableName = "view_GovNotice"; string identityColumnName = "NoticeId"; string fields = "NoticeId,CompanyId,Title,IsRemind,[Views],DepartId,Operator,OperatorId,IssueTime "; string query = string.Format(" (NoticeType='{0}') AND CompanyId='{1}'", NoticeType, CompanyId); query = query + string.Format(" AND CAST(NoticeReceiverXML AS XML).exist('/ROOT/row/@ItemType[.=\"{0}\"]') = 1", (int)Type); string orderByString = " IssueTime DESC"; using (IDataReader dr = EyouSoft.Toolkit.DAL.DbHelper.ExecuteReader(_db, PageSize, PageIndex, ref RecordCount, tableName, identityColumnName, fields, query, orderByString)) { ResultList = new List <EyouSoft.Model.GovStructure.MGovNotice>(); while (dr.Read()) { EyouSoft.Model.GovStructure.MGovNotice model = new EyouSoft.Model.GovStructure.MGovNotice() { NoticeId = dr.GetString(dr.GetOrdinal("NoticeId")), CompanyId = dr.GetString(dr.GetOrdinal("CompanyId")), Title = dr.IsDBNull(dr.GetOrdinal("Title")) ? "" : dr.GetString(dr.GetOrdinal("Title")), //Content = dr.IsDBNull(dr.GetOrdinal("Content")) ? "" : dr.GetString(dr.GetOrdinal("Content")), IsRemind = dr.GetString(dr.GetOrdinal("IsRemind")) == "1" ? true : false, Views = dr.IsDBNull(dr.GetOrdinal("Views")) ? 0 : dr.GetInt32(dr.GetOrdinal("Views")), OperatorId = dr.GetString(dr.GetOrdinal("OperatorId")), IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")), Operator = dr.IsDBNull(dr.GetOrdinal("Operator")) ? "" : dr.GetString(dr.GetOrdinal("Operator")), //MGovNoticeReceiverList = this.GetNoticeReceiveList(dr["NoticeReceiverXML"].ToString()), //ComAttachList = this.GetAttachList(dr["ComAttachXML"].ToString(), dr.GetString(dr.GetOrdinal("NoticeId")), ItemType) }; ResultList.Add(model); model = null; } }; return(ResultList); }