private void BindGrid1()
{
if (Grid2.SelectedRowIndex < 0)
{
return;
}
int classId = Convert.ToInt32(Grid2.DataKeys[Grid2.SelectedRowIndex][0]);
DataTable table = null;
if (classId == 101)
{
table = DataSourceUtil.GetDataTable();
}
else
{
table = DataSourceUtil.GetDataTable2();
}
Grid1.DataSource = table;
Grid1.DataBind();
UpdateClassDesc(classId);
}
private void BindGrid()
{
DataTable table = DataSourceUtil.GetDataTable();
Grid1.DataSource = table;
Grid1.DataBind();
}
// 表格过滤
public DataTable GetFilteredTable(JArray filteredData)
{
// 示例使用的模拟数据是一次性返回的，因此我们需要新建一个 DataTable 来过滤返回的数据
// 注：实际应用环境请不要这么做！！！（可以将过滤条件直接用于数据库检索）
DataTable source = DataSourceUtil.GetDataTable();
DataTable result = source.Clone();
foreach (DataRow row in source.Rows)
{
bool filtered = true;
foreach (JObject filteredObj in filteredData)
{
if (!CheckDataRow(row, filteredObj))
{
filtered = false;
break;
}
}
if (filtered)
{
result.Rows.Add(row.ItemArray);
}
}
return(result);
}
private DataTable GetFilteredData(string gender, string[] majors)
{
DataTable table = DataSourceUtil.GetDataTable();
DataView view = table.DefaultView;
List <string> filters = new List <string>();
// 性别过滤
if (!String.IsNullOrEmpty(gender))
{
filters.Add(String.Format("Gender = {0}", gender));
}
// 专业过滤
if (majors != null && majors.Length > 0)
{
List <string> majorFilters = new List <string>();
foreach (string ddb in majors)
{
majorFilters.Add(String.Format("Major = '{0}'", ddb));
}
filters.Add("(" + String.Join(" OR ", majorFilters.ToArray()) + ")");
}
if (filters.Count > 0)
{
view.RowFilter = String.Join(" AND ", filters.ToArray());
}
return(table);
}
// GET: GridDataUrl/GridDataUrlData
public ActionResult Index(bool?data2)
{
JArray ja = new JArray();
DataTable source = null;
if (data2.HasValue && data2.Value)
{
source = DataSourceUtil.GetDataTable2();
}
else
{
source = DataSourceUtil.GetDataTable();
}
foreach (DataRow row in source.Rows)
{
JObject jo = new JObject();
jo.Add("Id", (int)row["Id"]);
jo.Add("Name", row["Name"].ToString());
jo.Add("Gender", (int)row["Gender"]);
jo.Add("EntranceYear", (int)row["EntranceYear"]);
jo.Add("AtSchool", (bool)row["AtSchool"]);
jo.Add("Major", row["Major"].ToString());
jo.Add("Group", (int)row["Group"]);
ja.Add(jo);
}
return(Content(ja.ToString(Newtonsoft.Json.Formatting.None)));
}
/// <summary>
/// 模拟数据库分页（实际项目中请直接使用SQL语句返回分页数据！）
/// </summary>
/// <returns></returns>
private DataTable GetPagedDataTable(int pageIndex, int pageSize, bool?data2)
{
DataTable source = null;
if (data2.HasValue && data2.Value)
{
source = DataSourceUtil.GetDataTable2();
}
else
{
source = DataSourceUtil.GetDataTable();
}
DataTable paged = source.Clone();
int rowbegin = pageIndex * pageSize;
int rowend = (pageIndex + 1) * pageSize;
if (rowend > source.Rows.Count)
{
rowend = source.Rows.Count;
}
for (int i = rowbegin; i < rowend; i++)
{
paged.ImportRow(source.Rows[i]);
}
return(paged);
}
// 模拟在服务器端保存数据
// 特别注意：在真实的开发环境中，不要在Session放置大量数据，否则会严重影响服务器性能
private DataTable GetSourceData()
{
if (Session[KEY_FOR_DATASOURCE_SESSION] == null)
{
Session[KEY_FOR_DATASOURCE_SESSION] = DataSourceUtil.GetDataTable();
}
return((DataTable)Session[KEY_FOR_DATASOURCE_SESSION]);
}
private void BindGrid()
{
ViewState["UseDataSource1"] = true;
DataTable table = DataSourceUtil.GetDataTable();
Grid1.DataSource = table;
Grid1.DataBind();
}
private void BindGrid()
{
DataTable table = DataSourceUtil.GetDataTable();
Grid1.DataSource = table;
Grid1.DataBind();
Grid1.SelectedRowIndexArray = new int[] { 4, 9 };
}
// GET: Grid/ExcelGroupField/ExportToExcel
public ActionResult ExportToExcel(JArray content)
{
DataTable source = DataSourceUtil.GetDataTable();
//string TH_HTML = "<th>{0}</th>";
string TD_HTML = "<td>{0}</td>";
//string TD_IMAGE_HTML = "<td><img src=\"{0}\"></td>";
StringBuilder sb = new StringBuilder();
sb.Append("<meta http-equiv=\"Content-Type\" content=\"application/vnd.ms-excel;charset=utf-8\"/>");
sb.Append("<table cellspacing=\"0\" rules=\"all\" border=\"1\" style=\"border-collapse:collapse;\">");
MultiHeaderTable mht = new MultiHeaderTable();
mht.ResolveMultiHeaderTable(content);
foreach (List <object[]> rows in mht.MultiTable)
{
sb.Append("<tr>");
foreach (object[] cell in rows)
{
int rowspan = Convert.ToInt32(cell[0]);
int colspan = Convert.ToInt32(cell[1]);
JObject column = cell[2] as JObject;
sb.AppendFormat("<th{0}{1}{2}>{3}</th>",
rowspan != 1 ? " rowspan=\"" + rowspan + "\"" : "",
colspan != 1 ? " colspan=\"" + colspan + "\"" : "",
colspan != 1 ? " style=\"text-align:center;\"" : "",
column.Value <string>("text"));
}
sb.Append("</tr>");
}
int rowIndex = 1;
foreach (DataRow row in source.Rows)
{
sb.Append("<tr>");
sb.AppendFormat(TD_HTML, rowIndex++);
sb.AppendFormat(TD_HTML, row["Name"]);
sb.AppendFormat(TD_HTML, row["Gender"].ToString() == "1" ? "男" : "女");
sb.AppendFormat(TD_HTML, row["ChineseScore"]);
sb.AppendFormat(TD_HTML, row["MathScore"]);
sb.AppendFormat(TD_HTML, row["TotalScore"]);
sb.AppendFormat(TD_HTML, row["Major"]);
sb.AppendFormat(TD_HTML, ((DateTime)row["LogTime"]).ToString("yyyy-MM-dd"));
sb.Append("</tr>");
}
sb.Append("</table>");
return(File(Encoding.UTF8.GetBytes(sb.ToString()), "application/vnd.ms-excel", "myexcel.xls"));
}
// GET/POST 都可以
public ActionResult ExportToExcel(JObject content)
{
Dictionary <string, int> contentDic = content.ToObject <Dictionary <string, int> >();
DataTable source = DataSourceUtil.GetDataTable();
string TH_HTML = "<th>{0}</th>";
string TD_HTML = "<td>{0}</td>";
string TD_IMAGE_HTML = "<td><img src=\"{0}\"></td>";
StringBuilder sb = new StringBuilder();
sb.Append("<meta http-equiv=\"Content-Type\" content=\"application/vnd.ms-excel;charset=utf-8\"/>");
sb.Append("<table cellspacing=\"0\" rules=\"all\" border=\"1\" style=\"border-collapse:collapse;\">");
sb.Append("<tr>");
sb.AppendFormat(TH_HTML, "");
sb.AppendFormat(TH_HTML, "姓名");
sb.AppendFormat(TH_HTML, "性别");
sb.AppendFormat(TH_HTML, "入学年份");
sb.AppendFormat(TH_HTML, "是否在校");
sb.AppendFormat(TH_HTML, "所学专业");
sb.AppendFormat(TH_HTML, "分组");
sb.AppendFormat(TH_HTML, "语文成绩");
sb.Append("</tr>");
int rowIndex = 1;
foreach (DataRow row in source.Rows)
{
string rowId = row["Id"].ToString();
sb.Append("<tr>");
sb.AppendFormat(TD_HTML, rowIndex++);
sb.AppendFormat(TD_HTML, row["Name"]);
sb.AppendFormat(TD_HTML, row["Gender"].ToString() == "1" ? "男" : "女");
sb.AppendFormat(TD_HTML, row["EntranceYear"]);
sb.AppendFormat(TD_HTML, (bool)row["AtSchool"] ? "√" : "×");
sb.AppendFormat(TD_HTML, row["Major"]);
sb.AppendFormat(TD_IMAGE_HTML, GetAbsoluteUrl(String.Format("~/res/images/16/{0}.png", row["Group"])));
if (contentDic.ContainsKey(rowId))
{
sb.AppendFormat(TD_HTML, contentDic[rowId]);
}
else
{
// 未找到！
sb.AppendFormat(TD_HTML, "");
}
sb.Append("</tr>");
}
sb.Append("</table>");
return(File(Encoding.UTF8.GetBytes(sb.ToString()), "application/vnd.ms-excel", "myexcel.xls"));
}
private DataView GetSortedDataView(string sortField, string sortDirection)
{
// 模拟数据排序
DataTable table = DataSourceUtil.GetDataTable();
DataView view1 = table.DefaultView;
view1.Sort = String.Format("{0} {1}", sortField, sortDirection);
return(view1);
}
private void BindGrid()
{
DataTable table = DataSourceUtil.GetDataTable();
for (int i = 0; i < 2; i++)
{
table.Merge(DataSourceUtil.GetDataTable(), true);
}
Grid1.DataSource = table;
Grid1.DataBind();
}
public ActionResult Grid1_Sort(string[] Grid1_fields, string Grid1_sortField, string Grid1_sortDirection)
{
// 模拟数据排序
DataTable table = DataSourceUtil.GetDataTable();
DataView view1 = table.DefaultView;
view1.Sort = String.Format("{0} {1}", Grid1_sortField, Grid1_sortDirection);
// 更新表格数据源
UIHelper.Grid("Grid1").DataSource(view1, Grid1_fields);
return(UIHelper.Result());
}
private void BindGrid()
{
string sortField = Grid1.SortField;
string sortDirection = Grid1.SortDirection;
DataTable table = DataSourceUtil.GetDataTable();
DataView view1 = table.DefaultView;
view1.Sort = String.Format("{0} {1}", sortField, sortDirection);
Grid1.DataSource = view1;
Grid1.DataBind();
}
// 模拟在服务器端保存数据
// 特别注意：在真实的开发环境中，不要在Session放置大量数据，否则会严重影响服务器性能
private DataTable GetSourceData()
{
if (Session[KEY_FOR_DATASOURCE_SESSION] == null)
{
DataTable table = DataSourceUtil.GetDataTable();
// 修改最后一行的数据
DataRow lastRow = table.Rows[table.Rows.Count - 1];
lastRow["Major"] = "<b>" + lastRow["Major"] + "&</b>";
Session[KEY_FOR_DATASOURCE_SESSION] = table;
}
return((DataTable)Session[KEY_FOR_DATASOURCE_SESSION]);
}
private DataTable GetClassDetailTable(int classId)
{
DataTable table = null;
if (classId == 101)
{
table = DataSourceUtil.GetDataTable();
}
else
{
table = DataSourceUtil.GetDataTable2();
}
return(table);
}
/// <summary>
/// 模拟返回总项数
/// </summary>
/// <returns></returns>
private int GetTotalCount(bool?data2)
{
DataTable source = null;
if (data2.HasValue && data2.Value)
{
source = DataSourceUtil.GetDataTable2();
}
else
{
source = DataSourceUtil.GetDataTable();
}
return(source.Rows.Count);
}
public ActionResult Button1_Click(string[] fields, string source)
{
var grid1 = UIHelper.Grid("Grid1");
if (source == "source1")
{
grid1.DataSource(DataSourceUtil.GetDataTable(), fields);
grid1.Attribute("data-source-key", "source2");
}
else
{
grid1.DataSource(null);
grid1.Attribute("data-source-key", "source1");
}
return(UIHelper.Result());
}
protected void Button1_Click(object sender, EventArgs e)
{
DataTable table;
if (Convert.ToBoolean(ViewState["EMPTY_DATA_SOURCE"]))
{
ViewState["EMPTY_DATA_SOURCE"] = false;
table = DataSourceUtil.GetDataTable();
}
else
{
ViewState["EMPTY_DATA_SOURCE"] = true;
table = null;
}
Grid1.DataSource = table;
Grid1.DataBind();
}
protected void Button2_Click(object sender, EventArgs e)
{
DataTable table;
if (Convert.ToBoolean(ViewState["UseDataSource1"]))
{
ViewState["UseDataSource1"] = false;
table = DataSourceUtil.GetDataTable2();
}
else
{
ViewState["UseDataSource1"] = true;
table = DataSourceUtil.GetDataTable();
}
Grid1.DataSource = table;
Grid1.DataBind();
}
// 模拟在服务器端保存数据
// 特别注意：在真实的开发环境中，不要在Session放置大量数据，否则会严重影响服务器性能
private DataTable GetSourceData()
{
if (Session[KEY_FOR_DATASOURCE_SESSION] == null)
{
DataTable hobbyTable = GetHobbyTable();
// 修改数据源的结构，增加 HobbyText 项
DataTable table = DataSourceUtil.GetDataTable();
table.Columns.Add(new DataColumn("HobbyText", typeof(String)));
foreach (DataRow row in table.Rows)
{
row["HobbyText"] = GetHobbyText(hobbyTable, row["Hobby"].ToString());
}
Session[KEY_FOR_DATASOURCE_SESSION] = table;
}
return((DataTable)Session[KEY_FOR_DATASOURCE_SESSION]);
}
private void AutoBindGrid(string gridSourceKey, JArray gridFields)
{
var grid1 = UIHelper.Grid("Grid1");
DataTable source = null;
if (gridSourceKey == "table1")
{
source = DataSourceUtil.GetDataTable2();
gridSourceKey = "table2";
}
else
{
source = DataSourceUtil.GetDataTable();
gridSourceKey = "table1";
}
grid1.DataSource(source, gridFields);
grid1.Attribute("data-source-key", gridSourceKey);
}
private void LoadData()
{
DataTable table = DataSourceUtil.GetDataTable();
int newtableID = 101;
DataTable newtable = table.Clone();
for (int i = 0; i <= 2; i++)
{
foreach (DataRow row in table.Rows)
{
row["Id"] = newtableID;
newtable.ImportRow(row);
newtableID++;
}
}
ViewBag.Grid1DataSource = newtable;
}
public ActionResult Grid1_RowMove(JArray rowIds)
{
DataTable originalTable = DataSourceUtil.GetDataTable();
DataTable newTable = originalTable.Clone();
foreach (string rowId in rowIds)
{
DataRow rowInOriginalTable = FindRow(rowId, originalTable);
if (rowInOriginalTable != null)
{
newTable.ImportRow(rowInOriginalTable);
}
}
Session[KEY_FOR_DATASOURCE_SESSION] = newTable;
ShowNotify("数据保存成功！");
return(UIHelper.Result());
}
protected void Button1_Click(object sender, EventArgs e)
{
DataTable table;
if (Convert.ToBoolean(ViewState["UseDataSource1"]))
{
ViewState["UseDataSource1"] = false;
table = DataSourceUtil.GetDataTable2();
}
else
{
ViewState["UseDataSource1"] = true;
table = DataSourceUtil.GetDataTable();
}
// 重新绑定数据前，先清空高亮的行数据
highlightRows.Text = "";
Grid1.DataSource = table;
Grid1.DataBind();
}
public ActionResult btnSubmit_Click(string[] Grid1_fields, JArray Grid1_modifiedData)
{
DataTable source = DataSourceUtil.GetDataTable();
foreach (JObject modifiedRow in Grid1_modifiedData)
{
string status = modifiedRow.Value <string>("status");
int rowId = Convert.ToInt32(modifiedRow.Value <string>("id"));
if (status == "modified")
{
UpdateDataRow(modifiedRow, rowId, source);
}
}
UIHelper.Grid("Grid1").DataSource(source, Grid1_fields);
UIHelper.Label("labResult").Text(String.Format("用户修改的数据：<pre>{0}</pre>", Grid1_modifiedData.ToString(Newtonsoft.Json.Formatting.Indented)), false);
ShowNotify("数据保存成功！（表格数据已重新绑定）");
return(UIHelper.Result());
}
// GET: GridDataUrl/SortingData
public ActionResult Index(string sortField, string sortDirection, bool?data2)
{
JArray ja = new JArray();
DataTable source = null;
if (data2.HasValue && data2.Value)
{
source = DataSourceUtil.GetDataTable2();
}
else
{
source = DataSourceUtil.GetDataTable();
}
DataView view1 = source.DefaultView;
view1.Sort = String.Format("{0} {1}", sortField, sortDirection);
DataTable sortedTable = view1.ToTable();
foreach (DataRow row in sortedTable.Rows)
{
JObject jo = new JObject();
jo.Add("Id", (int)row["Id"]);
jo.Add("Name", row["Name"].ToString());
jo.Add("Gender", (int)row["Gender"]);
jo.Add("EntranceYear", (int)row["EntranceYear"]);
jo.Add("AtSchool", (bool)row["AtSchool"]);
jo.Add("Major", row["Major"].ToString());
jo.Add("Group", (int)row["Group"]);
ja.Add(jo);
}
return(Content(ja.ToString(Newtonsoft.Json.Formatting.None)));
}
// GET: Grid/DynamicColumns
public ActionResult Index()
{
InitGridColumns();
return(View(DataSourceUtil.GetDataTable()));
}
public ActionResult btnSearch_Click(string[] Grid1_fields)
{
UIHelper.Grid("Grid1").DataSource(DataSourceUtil.GetDataTable(), Grid1_fields);
return(UIHelper.Result());
}