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