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