public void getdata1(string sqlstring, int num)
{
ds = data.query(sqlstring);
for (int i = 0; i < num; i++)
{
bk1[i] = new bookinfor();
bk1[i].no = ds.Tables["base"].Rows[i]["bno"].ToString();
bk1[i].name = ds.Tables["base"].Rows[i]["bname"].ToString();
bk1[i].picture = ds.Tables["base"].Rows[i]["bpicture"].ToString();
}
}
//获取数据(ab为页面获取的页码)
public void getdata()
{
ds = data.query(sql);
bk = new bookinfor();
bk.no = ds.Tables["base"].Rows[0]["bno"].ToString();
bk.name = ds.Tables["base"].Rows[0]["bname"].ToString();
bk.author = ds.Tables["base"].Rows[0]["bauthor"].ToString();
bk.press = ds.Tables["base"].Rows[0]["bpress"].ToString();
bk.intro = ds.Tables["base"].Rows[0]["bintro"].ToString();
bk.price = ds.Tables["base"].Rows[0]["bprice"].ToString();
bk.picture = ds.Tables["base"].Rows[0]["bpicture"].ToString();
}
//获取数据(ab为页面获取的页码)
public void getdata(int pagenum)
{
// 取得总页数
int a = ds.Tables["base"].Rows.Count % 6;
if (a > 0)
{
pagecount = ds.Tables["base"].Rows.Count / 6 + 1;
}
else
{
pagecount = ds.Tables["base"].Rows.Count / 6;
}
if (pagecount == 0)
{
pagecount = 1;
}
//将页面传递的页码赋给pagecurrent
if (pagenum > 0 && pagenum <= pagecount)
{
pagecurrent = pagenum;
}
int num = 0;
for (int i = ((pagecurrent - 1) * 6); i < ds.Tables["base"].Rows.Count; i++)
{
if (num >= 6)
{
break;
}
bk[num] = new bookinfor();
bk[num].no = ds.Tables["base"].Rows[i]["bno"].ToString();
bk[num].name = ds.Tables["base"].Rows[i]["bname"].ToString();
bk[num].price = ds.Tables["base"].Rows[i]["bprice"].ToString();
bk[num].picture = ds.Tables["base"].Rows[i]["bpicture"].ToString();
num++;
}
}
