/// <summary>
/// 添加高处作业票
/// </summary>
/// <param name="heightWork"></param>
public static void AddHeightWork(Model.License_HeightWork heightWork)
{
Model.SUBHSSEDB db = Funs.DB;
Model.License_HeightWork newHeightWork = new Model.License_HeightWork
{
HeightWorkId = heightWork.HeightWorkId,
ProjectId = heightWork.ProjectId,
LicenseCode = heightWork.LicenseCode,
ApplyUnitId = heightWork.ApplyUnitId,
ApplyManId = heightWork.ApplyManId,
ApplyDate = heightWork.ApplyDate,
WorkPalce = heightWork.WorkPalce,
WorkType = heightWork.WorkType,
ValidityStartTime = heightWork.ValidityStartTime,
ValidityEndTime = heightWork.ValidityEndTime,
WorkMeasures = heightWork.WorkMeasures,
EquipmentTools = heightWork.EquipmentTools,
CancelManId = heightWork.CancelManId,
CancelReasons = heightWork.CancelReasons,
CancelTime = heightWork.CancelTime,
CloseManId = heightWork.CloseManId,
CloseReasons = heightWork.CloseReasons,
CloseTime = heightWork.CloseTime,
NextManId = heightWork.NextManId,
States = heightWork.States,
};
db.License_HeightWork.InsertOnSubmit(newHeightWork);
db.SubmitChanges();
////增加一条编码记录
CodeRecordsService.InsertCodeRecordsByMenuIdProjectIdUnitId(Const.ProjectHeightWorkMenuId, heightWork.ProjectId, heightWork.ApplyUnitId, heightWork.HeightWorkId, heightWork.ApplyDate);
}
/// <summary>
/// 根据主键删除高处作业票
/// </summary>
/// <param name="heightWorkId"></param>
public static void DeleteHeightWorkById(string heightWorkId)
{
Model.SUBHSSEDB db = Funs.DB;
Model.License_HeightWork heightWork = db.License_HeightWork.FirstOrDefault(e => e.HeightWorkId == heightWorkId);
if (heightWork != null)
{
///删除编码表记录
CodeRecordsService.DeleteCodeRecordsByDataId(heightWorkId);
///删除-安全措施
DeleteLicenseItemByDataId(heightWorkId);
///删除作业票审核信息
DeleteFlowOperateByDataId(heightWorkId);
db.License_HeightWork.DeleteOnSubmit(heightWork);
db.SubmitChanges();
}
}
/// <summary>
/// 修改高处作业票
/// </summary>
/// <param name="heightWork"></param>
public static void UpdateHeightWork(Model.License_HeightWork heightWork)
{
Model.SUBHSSEDB db = Funs.DB;
Model.License_HeightWork newHeightWork = db.License_HeightWork.FirstOrDefault(e => e.HeightWorkId == heightWork.HeightWorkId);
if (newHeightWork != null)
{
newHeightWork.WorkPalce = heightWork.WorkPalce;
newHeightWork.WorkType = heightWork.WorkType;
newHeightWork.ValidityStartTime = heightWork.ValidityStartTime;
newHeightWork.ValidityEndTime = heightWork.ValidityEndTime;
newHeightWork.WorkMeasures = heightWork.WorkMeasures;
newHeightWork.EquipmentTools = heightWork.EquipmentTools;
newHeightWork.CancelManId = heightWork.CancelManId;
newHeightWork.CancelReasons = heightWork.CancelReasons;
newHeightWork.CancelTime = heightWork.CancelTime;
newHeightWork.CloseManId = heightWork.CloseManId;
newHeightWork.CloseReasons = heightWork.CloseReasons;
newHeightWork.CloseTime = heightWork.CloseTime;
newHeightWork.NextManId = heightWork.NextManId;
newHeightWork.States = heightWork.States;
db.SubmitChanges();
}
}
