CashMap/DataSet1.xsd at master · ME17FD/CashMap · GitHub

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
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="DataSet1" targetNamespace="http://tempuri.org/DataSet1.xsd" xmlns:mstns="http://tempuri.org/DataSet1.xsd" xmlns="http://tempuri.org/DataSet1.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="ConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="ConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.CashMap.Properties.Settings.GlobalReference.Default.ConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="commandeTableAdapter" GeneratorDataComponentClassName="commandeTableAdapter" Name="commande" UserDataComponentName="commandeTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectName="master.dbo.commande" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[commande] WHERE (([num_cmd] = @Original_num_cmd) AND ((@IsNull_date_cmd = 1 AND [date_cmd] IS NULL) OR ([date_cmd] = @Original_date_cmd)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_num_cmd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="num_cmd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_date_cmd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="date_cmd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_date_cmd" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="date_cmd" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[commande] ([date_cmd]) VALUES (@date_cmd);
SELECT num_cmd, date_cmd FROM commande WHERE (num_cmd = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@date_cmd" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="date_cmd" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT num_cmd, date_cmd FROM dbo.commande</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[commande] SET [date_cmd] = @date_cmd WHERE (([num_cmd] = @Original_num_cmd) AND ((@IsNull_date_cmd = 1 AND [date_cmd] IS NULL) OR ([date_cmd] = @Original_date_cmd)));
SELECT num_cmd, date_cmd FROM commande WHERE (num_cmd = @num_cmd)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@date_cmd" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="date_cmd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_num_cmd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="num_cmd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_date_cmd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="date_cmd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_date_cmd" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="date_cmd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="num_cmd" ColumnName="num_cmd" DataSourceName="master.dbo.commande" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@num_cmd" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="num_cmd" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="num_cmd" DataSetColumn="num_cmd" />
              <Mapping SourceColumn="date_cmd" DataSetColumn="date_cmd" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="lignecommandeTableAdapter" GeneratorDataComponentClassName="lignecommandeTableAdapter" Name="lignecommande" UserDataComponentName="lignecommandeTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectName="master.dbo.lignecommande" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[lignecommande] WHERE (([num_prod] = @Original_num_prod) AND ([num_cmd] = @Original_num_cmd) AND ((@IsNull_qte_cmdee = 1 AND [qte_cmdee] IS NULL) OR ([qte_cmdee] = @Original_qte_cmdee)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_num_prod" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="num_prod" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_num_cmd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="num_cmd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_qte_cmdee" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="qte_cmdee" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_qte_cmdee" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="qte_cmdee" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[lignecommande] ([num_prod], [num_cmd], [qte_cmdee]) VALUES (@num_prod, @num_cmd, @qte_cmdee);
SELECT num_prod, num_cmd, qte_cmdee FROM lignecommande WHERE (num_cmd = @num_cmd) AND (num_prod = @num_prod)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@num_prod" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="num_prod" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@num_cmd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="num_cmd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@qte_cmdee" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="qte_cmdee" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT num_prod, num_cmd, qte_cmdee FROM dbo.lignecommande</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[lignecommande] SET [num_prod] = @num_prod, [num_cmd] = @num_cmd, [qte_cmdee] = @qte_cmdee WHERE (([num_prod] = @Original_num_prod) AND ([num_cmd] = @Original_num_cmd) AND ((@IsNull_qte_cmdee = 1 AND [qte_cmdee] IS NULL) OR ([qte_cmdee] = @Original_qte_cmdee)));
SELECT num_prod, num_cmd, qte_cmdee FROM lignecommande WHERE (num_cmd = @num_cmd) AND (num_prod = @num_prod)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@num_prod" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="num_prod" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@num_cmd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="num_cmd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@qte_cmdee" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="qte_cmdee" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_num_prod" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="num_prod" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_num_cmd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="num_cmd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_qte_cmdee" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="qte_cmdee" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_qte_cmdee" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="qte_cmdee" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="num_prod" DataSetColumn="num_prod" />
              <Mapping SourceColumn="num_cmd" DataSetColumn="num_cmd" />
              <Mapping SourceColumn="qte_cmdee" DataSetColumn="qte_cmdee" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="produitTableAdapter" GeneratorDataComponentClassName="produitTableAdapter" Name="produit" UserDataComponentName="produitTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectName="master.dbo.produit" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[produit] WHERE (([num_prod] = @Original_num_prod) AND ((@IsNull_libelle = 1 AND [libelle] IS NULL) OR ([libelle] = @Original_libelle)) AND ((@IsNull_pu_prod = 1 AND [pu_prod] IS NULL) OR ([pu_prod] = @Original_pu_prod)) AND ((@IsNull_qte_stock = 1 AND [qte_stock] IS NULL) OR ([qte_stock] = @Original_qte_stock)) AND ((@IsNull_s_min = 1 AND [s_min] IS NULL) OR ([s_min] = @Original_s_min)) AND ((@IsNull_s_max = 1 AND [s_max] IS NULL) OR ([s_max] = @Original_s_max)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_num_prod" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="num_prod" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_libelle" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="libelle" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_libelle" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="libelle" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_pu_prod" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="pu_prod" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_pu_prod" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="pu_prod" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_qte_stock" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="qte_stock" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_qte_stock" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="qte_stock" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_s_min" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="s_min" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_s_min" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="s_min" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_s_max" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="s_max" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_s_max" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="s_max" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[produit] ([libelle], [pu_prod], [qte_stock], [s_min], [s_max]) VALUES (@libelle, @pu_prod, @qte_stock, @s_min, @s_max);
SELECT num_prod, libelle, pu_prod, qte_stock, s_min, s_max FROM produit WHERE (num_prod = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@libelle" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="libelle" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@pu_prod" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="pu_prod" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@qte_stock" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="qte_stock" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@s_min" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="s_min" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@s_max" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="s_max" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT num_prod, libelle, pu_prod, qte_stock, s_min, s_max FROM dbo.produit</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[produit] SET [libelle] = @libelle, [pu_prod] = @pu_prod, [qte_stock] = @qte_stock, [s_min] = @s_min, [s_max] = @s_max WHERE (([num_prod] = @Original_num_prod) AND ((@IsNull_libelle = 1 AND [libelle] IS NULL) OR ([libelle] = @Original_libelle)) AND ((@IsNull_pu_prod = 1 AND [pu_prod] IS NULL) OR ([pu_prod] = @Original_pu_prod)) AND ((@IsNull_qte_stock = 1 AND [qte_stock] IS NULL) OR ([qte_stock] = @Original_qte_stock)) AND ((@IsNull_s_min = 1 AND [s_min] IS NULL) OR ([s_min] = @Original_s_min)) AND ((@IsNull_s_max = 1 AND [s_max] IS NULL) OR ([s_max] = @Original_s_max)));
SELECT num_prod, libelle, pu_prod, qte_stock, s_min, s_max FROM produit WHERE (num_prod = @num_prod)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@libelle" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="libelle" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@pu_prod" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="pu_prod" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@qte_stock" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="qte_stock" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@s_min" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="s_min" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@s_max" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="s_max" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_num_prod" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="num_prod" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_libelle" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="libelle" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_libelle" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="libelle" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_pu_prod" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="pu_prod" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_pu_prod" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="pu_prod" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_qte_stock" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="qte_stock" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_qte_stock" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="qte_stock" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_s_min" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="s_min" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_s_min" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="s_min" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_s_max" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="s_max" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_s_max" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="s_max" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="num_prod" ColumnName="num_prod" DataSourceName="master.dbo.produit" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@num_prod" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="num_prod" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="num_prod" DataSetColumn="num_prod" />
              <Mapping SourceColumn="libelle" DataSetColumn="libelle" />
              <Mapping SourceColumn="pu_prod" DataSetColumn="pu_prod" />
              <Mapping SourceColumn="qte_stock" DataSetColumn="qte_stock" />
              <Mapping SourceColumn="s_min" DataSetColumn="s_min" />
              <Mapping SourceColumn="s_max" DataSetColumn="s_max" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="DataSet1" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_UserDSName="DataSet1" msprop:Generator_DataSetName="DataSet1">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="commande" msprop:Generator_RowEvHandlerName="commandeRowChangeEventHandler" msprop:Generator_RowDeletedName="commandeRowDeleted" msprop:Generator_RowDeletingName="commandeRowDeleting" msprop:Generator_RowEvArgName="commandeRowChangeEvent" msprop:Generator_TablePropName="commande" msprop:Generator_RowChangedName="commandeRowChanged" msprop:Generator_RowChangingName="commandeRowChanging" msprop:Generator_TableClassName="commandeDataTable" msprop:Generator_RowClassName="commandeRow" msprop:Generator_TableVarName="tablecommande" msprop:Generator_UserTableName="commande">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="num_cmd" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInRow="num_cmd" msprop:Generator_ColumnPropNameInTable="num_cmdColumn" msprop:Generator_ColumnVarNameInTable="columnnum_cmd" msprop:Generator_UserColumnName="num_cmd" type="xs:int" />
              <xs:element name="date_cmd" msprop:Generator_ColumnPropNameInRow="date_cmd" msprop:Generator_ColumnPropNameInTable="date_cmdColumn" msprop:Generator_ColumnVarNameInTable="columndate_cmd" msprop:Generator_UserColumnName="date_cmd" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="lignecommande" msprop:Generator_RowEvHandlerName="lignecommandeRowChangeEventHandler" msprop:Generator_RowDeletedName="lignecommandeRowDeleted" msprop:Generator_RowDeletingName="lignecommandeRowDeleting" msprop:Generator_RowEvArgName="lignecommandeRowChangeEvent" msprop:Generator_TablePropName="lignecommande" msprop:Generator_RowChangedName="lignecommandeRowChanged" msprop:Generator_RowChangingName="lignecommandeRowChanging" msprop:Generator_TableClassName="lignecommandeDataTable" msprop:Generator_RowClassName="lignecommandeRow" msprop:Generator_TableVarName="tablelignecommande" msprop:Generator_UserTableName="lignecommande">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="num_prod" msprop:Generator_ColumnPropNameInRow="num_prod" msprop:Generator_ColumnPropNameInTable="num_prodColumn" msprop:Generator_ColumnVarNameInTable="columnnum_prod" msprop:Generator_UserColumnName="num_prod" type="xs:int" />
              <xs:element name="num_cmd" msprop:Generator_ColumnPropNameInRow="num_cmd" msprop:Generator_ColumnPropNameInTable="num_cmdColumn" msprop:Generator_ColumnVarNameInTable="columnnum_cmd" msprop:Generator_UserColumnName="num_cmd" type="xs:int" />
              <xs:element name="qte_cmdee" msprop:Generator_ColumnPropNameInRow="qte_cmdee" msprop:Generator_ColumnPropNameInTable="qte_cmdeeColumn" msprop:Generator_ColumnVarNameInTable="columnqte_cmdee" msprop:Generator_UserColumnName="qte_cmdee" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="produit" msprop:Generator_RowEvHandlerName="produitRowChangeEventHandler" msprop:Generator_RowDeletedName="produitRowDeleted" msprop:Generator_RowDeletingName="produitRowDeleting" msprop:Generator_RowEvArgName="produitRowChangeEvent" msprop:Generator_TablePropName="produit" msprop:Generator_RowChangedName="produitRowChanged" msprop:Generator_RowChangingName="produitRowChanging" msprop:Generator_TableClassName="produitDataTable" msprop:Generator_RowClassName="produitRow" msprop:Generator_TableVarName="tableproduit" msprop:Generator_UserTableName="produit">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="num_prod" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnPropNameInRow="num_prod" msprop:Generator_ColumnPropNameInTable="num_prodColumn" msprop:Generator_ColumnVarNameInTable="columnnum_prod" msprop:Generator_UserColumnName="num_prod" type="xs:int" />
              <xs:element name="libelle" msprop:Generator_ColumnPropNameInRow="libelle" msprop:Generator_ColumnPropNameInTable="libelleColumn" msprop:Generator_ColumnVarNameInTable="columnlibelle" msprop:Generator_UserColumnName="libelle" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="pu_prod" msprop:Generator_ColumnPropNameInRow="pu_prod" msprop:Generator_ColumnPropNameInTable="pu_prodColumn" msprop:Generator_ColumnVarNameInTable="columnpu_prod" msprop:Generator_UserColumnName="pu_prod" type="xs:double" minOccurs="0" />
              <xs:element name="qte_stock" msprop:Generator_ColumnPropNameInRow="qte_stock" msprop:Generator_ColumnPropNameInTable="qte_stockColumn" msprop:Generator_ColumnVarNameInTable="columnqte_stock" msprop:Generator_UserColumnName="qte_stock" type="xs:int" minOccurs="0" />
              <xs:element name="s_min" msprop:Generator_ColumnPropNameInRow="s_min" msprop:Generator_ColumnPropNameInTable="s_minColumn" msprop:Generator_ColumnVarNameInTable="columns_min" msprop:Generator_UserColumnName="s_min" type="xs:int" minOccurs="0" />
              <xs:element name="s_max" msprop:Generator_ColumnPropNameInRow="s_max" msprop:Generator_ColumnPropNameInTable="s_maxColumn" msprop:Generator_ColumnVarNameInTable="columns_max" msprop:Generator_UserColumnName="s_max" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:commande" />
      <xs:field xpath="mstns:num_cmd" />
    </xs:unique>
    <xs:unique name="lignecommande_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:lignecommande" />
      <xs:field xpath="mstns:num_prod" />
      <xs:field xpath="mstns:num_cmd" />
    </xs:unique>
    <xs:unique name="produit_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:produit" />
      <xs:field xpath="mstns:num_prod" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK__lignecomm__num_c__2A6B46EF" msdata:parent="commande" msdata:child="lignecommande" msdata:parentkey="num_cmd" msdata:childkey="num_cmd" msprop:Generator_UserParentTable="commande" msprop:Generator_UserChildTable="lignecommande" msprop:Generator_RelationVarName="relationFK__lignecomm__num_c__2A6B46EF" msprop:Generator_ChildPropName="GetlignecommandeRows" msprop:Generator_ParentPropName="commandeRow" msprop:Generator_UserRelationName="FK__lignecomm__num_c__2A6B46EF" />
      <msdata:Relationship name="FK__lignecomm__num_p__297722B6" msdata:parent="produit" msdata:child="lignecommande" msdata:parentkey="num_prod" msdata:childkey="num_prod" msprop:Generator_UserParentTable="produit" msprop:Generator_UserChildTable="lignecommande" msprop:Generator_RelationVarName="relationFK__lignecomm__num_p__297722B6" msprop:Generator_UserRelationName="FK__lignecomm__num_p__297722B6" msprop:Generator_ChildPropName="GetlignecommandeRows" msprop:Generator_ParentPropName="produitRow" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>