public override int Exists(DB_OPT dbo)
{
StringBuilder builder = new StringBuilder();
builder.Append("select count(1) from GOV_TC_DB_ZSZXFJ");
builder.Append(" where pk='" + base.pk + "' ");
return dbo.BackIsSelect(builder.ToString(), null);
}
public int Exists(string PK, DB_OPT dbo)
{
StringBuilder builder = new StringBuilder();
builder.Append("select count(PK) from GOV_TC_DB_SFProExecuteStandard");
builder.Append(" where PK=:PK");
OracleParameter[] parameters = new OracleParameter[] { new OracleParameter(":PK", OracleType.Char) };
parameters[0].Value = PK;
return dbo.BackIsSelect(builder.ToString(), parameters, "");
}
public override int Exists(DB_OPT dbo)
{
StringBuilder builder = new StringBuilder();
builder.Append("select count(PK) from gov_tc_db_ServicesType");
builder.Append(" where PK=:PK");
OracleParameter[] parameters = new OracleParameter[] { new OracleParameter(":PK", OracleType.VarChar) };
parameters[0].Value = base.PK;
return dbo.BackIsSelect(builder.ToString(), parameters, "");
}
public int Exists(string PK, string tablename, DB_OPT dbo)
{
StringBuilder builder = new StringBuilder();
builder.Append("select count(PK) from " + tablename);
builder.Append(" where PK=:PK");
OracleParameter[] parameters = new OracleParameter[] { new OracleParameter(":PK", OracleType.Char) };
parameters[0].Value = PK;
return dbo.BackIsSelect(builder.ToString(), parameters, "");
}
public override int Exists(DB_OPT dbo)
{
StringBuilder builder = new StringBuilder();
if (base.BH != "")
{
builder.Append("select count(PK) from " + base.TableName + " where BH='" + base.BH + "'");
}
else
{
builder.Append("select count(PK) from " + base.TableName + " where PK='" + base.PK + "'");
}
return dbo.BackIsSelect(builder.ToString(), null);
}
public override int Exists(string PowerCode, DB_OPT dbo)
{
StringBuilder builder = new StringBuilder();
builder.Append("select count(1) from DB_Menu where PowerCode='" + PowerCode + "'");
return dbo.BackIsSelect(builder.ToString(), null);
}
public override int Exists(DB_OPT dbo)
{
StringBuilder builder = new StringBuilder();
builder.Append("select count(1) from DB_Menu where MemuPK='" + base.MemuPK + "'");
return dbo.BackIsSelect(builder.ToString(), null);
}
public override int Exists(string bh, DB_OPT dbo)
{
StringBuilder builder = new StringBuilder();
builder.Append("select count(1) from DB_Role where BH='" + bh + "'");
return dbo.BackIsSelect(builder.ToString(), null);
}
public override int Exists(DB_OPT dbo)
{
StringBuilder builder = new StringBuilder();
builder.Append("select count(1) from GOV_TC_DB_UNITCOUNT where PK='" + base.PK + "'");
return dbo.BackIsSelect(builder.ToString(), null);
}
public override int Exists(DB_OPT dbo)
{
StringBuilder builder = new StringBuilder();
builder.Append("select count(pk_corp) from DB_Company where pk_corp='" + base.pk_corp + "'");
return dbo.BackIsSelect(builder.ToString(), null);
}
public static int IsFlowOK(string pk, DB_OPT dbo)
{
string strSql = "select Count(PK) from GOV_TC_DB_Operation where rtrim(OperationPK)='" + pk.Trim() + "'";
return dbo.BackIsSelect(strSql, null);
}
public override int Exists(string col, string val, DB_OPT dbo)
{
StringBuilder builder = new StringBuilder();
builder.Append("select count(EmployeePK) from DB_Employee where " + col + "='" + val + "'");
return dbo.BackIsSelect(builder.ToString(), null);
}
public override int ExistsByUserPK(DB_OPT dbo)
{
StringBuilder builder = new StringBuilder();
builder.Append("select count(UserPK) from DB_Users where UserPK='" + base.UserPK + "'");
return dbo.BackIsSelect(builder.ToString(), null);
}
public override int Exists(string BH, DB_OPT dbo)
{
StringBuilder builder = new StringBuilder();
builder.Append("select count(1) from " + base.TableName + " where BH='" + BH + "'");
return dbo.BackIsSelect(builder.ToString(), null);
}
public override int Exists(DB_OPT dbo)
{
StringBuilder builder = new StringBuilder();
builder.Append("select count(1) from db_DataRowPowerItem where PK='" + base.PK + "'");
return dbo.BackIsSelect(builder.ToString(), null);
}