private HtmlSelect CreateSelect(Configuration.SearchInputFieldRow searchInputFieldRow)
{
HtmlSelect select = new HtmlSelect();
using (OleDbCommand command = searchInputFieldRow.GetDatabaseCommand())
{
if (command.Parameters.Count > 0)
{
command.Parameters[0].Value = AppUser.GetRole();
}
using (OleDbDataAdapter adapter = new OleDbDataAdapter(command))
{
DataTable list = new DataTable();
adapter.Fill(list);
select.DataSource = list;
select.DataValueField = list.Columns[0].ColumnName;
select.DataBind();
}
command.Connection.Dispose();
}
select.Items.Insert(0, new ListItem("", ""));
return(select);
}
private void AddInputControl(HtmlControl parent, HtmlControl control, Configuration.SearchInputFieldRow searchInputFieldRow, string className, string tip)
{
parent.Controls.Add(control);
control.Attributes["class"] = "Input " + className;
control.Attributes["data-id"] = searchInputFieldRow.FieldID;
control.Attributes["title"] = tip;
}
private void Autocomplete()
{
string id = Request.QueryString["criteria"];
string text = Request.QueryString["query"];
Configuration config = AppContext.GetConfiguration();
Configuration.SearchInputFieldRow searchInputFieldRow = config.SearchInputField.First(o => o.FieldID == id);
using (OleDbCommand command = searchInputFieldRow.GetDatabaseCommand())
{
command.Parameters[0].Value = text;
if (command.Parameters.Count > 1)
{
command.Parameters[1].Value = AppUser.GetRole();
}
List <string> values = new List <string>();
using (OleDbDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
values.Add(reader.GetString(0));
}
}
command.Connection.Dispose();
Dictionary <String, Object> result = new Dictionary <String, Object>();
result.Add("suggestions", values);
ReturnJson(result);
}
}
private void DefaultMethod()
{
Configuration config = AppContext.GetConfiguration();
Configuration.ApplicationRow applicationRow = config.Application.First(o => o.ApplicationID == Request.Form["app"]);
Configuration.SearchRow searchRow = config.Search.First(o => o.SearchID == Request.Form["search"]);
JavaScriptSerializer serializer = new JavaScriptSerializer();
Dictionary <String, Object> criteria = serializer.Deserialize <Dictionary <String, Object> >(Request.Form["criteria"]);
List <String> levels = new List <String>();
if (!applicationRow.IsZoneLevelIDNull())
{
levels = applicationRow.ZoneLevelRow.GetLevelRows().Select(o => o.LevelID).ToList();
}
List <String> where = new List <String>();
List <Object> parameters = new List <Object>();
foreach (string criteriaID in criteria.Keys)
{
Configuration.SearchInputFieldRow searchInputFieldRow = config.SearchInputField.First(o => o.FieldID == criteriaID);
switch (searchInputFieldRow.FieldType)
{
case "autocomplete":
case "date":
case "list":
case "number":
case "text":
where.Add(searchInputFieldRow.ColumnName + " = ?");
parameters.Add(criteria[criteriaID]);
break;
case "daterange":
case "numberrange":
ArrayList values = (ArrayList)criteria[criteriaID];
if (values[0] != null)
{
where.Add(searchInputFieldRow.ColumnName + " >= ?");
parameters.Add(values[0]);
}
if (values[1] != null)
{
where.Add(searchInputFieldRow.ColumnName + " <= ?");
parameters.Add(values[1]);
}
break;
}
}
Dictionary <String, Object> result = new Dictionary <String, Object>();
using (OleDbCommand command = searchRow.GetSelectCommand())
{
command.CommandText = String.Format(command.CommandText, String.Join(" and ", where.ToArray()));
for (int i = 0; i < parameters.Count; ++i)
{
command.Parameters.AddWithValue(i.ToString(), parameters[i]);
}
using (OleDbDataReader reader = command.ExecuteReader())
{
// get the indexes of the ID columns
int mapIdColumn = reader.GetColumnIndex("MapID");
int dataIdColumn = reader.GetColumnIndex("DataID");
int levelIdColumn = levels.Count > 0 ? reader.GetColumnIndex("LevelID") : -1;
// write the column headers
List <String> headers = new List <String>();
for (int i = 0; i < reader.FieldCount; ++i)
{
if (i != mapIdColumn && i != dataIdColumn && i != levelIdColumn)
{
headers.Add(reader.GetName(i));
}
}
result.Add("headers", headers);
// write the data
List <Dictionary <String, Object> > rows = new List <Dictionary <String, Object> >();
while (reader.Read())
{
if (!reader.IsDBNull(mapIdColumn) && !reader.IsDBNull(dataIdColumn))
{
Dictionary <String, String> id = new Dictionary <String, String>();
id.Add("m", reader.GetValue(mapIdColumn).ToString());
if (dataIdColumn > -1 && !reader.IsDBNull(dataIdColumn))
{
id.Add("d", reader.GetValue(dataIdColumn).ToString());
}
if (levelIdColumn > -1 && !reader.IsDBNull(levelIdColumn))
{
string levelId = reader.GetValue(levelIdColumn).ToString();
if (levels.Contains(levelId))
{
id.Add("l", levelId);
}
}
List <Object> values = new List <Object>();
for (int i = 0; i < reader.FieldCount; ++i)
{
if (i != mapIdColumn && i != dataIdColumn && i != levelIdColumn)
{
values.Add(reader.IsDBNull(i) ? null : reader.GetValue(i));
}
}
Dictionary <String, Object> row = new Dictionary <String, Object>();
row.Add("id", id);
row.Add("v", values);
rows.Add(row);
}
}
result.Add("rows", rows);
}
}
ReturnJson(result);
}
