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