PositionEnglishComparisonService.cs 698 B

12345678910111213141516171819202122232425
  1. using Models;
  2. using System;
  3. using System.Collections.Generic;
  4. using System.Data.SqlClient;
  5. using System.Data;
  6. using System.Linq;
  7. using System.Text;
  8. using System.Threading.Tasks;
  9. namespace DAL
  10. {
  11. public class PositionEnglishComparisonService
  12. {
  13. List<PositionEnglishComparison> excuteSql(string sql, params SqlParameter[] param)
  14. {
  15. return ServiceBase<PositionEnglishComparison>.excuteSql(new PositionEnglishComparison(), "PositionEnglishComparison", sql, CommandType.Text, param);
  16. }
  17. public List<PositionEnglishComparison> GetAll()
  18. {
  19. return excuteSql("select * from PositionEnglishComparison With(Nolock) ");
  20. }
  21. }
  22. }