using HH.WCS.Hexafluo.util;
using HH.WCS.SJML.Dto;
using HH.WCS.SJML.Entitys;
using SqlSugar;
using System.Collections.Generic;

namespace HH.WCS.SJML.wms
{
    public class TN_WeightCounterHelper
    {
        public List<TN_WeightCounterEntitys> WeightSelect(TN_WeightCounterEntitys tN_Weight)
        {
            OperateResult result = new OperateResult();
            var db = new SqlHelper<object>().GetInstance();
            var exp = Expressionable.Create<TN_WeightCounterEntitys>();
            exp.And(it => it.S_Erp_info == "N");
            exp.And(it => it.D_Weight_even == 0);
            exp.And(it => it.D_Weight_sum == 0);
            exp.AndIF(!string.IsNullOrEmpty(tN_Weight.S_BatchNumber), it => it.S_BatchNumber == tN_Weight.S_BatchNumber);
            exp.AndIF(!string.IsNullOrEmpty(tN_Weight.S_FrockNumber), it => it.S_FrockNumber == tN_Weight.S_FrockNumber);
            exp.AndIF(!string.IsNullOrEmpty(tN_Weight.S_Item_Code), it => it.S_Item_Code == tN_Weight.S_Item_Code);
            exp.AndIF(!string.IsNullOrEmpty(tN_Weight.S_Task_No), it => it.S_Task_No == tN_Weight.S_Task_No);
            var ta = db.Queryable<TN_WeightCounterEntitys>().Where(exp.ToExpression()).ToList();
            return ta;

        }
    }
}