Example #1
0
        public void SuaThongTin(EC_NhanVien EC_NV)
        {
            string a = "1995-12-12";

            connect.ThucHienLenh(@"update tblNhanVien set TenNV = N'" + EC_NV.TenNV + "', NgaySinh = '" + EC_NV.NgaySinh + "', GioiTinh = N'" + EC_NV.GioiTinh + "', CMND = '" + EC_NV.CMND + "', SoDT = '" + EC_NV.SoDT + "', DiaChi = N'" + EC_NV.DiaChi + "'  where MaNV = '" + EC_NV.MaNV + "'");
        }
Example #2
0
 public void XoaTTNhanVien(EC_NhanVien EC_NV)
 {
     connect.ThucHienLenh(@"delete from tblNhanVien where MaNV = '" + EC_NV.MaNV + "'");
     connect.ThucHienLenh(@"insert into tblNhanVien(MaNV) values('" + EC_NV.MaNV + "')");
 }
Example #3
0
        public void ThemThongTin(EC_NhanVien EC_NV)
        {
            string a = "1995-12-12";

            connect.ThucHienLenh(@"insert into tblNhanVien(MaNV, TenNV, NgaySinh, GioiTinh, CMND, DiaChi, SoDT) values(N'" + EC_NV.MaNV + "', N'" + EC_NV.TenNV + "', '" + EC_NV.NgaySinh + "', N'" + EC_NV.GioiTinh + "', '" + EC_NV.CMND + "', N'" + EC_NV.DiaChi + "', '" + EC_NV.SoDT + "') ");
        }