Example #1
0
 /// <summary>
 /// 获取签名列表
 /// </summary>
 /// <returns></returns>
 public List<table_repark_keystore> get_keystore_list()
 {
     List<table_repark_keystore> objs = new List<table_repark_keystore>();
     string sql = "select * from repark_keystore order by id desc";
     SQLiteDataReader reader = SqliteManager.GetManager().get_reader(sql);
     if (reader != null)
     {
         while (reader.Read())
         {
             table_repark_keystore obj = new table_repark_keystore();
             obj.id = int.Parse(reader["id"].ToString());
             obj.uid = reader["uid"].ToString();
             obj.gid = reader["gid"].ToString();
             obj.title = reader["title"].ToString();
             obj.path = reader["path"].ToString();
             obj.ctime = reader["ctime"].ToString();
             obj.alias = reader["alias"].ToString();
             obj.pwd1 = reader["pwd1"].ToString();
             obj.pwd2 = reader["pwd2"].ToString();
             obj.md5 = reader["md5"].ToString();
             objs.Add(obj);
         }
         reader.Close();
     }
     return objs;
 }
Example #2
0
        /// <summary>
        /// 获取签名信息
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public table_repark_keystore get_keystore(int id)
        {
            string sql = "select * from repark_keystore where id=" + id;
            SQLiteDataReader reader = SqliteManager.GetManager().get_reader(sql);
            if (reader != null)
            {
                if (reader.Read())
                {
                    table_repark_keystore obj = new table_repark_keystore();
                    obj.id = int.Parse(reader["id"].ToString());
                    obj.uid = reader["uid"].ToString();
                    obj.gid = reader["gid"].ToString();
                    obj.title = reader["title"].ToString();
                    obj.path = reader["path"].ToString();
                    obj.ctime = reader["ctime"].ToString();
                    obj.alias = reader["alias"].ToString();
                    obj.pwd1 = reader["pwd1"].ToString();
                    obj.pwd2 = reader["pwd2"].ToString();
                    obj.md5 = reader["md5"].ToString();
                    reader.Close();
                    return obj;

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