/// <summary> /// 获得公告通知实体 /// </summary> /// <param name="NoticeId">公告通知ID</param> /// <param name="ItemType">附件类型</param> /// <returns></returns> public EyouSoft.Model.GovStructure.MGovNotice GetGovNoticeModel(string NoticeId, EyouSoft.Model.EnumType.ComStructure.AttachItemType ItemType) { EyouSoft.Model.GovStructure.MGovNotice model = null; StringBuilder StrSql = new StringBuilder(); StrSql.Append("SELECT NoticeId,CompanyId,Title,[Content],IsRemind,IsMsg,MsgContent,DepartId,[Views],Operator,OperatorId,IssueTime, "); StrSql.AppendFormat(" (SELECT Name,FilePath,Size,Downloads FROM tbl_ComAttach WHERE ItemType={0} AND ItemId=a.NoticeId FOR XML RAW,ROOT('ROOT'))AS ComAttachXML,", (int)ItemType); StrSql.Append(" (SELECT ItemType,ItemId FROM tbl_GovNoticeReceiver WHERE NoticeId=a.NoticeId FOR XML RAW,ROOT('ROOT'))AS NoticeReceiverXML "); StrSql.AppendFormat(" FROM tbl_GovNotice a WHERE NoticeId='{0}' ", NoticeId); DbCommand dc = this._db.GetSqlStringCommand(StrSql.ToString()); using (IDataReader dr = EyouSoft.Toolkit.DAL.DbHelper.ExecuteReader(dc, this._db)) { if (dr.Read()) { 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, IsMsg = dr.GetString(dr.GetOrdinal("IsMsg")) == "1" ? true : false, MsgContent = dr.IsDBNull(dr.GetOrdinal("MsgContent")) ? "" : dr.GetString(dr.GetOrdinal("MsgContent")), Views = dr.GetInt32(dr.GetOrdinal("Views")), OperatorId = dr.IsDBNull(dr.GetOrdinal("OperatorId")) ? "" : dr.GetString(dr.GetOrdinal("OperatorId")), IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")), Operator = dr.GetString(dr.GetOrdinal("Operator")), ComAttachList = this.GetAttachList(dr["ComAttachXML"].ToString(), NoticeId, ItemType), MGovNoticeReceiverList = this.GetNoticeReceiveList(dr["NoticeReceiverXML"].ToString(), NoticeId) }; } }; return(model); }
/// <summary> /// 获得公告通知实体 /// </summary> /// <param name="NoticeId">公告通知ID</param> /// <returns></returns> public EyouSoft.Model.GovStructure.MGovNotice GetGovNoticeModel(string NoticeId) { EyouSoft.Model.GovStructure.MGovNotice model = null; if (!string.IsNullOrEmpty(NoticeId)) { model = new EyouSoft.Model.GovStructure.MGovNotice(); return(dal.GetGovNoticeModel(NoticeId, ItemType)); } return(model); }
/// <summary> /// 获得公告通知信息列表 /// </summary> /// <param name="NoticeType">消息类型</param> /// <param name="CompanyId">公司编号</param> /// <param name="Title">标题</param> /// <param name="OperatorId">发布人ID</param> /// <param name="Operator">发布人</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, string Title, string OperatorId, string Operator, 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,ComAttachXML,IsRemind,[Views],DepartId,Operator,OperatorId,IssueTime "; string query = string.Format(" (NoticeType='{0}') AND CompanyId='{1}'", NoticeType, CompanyId); if (!string.IsNullOrEmpty(Title)) { query = query + string.Format(" and Title like '%{0}%'", Title); } if (!string.IsNullOrEmpty(OperatorId)) { query = query + string.Format(" and OperatorId = '{0}'", OperatorId); } if (!string.IsNullOrEmpty(Operator)) { query = query + string.Format(" and Operator like '%{0}%'", Operator); } 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")), IsRemind = dr.GetString(dr.GetOrdinal("IsRemind")) == "1" ? true : false, Views = dr.IsDBNull(dr.GetOrdinal("Views")) ? 0 : dr.GetInt32(dr.GetOrdinal("Views")), OperatorId = dr.IsDBNull(dr.GetOrdinal("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); }