bool RefreshBookData(string sqlStr) { DataSet ds = new DataSet(); ds = CDataBase.GetDataFromDB(sqlStr); if (ds != null) { dgrdvBookCity.DataSource = ds.Tables[0]; dgrdvBookCity.Columns[0].HeaderText = "仓库编号"; dgrdvBookCity.Columns[0].Width = 100; dgrdvBookCity.Columns[1].HeaderText = "书籍编号"; dgrdvBookCity.Columns[1].Width = 98; dgrdvBookCity.Columns[2].HeaderText = "书名"; dgrdvBookCity.Columns[2].Width = 98; dgrdvBookCity.Columns[3].HeaderText = "作者"; dgrdvBookCity.Columns[3].Width = 80; dgrdvBookCity.Columns[4].HeaderText = "出版社"; dgrdvBookCity.Columns[4].Width = 80; dgrdvBookCity.Columns[5].HeaderText = "零售价"; dgrdvBookCity.Columns[5].Width = 80; dgrdvBookCity.Columns[6].HeaderText = "折扣信息"; dgrdvBookCity.Columns[6].Width = 80; return(true); } else { dgrdvBookCity.DataSource = null; return(false); } }
public void RefreshData() { string sqlStr = ""; DataSet ds = new DataSet(); if (cmbUserType.Text.Trim() == "普通管理员") { sqlStr = "select " + dgrdvAdminSelectSql + " from tbl_Admin where adminType= '普通管理员'"; ds = CDataBase.GetDataFromDB(sqlStr); if (ds != null) { SetDgrdvAdmin(ds); } else { dgrdvUser.DataSource = null; } } else { sqlStr = "select * from tbl_Customer"; ds = CDataBase.GetDataFromDB(sqlStr); if (ds != null) { SetDgrdvCustomer(ds); } else { dgrdvUser.DataSource = null; } } }
bool RefreshFinanceData(string sqlStr) { DataSet ds = new DataSet(); ds = CDataBase.GetDataFromDB(sqlStr); if (ds != null) { dgrdvFinance.DataSource = ds.Tables[0]; dgrdvFinance.Columns[0].HeaderText = "账单编号"; dgrdvFinance.Columns[0].Width = 137; dgrdvFinance.Columns[1].HeaderText = "金额"; dgrdvFinance.Columns[1].Width = 70; dgrdvFinance.Columns[2].HeaderText = "类型"; dgrdvFinance.Columns[2].Width = 60; dgrdvFinance.Columns[3].HeaderText = "创建者"; dgrdvFinance.Columns[3].Width = 112; dgrdvFinance.Columns[4].HeaderText = "创建时间"; dgrdvFinance.Columns[4].Width = 120; return(true); } else { dgrdvFinance.DataSource = null; return(false); } }
void RefreshImportData() { string sqlStr1; DataSet ds1 = new DataSet(); sqlStr1 = "select tbl_ImportList.warehouseID, tbl_Warehouse.warehouseCity, tbl_Book.bookID," + " tbl_Book.title, tbl_ImportList.importPrice, tbl_ImportList.importNumber, tbl_ImportList.status, tbl_ImportList.generateDateTime " + " from tbl_ImportList , tbl_Book, tbl_Warehouse where tbl_ImportList.bookID = tbl_Book.bookID " + "and tbl_ImportList.warehouseID = tbl_Warehouse.warehouseID "; ds1 = CDataBase.GetDataFromDB(sqlStr1); if (ds1 != null) { dgrdvImportList.DataSource = ds1.Tables[0]; dgrdvImportList.Columns[0].HeaderText = "仓库编号"; dgrdvImportList.Columns[0].Width = 80; dgrdvImportList.Columns[1].HeaderText = "仓库所在地"; dgrdvImportList.Columns[1].Width = 95; dgrdvImportList.Columns[2].HeaderText = "书籍编号"; dgrdvImportList.Columns[2].Width = 80; dgrdvImportList.Columns[3].HeaderText = "书名"; dgrdvImportList.Columns[3].Width = 78; dgrdvImportList.Columns[4].HeaderText = "进货价"; dgrdvImportList.Columns[4].Width = 75; dgrdvImportList.Columns[5].HeaderText = "进货数量"; dgrdvImportList.Columns[5].Width = 80; dgrdvImportList.Columns[6].HeaderText = "当前状态"; dgrdvImportList.Columns[6].Width = 80; dgrdvImportList.Columns[7].HeaderText = "生成日期"; dgrdvImportList.Columns[7].Width = 135; } else { dgrdvImportList.DataSource = null; } }
private void btnDelete_Click(object sender, EventArgs e) { try { if (txtBookID.Text.Trim() == "") { MessageBox.Show("没有可删除的记录!", "提示"); return; } string sqlStr1 = "select * from tbl_ShoppingBasket where bookID='" + txtBookID.Text.Trim() + "'"; string sqlStr2 = "select * from tbl_OrderForm where bookID='" + txtBookID.Text.Trim() + "'"; string sqlStr3 = "select * from tbl_ImportList where bookID='" + txtBookID.Text.Trim() + "'"; string sqlStr4 = "select * from tbl_Stocks where bookID='" + txtBookID.Text.Trim() + "'"; if (CDataBase.GetDataFromDB(sqlStr1) != null) { MessageBox.Show("顾客购物篮中存在这本书,不能删除该书!", "删除出错", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (CDataBase.GetDataFromDB(sqlStr2) != null) { MessageBox.Show("顾客订单中存在这本书,不能删除该书!", "删除出错", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (CDataBase.GetDataFromDB(sqlStr3) != null) { MessageBox.Show("进货清单中存在这本书,不能删除该书!", "删除出错", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (CDataBase.GetDataFromDB(sqlStr4) != null) { string sqlStr5 = "delete from tbl_Stocks where bookID='" + txtBookID.Text.Trim() + "'"; CDataBase.UpdateDB(sqlStr5); } else if (MessageBox.Show("确定要删除书籍“" + txtTitle.Text.Trim() + "”吗?", "删除书籍", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes) { string sqlStr = "delete from tbl_Book where bookID='" + txtBookID.Text.Trim() + "'"; CDataBase.UpdateDB(sqlStr); int n = dgrdvBook.CurrentCell.RowIndex; dgrdvBook.Rows.RemoveAt(n); if (dgrdvBook.Rows.Count == 1) { ClearAll(); dgrdvBook.DataSource = null; } else { dgrdvBook_RowHeaderMouseClick(null, null); } } } catch (Exception ex) { CDataBase.conn.Close(); MessageBox.Show(ex.Message); } }
bool No(string no) { string sqlStr = "select * from tbl_Book"; DataSet ds = new DataSet(); ds = CDataBase.GetDataFromDB(sqlStr); if (ds != null) { int n = ds.Tables[0].Rows.Count; for (int i = 0; i < n; i++) { if (no == ds.Tables[0].Rows[i].ItemArray[0].ToString().Trim()) { return(false); } } } return(true); }
private void btnDelete_Click(object sender, EventArgs e) { try { int n = dgrdvWarehouse.CurrentCell.RowIndex; string warehouseID = dgrdvWarehouse[0, n].Value.ToString().Trim(); string sqlStr1 = "select * from tbl_ImportList where warehouseID='" + warehouseID + "'"; string sqlStr2 = "select * from tbl_Stocks where warehouseID='" + warehouseID + "'"; if (CDataBase.GetDataFromDB(sqlStr1) != null) { MessageBox.Show("进货清单中存在该仓库,不能删除该仓库!", "删除出错", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (CDataBase.GetDataFromDB(sqlStr2) != null) { MessageBox.Show("该仓库中仍有书籍库存,不能删除该仓库!", "删除出错", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (MessageBox.Show("确定要删除仓库“" + warehouseID + "”吗?", "删除仓库", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes) { string sqlStr = "delete from tbl_Warehouse where warehouseID='" + warehouseID + "'"; CDataBase.UpdateDB(sqlStr); int m = dgrdvWarehouse.CurrentCell.RowIndex; dgrdvWarehouse.Rows.RemoveAt(m); if (dgrdvWarehouse.Rows.Count == 1) { ClearAll(); dgrdvWarehouse.DataSource = null; } else { dgrdvWarehouse_RowHeaderMouseClick(null, null); } } } catch (Exception ex) { CDataBase.conn.Close(); MessageBox.Show(ex.Message); } }
private void FrmAddNewBook_Load(object sender, EventArgs e) { string sqlStr = "select * from tbl_Warehouse"; DataSet ds = new DataSet(); ds = CDataBase.GetDataFromDB(sqlStr); if (ds != null) { int n = ds.Tables[0].Rows.Count; cmbWarehouse.Items.Clear(); for (int i = 0; i < n; i++) { cmbWarehouse.Items.Add(ds.Tables[0].Rows[i].ItemArray[0]); } cmbWarehouse.SelectedIndex = -1; } else { MessageBox.Show("没有可用的仓库", "警告"); this.Close(); } }
bool RefreshData(string sqlStr) { DataSet ds = new DataSet(); ds = CDataBase.GetDataFromDB(sqlStr); if (ds != null) { dgrdvBook.DataSource = ds.Tables[0]; dgrdvBook.Columns[0].HeaderText = "书籍编号"; dgrdvBook.Columns[0].Width = 80; dgrdvBook.Columns[1].HeaderText = "ISBN"; dgrdvBook.Columns[1].Width = 80; dgrdvBook.Columns[2].HeaderText = "书名"; dgrdvBook.Columns[2].Width = 115; dgrdvBook.Columns[3].HeaderText = "作者"; dgrdvBook.Columns[3].Width = 60; dgrdvBook.Columns[4].HeaderText = "出版社"; dgrdvBook.Columns[4].Width = 70; dgrdvBook.Columns[5].HeaderText = "出版年份"; dgrdvBook.Columns[5].Width = 80; dgrdvBook.Columns[6].HeaderText = "零售价"; dgrdvBook.Columns[6].Width = 70; dgrdvBook.Columns[7].HeaderText = "进货价"; dgrdvBook.Columns[7].Width = 70; dgrdvBook.Columns[8].HeaderText = "利润"; dgrdvBook.Columns[8].Width = 40; dgrdvBook.Columns[9].HeaderText = "利润率"; dgrdvBook.Columns[9].Width = 70; dgrdvBook.Columns[10].HeaderText = "折扣信息"; dgrdvBook.Columns[10].Width = 80; dgrdvBook_RowHeaderMouseClick(null, null); return(true); } else { dgrdvBook.DataSource = null; return(false); } }
bool RefreshData(string sqlStr) { DataSet ds = new DataSet(); ds = CDataBase.GetDataFromDB(sqlStr); if (ds != null) { dgrdvWarehouse.DataSource = ds.Tables[0]; dgrdvWarehouse.Columns[0].HeaderText = "仓库编号"; dgrdvWarehouse.Columns[0].Width = 82; dgrdvWarehouse.Columns[1].HeaderText = "所在城市"; dgrdvWarehouse.Columns[1].Width = 80; dgrdvWarehouse.Columns[2].HeaderText = "联系电话"; dgrdvWarehouse.Columns[2].Width = 100; dgrdvWarehouse.Columns[3].HeaderText = "每月租金"; dgrdvWarehouse.Columns[3].Width = 80; return(true); } else { dgrdvWarehouse.DataSource = null; return(false); } }
void RefreshBasketData() { string sqlStr = "select tbl_Stocks.warehouseID, tbl_Book.bookID, tbl_Book.title, tbl_Book.retailPrice, tbl_ShoppingBasket.basketNumber, " + " tbl_Book.discountRate, tbl_Stocks.leftAmount, tbl_ShoppingBasket.basketStatus " + " from tbl_Book, tbl_ShoppingBasket, tbl_Stocks where tbl_Book.bookID = tbl_ShoppingBasket.bookID and " + " tbl_Stocks.warehouseID = tbl_ShoppingBasket.warehouseID and " + " tbl_Stocks.bookID = tbl_Book.bookID and tbl_ShoppingBasket.customerEmail = '" + CPublic.userInfo[0] + "'"; DataSet ds = new DataSet(); ds = CDataBase.GetDataFromDB(sqlStr); if (ds != null) { dgrdvBasket.DataSource = ds.Tables[0]; dgrdvBasket.Columns[0].HeaderText = "仓库编号"; dgrdvBasket.Columns[0].Width = 100; dgrdvBasket.Columns[1].HeaderText = "书籍编号"; dgrdvBasket.Columns[1].Width = 100; dgrdvBasket.Columns[2].HeaderText = "书名"; dgrdvBasket.Columns[2].Width = 80; dgrdvBasket.Columns[3].HeaderText = "单价"; dgrdvBasket.Columns[3].Width = 60; dgrdvBasket.Columns[4].HeaderText = "数量"; dgrdvBasket.Columns[4].Width = 60; dgrdvBasket.Columns[5].HeaderText = "折扣信息"; dgrdvBasket.Columns[5].Width = 80; dgrdvBasket.Columns[6].HeaderText = "库存量"; dgrdvBasket.Columns[6].Width = 80; dgrdvBasket.Columns[7].HeaderText = "状态"; dgrdvBasket.Columns[7].Width = 60; } else { dgrdvBasket.DataSource = null; } }
bool RefreshData(string sqlStr) { DataSet ds = new DataSet(); ds = CDataBase.GetDataFromDB(sqlStr); if (ds != null) { dgrdvOrder.DataSource = ds.Tables[0]; dgrdvOrder.Columns[0].HeaderText = "书名"; dgrdvOrder.Columns[0].Width = 100; dgrdvOrder.Columns[1].HeaderText = "数量"; dgrdvOrder.Columns[1].Width = 60; dgrdvOrder.Columns[2].HeaderText = "付款时间"; dgrdvOrder.Columns[2].Width = 115; dgrdvOrder.Columns[3].HeaderText = "订单状态"; dgrdvOrder.Columns[3].Width = 100; return(true); } else { dgrdvOrder.DataSource = null; return(false); } }
private void btnSelect_Click(object sender, EventArgs e) { try { string sqlStr = ""; bool fuzzyQuery; DataSet ds = new DataSet(); if (cmbUserType.SelectedIndex == -1) { MessageBox.Show("请选择用户类型!", "提示"); return; } if (cmbSelect.SelectedIndex == -1) { MessageBox.Show("请选择查询条件!", "提示"); return; } if (txtSelect.Text.Trim() == "") { MessageBox.Show("请输入需要查询的“" + cmbSelect.SelectedItem.ToString().Trim() + "”!", "提示"); return; } fuzzyQuery = txtSelect.Text.Trim().Contains('%'); string op = fuzzyQuery ? "like" : "="; if (cmbUserType.Text.Trim() == "普通管理员") { if (cmbSelect.SelectedIndex == 0) { sqlStr = "select " + dgrdvAdminSelectSql + " from tbl_Admin where adminUserName " + op + " '" + txtSelect.Text.Trim() + "' and adminType <> '超级管理员'"; } else if (cmbSelect.SelectedIndex == 1) { sqlStr = "select " + dgrdvAdminSelectSql + " from tbl_Admin where adminName " + op + " '" + txtSelect.Text.Trim() + "' and adminType <> '超级管理员'"; } else if (cmbSelect.SelectedIndex == 2) { sqlStr = "select " + dgrdvAdminSelectSql + " from tbl_Admin where jobID " + op + " '" + txtSelect.Text.Trim() + "' and adminType <> '超级管理员'"; } else if (cmbSelect.SelectedIndex == 3) { sqlStr = "select " + dgrdvAdminSelectSql + " from tbl_Admin where adminSex " + op + " '" + txtSelect.Text.Trim() + "' and adminType <> '超级管理员'"; } else if (cmbSelect.SelectedIndex == 4) { int d = txtSelect.Text.IndexOf(','); if (d < 0) { sqlStr = "select " + dgrdvAdminSelectSql + " from tbl_Admin where adminAge " + op + " '" + txtSelect.Text.Trim() + "' and adminType <> '超级管理员'"; } else { string s1 = txtSelect.Text.Substring(0, d); string s2 = txtSelect.Text.Substring(d + 1, txtSelect.Text.Length - d - 1); sqlStr = "select " + dgrdvAdminSelectSql + " from tbl_Admin where adminAge >=" + Convert.ToInt32(s1) + " and adminAge <=" + Convert.ToInt32(s2) + " and adminType <> '超级管理员'"; } } else if (cmbSelect.SelectedIndex == 5) { sqlStr = "select " + dgrdvAdminSelectSql + " from tbl_Admin where startDate " + op + " '" + txtSelect.Text.Trim() + "' and adminType <> '超级管理员'"; } else if (cmbSelect.SelectedIndex == 6) { int d = txtSelect.Text.IndexOf(','); if (d < 0) { sqlStr = "select " + dgrdvAdminSelectSql + " from tbl_Admin where salaryPerMonth " + op + " '" + txtSelect.Text.Trim() + "' and adminType <> '超级管理员'"; } else { string s1 = txtSelect.Text.Substring(0, d); string s2 = txtSelect.Text.Substring(d + 1, txtSelect.Text.Length - d - 1); sqlStr = "select " + dgrdvAdminSelectSql + " from tbl_Admin where salaryPerMonth >=" + Convert.ToInt32(s1) + " and salaryPerMonth <=" + Convert.ToInt32(s2) + " and adminType <> '超级管理员'"; } } ds = CDataBase.GetDataFromDB(sqlStr); if (ds != null) { SetDgrdvAdmin(ds); btnDelete.Enabled = true; } else { dgrdvUser.DataSource = null; ClearAll(); MessageBox.Show("没有符合条件的管理员记录!", "提示"); txtSelect.Text = ""; } } else { if (cmbSelect.SelectedIndex == 0) { sqlStr = "select * from tbl_Customer where customerEmail " + op + " '" + txtSelect.Text.Trim() + "'"; } else if (cmbSelect.SelectedIndex == 1) { sqlStr = "select * from tbl_Customer where customerName " + op + " '" + txtSelect.Text.Trim() + "'"; } else if (cmbSelect.SelectedIndex == 2) { sqlStr = "select * from tbl_Customer where customerPhone " + op + " '" + txtSelect.Text.Trim() + "'"; } else if (cmbSelect.SelectedIndex == 3) { sqlStr = "select * from tbl_Customer where customerAddress " + op + " '" + txtSelect.Text.Trim() + "'"; } else if (cmbSelect.SelectedIndex == 4) { int d = txtSelect.Text.IndexOf(','); if (d < 0) { sqlStr = "select * from tbl_Customer where balance " + op + " '" + txtSelect.Text.Trim() + "'"; } else { string s1 = txtSelect.Text.Substring(0, d); string s2 = txtSelect.Text.Substring(d + 1, txtSelect.Text.Length - d - 1); sqlStr = "select * from tbl_Customer where balance >=" + Convert.ToDouble(s1) + " and balance <=" + Convert.ToDouble(s2); } } ds = CDataBase.GetDataFromDB(sqlStr); if (ds != null) { SetDgrdvCustomer(ds); btnDelete.Enabled = true; } else { dgrdvUser.DataSource = null; ClearAll(); MessageBox.Show("没有符合条件的顾客记录!", "提示"); txtSelect.Text = ""; } } } catch (Exception ex) { CDataBase.conn.Close(); MessageBox.Show(ex.Message); } }
private void btnPay_Click(object sender, EventArgs e) { try { double totalPay = 0.0; double Price; double discount; int Amount; int stockAmount; int rowNum = dgrdvBasket.RowCount - 1; DateTime dtFinance = System.DateTime.Now; string generateDate = dtFinance.ToString().Trim(); for (int i = 0; i < rowNum; i++) { Price = Convert.ToDouble(dgrdvBasket[3, i].Value.ToString().Trim()); discount = Convert.ToDouble(dgrdvBasket[5, i].Value.ToString().Trim()); Amount = Convert.ToInt32(dgrdvBasket[4, i].Value.ToString().Trim()); stockAmount = Convert.ToInt32(dgrdvBasket[6, i].Value.ToString().Trim()); if (Amount > stockAmount) { MessageBox.Show("书籍:" + dgrdvBasket[2, i].Value.ToString().Trim() + " 库存不足\n 请更改数量!", "提示"); nupNumberUpdate.Enabled = true; nupNumberUpdate.Focus(); return; } if (dgrdvBasket[7, i].Value.ToString().Trim() == "未付款") { totalPay += (Price * Amount * discount); } } if (totalPay == 0.0) { MessageBox.Show("当前没有购物篮需要付款!", "提示"); return; } if (MessageBox.Show("购物篮付款总额为:" + totalPay.ToString() + "元\n 确定要付款吗?", "购物篮付款", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes) { int rowNum1 = dgrdvBasket.RowCount - 1; string sqlStr3, sqlStr4, sqlStr5, sqlStr6, warehouseID, bookID; int Number; DataSet ds = new DataSet(); sqlStr6 = "select balance from tbl_Customer where customerEmail='" + CPublic.userInfo[0] + "'"; ds = CDataBase.GetDataFromDB(sqlStr6); double balance = Convert.ToDouble(ds.Tables[0].Rows[0].ItemArray[0].ToString().Trim()); if (balance < totalPay) { MessageBox.Show("您的余额不足,未能完成付款!", "很遗憾"); return; } sqlStr3 = "update tbl_Customer set balance = balance - " + totalPay + " where customerEmail ='" + CPublic.userInfo[0] + "'"; CDataBase.UpdateDB(sqlStr3); for (int i = 0; i < rowNum1; i++) { if (dgrdvBasket[7, i].Value.ToString().Trim() == "未付款") { warehouseID = dgrdvBasket[0, i].Value.ToString().Trim(); bookID = dgrdvBasket[1, i].Value.ToString().Trim(); Number = Convert.ToInt32(dgrdvBasket[4, i].Value.ToString().Trim()); sqlStr4 = "update tbl_Stocks set leftAmount = leftAmount - " + Number + " , soldAmount = soldAmount + " + Number + " where warehouseID='" + warehouseID + "' and bookID='" + bookID + "'"; CDataBase.UpdateDB(sqlStr4); sqlStr5 = "insert into tbl_OrderForm values ('" + bookID + "','" + CPublic.userInfo[0] + "', " + Number + " ,'" + generateDate + "', '未出库' )"; CDataBase.UpdateDB(sqlStr5); } } string sqlStr1; sqlStr1 = "update tbl_ShoppingBasket set basketStatus = '已付款' where basketStatus = '未付款' "; CDataBase.UpdateDB(sqlStr1); RefreshBasketData(); string financeID = generateDate.Replace('/', '0').Replace(' ', '0').Replace(':', '0'); sqlStr1 = "insert into tbl_Finance values('" + financeID + "', " + totalPay + " , '进账' , '" + CPublic.userInfo[0] + "', '" + generateDate + "')"; CDataBase.UpdateDB(sqlStr1); btnPay.Enabled = false; btnDelete.Enabled = false; RefreshBookData(publicSqlString); } } catch (Exception ex) { CDataBase.conn.Close(); MessageBox.Show(ex.Message); } }
private void btnImport_Click(object sender, EventArgs e) { try { if (btnImport.Text == "进货") { btnImport.Text = "确定"; txtImportPrice.Enabled = true; txtImportAmount.Enabled = true; return; } else { btnImport.Text = "进货"; txtImportPrice.Enabled = false; txtImportAmount.Enabled = false; if (dgrdvStock.DataSource == null) { MessageBox.Show("没有选择想要进货的书籍!", "提示"); return; } if (txtImportPrice.Text.Trim() == "") { MessageBox.Show("请输入进货价!", "提示"); return; } else if (Convert.ToDouble(txtImportPrice.Text.Trim()) < 0) { MessageBox.Show("进货价须大于零", "提示"); return; } else if (Convert.ToInt32(txtImportAmount.Text.Trim()) < 0) { MessageBox.Show("进货数量须大于零", "提示"); return; } else if (txtImportAmount.Text.Trim() == "") { MessageBox.Show("请输入进货数量!", "提示"); return; } int n = dgrdvStock.CurrentCell.RowIndex; string warehouseID, bookID; warehouseID = dgrdvStock[0, n].Value.ToString().Trim(); bookID = dgrdvStock[2, n].Value.ToString().Trim(); string sqlStr; sqlStr = "select * from tbl_ImportList where warehouseID='" + warehouseID + "' and bookID='" + bookID + "'"; if (CDataBase.GetDataFromDB(sqlStr) != null) { if (MessageBox.Show("进货清单中已经存在该书的进货信息,仍然选择进货?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button2) == DialogResult.Yes) { ; } else { return; } } DateTime generateDateTime = new DateTime(); generateDateTime = System.DateTime.Now; sqlStr = "insert into tbl_ImportList values('" + warehouseID + "','" + bookID + "','" + generateDateTime.ToString().Trim() + "', " + Convert.ToDouble(txtImportPrice.Text.Trim()) + " , " + Convert.ToInt32(txtImportAmount.Text.Trim()) + " , " + "'未付款')"; CDataBase.UpdateDB(sqlStr); sqlStr = "delete from tbl_ImportList where status = '已付款' or status ='已退货'"; CDataBase.UpdateDB(sqlStr); RefreshImportData(); MessageBox.Show("添加进货清单成功!", "提示"); btnPay.Enabled = true; txtImportPrice.Text = ""; txtImportAmount.Text = ""; } } catch (Exception ex) { CDataBase.conn.Close(); MessageBox.Show(ex.Message); } }