123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051 |
- 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 BlPcData : BaseBLL<MoPcData>
- {
- private IDalPcData dalData;
- /// <summary>
- /// 构造函数
- /// </summary>
- public BlPcData() : base()
- {
- base.Init(this.GetType().FullName, System.Reflection.Assembly.GetExecutingAssembly().GetName().Name);
- dalData = baseDal as IDalPcData;
- }
-
- public List<MoPcData> GetDATA2PLC(int presentID)
- {
- string sql = $"select top 12* from PC_DATA where ID >= {presentID}";
- var list = dalData.GetList(sql, null);
- if (list.Count > 0) return list;
- else return null;
- }
- public int TruncateTable()
- {
- string sql = "TRUNCATE TABLE PC_DATA";
- int res = dalData.SqlExecute(sql);
- return res;
- }
- public MoPcData FindbyVinCode(string vincode)
- {
- string sql = $"select * from pc_data where vin = '{vincode}' order by ID desc ";
- var list = dalData.GetList(sql, null);
- if (list.Count > 0) return list[0];
- else return null;
- }
- }
- }
|