public string Query()
{
string str = base.Request.Form["Title"];
string str2 = base.Request.Form["Address"];
string str3 = base.Request.Form["typeid"];
string text = base.Request.Form["sidx"];
string text2 = base.Request.Form["sord"];
RoadFlow.Platform.Dictionary dictionary = new RoadFlow.Platform.Dictionary();
RoadFlow.Platform.AppLibrary appLibrary = new RoadFlow.Platform.AppLibrary();
string type = str3.IsGuid() ? appLibrary.GetAllChildsIDString(str3.ToGuid()) : "";
int pageSize = Tools.GetPageSize();
int pageNumber = Tools.GetPageNumber();
string order = (text.IsNullOrEmpty() ? "Title" : text) + " " + (text2.IsNullOrEmpty() ? "asc" : text2);
long count;
List <RoadFlow.Data.Model.AppLibrary> pagerData = appLibrary.GetPagerData(out count, pageSize, pageNumber, str.Trim1(), type, str2.Trim1(), order);
JsonData jsonData = new JsonData();
foreach (RoadFlow.Data.Model.AppLibrary item in pagerData)
{
string empty = string.Empty;
empty = ((!item.Ico.IsFontIco()) ? ("<img src=\"" + item.Ico.Trim1() + "\" style=\"vertical-align:middle;\" />") : ("<i class=\"fa " + item.Ico.Trim1() + "\" style=\"font-size:14px;vertical-align:middle;" + (item.Color.IsNullOrEmpty() ? "" : ("color:" + item.Color + ";")) + "\"></i>"));
JsonData jsonData2 = new JsonData();
jsonData2["id"] = item.ID.ToString();
jsonData2["Title"] = empty + "<span style=\"vertical-align:middle;margin-left:4px;\">" + item.Title + "</span>";
jsonData2["Address"] = item.Address;
jsonData2["TypeTitle"] = dictionary.GetTitle(item.Type);
jsonData2["Opation"] = "<a class=\"editlink\" href=\"javascript:void(0);\" onclick=\"edit('" + item.ID.ToString() + "');return false;\" style=\"margin-right:6px;\">编辑</a><a class=\"editlink\" href=\"javascript:void(0);\" onclick=\"editsubpage('" + item.ID.ToString() + "');return false;\">子页面</a>";
jsonData.Add(jsonData2);
}
return("{\"userdata\":{\"total\":" + count + ",\"pagesize\":" + pageSize + ",\"pagenumber\":" + pageNumber + "},\"rows\":" + jsonData.ToJson() + "}");
}
public DataTable GetExportDataTable(Guid programID, out string template, out string headerText, out string fileName)
{
template = "";
headerText = "";
fileName = "";
ProgramBuilderCache set = this.GetSet(programID);
if (set == null)
{
return(new DataTable());
}
template = Files.FilePath + set.Program.ExportTemplate.DesDecrypt();
headerText = set.Program.ExportHeaderText;
fileName = set.Program.ExportFileName;
string querySql;
List <IDbDataParameter> parList;
DataTable dataTable1 = new DBConnection().GetDataTable(this.GetExportCache(programID, out querySql, out parList), querySql, (IDataParameter[])parList.ToArray());
List <RoadFlow.Data.Model.ProgramBuilderExport> export = set.Export;
DataTable dataTable2 = new DataTable();
foreach (RoadFlow.Data.Model.ProgramBuilderExport programBuilderExport in export)
{
string showTitle = programBuilderExport.ShowTitle;
int? nullable = programBuilderExport.DataType;
int type;
if (!nullable.HasValue)
{
type = 0;
}
else
{
nullable = programBuilderExport.DataType;
type = nullable.Value;
}
Type exportColumnsType = this.GetExportColumnsType(type);
DataColumn column = new DataColumn(showTitle, exportColumnsType);
DataColumn dataColumn = column;
nullable = programBuilderExport.Width;
string str = nullable.ToString();
dataColumn.Caption = str;
dataTable2.Columns.Add(column);
}
int num = 1;
Dictionary dictionary = new Dictionary();
Organize organize = new Organize();
foreach (DataRow row1 in (InternalDataCollectionBase)dataTable1.Rows)
{
DataRow row2 = dataTable2.NewRow();
foreach (RoadFlow.Data.Model.ProgramBuilderExport programBuilderExport in export)
{
object empty = (object)string.Empty;
object obj1 = programBuilderExport.Field.IsNullOrEmpty() ? (object)"" : row1[programBuilderExport.Field];
int? showType = programBuilderExport.ShowType;
object obj2;
if (showType.HasValue)
{
switch (showType.GetValueOrDefault())
{
case 0:
obj2 = obj1;
goto label_24;
case 1:
obj2 = (object)num.ToString();
goto label_24;
case 2:
obj2 = (object)obj1.ToString().ToDateTime().ToString(programBuilderExport.ShowFormat);
goto label_24;
case 3:
obj2 = (object)obj1.ToString().ToDecimal().ToString(programBuilderExport.ShowFormat);
goto label_24;
case 4:
obj2 = (object)dictionary.GetTitle(obj1.ToString().ToGuid());
goto label_24;
case 5:
obj2 = (object)organize.GetNames(obj1.ToString(), ",");
goto label_24;
case 6:
obj2 = (object)programBuilderExport.CustomString;
goto label_24;
}
}
obj2 = obj1;
label_24:
row2[programBuilderExport.ShowTitle] = obj2;
}
++num;
dataTable2.Rows.Add(row2);
}
return(dataTable2);
}
public DataTable GetExportDataTable(Guid programID, out string template, out string headerText, out string fileName)
{
template = "";
headerText = "";
fileName = "";
ProgramBuilderCache set = GetSet(programID);
if (set == null)
{
return(new DataTable());
}
template = Files.FilePath + set.Program.ExportTemplate.DesDecrypt();
headerText = set.Program.ExportHeaderText;
fileName = set.Program.ExportFileName;
string querySql;
List <IDbDataParameter> parList;
Guid exportCache = GetExportCache(programID, out querySql, out parList);
DBConnection dBConnection = new DBConnection();
Guid connID = exportCache;
string sql = querySql;
IDataParameter[] param = parList.ToArray();
DataTable dataTable = dBConnection.GetDataTable(connID, sql, param);
List <RoadFlow.Data.Model.ProgramBuilderExport> export = set.Export;
DataTable dataTable2 = new DataTable();
foreach (RoadFlow.Data.Model.ProgramBuilderExport item in export)
{
DataColumn dataColumn = new DataColumn(item.ShowTitle, GetExportColumnsType(item.DataType.HasValue ? item.DataType.Value : 0));
dataColumn.Caption = item.Width.ToString();
dataTable2.Columns.Add(dataColumn);
}
int num = 1;
Dictionary dictionary = new Dictionary();
Organize organize = new Organize();
foreach (DataRow row in dataTable.Rows)
{
DataRow dataRow2 = dataTable2.NewRow();
foreach (RoadFlow.Data.Model.ProgramBuilderExport item2 in export)
{
object empty = string.Empty;
object obj = item2.Field.IsNullOrEmpty() ? "" : row[item2.Field];
switch (item2.ShowType)
{
case 0:
empty = obj;
break;
case 1:
empty = num.ToString();
break;
case 2:
empty = obj.ToString().ToDateTime().ToString(item2.ShowFormat);
break;
case 3:
empty = obj.ToString().ToDecimal().ToString(item2.ShowFormat);
break;
case 4:
empty = dictionary.GetTitle(obj.ToString().ToGuid());
break;
case 5:
empty = organize.GetNames(obj.ToString());
break;
case 6:
empty = item2.CustomString;
break;
default:
empty = obj;
break;
}
dataRow2[item2.ShowTitle] = empty;
}
num++;
dataTable2.Rows.Add(dataRow2);
}
return(dataTable2);
}
public ActionResult Index()
{
RoadFlow.Platform.Dictionary dictionary = new RoadFlow.Platform.Dictionary();
string obj = base.Request.QueryString["values"] ?? "";
string text7 = base.Request.QueryString["rootid"];
string text = base.Request.QueryString["datasource"];
string str = base.Request.QueryString["sql"];
DataTable dataTable = new DataTable();
if ("1" == text)
{
string str2 = base.Request.QueryString["dbconn"];
RoadFlow.Platform.DBConnection dBConnection = new RoadFlow.Platform.DBConnection();
RoadFlow.Data.Model.DBConnection dbconn = dBConnection.Get(str2.ToGuid());
dataTable = dBConnection.GetDataTable(dbconn, str.UrlDecode().FilterWildcard().ReplaceSelectSql());
}
StringBuilder stringBuilder = new StringBuilder();
string[] array = obj.Split(',');
foreach (string text2 in array)
{
if (!text2.IsNullOrEmpty())
{
if (!(text == "0"))
{
if (text == "1")
{
string value = string.Empty;
foreach (DataRow row in dataTable.Rows)
{
if (text2 == row[0].ToString())
{
value = ((dataTable.Columns.Count > 1) ? row[1].ToString() : text2);
break;
}
}
stringBuilder.AppendFormat("<div onclick=\"currentDel=this;showinfo('{0}');\" class=\"selectorDiv\" ondblclick=\"currentDel=this;del();\" value=\"{0}\">", text2);
stringBuilder.Append(value);
stringBuilder.Append("</div>");
continue;
}
if (text == "2")
{
string text3 = base.Request.QueryString["url2"];
if (!text3.IsNullOrEmpty())
{
text3 = ((text3.IndexOf('?') >= 0) ? (text3 + "&values=" + text2) : (text3 + "?values=" + text2));
StringBuilder stringBuilder2 = new StringBuilder();
try
{
TextWriter writer = new StringWriter(stringBuilder2);
base.Server.Execute(text3, writer);
}
catch
{
}
stringBuilder.AppendFormat("<div onclick=\"currentDel=this;showinfo('{0}');\" class=\"selectorDiv\" ondblclick=\"currentDel=this;del();\" value=\"{0}\">", text2);
stringBuilder.Append(stringBuilder2.ToString());
stringBuilder.Append("</div>");
}
continue;
}
if (text == "3")
{
string str3 = base.Request.QueryString["dbconn"];
string text4 = base.Request.QueryString["dbtable"];
string text5 = base.Request.QueryString["valuefield"];
string text6 = base.Request.QueryString["titlefield"];
string text8 = base.Request.QueryString["parentfield"];
string str4 = base.Request.QueryString["where1"];
RoadFlow.Platform.DBConnection dBConnection2 = new RoadFlow.Platform.DBConnection();
RoadFlow.Data.Model.DBConnection dbconn2 = dBConnection2.Get(str3.ToGuid());
string str5 = "select " + text6 + " from " + text4 + " where " + text5 + "='" + text2 + "'";
DataTable dataTable2 = dBConnection2.GetDataTable(dbconn2, str5.ReplaceSelectSql());
string value2 = string.Empty;
if (dataTable2.Rows.Count > 0)
{
value2 = dataTable2.Rows[0][0].ToString();
}
stringBuilder.AppendFormat("<div onclick=\"currentDel=this;showinfo('{0}');\" class=\"selectorDiv\" ondblclick=\"currentDel=this;del();\" value=\"{0}\">", text2);
stringBuilder.Append(value2);
stringBuilder.Append("</div>");
ViewBag.where = str4.UrlEncode();
continue;
}
}
Guid test;
if (text2.IsGuid(out test))
{
stringBuilder.AppendFormat("<div onclick=\"currentDel=this;showinfo('{0}');\" class=\"selectorDiv\" ondblclick=\"currentDel=this;del();\" value=\"{0}\">", text2);
stringBuilder.Append(dictionary.GetTitle(test));
stringBuilder.Append("</div>");
}
}
}
base.ViewBag.defaultValuesString = stringBuilder.ToString().Trim1();
return(View());
}
