WD_CostInfoDataAccess.cs 1.4 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344
  1. using HNWD.Pregrant.Model;
  2. using System.Collections.Generic;
  3. namespace HNWD.Pregrant.DataAccess
  4. {
  5. public class WD_CostInfoDataAccess : GenericDataAccess<WD_CostInfo>
  6. {
  7. private WD_CostInfo wd_CostInfo = null;
  8. public WD_CostInfoExt ext = new WD_CostInfoExt();
  9. private readonly static WD_CostInfoDataAccess wd_CostInfoDataAccess = new WD_CostInfoDataAccess();
  10. public WD_CostInfoDataAccess(WD_CostInfo wd_CostInfo)
  11. {
  12. this.wd_CostInfo = wd_CostInfo;
  13. }
  14. public static WD_CostInfoDataAccess GetInstance()
  15. {
  16. return wd_CostInfoDataAccess;
  17. }
  18. private WD_CostInfoDataAccess()
  19. {
  20. }
  21. public List<WD_CostInfo> QueryAll()
  22. {
  23. string strSql = " select {0} from [WD_CostInfo] where DATEDIFF(day,[COST_CREATEDATE],getdate() )<2 ";
  24. ext.messageDataList = this.Query(strSql, new WD_CostInfo());
  25. ext.messageDataList.ForEach(f => f.bSuccess = this.bSuccess);
  26. ext.messageDataList.ForEach(f => f.Code = this.Code);
  27. ext.messageDataList.ForEach(f => f.Message = this.Message);
  28. ext.messageDataList.ForEach(f => f.Rows = this.Rows);
  29. ext.Code = this.Code;
  30. ext.Message = this.Message;
  31. ext.Rows = this.Rows;
  32. return ext.messageDataList;
  33. }
  34. }
  35. }