public void Put(string id, [FromBody] UserModle user)
{
var guid = Guid.Parse(id);
user.Id = guid;
_userRepository.UpdateUser(user);
}
/// <summary>
/// 用户列表
/// </summary>
/// <returns></returns>
public List <UserModle> getUserList()
{
List <UserModle> listUser = new List <UserModle>();
string sql = "select * from [user] where 1=@queryAll ";
SqlParameter[] sqlParameters =
{
new SqlParameter("@queryAll", 1)
};
SqlDataReader sqlDataReader = Utility.Sql.Sqlhelper.GetSqlDataReader(sql,
DataSourceType.business, sqlParameters);
while (sqlDataReader.Read())
{
UserModle m = new UserModle();
m.userID = sqlDataReader["userID"].ToString();
m.name = sqlDataReader["name"].ToString();
listUser.Add(m);
}
return(listUser);
}
/// <summary>
/// 保存单据
/// </summary>
protected override void saveDate()
{
using (var db = new NoteBookContext())
{
UserModle m = new UserModle();
m.userID = base.txt_userID.Text;
m.name = base.txt_userName.Text;
m.pwd = Encrypt.Encode(base.txt_pwd.Text);
m.RegistrationDate = Convert.ToDateTime(base.tbd_effect.Text);
if (base.tbd_failure.Text != null & base.tbd_failure.Text != "")
{
m.DateOfCancellation = Convert.ToDateTime(base.tbd_failure.Text);
}
db.Users.Add(m);
try
{
db.SaveChanges();
}
catch (Exception ex)
{
MessageBox.Show("数据保存错误:" + ex.Message + ex.InnerException, "数据保存提示");
return;
}
mList.Add(m);
}
}
public void AddUser_UserMissAge()
{
var user = new UserModle
{
FirstName = "FirstName",
LastName = "Last name",
Addresses = new List <string> {
"address"
}
};
var actual = _target.AddUser(user);
}
protected override void adminSetUp()
{
using (var db = new TestContext())
{
UserModle m = new UserModle();
m.userID = base.txt_adminCode.Text;
m.name = base.txt_adminName.Text;
m.pwd = base.txt_adminPwd.Text;
m.RegistrationDate = DateTime.Now;
db.Users.Add(m);
db.SaveChanges();
}
}
public void AddUser_IDataTableContext_Throw()
{
var user = new UserModle
{
Age = 5,
FirstName = "First name",
LastName = "Last name",
Addresses = new List <string> {
"address"
}
};
_tableContext.Stub(table =>
table.ExecuteScalar(Arg <string> .Is.Anything,
Arg <CommandType> .Is.Anything,
Arg <SqlParameter> .Is.Anything)).Throw(new Exception());
var actual = _target.AddUser(user);
}
public void AddUser_AddSuccess()
{
var user = new UserModle
{
Age = 18,
FirstName = "First name",
LastName = "Last name",
Addresses = new List <string> {
"address"
}
};
var expected = Guid.NewGuid();
_tableContext.Stub(table =>
table.ExecuteScalar(Arg <string> .Is.Anything,
Arg <CommandType> .Is.Anything,
Arg <SqlParameter> .Is.Anything)).Return(expected);
var actual = _target.AddUser(user);
Assert.IsNotNull(actual);
Assert.AreEqual(expected, actual);
}
public void Post([FromBody] UserModle user)
{
_userRepository.AddUser(user);
}
