//参与调查时用 ||平台审核进入时用 public IQueryable <V_EmployeeSurvey> Get_ESurvey(string requireMasterID) { EmployeeSurveyViewDal employeeSurveyViewDal = new EmployeeSurveyViewDal(); var vanswer = (from answ in employeeSurveyViewDal.GetAnswerList() orderby answ.CODE ascending select answ); var m = from master in employeeSurveyViewDal.GetMasterList() join sub in (from subject in employeeSurveyViewDal.GetSubjectList() join ans in vanswer on new { subject.REQUIREMASTERID, subject.SUBJECTID } equals new { ans.REQUIREMASTERID, ans.SUBJECTID } into answer orderby subject.SUBJECTID ascending select new V_EmployeeSurveySubject { SubjectInfo = subject, AnswerList = answer } ) on master.REQUIREMASTERID equals sub.SubjectInfo.REQUIREMASTERID into subject where master.REQUIREMASTERID == requireMasterID select new V_EmployeeSurvey { RequireMaster = master, SubjectViewList = subject }; // m = m.Where(ent => ent.RequireMaster.REQUIREMASTERID == requireMasterID); return(m); }
//审核通过的调查方案 public IQueryable <V_EmployeeSurvey> Get_ESurveyChecked(int pageIndex, int pageSize, string sort, string filterString, object[] paras, ref int pageCount, string userId, List <string> guidStringList, string checkState) { EmployeeSurveyViewDal employeeSurveyViewDal = new EmployeeSurveyViewDal(); DateTime d = DateTime.Parse(paras[0].ToString()).Date; DateTime d2 = DateTime.Parse(paras[1].ToString()).AddDays(1); var m = from master in employeeSurveyViewDal.GetMasterList() join sub in (from subject in employeeSurveyViewDal.GetSubjectList() join ans in (from answ in employeeSurveyViewDal.GetAnswerList() orderby answ.CREATEDATE select answ) on new { subject.REQUIREMASTERID, subject.SUBJECTID } equals new { ans.REQUIREMASTERID, ans.SUBJECTID } into answer select new V_EmployeeSurveySubject { SubjectInfo = subject, AnswerList = answer } ) on master.REQUIREMASTERID equals sub.SubjectInfo.REQUIREMASTERID into subject select new V_EmployeeSurvey { RequireMaster = master, SubjectViewList = subject }; m = m.Where(ent => ent.RequireMaster.CHECKSTATE == checkState && ent.RequireMaster.CREATEDATE >= d && ent.RequireMaster.CREATEDATE < d2); return(m); }