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); } }