public GroupInfo Group_GetItem(int GroupID)
{
SQLDataHelper SQLDB = new SQLDataHelper();
SQLDB.Addparameter("@GroupID", GroupID);
SqlDataReader rd = SQLDB.executereader("sp_Group_GetItem", CommandType.StoredProcedure);
GroupInfo item = null;
while (rd.Read())
{
item = new GroupInfo();
item.GroupID = int.Parse(rd["GroupID"].ToString());
item.GroupName = rd["GroupName"].ToString();
item.Descriptions = rd["Descriptions"].ToString();
item.IsActived = int.Parse(rd["IsActived"].ToString());
}
return item;
}
public List<GroupInfo> Group_GetActivedItems()
{
SQLDataHelper SQLDB = new SQLDataHelper();
SqlDataReader rd = SQLDB.executereader("sp_Group_GetActivedItems", CommandType.StoredProcedure);
List<GroupInfo> list = new List<GroupInfo>();
GroupInfo item = null;
while (rd.Read())
{
item = new GroupInfo();
item.GroupID = int.Parse(rd["GroupID"].ToString());
item.GroupName = rd["GroupName"].ToString();
list.Add(item);
}
return list;
}
