1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| SqlCommand sqlInsertDocument = isoSqlConnection.CreateCommand();
sqlInsertDocument.CommandText = "INSERT INTO" +
" Document " +
"(DocumentTypeCode, ZoneCode, TreatmentCode, Season, JobNumber,JobRevision, Employee, FileName)" +
" VALUES " +
"(@DocumentTypeCode, @ZoneCode, @TreatmentCode, @Season, @JobNumber, @JobRevision, @Employee, @FileName)";
SqlParameterCollection MesParams=sqlInsertDocument.Parameters;
MesParams.Add("@DocumentTypeCode", SqlDbType.Char).Value = documentTypeCode;
MesParams.Add("@ZoneCode", SqlDbType.Char).Value = zoneCode;
MesParams.Add("@TreatmentCode", SqlDbType.Int).Value = treatmentCode;
MesParams.Add("@Season", SqlDbType.Int).Value = season;
MesParams.Add("@JobNumber", SqlDbType.Int).Value = nextJobNumber;
MesParams.Add("JobRevision", SqlDbType.Int).Value = 0;
MesParams.Add("@Employee", SqlDbType.Int).Value = GetEmployeeID(loginName);
MesParams.Add("@FileName", SqlDbType.Char).Value = documentName; |
Partager