1

pulg

2025-05-27 bc3d7a828114cb9df154da869ec986cf6733a779

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
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;
 
        }
    }
}