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();
}