/// <summary>
/// 查询
/// </summary>
public void SearchDatat()
{
//查询条件
var key = Utils.SqlStringFormat(PageRequest.GetString("key"), 2);
//分页
var pageIndex = PageRequest.GetInt("pageIndex", 1);
var pageSize = PageRequest.GetInt("pageSize", 1);
//字段排序
var sortField = PageRequest.GetString("sortField");
var sortOrder = PageRequest.GetString("sortOrder");
var order = "";
if (String.IsNullOrEmpty(sortField) == false)
{
if (sortOrder != "desc")
{
sortOrder = "asc";
}
order = " " + sortField + " " + sortOrder;
}
else
{
order += " OrderID";
}
const string strWhere = "IsNav=1";
var dt = new AdminFlag().GetTable(-1, -1, strWhere, order);
var tempDt = dt.Clone();
foreach (DataRow model in dt.Rows)
{
if (ManageHelper.CheckAdminHavePower(model["Flag"].ToString()))
{
tempDt.Rows.Add(model.ItemArray);
}
}
var dataAll = MyDBUtils.DataTable2ArrayList(tempDt);
var result = new Hashtable();
result["data"] = dataAll;
var json = PluSoft.Utils.JSON.Encode(dataAll);
Response.Write(json);
}
