BlProductData.cs 1.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142
  1. using ProjectBase.Data.BaseDAL;
  2. using SIMDP.DAL.IDALSQL;
  3. using SIMDP.Model;
  4. using System;
  5. using System.Collections.Generic;
  6. using System.Linq;
  7. using System.Text;
  8. using System.Threading.Tasks;
  9. namespace SIMDP.BLL
  10. {
  11. public class BlProductData : BaseBLL<MoProductData>
  12. {
  13. private IDalProductData dalData;
  14. /// <summary>
  15. /// 构造函数
  16. /// </summary>
  17. public BlProductData() : base()
  18. {
  19. base.Init(this.GetType().FullName, System.Reflection.Assembly.GetExecutingAssembly().GetName().Name);
  20. dalData = baseDal as IDalProductData;
  21. }
  22. /// <summary>
  23. /// 获取指定PLC下的数据点
  24. /// </summary>
  25. /// <param name="id"></param>
  26. /// <returns></returns>
  27. public MoProductData FindByBatch(string batchId)
  28. {
  29. string sql = string.Format("SELECT TOP 1 * FROM product_data WHERE batchid = '{0}' order by data_id desc", batchId);
  30. var list = dalData.GetList(sql, null);
  31. if (list.Count > 0)
  32. return list[0];
  33. else
  34. return null;
  35. }
  36. }
  37. }