public static bool EditUser(string userId, string userName)
{
string sql = "update UserInfo set UserName=@UserName where UserId=@UserId";
MySqlConnection con = new MySqlConnection(ConnectionString);
MySqlCommand cmd = new MySqlCommand(sql, con);
cmd.Parameters.Add("@UserName", MySqlDbType.VarString, 50).Value = userName.Trim();
cmd.Parameters.Add("@UserId", MySqlDbType.Int32).Value = userId;
int result = 0;
try
{
con.Open();
result = cmd.ExecuteNonQuery();
}
catch (MySqlException e)
{
Logger.Error("修改UserInfo出错。userId=" + userId + ", userName=" + userName, e);
}
finally
{
con.Close();
}
if (result > 0)
{
CacheFoxData.RefreshUserInfo();
}
return(result > 0);
}
public static bool DeleteUser(string userId)
{
string sql = "delete from UserInfo where UserId=@UserId";
MySqlConnection con = new MySqlConnection(ConnectionString);
MySqlCommand cmd = new MySqlCommand(sql, con);
cmd.Parameters.Add("@UserId", MySqlDbType.Int32).Value = userId;
int result = 0;
try
{
con.Open();
result = cmd.ExecuteNonQuery();
}
catch (MySqlException e)
{
Logger.Error("删除UserInfo出错。userId=" + userId, e);
}
finally
{
con.Close();
}
if (result > 0)
{
CacheFoxData.RefreshUserInfo();
}
return(result > 0);
}
public static string AddUser(string userName, string userRole)
{
string sql = "insert into UserInfo(UserName, UserRole) values(@UserName, @UserRole)";
MySqlConnection con = new MySqlConnection(ConnectionString);
MySqlCommand cmd = new MySqlCommand(sql, con);
cmd.Parameters.Add("@UserName", MySqlDbType.VarString, 50).Value = userName.Trim();
cmd.Parameters.Add("@UserRole", MySqlDbType.Int32).Value = userRole;
long result = 0;
try
{
con.Open();
cmd.ExecuteNonQuery();
result = cmd.LastInsertedId;
}
catch (MySqlException e)
{
Logger.Error("新增UserInfo出错。 userName=" + userName, e);
}
finally
{
con.Close();
}
if (result > 0)
{
CacheFoxData.RefreshUserInfo();
}
return(result.ToString());
}