void Form_Load() { dt = XuLyDuLieu.docDuLieu("Select N.HoTen, C.TenCN, C.MaCN, N.MaNV From NHAN_VIEN N,CHI_NHANH C Where N.MaCN = C.MaCN and TaiKhoan = '" + TaiKhoan + "'"); foreach (DataRow dr in dt.Rows) { txtTen.Text = dr[0].ToString(); HoaDon.HoTenNV = dr[0].ToString(); lbChiNhanh.Text = dr[1].ToString(); MaCN = dr[2].ToString(); MaNV = dr[3].ToString(); } int M = 0; dt = XuLyDuLieu.docDuLieu("Select * From DAT_HANG Where MaBan = " + MaBan); foreach (DataRow dr in dt.Rows) { M = int.Parse(dr[0].ToString()); } Ma = M; Load_Ban(); dtDonHang = XuLyDuLieu.docDuLieu("Select D.MaDonHang, D.MaDH, M.TenMA, M.DonGia, D.SoLuong, M.DonGia * D.SoLuong as ThanhTien From DON_HANG D, MON_AN M, DAT_HANG DH Where D.MaDH = DH.MaDH and D.MaMA = M.MaMA and MaBan = " + MaBan); dv = new DataView(dtDonHang); dgvGioHang.DataSource = dv; dgvGioHang.Columns[0].Visible = false; dgvGioHang.Columns[1].Visible = false; dsChiNhanh = XuLyDuLieu.docDuLieu("Select * From Chi_Nhanh"); ds = new DataView(dsChiNhanh); dgvChiNhanh.DataSource = ds; }
void LoadChiNhanh() { DataTable listChiNhanh = XuLyDuLieu.docDuLieu("SELECT TenCN FROM dbo.CHI_NHANH"); cbChiNhanh.DataSource = listChiNhanh; cbChiNhanh.DisplayMember = "TenCN"; }
private void btThem_Click(object sender, EventArgs e) { pnMonAn.Controls.Clear(); int i = 1; int j = 1; int z = 1; int y = 1; DataTable dt = XuLyDuLieu.docDuLieu("Select M.* From MON_AN M,CHI_NHANH C Where M.MaCN = C.MaCN and M.Loai like N'Them' and C.TenCN like N'" + lbChiNhanh.Text + "'"); foreach (DataRow dr in dt.Rows) { Button N = new Button(); N.Width = 60; N.Height = 60; N.Top = 10 * z; N.Left = 10 * i; N.BackColor = Color.SkyBlue; //N.Name = "BT" + i; N.Tag = string.Format("{0}", dr[0].ToString()); N.Text = dr[1].ToString(); this.pnMonAn.Controls.Add(N); N.Click += new EventHandler(N_Click); i += 6; j++; if (j == 8 * y) { y++; i = 1; j = 1; z = 7; } } }
void Load_Ban() { dgvDSBan.Controls.Clear(); int i = 1; int j = 1; int z = 1; int y = 1; dt = XuLyDuLieu.docDuLieu("Select * From BAN Where MaCN = '" + MaCN + "'"); foreach (DataRow dr in dt.Rows) { Button N = new Button(); N.Width = 60; N.Height = 60; N.Top = 10 * z; N.Left = 10 * i; N.BackColor = Color.Aqua; //N.Name = "BT" + i; N.Tag = string.Format("{0}", dr[0].ToString()); N.Text = dr[1].ToString(); this.dgvDSBan.Controls.Add(N); N.Click += new EventHandler(Ban_Click); N.DialogResult = DialogResult.OK; i += 6; j++; if (j == 7 * y) { y++; i = 1; j = 1; z = 7; } } }
private void btXacNhan_Click(object sender, EventArgs e) { MaQL M = new MaQL(); M.ShowDialog(); if (M.DialogResult == DialogResult.OK) { dt = XuLyDuLieu.docDuLieu("Select MaCN From CHI_NHANH Where TenCN like N'" + txtChiNhanh.Text + "'"); foreach (DataRow dr in dt.Rows) { Ma = dr[0].ToString(); } // Store SqlConnection con = new SqlConnection(XuLyDuLieu.connectionString); con.Open(); SqlCommand cmd = new SqlCommand("DangKy", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@MaCN", SqlDbType.Char)); cmd.Parameters.Add(new SqlParameter("@HoTen", SqlDbType.NVarChar)); cmd.Parameters.Add(new SqlParameter("@GioiTinh", SqlDbType.Char)); cmd.Parameters.Add(new SqlParameter("@DienThoai", SqlDbType.Int)); cmd.Parameters.Add(new SqlParameter("@DiaChi", SqlDbType.NVarChar)); cmd.Parameters.Add(new SqlParameter("@NgaySinh", SqlDbType.DateTime)); cmd.Parameters.Add(new SqlParameter("@TaiKhoan", SqlDbType.Char)); cmd.Parameters.Add(new SqlParameter("@MatKhau", SqlDbType.Char)); cmd.Parameters["@MaCN"].Value = Ma; cmd.Parameters["@HoTen"].Value = txtHoTen.Text; if (cbNam.CheckState == CheckState.Checked) { cmd.Parameters["@GioiTinh"].Value = cbNam.Text; } else { cmd.Parameters["@GioiTinh"].Value = cbNu.Text; } cmd.Parameters["@DienThoai"].Value = txtSDT.Text; cmd.Parameters["@DiaChi"].Value = txtDiaChi.Text; cmd.Parameters["@NgaySinh"].Value = txtNgaySinh.Text; cmd.Parameters["@TaiKhoan"].Value = txtTaiKhoan.Text; cmd.Parameters["@MatKhau"].Value = txtMatKhau.Text; cmd.Parameters.Add("RETURN_VALUE", SqlDbType.Int).Direction = ParameterDirection.ReturnValue; cmd.ExecuteNonQuery(); con.Close(); int ReturnValueInt = Convert.ToInt32(cmd.Parameters["RETURN_VALUE"].Value); if (ReturnValueInt == 1) { MessageBox.Show("Đăng ký thành công"); this.Hide(); } else { MessageBox.Show("Tài khoản đã tồn tại"); } } }
private void GhiChu_Load(object sender, EventArgs e) { dt = XuLyDuLieu.docDuLieu("Select GhiChu From DAT_HANG Where MaDH = " + UDQL.Ma + "and MaBan = " + UDQL.MaBan); foreach (DataRow dr in dt.Rows) { txtGhiChu.Text = dr[0].ToString(); } }
void LoadMonAnTheoDanhMuc(string tenDanhMuc) { DataTable listFood = XuLyDuLieu.docDuLieu(string.Format("SELECT M.TenMA FROM dbo.MON_AN M, dbo.CHI_NHANH C WHERE M.MaCN = C.MaCN and M.Loai = '{0}' AND C.TenCN like N'{1}'", tenDanhMuc, cbChiNhanh.Text)); cbMonAn.DataSource = listFood; cbMonAn.DisplayMember = "TenMA"; //cbMonAn.ValueMember = "Tên Món"; }
private void DangKy_Load(object sender, EventArgs e) { dt = XuLyDuLieu.docDuLieu("Select TenCN From CHI_NHANH"); foreach (DataRow dr in dt.Rows) { txtChiNhanh.Items.Add(dr[0].ToString()); } }
private void LoadDSBan(string MaCN) { string str = "Select * From BAN Where MaCN like N'%" + MaCN.ToString() + "'"; dsBan = XuLyDuLieu.docDuLieu(str); dgvBan.DataSource = dsBan; dgvBan.Columns[0].Visible = false; dgvBan.Columns[2].Visible = false; }
public void loadDSMM() { string str = "Select * from MON_AN where Loai = 'Nuoc' and MaCN like N'%" + cbbChiNhanh.SelectedValue + "'"; dsMM = XuLyDuLieu.docDuLieu(str); dgvNuoc.DataSource = dsMM; dgvNuoc.Columns[0].Visible = false; dgvNuoc.Columns[5].Visible = false; }
private void loadDSChiNhanh() { string str = "select * from CHI_NHANH"; dsCN = XuLyDuLieu.docDuLieu(str); cbbChiNhanh.DataSource = dsCN; cbbChiNhanh.ValueMember = "MaCN"; cbbChiNhanh.DisplayMember = "TenCN"; }
private void cbbChiNhanh_SelectedIndexChanged(object sender, EventArgs e) { dt = XuLyDuLieu.docDuLieu("Select C.SoDienT, N.HoTen, B.SoLuongDH, B.TongDT, B.Ngay From BAO_CAO B, NHAN_VIEN N, CHI_NHANH C Where B.MaNV = N.MaNV and B.MaCN = C.MaCN and C.TenCN like N'" + cbbChiNhanh.Text + "'"); dgvThongKe.DataSource = dt; dgvThongKe.Columns[0].Visible = false; foreach (DataRow dr in dt.Rows) { lbSDT.Text = dr[0].ToString(); } }
private void ThongKe_Load(object sender, EventArgs e) { dt = XuLyDuLieu.docDuLieu("Select TenCN From CHI_NHANH"); foreach (DataRow dr in dt.Rows) { cbbChiNhanh.Items.Add(dr[0].ToString()); } dt = XuLyDuLieu.docDuLieu("Select N.HoTen, C.TenCN, B.SoLuongDH, B.TongDT, B.Ngay From BAO_CAO B, NHAN_VIEN N, CHI_NHANH C Where B.MaNV = N.MaNV and B.MaCN = C.MaCN"); dgvThongKe.DataSource = dt; }
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 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 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 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 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 TongDai_Load(object sender, EventArgs e) { btnThemMon.Enabled = false; btTaoMoi.Enabled = false; DataTable db = XuLyDuLieu.docDuLieu("Select * From DAT_HANG"); foreach (DataRow r in db.Rows) { MaDH = r[0].ToString(); } DataTable dT = XuLyDuLieu.docDuLieu("Select * From KHACH_HANG"); foreach (DataRow r in dT.Rows) { MaKH = r[0].ToString(); } Form_Load(); }
private void ProFile_Load(object sender, EventArgs e) { dt = XuLyDuLieu.docDuLieu("Select * From NHAN_VIEN Where TaiKhoan = '" + UDQL.TaiKhoan + "'"); foreach (DataRow dr in dt.Rows) { txtHoTen.Text = dr[2].ToString(); txtDiaChi.Text = dr[5].ToString(); txtSDT.Text = dr[4].ToString(); txtTaiKhoan.Text = dr[7].ToString(); txtMatKhau.Text = dr[8].ToString(); if (dr[3].ToString() == "Nam") { cbNam.CheckState = CheckState.Checked; } else { cbNu.CheckState = CheckState.Checked; } } }
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(); }
void Form_Load() { DataTable db = XuLyDuLieu.docDuLieu("Select * From DAT_HANG Where MaKH = '" + dsKhachHang.MaKH + "'"); foreach (DataRow r in db.Rows) { MaDH = r[0].ToString(); } Tong = 0; DataTable dt = XuLyDuLieu.docDuLieu("Select D.MaDonHang, D.MaDH, M.TenMA, M.DonGia, D.SoLuong, M.DonGia * D.SoLuong as ThanhTien From DON_HANG D, MON_AN M, DAT_HANG DH Where D.MaDH = DH.MaDH and D.MaMA = M.MaMA and DH.MaDH = '" + MaDH + "'"); foreach (DataRow dr in dt.Rows) { Tong += int.Parse(dr[5].ToString()); } txtTongTien.Text = Tong.ToString(); DataTable dtDonHang = XuLyDuLieu.docDuLieu("Select D.MaDonHang, D.MaDH, M.TenMA, M.DonGia, D.SoLuong, M.DonGia * D.SoLuong as ThanhTien From DON_HANG D, MON_AN M, DAT_HANG DH Where D.MaDH = DH.MaDH and D.MaMA = M.MaMA and DH.MaDH = '" + MaDH + "'"); dgvGioHang.DataSource = dtDonHang; dgvGioHang.Columns[0].Visible = false; dgvGioHang.Columns[1].Visible = false; }
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(); }
private void HoaDon_Load(object sender, EventArgs e) { dt = XuLyDuLieu.docDuLieu("Select MaHD From HOA_DON"); foreach (DataRow n in dt.Rows) { Ma = int.Parse(n[0].ToString()); } dt = XuLyDuLieu.docDuLieu("Select M.DonGia * D.SoLuong as ThanhTien From DON_HANG D, MON_AN M, DAT_HANG DH Where D.MaDH = DH.MaDH and D.MaMA = M.MaMA and MaBan = " + UDQL.MaBan); foreach (DataRow dn in dt.Rows) { TongTien += int.Parse(dn[0].ToString()); } lbToDay.Text = (DateTime.Now).ToString(); dt = XuLyDuLieu.docDuLieu("Select M.TenMA, M.DonGia, D.SoLuong, M.DonGia * D.SoLuong as ThanhTien From DON_HANG D, MON_AN M, DAT_HANG DH Where D.MaDH = DH.MaDH and D.MaMA = M.MaMA and MaBan = " + UDQL.MaBan); dgvHoaDon.DataSource = dt; lbMaHD.Text = (Ma + 1).ToString(); lbTenNV.Text = HoTenNV; dt = XuLyDuLieu.docDuLieu("Select TenBan From BAN Where MaBan =" + UDQL.MaBan); foreach (DataRow d in dt.Rows) { lbTenBan.Text = d[0].ToString(); } lblSotien.Text = TongTien.ToString(); }
void Form_Load() { dt = XuLyDuLieu.docDuLieu("Select * From KHACH_HANG"); dgvKhachHang.DataSource = dt; dgvKhachHang.Columns[0].Visible = false; }
void LoadChiNhanh() { DataTable listChiNhanh = XuLyDuLieu.docDuLieu("SELECT TenCN AS N'Tên Chi Nhánh', SoLuongBan AS N'Số Lượng Bàn', DiaChi AS N'Địa Chỉ', SoDienT AS N'Điện Thoại', QuanLy AS N'Quản Lý' FROM dbo.CHI_NHANH"); dgvChiNhanh.DataSource = listChiNhanh; }
private void cbbThongKe_SelectedIndexChanged(object sender, EventArgs e) { dt = XuLyDuLieu.docDuLieu("Select N.HoTen, B.SoLuongDH, B.TongDT From BAO_CAO B, NHAN_VIEN N, CHI_NHANH C Where B.MaNV = N.MaNV and B.MaCN = C.MaCN and C.TenCN like N'" + cbbChiNhanh.Text + "' and B.Ngay like N'%" + cbbThongKe.Text + "%'"); dgvThongKe.DataSource = dt; }
private void GiaoHang_Load(object sender, EventArgs e) { DataTable dt = XuLyDuLieu.docDuLieu("Select G.MaGH, K.HoTen, G.NgayGH, D.NgayDH, M.TenMA, DH.SoLuong From GIAO_HANG G, DAT_HANG D, DON_HANG DH, MON_AN M, KHACH_HANG K Where K.MaKH = D.MaKH and M.MaMA = DH.MaMA and G.MaDH = D.MaDH and D.MaDH = DH.MaDH"); dgvGiaoHang.DataSource = dt; }
private void cbChiNhanh_SelectedIndexChanged(object sender, EventArgs e) { DataTable dt = XuLyDuLieu.docDuLieu("Select M.TenMA From MON_AN M, CHI_NHANH C Where M.MaCN = C.MaCN and C.TenCN like N'" + cbChiNhanh.Text + "' and M.Loai = '" + tenDanhMuc + "'"); cbMonAn.DataSource = dt; }