/******************** GridViews ********************/
/// <summary>
/// Builds gridviews with data from master filter to create the html
/// </summary>
private void BuildGridViews(Frame f, string masterFilter, List<string> inputNames, List<string> sqlList,
List<string> connList, List<string> titleList, List<string> tableWidthList, bool queryDebug)
{
/*
sql_tool_filter=[orderid = value],[customerid = value];
OR
orderid = value, customerid=value
*/
try
{
string pageIdHash = Generic.GetHash(f.IDPage.ToString(CultureInfo.InvariantCulture));
string masterFilterHash = Generic.GetHash(masterFilter);
string filter = filter_sessions.GetMasterFilterString(pageIdHash, masterFilterHash);
if (filter == string.Empty) return;
List<string> inputData = BuildInputDataList(filter, inputNames);
BuildGridview bgv = new BuildGridview(sqlList, connList, inputData, titleList, tableWidthList, queryDebug);
gridviewContainer.Controls.Add(bgv.GetHtmlControls());
}
catch (Exception ex)
{
throw new Exception("error building gridviews " + ex.Message);
}
}
/// <summary>
/// Builds gridviews with data from textbox
/// </summary>
private void BuildGridViews()
{
try
{
List<string> connList = (List<string>) ViewState["conn_list"];
List<string> sqlList = (List<string>) ViewState["sql_list"];
List<string> inputNames = (List<string>) ViewState["input_name"];
List<string> titleList = (List<string>) ViewState["title_list"];
List<string> tableWidthList = (List<string>) ViewState["table_width_list"];
bool queryDebug = (bool) ViewState["query_debug"];
Dictionary<string, object> inputData = BuildInputDataList(inputNames);
if (!(bool) inputData["hasvalue"]) return;
List<string> listData = (List<string>)inputData["data"];
BuildGridview bgv = new BuildGridview(sqlList, connList, listData, titleList, tableWidthList, queryDebug);
gridviewContainer.Controls.Add(bgv.GetHtmlControls());
}
catch (Exception ex)
{
throw new Exception("error building gridviews " + ex.Message);
}
}
