private void radGridView1_UserDeletedRow(object sender, GridViewRowEventArgs e)
{
GridViewRowInfo[] rows = e.Rows;
for (int i = 0; i < (int)rows.Length; i++)
{
GridViewRowInfo row = rows[i];
if (row.HierarchyLevel != 0)
{
GridViewRelation relation = this.radGridView1.Relations.Find(row.ViewTemplate.Parent, row.ViewTemplate);
GridViewRowInfo parentRow = row.Parent as GridViewRowInfo;
PropertyDescriptorCollection parentProperties = ListBindingHelper.GetListItemProperties(parentRow.DataBoundItem);
PropertyDescriptor childDescriptor = parentProperties.Find(relation.ChildColumnNames[0], true);
if (childDescriptor != null)
{
IList children = childDescriptor.GetValue(parentRow.DataBoundItem) as IList;
if (children != null)
{
children.Remove(row.DataBoundItem);
row.ViewInfo.Refresh();
foreach (var childRow in row.ViewInfo.ChildRows)
{
childRow.InvalidateRow();
}
}
}
}
}
}
public RadForm1()
{
InitializeComponent();
radGridView1.UseScrollbarsInHierarchy = true;
master.Columns.Add("ID", typeof(int));
master.Columns.Add("F_ID", typeof(int));
master.Columns.Add("test", typeof(string));
child.Columns.Add("F_ID", typeof(int));
child.Columns.Add("test", typeof(string));
for (int i = 0; i < 100; i++)
{
master.Rows.Add(i, i % 2, "Row " + i);
child.Rows.Add(i % 2, "Child " + i);
}
radGridView1.DataSource = master;
GridViewTemplate template = new GridViewTemplate();
template.DataSource = child;
radGridView1.MasterTemplate.Templates.Add(template);
GridViewRelation relation = new GridViewRelation(radGridView1.MasterTemplate);
relation.ChildTemplate = template;
relation.RelationName = "Test";
relation.ParentColumnNames.Add("F_ID");
relation.ChildColumnNames.Add("F_ID");
radGridView1.Relations.Add(relation);
}
private void PopulateMedatdataRows(RadGridView gridView)
{
GridViewTemplate metadataTemplate = new GridViewTemplate();
metadataTemplate.DataSource = _resources.SelectMany(r => r.VirtualResourceMetadataSet).Select(n => n);
metadataTemplate.Columns.Add(CreateMetadataCommandColumn());
metadataTemplate.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
metadataTemplate.Caption = "Metadata";
metadataTemplate.AllowAddNewRow = false;
metadataTemplate.ReadOnly = false;
metadataTemplate.ShowRowHeaderColumn = false;
HideColumns(metadataTemplate);
SetColumnsAsReadOnly(metadataTemplate);
GridViewRelation metadataRelation = new GridViewRelation(gridView.MasterTemplate);
metadataRelation.ChildTemplate = metadataTemplate;
metadataRelation.RelationName = "VirtualResourceId";
metadataRelation.ParentColumnNames.Add("VirtualResourceId");
metadataRelation.ChildColumnNames.Add("VirtualResourceId");
gridView.Relations.Add(metadataRelation);
gridView.ShowChildViewCaptions = true;
gridView.Templates.Add(metadataTemplate);
}
private void Form1_Load(object sender, EventArgs e)
{
radGridView1.DataSource = adventureWorksDS.SalesTerritory;
radGridView1.MasterTemplate.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
radGridView1.ThemeName = "VistaOrange";
radGridView1.MasterTemplate.AllowAddNewRow = false;
radGridView1.Columns["rowguid"].IsVisible = false;
GridViewTemplate childTmpt = new GridViewTemplate();
childTmpt.DataSource = adventureWorksDS.SalesPerson;
childTmpt.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
childTmpt.AllowAddNewRow = false;
radGridView1.MasterTemplate.Templates.Add(childTmpt);
GridViewRelation relation = new GridViewRelation(radGridView1.MasterTemplate);
relation.ChildTemplate = childTmpt;
relation.RelationName = "SalesTerritoryPerson";
relation.ParentColumnNames.Add("TerritoryID");
relation.ChildColumnNames.Add("TerritoryID");
radGridView1.Relations.Add(relation);
salesTerritoryTA.Fill(adventureWorksDS.SalesTerritory);
salesPersonTA.Fill(adventureWorksDS.SalesPerson);
childTmpt.Columns["rowguid"].IsVisible = false;
}
public void LoadGrid()
{
if (radGridView1.Relations.Count > 0)
{
radGridView1.Relations.Clear();
}
GridViewRelation relation1 = new GridViewRelation(radGridView1.MasterTemplate)
{
ChildTemplate = radGridView1.MasterTemplate.Templates[0],
RelationName = "FKSymbol"
};
relation1.ParentColumnNames.Add("Symbol");
relation1.ChildColumnNames.Add("Symbol");
radGridView1.Relations.Add(relation1);
HtmlViewDefinition viewDef = new HtmlViewDefinition();
viewDef.RowTemplate.Rows.Add(new RowDefinition());
viewDef.RowTemplate.Rows.Add(new RowDefinition());
viewDef.RowTemplate.Rows.Add(new RowDefinition());
viewDef.RowTemplate.Rows.Add(new RowDefinition());
viewDef.RowTemplate.Rows.Add(new RowDefinition());
viewDef.RowTemplate.Rows.Add(new RowDefinition());
viewDef.RowTemplate.Rows[0].Cells.Add(new CellDefinition("Time1", 0, 1, 1));
viewDef.RowTemplate.Rows[0].Cells.Add(new CellDefinition("Time", 0, 1, 1));
viewDef.RowTemplate.Rows[1].Cells.Add(new CellDefinition("Open1", 0, 1, 1));
viewDef.RowTemplate.Rows[1].Cells.Add(new CellDefinition("Open", 0, 1, 1));
viewDef.RowTemplate.Rows[2].Cells.Add(new CellDefinition("High1", 0, 1, 1));
viewDef.RowTemplate.Rows[2].Cells.Add(new CellDefinition("High", 0, 1, 1));
viewDef.RowTemplate.Rows[3].Cells.Add(new CellDefinition("Low1", 0, 1, 1));
viewDef.RowTemplate.Rows[3].Cells.Add(new CellDefinition("Low", 0, 1, 1));
viewDef.RowTemplate.Rows[4].Cells.Add(new CellDefinition("Close1", 0, 1, 1));
viewDef.RowTemplate.Rows[4].Cells.Add(new CellDefinition("Close", 0, 1, 1));
viewDef.RowTemplate.Rows[5].Cells.Add(new CellDefinition("Trades1", 0, 1, 1));
viewDef.RowTemplate.Rows[5].Cells.Add(new CellDefinition("Trades", 0, 1, 1));
radGridView1.MasterTemplate.Templates[0].ViewDefinition = viewDef;
radGridView1.Columns["Symbol"].MinWidth = 60;
radGridView1.Columns["Last"].MinWidth = 50;
radGridView1.Columns["Variation"].MinWidth = 50;
radGridView1.Columns["Volume"].MinWidth = 60;
radGridView1.Columns["Symbol"].TextAlignment = ContentAlignment.TopLeft;
radGridView1.Columns["Last"].TextAlignment = ContentAlignment.TopRight;
radGridView1.Columns["Variation"].TextAlignment = ContentAlignment.TopRight;
radGridView1.Columns["Volume"].TextAlignment = ContentAlignment.TopRight;
radGridView1.GridBehavior = new RadGridBehavior();
//Expand rows:
if (rowsExpanded.Count > 0 && rowsExpanded.Count == radGridView1.Rows.Count)
{
for (int i = 0; i < radGridView1.Rows.Count; i++)
{
radGridView1.Rows[i].IsExpanded = rowsExpanded[i];
}
}
}
private void SetOrderGridTemplates()
{
GridViewTemplate template = CreateOrderDetailsTemplate();
GridViewRelation relation = new GridViewRelation(OrdersGrid.MasterTemplate, template);
relation.RelationName = "Vehicles";
OrdersGrid.Relations.Add(relation);
}
void LoadDetailsTable()
{
DataTable table = new DataTable("Details");
table.Columns.Add("EmployeeID", typeof(int));
table.Columns.Add("Photo", typeof(byte[]));
table.Columns.Add("FirstName", typeof(string));
table.Columns.Add("LastName", typeof(string));
table.Columns.Add("Title", typeof(string));
table.Columns.Add("Address", typeof(string));
table.Columns.Add("City", typeof(string));
table.Columns.Add("BirthDate", typeof(DateTime));
table.Columns.Add("Country", typeof(string));
foreach (DataRow row in this.northwindDataSet.Employees.Rows)
{
table.Rows.Add(row["EmployeeID"], row["Photo"], row["FirstName"],
row["LastName"], row["Title"], row["Address"], row["City"], row["BirthDate"], row["Country"]);
}
GridViewTemplate template = new GridViewTemplate();
template.Caption = "Details";
template.DataSource = table;
template.AllowRowResize = false;
template.ShowColumnHeaders = false;
template.Columns["Photo"].Width = 125;
template.Columns["City"].Width = 70;
template.Columns["Country"].Width = 70;
template.Columns["FirstName"].DisableHTMLRendering = false;
template.Columns["Title"].DisableHTMLRendering = false;
template.Columns["BirthDate"].DisableHTMLRendering = false;
template.Columns["Address"].Width = 200;
template.Columns["Address"].DisableHTMLRendering = false;
this.radGridView1.Templates.Insert(0, template);
GridViewRelation relation = new GridViewRelation(this.radGridView1.MasterTemplate);
relation.ChildTemplate = template;
relation.ParentColumnNames.Add("EmployeeID");
relation.ChildColumnNames.Add("EmployeeID");
this.radGridView1.Relations.Add(relation);
HtmlViewDefinition viewDef = new HtmlViewDefinition();
viewDef.RowTemplate.Rows.Add(new RowDefinition());
viewDef.RowTemplate.Rows.Add(new RowDefinition());
viewDef.RowTemplate.Rows.Add(new RowDefinition());
viewDef.RowTemplate.Rows[0].Cells.Add(new CellDefinition("Photo", 0, 1, 3));
viewDef.RowTemplate.Rows[0].Cells.Add(new CellDefinition("FirstName", 0, 1, 1));
viewDef.RowTemplate.Rows[0].Cells.Add(new CellDefinition("BirthDate", 0, 2, 1));
viewDef.RowTemplate.Rows[1].Cells.Add(new CellDefinition("Title", 0, 3, 1));
viewDef.RowTemplate.Rows[2].Cells.Add(new CellDefinition("Address", 0, 1, 1));
viewDef.RowTemplate.Rows[2].Cells.Add(new CellDefinition("City", 0, 1, 1));
viewDef.RowTemplate.Rows[2].Cells.Add(new CellDefinition("Country", 0, 1, 1));
template.ViewDefinition = viewDef;
}
private void CreateBoundHierarchy()
{
var deliveryBiz = new DeliveryBiz();
using (this.radGridView.DeferRefresh())
{
this.radGridView.MasterTemplate.Reset();
this.radGridView.AutoGenerateColumns = true;
this.radGridView.AllowCellContextMenu = false;
this.radGridView.ReadOnly = true;
this.radGridView.TableElement.RowHeight = 20;
this.radGridView.DataSource = deliveryBiz.GetTemplateData();
this.radGridView.MasterTemplate.Columns["Vehicle"].HeaderText = "Xe";
this.radGridView.MasterTemplate.Columns["DeliveryNo"].HeaderText = "Số giao hàng";
this.radGridView.MasterTemplate.Columns["DeliveryDate"].HeaderText = "Ngày giao";
this.radGridView.MasterTemplate.Columns["StartTime"].HeaderText = "Giờ giao";
this.radGridView.MasterTemplate.Columns["Status"].HeaderText = "Tình trạng";
this.radGridView.MasterTemplate.Columns["Id"].IsVisible = false;
this.radGridView.MasterTemplate.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
var orderBiz = new OrderBiz();
GridViewTemplate template = new GridViewTemplate();
template.AutoGenerateColumns = true;
template.AllowAddNewRow = false;
template.AllowCellContextMenu = false;
template.ReadOnly = true;
template.DataSource = orderBiz.GetTemplateData();
this.radGridView.Templates.Add(template);
template.Columns["OrderNo"].HeaderText = "Mã đơn hàng";
template.Columns["Status"].HeaderText = "Tình trạng";
template.Columns["Customer"].HeaderText = "Khách hàng";
template.Columns["DeliveryDate"].HeaderText = "Ngày giao";
template.Columns["DeliveryInternal"].HeaderText = "Hình thức vận chuyển";
template.Columns["SendMessage"].HeaderText = "Tin nhắn";
template.Columns["SendEmail"].HeaderText = "Email";
template.Columns["SendReport"].HeaderText = "Thông báo";
template.Columns["Id"].IsVisible = false;
template.Columns["ParentId"].IsVisible = false;
template.Columns["Recipient"].IsVisible = false;
template.Columns["CustomerId"].IsVisible = false;
template.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
GridViewRelation relation = new GridViewRelation(radGridView.MasterTemplate, template);
relation.RelationName = "SuppliersProducts";
relation.ParentColumnNames.Add("Id");
relation.ChildColumnNames.Add("ParentId");
this.radGridView.Relations.Add(relation);
FormatCell();
}
}
private void Form1_Load(object sender, EventArgs e)
{
FillPeople();
FillAddresses();
radGridView1.DataSource = people;
GridViewTemplate template = new GridViewTemplate();
template.DataSource = addresses;
radGridView1.MasterTemplate.Templates.Add(template);
GridViewRelation relation = new GridViewRelation(radGridView1.MasterTemplate);
relation.ChildTemplate = template;
relation.RelationName = "PersonAddress";
relation.ParentColumnNames.Add("Id");
relation.ChildColumnNames.Add("PersonId");
radGridView1.Relations.Add(relation);
}
private void CreateUnboundHierarchy()
{
using (this.radGridView1.DeferRefresh())
{
this.radGridView1.MasterTemplate.Reset();
SetupMasterForUnbound();
GridViewTemplate template = SetupChildForUnbound();
GridViewRelation relation = new GridViewRelation(this.radGridView1.MasterTemplate, template);
relation.RelationName = "EmployeesOrders";
relation.ParentColumnNames.Add("Name");
relation.ChildColumnNames.Add("Name");
radGridView1.Relations.Add(relation);
}
this.radGridView1.ChildRows[0].IsExpanded = true;
}
private void CreateBoundHierarchy()
{
using (this.radGridView1.DeferRefresh())
{
this.radGridView1.MasterTemplate.Reset();
this.radGridView1.TableElement.RowHeight = 20;
this.radGridView1.DataSource = nwindDataSet.Suppliers;
this.radGridView1.MasterTemplate.Columns["CompanyName"].HeaderText = "Company Name";
this.radGridView1.MasterTemplate.Columns["ContactName"].HeaderText = "Contact Name";
this.radGridView1.MasterTemplate.Columns["SupplierID"].IsVisible = false;
this.radGridView1.MasterTemplate.Columns["Fax"].IsVisible = false;
this.radGridView1.MasterTemplate.Columns["ContactTitle"].IsVisible = false;
this.radGridView1.MasterTemplate.Columns["Region"].IsVisible = false;
this.radGridView1.MasterTemplate.Columns["City"].IsVisible = false;
this.radGridView1.MasterTemplate.Columns["PostalCode"].IsVisible = false;
this.radGridView1.MasterTemplate.Columns["HomePage"].IsVisible = false;
this.radGridView1.MasterTemplate.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
GridViewTemplate template = new GridViewTemplate();
template.DataSource = nwindDataSet.Products;
this.radGridView1.Templates.Add(template);
template.Columns["ProductName"].HeaderText = "Product Name";
template.Columns["QuantityPerUnit"].HeaderText = "Quantity Per Unit";
template.Columns["QuantityPerUnit"].TextAlignment = ContentAlignment.MiddleCenter;
template.Columns["UnitPrice"].HeaderText = "Unit Price";
template.Columns["UnitPrice"].FormatString = "${0:F2}";
template.Columns["ProductID"].IsVisible = false;
template.Columns["SupplierID"].IsVisible = false;
template.Columns["CategoryID"].IsVisible = false;
template.Columns["UnitsInStock"].IsVisible = false;
template.Columns["UnitsOnOrder"].IsVisible = false;
template.Columns["ReorderLevel"].IsVisible = false;
template.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
GridViewRelation relation = new GridViewRelation(radGridView1.MasterTemplate, template);
relation.RelationName = "SuppliersProducts";
relation.ParentColumnNames.Add("SupplierID");
relation.ChildColumnNames.Add("SupplierID");
this.radGridView1.Relations.Add(relation);
}
}
private void SetUpGrid()
{
((IDbSet <OrderType>) this.data.OrderTypes.All()).Load();
this.radGridView1.DataSource = ((IDbSet <OrderType>) this.data.OrderTypes.All()).Local.ToBindingList();
this.radGridView1.Columns["Orders"].IsVisible = false;
this.radGridView1.Columns["Shippers"].IsVisible = false;
this.radGridView1.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
GridViewTemplate ordersTemplate = new GridViewTemplate();
ordersTemplate.Caption = "Orders";
radGridView1.MasterTemplate.Templates.Add(ordersTemplate);
((IDbSet <Order>) this.data.Orders.All()).Load();
ordersTemplate.DataSource = ((IDbSet <Order>) this.data.Orders.All()).Local.ToBindingList();
ordersTemplate.Columns["OrderType"].IsVisible = false;
ordersTemplate.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
GridViewRelation relation = new GridViewRelation(radGridView1.MasterTemplate);
relation.ChildTemplate = ordersTemplate;
relation.RelationName = "OrderTypesOrders";
relation.ParentColumnNames.Add("OrderTypeId");
relation.ChildColumnNames.Add("OrderTypeId");
radGridView1.Relations.Add(relation);
GridViewTemplate shippersTemplate = new GridViewTemplate();
shippersTemplate.Caption = "Shippers";
radGridView1.MasterTemplate.Templates.Add(shippersTemplate);
((IDbSet <Shipper>) this.data.Shippers.All()).Load();
shippersTemplate.DataSource = ((IDbSet <Shipper>) this.data.Shippers.All()).Local.ToBindingList();
shippersTemplate.Columns["OrderType"].IsVisible = false;
shippersTemplate.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
GridViewRelation relation2 = new GridViewRelation(radGridView1.MasterTemplate);
relation2.ChildTemplate = shippersTemplate;
relation2.RelationName = "OrderTypesShippers";
relation2.ParentColumnNames.Add("OrderTypeId");
relation2.ChildColumnNames.Add("OrderTypeId");
radGridView1.Relations.Add(relation2);
}
void LoadPerformanceTable()
{
Random r = new Random();
DataTable chartTable = new DataTable();
chartTable.Columns.Add("EmployeeID", typeof(int));
for (int i = 0; i < 12; i++)
{
chartTable.Columns.Add("Month" + (i + 1), typeof(int));
}
foreach (DataRow row in this.northwindDataSet.Employees.Rows)
{
DataRow dataRow = chartTable.NewRow();
dataRow["EmployeeID"] = row["EmployeeID"];
for (int i = 0; i < 12; i++)
{
dataRow[i + 1] = r.Next(1000) * 10;
}
chartTable.Rows.Add(dataRow);
}
GridViewTemplate template2 = new GridViewTemplate();
template2.Caption = "Performance";
template2.DataSource = chartTable;
template2.AllowRowResize = false;
template2.ShowColumnHeaders = false;
template2.ShowRowHeaderColumn = false;
template2.Columns[0].Width = 600;
for (int i = 1; i < template2.Columns.Count; i++)
{
template2.Columns[i].IsVisible = false;
}
this.radGridView1.Templates.Add(template2);
GridViewRelation relation2 = new GridViewRelation(this.radGridView1.MasterTemplate);
relation2.ChildTemplate = template2;
relation2.ParentColumnNames.Add("EmployeeID");
relation2.ChildColumnNames.Add("EmployeeID");
this.radGridView1.Relations.Add(relation2);
}
private void radGridView1_UserAddingRow(object sender, GridViewRowCancelEventArgs e)
{
GridViewRowInfo row = e.Rows[0];
if (row.HierarchyLevel == 0)
{
return;
}
GridViewRelation relation = this.radGridView1.Relations.Find(row.ViewTemplate.Parent, row.ViewTemplate);
GridViewRowInfo parentRow = row.Parent as GridViewRowInfo;
PropertyDescriptorCollection parentProperties = ListBindingHelper.GetListItemProperties(parentRow.DataBoundItem);
PropertyDescriptor childDescriptor = parentProperties.Find(relation.ChildColumnNames[0], true);
if (childDescriptor != null)
{
IList children = childDescriptor.GetValue(parentRow.DataBoundItem) as IList;
if (children != null)
{
object newItem = Activator.CreateInstance(ListBindingHelper.GetListItemType(children));
bool success = true;
foreach (GridViewColumn column in row.ViewTemplate.Columns)
{
if (column.IsVisible && !column.ReadOnly && row.Cells[column.FieldName].Value != null && success)
{
success = success & this.SetBoundValue(newItem, column.FieldName, row.Cells[column.FieldName].Value);
}
}
if (!success)
{
e.Cancel = true;
}
else
{
children.Add(newItem);
}
}
}
}
private GridViewTemplate CreateOrderDetailsTemplate()
{
GridViewTemplate orderDetailsTemplate = new GridViewTemplate();
OrdersGrid.Templates.Add(orderDetailsTemplate);
GridViewTextBoxColumn orderColumn = new GridViewTextBoxColumn("vehicle_number");
orderDetailsTemplate.Columns.Add(orderColumn);
orderColumn = new GridViewTextBoxColumn("order_number");
orderDetailsTemplate.Columns.Add(orderColumn);
orderColumn = new GridViewTextBoxColumn("model_name");
orderDetailsTemplate.Columns.Add(orderColumn);
orderColumn = new GridViewTextBoxColumn("engine_designation");
orderDetailsTemplate.Columns.Add(orderColumn);
orderColumn = new GridViewTextBoxColumn("colour");
orderDetailsTemplate.Columns.Add(orderColumn);
orderColumn = new GridViewTextBoxColumn("expected_delivery_date");
orderDetailsTemplate.Columns.Add(orderColumn);
orderColumn = new GridViewTextBoxColumn("actual_delivery_date");
orderDetailsTemplate.Columns.Add(orderColumn);
orderColumn = new GridViewTextBoxColumn("Model.base_cost");
orderDetailsTemplate.Columns.Add(orderColumn);
orderColumn = new GridViewTextBoxColumn("Model.average_lead_time");
orderDetailsTemplate.Columns.Add(orderColumn);
orderColumn = new GridViewTextBoxColumn("Engine.fuel_type");
orderDetailsTemplate.Columns.Add(orderColumn);
orderColumn = new GridViewTextBoxColumn("Trim.additional_cost");
orderDetailsTemplate.Columns.Add(orderColumn);
orderDetailsTemplate.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
var trimDetailsTemplate = CreateTrimDetailsTemplate(orderDetailsTemplate);
GridViewRelation relation = new GridViewRelation(orderDetailsTemplate, trimDetailsTemplate);
relation.RelationName = "TrimEquipment";
OrdersGrid.Relations.Add(relation);
return(orderDetailsTemplate);
}
private void SetUpGrid()
{
((IDbSet<OrderType>)this.data.OrderTypes.All()).Load();
this.radGridView1.DataSource = ((IDbSet<OrderType>)this.data.OrderTypes.All()).Local.ToBindingList();
this.radGridView1.Columns["Orders"].IsVisible = false;
this.radGridView1.Columns["Shippers"].IsVisible = false;
this.radGridView1.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
GridViewTemplate ordersTemplate = new GridViewTemplate();
ordersTemplate.Caption = "Orders";
radGridView1.MasterTemplate.Templates.Add(ordersTemplate);
((IDbSet<Order>)this.data.Orders.All()).Load();
ordersTemplate.DataSource = ((IDbSet<Order>)this.data.Orders.All()).Local.ToBindingList();
ordersTemplate.Columns["OrderType"].IsVisible = false;
ordersTemplate.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
GridViewRelation relation = new GridViewRelation(radGridView1.MasterTemplate);
relation.ChildTemplate = ordersTemplate;
relation.RelationName = "OrderTypesOrders";
relation.ParentColumnNames.Add("OrderTypeId");
relation.ChildColumnNames.Add("OrderTypeId");
radGridView1.Relations.Add(relation);
GridViewTemplate shippersTemplate = new GridViewTemplate();
shippersTemplate.Caption = "Shippers";
radGridView1.MasterTemplate.Templates.Add(shippersTemplate);
((IDbSet<Shipper>)this.data.Shippers.All()).Load();
shippersTemplate.DataSource = ((IDbSet<Shipper>)this.data.Shippers.All()).Local.ToBindingList();
shippersTemplate.Columns["OrderType"].IsVisible = false;
shippersTemplate.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
GridViewRelation relation2 = new GridViewRelation(radGridView1.MasterTemplate);
relation2.ChildTemplate = shippersTemplate;
relation2.RelationName = "OrderTypesShippers";
relation2.ParentColumnNames.Add("OrderTypeId");
relation2.ChildColumnNames.Add("OrderTypeId");
radGridView1.Relations.Add(relation2);
}
private void Form1_Load(object sender, EventArgs e)
{
RadGridLocalizationProvider.CurrentProvider = new MyRuRadGridLocalizationProvider();
this.db.Автомобили.Load();
this.radGridView1.DataSource = this.db.Автомобили.Local.ToBindingList();
this.radGridView1.Columns[0].Width = 30;
this.radGridView1.Columns[0].HeaderText = "№";
this.radGridView1.Columns[0].ReadOnly = true;
this.radGridView1.Columns[1].Width = 100;
this.radGridView1.Columns[2].Width = 100;
this.radGridView1.Columns[3].Width = 150;
this.radGridView1.Columns[4].Width = 100;
this.radGridView1.Columns[5].Width = 150;
this.radGridView1.Columns[6].Width = 150;
this.radGridView1.Columns[7].Width = 150;
this.radGridView1.Columns[8].Width = 150;
this.radGridView1.Columns[9].IsVisible = false;
this.db.Цвет.Load();
comboColumn = new GridViewComboBoxColumn(radGridView1.Columns[9].Name);
comboColumn.DataSource = this.db.Цвет.Local.ToBindingList();
comboColumn.Width = 100;
comboColumn.ValueMember = "id";
comboColumn.DisplayMember = "Наименование";
comboColumn.FieldName = radGridView1.Columns[9].Name;
this.radGridView1.Columns.Add(comboColumn);
radGridView1.Columns.Move(25, 9);
this.radGridView1.Columns[11].IsVisible = false;
this.radGridView1.Columns[11].Width = 100;
this.radGridView1.Columns[12].Width = 80;
this.radGridView1.Columns[13].Width = 80;
this.radGridView1.Columns[14].Width = 80;
this.radGridView1.Columns[15].HeaderText = "Нач.Гарантии";
this.radGridView1.Columns[15].Width = 80;
this.radGridView1.Columns[16].HeaderText = "Валюта";
this.db.Валюты.Load();
comboColumnVal = new GridViewComboBoxColumn(radGridView1.Columns[16].Name);
comboColumnVal.DataSource = this.db.Валюты.Local.ToBindingList();
comboColumnVal.Width = 100;
comboColumnVal.ValueMember = "id";
comboColumnVal.DisplayMember = "Наименование";
comboColumnVal.FieldName = radGridView1.Columns[16].Name;
this.radGridView1.Columns.Add(comboColumnVal);
radGridView1.Columns.Move(oldIndex: 26, newIndex: 16);
this.radGridView1.Columns[17].IsVisible = false;
this.radGridView1.Columns[18].Width = 80;
this.radGridView1.Columns[18].HeaderText = "Кон.Гарантии";
this.radGridView1.Columns[19].Width = 80;
this.radGridView1.Columns[19].HeaderText = "Ориг.VIN";
this.radGridView1.Columns[20].HeaderText = "Дата Регистр.";
this.radGridView1.Columns[20].Width = 80;
radGridView1.Columns[21].IsVisible = false;
radGridView1.Columns[22].IsVisible = false;
radGridView1.Columns[23].IsVisible = false;
radGridView1.Columns[24].IsVisible = false;
radGridView1.Columns[25].IsVisible = false;
radGridView1.Columns[26].IsVisible = false;
//добавление связанной таблицы Тип Салона
var Salon = new GridViewTemplate();
this.db.ТипСалона.Load();
Salon.DataSource = this.db.ТипСалона.Local.ToBindingList();
Salon.Caption = "Тип Салона";
Salon.Columns[1].Width = 200;
Salon.Columns[0].IsVisible = false;
Salon.Columns[2].IsVisible = false;
Salon.Columns[3].IsVisible = false;
this.radGridView1.MasterTemplate.Templates.Add(Salon);
GridViewRelation relationSalon = new GridViewRelation(this.radGridView1.MasterTemplate);
relationSalon.ChildTemplate = Salon;
relationSalon.RelationName = "Тип Салона";
relationSalon.ParentColumnNames.Add("id");
relationSalon.ChildColumnNames.Add("ID_Авто");
this.radGridView1.Relations.Add(relationSalon);
//добавление связанной таблицы Тип Комплектации
GridViewTemplate complect = new GridViewTemplate();
this.db.ВариантыКомплектации.Load();
complect.DataSource = this.db.ВариантыКомплектации.Local.ToBindingList();
complect.Caption = "Варианты комплектации";
complect.Columns[0].IsVisible = false;
complect.Columns[7].IsVisible = false;
complect.Columns[8].IsVisible = false;
complect.Columns[9].IsVisible = false;
complect.Columns[10].IsVisible = false;
complect.Columns[11].IsVisible = false;
complect.Columns[2].Width = 200;
complect.Columns[3].Width = 100;
complect.Columns[4].Width = 100;
complect.Columns[5].Width = 100;
complect.Columns[6].Width = 200;
this.radGridView1.MasterTemplate.Templates.Add(complect);
GridViewRelation relationcomplect = new GridViewRelation(this.radGridView1.MasterTemplate);
relationcomplect.ChildTemplate = complect;
relationcomplect.RelationName = "Варианты комплектации";
relationcomplect.ParentColumnNames.Add("id");
relationcomplect.ChildColumnNames.Add("ID_Авто");
this.radGridView1.Relations.Add(relationcomplect);
//добавление связанной таблицы ТипКузова
GridViewTemplate Kuzov = new GridViewTemplate();
this.db.ТипКузова.Load();
Kuzov.DataSource = this.db.ТипКузова.Local.ToBindingList();
Kuzov.Caption = "Тип Кузова";
Kuzov.Columns[1].Width = 200;
Kuzov.Columns[0].IsVisible = false;
Kuzov.Columns[2].IsVisible = false;
Kuzov.Columns[3].IsVisible = false;
Kuzov.Columns[4].IsVisible = false;
complect.Templates.Add(Kuzov);
GridViewRelation relationKuzov = new GridViewRelation(complect);
relationKuzov.ChildTemplate = Kuzov;
relationKuzov.RelationName = "Тип Кузова";
relationKuzov.ParentColumnNames.Add("id");
relationKuzov.ParentColumnNames.Add("id_Авто");
relationKuzov.ChildColumnNames.Add("ID_Комплект");
relationKuzov.ChildColumnNames.Add("id_Авто");
this.radGridView1.Relations.Add(relationKuzov);
//добавление связанной таблицы ТипКПП
GridViewTemplate template = new GridViewTemplate();
this.db.ТипКПП.Load();
template.DataSource = this.db.ТипКПП.Local.ToBindingList();
template.Caption = "Тип КПП";
template.Columns[0].IsVisible = false;
template.Columns[2].IsVisible = false;
template.Columns[1].Width = 200;
template.Columns[3].IsVisible = false;
template.Columns[4].IsVisible = false;
complect.Templates.Add(template);
GridViewRelation relation = new GridViewRelation(complect);
relation.ChildTemplate = template;
relation.RelationName = "Тип КПП";
relation.ParentColumnNames.Add("id");
relation.ParentColumnNames.Add("id_Авто");
relation.ChildColumnNames.Add("ID_Комплект");
relation.ChildColumnNames.Add("id_Авто");
this.radGridView1.Relations.Add(relation);
//типы двигателей
var dvig_komplect = new GridViewTemplate();
this.db.ТипыДвигателей.Load();
dvig_komplect.DataSource = this.db.ТипыДвигателей.Local.ToBindingList();
dvig_komplect.Caption = "Типы Двигателя";
complect.Templates.Add(dvig_komplect);
dvig_komplect.Columns[1].Width = 200;
dvig_komplect.Columns[2].Width = 200;
dvig_komplect.Columns[0].IsVisible = false;
dvig_komplect.Columns[3].IsVisible = false;
dvig_komplect.Columns[4].IsVisible = false;
dvig_komplect.Columns[5].IsVisible = false;
GridViewRelation relationdvig_com = new GridViewRelation(complect);
relationdvig_com.ChildTemplate = dvig_komplect;
relationdvig_com.RelationName = "Тип Двигателя";
relationdvig_com.ParentColumnNames.Add("id");
relationdvig_com.ParentColumnNames.Add("id_Авто");
relationdvig_com.ChildColumnNames.Add("ID_Комплект");
relationdvig_com.ChildColumnNames.Add("id_Авто");
this.radGridView1.Relations.Add(relationdvig_com);
//
}
private void CreateBoundHierarchy()
{
var deliveryBiz = new DeliveryBiz();
using (this.radGridView.DeferRefresh())
{
this.radGridView.MasterTemplate.Reset();
this.radGridView.AutoGenerateColumns = true;
this.radGridView.AllowCellContextMenu = false;
this.radGridView.ReadOnly = true;
this.radGridView.TableElement.RowHeight = 20;
this.radGridView.DataSource = deliveryBiz.GetTemplateData();
this.radGridView.MasterTemplate.Columns["Vehicle"].HeaderText = "Xe";
this.radGridView.MasterTemplate.Columns["DeliveryNo"].HeaderText = "Số giao hàng";
this.radGridView.MasterTemplate.Columns["DeliveryDate"].HeaderText = "Ngày giao";
this.radGridView.MasterTemplate.Columns["StartTime"].HeaderText = "Giờ giao";
this.radGridView.MasterTemplate.Columns["Status"].HeaderText = "Tình trạng";
this.radGridView.MasterTemplate.Columns["Id"].IsVisible = false;
this.radGridView.MasterTemplate.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
var orderBiz = new OrderBiz();
GridViewTemplate template = new GridViewTemplate();
template.AutoGenerateColumns = true;
template.AllowAddNewRow = false;
template.AllowCellContextMenu = false;
template.ReadOnly = true;
template.DataSource = orderBiz.GetTemplateData();
this.radGridView.Templates.Add(template);
template.Columns["OrderNo"].HeaderText = "Mã đơn hàng";
template.Columns["Status"].HeaderText = "Tình trạng";
template.Columns["Customer"].HeaderText = "Khách hàng";
template.Columns["DeliveryDate"].HeaderText = "Ngày giao";
template.Columns["DeliveryInternal"].HeaderText = "Hình thức vận chuyển";
template.Columns["SendMessage"].HeaderText = "Tin nhắn";
template.Columns["SendEmail"].HeaderText = "Email";
template.Columns["SendReport"].HeaderText = "Thông báo";
template.Columns["Id"].IsVisible = false;
template.Columns["ParentId"].IsVisible = false;
template.Columns["Recipient"].IsVisible = false;
template.Columns["CustomerId"].IsVisible = false;
template.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
GridViewRelation relation = new GridViewRelation(radGridView.MasterTemplate, template);
relation.RelationName = "SuppliersProducts";
relation.ParentColumnNames.Add("Id");
relation.ChildColumnNames.Add("ParentId");
this.radGridView.Relations.Add(relation);
FormatCell();
}
}
private void FillDataLoanToControl(string query, Dictionary <string, string> param = null)
{
try
{
using (SqlConnection con = new SqlConnection(Properties.Settings.Default.vPretConnectionString))
{
con.Open();
using (SqlCommand cmd = new SqlCommand(query, con))
{
cmd.CommandType = CommandType.Text;
if (param != null)
{
foreach (KeyValuePair <string, string> sqlparam in param)
{
cmd.Parameters.Add(new SqlParameter(sqlparam.Key, sqlparam.Value));
}
}
using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
{
using (DataSet ds = new DataSet())
{
cmd.ExecuteNonQuery();
sda.Fill(ds);
radGridViewControlTech.DataSource = ds.Tables[0];
GridViewCheckBoxColumn checkbox = new GridViewCheckBoxColumn();
checkbox.Name = "ValiderControle";
checkbox.FieldName = "ValiderControle";
checkbox.HeaderText = "Valider Contrôle";
checkbox.DataType = typeof(int);
checkbox.EditMode = EditMode.OnValueChange;
radGridViewControlTech.MasterTemplate.Columns.Add(checkbox);
radGridViewControlTech.MasterTemplate.Columns["LOAID"].IsVisible = false;
radGridViewControlTech.MasterTemplate.BestFitColumns();
radGridViewControlTech.AllowAddNewRow = false;
radGridViewControlTech.AllowColumnResize = true;
radGridViewControlTech.MasterTemplate.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
/*
* Here the relation between Loan & product
* */
GridViewTemplate template1 = new GridViewTemplate();
template1.AllowAddNewRow = false;
template1.DataSource = ds.Tables[1];
radGridViewControlTech.MasterTemplate.Templates.Add(template1);
GridViewRelation relation1 = new GridViewRelation(radGridViewControlTech.MasterTemplate);
relation1.ChildTemplate = template1;
relation1.RelationName = "Produit / Pret";
relation1.ParentColumnNames.Add("LOAID");
relation1.ChildColumnNames.Add("PROLOAIDFK");
radGridViewControlTech.Templates[0].Columns["PROLOAIDFK"].IsVisible = false;
radGridViewControlTech.Templates[0].Columns["PROID"].IsVisible = false;
radGridViewControlTech.Templates[0].AllowAutoSizeColumns = true;
radGridViewControlTech.Templates[0].AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
radGridViewControlTech.Templates[0].BestFitColumns();
radGridViewControlTech.Relations.Add(relation1);
/**
* Here the relation between Product & accessories
**/
// Can't use radgridview.MasterTemplates.template for some reasons
GridViewTemplate template2 = new GridViewTemplate();
template2.AllowAddNewRow = false;
template2.DataSource = ds.Tables[2];
template1.Templates.Add(template2);
GridViewRelation relation2 = new GridViewRelation(template1);
relation2.ChildTemplate = template2;
relation2.RelationName = "Produit / Accessoire";
relation2.ParentColumnNames.Add("PROID");
relation2.ChildColumnNames.Add("ACCPROIDFK");
template2.Columns["ACCPROIDFK"].IsVisible = false;
template2.AllowAutoSizeColumns = true;
template2.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
template2.BestFitColumns();
radGridViewControlTech.Relations.Add(relation2);
template2.Columns["Nom Accessoire"].ReadOnly = true;
template2.Columns["PN Accessoire"].ReadOnly = true;
template2.Columns["Commentaire Accessoire"].ReadOnly = true;
template1.Columns["Nom Produit"].ReadOnly = true;
template1.Columns["N°Série Produit"].ReadOnly = true;
template1.Columns["Commentaire Produit"].ReadOnly = true;
template1.AllowDeleteRow = false;
template2.AllowDeleteRow = false;
radGridViewControlTech.MasterTemplate.AllowDeleteRow = false;
foreach (GridViewColumn row in radGridViewControlTech.Columns)
{
if (row.FieldName.Equals("ValiderControle") == false)
{
row.ReadOnly = true;
}
}
foreach (GridViewRowInfo rowInfo in radGridViewControlTech.Rows)
{
IQueryable <LOAN> loans = (from LOAN in VpretContext.Instance.vPretContext.LOAN
where LOAN.LOA_ID.Equals(rowInfo.Cells["LOAID"].Value.ToString())
select LOAN);
if (loans != null)
{
foreach (LOAN loan in loans)
{
GridViewDataRowInfo row = rowInfo as GridViewDataRowInfo;
GridViewHierarchyRowInfo hierarchyRow = row as GridViewHierarchyRowInfo;
if (hierarchyRow != null)
{
IterateChildRowsAndAddProduct(hierarchyRow);
}
if (loan.LOA_STATE == 1)
{
rowInfo.Cells["ValiderControle"].Value = CheckState.Checked;
}
}
}
}
}
}
}
}
radGridViewControlTech.MasterTemplate.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
radGridViewControlTech.Templates[0].AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
this.Dock = DockStyle.Fill;
}
catch (Exception ex)
{
Log.UCTechControle.Error("FillDataLoanToControl - Exception: " + ex.ToString());
}
finally
{
Log.UCTechControle.Debug("FillDataLoanToControl : STATUT : PASSED");
}
}
/// <summary>
/// This function create & set all values for Reception of Products
/// </summary>
/// <param name="query"></param>
/// <param name="param"></param>
private void FillDataReceptionProduct(string query, Dictionary <string, string> param = null)
{
try
{
using (SqlConnection con = new SqlConnection(Properties.Settings.Default.x3v5sConnectionString))
{
using (SqlCommand cmd = new SqlCommand(query, con))
{
cmd.CommandType = CommandType.Text;
if (param != null)
{
foreach (KeyValuePair <string, string> sqlparam in param)
{
cmd.Parameters.Add(new SqlParameter(sqlparam.Key, sqlparam.Value));
}
}
using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
{
using (DataSet ds = new DataSet())
{
sda.Fill(ds);
radGridViewProductReturn.DataSource = ds.Tables[0];
GridViewCheckBoxColumn checkbox = new GridViewCheckBoxColumn();
checkbox.DataType = typeof(int);
checkbox.EditMode = EditMode.OnValueChange;
checkbox.Name = "ValiderArrivee1";
checkbox.FieldName = "ValiderArrivee";
checkbox.HeaderText = "Valider l'arrivée";
radGridViewProductReturn.MasterTemplate.Columns.Add(checkbox);
radGridViewProductReturn.MasterTemplate.BestFitColumns();
radGridViewProductReturn.AllowAddNewRow = false;
radGridViewProductReturn.AllowColumnResize = true;
GridViewTemplate template = new GridViewTemplate();
template.AllowAddNewRow = false;
template.DataSource = ds.Tables[1];
radGridViewProductReturn.MasterTemplate.Templates.Add(template);
GridViewRelation relation = new GridViewRelation(radGridViewProductReturn.MasterTemplate);
relation.ChildTemplate = template;
relation.RelationName = "Produit / Pret";
relation.ParentColumnNames.Add("N° CP");
relation.ChildColumnNames.Add("N° CP");
// radGridViewRecepFournisseur.MasterTemplate.Columns["N° CP"].IsVisible = false;
radGridViewProductReturn.Templates[0].Columns["N° CP"].IsVisible = false;
radGridViewProductReturn.Templates[0].AllowAutoSizeColumns = true;
radGridViewProductReturn.Templates[0].BestFitColumns();
radGridViewProductReturn.Relations.Add(relation);
template.Columns["Produit"].ReadOnly = true;
template.Columns["Détail"].ReadOnly = true;
template.Columns["N°Série"].ReadOnly = true;
template.AllowDeleteRow = false;
radGridViewProductReturn.MasterTemplate.AllowDeleteRow = false;
foreach (GridViewColumn row in radGridViewProductReturn.Columns)
{
if (row.FieldName.Equals("ValiderArrivee") == false)
{
row.ReadOnly = true;
}
}
foreach (GridViewRowInfo rowInfo in radGridViewProductReturn.Rows)
{
IQueryable <LOAN> loans = (from LOAN in VpretContext.Instance.vPretContext.LOAN
where LOAN.LOA_CP.Equals(rowInfo.Cells["N° CP"].Value.ToString())
select LOAN);
if (loans != null)
{
foreach (LOAN loan in loans)
{
if (loan.LOA_STATE != null)
{
if (loan.LOA_STATE == 1)
{
rowInfo.Cells["ValiderArrivee1"].Value = CheckState.Checked;
}
}
}
}
}
radGridViewProductReturn.MasterTemplate.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
radGridViewProductReturn.Templates[0].AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.None;
radGridViewProductReturn.AutoScroll = true;
radGridViewProductReturn.MasterTemplate.HorizontalScrollState = ScrollState.AlwaysShow;
radGridViewProductReturn.MasterTemplate.Templates[0].HorizontalScrollState = ScrollState.AlwaysShow;
radGridViewProductReturn.MasterTemplate.AutoGenerateColumns = true;
radGridViewProductReturn.MasterTemplate.Templates[0].AutoGenerateColumns = true;
radGridViewProductReturn.Templates[0].BestFitColumns();
this.Dock = DockStyle.Fill;
}
}
}
}
}
catch (Exception ex)
{
Log.UCRP.Error("FillDataRadGridRecepProduit() - Exception: " + ex.ToString());
}
finally
{
Log.UCRP.Debug("FillDataRadGridRecepProduit() : STATUT : PASSED");
}
}
void frmBiddings_Load(object sender, EventArgs e)
{
try
{
GridViewCheckBoxColumn col = new GridViewCheckBoxColumn();
col.Width = 60;
col.AutoSizeMode = BestFitColumnMode.None;
col.HeaderText = "";
col.Name = "chkBid";
grdPendingJobs.Columns.Add(col);
col = new GridViewCheckBoxColumn();
col.Width = 60;
col.AutoSizeMode = BestFitColumnMode.None;
col.HeaderText = "";
col.Name = "chkBid";
grdPreBookings.Columns.Add(col);
//this.grdPendingJobs.MasterTemplate.Reset();
// this.grdPendingJobs.TableElement.RowHeight = 20;
PopulateData();
FormatGrid();
GridViewCommandColumn cmdCol = new GridViewCommandColumn();
cmdCol.UseDefaultText = true;
cmdCol.DefaultText = "Accept";
cmdCol.Name = "accept";
cmdCol.Width = 70;
cmdCol.TextAlignment = ContentAlignment.MiddleCenter;
grdPendingJobs.Templates[0].Columns.Add(cmdCol);
cmdCol = new GridViewCommandColumn();
cmdCol.UseDefaultText = true;
cmdCol.DefaultText = "Accept";
cmdCol.Name = "accept";
cmdCol.Width = 70;
cmdCol.TextAlignment = ContentAlignment.MiddleCenter;
grdPreBookings.Templates[0].Columns.Add(cmdCol);
GridViewRelation relation = new GridViewRelation(grdPendingJobs.MasterTemplate, grdPendingJobs.Templates[0]);
relation.RelationName = "BookingBiddings"; relation.ParentColumnNames.Add("Id");
relation.ChildColumnNames.Add("Id");
this.grdPendingJobs.Relations.Add(relation);
relation = new GridViewRelation(grdPreBookings.MasterTemplate, grdPreBookings.Templates[0]);
relation.RelationName = "BookingBiddings"; relation.ParentColumnNames.Add("Id");
relation.ChildColumnNames.Add("Id");
this.grdPreBookings.Relations.Add(relation);
grdPendingJobs.Rows.ToList().ForEach(c => c.Cells["chkBid"].Value = c.Cells["Bid"].Value);
grdPreBookings.Rows.ToList().ForEach(c => c.Cells["chkBid"].Value = c.Cells["Bid"].Value);
timer1.Start();
this.SizeChanged += new EventHandler(frmBiddings_SizeChanged);
}
catch (Exception ex)
{
ENUtils.ShowMessage(ex.Message);
}
}
