public static string TransToWMSStore(string planCode, string resourceStore, string itemCode, string destinationStore, int transQTY) { DB.GetInstance().BeginTransaction(); try { List <PlanBomEntity> planBOMs = PlanBOMFactory.GetByOrderCode(planCode); planBOMs = (from p in planBOMs where p.ITEM_CODE == itemCode && p.LINESIDE_STOCK_CODE == resourceStore select p).ToList <PlanBomEntity>(); List <LineSideStockEntity> all = DB.GetInstance().Fetch <LineSideStockEntity>(""); PlanBomEntity resouece = planBOMs[0]; LineSideStockEntity rsourceStore = LineSideStockFactory.GetStoreItem(resourceStore, itemCode); LineSideStockEntity destination = LineSideStockFactory.GetStoreItem(destinationStore, itemCode); rsourceStore.ITEM_QTY = rsourceStore.ITEM_QTY - transQTY; DB.GetInstance().Update(rsourceStore); IMESLine2LineEntity line2lineEntity = new IMESLine2LineEntity { AUFNR = resouece.ORDER_CODE, WERKS = resouece.FACTORY, VORNR = resouece.PROCESS_CODE, SUBMAT = resouece.ITEM_CODE, MENGE = transQTY.ToString(), TLGORT = destinationStore, SLGORT = resourceStore, PRIND = "0", }; DB.GetInstance().Insert(line2lineEntity); SAPMessageTransEntity msgEntity = new SAPMessageTransEntity { MESSAGE_CODE = "0047", WORK_DATE = DateTime.Now, HANDLE_FLAG = "0", }; DB.GetInstance().Insert(msgEntity); DB.GetInstance().CompleteTransaction(); return("true"); } catch (Exception e) { DB.GetInstance().AbortTransaction(); return(e.Message); } }
public static int Update(PlanBomEntity p) { return(new PlanBOMDal().Update(p)); }
public int Update(PlanBomEntity p) { return(db.Update("DATA_PLAN_BOM", "RMES_ID", p)); }