WD_MessageInfoDataAccess.cs 1.5 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546
  1. using HNWD.Pregrant.Model;
  2. using System.Collections.Generic;
  3. namespace HNWD.Pregrant.DataAccess
  4. {
  5. public class WD_MessageInfoDataAccess : GenericDataAccess<WD_MessageInfo>
  6. {
  7. private WD_MessageInfo wd_MessageInfo = null;
  8. public WD_MessageInfoExt ext = new WD_MessageInfoExt();
  9. private WD_MessageInfoDataAccess(WD_MessageInfo wd_MessageInfo)
  10. {
  11. this.wd_MessageInfo = wd_MessageInfo;
  12. }
  13. private readonly static WD_MessageInfoDataAccess wd_MessageInfoDataAccess = new WD_MessageInfoDataAccess(null);
  14. private readonly static object lockobj = new object();
  15. public static WD_MessageInfoDataAccess GetInstance()
  16. {
  17. lock (lockobj)
  18. {
  19. return wd_MessageInfoDataAccess;
  20. }
  21. }
  22. public List<WD_MessageInfo> QueryAll()
  23. {
  24. string strSql = " select TOP 5 [MESSAGE_CONTENT],[MESSAGE_DATETIME] from [WD_MessageInfo] order by [ID] DESC ";
  25. ext.messageDataList = this.Query(strSql, new WD_MessageInfo());
  26. ext.messageDataList.ForEach(f => f.bSuccess = this.bSuccess);
  27. ext.messageDataList.ForEach(f => f.Code = this.Code);
  28. ext.messageDataList.ForEach(f => f.Message = this.Message);
  29. ext.messageDataList.ForEach(f => f.Rows = this.Rows);
  30. ext.bSuccess = this.bSuccess;
  31. ext.Code = this.Code;
  32. ext.Message = this.Message;
  33. ext.Rows = this.Rows;
  34. return ext.messageDataList;
  35. }
  36. }
  37. }