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