/// <summary> /// 根据主键删除一般机具设备资质 /// </summary> /// <param name="generalEquipmentQualityId"></param> public static void DeleteGeneralEquipmentQualityById(string generalEquipmentQualityId) { Model.SUBHSSEDB db = Funs.DB; Model.QualityAudit_GeneralEquipmentQuality generalEquipmentQuality = db.QualityAudit_GeneralEquipmentQuality.FirstOrDefault(e => e.GeneralEquipmentQualityId == generalEquipmentQualityId); if (generalEquipmentQuality != null) { CodeRecordsService.DeleteCodeRecordsByDataId(generalEquipmentQualityId); CommonService.DeleteAttachFileById(generalEquipmentQualityId); db.QualityAudit_GeneralEquipmentQuality.DeleteOnSubmit(generalEquipmentQuality); db.SubmitChanges(); } }
/// <summary> /// 修改一般机具设备资质 /// </summary> /// <param name="generalEquipmentQuality"></param> public static void UpdateGeneralEquipmentQuality(Model.QualityAudit_GeneralEquipmentQuality generalEquipmentQuality) { Model.SUBHSSEDB db = Funs.DB; Model.QualityAudit_GeneralEquipmentQuality newGeneralEquipmentQuality = db.QualityAudit_GeneralEquipmentQuality.FirstOrDefault(e => e.GeneralEquipmentQualityId == generalEquipmentQuality.GeneralEquipmentQualityId); if (newGeneralEquipmentQuality != null) { newGeneralEquipmentQuality.ProjectId = generalEquipmentQuality.ProjectId; newGeneralEquipmentQuality.GeneralEquipmentQualityCode = generalEquipmentQuality.GeneralEquipmentQualityCode; newGeneralEquipmentQuality.UnitId = generalEquipmentQuality.UnitId; newGeneralEquipmentQuality.SpecialEquipmentId = generalEquipmentQuality.SpecialEquipmentId; newGeneralEquipmentQuality.EquipmentCount = generalEquipmentQuality.EquipmentCount; newGeneralEquipmentQuality.IsQualified = generalEquipmentQuality.IsQualified; newGeneralEquipmentQuality.Remark = generalEquipmentQuality.Remark; newGeneralEquipmentQuality.CompileMan = generalEquipmentQuality.CompileMan; newGeneralEquipmentQuality.CompileDate = generalEquipmentQuality.CompileDate; newGeneralEquipmentQuality.InDate = generalEquipmentQuality.InDate; newGeneralEquipmentQuality.QRCodeAttachUrl = generalEquipmentQuality.QRCodeAttachUrl; db.SubmitChanges(); } }
/// <summary> /// 添加一般机具设备资质 /// </summary> /// <param name="generalEquipmentQuality"></param> public static void AddGeneralEquipmentQuality(Model.QualityAudit_GeneralEquipmentQuality generalEquipmentQuality) { Model.SUBHSSEDB db = Funs.DB; Model.QualityAudit_GeneralEquipmentQuality newGeneralEquipmentQuality = new Model.QualityAudit_GeneralEquipmentQuality { GeneralEquipmentQualityId = generalEquipmentQuality.GeneralEquipmentQualityId, ProjectId = generalEquipmentQuality.ProjectId, GeneralEquipmentQualityCode = generalEquipmentQuality.GeneralEquipmentQualityCode, UnitId = generalEquipmentQuality.UnitId, SpecialEquipmentId = generalEquipmentQuality.SpecialEquipmentId, EquipmentCount = generalEquipmentQuality.EquipmentCount, IsQualified = generalEquipmentQuality.IsQualified, Remark = generalEquipmentQuality.Remark, CompileMan = generalEquipmentQuality.CompileMan, CompileDate = generalEquipmentQuality.CompileDate, InDate = generalEquipmentQuality.InDate }; db.QualityAudit_GeneralEquipmentQuality.InsertOnSubmit(newGeneralEquipmentQuality); db.SubmitChanges(); CodeRecordsService.InsertCodeRecordsByMenuIdProjectIdUnitId(Const.GeneralEquipmentQualityMenuId, generalEquipmentQuality.ProjectId, null, generalEquipmentQuality.GeneralEquipmentQualityId, generalEquipmentQuality.CompileDate); }