public GridEditColumnBuilder <T> CheckBoxFor(string name, Func <T, bool> func)
{
var column = new GridCheckBoxColumn <T>(GridModel, name, func);
GridModel.ColumnList.Add(column);
return(new GridEditColumnBuilder <T>(column));
}
public GridCheckBoxColumn AddCheckBoxColumn(string dataField, string headerText)
{
GridCheckBoxColumn c = new GridCheckBoxColumn();
_grid.MasterTableView.Columns.Add(c);
c.DataField = dataField;
c.HeaderText = headerText;
return(c);
}
public override void AttachProperties(GridColumn gridColumn)
{
base.AttachProperties(gridColumn);
GridCheckBoxColumn column = (GridCheckBoxColumn)gridColumn;
column.DataField = DataFieldKey;
column.ReadOnly = IsReadOnly;
}
/// <summary>
/// Formats a Grid Column based on the Settings
/// </summary>
/// <param name = "setting"></param>
public static GridColumn FormatGridColumn(GridViewColumn setting)
{
GridColumn column;
switch (setting.Type.ToLower())
{
case "image":
column = new GridImageColumn();
//((GridImageColumn)column) = new Bitmap(1, 1); // Default empty Image
break;
case "process":
column = new GridPercentColumn();
break;
case "check":
column = new GridCheckBoxColumn();
break;
case "rating":
//column = new DataGridViewRatingColumn();
column = new GridTextColumn();
break;
default:
column = new GridTextColumn();
break;
}
column.HeaderText = setting.Title;
column.IsReadOnly = setting.Readonly;
column.IsHidden = !setting.Display;
column.Width = setting.Width;
//column.IsFrozen = setting.Frozen;
// For columns bound to a data Source set the property
//if (setting.Bound)
//{
column.MappingName = setting.Name;
//}
switch (setting.Type.ToLower())
{
case "text":
case "process":
// column.ValueType = typeof(string);
break;
case "number":
case "check":
case "rating":
// column.ValueType = typeof(int);
break;
}
return(column);
}
private void CargarRadGrid2()
{
//DataTable dt = new DataTable();
DataSet dsAccionesModulos = new DataSet();
//DataTable dtAcciones = new DataTable();
DataTable dtModulos = new DataTable();
string mensaje = string.Empty;
dsAccionesModulos = perfiles.ModuloConsultar(ref mensaje);
if (!mensaje.Equals(string.Empty))
{
(this.Master as Principal).AlertError(mensaje);
}
//Dividir tablas de consulta
dtAcciones = dsAccionesModulos.Tables[0];
RadGrid3.DataSource = dtAcciones == null ? new DataTable() : dtAcciones;
RadGrid3.DataBind();
dtModulos = dsAccionesModulos.Tables[1];
//Agregar columnas al RadGrid2
GridCheckBoxColumn boundColumn1;
foreach (DataRow drAccion in dtAcciones.Rows)
{
string sAccion = drAccion["Accion"].ToString();
if (RadGrid2.MasterTableView.Columns.Contains(sAccion))
{
continue;
}
boundColumn1 = new GridCheckBoxColumn();
RadGrid2.MasterTableView.Columns.Add(boundColumn1);
boundColumn1.DataField = sAccion;
boundColumn1.ToolTip = sAccion;
boundColumn1.HeaderText = sAccion;
boundColumn1.UniqueName = sAccion.Replace(" ", "");
boundColumn1.HeaderStyle.Width = 70;
boundColumn1.ItemStyle.HorizontalAlign = HorizontalAlign.Center;
boundColumn1.Visible = true;
}
RadGrid2.DataSource = dtModulos == null ? new DataTable() : dtModulos;
RadGrid2.DataBind();
CargarAcciones();
}
public Form1()
{
InitializeComponent();
sfDataGrid.AutoGenerateColumns = false;
sfDataGrid.DataSource = new ViewModel().Orders;
sfDataGrid.LiveDataUpdateMode = LiveDataUpdateMode.AllowDataShaping;
sfDataGrid.AllowEditing = true;
sfDataGrid.AutoSizeColumnsMode = AutoSizeColumnsMode.AllCells;
sfDataGrid.AddNewRowPosition = RowPosition.Top;
GridNumericColumn gridTextColumn1 = new GridNumericColumn()
{
MappingName = "OrderID", HeaderText = "Order ID"
};
GridTextColumn gridTextColumn2 = new GridTextColumn()
{
MappingName = "CustomerID", HeaderText = "Customer ID", AllowEditing = true
};
GridTextColumn gridTextColumn3 = new GridTextColumn()
{
MappingName = "CustomerName", HeaderText = "Customer Name"
};
GridTextColumn gridTextColumn4 = new GridTextColumn()
{
MappingName = "Country", HeaderText = "Country"
};
GridTextColumn gridTextColumn5 = new GridTextColumn()
{
MappingName = "ShipCity", HeaderText = "Ship City"
};
GridCheckBoxColumn checkBoxColumn = new GridCheckBoxColumn()
{
MappingName = "IsShipped", HeaderText = "Is Shipped"
};
// enable the context menu for new records
sfDataGrid.RecordContextMenu = new ContextMenuStrip();
sfDataGrid.RecordContextMenu.Items.Add("Copy", null, OnBuscarMenuClicked);
sfDataGrid.Columns.Add(gridTextColumn1);
sfDataGrid.Columns.Add(gridTextColumn2);
sfDataGrid.Columns.Add(gridTextColumn3);
sfDataGrid.Columns.Add(gridTextColumn4);
sfDataGrid.Columns.Add(gridTextColumn5);
sfDataGrid.Columns.Add(checkBoxColumn);
sfDataGrid.TableControl.MouseUp += SfDataGrid_MouseUp;
}
public Form1()
{
InitializeComponent();
sfDataGrid.AutoGenerateColumns = false;
sfDataGrid.DataSource = new ViewModel().Orders;
sfDataGrid.ShowRowHeader = true;
sfDataGrid.LiveDataUpdateMode = LiveDataUpdateMode.AllowDataShaping;
sfDataGrid.ShowGroupDropArea = true;
GridTextColumn gridTextColumn1 = new GridTextColumn()
{
MappingName = "OrderID", HeaderText = "Order ID"
};
GridTextColumn gridTextColumn2 = new GridTextColumn()
{
MappingName = "CustomerID", HeaderText = "Customer ID"
};
GridTextColumn gridTextColumn3 = new GridTextColumn()
{
MappingName = "CustomerName", HeaderText = "Customer Name"
};
GridTextColumn gridTextColumn4 = new GridTextColumn()
{
MappingName = "Country", HeaderText = "Country"
};
GridTextColumn gridTextColumn5 = new GridTextColumn()
{
MappingName = "ShipCity", HeaderText = "Ship City"
};
GridCheckBoxColumn checkBoxColumn = new GridCheckBoxColumn()
{
MappingName = "IsShipped", HeaderText = "Is Shipped"
};
sfDataGrid.Columns.Add(gridTextColumn1);
sfDataGrid.Columns.Add(gridTextColumn2);
sfDataGrid.Columns.Add(gridTextColumn3);
sfDataGrid.Columns.Add(gridTextColumn4);
sfDataGrid.Columns.Add(gridTextColumn5);
sfDataGrid.Columns.Add(checkBoxColumn);
btnExportExcel.Click += BtnExportExcel_Click;
sfDataGrid.DrawCell += SfDataGrid_DrawCell;
}
public Form1()
{
InitializeComponent();
//To add custom renderer into SfDataGrid.
this.sfDataGrid.CellRenderers.Add("TextButton", new GridTextButtonCellRenderer(this.sfDataGrid));
sfDataGrid.AutoGenerateColumns = false;
sfDataGrid.DataSource = new ViewModel().Orders;
sfDataGrid.LiveDataUpdateMode = LiveDataUpdateMode.AllowDataShaping;
GridTextColumn gridTextColumn1 = new GridTextColumn()
{
MappingName = "OrderID", HeaderText = "Order ID"
};
GridTextColumn gridTextColumn3 = new GridTextColumn()
{
MappingName = "CustomerName", HeaderText = "Customer Name"
};
GridTextColumn gridTextColumn4 = new GridTextColumn()
{
MappingName = "Country", HeaderText = "Country"
};
GridTextColumn gridTextColumn5 = new GridTextColumn()
{
MappingName = "ShipCity", HeaderText = "Ship City"
};
GridCheckBoxColumn checkBoxColumn = new GridCheckBoxColumn()
{
MappingName = "IsShipped", HeaderText = "Is Shipped"
};
//To add TextButtonColumn in grid
this.sfDataGrid.Columns.Add(new GridTextButtonColumn()
{
MappingName = "CustomerID", Width = 140
});
sfDataGrid.Columns.Add(gridTextColumn1);
sfDataGrid.Columns.Add(gridTextColumn3);
sfDataGrid.Columns.Add(gridTextColumn4);
sfDataGrid.Columns.Add(gridTextColumn5);
sfDataGrid.Columns.Add(checkBoxColumn);
}
private GridColumn CreateSfColumn(Field field, int i)
{
GridColumn result;
DataType t = field.SchemaType == SchemaType.Data
? ((DataField)field).DataType
: DataType.String;
if (t == DataType.Int32 ||
t == DataType.Float ||
t == DataType.Double ||
t == DataType.Decimal)
{
result = new GridNumericColumn();
}
else if (t == DataType.DateTimeOffset)
{
result = new GridDateTimeColumn();
}
else if (t == DataType.Boolean)
{
result = new GridCheckBoxColumn();
}
else
{
result = new GridTextColumn()
{
TextWrapping = TextWrapping.NoWrap
};
}
result.MappingName = $"[{i}]";
result.HeaderText = field.Name;
result.AllowFiltering = false;
result.AllowFocus = true;
result.AllowResizing = true;
result.AllowSorting = true;
result.FilterBehavior = FilterBehavior.StronglyTyped;
result.AllowEditing = true;
return(result);
}
private GridColumn CreateSfColumn(Series s, int i)
{
GridColumn result;
if (s.DataType == typeof(int) ||
s.DataType == typeof(float) ||
s.DataType == typeof(double) ||
s.DataType == typeof(decimal))
{
result = new GridNumericColumn();
}
else if (s.DataType == typeof(DateTime) ||
s.DataType == typeof(DateTimeOffset))
{
result = new GridDateTimeColumn();
}
else if (s.DataType == typeof(bool))
{
result = new GridCheckBoxColumn();
}
else
{
result = new GridTextColumn();
}
result.MappingName = $"[{i}]";
result.HeaderText = s.Name;
result.AllowFiltering = false;
result.AllowFocus = true;
result.AllowResizing = true;
result.AllowSorting = true;
result.FilterBehavior = FilterBehavior.StronglyTyped;
result.AllowEditing = true;
result.ShowToolTip = false;
result.ShowHeaderToolTip = true;
result.HeaderToolTipTemplate = _headerTooltipTemplate;
return(result);
}
private GridColumn CreateSfColumn(SchemaElement se, int i)
{
GridColumn result;
if (se.ElementType == typeof(int) ||
se.ElementType == typeof(float) ||
se.ElementType == typeof(double) ||
se.ElementType == typeof(decimal))
{
result = new GridNumericColumn();
}
else if (se.ElementType == typeof(DateTime) ||
se.ElementType == typeof(DateTimeOffset))
{
result = new GridDateTimeColumn();
}
else if (se.ElementType == typeof(bool))
{
result = new GridCheckBoxColumn();
}
else
{
result = new GridTextColumn();
}
result.MappingName = $"[{i}]";
result.HeaderText = se.Name;
result.AllowFiltering = false;
result.AllowFocus = true;
result.AllowResizing = true;
result.AllowSorting = true;
result.FilterBehavior = FilterBehavior.StronglyTyped;
result.AllowEditing = true;
return(result);
}
public static void BindTelerikGrid(
ref RadGrid Grid
, DataTable Dt_Source
, List<ClsBindGridColumn_Web_Telerik> List_Gc
, string Key = ""
, bool AllowSort = true
, bool HasDelete = false
, eSelectorType SelectorType = eSelectorType.None
)
{
Grid.DataSource = Dt_Source;
if (Grid.Columns.Count > 0)
{ Grid.Columns.Clear(); }
Grid.AutoGenerateColumns = false;
if (SelectorType != eSelectorType.None)
{
Grid.ClientSettings.Selecting.AllowRowSelect = true;
Grid.ClientSettings.Selecting.UseClientSelectColumnOnly = true;
}
Grid.AllowMultiRowSelection = SelectorType == eSelectorType.Multiple;
//Grid.ClientSettings.Resizing.AllowColumnResize = true;
//Grid.ClientSettings.Resizing.AllowResizeToFit = true;
TableItemStyle Tis = null;
foreach (ClsBindGridColumn_Web_Telerik Inner_Gc in List_Gc)
{
if (!Inner_Gc.mIsVisible)
{
continue;
}
switch (Inner_Gc.mFieldType)
{
case Layer01_Constants.eSystem_Lookup_FieldType.FieldType_Text:
{
GridBoundColumn Gc = new GridBoundColumn();
Grid.Columns.Add(Gc);
Gc.HeaderStyle.Width = Inner_Gc.mUnit_Width;
Gc.HeaderText = Inner_Gc.mFieldDesc;
Gc.DataField = Inner_Gc.mFieldName;
Gc.ReadOnly = !Inner_Gc.mEnabled;
Gc.DataFormatString = Inner_Gc.mDataFormat;
if (AllowSort)
{ Gc.HeaderButtonType = GridHeaderButtonType.LinkButton; }
Gc.SortExpression = Inner_Gc.mFieldName;
Tis = Gc.ItemStyle;
break;
}
case Layer01_Constants.eSystem_Lookup_FieldType.FieldType_Checkbox:
{
GridCheckBoxColumn Gc = new GridCheckBoxColumn();
Grid.Columns.Add(Gc);
Gc.HeaderStyle.Width = Inner_Gc.mUnit_Width;
Gc.DataField = Inner_Gc.mFieldName;
Gc.HeaderText = Inner_Gc.mFieldDesc;
Gc.ReadOnly = !Inner_Gc.mEnabled;
if (AllowSort)
{ Gc.HeaderButtonType = GridHeaderButtonType.LinkButton; }
Gc.SortExpression = Inner_Gc.mFieldName;
Tis = Gc.ItemStyle;
break;
}
case Layer01_Constants.eSystem_Lookup_FieldType.FieldType_DateTime:
{
GridDateTimeColumn Gc = new Telerik.Web.UI.GridDateTimeColumn();
Grid.Columns.Add(Gc);
Gc.HeaderStyle.Width = Inner_Gc.mUnit_Width;
Gc.DataField = Inner_Gc.mFieldName;
Gc.HeaderText = Inner_Gc.mFieldDesc;
Gc.ReadOnly = !Inner_Gc.mEnabled;
Gc.DataFormatString = Inner_Gc.mDataFormat;
if (AllowSort)
{ Gc.HeaderButtonType = GridHeaderButtonType.LinkButton; }
Gc.SortExpression = Inner_Gc.mFieldName;
Tis = Gc.ItemStyle;
break;
}
case Layer01_Constants.eSystem_Lookup_FieldType.FieldType_Button:
{
GridButtonColumn Gc = new GridButtonColumn();
Grid.Columns.Add(Gc);
Gc.HeaderStyle.Width = Inner_Gc.mUnit_Width;
Gc.HeaderText = Inner_Gc.mFieldDesc;
Gc.CommandName = Inner_Gc.mCommandName;
if (Inner_Gc.mFieldName == "")
{ Gc.Text = Inner_Gc.mFieldText; }
else
{ Gc.DataTextField = Inner_Gc.mFieldName; }
switch (Inner_Gc.mButtonType)
{
case ButtonColumnType.PushButton:
Gc.ButtonType = Telerik.Web.UI.GridButtonColumnType.PushButton;
break;
case ButtonColumnType.LinkButton:
Gc.ButtonType = Telerik.Web.UI.GridButtonColumnType.LinkButton;
break;
}
Tis = Gc.ItemStyle;
break;
}
case Layer01_Constants.eSystem_Lookup_FieldType.FieldType_HyperLink:
{
GridHyperLinkColumn Gc = new GridHyperLinkColumn();
Grid.Columns.Add(Gc);
Gc.HeaderStyle.Width = Inner_Gc.mUnit_Width;
Gc.HeaderText = Inner_Gc.mFieldDesc;
Gc.Text = Inner_Gc.mFieldText;
Gc.DataNavigateUrlFormatString = Inner_Gc.mFieldNavigateUrl_Text;
Gc.DataNavigateUrlFields = new string[] { Inner_Gc.mFieldNavigateUrl_Field };
Tis = Gc.ItemStyle;
break;
}
default:
{
GridBoundColumn Gc = new GridBoundColumn();
Grid.Columns.Add(Gc);
Gc.HeaderStyle.Width = Inner_Gc.mUnit_Width;
Gc.HeaderText = Inner_Gc.mFieldDesc;
Gc.DataField = Inner_Gc.mFieldName;
Gc.ReadOnly = true;
Gc.DataFormatString = Inner_Gc.mDataFormat;
if (AllowSort)
{ Gc.HeaderButtonType = GridHeaderButtonType.LinkButton; }
Tis = Gc.ItemStyle;
break;
}
}
//Tis.Width = Inner_Gc.mUnit_Width;
}
if (HasDelete) { }
switch (SelectorType)
{
case eSelectorType.Single:
case eSelectorType.Multiple:
{
GridClientSelectColumn Gc = new GridClientSelectColumn();
Grid.Columns.Insert(0, Gc);
Gc.UniqueName = "Select";
Gc.HeaderText = "";
Gc.HeaderStyle.Width = new Unit("40px");
break;
}
}
if (Key != "")
{ Grid.MasterTableView.DataKeyNames = new string[] { Key }; }
Grid.DataBind();
}
public static void GenerateColumnsSfDataGrid(SfDataGrid dataGrid, DataTable table, string prefab)
{
using (var conn = new SqlConnection(App.ConnectionString))
{
conn.Open();
if (!string.IsNullOrEmpty(prefab))
{
DataTable prefabTable = App.GetPrefabDataTable(conn, $"{App.Settings["Schema"]}_PREFABS", prefab);
DataTable comboTable =
App.GetPrefabDataTable(conn, $"{App.Settings["Schema"]}_COMBOBOXES", prefab);
//could loop by table.ColumnNames.Count; but if prebab is changed... problems; maybe not all columns showing
for (var i = 0; i < table.Columns.Count; i++)
{
GridColumn column;
try
{
if (prefabTable.Rows[i]["TYPES"].ToString().ToLower().Equals("autocomplete"))
{
var comboStrings = new HashSet <string>();
for (var j = 0; j < comboTable.Rows.Count; j++)
{
if (!string.IsNullOrEmpty(
comboTable.Rows[j][prefabTable.Rows[i]["COLUMNS"].ToString()].ToString()))
{
comboStrings.Add(comboTable.Rows[j][prefabTable.Rows[i]["COLUMNS"].ToString()]
.ToString());
}
}
StringBuilder sb1 = new StringBuilder();
sb1.AppendLine(
"<DataTemplate xmlns=\"http://schemas.microsoft.com/winfx/2006/xaml/presentation\" xmlns:x=\"http://schemas.microsoft.com/winfx/2006/xaml\">");
sb1.AppendLine("<ComboBox PlaceholderText=\"{Binding " + prefabTable.Rows[i]["COLUMNS"] +
", Mode=TwoWay}\" IsEditable=\"True\" IsTextSearchEnabled=\"True\" IsDropDownOpen=\"True\" >");
foreach (var comboString in comboStrings)
{
sb1.AppendLine($"<x:String>{comboString}</x:String>");
}
sb1.AppendLine("</ComboBox>");
sb1.AppendLine("</DataTemplate>");
DataTemplate cellTemplate = (DataTemplate)XamlReader.Load(sb1.ToString());
column = new GridTemplateColumn
{
MappingName = table.Columns[i].ColumnName,
HeaderText = prefabTable.Rows[i]["COLUMNS"].ToString(),
EditTemplate = cellTemplate
};
dataGrid.Columns.Add(column);
}
else if (prefabTable.Rows[i]["TYPES"].ToString().ToLower().Equals("datepicker"))
{
column = new GridDateTimeColumn
{
MappingName = table.Columns[i].ColumnName,
FormatString = "MM/dd/yyyy",
AllowInlineEditing = true,
AllowNullValue = true,
HeaderText = prefabTable.Rows[i]["COLUMNS"].ToString(),
WaterMark = string.Empty
};
dataGrid.Columns.Add(column);
}
else if (prefabTable.Rows[i]["TYPES"].ToString().ToLower().Equals("checkbox"))
{
column = new GridCheckBoxColumn
{
MappingName = table.Columns[i].ColumnName,
IsThreeState = false,
HeaderText = prefabTable.Rows[i]["COLUMNS"].ToString()
};
dataGrid.Columns.Add(column);
}
else if (prefabTable.Rows[i]["TYPES"].ToString().ToLower().Equals("numeric"))
{
column = new GridNumericColumn
{
MappingName = table.Columns[i].ColumnName,
HeaderText = prefabTable.Rows[i]["COLUMNS"].ToString(),
MaximumNumberDecimalDigits = 3
};
dataGrid.Columns.Add(column);
} /*
* else if (prefabTable.Rows[i]["TYPES"].ToString().ToLower().Equals("currency"))
* {
* column = new GridCurrencyColumn
* {
* MappingName = table.Columns[i].ColumnName,
* HeaderText = prefabTable.Rows[i]["COLUMNS"].ToString()
* };
*
* dataGrid.Columns.Add(column);
* }*/
else if (prefabTable.Rows[i]["TYPES"].ToString().ToLower().Equals("hyperlink"))
{
column = new GridHyperlinkColumn
{
MappingName = table.Columns[i].ColumnName,
HeaderText = prefabTable.Rows[i]["COLUMNS"].ToString()
};
dataGrid.Columns.Add(column);
} /*
* else if (prefabTable.Rows[i]["TYPES"].ToString().ToLower().Equals("percentage"))
* {
* column = new GridPercentColumn
* {
* MappingName = table.Columns[i].ColumnName,
* HeaderText = prefabTable.Rows[i]["COLUMNS"].ToString()
* };
*
* dataGrid.Columns.Add(column);
* }*/
else if (prefabTable.Rows[i]["TYPES"].ToString().ToLower().Equals("combobox"))
{
var comboStrings = new HashSet <string>();
for (var j = 0; j < comboTable.Rows.Count; j++)
{
if (!string.IsNullOrEmpty(
comboTable.Rows[j][prefabTable.Rows[i]["COLUMNS"].ToString()].ToString()))
{
comboStrings.Add(comboTable.Rows[j][prefabTable.Rows[i]["COLUMNS"].ToString()]
.ToString());
}
}
column = new GridComboBoxColumn
{
MappingName = table.Columns[i].ColumnName,
ItemsSource = comboStrings,
HeaderText = prefabTable.Rows[i]["COLUMNS"].ToString()
};
dataGrid.Columns.Add(column);
}
else
{
column = new GridTextColumn
{
MappingName = table.Columns[i].ColumnName,
HeaderText = prefabTable.Rows[i]["COLUMNS"].ToString()
};
dataGrid.Columns.Add(column);
} //TODO: More? CalendarDatePicker, TimePicker, DatePicker, Slider, ToggleSwitch, RichEditBox, PasswordBox, ColorPicker, ComboBox, RatingControl
}
catch
{
column = new GridTextColumn
{
MappingName = table.Columns[i].ColumnName,
HeaderText = table.Columns[i].ColumnName
};
dataGrid.Columns.Add(column);
}
}
}
else
{
foreach (DataColumn column in table.Columns)
{
GridColumn gridColumn = new GridTextColumn
{
MappingName = column.ColumnName,
HeaderText = column.ColumnName
};
dataGrid.Columns.Add(gridColumn);
}
}
conn.Close();
}
}
protected void gv_presencia_ColumnCreated(object sender, GridColumnCreatedEventArgs e)
{
if (e.Column.UniqueName == "nodocomercial")
{
e.Column.Visible = false;
GridBoundColumn boundColumn = e.Column as GridBoundColumn;
boundColumn.ReadOnly = true;
//boundColumn.DataFormatString = "{0:d}";
}
else if (e.Column.UniqueName == "Ciudad")
{
GridBoundColumn boundColumn = e.Column as GridBoundColumn;
boundColumn.ReadOnly = true;
}
else if (e.Column.UniqueName == "Mercaderista")
{
GridBoundColumn boundColumn = e.Column as GridBoundColumn;
boundColumn.ReadOnly = true;
}
else if (e.Column.UniqueName == "Supervisoras")
{
GridBoundColumn boundColumn = e.Column as GridBoundColumn;
boundColumn.ReadOnly = true;
}
else if (e.Column.UniqueName == "Direccion")
{
e.Column.Visible = false;
GridBoundColumn boundColumn = e.Column as GridBoundColumn;
boundColumn.ReadOnly = true;
}
else if (e.Column.UniqueName == "Distrito")
{
e.Column.Visible = false;
GridBoundColumn boundColumn = e.Column as GridBoundColumn;
boundColumn.ReadOnly = true;
}
else if (e.Column.UniqueName == "Dni/Ruc")
{
e.Column.Visible = false;
GridBoundColumn boundColumn = e.Column as GridBoundColumn;
boundColumn.ReadOnly = true;
}
else if (e.Column.UniqueName == "Telefono")
{
e.Column.Visible = false;
GridBoundColumn boundColumn = e.Column as GridBoundColumn;
boundColumn.ReadOnly = true;
}
else if (e.Column.UniqueName == "Distribuidora")
{
e.Column.Visible = false;
GridBoundColumn boundColumn = e.Column as GridBoundColumn;
boundColumn.ReadOnly = true;
}
else if (e.Column.UniqueName == "CodDistrib")
{
e.Column.Visible = false;
GridBoundColumn boundColumn = e.Column as GridBoundColumn;
boundColumn.ReadOnly = true;
}
else if (e.Column.UniqueName == "opreport")
{
e.Column.Visible = false;
GridBoundColumn boundColumn = e.Column as GridBoundColumn;
boundColumn.ReadOnly = true;
}
else if (e.Column.UniqueName == "id_mercaderista")
{
e.Column.Visible = false;
GridBoundColumn boundColumn = e.Column as GridBoundColumn;
boundColumn.ReadOnly = true;
}
else if (e.Column.UniqueName == "PDV_Client")
{
GridBoundColumn boundColumn = e.Column as GridBoundColumn;
boundColumn.ReadOnly = true;
}
else if (e.Column.UniqueName == "Total Dis")
{
GridBoundColumn boundColumn = e.Column as GridBoundColumn;
boundColumn.ReadOnly = true;
}
else if (e.Column.UniqueName == "% Distb")
{
GridBoundColumn boundColumn = e.Column as GridBoundColumn;
boundColumn.ReadOnly = true;
}
else if (e.Column.UniqueName == "% Distb ")
{
GridBoundColumn boundColumn = e.Column as GridBoundColumn;
boundColumn.ReadOnly = true;
}
else if (e.Column.UniqueName == "01 A 07 SKUs")
{
GridBoundColumn boundColumn = e.Column as GridBoundColumn;
boundColumn.ReadOnly = true;
}
else if (e.Column.UniqueName == "08 A 13 SKUs")
{
GridBoundColumn boundColumn = e.Column as GridBoundColumn;
boundColumn.ReadOnly = true;
}
else if (e.Column.UniqueName == "14 A 17 SKUs")
{
GridBoundColumn boundColumn = e.Column as GridBoundColumn;
boundColumn.ReadOnly = true;
}
else if (e.Column.UniqueName == "18 A Más SKUs")
{
GridBoundColumn boundColumn = e.Column as GridBoundColumn;
boundColumn.ReadOnly = true;
}
else if (e.Column.UniqueName == "18 A 20 SKUs ")
{
GridBoundColumn boundColumn = e.Column as GridBoundColumn;
boundColumn.ReadOnly = true;
}
else if (e.Column.UniqueName == "Mercado")
{
GridBoundColumn boundColumn = e.Column as GridBoundColumn;
boundColumn.ReadOnly = true;
}
else if (e.Column.UniqueName == "Cliente")
{
GridBoundColumn boundColumn = e.Column as GridBoundColumn;
boundColumn.ReadOnly = true;
}
else if (e.Column.UniqueName == "createby")
{
GridBoundColumn boundColumn = e.Column as GridBoundColumn;
boundColumn.ReadOnly = true;
}
else if (e.Column.UniqueName == "dateby")
{
GridDateTimeColumn boundColumn = e.Column as GridDateTimeColumn;
boundColumn.ReadOnly = true;
if (boundColumn != null)
{
boundColumn.DataFormatString = "{0:dd/MM/yy}";
}
}
else if (e.Column.UniqueName == "modiby")
{
GridBoundColumn boundColumn = e.Column as GridBoundColumn;
boundColumn.ReadOnly = true;
}
else if (e.Column.UniqueName == "datemodiby")
{
GridDateTimeColumn boundColumn = e.Column as GridDateTimeColumn;
boundColumn.ReadOnly = true;
if (boundColumn != null)
{
boundColumn.DataFormatString = "{0:dd/MM/yy}";
}
}
else if (e.Column.UniqueName == "validado")
{
e.Column.Visible = false;
GridCheckBoxColumn boundColumn = e.Column as GridCheckBoxColumn;
boundColumn.ReadOnly = true;
}
else if (e.Column.UniqueName == "Fecha")
{
GridDateTimeColumn boundColumn = e.Column as GridDateTimeColumn;
if (boundColumn != null)
{
boundColumn.DataFormatString = "{0:dd/MM/yy}";
}
}
else
{
GridBoundColumn boundColumn = e.Column as GridBoundColumn;
if (boundColumn != null && TipoReporte.Equals("04"))
{
boundColumn.DataFormatString = "{0:C}";
}
if (boundColumn != null && TipoReporte.Equals("05"))
{
boundColumn.DataFormatString = "{0:C}";
}
//boundColumn.DataFormatString = "{0:S/.####.##}";
}
#region Presencia_Colgate
if (TipoReporte.Equals("04") || TipoReporte.Equals("0"))
{
if (e.Column.UniqueName == "nodocomercial_Calc")
{
e.Column.Visible = false;
GridBoundColumn boundColumn = e.Column as GridBoundColumn;
boundColumn.ReadOnly = true;
}
else if (e.Column.UniqueName == "PDV_Client_Calc")
{
e.Column.Visible = false;
GridBoundColumn boundColumn = e.Column as GridBoundColumn;
boundColumn.ReadOnly = true;
}
else if (e.Column.UniqueName == "fec_reg_cel_Calc")
{
e.Column.Visible = false;
GridBoundColumn boundColumn = e.Column as GridBoundColumn;
boundColumn.ReadOnly = true;
}
else if (e.Column.UniqueName == "id_mercaderista_Calc")
{
e.Column.Visible = false;
GridBoundColumn boundColumn = e.Column as GridBoundColumn;
boundColumn.ReadOnly = true;
}
}
#endregion
//else if (e.Column.UniqueName == "createby")
//{
// e.Column.OrderIndex = 1;
//}
//else if (e.Column.UniqueName == "Colgate Ultra 12 x 14")
//{
// GridBoundColumn colTelephone =
// gv_presencia.Columns.FindByUniqueName("Colgate Ultra 12 x 14") as GridBoundColumn;
// colTelephone.DataFormatString = "{0:$####.##}";
//}
//else if (e.Column.UniqueName == "createby")
//{
// "{0:$####.##}"
//}
////DataFormatString="{0:C}"
}
private void CreateGridColumns()
{
if (TableInfo == null)
{
return;
}
TableInfo ti = TableInfo;
int i = 0;
uxGrid.MasterTableView.Columns.Clear();
foreach (ColumnInfo c in ti.Columns)
{
if (c.IsPrimaryKey)
{
uxGrid.MasterTableView.DataKeyNames = new string[] { c.ColumnName };
if (c.IsIdentity)
{
continue;
}
}
GridEditableColumn col;
var fk = c.ForeignKeyRelation;
if (fk == null)
{
if (c.DataType == DbType.Boolean)
{
col = new GridCheckBoxColumn();
uxGrid.MasterTableView.Columns.Insert(i, col);
((GridCheckBoxColumn)col).DataField = c.ColumnName;
}
else
{
col = new GridBoundColumn();
uxGrid.MasterTableView.Columns.Insert(i, col);
((GridBoundColumn)col).DataField = c.ColumnName;
}
col.DataType = DbTypeUtility.GetType(c.DataType);
}
else
{
GridDropDownColumn dc = new GridDropDownColumn();
col = dc;
if (c.ColumnName.ToLower() != "unionid")
{
uxGrid.MasterTableView.Columns.Insert(i, col);
dc.DataField = c.ColumnName;
dc.DataType = DbTypeUtility.GetType(c.DataType);
dc.DataSourceID = "gidDS_" + c.ColumnName;
dc.ListTextField = "_col_";
dc.ListValueField = fk.PKField;
}
}
col.HeaderText = c.Title;
col.SortExpression = c.ColumnName;
col.ShowFilterIcon = false;
col.CurrentFilterFunction = GridKnownFunction.Contains;
col.AutoPostBackOnFilter = true;
//col.UniqueName = c.ColumnName;
i++;
}
}
private void Page_Load(object sender, System.EventArgs e)
{
if (!IsPostBack)
{
GridEditCommandColumn GEC = new GridEditCommandColumn();
this.RadGrid1.MasterTableView.Columns.Add(GEC);
GEC.UniqueName = "EditCommandColumn";
GEC.ButtonType = GridButtonColumnType.ImageButton;
GEC.ItemStyle.Width = 20;
GEC.OrderIndex = 0;
GridButtonColumn GBC = new GridButtonColumn();
this.RadGrid1.MasterTableView.Columns.Add(GBC);
GBC.CommandName = "Delete";
GBC.Text = "Delete";
GBC.ItemStyle.Width = 20;
GBC.ButtonType = GridButtonColumnType.ImageButton;
BLL.CustomFilteringColumn gridColumn2 = new BLL.CustomFilteringColumn();
this.RadGrid1.MasterTableView.Columns.Add(gridColumn2);
gridColumn2.DataField = "FirstName";
gridColumn2.HeaderText = "First Name";
gridColumn2.ItemStyle.CssClass = "UseHand";
BLL.CustomFilteringColumn gridColumn3 = new BLL.CustomFilteringColumn();
this.RadGrid1.MasterTableView.Columns.Add(gridColumn3);
gridColumn3.DataField = "LastName";
gridColumn3.HeaderText = "Last Name";
BLL.CustomFilteringColumn gridColumn4 = new BLL.CustomFilteringColumn();
this.RadGrid1.MasterTableView.Columns.Add(gridColumn4);
gridColumn4.DataField = "Email";
gridColumn4.HeaderText = "Email";
gridColumn4.ItemStyle.Width = 400;
GridDateTimeColumn gridColumn5 = new GridDateTimeColumn();
this.RadGrid1.MasterTableView.Columns.Add(gridColumn5);
gridColumn5.DataField = "Birthday";
gridColumn5.HeaderText = "Birthday";
gridColumn5.ItemStyle.Width = 200;
gridColumn5.AllowFiltering = false;
GridCheckBoxColumn gridColumn6 = new GridCheckBoxColumn();
this.RadGrid1.MasterTableView.Columns.Add(gridColumn6);
gridColumn6.DataField = "IsLockedOut";
gridColumn6.HeaderText = "Locked Out";
gridColumn6.AllowFiltering = false;
//BLL.CustomFilteringColumn gridColumn7 = new BLL.CustomFilteringColumn();
//this.RadGrid1.MasterTableView.Columns.Add(gridColumn7);
//gridColumn7.DataField = "Gender";
//gridColumn7.HeaderText = "Gender";
//gridColumn7.AllowFiltering = false;
//RadComboBox gridColumn7 = new RadComboBox();
//this.RadGrid1.MasterTableView.Columns.Add(gridColumn7);
//gridColumn7.Items[0].Text = "Male";
//gridColumn7.Items[0].Value = "Male";
//gridColumn7.Items[1].Text = "Female";
//gridColumn7.Items[1].Value = "Female";
}
}
public static void GenerateColumnsSfDataGrid(SfDataGrid dataGrid, DataTable table, string prefab)
{
using (var conn = new SqlConnection(App.ConnectionString))
{
conn.Open();
if (!string.IsNullOrEmpty(prefab))
{
DataTable prefabTable = App.GetPrefabDataTable(conn, $"{Settings.Default.Schema}_PREFABS", prefab);
DataTable comboTable =
App.GetPrefabDataTable(conn, $"{Settings.Default.Schema}_COMBOBOXES", prefab);
//could loop by table.ColumnNames.Count; but if prebab is changed... problems; maybe not all columns showing
for (var i = 0; i < table.Columns.Count; i++)
{
GridColumn column;
try
{
if (prefabTable.Rows[i]["TYPES"].ToString().ToLower().Equals("autocomplete"))
{
column = new GridTemplateColumn
{
MappingName = table.Columns[i].ColumnName,
HeaderText = prefabTable.Rows[i]["COLUMNS"].ToString()
};
var comboStrings = new HashSet <string>();
for (var j = 0; j < comboTable.Rows.Count; j++)
{
if (!string.IsNullOrEmpty(
comboTable.Rows[j][prefabTable.Rows[i]["COLUMNS"].ToString()].ToString()))
{
comboStrings.Add(comboTable.Rows[j][prefabTable.Rows[i]["COLUMNS"].ToString()]
.ToString());
}
}
var autoCompleteElem = new FrameworkElementFactory(typeof(AutoComplete));
var autoCompleteItemsBind = new Binding
{
Source = comboStrings,
UpdateSourceTrigger = UpdateSourceTrigger.PropertyChanged,
BindsDirectlyToSource = true
};
var autoCompleteBind =
new Binding(table.Columns[i].ColumnName)
{
UpdateSourceTrigger = UpdateSourceTrigger.PropertyChanged,
Mode = BindingMode.TwoWay,
BindsDirectlyToSource = true
};
autoCompleteElem.SetValue(UIElement.FocusableProperty, true);
autoCompleteElem.SetValue(AutoComplete.IsDropDownOpenProperty, true);
autoCompleteElem.SetValue(ItemsControl.IsTextSearchEnabledProperty, true);
autoCompleteElem.SetValue(AutoComplete.IsAutoAppendProperty, true);
autoCompleteElem.SetValue(ItemsControl.IsTextSearchCaseSensitiveProperty, false);
autoCompleteElem.SetValue(AutoComplete.CustomSourceProperty, autoCompleteItemsBind);
autoCompleteElem.SetValue(AutoComplete.TextProperty, autoCompleteBind);
autoCompleteElem.SetValue(AutoComplete.CanResizePopupProperty, false);
//autoCompleteElem.SetValue(AutoComplete.IsFilterProperty, true);
autoCompleteElem.SetValue(AutoComplete.EnableSortingProperty, false);
var cellEditingTemplate =
new DataTemplate(typeof(AutoComplete))
{
VisualTree = autoCompleteElem
};
((GridTemplateColumn)column).EditTemplate = cellEditingTemplate;
var defaultElement = new FrameworkElementFactory(typeof(TextBlock));
var bind = new Binding(table.Columns[i].ColumnName)
{
UpdateSourceTrigger = UpdateSourceTrigger.PropertyChanged,
Mode = BindingMode.TwoWay,
BindsDirectlyToSource = true
};
defaultElement.SetValue(TextBlock.TextProperty, bind);
defaultElement.SetValue(FrameworkElement.VerticalAlignmentProperty,
VerticalAlignment.Center);
var defaultTemplate = new DataTemplate(typeof(TextBlock))
{
VisualTree = defaultElement
};
((GridTemplateColumn)column).CellTemplate = defaultTemplate;
dataGrid.Columns.Add(column);
}
else if (prefabTable.Rows[i]["TYPES"].ToString().ToLower().Equals("datepicker"))
{
column = new GridDateTimeColumn
{
MappingName = table.Columns[i].ColumnName,
Pattern = DateTimePattern.ShortDate,
CanEdit = true,
AllowNullValue = true,
NullText = string.Empty,
AllowScrollingOnCircle = true,
EnableBackspaceKey = true,
EnableDeleteKey = true,
ShowRepeatButton = true,
HeaderText = prefabTable.Rows[i]["COLUMNS"].ToString()
};
dataGrid.Columns.Add(column);
}
else if (prefabTable.Rows[i]["TYPES"].ToString().ToLower().Equals("checkbox"))
{
column = new GridCheckBoxColumn
{
MappingName = table.Columns[i].ColumnName,
IsThreeState = false,
HeaderText = prefabTable.Rows[i]["COLUMNS"].ToString()
};
dataGrid.Columns.Add(column);
}
else if (prefabTable.Rows[i]["TYPES"].ToString().ToLower().Equals("numeric"))
{
column = new GridNumericColumn
{
MappingName = table.Columns[i].ColumnName,
HeaderText = prefabTable.Rows[i]["COLUMNS"].ToString(),
NumberDecimalDigits = 3,
NumberGroupSeparator = ","
};
dataGrid.Columns.Add(column);
}
else if (prefabTable.Rows[i]["TYPES"].ToString().ToLower().Equals("currency"))
{
column = new GridCurrencyColumn
{
MappingName = table.Columns[i].ColumnName,
HeaderText = prefabTable.Rows[i]["COLUMNS"].ToString()
};
dataGrid.Columns.Add(column);
}
else if (prefabTable.Rows[i]["TYPES"].ToString().ToLower().Equals("hyperlink"))
{
column = new GridHyperlinkColumn
{
MappingName = table.Columns[i].ColumnName,
HeaderText = prefabTable.Rows[i]["COLUMNS"].ToString()
};
dataGrid.Columns.Add(column);
}
else if (prefabTable.Rows[i]["TYPES"].ToString().ToLower().Equals("percentage"))
{
column = new GridPercentColumn
{
MappingName = table.Columns[i].ColumnName,
HeaderText = prefabTable.Rows[i]["COLUMNS"].ToString()
};
dataGrid.Columns.Add(column);
}
else if (prefabTable.Rows[i]["TYPES"].ToString().ToLower().Equals("combobox"))
{
var comboStrings = new HashSet <string>();
for (var j = 0; j < comboTable.Rows.Count; j++)
{
if (!string.IsNullOrEmpty(
comboTable.Rows[j][prefabTable.Rows[i]["COLUMNS"].ToString()].ToString()))
{
comboStrings.Add(comboTable.Rows[j][prefabTable.Rows[i]["COLUMNS"].ToString()]
.ToString());
}
}
column = new GridComboBoxColumn
{
MappingName = table.Columns[i].ColumnName,
ItemsSource = comboStrings,
StaysOpenOnEdit = true,
IsEditable = true,
HeaderText = prefabTable.Rows[i]["COLUMNS"].ToString()
};
dataGrid.Columns.Add(column);
}
else
{
column = new GridTextColumn
{
MappingName = table.Columns[i].ColumnName,
HeaderText = prefabTable.Rows[i]["COLUMNS"].ToString()
};
dataGrid.Columns.Add(column);
}
}
catch
{
column = new GridTextColumn
{
MappingName = table.Columns[i].ColumnName,
HeaderText = table.Columns[i].ColumnName
};
dataGrid.Columns.Add(column);
}
}
}
else
{
foreach (DataColumn column in table.Columns)
{
GridColumn gridColumn = new GridTextColumn
{
MappingName = column.ColumnName,
HeaderText = column.ColumnName
};
dataGrid.Columns.Add(gridColumn);
}
}
conn.Close();
}
}
public override GridColumn CreateColumn()
{
GridCheckBoxColumn column = new GridCheckBoxColumn();
return(column);
}
public static void UtworzKolumny(List <GridViewColumn> kolumny, RadGrid radGrid, bool isPostBack, Page page)
{
foreach (var opisKolumny in kolumny)
{
GridEditableColumn column = null;
if (opisKolumny.ColumnType == GridColumnType.CheckboxColumn)
{
var cbColumn = new GridCheckBoxColumn();
cbColumn.DataField = opisKolumny.Name;
column = cbColumn;
}
else if (opisKolumny.ColumnType == GridColumnType.BoundColumn)
{
var bColumn = new GridBoundColumn();
bColumn.DataField = opisKolumny.Name;
bColumn.Aggregate = (Telerik.Web.UI.GridAggregateFunction)opisKolumny.Aggregate;
if (string.IsNullOrEmpty(opisKolumny.DataTypeName) == false)
{
bColumn.DataType = Type.GetType(opisKolumny.DataTypeName);
}
if (bColumn.Aggregate == GridAggregateFunction.Count)
{
bColumn.FooterText = "Ilość: ";
}
bColumn.DataFormatString = opisKolumny.DataFormatString;
column = bColumn;
}
else if (opisKolumny.ColumnType == GridColumnType.EnumColumn)
{
var templateColumn = new GridTemplateColumn();
templateColumn.DataField = opisKolumny.Name;
templateColumn.Aggregate = (Telerik.Web.UI.GridAggregateFunction)opisKolumny.Aggregate;
if (string.IsNullOrEmpty(opisKolumny.DataTypeName) == false)
{
templateColumn.DataType = Type.GetType(opisKolumny.DataTypeName);
}
var typEnuma = Type.GetType(opisKolumny.DataTypeName);
templateColumn.EditItemTemplate = new EnumEditColumnTemplate(opisKolumny.Name, typEnuma);
templateColumn.ItemTemplate = new EnumItemColumnTemplate(opisKolumny.Name);
templateColumn.FilterTemplate = new EnumFilterColumnTemplate(opisKolumny.Name, typEnuma, page);
column = templateColumn;
}
column.UniqueName = opisKolumny.Name;
column.HeaderText = opisKolumny.GetReadableName();
column.HeaderTooltip = opisKolumny.ToolTip;
column.FilterControlWidth = new Unit("80px");
column.ReadOnly = opisKolumny.ReadOnly;
//boundColumn.ColumnEditorID = opisKolumny.ColumnEditorID;
if (opisKolumny.Width != null)
{
column.HeaderStyle.Width = new Unit(opisKolumny.Width.ToString());
}
//if (opisKolumny.NazwaTypuPola == "Decimal")
//{
//}
if (opisKolumny.ShowColumnFilter)
{
column.AutoPostBackOnFilter = true;
column.CurrentFilterFunction = (Telerik.Web.UI.GridKnownFunction)opisKolumny.FilterFunction;
column.ShowFilterIcon = false;
if (isPostBack == false)
{
column.CurrentFilterValue = opisKolumny.FilterDefaultValue;
if (string.IsNullOrEmpty(opisKolumny.FilterDefaultValue) == false)
{
var filtr = "([" + opisKolumny.Name + "] = '" + opisKolumny.FilterDefaultValue + "')";
if (string.IsNullOrEmpty(radGrid.MasterTableView.FilterExpression))
{
radGrid.MasterTableView.FilterExpression = filtr;
}
else
{
radGrid.MasterTableView.FilterExpression = radGrid.MasterTableView.FilterExpression +
" AND " +
filtr;
}
}
}
}
else
{
column.AllowFiltering = false;
}
radGrid.MasterTableView.Columns.Add(column);
}
}