-
Notifications
You must be signed in to change notification settings - Fork 128
/
Index.cshtml
124 lines (119 loc) · 4.3 KB
/
Index.cshtml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
@{
Layout = "~/Views/_Layout.cshtml";
}
<div id="grid"></div>
<script>
$(function() {
$("#grid").dxDataGrid({
dataSource: DevExpress.data.AspNet.createStore({
key: "orderId",
loadUrl: "@Url.Action("Orders", "Northwind")",
updateUrl: "@Url.Action("UpdateOrder", "Northwind")",
insertUrl: "@Url.Action("InsertOrder", "Northwind")",
deleteUrl: "@Url.Action("DeleteOrder", "Northwind")",
onBeforeSend: function(operation, ajaxSettings) {
// operation - any of "load", "update", "insert", "delete"
// ajaxSettings - http://api.jquery.com/jquery.ajax/
}
}),
columns: [
{
dataField: "customerId",
caption: "Customer",
lookup: {
valueExpr: "value",
displayExpr: "text",
dataSource: DevExpress.data.AspNet.createStore({
key: "value",
loadUrl: "@Url.Action("CustomersLookup", "Northwind")"
})
}
},
{
dataField: "orderDate",
dataType: "date",
headerFilter: {
groupInterval: "quarter"
}
},
{
dataField: "orderDateOnly",
dataType: "date",
headerFilter: {
groupInterval: "quarter"
}
},
{
dataField: "orderTimeOnly",
dataType: "time",
headerFilter: {
//groupInterval: "quarter" // N|A
}
},
{
dataField: "freight",
headerFilter: {
groupInterval: 100
}
},
"shipCountry",
"shipRegion",
{
dataField: "shipVia",
lookup: {
valueExpr: "value",
displayExpr: "text",
dataSource: DevExpress.data.AspNet.createStore({
key: "value",
loadUrl: "@Url.Action("ShippersLookup", "Northwind")"
})
}
}
],
groupPanel: { visible: true },
searchPanel: { visible: true },
filterRow: { visible: true },
filterPanel: { visible: true },
headerFilter: {
allowSearch: true,
visible: true
},
editing: {
allowUpdating: true,
allowAdding: true,
allowDeleting: true
},
remoteOperations: true,
grouping: {
autoExpandAll: false
},
summary: {
totalItems: [
{ column: "freight", summaryType: "sum" },
{ column: "orderDate", summaryType: "count" },
{ column: "orderDateOnly", summaryType: "count" },
//{ column: "orderTimeOnly", summaryType: "count" }
],
groupItems: [
{ column: "freight", summaryType: "sum" },
{ summaryType: "count" }
]
},
masterDetail: {
enabled: true,
template: function(container, options) {
$("<div>")
.dxDataGrid({
dataSource: DevExpress.data.AspNet.createStore({
loadUrl: "@Url.Action("OrderDetails", "Northwind")",
loadParams: { orderId: options.data.orderId }
}),
remoteOperations: true,
showBorders: true
})
.appendTo(container);
}
}
});
});
</script>