146 lines
6.0 KiB
Plaintext
146 lines
6.0 KiB
Plaintext
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="query.aspx.cs" Inherits="query" %>
|
|
|
|
<!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></title>
|
|
</head>
|
|
<body>
|
|
<form id="form1" runat="server" visible="True">
|
|
<div>
|
|
<table width="100%">
|
|
<tr>
|
|
<td width="550px">
|
|
<asp:Label ID="fileSQL" runat="server" Text="Nome del file sql Oracle (eliminare l'estensione del file.):"></asp:Label>
|
|
</td>
|
|
<td>
|
|
<asp:TextBox ID="txtFileSQL" runat="server" Width="80%"></asp:TextBox>
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td width="550px">
|
|
<asp:Label ID="storedSQL" runat="server" Text="Nome della stored procedure SqlServer: (solo stored con unico parametro 'chiaveclientepb')"></asp:Label>
|
|
</td>
|
|
<td>
|
|
<asp:TextBox ID="txtStoredSQL" runat="server" Width="80%"></asp:TextBox>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
</div>
|
|
<div>
|
|
<table>
|
|
<tr>
|
|
<td>
|
|
<asp:Label ID="cf" runat="server" Text="codice cliente"></asp:Label>
|
|
</td>
|
|
<td>
|
|
|
|
<asp:TextBox ID="txtCF" runat="server"></asp:TextBox>
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td>
|
|
<asp:Label ID="rete" runat="server" Text="codice rete"></asp:Label>
|
|
</td>
|
|
<td>
|
|
|
|
<asp:TextBox ID="txtRETE" runat="server"></asp:TextBox>
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td>
|
|
<asp:Label ID="pb" runat="server" Text="codice agente"></asp:Label>
|
|
</td>
|
|
<td>
|
|
|
|
<asp:TextBox ID="txtPB" runat="server"></asp:TextBox>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
</div>
|
|
<br />
|
|
<table>
|
|
<tr>
|
|
<td>
|
|
<asp:Button ID="EseguiOracle" runat="server" Text="Esegui query su Oracle" OnClick="Esegui_Click" />
|
|
</td>
|
|
<td>
|
|
<asp:Button ID="EseguiSql" runat="server" Text="Esegui query su SqlServer" OnClick="EseguiSql_Click" />
|
|
</td>
|
|
<td>
|
|
</td>
|
|
<td>
|
|
<asp:Button ID="Compara" runat="server" Text="Compara Oracle e SqlServer" OnClick="Compara_Click" />
|
|
<asp:Label ID="lblRisultatoComparazione" runat="server" Text="..."></asp:Label>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
<br />
|
|
<br />
|
|
<asp:Button ID="NoSession" runat="server" Text="Cancella Sessione del Cliente corrente (per Oracle)"
|
|
OnClick="NoSession_Click" />
|
|
|
|
<asp:Button ID="LanciaProceduraCaricamentoDati" runat="server" OnClick="LanciaProceduraCaricamentoDati_Click"
|
|
Text="Lancia procedura 'avvio_report' (per Oracle)" />
|
|
<div style="height: 40px; width: 100%;">
|
|
</div>
|
|
<div style="height: 20px; width: 100%; background-color: #C0C0C0;">
|
|
Risultati su Oracle
|
|
</div>
|
|
<asp:Label ID="tempoElaborazioneOracle" runat="server"></asp:Label>
|
|
<br />
|
|
<asp:GridView ID="grigliaOracle" runat="server" AllowSorting="True" OnSorting="griglia_Sorting"
|
|
CellPadding="4" ForeColor="#333333" GridLines="None">
|
|
<AlternatingRowStyle BackColor="White" />
|
|
<Columns>
|
|
<asp:CommandField ShowSelectButton="True" />
|
|
</Columns>
|
|
<EditRowStyle BackColor="#2461BF" />
|
|
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
|
|
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
|
|
<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
|
|
<RowStyle BackColor="#EFF3FB" />
|
|
<SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
|
|
<SortedAscendingCellStyle BackColor="#F5F7FB" />
|
|
<SortedAscendingHeaderStyle BackColor="#6D95E1" />
|
|
<SortedDescendingCellStyle BackColor="#E9EBEF" />
|
|
<SortedDescendingHeaderStyle BackColor="#4870BE" />
|
|
</asp:GridView>
|
|
<asp:Label ID="lblNoDatiOracle" runat="server" Text="Nessun record trovato!" Visible="False"></asp:Label>
|
|
<br />
|
|
<br />
|
|
<div style="height: 20px; width: 100%; background-color: #C0C0C0;">
|
|
Risultati su SqlServer
|
|
</div>
|
|
<asp:Label ID="tempoElaborazioneSqlServer" runat="server"></asp:Label>
|
|
<br />
|
|
<asp:GridView ID="grigliaSqlServer" runat="server" AllowSorting="True" OnSorting="griglia_Sorting"
|
|
CellPadding="4" ForeColor="#333333" GridLines="None">
|
|
<AlternatingRowStyle BackColor="White" />
|
|
<Columns>
|
|
<asp:CommandField ShowSelectButton="True" />
|
|
</Columns>
|
|
<EditRowStyle BackColor="#2461BF" />
|
|
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
|
|
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
|
|
<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
|
|
<RowStyle BackColor="#EFF3FB" />
|
|
<SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
|
|
<SortedAscendingCellStyle BackColor="#F5F7FB" />
|
|
<SortedAscendingHeaderStyle BackColor="#6D95E1" />
|
|
<SortedDescendingCellStyle BackColor="#E9EBEF" />
|
|
<SortedDescendingHeaderStyle BackColor="#4870BE" />
|
|
</asp:GridView>
|
|
<asp:Label ID="lblNoDatiSqlServer" runat="server" Text="Nessun record trovato!" Visible="False"></asp:Label>
|
|
<br />
|
|
<br />
|
|
<br />
|
|
<p>
|
|
<asp:Button ID="btnMigrazioneDettaglioASUL" runat="server" Text="Migra dettaglio ASUL da ORACLE a SQL"
|
|
OnClick="btnMigrazioneDettaglioASUL_Click" />
|
|
<asp:Label ID="esitoMigrazioneFettaglioASUL" runat="server"></asp:Label>
|
|
</p>
|
|
</form>
|
|
</body>
|
|
</html>
|