From 286db121ac6b7e56b1b579ebcdd191526890f4af Mon Sep 17 00:00:00 2001
From: IPC-610 <IPC-610@DESKTOP-6LEOOS3>
Date: 星期四, 02 一月 2025 13:22:07 +0800
Subject: [PATCH] 修改问题
---
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