private int _pageRows = 0; //每页行数
/// <summary>
/// 设置表达式条件
/// </summary>
/// <param name="atkExp">表达式</param>
/// <param name="atkUion">操作方法</param>
/// <param name="tableAlias">别名</param>
private void SetConditionStr(System.Linq.Expressions.Expression atkExp, AtkExpUnion atkUion = AtkExpUnion.And, AtkAlias tableAlias = AtkAlias.a0)
{
SetWhere(atkExp, atkUion, tableAlias);//Where条件句
SetOrderBy(atkExp, false, tableAlias);//Order by 语句
}
/// <summary>
/// 设置where语句
/// </summary>
/// <param name="itemstr">表达式</param>
/// <param name="atkUion">操作方法</param>
private void SetWhere(string itemstr, AtkExpUnion atkUion = AtkExpUnion.And)
{
if (string.IsNullOrWhiteSpace(_atkWhereStr))
{
_atkWhereStr = itemstr;
}
else
{
if (atkUion == AtkExpUnion.Or)
{
_atkWhereStr = _atkWhereStr + " Or " + itemstr;
}
else
{
_atkWhereStr = _atkWhereStr + " And " + itemstr;
}
}
}
/// <summary>
/// 设置where语句
/// </summary>
/// <param name="atkExp">表达式</param>
/// <param name="atkUion">操作方法</param>
/// <param name="tableAlias">表别名</param>
private void SetWhere(System.Linq.Expressions.Expression atkExp, AtkExpUnion atkUion = AtkExpUnion.And, AtkAlias tableAlias = AtkAlias.a0)
{
var itemstr = AtkExpressionWriterSql.AtkWhereWriteToString(atkExp, AtkExpSqlType.atkWhere, tableAlias.ToString());
if (string.IsNullOrWhiteSpace(_atkWhereStr))
{
_atkWhereStr = itemstr;
}
else
{
if (atkUion == AtkExpUnion.Or)
{
_atkWhereStr = _atkWhereStr + " Or " + itemstr;
}
else
{
_atkWhereStr = _atkWhereStr + " And " + itemstr;
}
}
}