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