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