or
| <telerik:GridTableView runat="server" AutoGenerateColumns="False" Caption="Elenco Dipendenti" |
| CommandItemDisplay="Bottom" DataKeyNames="DipendentiID" DataSourceID="SqlDipendentiSource" |
| AllowSorting="False" EditMode="PopUp" Name="DipendentiView" NoDetailRecordsText="Nessun dipendente per la sede corrente."> |
| <CommandItemSettings AddNewRecordText="Aggiungi Dipendente" ShowRefreshButton="False" /> |
| <Columns> |
| <telerik:GridButtonColumn ButtonType="ImageButton" UniqueName="DipendentiEditCommandColumn" |
| CommandName="Edit" HeaderStyle-Width="30px"> |
| <HeaderStyle Width="30px"></HeaderStyle> |
| <ItemStyle CssClass="MyImageButton" /> |
| </telerik:GridButtonColumn> |
| <telerik:GridButtonColumn ButtonType="ImageButton" UniqueName="DipendentiDeleteCommandColumn" |
| CommandName="Delete" HeaderStyle-Width="30px"> |
| <HeaderStyle Width="30px"></HeaderStyle> |
| <ItemStyle CssClass="MyImageButton" /> |
| </telerik:GridButtonColumn> |
| <telerik:GridBoundColumn DataField="DipendentiID" HeaderText="ID" SortExpression="DipendentiID" |
| UniqueName="DipendentiID" DataType="System.Int32" ReadOnly="True" HeaderStyle-Width="35px" |
| HeaderStyle-HorizontalAlign="Center" AllowFiltering="False"> |
| <HeaderStyle HorizontalAlign="Center" Width="35px"></HeaderStyle> |
| <ItemStyle HorizontalAlign="Center" /> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="Nome" HeaderText="Nome" UniqueName="Nome" DataType="System.String" |
| ReadOnly="True" HeaderStyle-HorizontalAlign="Center" AllowFiltering="True"> |
| <HeaderStyle HorizontalAlign="Center"></HeaderStyle> |
| <ItemStyle HorizontalAlign="Center" /> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="Cognome" HeaderText="Cognome" UniqueName="Cognome" |
| DataType="System.String" ReadOnly="True" HeaderStyle-HorizontalAlign="Center" |
| AllowFiltering="True"> |
| <HeaderStyle HorizontalAlign="Center"></HeaderStyle> |
| <ItemStyle HorizontalAlign="Center" /> |
| </telerik:GridBoundColumn> |
| <telerik:GridTemplateColumn UniqueName="Sesso" InitializeTemplatesFirst="false" HeaderStyle-HorizontalAlign="Center" |
| AllowFiltering="false"> |
| <HeaderTemplate> |
| Sesso |
| </HeaderTemplate> |
| <ItemTemplate> |
| <%# (((bool)Eval("Sesso")) ? "M" : "F") %> |
| </ItemTemplate> |
| <HeaderStyle HorizontalAlign="Center"></HeaderStyle> |
| </telerik:GridTemplateColumn> |
| <telerik:GridBoundColumn DataField="DataAssunzione" HeaderText="Data di Assunzione" |
| UniqueName="DataAssunzione" DataType="System.DateTime" ReadOnly="True" HeaderStyle-HorizontalAlign="Center" |
| AllowFiltering="True"> |
| <HeaderStyle HorizontalAlign="Center"></HeaderStyle> |
| <ItemStyle HorizontalAlign="Center" /> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="DataLicenziamento" HeaderText="Data di Licenziamento" |
| UniqueName="DataLicenziamento" DataType="System.DateTime" ReadOnly="True" HeaderStyle-HorizontalAlign="Center" |
| AllowFiltering="True"> |
| <HeaderStyle HorizontalAlign="Center"></HeaderStyle> |
| <ItemStyle HorizontalAlign="Center" /> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="Telefono" HeaderText="Telefono" UniqueName="Telefono" |
| DataType="System.String" ReadOnly="True" HeaderStyle-HorizontalAlign="Center" |
| AllowFiltering="False"> |
| <HeaderStyle HorizontalAlign="Center"></HeaderStyle> |
| <ItemStyle HorizontalAlign="Center" /> |
| </telerik:GridBoundColumn> |
| </Columns> |
| <RowIndicatorColumn> |
| <HeaderStyle Width="20px" /> |
| </RowIndicatorColumn> |
| <ExpandCollapseColumn> |
| <HeaderStyle Width="20px" /> |
| </ExpandCollapseColumn> |
| <ParentTableRelation> |
| <telerik:GridRelationFields DetailKeyField="SediID" MasterKeyField="SediID" /> |
| </ParentTableRelation> |
| <NestedViewSettings DataSourceID="SqlDipendentiExtendedSource"> |
| <ParentTableRelation> |
| <telerik:GridRelationFields DetailKeyField="DipendentiID" MasterKeyField="DipendentiID" /> |
| </ParentTableRelation> |
| </NestedViewSettings> |
| <NestedViewTemplate> |
| <asp:Panel ID="NestedViewDipendentiPanel" runat="server"> |
| <div> |
| <fieldset style="padding: 10px;"> |
| <legend style="padding: 5px;">Dettagli su: <b> |
| <%# Eval("Nome") %> |
| <%# Eval("Cognome") %></b></legend> |
| <table width="50%"> |
| <tr> |
| <td> |
| Nome: |
| </td> |
| <td> |
| <%# Eval("Nome") %> |
| </td> |
| </tr> |
| <tr> |
| <td> |
| Cognome: |
| </td> |
| <td> |
| <%# Eval("Cognome") %> |
| </td> |
| </tr> |
| <tr> |
| <td> |
| Sesso: |
| </td> |
| <td> |
| <%# (((bool)Eval("Sesso")) ? "Maschio" : "Femmina")%> |
| </td> |
| </tr> |
| <tr> |
| <td> |
| Telefono: |
| </td> |
| <td> |
| <%# Eval("Telefono")%> |
| </td> |
| </tr> |
| <tr> |
| <td> |
| Domicilio: |
| </td> |
| <td> |
| <%# Eval("Domicilio") %> |
| </td> |
| </tr> |
| <tr> |
| <td> |
| Residenza: |
| </td> |
| <td> |
| <%# Eval("Residenza") %> |
| </td> |
| </tr> |
| <tr> |
| <td> |
| Residenza: |
| </td> |
| <td> |
| <%# Eval("Nascita") %> |
| </td> |
| </tr> |
| <tr> |
| <td> |
| Data di Assunzione: |
| </td> |
| <td> |
| <%# Eval("DataAssunzione") %> |
| </td> |
| </tr> |
| <tr> |
| <td> |
| Data di Licenziamento: |
| </td> |
| <td> |
| <%# ((Eval("DataLicenziamento") is DBNull) ? "Nessuna" : Eval("DataLicenziamento")) %> |
| </td> |
| </tr> |
| </table> |
| </fieldset> |
| </div> |
| </asp:Panel> |
| </NestedViewTemplate> |
| <EditFormSettings EditFormType="Template"> |
| <FormTemplate> |
| </FormTemplate> |
| </EditFormSettings> |
| </telerik:GridTableView> |
| <asp:SqlDataSource ID="SqlDipendentiSource" runat="server" ConnectionString="<%$ ConnectionStrings:ReleaseConnection %>" |
| SelectCommand="SELECT ML.Dipendenti.id AS DipendentiID, ML.Dipendenti.Nome, ML.Dipendenti.Cognome, ML.Dipendenti.Sesso, ML.Dipendenti.DataAssunzione, ML.Dipendenti.DataLicenziamento, ML.Dipendenti.Telefono, LocalitaPaesi.Via + ' ' + LocalitaPaesi.Numero + ', ' + LocalitaPaesi.NomeComune + ' (' + LocalitaPaesi.ProvinciaSigla + ') ' + LocalitaPaesi.PaeseSigla AS Residenza FROM ML.Dipendenti INNER JOIN LocalitaPaesi ON ML.Dipendenti.LuogoResidenza = LocalitaPaesi.id WHERE (ML.Dipendenti.Sede = @SediID)"> |
| <SelectParameters> |
| <asp:Parameter Name="SediID" Type="Int32" /> |
| </SelectParameters> |
| </asp:SqlDataSource> |
| <asp:SqlDataSource ID="SqlDipendentiExtendedSource" runat="server" ConnectionString="<%$ ConnectionStrings:ReleaseConnection %>" |
| SelectCommand="SELECT ML.Dipendenti.id AS DipendentiID, ML.Dipendenti.Nome, ML.Dipendenti.Cognome, ML.Dipendenti.Sesso, ML.Dipendenti.DataAssunzione, ML.Dipendenti.DataLicenziamento, ML.Dipendenti.DataNascita, ML.Dipendenti.Telefono, LocalitaPaesiDomicilio.Via + ' ' + LocalitaPaesiDomicilio.Numero + ', ' + LocalitaPaesiDomicilio.NomeComune + ' (' + LocalitaPaesiDomicilio.ProvinciaSigla + ') ' + LocalitaPaesiDomicilio.PaeseSigla AS Domicilio, LocalitaPaesiLuogoResidenza.Via + ' ' + LocalitaPaesiLuogoResidenza.Numero + ', ' + LocalitaPaesiLuogoResidenza.NomeComune + ' (' + LocalitaPaesiLuogoResidenza.ProvinciaSigla + ') ' + LocalitaPaesiLuogoResidenza.PaeseSigla AS Residenza, LocalitaPaesiLuogoNascita.Via + ' ' + LocalitaPaesiLuogoNascita.Numero + ', ' + LocalitaPaesiLuogoNascita.NomeComune + ' (' + LocalitaPaesiLuogoNascita.ProvinciaSigla + ') ' + LocalitaPaesiLuogoNascita.PaeseSigla AS Nascita, ML.Medici.Nome AS NomeMedico, ML.Medici.Cognome AS CognomeMedico, ML.Medici.Telefono AS TelefonoMedico, LocalitaMedico.Via + ' ' + LocalitaMedico.Numero + ', ' + LocalitaMedico.NomeComune + ' (' + LocalitaMedico.ProvinciaSigla + ') ' + LocalitaMedico.PaeseSigla AS LocalitaMedico FROM ML.Dipendenti INNER JOIN LocalitaPaesi AS LocalitaPaesiDomicilio ON ML.Dipendenti.LuogoResidenza = LocalitaPaesiDomicilio.id INNER JOIN LocalitaPaesi AS LocalitaPaesiLuogoNascita ON ML.Dipendenti.LuogoNascita = LocalitaPaesiLuogoNascita.id INNER JOIN LocalitaPaesi AS LocalitaPaesiLuogoResidenza ON ML.Dipendenti.LuogoResidenza = LocalitaPaesiLuogoResidenza.id INNER JOIN ML.TitoliStudio ON ML.Dipendenti.TitoloStudio = ML.TitoliStudio.id INNER JOIN ML.Medici ON ML.Dipendenti.Medico = ML.Medici.id INNER JOIN LocalitaPaesi AS LocalitaMedico ON ML.Medici.Locazione = LocalitaMedico.id WHERE (ML.Dipendenti.id = @DipendentiID)"> |
| <SelectParameters> |
| <asp:Parameter Name="DipendentiID" Type="Int32" /> |
| </SelectParameters> |
| </asp:SqlDataSource> |
| <telerik:RadGrid |
| ID="rdgCorrespondence" |
| runat="server" |
| AllowFilteringByColumn="True" |
| AllowPaging="True" |
| AllowSorting="True" |
| AutoGenerateColumns="False" |
| GridLines="None" |
| OnNeedDataSource="rdgCorrespondence_NeedDataSource" |
| OnDetailTableDataBind="rdgCorrespondence_DetailTableDataBind" |
| OnItemDataBound="rdgCorrespondence_ItemDataBound" |
| OnInsertCommand="rdgCorrespondence_InsertCommand" |
| OnUpdateCommand="rdgCorrespondence_UpdateCommand" |
| onitemcommand="rdgCorrespondence_ItemCommand"> |
| <MasterTableView |
| CommandItemDisplay="Top" |
| DataKeyNames="CorrespondenceID" |
| Name="Correspondences" |
| Width="100%" |
| HierarchyLoadMode="ServerBind"> |
| <CommandItemSettings |
| ShowExportToExcelButton="true" |
| /> |
| <EditFormSettings> |
| <EditColumn UniqueName="EditCommandColumn1"> |
| </EditColumn> |
| </EditFormSettings> |
| <HeaderStyle HorizontalAlign="Center" /> |
| <ExpandCollapseColumn Visible="True"> |
| </ExpandCollapseColumn> |
| <Columns> |
| <telerik:GridEditCommandColumn ButtonType="ImageButton"> |
| </telerik:GridEditCommandColumn> |
| <telerik:GridBoundColumn DataField="CorrespondenceID" HeaderText="ID" UniqueName="CorrespondenceID" |
| ReadOnly="true" FilterControlWidth="20" ItemStyle-Width="25" ItemStyle-HorizontalAlign="Right" ForceExtractValue="Always"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn UniqueName="TypeName" HeaderText="Type" DataField="TypeName"> |
| </telerik:GridBoundColumn> |
| </Columns> |
| <DetailTables> |
| <telerik:GridTableView |
| DataKeyNames="CorrespondenceNoteID" |
| CommandItemDisplay="Top" |
| Name="CorrespondenceNotes" |
| Width="100%" |
| AllowFilteringByColumn="false" |
| BorderColor="#fff" |
| HierarchyLoadMode="Client"> |
| <ParentTableRelation> |
| <telerik:GridRelationFields DetailKeyField="CorrespondenceID" MasterKeyField="CorrespondenceID" /> |
| </ParentTableRelation> |
| <Columns> |
| <telerik:GridEditCommandColumn ButtonType="ImageButton"> |
| </telerik:GridEditCommandColumn> |
| <telerik:GridBoundColumn DataField="CorrespondenceNoteID" HeaderText="Note ID" UniqueName="CorrespondenceNoteID" |
| ReadOnly="true"> |
| </telerik:GridBoundColumn> |
| <telerik:GridDateTimeColumn DataField="DateOfNote" HeaderText="Date" UniqueName="DateOfNote"> |
| </telerik:GridDateTimeColumn> |
| <telerik:GridBoundColumn DataField="Note" HeaderText="Comment" UniqueName="Note"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="CorrespondenceID" HeaderText="Correspondence ID" |
| UniqueName="CorrespondenceID" ReadOnly="true" Display="false"> |
| </telerik:GridBoundColumn> |
| </Columns> |
| <SortExpressions> |
| <telerik:GridSortExpression FieldName="DateOfNote" SortOrder="Descending" /> |
| </SortExpressions> |
| </telerik:GridTableView> |
| </DetailTables> |
| </MasterTableView> |
| </telerik:RadGrid> |
| protected void rdgCorrespondence_ItemCommand(object source, GridCommandEventArgs e) |
| { |
| string fileName = "Correspondences"; |
| if (e.CommandName = RadGrid.ExportToExcelCommandName) |
| { |
| grid.ExportSettings.FileName = fileName; |
| grid.ExportSettings.HideStructureColumns = true; |
| grid.ExportSettings.IgnorePaging = true; |
| grid.ExportSettings.OpenInNewWindow = true; |
| grid.ExportSettings.ExportOnlyData = true; |
| grid.MasterTableView.ExportToExcel(); |
| } |
| } |
| function CloseAndRebind(age) { |
| GetRadWindow().BrowserWindow.refreshGrid(age); |
| GetRadWindow().Close(); |
| } |

