private void loadGridData() { DataTable dt = null; if (_refreshData || Session["AllocationGroup"] == null) { dt = MasterData.AllocationGroup_Get(); HttpContext.Current.Session["AllocationGroup"] = dt; } else { dt = (DataTable)HttpContext.Current.Session["AllocationGroup"]; } 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(); int count = dt.Rows.Count; count = count > 0 ? count - 1: count; spanRowCount.InnerText = count.ToString(); } if (_export && dt != null && CanView) { exportExcel(dt); } grdMD.DataSource = dt; grdMD.DataBind(); }
private void loadGridDataAA() { _dtSystem = MasterData.SystemList_Get(includeArchive: false, cv: cvValue); if (_dtSystem != null && _qfSystemID != 0) { _dtSystem.DefaultView.RowFilter = string.Format(" WTS_SYSTEMID IN (0, {0}) ", _qfSystemID.ToString()); _dtSystem = _dtSystem.DefaultView.ToTable(); } _dtALLOCATION = MasterData.WorkAreaList_Get(includeArchive: false, cv: cvValue); if (_dtALLOCATION != null && _qfWorkAreaID != 0) { _dtALLOCATION.DefaultView.RowFilter = string.Format(" ALLOCATIONID = {0} ", _qfALLOCATIONID.ToString()); _dtALLOCATION = _dtALLOCATION.DefaultView.ToTable(); } _dtAllocationGroup = MasterData.AllocationGroup_Get(); DataTable dt = MasterData.WorkArea_SystemList_Get(workAreaID: this._qfALLOCATIONID, systemID: this._qfSystemID, cv: cvValue); if (dt != null) { //if (_qfSystemID > 0) //{ // dt.Columns["WTS_SYSTEM"].SetOrdinal(dt.Columns["ALLOCATIONID"].Ordinal); // dt.Columns["WTS_SYSTEMID"].SetOrdinal(dt.Columns["WTS_SYSTEM"].Ordinal); // dt.AcceptChanges(); //} this.DCCAA = dt.Columns; Page.ClientScript.RegisterArrayDeclaration("_dcc", JsonConvert.SerializeObject(DCCAA, Newtonsoft.Json.Formatting.None)); ListItem item = null; foreach (DataRow row in _dtALLOCATION.Rows) { item = ddlQF.Items.FindByValue(row["ALLOCATIONID"].ToString()); if (item == null) { ddlQF.Items.Add(new ListItem(row["ALLOCATION"].ToString(), row["ALLOCATIONID"].ToString())); } } item = ddlQF.Items.FindByValue(_qfWorkAreaID.ToString()); if (item != null) { item.Selected = true; } foreach (DataRow row in _dtSystem.Rows) { item = ddlQF_System.Items.FindByValue(row["WTS_SYSTEMID"].ToString()); if (item == null) { ddlQF_System.Items.Add(new ListItem(row["WTS_SYSTEM"].ToString(), row["WTS_SYSTEMID"].ToString())); } } item = ddlQF_System.Items.FindByValue(_qfSystemID.ToString()); if (item != null) { item.Selected = true; } InitializeColumnDataAA(ref dt); dt.AcceptChanges(); } if (_qfWorkAreaID != 0 && dt != null && dt.Rows.Count > 0) { dt.DefaultView.RowFilter = string.Format(" ALLOCATIONID = {0} OR (ALLOCATIONID = 0 AND WTS_SYSTEMID = 0) ", _qfWorkAreaID.ToString()); dt = dt.DefaultView.ToTable(); } if (_qfSystemID != 0 && dt != null && dt.Rows.Count > 0) { dt.DefaultView.RowFilter = string.Format(" WTS_SYSTEMID = {0} OR (WTS_SYSTEMID = 0 AND ALLOCATIONID = 0) OR WTS_SYSTEMID IS NULL ", _qfSystemID.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(); grdMD.DataSource = dt; grdMD.DataBind(); }