📄 tree.aspx
字号:
<%@ import namespace="System" %>
<%@ import namespace="System.Data" %>
<%@ import namespace="System.Configuration" %>
<%@ import namespace="System.Collections" %>
<%@ import namespace="System.Configuration" %>
<%@ import namespace="System.Web" %>
<%@ import namespace="System.Web.Security" %>
<%@ import namespace="System.Web.UI" %>
<%@ import namespace="System.Web" %>
<%@ import namespace="System.Web.UI.WebControls" %>
<%@ import namespace="System.Web.UI.WebControls.WebParts" %>
<%@ import namespace="System.Web.UI.HtmlControls" %>
<%@ import namespace="System.Data.OleDb" %>
<%@ Page Language="C#" %>
<script runat="server">
//Webconfig文件中获取数据库路径
public string g_StrConn = ConfigurationManager.AppSettings["Conn_Access"];
protected void Page_Load(object sender, EventArgs e)
{
string mode = Request.QueryString["mode"];
switch (mode)
{
case "getTree":
Response.Write(getTree());
break;
case "getAdd":
Response.Write(getAdd());
break;
case "saveAdd":
Response.Write(saveAdd());
break;
case "getEdit":
Response.Write(getEdit());
break;
case "saveEdit":
Response.Write(saveEdit());
break;
case "addSub":
Response.Write(addSub());
break;
case "del":
Response.Write(del());
break;
case "move":
Response.Write(move());
break;
case "returnEdit":
Response.Write(returnEdit());
break;
}
}
//******************
//** 获取树结构 **
//******************
public string getTree()
{
string fatherID = Request.QueryString["fatherID"];
if (!IsNumber(fatherID))
{
return "禁止提交非法的数据！";
}
string StrSql = "Select * From tree Where FatherID=" + fatherID + " Order By Name Asc";
OleDbConnection MyConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + Server.MapPath(g_StrConn));
OleDbCommand MyCmd = new OleDbCommand(StrSql, MyConn);
try
{
MyCmd.Connection.Open();
OleDbDataReader Dr = MyCmd.ExecuteReader();
string TopStr = "<a id='add" + fatherID + "'></a><table border='0' cellpadding='0' cellspacing='0' style='width: 100%; height: 10px'>";
string BottomStr = "</table>";
string MiddleStr = "";
while (Dr.Read())
{
MiddleStr = MiddleStr + "<tr><td align='left' valign='middle' style='width:200px;height:22px;' colspan='2'><span id='addSub" + Dr["ID"].ToString() + "'>";
string StrSql2 = "Select * From tree Where FatherID=" + Dr["ID"].ToString();
OleDbConnection MyConn2 = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + Server.MapPath(g_StrConn));
OleDbCommand MyCmd2 = new OleDbCommand(StrSql2, MyConn2);
try
{
MyCmd2.Connection.Open();
OleDbDataReader Dr2 = MyCmd2.ExecuteReader();
if (Dr2.Read())
{
MiddleStr = MiddleStr + "<img alt='' id='AddImg" + Dr["ID"].ToString() + "' src='Images/addImg.bmp' onclick=getdata('tree.aspx?mode=getTree&fatherID=" + Dr["ID"].ToString() + "','sub" + Dr["id"].ToString() + "');ShowSub(" + Dr["id"].ToString() + "); /> <a id='move" + Dr["ID"].ToString() + "' style='cursor:hand;' onmousedown=if(!g_CatchDiv){catchBDiv('move" + Dr["ID"].ToString() + "','" + moveJS(Dr["Name"].ToString()) + "')}; onmousemove=if(g_CatchDiv&&g_objNO!='" + Dr["id"].ToString() + "'){if(confirm('你确定将〖'+g_objName+'〗移动为〖" + moveJS(Dr["Name"].ToString()) + "〗的子级吗？'))postMove(g_objNO," + Dr["id"].ToString() + ")} oncontextmenu=showMenu(" + Dr["ID"].ToString() + "," + fatherID + "); onclick=if(!g_CatchDiv){menuClick('" + moveJS(Dr["Name"].ToString()) + "');}><img alt='' src='Images/folder.bmp' /> <span id='edit" + Dr["ID"].ToString() + "' style='font-size:12px; color:Black;'>" + moveHtml(Dr["Name"].ToString()) + "</span></a>";
}
else
{
MiddleStr = MiddleStr + "<span style='font-size:11px; color:Black;'> </span><a id='move" + Dr["ID"].ToString() + "' style='cursor:hand;' onmousedown=if(!g_CatchDiv){catchBDiv('move" + Dr["ID"].ToString() + "','" + moveJS(Dr["Name"].ToString()) + "')}; onmousemove=if(g_CatchDiv&&g_objNO!='" + Dr["id"].ToString() + "'){if(confirm('你确定将〖'+g_objName+'〗移动为〖" + moveJS(Dr["Name"].ToString()) + "〗的子级吗？'))postMove(g_objNO," + Dr["id"].ToString() + ")} oncontextmenu=showMenu(" + Dr["ID"].ToString() + "," + fatherID + "); onclick=if(!g_CatchDiv){menuClick('" + moveJS(Dr["Name"].ToString()) + "');}><img alt='' src='Images/folder.bmp' /> <span id='edit" + Dr["ID"].ToString() + "' style='font-size:12px; color:Black;'>" + moveHtml(Dr["Name"].ToString()) + "</span></a>";
}
MyCmd2.Connection.Close();
}
catch
{
return "数据库连接失败！";
}
MiddleStr = MiddleStr + "</span></td></tr><tr><td align='left' valign='middle' style='width:22px;'></td><td align='left' valign='middle' ><div style='display:none;' id='sub" + Dr["id"].ToString() + "'></div></td></tr>";
}
MyCmd.Connection.Close();
return TopStr + MiddleStr + BottomStr;
}
catch
{
return "数据库连接失败！";
}
}
//************************
//** 获取节点新增表单 **
//************************
public string getAdd()
{
string addHtml = "";
string fatherID = Request.QueryString["fatherID"];
if (!IsNumber(fatherID))
{
return "禁止提交非法的数据！";
}
addHtml = addHtml + "<span style='font-size:11px; color:Black;'> </span><img alt='' src='Images/folder.bmp' /> <input onblur=postAdd(" + fatherID + ") name='addName" + fatherID + "' type='text' value='新建菜单项' size='15'><br />";
return addHtml;
}
//**********************
//** 保存新增的节点 **
//**********************
public string saveAdd()
{
string id = Request.QueryString["id"];
string Name = Request["Name"];
if (Name.CompareTo("") == 0)
{
return "nameNull";
}
string fatherID = Request["fatherID"];
if (!IsNumber(fatherID))
{
return "禁止提交非法的数据！";
}
if (!checkName(Name,""))
{
return "addNameRep" + fatherID;
}
string StrSql = "Select * From tree";
OleDbConnection MyConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + Server.MapPath(g_StrConn));
try
{
MyConn.Open();
OleDbDataAdapter odAdapt = new OleDbDataAdapter(StrSql, MyConn);
OleDbCommandBuilder oCB = new OleDbCommandBuilder(odAdapt);
DataSet DS = new DataSet();
odAdapt.Fill(DS);
DataRow DR = DS.Tables[0].NewRow();
DR["name"] = Name;
DR["fatherID"] = fatherID;
DS.Tables[0].Rows.Add(DR);
odAdapt.Update(DS);
MyConn.Close();
return "added" + fatherID;
}
catch
{
return "数据库连接失败！";
}
}
//********************
//** 新增子级节点 **
//********************
public string addSub()
{
string changeHtml = "";
string id = Request.QueryString["id"];
if (!IsNumber(id))
{
return "禁止提交非法的数据！";
}
string StrSql = "Select * From tree Where id=" + id;
OleDbConnection MyConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + Server.MapPath(g_StrConn));
try
{
MyConn.Open();
OleDbDataAdapter odAdapt = new OleDbDataAdapter(StrSql, MyConn);
DataSet DS = new DataSet();
odAdapt.Fill(DS);
DataTable DT = DS.Tables[0];
changeHtml = changeHtml + "<img alt='' id='AddImg" + DT.Rows[0]["ID"].ToString() + "' src='Images/addImg.bmp' onclick=getdata('tree.aspx?mode=getTree&fatherID=" + DT.Rows[0]["ID"].ToString() + "','sub" + DT.Rows[0]["ID"].ToString() + "');ShowSub(" + DT.Rows[0]["ID"].ToString() + "); /> <a id='move" + DT.Rows[0]["ID"].ToString() + "' style='cursor:hand;' onmousedown=if(!g_CatchDiv){catchBDiv('move" + DT.Rows[0]["ID"].ToString() + "','" + moveJS(DT.Rows[0]["Name"].ToString()) + "')}; onmousemove=if(g_CatchDiv&&g_objNO!='" + DT.Rows[0]["id"].ToString() + "'){if(confirm('你确定将〖'+g_objName+'〗移动为〖" + moveJS(DT.Rows[0]["Name"].ToString()) + "〗的子级吗？'))postMove(g_objNO," + DT.Rows[0]["id"].ToString() + ")} oncontextmenu=showMenu(" + DT.Rows[0]["ID"].ToString() + "," + id + "); onclick=if(!g_CatchDiv){menuClick('" + moveJS(DT.Rows[0]["Name"].ToString()) + "');}><img alt='' src='Images/folder.bmp' /> <span id='edit" + DT.Rows[0]["ID"].ToString() + "' style='font-size:12px; color:Black;' >" + moveJS(DT.Rows[0]["name"].ToString()) + "</span></a>";
MyConn.Close();
}
catch
{
return "数据库连接失败！";
}
return changeHtml;
}
//************************
//** 获取节点修改表单 **
//************************
public string getEdit()
{
string editHtml = "";
string startValue = "";
string id = Request.QueryString["id"];
if (!IsNumber(id))
{
return "禁止提交非法的数据！";
}
string StrSql = "Select * From tree Where id=" + id;
OleDbConnection MyConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + Server.MapPath(g_StrConn));
try
{
MyConn.Open();
OleDbDataAdapter odAdapt = new OleDbDataAdapter(StrSql, MyConn);
DataSet DS = new DataSet();
odAdapt.Fill(DS);
DataTable DT = DS.Tables[0];
startValue = DT.Rows[0]["name"].ToString().Trim();
MyConn.Close();
editHtml = editHtml + "<input onblur=postEdit(" + id + ") name='editName" + id + "' type='text' value='" + moveHtml(startValue) + "' size='15'>";
return editHtml;
}
catch
{
return "数据库连接失败！";
}
}
//**********************
//** 保存修改的节点 **
//**********************
public string saveEdit()
{
string id = Request.QueryString["id"];
if (!IsNumber(id))
{
return "禁止提交非法的数据！";
}
string Name = Request["Name"];
if (Name.CompareTo("")==0)
{
return "nameNull";
}
if (!checkName(Name,id))
{
return "editNameRep" + id;
}
string StrSql = "Select * From tree Where id=" + id;
OleDbConnection MyConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + Server.MapPath(g_StrConn));
try
{
MyConn.Open();
OleDbDataAdapter odAdapt = new OleDbDataAdapter(StrSql, MyConn);
OleDbCommandBuilder oCB = new OleDbCommandBuilder(odAdapt);
DataSet DS = new DataSet();
odAdapt.Fill(DS);
DataTable DT = DS.Tables[0];
DT.Rows[0]["name"] = Name;
odAdapt.Update(DS);
MyConn.Close();
return "edited" + id;
}
catch
{
return "数据库连接失败！";
}
}
//************************
//** 返回修改后的节点 **
//************************
public string returnEdit()
{
string startValue = "";
string fatherID = "";
string id = Request.QueryString["id"];
if (!IsNumber(id))
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -