1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950 |
- 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;
- }
- public MoProductData Find2Bind(string vin)
- {
- if (string.IsNullOrEmpty(vin)) return null;
- string sql = $"batchid = '{vin}'";
- return dalData.FindSingle(sql);
- }
-
- /// <summary>
- /// 根据VIN码查询要绑定的生产数据
- /// </summary>
- /// <param name="vinCode"></param>
- /// <param name="everyDayProcuction"></param>
- /// <returns></returns>
- public MoProductData FindbyContainsVIN(string vinCode, int everyDayProcuction = 1500)
- {
- string sql = string.Format($"SELECT TOP {everyDayProcuction} * FROM product_data WHERE data_value like '%{0}%' order by data_id desc", vinCode);
- var list = dalData.GetList(sql, null);
- if (list.Count > 0) return list[0];
- else return null;
- }
- }
- }
|