コード例 #1
0
 public void SuaDuLieu(EC_NhanPhong ec)
 {
     sql.SuaDuLieu(ec);
 }
コード例 #2
0
 public void XoaduLieu(EC_NhanPhong ec)
 {
     sql.XoaDulieu(ec);
 }
コード例 #3
0
 public void ThemDuLieu(EC_NhanPhong ec)
 {
     sql.Themdulieu(ec);
 }
コード例 #4
0
 public void SuaDuLieu(EC_NhanPhong ec)
 {
     cn.ThucHienCauLenh("UPDATE NhanPhong1 SET  MaPhieuDky = '" + ec.MaDky + "', TenKhach = '" + ec.TenKhach + "', SDT = '" + ec.SDT + "',MaPhong='" + ec.MaPhong + "',CMND='" + ec.CMND + "',DiaChi='" + ec.DiaChi + "',NgayNhan='" + ec.NgayNhan + "',NgayTra='" + ec.NgayTra + "' WHERE   MaPhieuDky = '" + ec.MaPhieu + "'");
 }
コード例 #5
0
 public int XoaDulieu(EC_NhanPhong ec)
 {
     return(cn.Query("delete from NhanPhong1 where MaPhieuNhan = '" + ec.MaPhieu + "'"));
 }
コード例 #6
0
 public void Themdulieu(EC_NhanPhong ec)
 {
     cn.ThucHienCauLenh("INSERT INTO NhanPhong1 (MaPhieuDKy, MaPhieuNhan, MaPhong, TenKhach, SDT, CMND, DiaChi, NgayNhan, NgayTra)VALUES(N'" + ec.MaDky + "', N'" + ec.MaPhieu + "', N'" + ec.MaPhong + "', N'" + ec.TenKhach + "', N'" + ec.SDT + "', N'" + ec.CMND + "', N'" + ec.DiaChi + "', '" + ec.NgayNhan + "', '" + ec.NgayTra + "')");
 }