Beispiel #1
0
        /// <summary>
        /// 是否存在该记录
        /// </summary>
        public bool Exists(string C_ACCOUNT)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select count(1) from TS_USER");
            strSql.Append(" where N_TYPE=3 and C_ACCOUNT=:C_ACCOUNT ");
            OracleParameter[] parameters =
            {
                new OracleParameter(":C_ACCOUNT", OracleDbType.Varchar2, 50)
            };
            parameters[0].Value = C_ACCOUNT;

            return(DbHelperOra.Exists(strSql.ToString(), parameters));
        }
        /// <summary>
        /// 是否存在该记录
        /// </summary>
        public bool Exists(string C_ID)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select count(1) from TS_USER_ROLE_PCI");
            strSql.Append(" where C_ID=:C_ID ");
            OracleParameter[] parameters =
            {
                new OracleParameter(":C_ID", OracleDbType.Varchar2, 50)
            };
            parameters[0].Value = C_ID;

            return(DbHelperOra.Exists(strSql.ToString(), parameters));
        }
Beispiel #3
0
        /// <summary>
        /// 是否存在该记录
        /// </summary>
        public bool Exists(string C_ROLE_NAME)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select count(1) from TS_ROLE_PCI");
            strSql.Append(" where N_STATUS=1 and C_ROLE_NAME=:C_ROLE_NAME ");
            OracleParameter[] parameters =
            {
                new OracleParameter(":C_ROLE_NAME", OracleDbType.Varchar2, 20)
            };
            parameters[0].Value = C_ROLE_NAME;

            return(DbHelperOra.Exists(strSql.ToString(), parameters));
        }