private void btnClose_Click(object sender, EventArgs e) { try { string sqlStr; sqlStr = "update tbl_OrderForm set orderStatus = '已出库' where orderStatus = '未出库' "; CDataBase.UpdateDB(sqlStr); if ((ob_FrmInfoCustomer != null && !ob_FrmInfoCustomer.IsDisposed) || (ob_FrmBookCity != null && !ob_FrmBookCity.IsDisposed) || (ob_FrmOrder != null && !ob_FrmOrder.IsDisposed) || (ob_FrmHelp != null && !ob_FrmHelp.IsDisposed)) { if (MessageBox.Show("已打开了部分子系统,确实要退出系统吗?", "询问", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes) { Application.Exit(); } } else { Application.Exit(); } } catch (Exception ex) { CDataBase.conn.Close(); MessageBox.Show(ex.Message); } }
private void btnClose_Click(object sender, EventArgs e) { string sqlStr; sqlStr = "update tbl_OrderForm set orderStatus = '已送达' where orderStatus = '已出库' "; CDataBase.UpdateDB(sqlStr); if ((ob_FrmBook != null && !ob_FrmBook.IsDisposed) || (ob_FrmFinance != null && !ob_FrmFinance.IsDisposed) || (ob_FrmStock != null && !ob_FrmStock.IsDisposed) || (ob_FrmInfoAdmin != null && !ob_FrmInfoAdmin.IsDisposed) || (ob_FrmUser != null && !ob_FrmUser.IsDisposed) || (ob_FrmDataBase != null && !ob_FrmDataBase.IsDisposed) || (ob_FrmHelp != null && !ob_FrmHelp.IsDisposed)) { if (MessageBox.Show("已打开了部分子系统,确实要退出系统吗?", "询问", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes) { Application.Exit(); } } else { Application.Exit(); } }
private void btnDelete_Click(object sender, EventArgs e) { try { string userName; if (dgrdvUser.DataSource == null) { MessageBox.Show("没有可以删除的用户", "提示"); } else { int n = this.dgrdvUser.CurrentCell.RowIndex; userName = this.dgrdvUser.Rows[n].Cells[0].Value.ToString().Trim(); if (MessageBox.Show("确定要删除用户“" + userName + "”吗?", "删除用户", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes) { string sqlStr = "delete from tbl_User where userName='******'"; CDataBase.UpdateDB(sqlStr); dgrdvUser.Rows.RemoveAt(n); } } } catch (Exception ex) { CDataBase.conn.Close(); MessageBox.Show(ex.Message); } }
private void btnDeletePswPctQuestion_Click(object sender, EventArgs e) { try { if (MessageBox.Show("删除密保问题答案后,一旦忘记用户密码,将无法找回,确定要删除吗?", "删除密保问题答案", MessageBoxButtons.YesNo, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button2) == DialogResult.Yes) { string sqlStr = "delete from tbl_Information where userName='******'"; if (CDataBase.UpdateDB(sqlStr)) { txtName.Text = ""; txtAnswer1.Text = ""; txtAnswer2.Text = ""; txtAnswer3.Text = ""; sqlStr = "update tbl_User set firstLogin='******' where userName='******'"; CDataBase.UpdateDB(sqlStr); MessageBox.Show("删除密保问题成功", "恭喜"); set = true; txtName.Focus(); } } } catch (Exception ex) { CDataBase.conn.Close(); MessageBox.Show(ex.Message); } }
private void btnAdd_Click(object sender, EventArgs e) { try { if (btnAdd.Text == "添加") { btnAdd.Text = "确定"; btnDelete.Enabled = false; ObjOpen(); } else if (txtWarehouseID.Text.Trim() == "") { MessageBox.Show("仓库编号不能为空!", "提示"); txtWarehouseID.Focus(); return; } else if (txtCity.Text.Trim() == "") { MessageBox.Show("所在城市不能为空!", "提示"); txtCity.Focus(); return; } else if (txtPhone.Text.Trim() == "") { MessageBox.Show("联系电话不能为空!", "提示"); txtPhone.Focus(); return; } else if (txtRent.Text.Trim() == "") { MessageBox.Show("每月租金不能为空!", "提示"); txtRent.Focus(); return; } else if (!No(txtWarehouseID.Text.Trim())) { MessageBox.Show("该仓库已存在!", "提示"); ClearAll(); return; } else { btnAdd.Text = "添加"; string sqlStr = "insert into tbl_Warehouse values('" + txtWarehouseID.Text.Trim() + "','" + txtCity.Text.Trim() + "','" + txtPhone.Text.Trim() + "','" + txtRent.Text.Trim() + "')"; CDataBase.UpdateDB(sqlStr); RefreshData("select * from tbl_Warehouse"); ClearAll(); ObjClose(); } } catch (Exception ex) { CDataBase.conn.Close(); MessageBox.Show(ex.Message); ClearAll(); ObjClose(); } }
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); } }
private void btnUpdate_Click(object sender, EventArgs e) { try { if (btnUpdate.Text.Trim() == "修改") { btnUpdate.Text = "确定"; btnAdd.Enabled = false; btnDelete.Enabled = false; btnClose.Enabled = false; cmbSelect.Enabled = false; txtSelect.Enabled = false; btnSelect.Enabled = false; btnAll.Enabled = false; btnUp.Enabled = false; btnDown.Enabled = false; dgrdvBook.Enabled = false; ObjUpdateOpen(); } else { btnUpdate.Text = "修改"; btnAdd.Enabled = true; btnDelete.Enabled = true; btnClose.Enabled = true; cmbSelect.Enabled = true; txtSelect.Enabled = true; btnSelect.Enabled = true; btnAll.Enabled = true; btnUp.Enabled = true; btnDown.Enabled = true; dgrdvBook.Enabled = true; ObjClose(); double retail = Convert.ToDouble(txtRetail.Text.Trim()); double import = Convert.ToDouble(txtImport.Text.Trim()); string sqlStr; sqlStr = "update tbl_Book set bookID='" + txtBookID.Text.Trim() + "',ISBN='" + txtISBN.Text.Trim() + "',title='" + txtTitle.Text.Trim() + "',bookAuthor='" + txtAuthor.Text.Trim() + "',bookPublisher='" + txtPublisher.Text.Trim() + "',year='" + txtYear.Text.Trim() + "',retailPrice =" + retail + " ,importPrice =" + import + " ,profit = " + (retail - import) + " ,profitRate = " + ((retail - import) / import) + " ,discountRate = " + TDouble(txtDiscount.Text.Trim()) + " where bookID='" + txtBookID.Text.Trim() + "'"; CDataBase.UpdateDB(sqlStr); bool b = RefreshData("select * from tbl_Book"); } } catch (Exception ex) { CDataBase.conn.Close(); MessageBox.Show(ex.Message); } }
void InsertAdminInfo() { CDataBase.conn.ConnectionString = CDataBase.connStr; string psw = CPublic.GetMd5Str(txtSAPassword.Text.Trim()); string sqlStr1 = "insert into tbl_User values('" + txtSuperAdmin.Text.Trim() + "','" + psw.Trim() + "','超级管理员','是')"; string sqlStr2 = "insert into tbl_Admin values('" + txtSuperAdmin.Text.Trim() + "','" + txtSuperName.Text.Trim() + "','" + "000" + "','" + cmbSuperSex.Text.Trim() + "','" + txtSuperAge.Text.Trim() + "','" + "超级管理员" + "','" + "2014-01-01" + "','" + "10000" + "')"; if (CDataBase.UpdateDB(sqlStr1) && CDataBase.UpdateDB(sqlStr2)) { MessageBox.Show("超级管理员: " + txtSuperAdmin.Text + " 注册成功!"); } }
private void btnOK_Click(object sender, EventArgs e) { try { startDateString = dtpStartDate.Value.ToString("yyyy-MM-dd"); if (txtName.Text.Trim() == "") { MessageBox.Show("姓名不能为空", "提示"); txtName.Focus(); } else if (txtJobID.Text.Trim() == "") { MessageBox.Show("工号不能为空", "提示"); txtJobID.Focus(); } else if (txtAge.Text.Trim() == "") { MessageBox.Show("年龄不能为空", "提示"); txtAge.Focus(); } else if (int.Parse(txtAge.Text.Trim()) <= 0) { MessageBox.Show("年龄必须大于零", "提示"); } else if (txtSalaryPerMonth.Text.Trim() == "") { MessageBox.Show("月薪不能为空", "提示"); txtSalaryPerMonth.Focus(); } else { string sqlStr = "insert into tbl_Admin values('" + txtUserName.Text.Trim() + "','" + txtName.Text.Trim() + "','" + txtJobID.Text.Trim() + "','" + cmbSex.Text.Trim() + "','" + txtAge.Text.Trim() + "','" + "普通管理员" + "','" + startDateString + "','" + txtSalaryPerMonth.Text.Trim() + "')"; if (CDataBase.UpdateDB(sqlStr)) { MessageBox.Show("普通管理员:" + txtUserName.Text + " 信息完善成功!", "完善用户信息"); } this.Close(); } } catch (Exception ex) { CDataBase.conn.Close(); MessageBox.Show(ex.Message); this.Close(); } }
private void btnClose_Click(object sender, EventArgs e) { try { string sqlStr = "delete from tbl_ShoppingBasket where basketStatus = '已付款' or basketStatus ='已删除'"; if (CDataBase.UpdateDB(sqlStr)) { this.Close(); } } catch (Exception ex) { CDataBase.conn.Close(); MessageBox.Show(ex.Message); } }
private void btnAddToBasket_Click(object sender, EventArgs e) { try { if (dgrdvBookCity.DataSource == null) { MessageBox.Show("没有能够添加到购物篮的书籍!", "提示"); return; } if (nupNumber.Value < 1) { MessageBox.Show("请输入要选购的数量!", "提示"); nupNumber.Focus(); return; } int n = dgrdvBookCity.CurrentCell.RowIndex; string warehouseID = dgrdvBookCity[0, n].Value.ToString().Trim(); string bookID = dgrdvBookCity[1, n].Value.ToString().Trim(); int m = dgrdvBasket.RowCount - 1; for (int i = 0; i < m; i++) { if (dgrdvBasket[0, i].Value.ToString().Trim() == warehouseID && dgrdvBasket[1, i].Value.ToString().Trim() == bookID && dgrdvBasket[7, i].Value.ToString().Trim() == "未付款") { MessageBox.Show("购物篮中已经存在该书,请更改购物篮数量!", "提示"); nupNumberUpdate.Focus(); return; } } string sqlStr = "insert into tbl_ShoppingBasket values('" + bookID + "','" + warehouseID + "','" + CPublic.userInfo[0] + "', " + (int)nupNumber.Value + " , " + "'未付款')"; CDataBase.UpdateDB(sqlStr); sqlStr = "delete from tbl_ShoppingBasket where basketStatus = '已付款' or basketStatus ='已删除'"; CDataBase.UpdateDB(sqlStr); RefreshBasketData(); MessageBox.Show("添加到购物篮成功!", "提示"); btnPay.Enabled = true; nupNumber.Enabled = false; nupNumber.Value = 0; } catch (Exception ex) { CDataBase.conn.Close(); MessageBox.Show(ex.Message); } }
private void btnUpdate_Click(object sender, EventArgs e) { try { if (txtName1.Text.Trim() == "") { MessageBox.Show("姓名不能为空", "提示"); txtName1.Focus(); } else if (txtStartDate.Text.Trim() == "") { MessageBox.Show("入职日期不能为空", "提示"); txtStartDate.Focus(); } else if (txtAge.Text.Trim() == "") { MessageBox.Show("年龄不能为空", "提示"); txtAge.Focus(); } else if (txtSalary.Text.Trim() == "") { MessageBox.Show("月薪不能为空", "提示"); txtSalary.Focus(); } else { string sqlStr = "update tbl_Admin set adminName='" + txtName1.Text.Trim() + "',adminAge='" + txtAge.Text.Trim() + "',startDate='" + txtStartDate.Text.Trim() + "',salaryPerMonth='" + txtSalary.Text.Trim() + "' where adminUserName='******'"; if (CDataBase.UpdateDB(sqlStr)) { MessageBox.Show("修改个人信息成功!", "恭喜"); adminName = txtName1.Text; startDate = txtStartDate.Text; adminAge = txtAge.Text; adminSalary = txtSalary.Text; } } } catch (Exception ex) { CDataBase.conn.Close(); MessageBox.Show(ex.Message); this.Close(); } }
private void btnChagePassword_Click(object sender, EventArgs e) { try { if (CPublic.GetMd5Str(txtOldPassword.Text.Trim()) != CPublic.userInfo[1]) { MessageBox.Show("旧密码错误,请重新输入", "提示"); txtOldPassword.Text = ""; txtNewPassword1.Text = ""; txtNewPassword2.Text = ""; txtOldPassword.Focus(); } else if (txtNewPassword1.Text.Trim() == "" && txtNewPassword2.Text.Trim() == "") { MessageBox.Show("密码不能为空", "提示"); txtNewPassword1.Focus(); } else if (txtNewPassword1.Text.Trim() == txtNewPassword2.Text.Trim()) { string psw = CPublic.GetMd5Str(txtNewPassword1.Text.Trim()); string sqlStr = "update tbl_User set userPassword='******' where userName='******'"; if (CDataBase.UpdateDB(sqlStr)) { CPublic.userInfo[1] = psw.Trim(); MessageBox.Show("修改成功,请记住您的新密码", "修改密码"); txtOldPassword.Text = ""; txtNewPassword1.Text = ""; txtNewPassword2.Text = ""; } } else { MessageBox.Show("两次输入的密码不一致", "提示"); txtNewPassword1.Text = ""; txtNewPassword2.Text = ""; txtNewPassword1.Focus(); } } catch (Exception ex) { CDataBase.conn.Close(); MessageBox.Show(ex.Message); } }
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 btnUpdate_Click(object sender, EventArgs e) { try { if (txtName1.Text.Trim() == "") { MessageBox.Show("姓名不能为空", "提示"); txtName1.Focus(); } else if (txtPhone.Text.Trim() == "") { MessageBox.Show("电话不能为空", "提示"); txtPhone.Focus(); } else if (txtAddress.Text.Trim() == "") { MessageBox.Show("地址不能为空", "提示"); txtAddress.Focus(); } else { string sqlStr = "update tbl_Customer set customerName='" + txtName1.Text.Trim() + "',customerPhone='" + txtPhone.Text.Trim() + "',customerAddress='" + txtAddress.Text.Trim() + "',balance='" + txtBalance.Text.Trim() + "' where customerEmail='" + CPublic.userInfo[0] + "'"; if (CDataBase.UpdateDB(sqlStr)) { MessageBox.Show("修改个人信息成功!", "恭喜"); customerName = txtName1.Text; balance = txtBalance.Text; } } } catch (Exception ex) { CDataBase.conn.Close(); MessageBox.Show(ex.Message); this.Close(); } }
private void btnUpdateNumber_Click(object sender, EventArgs e) { try { int n = dgrdvBasket.CurrentCell.RowIndex; string warehouseID = dgrdvBasket[0, n].Value.ToString().Trim(); string bookID = dgrdvBasket[1, n].Value.ToString().Trim(); if (MessageBox.Show("确定将数量更改为" + nupNumberUpdate.Value.ToString().Trim() + "吗 ?", "删除购物篮", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes) { string sqlStr = "update tbl_ShoppingBasket set basketNumber = " + (int)nupNumberUpdate.Value + " where warehouseID='" + warehouseID + "' and bookID='" + bookID + "' and basketStatus ='未付款'"; CDataBase.UpdateDB(sqlStr); RefreshBasketData(); } } catch (Exception ex) { CDataBase.conn.Close(); MessageBox.Show(ex.Message); } }
private void btnOK_Click(object sender, EventArgs e) { try { if (txtName.Text.Trim() == "") { MessageBox.Show("姓名不能为空", "提示"); txtName.Focus(); } else if (txtPhone.Text.Trim() == "") { MessageBox.Show("电话不能为空", "提示"); txtPhone.Focus(); } else if (txtAddress.Text.Trim() == "") { MessageBox.Show("地址不能为空", "提示"); txtAddress.Focus(); } else { string sqlStr = "insert into tbl_Customer values('" + txtUserName.Text.Trim() + "','" + txtName.Text.Trim() + "','" + txtPhone.Text.Trim() + "','" + txtAddress.Text.Trim() + "','" + "10000.00" + "')"; if (CDataBase.UpdateDB(sqlStr)) { MessageBox.Show("顾客:" + txtUserName.Text + " 信息完善成功!", "完善用户信息"); } this.Close(); } } catch (Exception ex) { CDataBase.conn.Close(); MessageBox.Show(ex.Message); this.Close(); } }
private void btnReturn_Click(object sender, EventArgs e) { try { int n = dgrdvImportList.CurrentCell.RowIndex; string warehouseID = dgrdvImportList[0, n].Value.ToString().Trim(); string bookID = dgrdvImportList[2, n].Value.ToString().Trim(); string generateDate = dgrdvImportList[7, n].Value.ToString().Trim(); if (MessageBox.Show("确定要退货吗?", "退货", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes) { string sqlStr = "update tbl_ImportList set status = '已退货' where warehouseID='" + warehouseID + "' and bookID='" + bookID + "' and generateDateTime='" + generateDate + "'"; CDataBase.UpdateDB(sqlStr); RefreshImportData(); } } catch (Exception ex) { CDataBase.conn.Close(); MessageBox.Show(ex.Message); } }
private void btnAdd_Click(object sender, EventArgs e) { try { if (btnAdd.Text.Trim() == "添加") { btnAdd.Text = "确定"; ObjAddOpen(); bool a = RefreshData("select * from tbl_Book"); ClearAll(); txtDiscount.Text = "%形式"; btnUpdate.Enabled = false; btnDelete.Enabled = false; cmbSelect.Enabled = false; txtSelect.Enabled = false; btnSelect.Enabled = false; btnAll.Enabled = false; btnUp.Enabled = false; btnDown.Enabled = false; dgrdvBook.Enabled = false; return; } else if (txtBookID.Text.Trim() == "") { MessageBox.Show("书籍编号不能为空!", "提示"); txtBookID.Focus(); return; } else if (txtISBN.Text.Trim() == "") { MessageBox.Show("ISBN不能为空!", "提示"); txtISBN.Focus(); return; } else if (txtTitle.Text.Trim() == "") { MessageBox.Show("书名不能为空!", "提示"); txtTitle.Focus(); return; } else if (txtAuthor.Text == "") { MessageBox.Show("作者不能为空!", "提示"); txtAuthor.Focus(); return; } else if (txtPublisher.Text.Trim() == "") { MessageBox.Show("出版社不能为空!", "提示"); txtPublisher.Focus(); return; } else if (txtYear.Text.Trim() == "") { MessageBox.Show("出版年份不能为空!", "提示"); txtYear.Focus(); return; } else if (txtRetail.Text.Trim() == "") { MessageBox.Show("零售价不能为空!", "提示"); txtRetail.Focus(); return; } else if (txtImport.Text.Trim() == "") { MessageBox.Show("进货价不能为空!", "提示"); txtImport.Focus(); return; } else if (txtDiscount.Text.Trim() == "") { MessageBox.Show("折扣信息不能为空!", "提示"); txtDiscount.Focus(); return; } else if (!No(txtBookID.Text.Trim())) { MessageBox.Show("该书已存在!", "提示"); ClearAll(); return; } btnAdd.Text = "添加"; double retail = Convert.ToDouble(txtRetail.Text.Trim()); double import = Convert.ToDouble(txtImport.Text.Trim()); string sqlStr = "insert into tbl_Book values('" + txtBookID.Text.Trim() + "','" + txtISBN.Text.Trim() + "','" + txtTitle.Text.Trim() + "','" + txtAuthor.Text.Trim() + "','" + txtPublisher.Text.Trim() + "','" + txtYear.Text.Trim() + "','" + txtRetail.Text.Trim() + "','" + txtImport.Text.Trim() + "', " + (retail - import) + " , " + ((retail - import) / import) + " , '" + TDouble(txtDiscount.Text.Trim()) + "')"; CDataBase.UpdateDB(sqlStr); bool b = RefreshData("select * from tbl_Book"); if (MessageBox.Show("添加成功!继续添加吗?", "添加书籍", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == DialogResult.Yes) { ClearAll(); ObjAddOpen(); btnAdd.Text = "确定"; } else { ObjClose(); btnUpdate.Enabled = true; btnDelete.Enabled = true; btnClose.Enabled = true; cmbSelect.Enabled = true; txtSelect.Enabled = true; btnSelect.Enabled = true; btnAll.Enabled = true; dgrdvBook.Enabled = true; } } catch (Exception ex) { CDataBase.conn.Close(); MessageBox.Show(ex.Message); ClearAll(); ObjClose(); btnUpdate.Enabled = true; btnDelete.Enabled = true; btnClose.Enabled = true; cmbSelect.Enabled = true; txtSelect.Enabled = true; btnSelect.Enabled = true; btnAll.Enabled = true; dgrdvBook.Enabled = true; dgrdvBook_RowHeaderMouseClick(null, null); } }
private void btnSetPswPctQuestion_Click(object sender, EventArgs e) { try { if (txtName.Enabled == false) { txtName.Enabled = true; txtAnswer1.Enabled = true; txtAnswer2.Enabled = true; txtAnswer3.Enabled = true; txtName.Focus(); btnSetPswPctQuestion.Text = "确定"; } else { if (txtName.Text.Trim() == "") { MessageBox.Show("姓名不能为空", "提示"); txtName.Focus(); return; } else if (txtAnswer1.Text.Trim() == "") { MessageBox.Show("请输入第一个问题的答案", "提示"); txtAnswer1.Focus(); return; } else if (txtAnswer2.Text.Trim() == "") { MessageBox.Show("请输入第二个问题的答案", "提示"); txtAnswer2.Focus(); return; } else if (txtAnswer3.Text.Trim() == "") { MessageBox.Show("请输入第三个问题的答案", "提示"); txtAnswer3.Focus(); return; } string sqlStr; if (set) { sqlStr = "insert into tbl_Information values('" + CPublic.userInfo[0] + "','" + txtName.Text.Trim() + "','" + txtAnswer1.Text.Trim() + "','" + txtAnswer2.Text.Trim() + "','" + txtAnswer3.Text.Trim() + "')"; if (CDataBase.UpdateDB(sqlStr)) { MessageBox.Show("设置密保问题成功", "恭喜"); set = false; sqlStr = "update tbl_User set firstLogin='******' where userName='******'"; CDataBase.UpdateDB(sqlStr); } } else { sqlStr = "update tbl_Information set name='" + txtName.Text.Trim() + "',Answer1='" + txtAnswer1.Text.Trim() + "',Answer2='" + txtAnswer2.Text.Trim() + "',Answer3='" + txtAnswer3.Text.Trim() + "' where userName='******'"; if (CDataBase.UpdateDB(sqlStr)) { MessageBox.Show("修改密保问题成功", "恭喜"); } } btnSetPswPctQuestion.Text = "设置密保问题"; txtName.Text = ""; txtAnswer1.Text = ""; txtAnswer2.Text = ""; txtAnswer3.Text = ""; txtName.Enabled = false; txtBalance.Enabled = false; txtAnswer1.Enabled = false; txtAnswer2.Enabled = false; txtAnswer3.Enabled = false; btnSetPswPctQuestion.Enabled = false; btnDeletePswPctQuestion.Enabled = false; } } catch (Exception ex) { CDataBase.conn.Close(); MessageBox.Show(ex.Message); } }
private void btnOK_Click(object sender, EventArgs e) { try { if (txtUserName.Text.Trim() == "") { MessageBox.Show("注册邮箱不能为空", "提示"); txtUserName.Focus(); } else if (!UserName(txtUserName.Text.Trim())) { MessageBox.Show("该用户已存在!", "提示"); txtUserName.Text = ""; txtUserName.Focus(); } else if (txtName.Text.Trim() == "") { MessageBox.Show("姓名不能为空", "提示"); txtName.Focus(); } else if (txtPhone.Text.Trim() == "") { MessageBox.Show("电话不能为空", "提示"); txtPhone.Focus(); } else if (txtAddress.Text.Trim() == "") { MessageBox.Show("地址不能为空", "提示"); txtAddress.Focus(); } else if (txtPassword.Text.Trim() == "" && txtComfirmPassword.Text.Trim() == "") { MessageBox.Show("密码不能为空", "提示"); txtPassword.Focus(); } else if (txtPassword.Text.Trim() != txtComfirmPassword.Text.Trim()) { MessageBox.Show("两次密码不一致", "提示"); txtPassword.Text = ""; txtComfirmPassword.Text = ""; txtPassword.Focus(); } else { string sqlStr1 = "insert into tbl_User values('" + txtUserName.Text.Trim() + "','" + CPublic.GetMd5Str(txtPassword.Text.Trim()) + "','" + "顾客" + "','" + "是" + "')"; string sqlStr2 = "insert into tbl_Customer values('" + txtUserName.Text.Trim() + "','" + txtName.Text.Trim() + "','" + txtPhone.Text.Trim() + "','" + txtAddress.Text.Trim() + "','" + "10000.00" + "')"; if (CDataBase.UpdateDB(sqlStr1) && CDataBase.UpdateDB(sqlStr2)) { MessageBox.Show("顾客:" + txtUserName.Text + " 注册成功!", "恭喜"); } this.Close(); } } catch (Exception ex) { CDataBase.conn.Close(); MessageBox.Show(ex.Message); this.Close(); } }
private void btnRegedit_Click(object sender, EventArgs e) { try { if (btnRegedit.Text == "注册") { btnRegedit.Text = "确定"; btnCancel.Enabled = true; ObjOpen(); } else if (txtUserName.Text.Trim() == "") { MessageBox.Show("用户名不能为空", "提示"); txtUserName.Focus(); } else if (txtPassword.Text.Trim() == "") { MessageBox.Show("密码不能为空", "提示"); txtPassword.Focus(); } else if (!UserNameExist(txtUserName.Text.Trim())) { MessageBox.Show("该用户已存在!", "提示"); txtUserName.Text = ""; txtPassword.Text = ""; ObjOpen(); btnRegedit.Text = "注册"; txtUserName.Focus(); } else { btnRegedit.Text = "注册"; string psw = CPublic.GetMd5Str(txtPassword.Text.Trim()); string sqlStr = "insert into tbl_User values('" + txtUserName.Text.Trim() + "','" + psw.Trim() + "','" + cmbPurview.Text.Trim() + "','是')"; string regType = cmbPurview.Text.Trim(); if (CDataBase.UpdateDB(sqlStr)) { MessageBox.Show(cmbPurview.Text + " " + txtUserName.Text + " 注册成功!\n" + "请进一步完善用户信息", "注册用户"); } CPublic.userName = txtUserName.Text.Trim(); if (regType == "普通管理员") { if (ob_FrmCompleteAdminInfo == null || ob_FrmCompleteAdminInfo.IsDisposed) { ob_FrmCompleteAdminInfo = new FrmCompleteAdminInfo(); ob_FrmCompleteAdminInfo.Show(); } else { ob_FrmCompleteAdminInfo.Activate(); } } else if (regType == "顾客") { if (ob_FrmCompleteCustomerInfo == null || ob_FrmCompleteCustomerInfo.IsDisposed) { ob_FrmCompleteCustomerInfo = new FrmCompleteCustomerInfo(); ob_FrmCompleteCustomerInfo.Show(); } else { ob_FrmCompleteCustomerInfo.Activate(); } } ClearAll(); ObjClose(); btnCancel.Enabled = false; } } catch (Exception ex) { CDataBase.conn.Close(); MessageBox.Show(ex.Message); ClearAll(); ObjClose(); btnCancel.Enabled = false; } }
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 btnPay_Click(object sender, EventArgs e) { try { double totalPay = 0.0; double importPrice; int importAmount; int rowNum = dgrdvImportList.RowCount - 1; for (int i = 0; i < rowNum; i++) { importPrice = Convert.ToDouble(dgrdvImportList[4, i].Value.ToString().Trim()); importAmount = Convert.ToInt32(dgrdvImportList[5, i].Value.ToString().Trim()); if (dgrdvImportList[6, i].Value.ToString().Trim() == "未付款") { totalPay += (importPrice * importAmount); } } if (totalPay == 0.0) { MessageBox.Show("当前没有订货清单需要付款!", "提示"); return; } if (MessageBox.Show("订货清单付款总额为:" + totalPay.ToString() + "元\n 确定要付款吗?", "订货清单付款", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes) { string sqlStr1, sqlStr2; sqlStr1 = "update tbl_ImportList set status = '已付款' where status = '未付款' "; CDataBase.UpdateDB(sqlStr1); RefreshImportData(); int rowNum1 = dgrdvImportList.RowCount - 1; string sqlStr3, sqlStr4, warehouseID, bookID; double importPrice1; int importNumber; for (int i = 0; i < rowNum1; i++) { if (dgrdvImportList[6, i].Value.ToString().Trim() == "已付款") { warehouseID = dgrdvImportList[0, i].Value.ToString().Trim(); bookID = dgrdvImportList[2, i].Value.ToString().Trim(); importPrice1 = Convert.ToDouble(dgrdvImportList[4, i].Value.ToString().Trim()); importNumber = Convert.ToInt32(dgrdvImportList[5, i].Value.ToString().Trim()); sqlStr3 = "update tbl_Book set importPrice = " + importPrice1 + ", profit = retailPrice - " + importPrice1 + " , profitRate = (retailPrice-" + importPrice1 + ")/" + importPrice1 + " where bookID='" + bookID + "'"; sqlStr4 = "update tbl_Stocks set leftAmount = leftAmount + " + importNumber + " where warehouseID='" + warehouseID + "' and bookID='" + bookID + "'"; if (!CDataBase.UpdateDB(sqlStr3) || !CDataBase.UpdateDB(sqlStr4)) { MessageBox.Show("添加库存失败!", "警告"); return; } } } DateTime dtFinance = System.DateTime.Now; string generateDate = dtFinance.ToString().Trim(); string financeID = generateDate.Replace('/', '0').Replace(' ', '0').Replace(':', '0'); sqlStr2 = "insert into tbl_Finance values('" + financeID + "', " + totalPay + " , '出账' , '" + CPublic.userInfo[0] + "', '" + generateDate + "')"; CDataBase.UpdateDB(sqlStr2); btnPay.Enabled = false; RefreshStockData(publicSqlString1); } } catch (Exception ex) { CDataBase.conn.Close(); MessageBox.Show(ex.Message); } }
private void btnOK_Click(object sender, EventArgs e) { try { if (txtBookID.Text.Trim() == "") { MessageBox.Show("书籍编号不能为空!", "提示"); txtBookID.Focus(); return; } else if (txtISBN.Text.Trim() == "") { MessageBox.Show("ISBN不能为空!", "提示"); txtISBN.Focus(); return; } else if (txtTitle.Text.Trim() == "") { MessageBox.Show("书名不能为空!", "提示"); txtTitle.Focus(); return; } else if (txtAuthor.Text == "") { MessageBox.Show("作者不能为空!", "提示"); txtAuthor.Focus(); return; } else if (txtPublisher.Text.Trim() == "") { MessageBox.Show("出版社不能为空!", "提示"); txtPublisher.Focus(); return; } else if (txtYear.Text.Trim() == "") { MessageBox.Show("出版年份不能为空!", "提示"); txtYear.Focus(); return; } else if (txtImport.Text.Trim() == "") { MessageBox.Show("进货价不能为空!", "提示"); txtImport.Focus(); return; } else if (Convert.ToDouble(txtImport.Text.Trim()) < 0) { MessageBox.Show("进货价不能小于零", "提示"); txtImport.Focus(); return; } else if (txtImportNumber.Text.Trim() == "") { MessageBox.Show("进货数量不能为空!", "提示"); txtImportNumber.Focus(); return; } else if (Convert.ToInt32(txtImportNumber.Text.Trim()) < 0) { MessageBox.Show("进货数量不能小于零!", "提示"); txtImportNumber.Focus(); return; } else if (cmbWarehouse.Text.Trim() == "") { MessageBox.Show("进货仓库不能为空!", "提示"); cmbWarehouse.Focus(); return; } else if (txtRetail.Text.Trim() == "") { MessageBox.Show("零售价不能为空!", "提示"); txtRetail.Focus(); return; } else if (Convert.ToDouble(txtRetail.Text.Trim()) < 0) { MessageBox.Show("零售价不能小于零!", "提示"); txtRetail.Focus(); return; } else if (txtDiscount.Text.Trim() == "") { MessageBox.Show("折扣信息不能为空!", "提示"); txtDiscount.Focus(); return; } else if (Convert.ToDouble(txtDiscount.Text.Trim()) < 0 || Convert.ToDouble(txtDiscount.Text.Trim()) > 1) { MessageBox.Show("折扣信息不符合要求", "提示"); txtDiscount.Focus(); return; } else if (!No(txtBookID.Text.Trim())) { MessageBox.Show("该书已存在!", "提示"); ClearAll(); return; } double retail = Convert.ToDouble(txtRetail.Text.Trim()); double import = Convert.ToDouble(txtImport.Text.Trim()); int importNumber = Convert.ToInt32(txtImportNumber.Text.Trim()); double discount = Convert.ToDouble(txtDiscount.Text.Trim()); string sqlStr1 = "insert into tbl_Book values('" + txtBookID.Text.Trim() + "','" + txtISBN.Text.Trim() + "','" + txtTitle.Text.Trim() + "','" + txtAuthor.Text.Trim() + "','" + txtPublisher.Text.Trim() + "','" + txtYear.Text.Trim() + "','" + txtRetail.Text.Trim() + "','" + txtImport.Text.Trim() + "', " + (retail - import) + " , " + (retail - import) / import + " , " + discount + " )"; DateTime dt = System.DateTime.Now; string generateDateTime = dt.ToString().Trim(); string sqlStr2 = "insert into tbl_ImportList values('" + cmbWarehouse.SelectedItem.ToString().Trim() + "','" + txtBookID.Text.Trim() + "', '" + generateDateTime + "' , " + import + " , " + importNumber + " , '未付款')"; string sqlStr3 = "insert into tbl_Stocks values('" + cmbWarehouse.SelectedItem.ToString().Trim() + "','" + txtBookID.Text.Trim() + "', 0 , 0 , 10)"; if (CDataBase.UpdateDB(sqlStr1) && CDataBase.UpdateDB(sqlStr2) && CDataBase.UpdateDB(sqlStr3)) { MessageBox.Show("添加新书成功!", "恭喜"); } ClearAll(); } catch (Exception ex) { CDataBase.conn.Close(); MessageBox.Show(ex.Message); ClearAll(); } }
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); } }