/// <summary> /// 根据人员考勤主键删除一个人员考勤管理信息 /// </summary> /// <param name="checkingId">人员考勤主键</param> public static void DeletePersonInfoByCheckingId(string checkingId) { Model.SUBHSSEDB db = Funs.DB; Model.SitePerson_Checking personInfo = db.SitePerson_Checking.FirstOrDefault(e => e.CheckingId == checkingId); if (personInfo != null) { db.SitePerson_Checking.DeleteOnSubmit(personInfo); db.SubmitChanges(); } }
/// <summary> /// 修改人员考勤管理信息 /// </summary> /// <param name="personInfo">人员考勤管理实体</param> public static void UpdatePersonInfo(Model.SitePerson_Checking personInfo) { Model.SUBHSSEDB db = Funs.DB; Model.SitePerson_Checking newPersonInfo = db.SitePerson_Checking.First(e => e.CheckingId == personInfo.CheckingId); newPersonInfo.CardNo = personInfo.CardNo; newPersonInfo.PersonId = personInfo.PersonId; newPersonInfo.ProjectId = personInfo.ProjectId; newPersonInfo.WorkAreaId = personInfo.WorkAreaId; newPersonInfo.WorkAreaName = personInfo.WorkAreaName; newPersonInfo.IdentityCard = personInfo.IdentityCard; newPersonInfo.IntoOutTime = personInfo.IntoOutTime; newPersonInfo.IntoOut = personInfo.IntoOut; newPersonInfo.Address = personInfo.Address; db.SubmitChanges(); }
/// <summary> /// 增加人员考勤管理信息 /// </summary> /// <param name="personInfo">人员考勤管理实体</param> public static void AddPersonInfo(Model.SitePerson_Checking personInfo) { Model.SUBHSSEDB db = Funs.DB; Model.SitePerson_Checking newPersonInfo = new Model.SitePerson_Checking { CheckingId = personInfo.CheckingId, PersonId = personInfo.PersonId, CardNo = personInfo.CardNo, ProjectId = personInfo.ProjectId, WorkAreaId = personInfo.WorkAreaId, WorkAreaName = personInfo.WorkAreaName, IdentityCard = personInfo.IdentityCard, IntoOutTime = personInfo.IntoOutTime, IntoOut = personInfo.IntoOut, Address = personInfo.Address, States = BLL.Const.State_2 }; db.SitePerson_Checking.InsertOnSubmit(newPersonInfo); db.SubmitChanges(); }