TdevDevSpotRepository.cs 825 B

123456789101112131415161718192021222324
  1. using Ropin.Inspection.Model.Entities;
  2. using System;
  3. using System.Collections.Generic;
  4. using System.Linq;
  5. using System.Text;
  6. using System.Threading.Tasks;
  7. namespace Ropin.Inspection.Repository
  8. {
  9. public class TdevDevSpotRepository : RepositoryBase<TDEV_DevSpot, Guid>, ITdevDevSpotRepository
  10. {
  11. public TdevDevSpotRepository(InspectionDbContext DbContext) : base(DbContext)
  12. {
  13. }
  14. public Task<int> DeleteByDevIdAsync(string devId)
  15. {
  16. MySqlConnector.MySqlParameter[] parameters = new[] { new MySqlConnector.MySqlParameter("devId", devId) };
  17. int result = EntityFrameworkCoreExtensions.ExecuteSqlNoQuery(DbContext.Database, "DELETE from TDEV_DevSpot WHERE C_DevStoreCode = @devId", parameters);
  18. return Task.FromResult(result);
  19. }
  20. }
  21. }