public async Task <int> SyncClients(string userid, string token) { var currentUser = HttpContext.Current.User.Identity.Name; // 先到clockify获取数据 var ls = await _clockifyService.GetClients(userid, token); var list = new List <Client>(); foreach (var l in ls) { list.Add(new Client() { Gid = l.id, Name = l.name, Note = l.note, CreatedDate = DateTime.Now, CreatedUserID = currentUser, CreatedUserName = currentUser, IsDeleted = false, UpdatedDate = DateTime.Now, UpdatedUserID = currentUser, UpdatedUserName = currentUser }); } // 然后在本地插入或者同步数据 var affectedRecordCount = _clientService.Repository.SqlExcute("truncate table [Client]"); affectedRecordCount = await _clientService.Repository.InsertAsync(list); return(affectedRecordCount); }
public async Task <int> SyncClients(string userid, string token) { // 先到clockify获取数据 var ls = await _clockifyService.GetClients(userid, token); var list = new List <Client>(); foreach (var l in ls) { list.Add(new Client() { Gid = l.id, Name = l.name, Note = l.note, CreatedDate = DateTime.Now, CreatedUserID = userid, CreatedUserName = userid, IsDeleted = false, UpdatedDate = DateTime.Now, UpdatedUserID = userid, UpdatedUserName = userid }); } // 然后在本地插入或者同步数据 await _clientService.Clear(); var affectedRecordCount = await _clientService.AddManyAsync(list); return(affectedRecordCount); }