public async void GetAsync()
{
var date = DateTime.Now.AddMonths(-1);
var query = new WhereQueryable <CustomerDTO>((x) => x.CreatedTime >= date);
var query1 = new WhereJoinQueryable <User, User, Contact, CustomerDynamicField>((y, yy, z, zzz) => true);
//var a = await GetListAsync(x => true, (y, yy, z, zzz) => true, 20, 0, "PreUser,PostUser,Contacts,CustomerDynamicFields", new List<OrderByEntity> { new OrderByEntity { IsAsc = false, KeyWord = "LastPaidTime", IsMainTable = true } });
var b = await CountAsync(query, query1, "PreUser,PostUser,Contacts,CustomerDynamicFields");
}
public async void Get()
{
var mainQuery = new WhereQueryable <CustomerDTO, User, User>((x, y, yy) => true);
var joinQuery = new WhereJoinQueryable <CustomerDynamicField, Contact>((w, d) => true);
mainQuery = mainQuery.WhereAnd((x, y, yy) => x.ID == "1");
var data = await GetAsync(mainQuery, joinQuery, "PreUser,PostUser", "Contacts");
}
public void GetAsync()
{
var date = DateTime.Now.AddMonths(-1);
var query = new WhereQueryable <CustomerDTO, User, User, Customer>((x, y, yy, z) => x.IsSubmit == true);
var query0 = new WhereQueryable <CustomerDTO, User, User, CustomerDynamicField>((x, y, yy, d) => true);
var query1 = new WhereJoinQueryable <Contact, CustomerDynamicField>((z, zzz) => z.Content.Contains("'13321952950'"));
//var a = await GetListAsync(x => true, (y, yy, z, zzz) => true, 20, 0, "PreUser,PostUser,Contacts,CustomerDynamicFields", new List<OrderByEntity> { new OrderByEntity { IsAsc = false, KeyWord = "LastPaidTime", IsMainTable = true } });
//var b = await GetListAsync(query, query1, 20, 0, "PreUser,PostUser", "Contacts,CustomerDynamicFields");
//query.WhereAnd((x, y, yy) => true);
//query1.WhereAnd((z, zz) => true);
//query0.WhereAnd((x, y, yy, z, zzz) => true);
query0 = query0.WhereAnd((x, y, yy, d) => d.DynamicFieldID == "7" && d.FieldKey == "310300");
var bb = GetListAsync(query, 20, 0, "PreUser,PostUser,IntroducerCustomer").Result;
//var cc = CountAsync(query0, "PreUser,PostUser,CustomerDynamicFields").Result;
}
public async void GetAsync()
{
var date = DateTime.Now.AddMonths(-1);
var query = new WhereQueryable <CustomerDTO, User, User, CustomerDynamicField, Order>((x, y, yy, d, o) => true);
var query0 = new WhereQueryable <CustomerDTO, User, User, CustomerDynamicField, Contact>((x, y, yy, d, w) => true);
var query1 = new WhereJoinQueryable <CustomerDynamicField>((z) => true);
var query2 = new WhereQueryable <CustomerDTO, User, User, Contact>((x, y, yy, d) => true);
//var a = await GetListAsync(x => true, (y, yy, z, zzz) => true, 20, 0, "PreUser,PostUser,Contacts,CustomerDynamicFields", new List<OrderByEntity> { new OrderByEntity { IsAsc = false, KeyWord = "LastPaidTime", IsMainTable = true } });
//var b = await GetListAsync(query, query1, 20, 0, "PreUser,PostUser", "Contacts,CustomerDynamicFields");
//query.WhereAnd((x, y, yy) => true);
//query1.WhereAnd((z, zz) => true);
//query0.WhereAnd((x, y, yy, z, zzz) => true);
var include = "PreUser,PostUser";
//include += ",Contacts,'',Contacts";
//var nickname = "wang(aaa)";
//query0 = query0.WhereAnd((x, y, yy, d, w) => d.DynamicFieldID == "3");
//var bb = GetListAsync(query, query1, 20, 0, "PreUser,PostUser,CustomerDynamicFields,Orders", "CustomerDynamicFields").Result;
//query2 = query2.WhereAnd((x, y, yy, d) => d.Content.Contains("'13321952950'"));
var bb = GetAsync(query2, query1, include + ",Contacts", "CustomerDynamicFields").Result;
//var a = await DAL.ExecuteQuerySQLAsync<Customer>("select a.ID,a.CustomerNum,a.LastPaidTime from `customer` where a.IsSubmit = True");
}