| <telerik:RadGrid ID="gvCktMap" BorderColor="White" runat="server" AutoGenerateColumns="true" |
| AllowSorting="true" BackColor="White" AllowPaging="true" PageSize="25" GridLines="None" |
| OnPageIndexChanging="gvCktMap_PageIndexChanging" OnRowCancelingEdit="gvCktMap_RowCancelingEdit" |
| OnRowCommand="gvCktMap_RowCommand" OnRowUpdating="gvCktMap_RowUpdating" OnRowDataBound="gvCktMap_RowDataBound" |
| OnSorting="gvCktMap_Sorting" OnRowEditing="gvCktMap_RowEditing" ShowGroupPanel="True" |
| EnableHeaderContextMenu="true" EnableHeaderContextFilterMenu="true" AllowMultiRowSelection="true" |
| AllowFilteringByColumn="True" AllowCustomPaging="false" OnItemCreated="gvCktMap_ItemCreated" |
| EnableViewState="false" OnNeedDataSource="gvCktMap_NeedDataSource" OnItemUpdated="gvCktMap_ItemUpdated" |
| > |
| <MasterTableView DataKeyNames="sId" UseAllDataFields="true"> |
| <Columns> |
| <telerik:GridBoundColumn UniqueName="sId" HeaderText="sId" DataField="sId" Visible="false"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn UniqueName="orderId" HeaderText="orderId" DataField="orderId"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn UniqueName="REJ" HeaderText="REJ" DataField="REJ"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn UniqueName="Desc" HeaderText="Desc" DataField="Desc"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn UniqueName="CustomerName" HeaderText="CustomerName" DataField="CustomerName"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn UniqueName="MarketName" HeaderText="MarketName" DataField="MarketName"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn UniqueName="HeadendName" HeaderText="HeadendName" DataField="HeadendName"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn UniqueName="SiteName" HeaderText="SiteName" DataField="SiteName"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn UniqueName="TaskStatus" HeaderText="TaskStatus" DataField="TaskStatus"> |
| </telerik:GridBoundColumn> |
| </Columns> </mastertableview> |
| </telerik:RadGrid> |
| private void bingGrid() |
| { |
| try |
| { |
| gvCktMap.Columns.Clear(); |
| DataSet dsResult = new DataSet(); |
| DataSet dsEditItems = new DataSet(); |
| dsEditItems.ReadXml(Server.MapPath("XMLS/" + Session["TaskID"].ToString() + ".xml")); |
| clsSearch_BL clsObj = new clsSearch_BL(); |
| clsObj.TaskID = (string)Session["TaskID"]; |
| clsObj.CustName = (string)Session["CustName"]; |
| clsObj.MarketName = (string)Session["MarketName"]; |
| clsObj.HeadendName = (string)Session["HeadendName"]; |
| clsObj.SiteName = (string)Session["SiteName"]; |
| clsObj.TaskStatus = (string)Session["TaskStatus"]; |
| clsObj.OrdType = (string)Session["OrdType"]; |
| clsObj.OrdStatus = (string)Session["OrdStatus"]; |
| clsObj.ProName = (string)Session["ProName"]; |
| clsObj.LOC = (string)Session["LOC"]; |
| dsResult = clsObj.getSearchResults_BL(clsObj); |
| Session["SearchRes"] = dsResult; |
| DataTable dtFilter = new DataTable(); |
| DataColumn dtCol = new DataColumn("FilterBy"); |
| dtFilter.Columns.Add(dtCol); |
| dtCol = new DataColumn("DataType"); |
| dtFilter.Columns.Add(dtCol); |
| gvCktMap.DataSource = dsResult; |
| gvCktMap.DataBind(); |
| } |
| catch (Exception ex) |
| { |
| } |
| } |
EnableEmbeddedBaseStylesheet
="true"
| <telerik:radtabstrip ID="RadTabStripbooks" runat="server" MultiPageID="RadMultiPagebooks" |
| SelectedIndex="0" dir="rtl" Skin="" > |
| <Tabs> |
| <telerik:RadTab Text=" " CssClass="tabStrip1" PageViewID="RadPageView1b"> |
| </telerik:RadTab> |
| <telerik:RadTab Text=" " CssClass="tabStrip2" PageViewID="RadPageView2b" > |
| </telerik:RadTab> |
| </Tabs> |
| </telerik:radtabstrip> |
| <telerik:RadMultiPage ID="RadMultiPagebooks" runat="server" SelectedIndex="0" dir="rtl" Width="100%" EnableEmbeddedBaseStylesheet="true" > |
| <telerik:RadPageView ID="RadPageView1b" runat="server" BackColor="#a6ce39" > |
| <div style="width:100%;"> |
| <telerik:RadRotator ID="RadRotator1" runat="server" Height="190px" width="100%" BackColor="#a6ce39" RotatorType="ButtonsOver" ItemHeight="100px" ItemWidth="165px" DataSourceID="XmlDataSource1" Skin="Windows7" EnableEmbeddedBaseStylesheet="true" > |
| <ItemTemplate> |
| <div class="itemTemplate"> |
| SOME CODE...... |
| </div> |
| </ItemTemplate> |
| </telerik:RadRotator> |
| </div> |
| </telerik:RadPageView> |
| <telerik:RadPageView ID="RadPageView2b" runat="server" BackColor="#526b75" > |
| <div style="width:100%;"> |
| <telerik:RadRotator ID="RadRotator2b" runat="server" Height="190px" width="100%" BackColor="#526b75" |
| RotatorType="ButtonsOver" ItemHeight="100px" ItemWidth="165px" DataSourceID="XmlDataSource2" Skin="Windows7" EnableEmbeddedBaseStylesheet="true" > |
| <ItemTemplate> |
| <div class="itemTemplate"> |
| SOME CODE...... |
| </div> |
| </ItemTemplate> |
| </telerik:RadRotator> |
| </div> |
| </telerik:RadPageView> |
| </telerik:RadMultiPage> |