C#的EXT相关操作类

自己接触EXT已经有三个来月了，学习了不少的东西。在这里把一些接触到的东西记录下来，算是再熟悉一次。

 下面这个类里面的方法是相关的把DataTable中的数据转换成JSON格式的方法，把树TreeNode转换成JSON格式的方法，如下：

using System.Data; using System.Web.UI.WebControls; using System.Text; public class JsonHelper { public JsonHelper() { } /// <summary> /// 将TreeNode数组中的每一个节点及其全部子节点转换为Json格式字符串 /// </summary> /// <param name="nodes"></param> /// <returns></returns> public static string GetJSTreeJSONData(TreeNodeCollection nodes) { StringBuilder treeString = new StringBuilder(); //构建JSON开头 treeString.Append("["); for (int i = 0; i < nodes.Count; i++) { //如果有子节点,则进行子节点构建 if (nodes[i].ChildNodes.Count != 0) { treeString.Append("{ attributes: {pk_id: '" + nodes[i].Value + "'}, text:'" + nodes[i].Text + "',expanded: false"); RecurrenceBuildJSTreeJSONData(treeString, nodes[i]); } else { treeString.Append("{ attributes: {pk_id: '" + nodes[i].Value + "'}, text:'" + nodes[i].Text + "',leaf: true"); } //构建节点结尾 treeString.Append("}"); if (i != nodes.Count - 1) { treeString.Append(","); } } treeString.Append("]"); return treeString.ToString(); } /// <summary> /// 将单个节点及其所有子节点转换为Json格式字符串 /// </summary> /// <param name="nodes"></param> /// <returns></returns> public static string GetJSTreeJSONData(TreeNode nodes) { StringBuilder treeString = new StringBuilder(); //构建JSON开头 treeString.Append("["); //构建节点 treeString.Append("{ attributes: {pk_id: '" + nodes.Value + "'}, text:'" + nodes.Text + "',expanded: false"); //如果有子节点,则进行子节点构建 if (nodes.ChildNodes.Count != 0) { RecurrenceBuildJSTreeJSONData(treeString, nodes); } //构建节点结尾 treeString.Append("}"); //构建JSON结尾 treeString.Append("]"); return treeString.ToString(); } private static void RecurrenceBuildJSTreeJSONData(StringBuilder treeString, TreeNode nodes) { //构建子节点开头 treeString.Append(",children: ["); for (int i = 0; i < nodes.ChildNodes.Count; i++) { treeString.Append("{ attributes: {pk_id: '" + nodes.ChildNodes[i].Value + "',parent_id:'" + nodes.Value + "'}, text:'" + nodes.ChildNodes[i].Text + "'"); if (nodes.ChildNodes[i].ChildNodes.Count != 0) RecurrenceBuildJSTreeJSONData(treeString, nodes.ChildNodes[i]); else treeString.Append(",leaf:true"); //构建最后一条节点的结尾 if (i == nodes.ChildNodes.Count - 1) treeString.Append("}"); //构建非最后一条节点的结尾 else treeString.Append("},"); } //构建子节点结尾 treeString.Append("]"); } /// <summary> /// 转换异常信息为同一的Json数据格式 /// </summary> /// <param name="msg"></param> /// <returns></returns> public static string GetErrorJson(string msg) { if (msg.IndexOf("/n") > 0) { msg = msg.Substring(0, msg.IndexOf("/n")); } return "err:{msg:'" + msg + "'}"; } /// <summary> /// 将DataTable数据转换为Json表格数据格式 /// </summary> /// <param name="dt"></param> /// <returns></returns> public static string GetTableJson(DataTable dt) { //数据样式 string data = "data:["; if (dt != null && dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { data += "{"; foreach (DataColumn column in dt.Columns) { data += column.ColumnName + ":'" + row[column].ToString() + "',"; } data = data.Substring(0, data.Length - 1); data += "},"; } data = data.Substring(0, data.Length - 1); } data += "]"; return data; } }

以后所有的涉及的相关操作都要根据这个公共类的方法进行。