public User GetUser(string userid) { var sql = $"select * from {CoreCommon.Table_User} where {nameof(User.UserID)} = '{userid}' "; var result = SQLiteCore.SqlRow(sql); if (result.Length == 3) { return(new User() { UserID = result[0], Password = result[1], Salt = result[2] }); } return(null); }
public UserSecret Get(string id) { var sql = $"SELECT * FROM {CoreCommon.Table_Secret} WHERE {nameof(UserSecret.Id)} = '{id}'"; var result = SQLiteCore.SqlRow(sql); if (result != null && result.Length == 6) { var model = new UserSecret() { Id = result[0], UserID = result[1], Password = result[2], Salt = result[3], Type = result[4], Remark = result[5] }; return(model); } return(null); }