private Boolean PraseHtml(string html, out bookinfo bookinfo)
{
bookinfo = new bookinfo();
if ("" == html || "{\"result\":0,\"data\":null}" == html)
{
MyOperation.DebugPrint("没有找到对应的图书信息", 1);
DisplayAll(0);
return(false);
}
try
{
JObject jo1 = (JObject)JsonConvert.DeserializeObject(html);
bookinfo.gbookid = jo1["data"]["id"].ToString();
bookinfo.name = jo1["data"]["name"].ToString();
bookinfo.author = jo1["data"]["author"].ToString();
bookinfo.imgpath = jo1["data"]["imgpath"].ToString();
bookinfo.press = jo1["data"]["press"].ToString();
bookinfo.price = jo1["data"]["fixedPrice"].ToString();
bookinfo.isbn = jo1["data"]["isbn"].ToString();
DisplayAll(1);
return(true);
}
catch (Exception e)
{
MyOperation.DebugPrint("PraseHtml:出现catch异常:" + e.Message);
DisplayAll(0);
return(false);
}
}
private string InsertNewBookInfo(bookinfo bi)
{
if (null == bi)
{
return("");
}
try
{
string sql = string.Format("INSERT INTO tt_bookinfo (id,gbookid,name,author,press,price,ISBN,imgpath) VALUES (null,'{0}','{1}','{2}','{3}','{4}','{5}','{6}')",
bi.gbookid, bi.name, bi.author, bi.press, bi.price, bi.isbn, bi.imgpath);
if (dbo.AddDelUpdate(sql) == 1)
{
sql = "SELECT id FROM tt_bookinfo WHERE isbn ='" + bi.isbn + "'";
DataTable dt = dbo.Selectinfo(sql);
return(dt.Rows[0]["id"].ToString());
}
else
{
MyOperation.MessageShow("同步教材信息至本地时发生错误，请联系管理员处理");
return("");
}
}
catch (Exception e)
{
MyOperation.DebugPrint("InsertNewBookInfo出现catch异常:" + e.Message, 3);
}
return("");
}
protected void Page_Load(object sender, EventArgs e)
{
string bookID = Request.QueryString["bookID"];
IDBook = bookID;
if (bookID != null)
{
DataTable dt = new bookinfo().getBookByID(bookID);
if (dt.Rows.Count > 0)
{
bookImage.ImageUrl = "~/images/books/large/large-" + dt.Rows[0]["bookImage"].ToString();
bookName.Text = dt.Rows[0]["bookName"].ToString();
bookAuthor.Text = dt.Rows[0]["bookAuthor"].ToString();
bookSetPrice.Text = dt.Rows[0]["bookSetPrice"].ToString();
bookPrice.Text = dt.Rows[0]["bookPrice"].ToString();
bookBought.Text = dt.Rows[0]["bookBought"].ToString();
double price = Convert.ToDouble(dt.Rows[0]["bookPrice"].ToString());
double setPrice = Convert.ToDouble(dt.Rows[0]["bookSetPrice"].ToString());
LabelDiscount.Text = "(" + Math.Round(price / setPrice, 2) * 10 + "折)";
TextSummary.Text = dt.Rows[0]["bookSummary"].ToString();
TextPreview.Text = dt.Rows[0]["bookPreview"].ToString();
}
}
else
{
Response.Redirect("Default.aspx");
}
}
private void button2_Click(object sender, EventArgs e)
{
{
if (string.IsNullOrWhiteSpace(textBox1.Text) || string.IsNullOrWhiteSpace(textBox2.Text) || string.IsNullOrWhiteSpace(textBox4.Text) || string.IsNullOrWhiteSpace(textBox5.Text))
{
MessageBox.Show("TextBoxes are Empty Please Check Again");
}
else
{
bookdbmlDataContext vdb = new bookdbmlDataContext();
bookinfo vb = new bookinfo();
vb.Name = textBox1.Text;
vb.Author = textBox2.Text;
vb.Edition = textBox3.Text;
vb.Type = textBox4.Text;
vdb.bookinfos.InsertOnSubmit(vb);
vdb.SubmitChanges();
File.Copy(temp, @"C:\Users\Tomal\Documents\Visual Studio 2013\Projects\Info\AllInfo\pdf\" + textBox1.Text + ".pdf");
MessageBox.Show("Book is added successfully in the library. Thank you");
// this.Visible = false;
// this.Visible = true;
textBox1.Text = null;
textBox2.Text = null;
textBox3.Text = null;
textBox4.Text = null;
textBox5.Text = null;
}
}
}
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 DisplayBookinfo(bookinfo bi)
{
if (null == bi)
{
return;
}
try
{
lbb_bookid.Content = "内部编号：" + bi.bookid;
lbb_author.Content = "作者：" + bi.author;
lbb_ISBN.Content = "ISBN：" + bi.isbn;
lbb_name.Content = "书名：" + bi.name;
lbb_press.Content = "出版社：" + bi.press;
lbb_price.Content = "定价：" + bi.price;
//====================标准image source添加方法=====================
// Create source
BitmapImage myBitmapImage = new BitmapImage();
// BitmapImage.UriSource must be in a BeginInit/EndInit block
myBitmapImage.BeginInit();
myBitmapImage.UriSource = new Uri(@bi.imgpath, UriKind.Absolute);
// To save significant application memory, set the DecodePixelWidth or
// DecodePixelHeight of the BitmapImage value of the image source to the desired
// height or width of the rendered image. If you don't do this, the application will
// cache the image as though it were rendered as its normal size rather then just
// the size that is displayed.
// Note: In order to preserve aspect ratio, set DecodePixelWidth
// or DecodePixelHeight but not both.
myBitmapImage.DecodePixelWidth = 250;
myBitmapImage.EndInit();
//set image source
bookimage.Source = myBitmapImage;
DisplayAll(1);
}
catch (UriFormatException e)
{
MyOperation.DebugPrint("DisplayBookinfo未能解析URL:" + e.Message, 1);
bookimage.Source = new BitmapImage(new Uri(@"/images/defaultbookimg.jpg", UriKind.RelativeOrAbsolute));
DisplayAll(1);
}
catch (Exception e)
{
MyOperation.DebugPrint("DisplayBookinfo出现catch异常:" + e.Message, 3);
DisplayAll(2);
MyOperation.MessageShow("系统异常，请联系管理员处理");
}
}
public void Bind()
{
if (message == null)
{
Response.Redirect("Default.aspx");
}
else
{
DataTable bdt = new bookinfo().getBooksByKeyword(message);
for (int i = 0; i < bdt.Rows.Count; i++)
{
DataRow row = dt.NewRow();
row["ID"] = bdt.Rows[i]["bookID"].ToString();
row["Name"] = bdt.Rows[i]["bookName"].ToString();
row["Price"] = "￥" + bdt.Rows[i]["bookPrice"].ToString();
row["Image"] = bdt.Rows[i]["bookImage"].ToString();
row["Author"] = bdt.Rows[i]["bookAuthor"].ToString();
dt.Rows.Add(row);
}
}
GridView1.DataSource = dt.DefaultView;
GridView1.DataBind();
}
public ActionResult Add()
{
string name = Request["title"];
string author = Request["author"];
string price = Request["price"];
string date = Request["date"];
string cname = Request["catogory"];
int temp = (from t in d.bookinfos
orderby t.Id descending
select t.Id).First();
int value = temp;
bookinfo p = new bookinfo();
p.title = name;
p.price = price;
p.author = author;
p.c_name = cname;
p.date = date;
p.Id = value + 1;
d.bookinfos.InsertOnSubmit(p);
d.SubmitChanges();
return(RedirectToAction("Index"));
}
private void button4_Click(object sender, RoutedEventArgs e)
{
if (string.IsNullOrEmpty(tb1.Text))
{
MyOperation.MessageShow("必须输入书名");
tb1.Focus();
return;
}
if (string.IsNullOrEmpty(tb2.Text))
{
MyOperation.MessageShow("必须输入作者");
tb2.Focus();
return;
}
if (string.IsNullOrEmpty(tb3.Text))
{
MyOperation.MessageShow("必须输入出版社");
tb3.Focus();
return;
}
if (string.IsNullOrEmpty(tb5.Text))
{
MyOperation.MessageShow("必须输入ISBN");
tb5.Focus();
return;
}
if (string.IsNullOrEmpty(tb6.Text))
{
MyOperation.MessageShow("必须输入定价");
tb6.Focus();
return;
}
string url = "http://api.jige.olege.com/book";
IDictionary <string, string> parameters = new Dictionary <string, string>();
parameters.Add("isbn", tb5.Text);
parameters.Add("fixedPrice", tb6.Text);
parameters.Add("name", tb1.Text);
parameters.Add("press", tb3.Text);
parameters.Add("author", tb2.Text);
Encoding encoding = Encoding.GetEncoding("UTF-8");
HttpWebResponse response = CreatePostHttpResponse(url, parameters, null, null, encoding, null);
StreamReader reader = new StreamReader(response.GetResponseStream(), Encoding.Default);
Char[] read = new Char[256];
// Reads 256 characters at a time.
int count = reader.Read(read, 0, 256);
String str = "";
while (count > 0)
{
// Dumps the 256 characters on a string and displays the string to the console.
str = new String(read, 0, count);
Console.Write(str);
count = reader.Read(read, 0, 256);
}
MyOperation.DebugPrint("新增图书信息" + tb5.Text + tb6.Text + tb1.Text + tb3.Text + tb2.Text);
MyOperation.DebugPrint("新增图书信息返回的JSON中data.id为:" + str, 3);
try
{
JObject jo1 = (JObject)JsonConvert.DeserializeObject(str);
bookinfo bi = new bookinfo();
bi.author = tb2.Text;
bi.gbookid = jo1["data"].ToString();
bi.imgpath = "";
bi.isbn = tb5.Text;
bi.name = tb1.Text;
bi.press = tb3.Text;
bi.price = tb6.Text;
bi.bookid = InsertNewBookInfo(bi);
if ("" == bi.bookid)
{
return;
}
MyOperation.MessageShow("添加成功！");
DisplayBookinfo(bi);
}
catch (Exception ex)
{
MyOperation.DebugPrint("新增图书信息button4_Click:出现catch异常:" + ex.Message, 3);
MyOperation.MessageShow("新增图书出现异常，请尝试重新搜索ISBN");
}
}
public ActionResult Create([Bind(Include = "ISBN")] RECOM_BOOK_USER rECOM_BOOK_USER)
{
string isbn = Request["ISBN"];
if (isbn.Length != 13)
{
ModelState.AddModelError("ISBN", "ISBN必须为13位数字编号");
return(View());
}
var query = db.BOOKS.SqlQuery("SELECT * FROM BOOKS WHERE ISBN ='" + isbn + "'");
int count = query.ToList().Count;
if (query.ToList().Count > 0)
{
ModelState.AddModelError("ISBN", "该书已存在书库中");
return(View());
}
HttpWebRequest myRequest = null;
HttpWebResponse myHttpResponse = null;
string doubanurl = "http://api.douban.com/book/subject/isbn/";
string geturl = doubanurl + isbn;
myRequest = (HttpWebRequest)WebRequest.Create(geturl);
//myRequest.Method = "HEAD";
//myRequest.AllowAutoRedirect = false;
try
{
myHttpResponse = (HttpWebResponse)myRequest.GetResponse();
}
catch (WebException ex)
{
myHttpResponse = (HttpWebResponse)ex.Response;
}
StreamReader reader = new StreamReader(myHttpResponse.GetResponseStream());
string xmldetail = reader.ReadToEnd();
reader.Close();
myHttpResponse.Close();
myRequest.Abort();
if (myHttpResponse != null)
{
if (myHttpResponse.StatusCode == HttpStatusCode.NotFound)
{
ModelState.AddModelError("ISBN", "无效的ISBN");
return(View());
}
}
var books = new bookinfo();
XmlDocument xml = new XmlDocument();
xml.LoadXml(xmldetail);
XmlNamespaceManager nsmgr = new XmlNamespaceManager(xml.NameTable);
nsmgr.AddNamespace("db", "http://www.w3.org/2005/Atom");
XmlElement root = xml.DocumentElement;
XmlNodeList nodes = root.SelectNodes("/db:entry", nsmgr);
foreach (XmlNode nodeData in nodes)
{
foreach (XmlNode childnode in nodeData.ChildNodes)
{
string str = childnode.Name;
switch (str)
{
case "title":
books.Name = childnode.InnerText;
break;
case "link":
if (childnode.Attributes[1].Value == "image")
{
books.Imageurl = childnode.Attributes[0].Value;
}
break;
case "summary":
books.Summary = childnode.InnerText;
break;
case "db:attribute":
{
switch (childnode.Attributes[0].Value)
{
case "isbn13":
books.Isbn = childnode.InnerText;
break;
case "pages":
books.Pages = childnode.InnerText;
break;
case "author":
books.Author = childnode.InnerText;
break;
case "price":
books.Price = childnode.InnerText;
break;
case "publisher":
books.Publisher = childnode.InnerText;
break;
case "pubdate":
books.Pubdate = childnode.InnerText;
break;
} //end switch
break;
}
} //end switch
} //end foreach
} //end foreach
iSBN = books.Isbn;
bOOKNAME = books.Name;
return(RedirectToRoute(new { controller = "RECOM_BOOK_USER", action = "AddBook", id = isbn }));
}
protected void Page_Load(object sender, EventArgs e)
{
bookinfo books = new bookinfo();
DataTable dt = books.getTopBooksOrderByID();
if (dt.Rows.Count >= 8)
{
string bookName;
if (dt.Rows[0]["bookName"].ToString().Length > 11)
{
bookName = dt.Rows[0]["bookName"].ToString().Substring(0, 10) + "…";
}
else
{
bookName = dt.Rows[0]["bookName"].ToString();
}
WebUserControlHomepageItem1.Title = bookName;
WebUserControlHomepageItem1.Price = dt.Rows[0]["bookPrice"].ToString();
WebUserControlHomepageItem1.Bought = dt.Rows[0]["bookBought"].ToString();
WebUserControlHomepageItem1.ImageUrl = dt.Rows[0]["bookImage"].ToString();
WebUserControlHomepageItem1.HyberLink = dt.Rows[0]["bookID"].ToString();
if (dt.Rows[1]["bookName"].ToString().Length > 11)
{
bookName = dt.Rows[1]["bookName"].ToString().Substring(0, 10) + "…";
}
else
{
bookName = dt.Rows[1]["bookName"].ToString();
}
WebUserControlHomepageItem2.Title = bookName;
WebUserControlHomepageItem2.Price = dt.Rows[1]["bookPrice"].ToString();
WebUserControlHomepageItem2.Bought = dt.Rows[1]["bookBought"].ToString();
WebUserControlHomepageItem2.ImageUrl = dt.Rows[1]["bookImage"].ToString();
WebUserControlHomepageItem2.HyberLink = dt.Rows[1]["bookID"].ToString();
if (dt.Rows[2]["bookName"].ToString().Length > 11)
{
bookName = dt.Rows[2]["bookName"].ToString().Substring(0, 10) + "…";
}
else
{
bookName = dt.Rows[2]["bookName"].ToString();
}
WebUserControlHomepageItem3.Title = bookName;
WebUserControlHomepageItem3.Price = dt.Rows[2]["bookPrice"].ToString();
WebUserControlHomepageItem3.Bought = dt.Rows[2]["bookBought"].ToString();
WebUserControlHomepageItem3.ImageUrl = dt.Rows[2]["bookImage"].ToString();
WebUserControlHomepageItem3.HyberLink = dt.Rows[2]["bookID"].ToString();
if (dt.Rows[3]["bookName"].ToString().Length > 11)
{
bookName = dt.Rows[3]["bookName"].ToString().Substring(0, 10) + "…";
}
else
{
bookName = dt.Rows[3]["bookName"].ToString();
}
WebUserControlHomepageItem4.Title = bookName;
WebUserControlHomepageItem4.Price = dt.Rows[3]["bookPrice"].ToString();
WebUserControlHomepageItem4.Bought = dt.Rows[3]["bookBought"].ToString();
WebUserControlHomepageItem4.ImageUrl = dt.Rows[3]["bookImage"].ToString();
WebUserControlHomepageItem4.HyberLink = dt.Rows[3]["bookID"].ToString();
if (dt.Rows[4]["bookName"].ToString().Length > 11)
{
bookName = dt.Rows[4]["bookName"].ToString().Substring(0, 10) + "…";
}
else
{
bookName = dt.Rows[4]["bookName"].ToString();
}
WebUserControlHomepageItem5.Title = bookName;
WebUserControlHomepageItem5.Price = dt.Rows[4]["bookPrice"].ToString();
WebUserControlHomepageItem5.Bought = dt.Rows[4]["bookBought"].ToString();
WebUserControlHomepageItem5.ImageUrl = dt.Rows[4]["bookImage"].ToString();
WebUserControlHomepageItem5.HyberLink = dt.Rows[4]["bookID"].ToString();
if (dt.Rows[5]["bookName"].ToString().Length > 11)
{
bookName = dt.Rows[5]["bookName"].ToString().Substring(0, 10) + "…";
}
else
{
bookName = dt.Rows[5]["bookName"].ToString();
}
WebUserControlHomepageItem6.Title = bookName;
WebUserControlHomepageItem6.Price = dt.Rows[5]["bookPrice"].ToString();
WebUserControlHomepageItem6.Bought = dt.Rows[5]["bookBought"].ToString();
WebUserControlHomepageItem6.ImageUrl = dt.Rows[5]["bookImage"].ToString();
WebUserControlHomepageItem6.HyberLink = dt.Rows[5]["bookID"].ToString();
if (dt.Rows[6]["bookName"].ToString().Length > 11)
{
bookName = dt.Rows[6]["bookName"].ToString().Substring(0, 10) + "…";
}
else
{
bookName = dt.Rows[6]["bookName"].ToString();
}
WebUserControlHomepageItem7.Title = bookName;
WebUserControlHomepageItem7.Price = dt.Rows[6]["bookPrice"].ToString();
WebUserControlHomepageItem7.Bought = dt.Rows[6]["bookBought"].ToString();
WebUserControlHomepageItem7.ImageUrl = dt.Rows[6]["bookImage"].ToString();
WebUserControlHomepageItem7.HyberLink = dt.Rows[6]["bookID"].ToString();
if (dt.Rows[7]["bookName"].ToString().Length > 11)
{
bookName = dt.Rows[7]["bookName"].ToString().Substring(0, 10) + "…";
}
else
{
bookName = dt.Rows[7]["bookName"].ToString();
}
WebUserControlHomepageItem8.Title = bookName;
WebUserControlHomepageItem8.Price = dt.Rows[7]["bookPrice"].ToString();
WebUserControlHomepageItem8.Bought = dt.Rows[7]["bookBought"].ToString();
WebUserControlHomepageItem8.ImageUrl = dt.Rows[7]["bookImage"].ToString();
WebUserControlHomepageItem8.HyberLink = dt.Rows[7]["bookID"].ToString();
}
dt = books.getTopBooksOrderByBought();
if (dt.Rows.Count >= 13)
{
HyperLink1.Text = dt.Rows[0]["bookName"].ToString();
HyperLink1.NavigateUrl = "Book.aspx?bookID=" + dt.Rows[0]["bookID"].ToString();
HyperLink2.Text = dt.Rows[1]["bookName"].ToString();
HyperLink2.NavigateUrl = "Book.aspx?bookID=" + dt.Rows[1]["bookID"].ToString();
HyperLink3.Text = dt.Rows[2]["bookName"].ToString();
HyperLink3.NavigateUrl = "Book.aspx?bookID=" + dt.Rows[2]["bookID"].ToString();
HyperLink4.Text = dt.Rows[3]["bookName"].ToString();
HyperLink4.NavigateUrl = "Book.aspx?bookID=" + dt.Rows[3]["bookID"].ToString();
HyperLink5.Text = dt.Rows[4]["bookName"].ToString();
HyperLink5.NavigateUrl = "Book.aspx?bookID=" + dt.Rows[4]["bookID"].ToString();
HyperLink6.Text = dt.Rows[5]["bookName"].ToString();
HyperLink6.NavigateUrl = "Book.aspx?bookID=" + dt.Rows[5]["bookID"].ToString();
HyperLink7.Text = dt.Rows[6]["bookName"].ToString();
HyperLink7.NavigateUrl = "Book.aspx?bookID=" + dt.Rows[6]["bookID"].ToString();
HyperLink8.Text = dt.Rows[7]["bookName"].ToString();
HyperLink8.NavigateUrl = "Book.aspx?bookID=" + dt.Rows[7]["bookID"].ToString();
HyperLink9.Text = dt.Rows[8]["bookName"].ToString();
HyperLink9.NavigateUrl = "Book.aspx?bookID=" + dt.Rows[8]["bookID"].ToString();
HyperLink10.Text = dt.Rows[9]["bookName"].ToString();
HyperLink10.NavigateUrl = "Book.aspx?bookID=" + dt.Rows[9]["bookID"].ToString();
HyperLink11.Text = dt.Rows[10]["bookName"].ToString();
HyperLink11.NavigateUrl = "Book.aspx?bookID=" + dt.Rows[10]["bookID"].ToString();
HyperLink12.Text = dt.Rows[11]["bookName"].ToString();
HyperLink12.NavigateUrl = "Book.aspx?bookID=" + dt.Rows[12]["bookID"].ToString();
HyperLink13.Text = dt.Rows[12]["bookName"].ToString();
HyperLink13.NavigateUrl = "Book.aspx?bookID=" + dt.Rows[12]["bookID"].ToString();
}
}
