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