Пример #1
0
		public int AddTreeNode(SysNode model)
		{
			model.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("@NodeID,@Text,@ParentID,@Location,@OrderID,@comment,@Url,@PermissionID,@ImageUrl)");
				
			//
			SqlParameter[] parameters = {
											new SqlParameter("@NodeID", SqlDbType.Int,4),
											new SqlParameter("@Text", SqlDbType.VarChar,100),
											new SqlParameter("@ParentID", SqlDbType.Int,4),										
											new SqlParameter("@Location", SqlDbType.VarChar,50),
											new SqlParameter("@OrderID", SqlDbType.Int,4),
											new SqlParameter("@comment", SqlDbType.VarChar,50),
											new SqlParameter("@Url", SqlDbType.VarChar,100),
											new SqlParameter("@PermissionID", SqlDbType.Int,4),
											new SqlParameter("@ImageUrl", SqlDbType.VarChar,100)};
			parameters[0].Value = model.NodeID;
			parameters[1].Value = model.Text;
			parameters[2].Value = model.ParentID;		
			parameters[3].Value = model.Location;
			parameters[4].Value = model.OrderID;
			parameters[5].Value = model.Comment;
			parameters[6].Value = model.Url;
			parameters[7].Value = model.PermissionID;
			parameters[8].Value = model.ImageUrl;
		
			DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
			return model.NodeID;
		}
Пример #2
0
		public int AddTreeNode(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(""+node.ModuleID+",");
//			strSql.Append(""+node.KeShiDM+",");
//			strSql.Append("'"+node.KeshiPublic+"'");
			strSql.Append(")");						
			DbHelperSQL.ExecuteSql(strSql.ToString());
			return node.NodeID;

		}
Пример #3
0
		public void UpdateNode(SysNode node)
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("update S_Tree set ");
			strSql.Append("Text='"+node.Text+"',");
			strSql.Append("ParentID="+node.ParentID.ToString()+",");
			strSql.Append("Location='"+node.Location+"',");
			strSql.Append("OrderID="+node.OrderID+",");
			strSql.Append("comment='"+node.Comment+"',");
			strSql.Append("Url='"+node.Url+"',");
			strSql.Append("PermissionID="+node.PermissionID+",");
			strSql.Append("ImageUrl='"+node.ImageUrl+"'");
//			strSql.Append("ModuleID="+node.ModuleID+",");
//			strSql.Append("KeShiDM="+node.KeShiDM+",");
//			strSql.Append("KeshiPublic='"+node.KeshiPublic+"'");
			strSql.Append(" where NodeID="+node.NodeID);
			DbHelperSQL.ExecuteSql(strSql.ToString());

		}
Пример #4
0
		public void UpdateNode(SysNode model)
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("update S_Tree set ");
			strSql.Append("Text=@Text,");
			strSql.Append("ParentID=@ParentID,");
			strSql.Append("Location=@Location,");
			strSql.Append("OrderID=@OrderID,");
			strSql.Append("comment=@comment,");
			strSql.Append("Url=@Url,");
			strSql.Append("PermissionID=@PermissionID,");
			strSql.Append("ImageUrl=@ImageUrl");
			strSql.Append(" where NodeID=@NodeID");

			SqlParameter[] parameters = {
											new SqlParameter("@NodeID", SqlDbType.Int,4),
											new SqlParameter("@Text", SqlDbType.VarChar,100),
											new SqlParameter("@ParentID", SqlDbType.Int,4),										
											new SqlParameter("@Location", SqlDbType.VarChar,50),
											new SqlParameter("@OrderID", SqlDbType.Int,4),
											new SqlParameter("@comment", SqlDbType.VarChar,50),
											new SqlParameter("@Url", SqlDbType.VarChar,100),
											new SqlParameter("@PermissionID", SqlDbType.Int,4),
											new SqlParameter("@ImageUrl", SqlDbType.VarChar,100)};
			parameters[0].Value = model.NodeID;
			parameters[1].Value = model.Text;
			parameters[2].Value = model.ParentID;		
			parameters[3].Value = model.Location;
			parameters[4].Value = model.OrderID;
			parameters[5].Value = model.Comment;
			parameters[6].Value = model.Url;
			parameters[7].Value = model.PermissionID;
			parameters[8].Value = model.ImageUrl;

			DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);

		}
