private void CreateOrUpdateIdCertificate(DataContext dc, Staff staff, StaffIdCard card)
{
// 建立身份证的证照信息
CertificateType ct = dc.Context.GetTable <CertificateType>().FirstOrDefault(s => s.systemCode.Equals(SystemCertificateType.IdCard));
if (ct == null)
{
throw new SystemCertificateTypeNotFoundException();
}
Certificate cer = dc.Context.GetTable <Certificate>().FirstOrDefault(c => c.certificateTypeId.Equals(ct.id) && c.staffNr.Equals(staff.nr));
if (cer == null)
{
cer = new Certificate()
{
certificateTypeId = ct.id,
staffNr = staff.nr,
effectiveFrom = card.effectiveFrom,
effectiveEnd = card.effectiveEnd,
institution = card.institution,
remark = string.Format("在{0}系统自动创建", DateTime.Now)
};
dc.Context.GetTable <Certificate>().InsertOnSubmit(cer);
}
}
public bool CheckStaffAndUpdateInfo(StaffIdCard card)
{
DataContext dc = new DataContext(this.DbString);
Staff staff = dc.Context.GetTable <Staff>().FirstOrDefault(s => s.id.Equals(card.id));
if (staff != null)
{
if (string.IsNullOrEmpty(staff.name))
{
staff.name = card.name;
}
if (string.IsNullOrEmpty(staff.sex))
{
staff.sex = card.sex;
}
if (string.IsNullOrEmpty(staff.ethnic))
{
staff.ethnic = card.ethnic;
}
if (!staff.birthday.HasValue)
{
staff.birthday = card.birthday;
}
if (string.IsNullOrEmpty(staff.residenceAddress))
{
staff.residenceAddress = card.residenceAddress;
}
if (string.IsNullOrEmpty(staff.photo))
{
staff.photo = card.photo;
}
// 将是否已经身份证验证置为true
staff.isIdChecked = true;
this.CreateOrUpdateIdCertificate(dc, staff, card);
dc.Context.SubmitChanges();
try
{
IMessageRecordService mrs = new MessageRecordService(this.DbString);
mrs.CreateStaffIdCheckMessage(staff.nr);
}
catch { }
return(true);
}
return(false);
}
private bool upDate()
{
IStaffService staffService = new StaffService(Settings.Default.db);
StaffIdCard cardData = new StaffIdCard();
cardData.id = ID.Text;
cardData.name = Name.Text;
cardData.sex = escape.SexEscapeForUpdate(Sex.Text);
cardData.ethnic = Nation.Text;
cardData.birthday = Convert.ToDateTime(Born.Text);
cardData.residenceAddress = Address.Text;
cardData.effectiveFrom = Convert.ToDateTime(UserLifeBegin.Text);
cardData.effectiveEnd = Convert.ToDateTime(UserLifeEnd.Text);
cardData.institution = GrantDept.Text;
cardData.photo = "data:image/jpg;base64," + photoToString();
return(staffService.CheckStaffAndUpdateInfo(cardData));
}
public bool CreateInfoAndSetCheck(StaffIdCard card, bool isIdChecked = false)
{
Staff staff = new Staff()
{
nr = Guid.NewGuid().ToString(),
name = card.name,
sex = card.sex,
ethnic = card.ethnic,
birthday = card.birthday,
residenceAddress = card.residenceAddress,
id = card.id,
isIdChecked = isIdChecked
};
DataContext dc = new DataContext(this.DbString);
// this.CreateOrUpdateIdCertificate(dc, staff, card);
dc.Context.GetTable <Staff>().InsertOnSubmit(staff);
dc.Context.SubmitChanges();
return(true);
}
