📄 default.aspx.cs
字号:
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Text;
public partial class _Default : System.Web.UI.Page
{
protected string databaseContent;
protected string eventContent;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack) {
DataSet ds = new SqlHelp().GetList("select * from Type");
databaseContent = GetDatabaseContent(ds);
eventContent = GetEventConent(ds);
}
}
private string GetDatabaseContent(DataSet ds) {
StringBuilder sb = new StringBuilder();
if (ds != null) {
DataTable dt = ds.Tables["ds"];
//int index = 0;
int cols = 3;
int rows = dt.Rows.Count % cols == 0 ? dt.Rows.Count / cols : dt.Rows.Count / cols + 1;
string className = "News";
string pageName = "News";
for (int index = 0; index < dt.Rows.Count; index++) {
int curRow = index / 3 + 1;
int curCol = index % 3 + 1;
sb.Append("{ id : \"m_" + curCol + "_" + curRow + "\", title : \"" + (string)dt.Rows[index]["TypeName"] + "\", className : \"" + className + "\", src : \"" + pageName + "\", tag : \"" + (int)dt.Rows[index]["TypeId"] + "\" }");
if (index < dt.Rows.Count - 1) {
sb.Append("," + "\r\n");
} else {
return sb.ToString();
}
}
}
return sb.ToString();
}
private string GetEventConent(DataSet ds) {
StringBuilder sb = new StringBuilder();
if (ds != null) {
DataTable dt = ds.Tables["ds"];
int index = 0;
int cols = 3;
int rows = dt.Rows.Count / cols; //有意不全部显示,可以让用户自己添加
for (int j = 1; j <= cols; j++) {
sb.Append("{ cols : \"m_"+j+"\", rows : ["+"\r\n");
for (int i = 1; i <= rows; i++) {
sb.Append("\t");
sb.Append("{ id : \"m_"+j+"_"+i+"\", window : 1, locks : false }");
if (i < rows) {
sb.Append("," + "\r\n");
}
}
sb.Append("] }" + "\r\n");
if (j < cols) {
sb.Append("," + "\r\n");
}
}
}
return sb.ToString();
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -