public GroupInfo GroupInfoIDataReader(IDataReader dr)
{
GroupInfo obj = new DataAccess.GroupInfo();
obj.GroupID = (dr["GroupID"] is DBNull) ? string.Empty : dr["GroupID"].ToString();
obj.ParentID = (dr["ParentID"] is DBNull) ? string.Empty : dr["ParentID"].ToString();
obj.GroupName = (dr["GroupName"] is DBNull) ? string.Empty : dr["GroupName"].ToString();
obj.Description = (dr["Description"] is DBNull) ? string.Empty : dr["Description"].ToString();
obj.Status = (dr["Status"] is DBNull) ? string.Empty : dr["Status"].ToString();
obj.Priority = (dr["Priority"] is DBNull) ? string.Empty : dr["Priority"].ToString();
obj.Lang = (dr["Lang"] is DBNull) ? string.Empty : dr["Lang"].ToString();
return(obj);
}
public List <GroupInfo> GroupInfo_GetByLevel(string Level, int LevelLength)
{
List <DataAccess.GroupInfo> list = new List <DataAccess.GroupInfo>();
DataAccess.GroupInfo obj = new DataAccess.GroupInfo();
DbCommand cmd = db.GetStoredProcCommand("sp_GroupInfo_GetByLevel", Level, LevelLength);
using (IDataReader dr = db.ExecuteReader(cmd))
{
while (dr.Read())
{
list.Add(obj.GroupInfoIDataReader(dr));
}
dr.Close();
dr.Dispose();
}
return(list);
}
public List <GroupInfo> GroupInfo_GetByAll()
{
List <DataAccess.GroupInfo> list = new List <DataAccess.GroupInfo>();
DataAccess.GroupInfo obj = new DataAccess.GroupInfo();
DbCommand cmd = db.GetStoredProcCommand("Group_SelectAll");
using (IDataReader dr = db.ExecuteReader(cmd))
{
while (dr.Read())
{
list.Add(obj.GroupInfoIDataReader(dr));
}
dr.Close();
dr.Dispose();
}
return(list);
}
public List <GroupInfo> GroupInfo_Paging(string CurentGroupInfo, string GroupInfoSize)
{
List <DataAccess.GroupInfo> list = new List <DataAccess.GroupInfo>();
DataAccess.GroupInfo obj = new DataAccess.GroupInfo();
DbCommand cmd = db.GetStoredProcCommand("Group_SelectPage", CurentGroupInfo, GroupInfoSize);
using (IDataReader dr = db.ExecuteReader(cmd))
{
while (dr.Read())
{
list.Add(obj.GroupInfoIDataReader(dr));
}
dr.Close();
dr.Dispose();
}
return(list);
}
