protected void SetupMultiHeader(DataTable dt) { iti_Tools_Sharp.DynamicHeader dynamicHeader = new iti_Tools_Sharp.DynamicHeader(); //If you want to start with the original header //copy the Columns of the dt into the dynamic header //else you can just create the rows you want to add iti_Tools_Sharp.DynamicHeaderRow firstHeaderRow = new iti_Tools_Sharp.DynamicHeaderRow(); dynamicHeader.Rows.Add(firstHeaderRow); firstHeaderRow.CssClass = "metricsHeader"; iti_Tools_Sharp.DynamicHeaderRow secondHeaderRow = new iti_Tools_Sharp.DynamicHeaderRow(); dynamicHeader.Rows.Add(secondHeaderRow); secondHeaderRow.CssClass = "metricsHeader"; //"metricsSubHeader"; for (int i = 0; i < dt.Columns.Count; i++) { iti_Tools_Sharp.DynamicHeaderCell cell = new iti_Tools_Sharp.DynamicHeaderCell(); cell.Text = dt.Columns[i].ColumnName; firstHeaderRow.Cells.Add(cell); cell.CssClass = "metricsHeader"; cell = new iti_Tools_Sharp.DynamicHeaderCell(); cell.Text = dt.Columns[i].ColumnName; secondHeaderRow.Cells.Add(cell); cell.CssClass = "metricsHeader"; //"metricsSubHeader"; cell.Style["border-top"] = "1px solid grey"; } grdMD.DynamicHeader = dynamicHeader; }
private void loadGridData() { _dtUser = UserManagement.LoadUserList(organizationId: 0, excludeDeveloper: false, loadArchived: false, userNameSearch: ""); Page.ClientScript.RegisterArrayDeclaration("_userList", JsonConvert.SerializeObject(_dtUser, Newtonsoft.Json.Formatting.None)); _dtAllocation_Unused = MasterData.Allocation_Get_All_Unused(); Page.ClientScript.RegisterArrayDeclaration("_Allocation_Unused", JsonConvert.SerializeObject(_dtAllocation_Unused, Newtonsoft.Json.Formatting.None)); DataTable dt = null; if (_refreshData || Session["AllocationGroup_Assignment"] == null) { dt = MasterData.AllocationGroup_Assignment_Get(this._qfWorkAreaID); HttpContext.Current.Session["AllocationGroup_Assignment"] = dt; } else { dt = (DataTable)HttpContext.Current.Session["AllocationGroup_Assignment"]; } if (dt != null) { this.DCC = dt.Columns; Page.ClientScript.RegisterArrayDeclaration("_dcc", JsonConvert.SerializeObject(DCC, Newtonsoft.Json.Formatting.None)); spanRowCount.InnerText = dt.Rows.Count.ToString(); InitializeColumnData(ref dt); dt.AcceptChanges(); iti_Tools_Sharp.DynamicHeader head = WTSUtility.CreateGridMultiHeader(dt); if (head != null) { grdMD.DynamicHeader = head; } int count = dt.Rows.Count; count = count > 0 ? count - 1 : count; spanRowCount.InnerText = count.ToString(); } grdMD.DataSource = dt; grdMD.DataBind(); }
private void loadGridData(bool bind = true) { _dtResources = MasterData.WTS_Resource_Get(includeArchive: false); _dtUser = UserManagement.LoadUserList(organizationId: 0, excludeDeveloper: false, loadArchived: false, userNameSearch: ""); Page.ClientScript.RegisterArrayDeclaration("_userList", JsonConvert.SerializeObject(_dtUser, Newtonsoft.Json.Formatting.None)); DataTable dt = null, dtTemp = null; DataSet ds = null; if (_refreshData || Session["dtMD_AllocationDS"] == null) { ds = MasterData.AllocationList_Get(includeArchive: true); if (ds != null && ds.Tables.Count > 0) { if (ds.Tables.Contains("Allocation")) { dt = ds.Tables["Allocation"]; HttpContext.Current.Session["dtMD_AllocationDS"] = ds; } } } else { ds = (DataSet) HttpContext.Current.Session["dtMD_AllocationDS"]; if (ds.Tables.Contains("Allocation")) { dt = ds.Tables["Allocation"]; } } if (dt != null) { // 12902 - 3: dtTemp = dt.DefaultView.ToTable(true, new string[] { "AllocationGroupID", "AllocationGroup", "AllocationCategoryID", "AllocationCategory" }); dtTemp.DefaultView.RowFilter = "AllocationGroupID IS NOT NULL"; //dtTemp = dt.DefaultView.ToTable(true, new string[] { "AllocationCategoryID", "AllocationCategory" }); //dtTemp.DefaultView.RowFilter = "AllocationCategoryID IS NOT NULL"; dtTemp = dtTemp.DefaultView.ToTable(); this.DCC = dt.Columns; Page.ClientScript.RegisterArrayDeclaration("_dcc", JsonConvert.SerializeObject(DCC, Newtonsoft.Json.Formatting.None)); if (ds.Tables.Contains("Category")) { _dtCat = ds.Tables["Category"]; Page.ClientScript.RegisterArrayDeclaration("_AllocationCategoryList", JsonConvert.SerializeObject(_dtCat, Newtonsoft.Json.Formatting.None)); } //12092 - 3: if (ds.Tables.Contains("Group")) { _dtGroup = ds.Tables["Group"]; Page.ClientScript.RegisterArrayDeclaration("_AllocationGroupList", JsonConvert.SerializeObject(_dtGroup, Newtonsoft.Json.Formatting.None)); } ListItem item = null; foreach (DataRow row in dtTemp.Rows) { item = ddlQF.Items.FindByValue(row["AllocationCategoryID"].ToString()); if (item == null) { ddlQF.Items.Add(new ListItem(row["AllocationCategory"].ToString(), row["AllocationCategoryID"].ToString())); } // 12902 - 3: item = ddlQFGroup.Items.FindByValue(row["AllocationGroupID"].ToString()); if (item == null) { ddlQFGroup.Items.Add(new ListItem(row["AllocationGroup"].ToString(), row["AllocationGroupID"].ToString())); } } // 12092 - 3 - Remarked out: // item = ddlQF.Items.FindByValue(_qfAllocationCategoryID.ToString()); //if (item != null) //{ // item.Selected = true; //} // 12092 - 3: item = ddlQFGroup.Items.FindByValue(_qfAllocationGroupID.ToString()); if (item != null) { item.Selected = true; } InitializeColumnData(ref dt); dt.AcceptChanges(); iti_Tools_Sharp.DynamicHeader head = WTSUtility.CreateGridMultiHeader(dt); if (head != null) { grdMD.DynamicHeader = head; } } // 12902 - 3: if (_qfAllocationGroupID != 0 && dt != null && dt.Rows.Count > 0) { dt.DefaultView.RowFilter = string.Format(" AllocationGroupID = {0}", _qfAllocationGroupID.ToString()); dt = dt.DefaultView.ToTable(); } //if (_qfAllocationCategoryID != 0 && dt != null && dt.Rows.Count > 0) //{ // dt.DefaultView.RowFilter = string.Format(" AllocationCategoryID = {0}", _qfAllocationCategoryID.ToString()); // dt = dt.DefaultView.ToTable(); //} int count = dt.Rows.Count; count = count > 0 ? count - 1 : count; //need to subtract the empty row spanRowCount.InnerText = count.ToString(); if (_export) { exportExcel(dt); } grdMD.DataSource = dt; if (bind) grdMD.DataBind(); }