//================delete data
public void XoaDuLieu(EC_ThongTinNo etn)
{
cn.ThucThiSQL("DELETE FROM ThongTinNo where IDThongTin=" + etn.IDThongTin);
}
//================ update data
public void SuaDuLieu(EC_ThongTinNo etn)
{
cn.ThucThiSQL("UPDATE ThongTinNo SET DaThanhToan=1 where IDThongTin=" + etn.IDThongTin);
}
//===============thêm data (insert)===================
public void ThemDuLieu(EC_ThongTinNo etn)
{
SQLN = @"INSERT INTO ThongTinNo (SoPhieu, NgayNo, MaPhong, NguoiNo, DaThanhToan, Phone, DiaChi, SoTien, GhiChu)
VALUES ('" + etn.SoPhieu + "',CONVERT(datetime,'" + etn.NgayNo + "',103)," + etn.MaPhong + ",'" + etn.NguoiNo + "',0,'" + etn.Phone + "',N'" + etn.DiaChi + "'," + etn.SoTien + ",N'" + etn.GhiChu + "')";
cn.ThucThiSQL(SQLN);
}
// delete data
public void XoaDuLieu(EC_ThongTinNo et)
{
SQL.XoaDuLieu(et);
}
//-------- update data
public void SuaDuLieu(EC_ThongTinNo et)
{
SQL.SuaDuLieu(et);
}
public void ThemDuLieu(EC_ThongTinNo et)
{
SQL.ThemDuLieu(et);
}
