public static ChamSocCollection SelectAll()
{
var List = new ChamSocCollection();
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblChamSoc_Select_SelectAll_linhnx"))
{
while (rd.Read())
{
List.Add(getFromReader(rd));
}
}
return(List);
}
public static ChamSocCollection SelectByKhId(SqlConnection con, string KhId)
{
var List = new ChamSocCollection();
var obj = new SqlParameter[2];
obj[0] = new SqlParameter("KH_ID", KhId);
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblChamSoc_Select_SelectByKhId_linhnx", obj))
{
while (rd.Read())
{
List.Add(getFromReader(rd));
}
}
return(List);
}
