public SaveDataResult ImportHWGR(List <ImportHWGRData> list)
{
SaveDataResult result = new SaveDataResult();
result.Success = true;
if (list.Count > 0)
{
string query =
@" create table #hwgr4insert
(
HWGR_SystemID int,
World_SystemID int,
ImportName nvarchar (50)
)
";
using (IDbCommand command = CreateCommand())
{
command.CommandText = query;
command.CommandTimeout = 60 * 3;
command.ExecuteNonQuery();
foreach (ImportHWGRData value in list)
{
query =
"insert into #hwgr4insert (HWGR_SystemID,World_SystemID, ImportName) values({0},{1},N'{2}')";
command.CommandText =
string.Format(query, value.HWGR_SystemID, value.World_SystemID, value.Name);
command.ExecuteNonQuery();
}
command.CommandText = "spHWGR_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())
{
ImportHWGRData value = new ImportHWGRData();
value.HWGR_SystemID = reader.GetInt32(0);
value.World_SystemID = reader.GetInt32(1);
list.Add(value);
}
reader.NextResult();
result.Success = ((int)importResult.Value > 0);
}
result.Data = list;
}
}
OnDaoInvalidateWholeCache();
return(result);
}
internal ImportFileHWGRData(int recordNumber, ImportHWGRData data)
{
RecordNumber = recordNumber;
Data = data;
}
