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); }