private void btSua_Click(object sender, EventArgs e) { if (dgvKhachHang.SelectedRows.Count > 0) { DataRow cn = ((DataRowView)dgvKhachHang.SelectedRows[0].DataBoundItem).Row; XuLyDuLieu.ghiDuLieu("KHACH_HANG", dt); } Form_Load(); }
private void dgvBan_SelectionChanged(object sender, EventArgs e) { if (dgvBan.SelectedRows.Count > 0) { DataRow dr = ((DataRowView)dgvBan.SelectedRows[0].DataBoundItem).Row; this.txtTenBan.Text = dr[1].ToString(); this.cbTrangThai.Text = dr[3].ToString(); XuLyDuLieu.ghiDuLieu("CHI_NHANH", dsBan); } }
private void btSuaBan_Click_1(object sender, EventArgs e) { if (dgvBan.SelectedRows.Count > 0) { DataRow dr = ((DataRowView)dgvBan.SelectedRows[0].DataBoundItem).Row; dr[1] = this.txtTenBan.Text; dr[3] = this.cbTrangThai.Text; XuLyDuLieu.ghiDuLieu("BAN", dsBan); } Form_Load(); }
private void btThemBan_Click(object sender, EventArgs e) { DataRow cn = ((DataRowView)dgvChiNhanh.SelectedRows[0].DataBoundItem).Row; DataRow dr = dsBan.NewRow(); dr[1] = this.txtTenBan.Text; dr[2] = cn[0].ToString(); dr[3] = this.cbTrangThai.Text; dsBan.Rows.Add(dr); XuLyDuLieu.ghiDuLieu("BAN", dsBan); Form_Load(); }
private void N_Click(object sender, EventArgs e) { dtDonHang = XuLyDuLieu.docDuLieu("Select * From DON_HANG"); DataRow dr = dtDonHang.NewRow(); dr[1] = Ma; dr[2] = ((Button)sender).Tag; dr[3] = 1; dtDonHang.Rows.Add(dr); XuLyDuLieu.ghiDuLieu("DON_HANG", dtDonHang); Form_Load(); }
private void btSua_Click(object sender, EventArgs e) { if (dgvNuoc.SelectedRows.Count > 0) { DataRow cn = ((DataRowView)dgvNuoc.SelectedRows[0].DataBoundItem).Row; cn[1] = txtTen.Text; cn[2] = txtDonGia.Text; cn[3] = txtThongTin.Text; XuLyDuLieu.ghiDuLieu("MON_AN", dsMM); } }
private void btInHoaDon_Click(object sender, EventArgs e) { dt = XuLyDuLieu.docDuLieu("Select * From HOA_DON"); DataRow dr = dt.NewRow(); dr[0] = Ma + 1; dr[1] = UDQL.Ma; dr[2] = TongTien; dt.Rows.Add(dr); XuLyDuLieu.ghiDuLieu("HOA_DON", dt); this.Hide(); }
private void btXacNhan_Click(object sender, EventArgs e) { dt = XuLyDuLieu.docDuLieu("Select * From KHACH_HANG"); DataRow dr = dt.NewRow(); dr[2] = txtTenKH.Text; dr[1] = txtSDTKH.Text; dr[3] = txtDiaChiKH.Text; dt.Rows.Add(dr); XuLyDuLieu.ghiDuLieu("KHACH_HANG", dt); this.Hide(); }
private void btThemCN_Click(object sender, EventArgs e) { DataRow dr = dsChiNhanh.NewRow(); dr[0] = this.txtMaCN.Text; dr[1] = this.txtTenCN.Text; dr[2] = this.txtSoLuongBanCN.Text; dr[3] = this.txtDiaChiCN.Text; dr[4] = this.txtSDTCN.Text; dr[5] = this.txtQuanLyCN.Text; dsChiNhanh.Rows.Add(dr); XuLyDuLieu.ghiDuLieu("CHI_NHANH", dsChiNhanh); Form_Load(); }
private void btXoa_Click(object sender, EventArgs e) { if (dgvNuoc.SelectedRows.Count > 0) { DataRow cn = ((DataRowView)dgvNuoc.SelectedRows[0].DataBoundItem).Row; String noidung = String.Format("Anh/chi co muon xoa món '{0}' khong?", cn[1]); DialogResult dr = MessageBox.Show(noidung, "Thong bao", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (dr == DialogResult.Yes) { cn.Delete(); XuLyDuLieu.ghiDuLieu("MON_AN", dsMM); } } }
private void btGuiDonHang_Click(object sender, EventArgs e) { DataTable dt = XuLyDuLieu.docDuLieu("Select * From GIAO_HANG"); DataRow dr = dt.NewRow(); dr[1] = DateTime.Now; dr[2] = MaDH; dt.Rows.Add(dr); XuLyDuLieu.ghiDuLieu("GIAO_HANG", dt); MaKH = string.Empty; Form_Load(); btnThemMon.Enabled = false; btTaoMoi.Enabled = false; }
private void btSuaCN_Click(object sender, EventArgs e) { if (dgvChiNhanh.SelectedRows.Count > 0) { DataRow dr = ((DataRowView)dgvChiNhanh.SelectedRows[0].DataBoundItem).Row; dr[0] = this.txtMaCN.Text; dr[1] = this.txtTenCN.Text; dr[2] = this.txtSoLuongBanCN.Text; dr[3] = this.txtDiaChiCN.Text; dr[4] = this.txtSDTCN.Text; dr[5] = this.txtQuanLyCN.Text; XuLyDuLieu.ghiDuLieu("CHI_NHANH", dsChiNhanh); } Load_Ban(); }
private void btMoi_Click(object sender, EventArgs e) { dt = XuLyDuLieu.docDuLieu("Select * From DAT_HANG"); DataRow dr = dt.NewRow(); dr[1] = MaNV; dr[2] = DBNull.Value; dr[3] = MaCN; dr[4] = MaBan; dr[5] = DateTime.Now; dr[6] = DBNull.Value; dt.Rows.Add(dr); XuLyDuLieu.ghiDuLieu("DAT_HANG", dt); Form_Load(); pnMonAn.Enabled = true; }
private void btTaoMoi_Click(object sender, EventArgs e) { DataTable dt = XuLyDuLieu.docDuLieu("Select * From DAT_HANG"); DataRow dr = dt.NewRow(); dr[1] = UDQL.MaNV; dr[2] = dsKhachHang.MaKH; dr[3] = DBNull.Value; dr[4] = DBNull.Value; dr[5] = DateTime.Now; dr[6] = DBNull.Value; dt.Rows.Add(dr); XuLyDuLieu.ghiDuLieu("DAT_HANG", dt); DataTable db = XuLyDuLieu.docDuLieu("Select * From DAT_HANG Where MaKH = '" + dsKhachHang.MaKH + "'"); foreach (DataRow r in db.Rows) { MaDH = r[0].ToString(); } Form_Load(); }
private void btThem_Click(object sender, EventArgs e) { string MaMA = "MA0001"; while (XuLyDuLieu.kiemtratontai(MaMA)) { if (dem < 10) { MaMA = "MA000" + dem.ToString(); } else if (dem < 100) { MaMA = "MA00" + dem.ToString(); } else if (dem < 1000) { MaMA = "MA0" + dem.ToString(); } else { MaMA = "MA" + dem.ToString(); } dem++; } DataRow cn = dsMM.NewRow(); cn[0] = MaMA; cn[1] = txtTen.Text; cn[2] = txtDonGia.Text; cn[3] = txtThongTin.Text; cn[4] = "Dessert"; cn[5] = cbbChiNhanh.SelectedValue; dsMM.Rows.Add(cn); XuLyDuLieu.ghiDuLieu("MON_AN", dsMM); loadDSMM(); }
private void btnThemMon_Click(object sender, EventArgs e) { DataTable db = XuLyDuLieu.docDuLieu("Select * From DAT_HANG Where MaKH = '" + dsKhachHang.MaKH + "'"); foreach (DataRow r in db.Rows) { MaDH = r[0].ToString(); } DataTable dm = XuLyDuLieu.docDuLieu("Select * From MON_AN Where TenMA like N'" + cbMonAn.Text + "'"); foreach (DataRow d in dm.Rows) { Ma = d[0].ToString(); } DataTable dt = XuLyDuLieu.docDuLieu("Select * From DON_HANG"); DataRow dr = dt.NewRow(); dr[1] = MaDH; dr[2] = Ma; dr[3] = nbudSoLuong.Value; dt.Rows.Add(dr); XuLyDuLieu.ghiDuLieu("DON_HANG", dt); Form_Load(); }