/// <summary>
/// 模拟数据库分页（实际项目中请直接使用SQL语句返回分页数据！）
/// </summary>
/// <returns></returns>
private DataTable GetPagedDataTable(int pageIndex, int pageSize, int recordCount)
{
DataTable source = DataSourceUtil.GetTreeDataTable();
DataTable topTable = GetTopNodeTable(source);
DataTable paged = source.Clone();
int rowbegin = pageIndex * pageSize;
int rowend = (pageIndex + 1) * pageSize;
if (rowend > recordCount)
{
rowend = recordCount;
}
for (int i = rowbegin; i < rowend; i++)
{
DataRow topTableRow = topTable.Rows[i];
paged.ImportRow(topTableRow);
ImportCurrentPageTable(source, paged, Convert.ToInt32(topTableRow["Id"]));
}
return(paged);
}
// GET: GridDataUrl/TreeGridData
public ActionResult Index()
{
JArray ja = new JArray();
DataTable source = DataSourceUtil.GetTreeDataTable();
foreach (DataRow row in source.Rows)
{
JObject jo = new JObject();
jo.Add("ParentId", (int)row["ParentId"]);
jo.Add("Id", (int)row["Id"]);
jo.Add("Name", row["Name"].ToString());
jo.Add("Type", row["Type"].ToString());
jo.Add("ModifyDate", (DateTime)row["ModifyDate"]);
object fileSize = row["Size"];
if (fileSize == DBNull.Value)
{
jo.Add("Size", "");
}
else
{
jo.Add("Size", (int)fileSize);
}
ja.Add(jo);
}
return(Content(ja.ToString(Newtonsoft.Json.Formatting.None)));
}
// 模拟在服务器端保存数据
// 特别注意：在真实的开发环境中，不要在Session放置大量数据，否则会严重影响服务器性能
private DataTable GetSourceData()
{
if (Session[KEY_FOR_DATASOURCE_SESSION] == null)
{
Session[KEY_FOR_DATASOURCE_SESSION] = DataSourceUtil.GetTreeDataTable();
}
return((DataTable)Session[KEY_FOR_DATASOURCE_SESSION]);
}
/// <summary>
/// 模拟返回总项数
/// </summary>
/// <returns></returns>
private int GetTotalCount()
{
DataTable source = DataSourceUtil.GetTreeDataTable();
return(GetTopNodeTable(source).Rows.Count);
}
