SQLServerDAL/SysManage.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System.Text;
using System.Data;
using CAI.SHOP.IDAL;
using Maticsoft.DBUtility;
namespace CAI.SHOP.SQLServerDAL
{
	/// <summary>
	/// 系统菜单管理类。(普通SQL实现方式)
	/// </summary>
    public class SysManage : ISysManage
	{
        //在这里可以更换数据库,支持多数据库，支持采用加密方式实现
        //DbHelperSQLP DbHelperSQL = new DbHelperSQLP(PubConstant.GetConnectionString("ConnectionString2"));
		public SysManage()
		{            
		}
        
		public int GetMaxId()
		{
			string strsql="select max(NodeID)+1 from S_Tree";
			object obj=DbHelperSQL.GetSingle(strsql);
			if(obj==null)
			{
				return 1;
			}
			else
			{
				return int.Parse(obj.ToString());
			}
		}

        public int AddTreeNode(CAI.SHOP.Model.SysNode node)
		{
			node.NodeID=GetMaxId();

			StringBuilder strSql=new StringBuilder();
			strSql.Append("insert into S_Tree(");
			strSql.Append("NodeID,Text,ParentID,Location,OrderID,comment,Url,PermissionID,ImageUrl)");
			strSql.Append(" values (");
			strSql.Append("'"+node.NodeID+"',");
			strSql.Append("'"+node.Text+"',");
			strSql.Append(""+node.ParentID+",");			
			strSql.Append("'"+node.Location+"',");
			strSql.Append(""+node.OrderID+",");		
			strSql.Append("'"+node.Comment+"',");
			strSql.Append("'"+node.Url+"',");
			strSql.Append(""+node.PermissionID+",");
			strSql.Append("'"+node.ImageUrl+"'");
			strSql.Append(")");						
			DbHelperSQL.ExecuteSql(strSql.ToString());
			return node.NodeID;

		}

        public void UpdateNode(CAI.SHOP.Model.SysNode node)
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("update S_Tree set ");
			strSql.Append("Text='"+node.Text+"',");
			strSql.Append("ParentID="+node.ParentID.ToString()+",");