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); }