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