public static BanHang_ChiPhiChiTietCollection SelectAll() { var List = new BanHang_ChiPhiChiTietCollection(); using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblBanHang_ChiPhiChiTiet_Select_SelectAll_linhnx")) { while (rd.Read()) { List.Add(getFromReader(rd)); } } return(List); }
public static BanHang_ChiPhiChiTietCollection SelectByBHCP(SqlConnection con, Int64 BHCP) { var List = new BanHang_ChiPhiChiTietCollection(); var obj = new SqlParameter[1]; obj[0] = new SqlParameter("BHCP", BHCP); using (IDataReader rd = SqlHelper.ExecuteReader(con, CommandType.StoredProcedure, "sp_tblBanHang_ChiPhiChiTiet_Select_SelectByBHCP_linhnx", obj)) { while (rd.Read()) { List.Add(getFromReader(rd)); } } return(List); }