From f2bc08e28dda7022202f07217f6a3c150f818af7 Mon Sep 17 00:00:00 2001
From: zhaowc <526854230@qq.com>
Date: 星期一, 20 一月 2025 08:32:16 +0800
Subject: [PATCH] Merge branch 'master' of https://gitee.com/liudongl/jc24-wms
---
Wms/WMS.DAL/SysInfrastructure/MaterialsRepository.cs | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/Wms/WMS.DAL/SysInfrastructure/MaterialsRepository.cs b/Wms/WMS.DAL/SysInfrastructure/MaterialsRepository.cs
index 73e37c6..a70e21d 100644
--- a/Wms/WMS.DAL/SysInfrastructure/MaterialsRepository.cs
+++ b/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 //鐗╂枡缂栧彿
--
Gitblit v1.8.0