/// <summary> /// 分页查询 /// </summary> /// <param name="query"></param> /// <param name="pageNumber"></param> /// <param name="pageSize"></param> /// <param name="totalNumber"></param> /// <returns></returns> public List <BasePersonRelationshipModel> GetEntities(BasePersonRelationshipQuery query, int pageNumber, int pageSize, out int totalNumber) { PageModel model = new PageModel(); model.pageIndex = pageNumber; model.pageSize = pageSize; List <BasePersonRelationshipModel> list = mapContext.QueryForList <BasePersonRelationshipModel>("PersonRelationshipPage", model).ToList(); totalNumber = list.Count(); return(list.Skip((pageNumber - 1) * pageSize).Take(pageSize).ToList()); }
/// <summary> /// 根据人员id和类型id删除人员类型绑定 /// </summary> /// <param name="query"></param> /// <returns></returns> public int DeletePersonRelationshipByPersonIdAndTypeId(BasePersonRelationshipQuery query) { try { return(mapContext.Delete("DeletePersonRelationshipByPersonIdAndTypeId", query)); } catch (Exception ex) { throw ex; } }
/// <summary> /// 修改人员信息 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool UpdatePersonInfo(PersonInfoCustom model) { try { bool result = true; //修改人员基础信息 ApiPersonInfoModel personModel = new ApiPersonInfoModel(); personModel.PersonID = model.personID; personModel.Name = model.name; personModel.EnName = model.EnName; personModel.Gender = model.Gender; personModel.Nation = model.Nation; personModel.Birthday = model.birthday; personModel.BloodType = model.BloodType; personModel.Religion = model.Religion; personModel.NativePlace = model.nativePlace; personModel.Nationality = model.Nationality; personModel.PoliticalStatus = model.PoliticalStatus; personModel.MarriageStatus = model.MarriageStatus; personModel.IDCard = model.IDCard; personModel.Phone = model.phone; string parStr = JsonHelper.ObjectToString <ApiPersonInfoModel>(personModel); string str = HttpHelper.PostWebRequestBandError("http://" + personIp + "/ApiPersonInfo/UpdatePersonInfo", parStr, "application/json;charset=utf-8", Encoding.UTF8); int result1 = JsonHelper.StringToObject <int>(str); if (result1 == 1) { result = false; } List <BasePersonRelationshipModel> relationList = basePersonRelationshipDAL.GetPersonTypeByPersonId(model.personID); //职工扩展 BasePersonRelationshipModel staffRelation = relationList.FirstOrDefault(n => n.type_id == (int)PersonType.职工); ServStaffInfoModel staffmodel = new ServStaffInfoModel(); staffmodel.person_id = model.personID; staffmodel.org_id = model.org_id; staffmodel.job_grade = model.job_grade; if (model.start_time != "") { staffmodel.start_time = Convert.ToDateTime(model.start_time); } staffmodel.work_num = model.work_num; staffmodel.staff_type = model.staff_type_id; staffmodel.staff_status = model.staff_status_id; if (model.staffFlag == 1) //有职工扩展 { if (staffRelation != null) //修改职工信息 { int num = servStaffInfoDAL.UpdateStaffInfoById(staffmodel); if (num == 0) { result = false; } } else//新增职工扩展 { //新增人员扩展 BasePersonRelationshipModel staffRelation1 = new BasePersonRelationshipModel(); staffRelation1.type_id = (int)PersonType.职工; staffRelation1.person_id = model.personID; int id1 = basePersonRelationshipDAL.AddEntity(staffRelation1); if (id1 == 0) { result = false; } //新增职工信息 int id = servStaffInfoDAL.AddEntity(staffmodel); if (id == 0) { result = false; } } } else//没有职工信息 { if (staffRelation != null)//删除职工信息 { //删除职工关联 BasePersonRelationshipQuery query = new BasePersonRelationshipQuery(); query.person_id = model.personID; query.type_id = (int)PersonType.职工; int num = basePersonRelationshipDAL.DeletePersonRelationshipByPersonIdAndTypeId(query); if (num == 0) { result = false; } //删除职工信息 num = servStaffInfoDAL.DeleteStaffInfoById(model.personID); if (num == 0) { result = false; } } } //教师 BasePersonRelationshipModel teacherRelation = relationList.FirstOrDefault(n => n.type_id == (int)PersonType.教师); ServTeacherInfoModel teacherModel = new ServTeacherInfoModel(); teacherModel.person_id = model.personID; teacherModel.class_id = model.faculty; teacherModel.level = model.level_id; teacherModel.status = model.teach_status_id; if (model.teacherFlag == 1) //有教师扩展 { if (teacherRelation != null) //修改教师扩展 { int num = servTeacherInfoDAL.UpdateTeacherInfoById(teacherModel); if (num == 0) { result = false; } } else//新增教师扩展 { //新增人员教师关联 BasePersonRelationshipModel staffRelation1 = new BasePersonRelationshipModel(); staffRelation1.type_id = (int)PersonType.教师; staffRelation1.person_id = model.personID; int id1 = basePersonRelationshipDAL.AddEntity(staffRelation1); if (id1 == 0) { result = false; } //新增教师信息 int id = servTeacherInfoDAL.AddEntity(teacherModel); if (id == 0) { result = false; } } } else//没有教师扩展 { if (teacherRelation != null)//删除教师扩展 { //删除人员教师关联 BasePersonRelationshipQuery query = new BasePersonRelationshipQuery(); query.person_id = model.personID; query.type_id = (int)PersonType.教师; int num = basePersonRelationshipDAL.DeletePersonRelationshipByPersonIdAndTypeId(query); if (num == 0) { result = false; } //删除教师信息 num = servTeacherInfoDAL.DeleteTeacherInfoById(model.personID); if (num == 0) { result = false; } } } //学生 BasePersonRelationshipModel studentRelation = relationList.FirstOrDefault(n => n.type_id == (int)PersonType.学生); ServStudentInfoModel studentModel = new ServStudentInfoModel(); studentModel.person_id = model.personID; studentModel.student_num = model.student_num; studentModel.student_grade = model.student_grade; studentModel.class_id = model.class_Name; if (model.in_time != "") { studentModel.in_time = Convert.ToDateTime(model.in_time); } studentModel.edu_year = model.edu_year; studentModel.teacher_id = model.teacher_Name; studentModel.staff_id = model.staff_Name; studentModel.student_type = model.student_type_id; studentModel.status = model.studentStatus_id; if (model.studentFlag == 1) //有学生扩展 { if (studentRelation != null) //修改学生扩展 { int num = servStudentInfoDAL.UpdateStudentInfoById(studentModel); if (num == 0) { result = false; } } else//新增学生扩展 { //新增人员学生关联 BasePersonRelationshipModel staffRelation1 = new BasePersonRelationshipModel(); staffRelation1.type_id = (int)PersonType.学生; staffRelation1.person_id = model.personID; int id1 = basePersonRelationshipDAL.AddEntity(staffRelation1); if (id1 == 0) { result = false; } //新增学生信息 int id = servStudentInfoDAL.AddEntity(studentModel); if (id == 0) { result = false; } } } else { if (studentRelation != null)//删除学生扩展 { //删除人员学生关联 BasePersonRelationshipQuery query = new BasePersonRelationshipQuery(); query.person_id = model.personID; query.type_id = (int)PersonType.学生; int num = basePersonRelationshipDAL.DeletePersonRelationshipByPersonIdAndTypeId(query); if (num == 0) { result = false; } //删除学生信息 num = servStudentInfoDAL.DeleteStudentInfoById(model.personID); if (num == 0) { result = false; } } } return(result); } catch (Exception ex) { throw ex; } }
/// <summary> /// 查询全部 /// </summary> /// <param name="query"></param> /// <returns></returns> public List <BasePersonRelationshipModel> GetEntities(BasePersonRelationshipQuery query) { List <BasePersonRelationshipModel> list = mapContext.QueryForList <BasePersonRelationshipModel>("GetPersonRelationship", query).ToList(); return(list); }