コード例 #1
0
 public void XoaDuLieu(ECtblNhanVien et)
 {
     sql.XoaDuLieu(et);
 }
コード例 #2
0
 public void SuaDuLieu(ECtblNhanVien et)
 {
     sql.SuaDuLieu(et);
 }
コード例 #3
0
 public void ThemDuLieu(ECtblNhanVien et)
 {
     sql.ThemDuLieu(et);
 }
コード例 #4
0
 public void XoaDuLieu(ECtblNhanVien et)
 {
     cn.ThucThiCauLenhSQL(@"DELETE from tblNhanVien where MaNV=N'" + et.MaNV + "'");
 }
コード例 #5
0
 public void SuaDuLieu(ECtblNhanVien et)
 {
     cn.ThucThiCauLenhSQL(@"UPDATE tblNhanVien SET TenNV =N'" + et.TenNV + "', DiaChi =N'" + et.DiaChi + "', DienThoai =N'" + et.DienThoai + "', TinhTrang = N'" + et.TinhTrang + "', TenDN ='" + et.TenDN + "', MatKhau ='" + et.MatKhau + "' where MaNV=N'" + et.MaNV + "'");
 }
コード例 #6
0
 public void ThemDuLieu(ECtblNhanVien et)
 {
     cn.ThucThiCauLenhSQL(@"INSERT INTO tblNhanVien (MaNV, TenNV, DiaChi, DienThoai, TinhTrang, TenDN, MatKhau ) VALUES(N'" + et.MaNV + "',N'" + et.TenNV + "',N'" + et.DiaChi + "',N'" + et.DienThoai + "',N'" + et.TinhTrang + "',N'" + et.TenDN + "','" + et.MatKhau + "')");
 }