From adee7a71ba7ab1b63cab63381dfe1846437853d6 Mon Sep 17 00:00:00 2001
From: wzp <2040239371@qq.com>
Date: 星期四, 02 三月 2023 17:37:05 +0800
Subject: [PATCH] 增加分销商配置
---
web/Dao/SysDictDataDao.cs | 12 +++++++++++-
1 files changed, 11 insertions(+), 1 deletions(-)
diff --git a/web/Dao/SysDictDataDao.cs b/web/Dao/SysDictDataDao.cs
index 343d34f..84df31b 100644
--- a/web/Dao/SysDictDataDao.cs
+++ b/web/Dao/SysDictDataDao.cs
@@ -4,7 +4,7 @@
using System.Text;
using Model;
using Common;
-using Oracle.DataAccess.Client;
+using Oracle.ManagedDataAccess.Client;
using System.Data.Common;
namespace Dao
@@ -98,6 +98,15 @@
if (!string.IsNullOrEmpty(bean.DictType))
{
builder.Append(" and DICT_TYPE = '" + bean.DictType + "'");
+ }
+
+ if (bean.ParanSource == -1)
+ {
+ builder.Append(" AND (PARAN_SOURCE != " + bean.ParanSource + " OR PARAN_SOURCE IS NULL) ");
+ }
+ else
+ {
+ builder.Append(" AND PARAN_SOURCE = " + bean.ParanSource + " ");
}
if (bean.Status == -1)
@@ -279,6 +288,7 @@
o.DictLabel = oracleReaderWrapper.GetString("DICT_LABEL", "");
o.DictType = oracleReaderWrapper.GetString("DICT_TYPE", "");
o.DictSort = oracleReaderWrapper.GetInt("DICT_SORT", 1);
+ o.ParanSource = oracleReaderWrapper.GetInt("PARAN_SOURCE", 1);
o.DelFlag = oracleReaderWrapper.GetInt("DEL_FLAG", 0);
o.Status = oracleReaderWrapper.GetInt("STATUS", 0);
o.CreateBy = oracleReaderWrapper.GetString("CREATE_BY", "");
--
Gitblit v1.9.1