/// <summary> /// 获取SDK列表 /// </summary> /// <returns></returns> public List<table_repark_sdk> get_sdk_list() { List<table_repark_sdk> sdks = new List<table_repark_sdk>(); string sql = "select * from repark_sdk order by id desc"; SQLiteDataReader reader = SqliteManager.GetManager().get_reader(sql); if (reader != null) { while (reader.Read()) { table_repark_sdk sdk = new table_repark_sdk(); sdk.id = int.Parse(reader["id"].ToString()); sdk.uid = reader["uid"].ToString(); sdk.gid = reader["gid"].ToString(); sdk.sdk_title = reader["sdk_title"].ToString(); sdk.sdk_content = reader["sdk_content"].ToString(); sdk.ctime = reader["ctime"].ToString(); sdk.sdk_versioncode = reader["sdk_versioncode"].ToString(); sdk.sdk_path = reader["sdk_path"].ToString(); sdk.sdk_codeclass = reader["sdk_codeclass"].ToString(); sdks.Add(sdk); } reader.Close(); } return sdks; }
/// <summary> /// 获取SDK信息 /// </summary> /// <param name="id"></param> /// <returns></returns> public table_repark_sdk get_sdk(int id) { string sql = "select * from repark_sdk where id=" + id; SQLiteDataReader reader = SqliteManager.GetManager().get_reader(sql); if (reader != null) { if (reader.Read()) { table_repark_sdk sdk = new table_repark_sdk(); sdk.id = int.Parse(reader["id"].ToString()); sdk.uid = reader["uid"].ToString(); sdk.gid = reader["gid"].ToString(); sdk.sdk_title = reader["sdk_title"].ToString(); sdk.sdk_content = reader["sdk_content"].ToString(); sdk.ctime = reader["ctime"].ToString(); sdk.sdk_versioncode = reader["sdk_versioncode"].ToString(); sdk.sdk_path = reader["sdk_path"].ToString(); sdk.sdk_codeclass = reader["sdk_codeclass"].ToString(); reader.Close(); return sdk; } reader.Close(); } return null; }