/// <summary>
/// 获取分组列表
/// </summary>
/// <returns></returns>
public List<table_repark_group> get_group_list()
{
List<table_repark_group> objs = new List<table_repark_group>();
string sql = "select * from repark_group";
SQLiteDataReader reader = SqliteManager.GetManager().get_reader(sql);
if (reader != null)
{
while (reader.Read())
{
table_repark_group obj = new table_repark_group();
obj.id = int.Parse(reader["id"].ToString());
obj.uid = reader["uid"].ToString();
obj.title = reader["title"].ToString();
obj.content = reader["content"].ToString();
obj.ctime = reader["ctime"].ToString();
objs.Add(obj);
}
reader.Close();
}
return objs;
}
/// <summary>
/// 获取分组信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public table_repark_group get_group(int id)
{
string sql = "select * from repark_group where id=" + id;
SQLiteDataReader reader = SqliteManager.GetManager().get_reader(sql);
if (reader != null)
{
if (reader.Read())
{
table_repark_group obj = new table_repark_group();
obj.id = int.Parse(reader["id"].ToString());
obj.uid = reader["uid"].ToString();
obj.title = reader["title"].ToString();
obj.content = reader["content"].ToString();
obj.ctime = reader["ctime"].ToString();
reader.Close();
return obj;
}
reader.Close();
}
return null;
}