Пример #5
0
		/// <summary>
		/// 得到菜单节点
		/// </summary>
		/// <param name="NodeID"></param>
		/// <returns></returns>
		public SysNode GetNode(int NodeID)
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("select * from S_Tree ");	
			strSql.Append(" where NodeID=@NodeID");
			
			SqlParameter[] parameters = {
											new SqlParameter("@NodeID", SqlDbType.Int,4)
										};
			parameters[0].Value = NodeID;	

			SysNode node=new SysNode();
			DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
			if(ds.Tables[0].Rows.Count>0)
			{
				node.NodeID=int.Parse(ds.Tables[0].Rows[0]["NodeID"].ToString());
				node.Text=ds.Tables[0].Rows[0]["text"].ToString();
				if(ds.Tables[0].Rows[0]["ParentID"].ToString()!="")
				{
					node.ParentID=int.Parse(ds.Tables[0].Rows[0]["ParentID"].ToString());
				}
				node.Location=ds.Tables[0].Rows[0]["Location"].ToString();
				if(ds.Tables[0].Rows[0]["OrderID"].ToString()!="")
				{
					node.OrderID=int.Parse(ds.Tables[0].Rows[0]["OrderID"].ToString());
				}
				node.Comment=ds.Tables[0].Rows[0]["comment"].ToString();
				node.Url=ds.Tables[0].Rows[0]["url"].ToString();
				if(ds.Tables[0].Rows[0]["PermissionID"].ToString()!="")
				{
					node.PermissionID=int.Parse(ds.Tables[0].Rows[0]["PermissionID"].ToString());
				}
				node.ImageUrl=ds.Tables[0].Rows[0]["ImageUrl"].ToString();	
								
				return node;
			}
			else
			{
				return null;
			}

			
		}
Пример #6
0
 public void UpdateNode(SysNode node)
 {
     dal.UpdateNode(node);
 }
Пример #7
0
 public int AddTreeNode(SysNode node)
 {
     return dal.AddTreeNode(node);
 }
Пример #8
0
        protected void btnAdd_Click(object sender, System.EventArgs e)
        {
            string id=Maticsoft.Common.PageValidate.InputText(this.lblID.Text,10);
            string orderid=Maticsoft.Common.PageValidate .InputText(this.txtOrderid.Text,5);
            string name=txtName.Text;
            string url=Maticsoft.Common.PageValidate.InputText(txtUrl.Text,100);
            //			string imgUrl=Maticsoft.Common.PageValidate.InputText(txtImgUrl.Text,100);
            string imgUrl=this.hideimgurl.Value;
            string target=this.listTarget.SelectedValue;
            int parentid=int.Parse(target);

            string strErr="";

            if(orderid.Trim()=="")
            {
                strErr+="编号不能为空\\n";

            }
            try
            {
                int.Parse(orderid);
            }
            catch
            {
                strErr+="编号格式不正确\\n";

            }
            if(name.Trim()=="")
            {
                strErr+="名称不能为空\\n";
            }

            if(this.listPermission.SelectedItem.Text.StartsWith("╋"))
            {
                strErr+="权限类别不能做权限使用\\n";
            }

            if(strErr!="")
            {
                Maticsoft.Common.MessageBox.Show(this,strErr);
                return;
            }

            int permission_id=-1;
            if(this.listPermission.SelectedIndex>0)
            {
                permission_id=int.Parse(this.listPermission.SelectedValue);
            }
            int moduleid=-1;
            //			if(this.dropModule.SelectedIndex>0)
            //			{
            //				moduleid=int.Parse(this.dropModule.SelectedValue);
            //			}
            //			int moduledeptid=-1;
            //			if(this.dropModuleDept.SelectedIndex>0)
            //			{
            //				moduledeptid=int.Parse(this.dropModuleDept.SelectedValue);
            //			}
            int keshidm=-1;
            //			if(this.Dropdepart.SelectedIndex>0)
            //			{
            //				keshidm=int.Parse(this.Dropdepart.SelectedValue);
            //			}
            string keshipublic="false";
            //			if(this.chkPublic.Checked)
            //			{
            //				keshipublic="true";
            //			}
            string comment=Maticsoft.Common.PageValidate.InputText(txtDescription.Text,100);

            SysNode node=new SysNode();
            node.NodeID=int.Parse(id);
            node.OrderID=int.Parse(orderid);
            node.Text=name;
            node.ParentID=parentid;
            node.Location=parentid+"."+orderid;
            node.Comment=comment;
            node.Url=url;
            node.PermissionID=permission_id;
            node.ImageUrl=imgUrl;
            node.ModuleID=moduleid;
            node.KeShiDM=keshidm;
            node.KeshiPublic=keshipublic;

            Maticsoft.BLL.SysManage sm=new Maticsoft.BLL.SysManage();
            sm.UpdateNode(node);
            Response.Redirect("show.aspx?id="+id);
        }
