From f63d8ead25bdb3c32dacca817a059bd30390e9bc Mon Sep 17 00:00:00 2001
From: yzh <snbbt@21cn.com>
Date: 星期三, 15 六月 2022 22:20:07 +0800
Subject: [PATCH] 1.系统账户数据库优化： 修改“账户类型”的数据类型为VARCHAR2(1024)，多个角色时以半角“,”分隔。 加密盐。 密码加密优化；账户登录优化；角色权限管理（作废用户权限）； 2.字典类型管理（定义：用户角色） 3.字典数据管理（初始化用户角色数据） 3.角色权限管理 4.系统账户管理，账户类型对应用户角色（可多选）。
---
web/Dao/GwDiverterDao.cs | 38 +++++++++++++++++++-------------------
1 files changed, 19 insertions(+), 19 deletions(-)
diff --git a/web/Dao/GwDiverterDao.cs b/web/Dao/GwDiverterDao.cs
index f0e3b31..a1862b0 100644
--- a/web/Dao/GwDiverterDao.cs
+++ b/web/Dao/GwDiverterDao.cs
@@ -153,25 +153,25 @@
foreach (GwDiverterItem gwDiverterItem in items)
{
OracleParameter[] oracleParameterArray2 = new OracleParameter[17]
- {
- new OracleParameter(":DIVERTER_ID", (object) diverter.DiverterID),
- new OracleParameter(":CM_OP_ID", (object) gwDiverterItem.CMOPID),
- new OracleParameter(":CU_OP_ID", (object) gwDiverterItem.CUOPID),
- new OracleParameter(":CT_OP_ID", (object) gwDiverterItem.CTOPID),
- new OracleParameter(":CM_EXT_NO", (object) gwDiverterItem.CMExtNo),
- new OracleParameter(":CU_EXT_NO", (object) gwDiverterItem.CUExtNo),
- new OracleParameter(":CT_EXT_NO", (object) gwDiverterItem.CTExtNo),
- new OracleParameter(":CM_EXT_PARAMS", (object) gwDiverterItem.CMExtParams),
- new OracleParameter(":CU_EXT_PARAMS", (object) gwDiverterItem.CUExtParams),
- new OracleParameter(":CT_EXT_PARAMS", (object) gwDiverterItem.CTExtParams),
- new OracleParameter(":DMODE", (object) gwDiverterItem.Mode),
- new OracleParameter(":SM_MIN_LENGTH", (object) gwDiverterItem.SmMinLength),
- new OracleParameter(":SM_MAX_LENGTH", (object) gwDiverterItem.SmMaxLength),
- new OracleParameter(":SEGMENTS", (object) gwDiverterItem.Segments),
- new OracleParameter(":KEYWORDS", (object) gwDiverterItem.Keywords),
- new OracleParameter(":PROVINCE", (object) gwDiverterItem.Province),
- new OracleParameter(":EXTNO_MODE", (object) gwDiverterItem.ExtNoMode)
- };
+ {
+ new OracleParameter(":DIVERTER_ID", (object) diverter.DiverterID),
+ new OracleParameter(":CM_OP_ID", (object) gwDiverterItem.CMOPID),
+ new OracleParameter(":CU_OP_ID", (object) gwDiverterItem.CUOPID),
+ new OracleParameter(":CT_OP_ID", (object) gwDiverterItem.CTOPID),
+ new OracleParameter(":CM_EXT_NO", (object) gwDiverterItem.CMExtNo),
+ new OracleParameter(":CU_EXT_NO", (object) gwDiverterItem.CUExtNo),
+ new OracleParameter(":CT_EXT_NO", (object) gwDiverterItem.CTExtNo),
+ new OracleParameter(":CM_EXT_PARAMS", (object) gwDiverterItem.CMExtParams),
+ new OracleParameter(":CU_EXT_PARAMS", (object) gwDiverterItem.CUExtParams),
+ new OracleParameter(":CT_EXT_PARAMS", (object) gwDiverterItem.CTExtParams),
+ new OracleParameter(":DMODE", (object) gwDiverterItem.Mode),
+ new OracleParameter(":SM_MIN_LENGTH", (object) gwDiverterItem.SmMinLength),
+ new OracleParameter(":SM_MAX_LENGTH", (object) gwDiverterItem.SmMaxLength),
+ new OracleParameter(":SEGMENTS", (object) gwDiverterItem.Segments),
+ new OracleParameter(":KEYWORDS", (object) gwDiverterItem.Keywords),
+ new OracleParameter(":PROVINCE", (object) gwDiverterItem.Province),
+ new OracleParameter(":EXTNO_MODE", (object) gwDiverterItem.ExtNoMode)
+ };
list.Add(new KeyValuePair<string, OracleParameter[]>(key2, oracleParameterArray2));
}
OracleHelper.ExecuteSqlTran(list, OracleHelper.Connection);
--
Gitblit v1.9.1