public string GetSqlForSelectBuilder(BuilderData data)
{
bool flag;
string str = "";
goto Label_0295;
Label_000C:
if (!flag)
{
str = str + " from " + data.From;
if (0x7fffffff == 0)
{
goto Label_0033;
}
if (8 != 0)
{
goto Label_0109;
}
goto Label_01AE;
}
return(str);
Label_0033:
if (!flag)
{
str = str + " having " + data.Having;
if ((((uint)flag) - ((uint)flag)) <= uint.MaxValue)
{
}
}
str = string.Format("select * from\r\n\t\t\t\t\t\t\t\t\t\t(\r\n\t\t\t\t\t\t\t\t\t\t\tselect {0}, \r\n\t\t\t\t\t\t\t\t\t\t\t\trow_number() over (order by {1}) Ms_Data_ROWNUMBER\r\n\t\t\t\t\t\t\t\t\t\t\t{2}\r\n\t\t\t\t\t\t\t\t\t\t)\r\n\t\t\t\t\t\t\t\t\t\twhere Ms_Data_RowNumber between {3} and {4}\r\n\t\t\t\t\t\t\t\t\t\torder by Ms_Data_RowNumber", new object[] { data.Select, data.OrderBy, str, data.xfe758c7684820895(), data.xf4393586de9748ad() });
if ((((uint)flag) | 0xff) != 0)
{
return(str);
}
goto Label_000C;
Label_00DB:
flag = data.Having.Length <= 0;
if (0 == 0)
{
if (0 != 0)
{
string str2;
return(str2);
}
goto Label_0033;
}
Label_0109:
flag = data.WhereSql.Length <= 0;
if ((((uint)flag) + ((uint)flag)) >= 0)
{
if (!flag)
{
str = str + " where " + data.WhereSql;
}
flag = data.GroupBy.Length <= 0;
if (!flag)
{
str = str + " group by " + data.GroupBy;
}
}
goto Label_00DB;
Label_01AE:
if (data.Having.Length > 0)
{
str = str + " having " + data.Having;
}
if (data.OrderBy.Length <= 0)
{
return(str);
}
return(str + " order by " + data.OrderBy);
Label_01F1:
if (flag)
{
goto Label_01AE;
}
str = str + " group by " + data.GroupBy;
if ((((uint)flag) + ((uint)flag)) < 0)
{
goto Label_00DB;
}
if ((((uint)flag) - ((uint)flag)) >= 0)
{
if (((uint)flag) <= uint.MaxValue)
{
goto Label_01AE;
}
goto Label_0109;
}
goto Label_0295;
Label_0250:
if (!flag)
{
str = str + " where " + data.WhereSql;
if (0 == 0)
{
if ((((uint)flag) <= uint.MaxValue) && (((uint)flag) <= uint.MaxValue))
{
goto Label_0267;
}
goto Label_0250;
}
goto Label_01F1;
}
Label_0267:
flag = data.GroupBy.Length <= 0;
if (0 == 0)
{
goto Label_01F1;
}
goto Label_0250;
Label_0295:
flag = data.PagingItemsPerPage != 0;
if (!flag)
{
str = ("select " + data.Select) + " from " + data.From;
flag = data.WhereSql.Length <= 0;
if (((uint)flag) >= 0)
{
goto Label_0250;
}
goto Label_01F1;
}
flag = data.PagingItemsPerPage <= 0;
goto Label_000C;
}
public string GetSqlForSelectBuilder(BuilderData data)
{
// This item is obfuscated and can not be translated.
string str = "";
str = "select " + data.Select;
str = str + " from " + data.From;
bool flag = data.WhereSql.Length <= 0;
if (0 != 0)
{
goto Label_00FB;
}
goto Label_0153;
Label_0011:
str = str + string.Format(" limit {0}, {1}", data.xfe758c7684820895() - 1, data.xf4393586de9748ad());
if (0 != 0)
{
goto Label_00A4;
}
if (((uint)flag) >= 0)
{
return(str);
}
Label_0054:
if (!flag)
{
goto Label_0011;
}
return(str);
Label_005B:
if (-2 != 0)
{
goto Label_0054;
}
goto Label_0011;
Label_0067:
if (data.PagingItemsPerPage <= 0)
{
}
flag = true;
if (((uint)flag) <= uint.MaxValue)
{
goto Label_005B;
}
goto Label_0011;
Label_00A4:
if (-2 == 0)
{
goto Label_00F3;
}
goto Label_0067;
Label_00B0:
flag = data.OrderBy.Length <= 0;
if ((((uint)flag) + ((uint)flag)) > uint.MaxValue)
{
goto Label_005B;
}
Label_00F3:
while (!flag)
{
str = str + " order by " + data.OrderBy;
goto Label_00A4;
}
if ((((uint)flag) - ((uint)flag)) <= uint.MaxValue)
{
goto Label_0067;
}
goto Label_00A4;
Label_00FB:
str = str + " group by " + data.GroupBy;
Label_010D:
flag = data.Having.Length <= 0;
while (!flag)
{
str = str + " having " + data.Having;
goto Label_00B0;
}
if ((((uint)flag) | 2) != 0)
{
goto Label_00B0;
}
Label_0153:
if (!flag)
{
str = str + " where " + data.WhereSql;
if (0x7fffffff == 0)
{
goto Label_0067;
}
}
flag = data.GroupBy.Length <= 0;
if (flag)
{
goto Label_010D;
}
if (((uint)flag) >= 0)
{
goto Label_00FB;
}
goto Label_00B0;
}
public string GetSqlForSelectBuilder(BuilderData data)
{
// This item is obfuscated and can not be translated.
bool flag;
string str = "";
Label_0141:
str = ("select " + data.Select) + " from " + data.From;
if ((((uint)flag) + ((uint)flag)) >= 0)
{
flag = data.WhereSql.Length <= 0;
if (0x7fffffff != 0)
{
if (!flag)
{
str = str + " where " + data.WhereSql;
}
flag = data.GroupBy.Length <= 0;
if (((((uint)flag) & 0) == 0) && flag)
{
if (-2147483648 == 0)
{
goto Label_000C;
}
}
else
{
str = str + " group by " + data.GroupBy;
}
}
flag = data.Having.Length <= 0;
if (!flag)
{
str = str + " having " + data.Having;
if (0 != 0)
{
goto Label_0141;
}
}
flag = data.OrderBy.Length <= 0;
if (!flag)
{
str = str + " order by " + data.OrderBy;
goto Label_0043;
}
if (((uint)flag) >= 0)
{
goto Label_0043;
}
}
goto Label_004D;
Label_000C:
if (!flag)
{
return(str + string.Format(" limit {0}, {1}", data.xfe758c7684820895() - 1, data.xf4393586de9748ad()));
}
return(str);
Label_0043:
if (data.PagingItemsPerPage <= 0)
{
}
Label_004D:
flag = true;
goto Label_000C;
}
public string GetSqlForSelectBuilder(BuilderData data)
{
bool flag;
string str = "";
if (2 != 0)
{
goto Label_0333;
}
goto Label_0105;
Label_00B7:
flag = data.Having.Length <= 0;
if (!flag)
{
str = str + " having " + data.Having;
if (1 == 0)
{
goto Label_023B;
}
}
str = string.Format("with PagedPersons as\r\n\t\t\t\t\t\t\t\t\t\t(\r\n\t\t\t\t\t\t\t\t\t\t\tselect top 100 percent {0}, row_number() over (order by {1}) as Ms_Data_ROWNUMBER\r\n\t\t\t\t\t\t\t\t\t\t\t{2}\r\n\t\t\t\t\t\t\t\t\t\t)\r\n\t\t\t\t\t\t\t\t\t\tselect *\r\n\t\t\t\t\t\t\t\t\t\tfrom PagedPersons\r\n\t\t\t\t\t\t\t\t\t\twhere Ms_Data_RowNumber between {3} and {4}", new object[] { data.Select, data.OrderBy, str, data.xfe758c7684820895(), data.xf4393586de9748ad() });
if (((uint)flag) > uint.MaxValue)
{
goto Label_016B;
}
return(str);
Label_00E2:
if (!flag)
{
str = str + " group by " + data.GroupBy;
if ((((uint)flag) + ((uint)flag)) > uint.MaxValue)
{
goto Label_00E2;
}
}
goto Label_00B7;
Label_0105:
flag = data.GroupBy.Length <= 0;
goto Label_00E2;
Label_0165:
if (!flag)
{
str = ("select " + data.Select) + " from " + data.From;
flag = data.WhereSql.Length <= 0;
if ((((uint)flag) - ((uint)flag)) > uint.MaxValue)
{
goto Label_00B7;
}
if ((((uint)flag) - ((uint)flag)) > uint.MaxValue)
{
goto Label_017F;
}
goto Label_023B;
}
Label_016B:
flag = data.PagingItemsPerPage <= 0;
if (!flag)
{
str = str + " from " + data.From;
if (data.WhereSql.Length > 0)
{
str = str + " where " + data.WhereSql;
}
goto Label_0105;
}
if (-2 != 0)
{
return(str);
}
if (-1 != 0)
{
string str2;
return(str2);
}
goto Label_00E2;
Label_017F:
if (0 != 0)
{
goto Label_0165;
}
Label_0187:
flag = data.OrderBy.Length <= 0;
if (flag)
{
return(str);
}
str = str + " order by " + data.OrderBy;
if (0 == 0)
{
if ((((uint)flag) - ((uint)flag)) <= uint.MaxValue)
{
return(str);
}
goto Label_0333;
}
Label_01CE:
str = str + " group by " + data.GroupBy;
if ((((uint)flag) + ((uint)flag)) < 0)
{
goto Label_00B7;
}
Label_0200:
flag = data.Having.Length <= 0;
if ((3 != 0) && flag)
{
goto Label_0187;
}
str = str + " having " + data.Having;
goto Label_017F;
Label_023B:
if (((((uint)flag) - ((uint)flag)) < 0) || !flag)
{
str = str + " where " + data.WhereSql;
}
flag = data.GroupBy.Length <= 0;
if (2 != 0)
{
if ((((uint)flag) + ((uint)flag)) <= uint.MaxValue)
{
if (!flag)
{
goto Label_01CE;
}
goto Label_0200;
}
if ((((uint)flag) | 0x80000000) != 0)
{
goto Label_01CE;
}
}
else
{
goto Label_0165;
}
Label_0333:
flag = data.PagingItemsPerPage != 0;
if ((((uint)flag) - ((uint)flag)) >= 0)
{
goto Label_0165;
}
goto Label_01CE;
}
