public IEnumerable <T> GetSelect(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();
return(ChangeSource(lst, dtConvert));
}
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 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));
}
private string GetSelectField()
{
//如果没有selectName，默认搜索全部,返回*
if (SelectName.Count <= 0)
{
return("*");
}
return(SelectName.ToString());
}
public ReflectionGenerics Select(SelectName selectName)
{
ClearCondition();
foreach (ColumnStruct item in selectName)
{
SelectName.Add(item);
}
return(this);
}
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>();
}
