From 3796ad0aab8e89eb0732fed0f2eced943028909c Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期二, 23 八月 2022 22:54:19 +0800
Subject: [PATCH] 修改报工+已报废数量
---
VueWebApi/DLL/DAL/BasicSettingDAL.cs | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/VueWebApi/DLL/DAL/BasicSettingDAL.cs b/VueWebApi/DLL/DAL/BasicSettingDAL.cs
index 84404ba..619afec 100644
--- a/VueWebApi/DLL/DAL/BasicSettingDAL.cs
+++ b/VueWebApi/DLL/DAL/BasicSettingDAL.cs
@@ -232,7 +232,7 @@
var dynamicParams = new DynamicParameters();
try
{
- sql = @"select * from TOrganization where parent_id=@orgid";
+ sql = @"select * from TOrganization where parent_id=@orgid and is_delete<>'1'";
dynamicParams.Add(@"orgid", orgid);
cont = DapperHelper.selectcount(sql, dynamicParams);
if (cont>0)
--
Gitblit v1.9.3