public string GetSqlForSelectBuilder(BuilderData data)
{
string str2;
bool flag;
object obj2;
object[] objArray;
string str = "";
if (0 == 0)
{
str = ("select " + data.Select) + " from " + data.From;
flag = data.WhereSql.Length <= 0;
goto Label_028E;
}
goto Label_029D;
Label_0032:
if (!flag)
{
goto Label_0085;
}
return(str);
Label_003D:
objArray = new object[4];
if ((((uint)flag) + ((uint)flag)) >= 0)
{
objArray[0] = obj2;
objArray[1] = " fetch next ";
objArray[2] = data.PagingItemsPerPage;
objArray[3] = " rows only";
str = string.Concat(objArray);
if ((((uint)flag) | 8) != 0)
{
return(str);
}
goto Label_0032;
}
Label_0085:
obj2 = str;
if (3 != 0)
{
goto Label_003D;
}
Label_00D9:
if (0 != 0)
{
goto Label_028E;
}
if ((((uint)flag) - ((uint)flag)) < 0)
{
goto Label_024C;
}
objArray = new object[4];
objArray[0] = obj2;
objArray[1] = " offset ";
if ((((uint)flag) | 0x80000000) != 0)
{
objArray[2] = data.xfe758c7684820895() - 1;
objArray[3] = " rows";
if (((uint)flag) > uint.MaxValue)
{
goto Label_00D9;
}
}
if (0 == 0)
{
str = string.Concat(objArray);
flag = data.PagingItemsPerPage <= 0;
goto Label_0032;
}
if ((((uint)flag) - ((uint)flag)) >= 0)
{
goto Label_0085;
}
goto Label_003D;
Label_015F:
if (!flag)
{
goto Label_01AD;
}
Label_0162:
flag = data.PagingItemsPerPage <= 0;
if (0 != 0)
{
if (15 == 0)
{
goto Label_0199;
}
goto Label_015F;
}
if (flag)
{
return(str);
}
obj2 = str;
if ((((uint)flag) & 0) == 0)
{
goto Label_00D9;
}
if ((((uint)flag) | 2) == 0)
{
}
goto Label_023A;
Label_0199:
flag = data.OrderBy.Length <= 0;
goto Label_015F;
Label_01AD:
str = str + " order by " + data.OrderBy;
if ((((uint)flag) & 0) == 0)
{
goto Label_0162;
}
Label_01D3:
if ((((uint)flag) + ((uint)flag)) < 0)
{
goto Label_024C;
}
if ((((uint)flag) | 15) != 0)
{
if (((uint)flag) < 0)
{
goto Label_01AD;
}
goto Label_0199;
}
goto Label_0162;
Label_023A:
flag = data.GroupBy.Length <= 0;
Label_024C:
if (!flag)
{
str = str + " group by " + data.GroupBy;
}
flag = data.Having.Length <= 0;
if (!flag)
{
str = str + " having " + data.Having;
goto Label_01D3;
}
goto Label_0199;
Label_028E:
if (flag)
{
goto Label_023A;
}
Label_029D:
str = str + " where " + data.WhereSql;
if (0 == 0)
{
goto Label_023A;
}
return(str2);
}
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.
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 = "";
goto Label_01BB;
Label_000F:
return(str + " offset " + (data.xfe758c7684820895() - 1));
Label_0101:
str = str + " having " + data.Having;
Label_0113:
flag = data.OrderBy.Length <= 0;
Label_0071:
if (!flag)
{
str = str + " order by " + data.OrderBy;
if ((((uint)flag) - ((uint)flag)) < 0)
{
string str2;
return(str2);
}
}
flag = data.PagingItemsPerPage <= 0;
if (flag)
{
return(str);
}
if ((((uint)flag) + ((uint)flag)) <= uint.MaxValue)
{
if (-2 != 0)
{
flag = data.PagingItemsPerPage <= 0;
if ((((uint)flag) >= 0) && flag)
{
goto Label_000F;
}
str = str + " limit " + data.PagingItemsPerPage;
}
if (0 == 0)
{
goto Label_000F;
}
goto Label_0071;
}
goto Label_01BB;
Label_0136:
flag = data.GroupBy.Length <= 0;
if ((((uint)flag) | 8) != 0)
{
if (!flag)
{
str = str + " group by " + data.GroupBy;
}
if (data.Having.Length <= 0)
{
goto Label_0113;
}
goto Label_0101;
}
Label_0160:
flag = data.WhereSql.Length <= 0;
do
{
if ((((uint)flag) + ((uint)flag)) >= 0)
{
if (!flag)
{
break;
}
goto Label_0136;
}
}while ((((uint)flag) | uint.MaxValue) == 0);
str = str + " where " + data.WhereSql;
if (1 == 0)
{
goto Label_0101;
}
goto Label_0136;
Label_01BB:
str = ("select " + data.Select) + " from " + data.From;
goto Label_0160;
}
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)
{
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;
}
