public async Task <int> InsertWebScanUrlModel(WebScanUrlModel entity) { var sql = @"IF NOT EXISTS (SELECT * FROM ScanUrl WITH(NOLOCK) WHERE Url = @Url) BEGIN INSERT INTO ScanUrl (AvId, Name, Url, IsDownload, CreateTime, UpdateTime) VALUES (@AvId, @Name, @Url, @IsDownload, GETDATE(), GETDATE()); SELECT @@IDENTITY; END ELSE BEGIN SELECT 0; END"; return(await QuerySingleOrDefaultAsync <int>(sql, entity)); }
//保存扫描URL模型 public async static Task <int> SaveWebScanUrlModel(WebScanUrlModel entity) { int ret = 0; switch (entity.ScanUrlSite) { case WebScanUrlSite.JavLibrary: ret = await new JavLibraryDAL().InsertWebScanUrlModel(entity); break; case WebScanUrlSite.JavBus: break; } return(ret); }