public void UpdateNode(PZYM.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() + ","); 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(" where NodeID=" + node.NodeID); DbHelperOra.ExecuteSql(strSql.ToString()); }
/// <summary> /// 得到菜单节点 /// </summary> /// <param name="NodeID"></param> /// <returns></returns> public PZYM.Shop.Model.SysNode GetNode(int NodeID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from S_Tree "); strSql.Append(" where NodeID=@NodeID"); OracleParameter[] parameters = { new OracleParameter("@NodeID", OracleType.Int32, 4) }; parameters[0].Value = NodeID; PZYM.Shop.Model.SysNode node = new PZYM.Shop.Model.SysNode(); DataSet ds = DbHelperOra.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); } }
public int AddTreeNode(PZYM.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(")"); DbHelperOra.ExecuteSql(strSql.ToString()); return(node.NodeID); }
public void UpdateNode(PZYM.Shop.Model.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"); OracleParameter[] parameters = { new OracleParameter("@NodeID", OracleType.Int32, 4), new OracleParameter("@Text", OracleType.VarChar, 100), new OracleParameter("@ParentID", OracleType.Int32, 4), new OracleParameter("@Location", OracleType.VarChar, 50), new OracleParameter("@OrderID", OracleType.Int32, 4), new OracleParameter("@comment", OracleType.VarChar, 50), new OracleParameter("@Url", OracleType.VarChar, 100), new OracleParameter("@PermissionID", OracleType.Int32, 4), new OracleParameter("@ImageUrl", OracleType.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; DbHelperOra.ExecuteSql(strSql.ToString(), parameters); }
public int AddTreeNode(PZYM.Shop.Model.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)"); // OracleParameter[] parameters = { new OracleParameter("@NodeID", OracleType.Number, 4), new OracleParameter("@Text", OracleType.VarChar, 100), new OracleParameter("@ParentID", OracleType.Int32, 4), new OracleParameter("@Location", OracleType.VarChar, 50), new OracleParameter("@OrderID", OracleType.Int32, 4), new OracleParameter("@comment", OracleType.VarChar, 50), new OracleParameter("@Url", OracleType.VarChar, 100), new OracleParameter("@PermissionID", OracleType.Int32, 4), new OracleParameter("@ImageUrl", OracleType.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; DbHelperOra.ExecuteSql(strSql.ToString(), parameters); return(model.NodeID); }
/// <summary> /// 得到菜单节点 /// </summary> /// <param name="NodeID"></param> /// <returns></returns> public PZYM.Shop.Model.SysNode GetNode(int NodeID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from S_Tree "); strSql.Append(" where NodeID=" + NodeID); PZYM.Shop.Model.SysNode node = new PZYM.Shop.Model.SysNode(); DataSet ds = DbHelperSQL.Query(strSql.ToString()); 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); } }
/// <summary> /// 得到菜单节点 /// </summary> /// <param name="NodeID"></param> /// <returns></returns> public PZYM.Shop.Model.SysNode GetNode(int NodeID) { StringBuilder strSql=new StringBuilder(); strSql.Append("select * from S_Tree "); strSql.Append(" where NodeID="+NodeID); PZYM.Shop.Model.SysNode node = new PZYM.Shop.Model.SysNode(); DataSet ds=DbHelperSQL.Query(strSql.ToString()); 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; } }
/// <summary> /// 得到菜单节点 /// </summary> /// <param name="NodeID"></param> /// <returns></returns> public PZYM.Shop.Model.SysNode GetNode(int NodeID) { StringBuilder strSql=new StringBuilder(); strSql.Append("select * from S_Tree "); strSql.Append(" where NodeID=@NodeID"); OracleParameter[] parameters = { new OracleParameter("@NodeID", OracleType.Int32,4) }; parameters[0].Value = NodeID; PZYM.Shop.Model.SysNode node = new PZYM.Shop.Model.SysNode(); DataSet ds=DbHelperOra.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; } }