逻辑优化

快乐的昕的电脑

2025-10-18 b876edb8c9865d15a41cc0926cde34aa8c89c1f2

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
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
using PadApplication.DB;
using PadApplication.Entites.DbModels;
using PadApplication.Entites.Dto;
 
namespace PadApplication.Services;
 
public class MesStaffManager : Repository<MesStaff>
{
    //当前类已经继承了 Repository 增、删、查、改的方法
 
    public List<MesStaff> GetAllXS0101()
    {
        var departmentNos = new[] { "MS01", "MS0102", "MS0103" };
        return Db.Queryable<MesStaff>()
            .Where(s =>
                departmentNos.Contains(s.DepartmentNo) && s.State == "Y")
            .ToList();
    }
 
    //public List<MesStaff> GetAllXS0101()
    //{
    //    return Db.Queryable<MesStaff>()
    //        .Where(s =>
    //            s.DepartmentNo == "XS0101" && s.State == "Y" && s.Memo == "注塑工")
    //        .ToList();
    //}
 
    public List<MesReporting> GetMesReportingList(OrderMachineDto dto)
    {
        return Db.Queryable<MesReporting>()
            .LeftJoin<MesStaff>((a, b) =>
                a.BgPerson == b.StaffNo)
            .Where((a, b) => a.AddressCode == "XF" && a.BillNo == dto.orderNo)
            .OrderByDescending(a => a.BgDate)
            .Select((a, b) => new MesReporting
            {
                BillNo = a.BillNo,
                ItemNoCade = a.ItemNoCade,
                BgPerson = a.BgPerson,
                StaffName = b.StaffName,
                BgDate = a.BgDate,
                OkQty = a.OkQty
            })
            .ToList();
    }
}