private void btnTimKiem_Click_1(object sender, EventArgs e) { clearList(); string key = cmbValue.Text.Trim(); DAL.sqlConnect sqlConn = new DAL.sqlConnect(); string query; SqlDataReader dr = null; if (cmbTimKiem.Text.Equals("Mã nhân viên")) { query = "select nv.ID_NhanVien, nv.HoTen, nd.TaiKhoan, nd.MatKhau, q.ID_QuyenHan, Them, Sua, Xoa, Ad from NHANVIEN nv, NGUOIDUNG nd, QUYENHAN q where nv.TaiKhoan = nd.TaiKhoan and nd.ID_QuyenHan = q.ID_QuyenHan and nv.ID_NhanVien like '" + key + "%'"; dr = sqlConn.execCommand(query); while (dr.Read()) { addList(dr); } } else if (cmbTimKiem.Text.Equals("Họ tên")) { query = "select nv.ID_NhanVien, nv.HoTen, nd.TaiKhoan, nd.MatKhau, q.ID_QuyenHan, Them, Sua, Xoa, Ad from NHANVIEN nv, NGUOIDUNG nd, QUYENHAN q where nv.TaiKhoan = nd.TaiKhoan and nd.ID_QuyenHan = q.ID_QuyenHan and nv.HoTen like '" + key + "%'"; dr = sqlConn.execCommand(query); while (dr.Read()) { addList(dr); } } else if (cmbTimKiem.Text.Equals("Tài khoản")) { query = "select nv.ID_NhanVien, nv.HoTen, nd.TaiKhoan, nd.MatKhau, q.ID_QuyenHan, Them, Sua, Xoa, Ad from NHANVIEN nv, NGUOIDUNG nd, QUYENHAN q where nv.TaiKhoan = nd.TaiKhoan and nd.ID_QuyenHan = q.ID_QuyenHan and nd.TaiKhoan like '" + key + "%'"; dr = sqlConn.execCommand(query); while (dr.Read()) { addList(dr); } } else { query = "select nv.ID_NhanVien, nv.HoTen, nd.TaiKhoan, nd.MatKhau, q.ID_QuyenHan, Them, Sua, Xoa, Ad from NHANVIEN nv, NGUOIDUNG nd, QUYENHAN q where nv.TaiKhoan = nd.TaiKhoan and nd.ID_QuyenHan = q.ID_QuyenHan and q.ID_QuyenHan like '" + key + "%'"; dr = sqlConn.execCommand(query); while (dr.Read()) { addList(dr); } } }
private void cmbTimKiem_SelectionChangeCommitted(object sender, EventArgs e) { cmbValue.Items.Clear(); cmbValue.ResetText(); int key = cmbTimKiem.SelectedIndex; string query = "select xe.ID_Xe, h.HangXe, xe.BienSoXe, xe.DoiXe, xe.SoKhung, xe.SoMay, xe.SoKM from THONGTINXE xe, HANGXE h where xe.ID_HangXe = h.ID_HangXe"; DAL.sqlConnect sqlConn = new DAL.sqlConnect(); SqlDataReader dr = sqlConn.execCommand(query); if (key == 0) { while (dr.Read()) { cmbValue.Items.Add(dr["ID_Xe"].ToString()); } } else if (key == 1) { //cmbValue.Items.Add(dr["HangXe"].ToString()); loadHangXe(); } else if (key == 2) { while (dr.Read()) { cmbValue.Items.Add(dr["BienSoXe"].ToString()); } } else if (key == 3) { while (dr.Read()) { cmbValue.Items.Add(dr["DoiXe"].ToString()); } } else if (key == 4) { while (dr.Read()) { cmbValue.Items.Add(dr["SoKhung"].ToString()); } } else if (key == 5) { while (dr.Read()) { cmbValue.Items.Add(dr["SoMay"].ToString()); } } else { while (dr.Read()) { cmbValue.Items.Add(dr["SoKM"].ToString()); } } }
private void loadTenVT() { string query = "select TenVatTu from VATTU"; DAL.sqlConnect sqlConn = new DAL.sqlConnect(); SqlDataReader dr = sqlConn.execCommand(query); while (dr.Read()) { cmbValue.Items.Add(dr["TenVatTu"].ToString()); } }
private void loadBienSoXe() { string query = "select BienSoXe from THONGTINXE"; DAL.sqlConnect sqlConn = new DAL.sqlConnect(); SqlDataReader dr = sqlConn.execCommand(query); while (dr.Read()) { cmbValue.Items.Add(dr["BienSoXe"].ToString()); } }
private void loadTenKH() { string query = "select HoTen from KHACHHANG"; DAL.sqlConnect sqlConn = new DAL.sqlConnect(); SqlDataReader dr = sqlConn.execCommand(query); while (dr.Read()) { cmbValue.Items.Add(dr["HoTen"].ToString()); } }
public void showLsvThongTinXe() { clearLsvThongTinXe(); string query = "select xe.ID_Xe, h.HangXe, xe.BienSoXe, xe.DoiXe, xe.SoKhung, xe.SoMay, xe.SoKM from THONGTINXE xe, HANGXE h where xe.ID_HangXe = h.ID_HangXe"; DAL.sqlConnect sqlConn = new DAL.sqlConnect(); SqlDataReader dr = sqlConn.execCommand(query); while (dr.Read()) { addList(dr); } }
public void showLsvHD_PVT() { clearLsvHD_PVT(); string query = "select hd.ID_HoaDonVatTu, p.ID_PhieuVatTu, vt.TenVatTu, hd.SoLuong, hd.TongTien from HOADON_PHIEUVATTU hd, PHIEUVATTU p, VATTU vt where hd.ID_VatTu = vt.ID_VatTu and hd.ID_PhieuVatTu = p.ID_PhieuVatTu"; DAL.sqlConnect sqlConn = new DAL.sqlConnect(); SqlDataReader dr = sqlConn.execCommand(query); while (dr.Read()) { addList(dr); } }
public void showLsvPhieuKhaoSat() { clearLsvPhieuKhaoSat(); string query = "select pks.ID_PhieuKhaoSat, kh.HoTen, xe.BienSoXe, pks.YeuCau from PHIEUKHAOSAT pks, KHACHHANG kh, THONGTINXE xe where pks.ID_KhachHang = kh.ID_KhachHang and pks.ID_Xe = xe.ID_Xe"; DAL.sqlConnect sqlConn = new DAL.sqlConnect(); SqlDataReader dr = sqlConn.execCommand(query); while (dr.Read()) { addList(dr); } }
public void showLsvVatTu() { clearLsvVatTu(); string query = "select vt.ID_VatTu, vt.TenVatTu, vt.TheLoai, vt.SoTien, c.TenNCC from VATTU vt, NHACUNGCAP c where vt.ID_NhaCungCap = c.ID_NhaCungCap"; DAL.sqlConnect sqlConn = new DAL.sqlConnect(); SqlDataReader dr = sqlConn.execCommand(query); while (dr.Read()) { addList(dr); } }
private void btnXong_Click(object sender, EventArgs e) { clearList(); string key = txtTK.Text.Trim(); DAL.sqlConnect sqlConn = new DAL.sqlConnect(); string query; SqlDataReader dr = null; if (cmbTK.Text.Equals("Mã khách hàng")) { query = "select kh.ID_KhachHang, kh.HoTen, tt.BienSoXe, hx.HangXe, tt.DoiXe, tt.SoKhung, tt.SoMay, kh.SDT, kh.Email, kh.DiaChi from KHACHHANG kh, PHIEUKHAOSAT ks, THONGTINXE tt, HANGXE hx where kh.ID_KhachHang = ks.ID_KhachHang and ks.ID_Xe = tt.ID_Xe and tt.ID_HangXe = hx.ID_HangXe and kh.ID_KhachHang like '" + key + "%'"; dr = sqlConn.execCommand(query); while (dr.Read()) { addList(dr); } } else if (cmbTK.Text.Equals("Họ tên")) { query = "select kh.ID_KhachHang, kh.HoTen, tt.BienSoXe, hx.HangXe, tt.DoiXe, tt.SoKhung, tt.SoMay, kh.SDT, kh.Email, kh.DiaChi from KHACHHANG kh, PHIEUKHAOSAT ks, THONGTINXE tt, HANGXE hx where kh.ID_KhachHang = ks.ID_KhachHang and ks.ID_Xe = tt.ID_Xe and tt.ID_HangXe = hx.ID_HangXe and kh.HoTen like '" + key + "%'"; dr = sqlConn.execCommand(query); while (dr.Read()) { addList(dr); } } else { query = "select kh.ID_KhachHang, kh.HoTen, tt.BienSoXe, hx.HangXe, tt.DoiXe, tt.SoKhung, tt.SoMay, kh.SDT, kh.Email, kh.DiaChi from KHACHHANG kh, PHIEUKHAOSAT ks, THONGTINXE tt, HANGXE hx where kh.ID_KhachHang = ks.ID_KhachHang and ks.ID_Xe = tt.ID_Xe and tt.ID_HangXe = hx.ID_HangXe and tt.BienSoXe like '" + key + "%'"; dr = sqlConn.execCommand(query); while (dr.Read()) { addList(dr); } } }
private void btnXong_Click(object sender, EventArgs e) { clearList(); string key = txtTK.Text.Trim(); DAL.sqlConnect sqlConn = new DAL.sqlConnect(); string query = null; SqlDataReader dr = null; if (cmbThongKe.Text.Equals("Mã hóa đơn")) { query = "select a.ID_HoaDonThanhToan, a.TenHoaDon, b.ID_LenhSuaChua, c.MaNguoiPhuTrach, a.TienDichVu, d.TongTien, a.TongTienThanhToan from HOADON_THANHTOAN a, LENHSUACHUA b, PHIEUVATTU c, HOADON_PHIEUVATTU d where a.ID_LenhSuaChua = b.ID_LenhSuaChua and b.ID_PhieuVatTu = c.ID_PhieuVatTu and c.ID_PhieuVatTu = d.ID_PhieuVatTu and a.ID_HoaDonThanhToan like'" + key + "%'"; dr = sqlConn.execCommand(query); while (dr.Read()) { addList(dr); } } else if (cmbThongKe.Text.Equals("Tên hóa đơn")) { query = "select a.ID_HoaDonThanhToan, a.TenHoaDon, b.ID_LenhSuaChua, c.MaNguoiPhuTrach, a.TienDichVu, d.TongTien, a.TongTienThanhToan from HOADON_THANHTOAN a, LENHSUACHUA b, PHIEUVATTU c, HOADON_PHIEUVATTU d where a.ID_LenhSuaChua = b.ID_LenhSuaChua and b.ID_PhieuVatTu = c.ID_PhieuVatTu and c.ID_PhieuVatTu = d.ID_PhieuVatTu and a.TenHoaDon like '" + key + "%'"; dr = sqlConn.execCommand(query); while (dr.Read()) { addList(dr); } } else { query = "select a.ID_HoaDonThanhToan, a.TenHoaDon, b.ID_LenhSuaChua, c.MaNguoiPhuTrach, a.TienDichVu, d.TongTien, a.TongTienThanhToan from HOADON_THANHTOAN a, LENHSUACHUA b, PHIEUVATTU c, HOADON_PHIEUVATTU d where a.ID_LenhSuaChua = b.ID_LenhSuaChua and b.ID_PhieuVatTu = c.ID_PhieuVatTu and c.ID_PhieuVatTu = d.ID_PhieuVatTu and c.MaNguoiPhuTrach like '" + key + "%'"; dr = sqlConn.execCommand(query); while (dr.Read()) { addList(dr); } } }
private void btnXong_Click(object sender, EventArgs e) { clearList(); string key = txtTK.Text.Trim(); DAL.sqlConnect sqlConn = new DAL.sqlConnect(); string query = null; SqlDataReader dr = null; if (cmbTK.Text.Equals("Tên nhà cung cấp")) { query = "select ncc.ID_NhaCungCap, vt.ID_VatTu, ncc.TenNCC, vt.TenVatTu, ncc.DiaChi, ncc.SDT, ncc.Email, ncc.Website, hd.SoLuong, vt.SoTien, hd.TongTien from NHACUNGCAP ncc, VATTU vt, HOADON_PHIEUVATTU hd where ncc.ID_NhaCungCap = vt.ID_NhaCungCap and vt.ID_VatTu = hd.ID_VatTu and ncc.TenNCC like '" + key + "%'"; dr = sqlConn.execCommand(query); while (dr.Read()) { addList(dr); } } else if (cmbTK.Text.Equals("Tên vật tư")) { query = "select ncc.ID_NhaCungCap, vt.ID_VatTu, ncc.TenNCC, vt.TenVatTu, ncc.DiaChi, ncc.SDT, ncc.Email, ncc.Website, hd.SoLuong, vt.SoTien, hd.TongTien from NHACUNGCAP ncc, VATTU vt, HOADON_PHIEUVATTU hd where ncc.ID_NhaCungCap = vt.ID_NhaCungCap and vt.ID_VatTu = hd.ID_VatTu and vt.TenVatTu like '" + key + "%'"; dr = sqlConn.execCommand(query); while (dr.Read()) { addList(dr); } } else { query = "select ncc.ID_NhaCungCap, vt.ID_VatTu, ncc.TenNCC, vt.TenVatTu, ncc.DiaChi, ncc.SDT, ncc.Email, ncc.Website, hd.SoLuong, vt.SoTien, hd.TongTien from NHACUNGCAP ncc, VATTU vt, HOADON_PHIEUVATTU hd where ncc.ID_NhaCungCap = vt.ID_NhaCungCap and vt.ID_VatTu = hd.ID_VatTu and hd.SoLuong like '" + key + "%'"; dr = sqlConn.execCommand(query); while (dr.Read()) { addList(dr); } } }
private void btnXong_Click(object sender, EventArgs e) { clearList(); string key = txtTK.Text.Trim(); DAL.sqlConnect sqlConn = new DAL.sqlConnect(); string query; SqlDataReader dr = null; if (cmbTK.Text.Equals("Mã phân công")) { query = "select pc.ID_PhanCong, nv.ID_NhanVien, nv.HoTen, nv.SDT, nv.NgaySinh, nv.GioiTinh, nv.DiaChi, pc.NgayBatDau from NHANVIEN nv, PHANCONG pc where nv.ID_NhanVien = pc.ID_NhanVien and pc.ID_PhanCong like '" + key + "%'"; dr = sqlConn.execCommand(query); while (dr.Read()) { addList(dr); } } else if (cmbTK.Text.Equals("Mã nhân viên")) { query = "select pc.ID_PhanCong, nv.ID_NhanVien, nv.HoTen, nv.SDT, nv.NgaySinh, nv.GioiTinh, nv.DiaChi, pc.NgayBatDau from NHANVIEN nv, PHANCONG pc where nv.ID_NhanVien = pc.ID_NhanVien and nv.ID_NhanVien like '" + key + "%'"; dr = sqlConn.execCommand(query); while (dr.Read()) { addList(dr); } } else { query = "select pc.ID_PhanCong, nv.ID_NhanVien, nv.HoTen, nv.SDT, nv.NgaySinh, nv.GioiTinh, nv.DiaChi, pc.NgayBatDau from NHANVIEN nv, PHANCONG pc where nv.ID_NhanVien = pc.ID_NhanVien and nv.HoTen like '" + key + "%'"; dr = sqlConn.execCommand(query); while (dr.Read()) { addList(dr); } } }
private void btnXong_Click(object sender, EventArgs e) { clearList(); string key = txtTK.Text.Trim(); DAL.sqlConnect sqlConn = new DAL.sqlConnect(); string query = null; SqlDataReader dr = null; if (cmbTK.Text.Equals("Mã hóa đơn vật tư")) { query = "select a.ID_HoaDonVatTu, b.ID_PhieuVatTu, c.ID_VatTu, c.TenVatTu, b.MaNguoiPhuTrach, a.SoLuong, c.TheLoai, b.ThoiGian, c.SoTien, a.TongTien from HOADON_PHIEUVATTU a, PHIEUVATTU b, VATTU c where a.ID_VatTu = c.ID_VatTu and a.ID_PhieuVatTu = b.ID_PhieuVatTu and a.ID_HoaDonVatTu like'" + key + "%'"; dr = sqlConn.execCommand(query); while (dr.Read()) { addList(dr); } } else if (cmbTK.Text.Equals("Mã phiếu vật tư")) { query = "select a.ID_HoaDonVatTu, b.ID_PhieuVatTu, c.ID_VatTu, c.TenVatTu, b.MaNguoiPhuTrach, a.SoLuong, c.TheLoai, b.ThoiGian, c.SoTien, a.TongTien from HOADON_PHIEUVATTU a, PHIEUVATTU b, VATTU c where a.ID_VatTu = c.ID_VatTu and a.ID_PhieuVatTu = b.ID_PhieuVatTu and b.ID_PhieuVatTu like '" + key + "%'"; dr = sqlConn.execCommand(query); while (dr.Read()) { addList(dr); } } else { query = "select a.ID_HoaDonVatTu, b.ID_PhieuVatTu, c.ID_VatTu, c.TenVatTu, b.MaNguoiPhuTrach, a.SoLuong, c.TheLoai, b.ThoiGian, c.SoTien, a.TongTien from HOADON_PHIEUVATTU a, PHIEUVATTU b, VATTU c where a.ID_VatTu = c.ID_VatTu and a.ID_PhieuVatTu = b.ID_PhieuVatTu and c.TenVatTu like '" + key + "%'"; dr = sqlConn.execCommand(query); while (dr.Read()) { addList(dr); } } }
public void showList() { clearList(); string query = "select a.ID_HoaDonThanhToan, a.TenHoaDon, b.ID_LenhSuaChua, c.MaNguoiPhuTrach, a.TienDichVu, d.TongTien, a.TongTienThanhToan from HOADON_THANHTOAN a, LENHSUACHUA b, PHIEUVATTU c, HOADON_PHIEUVATTU d where a.ID_LenhSuaChua = b.ID_LenhSuaChua and b.ID_PhieuVatTu = c.ID_PhieuVatTu and c.ID_PhieuVatTu = d.ID_PhieuVatTu"; SqlDataReader dr = null; try { DAL.sqlConnect sqlConn = new DAL.sqlConnect(); dr = sqlConn.execCommand(query); while (dr.Read()) { addList(dr); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public void showList() { clearList(); string query = "select pc.ID_PhanCong, nv.ID_NhanVien, nv.HoTen, nv.SDT, nv.NgaySinh, nv.GioiTinh, nv.DiaChi, pc.NgayBatDau from NHANVIEN nv, PHANCONG pc where nv.ID_NhanVien = pc.ID_NhanVien"; SqlDataReader dr = null; try { DAL.sqlConnect sqlConn = new DAL.sqlConnect(); dr = sqlConn.execCommand(query); while (dr.Read()) { addList(dr); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public void showList() { clearList(); string query = "select ncc.ID_NhaCungCap, vt.ID_VatTu, ncc.TenNCC, vt.TenVatTu, ncc.DiaChi, ncc.SDT, ncc.Email, ncc.Website, hd.SoLuong, vt.SoTien, hd.TongTien from NHACUNGCAP ncc, VATTU vt, HOADON_PHIEUVATTU hd where ncc.ID_NhaCungCap = vt.ID_NhaCungCap and vt.ID_VatTu = hd.ID_VatTu"; SqlDataReader dr = null; try { DAL.sqlConnect sqlConn = new DAL.sqlConnect(); dr = sqlConn.execCommand(query); while (dr.Read()) { addList(dr); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public void showList() { clearList(); string query = "select nv.ID_NhanVien, nv.HoTen, nd.TaiKhoan, nd.MatKhau, q.ID_QuyenHan, Them, Sua, Xoa, Ad from NHANVIEN nv, NGUOIDUNG nd, QUYENHAN q where nv.TaiKhoan = nd.TaiKhoan and nd.ID_QuyenHan = q.ID_QuyenHan "; SqlDataReader dr = null; try { DAL.sqlConnect sqlConn = new DAL.sqlConnect(); dr = sqlConn.execCommand(query); while (dr.Read()) { addList(dr); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public void showList() { clearList(); string query = "select a.ID_HoaDonVatTu, b.ID_PhieuVatTu, c.ID_VatTu, c.TenVatTu, b.MaNguoiPhuTrach, a.SoLuong, c.TheLoai, b.ThoiGian, c.SoTien, a.TongTien from HOADON_PHIEUVATTU a, PHIEUVATTU b, VATTU c where a.ID_VatTu = c.ID_VatTu and a.ID_PhieuVatTu = b.ID_PhieuVatTu "; SqlDataReader dr = null; try { DAL.sqlConnect sqlConn = new DAL.sqlConnect(); dr = sqlConn.execCommand(query); while (dr.Read()) { addList(dr); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public void showList() { clearList(); string query = "select kh.ID_KhachHang, kh.HoTen, tt.BienSoXe, hx.HangXe, tt.DoiXe,tt.SoKhung, tt.SoMay, kh.SDT, kh.Email, kh.DiaChi from KHACHHANG kh, PHIEUKHAOSAT ks, THONGTINXE tt, HANGXE hx where kh.ID_KhachHang = ks.ID_KhachHang and ks.ID_Xe = tt.ID_Xe and tt.ID_HangXe = hx.ID_HangXe"; SqlDataReader dr = null; try { DAL.sqlConnect sqlConn = new DAL.sqlConnect(); dr = sqlConn.execCommand(query); while (dr.Read()) { addList(dr); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void frmMain_Load(object sender, EventArgs e) { string query = "select q.Them, q.Sua, q.Xoa, q.Ad from QUYENHAN q, NGUOIDUNG n where q.ID_QuyenHan = n.ID_QuyenHan and n.TaiKhoan = '" + DAL.NguoiDung_Model.taikhoan + "' and n.MatKhau = '" + DAL.NguoiDung_Model.matkhau + "'"; DAL.sqlConnect sqlConn = new DAL.sqlConnect(); sqlConn.openConnection(); SqlDataReader dr = sqlConn.execCommand(query); while (dr.Read()) { if (dr["Ad"].ToString().Equals("True")) { mnuHT_QLND.Enabled = true; mnuHT_PQ.Enabled = true; } else { mnuHT_QLND.Enabled = false; mnuHT_PQ.Enabled = false; } if (dr["Them"].ToString().Equals("False") && dr["Sua"].ToString().Equals("False") && dr["Xoa"].ToString().Equals("False")) { mnuDM.Enabled = false; } else { mnuDM.Enabled = true; } } //DAL.NguoiDung_Model nd = new DAL.NguoiDung_Model(); //nd.checkPermission(btnThemKH, btnSuaKH, btnXoaKH); //loadLsvKhachHang(); //pnlThemKH.Visible = false; lockControl(); }