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"); }