public static ARAgentSettleCollection Search(SearchFilter SearchKey) { ARAgentSettleCollection collection = new ARAgentSettleCollection(); using (var reader = SqlHelper.ExecuteReader("ARAgentSettle_Search", SearchFilterManager.SqlSearchParam(SearchKey))) { while (reader.Read()) { ARAgentSettle obj = new ARAgentSettle(); obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }
public static ARAgentSettleCollection GetbyUser(string CreatedUser, int CompanyID) { ARAgentSettleCollection collection = new ARAgentSettleCollection(); ARAgentSettle obj; var sqlParams = new SqlParameter[] { new SqlParameter("@CreatedUser", CreatedUser), new SqlParameter("@CompanyID", CompanyID), }; using (var reader = SqlHelper.ExecuteReader("ARAgentSettle_GetAll_byUser", sqlParams)) { while (reader.Read()) { obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }