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
| <asp:TextBox ID="IDJournal" runat="server"></asp:TextBox>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:SAV IMERIRConnectionString %>"
DeleteCommand="DELETE from Incidents where Incidents.id = @IdIncident"
InsertCommand="INSERT INTO INCIDENTS (IdAffaire, Principal, Commentaires, IdComposantDommage) VALUES (@IDJournal, @Principal, @Commentaires, @IdComposantDommage)"
SelectCommand="SELECT Incidents.Id as IdIncident, Composant.Designation as Composant, Composant.Id as IdComposant,Dommage.Id as IdDommage, Dommage.Description as Dommage,ComposantDommage.id as IdComposantDommage, Incidents.Principal, Incidents.Commentaires FROM Incidents,ComposantDommage,Composant, Dommage Where Dommage.Id = ComposantDommage.Id AND Incidents.IdComposantDommage = ComposantDommage.Id AND ComposantDommage.IdComposant = Composant.Id AND Incidents.IdAffaire = @IDJournal order by Principal DESC"
UpdateCommand="UPDATE Incidents SET IdComposantDommage = @IdComposantDommage, Principal = @Principal, Commentaires =@Commentaires where Id = @IdIncident">
<InsertParameters>
<asp:ControlParameter ControlID="IDJournal" Name="IDJournal" Type="Int32" />
<asp:Parameter Name="Principal" />
<asp:Parameter Name="Commentaires" />
<asp:ControlParameter ControlID="ListView1" Name="IdComposantDommage" PropertyName="SelectedDataKey[1]"
Type="Int32" />
</InsertParameters>
</asp:SqlDataSource>
<asp:SqlDataSource ID="Composants" runat="server"
ConnectionString="<%$ ConnectionStrings:SAV IMERIRConnectionString %>"
SelectCommand="SELECT Id as IdComposant, Designation as IntituleComposant FROM Composant UNION SELECT NULL, NULL"
ProviderName="<%$ ConnectionStrings:SAV IMERIRConnectionString.ProviderName %>">
</asp:SqlDataSource>
<asp:ListView ID="ListView1" runat="server" ConvertEmptyStringToNull="False"
DataKeyNames="IdIncident,IdComposantDommage"
DataSourceID="SqlDataSource1" InsertItemPosition="LastItem">
<InsertItemTemplate>
<asp:SqlDataSource ID="DommageComposants" runat="server"
ConnectionString="<%$ ConnectionStrings:SAV IMERIRConnectionString %>"
SelectCommand="SELECT Dommage.Description as IntituleDommage, Dommage.Id as IdDommage, ComposantDommage.Id as IdComposantDommage FROM [dbo].[Dommage] INNER JOIN ComposantDommage ON ComposantDommage.IdDommage = Dommage.Id Where ComposantDommage.IdComposant = @Composant UNION SELECT null, 0, 0">
<SelectParameters>
<asp:ControlParameter ControlID="Composant" Name="Composant"
PropertyName="SelectedValue" />
</SelectParameters>
</asp:SqlDataSource>
<tr style="">
<td>
<asp:ImageButton ID="CancelButton" runat="server" CommandName="Cancel"
ImageUrl="~/Images/s_cancel.png" width="12px" Height="12px"/>
<asp:ImageButton ID="InsertButton" runat="server" CommandName="Insert"
ImageUrl="~/Images/s_success.png" width="12px" Height="12px"/>
</td>
<td>
<asp:Label ID="IdIncidentLabel" runat="server" /></td>
<td>
<asp:DropDownList ID="Composant" runat="server"
DataSourceID="Composants" DataTextField="IntituleComposant"
DataValueField="IdComposant"
Width="100%" AutoPostBack="True">
</asp:DropDownList>
</td>
<td>
<asp:DropDownList ID="IdComposantDommage" runat="server"
DataSourceID="DommageComposants" DataTextField="IntituleDommage"
DataValueField="IdComposantDommage" AutoPostBack="True"
Width="100%">
</asp:DropDownList>
</td>
<td>
<asp:CheckBox ID="PrincipalCheckBox" runat="server"
Checked='<%# Bind("Principal") %>' />
</td>
<td>
<asp:TextBox ID="CommentairesTextBox" runat="server"
Text='<%# Bind("Commentaires") %>' />
</td>
</tr>
</InsertItemTemplate>
</asp:ListView> |
