public static NhomCollection SelectAll(SqlConnection con) { NhomCollection List = new NhomCollection(); using (IDataReader rd = SqlHelper.ExecuteReader(con, CommandType.StoredProcedure, "tblRss_sp_tblRssNhom_Select_SelectAll_linhnx")) { while (rd.Read()) { List.Add(getFromReader(rd)); } } return(List); }
public static NhomCollection SelectByDm(SqlConnection con, string DM_Ma) { NhomCollection List = new NhomCollection(); SqlParameter[] obj = new SqlParameter[1]; obj[0] = new SqlParameter("DM_Ma", DM_Ma); using (IDataReader rd = SqlHelper.ExecuteReader(con, CommandType.StoredProcedure, "tblRss_sp_tblRssNhomTin_Select_SelectByDm_linhnx", obj)) { while (rd.Read()) { List.Add(getFromReader(rd)); } } return(List); }
public static NhomCollection SelectByTin(string T_ID) { NhomCollection List = new NhomCollection(); SqlParameter[] obj = new SqlParameter[1]; obj[0] = new SqlParameter("T_ID", T_ID); using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "tblRss_sp_tblRssNhomTin_Select_SelectByTin_linhnx", obj)) { while (rd.Read()) { List.Add(getFromReader(rd)); } } return(List); }