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();
}
