/// <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)); }
/// <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)); }