private void lbDHC_Click(object sender, EventArgs e) { string DHC_Ma = lbDHC.SelectedValue.ToString(); dgvdsTD2.DataSource = XuLyDuLieu.docBang("Select MDC_Loai,MDC_TenMon,MDC_SoLuong,MDC_Gia from MonDaChon,dsDonHangCho where (DHC_Ma=MDC_Ma and MDC_Ma='" + DHC_Ma + "')"); //dgvdsMonAn.DataSource = XuLyDuLieu.docBang("Select MDC_Loai,MDC_TenMon,MDC_SoLuong,MDC_Gia from HoaDon,MonDaChon where (HD_MaHD=MDC_Ma and HD_MaHD='" + HD_MaHD + "')"); }
private void lbdsMaHD_Click(object sender, EventArgs e) { string HD_MaHD = lbdsMaHD.SelectedValue.ToString(); dgvdsDSHonHang.DataSource = XuLyDuLieu.docBang("Select * from HoaDon where (HD_MaHD='" + HD_MaHD + "')"); dgvdsMonAn.DataSource = XuLyDuLieu.docBang("Select MDC_Loai,MDC_TenMon,MDC_SoLuong,MDC_Gia from HoaDon,MonDaChon where (HD_MaMDC=MDC_Ma and HD_MaHD='" + HD_MaHD + "')"); }
private void QuanLyDatHang_Load(object sender, EventArgs e) { lbdsMaHD.DataSource = XuLyDuLieu.docBang("Select * from HoaDon"); //lbdsMaHD.DataSource = dsChiNhanh; lbdsMaHD.DisplayMember = "HD_MaMDC"; lbdsMaHD.ValueMember = "HD_MaHD"; lbDHC.DataSource = XuLyDuLieu.docBang("Select *from dsDonHangCho"); lbDHC.DisplayMember = "DHC_Ma"; lbDHC.ValueMember = "DHC_MaTD"; /*dsDonHang = XuLyDuLieu.docBang("Select * from ThongTinHoaDon"); * dsDonHangView = new DataView(dsDonHang); * dgvdsDSHonHang.DataSource = dsDonHangView;*/ //dsMonAn = XuLyDuLieu.docBang("Select * from dsMon"); //dsMonAnView = new DataView(dsMonAn); //dgvdsMonAn.DataSource = dsMonAnView; //dsChiNhanh = XuLyDuLieu.docBang("Select * from CHINHANH"); //dsChiNhanhView = new DataView(dsChiNhanh); //dgvdsChiNhanh.DataSource = dsChiNhanhView; dsKhach = XuLyDuLieu.docBang("Select * from ThongTinKhach"); dsKhachView = new DataView(dsKhach); dgvdsKhachHang.DataSource = dsKhachView; dgvdsKhach2.DataSource = dsKhachView; Bingding(); dsMonAn = XuLyDuLieu.docBang("Select * from dsMon"); dsMonAnView = new DataView(dsMonAn); dgvThucDon.DataSource = dsMonAnView; dsMonChon = XuLyDuLieu.docBang("Select *from MonDaChon"); dgvCacMonChon.DataSource = dsMonChon; dsDonHang = XuLyDuLieu.docBang("Select *from HoaDon"); dgvdsDonHang2.DataSource = dsDonHang; dgvdsDonHang3.DataSource = dsDonHang; dgvdsDonHang5.DataSource = dsDonHang; dsDonHangChoDuyet = XuLyDuLieu.docBang("Select HD_MaHD,HD_MaCN,HD_DiaCHi from HoaDon"); dgvdsDonHang4.DataSource = dsDonHangChoDuyet; dsChiNhanh = XuLyDuLieu.docBang("Select *from dsChiNhanh"); dgvdsChiNhanh2.DataSource = dsChiNhanh; BindingDHC(); /*int sum = 0; * for (int i = 0; i < lvCMDC.Rows.Count; i++) * { * sum += Convert.ToInt32(lvCMDC.Rows[i].Cells[3].Value); * } * textBox1.Text = sum.ToString();*/ }
private void bt_xoaThongtin_Click(object sender, EventArgs e) { if (dgvdsKhach2.SelectedRows.Count > 0) { DataRow dh = ((DataRowView)dgvdsKhach2.SelectedRows[0].DataBoundItem).Row; dh.Delete(); XuLyDuLieu.ghiBang("ThongTinKhach", dsKhach); } }
private void bt_themThongtin_Click(object sender, EventArgs e) { DataRow dh = dsKhach.NewRow(); dh["HoTenKhach"] = TT_Ten.Text; dh["DiaCHi"] = TT_DiaChi.Text; dh["SDT"] = TT_SDT.Text; dh["SoLanDat"] = TT_SoLan.Text; dsKhach.Rows.Add(dh); XuLyDuLieu.ghiBang("ThongTinKhach", dsKhach); }
private void dsMonan_Load(object sender, EventArgs e) { ds = DocDSLOP(); dataGridView1.DataSource = ds; MonBo = Docmon(); MonChay = DocMonchay(); DoanhthuCN = Doanhthucn(); SLDH = Donhang(); //----- dsKhach = XuLyDuLieu.docBang("select * from thongtinkhach"); dsKhachView = new DataView(dsKhach); dgvdsKhachHang.DataSource = dsKhachView; }
private void bt_DuyetDH_Click(object sender, EventArgs e) { DataRow dh = dsDonHang.NewRow(); dh["HD_MaHD"] = DHC_Ma.Text; dh["HD_TenKhach"] = DHC_tbTen.Text; dh["HD_DiaCHi"] = DHC_tbDiaChi.Text; dh["HD_SDT"] = DHC_tbSDT.Text; dh["HD_MaMDC"] = DHC_MaTD.Text; dh["HD_TinhTrang"] = DHC_TinhTrang.Text; dsDonHang.Rows.Add(dh); XuLyDuLieu.ghiBang("HoaDon", dsDonHang); }
private void bt_suaThongTin_Click(object sender, EventArgs e) { if (dgvdsKhach2.SelectedRows.Count > 0) { DataRow dh = ((DataRowView)dgvdsKhach2.SelectedRows[0].DataBoundItem).Row; dh["HoTenKhach"] = TT_Ten.Text; dh["DiaCHi"] = TT_DiaChi.Text; dh["SDT"] = TT_SDT.Text; dh["SoLanDat"] = TT_SoLan.Text; XuLyDuLieu.ghiBang("ThongTinKhach", dsKhach); } else { MessageBox.Show("Chua Chon Don Hang", "Thong Bao", MessageBoxButtons.OK); } }
private void button1_Click(object sender, EventArgs e) { DataRow dh = dsDonHang.NewRow(); dh["HD_MaHD"] = tbMa.Text; dh["HD_DiaCHi"] = tbDiaChi.Text; dh["HD_TenKhach"] = tbTenKhach.Text; dh["HD_SDT"] = tbSDT.Text; dh["HD_Gia"] = tbTongTien.Text; dsDonHang.Rows.Add(dh); XuLyDuLieu.ghiBang("HoaDon", dsDonHang); MessageBox.Show("Bạn Đã Tạo Đơn Hàng Thành Công!!", "Thong Bao", MessageBoxButtons.OK); }
/*private void btThemDHC_Click(object sender, EventArgs e) * { * DataRow dh = dsDonHang.NewRow(); * dh["HD_MaHD"] = DHC_Ma.Text; * dh["HD_TenKhach"] = DHC_tbTen.Text; * dh["HD_DiaCHi"] = DHC_tbDiaChi.Text; * dh["HD_SDT"] = DHC_tbSDT.Text; * dh["HD_MaMDC"] = DHC_MaTD.Text; * dh["HD_TinhTrang"] = DHC_TinhTrang.Text; * * dsDonHang.Rows.Add(dh); * * XuLyDuLieu.ghiBang("HoaDon", dsDonHang); * }*/ private void CDH_btSua_Click(object sender, EventArgs e) { if (dgvdsDonHang3.SelectedRows.Count > 0) { DataRow dh = ((DataRowView)dgvdsDonHang3.SelectedRows[0].DataBoundItem).Row; dh["HD_MaHD"] = CDH_Ma.Text; dh["HD_DiaCHi"] = CDH_DiaChi.Text; dh["HD_MaCN"] = CDH_CN.Text; dh["HD_TenKhach"] = CDH_Ten.Text; dh["HD_SDT"] = CDH_SDT.Text; dh["HD_MaMDC"] = CDH_MaMDC.Text; XuLyDuLieu.ghiBang("HoaDon", dsDonHang); } else { MessageBox.Show("Chua Chon Don Hang", "Thong Bao", MessageBoxButtons.OK); } }
private void btSuaDH_Click(object sender, EventArgs e) { if (dgvdsDSHonHang.SelectedRows.Count > 0) { DataRow dh = ((DataRowView)dgvdsDSHonHang.SelectedRows[0].DataBoundItem).Row; dh["HD_MaHD"] = tbDHMaDH.Text; dh["HD_DiaCHi"] = tbDHDiaChi.Text; dh["HD_MaCN"] = tbDHMaCN.Text; dh["HD_TenKhach"] = tbDHTen.Text; dh["HD_SDT"] = tbDHSDT.Text; dh["HD_Gia"] = tbDHTien.Text; dh["HD_TinhTrang"] = tbDHTinhTrang.Text; XuLyDuLieu.ghiBang("HoaDon", dsDonHang); } else { MessageBox.Show("Chua Chon Don Hang", "Thong Bao", MessageBoxButtons.OK); } }
private void button3_Click(object sender, EventArgs e) { if (dgvdsDonHang5.SelectedRows.Count > 0) { DataRow dh = ((DataRowView)dgvdsDonHang5.SelectedRows[0].DataBoundItem).Row; dh["HD_MaHD"] = TD_MaDH.Text; dh["HD_DiaCHi"] = TD_DiaChi.Text; dh["HD_MaCN"] = TD_MaCN.Text; dh["HD_TenKhach"] = TD_Ten.Text; dh["HD_SDT"] = TD_SDT.Text; dh["HD_Gia"] = TD_Gia.Text; dh["HD_TinhTrang"] = TD_TinhTrang.Text; XuLyDuLieu.ghiBang("HoaDon", dsDonHang); MessageBox.Show("Đã thay đổi tình trạng đơn hàng", "Thong Bao", MessageBoxButtons.OK); } else { MessageBox.Show("Chua Chon Don Hang", "Thong Bao", MessageBoxButtons.OK); } }
private void lbdsMaHD_Click(object sender, EventArgs e) { string HD_MaHD = lbdsMaHD.SelectedValue.ToString(); dgvdsDSHonHang.DataSource = XuLyDuLieu.docBang("Select * from HoaDon where (HD_MaHD='" + HD_MaHD + "')"); //dgvdsMonAn.DataSource = XuLyDuLieu.docBang("Select MDC_Loai,MDC_TenMon,MDC_SoLuong,MDC_Gia from HoaDon,MonDaChon where (HD_MaHD=MDC_Ma and HD_MaHD='" + HD_MaHD + "')"); tbDHMaDH.DataBindings.Clear(); tbDHMaDH.DataBindings.Add("text", lbdsMaHD.DataSource, "HD_MaHD"); tbDHDiaChi.DataBindings.Clear(); tbDHDiaChi.DataBindings.Add("text", lbdsMaHD.DataSource, "HD_DiaCHi"); tbDHMaCN.DataBindings.Clear(); tbDHMaCN.DataBindings.Add("text", lbdsMaHD.DataSource, "HD_MaCN"); tbDHTen.DataBindings.Clear(); tbDHTen.DataBindings.Add("text", lbdsMaHD.DataSource, "HD_TenKhach"); tbDHSDT.DataBindings.Clear(); tbDHSDT.DataBindings.Add("text", lbdsMaHD.DataSource, "HD_SDT"); tbDHTien.DataBindings.Clear(); tbDHTien.DataBindings.Add("text", lbdsMaHD.DataSource, "HD_Gia"); tbDHTinhTrang.DataBindings.Clear(); tbDHTinhTrang.DataBindings.Add("text", lbdsMaHD.DataSource, "HD_TinhTrang"); }
private void lbDHC_Click(object sender, EventArgs e) { string DHC_MaTD = lbDHC.SelectedValue.ToString(); dgvdsTD2.DataSource = XuLyDuLieu.docBang("Select MDC_Ma,MDC_Loai,MDC_TenMon,MDC_SoLuong,MDC_Gia from MonDaChon,dsDonHangCho where (MDC_Ma='" + DHC_MaTD + "')"); }
private void WebDatHang_Load(object sender, EventArgs e) { dsMon = XuLyDuLieu.docBang("Select *from MonBo"); dgvdsMonAn3.DataSource = dsMon; }