private void dgvMatHang_HoaDon_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex == 0 && e.RowIndex != -1) // bấm nút xóa trên dgv
{
if (ThuvienWin.confirm())
{
DataTable dt = ThuvienWin.XemQuery("select * from hoadon where ID = " + MaChonHD);
ThuvienWin.ThemSuaXoaQuery(String.Format("update hoadon set Tongtien = '{0}' where ID = {1}", int.Parse(dt.Rows[0]["Tongtien"].ToString()) - int.Parse(dgvMatHang_HoaDon.Rows[e.RowIndex].Cells[9].Value.ToString()), MaChonHD));
dt = ThuvienWin.XemQuery("select * from mathang where ID = " + dgvMatHang_HoaDon.Rows[e.RowIndex].Cells[3].Value.ToString());
ThuvienWin.ThemSuaXoaQuery(String.Format("update mathang set Conlai = '{0}' where ID = {1}", int.Parse(dt.Rows[0]["Conlai"].ToString()) + int.Parse(dgvMatHang_HoaDon.Rows[e.RowIndex].Cells[5].Value.ToString()), dgvMatHang_HoaDon.Rows[e.RowIndex].Cells[3].Value.ToString()));
ThuvienWin.ThemSuaXoaQuery("delete from mathang_hoadon where ID = " + dgvMatHang_HoaDon.Rows[e.RowIndex].Cells[2].Value.ToString());
MessageBox.Show("Đã xóa thành công!", "Thông báo");
dgvMatHang_HoaDon.DataSource = ThuvienWin.XemQuery(String.Format(@"SELECT mathang_hoadon.ID, mathang_hoadon.Mamathang, mathang_hoadon.Mahoadon, mathang_hoadon.Soluongmathang, mathang.Mavach, mathang.Tenhang, mathang.Gia, mathang_hoadon.Thanhtien
FROM mathang INNER JOIN mathang_hoadon ON mathang.ID = mathang_hoadon.Mamathang
WHERE (((mathang_hoadon.Mahoadon)={0}));", MaChonHD));
cbThemMH_SelectedIndexChanged(sender, e);
cbSuaMH_SelectedIndexChanged(sender, e);
LayHoaDon();
TaoMaHD_MH();
tabControl1.SelectedTab = tabPage1;
}
}
else if (e.ColumnIndex == 1 && e.RowIndex != -1) // bấm nút sửa trên dgv
{
MaSuaMH_HD = dgvMatHang_HoaDon.Rows[e.RowIndex].Cells[2].Value.ToString();
cbSuaMH.SelectedValue = dgvMatHang_HoaDon.Rows[e.RowIndex].Cells[3].Value.ToString();
cbSuaMH_SelectedIndexChanged(sender, e);
txtSuaSL.Text = dgvMatHang_HoaDon.Rows[e.RowIndex].Cells[5].Value.ToString();
// dgvMatHang_HoaDon.DataSource = ThuvienWin.XemQuery(String.Format(@"SELECT mathang_hoadon.ID, mathang_hoadon.Mamathang, mathang_hoadon.Mahoadon, mathang_hoadon.soluongmathang, mathang.mavach, mathang.tenmathang, mathang.dongia
// FROM mathang INNER JOIN mathang_hoadon ON mathang.ID = mathang_hoadon.Mamathang
// WHERE (((mathang_hoadon.Mahoadon)={0}));", MaChonHD));
tabControl1.SelectedTab = tabPage2;
}
}
private void btnflp_Click(object sender, EventArgs e)
{
Button btn = (Button)sender;
switch (btn.Text)
{
case "Mặt hàng":
mathang mathang = new mathang();
mathang.ShowDialog();
break;
case "Thoát chương trình":
ThuvienWin.Thoat();
break;
case "Bán hàng":
banhang banhang = new banhang();
banhang.ShowDialog();
break;
//case "Danh sách hóa đơn":
// DSHoaDon DSHoaDon = new DSHoaDon();
// DSHoaDon.ShowDialog();
// break;
default:
MessageBox.Show("Chức năng này đang phát triển", "Thông báo");
break;
}
}
private void btnSua_Click(object sender, EventArgs e)
{
if (int.Parse(txtSuaSL.Text) > int.Parse(txtSuaCL.Text))
{
MessageBox.Show("Không được mua quá số lượng hàng còn lại!", "Thông báo");
return;
}
DataTable dt1 = ThuvienWin.XemQuery("select * from hoadon where ID = " + MaChonHD);
DataTable dt2 = ThuvienWin.XemQuery("select * from mathang_hoadon where ID = " + MaSuaMH_HD);
int SLold = int.Parse(dt2.Rows[0]["Soluongmathang"].ToString());
int SLnew = int.Parse(txtSuaSL.Text);
int tongtien = int.Parse(dt1.Rows[0]["Tongtien"].ToString());
if (SLnew > SLold)
{
tongtien = tongtien + ((SLnew - SLold) * int.Parse(txtSuaDG.Text));
DataTable dt = ThuvienWin.XemQuery("select * from mathang where ID = " + cbSuaMH.SelectedValue.ToString());
ThuvienWin.ThemSuaXoaQuery(String.Format("update mathang set Conlai = '{0}' where ID = {1}", int.Parse(dt.Rows[0]["Conlai"].ToString()) - (SLnew - SLold), cbSuaMH.SelectedValue.ToString()));
}
else
{
tongtien = tongtien - ((SLold - SLnew) * int.Parse(txtSuaDG.Text));
DataTable dt = ThuvienWin.XemQuery("select * from mathang where ID = " + cbSuaMH.SelectedValue.ToString());
ThuvienWin.ThemSuaXoaQuery(String.Format("update mathang set Conlai = '{0}' where ID = {1}", int.Parse(dt.Rows[0]["Conlai"].ToString()) + (SLold - SLnew), cbSuaMH.SelectedValue.ToString()));
}
ThuvienWin.ThemSuaXoaQuery(String.Format("update hoadon set Tongtien = '{0}' where ID = {1}", tongtien.ToString(), MaChonHD));
ThuvienWin.ThemSuaXoaQuery(String.Format("update mathang_hoadon set Soluongmathang = '{0}', Thanhtien = '{1}' where ID = {2}", SLnew, SLnew * int.Parse(txtSuaDG.Text), MaSuaMH_HD));
MessageBox.Show("Sửa thành công!", "Thông Báo"); dgvMatHang_HoaDon.DataSource = ThuvienWin.XemQuery(String.Format(@"SELECT mathang_hoadon.ID, mathang_hoadon.Mamathang, mathang_hoadon.Mahoadon, mathang_hoadon.Soluongmathang, mathang.Mavach, mathang.Tenhang, mathang.Gia, mathang_hoadon.Thanhtien
FROM mathang INNER JOIN mathang_hoadon ON mathang.ID = mathang_hoadon.Mamathang
WHERE (((mathang_hoadon.Mahoadon)={0}));", MaChonHD));
txtSuaSL.Text = "";
cbSuaMH_SelectedIndexChanged(sender, e);
LayHoaDon();
}
private void btnDangNhap_Click(object sender, EventArgs e)
{
String sql = String.Format("select * from taikhoan where tendangnhap = '{0}' and matkhau = '{1}'", txtTaiKhoan.Text, txtMatKhau.Text);
DataTable tb = new DataTable();
tb = ThuvienWin.XemQuery(sql);
if (tb.Rows.Count == 0)
{
MessageBox.Show("Tài Khoản hoặc Mật Khẩu sai", "Thông Báo");
return;
}
ThuvienWin.MaNguoiDung = int.Parse(tb.Rows[0]["ID"].ToString());
ThuvienWin.Quyen = int.Parse(tb.Rows[0]["Maquyen"].ToString());
sql = String.Format(@"SELECT chucnang.tenchucnang, chucnang.mota
FROM chucnang INNER JOIN quyen_chucnang ON chucnang.ID = quyen_chucnang.Machucnang
WHERE (((quyen_chucnang.Maquyen)={0}));", tb.Rows[0]["Maquyen"].ToString());
tb = ThuvienWin.XemQuery(sql);
for (int i = 0; i < tb.Rows.Count; i++)
{
ThuvienWin.ChucNangCuaNguoiDung += tb.Rows[i]["TenChucNang"].ToString();
}
this.Hide();
Menu Menu = new Menu();
Menu.ShowDialog();
}
private void cbThemMH_SelectedIndexChanged(object sender, EventArgs e)
{
DataTable dt = ThuvienWin.XemQuery(String.Format("select * from mathang where ID = {0}", cbThemMH.SelectedValue.ToString()));
txtThemMV.Text = dt.Rows[0]["Mavach"].ToString();
txtThemDG.Text = dt.Rows[0]["Gia"].ToString();
txtThemCL.Text = dt.Rows[0]["Conlai"].ToString();
}
private void LayMatHang()
{
String sql = "SELECT * FROM mathang";
DataTable dt = new DataTable();
dt = ThuvienWin.XemQuery(sql);
dgvMatHang.DataSource = dt;
}
private void LayHoaDon()
{
String sql = @"SELECT * from hoadon";
DataTable dt = new DataTable();
dt = ThuvienWin.XemQuery(sql);
dgvHoaDon.DataSource = dt;
}
private void btnTaoHD_Click(object sender, EventArgs e)
{
String sql = String.Format("insert into hoadon (ID,Tongtien,Ngaytao) values({0},'0','{1}')", MaHD, DateTime.Today.ToString());
ThuvienWin.ThemSuaXoaQuery(sql);
MessageBox.Show("Đã thêm thành công!", "Thông báo");
LayHoaDon();
TaoMaHoaDon();
}
private void btnSua_Click(object sender, EventArgs e)
{
if (ThuvienWin.confirm())
{
String sql = String.Format("update mathang set Mavach = '{0}', Tenhang = '{1}', Gia = {2}, Conlai = '{3}' where Id = {4}", txtSuaMV.Text, txtSuaTMH.Text, txtSuaGMH.Text, txtSuaSL.Text, MaSuaMH);
ThuvienWin.ThemSuaXoaQuery(sql);
MessageBox.Show("Sửa thành công!", "Thông Báo");
LayMatHang();
}
}
private void btnThem_Click(object sender, EventArgs e)
{
if (ThuvienWin.confirm())
{
String sql = String.Format("insert into mathang (ID,Mavach,Tenhang,Gia,Conlai) values({0},'{1}','{2}',{3},'{4}')", MaMH, txtThemMV.Text, txtThemTMH.Text, txtThemGMH.Text, txtThemSL.Text);
ThuvienWin.ThemSuaXoaQuery(sql);
MessageBox.Show("Đã thêm thành công!", "Thông báo");
TaoMaMatHang();
LayMatHang();
}
}
private void TaoMaHoaDon()
{
String sql = "SELECT Top 1 * FROM hoadon ORDER BY hoadon.ID DESC";
DataTable tb = new DataTable();
tb = ThuvienWin.XemQuery(sql);
if (tb.Rows.Count > 0)
{
MaHD = (int.Parse(tb.Rows[0]["Id"].ToString()) + 1).ToString();
}
else
{
MaHD = "1";
}
}
private void TaoMaMatHang()
{
String sql = "SELECT Top 1 * FROM mathang ORDER BY mathang.ID DESC";
DataTable tb = new DataTable();
tb = ThuvienWin.XemQuery(sql);
if (tb.Rows.Count > 0)
{
MaMH = (int.Parse(tb.Rows[0]["Id"].ToString()) + 1).ToString();
}
else
{
MaMH = "1";
}
}
private void layChucNang()
{
String sql = "select * from ChucNang";
DataTable dt = ThuvienWin.XemQuery(sql);
for (int i = 0; i < dt.Rows.Count; i++)
{
Button btn = new Button();
btn.Tag = dt.Rows[i]["TenChucNang"].ToString();
btn.Text = dt.Rows[i]["MoTa"].ToString();
btn.Height = 100;
btn.Width = 150;
btn.Click += btnflp_Click;
btn.Enabled = (ThuvienWin.ChucNangCuaNguoiDung.IndexOf(dt.Rows[i]["TenChucNang"].ToString()) > -1);
flpbutton.Controls.Add(btn);
}
}
private void LayMatHang()
{
String sql = "select * from mathang";
DataTable tb = new DataTable();
tb = ThuvienWin.XemQuery(sql);
cbThemMH.DataSource = tb;
cbThemMH.DisplayMember = "Tenhang";
cbThemMH.ValueMember = "ID";
cbThemMH.SelectedIndexChanged += cbThemMH_SelectedIndexChanged;
sql = "select * from mathang";
DataTable dt = new DataTable();
dt = ThuvienWin.XemQuery(sql);
cbSuaMH.DataSource = dt;
cbSuaMH.DisplayMember = "Tenhang";
cbSuaMH.ValueMember = "ID";
cbSuaMH.SelectedIndexChanged += cbSuaMH_SelectedIndexChanged;
}
private void btnThem_Click(object sender, EventArgs e)
{
if (int.Parse(txtThemSL.Text) > int.Parse(txtThemCL.Text))
{
MessageBox.Show("Không được mua quá số lượng hàng còn lại!", "Thông báo");
return;
}
DataTable dt = ThuvienWin.XemQuery("select * from hoadon where ID = " + MaChonHD);
int tongtien = int.Parse(dt.Rows[0]["Tongtien"].ToString()) + int.Parse(txtThemSL.Text) * int.Parse(txtThemDG.Text);
ThuvienWin.ThemSuaXoaQuery(String.Format("insert into mathang_hoadon(ID,Mamathang,Mahoadon,Soluongmathang,Thanhtien) values({0},{1},{2},'{3}','{4}')", MaMH_HD, cbThemMH.SelectedValue.ToString(), MaChonHD, txtThemSL.Text, int.Parse(txtThemDG.Text) * int.Parse(txtThemSL.Text)));
ThuvienWin.ThemSuaXoaQuery(String.Format("update hoadon set Tongtien = '{0}' where ID = {1}", tongtien, MaChonHD));
dt = ThuvienWin.XemQuery("select * from mathang where ID = " + cbThemMH.SelectedValue.ToString());
ThuvienWin.ThemSuaXoaQuery(String.Format("update mathang set Conlai = '{0}' where ID = {1}", int.Parse(dt.Rows[0]["Conlai"].ToString()) - int.Parse(txtThemSL.Text), cbThemMH.SelectedValue.ToString()));
MessageBox.Show("Đã thêm thành công!", "Thông báo");
dgvMatHang_HoaDon.DataSource = ThuvienWin.XemQuery(String.Format(@"SELECT mathang_hoadon.ID, mathang_hoadon.Mamathang, mathang_hoadon.Mahoadon, mathang_hoadon.Soluongmathang, mathang.Mavach, mathang.Tenhang, mathang.Gia, mathang_hoadon.Thanhtien
FROM mathang INNER JOIN mathang_hoadon ON mathang.ID = mathang_hoadon.Mamathang
WHERE (((mathang_hoadon.Mahoadon)={0}));", MaChonHD));
txtThemSL.Text = "";
cbThemMH_SelectedIndexChanged(sender, e);
LayHoaDon();
TaoMaHD_MH();
}
private void dgvHoaDon_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex == 0 && e.RowIndex != -1) // bấm nút xóa trên dgv
{
if (ThuvienWin.confirm())
{
ThuvienWin.ThemSuaXoaQuery("delete from hoadon where ID = " + dgvHoaDon.Rows[e.RowIndex].Cells[2].Value.ToString());
MessageBox.Show("Đã xóa thành công!", "Thông báo");
dgvMatHang_HoaDon.DataSource = ThuvienWin.XemQuery(String.Format(@"SELECT mathang_hoadon.ID, mathang_hoadon.Mamathang, mathang_hoadon.Mahoadon, mathang_hoadon.Soluongmathang, mathang.Mavach, mathang.Tenhang, mathang.Gia, mathang_hoadon.Thanhtien
FROM mathang INNER JOIN mathang_hoadon ON mathang.ID = mathang_hoadon.Mamathang
WHERE (((mathang_hoadon.Mahoadon)={0}));", dgvHoaDon.Rows[e.RowIndex].Cells[2].Value.ToString()));
LayHoaDon();
TaoMaHoaDon();
}
}
else if (e.ColumnIndex == 1 && e.RowIndex != -1) // bấm nút hiển thị trên dgv
{
MaChonHD = dgvHoaDon.Rows[e.RowIndex].Cells[2].Value.ToString();
dgvMatHang_HoaDon.DataSource = ThuvienWin.XemQuery(String.Format(@"SELECT mathang_hoadon.ID, mathang_hoadon.Mamathang, mathang_hoadon.Mahoadon, mathang_hoadon.Soluongmathang, mathang.Mavach, mathang.Tenhang, mathang.Gia, mathang_hoadon.Thanhtien
FROM mathang INNER JOIN mathang_hoadon ON mathang.ID = mathang_hoadon.Mamathang
WHERE (((mathang_hoadon.Mahoadon)={0}));", MaChonHD));
}
}
private void dgvMatHang_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex == 1 && e.RowIndex != -1) // bấm nút sửa trên dgv
{
MaSuaMH = dgvMatHang.Rows[e.RowIndex].Cells[2].Value.ToString();
txtSuaMV.Text = dgvMatHang.Rows[e.RowIndex].Cells[3].Value.ToString();
txtSuaTMH.Text = dgvMatHang.Rows[e.RowIndex].Cells[4].Value.ToString();
txtSuaGMH.Text = dgvMatHang.Rows[e.RowIndex].Cells[6].Value.ToString();
txtSuaSL.Text = dgvMatHang.Rows[e.RowIndex].Cells[5].Value.ToString();
tabControl1.SelectedTab = tabPage2;
}
else if (e.ColumnIndex == 0 && e.RowIndex != -1) // bấm nút xóa trên dgv
{
if (ThuvienWin.confirm())
{
String sql = String.Format("delete from mathang where ID = {0}", dgvMatHang.Rows[e.RowIndex].Cells[2].Value.ToString());
ThuvienWin.ThemSuaXoaQuery(sql);
MessageBox.Show("Xóa Thành Công!", "Thông Báo");
TaoMaMatHang();
LayMatHang();
tabControl1.SelectedTab = tabPage1;
}
}
}
private void btnThoat_Click(object sender, EventArgs e)
{
ThuvienWin.Thoat();
}
