PayPlatFormDAL.cs 1.1 KB

123456789101112131415161718192021222324252627282930313233343536373839
  1. using Common.Model;
  2. using CoreEntity.Entity;
  3. using System;
  4. using System.Collections.Generic;
  5. using System.Data;
  6. using System.Text;
  7. using ZcPeng.PublicLibrary;
  8. namespace CoreEntity.DAL
  9. {
  10. public class PayPlatFormDAL
  11. {
  12. public static IList<Mem_Payplatform> getPayTerms()
  13. {
  14. #region 获取机构列表
  15. DataTable dt = new DataTable();
  16. string result;
  17. IList<Mem_Payplatform> permss = new List<Mem_Payplatform>(0);
  18. string commandText1 =
  19. "select A.*" +
  20. " from Mem_PayPlatform as A " +
  21. " where 1=1 "
  22. + " ORDER BY A.PayPlatFormKey desc";
  23. bool success = DataAccess.GetValues(commandText1, ref dt, null, out result);
  24. #endregion
  25. if (dt != null && dt.Rows.Count > 0)
  26. {
  27. // 把DataTable转换为IList<T>
  28. permss = ModelConvertHelper<Mem_Payplatform>.ConvertToModel(dt);
  29. }
  30. return permss;
  31. }
  32. }
  33. }