/// <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.MYuYue> GetList(int PageSize, int PageIndex, ref int RecordCount, Eyousoft_yhq.Model.MYuYueSer serModel) { IList <Eyousoft_yhq.Model.MYuYue> list = new List <Eyousoft_yhq.Model.MYuYue>(); string tableName = "tbl_YuYue"; string fileds = " * "; string orderByString = " YYTime 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.MYuYue model = new Eyousoft_yhq.Model.MYuYue(); model.YYID = dr.GetInt32(dr.GetOrdinal("YYID")); model.YYRoute = dr.IsDBNull(dr.GetOrdinal("YYRoute")) ? "" : dr.GetString(dr.GetOrdinal("YYRoute")); model.YYName = dr.IsDBNull(dr.GetOrdinal("YYName")) ? "" : dr.GetString(dr.GetOrdinal("YYName")); model.YYMobile = dr.IsDBNull(dr.GetOrdinal("YYMobile")) ? "" : dr.GetString(dr.GetOrdinal("YYMobile")); model.YYInfo = dr.IsDBNull(dr.GetOrdinal("YYInfo")) ? "" : dr.GetString(dr.GetOrdinal("YYInfo")); model.YYTime = dr.GetDateTime(dr.GetOrdinal("YYTime")); 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.MYuYue> GetList(int PageSize, int PageIndex, ref int RecordCount, Eyousoft_yhq.Model.MYuYueSer serModel) { return(dal.GetList(PageSize, PageIndex, ref RecordCount, serModel)); }