public string GetSelectJsons(SelectName selectClip, WhereClip whereClip, OrderByClip orderByClip, GroupByClip groupByClip, int pageIndex, int pageSize, Dictionary <string, Dictionary <string, string> > dtConvert = null) { PageData <T> page = EntityGenerics <DB, T> .Instance.Select(selectClip).SetWhereClip(whereClip) .SetOrderByClip(orderByClip).SetGroupByClip(groupByClip).ToList(pageSize, pageIndex); page.Rows = ChangeSource(page.Rows, dtConvert); return(JsonConvert.SerializeObject((object)page, dateTimeJsonSerializerSettings)); }
public ReflectionGenerics SetOrderByClip(OrderByClip orderByClip) { foreach (ItemStruct item in orderByClip) { OrderByClip.Add(item); } return(this); }
public PageData <T> GetSelect(SelectName selectClip, WhereClip whereClip, OrderByClip orderByClip, GroupByClip groupByClip, int pageIndex, int pageSize, Dictionary <string, Dictionary <string, string> > dtConvert = null) { PageData <T> page = EntityGenerics <DB, T> .Instance.Select(selectClip).SetWhereClip(whereClip) .SetOrderByClip(orderByClip).SetGroupByClip(groupByClip).ToList(pageSize, pageIndex); page.Rows = ChangeSource(page.Rows, dtConvert); return(page); }
public string GetSelectJsons(SelectName selectClip, WhereClip whereClip, OrderByClip orderByClip, GroupByClip groupByClip, Dictionary <string, Dictionary <string, string> > dtConvert = null) { IEnumerable <T> lst = EntityGenerics <DB, T> .Instance.Select(selectClip).SetWhereClip(whereClip) .SetOrderByClip(orderByClip).SetGroupByClip(groupByClip).ToList(); lst = ChangeSource(lst, dtConvert); return(JsonConvert.SerializeObject((object)lst, DateTimeJsonSerializerSettings)); }
public void ClearCondition() { SelectName = new SelectName(); InsertClip = new InsertClip(); UpdateClip = new UpdateClip(); OrderByClip = new OrderByClip(); GroupByClip = new GroupByClip(); WhereClip = new WhereClip(); OtherT = new List <string>(); SKipNum = 0; TakeNum = 0; lstDbParmeters = new List <DbParameter>(); }
public void GetCondition(ref StringBuilder strBuilder) { strBuilder.Append(GetJoin()); if (WhereClip.Count > 0) { string sqlWhereClip = ""; List <DbParameter> parameters = new List <DbParameter>(); WhereClip.GetPartmerStrings(excuteImport, ref sqlWhereClip, ref parameters); lstDbParmeters.AddRange(parameters); strBuilder.Append(" WHERE " + sqlWhereClip); } if (GroupByClip.Count > 0) { strBuilder.Append(" GROUP BY " + GroupByClip.ToString()); } if (OrderByClip.Count > 0) { strBuilder.Append(" ORDER BY " + OrderByClip.ToString()); } }
public IEnumerable <T> GetList(WhereClip whereClip, OrderByClip orderByClip, Dictionary <string, Dictionary <string, string> > dtConvert = null) { IEnumerable <T> lst = EntityGenerics <DB, T> .Instance.Select().SetWhereClip(whereClip).SetOrderByClip(orderByClip).ToList(); return(ChangeSource(lst, dtConvert)); }
public string GetJson(WhereClip whereClip, OrderByClip orderByClip) { T val = Get(whereClip, orderByClip); return(JsonConvert.SerializeObject((object)val, DateTimeJsonSerializerSettings)); }
public T Get(WhereClip whereClip, OrderByClip orderByClip) { return(EntityGenerics <DB, T> .Instance.Select().SetWhereClip(whereClip).SetOrderByClip(orderByClip).ToFirst()); }