基础信息，仓库管理页面修改

zhaowc

2024-08-22 e65ffb14073b14fbc062849ce6e9fa16d72680fd

基础信息，仓库管理页面修改

 Wms/WMS.BLL/SysServer/MaterialsServer.cs

@@ -58,7 +58,7 @@
            return Db.Queryable<SysMaterials>()
                     .LeftJoin<SysUserInfor>((a, b) => a.CreateUser == b.Id)
                     .LeftJoin<SysPackag>((a, b,c) => a.PackagNo == c.PackagNo) 
                     .Where((a,b,c) => c.IsDel == "0")
                     //.Where((a,b,c) => c.IsDel == "0")
                     .WhereIF(!string.IsNullOrEmpty(skuNo), a => a.SkuNo.Contains(skuNo))
                     .WhereIF(!string.IsNullOrEmpty(skuName), a => a.SkuNo.Contains(skuName))
                     .WhereIF(!string.IsNullOrEmpty(auditStatusNo), a => a.AuditStatusNo == auditStatusNo)
@@ -92,6 +92,16 @@
            return await Db.Queryable<SysMaterials>().CountAsync(s => s.SkuNo == SkuNo && s.IsDel == "0");
        }


        /// <summary>
        /// 根据编号查询物料信息
        /// </summary>
        /// <param name="PackagNo">包装编号</param>
        /// <returns></returns>
        public async Task<int> GetMateByPa(string PackagNo)
        {
            return await Db.Queryable<SysMaterials>().CountAsync(s => s.PackagNo == PackagNo && s.IsDel == "0");
        }
        /// <summary>
        /// 新增物料信息
        /// </summary>