コード例 #1
0
        public int UpdatePwd(Oper oper, BusiLog busiLog)
        {
            //SqlConnection conn = ConnectionPool.BorrowConnection();
            int iRet = 0;

            using (SqlConnection conn = ConnectionPool.BorrowConnection())
            {
                //conn.Open();

                SqlTransaction trans = conn.BeginTransaction();
                try
                {
                    iRet = OperAccess.UpdatePwd(trans, oper);
                    BusiLogAccess.AddBusiLog(trans, busiLog);
                    trans.Commit();
                }
                catch (SqlException sex)
                {
                    trans.Rollback();
                    throw sex;
                }
                catch (Exception ex)
                {
                    trans.Rollback();
                    throw ex;
                }
                finally
                {
                    ConnectionPool.ReturnConnection(conn);
                }
            }
            return(iRet);
        }
コード例 #2
0
        public DataTable GetAllOperNoAdmin()
        {
            SqlConnection conn  = ConnectionPool.BorrowConnection();
            DataTable     dtRet = null;

            try
            {
                dtRet = OperAccess.GetAllOperNoAdmin(conn);
            }
            finally
            {
                ConnectionPool.ReturnConnection(conn);
            }
            return(dtRet);
        }
コード例 #3
0
        public Oper GetOper(Oper oper)
        {
            SqlConnection conn    = ConnectionPool.BorrowConnection();
            Oper          OldOper = null;

            try
            {
                OldOper = OperAccess.GetOper(conn, oper);
            }
            finally
            {
                ConnectionPool.ReturnConnection(conn);
            }
            return(OldOper);
        }
コード例 #4
0
        public int AddOper(Oper oper, BusiLog busiLog)
        {
            int iRet = 0;

            using (SqlConnection conn = ConnectionPool.BorrowConnection())
            {
                //conn.Open();

                SqlTransaction trans = conn.BeginTransaction();
                try
                {
                    iRet           = OperIDAccess.GetOperID(trans);
                    oper.cnnOperID = iRet;
                    oper.cnvcPwd   = DataSecurity.Encrypt(oper.cnvcPwd);
                    OperAccess.AddOper(trans, oper);

                    BusiLogAccess.AddBusiLog(trans, busiLog);
                    trans.Commit();
                }
                catch (SqlException sex)
                {
                    trans.Rollback();
                    throw sex;
                }
                catch (Exception ex)
                {
                    trans.Rollback();
                    throw ex;
                }
                finally
                {
                    ConnectionPool.ReturnConnection(conn);
                }
            }
            return(iRet);
        }
コード例 #5
0
ファイル: OperLogin.cs プロジェクト: zhenghua75/ynhnOilManage
        /// <summary>
        /// 执行登录
        /// </summary>
        /// <returns></returns>
        public Oper Login(out ArrayList lstPurview, out ArrayList lstPage)
        {
            SqlConnection conn = ConnectionPool.BorrowConnection();

            try
            {
                #region 取操作员实体

                DataTable dtOper = OperAccess.GetOperByName(conn, strOperName);
                if (dtOper.Rows.Count > 1)
                {
                    throw new BusinessException("操作员登录", "有同名操作员存在,登录失败!");
                }
                // 取操作员实体
                Oper operLogin = new Oper(dtOper);

                if (null == operLogin)
                {
                    throw new BusinessException("操作员登录", "操作员不存在,登录失败!");
                }
                if (!operLogin.cnbValidate)
                {
                    throw new BusinessException("操作员登录", "账号已失效,登录失败!");
                }
                if (operLogin.cnvcPwd != DataSecurity.Encrypt(strPassword))
                {
                    throw new BusinessException("操作员登录", "操作员密码不正确,登录失败!");
                }

                #endregion


                #region 处理操作人员权限

                // 处理操作人员权限
                lstPurview = new ArrayList();
                lstPage    = new ArrayList();
                DataTable dtOperFunc = OperFuncAccess.GetOneOperFuncList(conn, operLogin.cnnOperID.ToString());
                foreach (DataRow row in dtOperFunc.Rows)
                {
                    OperFunc operFunc = new OperFunc(row);
                    lstPurview.Add(operFunc.cnvcFuncName);
                    lstPage.Add(operFunc.cnvcFuncAddress);
                }

                #endregion

                #region 写登录日志

                // 写登录日志
                LoginLog loginLog = new LoginLog();
                loginLog.cnvcOperName  = strOperName;
                loginLog.cnvcIPAddress = strLoginIP;
                loginLog.cnvcBrowser   = strBrowser;
                loginLog.cndLoginTime  = DateTime.Now;
                EntityMapping.Create(loginLog, conn);

                #endregion

                return(operLogin);
            }
            finally
            {
                ConnectionPool.ReturnConnection(conn);
            }
        }