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_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;
}
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_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;
}
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 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;
}
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 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 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;
}
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_KhachHang) from KHACHHANG";
DAL.sqlConnect sqlConn = new DAL.sqlConnect();
int count = int.Parse(sqlConn.execScanler(query));
txtID_KhachHang.Text = "KH" + (count + 1).ToString();
txtHoTen.ResetText();
txtSDT.ResetText();
txtEmail.ResetText();
txtDiaChi.ResetText();
}
public void clearControl()
{
string query = "select count(ID_PhieuDanhGia) from PHIEUDANHGIA";
DAL.sqlConnect sqlConn = new DAL.sqlConnect();
int count = int.Parse(sqlConn.execScanler(query));
txtID_PhieuDanhGia.Text = "PDG" + (count + 1).ToString();
cmbID_PhieuKhaoSat.ResetText();
txtMaBH.ResetText();
txtTinhTrangXe.ResetText();
txtBaoGia.ResetText();
}
public void clearControl()
{
string query = "select count(ID_HoaDonThanhToan) from HOADON_THANHTOAN";
DAL.sqlConnect sqlConn = new DAL.sqlConnect();
int count = int.Parse(sqlConn.execScanler(query));
txtID_HoaDonThanhToan.Text = "HDTT" + (count + 1).ToString();
cmbID_LenhSuaChua.ResetText();
txtTenHD.ResetText();
txtMaNPT.ResetText();
txtTienDichVu.ResetText();
}
public void clearControl()
{
string query = "select count(ID_PhieuKhaoSat) from PHIEUKHAOSAT";
DAL.sqlConnect sqlConn = new DAL.sqlConnect();
int count = int.Parse(sqlConn.execScanler(query));
txtID_PhieuKhaoSat.Text = "PKS" + (count + 1).ToString();
txtYeuCau.ResetText();
cmbID_KhachHang.ResetText();
cmbTenKH.ResetText();
cmbID_Xe.ResetText();
cmbBienSoXe.ResetText();
}
public void clearControl()
{
string query = "select count(ID_NhaCungCap) from NHACUNGCAP";
DAL.sqlConnect sqlConn = new DAL.sqlConnect();
int count = int.Parse(sqlConn.execScanler(query));
txtID_NhaCungCap.Text = "NCC" + (count + 1).ToString();
txtTenNCC.ResetText();
txtDiaChi.ResetText();
txtSDT.ResetText();
txtEmail.ResetText();
txtWebsite.ResetText();
}
public void clearControl()
{
string query = "select count(ID_VatTu) from VATTU";
DAL.sqlConnect sqlConn = new DAL.sqlConnect();
int count = int.Parse(sqlConn.execScanler(query));
txtID_VatTu.Text = "VT" + (count + 1).ToString();
txtTenVatTu.ResetText();
txtTheLoai.ResetText();
txtSoTien.ResetText();
cmbTenNCC.ResetText();
cmbID_NCC.ResetText();
}
public void clearControl()
{
string query = "select count(ID_NhanVien) from NHANVIEN";
DAL.sqlConnect sqlConn = new DAL.sqlConnect();
int count = int.Parse(sqlConn.execScanler(query));
txtID_NhanVien.Text = "NV" + (count + 1).ToString();
txtHoTen.ResetText();
txtSDT.ResetText();
dtNgaySinh.Value = DateTime.Now;
rdbNam.Checked = true;
txtDiaChi.ResetText();
cmbTaiKhoan.SelectedItem = "read_only";
}
public void clearControl()
{
string query = "select count(ID_Xe) from THONGTINXE";
DAL.sqlConnect sqlConn = new DAL.sqlConnect();
int count = int.Parse(sqlConn.execScanler(query));
txtID_Xe.Text = "X" + (count + 1).ToString();
cmbID_HangXe.ResetText();
cmbHangXe.ResetText();
txtBienSoXe.ResetText();
txtDoiXe.ResetText();
txtSoKhung.ResetText();
txtSoMay.ResetText();
txtSoKM.ResetText();
}
private void cmbTenKH_TextChanged(object sender, EventArgs e)
{
string key = cmbTenKH.Text.Trim();
cmbID_KhachHang.ResetText();
string query = "select ID_KhachHang from KHACHHANG where HoTen like '" + key + "%'";
DAL.sqlConnect sqlConn = new DAL.sqlConnect();
string value = sqlConn.execScanler(query);
cmbID_KhachHang.Text = value;
//SqlDataReader dr = sqlConn.execCommand(query);
//while (dr.Read())
//{
// cmbID_KhachHang.Text += dr["ID_KhachHang"].ToString();
//}
//sqlConn.closeConnection();
}