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)); }