JC26WMS.git - Gitblit

			@@ -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>