private TmUser GetUserByUserName(string username)
{
MySqlCommand mySqlCommand = new MySqlCommand("select * from " + SoulName + " where username = '******'", TmMysqlConnection.Connection);//读取数据函数
MySqlDataReader reader = mySqlCommand.ExecuteReader();
try
{
TmUser item = new TmUser();
while (reader.Read())
{
if (reader.HasRows)
{
item.Id = reader.GetInt32(0);
item.Username = reader.GetString(1);
item.Password = reader.GetString(2);
item.Serverid = reader.GetInt32(3);
item.Phone = reader.GetString(4);
item.Qq = reader.GetString(5);
item.LoginCount = reader.GetInt32(6);
item.LoginDateTime = reader.GetString(7);
item.RigisterDateTime = reader.GetString(8);
}
}
return(item);
}
catch (Exception)
{
Console.WriteLine("查询失败...");
return(null);
}
finally
{
reader.Close();
}
} //得到user用户 //读取表格
public void ReturnsTrueForNullWhenNull()
{
TmUser tmUser = null;
var result = tmUser == null;
result.Should().Be(true);
}
private void GetTmUserByName(object sender, TmParameter parameter)
{
string name = TmParameterTool.GetValue <string>(parameter, "Username");
TmUser user2 = GetUserByUserName(name);
if (user2 != null)
{
(sender as TmUserHandler).User = user2;
}
}
public void ReturnsTrue(TmNativeDefs.IfaceUser ifaceUser)
{
Encoding.RegisterProvider(CodePagesEncodingProvider.Instance);
var tmUser1 = TmUser.CreateFromIfaceUser(ifaceUser);
var tmUser2 = TmUser.CreateFromIfaceUser(ifaceUser);
var result = tmUser1.Equals(tmUser2);
result.Should().Be(true);
}
public void ReturnFalseForNull(TmNativeDefs.IfaceUser ifaceUser)
{
Encoding.RegisterProvider(CodePagesEncodingProvider.Instance);
var tmUser = TmUser.CreateFromIfaceUser(ifaceUser);
var result = tmUser.Equals(null);
result.Should().Be(false);
}
public void ReturnsFalseForWrongComment(byte[] comment, TmNativeDefs.IfaceUser ifaceUser)
{
Encoding.RegisterProvider(CodePagesEncodingProvider.Instance);
var tmUser1 = TmUser.CreateFromIfaceUser(ifaceUser);
ifaceUser.Comment = comment;
var tmUser2 = TmUser.CreateFromIfaceUser(ifaceUser);
var result = tmUser1.Equals(tmUser2);
result.Should().Be(false);
}
public void ReturnsFalseForWrongHandle(TmNativeDefs.IfaceUser ifaceUser)
{
Encoding.RegisterProvider(CodePagesEncodingProvider.Instance);
var tmUser1 = TmUser.CreateFromIfaceUser(ifaceUser);
ifaceUser.Handle += 1;
var tmUser2 = TmUser.CreateFromIfaceUser(ifaceUser);
var result = tmUser1 == tmUser2;
result.Should().Be(false);
}
public void ReturnsFalseForWrongCreationTime(int creationTimeStamp, TmNativeDefs.IfaceUser ifaceUser)
{
Encoding.RegisterProvider(CodePagesEncodingProvider.Instance);
var tmUser1 = TmUser.CreateFromIfaceUser(ifaceUser);
ifaceUser.CreationTime = creationTimeStamp;
var tmUser2 = TmUser.CreateFromIfaceUser(ifaceUser);
var result = tmUser1 == tmUser2;
result.Should().Be(false);
}
public void ReturnsFalseForWrongParentProcessId(TmNativeDefs.IfaceUser ifaceUser)
{
Encoding.RegisterProvider(CodePagesEncodingProvider.Instance);
var tmUser1 = TmUser.CreateFromIfaceUser(ifaceUser);
ifaceUser.Pid += 1;
var tmUser2 = TmUser.CreateFromIfaceUser(ifaceUser);
var result = tmUser1.Equals(tmUser2);
result.Should().Be(false);
}
public void SetsCorrectValues(byte[] name,
byte[] comment,
int creationTime,
string expectedName,
string expectedComment)
{
Encoding.RegisterProvider(CodePagesEncodingProvider.Instance);
var ifaceUser = A.Dummy <TmNativeDefs.IfaceUser>();
ifaceUser.Name = name;
ifaceUser.Comment = comment;
ifaceUser.CreationTime = creationTime;
var tmUser = TmUser.CreateFromIfaceUser(ifaceUser);
tmUser.Name.Should().Be(expectedName);
tmUser.Comment.Should().Be(expectedComment);
tmUser.CreationTime.Should().Be(DateUtil.GetDateTimeFromTimestamp(creationTime));
}
