public static async Task <int> FromDBByCreateTimeAsync(this AccountDataContainer item
, DateTime beginCreateTime, DateTime endCreateTime, bool sortByCreateTimeDesc, TimeSpan timeZoneOffset, int offset = 0, int limit = 10)
{
item.Clear();
AccountBasicDataContainer basicDataContainer = new AccountBasicDataContainer();
if (await basicDataContainer.FromDBByCreateTimeAsync(beginCreateTime, endCreateTime, sortByCreateTimeDesc, offset, limit) == 0)
{
return(0);
}
List <Task <bool> > tasks = new List <Task <bool> >();
foreach (var it in basicDataContainer.Items)
{
var accountData = new AccountData();
accountData.BasicData = it;
item.Add(accountData);
tasks.Add(accountData.FromDBByAccountDBKeyAsync(it.AccountDBKey, false, timeZoneOffset));
}
await Task.WhenAll(tasks.ToArray());
return(item.Count);
}
public static async Task <int> FromDBByLikeEMailAsync(this AccountDataContainer item, string email, TimeSpan timeZoneOffset, int offset, int limit = 10)
{
item.Clear();
AccountBasicDataContainer basicDataContainer = new AccountBasicDataContainer();
if (await basicDataContainer.FromDBByLikeEMailAsync(email, offset, limit) == 0)
{
return(0);
}
List <Task <bool> > tasks = new List <Task <bool> >();
foreach (var it in basicDataContainer.Items)
{
var accountData = new AccountData();
accountData.BasicData = it;
item.Add(accountData);
tasks.Add(accountData.FromDBByAccountDBKeyAsync(it.AccountDBKey, false, timeZoneOffset));
}
await Task.WhenAll(tasks.ToArray());
return(item.Count);
}
public static async Task <int> FromDBCountAsync(this AccountBasicDataContainer item)
{
var query = new DBQuery_Account_Select_Count();
await DBThread.Instance.ReqQueryAsync(query);
return(query.OUT.Count);
}
public static async Task <int> FromDBByEMailsAsync(this AccountBasicDataContainer item, string[] emails)
{
item.Clear();
if (emails.Length == 0)
{
return(0);
}
List <DBQuery_Account_Select_By_EMail> queries = new List <DBQuery_Account_Select_By_EMail>();
foreach (var it_email in emails)
{
var query = new DBQuery_Account_Select_By_EMail();
query.IN.EMail = it_email;
queries.Add(query);
}
await DBThread.Instance.ReqQueryAsync(queries.ToArray());
foreach (var it in queries)
{
if (it.OUT.FirstItem == null)
{
continue;
}
item.Add(it.OUT.FirstItem);
}
return(item.Count);
}
public static async Task <int> FromDBByLikeEMailCountAsync(this AccountBasicDataContainer item, string email)
{
var query = new DBQuery_Account_Select_By_LikeEMail_Count();
query.IN.EMail = email;
await DBThread.Instance.ReqQueryAsync(query);
return(query.OUT.Count);
}
public static async Task <int> FromDBByLikeEMailAsync(this AccountBasicDataContainer item, string email, int offset = 0, int limit = 10)
{
item.Clear();
var query = new DBQuery_Account_Select_By_LikeEMail();
query.IN.EMail = email;
query.IN.Offset = offset;
query.IN.Limit = limit;
var result = await DBThread.Instance.ReqQueryAsync(query);
query.OUT.Items.CopyTo(ref item);
return(item.Count);
}
public static async Task <int> FromDBByCreateTimeAsync(this AccountBasicDataContainer item
, DateTime beginCreateTime, DateTime endCreateTime, bool sortByCreateTimeDesc, int offset = 0, int limit = 10)
{
item.Clear();
var query = new DBQuery_Account_Select_By_CreateTime();
query.IN.BeginCreateTime = beginCreateTime;
query.IN.EndCreateTime = endCreateTime;
query.IN.SortByCreateTimeDesc = sortByCreateTimeDesc;
query.IN.Offset = offset;
query.IN.Limit = limit;
var result = await DBThread.Instance.ReqQueryAsync(query);
query.OUT.Items.CopyTo(ref item);
return(item.Count);
}