public void ReloadData() { //CREATE SOURCE ZView V_ = ZViewList.ViewList.FirstOrDefault(x => x.Name == CurrViewName); BindingSource BS_ = new BindingSource(); BS_.DataSource = DAL_.LoadView(V_.CommandText); GridViewMain.DataSource = BS_; }
private void RibbonButton_Click(object sender, EventArgs e) { //GET CORRESPONDING VIEW CurrViewName = ((RibbonButton)sender).Tag.ToString(); ZView V_ = ZViewList.ViewList.FirstOrDefault(x => x.Name == CurrViewName); //CREATE COLUMNS GridViewMain.AutoGenerateColumns = false; GridViewMain.Columns.Clear(); GridViewMain.VirtualMode = true; foreach (ZColumn col_ in V_.Columns.Where(x => x.Hidden != true)) { if (col_.ColumnType.ToLower() == "bool" || col_.ColumnType.ToLower() == "boolean") { GridViewMain.Columns.Add(new DataGridViewCheckBoxColumn { HeaderText = col_.Caption, FillWeight = col_.Width, Visible = !col_.Visible, DataPropertyName = col_.FieldName }); } else { GridViewMain.Columns.Add(new DataGridViewTextBoxColumn { HeaderText = col_.Caption, FillWeight = col_.Width, Visible = !col_.Visible, DataPropertyName = col_.FieldName }); } } GridViewMain.OpenForm = V_.Name; ReloadData(); //ToDo Custom Summary Column int i_ = 0; ZControls.SummaryColumn[] _SummaryColumn = new ZControls.SummaryColumn[i_]; foreach (ZColumn col_ in V_.Columns.Where(x => x.FooterType != null)) { i_ += 1; Array.Resize(ref _SummaryColumn, i_); ZControls.SummaryColumn.FooterTypes FType_ = (ZControls.SummaryColumn.FooterTypes)System.Enum.Parse(typeof(ZControls.SummaryColumn.FooterTypes), col_.FooterType); _SummaryColumn[i_ - 1] = new ZControls.SummaryColumn { FieldName = col_.FooterFieldName, FooterType = FType_, OutputColumn = col_.FieldName }; } // ZControls.SummaryColumn[] _SummaryColumn = new ZControls.SummaryColumn[] { new ZControls.SummaryColumn { FieldName = "Name", FooterType = ZControls.SummaryColumn.FooterTypes.Count, OutputColumn = "Name"} }; GridViewMain.SummaryColumns = _SummaryColumn; ZControls.SummarySupport.AddSummary(GridViewMain); //Rehide columns foreach (DataGridViewColumn col_ in GridViewMain.Columns) { col_.Visible = !V_.Columns.FirstOrDefault(x => x.FieldName == col_.DataPropertyName).Hidden; } GridViewMain.VirtualMode = false; ribbonMain.ActiveTab = rtMenu; this.Text = V_.Caption; WindowList.WindowInstances.FirstOrDefault(x => x.FormName == "ViewForm").Caption = "Home"; RefreshOrb(); }