/// <summary> /// 修改分包商资质 /// </summary> /// <param name="subUnitQuality"></param> public static void UpdateSubUnitQuality(Model.QualityAudit_SubUnitQuality subUnitQuality) { Model.SUBHSSEDB db = Funs.DB; Model.QualityAudit_SubUnitQuality newSubUnitQuality = db.QualityAudit_SubUnitQuality.FirstOrDefault(e => e.SubUnitQualityId == subUnitQuality.SubUnitQualityId); if (newSubUnitQuality != null) { newSubUnitQuality.UnitId = subUnitQuality.UnitId; newSubUnitQuality.SubUnitQualityCode = subUnitQuality.SubUnitQualityCode; newSubUnitQuality.SubUnitQualityName = subUnitQuality.SubUnitQualityName; newSubUnitQuality.BusinessLicense = subUnitQuality.BusinessLicense; newSubUnitQuality.BL_EnableDate = subUnitQuality.BL_EnableDate; newSubUnitQuality.BL_ScanUrl = subUnitQuality.BL_ScanUrl; newSubUnitQuality.OrganCode = subUnitQuality.OrganCode; newSubUnitQuality.O_EnableDate = subUnitQuality.O_EnableDate; newSubUnitQuality.O_ScanUrl = subUnitQuality.O_ScanUrl; newSubUnitQuality.Certificate = subUnitQuality.Certificate; newSubUnitQuality.C_EnableDate = subUnitQuality.C_EnableDate; newSubUnitQuality.C_ScanUrl = subUnitQuality.C_ScanUrl; newSubUnitQuality.QualityLicense = subUnitQuality.QualityLicense; newSubUnitQuality.QL_EnableDate = subUnitQuality.QL_EnableDate; newSubUnitQuality.QL_ScanUrl = subUnitQuality.QL_ScanUrl; newSubUnitQuality.HSELicense = subUnitQuality.HSELicense; newSubUnitQuality.H_EnableDate = subUnitQuality.H_EnableDate; newSubUnitQuality.H_ScanUrl = subUnitQuality.H_ScanUrl; newSubUnitQuality.HSELicense2 = subUnitQuality.HSELicense2; newSubUnitQuality.H_EnableDate2 = subUnitQuality.H_EnableDate2; newSubUnitQuality.H_ScanUrl2 = subUnitQuality.H_ScanUrl2; newSubUnitQuality.SecurityLicense = subUnitQuality.SecurityLicense; newSubUnitQuality.SL_EnableDate = subUnitQuality.SL_EnableDate; newSubUnitQuality.SL_ScanUrl = subUnitQuality.SL_ScanUrl; newSubUnitQuality.CompileMan = subUnitQuality.CompileMan; newSubUnitQuality.CompileDate = subUnitQuality.CompileDate; db.SubmitChanges(); } }
/// <summary> /// 根据主键删除分包商资质 /// </summary> /// <param name="subUnitQualityId"></param> public static void DeleteSubUnitQualityById(string subUnitQualityId) { Model.SUBHSSEDB db = Funs.DB; Model.QualityAudit_SubUnitQuality subUnitQuality = db.QualityAudit_SubUnitQuality.FirstOrDefault(e => e.SubUnitQualityId == subUnitQualityId); if (subUnitQuality != null) { if (!string.IsNullOrEmpty(subUnitQuality.BL_ScanUrl)) { UploadFileService.DeleteFile(Funs.RootPath, subUnitQuality.BL_ScanUrl); } if (!string.IsNullOrEmpty(subUnitQuality.O_ScanUrl)) { UploadFileService.DeleteFile(Funs.RootPath, subUnitQuality.O_ScanUrl); } if (!string.IsNullOrEmpty(subUnitQuality.C_ScanUrl)) { UploadFileService.DeleteFile(Funs.RootPath, subUnitQuality.C_ScanUrl); } if (!string.IsNullOrEmpty(subUnitQuality.QL_ScanUrl)) { UploadFileService.DeleteFile(Funs.RootPath, subUnitQuality.QL_ScanUrl); } if (!string.IsNullOrEmpty(subUnitQuality.H_ScanUrl)) { UploadFileService.DeleteFile(Funs.RootPath, subUnitQuality.H_ScanUrl); } if (!string.IsNullOrEmpty(subUnitQuality.H_ScanUrl2)) { UploadFileService.DeleteFile(Funs.RootPath, subUnitQuality.H_ScanUrl2); } if (!string.IsNullOrEmpty(subUnitQuality.SL_ScanUrl)) { UploadFileService.DeleteFile(Funs.RootPath, subUnitQuality.SL_ScanUrl); } CodeRecordsService.DeleteCodeRecordsByDataId(subUnitQualityId); db.QualityAudit_SubUnitQuality.DeleteOnSubmit(subUnitQuality); db.SubmitChanges(); } }
/// <summary> /// 添加分包商资质 /// </summary> /// <param name="subUnitQuality"></param> public static void AddSubUnitQuality(Model.QualityAudit_SubUnitQuality subUnitQuality) { Model.SUBHSSEDB db = Funs.DB; Model.QualityAudit_SubUnitQuality newSubUnitQuality = new Model.QualityAudit_SubUnitQuality { SubUnitQualityId = subUnitQuality.SubUnitQualityId, UnitId = subUnitQuality.UnitId, SubUnitQualityCode = subUnitQuality.SubUnitQualityCode, SubUnitQualityName = subUnitQuality.SubUnitQualityName, BusinessLicense = subUnitQuality.BusinessLicense, BL_EnableDate = subUnitQuality.BL_EnableDate, BL_ScanUrl = subUnitQuality.BL_ScanUrl, OrganCode = subUnitQuality.OrganCode, O_EnableDate = subUnitQuality.O_EnableDate, O_ScanUrl = subUnitQuality.O_ScanUrl, Certificate = subUnitQuality.Certificate, C_EnableDate = subUnitQuality.C_EnableDate, C_ScanUrl = subUnitQuality.C_ScanUrl, QualityLicense = subUnitQuality.QualityLicense, QL_EnableDate = subUnitQuality.QL_EnableDate, QL_ScanUrl = subUnitQuality.QL_ScanUrl, HSELicense = subUnitQuality.HSELicense, H_EnableDate = subUnitQuality.H_EnableDate, H_ScanUrl = subUnitQuality.H_ScanUrl, HSELicense2 = subUnitQuality.HSELicense2, H_EnableDate2 = subUnitQuality.H_EnableDate2, H_ScanUrl2 = subUnitQuality.H_ScanUrl2, SecurityLicense = subUnitQuality.SecurityLicense, SL_EnableDate = subUnitQuality.SL_EnableDate, SL_ScanUrl = subUnitQuality.SL_ScanUrl, CompileMan = subUnitQuality.CompileMan, CompileDate = subUnitQuality.CompileDate }; db.QualityAudit_SubUnitQuality.InsertOnSubmit(newSubUnitQuality); db.SubmitChanges(); }