Wms/WMS.DAL/SysInfrastructure/MaterialsRepository.cs
@@ -114,7 +114,7 @@ /// <returns></returns> public List<SysMaterials> GetMateByNo(string SkuNo) { string str = "select * from SysMaterials where SkuNo = @skuno"; string str = "select * from SysMaterials where SkuNo = @skuno and isdel = '0'"; List<SysMaterials> mate = Db.Ado.SqlQuery<SysMaterials>(str, new { skuno = SkuNo //物料编号