Exemplo n.º 1
0
 /// <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;
 }
Exemplo n.º 2
0
        /// <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;
        }