BLDataPoint.cs 1.6 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152
  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.Data;
  7. using System.Linq;
  8. using System.Text;
  9. using System.Threading.Tasks;
  10. namespace SIMDP.BLL
  11. {
  12. public class BlDataPoint : BaseBLL<MoDataPoint>
  13. {
  14. private IDalDataPoint dalDataPoint;
  15. /// <summary>
  16. /// 构造函数
  17. /// </summary>
  18. public BlDataPoint() : base()
  19. {
  20. base.Init(this.GetType().FullName, System.Reflection.Assembly.GetExecutingAssembly().GetName().Name);
  21. dalDataPoint = baseDal as IDalDataPoint;
  22. dalDataPoint.OnOperationLog += new OperationLogEventHandler(BlLogOperation.OnOperationLog);
  23. }
  24. /// <summary>
  25. /// 获取指定PLC下的数据点
  26. /// </summary>
  27. /// <param name="id"></param>
  28. /// <returns></returns>
  29. public List<MoDataPoint> GetDataPointsByPlcID(long id)
  30. {
  31. string sql = string.Format("SELECT * FROM data_point WHERE data_point_plc_id = {0}", id);
  32. return dalDataPoint.GetList(sql, null);
  33. }
  34. public DataTable GetVar()
  35. {
  36. string sql = "SELECT data_point_id,data_point_name,data_point_type from data_point";
  37. DataTable dt = dalDataPoint.SqlTable(sql);
  38. return dt;
  39. }
  40. //public List<MoDataPoint> GetSpecialPointsbyGroupID(int groupId)
  41. //{
  42. // string sql = $"select * from data_point where data_point_group_id = '{groupId}'";
  43. // return dalDataPoint.GetList(sql);
  44. //}
  45. }
  46. }