public HoaDonDichVuInfo HoaDonDichVu_GetItem(int HoaDon_DichVuID) { SQLDataHelper SQLDB = new SQLDataHelper(); SQLDB.Addparameter("@HoaDon_DichVuID", HoaDon_DichVuID); SqlDataReader rd = SQLDB.executereader("sp_HoaDonDichVu_GetItem", CommandType.StoredProcedure); HoaDonDichVuInfo item = null; while (rd.Read()) { item = new HoaDonDichVuInfo(); item.HoaDon_DichVuID = int.Parse(rd["HoaDon_DichVuID"].ToString()); item.HoaDonID = int.Parse(rd["HoaDonID"].ToString()); item.PhongID = int.Parse(rd["PhongID"].ToString()); item.DichVuID = int.Parse(rd["DichVuID"].ToString()); item.KhachHangID = int.Parse(rd["KhachHangID"].ToString()); item.NgaySuDung = rd["NgaySuDung"].ToString(); item.SoLuong = int.Parse(rd["SoLuong"].ToString()); item.DonGia = decimal.Parse(rd["DonGia"].ToString()); item.TongTien = decimal.Parse(rd["TongTien"].ToString()); } return item; }
public List<HoaDonDichVuInfo> HoaDonDichVu_GetItems([Optional, DefaultParameterValue(0)] int HoaDon_DichVuID) { SQLDataHelper SQLDB = new SQLDataHelper(); SQLDB.Addparameter("@HoaDon_DichVuID", HoaDon_DichVuID); SqlDataReader rd = SQLDB.executereader("sp_HoaDonDichVu_GetItems", CommandType.StoredProcedure); List<HoaDonDichVuInfo> list = new List<HoaDonDichVuInfo>(); HoaDonDichVuInfo item = null; while (rd.Read()) { item = new HoaDonDichVuInfo(); item.HoaDon_DichVuID = int.Parse(rd["HoaDon_DichVuID"].ToString()); item.HoaDonID = int.Parse(rd["HoaDonID"].ToString()); item.PhongID = int.Parse(rd["PhongID"].ToString()); item.DichVuID = int.Parse(rd["DichVuID"].ToString()); item.KhachHangID = int.Parse(rd["KhachHangID"].ToString()); item.HoTen = rd["HoTen"].ToString(); item.PhongName = rd["PhongName"].ToString(); item.DichVuName = rd["DichVuName"].ToString(); item.NgaySuDung = rd["NgaySuDung"].ToString(); item.SoLuong = int.Parse(rd["SoLuong"].ToString()); item.DonGia = decimal.Parse(rd["DonGia"].ToString()); item.TongTien = decimal.Parse(rd["TongTien"].ToString()); list.Add(item); } return list; }