or
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="RMAGenerator.aspx.cs" Inherits="ECSMT.RMAGenerator" %>
<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<
html
xmlns
=
"http://www.w3.org/1999/xhtml"
>
<
head
runat
=
"server"
>
<
title
>JDE RMA Grid Creation</
title
>
<
script
src
=
"/Scripts/modernizr-2.0.6.min.js"
type
=
"text/javascript"
> </
script
>
<
style
>
section
{
background: #cfdbe6;
margin: 20px;
padding: 5px;
border-radius: 10px;
box-shadow: 4px 4px 10px rgba(0, 0, 0, 0.5);
background: cfdbe6;
width: 95%;
color: #696969;
font-size: 12px;
}
section h1 {font-size: 16px; font-weight: bold; color:Navy }
section h2 {font-size: 12px; font-weight: bold; text-decoration: underline}
.MyImageButton
{
cursor: hand;
}
.EditFormHeader td
{
font-size: 14px;
padding: 4px !important;
color: #0066cc;
}
</
style
>
</
head
>
<
body
>
<
form
id
=
"form1"
runat
=
"server"
>
<
telerik:RadScriptManager
ID
=
"RadScriptManager1"
runat
=
"server"
>
</
telerik:RadScriptManager
>
<
telerik:RadAjaxManager
ID
=
"RadAjaxManager1"
runat
=
"server"
>
<
AjaxSettings
>
<
telerik:AjaxSetting
AjaxControlID
=
"rgrdRMA"
>
<
UpdatedControls
>
<
telerik:AjaxUpdatedControl
ControlID
=
"rgrdRMA"
LoadingPanelID
=
"RadAjaxLoadingPanel1"
/>
</
UpdatedControls
>
</
telerik:AjaxSetting
>
<
telerik:AjaxSetting
AjaxControlID
=
"rbtnAppend"
>
<
UpdatedControls
>
<
telerik:AjaxUpdatedControl
ControlID
=
"rbtnAppend"
></
telerik:AjaxUpdatedControl
>
<
telerik:AjaxUpdatedControl
ControlID
=
"rgrdRMA"
LoadingPanelID
=
"RadAjaxLoadingPanel1"
></
telerik:AjaxUpdatedControl
>
</
UpdatedControls
>
</
telerik:AjaxSetting
>
<%-- <
telerik:AjaxSetting
AjaxControlID
=
"rbtnExport"
>
<
UpdatedControls
>
<
telerik:AjaxUpdatedControl
ControlID
=
"rbtnExport"
></
telerik:AjaxUpdatedControl
>
<
telerik:AjaxUpdatedControl
ControlID
=
"rgrdExpXl"
LoadingPanelID
=
"RadAjaxLoadingPanel1"
></
telerik:AjaxUpdatedControl
>
</
UpdatedControls
>
</
telerik:AjaxSetting
>--%>
</
AjaxSettings
>
</
telerik:RadAjaxManager
>
<
telerik:RadAjaxLoadingPanel
ID
=
"RadAjaxLoadingPanel1"
runat
=
"server"
Skin
=
"Default"
Width
=
"100%"
Height
=
"100%"
>
</
telerik:RadAjaxLoadingPanel
>
<
h3
>RMA Generator</
h3
>
<
h1
>CEI:<
asp:Label
ID
=
"lblCEI"
runat
=
"server"
Text
=
"0"
></
asp:Label
>
CMT:<
asp:Label
ID
=
"lblCMT"
runat
=
"server"
Text
=
"0"
></
asp:Label
></
h1
>
<
h3
><
asp:Label
ID
=
"lblCustInfo"
runat
=
"server"
Text
=
"Customer Information"
></
asp:Label
></
h3
>
<
telerik:RadGrid
ID
=
"rgrdRMA"
runat
=
"server"
GridLines
=
"Both"
Skin
=
"Windows7"
AllowPaging
=
"False"
AllowSorting
=
"false"
AutoGenerateColumns
=
"False"
OnNeedDataSource
=
"rgrdRMA_NeedDataSource"
OnUpdateCommand
=
"rgrdRMA_UpdateCommand"
OnInsertCommand
=
"rgrdRMA_InsertCommand"
OnDeleteCommand
=
"rgrdRMA_DeleteCommand"
ShowStatusBar
=
"true"
>
<
MasterTableView
Width
=
"100%"
CommandItemDisplay
=
"Top"
DataKeyNames
=
"RowNumber"
AutoGenerateColumns
=
"False"
EditMode
=
"InPlace"
>
<
Columns
>
<
telerik:GridEditCommandColumn
UniqueName
=
"EditCommandColumn"
>
</
telerik:GridEditCommandColumn
>
<
telerik:GridDropDownColumn
DataField
=
"LastDispo"
DataSourceID
=
"SqlDataSource1"
HeaderText
=
"LastDispo"
ListTextField
=
"DescOne"
ListValueField
=
"LastDispo"
UniqueName
=
"LastDispo"
>
</
telerik:GridDropDownColumn
>
<
telerik:GridDropDownColumn
DataField
=
"LITM"
DataSourceID
=
"SqlDataSource2"
HeaderText
=
"LITM"
ListTextField
=
"DSC"
ListValueField
=
"LITM"
UniqueName
=
"LITM"
>
</
telerik:GridDropDownColumn
>
<
telerik:GridNumericColumn
UniqueName
=
"ReturnQty"
SortExpression
=
"ReturnQty"
HeaderText
=
"ReturnQty"
DataField
=
"ReturnQty"
/>
<
telerik:GridDropDownColumn
DataField
=
"ReturnEquipNum"
DataSourceID
=
"EquipmentForReceipt"
HeaderText
=
"ReturnEquipNum"
ListTextField
=
"BigDescrip"
ListValueField
=
"ReturnEquipNum"
UniqueName
=
"ReturnEquipNum"
>
</
telerik:GridDropDownColumn
>
<
telerik:GridBoundColumn
UniqueName
=
"ReturnSerialNum"
SortExpression
=
"ReturnSerialNum"
HeaderText
=
"ReturnSerialNum"
DataField
=
"ReturnSerialNum"
ReadOnly
=
"true"
/>
<
telerik:GridBoundColumn
UniqueName
=
"IncomingLocCode"
SortExpression
=
"IncomingLocCode"
HeaderText
=
"IncomingLocCode"
DataField
=
"IncomingLocCode"
/>
<
telerik:GridDropDownColumn
DataField
=
"ShipToAddr"
DataSourceID
=
"ShipTosFilteredByCMT"
HeaderText
=
"ShipToAddr"
ListTextField
=
"ShipToAddr"
ListValueField
=
"ShipToAddr"
UniqueName
=
"ShipToAddr"
>
</
telerik:GridDropDownColumn
>
<
telerik:GridNumericColumn
UniqueName
=
"ReplacementQty"
SortExpression
=
"ReplacementQty"
HeaderText
=
"ReplacementQty"
DataField
=
"ReplacementQty"
/>
<
telerik:GridNumericColumn
UniqueName
=
"ReplacementEquipID"
SortExpression
=
"ReplacementEquipID"
HeaderText
=
"ReplacementEquipID"
DataField
=
"ReplacementEquipID"
/>
<
telerik:GridBoundColumn
UniqueName
=
"OutgoingLocCode"
SortExpression
=
"OutgoingLocCode"
HeaderText
=
"OutgoingLocCode"
DataField
=
"OutgoingLocCode"
/>
<
telerik:GridBoundColumn
UniqueName
=
"RequestedShipDate"
SortExpression
=
"RequestedShipDate"
HeaderText
=
"RequestedShipDate"
DataField
=
"RequestedShipDate"
ReadOnly
=
"true"
/>
<
telerik:GridButtonColumn
UniqueName
=
"DeleteColumn"
CommandName
=
"Delete"
ButtonType
=
"LinkButton"
Text
=
"Delete"
/>
</
Columns
>
</
MasterTableView
>
</
telerik:RadGrid
>
<
asp:Table
ID
=
"tblControls"
runat
=
"server"
Width
=
"100%"
>
<
asp:TableRow
Width
=
"100%"
>
<
asp:TableCell
Width
=
"20%"
HorizontalAlign
=
"Right"
>
<
h1
>Append RMA Product For</
h1
>
</
asp:TableCell
>
<
asp:TableCell
Width
=
"30%"
HorizontalAlign
=
"Right"
>
<
telerik:RadComboBox
ID
=
"rcmbProduct"
Runat
=
"server"
Width
=
"100%"
AutoPostBack
=
"true"
></
telerik:RadComboBox
>
</
asp:TableCell
>
<
asp:TableCell
Width
=
"10%"
HorizontalAlign
=
"Left"
>
<
telerik:RadButton
ID
=
"rbtnAppend"
runat
=
"server"
Text
=
"Append"
OnClick
=
"rbtnAppend_Click"
AutoPostBack
=
"true"
></
telerik:RadButton
>
</
asp:TableCell
>
<
asp:TableCell
Width
=
"40%"
HorizontalAlign
=
"Justify"
>
<
telerik:RadButton
ID
=
"rbtnExport"
runat
=
"server"
Text
=
"Export"
OnClick
=
"rbtnExport_Click"
AutoPostBack
=
"true"
></
telerik:RadButton
>
</
asp:TableCell
>
</
asp:TableRow
>
<
asp:TableRow
>
<
asp:TableCell
Width
=
"20%"
HorizontalAlign
=
"Center"
>
<
asp:Label
ID
=
"lblCurPC"
Text
=
"Current PC:"
runat
=
"server"
></
asp:Label
>
</
asp:TableCell
>
<
asp:TableCell
Width
=
"20%"
HorizontalAlign
=
"Center"
>
<
asp:Label
ID
=
"lblCurPCType"
Text
=
"Current PC Type:"
runat
=
"server"
></
asp:Label
>
</
asp:TableCell
>
<
asp:TableCell
Width
=
"20%"
HorizontalAlign
=
"Center"
>
<
asp:Label
ID
=
"lblCurScreenSKU"
Text
=
"Current Screen SKU :"
runat
=
"server"
></
asp:Label
>
</
asp:TableCell
>
<
asp:TableCell
Width
=
"40%"
HorizontalAlign
=
"Center"
>
</
asp:TableCell
>
</
asp:TableRow
>
</
asp:Table
>
<
telerik:RadGrid
ID
=
"rgrdExpXl"
runat
=
"server"
GridLines
=
"Both"
Skin
=
"Windows7"
AllowPaging
=
"False"
AutoGenerateColumns
=
"False"
OnNeedDataSource
=
"rgrdExpXl_NeedDataSource"
>
<
MasterTableView
Width
=
"100%"
AutoGenerateColumns
=
"False"
>
<
Columns
>
<
telerik:GridBoundColumn
DataField
=
"LastDispo"
HeaderText
=
""
UniqueName
=
"LastDispo"
/>
<
telerik:GridBoundColumn
DataField
=
"LITM"
HeaderText
=
""
UniqueName
=
"LITM"
/>
<
telerik:GridNumericColumn
UniqueName
=
"ReturnQty"
HeaderText
=
""
DataField
=
"ReturnQty"
/>
<
telerik:GridBoundColumn
DataField
=
"ReturnEquipNum"
HeaderText
=
""
UniqueName
=
"ReturnEquipNum"
/>
<
telerik:GridBoundColumn
UniqueName
=
"ReturnSerialNum"
HeaderText
=
""
DataField
=
"ReturnSerialNum"
/>
<
telerik:GridBoundColumn
UniqueName
=
"RequestedShipDate"
HeaderText
=
""
DataField
=
"RequestedShipDate"
/>
<
telerik:GridBoundColumn
DataField
=
"LITM"
HeaderText
=
""
UniqueName
=
"LITM2"
/>
<
telerik:GridBoundColumn
DataField
=
"ShipToAddr"
HeaderText
=
""
UniqueName
=
"ShipToAddr"
/>
<
telerik:GridNumericColumn
UniqueName
=
"ReplacementEquipID"
HeaderText
=
""
DataField
=
"ReplacementEquipID"
/>
<
telerik:GridNumericColumn
UniqueName
=
"ReplacementQty"
HeaderText
=
""
DataField
=
"ReplacementQty"
/>
<
telerik:GridNumericColumn
UniqueName
=
"ReturnQty2"
HeaderText
=
""
DataField
=
"ReturnQty"
/>
<
telerik:GridNumericColumn
UniqueName
=
"LineNumber"
HeaderText
=
""
DataField
=
"LineNumber"
/>
<
telerik:GridBoundColumn
UniqueName
=
"IncomingLocCode"
HeaderText
=
""
DataField
=
"IncomingLocCode"
/>
<
telerik:GridBoundColumn
UniqueName
=
"OutgoingLocCode"
HeaderText
=
""
DataField
=
"OutgoingLocCode"
/>
</
Columns
>
</
MasterTableView
>
</
telerik:RadGrid
>
<
asp:SqlDataSource
ID
=
"SqlDataSource1"
runat
=
"server"
ConnectionString="<%$ ConnectionStrings:JDECommon %>"
ProviderName="System.Data.SqlClient" SelectCommand="uspGetLastDispoForRMAGrid">
</
asp:SqlDataSource
>
<
asp:SqlDataSource
ID
=
"SqlDataSource2"
runat
=
"server"
ConnectionString="<%$ ConnectionStrings:JDECommon %>"
ProviderName="System.Data.SqlClient" SelectCommand="uspGetRMASKUS">
</
asp:SqlDataSource
>
<
asp:SqlDataSource
ID
=
"ShipTosFilteredByCMT"
runat
=
"server"
ConnectionString="<%$ ConnectionStrings:JDECommon %>"
SelectCommand= "uspGetRMAShipTos @CMT">
<
SelectParameters
>
<
asp:ControlParameter
ControlID
=
"lblCMT"
Name
=
"CMT"
PropertyName
=
"Text"
/>
</
SelectParameters
>
</
asp:SqlDataSource
>
<
asp:SqlDataSource
ID
=
"EquipmentForReceipt"
runat
=
"server"
ConnectionString="<%$ ConnectionStrings:JDECommon %>"
SelectCommand= "uspGetRMAOutboundEquipmentForCEI @CEI ">
<
SelectParameters
>
<
asp:ControlParameter
ControlID
=
"lblCEI"
Name
=
"CEI"
PropertyName
=
"Text"
/>
</
SelectParameters
>
</
asp:SqlDataSource
>
</
form
>
</
body
>
<
script
type
=
"text/javascript"
>
Modernizr.load([{
complete: function ()
{
if (!window.jQuery)
{
Modernizr.load('/Scripts/jquery-1.6.1.min.js');
}
}
},
{
test: Modernizr.borderradius || Modernizr.boxshadow,
nope: '/Scripts/PIE.js',
callback: function ()
{
$('section').each(function ()
{
PIE.attach(this);
});
}
}]);
</
script
>
</
html
>
<
telerik:RadAjaxPanel
ID
=
"RadAjaxPanel1"
runat
=
"server"
Height
=
"400px"
Width
=
"990px"
>
<
telerik:RadGrid
ID
=
"DataGrid"
runat
=
"server"
OnDeleteCommand
=
"DataGrid_DeleteCommand"
OnNeedDataSource
=
"DataGrid_NeedDataSource"
OnUpdateCommand
=
"DataGrid_UpdateCommand"
AllowPaging
=
"True"
AllowSorting
=
"True"
PageSize
=
"20"
GridLines
=
"Horizontal"
ShowFooter
=
"True"
ShowStatusBar
=
"True"
Width
=
"100%"
CellSpacing
=
"0"
AutoGenerateColumns
=
"False"
onitemcommand
=
"DataGrid_ItemCommand"
>
<
MasterTableView
DataKeyNames
=
"id"
>
</
MasterTableView
>
</
telerik:RadGrid
>
</
telerik:RadAjaxPanel
>
DataTable dtFields = DataManager.Instance.GetGridData(0, 1,
this
.module.DataObject,
this
.module.DataSource);
foreach
(DataColumn dc
in
dtFields.Columns)
{
if
(dc.ColumnName ==
"id"
)
continue
;
GridBoundColumn gbc =
new
GridBoundColumn();
gbc.HeaderText = dc.ColumnName;
gbc.DataField = dc.ColumnName;
this
.DataGrid.MasterTableView.Columns.Add(gbc);
}
GridEditCommandColumn gecc =
new
GridEditCommandColumn();
gecc.ButtonType = GridButtonColumnType.ImageButton;
gecc.EditImageUrl =
"~/Images/Icons/87._16x16.png"
;
this
.DataGrid.MasterTableView.Columns.Add(gecc);
GridButtonColumn gbc =
new
GridButtonColumn();
gbc.ButtonType = GridButtonColumnType.ImageButton;
gbc.ImageUrl =
"~/Images/Icons/7._16x16.png"
;
gbc.CommandName =
"Delete"
;
gbc.ConfirmText =
"Weet u zeker dat u dit item wilt verwijderen?"
;
gbc.ConfirmDialogType = GridConfirmDialogType.RadWindow;
gbc.ConfirmTitle =
"Verwijderen"
;
this
.DataGrid.MasterTableView.Columns.Add(gbc);
<%@ Page Title="" Language="C#" AutoEventWireup="true" CodeBehind="Test_RadComboBox.aspx.cs" Inherits="KR.IQ.Test_RadComboBox" %>
<%@ Register TagPrefix="telerik" Namespace="Telerik.Web.UI" Assembly="Telerik.Web.UI" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<
html
xmlns
=
"http://www.w3.org/1999/xhtml"
>
<
head
id
=
"Head1"
runat
=
"server"
>
<
title
>Page Title</
title
>
</
head
>
<
body
style
=
"margin:0 auto;width:1000px;position:relative;"
>
<!-- Provide the layout for all pages -->
<
form
id
=
"form1"
runat
=
"server"
>
<
ajax:ToolkitScriptManager
ID
=
"ScriptManager"
runat
=
"server"
EnablePartialRendering
=
"true"
CombineScripts
=
"false"
></
ajax:ToolkitScriptManager
>
<
telerik:RadAjaxManager
ID
=
"RadAjaxManager1"
runat
=
"server"
DefaultLoadingPanelID
=
"LoadingPanel1"
/>
<
script
type
=
"text/javascript"
>
Sys.WebForms.PageRequestManager.getInstance().add_beginRequest(beginRequest);
Sys.WebForms.PageRequestManager.getInstance().add_pageLoaded(pageLoaded);
</
script
>
<
div
id
=
"container"
>
<
div
id
=
"mainBody"
>
<
telerik:RadAjaxLoadingPanel
ID
=
"LoadingPanel1"
runat
=
"server"
EnableSkinTransparency
=
"false"
>
<
div
class
=
"ajaxLoadingDiv"
style
=
"width:200px;height:100px;background-color:white;position:absolute; border:1px solid #3AB2E6;"
>
<
br
/>
<
center
><
img
src
=
"/Images/Global/Ajax/ajax-loader.gif"
alt
=
"loading"
/>
<
br
/>
<
asp:Label
runat
=
"server"
Text
=
"Loading..."
ID
=
"lblProgressTemplateRAD"
></
asp:Label
>
</
center
>
</
div
>
</
telerik:RadAjaxLoadingPanel
>
<
div
id
=
"fi"
>
<
telerik:RadComboBox
ID
=
"radComboBoxFIFilter"
runat
=
"server"
Width
=
"200px"
AppendDataBoundItems
=
"true"
CssClass
=
"floatRight"
>
<
Items
>
<
telerik:RadComboBoxItem
Text
=
"SHOW ALL"
Value
=
"ALL"
/>
</
Items
>
</
telerik:RadComboBox
>
</
div
>
</
div
>
</
div
>
</
form
>
</
body
>
</
html
>
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
namespace KR.IQ
{
public partial class Test_RadComboBox : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
FillRadComboBox();
}
/// <
summary
>
/// Sets up the featured insights control with the filter, default content types and homepage tag
/// </
summary
>
private void FillRadComboBox()
{
List<
KeyValuePair
<string, string>> filterItemList = new List<
KeyValuePair
<string, string>>()
{
new KeyValuePair<
string
, string>("One", "1"),
new KeyValuePair<
string
, string>("Two", "2"),
new KeyValuePair<
string
, string>("Three", "3")
};
radComboBoxFIFilter.DataValueField = "key";
radComboBoxFIFilter.DataTextField = "value";
radComboBoxFIFilter.DataSource = filterItemList;
radComboBoxFIFilter.DataBind();
}
}
}
<
telerik:GridGroupByField
FieldName
=
"INFO_GAME"
FieldAlias
=
"Ā»"
HeaderValueSeparator
=
" "
> </
telerik:GridGroupByField
>