public static bool UpdateUdpEndPoint(string ip, int port, string uid)
{
var sql = $"update userinfo set udpip='{ip}',udp_port={port},create_date='{DateTime.Now}' where id={uid}";
var ret = MysqlTool.ExecuteNonQuery(sql);
return(ret > 0);
}
public static bool UpdateLoginState(int loginState)
{
var sql = "update userinfo set login_state=@login_state";
var param = new MySqlParameter[1]
{
new MySqlParameter("login_state", loginState),
};
var ret = MysqlTool.ExecuteNonQuery(sql, param);
return(ret > 0);
}
public static bool Add(UserInfoModel model, int loginState = 0)
{
var sql = "insert into userinfo(username,userpass,nickname,login_state) values(@username,@userpass,@nickname,@loginState)";
var param = new MySqlParameter[4];
param[0] = new MySqlParameter("username", model.username);
param[1] = new MySqlParameter("userpass", model.userpass);
param[2] = new MySqlParameter("nickname", model.nickname);
param[3] = new MySqlParameter("loginState", loginState);
var ret = MysqlTool.ExecuteNonQuery(sql, param);
return(ret > 0);
}