private void button1_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(textBox1.Text)) { MessageBox.Show("定价不能为空!"); textBox1.Focus(); return; } IDictionary <string, string> parameters = new Dictionary <string, string>(); parameters.Add("isbn", label7.Text); parameters.Add("fixedPrice", textBox1.Text); parameters.Add("name", label9.Text); parameters.Add("press", ("" == label8.Text) ? "无" : label8.Text); parameters.Add("author", ("" == label10.Text)? "无" : label10.Text); string gbookid; if (yg.InsertNewBookInfo(parameters, out gbookid)) { YouGeWinformApi.Localbookinfo lbi = new YouGeWinformApi.Localbookinfo(); lbi.author = label10.Text; lbi.fixedprice = textBox1.Text; lbi.guid = gbookid; lbi.imgpath = ""; lbi.isbn = label7.Text; lbi.name = label9.Text; lbi.press = label8.Text; if (ygw.InsertNewBookInfo(lbi, out gbookid)) { MessageBox.Show("添加成功,重新搜索即可查到"); return; } } MessageBox.Show("添加失败,请在网络状态良好的情况下重试"); MyOperation.DebugPrint("复制图书信息失败,请在网络状态良好的情况下重试"); }
private void button1_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(textBox1.Text)) { MessageBox.Show("请输入书名"); textBox1.Focus(); return; } if (string.IsNullOrEmpty(textBox2.Text)) { MessageBox.Show("请输入作者"); textBox2.Focus(); return; } if (string.IsNullOrEmpty(textBox3.Text)) { MessageBox.Show("请输入出版社"); textBox3.Focus(); return; } if (string.IsNullOrEmpty(textBox4.Text)) { MessageBox.Show("请输入定价"); textBox4.Focus(); return; } if (string.IsNullOrEmpty(textBox5.Text)) { MessageBox.Show("请输入ISBN"); textBox5.Focus(); return; } IDictionary <string, string> parameters = new Dictionary <string, string>(); parameters.Add("isbn", textBox5.Text); parameters.Add("fixedPrice", textBox4.Text); parameters.Add("name", textBox1.Text); parameters.Add("press", textBox3.Text); parameters.Add("author", textBox2.Text); string gbookid; if (yg.InsertNewBookInfo(parameters, out gbookid)) { YouGeWinformApi.Localbookinfo lbi = new YouGeWinformApi.Localbookinfo(); lbi.author = textBox2.Text; lbi.fixedprice = textBox4.Text; lbi.guid = gbookid; lbi.imgpath = ""; lbi.isbn = textBox5.Text; lbi.name = textBox1.Text; lbi.press = textBox3.Text; if (ygw.InsertNewBookInfo(lbi, out gbookid)) { MessageBox.Show("添加成功,重新搜索即可查到"); this.Dispose(); return; } } MessageBox.Show("添加失败,请在网络状态良好的情况下重试"); MyOperation.DebugPrint("添加图书信息失败,请在网络状态良好的情况下重试"); }
public DataTable SearchBookinfoByIsbn(string isbn) { DataTable dt = ygw.SearchBookinfoByIsbn(isbn); if (dt.Rows.Count > 0) { //如果本地已经有图书信息,就直接返回给用户 return(dt); } //本地没有图书信息,从主数据库取信息 dt = new DataTable(); //初始化dt结构 dt.Columns.Add("id", System.Type.GetType("System.Int32")); dt.Columns.Add("name", System.Type.GetType("System.String")); dt.Columns.Add("press", System.Type.GetType("System.String")); dt.Columns.Add("isbn", System.Type.GetType("System.String")); dt.Columns.Add("price", System.Type.GetType("System.String")); dt.Columns.Add("author", System.Type.GetType("System.String")); try { JObject jo; if (yg.SearchBookinfoByIsbn(isbn, out jo)) { YouGeWinformApi.Localbookinfo lbi = new YouGeWinformApi.Localbookinfo(); lbi.author = jo["data"]["author"].ToString(); lbi.fixedprice = jo["data"]["fixedPrice"].ToString(); lbi.guid = jo["data"]["id"].ToString();; lbi.imgpath = jo["data"]["imgpath"].ToString(); lbi.isbn = jo["data"]["isbn"].ToString(); lbi.name = jo["data"]["name"].ToString(); lbi.press = jo["data"]["press"].ToString(); //如果从主数据库取到了图书信息,那么就写入本地数据库 string newid; if (ygw.InsertNewBookInfo(lbi, out newid)) { //写入成功之后,将dt变量赋值并返回 DataRow dr = dt.NewRow(); dr["id"] = Convert.ToInt32(newid); dr["name"] = lbi.name; dr["press"] = lbi.press; dr["isbn"] = lbi.isbn; dr["price"] = lbi.fixedprice; dr["author"] = lbi.author; dt.Rows.Add(dr); return(dt); } else { return(dt); } } else { return(dt); } } catch { //异常返回不一定是错误,jo对象解析完毕也会走到这里 return(dt); } }