protected void BindProClamationList() { pageIndex = Utils.GetInt(Utils.GetQueryStringValue("page"), 1); ///////绑定查询条件 EyouSoft.Model.PersonalCenterStructure.NoticeNews sModel = new EyouSoft.Model.PersonalCenterStructure.NoticeNews(); Titles = EyouSoft.Common.Utils.GetQueryStringValue("Titles"); OperateName = EyouSoft.Common.Utils.GetQueryStringValue("OperateName"); if (EyouSoft.Common.Utils.GetQueryStringValue("IssueTime") == "") { sModel.IssueTime = null; } else { sModel.IssueTime = EyouSoft.Common.Utils.GetDateTime(EyouSoft.Common.Utils.GetQueryStringValue("IssueTime")); IssueTime = sModel.IssueTime.Value.ToString("yyyy-MM-dd"); } sModel.Title = Titles; sModel.OperateName = OperateName; nBll = new EyouSoft.BLL.CompanyStructure.News(); newslist = nBll.GetZuTuanAcceptNews(pageSize, pageIndex, ref recordCount, SiteUserInfo.CompanyID, sModel); len = newslist.Count(); rptList.DataSource = newslist; rptList.DataBind(); newslist = null; BindPage(); }
/// <summary> /// 获取某个用户接收到的消息列表 /// </summary> /// <param name="userId">用户编号</param> /// <param name="companydId">公司编号</param> /// <returns></returns> public IList <EyouSoft.Model.PersonalCenterStructure.NoticeNews> GetAcceptNews(int PageSize, int PageIndex, ref int RecordCount, int userId, int companydId) { int deptId = 0; IList <EyouSoft.Model.PersonalCenterStructure.NoticeNews> lsNews = new List <EyouSoft.Model.PersonalCenterStructure.NoticeNews>(); DbCommand cmd = this._db.GetSqlStringCommand(SQL_SELECT_DeptId); this._db.AddInParameter(cmd, "Id", DbType.Int32, userId); this._db.AddInParameter(cmd, "CompanyId", DbType.Int32, companydId); using (IDataReader rdr = EyouSoft.Toolkit.DAL.DbHelper.ExecuteReader(cmd, this._db)) { if (rdr.Read()) { deptId = rdr.IsDBNull(rdr.GetOrdinal("DepartId")) ? 0 : rdr.GetInt32(rdr.GetOrdinal("DepartId")); } } string tableName = "View_AceptNews"; string primaryKey = "ID"; string orderByString = "IisuerTime DESC"; string fields = " ID, Title,Views,Iisuer,IisuerTime"; StringBuilder cmdQuery = new StringBuilder(" IsDelete='0'"); cmdQuery.AppendFormat(" and CompanyId = {1} and (AcceptId = {0} or AcceptType = 0)", deptId, companydId); using (IDataReader rdr = EyouSoft.Toolkit.DAL.DbHelper.ExecuteReader(this._db, PageSize, PageIndex, ref RecordCount, tableName, primaryKey, fields, cmdQuery.ToString(), orderByString)) { while (rdr.Read()) { EyouSoft.Model.PersonalCenterStructure.NoticeNews newInfo = new EyouSoft.Model.PersonalCenterStructure.NoticeNews(); newInfo.Id = rdr.GetInt32(rdr.GetOrdinal("ID")); newInfo.Title = rdr.IsDBNull(rdr.GetOrdinal("Title")) ? "" : rdr.GetString(rdr.GetOrdinal("Title")); newInfo.ClickNum = rdr.IsDBNull(rdr.GetOrdinal("Views")) ? 0 : rdr.GetInt32(rdr.GetOrdinal("Views")); newInfo.OperateName = rdr.IsDBNull(rdr.GetOrdinal("Iisuer")) ? "" : rdr.GetString(rdr.GetOrdinal("Iisuer")); newInfo.IssueTime = rdr.GetDateTime(rdr.GetOrdinal("IisuerTime")); lsNews.Add(newInfo); } } return(lsNews); }
/// <summary> /// 获取组团端消息 /// </summary> /// <returns></returns> public IList <EyouSoft.Model.PersonalCenterStructure.NoticeNews> GetZuTuanAcceptNews(int PageSize, int PageIndex, ref int RecordCount, int CompanyId, EyouSoft.Model.PersonalCenterStructure.NoticeNews SearchModel) { IList <EyouSoft.Model.PersonalCenterStructure.NoticeNews> lsNews = new List <EyouSoft.Model.PersonalCenterStructure.NoticeNews>(); EyouSoft.Model.PersonalCenterStructure.NoticeNews model = null; string tableName = "View_AceptNews"; string primaryKey = "ID"; string orderByString = "IisuerTime DESC"; string fields = " ID, Title,Views,Iisuer,IisuerTime"; StringBuilder cmdQuery = new StringBuilder(); cmdQuery.AppendFormat(" AcceptType = 2 and IsDelete = '0' and CompanyId={0}", CompanyId); if (SearchModel != null) { if (!String.IsNullOrEmpty(SearchModel.Title)) { cmdQuery.AppendFormat(" AND Title like '%{0}%' ", SearchModel.Title); } if (!String.IsNullOrEmpty(SearchModel.OperateName)) { cmdQuery.AppendFormat(" AND Iisuer='{0}' ", SearchModel.OperateName.Trim()); } if (SearchModel.IssueTime.HasValue && SearchModel.IssueTime != DateTime.MinValue) { cmdQuery.AppendFormat(" AND DATEDIFF(DAY,'{0}',IisuerTime)=0", SearchModel.IssueTime); } } using (IDataReader rdr = EyouSoft.Toolkit.DAL.DbHelper.ExecuteReader(this._db, PageSize, PageIndex, ref RecordCount, tableName, primaryKey, fields, cmdQuery.ToString(), orderByString)) { while (rdr.Read()) { model = new EyouSoft.Model.PersonalCenterStructure.NoticeNews(); model.Id = rdr.GetInt32(rdr.GetOrdinal("ID")); model.Title = rdr.IsDBNull(rdr.GetOrdinal("Title")) ? "" : rdr.GetString(rdr.GetOrdinal("Title")); model.OperateName = rdr.IsDBNull(rdr.GetOrdinal("Iisuer")) ? "" : rdr.GetString(rdr.GetOrdinal("Iisuer")); model.IssueTime = rdr.GetDateTime(rdr.GetOrdinal("IisuerTime")); lsNews.Add(model); } } return(lsNews); }
/// <summary> /// 获取组团端消息 /// </summary> /// <returns></returns> public IList <EyouSoft.Model.PersonalCenterStructure.NoticeNews> GetZuTuanAcceptNews(int CompanyId) { IList <EyouSoft.Model.PersonalCenterStructure.NoticeNews> lsNews = new List <EyouSoft.Model.PersonalCenterStructure.NoticeNews>(); EyouSoft.Model.PersonalCenterStructure.NoticeNews model = null; DbCommand cmd = this._db.GetSqlStringCommand(String.Format(SQL_SELECR_ZuTuanNews, CompanyId)); using (IDataReader rdr = EyouSoft.Toolkit.DAL.DbHelper.ExecuteReader(cmd, this._db)) { while (rdr.Read()) { model = new EyouSoft.Model.PersonalCenterStructure.NoticeNews(); model.Id = rdr.GetInt32(rdr.GetOrdinal("ID")); model.Title = rdr.IsDBNull(rdr.GetOrdinal("Title")) ? "" : rdr.GetString(rdr.GetOrdinal("Title")); model.ClickNum = rdr.IsDBNull(rdr.GetOrdinal("Views")) ? 0 : rdr.GetInt32(rdr.GetOrdinal("Views")); model.OperateName = rdr.IsDBNull(rdr.GetOrdinal("Iisuer")) ? "" : rdr.GetString(rdr.GetOrdinal("Iisuer")); model.IssueTime = rdr.GetDateTime(rdr.GetOrdinal("IisuerTime")); lsNews.Add(model); } } return(lsNews); }
/// <summary> /// 获取组团端消息 /// </summary> /// <returns></returns> public IList <EyouSoft.Model.PersonalCenterStructure.NoticeNews> GetZuTuanAcceptNews(int PageSize, int PageIndex, ref int RecordCount, int CompanyId, EyouSoft.Model.PersonalCenterStructure.NoticeNews SearchModel) { return(Dal.GetZuTuanAcceptNews(PageSize, PageIndex, ref RecordCount, CompanyId, SearchModel)); }