public static DichVuChiTietCollection SelectAll()
{
var List = new DichVuChiTietCollection();
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblSpaMgr_DichVuChiTiet_Select_SelectAll_linhnx"))
{
while (rd.Read())
{
List.Add(getFromReader(rd));
}
}
return(List);
}
public static DichVuChiTietCollection SelectByDvId(SqlConnection con, string DV_ID)
{
var List = new DichVuChiTietCollection();
var obj = new SqlParameter[1];
if (!string.IsNullOrEmpty(DV_ID))
{
obj[0] = new SqlParameter("DV_ID", DV_ID);
}
else
{
obj[0] = new SqlParameter("DV_ID", DBNull.Value);
}
using (IDataReader rd = SqlHelper.ExecuteReader(con, CommandType.StoredProcedure, "sp_tblSpaMgr_DichVuChiTiet_Select_SelectByDvId_linhnx", obj))
{
while (rd.Read())
{
List.Add(getFromReader(rd));
}
}
return(List);
}
