js元素的增删改查_增删改查怎么实现

 1 using System;  2 using System.Collections.Generic;  3 using System.Linq;  4 using System.Linq.Expressions;  5 using System.Threading.Tasks;  6 using Abp.Dependency;  7 using Abp.Domain.Entities;  8  9 namespace Abp.Domain.Repositories  10 {  11 //  12 // 摘要:  13 // This interface is implemented by all repositories to ensure implementation of  14 // fixed methods.  15 //  16 // 类型参数:  17 // TEntity:  18 // Main Entity type this repository works on  19 //  20 // TPrimaryKey:  21 // Primary key type of the entity  22 public interface IRepository<TEntity, TPrimaryKey> : IRepository, ITransientDependency where TEntity : class, IEntity<TPrimaryKey>  23  {  24 //  25 // 摘要:  26 // Gets count of all entities in this repository.  27 //  28 // 返回结果:  29 // Count of entities  30 int Count();  31 //  32 // 摘要:  33 // Gets count of all entities in this repository based on given predicate.  34 //  35 // 参数:  36 // predicate:  37 // A method to filter count  38 //  39 // 返回结果:  40 // Count of entities  41 int Count(Expression<Func<TEntity, bool>> predicate);  42 //  43 // 摘要:  44 // Gets count of all entities in this repository based on given predicate.  45 //  46 // 参数:  47 // predicate:  48 // A method to filter count  49 //  50 // 返回结果:  51 // Count of entities  52 Task<int> CountAsync(Expression<Func<TEntity, bool>> predicate);  53 //  54 // 摘要:  55 // Gets count of all entities in this repository.  56 //  57 // 返回结果:  58 // Count of entities  59 Task<int> CountAsync();  60 //  61 // 摘要:  62 // Deletes an entity.  63 //  64 // 参数:  65 // entity:  66 // Entity to be deleted  67 void Delete(TEntity entity);  68 //  69 // 摘要:  70 // Deletes an entity by primary key.  71 //  72 // 参数:  73 // id:  74 // Primary key of the entity  75 void Delete(TPrimaryKey id);  76 //  77 // 摘要:  78 // Deletes many entities by function. Notice that: All entities fits to given predicate  79 // are retrieved and deleted. This may cause major performance problems if there  80 // are too many entities with given predicate.  81 //  82 // 参数:  83 // predicate:  84 // A condition to filter entities  85 void Delete(Expression<Func<TEntity, bool>> predicate);  86 //  87 // 摘要:  88 // Deletes an entity by primary key.  89 //  90 // 参数:  91 // id:  92 // Primary key of the entity  93  Task DeleteAsync(TPrimaryKey id);  94 //  95 // 摘要:  96 // Deletes many entities by function. Notice that: All entities fits to given predicate  97 // are retrieved and deleted. This may cause major performance problems if there  98 // are too many entities with given predicate.  99 // 100 // 参数: 101 // predicate: 102 // A condition to filter entities 103 Task DeleteAsync(Expression<Func<TEntity, bool>> predicate); 104 // 105 // 摘要: 106 // Deletes an entity. 107 // 108 // 参数: 109 // entity: 110 // Entity to be deleted 111  Task DeleteAsync(TEntity entity); 112 // 113 // 摘要: 114 // Gets an entity with given given predicate or null if not found. 115 // 116 // 参数: 117 // predicate: 118 // Predicate to filter entities 119 TEntity FirstOrDefault(Expression<Func<TEntity, bool>> predicate); 120 // 121 // 摘要: 122 // Gets an entity with given primary key or null if not found. 123 // 124 // 参数: 125 // id: 126 // Primary key of the entity to get 127 // 128 // 返回结果: 129 // Entity or null 130  TEntity FirstOrDefault(TPrimaryKey id); 131 // 132 // 摘要: 133 // Gets an entity with given given predicate or null if not found. 134 // 135 // 参数: 136 // predicate: 137 // Predicate to filter entities 138 Task<TEntity> FirstOrDefaultAsync(Expression<Func<TEntity, bool>> predicate); 139 // 140 // 摘要: 141 // Gets an entity with given primary key or null if not found. 142 // 143 // 参数: 144 // id: 145 // Primary key of the entity to get 146 // 147 // 返回结果: 148 // Entity or null 149 Task<TEntity> FirstOrDefaultAsync(TPrimaryKey id); 150 // 151 // 摘要: 152 // Gets an entity with given primary key. 153 // 154 // 参数: 155 // id: 156 // Primary key of the entity to get 157 // 158 // 返回结果: 159 // Entity 160  TEntity Get(TPrimaryKey id); 161 // 162 // 摘要: 163 // Used to get a IQueryable that is used to retrieve entities from entire table. 164 // 165 // 返回结果: 166 // IQueryable to be used to select entities from database 167 IQueryable<TEntity> GetAll(); 168 // 169 // 摘要: 170 // Used to get a IQueryable that is used to retrieve entities from entire table. 171 // One or more 172 // 173 // 参数: 174 // propertySelectors: 175 // A list of include expressions. 176 // 177 // 返回结果: 178 // IQueryable to be used to select entities from database 179 IQueryable<TEntity> GetAllIncluding(params Expression<Func<TEntity, object>>[] propertySelectors); 180 // 181 // 摘要: 182 // Used to get all entities based on given predicate. 183 // 184 // 参数: 185 // predicate: 186 // A condition to filter entities 187 // 188 // 返回结果: 189 // List of all entities 190 List<TEntity> GetAllList(Expression<Func<TEntity, bool>> predicate); 191 // 192 // 摘要: 193 // Used to get all entities. 194 // 195 // 返回结果: 196 // List of all entities 197 List<TEntity> GetAllList(); 198 // 199 // 摘要: 200 // Used to get all entities based on given predicate. 201 // 202 // 参数: 203 // predicate: 204 // A condition to filter entities 205 // 206 // 返回结果: 207 // List of all entities 208 Task<List<TEntity>> GetAllListAsync(Expression<Func<TEntity, bool>> predicate); 209 // 210 // 摘要: 211 // Used to get all entities. 212 // 213 // 返回结果: 214 // List of all entities 215 Task<List<TEntity>> GetAllListAsync(); 216 // 217 // 摘要: 218 // Gets an entity with given primary key. 219 // 220 // 参数: 221 // id: 222 // Primary key of the entity to get 223 // 224 // 返回结果: 225 // Entity 226 Task<TEntity> GetAsync(TPrimaryKey id); 227 // 228 // 摘要: 229 // Inserts a new entity. 230 // 231 // 参数: 232 // entity: 233 // Inserted entity 234  TEntity Insert(TEntity entity); 235 // 236 // 摘要: 237 // Inserts a new entity and gets it's Id. It may require to save current unit of 238 // work to be able to retrieve id. 239 // 240 // 参数: 241 // entity: 242 // Entity 243 // 244 // 返回结果: 245 // Id of the entity 246  TPrimaryKey InsertAndGetId(TEntity entity); 247 // 248 // 摘要: 249 // Inserts a new entity and gets it's Id. It may require to save current unit of 250 // work to be able to retrieve id. 251 // 252 // 参数: 253 // entity: 254 // Entity 255 // 256 // 返回结果: 257 // Id of the entity 258 Task<TPrimaryKey> InsertAndGetIdAsync(TEntity entity); 259 // 260 // 摘要: 261 // Inserts a new entity. 262 // 263 // 参数: 264 // entity: 265 // Inserted entity 266 Task<TEntity> InsertAsync(TEntity entity); 267 // 268 // 摘要: 269 // Inserts or updates given entity depending on Id's value. 270 // 271 // 参数: 272 // entity: 273 // Entity 274  TEntity InsertOrUpdate(TEntity entity); 275 // 276 // 摘要: 277 // Inserts or updates given entity depending on Id's value. Also returns Id of the 278 // entity. It may require to save current unit of work to be able to retrieve id. 279 // 280 // 参数: 281 // entity: 282 // Entity 283 // 284 // 返回结果: 285 // Id of the entity 286  TPrimaryKey InsertOrUpdateAndGetId(TEntity entity); 287 // 288 // 摘要: 289 // Inserts or updates given entity depending on Id's value. Also returns Id of the 290 // entity. It may require to save current unit of work to be able to retrieve id. 291 // 292 // 参数: 293 // entity: 294 // Entity 295 // 296 // 返回结果: 297 // Id of the entity 298 Task<TPrimaryKey> InsertOrUpdateAndGetIdAsync(TEntity entity); 299 // 300 // 摘要: 301 // Inserts or updates given entity depending on Id's value. 302 // 303 // 参数: 304 // entity: 305 // Entity 306 Task<TEntity> InsertOrUpdateAsync(TEntity entity); 307 // 308 // 摘要: 309 // Creates an entity with given primary key without database access. 310 // 311 // 参数: 312 // id: 313 // Primary key of the entity to load 314 // 315 // 返回结果: 316 // Entity 317  TEntity Load(TPrimaryKey id); 318 // 319 // 摘要: 320 // Gets count of all entities in this repository based on given predicate (use this 321 // overload if expected return value is greather than System.Int32.MaxValue). 322 // 323 // 参数: 324 // predicate: 325 // A method to filter count 326 // 327 // 返回结果: 328 // Count of entities 329 long LongCount(Expression<Func<TEntity, bool>> predicate); 330 // 331 // 摘要: 332 // Gets count of all entities in this repository (use if expected return value is 333 // greather than System.Int32.MaxValue. 334 // 335 // 返回结果: 336 // Count of entities 337 long LongCount(); 338 // 339 // 摘要: 340 // Gets count of all entities in this repository (use if expected return value is 341 // greather than System.Int32.MaxValue. 342 // 343 // 返回结果: 344 // Count of entities 345 Task<long> LongCountAsync(); 346 // 347 // 摘要: 348 // Gets count of all entities in this repository based on given predicate (use this 349 // overload if expected return value is greather than System.Int32.MaxValue). 350 // 351 // 参数: 352 // predicate: 353 // A method to filter count 354 // 355 // 返回结果: 356 // Count of entities 357 Task<long> LongCountAsync(Expression<Func<TEntity, bool>> predicate); 358 // 359 // 摘要: 360 // Used to run a query over entire entities. Abp.Domain.Uow.UnitOfWorkAttribute 361 // attribute is not always necessary (as opposite to Abp.Domain.Repositories.IRepository`2.GetAll) 362 // if queryMethod finishes IQueryable with ToList, FirstOrDefault etc.. 363 // 364 // 参数: 365 // queryMethod: 366 // This method is used to query over entities 367 // 368 // 类型参数: 369 // T: 370 // Type of return value of this method 371 // 372 // 返回结果: 373 // Query result 374 T Query<T>(Func<IQueryable<TEntity>, T> queryMethod); 375 // 376 // 摘要: 377 // Gets exactly one entity with given predicate. Throws exception if no entity or 378 // more than one entity. 379 // 380 // 参数: 381 // predicate: 382 // Entity 383 TEntity Single(Expression<Func<TEntity, bool>> predicate); 384 // 385 // 摘要: 386 // Gets exactly one entity with given predicate. Throws exception if no entity or 387 // more than one entity. 388 // 389 // 参数: 390 // predicate: 391 // Entity 392 Task<TEntity> SingleAsync(Expression<Func<TEntity, bool>> predicate); 393 // 394 // 摘要: 395 // Updates an existing entity. 396 // 397 // 参数: 398 // entity: 399 // Entity 400  TEntity Update(TEntity entity); 401 // 402 // 摘要: 403 // Updates an existing entity. 404 // 405 // 参数: 406 // id: 407 // Id of the entity 408 // 409 // updateAction: 410 // Action that can be used to change values of the entity 411 // 412 // 返回结果: 413 // Updated entity 414 TEntity Update(TPrimaryKey id, Action<TEntity> updateAction); 415 // 416 // 摘要: 417 // Updates an existing entity. 418 // 419 // 参数: 420 // id: 421 // Id of the entity 422 // 423 // updateAction: 424 // Action that can be used to change values of the entity 425 // 426 // 返回结果: 427 // Updated entity 428 Task<TEntity> UpdateAsync(TPrimaryKey id, Func<TEntity, Task> updateAction); 429 // 430 // 摘要: 431 // Updates an existing entity. 432 // 433 // 参数: 434 // entity: 435 // Entity 436 Task<TEntity> UpdateAsync(TEntity entity); 437  } 438 }

 1 using Abp.Domain.Entities;  2 using System;  3 using System.Collections.Generic;  4 using System.ComponentModel.DataAnnotations;  5 using System.Text;  6  7 namespace Ocean.Entities  8 {  9 public class User : Entity 10  { 11 /// <summary> 12 /// 用户名 13 /// </summary> 14 [MaxLength(500)] 15 public virtual string UserName { get; set; } 16 17 /// <summary> 18 /// 真实姓名 19 /// </summary> 20 [MaxLength(500)] 21 public virtual string RealName { get; set; } 22 23 /// <summary> 24 /// 邮箱 25 /// </summary> 26 [MaxLength(50)] 27 public virtual string Email { get; set; } 28 29 /// <summary> 30 /// 添加时间 31 /// </summary> 32 public virtual DateTime CreationTime { get; set; } = DateTime.Now; 33 34 /// <summary> 35 /// 用户状态 36 /// </summary> 37 public virtual int Status { get; set; } = 0; 38  } 39 }

 1 using Abp.Domain.Repositories;  2 using System;  3 using System.Collections.Generic;  4 using System.Text;  5  6 namespace Ocean.IRepositories  7 {  8 public interface IUserRepository : IRepository  9  { 10 //自定义除增删改查基本操作之外的其余方法接口 11  } 12 }

 1 using Ocean.IRepositories;  2 using System;  3 using System.Collections.Generic;  4 using System.Text;  5  6 namespace Ocean.EntityFrameworkCore.Repositories  7 {  8 public class UserRepository : IUserRepository  9  { 10 // 11  } 12 }

 1 using Abp.EntityFrameworkCore;  2 using Microsoft.EntityFrameworkCore;  3 using Ocean.Entities;  4  5 namespace Ocean.EntityFrameworkCore  6 {  7 public class OceanDbContext : AbpDbContext  8  {  9 //Add DbSet properties for your entities... 10 public virtual DbSet<User> User { get; set; } 11 12 public OceanDbContext(DbContextOptions<OceanDbContext> options) 13 : base(options) 14  { 15 // 16  } 17  } 18 }

 1 using Abp.Application.Services;  2 using System;  3 using System.Collections.Generic;  4 using System.Text;  5  6 namespace Ocean.User  7 {  8 public interface IUserAppService : IApplicationService  9  { 10 List<Entities.User> GetUsers(); 11 12 void UpdateUser(Entities.User entity); 13 14 void CreateUser(Entities.User entity); 15 16 void DeleteUser(int Id); 17  } 18 }

 1 using Abp.Domain.Repositories;  2 using Ocean.Entities;  3 using System;  4 using System.Collections.Generic;  5 using System.Linq;  6 using System.Text;  7  8 namespace Ocean.User  9 { 10 public class UserAppService : OceanAppServiceBase, IUserAppService 11  { 12 private readonly IRepository<Entities.User> _UserRepository; 13 public UserAppService(IRepository<Entities.User> userRepository) 14  { 15 _UserRepository = userRepository; 16  } 17 18 public void CreateUser(Entities.User entity) 19  { 20 Logger.Info($"Created a User for entity at:{DateTime.Now}"); 21 try 22  { 23  _UserRepository.Insert(entity); 24  } 25 catch (Exception ex) 26  { 27  Logger.Error(ex.ToString()); 28  } 29  } 30 31 public void DeleteUser(int Id) 32  { 33 Logger.Info($"Deleted a User for Id at:{DateTime.Now}"); 34 try 35  { 36  _UserRepository.Delete(Id); 37  } 38 catch (Exception ex) 39  { 40  Logger.Error(ex.ToString()); 41  } 42  } 43 44 public List<Entities.User> GetUsers() 45  { 46 List<Entities.User> list = new List<Entities.User>(); 47 Logger.Info($"Get Users List at:{DateTime.Now}"); 48 try 49  { 50 list = _UserRepository.GetAll().ToList(); 51  } 52 catch (Exception ex) 53  { 54  Logger.Error(ex.ToString()); 55  } 56 return list; 57  } 58 59 public void UpdateUser(Entities.User entity) 60  { 61 Logger.Info($"Updated a User for entity at:{DateTime.Now}"); 62 try 63  { 64  _UserRepository.Update(entity); 65  } 66 catch (Exception ex) 67  { 68  Logger.Error(ex.ToString()); 69  } 70  } 71  } 72 }

 1 public override void SetNavigation(INavigationProviderContext context)  2  {  3  context.Manager.MainMenu  4  .AddItem(  5 new MenuItemDefinition(  6  PageNames.Home,  7 L("HomePage"),  8 url: "",  9 icon: "fa fa-home" 10  ) 11  ).AddItem( 12 new MenuItemDefinition( 13  PageNames.About, 14 L("About"), 15 url: "Home/About", 16 icon: "fa fa-info" 17  ) 18  ).AddItem( 19 new MenuItemDefinition( 20  PageNames.User, 21 L("User"), 22 url: "User/Index", 23 icon: "fa fa-user" 24  ) 25  ); 26 }

1 public class PageNames 2  { 3 public const string Home = "Home"; 4 public const string About = "About"; 5 public const string User = "User"; 6 }

 1 namespace Ocean.Web.Controllers  2 {  3 public class UserController : OceanControllerBase  4  {  5 // GET: /<controller>/  6 public ActionResult Index()  7  {  8 return View();  9  } 10  } 11 }

 1 @using Ocean.Web.Startup  2 @{  3 ViewBag.ActiveMenu = PageNames.User;  4 }  5  6 <div id="userApp">  7 <div class="row">  8 <div class="col-md-12">  9 <button data-toggle="modal" data-target="#userModal" class="btn btn-primary pull-right"><i class="fa fa-plus"></i>添加用户</button> 10 </div> 11 </div> 12 <div class="row"> 13 <table class="table"> 14 <thead> 15 <tr> 16 <th>用户Id</th> 17 <th>用户名</th> 18 <th>真实姓名</th> 19 <th>用户邮箱</th> 20 </tr> 21 </thead> 22 <tbody> 23 <tr v-for="user in userList"> 24 <td><a href="javascript:void(0)" v-on:click="updateUser(user)">{ {user.id}}</a></td> 25 <td>{ {user.userName}}</td> 26 <td>{ {user.realName}}</td> 27 <td>{ {user.email}}</td> 28 </tr> 29 </tbody> 30 </table> 31 </div> 32 33 <div class="modal fade" id="userModal" tabindex="-1" role="dialog" data-backdrop="static"> 34 <div class="modal-dialog" role="document"> 35 <div class="modal-content"> 36 <form name="userForm" role="form" novalidate class="form-validation"> 37 <div class="modal-header"> 38 <h4 class="modal-title"> 39 <span v-if="userModel.id">编辑用户</span> 40 <span v-if="!userModel.id">添加用户</span> 41 </h4> 42 </div> 43 <div class="modal-body"> 44 <input type="hidden" v-model="userModel.id" /> 45 <div class="form-group"> 46 <label>用户名</label> 47 <input class="form-control" type="text" v-model="userModel.userName" required> 48 </div> 49 <div class="form-group"> 50 <label>真实姓名</label> 51 <input class="form-control" type="text" v-model="userModel.realName" required> 52 </div> 53 <div class="form-group"> 54 <label>用户邮箱</label> 55 <input class="form-control" type="text" v-model="userModel.email" required> 56 </div> 57 </div> 58 <div class="modal-footer"> 59 <button type="button" class="btn btn-default" data-dismiss="modal">@L("Cancel")</button> 60 <button type="button" class="btn btn-primary blue" v-on:click="createUser"><i class="fa fa-save"></i> <span>@L("Save")</span></button> 61 </div> 62 </form> 63 </div> 64 </div> 65 </div> 66 </div> 67 68 @section scripts{ 69 <script src="~/lib/vue/dist/vue.js"></script> 70 <script src="~/js/views/user/index.js"></script> 71 } 

 1 //abp的调用接口abp.services.app.user  2 var _userService = abp.services.app.user;  3 var appVue = new Vue({  4 el: "#userApp",  5  data: {  6  userModel: {  7 id: 0,  8 userName: '',  9 realName: '', 10 email: '' 11  }, 12  userList: [] 13  }, 14  methods: { 15 getUsers: function () { 16 var own = this; 17 _userService.getUsers().done(function (result) { 18 own.userList = result; 19  }); 20  }, 21 createUser: function () { 22 var own = this; 23 if (own.userModel.id > 0) { 24 _userService.updateUser(own.userModel).done(function () { 25  location.reload(); 26  }) 27  } 28 else { 29 _userService.createUser(own.userModel).done(function () { 30  location.reload(); 31  }); 32  } 33  }, 34 updateUser: function (user) { 35 var own = this; 36 own.userModel = user; 37 $('#userModal').modal(); 38  } 39  } 40 }); 41 appVue.getUsers();