Пример #9
0
		protected void btnAdd_Click(object sender, System.EventArgs e)
		{
			
			string orderid=LTP.Common.PageValidate.InputText(txtId.Text,10);
			string name=txtName.Text;
			string url=LTP.Common.PageValidate.InputText(txtUrl.Text,100);
			//string imgUrl=LTP.Common.PageValidate.InputText(txtImgUrl.Text,100);
			string imgUrl=this.hideimgurl.Value;

			string target=this.listTarget.SelectedValue;			
			int parentid=int.Parse(target);

			string strErr="";

			if(orderid.Trim()=="")
			{				
				strErr+="编号不能为空\\n";				
			}
			try
			{
				int.Parse(orderid);
			}
			catch
			{				
				strErr+="编号格式不正确\\n";
				
			}
			if(name.Trim()=="")
			{				
				strErr+="名称不能为空\\n";				
			}

			if(this.listPermission.SelectedItem.Text.StartsWith("╋"))
			{				
				strErr+="权限类别不能做权限使用\\n";				
			}

			if(strErr!="")
			{
				LTP.Common.MessageBox.Show(this,strErr);
				return;
			}
            
			int permission_id=-1;
			if(this.listPermission.SelectedIndex>0)
			{
				permission_id=int.Parse(this.listPermission.SelectedValue);
			}
			int moduleid=-1;
			int keshidm=-1;
			string keshipublic="false";
			string comment=LTP.Common.PageValidate.InputText(txtDescription.Text,100);
		
			SysNode node=new SysNode();
			node.Text=name;
			node.ParentID=parentid;
			node.Location=parentid+"."+orderid;
			node.OrderID=int.Parse(orderid);
			node.Comment=comment;
			node.Url=url;
			node.PermissionID=permission_id;
			node.ImageUrl=imgUrl;
			node.ModuleID=moduleid;
			node.KeShiDM=keshidm;
			node.KeshiPublic=keshipublic;
            Maticsoft.BLL.SysManage sm = new Maticsoft.BLL.SysManage();
            if (CheckBox1.Checked)
            {
                LTP.Accounts.Bus.Permissions p = new LTP.Accounts.Bus.Permissions();
                string permissionName = node.Text;
                int parentID = node.ParentID;
                if (parentID == 0)
                {
                    //根目录下不能选择同步创建权限
                    LTP.Common.MessageBox.Show(this.Page, "根目录不能选择同步创建权限,请您手动创建!");
                    return;
                }
                SysNode parentNode = new SysNode();
                parentNode = sm.GetNode(parentID);
                int catalogID = sm.GetPermissionCatalogID(parentNode.PermissionID);
                int permissionID = p.Create(catalogID, permissionName);
                node.PermissionID = permissionID;
            }			
			sm.AddTreeNode(node);

			if(chkAddContinue.Checked)
			{
				Response.Redirect("Add.aspx");
			}
			else
			{
				Response.Redirect("treelist.aspx");
			}
		}