public static List <LocationEntity> GetByUserID(string userid, string programcode) { List <ProductLineEntity> _plines = ProductLineFactory.GetByUserID(userid, programcode); List <string> _ps = (from s in _plines select s.RMES_ID).ToList <string>(); return(new LocationDal().FindBySql <LocationEntity>("where pline_code in (@plines)", new { plines = _ps })); }
public static List <PlanTempEntity> GetCurrentUnfinishedPlanByUserID(string userID, string programcode) { UserEntity user = UserFactory.GetByID(userID); List <ProductLineEntity> plines = ProductLineFactory.GetByUserID(userID, programcode); if (plines == null || plines.Count < 1) { return(null); } else { List <string> plineCodes = new List <string>(); foreach (var p in plines) { plineCodes.Add(p.RMES_ID); } return(new PlanTempDal().GetCurrentUnfinishedPlanByPlines(plineCodes.ToArray())); } }