public SaveDataResult ImportAbsence(List <ImportAbsenceData> list) { SaveDataResult result = new SaveDataResult(); result.Success = true; if (list.Count > 0) { string query = @" create table #abs4insert ( SystemID int, CharID nvarchar (10), [Name] nvarchar (50) ) "; using (IDbCommand command = CreateCommand()) { command.CommandText = query; command.CommandTimeout = 60 * 3; command.ExecuteNonQuery(); foreach (ImportAbsenceData value in list) { query = @"insert into #abs4insert (SystemID, CharID, [Name]) values({0},'{1}',N'{2}')" ; command.CommandText = string.Format(query, value.SystemID, value.CharID, value.Name); command.ExecuteNonQuery(); } command.CommandText = "spAbsence_ImportData"; command.CommandType = CommandType.StoredProcedure; SqlParameter importResult = new SqlParameter("@result", SqlDbType.Int, 4); importResult.Direction = ParameterDirection.Output; command.Parameters.Add(importResult); using (IDataReader reader = command.ExecuteReader(CommandBehavior.SequentialAccess)) { list.Clear(); while (reader.Read()) { ImportAbsenceData value = new ImportAbsenceData(); value.SystemID = reader.GetInt32(0); list.Add(value); } reader.NextResult(); result.Success = ((int)importResult.Value > 0); } result.Data = list; } } OnDaoInvalidateWholeCache(); return(result); }
internal ImportFileAbsenceData(int recordNumber, ImportAbsenceData data) { RecordNumber = recordNumber; Data = data; }