private void DoJob() { var watcher = new Stopwatch(); var taskId = new Guid("6128230d-8a6d-495a-91e2-08fd476d9355");//关注公众号TaskId //var taskId = new Guid("5897E3CC-5B7C-49BB-AF5F-22780DDCE234");//dev const int userCount = 1484709; Logger.Info($"共{userCount}条用户信息进行需要首单初始化"); const int step = 3000; var start = 0; while (start < userCount) { watcher.Start(); var userList = DalTask.GetBindWxInfoList(start, step, false); var count = 0; var result = new Tuple <int, int>(0, 0); if (userList.Any()) { var data = userList.Where(g => g.AuthSource.ToLower().Equals("weixin") && g.BindingStatus.ToLower().Equals("bound") && g.UserId != null && !string.IsNullOrWhiteSpace(g.UnionId)) .Select(g => g.UserId.Value).Distinct().ToList(); var dat = DalTask.CheckTaskUserId(data, taskId, Logger); count = dat.Count; if (count > 0) { result = DalTask.InitUserTaskInfo(dat, taskId, "5Follow", Logger); } } watcher.Stop(); Logger.Info( $"关注公众号任务初始化,最大的PKID==>{start + step},第{start / step + 1}批数据,共{userCount / step + 1}批,有效数据{count}条,插入用户任务表共==>{result.Item1}条,插入用户任务详情==>{result.Item2}条数据,用时{watcher.ElapsedMilliseconds}毫秒"); watcher.Reset(); start += step; } watcher.Stop(); }
private static void DoJob() { var watcher = new Stopwatch(); var taskId = new Guid("6cf07554-9b2e-4e18-9c73-5e15c16a801c");//绑定微信TaskId //var taskId = new Guid("6A19450D-A1C1-455F-B49D-06EDEF6A1827");//dev const int userCount = 2552500; Logger.Info($"共{userCount}条用户信息进行绑定微信初始化"); const int step = 3000; var start = 0; while (start < userCount) { watcher.Start(); var userList = DalTask.GetBindWxInfoList(start, step); var count = 0; var result = new Tuple <int, int>(0, 0); if (userList.Any()) { var data = userList.Where(g => g.AuthSource.ToLower().Equals("weixin") && g.BindingStatus.ToLower().Equals("bound") && g.UserId != null) .Select(g => g.UserId.Value).Distinct().ToList(); var dat = DalTask.CheckTaskUserId(data, taskId, Logger); count = dat.Count; if (count > 0) { result = DalTask.InitUserTaskInfo(dat, taskId, "4BindWX", Logger); } } watcher.Stop(); Logger.Info($"绑定微信任务初始化,最大的PKID==>{start + step},第{start / step + 1}批数据,共{userCount / step + 1}批,有效数据{count}条,插入用户任务表共==>{result.Item1}条,插入用户任务详情==>{result.Item2}条数据,用时{watcher.ElapsedMilliseconds}毫秒"); watcher.Reset(); start += step; } watcher.Stop(); }