前台代码下载地址
http://www.baidupcs.com/file/043e27183b83917671dfbf5645559cae?fid=2467423588-250528-2474618939&time=
1362981939&sign=FDTA-DCb740ccc5511e5e8fedcff06b081203-jRy6dVFO4Oj44qlPgo%2Fiwz2ob1I%3D&expires=1h
后台代码
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
namespace Windows_Dal
{
public class Treeview_Dal
{
static SqlConnection myConnection = new SqlConnection("server=.;database=windows_test;uid=sa;pwd=1");
public static DataTable GetMenuToDataTable()
{
string sql = "select * from sysMenuTree";
return DBTools.DB.ExecuteDataSet(CommandType.Text, sql).Tables[0];
}
public static bool Update_Treeview(string id, string text)
{
myConnection.Open();
SqlTransaction myTrans = myConnection.BeginTransaction();
SqlCommand myCommand = new SqlCommand();
myCommand.Connection = myConnection;
myCommand.Transaction = myTrans;
int count = 0;
try
{
string sql = string.Format("update sysMenuTree set sText = '{0}' where NoteId = '{1}'", text, id);
myCommand.CommandText = sql;
count = myCommand.ExecuteNonQuery();
//DBTools.DB.ExecuteNonQuery(CommandType.Text, sql);
myTrans.Commit();
}
catch (Exception)
{
myTrans.Rollback();
}
finally
{
myConnection.Close();
}
return count > 0 ? true : false;
}
public static bool Add_Treeview(string id, string text)
{
myConnection.Open();
SqlTransaction myTrans = myConnection.BeginTransaction();
SqlCommand myCommand = new SqlCommand();
myCommand.Connection = myConnection;
myCommand.Transaction = myTrans;
int count = 0;
try
{
string sql = string.Format("insert into sysMenuTree values('{0}','{1}','','','','','')", id, text);
myCommand.CommandText = sql;
count = myCommand.ExecuteNonQuery();
//DBTools.DB.ExecuteNonQuery(CommandType.Text, sql);
myTrans.Commit();
}
catch (Exception)
{
myTrans.Rollback();
}
finally
{
myConnection.Close();
}
return count > 0 ? true : false;
//string sql = string.Format("insert into sysMenuTree values('{0}','{1}','','','','','')", id, text);
//return DBTools.DB.ExecuteNonQuery(CommandType.Text, sql) > 0 ? true : false;
}
public static bool Add_Treeview(string text)
{
myConnection.Open();
SqlTransaction myTrans = myConnection.BeginTransaction();
SqlCommand myCommand = new SqlCommand();
myCommand.Connection = myConnection;
myCommand.Transaction = myTrans;
int count = 0;
try
{
string sql = string.Format("insert into sysMenuTree values('0','{0}','','','','','')", text);
myCommand.CommandText = sql;
count = myCommand.ExecuteNonQuery();
//DBTools.DB.ExecuteNonQuery(CommandType.Text, sql);
myTrans.Commit();
}
catch (Exception)
{
myTrans.Rollback();
}
finally
{
myConnection.Close();
}
return count > 0 ? true : false;
//string sql = string.Format("insert into sysMenuTree values('{0}','{1}','','','','','')", id, text);
//return DBTools.DB.ExecuteNonQuery(CommandType.Text, sql) > 0 ? true : false;
}
public static int Del_Treeview(string id)
{
string sql = string.Format("select count(*) from sysMenuTree where ParentId = '{0}'", id);
if ((int)DBTools.DB.ExecuteScalar(CommandType.Text, sql) > 0)
{
return 3;
}
else
{
myConnection.Open();
SqlTransaction myTrans = myConnection.BeginTransaction();
SqlCommand myCommand = new SqlCommand();
myCommand.Connection = myConnection;
myCommand.Transaction = myTrans;
int count = 0;
try
{
sql = string.Format("delete sysMenuTree where NoteId = '{0}'", id);
myCommand.CommandText = sql;
count = myCommand.ExecuteNonQuery();
//DBTools.DB.ExecuteNonQuery(CommandType.Text, sql);
myTrans.Commit();
}
catch (Exception)
{
myTrans.Rollback();
}
finally
{
myConnection.Close();
}
return count > 0 ? 1 : 2;
//sql = string.Format("delete sysMenuTree where NoteId = '{0}'", id);
//return DBTools.DB.ExecuteNonQuery(CommandType.Text, sql) > 0 ? true : false;
}
}
}
}
数据库设计
noteid parentid stext
1 0 医药专家
2 1 中药
大家可以修改一下加载方式 和 完成操作后的用户体验 就可以直接使用了。