From 2f74eb23c0d2d4a246bc612c5c34bdfa8dea5603 Mon Sep 17 00:00:00 2001
From: wzp <2040239371@qq.com>
Date: 星期五, 11 十一月 2022 09:25:02 +0800
Subject: [PATCH] 修改账号产品关联的bug 修改产品不显示的bug

---
 web/Dao/UserDao.cs |   78 +++++++++++++++++++-------------------
 1 files changed, 39 insertions(+), 39 deletions(-)

diff --git a/web/Dao/UserDao.cs b/web/Dao/UserDao.cs
index 3e8e6d3..77aa6bb 100644
--- a/web/Dao/UserDao.cs
+++ b/web/Dao/UserDao.cs
@@ -1,4 +1,4 @@
-锘� 
+锘�
 using Common;
 using Model;
 using Oracle.DataAccess.Client;
@@ -14,7 +14,7 @@
     //璐﹀彿澶勭悊
     public class UserDao : IDisposable
     {
-        public bool CheckLogin(string account, string password, SysUser user)//鐢ㄦ埛鐧诲綍
+        public bool CheckLogin(string account, string password,SysUser user)//鐢ㄦ埛鐧诲綍
         {
             string str1 = ConfigurationManager.AppSettings["CopyID"];
             string str2 = "my@smgw" + str1.Substring(str1.Length - 6);
@@ -52,7 +52,7 @@
                     recordCount = this.ReadCount(reader);
             }
             //using (OracleDataReader reader = OracleHelper.ExecuteReader(PubConstant.doOracleSql(pageIndex, pageSize, recordCount, "select * from Sys_User").ToString(), OracleHelper.Connection))
-            using (OracleDataReader reader = OracleHelper.ExecuteReader(PubConstant.doOracleSql(pageIndex, pageSize, recordCount, "select * " + stringBuilder.ToString() ).ToString(), OracleHelper.Connection))
+            using (OracleDataReader reader = OracleHelper.ExecuteReader(PubConstant.doOracleSql(pageIndex, pageSize, recordCount, "select * " + stringBuilder.ToString()).ToString(), OracleHelper.Connection))
             {
                 while (((DbDataReader)reader).Read())
                 {
@@ -81,7 +81,7 @@
             return dictionary;
         }
 
-            public Dictionary<string, SysUserMenu> LoadUserRoleMenuList(int userID)
+        public Dictionary<string, SysUserMenu> LoadUserRoleMenuList(int userID)
         {
             StringBuilder stringBuilder = new StringBuilder();
 
@@ -95,11 +95,11 @@
                     stringBuilder.Append(" select sm.* from sys_menu sm ");
                     stringBuilder.Append(" left join ( ");
                     stringBuilder.Append(" select distinct * from ( ");
-                    stringBuilder.Append(" select * from sys_role_menu where role_id = " + list[0] + " ");
+                    stringBuilder.Append(" select * from sys_role_menu where role_id ='" + list[0] + "' ");
 
                     for (int i = 1; i < list.Count; i++)
                     {
-                        stringBuilder.Append(" union (select * from sys_role_menu where role_id = " + list[i] + ") ");
+                        stringBuilder.Append(" union (select * from sys_role_menu where role_id = '" + list[i] + "') ");
 
                     }
                     stringBuilder.Append(" ) bb ");
@@ -153,40 +153,40 @@
         }
 
         //鏂板姞鐧婚檰鏃ュ織
-         public List<SysMenu> LoadSysMenuIDList(int menuid, int menulv)
-    {
-      List<SysMenu> list = new List<SysMenu>();
-      using (OracleDataReader reader = OracleHelper.ExecuteReader("select * from SYS_MENU WHERE MENU_LV=1 ORDER BY MENU_ID", OracleHelper.Connection))
-      {
-        while (reader != null)
+        public List<SysMenu> LoadSysMenuIDList(int menuid, int menulv)
         {
-          if (((DbDataReader) reader).Read())
-            list.Add(this.ReadSysMenu(reader));
-          else
-            break;
+            List<SysMenu> list = new List<SysMenu>();
+            using (OracleDataReader reader = OracleHelper.ExecuteReader("select * from SYS_MENU WHERE MENU_LV=1 ORDER BY MENU_ID", OracleHelper.Connection))
+            {
+                while (reader != null)
+                {
+                    if (((DbDataReader)reader).Read())
+                        list.Add(this.ReadSysMenu(reader));
+                    else
+                        break;
+                }
+            }
+            return list;
         }
-      }
-      return list;
-    }
 
 
-         public SysMenu GetMenuID(int refid)
-         {
-             SysMenu sysMenu = new SysMenu();
-             using (OracleDataReader reader = OracleHelper.ExecuteReader(string.Format("select * from SYS_MENU WHERE MENU_ID=:MENU_ID"), OracleHelper.Connection, new OracleParameter(":MENU_ID", (object)refid)))
-             {
-                 if (((DbDataReader)reader).Read())
-                 {
-                     sysMenu = this.ReadSysMenu(reader);
-                     return sysMenu;
-                 }
-             }
-             return sysMenu;
-         }
+        public SysMenu GetMenuID(int refid)
+        {
+            SysMenu sysMenu = new SysMenu();
+            using (OracleDataReader reader = OracleHelper.ExecuteReader(string.Format("select * from SYS_MENU WHERE MENU_ID=:MENU_ID"), OracleHelper.Connection, new OracleParameter(":MENU_ID", (object)refid)))
+            {
+                if (((DbDataReader)reader).Read())
+                {
+                    sysMenu = this.ReadSysMenu(reader);
+                    return sysMenu;
+                }
+            }
+            return sysMenu;
+        }
 
 
 
-//
+        //
 
         private SysMenu ReadSysMenu(OracleDataReader reader)
         {
@@ -210,7 +210,6 @@
             e.Salt = oracleReaderWrapper.GetString("SALT", "");
             e.UserName = oracleReaderWrapper.GetString("USER_NAME", "");
             e.UserType = oracleReaderWrapper.GetString("USER_TYPE", "");
-            e.RoleNames = oracleReaderWrapper.GetString("ROLE_NAMES", "");            
             e.ExpireTime = oracleReaderWrapper.GetDateTime("EXPIRE_TIME");
             e.CreateTime = oracleReaderWrapper.GetDateTime("CREATE_TIME");
             e.Remark = oracleReaderWrapper.GetString("REMARK", "");
@@ -223,6 +222,7 @@
             e.IsVerification = oracleReaderWrapper.GetInt("ISVERIFICATION", 0);
             e.ClientIp = oracleReaderWrapper.GetString("CLIENTIP", "");
             e.Status = oracleReaderWrapper.GetInt("STATUS", 0);
+            e.RoleNames = oracleReaderWrapper.GetString("Role_Names","");
             return true;
         }
 
@@ -297,14 +297,14 @@
         {
             //return Convert.ToInt32(OracleHelper.ExecuteScalar("select COUNT(*) from SYS_USER WHERE USER_NAME=:USER_NAME AND USER_ID!=:USER_ID", OracleHelper.Connection, new OracleParameter(":USER_NAME", (object)userName), new OracleParameter(":USER_ID", (object)userId))) > 0;
 
-            using (OracleDataReader reader = OracleHelper.ExecuteReader("select * from SYS_USER WHERE USER_NAME=:USER_NAME ", OracleHelper.Connection, new OracleParameter(":USER_NAME", (object)userName) ))
+            using (OracleDataReader reader = OracleHelper.ExecuteReader("select * from SYS_USER WHERE USER_NAME=:USER_NAME ", OracleHelper.Connection, new OracleParameter(":USER_NAME", (object)userName)))
             {
                 while (((DbDataReader)reader).Read())
                 {
                     SysUser e = new SysUser();
                     if (this.ReadInfo(reader, e))
                     {
-                        if(e.UserID!= userId)
+                        if (e.UserID != userId)
                         {
                             return true;
                         }
@@ -317,7 +317,7 @@
 
         public bool Update(SysUser o)//淇敼璐﹀彿
         {
-            return OracleHelper.ExecuteSql("update SYS_USER SET ACCOUNT=:ACCOUNT, USER_NAME=:USER_NAME,USER_TYPE=:USER_TYPE,EXPIRE_TIME=:EXPIRE_TIME,REMARK=:REMARK,MOBILE=:MOBILE,EMAIL=:EMAIL,MOBILE_FLAG=:MOBILE_FLAG,EMAIL_FLAG=:EMAIL_FLAG,ISENCRYPTION=:ISENCRYPTION,ISVERIFICATION=:ISVERIFICATION,CLIENTIP=:CLIENTIP,CREATE_TIME=:CREATE_TIME WHERE USER_ID=:USER_ID", OracleHelper.Connection, new OracleParameter(":ACCOUNT", (object)o.Account), new OracleParameter(":USER_NAME", (object)o.UserName), new OracleParameter(":USER_TYPE", (object)o.UserType), new OracleParameter(":EXPIRE_TIME", (object)o.ExpireTime), new OracleParameter(":REMARK", (object)o.Remark), new OracleParameter(":USER_ID", (object)o.UserID), new OracleParameter(":MOBILE", (object)o.Mobile), new OracleParameter(":EMAIL", (object)o.Email), new OracleParameter(":MOBILE_FLAG", (object)o.MobileFlag), new OracleParameter(":EMAIL_FLAG", (object)o.EmailFlag), new OracleParameter(":ISENCRYPTION", (object)o.IsEncryption), new OracleParameter(":ISVERIFICATION", (object)o.IsVerification), new OracleParameter(":CLIENTIP", (object)o.ClientIp), new OracleParameter(":CREATE_TIME", (object)o.CreateTime) ) > 0;
+            return OracleHelper.ExecuteSql("update SYS_USER SET ACCOUNT=:ACCOUNT, USER_NAME=:USER_NAME,USER_TYPE=:USER_TYPE,EXPIRE_TIME=:EXPIRE_TIME,REMARK=:REMARK,MOBILE=:MOBILE,EMAIL=:EMAIL,MOBILE_FLAG=:MOBILE_FLAG,EMAIL_FLAG=:EMAIL_FLAG,ISENCRYPTION=:ISENCRYPTION,ISVERIFICATION=:ISVERIFICATION,CLIENTIP=:CLIENTIP,CREATE_TIME=:CREATE_TIME WHERE USER_ID=:USER_ID", OracleHelper.Connection, new OracleParameter(":ACCOUNT", (object)o.Account), new OracleParameter(":USER_NAME", (object)o.UserName), new OracleParameter(":USER_TYPE", (object)o.UserType), new OracleParameter(":EXPIRE_TIME", (object)o.ExpireTime), new OracleParameter(":REMARK", (object)o.Remark), new OracleParameter(":USER_ID", (object)o.UserID), new OracleParameter(":MOBILE", (object)o.Mobile), new OracleParameter(":EMAIL", (object)o.Email), new OracleParameter(":MOBILE_FLAG", (object)o.MobileFlag), new OracleParameter(":EMAIL_FLAG", (object)o.EmailFlag), new OracleParameter(":ISENCRYPTION", (object)o.IsEncryption), new OracleParameter(":ISVERIFICATION", (object)o.IsVerification), new OracleParameter(":CLIENTIP", (object)o.ClientIp), new OracleParameter(":CREATE_TIME", (object)o.CreateTime)) > 0;
         }
 
         //鏇存柊鐘舵��
@@ -328,7 +328,7 @@
 
         public bool Add(SysUser e)//娣诲姞璐﹀彿
         {
-            return OracleHelper.ExecuteSql("INSERT INTO SYS_USER(USER_ID,ACCOUNT,PASSWORD, SALT, USER_NAME, USER_TYPE, EXPIRE_TIME,REMARK,MOBILE,EMAIL,MOBILE_FLAG,EMAIL_FLAG,ISENCRYPTION,ISVERIFICATION,CLIENTIP,CREATE_TIME) VALUES(SYS_USER_ID_SEQ.NextVal,:ACCOUNT,:PASSWORD, :SALT, :USER_NAME,:USER_TYPE,:EXPIRE_TIME,:REMARK,:MOBILE,:EMAIL,:MOBILE_FLAG,:EMAIL_FLAG,:ISENCRYPTION,:ISVERIFICATION,:CLIENTIP,:CREATE_TIME)", OracleHelper.Connection, new OracleParameter(":ACCOUNT", (object)e.Account), new OracleParameter(":PASSWORD", (object)e.Password), new OracleParameter(":SALT", (object)e.Salt), new OracleParameter(":USER_NAME", (object)e.UserName), new OracleParameter(":USER_TYPE", (object)e.UserType), new OracleParameter(":EXPIRE_TIME", (object)e.ExpireTime), new OracleParameter(":REMARK", (object)e.Remark), new OracleParameter(":MOBILE", (object)e.Mobile), new OracleParameter(":EMAIL", (object)e.Email), new OracleParameter(":MOBILE_FLAG", (object)e.MobileFlag), new OracleParameter(":EMAIL_FLAG", (object)e.EmailFlag), new OracleParameter(":ISENCRYPTION", (object)e.IsEncryption), new OracleParameter(":ISVERIFICATION", (object)e.IsVerification), new OracleParameter(":CLIENTIP", (object)e.ClientIp), new OracleParameter(":CREATE_TIME", (object)e.CreateTime) ) > 0;
+            return OracleHelper.ExecuteSql("INSERT INTO SYS_USER(USER_ID,ACCOUNT,PASSWORD, SALT, USER_NAME, USER_TYPE, EXPIRE_TIME,REMARK,MOBILE,EMAIL,MOBILE_FLAG,EMAIL_FLAG,ISENCRYPTION,ISVERIFICATION,CLIENTIP,CREATE_TIME) VALUES(SYS_USER_ID_SEQ.NextVal,:ACCOUNT,:PASSWORD, :SALT, :USER_NAME,:USER_TYPE,:EXPIRE_TIME,:REMARK,:MOBILE,:EMAIL,:MOBILE_FLAG,:EMAIL_FLAG,:ISENCRYPTION,:ISVERIFICATION,:CLIENTIP,:CREATE_TIME)", OracleHelper.Connection, new OracleParameter(":ACCOUNT", (object)e.Account), new OracleParameter(":PASSWORD", (object)e.Password), new OracleParameter(":SALT", (object)e.Salt), new OracleParameter(":USER_NAME", (object)e.UserName), new OracleParameter(":USER_TYPE", (object)e.UserType), new OracleParameter(":EXPIRE_TIME", (object)e.ExpireTime), new OracleParameter(":REMARK", (object)e.Remark), new OracleParameter(":MOBILE", (object)e.Mobile), new OracleParameter(":EMAIL", (object)e.Email), new OracleParameter(":MOBILE_FLAG", (object)e.MobileFlag), new OracleParameter(":EMAIL_FLAG", (object)e.EmailFlag), new OracleParameter(":ISENCRYPTION", (object)e.IsEncryption), new OracleParameter(":ISVERIFICATION", (object)e.IsVerification), new OracleParameter(":CLIENTIP", (object)e.ClientIp), new OracleParameter(":CREATE_TIME", (object)e.CreateTime)) > 0;
         }
 
         public bool UpdatePassword(int userID, string oldPassword, string newPassword)
@@ -339,7 +339,7 @@
         //鍔犲瘑鐩愪慨鏀瑰瘑鐮�
         public bool UpdatePwd(string account, string password)
         {
-            return OracleHelper.ExecuteSql("UPDATE SYS_USER SET PASSWORD=:PASSWORD WHERE ACCOUNT=:ACCOUNT", OracleHelper.Connection, new OracleParameter(":ACCOUNT", (object)account), new OracleParameter(":PASSWORD", (object)password) ) > 0;
+            return OracleHelper.ExecuteSql("UPDATE SYS_USER SET PASSWORD=:PASSWORD WHERE ACCOUNT=:ACCOUNT", OracleHelper.Connection, new OracleParameter(":ACCOUNT", (object)account), new OracleParameter(":PASSWORD", (object)password)) > 0;
         }
 
         public void UpdatePermission(int userid, string[] menuIDArray)

--
Gitblit v1.9.1