BaseService.cs 1.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748
  1. using SqlSugar;
  2. using SqlSugarDb.MySqlSugarClient;
  3. using System;
  4. using System.Collections.Generic;
  5. using System.Linq;
  6. using System.Text;
  7. using System.Threading.Tasks;
  8. namespace BizService
  9. {
  10. public class BaseService<TEntity> :SimpleClient<TEntity>, IBaseService<TEntity> where TEntity : class, new()
  11. {
  12. public BaseService(ISqlSugarClient context = null) : base(context)//注意这里要有默认值等于null
  13. {
  14. base.Context = DbSqlSugarClient.GetInstance();
  15. //创建库,创建表执行一次就可以注释
  16. //base.Context.DbMaintenance.CreateDatabase();
  17. //base.Context.CodeFirst.InitTables(
  18. // typeof(Product)
  19. // );
  20. }
  21. public bool Add(TEntity entity)
  22. {
  23. return base.Insert(entity);
  24. }
  25. public bool Delete(int id)
  26. {
  27. return base.DeleteById(id);
  28. }
  29. public bool Edit(TEntity entity)
  30. {
  31. return base.Update(entity);
  32. }
  33. public TEntity Find(int id)
  34. {
  35. return base.GetById(id);
  36. }
  37. public List<TEntity> QueryList()
  38. {
  39. return base.GetList();
  40. }
  41. }
  42. }