public static void Insert115FileSha(List <FileItemModel> models, bool truncate = false) { var files = models.Where(x => !string.IsNullOrEmpty(x.fid)).ToList(); Console.WriteLine($"获取到{files.Count}个文件"); int index = 1; if (files != null && files.Any()) { if (truncate) { ScanDataBaseManager.TruncateOneOneFiveFileShaMapping(); } foreach (var file in files) { Console.WriteLine($"正在处理{index++}"); OneOneFiveFileShaMapping entity = new OneOneFiveFileShaMapping() { FileName = file.n, FileSize = file.s, Sha = file.sha, IsOnLocal = false }; ScanDataBaseManager.InserOneOneFiveFileShaMapping(entity); } } }
public static int InserOneOneFiveFileShaMapping(OneOneFiveFileShaMapping entity) { var sql = @"IF NOT EXISTS (SELECT * FROM OneOneFiveFileShaMapping WHERE Sha = @Sha) INSERT INTO OneOneFiveFileShaMapping (FileName, Sha, FileSize, UpdateTime, IsOnLocal) VALUES (@FileName, @Sha, @FileSize, GETDATE(), @IsOnLocal)"; return(Execute(ConnectionStrings.Scan, sql, entity)); }