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(""); }
public void ThreadProc() { DBOperation dbo = new DBOperation(); YouGeWebApi ygw = new YouGeWebApi(); if (string.IsNullOrEmpty(_book_id)) { throw new Exception("book_id is null!"); } if (string.IsNullOrEmpty(_price)) { throw new Exception("price is null!"); } //判断本地是否有相同book_id和price的交易记录,如果有就全部同步成一个mallid,不要再上报给喵校园主库 string sql = string.Format("SELECT tt_bookinfo.id,tt_sellinfo.mallid FROM tt_bookinfo ,tt_sellinfo WHERE tt_bookinfo.id " + "= tt_sellinfo.bookid AND tt_bookinfo.gbookid ='{0}' AND ABS(tt_sellinfo.price- {1}) < 1e-5 AND tt_sellinfo.mallid IS NOT NULL", _book_id, _price); DataTable dt = dbo.Selectinfo(sql); //如果有,则直接全部更新一次mallid,不用上报给喵校园主库 if (dt.Rows.Count > 0) { sql = string.Format("UPDATE tt_sellinfo SET mallid = '{0}' WHERE bookid = '{1}' AND ABS(price- {2}) < 1e-5", dt.Rows[0]["mallid"].ToString(), dt.Rows[0]["id"].ToString(), _price); dbo.AddDelUpdate(sql); return; } //如果没有,则添加到喵校园主库,返回交易ID后,同步到每一条符合条件的交易中 string sellinfoid;//喵校园交易ID IDictionary <string, string> parameters = new Dictionary <string, string>(); parameters.Add("book_id", _book_id); parameters.Add("price", _price); parameters.Add("seller_id", Properties.Settings.Default.sellerid); if (ygw.InsertNewSellInfo(parameters, out sellinfoid)) { sql = string.Format("UPDATE tt_sellinfo SET mallid = '{0}' WHERE bookid = '{1}' AND ABS(price- {2}) < 1e-5", sellinfoid, _local_book_id, _price); dbo.AddDelUpdate(sql); MessageBox.Show("执行完成"); return; } else { MyOperation.DebugPrint("Insert Error!", 3); throw new Exception("Insert Error!"); } }
private void button3_Click(object sender, RoutedEventArgs e) { if (string.IsNullOrEmpty(textBox2.Text)) { MyOperation.MessageShow("请先输入图书编号"); textBox2.Focus(); return; } string sql = string.Format("UPDATE tt_sellinfo SET issold = 1 ,seller = '{0}',soldtime = '{1}' WHERE sellinfoid = '{2}' AND issold = '0'", "123", DateTime.Now.ToString("G"), textBox2.Text); if (dbo.AddDelUpdate(sql) != 1) { MyOperation.MessageShow(string.Format("没有查到图书唯一ID为【{0}】并且尚未出售的交易,请在上方查询详细信息", textBox2.Text)); textBox2.Focus(); return; } else { MyOperation.MessageShow("出售成功!"); textBox2.Focus(); } backgroundWorker1 = new System.ComponentModel.BackgroundWorker(); backgroundWorker1.DoWork += backgroundWorker1_DoWork; string sellinfoid = textBox2.Text; backgroundWorker1.RunWorkerAsync(sellinfoid); }
private void Button_Click(object sender, RoutedEventArgs e) { if (string.IsNullOrEmpty(tb_staffid.Text)) { MyOperation.MessageShow("请填写员工工号!"); tb_staffid.Focus(); return; } if (string.IsNullOrEmpty(tb_time.Text)) { MyOperation.MessageShow("请填写工时"); tb_time.Focus(); return; } string sql = string.Format("INSERT INTO tt_time (`id`,`group`,`time`,`staffid`,`mark`,`date`) VALUES (null,'{0}','{1}','{2}','{3}','{4}')", comboBox1.Text, tb_time.Text, tb_staffid.Text, tb_mark.Text, DateTime.Now); if (1 == dbo.AddDelUpdate(sql)) { MyOperation.MessageShow("添加成功"); tb_mark.Text = tb_staffid.Text = tb_time.Text = ""; return; } else { MyOperation.MessageShow("添加失败,请重试"); return; } }
private void button4_Click(object sender, RoutedEventArgs e) { string sql = string.Format("INSERT INTO tt_tikuan (sellerid,count,date) VALUES ('{0}','{1}','{2}')", textBox2.Text, textBox3.Text, DateTime.Now); dbo.AddDelUpdate(sql); displayye(textBox2.Text); }
private void Button_Click(object sender, RoutedEventArgs e) { if (string.IsNullOrEmpty(tb_title.Text)) { MyOperation.MessageShow("请填写完整的公告标题"); tb_title.Focus(); return; } if (string.IsNullOrEmpty(tb_context.Text)) { MyOperation.MessageShow("请填写完整的公告内容"); tb_context.Focus(); return; } string sql = string.Format("INSERT INTO tt_notice (id,title,context) VALUES (null,'{0}','{1}')", tb_title.Text, tb_context.Text); if (dbo.AddDelUpdate(sql) == 1) { MyOperation.MessageShow("添加成功"); tb_title.Text = ""; tb_context.Text = ""; } else { MyOperation.MessageShow("添加失败,请重试"); } }
private void button2_Click(object sender, RoutedEventArgs e) { if (string.IsNullOrEmpty(tb_name.Text)) { MyOperation.MessageShow("没有输入内容"); this.tb_name.Focus(); return; } string sql = string.Format("UPDATE tt_sellerinfo SET `name` = '{0}' WHERE `sellerid` = '{1}'", tb_name.Text, sellerid); if (1 == dbo.AddDelUpdate(sql)) { MyOperation.MessageShow("修改成功!"); } else { MyOperation.MessageShow("修改失败!"); } }
private void Button_Click(object sender, RoutedEventArgs e) { if (string.IsNullOrEmpty(tb_sellerid.Text) || tb_sellerid.Text.Length != 8) { MyOperation.MessageShow("请填写正确的书主号,长度8位"); tb_sellerid.Focus(); return; } else { string sqls = string.Format("SELECT * FROM tt_sellerinfo WHERE sellerid = '{0}'", tb_sellerid.Text); DataTable dt = dbo.Selectinfo(sqls); if (dt.Rows.Count > 0) { MyOperation.MessageShow("该书主号已经存在"); tb_sellerid.Focus(); return; } } if (string.IsNullOrEmpty(tb_name.Text)) { MyOperation.MessageShow("请填写完整的姓名"); tb_name.Focus(); return; } if (string.IsNullOrEmpty(tb_phone.Text)) { MyOperation.MessageShow("请填写完整的手机"); tb_phone.Focus(); return; } string sql = string.Format("INSERT INTO tt_sellerinfo (id,sellerid,name,phone,grade,mark) VALUES (null,'{0}','{1}','{2}','{3}','{4}')", tb_sellerid.Text, tb_name.Text, tb_phone.Text, tb_grade.Text, tb_mark.Text); if (dbo.AddDelUpdate(sql) == 1) { MyOperation.MessageShow("添加成功"); tb_sellerid.Text = tb_name.Text = tb_phone.Text = tb_mark.Text = tb_grade.Text = ""; } else { MyOperation.MessageShow("添加失败,请重试"); } }
private void button1_Click(object sender, RoutedEventArgs e) { //string ye = get_money2(); if (string.IsNullOrEmpty(textBox1.Text)) { MyOperation.MessageShow("请输入当前现金余额"); return; } string ye = textBox1.Text; string sql = string.Format("INSERT INTO tt_fanance (money,date) VALUES ('{0}','{1}')", ye, DateTime.Now); if (1 != dbo.AddDelUpdate(sql)) { MyOperation.MessageShow("结账失败,请联系管理员处理"); } else { MyOperation.MessageShow("结账成功,可以下班了!"); } }
private void Button_Click(object sender, RoutedEventArgs e) { if (string.IsNullOrEmpty(tb_name.Text)) { MyOperation.MessageShow("请填写姓名"); tb_name.Focus(); return; } if (string.IsNullOrEmpty(tb_phone.Text)) { MyOperation.MessageShow("请填写手机"); tb_phone.Focus(); return; } if (string.IsNullOrEmpty(tb_sellerid.Text)) { MyOperation.MessageShow("请填写学号"); tb_sellerid.Focus(); return; } if (string.IsNullOrEmpty(tb_email.Text)) { MyOperation.MessageShow("请填写邮箱"); tb_email.Focus(); return; } if (string.IsNullOrEmpty(passwordBox1.Password)) { MyOperation.MessageShow("请填写密码"); passwordBox1.Focus(); return; } if (string.IsNullOrEmpty(passwordBox2.Password)) { MyOperation.MessageShow("请填写确认密码"); passwordBox2.Focus(); return; } if (passwordBox1.Password != passwordBox2.Password) { MyOperation.MessageShow("两次输入的密码不一致"); passwordBox2.Focus(); return; } string sql = string.Format("INSERT INTO tt_staffinfo (id,staffid,name,phone,password,email,mark,role) VALUES (null,'{0}','{1}','{2}','{3}','{4}','{5}','{6}')", tb_sellerid.Text, tb_name.Text, tb_phone.Text, MyOperation.MD5(passwordBox1.Password), tb_email.Text, tb_mark.Text, comboBox1.SelectedValue.ToString()); if (1 != dbo.AddDelUpdate(sql)) { MyOperation.MessageShow("添加新用户失败,请重新添加"); return; } else { MyOperation.MessageShow("添加成功"); MyOperation.DebugPrint("添加了新用户"); tb_email.Text = tb_mark.Text = tb_name.Text = tb_phone.Text = tb_sellerid.Text = ""; return; } }
private void ChangePrice() { if (string.IsNullOrEmpty(tb_price.Text)) { MyOperation.MessageShow("请输入新的价格"); tb_price.Focus(); return; } if (sellinfoid == "") { MyOperation.MessageShow("请先在上方查询出要修改的交易信息"); tb_sellidsearch.Focus(); return; } string sql = string.Format("UPDATE tt_sellinfo SET price = '{0}' WHERE sellinfoid = '{1}'", tb_price.Text, sellinfoid); if (1 == dbo.AddDelUpdate(sql)) { MyOperation.MessageShow("修改成功!"); lb_bookinfo.Content = ""; if (string.IsNullOrEmpty(tb_sellidsearch.Text)) { MyOperation.MessageShow("请先输入图书编号"); tb_sellidsearch.Focus(); return; } sql = string.Format("SELECT tb.`name` AS `书名`,tb.press AS `出版社`,tb.price AS `定价`,tb.ISBN AS ISBN,st.`name` AS `收书人`," + "se.`issold` AS `出售`,se.`price` AS `售价` FROM tt_bookinfo AS tb , tt_sellinfo AS se ,tt_staffinfo AS st WHERE tb.id = se.bookid " + " AND st.staffid = se.buyer AND se.sellinfoid = {0}", sellinfoid); DataTable dt = dbo.Selectinfo(sql); if (dt.Rows.Count == 1) { lb_bookinfo.Content = "图书唯一ID:" + sellinfoid; lb_bookinfo.Content += "\r\n书名:" + dt.Rows[0]["书名"].ToString(); lb_bookinfo.Content += "\r\n出版社:" + dt.Rows[0]["出版社"].ToString(); lb_bookinfo.Content += "\r\n定价:" + dt.Rows[0]["定价"].ToString(); lb_bookinfo.Content += "\r\n售价:" + dt.Rows[0]["售价"].ToString(); lb_bookinfo.Content += "\r\n收书人:" + dt.Rows[0]["收书人"].ToString(); lb_bookinfo.Content += "\r\n是否出售:" + ((dt.Rows[0]["出售"].ToString() == "0") ? "否" : "是"); } else { tb_sellidsearch.Focus(); return; } } else { MyOperation.MessageShow("修改失败!"); return; } //同步修改喵校园主库中的售价信息 backgroundWorker1 = new System.ComponentModel.BackgroundWorker(); //backgroundWorker1.RunWorkerCompleted += backgroundWorker1_RunWorkerCompleted; backgroundWorker1.DoWork += backgroundWorker1_DoWork; string paras = tb_sellidsearch.Text + "|" + tb_price.Text; backgroundWorker1.RunWorkerAsync(paras); }