private async Task <IEnumerable <Entt_EventPendingConsole> > SearchEventPendingAsync(string consoleNo)
{
var pendingAdapter = new Entt_EventPendingConsoleAdapter();
var query = $"SELECT [Id],[EventName],[EventId] FROM [Entt].[EventPendingConsole] WHERE [ConsoleNo] = '{consoleNo}'";
var list = new List <Entt_EventPendingConsole>();
using (var conn = new SqlConnection(pendingAdapter.ConnectionString))
using (var cmd = new SqlCommand(query, conn))
{
await conn.OpenAsync();
using (var reader = await cmd.ExecuteReaderAsync())
{
while (await reader.ReadAsync())
{
var item = new Entt_EventPendingConsole
{
Id = reader["Id"].ReadNullableString(),
EventName = reader["EventName"].ReadNullableString(),
EventId = reader["EventId"].ReadNullableString()
};
list.Add(item);
}
}
}
return(list);
}
private void AddPendingItems(string parentId, string consignmentNo)
{
var pendingConsole = new Entt_EventPendingConsole
{
Id = GenerateId(20),
EventId = parentId,
EventName = "Sop",
ConsoleNo = consignmentNo,
Version = 0,
DateTime = DateTime.Now
};
m_sopEventPendingConsoleRows.Add(pendingConsole);
}
private Entt_EventPendingConsole GetPendingConsoleRow(string parentId, string consignmentNo, string eventType)
{
var pendingConsole = new Entt_EventPendingConsole
{
Id = GenerateId(20),
EventId = parentId,
EventName = eventType,
ConsoleNo = consignmentNo,
Version = 0,
DateTime = DateTime.Now
};
return(pendingConsole);
}
private async Task ProcessEventPendingItem(RecordConsole console, Entt_EventPendingConsole pending)
{
var itemList = console.ItemConsignments.Split(new[] { ',', '\t' }, StringSplitOptions.RemoveEmptyEntries);
var ok = false;
switch (pending.EventName)
{
//case "pos.oal.DeliveryEventNew":
// await ProcessDeliveryPendingItem(pending.event_id, itemList);
// ok = true;
// break;
case "Sop":
await ProcessSopPendingItem(pending.EventId, itemList);
ok = true;
break;
case "Sip":
await ProcessSipPendingItem(pending.EventId, itemList);
ok = true;
break;
case "Hip":
await ProcessHipPendingItem(pending.EventId, itemList);
ok = true;
break;
case "Hop":
await ProcessHopPendingItem(pending.EventId, itemList);
ok = true;
break;
case "StatusCode":
await ProcessStatPendingItem(pending.EventId, itemList);
ok = true;
break;
case "Vasn":
await ProcessVasnPendingItem(pending.EventId, itemList);
ok = true;
break;
//case "pos.oal.NormalConsoleEventNew":
// //ProcessNormPendingItem(item.console_no, item.event_id);
// break;
//case "pos.oal.MissortEventNew":
// await ProcessMissPendingItem(pending.event_id, itemList);
// ok = true;
// break;
//case "pos.oal.WwpEventNewLog":
// await ProcessWwpPendingItem(pending.event_id, itemList);
// ok = true;
// break;
//case "pos.oal.IpsImport":
// await ProcessIpsPendingItem(pending.event_id, itemList);
// ok = true;
// break;
}
if (ok)
{
var pendingAdapter = new Entt_EventPendingConsoleAdapter();
await pendingAdapter.DeleteAsync(pending.Id);
}
}
