コード例 #1
0
ファイル: Controller.cs プロジェクト: baiziyi008/iis_project
 /// <summary>
 /// 获取原包版本列表
 /// </summary>
 /// <param name="original_id"></param>
 /// <returns></returns>
 public List<table_repark_package_original_version> get_original_version_list_from_original(int original_id)
 {
     List<table_repark_package_original_version> versions = new List<table_repark_package_original_version>();
     string sql = "select * from repark_package_original_version where pkg_id=" + original_id + " order by id desc";
     SQLiteDataReader reader = SqliteManager.GetManager().get_reader(sql);
     if (reader != null)
     {
         while (reader.Read())
         {
             table_repark_package_original_version version = new table_repark_package_original_version();
             version.id = int.Parse(reader["id"].ToString());
             version.pkg_id = int.Parse(reader["pkg_id"].ToString());
             version.pkg_path = reader["pkg_path"].ToString();
             version.pkg_versioncode = reader["pkg_versioncode"].ToString();
             version.pkg_versionstring = reader["pkg_versionstring"].ToString();
             version.pkg_label = reader["pkg_label"].ToString();
             version.pkg_icon_path = reader["pkg_icon_path"].ToString();
             version.pkg_main_activity = reader["pkg_main_activity"].ToString();
             version.pkg_application_name = reader["pkg_application_name"].ToString();
             version.title = reader["title"].ToString();
             version.content = reader["content"].ToString();
             version.ctime = reader["ctime"].ToString();
             versions.Add(version);
         }
         reader.Close();
     }
     return versions;
 }
コード例 #2
0
ファイル: Controller.cs プロジェクト: baiziyi008/iis_project
        /// <summary>
        /// 获取原包版本信息
        /// </summary>
        /// <param name="versionid"></param>
        /// <returns></returns>
        public table_repark_package_original_version get_original_version(int versionid)
        {
            string sql = "select * from repark_package_original_version where id=" + versionid;
            SQLiteDataReader reader = SqliteManager.GetManager().get_reader(sql);
            if (reader != null)
            {
                if (reader.Read())
                {
                    table_repark_package_original_version version = new table_repark_package_original_version();
                    version.id = int.Parse(reader["id"].ToString());
                    version.pkg_id = int.Parse(reader["pkg_id"].ToString());
                    version.pkg_path = reader["pkg_path"].ToString();
                    version.pkg_versioncode = reader["pkg_versioncode"].ToString();
                    version.pkg_versionstring = reader["pkg_versionstring"].ToString();
                    version.pkg_label = reader["pkg_label"].ToString();
                    version.pkg_icon_path = reader["pkg_icon_path"].ToString();
                    version.pkg_main_activity = reader["pkg_main_activity"].ToString();
                    version.pkg_application_name = reader["pkg_application_name"].ToString();
                    version.title = reader["title"].ToString();
                    version.content = reader["content"].ToString();
                    version.ctime = reader["ctime"].ToString();
                    reader.Close();
                    return version;

                }
                reader.Close();
            }
            return null;
        }