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