/// <summary>
/// 根据人员Id删除一个人员信息
/// </summary>
/// <param name="personId">人员Id</param>
public static void DeletePerson(string personId)
{
Model.SUBHSSEDB db = Funs.DB;
Model.SitePerson_Person person = db.SitePerson_Person.FirstOrDefault(e => e.PersonId == personId);
if (person != null)
{
///删除编码表记录
BLL.CodeRecordsService.DeleteCodeRecordsByDataId(personId);
//删除管理人员资质
Model.QualityAudit_ManagePersonQuality managePersonQuality = db.QualityAudit_ManagePersonQuality.FirstOrDefault(e => e.PersonId == personId);
if (managePersonQuality != null)
{
CodeRecordsService.DeleteCodeRecordsByDataId(managePersonQuality.ManagePersonQualityId);
CommonService.DeleteAttachFileById(managePersonQuality.ManagePersonQualityId);
db.QualityAudit_ManagePersonQuality.DeleteOnSubmit(managePersonQuality);
db.SubmitChanges();
}
//删除特岗人员资质
var personQuality = PersonQualityService.GetPersonQualityByPersonId(personId);
if (personQuality != null)
{
CodeRecordsService.DeleteCodeRecordsByDataId(personQuality.PersonQualityId); //删除编号
CommonService.DeleteAttachFileById(personQuality.PersonQualityId); //删除附件
db.QualityAudit_PersonQuality.DeleteOnSubmit(personQuality);
db.SubmitChanges();
}
//删除安全人员资质
Model.QualityAudit_SafePersonQuality safePersonQuality = db.QualityAudit_SafePersonQuality.FirstOrDefault(e => e.PersonId == personId);
if (safePersonQuality != null)
{
CodeRecordsService.DeleteCodeRecordsByDataId(safePersonQuality.SafePersonQualityId);
CommonService.DeleteAttachFileById(safePersonQuality.SafePersonQualityId);
db.QualityAudit_SafePersonQuality.DeleteOnSubmit(safePersonQuality);
db.SubmitChanges();
}
///删除人员出入场记录
BLL.PersonInOutService.DeletePersonInOutByPersonId(person.PersonId);
db.SitePerson_Person.DeleteOnSubmit(person);
db.SubmitChanges();
}
}
/// <summary>
/// 修改安全人员资质
/// </summary>
/// <param name="SafePersonQuality"></param>
public static void UpdateSafePersonQuality(Model.QualityAudit_SafePersonQuality SafePersonQuality)
{
Model.SUBHSSEDB db = Funs.DB;
Model.QualityAudit_SafePersonQuality newSafePersonQuality = db.QualityAudit_SafePersonQuality.FirstOrDefault(e => e.SafePersonQualityId == SafePersonQuality.SafePersonQualityId);
if (newSafePersonQuality != null)
{
newSafePersonQuality.CertificateNo = SafePersonQuality.CertificateNo;
newSafePersonQuality.CertificateName = SafePersonQuality.CertificateName;
newSafePersonQuality.Grade = SafePersonQuality.Grade;
newSafePersonQuality.SendUnit = SafePersonQuality.SendUnit;
newSafePersonQuality.SendDate = SafePersonQuality.SendDate;
newSafePersonQuality.LimitDate = SafePersonQuality.LimitDate;
newSafePersonQuality.LateCheckDate = SafePersonQuality.LateCheckDate;
newSafePersonQuality.ApprovalPerson = SafePersonQuality.ApprovalPerson;
newSafePersonQuality.Remark = SafePersonQuality.Remark;
newSafePersonQuality.CompileMan = SafePersonQuality.CompileMan;
newSafePersonQuality.CompileDate = SafePersonQuality.CompileDate;
newSafePersonQuality.AuditDate = SafePersonQuality.AuditDate;
newSafePersonQuality.AuditorId = SafePersonQuality.AuditorId;
db.SubmitChanges();
}
}
/// <summary>
/// 添加安全人员资质
/// </summary>
/// <param name="SafePersonQuality"></param>
public static void AddSafePersonQuality(Model.QualityAudit_SafePersonQuality SafePersonQuality)
{
Model.SUBHSSEDB db = Funs.DB;
Model.QualityAudit_SafePersonQuality newSafePersonQuality = new Model.QualityAudit_SafePersonQuality
{
SafePersonQualityId = SafePersonQuality.SafePersonQualityId,
PersonId = SafePersonQuality.PersonId,
CertificateNo = SafePersonQuality.CertificateNo,
CertificateName = SafePersonQuality.CertificateName,
Grade = SafePersonQuality.Grade,
SendUnit = SafePersonQuality.SendUnit,
SendDate = SafePersonQuality.SendDate,
LimitDate = SafePersonQuality.LimitDate,
LateCheckDate = SafePersonQuality.LateCheckDate,
ApprovalPerson = SafePersonQuality.ApprovalPerson,
Remark = SafePersonQuality.Remark,
CompileMan = SafePersonQuality.CompileMan,
CompileDate = SafePersonQuality.CompileDate,
AuditDate = SafePersonQuality.AuditDate,
AuditorId = SafePersonQuality.AuditorId,
};
db.QualityAudit_SafePersonQuality.InsertOnSubmit(newSafePersonQuality);
db.SubmitChanges();
}
/// <summary>
/// 人员资质信息保存方法
/// </summary>
/// <param name="personQuality">人员信息</param>
public static void SavePersonQuality(Model.PersonQualityItem personQuality)
{
using (Model.SUBHSSEDB db = new Model.SUBHSSEDB(Funs.ConnString))
{
if (personQuality.QualityType == "1")
{
Model.QualityAudit_PersonQuality newPersonQuality = new Model.QualityAudit_PersonQuality
{
PersonQualityId = personQuality.PersonQualityId,
PersonId = personQuality.PersonId,
CertificateNo = personQuality.CertificateNo,
CertificateName = personQuality.CertificateName,
Grade = personQuality.Grade,
SendUnit = personQuality.SendUnit,
SendDate = Funs.GetNewDateTime(personQuality.SendDate),
LimitDate = Funs.GetNewDateTime(personQuality.LimitDate),
LateCheckDate = Funs.GetNewDateTime(personQuality.LateCheckDate),
ApprovalPerson = personQuality.ApprovalPerson,
Remark = personQuality.Remark,
CompileDate = Funs.GetNewDateTime(personQuality.CompileDate),
AuditOpinion = personQuality.AuditOpinion,
States = personQuality.States,
};
if (newPersonQuality.States == Const.State_2 || newPersonQuality.States == Const.State_R)
{
newPersonQuality.AuditDate = DateTime.Now;
}
else
{
newPersonQuality.AuditDate = null;
}
if (!string.IsNullOrEmpty(personQuality.CertificateId))
{
newPersonQuality.CertificateId = personQuality.CertificateId;
}
if (!string.IsNullOrEmpty(personQuality.CompileMan))
{
newPersonQuality.CompileMan = personQuality.CompileMan;
}
if (!string.IsNullOrEmpty(personQuality.AuditorId))
{
newPersonQuality.AuditorId = personQuality.AuditorId;
}
var getPersonQuality = db.QualityAudit_PersonQuality.FirstOrDefault(x => x.PersonQualityId == newPersonQuality.PersonQualityId || x.PersonId == newPersonQuality.PersonId);
if (getPersonQuality == null)
{
newPersonQuality.PersonQualityId = SQLHelper.GetNewID();
newPersonQuality.CompileDate = DateTime.Now;
db.QualityAudit_PersonQuality.InsertOnSubmit(newPersonQuality);
db.SubmitChanges();
}
else
{
newPersonQuality.PersonQualityId = getPersonQuality.PersonQualityId;
getPersonQuality.CertificateId = newPersonQuality.CertificateId;
getPersonQuality.CertificateNo = newPersonQuality.CertificateNo;
getPersonQuality.CertificateName = newPersonQuality.CertificateName;
getPersonQuality.Grade = newPersonQuality.Grade;
getPersonQuality.SendUnit = newPersonQuality.SendUnit;
getPersonQuality.SendDate = newPersonQuality.SendDate;
getPersonQuality.LimitDate = newPersonQuality.LimitDate;
getPersonQuality.LateCheckDate = newPersonQuality.LateCheckDate;
getPersonQuality.Remark = newPersonQuality.Remark;
getPersonQuality.AuditDate = newPersonQuality.AuditDate;
getPersonQuality.AuditorId = newPersonQuality.AuditorId;
getPersonQuality.States = newPersonQuality.States;
db.SubmitChanges();
}
if (!string.IsNullOrEmpty(newPersonQuality.PersonQualityId))
{
APIUpLoadFileService.SaveAttachUrl(Const.PersonQualityMenuId, newPersonQuality.PersonQualityId, personQuality.AttachUrl, "0");
}
}
else if (personQuality.QualityType == "2")
{
Model.QualityAudit_SafePersonQuality newSafeQuality = new Model.QualityAudit_SafePersonQuality
{
SafePersonQualityId = personQuality.PersonQualityId,
PersonId = personQuality.PersonId,
CertificateNo = personQuality.CertificateNo,
CertificateName = personQuality.CertificateName,
Grade = personQuality.Grade,
SendUnit = personQuality.SendUnit,
SendDate = Funs.GetNewDateTime(personQuality.SendDate),
LimitDate = Funs.GetNewDateTime(personQuality.LimitDate),
LateCheckDate = Funs.GetNewDateTime(personQuality.LateCheckDate),
ApprovalPerson = personQuality.ApprovalPerson,
Remark = personQuality.Remark,
CompileDate = Funs.GetNewDateTime(personQuality.CompileDate),
AuditDate = Funs.GetNewDateTime(personQuality.AuditDate),
AuditOpinion = personQuality.AuditOpinion,
States = personQuality.States,
};
if (newSafeQuality.States == Const.State_2 || newSafeQuality.States == Const.State_R)
{
newSafeQuality.AuditDate = DateTime.Now;
}
else
{
newSafeQuality.AuditDate = null;
}
//if (!string.IsNullOrEmpty(personQuality.CertificateId))
//{
// newSafeQuality.CertificateId = personQuality.CertificateId;
//}
if (!string.IsNullOrEmpty(personQuality.CompileMan))
{
newSafeQuality.CompileMan = personQuality.CompileMan;
}
if (!string.IsNullOrEmpty(personQuality.AuditorId))
{
newSafeQuality.AuditorId = personQuality.AuditorId;
}
var getSafePersonQuality = db.QualityAudit_SafePersonQuality.FirstOrDefault(x => x.SafePersonQualityId == newSafeQuality.SafePersonQualityId || x.PersonId == newSafeQuality.PersonId);
if (getSafePersonQuality == null)
{
newSafeQuality.SafePersonQualityId = SQLHelper.GetNewID();
newSafeQuality.CompileDate = DateTime.Now;
db.QualityAudit_SafePersonQuality.InsertOnSubmit(newSafeQuality);
db.SubmitChanges();
}
else
{
newSafeQuality.SafePersonQualityId = getSafePersonQuality.SafePersonQualityId;
//getPersonQuality.CertificateId = newSafeQuality.CertificateId;
getSafePersonQuality.CertificateNo = newSafeQuality.CertificateNo;
getSafePersonQuality.CertificateName = newSafeQuality.CertificateName;
getSafePersonQuality.Grade = newSafeQuality.Grade;
getSafePersonQuality.SendUnit = newSafeQuality.SendUnit;
getSafePersonQuality.SendDate = newSafeQuality.SendDate;
getSafePersonQuality.LimitDate = newSafeQuality.LimitDate;
getSafePersonQuality.LateCheckDate = newSafeQuality.LateCheckDate;
getSafePersonQuality.Remark = newSafeQuality.Remark;
getSafePersonQuality.AuditDate = newSafeQuality.AuditDate;
getSafePersonQuality.AuditorId = newSafeQuality.AuditorId;
getSafePersonQuality.States = newSafeQuality.States;
db.SubmitChanges();
}
if (!string.IsNullOrEmpty(newSafeQuality.SafePersonQualityId))
{
APIUpLoadFileService.SaveAttachUrl(Const.SafePersonQualityMenuId, newSafeQuality.SafePersonQualityId, personQuality.AttachUrl, "0");
}
}
//// 特种设备作业人员
if (personQuality.QualityType == "3")
{
Model.QualityAudit_EquipmentPersonQuality newEquipmentPersonQuality = new Model.QualityAudit_EquipmentPersonQuality
{
EquipmentPersonQualityId = personQuality.PersonQualityId,
PersonId = personQuality.PersonId,
CertificateNo = personQuality.CertificateNo,
CertificateName = personQuality.CertificateName,
Grade = personQuality.Grade,
SendUnit = personQuality.SendUnit,
SendDate = Funs.GetNewDateTime(personQuality.SendDate),
LimitDate = Funs.GetNewDateTime(personQuality.LimitDate),
LateCheckDate = Funs.GetNewDateTime(personQuality.LateCheckDate),
ApprovalPerson = personQuality.ApprovalPerson,
Remark = personQuality.Remark,
CompileDate = Funs.GetNewDateTime(personQuality.CompileDate),
AuditDate = Funs.GetNewDateTime(personQuality.AuditDate),
AuditOpinion = personQuality.AuditOpinion,
States = personQuality.States,
};
if (newEquipmentPersonQuality.States == Const.State_2 || newEquipmentPersonQuality.States == Const.State_R)
{
newEquipmentPersonQuality.AuditDate = DateTime.Now;
}
else
{
newEquipmentPersonQuality.AuditDate = null;
}
if (!string.IsNullOrEmpty(personQuality.CertificateId))
{
newEquipmentPersonQuality.CertificateId = personQuality.CertificateId;
}
if (!string.IsNullOrEmpty(personQuality.CompileMan))
{
newEquipmentPersonQuality.CompileMan = personQuality.CompileMan;
}
if (!string.IsNullOrEmpty(personQuality.AuditorId))
{
newEquipmentPersonQuality.AuditorId = personQuality.AuditorId;
}
var getEquipmentPersonQuality = db.QualityAudit_EquipmentPersonQuality.FirstOrDefault(x => x.EquipmentPersonQualityId == newEquipmentPersonQuality.EquipmentPersonQualityId || x.PersonId == newEquipmentPersonQuality.PersonId);
if (getEquipmentPersonQuality == null)
{
newEquipmentPersonQuality.EquipmentPersonQualityId = SQLHelper.GetNewID();
newEquipmentPersonQuality.CompileDate = DateTime.Now;
db.QualityAudit_EquipmentPersonQuality.InsertOnSubmit(newEquipmentPersonQuality);
db.SubmitChanges();
}
else
{
newEquipmentPersonQuality.EquipmentPersonQualityId = getEquipmentPersonQuality.EquipmentPersonQualityId;
getEquipmentPersonQuality.CertificateId = newEquipmentPersonQuality.CertificateId;
getEquipmentPersonQuality.CertificateNo = newEquipmentPersonQuality.CertificateNo;
getEquipmentPersonQuality.CertificateName = newEquipmentPersonQuality.CertificateName;
getEquipmentPersonQuality.Grade = newEquipmentPersonQuality.Grade;
getEquipmentPersonQuality.SendUnit = newEquipmentPersonQuality.SendUnit;
getEquipmentPersonQuality.SendDate = newEquipmentPersonQuality.SendDate;
getEquipmentPersonQuality.LimitDate = newEquipmentPersonQuality.LimitDate;
getEquipmentPersonQuality.LateCheckDate = newEquipmentPersonQuality.LateCheckDate;
getEquipmentPersonQuality.Remark = newEquipmentPersonQuality.Remark;
getEquipmentPersonQuality.AuditDate = newEquipmentPersonQuality.AuditDate;
getEquipmentPersonQuality.AuditorId = newEquipmentPersonQuality.AuditorId;
getEquipmentPersonQuality.States = newEquipmentPersonQuality.States;
db.SubmitChanges();
}
if (!string.IsNullOrEmpty(newEquipmentPersonQuality.EquipmentPersonQualityId))
{
APIUpLoadFileService.SaveAttachUrl(Const.EquipmentPersonQualityMenuId, newEquipmentPersonQuality.EquipmentPersonQualityId, personQuality.AttachUrl, "0");
}
}
if (!string.IsNullOrEmpty(personQuality.AuditDate) && string.IsNullOrEmpty(personQuality.AuditorId))
{
APICommonService.SendSubscribeMessage(personQuality.AuditorId, "人员资质" + personQuality.PersonName + "待您审核", personQuality.CompileManName, string.Format("{0:yyyy-MM-dd HH:mm:ss}", DateTime.Now));
}
}
}
