/// <summary> /// 获取分页数据 /// </summary> /// <param name="start"></param> /// <param name="end"></param> /// <returns></returns> public List <BookMsg> GetPageList(int start, int end) { string sql = "select * from (select row_number() over (order by id)as num,* from BookMsg)as t where t.num<=@end and t.num>=@start"; SqlParameter[] pars = { new SqlParameter("@start", start), new SqlParameter("@end", end), }; DataTable da = SqlHelp.GetTable(sql, CommandType.Text, pars); List <BookMsg> list = null; if (da.Rows.Count > 0) { list = new List <BookMsg>(); BookMsg bookMsg = null; foreach (DataRow row in da.Rows) { bookMsg = new BookMsg(); LoadEntity(row, bookMsg); list.Add(bookMsg); } } return(list); }
/// <summary> /// 数据查询 /// </summary> /// <param name="adminName"></param> /// <param name="adminPwd"></param> /// <returns></returns> public Admin GetAdminInof(string adminName, string adminPwd) { string sql = "select * from Admin where AdminName=@AdminName and AdminPwd=@AdminPwd"; SqlParameter[] pars = { new SqlParameter("@AdminName", SqlDbType.NVarChar, 20), new SqlParameter("@AdminPwd", SqlDbType.NVarChar, 20), }; pars[0].Value = adminName; pars[1].Value = adminPwd; DataTable da = SqlHelp.GetTable(sql, CommandType.Text, pars); Admin admin = null; if (da.Rows.Count > 0) { admin = new Admin(); LoadEntity(admin, da.Rows[0]); } return(admin); }