/// <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;
}
}
/// <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;
}
}
/// <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;
}
}
/// <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;
}
}
/// <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;
}
}
public bool UpdateEntity(int id, ServStaffInfoModel newentity)
{
throw new NotImplementedException();
}