public int Upd_ESurveyApp(T_OA_REQUIRE info) { try { EmployeeSurveyViewDal employeeSurveyViewDal = new EmployeeSurveyViewDal(); return(employeeSurveyViewDal.Upd_ESurveyApp(info)); } catch (Exception ex) { Tracer.Debug("调查申请EmployeeSurveyViewBll-Upd_ESurveyApp" + System.DateTime.Now.ToString() + " " + ex.ToString()); return(-1); } }
/// <summary> /// 增加员工调查申请表 /// </summary> /// <param name="userID"></param> /// <param name="postID"></param> /// <param name="companyID"></param> /// <param name="departmentID"></param> /// <returns></returns> public bool EmployeeSurveyAppAdd(T_OA_REQUIRE key) { using (EmployeeSurveyViewDal appDal = new EmployeeSurveyViewDal()) { if ((appDal != null) && (appDal.Add_ESurveyApp(key) == 1)) { return(true); } else { return(false); } } }
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); }
//更新方案 新 public int Upd_ESurvey(T_OA_REQUIREMASTER survey, List <V_EmployeeSurveySubject> addLst, List <V_EmployeeSurveySubject> updLst) { try { //masterBll.BeginTransaction(); //更新方案 EmployeeSurveyViewDal esvDal = new EmployeeSurveyViewDal(); if (esvDal.UpdateRequireMaster(survey) == -1) { masterBll.RollbackTransaction(); return(-1); } foreach (V_EmployeeSurveySubject i in addLst) { //添加 题目 答案 if (subjectViewBll.AddEmployeeSurveySubjectView(i) < 1) { masterBll.RollbackTransaction(); return(-1); } } foreach (V_EmployeeSurveySubject i in updLst) { //更新题目 if (esvDal.UpdateSurveySubject(i.SubjectInfo) < 1) { masterBll.RollbackTransaction(); return(-1); } //更新答案 if (UpdataAnswerList(i.SubjectInfo, i.AnswerList.ToList()) < 1) { masterBll.RollbackTransaction(); return(-1); } } masterBll.CommitTransaction(); return(1); } catch (Exception ex) { Tracer.Debug("调查方案EmployeeSurveyViewBll-Upd_ESurvey" + System.DateTime.Now.ToString() + " " + ex.ToString()); return(-1); } }
public int AddEmployeeSurveysView(V_EmployeeSurvey employeeSurveyView) { try { using (EmployeeSurveyViewDal employeeSurveyViewDal = new EmployeeSurveyViewDal()) { if (employeeSurveyViewDal.AddEmployeeSurveyView(employeeSurveyView) == -1) { return(-1); } return(1); } } catch (Exception ex) { Tracer.Debug("调查方案EmployeeSurveyViewBll-AddEmployeeSurveysView" + System.DateTime.Now.ToString() + " " + ex.ToString()); return(-1); } }
//参与调查时用 ||平台审核进入时用 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); }
//EmployeeSurveyViewDal esvDal = new EmployeeSurveyViewDal(); //更新方案 旧 public int UpdateEmployeeSurveyView(V_EmployeeSurvey infoView) { try { EmployeeSurveyViewDal esvDal = new EmployeeSurveyViewDal(); masterBll.BeginTransaction(); if (esvDal.UpdateRequireMaster(infoView.RequireMaster) == -1) { masterBll.RollbackTransaction(); return(-1); } //题目 添加、更新 List <V_EmployeeSurveySubject> subjectViewList = GetSubjectViewListByMasterID(infoView.RequireMaster.REQUIREMASTERID).ToList(); //////删除 IEnumerable <V_EmployeeSurveySubject> lstsub = infoView.SubjectViewList; foreach (V_EmployeeSurveySubject i in lstsub) { bool isAdd = true; foreach (V_EmployeeSurveySubject v in subjectViewList) { if (i.SubjectInfo.REQUIREDETAIL2ID == v.SubjectInfo.REQUIREDETAIL2ID) { isAdd = false; } break; } if (isAdd) { //添加 题目 答案 if (subjectViewBll.AddEmployeeSurveySubjectView(i) < 1) { masterBll.RollbackTransaction(); return(-1); } } else { //更新题目 if (esvDal.UpdateSurveySubject(i.SubjectInfo) < 1) { masterBll.RollbackTransaction(); return(-1); } //更新答案 if (UpdataAnswerList(i.SubjectInfo, i.AnswerList.ToList()) < 1) { masterBll.RollbackTransaction(); return(-1); } } } masterBll.CommitTransaction(); return(1); } catch (Exception ex) { Tracer.Debug("调查方案EmployeeSurveyViewBll-UpdateEmployeeSurveyView" + System.DateTime.Now.ToString() + " " + ex.ToString()); return(-1); } }