/// <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));
}
}
}
/// <summary>
/// 根据identityCard获取人员资质信息
/// </summary>
/// <param name="identityCard"></param>
/// <returns></returns>
public static Model.PersonQualityItem getPersonQualityInfo(string type, string dataId)
{
Model.PersonQualityItem getQualityItem = new Model.PersonQualityItem();
if (type == "1")
{
////特种作业人员
getQualityItem = (from x in Funs.DB.QualityAudit_PersonQuality
join y in Funs.DB.SitePerson_Person on x.PersonId equals y.PersonId
where x.PersonQualityId == dataId || x.PersonId == dataId
orderby y.CardNo
select new Model.PersonQualityItem
{
PersonQualityId = x.PersonQualityId,
QualityType = type,
PersonId = x.PersonId,
PersonName = y.PersonName,
CardNo = y.CardNo,
IdentityCard = y.IdentityCard,
ProjectId = y.ProjectId,
UnitId = y.UnitId,
UnitName = Funs.DB.Base_Unit.First(z => z.UnitId == y.UnitId).UnitName,
UnitCode = Funs.DB.Base_Unit.First(z => z.UnitId == y.UnitId).UnitCode,
WorkPostId = y.WorkPostId,
WorkPostName = Funs.DB.Base_WorkPost.First(z => z.WorkPostId == y.WorkPostId).WorkPostName,
CertificateId = x.CertificateId,
CertificateName = Funs.DB.Base_Certificate.First(z => z.CertificateId == x.CertificateId).CertificateName,
CertificateNo = x.CertificateNo,
Grade = x.Grade,
SendUnit = x.SendUnit,
SendDate = string.Format("{0:yyyy-MM-dd}", x.SendDate),
LimitDate = string.Format("{0:yyyy-MM-dd}", x.LimitDate),
LateCheckDate = string.Format("{0:yyyy-MM-dd}", x.LateCheckDate),
Remark = x.Remark,
CompileMan = x.CompileMan,
CompileManName = Funs.DB.Sys_User.First(z => z.UserId == x.CompileMan).UserName,
CompileDate = string.Format("{0:yyyy-MM-dd}", x.CompileDate),
AuditDate = string.Format("{0:yyyy-MM-dd}", x.AuditDate),
AuditorId = x.AuditorId,
AuditorName = Funs.DB.Sys_User.First(z => z.UserId == x.AuditorId).UserName,
AuditOpinion = x.AuditOpinion,
States = x.States,
AttachUrl = APIUpLoadFileService.getFileUrl(x.PersonQualityId, null),
}).FirstOrDefault();
}
//// 安管人员
else if (type == "2")
{
getQualityItem = (from x in Funs.DB.QualityAudit_SafePersonQuality
join y in Funs.DB.SitePerson_Person on x.PersonId equals y.PersonId
where x.SafePersonQualityId == dataId || x.PersonId == dataId
orderby y.CardNo
select new Model.PersonQualityItem
{
PersonQualityId = x.SafePersonQualityId,
QualityType = type,
PersonId = x.PersonId,
PersonName = y.PersonName,
CardNo = y.CardNo,
IdentityCard = y.IdentityCard,
ProjectId = y.ProjectId,
UnitId = y.UnitId,
UnitName = Funs.DB.Base_Unit.First(z => z.UnitId == y.UnitId).UnitName,
UnitCode = Funs.DB.Base_Unit.First(z => z.UnitId == y.UnitId).UnitCode,
WorkPostId = y.WorkPostId,
WorkPostName = Funs.DB.Base_WorkPost.First(z => z.WorkPostId == y.WorkPostId).WorkPostName,
//CertificateId = x.CertificateId,
CertificateName = x.CertificateName,
CertificateNo = x.CertificateNo,
Grade = x.Grade,
SendUnit = x.SendUnit,
SendDate = string.Format("{0:yyyy-MM-dd}", x.SendDate),
LimitDate = string.Format("{0:yyyy-MM-dd}", x.LimitDate),
LateCheckDate = string.Format("{0:yyyy-MM-dd}", x.LateCheckDate),
Remark = x.Remark,
CompileMan = x.CompileMan,
CompileManName = Funs.DB.Sys_User.First(z => z.UserId == x.CompileMan).UserName,
CompileDate = string.Format("{0:yyyy-MM-dd}", x.CompileDate),
AuditDate = string.Format("{0:yyyy-MM-dd}", x.AuditDate),
AuditorId = x.AuditorId,
AuditorName = Funs.DB.Sys_User.First(z => z.UserId == x.AuditorId).UserName,
AuditOpinion = x.AuditOpinion,
States = x.States,
AttachUrl = APIUpLoadFileService.getFileUrl(x.SafePersonQualityId, null),
}).FirstOrDefault();
}
else if (type == "3")
{
////特种设备作业人员
getQualityItem = (from x in Funs.DB.QualityAudit_EquipmentPersonQuality
join y in Funs.DB.SitePerson_Person on x.PersonId equals y.PersonId
where x.EquipmentPersonQualityId == dataId || x.PersonId == dataId
orderby y.CardNo
select new Model.PersonQualityItem
{
PersonQualityId = x.EquipmentPersonQualityId,
QualityType = type,
PersonId = x.PersonId,
PersonName = y.PersonName,
CardNo = y.CardNo,
IdentityCard = y.IdentityCard,
ProjectId = y.ProjectId,
UnitId = y.UnitId,
UnitName = Funs.DB.Base_Unit.First(z => z.UnitId == y.UnitId).UnitName,
UnitCode = Funs.DB.Base_Unit.First(z => z.UnitId == y.UnitId).UnitCode,
WorkPostId = y.WorkPostId,
WorkPostName = Funs.DB.Base_WorkPost.First(z => z.WorkPostId == y.WorkPostId).WorkPostName,
CertificateId = x.CertificateId,
CertificateName = Funs.DB.Base_Certificate.First(z => z.CertificateId == x.CertificateId).CertificateName,
CertificateNo = x.CertificateNo,
Grade = x.Grade,
SendUnit = x.SendUnit,
SendDate = string.Format("{0:yyyy-MM-dd}", x.SendDate),
LimitDate = string.Format("{0:yyyy-MM-dd}", x.LimitDate),
LateCheckDate = string.Format("{0:yyyy-MM-dd}", x.LateCheckDate),
Remark = x.Remark,
CompileMan = x.CompileMan,
CompileManName = Funs.DB.Sys_User.First(z => z.UserId == x.CompileMan).UserName,
CompileDate = string.Format("{0:yyyy-MM-dd}", x.CompileDate),
AuditDate = string.Format("{0:yyyy-MM-dd}", x.AuditDate),
AuditorId = x.AuditorId,
AuditorName = Funs.DB.Sys_User.First(z => z.UserId == x.AuditorId).UserName,
AuditOpinion = x.AuditOpinion,
States = x.States,
AttachUrl = APIUpLoadFileService.getFileUrl(x.EquipmentPersonQualityId, null),
}).FirstOrDefault();
}
return(getQualityItem);
}
