public static async Task <int> FromDBCountAsync(this UserBasicDataContainer item)
{
var query = new DBQuery_User_Select_Count();
await DBThread.Instance.ReqQueryAsync(query);
return(query.OUT.Count);
}
public static async Task <int> FromDBByEMailsAsync(this UserBasicDataContainer item, string[] emails)
{
item.Clear();
if (emails.Length == 0)
{
return(0);
}
List <DBQuery_User_Select_By_EMail> queries = new List <DBQuery_User_Select_By_EMail>();
foreach (var it_email in emails)
{
var query = new DBQuery_User_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> FromDBByCreateTimeAsync(this UserDataContainer item
, DateTime beginCreateTime, DateTime endCreateTime, bool sortByCreateTimeDesc, int offset = 0, int limit = 10)
{
item.Clear();
UserBasicDataContainer basicDataContainer = new UserBasicDataContainer();
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 UserData = new UserData();
UserData.BasicData = it;
item.Add(UserData);
tasks.Add(UserData.FromDBByUserIdAsync(it.UserId, false));
}
await Task.WhenAll(tasks.ToArray());
return(item.Count);
}
public static async Task <int> FromDBByLikeEMailAsync(this UserDataContainer item, string email, int offset, int limit = 10)
{
item.Clear();
UserBasicDataContainer basicDataContainer = new UserBasicDataContainer();
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 UserData = new UserData();
UserData.BasicData = it;
item.Add(UserData);
tasks.Add(UserData.FromDBByUserIdAsync(it.UserId, false));
}
await Task.WhenAll(tasks.ToArray());
return(item.Count);
}
public static async Task <int> FromDBByLikeEMailCountAsync(this UserBasicDataContainer item, string email)
{
var query = new DBQuery_User_Select_By_LikeEMail_Count();
query.IN.EMail = email;
await DBThread.Instance.ReqQueryAsync(query);
return(query.OUT.Count);
}
public static async Task <int> FromDBByLikeEMailAsync(this UserBasicDataContainer item, string email, int offset = 0, int limit = 10)
{
item.Clear();
var query = new DBQuery_User_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 UserBasicDataContainer item
, DateTime beginCreateTime, DateTime endCreateTime, bool sortByCreateTimeDesc, int offset = 0, int limit = 10)
{
item.Clear();
var query = new DBQuery_User_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);
}
