/// <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);
}
/// <summary>
/// 获取总页数数据
/// </summary>
/// <returns></returns>
public int GetRecordCount()
{
string sql = "select count(*) from BookMsg";
return(Convert.ToInt32(SqlHelp.ExecuteScalare(sql, CommandType.Text)));
}