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);
}
