public static ComUserGroupCollection GetAllItem() { ComUserGroupCollection collection = new ComUserGroupCollection(); using (var reader = SqlHelper.ExecuteReader("tblComUserGroup_GetAll", null)) { while (reader.Read()) { ComUserGroup obj = new ComUserGroup(); obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }
public static ComUserGroupCollection GetItemByGroup(string GroupCode) { ComUserGroupCollection collection = new ComUserGroupCollection(); var sqlParams = new SqlParameter[1]; sqlParams[0] = new SqlParameter("@GroupCode", GroupCode); using (var reader = SqlHelper.ExecuteReader("tblComUserGroup_GetByGroupCode", sqlParams)) { while (reader.Read()) { ComUserGroup obj = new ComUserGroup(); obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }