internal static UserPo GetUserPoFromUser(User user)
{
UserPo userPo = null;
if (!user.IsNullOrEmpty())
{
userPo = new UserPo
{
Id = user.Id,
UserName = user.UserName,
Password = user.Password,
IsAdmin = user.IsAdmin,
IsValid = user.IsValid,
CreateDate = user.CreateDate
};
}
return(userPo);
}
public User Post([FromForm] UserPo userPo)
{
Console.WriteLine("UserController Post");
var configuration = new MapperConfiguration(cfg =>
{
cfg.CreateMap <UserPo, User>();
});
IMapper mapper = configuration.CreateMapper();
User user = mapper.Map <User>(userPo);
user.CreateTime = new DateTime();
user = _userClient.RegistryUsers(user);
return(user);
}
internal static User GetUserFromUserPo(UserPo userPo)
{
User user = null;
if (!userPo.IsNullOrEmpty())
{
var roleDao = Container.CommonContainer.Resolve <IRoleDao>();
bool roleIsAdmin = roleDao.GetRoleList(userPo.Id).Any(rolePo => rolePo.IsAdmin);
user = new User
{
Id = userPo.Id,
UserName = userPo.UserName,
Password = userPo.Password,
IsAdmin = userPo.IsAdmin,
RoleIsAdmin = roleIsAdmin,
IsValid = userPo.IsValid,
CreateDate = userPo.CreateDate
};
}
return(user);
}
public void UpdateUser(UserPo user)
{
Mapper.GetMaper.Update("UpdateUser", user);
}
public int AddUser(UserPo user)
{
Object obj = Mapper.GetMaper.Insert("AddUser", user);
return((int)obj);
}
/// <summary>
/// SqlServer增删改查
/// </summary>
static void TestMSSql()
{
String username = "******";
String password = "******";
UserTable userTable = new UserTable();
Int32 i = 0;
for (i = 1; i < Int32.MaxValue; i++)
{
if (!userTable.IsExist(username + i.ToString()))
{
break;
}
}
User user1 = new User {
UserName = username + i.ToString(), PassWord = password
};
Console.WriteLine("{0} insert {1}", user1, userTable.Insert(user1));
User user2 = new User {
UserName = username + (i + 1).ToString(), PassWord = password
};
Console.WriteLine("{0} insert {1}", user2, userTable.InsertSafe(user2));
SQLServerHelper.ConnectionString = SQLServerHelper.GetConnectionStringByConfig();
// 插入
Boolean b = false;
User user = new User {
UserName = username + (i + 2).ToString(), PassWord = "******"
};
b = SQLServerHelper.Insert(user);
// 查询所有
List <User> list = SQLServerHelper.QueryAll <User>();
// 获取刚插入的一条
user = SQLServerHelper.QueryById <User, Int32>(list.Count);
user.PassWord = "******";
// 更新
//b = SQLServerHelper.Update(user); // !!!
b = SQLServerHelper.Update <User, Int32>(user, list.Count);
// 查询
user = SQLServerHelper.QueryById <User, Int32>(list.Count);
UserPo userPo = new UserPo(user);
user = SQLServerHelper.QueryById <User, Int32>(list.Count, SQLServerHelper.nameof(() => userPo.Id));
// 删除
//b = SQLServerHelper.Delete(user); // !!!
b = SQLServerHelper.Delete <User, Int32>(list.Count);
list = SQLServerHelper.QueryAll <User>();
}
