예제 #1
0
 public void TraPhong(EC_Phong EC_Ph)
 {
     connect.ThucHienLenh("update tblPhong set TrangThai = N'" + EC_Ph.TrangThai + "'  where MaPh = '" + EC_Ph.MaPh + "'");
 }
예제 #2
0
 public int SuaThongTin(EC_Phong EC_Ph)
 {
     return(connect.ThucHienLenh("update tblPhong set SoPhong = N'" + EC_Ph.SoPhong + "', TrangThai = N'" + EC_Ph.TrangThai + "'  where MaPh = '" + EC_Ph.MaPh + "'"));
 }
예제 #3
0
 public int XoaTTPhong(EC_Phong EC_Ph)
 {
     return(connect.ThucHienLenh("delete from tblPhong where MaPh = '" + EC_Ph.MaPh + "'"));
 }
예제 #4
0
 public int ThemThongTin(EC_Phong EC_Ph)
 {
     return(connect.ThucHienLenh("insert into tblPhong(MaPh,SoPhong,TrangThai) values(N'" + EC_Ph.MaPh + "', N'" + EC_Ph.SoPhong + "', N'" + EC_Ph.TrangThai + "') "));
 }