/// <summary> /// 根据人员考勤主键删除一个人员考勤管理信息 /// </summary> /// <param name="checkingId">人员考勤主键</param> public static void DeletePersonInOutByCheckingId(string PersonInOutId) { Model.SUBHSSEDB db = Funs.DB; Model.SitePerson_PersonInOut personInOut = db.SitePerson_PersonInOut.FirstOrDefault(e => e.PersonInOutId == PersonInOutId); if (personInOut != null) { db.SitePerson_PersonInOut.DeleteOnSubmit(personInOut); db.SubmitChanges(); } }
/// <summary> /// 增加人员出入场信息 /// </summary> /// <param name="PersonInOut">人员实体</param> public static void AddPersonInOut(Model.SitePerson_PersonInOut PersonInOut) { Model.SUBHSSEDB db = Funs.DB; Model.SitePerson_PersonInOut newPersonInOut = new Model.SitePerson_PersonInOut { PersonInOutId = SQLHelper.GetNewID(typeof(Model.SitePerson_PersonInOut)), ProjectId = PersonInOut.ProjectId, UnitId = PersonInOut.UnitId, PersonId = PersonInOut.PersonId, IsIn = PersonInOut.IsIn, ChangeTime = PersonInOut.ChangeTime }; db.SitePerson_PersonInOut.InsertOnSubmit(newPersonInOut); db.SubmitChanges(); }
/// <summary> /// 修改人员信息 /// </summary> /// <param name="person">人员实体</param> public static void UpdatePerson(Model.SitePerson_Person person) { Model.SUBHSSEDB db = Funs.DB; Model.SitePerson_Person newPerson = db.SitePerson_Person.FirstOrDefault(e => e.PersonId == person.PersonId); if (newPerson != null) { newPerson.FromPersonId = person.FromPersonId; newPerson.CardNo = person.CardNo; newPerson.PersonName = person.PersonName; newPerson.Sex = person.Sex; newPerson.IdentityCard = person.IdentityCard; newPerson.Address = person.Address; newPerson.ProjectId = person.ProjectId; newPerson.UnitId = person.UnitId; newPerson.TeamGroupId = person.TeamGroupId; newPerson.WorkAreaId = person.WorkAreaId; newPerson.WorkPostId = person.WorkPostId; newPerson.InTime = person.InTime; newPerson.OutTime = person.OutTime; newPerson.OutResult = person.OutResult; newPerson.Telephone = person.Telephone; newPerson.PositionId = person.PositionId; newPerson.PostTitleId = person.PostTitleId; newPerson.PhotoUrl = person.PhotoUrl; newPerson.IsUsed = person.IsUsed; newPerson.IsCardUsed = person.IsCardUsed; newPerson.DepartId = person.DepartId; newPerson.QRCodeAttachUrl = person.QRCodeAttachUrl; newPerson.Password = GetPersonPassWord(person.IdentityCard); newPerson.ExchangeTime2 = null; if (!string.IsNullOrEmpty(person.AuditorId)) { newPerson.AuditorId = person.AuditorId; } if (person.AuditorDate.HasValue) { newPerson.AuditorDate = person.AuditorDate; } newPerson.IsForeign = person.IsForeign; newPerson.IsOutside = person.IsOutside; db.SubmitChanges(); if (!CommonService.GetIsThisUnit(Const.UnitId_SEDIN)) { ////写入人员出入场时间表 Model.SitePerson_PersonInOut newPersonInOut = new Model.SitePerson_PersonInOut { ProjectId = person.ProjectId, UnitId = person.UnitId, PersonId = person.PersonId }; if (newPerson.InTime.HasValue) { var inOutIn = BLL.PersonInOutService.GetPersonInOutByTimePersonId(person.PersonId, person.InTime.Value, true); if (inOutIn == null) { newPersonInOut.ChangeTime = person.InTime; newPersonInOut.IsIn = true; BLL.PersonInOutService.AddPersonInOut(newPersonInOut); } } if (newPerson.OutTime.HasValue) { var inOutIn = BLL.PersonInOutService.GetPersonInOutByTimePersonId(person.PersonId, person.OutTime.Value, false); if (inOutIn == null) { newPersonInOut.ChangeTime = person.OutTime; newPersonInOut.IsIn = false; BLL.PersonInOutService.AddPersonInOut(newPersonInOut); } } } } }
/// <summary> /// 增加人员信息 /// </summary> /// <param name="person">人员实体</param> public static void AddPerson(Model.SitePerson_Person person) { Model.SUBHSSEDB db = Funs.DB; Model.SitePerson_Person newPerson = new Model.SitePerson_Person { PersonId = person.PersonId, CardNo = person.CardNo, PersonName = person.PersonName, Sex = person.Sex, IdentityCard = person.IdentityCard, Address = person.Address, ProjectId = person.ProjectId, UnitId = person.UnitId, TeamGroupId = person.TeamGroupId, WorkAreaId = person.WorkAreaId, WorkPostId = person.WorkPostId, OutTime = person.OutTime, OutResult = person.OutResult, Telephone = person.Telephone, PositionId = person.PositionId, PostTitleId = person.PostTitleId, PhotoUrl = person.PhotoUrl, IsUsed = person.IsUsed, IsCardUsed = person.IsCardUsed, DepartId = person.DepartId, FromPersonId = person.FromPersonId, Password = GetPersonPassWord(person.IdentityCard), AuditorId = person.AuditorId, AuditorDate = person.AuditorDate, IsForeign = person.IsForeign, IsOutside = person.IsOutside, Isprint = "0", }; if (person.InTime.HasValue) { newPerson.InTime = person.InTime; } else { newPerson.InTime = Funs.GetNewDateTime(DateTime.Now.ToShortDateString()); } db.SitePerson_Person.InsertOnSubmit(newPerson); db.SubmitChanges(); if (!CommonService.GetIsThisUnit(Const.UnitId_SEDIN)) { ///写入人员出入场时间表 Model.SitePerson_PersonInOut newPersonInOut = new Model.SitePerson_PersonInOut { ProjectId = person.ProjectId, UnitId = person.UnitId, PersonId = person.PersonId }; if (newPerson.InTime.HasValue) { newPersonInOut.ChangeTime = person.InTime; newPersonInOut.IsIn = true; BLL.PersonInOutService.AddPersonInOut(newPersonInOut); } if (newPerson.OutTime.HasValue) { newPersonInOut.ChangeTime = person.OutTime; newPersonInOut.IsIn = false; BLL.PersonInOutService.AddPersonInOut(newPersonInOut); } } ////增加一条编码记录 BLL.CodeRecordsService.InsertCodeRecordsByMenuIdProjectIdUnitId(BLL.Const.PersonListMenuId, person.ProjectId, person.UnitId, person.PersonId, person.InTime); }