/******************** 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); } }