public PositionTransferDetailViewModel GetDetailByID(int?id) { PositionTransferDetailViewModel model = new PositionTransferDetailViewModel(); try { using (SATEntities db = new SATEntities()) { model = db.vw_Move_Man_Power_Detail.Where(x => x.MopID == id).Select(s => new PositionTransferDetailViewModel { MopID = s.MopID, UserID = s.UserID, CurMpID = s.CurMpID, MovMpID = s.MovMpID, AgentMpID = s.AgentMpID, AgentPoTID = s.AgentPoTID, CurrentPo = s.CurPoName, MovePo = s.MovPoName, AgentPo = s.AgentPoName, MovRemark = s.MovRemark }).FirstOrDefault(); } } catch (Exception) { throw; } return(model); }
public List <PositionTransferDetailViewModel> GetDetail(int?id) { var list = new List <PositionTransferDetailViewModel>(); try { using (SATEntities db = new SATEntities()) { int index = 1; var detail = db.vw_Move_Man_Power_Detail.Where(x => x.MopID == id).ToList(); foreach (var item in detail) { PositionTransferDetailViewModel model = new PositionTransferDetailViewModel(); model.RowNumber = index++; model.MopID = item.MopID; model.UserID = item.UserID; model.FullName = item.FullName; model.CurMpID = item.CurMpID; model.CurPoName = item.CurPoName; model.MovMpID = item.MovMpID; model.MovPoName = item.MovPoName; model.AgentPoTID = item.AgentPoTID; model.AgentPoTName = item.AgentPoTName; model.AgentMpID = item.AgentMpID; model.AgentPoName = item.AgentPoName; model.MovRemark = item.MovRemark; model.CurrentPo = "(" + item.CurMpID + ") " + item.CurPoName; model.MovePo = "(" + item.MovMpID + ") " + item.MovPoName; model.AgentPo = "(" + item.AgentMpID + ") " + item.AgentPoName; model.AgentPo = item.AgentPoTName + " (" + item.AgentMpID + ") " + item.AgentPoName; model.BelongTo = item.DivName + " / " + item.DepName + " / " + item.SecName; list.Add(model); } } } catch (Exception) { throw; } return(list); }