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