protected void initList() { Eyousoft_yhq.BLL.BCustomMsg bll = new Eyousoft_yhq.BLL.BCustomMsg(); Eyousoft_yhq.Model.serCustomMsg serchModel = new Eyousoft_yhq.Model.serCustomMsg(); pageIndex = UtilsCommons.GetPagingIndex("Page"); var list = bll.GetList(pageSize, pageIndex, ref recordCount, serchModel); if (list != null && list.Count > 0) { rptList.DataSource = list; rptList.DataBind(); BindPage(); litMsg.Visible = false; } else { rptList.Visible = false; } }
protected void initList() { Eyousoft_yhq.BLL.BCustomMsg bll = new Eyousoft_yhq.BLL.BCustomMsg(); Eyousoft_yhq.Model.serCustomMsg serchModel = new Eyousoft_yhq.Model.serCustomMsg(); pageIndex = UtilsCommons.GetPagingIndex("Page"); var list = bll.GetList(pageSize, pageIndex, ref recordCount, serchModel); if (list != null && list.Count > 0) { rptList.DataSource = list; rptList.DataBind(); BindPage(); litMsg.Visible = false; } else { rptList.Visible = false; } }
/// <summary> /// 获取分页列表 /// </summary> /// <param name="PageSize"></param> /// <param name="PageIndex"></param> /// <param name="RecordCount"></param> /// <param name="serModel"></param> /// <returns></returns> public IList <Eyousoft_yhq.Model.CustomMsg> GetList(int PageSize, int PageIndex, ref int RecordCount, Eyousoft_yhq.Model.serCustomMsg serModel) { IList <Eyousoft_yhq.Model.CustomMsg> list = new List <Eyousoft_yhq.Model.CustomMsg>(); string tableName = "tbl_Recommend"; string fileds = " * "; string orderByString = " IssueTime desc "; StringBuilder query = new StringBuilder(); query.Append(" 1=1 "); if (serModel != null) { } using (IDataReader dr = DbHelper.ExecuteReader1(this._db, PageSize, PageIndex, ref RecordCount, tableName, fileds, query.ToString(), orderByString, null)) { while (dr.Read()) { Eyousoft_yhq.Model.CustomMsg model = new Eyousoft_yhq.Model.CustomMsg(); model.Id = dr.GetInt32(dr.GetOrdinal("id")); model.OpenId = dr.GetString(dr.GetOrdinal("OpenId")); model.NickName = dr.GetString(dr.GetOrdinal("NickName")); model.Sex = dr.GetString(dr.GetOrdinal("Sex")); model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")); model.CommendInfo = dr.GetString(dr.GetOrdinal("CommendInfo")); list.Add(model); } }; return(list); }
/// <summary> /// 获取分页列表 /// </summary> /// <param name="PageSize"></param> /// <param name="PageIndex"></param> /// <param name="RecordCount"></param> /// <param name="serModel"></param> /// <returns></returns> public IList <Eyousoft_yhq.Model.CustomMsg> GetList(int PageSize, int PageIndex, ref int RecordCount, Eyousoft_yhq.Model.serCustomMsg serModel) { return(dal.GetList(PageSize, PageIndex, ref RecordCount, serModel)); }