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 async void GetUnreadCountAsync(int type) { var query = new WhereQueryable <NotificationDTO, NotificationMark>((x, y) => y.UserID == "9" && x.IsRead == false & y.IsDeleted == false); if (type != 0) { query = query.WhereAnd((x, y) => x.Type == type); } var a = await GetAsync(x => true, "NotificationMarks"); }
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; }