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