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
| public void updateAGD(string rqtexcde, DateTime? rqtsollimdte, bool wrktyppnt, int origcpyaddrincde, string origcpylocdsc, int ctcincde, int agdincde, int agdelapsedel, DateTime agdfromdte, DateTime agdtodte, DateTime? agddonedte, string wrkdsc, int wrkstsincde, bool pdasendpnt, string typexcde)
{
try
{
if (maConnection == null || maConnection.State != ConnectionState.Open)
{
this.Connect();
}
// Objet Command
string query = "INSERT INTO [SOMTEST].[dbo].[w_agdpec] " +
"([RqtExCde] " +
",[RqtSolLimDte] " +
",[WrkTypPnt] " +
",[OrigCpyAddrIncde] " +
",[OrigCpyLocDsc] " +
",[CtcInCde] " +
",[AgdInCde] " +
",[AgdElapseDel] " +
",[AgdFromDte] " +
",[AgdToDte] " +
",[AgdDoneDte] " +
",[WrkDsc] " +
",[WrkStsInCde] " +
",[PDASendPnt] " +
",[TypExCde] " +
",[RqtPecInCde] " +
",[RqtPecFromDte] " +
",[RqtPecToDte] " +
",[WrkExCde] " +
",[RqtNatExCde]) " +
"VALUES " +
"(@rqtexcde " +
",@rqtsollimdte " +
",@wrktyppnt " +
",@origcpyaddrincde " +
",@origcpylocdsc " +
",@ctcincde " +
",@agdincde " +
",@agdelapsedel " +
",@agdfromdte " +
",@agdtodte " +
",@agddonedte " +
",@wrkdsc " +
",@wrkstsincde " +
",@pdasendpnt " +
",@typexcde " +
",NULL" +
",NULL " +
",NULL " +
",NULL " +
",NULL)";
SqlCommand command = new SqlCommand(query, maConnection);
// Création et déclaration des paramètres
command.Parameters.Add(new SqlParameter("@rqtexcde", SqlDbType.VarChar, 10));
command.Parameters.Add(new SqlParameter("@rqtsollimdte", SqlDbType.DateTime));
command.Parameters.Add(new SqlParameter("@wrktyppnt", SqlDbType.Bit));
command.Parameters.Add(new SqlParameter("@origcpyaddrincde", SqlDbType.Int));
command.Parameters.Add(new SqlParameter("@origcpylocdsc", SqlDbType.VarChar , 50));
command.Parameters.Add(new SqlParameter("@ctcincde", SqlDbType.Int));
command.Parameters.Add(new SqlParameter("@agdincde", SqlDbType.Int));
command.Parameters.Add(new SqlParameter("@agdelapsedel", SqlDbType.Int));
command.Parameters.Add(new SqlParameter("@agdfromdte", SqlDbType.DateTime));
command.Parameters.Add(new SqlParameter("@agdtodte", SqlDbType.DateTime));
command.Parameters.Add(new SqlParameter("@agddonedte", SqlDbType.DateTime));
command.Parameters.Add(new SqlParameter("@wrkdsc", SqlDbType.VarChar , 50));
command.Parameters.Add(new SqlParameter("@wrkstsincde", SqlDbType.Int));
command.Parameters.Add(new SqlParameter("@pdasendpnt", SqlDbType.Bit));
command.Parameters.Add(new SqlParameter("@typexcde", SqlDbType.VarChar , 3));
// Attribution des valeurs aux paramètres
command .Parameters["@rqtexcde"].Value = rqtexcde;
command.Parameters["@rqtsollimdte"].Value = rqtsollimdte;
command .Parameters["@wrktyppnt"].Value = convertToBool(wrktyppnt) ;
command .Parameters["@origcpyaddrincde"].Value = origcpyaddrincde ;
command .Parameters["@origcpylocdsc"].Value = origcpylocdsc ;
command .Parameters["@ctcincde"].Value = ctcincde ;
command .Parameters["@agdincde"].Value = agdincde ;
command .Parameters["@agdelapsedel"].Value = agdelapsedel ;
command .Parameters["@agdfromdte"].Value = agdfromdte ;
command .Parameters["@agdtodte"].Value = agdtodte ;
command.Parameters["@agddonedte"].Value = agddonedte;
command .Parameters["@wrkdsc"].Value = wrkdsc ;
command .Parameters["@wrkstsincde"].Value = wrkstsincde ;
command .Parameters["@pdasendpnt"].Value = convertToBool(pdasendpnt ) ;
command .Parameters["@typexcde"].Value = typexcde ;
// Execution
command.ExecuteNonQuery();
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
//fermeture connexion
this.Disconnect();
} |
