/// <summary> /// 根据主键删除特种机具设备入场报批明细 /// </summary> /// <param name="equipmentInItemId"></param> public static void DeleteEquipmentInItemById(string equipmentInItemId) { Model.SUBHSSEDB db = Funs.DB; Model.InApproveManager_EquipmentInItem equipmenetInItem = db.InApproveManager_EquipmentInItem.FirstOrDefault(e => e.EquipmentInItemId == equipmentInItemId); if (equipmenetInItem != null) { db.InApproveManager_EquipmentInItem.DeleteOnSubmit(equipmenetInItem); db.SubmitChanges(); } }
/// <summary> /// 修改特种机具设备入场报批明细 /// </summary> /// <param name="equipmentInItem"></param> public static void UpdateEquipmentInItem(Model.InApproveManager_EquipmentInItem equipmentInItem) { Model.SUBHSSEDB db = Funs.DB; Model.InApproveManager_EquipmentInItem newEquipmentItem = db.InApproveManager_EquipmentInItem.FirstOrDefault(e => e.EquipmentInItemId == equipmentInItem.EquipmentInItemId); if (newEquipmentItem != null) { newEquipmentItem.EquipmentInId = equipmentInItem.EquipmentInId; newEquipmentItem.SpecialEquipmentId = equipmentInItem.SpecialEquipmentId; newEquipmentItem.SizeModel = equipmentInItem.SizeModel; newEquipmentItem.OwnerCheck = equipmentInItem.OwnerCheck; newEquipmentItem.CertificateNum = equipmentInItem.CertificateNum; newEquipmentItem.SafetyInspectionNum = equipmentInItem.SafetyInspectionNum; newEquipmentItem.DrivingLicenseNum = equipmentInItem.DrivingLicenseNum; newEquipmentItem.RegistrationNum = equipmentInItem.RegistrationNum; newEquipmentItem.OperationQualificationNum = equipmentInItem.OperationQualificationNum; newEquipmentItem.InsuranceNum = equipmentInItem.InsuranceNum; newEquipmentItem.CommercialInsuranceNum = equipmentInItem.CommercialInsuranceNum; db.SubmitChanges(); } }
/// <summary> /// 添加特种机具设备入场报批明细 /// </summary> /// <param name="equipmentInItem"></param> public static void AddEquipmentInItem(Model.InApproveManager_EquipmentInItem equipmentInItem) { Model.SUBHSSEDB db = Funs.DB; Model.InApproveManager_EquipmentInItem newEquipmentItem = new Model.InApproveManager_EquipmentInItem { EquipmentInItemId = equipmentInItem.EquipmentInItemId, EquipmentInId = equipmentInItem.EquipmentInId, SpecialEquipmentId = equipmentInItem.SpecialEquipmentId, SizeModel = equipmentInItem.SizeModel, OwnerCheck = equipmentInItem.OwnerCheck, CertificateNum = equipmentInItem.CertificateNum, SafetyInspectionNum = equipmentInItem.SafetyInspectionNum, DrivingLicenseNum = equipmentInItem.DrivingLicenseNum, RegistrationNum = equipmentInItem.RegistrationNum, OperationQualificationNum = equipmentInItem.OperationQualificationNum, InsuranceNum = equipmentInItem.InsuranceNum, CommercialInsuranceNum = equipmentInItem.CommercialInsuranceNum }; db.InApproveManager_EquipmentInItem.InsertOnSubmit(newEquipmentItem); db.SubmitChanges(); }