/// <summary>
/// 添加吊装作业票
/// </summary>
/// <param name="liftingWork"></param>
public static void AddLiftingWork(Model.License_LiftingWork liftingWork)
{
Model.SUBHSSEDB db = Funs.DB;
Model.License_LiftingWork newLiftingWork = new Model.License_LiftingWork
{
LiftingWorkId = liftingWork.LiftingWorkId,
ProjectId = liftingWork.ProjectId,
LicenseCode = liftingWork.LicenseCode,
ApplyUnitId = liftingWork.ApplyUnitId,
ApplyManId = liftingWork.ApplyManId,
ApplyDate = liftingWork.ApplyDate,
WorkPalce = liftingWork.WorkPalce,
WorkLevel = liftingWork.WorkLevel,
ValidityStartTime = liftingWork.ValidityStartTime,
ValidityEndTime = liftingWork.ValidityEndTime,
WorkMeasures = liftingWork.WorkMeasures,
CraneCapacity = liftingWork.CraneCapacity,
CancelManId = liftingWork.CancelManId,
CancelReasons = liftingWork.CancelReasons,
CancelTime = liftingWork.CancelTime,
CloseManId = liftingWork.CloseManId,
CloseReasons = liftingWork.CloseReasons,
CloseTime = liftingWork.CloseTime,
NextManId = liftingWork.NextManId,
States = liftingWork.States,
};
db.License_LiftingWork.InsertOnSubmit(newLiftingWork);
db.SubmitChanges();
////增加一条编码记录
CodeRecordsService.InsertCodeRecordsByMenuIdProjectIdUnitId(Const.ProjectLiftingWorkMenuId, liftingWork.ProjectId, liftingWork.ApplyUnitId, liftingWork.LiftingWorkId, liftingWork.ApplyDate);
}
/// <summary>
/// 根据主键删除吊装作业票
/// </summary>
/// <param name="liftingWorkId"></param>
public static void DeleteLiftingWorkById(string liftingWorkId)
{
Model.SUBHSSEDB db = Funs.DB;
Model.License_LiftingWork liftingWork = db.License_LiftingWork.FirstOrDefault(e => e.LiftingWorkId == liftingWorkId);
if (liftingWork != null)
{
///删除编码表记录
CodeRecordsService.DeleteCodeRecordsByDataId(liftingWorkId);
///删除-安全措施
DeleteLicenseItemByDataId(liftingWorkId);
///删除作业票审核信息
DeleteFlowOperateByDataId(liftingWorkId);
db.License_LiftingWork.DeleteOnSubmit(liftingWork);
db.SubmitChanges();
}
}
/// <summary>
/// 修改吊装作业票
/// </summary>
/// <param name="liftingWork"></param>
public static void UpdateLiftingWork(Model.License_LiftingWork liftingWork)
{
Model.SUBHSSEDB db = Funs.DB;
Model.License_LiftingWork newLiftingWork = db.License_LiftingWork.FirstOrDefault(e => e.LiftingWorkId == liftingWork.LiftingWorkId);
if (newLiftingWork != null)
{
newLiftingWork.WorkPalce = liftingWork.WorkPalce;
newLiftingWork.WorkLevel = liftingWork.WorkLevel;
newLiftingWork.ValidityStartTime = liftingWork.ValidityStartTime;
newLiftingWork.ValidityEndTime = liftingWork.ValidityEndTime;
newLiftingWork.WorkMeasures = liftingWork.WorkMeasures;
newLiftingWork.CraneCapacity = liftingWork.CraneCapacity;
newLiftingWork.CancelManId = liftingWork.CancelManId;
newLiftingWork.CancelReasons = liftingWork.CancelReasons;
newLiftingWork.CancelTime = liftingWork.CancelTime;
newLiftingWork.CloseManId = liftingWork.CloseManId;
newLiftingWork.CloseReasons = liftingWork.CloseReasons;
newLiftingWork.CloseTime = liftingWork.CloseTime;
newLiftingWork.NextManId = liftingWork.NextManId;
newLiftingWork.States = liftingWork.States;
db.SubmitChanges();
}
}
