or
<
telerik:RadGrid
AutoGenerateColumns
=
"False"
ID
=
"RadGrid4"
AllowFilteringByColumn
=
"True"
AllowSorting
=
"True"
runat
=
"server"
OnItemCommand
=
"RadGrid4_ItemCommand"
OnItemCreated
=
"RadGrid4_ItemCreated"
EnableLinqExpressions
=
"false"
HtmlEncode
=
"true"
OnNeedDataSource
=
"RadGrid4_NeedDataSource"
GroupingSettings-RetainGroupFootersVisibility
=
"true"
ShowGroupPanel
=
"True"
CellSpacing
=
"-1"
GridLines
=
"Both"
Skin
=
"Office2010Silver"
EnableViewState
=
"true"
Width
=
"100%"
>
<
PagerStyle
Mode
=
"NextPrevAndNumeric"
/>
<
GroupingSettings
CaseSensitive
=
"false"
/>
<
ClientSettings
AllowKeyboardNavigation
=
"true"
>
</
ClientSettings
>
<
ExportSettings
OpenInNewWindow
=
"true"
FileName
=
"i-Dispatch Job Part Used Report"
ExportOnlyData
=
"true"
>
<
Pdf
PageHeight
=
"210mm"
PageWidth
=
"297mm"
DefaultFontFamily
=
"Arial Unicode MS"
PageTopMargin
=
"45mm"
BorderStyle
=
"Medium"
BorderColor
=
"#666666"
PaperSize
=
"A4"
>
</
Pdf
>
</
ExportSettings
>
<
MasterTableView
Width
=
"100%"
DataKeyNames
=
"JobID"
HierarchyLoadMode
=
"ServerOnDemand"
ShowGroupFooter
=
"true"
AllowMultiColumnSorting
=
"true"
>
<
Columns
>
<
telerik:GridMaskedColumn
DataField
=
"JobID"
HeaderText
=
"JobID#"
FilterControlWidth
=
"50px"
AutoPostBackOnFilter
=
"false"
CurrentFilterFunction
=
"EqualTo"
FilterDelay
=
"2000"
ShowFilterIcon
=
"false"
Mask
=
"#####"
GroupByExpression
=
"JobID Group By JobID"
>
<
ColumnValidationSettings
>
<
ModelErrorMessage
Text
=
""
></
ModelErrorMessage
>
</
ColumnValidationSettings
>
</
telerik:GridMaskedColumn
>
<
telerik:GridBoundColumn
DataField
=
"JobTitle"
FilterControlAltText
=
"Filter JobTitle column"
HeaderText
=
"Job Title"
SortExpression
=
"JobTitle"
UniqueName
=
"JobTitle"
>
<
ColumnValidationSettings
>
<
ModelErrorMessage
Text
=
""
/>
</
ColumnValidationSettings
>
</
telerik:GridBoundColumn
>
<
telerik:GridDateTimeColumn
DataField
=
"JobBookedDate"
PickerType
=
"DatePicker"
EnableTimeIndependentFiltering
=
"true"
DataFormatString
=
"{0:dd/MM/yyyy HH:mm }"
DataType
=
"System.DateTime"
FilterControlAltText
=
"Filter JobBookedDate column"
HeaderText
=
"Job Booked Date"
SortExpression
=
"JobBookedDate"
UniqueName
=
"JobBookedDate"
>
<
ColumnValidationSettings
>
<
ModelErrorMessage
Text
=
""
/>
</
ColumnValidationSettings
>
</
telerik:GridDateTimeColumn
>
<
telerik:GridTemplateColumn
DataField
=
"AssignedStaffID"
HeaderText
=
"Mobile Staff"
UniqueName
=
"AssignedStaffID"
HeaderStyle-Width
=
"200px"
SortExpression
=
"AssignedStaffID"
>
<
FilterTemplate
>
<
telerik:RadComboBox
ID
=
"comboStaff"
DataTextField
=
"StaffName"
DataValueField
=
"StaffID"
Height
=
"100px"
AppendDataBoundItems
=
"true"
SelectedValue='<%# ((GridItem)Container).OwnerTableView.GetColumn("AssignedStaffID").CurrentFilterValue %>'
runat="server" OnClientSelectedIndexChanged="StaffIndexChanged">
<
Items
>
<
telerik:RadComboBoxItem
Text
=
"All"
/>
</
Items
>
</
telerik:RadComboBox
>
<
telerik:RadScriptBlock
ID
=
"RadScriptBlock10"
runat
=
"server"
>
<
script
type
=
"text/javascript"
>
function StaffIndexChanged(sender, args) {
var tableView = $find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");
tableView.filter("AssignedStaffID", args.get_item().get_value(), "EqualTo");
}
</
script
>
</
telerik:RadScriptBlock
>
</
FilterTemplate
>
<
ItemTemplate
>
<%# Eval("Staff") %>
</
ItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
DataField
=
"CreatedBy"
HeaderText
=
"Added By"
UniqueName
=
"CreatedBy"
HeaderStyle-Width
=
"200px"
SortExpression
=
"CreatedBy"
>
<
FilterTemplate
>
<
telerik:RadComboBox
ID
=
"comboAdded"
DataTextField
=
"StaffName"
DataValueField
=
"StaffID"
Height
=
"100px"
AppendDataBoundItems
=
"true"
SelectedValue='<%# ((GridItem)Container).OwnerTableView.GetColumn("CreatedBy").CurrentFilterValue %>'
runat="server" OnClientSelectedIndexChanged="AddedByIndexChanged">
<
Items
>
<
telerik:RadComboBoxItem
Text
=
"All"
/>
</
Items
>
</
telerik:RadComboBox
>
<
telerik:RadScriptBlock
ID
=
"RadScriptBlock11"
runat
=
"server"
>
<
script
type
=
"text/javascript"
>
function AddedByIndexChanged(sender, args) {
var tableView = $find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");
tableView.filter("CreatedBy", args.get_item().get_value(), "EqualTo");
}
</
script
>
</
telerik:RadScriptBlock
>
</
FilterTemplate
>
<
ItemTemplate
>
<%# Eval("AddedBy") %>
</
ItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridBoundColumn
DataField
=
"PartCode"
FilterControlAltText
=
"Filter PartCode column"
HeaderText
=
"Part Code"
SortExpression
=
"PartCode"
UniqueName
=
"PartCode"
>
<
ColumnValidationSettings
>
<
ModelErrorMessage
Text
=
""
/>
</
ColumnValidationSettings
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"PartName"
Aggregate
=
"Count"
FooterText
=
"Total parts: "
FilterControlAltText
=
"Filter PartName column"
HeaderText
=
"Part Name"
SortExpression
=
"PartName"
UniqueName
=
"Part Name"
>
<
ColumnValidationSettings
>
<
ModelErrorMessage
Text
=
""
/>
</
ColumnValidationSettings
>
</
telerik:GridBoundColumn
>
<
telerik:GridNumericColumn
DataFormatString
=
"{0:$###,##0.00}"
DataField
=
"PartPurchasePrice"
DataType
=
"System.Double"
NumericType
=
"Currency"
HeaderText
=
"Purchase Price"
SortExpression
=
"PartPurchasePrice"
UniqueName
=
"PartPurchasePrice"
Aggregate
=
"Sum"
FooterText
=
"Total : "
FooterAggregateFormatString
=
"{0:C}"
>
<
FooterStyle
Font-Bold
=
"true"
></
FooterStyle
>
</
telerik:GridNumericColumn
>
<
telerik:GridNumericColumn
DataFormatString
=
"{0:$###,##0.00}"
DataField
=
"PartSalePrice"
DataType
=
"System.Double"
NumericType
=
"Currency"
HeaderText
=
"Recommended Sale Price"
SortExpression
=
"PartSalePrice"
UniqueName
=
"PartSalePrice"
FooterText
=
"Total: "
Aggregate
=
"Sum"
FooterAggregateFormatString
=
"{0:C}"
>
<
FooterStyle
Font-Bold
=
"true"
></
FooterStyle
>
</
telerik:GridNumericColumn
>
<
telerik:GridNumericColumn
DataFormatString
=
"{0:$###,##0.00}"
DataField
=
"JobPartUnitPrice"
DataType
=
"System.Double"
NumericType
=
"Currency"
HeaderText
=
"Sale Price Charged"
SortExpression
=
"JobPartUnitPrice"
UniqueName
=
"JobPartUnitPrice"
Aggregate
=
"Sum"
FooterAggregateFormatString
=
"{0:C}"
>
<
FooterStyle
Font-Bold
=
"true"
></
FooterStyle
>
</
telerik:GridNumericColumn
>
<
telerik:GridNumericColumn
DataField
=
"JobPartQuantity"
DataType
=
"System.Double"
HeaderText
=
"Quantity"
SortExpression
=
"JobPartQuantity"
UniqueName
=
"JobPartQuantity"
Aggregate
=
"Sum"
FooterAggregateFormatString
=
"{0:n}"
>
<
FooterStyle
Font-Bold
=
"true"
></
FooterStyle
>
</
telerik:GridNumericColumn
>
<
telerik:GridNumericColumn
DataFormatString
=
"{0:$###,##0.00}"
DataField
=
"JobPartGST"
DataType
=
"System.Double"
NumericType
=
"Currency"
HeaderText
=
"GST Charged"
SortExpression
=
"JobPartGST"
UniqueName
=
"JobPartGST"
Aggregate
=
"Sum"
FooterAggregateFormatString
=
"{0:C}"
>
<
FooterStyle
Font-Bold
=
"true"
></
FooterStyle
>
</
telerik:GridNumericColumn
>
<
telerik:GridNumericColumn
DataFormatString
=
"{0:$###,##0.00}"
DataField
=
"JobPartTotal"
DataType
=
"System.Double"
NumericType
=
"Currency"
HeaderText
=
"Total"
SortExpression
=
"JobPartTotal"
UniqueName
=
"JobPartTotal"
Aggregate
=
"Sum"
FooterAggregateFormatString
=
"{0:C}"
>
<
FooterStyle
Font-Bold
=
"true"
></
FooterStyle
>
</
telerik:GridNumericColumn
>
<
telerik:GridCalculatedColumn
HeaderText
=
"Gross Margin"
UniqueName
=
"GrossMargin"
DataType
=
"System.Double"
DataFormatString
=
"{0:$###,##0.00}"
DataFields
=
"JobPartUnitPrice, PartPurchasePrice"
Expression
=
"{0}-{1}"
FooterText
=
"Total : "
Aggregate
=
"Sum"
>
</
telerik:GridCalculatedColumn
>
<
telerik:GridCalculatedColumn
HeaderText
=
"Gross Margin Percentage"
UniqueName
=
"GrossMarginPercentage"
DataType
=
"System.Double"
DataFormatString
=
"{0:P}"
DataFields
=
"JobPartUnitPrice, PartPurchasePrice"
Expression
=
"iif({0}=0,0,iif(({0}-{1})=0,0,(({0}-{1})/{0})*100))"
FooterText
=
"Total : "
Aggregate
=
"Sum"
>
</
telerik:GridCalculatedColumn
>
</
Columns
>
<
GroupByExpressions
>
<
telerik:GridGroupByExpression
>
<
GroupByFields
>
<
telerik:GridGroupByField
FieldName
=
"JobID"
></
telerik:GridGroupByField
>
</
GroupByFields
>
<
SelectFields
>
<
telerik:GridGroupByField
FieldName
=
"JobID"
HeaderText
=
"JobID#"
></
telerik:GridGroupByField
>
</
SelectFields
>
</
telerik:GridGroupByExpression
>
</
GroupByExpressions
>
</
MasterTableView
>
<
ClientSettings
AllowDragToGroup
=
"true"
>
<
Scrolling
AllowScroll
=
"True"
UseStaticHeaders
=
"True"
/>
</
ClientSettings
>
<
GroupingSettings
ShowUnGroupButton
=
"true"
></
GroupingSettings
>
</
telerik:RadGrid
>
<%#Container.ItemIndex%>
<asp:ImageButton ID=
"imgAdmin"
runat=
"server"
OnCommand=
"verCalendarioAdmin"
<br> CommandArgument=
'<%#Container.ItemIndex%>'
ImageUrl=
"./Img/Perfil/administrar.png"
ToolTip=
'<%$ Resources: GridAdministrar %>'
/>
001.
<
telerik:RadSplitter
id
=
"RadSplitter1"
runat
=
"server"
Height
=
"488"
Width
=
"767"
>
002.
<
telerik:RadPane
id
=
"LPane"
runat
=
"server"
width
=
"22px"
Scrolling
=
"None"
>
003.
<
telerik:RadSlidingZone
ID
=
"LSlidingZone"
runat
=
"server"
Width
=
"22px"
>
004.
<
telerik:RadSlidingPane
ID
=
"LSlidingPane"
runat
=
"server"
005.
EnableDock
=
"True"
EnableResize
=
"True"
Scrolling
=
"None"
Title
=
"Location"
006.
Width
=
"250px"
>
007.
<
telerik:RadSplitter
ID
=
"Radsplitter3"
runat
=
"server"
Height
=
"275"
Orientation
=
"Horizontal"
Width
=
"260"
>
008.
<
telerik:RadPane
ID
=
"LoRadpane"
runat
=
"server"
Scrolling
=
"None"
CssClass
=
"AutoHeight"
>
009.
<
asp:Panel
ID
=
"pnlL"
runat
=
"server"
>
010.
<
div
ID
=
"DivC"
align
=
"center"
style
=
"overflow: hidden"
>
011.
012.
<
asp:DropDownList
ID
=
"Bdropdwn"
runat
=
"server"
013.
AutoPostBack
=
"false"
Height
=
"25px"
Width
=
"200px"
>
014.
</
asp:DropDownList
>
015.
016.
<
br
/>
017.
<
p
/>
018.
<
asp:ListBox
ID
=
"RListBox"
runat
=
"server"
AutoPostBack
=
"false"
019.
Height
=
"150px"
Width
=
"200px"
>
020.
</
asp:ListBox
>
021.
<
br
/>
022.
</
div
>
023.
</
asp:Panel
>
024.
</
telerik:RadPane
>
025.
<
telerik:RadSplitBar
id
=
"URadsplitbar"
runat
=
"server"
CssClass
=
"tab_click"
>
026.
</
telerik:RadSplitBar
>
027.
<
telerik:RadPane
id
=
"URadpane"
runat
=
"server"
>
028.
<
asp:Panel
id
=
"pnlU"
runat
=
"server"
Height
=
"100px"
Width
=
"260px"
>
029.
<
div
id
=
"layer"
align
=
"center"
>
030.
031.
<
p
align
=
"center"
>
032.
<
input
id
=
"file"
type
=
"file"
width
=
"200px"
/>
033.
</
p
>
034.
</
div
>
035.
<
div
id
=
"dvFileExplorer"
>
036.
<
asp:Panel
runat
=
"server"
ID
=
"pnlFileExplorer"
class
=
"dvFileExplorerContent"
>
037.
038.
<
telerik:RadFileExplorer
ID
=
"RadFileExplorer"
runat
=
"server"
039.
EnableOpenFile
=
"false"
040.
ExplorerMode
=
"Default"
Width
=
"100%"
>
041.
</
telerik:RadFileExplorer
>
042.
043.
</
asp:Panel
>
044.
</
div
>
045.
</
asp:Panel
>
046.
</
telerik:RadPane
>
047.
</
telerik:RadSplitter
>
048.
</
telerik:RadSlidingPane
>
049.
050.
<
telerik:RadSlidingPane
ID
=
"MPane"
runat
=
"server"
EnableDock
=
"True"
EnableResize
=
"True"
Title
=
"Message(s)"
Height
=
"275"
Width
=
"260"
>
051.
<
div
id
=
"AccordionMPane"
>
052.
</
div
>
053.
</
telerik:RadSlidingPane
>
054.
<
telerik:RadSlidingPane
id
=
"EPane"
runat
=
"server"
EnableDock
=
"True"
EnableResize
=
"True"
Title
=
"Error(s)"
Height
=
"275"
Width
=
"260"
>
055.
<
div
id
=
"AccordionEPane"
>
056.
</
div
>
057.
</
telerik:RadSlidingPane
>
058.
<
telerik:RadSlidingPane
id
=
"SPane"
runat
=
"server"
EnableDock
=
"True"
EnableResize
=
"True"
Title
=
"Summary"
Height
=
"275"
Width
=
"260"
>
059.
<
div
id
=
"AccordianSPane"
>
060.
</
div
>
061.
</
telerik:RadSlidingPane
>
062.
</
telerik:RadSlidingZone
>
063.
</
telerik:RadPane
>
064.
065.
<%--Splitter Bar--%>
066.
<
telerik:RadSplitBar
id
=
"RadSplitbar1"
runat
=
"server"
>
067.
</
telerik:RadSplitBar
>
068.
069.
<%--Main Pane--%>
070.
<
telerik:RadPane
id
=
"MiddlePane"
runat
=
"server"
Scrolling
=
"None"
>
071.
<
asp:UpdatePanel
ID
=
"UpdatePanel1"
runat
=
"server"
UpdateMode
=
"Conditional"
>
072.
<
ContentTemplate
>
073.
<
div
id
=
"TabDiv"
class
=
"tabcontainer"
style
=
"margin:0px;border-width:0px; padding:0px;border:none;"
>
074.
<
ul
class
=
"tabs"
>
075.
<
li
><
a
href
=
"#W#"
class
=
"tab-link current"
>W</
a
></
li
>
076.
<
li
><
a
href
=
"#S1#"
class
=
"tab-link"
>S1</
a
></
li
>
077.
<
li
><
a
href
=
"#S2#"
class
=
"tab-link"
>S2</
a
></
li
>
078.
<
li
><
a
href
=
"#S3#"
class
=
"tab-link"
>S3</
a
></
li
>
079.
<
li
><
a
href
=
"#R#"
class
=
"tab-link"
>R</
a
></
li
>
080.
</
ul
>
081.
<
div
id
=
"W#"
class
=
"tab-content"
>
082.
</
div
>
083.
<
div
id
=
"S1#"
class
=
"tab-content"
>
084.
<
div
>
085.
</
div
>
086.
</
div
>
087.
<
div
id
=
"S2#"
class
=
"tab-content"
>
088.
<
div
>
089.
</
div
>
090.
</
div
>
091.
<
div
id
=
"S3#"
class
=
"tab-content"
>
092.
<
div
>
093.
</
div
>
094.
</
div
>
095.
<
div
id
=
"R#"
class
=
"tab-content"
>
096.
<
div
>
097.
</
div
>
098.
</
div
>
099.
</
div
>
100.
</
ContentTemplate
>
101.
</
asp:UpdatePanel
>
102.
</
telerik:RadPane
>
103.
</
telerik:RadSplitter
>