<%@ Page Title="" Language="C#" MasterPageFile="~/site.master" AutoEventWireup="true" CodeFile="BOLDetail.aspx.cs" Inherits="production_BOLDetail" %>
<
asp:Content
ID
=
"Content1"
ContentPlaceHolderID
=
"head"
Runat
=
"Server"
>
</
asp:Content
>
<
asp:Content
ID
=
"Content2"
ContentPlaceHolderID
=
"cpMainContent"
Runat
=
"Server"
>
<
asp:SqlDataSource
ID
=
"SqlBOLSummary"
runat
=
"server"
ConnectionString="<%$ ConnectionStrings:CLS-SVR08_INSDataFiles %>"
SelectCommand="
SELECT blh.BOLNumber,
(CAST(MAX(blh.RackID) as varchar(3))) + ' - ' + (CAST(MAX(blh.RackID) as varchar(3))) as RackRange,
(CAST(MIN(blh.FromProcessSequence) as varchar(11))) + ' - ' + (CAST(MAX(blh.ToProcessSequence) as varchar(11))) as SeqRange,
COUNT(blh.RackID)/22 AS Racks,
COUNT(bld.ProcessSequence)/4 AS VINs
FROM [INS Data Files].[dbo].[BOL Load Header] blh
INNER JOIN [INS Data Files]..[BOL Load Detail] bld
ON blh.LoadID=bld.LoadID
WHERE blh.BOLNumber = @BOLNumber
GROUP BY blh.BOLNumber">
<
SelectParameters
>
<
asp:QueryStringParameter
DefaultValue
=
"0"
Name
=
"BOLNumber"
QueryStringField
=
"bol"
Type
=
"Int32"
/>
</
SelectParameters
>
</
asp:SqlDataSource
>
<
asp:SqlDataSource
ID
=
"SqlBOLRacks"
runat
=
"server"
ConnectionString="<%$ ConnectionStrings:CLS-SVR08_INSDataFiles %>"
SelectCommand="
SELECT [BOLNumber], [LoadID], [RackID], [RackGroup], [FromProcessSequence], [ToProcessSequence]
FROM [BOL Load Header]
WHERE ([BOLNumber] = @BOLNumber)
ORDER BY [RackID], [RackGroup]">
<
SelectParameters
>
<
asp:QueryStringParameter
DefaultValue
=
"0"
Name
=
"BOLNumber"
QueryStringField
=
"bol"
Type
=
"Int32"
/>
</
SelectParameters
>
</
asp:SqlDataSource
>
<
asp:SqlDataSource
ID
=
"SqlBOLSlots"
runat
=
"server"
ConnectionString="<%$ ConnectionStrings:CLS-SVR08_INSDataFiles %>"
SelectCommand="
SELECT [LoadID], [RackID], [SlotPosition], [LoadSequence], [VINSequence]
FROM [Load Detail]
WHERE ([LoadID] = @LoadID)
ORDER BY [LoadSequence]">
<
SelectParameters
>
<
asp:Parameter
Name
=
"LoadID"
Type
=
"Int32"
/>
</
SelectParameters
>
</
asp:SqlDataSource
>
<
asp:SqlDataSource
ID
=
"SqlBOLPartDetail"
runat
=
"server"
ConnectionString="<%$ ConnectionStrings:CLS-SVR08_INSDataFiles %>"></
asp:SqlDataSource
>
<
p
>
<
div
id
=
"divTitle"
>BOL Detail</
div
>
</
p
>
<
p
>
<
telerik:RadGrid
ID
=
"rgBOLSummary"
runat
=
"server"
AutoGenerateColumns
=
"False"
CellSpacing
=
"0"
DataSourceID
=
"SqlBOLSummary"
GridLines
=
"None"
>
<
MasterTableView
DataKeyNames
=
"BOLNumber"
DataSourceID
=
"SqlBOLSummary"
>
<
CommandItemSettings
ExportToPdfText
=
"Export to PDF"
></
CommandItemSettings
>
<
RowIndicatorColumn
Visible
=
"True"
FilterControlAltText
=
"Filter RowIndicator column"
>
<
HeaderStyle
Width
=
"20px"
></
HeaderStyle
>
</
RowIndicatorColumn
>
<
ExpandCollapseColumn
Visible
=
"True"
FilterControlAltText
=
"Filter ExpandColumn column"
>
<
HeaderStyle
Width
=
"20px"
></
HeaderStyle
>
</
ExpandCollapseColumn
>
<
Columns
>
<
telerik:GridBoundColumn
DataField
=
"BOLNumber"
DataType
=
"System.Int32"
FilterControlAltText
=
"Filter BOLNumber column"
HeaderText
=
"BOL Number"
ReadOnly
=
"True"
SortExpression
=
"BOLNumber"
UniqueName
=
"BOLNumber"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"RackRange"
FilterControlAltText
=
"Filter RackRange column"
HeaderText
=
"Rack Range"
ReadOnly
=
"True"
SortExpression
=
"RackRange"
UniqueName
=
"RackRange"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"SeqRange"
FilterControlAltText
=
"Filter SeqRange column"
HeaderText
=
"Sequence Range"
ReadOnly
=
"True"
SortExpression
=
"SeqRange"
UniqueName
=
"SeqRange"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Racks"
DataType
=
"System.Int32"
FilterControlAltText
=
"Filter Racks column"
HeaderText
=
"Racks"
ReadOnly
=
"True"
SortExpression
=
"Racks"
UniqueName
=
"Racks"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"VINs"
DataType
=
"System.Int32"
FilterControlAltText
=
"Filter VINs column"
HeaderText
=
"VINs"
ReadOnly
=
"True"
SortExpression
=
"VINs"
UniqueName
=
"VINs"
>
</
telerik:GridBoundColumn
>
</
Columns
>
<
EditFormSettings
>
<
EditColumn
FilterControlAltText
=
"Filter EditCommandColumn column"
></
EditColumn
>
</
EditFormSettings
>
</
MasterTableView
>
<
FilterMenu
EnableImageSprites
=
"False"
></
FilterMenu
>
</
telerik:RadGrid
>
</
p
>
<
telerik:RadGrid
ID
=
"rgBOLRacks"
runat
=
"server"
AutoGenerateColumns
=
"False"
CellSpacing
=
"0"
DataSourceID
=
"SqlBOLRacks"
GridLines
=
"None"
Skin
=
"Telerik"
>
<
MasterTableView
DataSourceID
=
"SqlBOLRacks"
>
<
DetailTables
>
<
telerik:GridTableView
runat
=
"server"
DataKeyNames
=
"LoadID"
DataSourceID
=
"SqlBOLSlots"
Name
=
"SlotDetail"
>
<
ParentTableRelation
>
<
telerik:GridRelationFields
DetailKeyField
=
"LoadID"
MasterKeyField
=
"LoadID"
/>
</
ParentTableRelation
>
<
Columns
>
<
telerik:GridBoundColumn
DataField
=
"RackID"
DataType
=
"System.Int32"
FilterControlAltText
=
"Filter RackID column"
HeaderText
=
"RackID"
SortExpression
=
"RackID"
UniqueName
=
"RackID"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"SlotPosition"
FilterControlAltText
=
"Filter RackGroup column"
HeaderText
=
"Slot Position"
SortExpression
=
"SlotPosition"
UniqueName
=
"SlotPosition"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"LoadSequence"
FilterControlAltText
=
"Filter RackGroup column"
HeaderText
=
"Load Sequence"
SortExpression
=
"LoadSequence"
UniqueName
=
"LoadSequence"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"VINSequence"
FilterControlAltText
=
"Filter RackGroup column"
HeaderText
=
"VIN Sequence"
SortExpression
=
"VINSequence"
UniqueName
=
"VINSequence"
>
</
telerik:GridBoundColumn
>
</
Columns
>
</
telerik:GridTableView
>
</
DetailTables
>
<
Columns
>
<
telerik:GridBoundColumn
DataField
=
"RackID"
DataType
=
"System.Int32"
FilterControlAltText
=
"Filter RackID column"
HeaderText
=
"RackID"
SortExpression
=
"RackID"
UniqueName
=
"RackID"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"RackGroup"
FilterControlAltText
=
"Filter RackGroup column"
HeaderText
=
"RackGroup"
SortExpression
=
"RackGroup"
UniqueName
=
"RackGroup"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"FromProcessSequence"
FilterControlAltText
=
"Filter FromProcessSequence column"
HeaderText
=
"FromProcessSequence"
SortExpression
=
"FromProcessSequence"
UniqueName
=
"FromProcessSequence"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"ToProcessSequence"
FilterControlAltText
=
"Filter ToProcessSequence column"
HeaderText
=
"ToProcessSequence"
SortExpression
=
"ToProcessSequence"
UniqueName
=
"ToProcessSequence"
>
</
telerik:GridBoundColumn
>
</
Columns
>
<
EditFormSettings
>
<
EditColumn
FilterControlAltText
=
"Filter EditCommandColumn column"
></
EditColumn
>
</
EditFormSettings
>
</
MasterTableView
>
<
FilterMenu
EnableImageSprites
=
"False"
></
FilterMenu
>
</
telerik:RadGrid
>
</
asp:Content
>
> | Entity A | |||||||
EntityASpecialOmnibus.pdf | Generic | Robert Frost | 8/24/2010 8:24:34 AM | |||||
> | Fund 1 | |||||||
FundDetail.pdf | Generic | Arthur Cunningham | 7/16/2010 5:35:43 PM | |||||
GreatNeckIncidentals.txt | Generic | Arthur Cunningham | 7/16/2010 5:39:35 PM | |||||
testdoc.pdf | Doc | admin1 | 1/24/2011 12:34:43 PM | William Yeats | ||||
testdoc2.pdf | Doc | admin1 | 1/24/2011 12:34:43 PM | William Yeats | ||||
testdoc3.pdf | Doc | admin1 | 1/24/2011 12:34:43 PM | William Yeats | ||||
testdoc6.pdf | Doc | admin1 | 1/24/2011 12:34:43 PM | William Yeats | ||||
> | Fund 2 | |||||||
FederalAction.doc | Generic | Arthur Cunningham | 7/16/2010 5:35:43 PM | |||||
Statereturn.pdf | Tax | admin1 | 7/16/2010 5:39:35 PM | William Yeats | ||||
FederalReturn.pdf | Tax | admin1 | 1/24/2011 12:34:43 PM | William Yeats | ||||
OhioK1G.pdf | K-1G | admin1 | 1/24/2011 12:34:43 PM | William Yeats |
Now, I am seeing that Grid persister is not working properly when I am Hiding/Showing Grid columns from Client side.
I am using below C# code on Page load event to maintain Grid Settings.
if (Page.IsPostBack)
{
GridSettingsPersister SavePersister = new GridSettingsPersister(this.radGridItem);
Session["GridSetting"] = SavePersister.SaveSettings();
}
//Loading the Grid control with the saved persistence setting
if (Session["GridSetting"] != null)
{
GridSettingsPersister LoadPersister = new GridSettingsPersister(this.radGridItem);
string settings = (string)Session["GridSetting"];
LoadPersister.LoadSettings(settings);
}
Below are my grid settings:
<telerik:radgrid id="radGridItem" allowpaging="True" runat="server" allowmultirowselection="true"
autogeneratecolumns="False" pagesize="20" allowsorting="True" gridlines="Horizontal"
onitemcommand="RadGridItem_ItemCommand" onitemdatabound="RadGridItem_ItemDataBound"
onneeddatasource="RadGridItem_NeedDataSource" onprerender="RadGridItem_PreRender">
<pagerstyle mode="NextPrevAndNumeric" position="Bottom" alwaysvisible="true" pagesizelabeltext="Size:"
showpagertext="True" />
<mastertableview tablelayout="Fixed" width="100%" canretrievealldata="false" autogeneratecolumns="False"
retrievealldatafields="false" allowmulticolumnsorting="false">
<Columns>
</Columns>
</mastertableview>
<clientsettings>
<Selecting AllowRowSelect="True" EnableDragToSelectRows="false" />
<ClientEvents OnGridCreated="gridCreated" />
<Resizing AllowColumnResize="true" ClipCellContentOnResize="false" ResizeGridOnColumnResize="false"
EnableRealTimeResize="true" />
</clientsettings>
<groupingsettings casesensitive="false" />
</telerik:radgrid>
Please let me know if require any other details from my side.
Thanks in advance
Gaurav Jain
<
asp:LinqDataSource
ID
=
"ldsDList"
runat
=
"server"
<br> ContextTypeName="MDataContext" <
br
> EnableDelete="True" EnableInsert="True" EnableUpdate="True" EntityTypeName="" <
br
> TableName="DLists"><
br
> <
InsertParameters
><
br
> <
asp:ControlParameter
ControlID
=
"HFUser"
Name
=
"EnteredBy"
<br> PropertyName="Value" Type="Int32" /><
br
> <
asp:Parameter
Name
=
"DateEntered"
Type
=
"DateTime"
/><
br
> </
InsertParameters
><
br
> <
UpdateParameters
><
br
> <
asp:ControlParameter
ControlID
=
"HFUser"
Name
=
"ModifiedBy"
<br> PropertyName="Value" Type="Int32" DbType="Int32" /><
br
> <
asp:Parameter
Name
=
"DateModified"
Type
=
"DateTime"
/><
br
> </
UpdateParameters
><
br
> </
asp:LinqDataSource
>
Protected
Sub
ldsDList_ContextCreating(sender
As
Object
, e
As
System.Web.UI.WebControls.LinqDataSourceContextEventArgs)
Handles
ldsDList.ContextCreating<br>
If
e.Operation = DataSourceOperation.Insert
Then
<br>
Me
.ldsDList.InsertParameters(
"DateEntered"
).DefaultValue = DateTime.Now.ToString()<br>
ElseIf
e.Operation = DataSourceOperation.Update
Then
<br>
Me
.ldsDList.UpdateParameters(
"DateModified"
).DefaultValue = DateTime.Now.ToString()<br>
End
If
<br>
End
Sub
Dim tab2 As RibbonBarTab = RadRibbonBar1.FindTabByValue("Tab2")
Dim combobox1 As RadComboBox = DirectCast(tab2.Groups(0).Items(0).FindControl("RadComboBox1"), RadComboBox)
doesn't work, when the control is in a RibbonBarContextualTabGroup or RibbonBarControlGroup.
Thanks for any help!!!
Michael