private void DataGridView_DuaMon() { myDataBases db = new myDataBases(); dgvDuaMon.DataSource = db.getData("select distinct MaBanAn from tblGoiMon1 where XacNhan = N'Xong'"); dgvHuyMon.DataSource = db.getData("select distinct MaBanAn, TenThucDon from tblGoiMon1 join tblThucDon on tblGoiMon1.MaThucDon=tblThucDon.MaThucDon where XacNhan = N'Hủy'"); }
private void BtnSave_Click(object sender, EventArgs e) { try { myDataBases db = new myDataBases(); if (kt == "Them") { db.executeQuery("insert into tblNCC values (dbo.sinhmaNCC(),N'" + textTenNCC.Text + "',N'" + textDiaChi.Text + "','" + textSDT.Text + "',N'" + textEmail.Text + "')"); MessageBox.Show("Thêm nhà cung cấp thành công!"); } if (kt == "Sua") { db.executeQuery("update tblNCC set TenNCC=N'" + textTenNCC.Text + "' where MaNCC='" + MaNCC1 + "'"); db.executeQuery("update tblNCC set DiaChi=N'" + textDiaChi.Text + "' where MaNCC='" + MaNCC1 + "'"); db.executeQuery("update tblNCC set SDT='" + textSDT.Text + "' where MaNCC='" + MaNCC1 + "'"); db.executeQuery("update tblNCC set Email=N'" + textEmail.Text + "' where MaNCC='" + MaNCC1 + "'"); MessageBox.Show("Sửa nhà cung cấp thành công!"); } setControls(true); refreshDataGridView(); } catch (Exception) { MessageBox.Show("Lỗi! Không thành công!"); } }
private void BtnThanhToan_Click(object sender, EventArgs e) { try { myDataBases db = new myDataBases(); string date = DateTime.Now.Year + "-" + (DateTime.Now.Month < 10 ? "0" + DateTime.Now.Month.ToString() : DateTime.Now.Month.ToString()) + "-" + (DateTime.Now.Day < 10 ? "0" + DateTime.Now.Day.ToString() : DateTime.Now.Day.ToString()); db.executeQuery("insert into tblHoaDon values (dbo.sinhmaHD()," + lbBanSo.Text + ",'" + date + " " + lblTime.Text + "'," + lbSoKhach.Text + ",'" + formLogin.MaNguoiDung + "'," + formGoiMon.TongTien + ")"); DataTable dt = db.getData("select tblGoiMon1.MaThucDon, SoLuong from tblGoiMon1 join tblThucDon on tblGoiMon1.MaThucDon=tblThucDon.MaThucDon where MaBanAn=" + lbBanSo.Text + " and XacNhan!=N'Hủy'"); if (dt != null) { foreach (DataRow dr in dt.Rows) { db.executeQuery("insert into tblCTHD values (dbo.sinhmaCTHD(),'" + dr["MaThucDon"].ToString() + "'," + dr["SoLuong"].ToString() + ")"); } } db.executeQuery("delete from tblGoiMon1 where MaBanAn=" + lbBanSo.Text); MessageBox.Show("Đã lưu!"); } catch (Exception) { MessageBox.Show("Lỗi!"); } }
private void BtnHuy_Click(object sender, EventArgs e) { myDataBases db = new myDataBases(); db.executeQuery("update tblYeuCauNL set XacNhan=N'Hủy' where MaNL='" + maNL + "'"); refreshDataGridView(); }
private void BtnSave_Click(object sender, EventArgs e) { try { myDataBases db = new myDataBases(); if (kt == "Them") { db.executeQuery("INSERT INTO tblThucDon values(dbo.sinhmaTD(), N'" + cbLoaiThucDon.Text + "', N'" + textTenThucDon.Text + "', N'" + textDonViTinh.Text + "'," + textDonGia.Text + ")"); MessageBox.Show("Thêm thực đơn thành công!"); } if (kt == "Sua") { db.executeQuery("update tblThucDon set Loai =N'" + cbLoaiThucDon.Text + "' where MaThucDon = '" + MaTD + "'"); db.executeQuery("update tblThucDon set TenThucDon =N'" + textTenThucDon.Text + "' where MaThucDon = '" + MaTD + "'"); db.executeQuery("update tblThucDon set DonViTinh =N'" + textDonViTinh.Text + "' where MaThucDon = '" + MaTD + "'"); db.executeQuery("update tblThucDon set DonGia =" + textDonGia.Text + "where MaThucDon = '" + MaTD + "'"); MessageBox.Show("Sửa thực đơn thành công!"); } setControls(true); refreshDataGridView(); } catch (Exception) { MessageBox.Show("Lỗi! Không thành công!"); } }
private void BtnTheoNgay_Click(object sender, EventArgs e) { myDataBases db = new myDataBases(); DateTime dateTime = dateNgay.DateTime; dgvHoaDon.DataSource = db.getData("select * from tblHoaDon where CONVERT(nvarchar(10), ThoiGianLap, 121)='" + dateTime.Year.ToString() + "-" + dateTime.Month.ToString() + "-" + dateTime.Day.ToString() + "'"); DataTable dt = db.getData("select TenThucDon, SUM(SoLuong) from tblThucDon join tblCTHD on tblThucDon.MaThucDon = tblCTHD.MaThucDon join tblHoaDon on tblHoaDon.SoHD = tblCTHD.SoHD where CONVERT(nvarchar(10), ThoiGianLap, 121)='" + dateTime.Year.ToString() + "-" + dateTime.Month.ToString() + "-" + dateTime.Day.ToString() + "' group by tblCTHD.MaThucDon, TenThucDon having SUM(SoLuong) >=all (select SUM(SoLuong) from tblCTHD join tblHoaDon on tblHoaDon.SoHD = tblCTHD.SoHD where CONVERT(nvarchar(10), ThoiGianLap, 121)='" + dateTime.Year.ToString() + "-" + dateTime.Month.ToString() + "-" + dateTime.Day.ToString() + "' group by MaThucDon)"); if (dt != null) { foreach (DataRow dr in dt.Rows) { lbMaxTD.Text = dr["TenThucDon"].ToString(); } } DataTable dt1 = db.getData("select SUM(TongTien) as TongTien, SUM(SoKhach) as TongKhach from tblHoaDon where CONVERT(nvarchar(10), ThoiGianLap, 121)='" + dateTime.Year.ToString() + "-" + dateTime.Month.ToString() + "-" + dateTime.Day.ToString() + "'"); if (dt1 != null) { foreach (DataRow dr in dt1.Rows) { lbTongKhach.Text = dr["TongKhach"].ToString() + "khách"; lbTongTien.Text = dr["TongTien"].ToString() + " VNĐ"; } } }
private void BtnTheoKhoang_Click(object sender, EventArgs e) { myDataBases db = new myDataBases(); DateTime dateTime1 = dateTu.DateTime, dateTime2 = dateDen.DateTime; dgvHoaDon.DataSource = db.getData("select * from tblHoaDon where ThoiGianLap >='" + dateTime1.Year.ToString() + "-" + dateTime1.Month.ToString() + "-" + dateTime1.Day.ToString() + " 00:00:00' and ThoiGianLap <='" + dateTime2.Year.ToString() + "-" + dateTime2.Month.ToString() + "-" + dateTime2.Day.ToString() + " 23:59:59'"); DataTable dt = db.getData("select TenThucDon, SUM(SoLuong) from tblThucDon join tblCTHD on tblThucDon.MaThucDon = tblCTHD.MaThucDon join tblHoaDon on tblHoaDon.SoHD = tblCTHD.SoHD where ThoiGianLap >='" + dateTime1.Year.ToString() + "-" + dateTime1.Month.ToString() + "-" + dateTime1.Day.ToString() + " 00:00:00' and ThoiGianLap <='" + dateTime2.Year.ToString() + "-" + dateTime2.Month.ToString() + "-" + dateTime2.Day.ToString() + " 23:59:59' group by tblCTHD.MaThucDon, TenThucDon having SUM(SoLuong) >=all (select SUM(SoLuong) from tblCTHD join tblHoaDon on tblHoaDon.SoHD = tblCTHD.SoHD where ThoiGianLap >='" + dateTime1.Year.ToString() + "-" + dateTime1.Month.ToString() + "-" + dateTime1.Day.ToString() + " 00:00:00' and ThoiGianLap <='" + dateTime2.Year.ToString() + "-" + dateTime2.Month.ToString() + "-" + dateTime2.Day.ToString() + " 23:59:59' group by MaThucDon)"); if (dt != null) { foreach (DataRow dr in dt.Rows) { lbMaxTD.Text = dr["TenThucDon"].ToString(); } } DataTable dt1 = db.getData("select SUM(TongTien) as TongTien, SUM(SoKhach) as TongKhach from tblHoaDon where ThoiGianLap >='" + dateTime1.Year.ToString() + "-" + dateTime1.Month.ToString() + "-" + dateTime1.Day.ToString() + " 00:00:00' and ThoiGianLap <='" + dateTime2.Year.ToString() + "-" + dateTime2.Month.ToString() + "-" + dateTime2.Day.ToString() + " 23:59:59'"); if (dt1 != null) { foreach (DataRow dr in dt1.Rows) { lbTongKhach.Text = dr["TongKhach"].ToString() + " khách"; lbTongTien.Text = dr["TongTien"].ToString() + " VNĐ"; } } }
private void FormHoaDon_Load(object sender, EventArgs e) { refreshDataGridView(); for (int i = 0; i < 9; i++) { cbThang.Items.Add("0" + (i + 1).ToString()); } for (int i = 9; i < 12; i++) { cbThang.Items.Add((i + 1).ToString()); } myDataBases db = new myDataBases(); DataTable dt = db.getData("select TenThucDon, SUM(SoLuong) from tblThucDon join tblCTHD on tblThucDon.MaThucDon = tblCTHD.MaThucDon group by tblCTHD.MaThucDon, TenThucDon having SUM(SoLuong) >=all (select SUM(SoLuong) from tblCTHD group by MaThucDon)"); if (dt != null) { foreach (DataRow dr in dt.Rows) { lbMaxTD.Text = dr["TenThucDon"].ToString(); } } DataTable dt1 = db.getData("select SUM(TongTien) as TongTien, SUM(SoKhach) as TongKhach from tblHoaDon"); if (dt1 != null) { foreach (DataRow dr in dt1.Rows) { lbTongKhach.Text = dr["TongKhach"].ToString() + " khách"; lbTongTien.Text = dr["TongTien"].ToString() + " VNĐ"; } } }
private void BtnSave_Click(object sender, EventArgs e) { try { myDataBases db = new myDataBases(); if (kt == "Them") { db.executeQuery("insert into tblNguyenLieu values (dbo.sinhmaNL(),N'" + textTenNL.Text + "','" + cbMaNCC.Text + "'," + textSoLuong.Text + ",'" + formLogin.MaNguoiDung + "',N'" + textDonViTinh.Text + "'," + textDonGia.Text + ")"); MessageBox.Show("Thêm nguyên liệu thành công!"); } if (kt == "Sua") { db.executeQuery("update tblNguyenLieu set TenNL = N'" + textTenNL.Text + "' where MaNL='" + MaNL + "'"); db.executeQuery("update tblNguyenLieu set MaNCC = '" + cbMaNCC.Text + "' where MaNL='" + MaNL + "'"); db.executeQuery("update tblNguyenLieu set MaNVNhap = '" + formLogin.MaNguoiDung + "' where MaNL='" + MaNL + "'"); db.executeQuery("update tblNguyenLieu set SoLuong = " + textSoLuong.Text + " where MaNL='" + MaNL + "'"); db.executeQuery("update tblNguyenLieu set DonViTinh = N'" + textDonViTinh.Text + "' where MaNL='" + MaNL + "'"); db.executeQuery("update tblNguyenLieu set DonGia = " + textDonGia.Text + " where MaNL='" + MaNL + "'"); MessageBox.Show("Sửa nguyên liệu thành công!"); } setControls(true); refreshDataGridView(); } catch (Exception) { MessageBox.Show("Lỗi! Không thành công!"); } }
private string getID(string tendangnhap, string matkhau) { string id = ""; try { myDataBases db = new myDataBases(); DataTable dt = new DataTable(); dt = db.getData("SELECT * FROM tblNguoiDung WHERE TenDangNhap = '" + tendangnhap + "' AND MatKhau = '" + matkhau + "'"); if (dt != null) { foreach (DataRow dr in dt.Rows) { id = dr["MaNguoiDung"].ToString(); hoten = dr["HoTen"].ToString(); quyen = dr["Quyen"].ToString(); } } } catch (Exception) { MessageBox.Show("Lỗi xảy ra khi truy vấn dữ liệu hoặc kết nối với server thất bại !"); } return(id); }
private void BtnAll_Click(object sender, EventArgs e) { myDataBases db = new myDataBases(); db.executeQuery("update tblYC_MuaNL set XacNhan=N'Chấp Nhận'"); refreshDataGridView(); }
private void BtnTuChoi_Click(object sender, EventArgs e) { myDataBases db = new myDataBases(); db.executeQuery("delete from tblYC_MuaNL where MaNL='" + MaNL + "'"); refreshDataGridView(); }
private void CbChonBan_SelectedIndexChanged(object sender, EventArgs e) { lvThucDon.Clear(); lvThucDon.Columns.Add("Thực Đơn", 175); lvThucDon.Columns.Add("Đơn Giá", 120); lvThucDon.Columns.Add("Số Lượng", 90); lvThucDon.Columns.Add("Xác Nhận", 100); myDataBases db = new myDataBases(); DataTable dt = db.getData("select TenThucDon, DonGia, SoLuong, XacNhan from tblGoiMon1 join tblThucDon on tblGoiMon1.MaThucDon=tblThucDon.MaThucDon where MaBanAn=" + cbChonBan.Text); n = dt.Rows.Count; int dem = 0; double tongtien = 0; if (dt != null) { foreach (DataRow dr in dt.Rows) { lvThucDon.Items.Add(dr["TenThucDon"].ToString()); lvThucDon.Items[dem].SubItems.Add(dr["DonGia"].ToString()); lvThucDon.Items[dem].SubItems.Add(dr["SoLuong"].ToString()); lvThucDon.Items[dem].SubItems.Add(dr["XacNhan"].ToString()); if (dr["XacNhan"].ToString() != "Hủy") { tongtien += double.Parse(dr["DonGia"].ToString()) * double.Parse(dr["SoLuong"].ToString()); } dem++; } } lbTongTien.Text = tongtien.ToString(); DataGridView_DuaMon(); }
private void ViewHoaDon_Load(object sender, EventArgs e) { if ((formLogin.quyen == "Giám Đốc") || (formLogin.quyen == "Bồi Bàn")) { btnThanhToan.Visible = true; } lblTime.Text = (DateTime.Now.Hour < 10 ? "0" + DateTime.Now.Hour.ToString() : DateTime.Now.Hour.ToString()) + ":" + (DateTime.Now.Minute < 10 ? "0" + DateTime.Now.Minute.ToString() : DateTime.Now.Minute.ToString()) + ":" + (DateTime.Now.Second < 10 ? "0" + DateTime.Now.Second.ToString() : DateTime.Now.Second.ToString()); lblDate.Text = (DateTime.Now.Day < 10 ? "0" + DateTime.Now.Day.ToString() : DateTime.Now.Day.ToString()) + "-" + (DateTime.Now.Month < 10 ? "0" + DateTime.Now.Month.ToString() : DateTime.Now.Month.ToString()) + "-" + DateTime.Now.Year; lbhoten.Text = formLogin.hoten; lbBanSo.Text = formGoiMon.SoBan; lbSoKhach.Text = formGoiMon.SoKhach; lbTongTien.Text = formGoiMon.TongTien + "VNĐ"; try { myDataBases db = new myDataBases(); dgvMonAn.DataSource = db.getData("select TenThucDon, DonGia, SoLuong from tblGoiMon1 join tblThucDon on tblGoiMon1.MaThucDon=tblThucDon.MaThucDon where MaBanAn=" + lbBanSo.Text + " and XacNhan!=N'Hủy'"); for (int i = 0; i < dgvMonAn.Rows.Count - 1; i++) { dgvMonAn.Rows[i].Cells[0].Value = (i + 1).ToString(); } } catch (Exception) { MessageBox.Show("Chưa chọn bàn!"); } }
private void refreshDataGridView() { myDataBases db = new myDataBases(); dgvCheBien.DataSource = db.getData("select TenThucDon, SoLuong, XacNhan, tblGoiMon1.MaThucDon from tblGoiMon1 join tblThucDon on tblGoiMon1.MaThucDon=tblThucDon.MaThucDon where MaBanAn=" + cbChonBan.Text); dgvNLHuy.DataSource = db.getData("select TenNL from tblYeuCauNL join tblNguyenLieu on tblYeuCauNL.MaNL=tblNguyenLieu.MaNL where XacNhan=N'Hủy' group by tblYeuCauNL.MaNL, TenNL"); }
private void refreshDataGridView() { myDataBases db = new myDataBases(); dgvYeuCauNL.DataSource = db.getData("select tblYeuCauNL.MaNL, TenNL, SUM(tblYeuCauNL.SoLuong) as SoLuong, DonGia, DonViTinh, XacNhan from tblYeuCauNL join tblNguyenLieu on tblYeuCauNL.MaNL = tblNguyenLieu.MaNL group by tblYeuCauNL.MaNL, tblYeuCauNL.MaNL, TenNL, DonGia, DonViTinh, XacNhan"); dgvNguyenLieu.DataSource = db.getData("select TenNL, TenNCC, SoLuong, HoTen, DonViTinh, DonGia, MaNL, tblNguyenLieu.MaNCC from tblNguyenLieu join tblNCC on tblNguyenLieu.MaNCC=tblNCC.MaNCC join tblNguoiDung on tblNguoiDung.MaNguoiDung=tblNguyenLieu.MaNVNhap"); dgvYeuCauMua.DataSource = db.getData("select tblYC_MuaNL.MaNL, TenNL, SUM(tblYC_MuaNL.SoLuong) as SoLuong, DonGia, DonViTinh, XacNhan from tblYC_MuaNL join tblNguyenLieu on tblYC_MuaNL.MaNL = tblNguyenLieu.MaNL where XacNhan=N'Chấp Nhận' group by tblYC_MuaNL.MaNL, tblYC_MuaNL.MaNL, TenNL, DonGia, DonViTinh, XacNhan"); }
private void BtnXacNhan_Click(object sender, EventArgs e) { MaNL = dgvThanhToan.Rows[row].Cells[0].Value.ToString(); myDataBases db = new myDataBases(); db.executeQuery("update tblNhapNL set XacNhan=N'Đã Thanh Toán' where MaNL='" + MaNL + "'"); MessageBox.Show("Đã xác nhận nhập nguyên liệu thành công!"); refreshDataGridView(); row = 0; }
private void BtnXoa_Click(object sender, EventArgs e) { DialogResult h = MessageBox.Show("Bạn có chắc muốn xóa thực đơn không?", "Thông báo", MessageBoxButtons.OKCancel); if (h == DialogResult.OK) { myDataBases db = new myDataBases(); db.executeQuery("delete from tblThucDon where MaThucDon='" + MaTD + "'"); refreshDataGridView(); } }
private void BtnXuat_Click(object sender, EventArgs e) { maNL = dgvYeuCauNL.Rows[dgvrowNL].Cells[0].Value.ToString(); myDataBases db = new myDataBases(); db.executeQuery("insert into tblXuatNL values ('" + maNL + "','" + DateTime.Now.Year.ToString() + "-" + DateTime.Now.Month.ToString() + "-" + DateTime.Now.Day.ToString() + "'," + textSoLuong.Text + ")"); db.executeQuery("update tblNguyenLieu set SoLuong=SoLuong-" + textSoLuong.Text + " where MaNL='" + maNL + "'"); db.executeQuery("delete from tblYeuCauNL where MaNL='" + maNL + "'"); refreshDataGridView(); MessageBox.Show("Xuất nguyên liệu thành công!"); dgvrowNL = 0; }
private void BtnXacNhan_Click(object sender, EventArgs e) { maNL_Nhap = dgvYeuCauMua.Rows[rowNhapNL].Cells[0].Value.ToString(); myDataBases db = new myDataBases(); db.executeQuery("insert into tblNhapNL values ('" + maNL_Nhap + "','" + DateTime.Now.Year.ToString() + "-" + DateTime.Now.Month.ToString() + "-" + DateTime.Now.Day.ToString() + "'," + dgvYeuCauMua.Rows[rowNhapNL].Cells[2].Value.ToString() + ", N'Đã Nhận, Chưa Thanh Toán Tiền')"); db.executeQuery("update tblNguyenLieu set SoLuong=SoLuong+" + dgvYeuCauMua.Rows[rowNhapNL].Cells[2].Value.ToString() + " where MaNL='" + maNL_Nhap + "'"); db.executeQuery("delete from tblYC_MuaNL where MaNL='" + maNL_Nhap + "'"); MessageBox.Show("Đã xác nhận nhập nguyên liệu thành công!"); refreshDataGridView(); rowNhapNL = 0; }
private void BtnSave_Click(object sender, EventArgs e) { try { myDataBases db = new myDataBases(); if (kt == "Them") { if (rbNam.Checked == true) { db.executeQuery("insert into tblNguoiDung values (dbo.sinhmaND(),N'" + textHoTen.Text + "','" + dateNgaySinh.Text + "',N'Nam',N'" + textQueQuan.Text + "','" + textSDT.Text + "','" + textTenDangNhap.Text + "','" + textMatKhau.Text + "',N'" + cbQuyen.Text + "')"); } if (rbNu.Checked == true) { db.executeQuery("insert into tblNguoiDung values (dbo.sinhmaND(),N'" + textHoTen.Text + "','" + dateNgaySinh.Text + "',N'Nữ',N'" + textQueQuan.Text + "','" + textSDT.Text + "','" + textTenDangNhap.Text + "','" + textMatKhau.Text + "',N'" + cbQuyen.Text + "')"); } if ((rbNam.Checked == false) && (rbNu.Checked == false)) { db.executeQuery("insert into tblNguoiDung values (dbo.sinhmaND(),N'" + textHoTen.Text + "','" + dateNgaySinh.Text + "',N'',N'" + textQueQuan.Text + "','" + textSDT.Text + "','" + textTenDangNhap.Text + "','" + textMatKhau.Text + "',N'" + cbQuyen.Text + "')"); } MessageBox.Show("Thêm nhân viên thành công!"); } if (kt == "Sua") { db.executeQuery("update tblNguoiDung set HoTen = N'" + textHoTen.Text + "' where MaNguoiDung='" + MaND + "'"); db.executeQuery("update tblNguoiDung set NgaySinh = N'" + dateNgaySinh.Text + "' where MaNguoiDung='" + MaND + "'"); if (rbNam.Checked == true) { db.executeQuery("update tblNguoiDung set GioiTinh = N'Nam' where MaNguoiDung='" + MaND + "'"); } if (rbNu.Checked == true) { db.executeQuery("update tblNguoiDung set GioiTinh = N'Nữ' where MaNguoiDung='" + MaND + "'"); } if ((rbNam.Checked == false) && (rbNu.Checked == false)) { db.executeQuery("update tblNguoiDung set GioiTinh = N'' where MaNguoiDung='" + MaND + "'"); } db.executeQuery("update tblNguoiDung set QueQuan = N'" + textQueQuan.Text + "' where MaNguoiDung='" + MaND + "'"); db.executeQuery("update tblNguoiDung set SDT = N'" + textSDT.Text + "' where MaNguoiDung='" + MaND + "'"); db.executeQuery("update tblNguoiDung set TenDangNhap = N'" + textTenDangNhap.Text + "' where MaNguoiDung='" + MaND + "'"); db.executeQuery("update tblNguoiDung set MatKhau = N'" + textMatKhau.Text + "' where MaNguoiDung='" + MaND + "'"); db.executeQuery("update tblNguoiDung set Quyen = N'" + cbQuyen.Text + "' where MaNguoiDung='" + MaND + "'"); MessageBox.Show("Sửa nhân viên thành công!"); } setControls(true); refreshDataGridView(); } catch (Exception) { MessageBox.Show("Lỗi! Không thành công!"); } }
private void BtnYeuCau_Click(object sender, EventArgs e) { try { myDataBases db = new myDataBases(); db.executeQuery("insert into tblYC_MuaNL values ('" + dgvNguyenLieu.Rows[dgvrow].Cells[6].Value.ToString() + "'," + textSoLuong1.Text + ",N'Chưa')"); MessageBox.Show("Yêu cầu thành công!"); } catch (Exception) { MessageBox.Show("Lỗi! Không thành công!"); } }
private void FormCheBien_Load(object sender, EventArgs e) { myDataBases db = new myDataBases(); dgvNguyenLieu.DataSource = db.getData("select TenNL, TenNCC, SoLuong, HoTen, DonViTinh, DonGia, MaNL, tblNguyenLieu.MaNCC from tblNguyenLieu join tblNCC on tblNguyenLieu.MaNCC=tblNCC.MaNCC join tblNguoiDung on tblNguoiDung.MaNguoiDung=tblNguyenLieu.MaNVNhap"); dgvNLHuy.DataSource = db.getData("select TenNL from tblYeuCauNL join tblNguyenLieu on tblYeuCauNL.MaNL=tblNguyenLieu.MaNL where XacNhan=N'Hủy' group by tblYeuCauNL.MaNL, TenNL"); DataTable dt = db.getData("select distinct MaBanAn from tblGoiMon1"); foreach (DataRow dr in dt.Rows) { cbChonBan.Items.Add(dr["MaBanAn"].ToString()); } }
private void DgvNguyenLieu_CellClick(object sender, DataGridViewCellEventArgs e) { dgvrowNL = e.RowIndex; if (dgvrowNL >= 0) { textTenNL.Text = dgvNguyenLieu.Rows[dgvrowNL].Cells[0].Value.ToString(); textSoLuong.Text = dgvNguyenLieu.Rows[dgvrowNL].Cells[2].Value.ToString(); sl = int.Parse(textSoLuong.Text); } myDataBases db = new myDataBases(); dgvNLHuy.DataSource = db.getData("select TenNL from tblYeuCauNL join tblNguyenLieu on tblYeuCauNL.MaNL=tblNguyenLieu.MaNL where XacNhan=N'Hủy'"); }
private void CbLoaiThucDon_SelectedIndexChanged(object sender, EventArgs e) { myDataBases db = new myDataBases(); if (cbLoaiThucDon.Text == "==Tất Cả==") { dgvThucDon.DataSource = db.getData("SELECT * FROM tblThucDon"); } else { dgvThucDon.DataSource = db.getData("SELECT * FROM tblThucDon where Loai=N'" + cbLoaiThucDon.Text + "'"); } }
private void BtnTim_Click(object sender, EventArgs e) { myDataBases db = new myDataBases(); if (cbTim_LoaiThucDon.Text == "==Tất Cả==") { dgvThucDon.DataSource = db.getData("select * from tblThucDon where TenThucDon like N'%" + textTim_TenThucDon.Text + "%'"); } else { dgvThucDon.DataSource = db.getData("select * from tblThucDon where TenThucDon like N'%" + textTim_TenThucDon.Text + "%' and Loai=N'" + cbTim_LoaiThucDon.Text + "'"); } }
private void BtnXong_Click(object sender, EventArgs e) { try { myDataBases db = new myDataBases(); db.executeQuery("update tblGoiMon1 set XacNhan=N'Xong' where MaBanAn=" + cbChonBan.Text + "and XacNhan != N'Hủy'"); refreshDataGridView(); MessageBox.Show("Xác nhận thành công!"); } catch (Exception) { MessageBox.Show("Chưa chọn bàn!"); } }
private void BtnHuyMon_Click(object sender, EventArgs e) { try { myDataBases db = new myDataBases(); db.executeQuery("update tblGoiMon1 set XacNhan=N'Hủy' where MaBanAn=" + cbChonBan.Text + " and MaThucDon='" + dgvCheBien.Rows[dgvrow].Cells[3].Value.ToString() + "'"); refreshDataGridView(); MessageBox.Show("Hủy món thành công!"); } catch (Exception) { MessageBox.Show("Chưa chọn bàn!"); } }
private void FormNguyenLieu_Load(object sender, EventArgs e) { refreshDataGridView(); if (formLogin.quyen.ToString() == "Giám Đốc") { btnSave.Visible = true; btnCancel.Visible = true; grXuLy.Visible = true; } myDataBases db = new myDataBases(); DataTable dt = db.getData("select distinct MaNCC from tblNCC"); foreach (DataRow dr in dt.Rows) { cbMaNCC.Items.Add(dr["MaNCC"].ToString()); } }
private void DgvHoaDon_CellClick(object sender, DataGridViewCellEventArgs e) { int numrow; numrow = e.RowIndex; if (numrow >= 0) { myDataBases db = new myDataBases(); dgvCTHD.DataSource = db.getData("select tblCTHD.*, TenThucDon, DonGia from tblCTHD join tblThucDon on tblCTHD.MaThucDon=tblThucDon.MaThucDon where SoHD='" + dgvHoaDon.Rows[numrow].Cells[0].Value.ToString() + "'"); dtExcel = db.getData("select tblCTHD.*, TenThucDon, DonGia from tblCTHD join tblThucDon on tblCTHD.MaThucDon=tblThucDon.MaThucDon where SoHD='" + dgvHoaDon.Rows[numrow].Cells[0].Value.ToString() + "'"); ngaylp = dgvHoaDon.Rows[numrow].Cells[2].Value.ToString(); nguoilp = dgvHoaDon.Rows[numrow].Cells[4].Value.ToString(); banso = dgvHoaDon.Rows[numrow].Cells[1].Value.ToString();; sokhach = dgvHoaDon.Rows[numrow].Cells[3].Value.ToString(); tongtien = dgvHoaDon.Rows[numrow].Cells[5].Value.ToString(); } }