private void search_book()
{
lbb_author.Content = lbb_ISBN.Content = lbb_name.Content = lbb_press.Content = lbb_price.Content = "";
if (string.IsNullOrEmpty(tb_isbn.Text))
{
MyOperation.MessageShow("请输入图书的ISBN号");
tb_isbn.Focus();
return;
}
string sql = string.Format("SELECT * FROM tt_bookinfo WHERE isbn LIKE '%{0}%'", tb_isbn.Text);
DataTable dt = dbo.Selectinfo(sql);
//修改为只看第一个符合ISBN号的图书，这样可以规避ISBN号重复的问题
if (dt.Rows.Count >= 1)
{
bookinfo boi = new bookinfo();
boi.bookid = dt.Rows[0]["id"].ToString();
boi.author = dt.Rows[0]["author"].ToString();
boi.isbn = dt.Rows[0]["isbn"].ToString();
boi.name = dt.Rows[0]["name"].ToString();
boi.press = dt.Rows[0]["press"].ToString();
boi.price = dt.Rows[0]["price"].ToString();
boi.imgpath = dt.Rows[0]["imgpath"].ToString();
tb_price.Text = (MyOperation.string2float(dt.Rows[0]["price"].ToString()) * 0.3).ToString("0.0");
DisplayBookinfo(boi);
return;
}
//else if (dt.Rows.Count > 1)
//{
// MyOperation.MessageShow("存在2本以上相同ISBN号的图书，请确认ISBN号或者联系系统管理员");
// tb_isbn.Focus();
// return;
//}
else
{
string url = string.Format("http://api.jige.olege.com/book?q={0}&type=ISBN", tb_isbn.Text);
string html = GetHtml(url);
bookinfo bi;
if (PraseHtml(html, out bi))
{
bi.bookid = InsertNewBookInfo(bi);
if ("" == bi.bookid)
{
return;
}
DisplayBookinfo(bi);
}
}
}
private void button5_Click(object sender, RoutedEventArgs e)
{
tb_price.Text = (MyOperation.string2float(lbb_price.Content.ToString()) * 0.3).ToString("0.0");
}
