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