public void UpdateMOHeaderTag(MOTag MT) { MOTagHeader _MOTagHeader = new MOTagHeader(); _MOTagHeader = MOTag2Entity(MT); _moTagHeaderLogic.Update(_MOTagHeader); }
public int CreateMOHeaderTag(MOTag MT) { Ticket _ticket = new Ticket(); MOTagHeader _moTagHeader = new MOTagHeader(); cat_TicketType cat = (cat_TicketType)_cat_TicketTypeLogic.ReadbyName(new cat_TicketType("MOTagHeader")).Result; int counter = GetLastCounter(); _ticket.cat_TicketTypeKey = cat.id; _ticket.InventoryEventKey = ActiveEventId; _ticket.TicketCounter = counter + 1; //_ticket.TicketCounter = MT.Counter; _moTagHeader.Planner = MT.Planner; _moTagHeader.MO = MT.MO; _moTagHeader.MO_Ln = MT.MO_Ln; _moTagHeader.MO_Status = MT.MO_Status; _moTagHeader.Order_Qty = MT.Order_Qty; _moTagHeader.Recv_Qty = MT.Recv_Qty; _moTagHeader.LineType = MT.LineType; _moTagHeader.FG_Qty_in_WIP = 0; _moTagHeader.Parent_Item_NO = MT.Parent_Item_NO; _moTagHeader.Parent_Item_Desc = MT.Parent_Item_Desc; _moTagHeader.Parent_ItemRef1 = MT.Parent_ItemRef1; _ticket.MOTagHeaders.Add(_moTagHeader); _ticket = (Ticket)(_ticketLogic.Create(_ticket).Result as Ticket); return(_ticket.TicketCounter); }
/// <summary> /// Converts a MOTag to a EF MOTagHeader Enttity /// </summary> /// <param name="MOT"></param> /// <returns></returns> private MOTagHeader MOTag2Entity(MOTag MOT) { Ticket T = new Ticket(); T = (Ticket)_ticketLogic.ReadbyId(MOT.TicketID).Result; MOTagHeader _MOtag = new MOTagHeader(); _MOtag.Ticket = T; _MOtag.Ticket.TicketCounter = MOT.Counter; _MOtag.Planner = MOT.Planner; _MOtag.MO = MOT.MO; _MOtag.MO_Ln = MOT.MO_Ln; _MOtag.MO_Status = MOT.MO_Status; _MOtag.LineType = MOT.LineType; _MOtag.Order_Qty = (int)MOT.Order_Qty; _MOtag.Recv_Qty = (int)MOT.Recv_Qty; _MOtag.FG_Qty_in_WIP = MOT.FGinWip; _MOtag.Parent_Item_NO = MOT.Parent_Item_NO; _MOtag.Parent_Item_Desc = MOT.Parent_Item_Desc; _MOtag.Parent_ItemRef1 = MOT.Parent_ItemRef1; _MOtag.CountedDate = MOT.CountedDate; _MOtag.CounterInitials = MOT.CounterInitials; _MOtag.TicketKey = MOT.TicketID; _MOtag.MOTagHeaderKey = MOT.MOTagID; return(_MOtag); }
/// <summary> /// Converts a MOTagHeader enttity from EF to a MOTag /// </summary> /// <param name="MOT"></param> /// <returns></returns> private MOTag Entity2MOTag(MOTagHeader MOT) { MOTag _MOtag = new MOTag(); Ticket _t = (Ticket)_ticketLogic.ReadbyId(MOT.TicketKey).Result; _MOtag.Counter = _t.TicketCounter; _MOtag.Planner = MOT.Planner; _MOtag.MO = MOT.MO; _MOtag.MO_Ln = MOT.MO_Ln; _MOtag.MO_Status = MOT.MO_Status; _MOtag.LineType = MOT.LineType; _MOtag.Order_Qty = (int)MOT.Order_Qty; _MOtag.Recv_Qty = (int)MOT.Recv_Qty; _MOtag.FGinWip = (int)MOT.FG_Qty_in_WIP; _MOtag.Parent_Item_NO = MOT.Parent_Item_NO; _MOtag.Parent_Item_Desc = MOT.Parent_Item_Desc; _MOtag.Parent_ItemRef1 = MOT.Parent_ItemRef1; _MOtag.CountedDate = MOT.CountedDate; _MOtag.CounterInitials = MOT.CounterInitials; _MOtag.MOTagID = MOT.MOTagHeaderKey; _MOtag.TicketID = MOT.TicketKey; return(_MOtag); }
public DataTable MOTagHeaders2Table() { DataTable _MTDT = new DataTable(); //-----------HEADER--------------------// _MTDT.Columns.Add("Counter", typeof(int)); _MTDT.Columns.Add("Planner", typeof(string)); _MTDT.Columns.Add("MO", typeof(string)); _MTDT.Columns.Add("MO_Ln", typeof(string)); _MTDT.Columns.Add("MO_Status", typeof(string)); _MTDT.Columns.Add("Order_Qty", typeof(int)); _MTDT.Columns.Add("Recv_Qty", typeof(int)); _MTDT.Columns.Add("LineType", typeof(string)); _MTDT.Columns.Add("FGinWip", typeof(int)); //-----------TITTLE--------------------// _MTDT.Columns.Add("Parent_Item_NO", typeof(string)); _MTDT.Columns.Add("Parent_Item_Desc", typeof(string)); _MTDT.Columns.Add("Parent_ItemRef1", typeof(string)); //-----------FOOTER--------------------// _MTDT.Columns.Add("CounterInitials", typeof(string)); _MTDT.Columns.Add("CountedDate", typeof(DateTime)); //-----------Keys----------------------// _MTDT.Columns.Add("MOTagKey", typeof(int)); _MTDT.Columns.Add("TicketID", typeof(int)); List <MOTagHeader> _MOList = _moTagHeaderLogic.ReadAll(); MOTag _MT = new MOTag(); for (int i = 0; i < _MOList.Count; i++) { _MT = Entity2MOTag(_MOList[i]); _MTDT.Rows.Add(_MT.Counter , _MT.Planner , _MT.MO , _MT.MO_Ln , _MT.MO_Status , _MT.Order_Qty , _MT.Recv_Qty , _MT.LineType , _MT.FGinWip , _MT.Parent_Item_NO , _MT.Parent_Item_Desc , _MT.Parent_Item_NO , _MT.CounterInitials , _MT.CountedDate , _MT.MOTagID , _MT.TicketID); } return(_MTDT); }
public MOTag LoadMOHeaderTag(int Counter) { MOTag _MOTag = new MOTag(); MOTagHeader _MOTagHeader = new MOTagHeader(); Ticket _Ticket = new Ticket(); _Ticket = (Ticket)_ticketLogic.ReadbyName(Counter, ActiveEventId).Result; //List< MOTagHeader> _MOTags= _Ticket.MOTagHeaders; _MOTagHeader.Ticket = _Ticket; _MOTagHeader = (MOTagHeader)_moTagHeaderLogic.ReadByCounter(Counter, ActiveEventId).Result; _MOTag = Entity2MOTag(_MOTagHeader); return(_MOTag); }
public static MOTag DataRow2MOTag(DataRow r) { MOTag _MOtag = new MOTag(); //_MOtag.Counter = Convert.ToInt32(r["Counter"].ToString()); _MOtag.Planner = r["Planner"].ToString(); _MOtag.MO = r["MONumber"].ToString(); _MOtag.MO_Ln = r["MOLineNumberString"].ToString(); _MOtag.MO_Status = r["MOLineStatus"].ToString(); _MOtag.LineType = r["MOLineType"].ToString(); _MOtag.Order_Qty = Convert.ToInt32(r["ItemOrderedQuantity"].ToString()); _MOtag.Recv_Qty = Convert.ToInt32(r["ReceiptQuantity"].ToString()); _MOtag.Parent_Item_NO = r["ItemNumber"].ToString(); _MOtag.Parent_Item_Desc = r["ItemDescription"].ToString(); _MOtag.Parent_ItemRef1 = r["ItemReference1"].ToString(); return(_MOtag); }