first commit

快乐的昕的电脑

2025-09-23 ae390b6ce95ac316ca9cf1f24ff4fc2bb2d240d3

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
using PadApplication.DB;
using PadApplication.Entites.DbModels;
using PadApplication.Entites.Dto;
 
namespace PadApplication.Services;
 
public class MesStaffManager : Repository<MesStaff>
{
    //当前类已经继承了 Repository 增、删、查、改的方法
 
    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();
    }
}