/// <summary> /// 根据主键删除项目协议记录 /// </summary> /// <param name="projectRecordId"></param> public static void DeleteProjectRecordById(string projectRecordId) { Model.SUBHSSEDB db = Funs.DB; Model.QualityAudit_ProjectRecord projectRecord = db.QualityAudit_ProjectRecord.FirstOrDefault(e => e.ProjectRecordId == projectRecordId); if (projectRecord != null) { CodeRecordsService.DeleteCodeRecordsByDataId(projectRecordId); CommonService.DeleteAttachFileById(projectRecordId); db.QualityAudit_ProjectRecord.DeleteOnSubmit(projectRecord); db.SubmitChanges(); } }
/// <summary> /// 修改项目协议记录 /// </summary> /// <param name="projectRecord"></param> public static void UpdateProjectRecord(Model.QualityAudit_ProjectRecord projectRecord) { Model.SUBHSSEDB db = Funs.DB; Model.QualityAudit_ProjectRecord newProjectRecord = db.QualityAudit_ProjectRecord.FirstOrDefault(e => e.ProjectRecordId == projectRecord.ProjectRecordId); if (newProjectRecord != null) { newProjectRecord.ProjectId = projectRecord.ProjectId; newProjectRecord.ProjectRecordCode = projectRecord.ProjectRecordCode; newProjectRecord.ProjectRecordName = projectRecord.ProjectRecordName; newProjectRecord.UnitId = projectRecord.UnitId; newProjectRecord.Remark = projectRecord.Remark; newProjectRecord.CompileMan = projectRecord.CompileMan; newProjectRecord.CompileDate = projectRecord.CompileDate; db.SubmitChanges(); } }
/// <summary> /// 添加项目协议记录 /// </summary> /// <param name="projectRecord"></param> public static void AddProjectRecord(Model.QualityAudit_ProjectRecord projectRecord) { Model.SUBHSSEDB db = Funs.DB; Model.QualityAudit_ProjectRecord newProjectRecord = new Model.QualityAudit_ProjectRecord { ProjectRecordId = projectRecord.ProjectRecordId, UnitId = projectRecord.UnitId, ProjectId = projectRecord.ProjectId, ProjectRecordCode = projectRecord.ProjectRecordCode, ProjectRecordName = projectRecord.ProjectRecordName, Remark = projectRecord.Remark, CompileMan = projectRecord.CompileMan, CompileDate = projectRecord.CompileDate }; db.QualityAudit_ProjectRecord.InsertOnSubmit(newProjectRecord); db.SubmitChanges(); CodeRecordsService.InsertCodeRecordsByMenuIdProjectIdUnitId(Const.ProjectRecordMenuId, projectRecord.ProjectId, null, projectRecord.ProjectRecordId, projectRecord.CompileDate); }