/// <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);
}