实现无极限增删改查连接数据同步数据库代码,Asp.Net代码库,德仔网

代码语言
代码分类
【Asp.Net】实现无极限增删改查连接数据同步数据库
作者:defddr / 发布于2014/11/13/ 1013
asp.netweb窗体开发，试用于后台管理系统

	<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Sys_TreeList.aspx.cs" Inherits="System_Sys_TreeList" %>
	
	<!DOCTYPE html>
	<html xmlns="http://www.w3.org/1999/xhtml">
	<head id="Head1" runat="server">
	 <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
	 <title>实现无限级树状结构并动态添加增删改功能</title>
	 <link href="../BootStrap/css/bootstrap.min.css" rel="stylesheet" media="screen" />
	 <link href="../BootStrap/css/bootstrap-theme.min.css" rel="stylesheet" media="screen" />
	 <script src="../BootStrap/js/jquery-2.0.2.min.js"></script>
	 <script src="../BootStrap/js/bootstrap.min.js"></script>
	 <script src="../BootStrap/My97DatePicker/WdatePicker.js"></script>
	
	 <link rel="stylesheet" href="../BootStrap/ztree/css/zTreeStyle/zTreeStyle.css" type="text/css" />
	 <script type="text/javascript" src="../BootStrap/ztree/js/jquery-1.4.4.min.js"></script>
	 <script type="text/javascript" src="../BootStrap/ztree/js/jquery.ztree.core-3.5.js"></script>
	 <script type="text/javascript" src="../BootStrap/zTree/js/jquery.ztree.excheck-3.5.js"></script>
	 <script type="text/javascript" src="../BootStrap/zTree/js/jquery.ztree.exedit-3.5.js"></script>
	 <script>
	 var setting = {
	 async: {
	 enable: true,//开启异步加载处理
	 dataFilter: filter//用于对 Ajax 返回数据进行预处理的函数
	 },
	 view: {
	 expandSpeed: "",//zTree 节点展开、折叠时的动画速度，设置方法同 JQuery 动画效果中 speed 参数。
	 addHoverDom: addHoverDom,//用于当鼠标移动到节点上时，显示用户自定义控件，显示隐藏状态同 zTree 内部的编辑、删除按钮
	 removeHoverDom: removeHoverDom,//设置鼠标移到节点上，在后面显示一个按钮
	 selectedMulti: false// 禁止多点同时选中的功能
	 },
	 edit: {
	 enable: true//设置 zTree 进入编辑状态
	 },
	 data: {
	 simpleData: {
	 enable: true//使用简单 Array 格式的数据
	 }
	 },
	 callback: {
	 beforeRemove: beforeRemove,//用于捕获节点被删除之前的事件回调函数，并且根据返回值确定是否允许删除操作
	 beforeRename: beforeRename//用于捕获节点编辑名称结束（Input 失去焦点 或 按下 Enter 键）之后，更新节点名称数据之前的事件回调函数，并且根据返回值确定是否允许更改名称的操作
	 }
	 };
	 //修改异步获取到的节点name属性
	 function filter(treeId, parentNode, childNodes) {
	 if (!childNodes) return null;
	 for (var i = 0, l = childNodes.length; i < l; i++) {
	 childNodes[i].name = childNodes[i].name.replace(/\.n/g, '.');
	 }
	 return childNodes;
	 }
	 //删除节点信息
	 function beforeRemove(treeId, treeNode) {
	 var zTree = $.fn.zTree.getZTreeObj("treeDemo");
	 zTree.selectNode(treeNode);
	 if (confirm("确认删除 节点 -- " + treeNode.name + " 吗？")) {
	 var treeInfo = treeNode.id;
	 $.ajax({
	 url: "Ajax.aspx?_tid=" + treeInfo + "&action=Remove",
	 type: "POST",
	 async: false,
	 success: function (res) {
	 if (res = "success") {
	 alert('删除成功!');
	 window.location.reload();
	 } else {
	 alert('删除失败!');
	 window.location.reload();
	 }
	 }
	 });
	 } else {
	 window.location.reload();
	 }
	 }
	 //修改节点信息
	 function beforeRename(treeId, treeNode, newName) {
	 if (newName.length == 0) {
	 alert("节点名称不能为空.");
	 return false;
	 }
	 var treeInfo = treeNode.id;
	 $.ajax({
	 url: "Ajax.aspx?_tid=" + treeInfo + "&_newname=" + newName + "&action=ReName",
	 type: "POST",
	 async: false,
	 success: function (res) {
	 if (res = "success") {
	 alert('修改成功!');
	 window.location.reload();
	 } else {
	 alert('修改失败!');
	 window.location.reload();
	 }
	 }
	 });
	 }
	 //添加新的节点
	 function addHoverDom(treeId, treeNode) {
	 var sObj = $("#" + treeNode.tId + "_span");
	 if (treeNode.editNameFlag || $("#addBtn_" + treeNode.tId).length > 0) return;
	 var addStr = "<span class='button add' id='addBtn_" + treeNode.tId
	 + "' title='add node' onfocus='this.blur();'></span>";
	 sObj.after(addStr);
	 var btn = $("#addBtn_" + treeNode.tId);
	 if (btn) btn.bind("click", function () {
	 var zTree = $.fn.zTree.getZTreeObj("treeDemo");
	 if (confirm("确认为 " + treeNode.name + " 添加子节点吗？")) {
	
	 // zTree.addNodes(treeNode, { id: (100 + newCount), pId: treeNode.id, name: "new node" + (newCount++) });
	 var treeInfo = treeNode.id;
	 $.ajax({
	 url: "Ajax.aspx?_Pid=" + treeInfo + "&action=Insert",
	 type: "POST",
	 async: false,
	 success: function (res) {
	 if (res = "success") {
	 alert('添加成功!');
	 window.location.reload();
	 } else {
	 alert('添加失败!');
	 window.location.reload();
	 }
	 }
	 });
	 }
	 });
	 };
	 //设置鼠标移到节点上，在后面显示一个按钮
	 function removeHoverDom(treeId, treeNode) {
	 $("#addBtn_" + treeNode.tId).unbind().remove();
	 };
	 var zNodes = [
	 <%=tree%>
	 ];
	 //加载显示
	 $(document).ready(function () {
	 $.fn.zTree.init($("#treeDemo"), setting, zNodes);
	 });
	 </script>
	</head>
	<body>
	 <form id="form1" runat="server">
	 <div style="margin: 0 auto; width: 90%">
	 <ol class="breadcrumb">
	 <li class="active">实现无限级树状结构并动态添加增删改功能</li>
	 </ol>
	 <table style="width: 100%;">
	 <tr>
	 <td valign="top" style="align: left; BORDER-RIGHT: #999999 1px dashed; width: 10%;">
	 <ul id="treeDemo" class="ztree" style="width: 94%; overflow: auto;"></ul>
	 </td>
	 <td valign="top" style="width: 80%">
	 <table style="display: none;">
	 <tr>
	 <td>父级：</td>
	
	 <td>
	 <asp:DropDownList ID="ddlMenuF" runat="server" AutoPostBack="true" OnSelectedIndexChanged="ddlMenuF_SelectedIndexChanged"></asp:DropDownList>
	 <asp:DropDownList ID="ddlMenuT" AutoPostBack="true" runat="server" OnSelectedIndexChanged="ddlMenuT_SelectedIndexChanged"></asp:DropDownList>
	 <asp:DropDownList ID="ddlMenuTh" runat="server"></asp:DropDownList>
	 </tr>
	 <tr>
	 <td>标题：</td>
	 <td>
	 <asp:TextBox class="form-control" ID="txttitle" placeholder="" runat="server"></asp:TextBox>*<asp:RequiredFieldValidator ID="RFVtitle" runat="server" ErrorMessage="标题：不能为空!" ForeColor="#FF3300" ControlToValidate="txttitle"></asp:RequiredFieldValidator>
	 </td>
	 </tr>
	 <tr>
	 <td>URL：</td>
	 <td>
	 <asp:TextBox class="form-control" ID="txtURL" placeholder="" runat="server"></asp:TextBox></td>
	 </tr>
	 <tr>
	 <td>序号：</td>
	 <td>
	 <asp:TextBox class="form-control" ID="txtOrderBy" placeholder="" runat="server"></asp:TextBox></td>
	 </tr>
	 <tr>
	 <td>ID：</td>
	 <td></td>
	 </tr>
	 <tr>
	 <td colspan="2">
	 <asp:Button ID="ButtonAdd" runat="server" Text="确认添加" class="btn btn-default" OnClick="ButtonAddSys_IBmenuTree_Click" />
	 <asp:Label ID="AddMSN" runat="server" Text=""></asp:Label>
	 </td>
	 </tr>
	 </table>
	 </td>
	 </tr>
	 </table>
	
	 </div>
	 </form>
	</body>
	</html>
	为前台代码
	using System;
	using System.Collections.Generic;
	using System.Linq;
	using System.Web;
	using System.Web.UI;
	using System.Web.UI.WebControls;
	using System.Data;
	using System.Data.Sql;
	using System.Data.SqlClient;
	using System.Text;
	using System.Configuration;
	using Boss.DAL;
	
	public partial class System_Sys_TreeList : System.Web.UI.Page
	{
	 public string tree, TopClass;
	 protected void Page_Load(object sender, EventArgs e)
	 {
	
	 //取得传过来的TopClassid从而判断要读取哪些功能菜单
	
	
	 //TopClass = Request.QueryString["id"].ToString();
	 //TopClass = "0";
	
	
	 if (!IsPostBack)
	 {
	 bindMenu();//获取父级ID
	 }
	
	 // getStrXml();
	 _GetXml();
	
	 }
	
	 #region 获取父级菜单
	 /// <summary>
	 /// 读取一级菜单
	 /// </summary>
	 private void bindMenu()
	 {
	 //" + TopClass + "
	 SysDataAndSQLClass ds = new SysDataAndSQLClass();//读取一级菜单
	 DataTable dt = ds.ExecSQLDataTable("select id,title from Sys_Tree WHERE pid=0 And IsValid=1 ORDER BY id ASC", "default");
	 ddlMenuF.Items.Clear();
	 ddlMenuF.Items.Add(new ListItem("-顶级-", "0"));
	 for (int i = 0; i < dt.Rows.Count; i++)
	 {
	 ddlMenuF.Items.Add(new ListItem(dt.Rows[i]["title"].ToString(), dt.Rows[i]["ID"].ToString()));
	 }
	 ddlMenuT.Items.Add(new ListItem("请选择", "0"));
	 ddlMenuTh.Items.Add(new ListItem("请选择", "0"));
	 }
	 /// <summary>
	 /// ///读取二级菜单
	 /// </summary>
	 /// <param name="sender"></param>
	 /// <param name="e"></param>
	 protected void ddlMenuF_SelectedIndexChanged(object sender, EventArgs e)
	 {
	 string id = ddlMenuF.SelectedValue;
	 ddlMenuT.Items.Clear();
	 ddlMenuTh.Items.Clear();
	 ddlMenuT.Items.Add(new ListItem("请选择", "0"));
	 ddlMenuTh.Items.Add(new ListItem("请选择", "0"));
	 if (id != "0")
	 {
	 SysDataAndSQLClass ds = new SysDataAndSQLClass();//读取二级菜单
	 DataTable dt = ds.ExecSQLDataTable("select id,title from Sys_Tree WHERE pid=" + id + " And IsValid=1 ORDER BY id ASC", "default");
	
	 for (int i = 0; i < dt.Rows.Count; i++)
	 {
	 ddlMenuT.Items.Add(new ListItem(dt.Rows[i]["title"].ToString(), dt.Rows[i]["ID"].ToString()));
	 }
	 }
	 ddlMenuTh.Visible = true;
	 }
	 /// <summary>
	 /// //读取三级菜单;
	 /// </summary>
	 /// <param name="sender"></param>
	 /// <param name="e"></param>
	 protected void ddlMenuT_SelectedIndexChanged(object sender, EventArgs e)
	 {
	 string id = ddlMenuT.SelectedValue;
	 ddlMenuTh.Items.Clear();
	 ddlMenuTh.Items.Add(new ListItem("请选择", "0"));
	 if (id != "0")
	 {
	 SysDataAndSQLClass ds = new SysDataAndSQLClass();
	 DataTable dt = ds.ExecSQLDataTable("select id,title from Sys_Tree WHERE pid=" + id + " And IsValid=1 ORDER BY id ASC", "default");
	 for (int i = 0; i < dt.Rows.Count; i++)
	 {
	 ddlMenuTh.Items.Add(new ListItem(dt.Rows[i]["title"].ToString(), dt.Rows[i]["ID"].ToString()));
	 }
	 if (dt.Rows.Count == 0)
	 {
	 ddlMenuTh.Visible = false;
	 }
	 else
	 {
	 ddlMenuTh.Visible = true;
	 }
	 }
	 }
	
	 #endregion
	
	 #region 获取菜单树
	
	 protected void _GetXml()
	 {
	 //" + TopClass + "
	 string _xml = "";
	 string _tag = "";
	 SysDataAndSQLClass ds = new SysDataAndSQLClass();
	 string sqlstr = "select id,pid,title,url from Sys_Tree where pid=0 And IsValid=1 ORDER BY id ASC ";
	 DataTable dt = ds.ExecSQLDataTable(sqlstr, "default");
	 if (dt.Rows.Count > 0)
	 {
	 for (int i = 0; i < dt.Rows.Count; i++)
	 {
	 _xml += "{\nid:\"" + dt.Rows[i]["ID"].ToString() + "\",pId:\"" + dt.Rows[i]["PID"].ToString() + "\", name: \"" + dt.Rows[i]["title"].ToString() + "\", open: true,\n";
	 _xml += "children: [\n";
	 _tag = _GetTag(dt.Rows[i]["id"].ToString()).ToString();
	 _xml += _tag + " \n ]\n},";
	 }
	 _xml += "";
	 tree = _xml;
	 }
	 }
	
	 protected string _GetTag(string _mid)
	 {
	 string _xml = "";
	 SysDataAndSQLClass ds = new SysDataAndSQLClass();
	 string sqlstr = "select id,pid,title,url from Sys_Tree where pid=" + _mid + " And IsValid=1 ORDER BY id ASC ";
	 DataTable dt = ds.ExecSQLDataTable(sqlstr, "default");
	 if (dt.Rows.Count > 0)
	 {
	 for (int i = 0; i < dt.Rows.Count; i++)
	 {
	 string sql = "select id,title,url from Sys_Tree where pid=" + dt.Rows[i]["id"].ToString() + " And IsValid=1 ORDER BY id ASC ";
	 DataTable dt_sql = ds.ExecSQLDataTable(sql, "default");
	 if (dt_sql.Rows.Count > 0)
	 {
	 _xml += "{\nid:\"" + dt.Rows[i]["ID"].ToString() + "\",pId:\"" + dt.Rows[i]["PID"].ToString() + "\", name: \"" + dt.Rows[i]["title"].ToString() + "\", open: true,\n";
	 _xml += "children: [\n";
	 _xml += _GetTag(dt.Rows[i]["id"].ToString()).ToString() + " \n ]\n},";
	 }
	 else
	 {
	 _xml += " { id:\"" + dt.Rows[i]["ID"].ToString() + "\",pId:\"" + dt.Rows[i]["PID"].ToString() + "\",name:\"" + dt.Rows[i]["title"].ToString() + "\"},";//新方法
	 }
	 }
	 }
	 return _xml;
	 }
	 #endregion
	
	 /// <summary>
	 /// 添加树
	 /// </summary>
	 /// <param name="sender"></param>
	 /// <param name="e"></param>
	 protected void ButtonAddSys_IBmenuTree_Click(object sender, EventArgs e)
	 {
	 string PID = ddlMenuF.Text;
	 if (ddlMenuTh.SelectedValue != "0")//第三项不为空时,父级菜单ID为三级菜单的ＩＤ
	 {
	 PID = ddlMenuTh.Text;
	 }
	 else
	 {
	 if (ddlMenuT.SelectedValue != "0")//第三项不为空时且第二项不为空时,父级菜单ID为二级菜单的ＩＤ
	 {
	 PID = ddlMenuT.Text;
	 }
	 else
	 {
	 PID = ddlMenuF.Text;//第三项不为空时且第二项为空时,父级菜单ID为一级或顶级菜单的ＩＤ
	 }
	 }
	 if (PID == "0")
	 {
	 PID = TopClass.ToString();
	 }
	 string title = txttitle.Text;
	 string URL = txtURL.Text;
	 string OrderBy = txtOrderBy.Text;
	 string SysbrandID = "";
	 string CreateLoginId = Session["UserName"].ToString();
	 //为存储过程调用准备参数
	 string tabName = "Sys_Tree";
	 string columns = "PID,title,URL,SysbrandID";//(父表主键),Pid
	 string values = "'" + PID + "','" + title + "','" + URL + "','" + SysbrandID + "'";//(父表主键值),'" + Pid + "'
	 //执行存储过程调用类
	 int i = Boss.DAL.SysDataAndSQLClass.Sys_IB_Insert(tabName, columns, values, "default");
	 if (i == 0)
	 {
	 //写日志
	 int ilog = Convert.ToInt32(SysCommonClass.InsertSysLog("Insert", "TableName:" + tabName, "Columns:" + columns + " |Values:" + values).ToString());
	 //调用执行写系统日志
	 AddMSN.Text = "添加成功!";
	 _GetXml();
	 }
	 }
	
	}
	为后台代码
	using Boss.DAL;
	using System;
	using System.Collections.Generic;
	using System.Data;
	using System.Data.SqlClient;
	using System.Linq;
	using System.Web;
	using System.Web.UI;
	using System.Web.UI.WebControls;
	
	public partial class System_Ajax : System.Web.UI.Page
	{
	 protected void Page_Load(object sender, EventArgs e)
	 {
	 Response.ContentType = "text/plain";
	 // 在完全处理之后再发送到请求客户端
	 Response.BufferOutput = true;
	 // 在服务器端不缓存页
	 Response.ExpiresAbsolute = DateTime.Now.AddDays(-1);
	 // 设置任何代理服务器不缓存页
	 Response.AddHeader("pragma", "no-cache");
	 // 设置请求的客户端浏览器不缓存页
	 Response.AddHeader("cache-control", "");
	 Response.CacheControl = "no-cache";
	
	 string action = Request["action"];
	 string result = "";
	 // 根据Action执行操作
	 switch (action)
	 {
	 //case "GetItemData":
	 // result = GetItemData();
	 // break;
	 case "ReName":
	 result = ReName();
	 break;
	 case "Remove":
	 result = Remove();
	 break;
	 case "Insert":
	 result = InsertNode();
	 break;
	 default:
	 break;
	 }
	
	 Response.Write(result);
	 }
	
	 /// <summary>
	 /// 添加
	 /// </summary>
	 /// <returns></returns>
	 private string InsertNode()
	 {
	 string flag = "false";
	 string _Pid = Request["_Pid"].ToString();
	 // string _Pid = Request["_Pid"].ToString().Split('_')[1].ToString();
	 SysDataAndSQLClass ds = new SysDataAndSQLClass();
	 string SQL = " insert into Sys_Tree(PID,ClassID,Title,describe,URL) values(" + _Pid + " ,1, 'newNode',' ', '#')";
	 int s = Convert.ToInt32(Boss.DAL.SysDataAndSQLClass.ExecTier(SQL, "default"));
	 if (s > 0)
	 {
	 flag = "success";
	 }
	 return flag;
	 }
	
	 /// <summary>
	 /// 删除
	 /// </summary>
	 /// <returns></returns>
	 private string Remove()
	 {
	 string flag = "false";
	 string _id = Request["_tid"].ToString();//.Split('_')[1].ToString();
	 SysDataAndSQLClass ds = new SysDataAndSQLClass();
	 string sqlstr = "Update Sys_Tree set IsValid=0 where ID=" + _id + " and IsValid=1";
	 int s = Convert.ToInt32(Boss.DAL.SysDataAndSQLClass.ExecTier(sqlstr, "default"));
	 if (s > 0)
	 {
	 flag = "success";
	 }
	 return flag;
	 }
	
	 /// <summary>
	 /// 修改
	 /// </summary>
	 /// <returns></returns>
	 private string ReName()
	 {
	 string flag = "false";
	 string _id = Request["_tid"].ToString();//.Split('_')[1].ToString();
	 string _newname = Request["_newname"];
	 SysDataAndSQLClass ds = new SysDataAndSQLClass();
	 string sqlstr = "Update Sys_Tree set Title='" + _newname + "' where ID=" + _id + " and IsValid=1";
	 int s = Convert.ToInt32(Boss.DAL.SysDataAndSQLClass.ExecTier(sqlstr, "default"));
	 if (s > 0)
	 {
	 flag = "success";
	 }
	 return flag;
	 }
	}
	为ajax调用代码
试试其它关键字
　增删改　　同步数据库　　　　ztree　
同语言下
可能有用的
defddr贡献的其它代码(6)