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 cmbID_Xe_TextChanged(object sender, EventArgs e)
{
string key = cmbID_Xe.Text.Trim();
string query = "select BienSoXe from THONGTINXE where ID_Xe like '" + key + "%'";
DAL.sqlConnect sqlConn = new DAL.sqlConnect();
string value = sqlConn.execScanler(query);
cmbBienSoXe.Text = value;
}
private void cmbID_HangXe_TextChanged(object sender, EventArgs e)
{
string key = cmbID_HangXe.Text;
string query = "select HangXe from HANGXE where ID_hangXe like '" + key + "%'";
DAL.sqlConnect sqlConn = new DAL.sqlConnect();
string value = sqlConn.execScanler(query);
cmbHangXe.Text = value;
}
private void cmbID_KhachHang_TextChanged(object sender, EventArgs e)
{
string key = cmbID_KhachHang.Text.Trim();
string query = "select HoTen from KHACHHANG where ID_KhachHang like '" + key + "%'";
DAL.sqlConnect sqlConn = new DAL.sqlConnect();
string value = sqlConn.execScanler(query);
cmbTenKH.Text = value;
}
private void cmbID_NCC_TextChanged(object sender, EventArgs e)
{
string key = cmbID_NCC.Text;
string query = "select TenNCC from NHACUNGCAP where ID_NhaCungCap like '" + key + "%'";
DAL.sqlConnect sqlConn = new DAL.sqlConnect();
string value = sqlConn.execScanler(query);
cmbTenNCC.Text = value;
}
private void loadHangXe()
{
DAL.sqlConnect sqlConn = new DAL.sqlConnect();
SqlDataReader dr = sqlConn.getDataTable("HANGXE");
while (dr.Read())
{
cmbValue.Items.Add(dr["HangXe"].ToString());
}
}
public void clearControl()
{
string query = "select count(ID_HangXe) from HANGXE";
DAL.sqlConnect sqlConn = new DAL.sqlConnect();
int count = int.Parse(sqlConn.execScanler(query));
txtID_HangXe.Text = "H" + (count + 1).ToString();
txtTenHangXe.ResetText();
}
private void loadNhaCungCap()
{
DAL.sqlConnect sqlConn = new DAL.sqlConnect();
SqlDataReader dr = sqlConn.getDataTable("NHACUNGCAP");
while (dr.Read())
{
cmbValue.Items.Add(dr["TenNCC"].ToString());
}
}
private void cmbID_NhanVien_TextChanged(object sender, EventArgs e)
{
string key = cmbID_NhanVien.Text.Trim();
string query = "select HoTen from NHANVIEN where ID_NhanVien like '" + key + "%'";
DAL.sqlConnect sqlConn = new DAL.sqlConnect();
string value = sqlConn.execScanler(query);
cmbTenNV.Text = value;
}
private void cmbID_VatTu_TextChanged(object sender, EventArgs e)
{
string key = cmbID_VatTu.Text.Trim();
string query = "select TenVatTu from VATTU where ID_VatTu like '" + key + "%'";
DAL.sqlConnect sqlConn = new DAL.sqlConnect();
string value = sqlConn.execScanler(query);
cmbTenVT.Text = value;
}
public void clearControl()
{
string query = "select count(ID_LenhSuaChua) from LENHSUACHUA";
DAL.sqlConnect sqlConn = new DAL.sqlConnect();
int count = int.Parse(sqlConn.execScanler(query));
txtID_LenhSuaChua.Text = "LSC" + (count + 1).ToString();
txtID_PhieuDanhGia.ResetText();
txtID_PhieuVatTu.ResetText();
}
public void showLsvNhanVien()
{
clearLsvNhanVien();
DAL.sqlConnect conn = new DAL.sqlConnect();
SqlDataReader dr = conn.getDataTable("NHANVIEN");
while (dr.Read())
{
addList(dr);
}
}
public void loadCombobox()
{
DAL.sqlConnect sqlConn = new DAL.sqlConnect();
SqlDataReader dr = sqlConn.getDataTable("LENHSUACHUA");
while (dr.Read())
{
cmbID_LenhSuaChua.Items.Add(dr["ID_LenhSuaChua"].ToString());
}
//cmbTimKiem.SelectedIndex = 0;
}
public void showLsvPhieuDanhGia()
{
clearLsvPhieuDanhGia();
DAL.sqlConnect sqlConn = new DAL.sqlConnect();
SqlDataReader dr = sqlConn.getDataTable("PHIEUDANHGIA");
while (dr.Read())
{
addList(dr);
}
}
public void showLsvNhaCungCap()
{
clearLsvNhaCungCap();
DAL.sqlConnect sqlConn = new DAL.sqlConnect();
SqlDataReader dr = sqlConn.getDataTable("NHACUNGCAP");
while (dr.Read())
{
addList(dr);
}
}
public void showLsvKhachHang()
{
clearLsvKhachHang();
DAL.sqlConnect conn = new DAL.sqlConnect();
SqlDataReader dr = conn.getDataTable("KHACHHANG");
while (dr.Read())
{
addList(dr);
}
}
public void showLsvPhieuVatTu()
{
clearLsvPhieuVatTu();
DAL.sqlConnect sqlConn = new DAL.sqlConnect();
SqlDataReader dr = sqlConn.getDataTable("PHIEUVATTU");
while (dr.Read())
{
addList(dr);
}
}
public void clearControl()
{
string query = "select count(ID_PhieuVatTu) from PHIEUVATTU";
DAL.sqlConnect sqlConn = new DAL.sqlConnect();
int count = int.Parse(sqlConn.execScanler(query));
txtID_PhieuVatTu.Text = "PVT" + (count + 1).ToString();
txtMaNPT.ResetText();
dtThoiGian.Value = DateTime.Now;
}
public void loadCombobox()
{
DAL.sqlConnect sqlConn = new DAL.sqlConnect();
SqlDataReader dr = sqlConn.getDataTable("PHIEUKHAOSAT");
while (dr.Read())
{
cmbID_PhieuKhaoSat.Items.Add(dr["ID_PhieuKhaoSat"].ToString());
}
//cmbTimKiem.SelectedIndex = 0;
}
public void showLsvLenhSuaChua()
{
clearLsvLenhSuaChua();
DAL.sqlConnect sqlConn = new DAL.sqlConnect();
SqlDataReader dr = sqlConn.getDataTable("LENHSUACHUA");
while (dr.Read())
{
addList(dr);
}
}
public void showLsvHD_TT()
{
clearLsvHD_TT();
DAL.sqlConnect sqlConn = new DAL.sqlConnect();
SqlDataReader dr = sqlConn.getDataTable("HOADON_THANHTOAN");
while (dr.Read())
{
addList(dr);
}
}
public void showLsvHangXe()
{
clearLsvHangXe();
DAL.sqlConnect sqlConn = new DAL.sqlConnect();
SqlDataReader dr = sqlConn.getDataTable("HANGXE");
while (dr.Read())
{
addList(dr);
}
}
public void showLsvPhanCong()
{
clearLsvPhanCong();
DAL.sqlConnect sqlConn = new DAL.sqlConnect();
SqlDataReader dr = sqlConn.getDataTable("PHANCONG");
while (dr.Read())
{
addList(dr);
}
}
public void loadCombobox()
{
DAL.sqlConnect sqlConn = new DAL.sqlConnect();
SqlDataReader dr = sqlConn.getDataTable("NHACUNGCAP");
while (dr.Read())
{
cmbID_NCC.Items.Add(dr["ID_NhaCungCap"].ToString());
cmbTenNCC.Items.Add(dr["TenNCC"].ToString());
}
//cmbTimKiem.SelectedIndex = 0;
}
public void loadCombobox()
{
DAL.sqlConnect sqlConn = new DAL.sqlConnect();
SqlDataReader dr = sqlConn.getDataTable("NGUOIDUNG");
while (dr.Read())
{
cmbTaiKhoan.Items.Add(dr["TaiKhoan"].ToString());
}
//cmbTimKiem.SelectedIndex = 0;
cmbTaiKhoan.SelectedItem = "read_only";
}
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());
}
}
public void clearControl()
{
string query = "select count(ID_HoaDonVatTu) from HOADON_PHIEUVATTU";
DAL.sqlConnect sqlConn = new DAL.sqlConnect();
int count = int.Parse(sqlConn.execScanler(query));
txtID_HoaDonVatTu.Text = "HDVT" + (count + 1).ToString();
cmbID_PhieuVatTu.ResetText();
cmbTenVT.ResetText();
txtSoLuong.ResetText();
}
public void clearControl()
{
string query = "select count(ID_PhanCong) from PHANCONG";
DAL.sqlConnect sqlConn = new DAL.sqlConnect();
int count = int.Parse(sqlConn.execScanler(query));
txtID_PhanCong.Text = "PC" + (count + 1).ToString();
cmbID_LenhSuaChua.ResetText();
cmbID_NhanVien.ResetText();
dtNgayBD.Value = DateTime.Now;
}
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());
}
}
