public Task <bool> InsertAsync(Base_UserEntity entity)
{
Sys_UserEntity user = new Sys_UserEntity();
var t10 = _sugarFactory.GetInstance(_options.First().ConnectionString, _options.First().ProviderName).Updateable <Base_UserEntity>()
.UpdateColumns(it => new { it.OpenId, it.Account })
.Where(it => it.UserId == entity.UserId).ExecuteCommand();
return(Task.FromResult(_sugarFactory.GetInstance(_options.First().ConnectionString, _options.First().ProviderName).Insertable(entity)
.ExecuteCommandIdentityIntoEntity()));
}
public int InsertUser(Sys_UserEntity sys_UserEntity)
{
string sql = "INSERT INTO Sys_User ( UserCode, UserPassWord, UserName, UserMail ) VALUES (@UserCode, @UserPassWord, @UserName, @UserMail)";
using (SqlConnection conn = new SqlConnection(this.SqlConnectionString))
{
conn.Open();
return(conn.Execute(sql, new {
UserCode = sys_UserEntity.UserCode,
UserPassWord = sys_UserEntity.UserPassWord,
UserName = sys_UserEntity.UserName,
UserMail = sys_UserEntity.UserMail
}));
}
}
public int UpdateUser(Sys_UserEntity sys_UserEntity)
{
string sql = "UPDATE Sys_User SET UserCode=@UserCode,UserPassWord=@UserPassWord,UserName=@UserName,UserMail=@UserMail WHERE UserId=@UserId";
using (var connection = new SqlConnection(SqlConnectionString))
{
connection.Open();
return(connection.Execute(sql, new
{
UserId = sys_UserEntity.UserId,
UserCode = sys_UserEntity.UserCode,
UserPassWord = sys_UserEntity.UserPassWord,
UserName = sys_UserEntity.UserName,
UserMail = sys_UserEntity.UserMail
}));
}
}
public IActionResult Edit([FromForm] Sys_UserEntity entity)
{
//判断是否存在维护的code
var _tempentity = _userService.GetSys_UserEntity(entity.UserCode);
//修改操作
if (entity.UserId > 0)
{
if (_tempentity == null || _tempentity.UserId == entity.UserId)
{
if (_userService.UpdateUser(entity) > 0)
{
ViewData["Status"] = 1;
}
else
{
ViewData["Status"] = -2;
}
}
else
{
//已存在rolecode
ViewData["Status"] = -1;
}
}
else
{
if (_tempentity == null)
{
//新增
_userService.InsertUser(entity);
ViewData["Status"] = 1;
}
else
{
//已存在rolecode
ViewData["Status"] = -1;
}
}
return(View());
}
