//[Transaction(TransactionMode.Requires)]
private void ProcessHuOut(ScmsTableIndex scmsTableIndex)
{
IList <Hu> huList = GetTransferHu();
if (huList != null && huList.Count > 0)
{
foreach (Hu hu in huList)
{
try
{
ScmsMaterialBarcode materialBarcode = scmsMaterialBarcodeMgr.LoadScmsMaterialBarcode(hu.HuId);
if (materialBarcode == null)
{
materialBarcode = new ScmsMaterialBarcode();
materialBarcode.Flag = MesDssConstants.SCMS_MES_FLAG_SCMS_UPDATED;
materialBarcode.HuId = hu.HuId;
materialBarcode.ItemCode = hu.Item.Code;
materialBarcode.ItemDesc = hu.Item.Desc1;
materialBarcode.Qty = Convert.ToInt32(hu.Qty);
scmsMaterialBarcodeMgr.CreateScmsMaterialBarcode(materialBarcode);
}
hu.TransferFlag = false;
huMgr.UpdateHu(hu);
}
catch (Exception e)
{
log.Error(hu.HuId + " create exception", e);
continue;
}
}
}
scmsTableIndexMgr.Complete(scmsTableIndex);
}
public void ProcessOut(ScmsTableIndex scmsTableIndex)
{
if (scmsTableIndex.TableName.Trim().ToUpper() == BusinessConstants.DSS_OUT_HU)
{
log.Debug("start process hu.");
this.ProcessHuOut(scmsTableIndex);
log.Debug("end process hu.");
}
else if (scmsTableIndex.TableName.Trim().ToUpper() == BusinessConstants.DSS_OUT_ITEM)
{
log.Debug("start process item.");
this.ProcessItemOut(scmsTableIndex);
log.Debug("end process item.");
}
else if (scmsTableIndex.TableName.Trim().ToUpper() == BusinessConstants.DSS_OUT_ORDERDETAIL)
{
log.Debug("start process OrderDetail.");
this.ProcessOrderDetailOut(scmsTableIndex);
log.Debug("end process OrderDetail.");
}
else if (scmsTableIndex.TableName.Trim().ToUpper() == BusinessConstants.DSS_OUT_MESBOMDETAIL)
{
log.Debug("start process MesBomDetail.");
this.ProcessMesBomDetailOut(scmsTableIndex);
log.Debug("end process MesBomDetail.");
}
}
private void ProcessMesBomDetailOut(ScmsTableIndex scmsTableIndex)
{
IList <MesBom> bomList = GetTransferBom();
if (bomList != null && bomList.Count > 0)
{
foreach (MesBom mesBom in bomList)
{
try
{
IList <MesBomDetail> scmsBomDetailList = mesBomDetailMgr.GetBomDetailList(mesBom);
if (scmsBomDetailList != null && scmsBomDetailList.Count > 0)
{
foreach (MesBomDetail mesBomDetail in scmsBomDetailList)
{
ScmsBom scmsBom = scmsBomMgr.LoadScmsBom(mesBomDetail.Bom.Code, mesBomDetail.Item.Code);
if (scmsBom == null)
{
scmsBom = new ScmsBom();
scmsBom.Bom = mesBomDetail.Bom.Code;
scmsBom.Flag = mesBomDetail.IsActive ? MesDssConstants.SCMS_MES_FLAG_SCMS_UPDATED : MesDssConstants.SCMS_MES_FLAG_SCMS_DELETE;
scmsBom.ItemCode = mesBomDetail.Item.Code;
scmsBom.LastModifyDate = DateTime.Now;
scmsBom.LastModifyUser = userMgr.GetMonitorUser().Code;
scmsBom.Qty = mesBomDetail.RateQty;
scmsBomMgr.CreateScmsBom(scmsBom);
}
else
{
//DJIN 20120817
scmsBom.Flag = mesBomDetail.IsActive || !mesBomDetail.EndDate.HasValue ? MesDssConstants.SCMS_MES_FLAG_SCMS_UPDATED : MesDssConstants.SCMS_MES_FLAG_SCMS_DELETE;
scmsBom.LastModifyDate = DateTime.Now;
scmsBom.LastModifyUser = userMgr.GetMonitorUser().Code;
scmsBom.Qty = mesBomDetail.RateQty;
scmsBomMgr.UpdateScmsBom(scmsBom);
}
}
}
mesBom.TransferFlag = false;
mesBomMgr.UpdateBom(mesBom);
}
catch (Exception e)
{
log.Error(mesBom.Code + " create exception", e);
continue;
}
}
}
scmsTableIndexMgr.Complete(scmsTableIndex);
}
//[Transaction(TransactionMode.Requires)]
private void ProcessItemOut(ScmsTableIndex scmsTableIndex)
{
IList <Item> itemList = GetTransferItem();
if (itemList != null && itemList.Count > 0)
{
foreach (Item item in itemList)
{
try
{
ScmsPart scmsPart = scmsPartMgr.LoadScmsPart(item.Code);
if (scmsPart == null)
{
scmsPart = new ScmsPart();
scmsPart.Code = item.Code;
scmsPart.Des = item.Description;
scmsPart.Uom = item.Uom.Code;
scmsPart.LastModifyDate = item.LastModifyDate;
scmsPart.LastModifyUser = item.LastModifyUser.Code;
scmsPart.Flag = MesDssConstants.SCMS_MES_FLAG_SCMS_UPDATED;
scmsPartMgr.CreateScmsPart(scmsPart);
}
else
{
scmsPart.Des = item.Description;
scmsPart.Uom = item.Uom.Code;
scmsPart.LastModifyDate = item.LastModifyDate;
scmsPart.LastModifyUser = item.LastModifyUser.Code;
scmsPart.Flag = MesDssConstants.SCMS_MES_FLAG_SCMS_UPDATED;
scmsPartMgr.UpdateScmsPart(scmsPart);
}
item.TransferFlag = false;
itemMgr.UpdateItem(item);
}
catch (Exception e)
{
log.Error(item.Code + " create exception", e);
continue;
}
}
}
scmsTableIndexMgr.Complete(scmsTableIndex);
}
public void UpdateScmsTableIndex(string tableName, DateTime lastModifyDate)
{
ScmsTableIndex scmsTableIndex = this.LoadScmsTableIndex(tableName);
if (scmsTableIndex == null)
{
log.Error("tableName[" + tableName + "] is not found");
}
else
{
if (scmsTableIndex.Flag == MesDssConstants.SCMS_TABLEINDEX_FLAG_FTPC_UPDATING)
{
//表示更新中
log.Error("tableName[" + tableName + "] is updating " + lastModifyDate.ToString());
}
else
{
scmsTableIndex.Flag = MesDssConstants.SCMS_TABLEINDEX_FLAG_SCMS_UPDATED;
scmsTableIndex.LastModifyDate = lastModifyDate;
this.UpdateScmsTableIndex(scmsTableIndex);
}
}
}
//[Transaction(TransactionMode.Requires)]
private void ProcessOrderDetailOut(ScmsTableIndex scmsTableIndex)
{
IList <OrderDetail> orderDetailList = GetTransferOrderDetail();
if (orderDetailList != null && orderDetailList.Count > 0)
{
foreach (OrderDetail orderDetail in orderDetailList)
{
try
{
ScmsWorkOrder workOrder = scmsWorkOrderMgr.LoadScmsWorkOrder(orderDetail.OrderHead.OrderNo, orderDetail.Item.Code);
ScmsWorkOrderNew newwo = scmsWorkOrderNewMgr.LoadScmsWorkOrder(orderDetail.OrderHead.OrderNo, orderDetail.Item.Code);
ScmsWorkOrderNewKQ kqwo = scmsWorkOrderNewKQMgr.LoadScmsWorkOrder(orderDetail.OrderHead.OrderNo, orderDetail.Item.Code);
if (orderDetail.OrderHead.SubType != "Rwo")//返工工单不许传递 djin 2012-4-28
{
if (workOrder == null)
{
#region SCMS_WO
workOrder = new ScmsWorkOrder();
workOrder.Bom = orderDetail.Bom != null ? orderDetail.Bom.Code : orderDetail.Item.Code;
workOrder.Flag = MesDssConstants.SCMS_MES_FLAG_SCMS_UPDATED;
workOrder.IsAdditional = orderDetail.OrderHead.IsAdditional ? "1" : "0";
workOrder.ItemCode = orderDetail.Item.Code;
workOrder.LastModifyDate = orderDetail.OrderHead.LastModifyDate;
workOrder.LastModifyUser = orderDetail.OrderHead.LastModifyUser.Code;
workOrder.OrderNo = orderDetail.OrderHead.OrderNo;
workOrder.ProductLine = flowMgr.LoadFlow(orderDetail.OrderHead.Flow).Description;
workOrder.Qty = Convert.ToInt32(orderDetail.OrderedQty);
workOrder.RefItemCode = orderDetail.ReferenceItemCode;
workOrder.RefOrderNo = orderDetail.OrderHead.ReferenceOrderNo;
workOrder.Shift = orderDetail.OrderHead.Shift.ShiftName;
workOrder.StartTime = orderDetail.OrderHead.StartTime;
workOrder.UC = Convert.ToInt32(orderDetail.UnitCount);
//workOrder.Version = orderDetail.ItemVersion;
workOrder.WindowTime = orderDetail.OrderHead.WindowTime;
workOrder.ShiftCode = orderDetail.OrderHead.Shift.Code;
scmsWorkOrderMgr.CreateScmsWorkOrder(workOrder);
#endregion
}
if (newwo == null)
{
#region scms_wo_new
newwo = new ScmsWorkOrderNew();
newwo.Bom = orderDetail.Bom.Code;
newwo.Flag = MesDssConstants.SCMS_MES_FLAG_SCMS_UPDATED;
newwo.IsAdditional = orderDetail.OrderHead.IsAdditional ? "1" : "0";
newwo.ItemCode = orderDetail.Item.Code;
newwo.LastModifyDate = orderDetail.OrderHead.LastModifyDate;
newwo.LastModifyUser = orderDetail.OrderHead.LastModifyUser.Code;
newwo.OrderNo = orderDetail.OrderHead.OrderNo;
newwo.ProductLine = flowMgr.LoadFlow(orderDetail.OrderHead.Flow).Description;
newwo.Qty = Convert.ToInt32(orderDetail.OrderedQty);
newwo.RefItemCode = orderDetail.ReferenceItemCode;
newwo.RefOrderNo = orderDetail.OrderHead.ReferenceOrderNo;
newwo.Shift = orderDetail.OrderHead.Shift.ShiftName;
newwo.StartTime = orderDetail.OrderHead.StartTime;
newwo.UC = Convert.ToInt32(orderDetail.UnitCount);
//workOrder.Version = orderDetail.ItemVersion;
newwo.WindowTime = orderDetail.OrderHead.WindowTime;
newwo.ShiftCode = orderDetail.OrderHead.Shift.Code;
scmsWorkOrderNewMgr.CreateScmsWorkOrder(newwo);
#endregion
}
if (kqwo == null)
{
#region scms_wo_kq
kqwo = new ScmsWorkOrderNewKQ();
kqwo.Bom = orderDetail.Bom.Code;
kqwo.Flag = MesDssConstants.SCMS_MES_FLAG_SCMS_UPDATED;
kqwo.IsAdditional = orderDetail.OrderHead.IsAdditional ? "1" : "0";
kqwo.ItemCode = orderDetail.Item.Code;
kqwo.LastModifyDate = orderDetail.OrderHead.LastModifyDate;
kqwo.LastModifyUser = orderDetail.OrderHead.LastModifyUser.Code;
kqwo.OrderNo = orderDetail.OrderHead.OrderNo;
kqwo.ProductLine = flowMgr.LoadFlow(orderDetail.OrderHead.Flow).Description;
kqwo.Qty = Convert.ToInt32(orderDetail.OrderedQty);
kqwo.RefItemCode = orderDetail.ReferenceItemCode;
kqwo.RefOrderNo = orderDetail.OrderHead.ReferenceOrderNo;
kqwo.Shift = orderDetail.OrderHead.Shift.ShiftName;
kqwo.StartTime = orderDetail.OrderHead.StartTime;
kqwo.UC = Convert.ToInt32(orderDetail.UnitCount);
//workOrder.Version = orderDetail.ItemVersion;
kqwo.WindowTime = orderDetail.OrderHead.WindowTime;
kqwo.ShiftCode = orderDetail.OrderHead.Shift.Code;
scmsWorkOrderNewKQMgr.CreateScmsWorkOrder(kqwo);
#endregion
}
orderDetail.TransferFlag = false;
orderDetailMgr.UpdateOrderDetail(orderDetail);
}
}
catch (Exception e)
{
log.Error(orderDetail.OrderHead.OrderNo + "," + orderDetail.Item.Code + " create exception", e);
continue;
}
}
}
ScmsTableIndex newTable = scmsTableIndexMgr.LoadScmsTableIndex("SCMS_WO_NEW");
if (newTable != null)
{
scmsTableIndexMgr.Complete(newTable);
}
ScmsTableIndex kqTable = scmsTableIndexMgr.LoadScmsTableIndex("SCMS_WO_TOSH");
if (kqTable != null)
{
scmsTableIndexMgr.Complete(kqTable);
}
scmsTableIndexMgr.Complete(scmsTableIndex);
}
public virtual void Complete(ScmsTableIndex scmsTableIndex)
{
scmsTableIndex.Flag = MesDssConstants.SCMS_TABLEINDEX_FLAG_SCMS_UPDATED;
scmsTableIndex.LastModifyDate = DateTime.Now;
this.UpdateScmsTableIndex(scmsTableIndex);
}
public virtual void DeleteScmsTableIndex(ScmsTableIndex entity)
{
entityDao.Delete(entity);
}
public virtual void UpdateScmsTableIndex(ScmsTableIndex entity)
{
entityDao.Update(entity);
}
public virtual void CreateScmsTableIndex(ScmsTableIndex entity)
{
entityDao.Create(entity);
}
