public bool AddEmployeeSurveyQuestion(T_OA_REQUIREDETAIL2 addId) { using (EmployeeSurveySubjectBll questionBll = new EmployeeSurveySubjectBll()) { return(questionBll.AddEmployeeSurveySubject(addId)); } }
public bool DeleteEmpSurveys(List <T_OA_REQUIREMASTER> objList) { using (EmployeeSurveysMasterBll empSurveysCreateBll = new EmployeeSurveysMasterBll()) { using (EmployeeSurveysAnswerBll empSurveysAnswerBll = new EmployeeSurveysAnswerBll()) { using (EmployeeSurveySubjectBll empSurveysSubjectBll = new EmployeeSurveySubjectBll()) { empSurveysCreateBll.BeginTransaction(); try { bool isSccess = true; foreach (T_OA_REQUIREMASTER obj in objList) { if (empSurveysCreateBll.Delete(obj.REQUIREMASTERID)) { //删除题目和答案 IQueryable <T_OA_REQUIREDETAIL2> objDetail2List = empSurveysSubjectBll.GetInfoListByMasterId(obj.REQUIREMASTERID); if (objDetail2List != null) { foreach (T_OA_REQUIREDETAIL2 objDetail2 in objDetail2List) { IQueryable <T_OA_REQUIREDETAIL> detailList = empSurveysAnswerBll.GetInfoListByMasterId(objDetail2.REQUIREMASTERID, objDetail2.SUBJECTID); if (detailList != null) { foreach (T_OA_REQUIREDETAIL objDetail in detailList) { if (empSurveysAnswerBll.DeleteEmployeeSurveysAnswer(objDetail.REQUIREDETAILID)) { } else { return(false); } } } } } } } if (isSccess) { empSurveysCreateBll.CommitTransaction(); return(true); } else { empSurveysCreateBll.RollbackTransaction(); return(false); } } catch { empSurveysCreateBll.RollbackTransaction(); return(false); } } } } }
public int AddEmpSurveysSubject(T_OA_REQUIREDETAIL2 obj) { using (EmployeeSurveySubjectBll empSurveysSubjectBll = new EmployeeSurveySubjectBll()) { int n = empSurveysSubjectBll.Add(obj) ? 1 : 0; return(n); } }
public bool AddEmployeeSurveyQuestion(T_OA_REQUIREDETAIL2 addId) { using (EmployeeSurveySubjectBll questionBll = new EmployeeSurveySubjectBll()) { return questionBll.AddEmployeeSurveySubject(addId); } }
public int DelEmpSurveysSubject(T_OA_REQUIREDETAIL2 obj) { using (EmployeeSurveySubjectBll empSurveysSubjectBll = new EmployeeSurveySubjectBll()) { if (!empSurveysSubjectBll.DeleteEmployeeSurveySubject(obj.REQUIREDETAIL2ID)) { return(-1); } return(1); } }
public int UpdateEmpSurveysSubject(T_OA_REQUIREDETAIL2 objSubject) { using (EmployeeSurveySubjectBll empSurveysSubjectBll = new EmployeeSurveySubjectBll()) { //事物 if (empSurveysSubjectBll.UpdateEmployeeSurveySubject(objSubject) != 1) { return(-1); } return(1); } }
public int AddEmpSurveysSubjectList(List <T_OA_REQUIREDETAIL2> objList) { using (EmployeeSurveySubjectBll empSurveysSubjectBll = new EmployeeSurveySubjectBll()) { //事物 int n = 0; foreach (T_OA_REQUIREDETAIL2 obj in objList) { n += empSurveysSubjectBll.Add(obj) ? 1 : 0; } return(n); } }
public List <T_OA_REQUIREDETAIL2> GetEmpSurveysSubjectList(string requireId) { using (EmployeeSurveySubjectBll empSurveysSubjectBll = new EmployeeSurveySubjectBll()) { IQueryable <T_OA_REQUIREDETAIL2> detailList = empSurveysSubjectBll.GetInfoListByMasterId(requireId); if (detailList != null) { return(detailList.ToList()); } else { return(null); } } }
public int Save_SubjectAnswer(List <V_EmployeeSurveySubject> lstAdd, List <V_EmployeeSurveySubject> lstUpd) { using (EmployeeSurveySubjectBll empSurveysSubjectBll = new EmployeeSurveySubjectBll()) { //事物 int n = 0; foreach (V_EmployeeSurveySubject i in lstAdd) { n += empSurveysSubjectBll.Add(i.SubjectInfo) ? 1 : 0; } foreach (V_EmployeeSurveySubject i in lstAdd) { n += empSurveysSubjectBll.UpdateEmployeeSurveySubject(i.SubjectInfo); } return(n); } }
public int UpdateEmpSurveysSubjectList(List <T_OA_REQUIREDETAIL2> objList) { using (EmployeeSurveySubjectBll empSurveysSubjectBll = new EmployeeSurveySubjectBll()) { //事物 int nRet = 0; foreach (T_OA_REQUIREDETAIL2 obj in objList) { nRet = empSurveysSubjectBll.UpdateEmployeeSurveySubject(obj); } if (nRet == -1)//没有修改也成功 { return(-1); } return(1); } }
public V_EmployeeSurveySubject GetInfoByTitle(string masterTitle) { V_EmployeeSurveySubject listAll = new V_EmployeeSurveySubject(); string masterId=listAll.Master.REQUIREMASTERID; using (EmployeeSurveysMasterBll masterBll = new EmployeeSurveysMasterBll()) { IQueryable<T_OA_REQUIREMASTER> masterList = masterBll.GetInfoListByTitle(masterTitle); if (masterList == null) { return null; } else { listAll.Master=masterList.ToList()[0]; } } using (EmployeeSurveySubjectBll questionBll = new EmployeeSurveySubjectBll()) { IQueryable<T_OA_REQUIREDETAIL2> questionList = questionBll.GetInfoListByMasterId(masterId); if (questionList == null) { return null; } else { listAll.Question = questionList.ToList()[0]; } } using(EmployeeSurveysAnswerBll answerBll=new EmployeeSurveysAnswerBll()) { IQueryable<T_OA_REQUIREDETAIL> answerList =answerBll.GetInfoByMasterId(masterId); if(answerList==null) { return null; } else { listAll.Answer=answerList.ToList()[0]; } } return listAll; }
public V_EmployeeSurveySubject GetInfoByTitle(string masterTitle) { V_EmployeeSurveySubject listAll = new V_EmployeeSurveySubject(); string masterId = listAll.Master.REQUIREMASTERID; using (EmployeeSurveysMasterBll masterBll = new EmployeeSurveysMasterBll()) { IQueryable <T_OA_REQUIREMASTER> masterList = masterBll.GetInfoListByTitle(masterTitle); if (masterList == null) { return(null); } else { listAll.Master = masterList.ToList()[0]; } } using (EmployeeSurveySubjectBll questionBll = new EmployeeSurveySubjectBll()) { IQueryable <T_OA_REQUIREDETAIL2> questionList = questionBll.GetInfoListByMasterId(masterId); if (questionList == null) { return(null); } else { listAll.Question = questionList.ToList()[0]; } } using (EmployeeSurveysAnswerBll answerBll = new EmployeeSurveysAnswerBll()) { IQueryable <T_OA_REQUIREDETAIL> answerList = answerBll.GetInfoByMasterId(masterId); if (answerList == null) { return(null); } else { listAll.Answer = answerList.ToList()[0]; } } return(listAll); }
public int DelEmpSurveysSubjectList(List <T_OA_REQUIREDETAIL2> objList) { using (EmployeeSurveysAnswerBll empSurveysAnswerBll = new EmployeeSurveysAnswerBll()) { using (EmployeeSurveySubjectBll empSurveysSubjectBll = new EmployeeSurveySubjectBll()) { //事务 bool sucess = true; foreach (T_OA_REQUIREDETAIL2 obj in objList) { if (empSurveysSubjectBll.DeleteEmployeeSurveySubject(obj.REQUIREDETAIL2ID)) { IQueryable <T_OA_REQUIREDETAIL> detailList = empSurveysAnswerBll.GetInfoListByMasterId(obj.REQUIREMASTERID, obj.SUBJECTID); if (detailList != null) { foreach (T_OA_REQUIREDETAIL objDetail in detailList) { if (empSurveysAnswerBll.DeleteEmployeeSurveysAnswer(objDetail.REQUIREDETAILID)) { } else { sucess = false; break; } } } if (sucess == false) { return(-1); } } else { return(-1); } } return(1); } } }
public int UpdateEmpSurveysSubjectList(List<T_OA_REQUIREDETAIL2> objList) { using (EmployeeSurveySubjectBll empSurveysSubjectBll = new EmployeeSurveySubjectBll()) { //事物 int nRet = 0; foreach (T_OA_REQUIREDETAIL2 obj in objList) { nRet = empSurveysSubjectBll.UpdateEmployeeSurveySubject(obj); } if (nRet == -1)//没有修改也成功 { return -1; } return 1; } }
public int UpdateEmpSurveysSubject(T_OA_REQUIREDETAIL2 objSubject) { using (EmployeeSurveySubjectBll empSurveysSubjectBll = new EmployeeSurveySubjectBll()) { //事物 if (empSurveysSubjectBll.UpdateEmployeeSurveySubject(objSubject) != 1) { return -1; } return 1; } }
public int DelEmpSurveysSubjectList(List<T_OA_REQUIREDETAIL2> objList) { using (EmployeeSurveysAnswerBll empSurveysAnswerBll = new EmployeeSurveysAnswerBll()) { using (EmployeeSurveySubjectBll empSurveysSubjectBll = new EmployeeSurveySubjectBll()) { //事务 bool sucess = true; foreach (T_OA_REQUIREDETAIL2 obj in objList) { if (empSurveysSubjectBll.DeleteEmployeeSurveySubject(obj.REQUIREDETAIL2ID)) { IQueryable<T_OA_REQUIREDETAIL> detailList = empSurveysAnswerBll.GetInfoListByMasterId(obj.REQUIREMASTERID, obj.SUBJECTID); if (detailList != null) { foreach (T_OA_REQUIREDETAIL objDetail in detailList) { if (empSurveysAnswerBll.DeleteEmployeeSurveysAnswer(objDetail.REQUIREDETAILID)) { } else { sucess = false; break; } } } if (sucess == false) { return -1; } } else { return -1; } } return 1; } } }
public int Save_SubjectAnswer(List<V_EmployeeSurveySubject> lstAdd,List<V_EmployeeSurveySubject> lstUpd) { using (EmployeeSurveySubjectBll empSurveysSubjectBll = new EmployeeSurveySubjectBll()) { //事物 int n = 0; foreach (V_EmployeeSurveySubject i in lstAdd) n += empSurveysSubjectBll.Add(i.SubjectInfo) ? 1 : 0; foreach (V_EmployeeSurveySubject i in lstAdd) n += empSurveysSubjectBll.UpdateEmployeeSurveySubject(i.SubjectInfo); return n; } }
public int AddEmpSurveysSubjectList(List<T_OA_REQUIREDETAIL2> objList) { using (EmployeeSurveySubjectBll empSurveysSubjectBll = new EmployeeSurveySubjectBll()) { //事物 int n = 0; foreach (T_OA_REQUIREDETAIL2 obj in objList) n += empSurveysSubjectBll.Add(obj) ? 1 : 0; return n; } }
public int AddEmpSurveysSubject(T_OA_REQUIREDETAIL2 obj) { using (EmployeeSurveySubjectBll empSurveysSubjectBll = new EmployeeSurveySubjectBll()) { int n = empSurveysSubjectBll.Add(obj) ? 1 : 0; return n; } }
public int DelEmpSurveysSubject(T_OA_REQUIREDETAIL2 obj) { using (EmployeeSurveySubjectBll empSurveysSubjectBll = new EmployeeSurveySubjectBll()) { if (!empSurveysSubjectBll.DeleteEmployeeSurveySubject(obj.REQUIREDETAIL2ID)) { return -1; } return 1; } }
public List<T_OA_REQUIREDETAIL2> GetEmpSurveysSubjectList(string requireId) { using (EmployeeSurveySubjectBll empSurveysSubjectBll = new EmployeeSurveySubjectBll()) { IQueryable<T_OA_REQUIREDETAIL2> detailList = empSurveysSubjectBll.GetInfoListByMasterId(requireId); if (detailList != null) { return detailList.ToList(); } else { return null; } } }
public bool DeleteEmpSurveys(List<T_OA_REQUIREMASTER> objList) { using (EmployeeSurveysMasterBll empSurveysCreateBll = new EmployeeSurveysMasterBll()) { using (EmployeeSurveysAnswerBll empSurveysAnswerBll = new EmployeeSurveysAnswerBll()) { using (EmployeeSurveySubjectBll empSurveysSubjectBll = new EmployeeSurveySubjectBll()) { empSurveysCreateBll.BeginTransaction(); try { bool isSccess = true; foreach (T_OA_REQUIREMASTER obj in objList) { if (empSurveysCreateBll.Delete(obj.REQUIREMASTERID)) { //删除题目和答案 IQueryable<T_OA_REQUIREDETAIL2> objDetail2List = empSurveysSubjectBll.GetInfoListByMasterId(obj.REQUIREMASTERID); if (objDetail2List != null) { foreach (T_OA_REQUIREDETAIL2 objDetail2 in objDetail2List) { IQueryable<T_OA_REQUIREDETAIL> detailList = empSurveysAnswerBll.GetInfoListByMasterId(objDetail2.REQUIREMASTERID, objDetail2.SUBJECTID); if (detailList != null) { foreach (T_OA_REQUIREDETAIL objDetail in detailList) { if (empSurveysAnswerBll.DeleteEmployeeSurveysAnswer(objDetail.REQUIREDETAILID)) { } else { return false; } } } } } } } if (isSccess) { empSurveysCreateBll.CommitTransaction(); return true; } else { empSurveysCreateBll.RollbackTransaction(); return false; } } catch { empSurveysCreateBll.RollbackTransaction(); return false; } } } } }