Esempio n. 1
0
 /// <summary>
 /// 更新一条数据
 /// </summary>
 /// <param name="model"></param>
 public int UpdateStaffInfoById(ServStaffInfoModel model)
 {
     try
     {
         int result = mapContext.Update("UpdateStaffInfo", model);
         return(result);
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Esempio n. 2
0
 /// <summary>
 /// 增加一条数据
 /// </summary>
 /// <param name="entity"></param>
 public int AddEntity(ServStaffInfoModel entity)
 {
     try
     {
         int id = (int)mapContext.Insert("InsertStaffInfo", entity);
         return(id);
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Esempio n. 3
0
        /// <summary>
        /// 根据人员id获取人员信息
        /// </summary>
        /// <param name="ssoId"></param>
        public PersonInfoCustom GetPersonInfoBySSOId(int ssoId)
        {
            try
            {
                //查询人员基础信息
                ApiPersonInfoModel apiModel = GetPostPersonInfoByPersonId(ssoId);

                //查询人员关联信息
                PersonInfoCustom personModel = new PersonInfoCustom();
                if (apiModel != null)
                {
                    personModel.personID = apiModel.PersonID; //人员编号
                    personModel.name     = apiModel.Name;     //姓名
                    //性别
                    personModel.genderName = apiModel.GenderName;
                    personModel.Gender     = apiModel.Gender;
                    //民族
                    personModel.nationName = apiModel.NationName;
                    personModel.Nation     = apiModel.Nation;
                    //生日
                    personModel.birthday = apiModel.Birthday;
                    //血型
                    personModel.bloodTypeName = apiModel.BloodTypeName;
                    personModel.BloodType     = apiModel.BloodType;
                    //宗教
                    personModel.religionName = apiModel.ReligionName;
                    personModel.Religion     = apiModel.Religion;
                    //籍贯
                    personModel.nativePlace = apiModel.NativePlace;
                    //国籍
                    personModel.nationalityName = apiModel.NationalityName;
                    personModel.Nationality     = apiModel.Nationality;
                    //政治面貌
                    personModel.politicalStatusName = apiModel.PoliticalStatusName;
                    personModel.PoliticalStatus     = apiModel.PoliticalStatus;
                    //婚姻
                    personModel.MarriageStatus     = apiModel.MarriageStatus;
                    personModel.marriageStatusName = apiModel.MarriageStatus == null ? "" : ((bool)apiModel.MarriageStatus) ? "已婚" : "未婚";
                    //照片
                    personModel.photoFileName = apiModel.PhotoFileName;
                    //身份证
                    personModel.IDCard = apiModel.IDCard;
                    //证件号
                    personModel.workNO = apiModel.WorkNO;
                    //学院
                    personModel.college = apiModel.College;
                    //一卡通卡号
                    personModel.oneCardNumber = apiModel.OneCardNumber;
                    //手机号
                    personModel.phone = apiModel.Phone;
                    //人员类型
                    personModel.PersonType     = apiModel.PersonType;
                    personModel.PersonTypeName = apiModel.PersonTypeName;
                    //部门
                    personModel.department   = apiModel.Department;
                    personModel.DepartmentID = apiModel.DepartmentID;
                    //根据人员id查询人员类型,然后根据类型查询对应的扩展表
                    List <BasePersonRelationshipModel> relationList = basePersonRelationshipDAL.GetPersonTypeByPersonId(ssoId);
                    for (int i = 0; i < relationList.Count; i++)
                    {
                        switch (relationList[i].type_id)
                        {
                        case (int)PersonType.学生:
                            ServStudentInfoModel student = servStudentInfoDAL.GetStudentInfoByPersonId(relationList[i].person_id);
                            if (student != null)
                            {
                                personModel.studentFlag      = 1;
                                personModel.student_num      = student.student_num;
                                personModel.student_grade    = student.student_grade.ToString();
                                personModel.class_Name       = student.class_id.ToString();
                                personModel.in_time          = student.in_time == null ? "" : Convert.ToDateTime(student.in_time).ToString("yyyy-MM-dd HH:mm:ss");
                                personModel.edu_year         = student.edu_year.ToString();
                                personModel.teacher_Name     = student.teacher_id;
                                personModel.staff_Name       = student.staff_id;
                                personModel.student_type_id  = student.student_type;
                                personModel.student_type     = ((StudentType)student.student_type).ToString();
                                personModel.studentStatus_id = student.status;
                                personModel.studentStatus    = ((StudentStatus)student.status).ToString();
                            }
                            break;

                        case (int)PersonType.教师:
                            ServTeacherInfoModel teacherModel = servTeacherInfoDAL.GetTeacherInfoByPersonId(relationList[i].person_id);
                            if (teacherModel != null)
                            {
                                personModel.teacherFlag     = 1;
                                personModel.faculty         = teacherModel.class_id.ToString();
                                personModel.faculty         = teacherModel.class_id;
                                personModel.level           = ((TeacherLevel)teacherModel.level).ToString();
                                personModel.level_id        = teacherModel.level;
                                personModel.teach_Status    = ((TeachStatus)teacherModel.status).ToString();
                                personModel.teach_status_id = teacherModel.status;
                            }
                            break;

                        case (int)PersonType.职工:
                            ServStaffInfoModel staffInfo = servStaffInfoDAL.GetStaffInfoByPersonId(relationList[i].person_id);
                            if (staffInfo != null)
                            {
                                personModel.staffFlag = 1;
                                //部门
                                personModel.org_id = staffInfo.org_id;
                                BaseOrganizitionInfoModel orgmodel = baseOrganizationDAL.GetEntity(staffInfo.org_id);
                                personModel.orgName         = orgmodel == null ? "" : orgmodel.org_name;
                                personModel.job_grade       = staffInfo.job_grade;
                                personModel.start_time      = staffInfo.start_time == null ? "" : Convert.ToDateTime(staffInfo.start_time).ToString("yyyy-MM-dd HH:mm:ss");
                                personModel.work_num        = staffInfo.work_num;
                                personModel.staff_type_id   = staffInfo.staff_type;
                                personModel.staff_type      = ((PersonStaffType)staffInfo.staff_type).ToString();
                                personModel.staff_status_id = staffInfo.staff_status;
                                personModel.staff_status    = ((PersonStaffStatus)staffInfo.staff_status).ToString();
                            }
                            break;
                        }
                    }
                }
                return(personModel);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Esempio n. 4
0
 /// <summary>
 /// 添加人员信息
 /// </summary>
 /// <param name="model"></param>
 /// <returns></returns>
 public bool AddPersonInfo(PersonInfoCustom model)
 {
     try
     {
         bool result = false;
         //往sso中添加人员基础信息
         ApiPersonInfoModel personModel = new ApiPersonInfoModel();
         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;
         personModel.Admin           = model.loginAdmin;
         personModel.PassWord        = model.loginPassWord;
         string parStr   = JsonHelper.ObjectToString <ApiPersonInfoModel>(personModel);
         string str      = HttpHelper.PostWebRequestBandError("http://" + personIp + "/ApiPersonInfo/AddPersonInfoAndAccount", parStr, "application/json;charset=utf-8", Encoding.UTF8);
         int    personId = JsonHelper.StringToObject <int>(str);
         if (personId < 1)
         {
             return(false);
         }
         else
         {
             result = true;
         }
         //添加人员信息表serv_person_info
         ServPersonInfoModel personInfoModel = new ServPersonInfoModel();
         personInfoModel.ssoid   = personId;
         personInfoModel.role_id = 0;
         personInfoModel.alias   = model.name;
         personInfoModel.status  = 1;
         int personInfoId = servPersonInfoDAL.AddEntity(personInfoModel);
         if (personInfoId < 1)
         {
             return(false);
         }
         //职工信息
         ServStaffInfoModel staffmodel = new ServStaffInfoModel();
         staffmodel.person_id = 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)//有职工扩展
         {
             //新增人员职工关联
             BasePersonRelationshipModel staffRelation1 = new BasePersonRelationshipModel();
             staffRelation1.type_id   = (int)PersonType.职工;
             staffRelation1.person_id = personId;
             int id1 = basePersonRelationshipDAL.AddEntity(staffRelation1);
             if (id1 < 1)
             {
                 return(false);
             }
             else
             {
                 result = true;
             }
             //新增职工信息
             int id = servStaffInfoDAL.AddEntity(staffmodel);
             if (id < 1)
             {
                 return(false);
             }
             else
             {
                 result = true;
             }
         }
         //教师信息
         ServTeacherInfoModel teacherModel = new ServTeacherInfoModel();
         teacherModel.person_id = personId;
         teacherModel.class_id  = model.faculty;
         teacherModel.level     = model.level_id;
         teacherModel.status    = model.teach_status_id;
         if (model.teacherFlag == 1)//有教师扩展
         {
             //新增人员教师关联
             BasePersonRelationshipModel staffRelation1 = new BasePersonRelationshipModel();
             staffRelation1.type_id   = (int)PersonType.教师;
             staffRelation1.person_id = personId;
             int id1 = basePersonRelationshipDAL.AddEntity(staffRelation1);
             if (id1 < 1)
             {
                 return(false);
             }
             else
             {
                 result = true;
             }
             //新增教师信息
             int id = servTeacherInfoDAL.AddEntity(teacherModel);
             if (id < 1)
             {
                 return(false);
             }
             else
             {
                 result = true;
             }
         }
         //学生信息
         ServStudentInfoModel studentModel = new ServStudentInfoModel();
         studentModel.person_id     = 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)//有学生扩展
         {
             //新增人员学生关联
             BasePersonRelationshipModel staffRelation1 = new BasePersonRelationshipModel();
             staffRelation1.type_id   = (int)PersonType.学生;
             staffRelation1.person_id = personId;
             int id1 = basePersonRelationshipDAL.AddEntity(staffRelation1);
             if (id1 < 1)
             {
                 return(false);
             }
             else
             {
                 result = true;
             }
             //新增学生信息
             int id = servStudentInfoDAL.AddEntity(studentModel);
             if (id < 1)
             {
                 return(false);
             }
             else
             {
                 result = true;
             }
         }
         return(result);
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Esempio n. 5
0
 /// <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;
     }
 }
Esempio n. 6
0
 public bool UpdateEntity(int id, ServStaffInfoModel newentity)
 {
     throw new NotImplementedException();
 }