/// <summary>
/// 获取渠道列表
/// </summary>
/// <returns></returns>
public List<table_repark_channel> get_channel_list()
{
List<table_repark_channel> objs = new List<table_repark_channel>();
string sql = "select * from repark_channel order by id desc";
SQLiteDataReader reader = SqliteManager.GetManager().get_reader(sql);
if (reader != null)
{
while (reader.Read())
{
table_repark_channel obj = new table_repark_channel();
obj.id = int.Parse(reader["id"].ToString());
obj.uid = reader["uid"].ToString();
obj.gid = reader["gid"].ToString();
obj.channel_name = reader["channel_name"].ToString();
obj.channel_sign = reader["channel_sign"].ToString();
obj.ctime = reader["ctime"].ToString();
objs.Add(obj);
}
reader.Close();
}
return objs;
}
/// <summary>
/// 获取渠道信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public table_repark_channel get_channel(int id)
{
string sql = "select * from repark_channel where id=" + id;
SQLiteDataReader reader = SqliteManager.GetManager().get_reader(sql);
if (reader != null)
{
if (reader.Read())
{
table_repark_channel obj = new table_repark_channel();
obj.id = int.Parse(reader["id"].ToString());
obj.uid = reader["uid"].ToString();
obj.gid = reader["gid"].ToString();
obj.channel_name = reader["channel_name"].ToString();
obj.channel_sign = reader["channel_sign"].ToString();
obj.ctime = reader["ctime"].ToString();
reader.Close();
return obj;
}
reader.Close();
}
return null;
}
