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