public UserInfo UpdateUserApi(Fish.OpenJudge.OpenPlatform.SDK.UserInfo apiInfo, int njustOjId, string AccessToken)
{
var userInfo = GetUserInfo(njustOjId);
if (userInfo == null)
{
userInfo = new UserInfo();
}
userInfo.NjustOjId = njustOjId;
userInfo.Type = 1;
userInfo.NjustOjName=apiInfo.Name;
userInfo.TrueName = apiInfo.NickName;
userInfo.AccessToken = AccessToken;
UpdateUserInfo(userInfo);
return userInfo;
}
public UserInfo UpdateUserName(UserInfo userInfo,int njustOjId)
{
var old = GetUserInfo(njustOjId);
userInfo.AccessToken = old.AccessToken;
userInfo.Type = old.Type;
userInfo.NjustOjId = old.NjustOjId;
userInfo.NjustOjName = old.NjustOjName;
if (userInfo.CfName!=null && old.CfName != userInfo.CfName)
{
var sto_cf = new OnlineContest.CodeforcesStorage();
sto_cf.UpdateRating(userInfo.CfName);
}
if (userInfo.TcName != null && old.TcName != userInfo.TcName)
{
var sto_tc = new OnlineContest.TopcoderStorage();
sto_tc.UpdateRating(userInfo.TcName);
}
UpdateUserInfo(userInfo);
return userInfo;
}
public void UpdateUserInfo(UserInfo userInfo)
{
storage.UpdateUserInfo(userInfo);
}
public static string UpdateUser(UserInfo user)
{
string sql = string.Format("REPLACE INTO `rank_in_all`.`user`"
+" (`njustoj_name`, `poj_name`, `hdoj_name`, `cf_name`, `tc_name`, `true_name`, `njustoj_id`, `token`, `type`) "
+"VALUES ('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', {6}, '{7}', {8});",
user.NjustOjName,user.PojName,user.HdojName,user.CfName,user.TcName,user.TrueName,user.NjustOjId,user.AccessToken,user.Type);
return sql;
}
/// <summary>
/// 更新一个用户的信息
/// </summary>
/// <param name="user_name"></param>
/// <returns></returns>
public void UpdateUserInfo(UserInfo userInfo)
{
mySqlCommand.CommandText = SQL.UpdateUser(userInfo);
mySqlCommand.ExecuteNonQuery();
}
/// <summary>
/// 获得一个用户的信息 根据njustoj-id
/// </summary>
/// <param name="njustoj_id"></param>
/// <returns></returns>
public UserInfo GetUserInfo(int njustoj_id)
{
mySqlCommand.CommandText = SQL.GetUser(njustoj_id);
UserInfo userinfo = null;
reader = mySqlCommand.ExecuteReader();
try
{
while (reader.Read())
{
userinfo = new UserInfo()
{
NjustOjName = reader.GetString("njustoj_name"),
PojName = CheckStringDBNull("poj_name"),
HdojName = CheckStringDBNull("hdoj_name"),
CfName = CheckStringDBNull("cf_name"),
TcName = CheckStringDBNull("tc_name"),
TrueName = CheckStringDBNull("true_name"),
NjustOjId = reader.GetInt32("njustoj_id"),
AccessToken = CheckStringDBNull("token"),
Type = reader.GetInt32("type")
};
}
}
catch (Exception)
{
Console.WriteLine("查询失败了！");
}
finally
{
reader.Close();
}
return userinfo;
}