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 70 71 72 73 74 75 76 77 78 79 80 81 82 83
| <asp:DataGrid ID="DataGrid2" runat="server" AutoGenerateColumns="False" CellPadding="4" OnEditCommand="trait_annul" OnPageIndexChanged="DataGrid2_PageIndexChanged"
DataSourceID="SqlDataSource2" ForeColor="#333333" GridLines="None" Visible="False" Font-Size="10pt" AllowPaging="True" PageSize="5">
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<EditItemStyle BackColor="#2461BF" />
<SelectedItemStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" Mode="NumericPages" />
<AlternatingItemStyle BackColor="White" />
<ItemStyle BackColor="#EFF3FB" />
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<Columns>
<asp:BoundColumn DataField="NUMERO_DEMANDE" HeaderText="#"></asp:BoundColumn>
<asp:BoundColumn DataField="DATE_DEMANDE" HeaderText="Date"></asp:BoundColumn>
<asp:BoundColumn DataField="NOMBREPARTDEM" HeaderText="Nb Part"></asp:BoundColumn>
<asp:BoundColumn DataField="COMTYPEDEM" HeaderText="Type"></asp:BoundColumn>
<asp:BoundColumn DataField="COMINTITULE" HeaderText="Intitulé"></asp:BoundColumn>
<asp:BoundColumn DataField="COMMAT" HeaderText="Matériels"></asp:BoundColumn>
<asp:BoundColumn DataField="COMDATEDEB" HeaderText="Début"></asp:BoundColumn>
<asp:BoundColumn DataField="COMDATEFIN" HeaderText="Fin"></asp:BoundColumn>
<asp:BoundColumn DataField="COMHEUREDEB" HeaderText="Heure début"></asp:BoundColumn>
<asp:BoundColumn DataField="COMHEUREFIN" HeaderText="Heure fin"></asp:BoundColumn>
<asp:BoundColumn DataField="COMDEPART" HeaderText="Département"></asp:BoundColumn>
<asp:EditCommandColumn CancelText="Cancel" EditText="retraiter" HeaderText="modifanul"
UpdateText="Update"></asp:EditCommandColumn>
</Columns>
</asp:DataGrid><asp:SqlDataSource ID="SqlDataSource2" runat="server" ConflictDetection="CompareAllValues"
ConnectionString="<%$ ConnectionStrings:GESSALLEConnectionString %>" DeleteCommand="DELETE FROM [DEMANDE] WHERE [NUMERO_DEMANDE] = @original_NUMERO_DEMANDE AND [DATE_DEMANDE] = @original_DATE_DEMANDE AND [NOMBREPARTDEM] = @original_NOMBREPARTDEM AND [COMTYPEDEM] = @original_COMTYPEDEM AND [COMINTITULE] = @original_COMINTITULE AND [COMMAT] = @original_COMMAT AND [COMDATEDEB] = @original_COMDATEDEB AND [COMDATEFIN] = @original_COMDATEFIN AND [COMHEUREDEB] = @original_COMHEUREDEB AND [COMHEUREFIN] = @original_COMHEUREFIN AND [COMDEPART] = @original_COMDEPART"
InsertCommand="INSERT INTO [DEMANDE] ([DATE_DEMANDE], [NOMBREPARTDEM], [COMTYPEDEM], [COMINTITULE], [COMMAT], [COMDATEDEB], [COMDATEFIN], [COMHEUREDEB], [COMHEUREFIN], [COMDEPART]) VALUES (@DATE_DEMANDE, @NOMBREPARTDEM, @COMTYPEDEM, @COMINTITULE, @COMMAT, @COMDATEDEB, @COMDATEFIN, @COMHEUREDEB, @COMHEUREFIN, @COMDEPART)"
OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT [NUMERO_DEMANDE], [DATE_DEMANDE], [NOMBREPARTDEM], [COMTYPEDEM], [COMINTITULE], [COMMAT], [COMDATEDEB], [COMDATEFIN], [COMHEUREDEB], [COMHEUREFIN], [COMDEPART] FROM [DEMANDE] WHERE (([IDSTATUT] = @IDSTATUT) AND ([NOM_USER] = @NOM_USER)) ORDER BY [NUMERO_DEMANDE] DESC"
UpdateCommand="UPDATE [DEMANDE] SET [DATE_DEMANDE] = @DATE_DEMANDE, [NOMBREPARTDEM] = @NOMBREPARTDEM, [COMTYPEDEM] = @COMTYPEDEM, [COMINTITULE] = @COMINTITULE, [COMMAT] = @COMMAT, [COMDATEDEB] = @COMDATEDEB, [COMDATEFIN] = @COMDATEFIN, [COMHEUREDEB] = @COMHEUREDEB, [COMHEUREFIN] = @COMHEUREFIN, [COMDEPART] = @COMDEPART WHERE [NUMERO_DEMANDE] = @original_NUMERO_DEMANDE AND [DATE_DEMANDE] = @original_DATE_DEMANDE AND [NOMBREPARTDEM] = @original_NOMBREPARTDEM AND [COMTYPEDEM] = @original_COMTYPEDEM AND [COMINTITULE] = @original_COMINTITULE AND [COMMAT] = @original_COMMAT AND [COMDATEDEB] = @original_COMDATEDEB AND [COMDATEFIN] = @original_COMDATEFIN AND [COMHEUREDEB] = @original_COMHEUREDEB AND [COMHEUREFIN] = @original_COMHEUREFIN AND [COMDEPART] = @original_COMDEPART">
<DeleteParameters>
<asp:Parameter Name="original_NUMERO_DEMANDE" Type="Int32" />
<asp:Parameter Name="original_DATE_DEMANDE" Type="String" />
<asp:Parameter Name="original_NOMBREPARTDEM" Type="Int32" />
<asp:Parameter Name="original_COMTYPEDEM" Type="String" />
<asp:Parameter Name="original_COMINTITULE" Type="String" />
<asp:Parameter Name="original_COMMAT" Type="String" />
<asp:Parameter Name="original_COMDATEDEB" Type="DateTime" />
<asp:Parameter Name="original_COMDATEFIN" Type="DateTime" />
<asp:Parameter Name="original_COMHEUREDEB" Type="String" />
<asp:Parameter Name="original_COMHEUREFIN" Type="String" />
<asp:Parameter Name="original_COMDEPART" Type="String" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="DATE_DEMANDE" Type="String" />
<asp:Parameter Name="NOMBREPARTDEM" Type="Int32" />
<asp:Parameter Name="COMTYPEDEM" Type="String" />
<asp:Parameter Name="COMINTITULE" Type="String" />
<asp:Parameter Name="COMMAT" Type="String" />
<asp:Parameter Name="COMDATEDEB" Type="DateTime" />
<asp:Parameter Name="COMDATEFIN" Type="DateTime" />
<asp:Parameter Name="COMHEUREDEB" Type="String" />
<asp:Parameter Name="COMHEUREFIN" Type="String" />
<asp:Parameter Name="COMDEPART" Type="String" />
<asp:Parameter Name="original_NUMERO_DEMANDE" Type="Int32" />
<asp:Parameter Name="original_DATE_DEMANDE" Type="String" />
<asp:Parameter Name="original_NOMBREPARTDEM" Type="Int32" />
<asp:Parameter Name="original_COMTYPEDEM" Type="String" />
<asp:Parameter Name="original_COMINTITULE" Type="String" />
<asp:Parameter Name="original_COMMAT" Type="String" />
<asp:Parameter Name="original_COMDATEDEB" Type="DateTime" />
<asp:Parameter Name="original_COMDATEFIN" Type="DateTime" />
<asp:Parameter Name="original_COMHEUREDEB" Type="String" />
<asp:Parameter Name="original_COMHEUREFIN" Type="String" />
<asp:Parameter Name="original_COMDEPART" Type="String" />
</UpdateParameters>
<SelectParameters>
<asp:Parameter DefaultValue="3" Name="IDSTATUT" Type="Int32" />
<asp:SessionParameter Name="NOM_USER" SessionField="name" Type="String" />
</SelectParameters>
<InsertParameters>
<asp:Parameter Name="DATE_DEMANDE" Type="String" />
<asp:Parameter Name="NOMBREPARTDEM" Type="Int32" />
<asp:Parameter Name="COMTYPEDEM" Type="String" />
<asp:Parameter Name="COMINTITULE" Type="String" />
<asp:Parameter Name="COMMAT" Type="String" />
<asp:Parameter Name="COMDATEDEB" Type="DateTime" />
<asp:Parameter Name="COMDATEFIN" Type="DateTime" />
<asp:Parameter Name="COMHEUREDEB" Type="String" />
<asp:Parameter Name="COMHEUREFIN" Type="String" />
<asp:Parameter Name="COMDEPART" Type="String" />
</InsertParameters>
</asp:SqlDataSource>
<br /> |
Partager