本文整理汇总了C#中SIGEM.Business.SQL.ONSqlSelect.AddWhere方法的典型用法代码示例。如果您正苦于以下问题：C# ONSqlSelect.AddWhere方法的具体用法？C# ONSqlSelect.AddWhere怎么用？C# ONSqlSelect.AddWhere使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类SIGEM.Business.SQL.ONSqlSelect的用法示例。
在下文中一共展示了ONSqlSelect.AddWhere方法的2个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: FixInstance
/// <summary>This method adds to the SQL statement the part that fixes the instance</summary>
/// <param name="onSql">This parameter has the current SQL statement</param>
/// <param name="onPath">Path to add to SQL statement</param>
/// <param name="processedOnPath">Path pocessed until the call of this method</param>
/// <param name="oid">OID to fix the instance in the SQL statement</param>
/// <param name="isLinkedTo">The alias belongs to a role in a linked To element</param>
public static void FixInstance(ONSqlSelect onSql, ONPath onPath, ONPath processedOnPath, AeronaveOid oid, bool isLinkedTo)
{
if ((onPath != null) && (string.Compare(onPath.Path, "agent", true) == 0))
{
if (onSql.GetParameter("agent") == null)
{
string lAlias = AddPath(onSql, JoinType.InnerJoin, "Aeronave", onPath, processedOnPath, "Aeronave", false, isLinkedTo);
onSql.AddWhere(lAlias + "." + CtesBD.FLD_AERONAVE_ID_AERONAVE + " = ?");
onSql.AddWhereParameter("agent", oid.Id_AeronaveAttr);
}
}
else
{
string lAlias = AddPath(onSql, JoinType.InnerJoin, "Aeronave", onPath, processedOnPath, "", false, isLinkedTo);
onSql.AddWhere(lAlias + "." + CtesBD.FLD_AERONAVE_ID_AERONAVE + " = ?");
onSql.AddWhereParameter("", oid.Id_AeronaveAttr);
}
}示例2: FixInstance
/// <summary>This method adds to the SQL statement the part that fixes the instance</summary>
/// <param name="onSql">This parameter has the current SQL statement</param>
/// <param name="onPath">Path to add to SQL statement</param>
/// <param name="processedOnPath">Path pocessed until the call of this method</param>
/// <param name="oid">OID to fix the instance in the SQL statement</param>
/// <param name="isLinkedTo">The alias belongs to a role in a linked To element</param>
public static void FixInstance(ONSqlSelect onSql, ONPath onPath, ONPath processedOnPath, RevisionPasajeroOid oid, bool isLinkedTo)
{
if ((onPath != null) && (string.Compare(onPath.Path, "agent", true) == 0))
{
if (onSql.GetParameter("agent") == null)
{
string lAlias = AddPath(onSql, JoinType.InnerJoin, "RevisionPasajero", onPath, processedOnPath, "RevisionPasajero", false, isLinkedTo);
onSql.AddWhere(lAlias + "." + CtesBD.FLD_REVISIONPASAJERO_ID_REVISIONPASAJERO + " = ?");
onSql.AddWhereParameter("agent", oid.Id_RevisionPasajeroAttr);
}
}
else
{
string lAlias = AddPath(onSql, JoinType.InnerJoin, "RevisionPasajero", onPath, processedOnPath, "", false, isLinkedTo);
onSql.AddWhere(lAlias + "." + CtesBD.FLD_REVISIONPASAJERO_ID_REVISIONPASAJERO + " = ?");
onSql.AddWhereParameter("", oid.Id_RevisionPasajeroAttr);
}
}