public IHttpActionResult GetActivities(string v1, int limit = 10, int page = 0, string where = null, string include = null, string order = null)
{
try
{
List <Wheres> list = new List <Wheres>();
Boolean isDesc = true;
string orderField = "updatedAt";
//条件
if (!string.IsNullOrEmpty(where))
{
list = JsonHelper.Deserialize <List <Wheres> >(where);
}
//判断页码
if (limit == 0)
{
int num = bll.QueryCount(list);
return(ok(new { results = new string[] { }, count = num }));
}
//排序
if (!string.IsNullOrEmpty(order))
{
string descStr = order.Substring(0, 1);
if (descStr.Equals("-"))
{
isDesc = true;
}
else
{
isDesc = false;
}
orderField = order.Substring(1);
}
//列集合
if (string.IsNullOrEmpty(include))
{
//为空时，查询所有列
var models = bll.QueryList(page, limit, list, orderField, isDesc);
return(ok(new { results = models }));
}
else
{
//非空时，解析所有列
Dictionary <string, string[]> columns = new Dictionary <string, string[]>();
string includeInit = include.Substring(0, include.Count() - 1);
string[] cols = includeInit.Split(new string[] { "]," }, StringSplitOptions.None);
foreach (var col in cols)
{
string[] cols1 = col.Split('[');
columns.Add(cols1[0], cols1[1].Split('|'));
}
var models = bll.QueryListX(page, limit, columns, list, orderField, isDesc);
return(ok(new { results = models }));
}
}
catch (Exception e)
{
return(execept(e.Message));
}
}
public ActionResult GetActivities(string v1, int limit = 10, int page = 0, string where = null, string include = null, string order = null)
{
try
{
List <Wheres> list = new List <Wheres>();
Boolean isDesc = true;
string orderField = "updatedAt";
//条件
if (!string.IsNullOrEmpty(where))
{
list = JsonHelper.Deserialize <List <Wheres> >(where);
}
//排序
if (!string.IsNullOrEmpty(order))
{
string descStr = order.Substring(0, 1);
if (isDesc.Equals("-"))
{
isDesc = true;
}
else
{
isDesc = false;
}
orderField = order.Substring(1);
}
//列集合
if (string.IsNullOrEmpty(include))
{
//为空时，查询所有列
var models = bll.QueryList(page, limit, list, orderField, isDesc);
return(View(models));
}
else
{
//非空时，解析所有列
Dictionary <string, string[]> columns = new Dictionary <string, string[]>();
string includeInit = include.Substring(0, include.Count() - 1);
string[] cols = includeInit.Split(new string[] { "]," }, StringSplitOptions.None);
foreach (var col in cols)
{
string[] cols1 = col.Split('[');
columns.Add(cols1[0], cols1[1].Split('|'));
}
var models = bll.QueryListX(page, limit, columns, list, orderField, isDesc);
return(View(models));
}
}
catch (Exception e)
{
return(Content("<script> alert('" + e.Message + "'); location.href = '" + Url.Action("Index", "Items") + "'</script>"));
}
}