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