protected void gv_Calculos_ColumnCreated(object sender, GridColumnCreatedEventArgs e)
{
if (e.Column.UniqueName == "en_blanco0")
{
GridDateTimeColumn boundColumn = e.Column as GridDateTimeColumn;
//e.Column.ItemStyle.Width = Unit.Pixel(40);
e.Column.ItemStyle.Width = Unit.Percentage(40);
e.Column.HeaderStyle.Width = Unit.Percentage(40);
//e.Column.HeaderStyle.Width = Unit.Pixel(40);
}
if (e.Column.UniqueName == "en_blanco1")
{
GridDateTimeColumn boundColumn = e.Column as GridDateTimeColumn;
e.Column.ItemStyle.Width = Unit.Pixel(40);
e.Column.HeaderStyle.Width = Unit.Pixel(40);
}
//if (e.Column.UniqueName == "Tipo")
//{
// GridDateTimeColumn boundColumn = e.Column as GridDateTimeColumn;
//}
//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}";
// }
//}
}
public void MontaGrid_Procedimento()
{
try
{
////<MasterTableView DataKeyNames="ProductID">
objGrid.ID = "grdProcedimentos";
objGrid.AutoGenerateColumns = false;
objGrid.AllowPaging = true;
objGrid.AllowSorting = true;
objGrid.AllowFilteringByColumn = true;
//objGrid.GridLines = "none";
objGrid.Skin = "DorSkin";
//Coluna TextoBox
GridBoundColumn ColunaTexPRC01 = new GridBoundColumn();
ColunaTexPRC01.DataField = "DSPRC";
ColunaTexPRC01.HeaderText = "Descrição";
objGrid.Columns.Add(ColunaTexPRC01);
//Coluna DateTime
GridDateTimeColumn ColunaDtaPRC01 = new GridDateTimeColumn();
ColunaDtaPRC01.DataField = "DTPRC";
ColunaDtaPRC01.HeaderText = "Data";
objGrid.Columns.Add(ColunaDtaPRC01);
}
catch
{
}
}
public GridDateTimeColumn AddDateTimeColumn(string dataField, string headerText, bool isReadOnly)
{
GridDateTimeColumn c = new GridDateTimeColumn();
_grid.MasterTableView.Columns.Add(c);
c.PickerType = GridDateTimeColumnPickerType.DateTimePicker;
//c.DataFormatString = CommonConst.DateTimeFormatString;
//c.EditDataFormatString = CommonConst.DateTimeFormatString;
SetBoundColumn(c, dataField, headerText, isReadOnly);
return(c);
}
private void SetupDataGrid()
{
// For demonstration purposes, set the non-default values for the SFDataGrid
sfDataGridSample.AddNewRowPosition = RowPosition.Bottom;
sfDataGridSample.AllowDeleting = true;
sfDataGridSample.AllowDraggingColumns = true;
sfDataGridSample.AllowGrouping = false;
sfDataGridSample.AllowResizingColumns = true;
sfDataGridSample.AllowSelectionOnMouseDown = true;
sfDataGridSample.AutoGenerateColumns = false;
sfDataGridSample.EditMode = EditMode.SingleClick;
sfDataGridSample.EditorSelectionBehavior = EditorSelectionBehavior.SelectAll;
sfDataGridSample.SelectionUnit = SelectionUnit.Cell;
sfDataGridSample.ShowRowHeader = true;
sfDataGridSample.AutoSizeColumnsMode = AutoSizeColumnsMode.Fill;
sfDataGridSample.ValidationMode = GridValidationMode.InEdit;
// Setup our event handler
sfDataGridSample.SelectionChanged += sfDataGridUpdate_SelectionChanged;
// For demonstration purposes, set the non-default values for the columns
GridDateTimeColumn col1 = (GridDateTimeColumn)sfDataGridSample.Columns["DateValue"];
col1.CellStyle.HorizontalAlignment = HorizontalAlignment.Center;
col1.Pattern = DateTimePattern.ShortDate;
col1.ShowDropDownButton = false;
col1.AllowDragging = true;
col1.ValidationMode = GridValidationMode.InView;
col1.DateTimeEditingMode = DateTimeEditingMode.Default;
col1.AllowGrouping = false;
col1.AllowResizing = true;
GridDateTimeColumn col2 = (GridDateTimeColumn)sfDataGridSample.Columns["TimeValue"];
col2.CellStyle.HorizontalAlignment = HorizontalAlignment.Center;
col2.Pattern = DateTimePattern.ShortTime;
col2.ShowDropDownButton = false;
col2.AllowDragging = true;
col2.ValidationMode = GridValidationMode.InView;
col2.DateTimeEditingMode = DateTimeEditingMode.Default;
col2.AllowGrouping = false;
col2.AllowResizing = true;
GridTextColumn col3 = (GridTextColumn)sfDataGridSample.Columns["StringValue"];
col3.CellStyle.HorizontalAlignment = HorizontalAlignment.Left;
col3.AllowDragging = true;
col3.ValidationMode = GridValidationMode.InEdit;
col3.AllowGrouping = false;
col3.AllowResizing = true;
}
public override View GetSampleContent(Context context)
{
sfGrid = new SfDataGrid(context);
viewmodel = new EditingViewModel();
sfGrid.AutoGenerateColumns = false;
sfGrid.RowHeight = 50;
sfGrid.AllowEditing = true;
sfGrid.EditTapAction = TapAction.OnTap;
sfGrid.ColumnSizer = ColumnSizer.Star;
sfGrid.SelectionMode = SelectionMode.Single;
sfGrid.NavigationMode = NavigationMode.Cell;
sfGrid.HeaderRowHeight = 40;
sfGrid.ItemsSource = viewmodel.DealerInformation;
sfGrid.VerticalOverScrollMode = VerticalOverScrollMode.None;
GridNumericColumn productPrice = new GridNumericColumn();
productPrice.MappingName = "ProductPrice";
productPrice.HeaderText = "Product Price";
productPrice.HeaderTextAlignment = GravityFlags.Center;
GridDateTimeColumn shippedDate = new GridDateTimeColumn();
shippedDate.MappingName = "ShippedDate";
shippedDate.HeaderText = "Shipped Date";
shippedDate.HeaderTextAlignment = GravityFlags.Center;
shippedDate.Format = "d";
GridPickerColumn dealerName = new GridPickerColumn();
dealerName.MappingName = "DealerName";
dealerName.HeaderText = "Dealer Name";
dealerName.ItemsSource = viewmodel.CustomerNames;
dealerName.HeaderTextAlignment = GravityFlags.Center;
GridTextColumn productNo = new GridTextColumn();
productNo.MappingName = "ProductNo";
productNo.HeaderText = "Product No";
productNo.HeaderTextAlignment = GravityFlags.Center;
sfGrid.Columns.Add(productNo);
sfGrid.Columns.Add(dealerName);
sfGrid.Columns.Add(shippedDate);
sfGrid.Columns.Add(productPrice);
return(sfGrid);
}
public override void AttachProperties(GridColumn gridColumn)
{
base.AttachProperties(gridColumn);
GridDateTimeColumn column = (GridDateTimeColumn)gridColumn;
column.PickerType = GridDateTimeColumnPickerType.TimePicker;
column.AllowFiltering = false;
if (TimeFormatString != null)
{
column.DataFormatString = TimeFormatString;
}
else
{
column.DataFormatString = UIConst.TimeFormatString;
}
}
public Editing()
{
sfGrid = new SfDataGrid();
viewmodel = new EditingViewModel();
sfGrid.AutoGenerateColumns = false;
sfGrid.RowHeight = 50;
sfGrid.AllowEditing = true;
sfGrid.SelectionMode = SelectionMode.Single;
sfGrid.NavigationMode = NavigationMode.Cell;
sfGrid.EditTapAction = TapAction.OnTap;
sfGrid.ColumnSizer = ColumnSizer.Star;
sfGrid.HeaderRowHeight = 40;
sfGrid.ItemsSource = viewmodel.DealerInformation;
GridNumericColumn productPrice = new GridNumericColumn();
productPrice.MappingName = "ProductPrice";
productPrice.HeaderText = "Product Price";
productPrice.HeaderTextAlignment = UIKit.UITextAlignment.Center;
GridDateTimeColumn shippedDate = new GridDateTimeColumn();
shippedDate.MappingName = "ShippedDate";
shippedDate.HeaderText = "Shipped Date";
shippedDate.Format = "d";
shippedDate.HeaderTextAlignment = UIKit.UITextAlignment.Center;
GridPickerColumn dealerName = new GridPickerColumn();
dealerName.MappingName = "DealerName";
dealerName.HeaderText = "Dealer Name";
dealerName.ItemsSource = viewmodel.CustomerNames;
dealerName.HeaderTextAlignment = UIKit.UITextAlignment.Center;
GridTextColumn productNo = new GridTextColumn();
productNo.MappingName = "ProductNo";
productNo.HeaderText = "Product No";
productNo.HeaderTextAlignment = UIKit.UITextAlignment.Center;
sfGrid.Columns.Add(productNo);
sfGrid.Columns.Add(dealerName);
sfGrid.Columns.Add(shippedDate);
sfGrid.Columns.Add(productPrice);
this.AddSubview(sfGrid);
}
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);
}
internal static string DateTimeFormatString(GridDateTimeColumn column, DateTime columnValue)
{
switch (column.pattern)
{
case DateTimePattern.ShortDate:
return(columnValue.ToString("d", column.dateTimeFormat));
case DateTimePattern.LongDate:
return(columnValue.ToString("D", column.dateTimeFormat));
case DateTimePattern.LongTime:
return(columnValue.ToString("T", column.dateTimeFormat));
case DateTimePattern.ShortTime:
return(columnValue.ToString("t", column.dateTimeFormat));
case DateTimePattern.FullDateTime:
return(columnValue.ToString("F", column.dateTimeFormat));
case DateTimePattern.RFC1123:
return(columnValue.ToString("R", column.dateTimeFormat));
case DateTimePattern.SortableDateTime:
return(columnValue.ToString("s", column.dateTimeFormat));
case DateTimePattern.UniversalSortableDateTime:
return(columnValue.ToString("u", column.dateTimeFormat));
case DateTimePattern.YearMonth:
return(columnValue.ToString("Y", column.dateTimeFormat));
case DateTimePattern.MonthDay:
return(columnValue.ToString("M", column.dateTimeFormat));
case DateTimePattern.CustomPattern:
return(columnValue.ToString(column.customPattern, column.dateTimeFormat));
default:
return(columnValue.ToString("MMMM", column.dateTimeFormat));
}
}
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);
}
public Form1()
{
InitializeComponent();
this.sfDataGrid.AutoGenerateColumns = false;
this.sfDataGrid.DataSource = new ViewModel().Orders;
this.sfDataGrid.LiveDataUpdateMode = LiveDataUpdateMode.AllowDataShaping;
GridNumericColumn gridTextColumn1 = new GridNumericColumn()
{
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"
};
GridDateTimeColumn gridDateTimeColumn = new GridDateTimeColumn()
{
MappingName = "Date", Width = 130, HeaderText = "Date", Pattern = Syncfusion.WinForms.Input.Enums.DateTimePattern.Custom, Format = "MM/dd/yyyy hh:mm"
};
this.sfDataGrid.Columns.Add(gridDateTimeColumn);
this.sfDataGrid.Columns.Add(gridTextColumn1);
this.sfDataGrid.Columns.Add(gridTextColumn2);
this.sfDataGrid.Columns.Add(gridTextColumn3);
this.sfDataGrid.Columns.Add(gridTextColumn4);
this.sfDataGrid.CellRenderers.Remove("DateTime");
this.sfDataGrid.CellRenderers.Add("DateTime", new GridDateTimeCellRendererExt());
}
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 override GridColumn CreateColumn()
{
GridDateTimeColumn column = new GridDateTimeColumn();
return(column);
}
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";
}
}
private void setupGridColumns(DataSet DS, CswNbtView View)
{
_Grid.Columns.Clear();
// Edit column
GridBoundColumn EditColumn = new GridBoundColumn();
EditColumn.UniqueName = "EditColumn";
EditColumn.HeaderText = "Edit";
EditColumn.DataField = "Edit";
EditColumn.Display = ShowActionColumns;
_Grid.Columns.Add(EditColumn);
// Node column
GridBoundColumn NodeNameColumn = new GridBoundColumn();
NodeNameColumn.UniqueName = "NodeName";
NodeNameColumn.HeaderText = "Node Name";
NodeNameColumn.DataField = "NodeName";
// BZ 6704
NodeNameColumn.Visible = false;
NodeNameColumn.Display = false;
_Grid.Columns.Add(NodeNameColumn);
// NodeKey column
GridBoundColumn NodeKeyColumn = new GridBoundColumn();
NodeKeyColumn.UniqueName = "NodeKey";
NodeKeyColumn.HeaderText = "NodeKey";
NodeKeyColumn.DataField = "NodeKey";
NodeKeyColumn.Display = false;
_Grid.Columns.Add(NodeKeyColumn);
foreach (DataTable Table in DS.Tables)
{
foreach (DataColumn Column in Table.Columns)
{
string ColumnName = Column.ColumnName;
if (ColumnName.Length > PropColumnPrefix.Length && ColumnName.Substring(0, PropColumnPrefix.Length) == PropColumnPrefix)
{
string NoPrefixColumnName = ColumnName.Substring(PropColumnPrefix.Length);
//Int32 CurrentNodeTypePropId = CswConvert.ToInt32( NoPrefixColumnName.Substring( 0, NoPrefixColumnName.IndexOf( '_' ) ) );
string RealColumnName = CswTools.XmlRealAttributeName(NoPrefixColumnName); //.Substring( NoPrefixColumnName.IndexOf( '_' ) + 1 ) );
//CswNbtMetaDataNodeTypeProp CurrentNodeTypeProp = _CswNbtResources.MetaData.getNodeTypeProp( CurrentNodeTypePropId );
//CswNbtViewProperty CurrentViewProp = View.FindPropertyById( CswNbtPropType.NodeTypePropId, CurrentNodeTypePropId );
CswNbtViewProperty CurrentViewProp = View.findPropertyByName(RealColumnName);
//if( CurrentViewProp == null )
// CurrentViewProp = View.FindPropertyByName( CurrentNodeTypeProp.PropName );
CswEnumNbtFieldType ColFieldType = CswNbtResources.UnknownEnum;
if (CurrentViewProp != null)
{
if (((CswNbtViewRelationship)CurrentViewProp.Parent).SecondType == CswEnumNbtViewRelatedIdType.NodeTypeId)
{
CswNbtMetaDataNodeType CurrentNT = _CswNbtResources.MetaData.getNodeType(((CswNbtViewRelationship)CurrentViewProp.Parent).SecondId);
CswNbtMetaDataNodeTypeProp CurrentNTP = CurrentNT.getNodeTypeProp(RealColumnName);
if (CurrentNTP != null)
{
ColFieldType = CurrentNTP.getFieldTypeValue();
}
}
else if (((CswNbtViewRelationship)CurrentViewProp.Parent).SecondType == CswEnumNbtViewRelatedIdType.ObjectClassId)
{
CswNbtMetaDataObjectClass CurrentOC = _CswNbtResources.MetaData.getObjectClass(((CswNbtViewRelationship)CurrentViewProp.Parent).SecondId);
foreach (CswNbtMetaDataNodeType CurrentNT in CurrentOC.getNodeTypes())
{
CswNbtMetaDataNodeTypeProp CurrentNTP = CurrentNT.getNodeTypeProp(RealColumnName);
if (CurrentNTP != null)
{
ColFieldType = CurrentNTP.getFieldTypeValue();
}
}
}
}
GridBoundColumn thisColumn = null;
//switch( CurrentNodeTypeProp.FieldType.FieldType )
switch (ColFieldType)
{
case CswEnumNbtFieldType.DateTime:
thisColumn = new GridDateTimeColumn();
thisColumn.DataFormatString = "{0:M/d/yyyy}";
thisColumn.DataType = typeof(DateTime);
break;
//case CswEnumNbtFieldType.Time:
// thisColumn = new GridDateTimeColumn();
// thisColumn.DataFormatString = "{0:H:mm:ss}";
// thisColumn.DataType = typeof( DateTime );
// break;
default:
thisColumn = new GridBoundColumn();
break;
}
thisColumn.UniqueName = ColumnName;
thisColumn.HeaderText = RealColumnName;
thisColumn.DataField = ColumnName;
if (CurrentViewProp != null && CurrentViewProp.Width != Int32.MinValue)
{
thisColumn.HeaderStyle.Width = Unit.Parse((CswConvert.ToInt32(CurrentViewProp.Width * 7)).ToString() + "px"); // average pixel width per character
}
//thisColumn.OrderIndex = CurrentViewProp.Order;
//Telerik.Web.UI.GridTableView GTV = new GridTableView( _Grid );
if (CurrentViewProp != null && CurrentViewProp.Order > 0 && _Grid.Columns.Count >= CurrentViewProp.Order)
{
_Grid.Columns.AddAt(CurrentViewProp.Order, thisColumn);
}
else
{
_Grid.Columns.Add(thisColumn);
}
}
}
}
// Delete column
GridBoundColumn DeleteColumn = new GridBoundColumn();
DeleteColumn.UniqueName = "DeleteColumn";
DeleteColumn.HeaderText = "Delete";
DeleteColumn.DataField = "Delete";
DeleteColumn.Display = ShowActionColumns;
_Grid.Columns.Add(DeleteColumn);
} // setupGridColumns()
private void CreateColumns(Report report)
{
DataTable table = new DataTable();
using (SqlCommand command = new SqlCommand())
{
command.CommandText = report.GetSqlOld(true, filterControl.ReportConditions);
command.CommandType = CommandType.Text;
Report.CreateParameters(UserSession.LoginUser, command, UserSession.LoginUser.UserID);
using (SqlConnection connection = new SqlConnection(GetReportConnectionString()))
{
connection.Open();
command.Connection = connection;
using (SqlDataAdapter adapter = new SqlDataAdapter(command))
{
adapter.FillSchema(table, SchemaType.Source);
adapter.Fill(table);
}
connection.Close();
}
}
ReportFields fields = new ReportFields(UserSession.LoginUser);
fields.LoadByReportID(_reportID);
foreach (ReportField field in fields)
{
if (field.IsCustomField == false && (field.LinkedFieldID == 30 || field.LinkedFieldID == 146))
{
GridButtonColumn column = new GridButtonColumn();
gridReport.MasterTableView.Columns.Add(column);
column.ButtonType = GridButtonColumnType.ImageButton;
column.ImageUrl = "../images/icons/open.png";
column.UniqueName = "ButtonOpen";
column.CommandName = "OpenItem";
column.HeaderStyle.Width = new Unit(32, UnitType.Pixel);
column.Resizable = false;
break;
}
}
if (fields.IsEmpty)
{
if (table.Columns.Contains("Ticket_Number"))
{
GridButtonColumn column = new GridButtonColumn();
gridReport.MasterTableView.Columns.Add(column);
column.ButtonType = GridButtonColumnType.ImageButton;
column.ImageUrl = "../images/icons/open.png";
column.UniqueName = "ButtonOpen";
column.CommandName = "OpenItem";
column.HeaderStyle.Width = new Unit(32, UnitType.Pixel);
column.Resizable = false;
}
}
foreach (DataColumn dataColumn in table.Columns)
{
GridBoundColumn gridColumn;
if (dataColumn.DataType == typeof(System.DateTime))
{
gridColumn = new GridDateTimeColumn();
gridColumn.DataFormatString = "{0:MM/dd/yyyy hh:mm tt}";
}
else if (dataColumn.DataType == typeof(System.Decimal) ||
dataColumn.DataType == typeof(System.Double)
)
{
gridColumn = new GridNumericColumn();
gridColumn.DataFormatString = "{0:0.00}";
}
else if (dataColumn.DataType == typeof(System.Int16) ||
dataColumn.DataType == typeof(System.Int32) ||
dataColumn.DataType == typeof(System.Int64))
{
gridColumn = new GridNumericColumn();
gridColumn.DataFormatString = "{0:0}";
}
else
{
gridColumn = new GridBoundColumn();
}
gridReport.MasterTableView.Columns.Add(gridColumn);
gridColumn.DataType = dataColumn.DataType;
gridColumn.DataField = dataColumn.ColumnName.Replace(' ', '_');
gridColumn.UniqueName = gridColumn.DataField;
gridColumn.HeaderText = dataColumn.ColumnName.Replace('_', ' ');
gridColumn.HeaderStyle.Width = new Unit(200, UnitType.Pixel);
}
}
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 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}"
}
