src/Services/Wms_materialServices.cs

（开头部分） 5KB

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

using IRepository;
using IServices;
using SqlSugar;
using System;
using YL.Core.Entity;
using YL.Utils.Excel;
using YL.Utils.Extensions;
using YL.Utils.Json;
using YL.Utils.Pub;
using YL.Utils.Table;

namespace Services
{
    public class Wms_materialServices : BaseServices<Wms_material>, IWms_materialServices
    {
        private readonly IWms_materialRepository _repository;
        private readonly SqlSugarClient _client;

        public Wms_materialServices(SqlSugarClient client, IWms_materialRepository repository) : base(repository)
        {
            _client = client;
            _repository = repository;
        }

        public string PageList(Bootstrap.BootstrapParams bootstrap)
        {
            int totalNumber = 0;
            if (bootstrap.offset != 0)
            {
                bootstrap.offset = bootstrap.offset / bootstrap.limit + 1;
            }
            var query = _client.Queryable<Wms_material, Sys_dict, Sys_dict, Wms_storagerack, Wms_reservoirarea, Wms_warehouse, Sys_user, Sys_user>
                ((s, t, ut, r, k, w, c, u) => new object[] {
                   JoinType.Left,s.MaterialType==t.DictId,
                   JoinType.Left,s.Unit==ut.DictId,
                   JoinType.Left,s.StoragerackId==r.StorageRackId,
                   JoinType.Left,s.ReservoirAreaId==k.ReservoirAreaId,
                   JoinType.Left,s.WarehouseId==w.WarehouseId,
                   JoinType.Left,s.CreateBy==c.UserId,
                   JoinType.Left,s.ModifiedBy==u.UserId,
                 })
                 .Where((s, t, ut, r, k, w, c, u) => s.IsDel == 1 && t.IsDel == 1 && ut.IsDel == 1 && r.IsDel == 1 && k.IsDel == 1 && w.IsDel == 1)
                 .Select((s, t, ut, r, k, w, c, u) => new
                 {
                     MaterialId = s.MaterialId.ToString(),
                     s.MaterialNo,
                     s.MaterialName,
                     r.StorageRackNo,
                     r.StorageRackName,
                     k.ReservoirAreaNo,
                     k.ReservoirAreaName,
                     w.WarehouseNo,
                     w.WarehouseName,
                     MaterialType = t.DictName,
                     Unit = ut.DictName,
                     s.Qty,
                     s.ExpiryDate,
                     s.IsDel,
                     s.Remark,
                     CName = c.UserNickname,
后面还有 77 行代码，解锁后查看完整代码

24 小时内免费解锁 3 个项目，之后 1 算力/个。 规则说明

AI 解读 AI

登录后可用，每次 10 算力，解读结果公开显示在下面。

还没有人解读过这个文件。