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