コード例 #1
0
        public bool EditAdmin(string userName, string loginPassword, string actionPassword, AdminGroupType groupType, string mac)
        {
            var          myconn = MyDBHelper.Instance.CreateConnection();
            MySqlCommand mycmd  = null;

            try
            {
                myconn.Open();
                mycmd = myconn.CreateCommand();

                string cmdTextA = "update admininfo set `UserName` = @UserName, `LoginPassword` = @LoginPassword, `GroupType` = @GroupType, `Mac` = @Mac where `UserName` = @UserName ";

                mycmd.CommandText = cmdTextA;
                mycmd.Parameters.AddWithValue("@UserName", DESEncrypt.EncryptDES(userName));
                mycmd.Parameters.AddWithValue("@LoginPassword", DESEncrypt.EncryptDES(loginPassword));
                mycmd.Parameters.AddWithValue("@ActionPassword", DESEncrypt.EncryptDES(actionPassword));
                mycmd.Parameters.AddWithValue("@GroupType", (int)groupType);
                mycmd.Parameters.AddWithValue("@Mac", mac);
                mycmd.ExecuteNonQuery();

                return(true);
            }
            finally
            {
                MyDBHelper.Instance.DisposeConnection(myconn);
                if (mycmd != null)
                {
                    mycmd.Dispose();
                }
            }
        }
コード例 #2
0
        public bool AddAdmin(string adminUserName, string loginPassword, string actionPassword, AdminGroupType groupType, string mac)
        {
            try
            {
                bool isOK = DBProvider.AdminDBProvider.AddAdmin(adminUserName, loginPassword, actionPassword, groupType, mac);
                if (isOK)
                {
                    this.ListAdmin.Add(new AdminUIModel(new MetaData.User.AdminInfo()
                    {
                        UserName       = adminUserName,
                        LoginPassword  = loginPassword,
                        ActionPassword = actionPassword,
                        GroupType      = groupType,
                        Macs           = new string[] { mac }
                    }));
                }

                return(isOK);
            }
            catch (Exception exc)
            {
                LogHelper.Instance.AddErrorLog("Add Admin Exception", exc);
                return(false);
            }
        }