123456789101112131415161718192021222324252627282930313233343536373839404142 |
- using ProjectBase.Data.BaseDAL;
- using SIMDP.DAL.IDALSQL;
- using SIMDP.Model;
- using System;
- using System.Collections.Generic;
- using System.Linq;
- using System.Text;
- using System.Threading.Tasks;
- namespace SIMDP.BLL
- {
- public class BlProductData : BaseBLL<MoProductData>
- {
- private IDalProductData dalData;
- /// <summary>
- /// 构造函数
- /// </summary>
- public BlProductData() : base()
- {
- base.Init(this.GetType().FullName, System.Reflection.Assembly.GetExecutingAssembly().GetName().Name);
- dalData = baseDal as IDalProductData;
- }
- /// <summary>
- /// 获取指定PLC下的数据点
- /// </summary>
- /// <param name="id"></param>
- /// <returns></returns>
- public MoProductData FindByBatch(string batchId)
- {
- string sql = string.Format("SELECT TOP 1 * FROM product_data WHERE batchid = '{0}' order by data_id desc", batchId);
- var list = dalData.GetList(sql, null);
- if (list.Count > 0)
- return list[0];
- else
- return null;
- }
- }
- }
|