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