1 2 3 4 5 6 7 8 9 10 11 12 13 14
|
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)";
sqlInsertDocument.Parameters.Add(new SqlParameter("@DocumentTypeCode", SqlDbType.Char)).Value = documentTypeCode;
sqlInsertDocument.Parameters.Add(new SqlParameter("@ZoneCode", SqlDbType.Char)).Value = zoneCode;
sqlInsertDocument.Parameters.Add(new SqlParameter("@TreatmentCode", SqlDbType.Int)).Value = treatmentCode;
sqlInsertDocument.Parameters.Add(new SqlParameter("@Season", SqlDbType.Int)).Value = season;
sqlInsertDocument.Parameters.Add(new SqlParameter("@JobNumber", SqlDbType.Int)).Value = nextJobNumber;
sqlInsertDocument.Parameters.Add(new SqlParameter("@JobRevision", SqlDbType.Int)).Value = 0;
sqlInsertDocument.Parameters.Add(new SqlParameter("@Employee", SqlDbType.Int)).Value = GetEmployeeID(loginName);
sqlInsertDocument.Parameters.Add(new SqlParameter("@FileName", SqlDbType.Char)).Value = documentName; |
Partager