From b6349cb2b3a868c8c917ca221bb7eaf6f272bdd2 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期一, 22 八月 2022 10:59:55 +0800
Subject: [PATCH] 功能模块添加过滤器
---
VueWebApi/DLL/DAL/BasicSettingDAL.cs | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/VueWebApi/DLL/DAL/BasicSettingDAL.cs b/VueWebApi/DLL/DAL/BasicSettingDAL.cs
index 711a850..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)
@@ -1551,7 +1551,7 @@
{
if (OperType == "Add")
{
- var sql0 = @"select * from TCustomer where code=@code";
+ var sql0 = @"select * from TCustomer where code=@unitcode";
dynamicParams.Add("@unitcode", unitcode);
var data = DapperHelper.selectdata(sql0, dynamicParams);
if (data.Rows.Count > 0)
--
Gitblit v1.9.3