1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69
|
<p class="corps">
<asp:GridView ID="gvContrat" OnRowCreated="gvContrat_OnRowCreated" OnRowCommand="gvContrat_OnRowCommand" runat="server" DataKeyNames="N_COD_NUMCONTRAT" AutoGenerateColumns="False" DataSourceID="SqlDataSourceAll" style="background-color: transparent; text-align: center; clear: both; table-layout: fixed; display: block; font-weight: normal; float: none; background-image: none; page-break-before: auto; page-break-after: auto; overflow: scroll; cursor: auto; color: black; line-height: normal; font-style: normal; letter-spacing: normal; border-collapse: collapse; font-variant: normal; text-decoration: none; border-right: #000033 thin solid; border-top: #000033 thin solid; border-left: #000033 thin solid; border-bottom: #000033 thin solid; left: 50px; position: absolute;" CellPadding="4" ForeColor="#333333" GridLines="None">
<Columns>
<asp:BoundField DataField="N_COD_NUMCONTRAT" HeaderText="N_COD_NUMCONTRAT" ReadOnly="True"
SortExpression="N_COD_NUMCONTRAT">
<HeaderStyle Width="70px" />
</asp:BoundField>
<asp:BoundField DataField="N_COD_NUMCOFFRE" HeaderText="Numéro du coffre"
SortExpression="N_COD_NUMCOFFRE" >
<HeaderStyle Width="70px" />
</asp:BoundField>
<asp:BoundField DataField="N_COD_NUMDOS" HeaderText="Numéro du dos" SortExpression="N_COD_NUMDOS" >
<HeaderStyle Width="70px" />
</asp:BoundField>
<asp:BoundField DataField="S_LIB_DESIGNATION" HeaderText="Désignation" SortExpression="S_LIB_DESIGNATION" >
<HeaderStyle Width="130px" />
</asp:BoundField>
<asp:BoundField DataField="S_LIB_NOMCONTRACTANT" HeaderText="Contractant" SortExpression="S_LIB_NOMCONTRACTANT" >
<HeaderStyle Width="130px" />
</asp:BoundField>
<asp:BoundField DataField="S_LIB_INITIALESCONTRACTANT" HeaderText="Initiales" SortExpression="S_LIB_INITIALESCONTRACTANT" >
<HeaderStyle Width="50px" />
</asp:BoundField>
<asp:BoundField DataField="S_LIB_NOMDIRECTION" HeaderText="Direction" SortExpression="S_LIB_NOMDIRECTION" >
<HeaderStyle Width="150px" />
</asp:BoundField>
<asp:BoundField DataField="SIGNATURE" HeaderText="Signataire ou interlocuteur" SortExpression="SIGNATURE" >
<HeaderStyle Width="150px" />
</asp:BoundField>
<asp:BoundField DataField="S_DAT_SIGNATURE" HeaderText="Date de signature du contrat" SortExpression="S_DAT_SIGNATURE">
<HeaderStyle Width="100px" />
</asp:BoundField>
<asp:BoundField DataField="S_DAT_FIN" HeaderText="Date de fin" SortExpression="S_DAT_FIN">
<HeaderStyle Width="100px" />
</asp:BoundField>
<asp:BoundField DataField="S_DAT_RESIL" HeaderText="Date de Résiliation" SortExpression="S_DAT_RESIL" >
<HeaderStyle Width="100px" />
</asp:BoundField>
<asp:BoundField DataField="S_DAT_FINARCHI" HeaderText="Date de fin d'archivage" SortExpression="S_DAT_FINARCHI" >
<HeaderStyle Width="100px" />
</asp:BoundField>
<asp:CheckBoxField DataField="B_BOL_SCANNE" HeaderText="Scanné" SortExpression="B_BOL_SCANNE" >
<HeaderStyle Width="90px" />
</asp:CheckBoxField>
<asp:CheckBoxField DataField="B_BOL_RECOND" HeaderText="Reconductible" SortExpression="B_BOL_RECOND" >
<HeaderStyle Width="90px" />
</asp:CheckBoxField>
<asp:CheckBoxField DataField="B_BOL_RESILIE" HeaderText="Résilié" SortExpression="B_BOL_RESILIE" >
<HeaderStyle Width="90px" />
</asp:CheckBoxField>
<asp:TemplateField HeaderText="Actions" >
<ItemTemplate>
<asp:LinkButton ID="action" OnClick="BtnTest_OnClick" Text="Détails" runat="server" Width="100px" />
</ItemTemplate>
</asp:TemplateField>
</Columns>
<FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
<PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
<SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
<HeaderStyle BackColor="#000066" Font-Bold="True" ForeColor="White" />
<EditRowStyle BackColor="#999999" />
<AlternatingRowStyle BackColor="White" ForeColor="#284775" />
</asp:GridView>
<asp:SqlDataSource SelectCommand="SELECT N_COD_NUMCONTRAT, N_COD_NUMCOFFRE, N_COD_NUMDOS, S_LIB_DESIGNATION, S_LIB_NOMCONTRACTANT, S_LIB_INITIALESCONTRACTANT, S_LIB_NOMDIRECTION, S_LIB_NOMSIGNATURE + S_LIB_PRENONSIGNATURE AS SIGNATURE, S_DAT_SIGNATURE, S_DAT_FIN, S_DAT_RESIL, S_DAT_FINARCHI, B_BOL_SCANNE, B_BOL_RECOND, B_BOL_RESILIE FROM contrat, signature, contractant, direction, designation WHERE contrat.N_COD_DESIGNATION = designation.N_COD_DESIGNATION AND contrat.N_COD_NUMCONTRACTANT = contractant.N_COD_NUMCONTRACTANT AND contrat.N_COD_NUMDIRECTION = direction.N_COD_NUMDIRECTION AND contrat.N_COD_NUMSIGNATURE = signature.N_COD_NUMSIGNATURE"
ID="SqlDataSourceAll" runat="server">"></asp:SqlDataSource>
</p> |
Partager