コード例 #1
0
        public IQueryable <V_EmployeeSurveySubject> GetSubjectViewListByMasterID(string masterId)
        {
            EmployeeSurveyViewDal employeeSurveyViewDal = new EmployeeSurveyViewDal();
            var s = from subject in employeeSurveyViewDal.GetSubjectList()
                    where subject.REQUIREMASTERID == masterId
                    join ans in employeeSurveyViewDal.GetAnswerList() on new { subject.REQUIREMASTERID, subject.SUBJECTID } equals new { ans.REQUIREMASTERID, ans.SUBJECTID } into answer
                select new V_EmployeeSurveySubject {
                SubjectInfo = subject, AnswerList = answer
            };

            if (s.Count() > 0)
            {
                return(s);
            }
            return(null);
        }
コード例 #2
0
        //参与调查时用 ||平台审核进入时用
        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);
        }
コード例 #3
0
        //审核通过的调查方案
        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);
        }