示例#1
0
 public void SuaDuLieu(EC_Dangky ec)
 {
     cn.ThucHienCauLenh("UPDATE DangKy SET  MaPhong = '" + ec.Maphong + "', TenKhach = '" + ec.Tenkhach + "', SDT = '" + ec.SDT + "',NgayDky='" + ec.Ngaydky + "',NgayNhan='" + ec.Ngaynhan + "' WHERE   MaPhieuDky = '" + ec.Maphieu + "'");
 }
示例#2
0
 public int XoaDulieu(EC_Dangky ec)
 {
     return(cn.Query("delete from DangKy where MaPhieuDky = '" + ec.Maphieu + "'"));
 }
示例#3
0
 public void ThemPhieu(EC_Dangky ec)
 {
     cn.ThucHienCauLenh("INSERT INTO DangKy (MaPhieuDky, MaPhong, TenKhach, SDT, NgayDky, NgayNhan)VALUES(N'" + ec.Maphieu + "', N'" + ec.Maphong + "', N'" + ec.Tenkhach + "', N'" + ec.SDT + "', CONVERT(DATETIME, '" + ec.Ngaydky + "', 102), CONVERT(DATETIME, '" + ec.Ngaynhan + "', 102))");
 }
示例#4
0
 public void SuaDuLieu(EC_Dangky ec)
 {
     sql.SuaDuLieu(ec);
 }
示例#5
0
 public void XoaduLieu(EC_Dangky ec)
 {
     sql.XoaDulieu(ec);
 }
示例#6
0
 public void ThemDuLieu(EC_Dangky ec)
 {
     sql.ThemPhieu(ec);
 }