public async static Task <RoleDbInfo> GetUserDbInfo(this SqlComponent self, int UserId)
{
string sql = "select * from User_Info where UserId = @UserId";
using (var db = self.GetDBConnection())
{
var ret = await db.QueryFirstOrDefaultAsync <UserInfo>(sql, new { UserId });
if (ret == null)
{
return(new RoleDbInfo());
}
else
{
RoleDbInfo role = RoleDbInfo.Parser.ParseFrom(ret.UserData);
return(role);
}
}
}
public async static Task <bool> SaveUserDbInfo(this SqlComponent self, int UserId, RoleDbInfo data)
{
string sql = "Update User_Info Set UserData=@UserData where UserId = @UserId";
using (var db = self.GetDBConnection())
{
var param = new { UserData = data.ToByteArray(), UserId = UserId };
var row = await db.ExecuteAsync(sql, param);
if (row == 0)
{
sql = "Insert User_Info (UserId,UserData)values(@UserId,@UserData)";
row = await db.ExecuteAsync(sql, param);
return(row == 1);
}
else
{
return(true);
}
}
}
