protected void grid_BeforeGetCallbackResult(object sender, EventArgs e)
{
ASPxGridView g = sender as ASPxGridView;
for (int i = 0; i < g.VisibleRowCount; i++)
{
if (g.IsGroupRow(i) && !g.IsRowExpanded(i) && g.GetRowLevel(i) > 0)
{
g.ExpandRow(i, true);
}
}
}
static GridViewSettings CreateStationGridSettings()
{
EssoEntities DB2 = new EssoEntities();
GridViewSettings settings = new GridViewSettings();
settings.Name = "gvStation";
settings.KeyFieldName = "ID";
settings.CallbackRouteValues = new { Controller = "Station", Action = "GridStationPartial" };
settings.Width = Unit.Percentage(100);
settings.InitNewRow += grid_InitNewRow;
settings.SettingsEditing.Mode = GridViewEditingMode.EditForm;
settings.SettingsEditing.AddNewRowRouteValues = new { Controller = "Station", Action = "SaveStation" };
settings.SettingsEditing.UpdateRowRouteValues = new { Controller = "Station", Action = "UpdateStation" };
settings.SettingsEditing.DeleteRowRouteValues = new { Controller = "Station", Action = "DeleteStation" };
settings.SettingsBehavior.ConfirmDelete = true;
settings.SettingsBehavior.AllowGroup = true;
settings.SettingsBehavior.AllowSort = true;
settings.Settings.VerticalScrollBarMode = ScrollBarMode.Visible;
settings.Settings.VerticalScrollableHeight = 500;
settings.SettingsPager.PageSize = 20;
settings.SettingsPager.Position = PagerPosition.Bottom;
//settings.SettingsPager.FirstPageButton.Visible = true;
//settings.SettingsPager.LastPageButton.Visible = true;
//settings.SettingsPager.PageSizeItemSettings.Visible = true;
//settings.SettingsPager.PageSizeItemSettings.Items = new string[] { "10", "20", "50" };
settings.Settings.ShowFilterRow = true;
settings.Settings.ShowFilterRowMenu = true;
settings.ClientSideEvents.BeginCallback = "OnStationBeginCallback";
//settings.Columns.Add(c =>
//{
// c.FieldName = "PHOTO";
// c.EditorProperties().BinaryImage(p =>
// {
// p.ImageHeight = 170;
// p.ImageWidth = 160;
// p.EnableServerResize = true;
// p.ImageSizeMode = ImageSizeMode.FitProportional;
// p.CallbackRouteValues = new { Action = "BinaryImageColumnPhotoUpdate", Controller = "Station" };
// p.EditingSettings.Enabled = true;
// p.EditingSettings.UploadSettings.UploadValidationSettings.MaxFileSize = 4194304;
// });
//});
settings.Columns.Add(c =>
{
c.FieldName = "NAME";
c.Caption = "Plant Name";
});
settings.Columns.Add(c =>
{ c.FieldName = "SIZE";
c.Caption = "Size"; c.Width = Unit.Pixel(150); });
//settings.Columns.Add(c =>
//{
// c.FieldName = "NAME";
// c.Caption = "Group Name";
// c.Visible = false;
// c.GroupIndex = 0;
// c.EditFormSettings.Visible = DefaultBoolean.False;
// c.EditorProperties().ComboBox(p =>
// {
// p.BindList(DB2.StationGroups.Where(x => x.IS_DELETED == false).Select(x => x.NAME).ToList());
// });
//});
settings.Columns.Add(column => {
column.FieldName = "GROUP_ID";
column.Caption = "Grup";
column.EditorProperties().ComboBox(p =>
{
p.TextField = "NAME";
p.ValueField = "ID";
p.ValueType = typeof(int);
p.DataSource = DB2.StationGroups.Where(x => x.IS_DELETED == false).Select(x => new { x.NAME, x.ID }).ToList();
});
});
//settings.Columns.Add(column =>
//{
// column.FieldName = "GROUP_ID";
// column.Caption = "Group";
// //column.GroupIndex = 0;
// //column.EditFormSettings.Visible = DefaultBoolean.False;
// //column.EditorProperties().ComboBox(p =>
// //{
// // p.BindList(DB2.StationGroups.Where(x => x.IS_DELETED == false).Select(x => x.NAME).ToList());
// //});
//});
settings.Columns.Add(column =>
{
column.FieldName = "USERS";
column.Caption = "Users";
column.EditFormSettings.Visible = DefaultBoolean.False;
});
settings.Columns.Add(column =>
{
column.FieldName = "IP_ADDRESS";
column.Caption = "Ip Address";
});
settings.Columns.Add(column =>
{
column.FieldName = "PORT";
column.Caption = "PORT";
});
settings.Columns.Add(column =>
{
column.FieldName = "ALARM_TEMP_ID";
column.Caption = "Alarm Tipi";
column.Visible = false;
column.EditFormSettings.Visible = DefaultBoolean.True;
});
settings.Columns.Add(column =>
{
column.FieldName = "IS_ACTIVE";
column.Caption = "Active";
column.Width = Unit.Pixel(50);
column.ColumnType = MVCxGridViewColumnType.CheckBox;
});
settings.Columns.Add(column =>
{
column.FieldName = "IS_LOCKED";
column.Caption = "Locked";
column.Width = Unit.Pixel(50);
column.ColumnType = MVCxGridViewColumnType.CheckBox;
});
settings.Columns.Add(c => { c.FieldName = "INSTALL_DATE"; c.Caption = "Installation Date"; c.Width = Unit.Pixel(200); });
settings.Columns.Add(c => { c.FieldName = "CREATED_DATE"; c.Caption = "Inserted Date"; c.Width = Unit.Pixel(200); }); //"CREATED_DATE").SortOrder = DevExpress.Data.ColumnSortOrder.Ascending;
settings.Columns.Add(column =>
{
column.FieldName = "ADDRESS";
column.Caption = "Address";
column.EditFormSettings.Visible = DefaultBoolean.False;
column.Visible = false;
});
settings.Columns.Add(column =>
{
column.FieldName = "DESCRIPTION";
column.Caption = "Desription";
column.EditFormSettings.Visible = DefaultBoolean.False;
column.Visible = false;
});
settings.Columns.Add(column =>
{
column.FieldName = "PLC_INTERFACE";
column.Caption = "PLC INTERFACE";
column.EditFormSettings.Visible = DefaultBoolean.False;
column.Visible = false;
});
settings.Columns.Add(column =>
{
column.FieldName = "EKK_INTERFACE";
column.Caption = "EKK INTERFACE";
column.EditFormSettings.Visible = DefaultBoolean.False;
column.Visible = false;
});
settings.Columns.Add(column =>
{
column.FieldName = "IRRADIATION_SCALE";
column.Caption = "Irradiation Scale(%)";
column.EditFormSettings.Visible = DefaultBoolean.False;
column.Visible = false;
});
settings.BeforeGetCallbackResult = (sender, e) =>
{
MVCxGridView grid = (MVCxGridView)sender;
grid.GroupBy(grid.Columns["GROUP_ID"]);
};
settings.PreRender = (sender, e) =>
{
ASPxGridView grid = (ASPxGridView)sender;
grid.ExpandRow(0);
};
return(settings);
}
