public void BindOrder() { Order o = new Order(); DataListOrder.DataSource = o.GetAllOrderAndOrderStatus(); DataListOrder.DataKeyField = "OrderId"; DataListOrder.DataBind(); }
private bool CanExecuteStart() { try { return(Operation == null && DataListOrder != null && DataListOrder.FirstOrDefault(p => p.Status == EnumWMSOrderStatus.Inactive) != null); } catch (Exception e) { _warehouse.AddEvent(Database.Event.EnumSeverity.Error, Database.Event.EnumType.Exception, string.Format("{0}.{1}: {2}", this.GetType().Name, (new StackTrace()).GetFrame(0).GetMethod().Name, e.Message)); return(false); } }
//public void Binduser() //{ // User bll = new User(); // IList<UserInfo> user = bll.GetUserDataByName(Session["CommodityimagesName"].ToString()); //} public void BindOrder() { if (Session["CommodityimagesName"] != null) { Order bll = new Order(); DataListOrder.DataSource = bll.GetOrderByOneName(Session["CommodityimagesName"].ToString()); DataListOrder.DataKeyField = "OrderId"; DataListOrder.DataBind(); } else { ClientScriptManager cs = this.ClientScript; cs.RegisterStartupScript(this.GetType(), "aa", "javascript:history.go(-1)", true); } }
private async Task ExecuteRefreshSelectedOrder() { try { if (SelectedOrder != null) { int?erpid = SelectedOrder?.ERPID; int?orderid = SelectedOrder?.OrderID; var orders = await _dbservicewms.GetOrdersWithCount(DateTime.Now.AddDays(-1), DateTime.Now, (int)EnumWMSOrderStatus.OnTargetPart, SelectedOrder.ERPID, SelectedOrder.OrderID); var o = orders.FirstOrDefault(); if (o != null) { int idx = DataListOrder.IndexOf(SelectedOrder); if (idx >= 0) { DataListOrder[idx] = new ReleaseOrderViewModel { ERPID = o.ERPID, ERPIDref = o.ERPIDStokbar, OrderID = o.OrderID, Destination = o.Destination, ReleaseTime = o.ReleaseTime, LastChange = o.LastChange, Portion = $"{o.CountAll - o.CountActive - o.CountMoveDone - o.CountFinished}+{o.CountActive}+{o.CountMoveDone}+{o.CountFinished}={o.CountAll}", Status = (EnumWMSOrderStatus)o.Status }; DataListOrder[idx].Initialize(_warehouse); } if (orderid != null) { SelectedOrder = DataListOrder.FirstOrDefault(p => p.ERPID == erpid && p.OrderID == orderid); } } } } catch (Exception e) { _warehouse.AddEvent(Database.Event.EnumSeverity.Error, Database.Event.EnumType.Exception, string.Format("{0}.{1}: {2}", this.GetType().Name, (new StackTrace()).GetFrame(0).GetMethod().Name, e.Message)); } }
private async Task ExecuteRefreshOrder() { try { int?erpid = SelectedOrder?.ERPID; int?orderid = SelectedOrder?.OrderID; _suborderid = SelectedSubOrder?.SubOrderID; var orders = await _dbservicewms.GetHistOrdersDistinct(DateFrom.TimeStamp, DateTo.TimeStamp, -1); DataListOrder.Clear(); foreach (var p in orders) { DataListOrder.Add(new ReleaseOrderViewModel { ERPID = p.ERPID, ERPIDref = p.ERPIDStokbar, OrderID = p.OrderID, Destination = p.Destination, ReleaseTime = p.ReleaseTime, LastChange = p.LastChange, Portion = $"{p.CountActive}/{p.CountAll} - {p.CountMoveDone}/{p.CountAll} - {p.CountFinished}/{p.CountAll}", Status = (EnumWMSOrderStatus)p.Status }); } foreach (var l in DataListOrder) { l.Initialize(_warehouse); } Records = DataListOrder.Count(); if (orderid != null) { SelectedOrder = DataListOrder.FirstOrDefault(p => p.ERPID == erpid && p.OrderID == orderid); } } catch (Exception e) { _warehouse.AddEvent(Database.Event.EnumSeverity.Error, Database.Event.EnumType.Exception, string.Format("{0}.{1}: {2}", this.GetType().Name, (new StackTrace()).GetFrame(0).GetMethod().Name, e.Message)); } }
private async Task ExecuteRefresh() { try { int?erpid = SelectedOrder == null ? -1 : SelectedOrder.ERPID; int orderid = SelectedOrder == null ? -1 : SelectedOrder.OrderID; _suborderid = SelectedSubOrder == null ? -1 : SelectedSubOrder.SubOrderID; _skuid = SelectedSKU == null ? -1 : SelectedSKU.ID; await ExecuteRefreshOrder(); if (orderid != -1) { SelectedOrder = DataListOrder.FirstOrDefault(p => p.ERPID == erpid && p.OrderID == orderid); } } catch (Exception e) { _warehouse.AddEvent(Database.Event.EnumSeverity.Error, Database.Event.EnumType.Exception, string.Format("{0}.{1}: {2}", this.GetType().Name, (new StackTrace()).GetFrame(0).GetMethod().Name, e.Message)); } }
private async Task ExecuteRefreshOrder() { try { var orders = await _dbservicewms.GetOrdersDistinct(DateTime.Now.AddDays(-1), DateTime.MaxValue, (int)EnumWMSOrderStatus.OnTargetPart); DataListOrder.Clear(); foreach (var p in orders) { DataListOrder.Add(new OrderViewModel { ID = 0, ERPID = p.ERPID, ERPIDRef = p.ERPIDStokbar, OrderID = p.OrderID, Destination = p.Destination, ReleaseTime = p.ReleaseTime, SubOrderID = p.SubOrderID, SubOrderERPID = p.SubOrderERPID, SubOrderName = p.SubOrderName, SKUID = null, SKUBatch = null, SKUQty = 0, Status = (EnumWMSOrderStatus)p.Status }); } foreach (var l in DataListOrder) { l.Initialize(_warehouse); } } catch (Exception e) { _warehouse.AddEvent(Database.Event.EnumSeverity.Error, Database.Event.EnumType.Exception, string.Format("{0}.{1}: {2}", this.GetType().Name, (new StackTrace()).GetFrame(0).GetMethod().Name, e.Message)); } }
private async Task ExecuteRefreshOrders() { try { int?erpid = SelectedOrder?.ERPID; int?orderid = SelectedOrder?.OrderID; int?ao_erpid = ActiveOrder?.ERPID; int?ao_orderid = ActiveOrder?.OrderID; _suborderid = SelectedSubOrder?.ID; _commandid = SelectedCommand?.WMSID; var ao = _dbservicewms.GetOrders((int)EnumWMSOrderStatus.Active, (int)EnumWMSOrderStatus.Active).FirstOrDefault(); if (ao != null) { ActiveOrder = new ReleaseOrderViewModel { ERPID = ao.ERP_ID, OrderID = ao.OrderID, TUID = ao.TU_ID, BoxID = ao.Box_ID, SKUID = ao.SKU_ID, SKUBatch = ao.SKU_Batch, Destination = ao.Destination, ReleaseTime = ao.ReleaseTime, Status = (EnumWMSOrderStatus)ao.Status } } ; else { ActiveOrder = null; } // if(ao_erpid != ActiveOrder?.ERPID || ao_orderid != ActiveOrder?.OrderID) // await ExecuteRefreshCommandWMS(); var orders = await _dbservicewms.GetOrdersDistinct(DateTime.Now.AddSeconds(1), DateTime.Now, (int)EnumWMSOrderStatus.OnTargetPart); _donotrefreshsuborder = true; DataListOrder.Clear(); foreach (var p in orders) { DataListOrder.Add(new ReleaseOrderViewModel { ERPID = p.ERPID, OrderID = p.OrderID, TUID = p.TUID, BoxID = p.BoxID, SKUID = p.SKUID, SKUBatch = p.SKUBatch, Destination = p.Destination, ReleaseTime = p.ReleaseTime, LastChange = p.LastChange, Status = (EnumWMSOrderStatus)p.Status }); } foreach (var l in DataListOrder) { l.Initialize(_warehouse); } _donotrefreshsuborder = false; if (orderid != null) { SelectedOrder = DataListOrder.FirstOrDefault(p => p.ERPID == erpid && p.OrderID == orderid); } else { SelectedOrder = DataListOrder.FirstOrDefault(); } if (SelectedOrder == null) { await ExecuteRefreshSubOrder(); } } catch (Exception e) { _warehouse.AddEvent(Database.Event.EnumSeverity.Error, Database.Event.EnumType.Exception, string.Format("{0}.{1}: {2}", this.GetType().Name, (new StackTrace()).GetFrame(0).GetMethod().Name, e.Message)); } }
private async Task ExecuteConfirm() { int orderid, suborderid; string skuid; try { EditEnabled = false; EnabledCC = false; try { switch (_selectedCommand) { case CommandType.AddOrder: Detailed.Order.SubOrderERPID = Detailed.Order.SubOrderID; _dbservicewms.AddOrder(Detailed.Order); orderid = Detailed.OrderID; await ExecuteRefresh(); SelectedOrder = DataListOrder.FirstOrDefault(p => p.OrderID == orderid); _dbservicewms.AddLog(_accessUser, EnumLogWMS.Event, "UI", $"Add order: {Detailed.Order.ToString()}"); break; case CommandType.EditOrder: _dbservicewms.UpdateOrders(SelectedOrder.ERPID, SelectedOrder.OrderID, Detailed.Order); var loe = from d in DataListOrder where d.OrderID == SelectedOrder.OrderID select d; foreach (var l in loe) { l.OrderID = Detailed.OrderID; l.Destination = Detailed.Destination; l.ReleaseTime = Detailed.ReleaseTime; } _dbservicewms.AddLog(_accessUser, EnumLogWMS.Event, "UI", $"Edit order: {Detailed.Order.ToString()}"); break; case CommandType.DeleteOrder: _dbservicewms.DeleteOrders(SelectedOrder.ERPID, SelectedOrder.OrderID); _dbservicewms.AddLog(_accessUser, EnumLogWMS.Event, "UI", $"Delete order: {Detailed.Order.ToString()}"); await ExecuteRefresh(); break; case CommandType.AddSubOrder: Detailed.Order.SubOrderERPID = Detailed.Order.SubOrderID; _dbservicewms.AddOrder(Detailed.Order); orderid = Detailed.OrderID; suborderid = Detailed.SubOrderID; await ExecuteRefresh(); SelectedSubOrder = DataListSubOrder.FirstOrDefault(p => p.OrderID == orderid && p.SubOrderID == suborderid); _dbservicewms.AddLog(_accessUser, EnumLogWMS.Event, "UI", $"Add suborder: {Detailed.Order.ToString()}"); break; case CommandType.EditSubOrder: Detailed.Order.SubOrderERPID = Detailed.Order.SubOrderID; _dbservicewms.UpdateSubOrders(Detailed.ERPID, SelectedSubOrder.OrderID, SelectedSubOrder.SubOrderID, Detailed.Order); var lse = from d in DataListSubOrder where d.OrderID == SelectedSubOrder.OrderID && d.SubOrderID == SelectedSubOrder.SubOrderID select d; foreach (var l in lse) { l.SubOrderID = Detailed.SubOrderID; l.SubOrderName = Detailed.SubOrderName; } SelectedSubOrder.SubOrderID = Detailed.SubOrderID; SelectedSubOrder.SubOrderName = Detailed.SubOrderName; _dbservicewms.AddLog(_accessUser, EnumLogWMS.Event, "UI", $"Edit suborder: {Detailed.Order.ToString()}"); break; case CommandType.DeleteSubOrder: _dbservicewms.DeleteSubOrders(Detailed.ERPID, Detailed.OrderID, Detailed.SubOrderID); _dbservicewms.AddLog(_accessUser, EnumLogWMS.Event, "UI", $"Delete suborder: {Detailed.Order.ToString()}"); await ExecuteRefresh(); break; case CommandType.AddSKU: if (Detailed.Order.SubOrderName == null) { Detailed.Order.SubOrderName = Detailed.Order.SubOrderID.ToString(); } Detailed.Order.SubOrderERPID = Detailed.Order.SubOrderID; _dbservicewms.AddSKU(Detailed.Order); orderid = Detailed.OrderID; suborderid = Detailed.SubOrderID; skuid = Detailed.SKUID; _dbservicewms.AddLog(_accessUser, EnumLogWMS.Event, "UI", $"Add SKU: {Detailed.Order.ToString()}"); await ExecuteRefresh(); SelectedSubOrder = DataListSubOrder.FirstOrDefault(p => p.OrderID == orderid && p.SubOrderID == suborderid); SelectedSKU = DataListSKU.FirstOrDefault(p => p.OrderID == orderid && p.SubOrderID == suborderid && p.SKUID == skuid); break; case CommandType.EditSKU: Detailed.Order.SubOrderERPID = Detailed.Order.SubOrderID; _dbservicewms.UpdateSKU(Detailed.Order); SelectedSKU.SKUID = Detailed.SKUID; SelectedSKU.SKUBatch = Detailed.SKUBatch; SelectedSKU.SKUQty = Detailed.SKUQty; _dbservicewms.AddLog(_accessUser, EnumLogWMS.Event, "UI", $"Edit SKU: {Detailed.Order.ToString()}"); break; case CommandType.DeleteSKU: _dbservicewms.DeleteSKU(Detailed.Order); _dbservicewms.AddLog(_accessUser, EnumLogWMS.Event, "UI", $"Delete SKU: {Detailed.Order.ToString()}"); await ExecuteRefresh(); break; default: break; } if (Detailed != null) { Detailed.EnableOrderEdit = false; Detailed.EnableSubOrderEdit = false; Detailed.EnableSKUEdit = false; Detailed.ValidationEnabled = false; } } catch (Exception e) { _warehouse.AddEvent(Event.EnumSeverity.Error, Event.EnumType.Exception, e.Message); } } catch (Exception e) { _warehouse.AddEvent(Database.Event.EnumSeverity.Error, Database.Event.EnumType.Exception, string.Format("{0}.{1}: {2}", this.GetType().Name, (new StackTrace()).GetFrame(0).GetMethod().Name, e.Message)); } }