public void UpdateNode(Hch.iDisk.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 Hch.iDisk.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;
Hch.iDisk.Model.SysNode node = new Hch.iDisk.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(Hch.iDisk.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(Hch.iDisk.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(Hch.iDisk.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 Hch.iDisk.Model.SysNode GetNode(int NodeID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from S_Tree ");
strSql.Append(" where NodeID=" + NodeID);
Hch.iDisk.Model.SysNode node = new Hch.iDisk.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 Hch.iDisk.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;
Hch.iDisk.Model.SysNode node = new Hch.iDisk.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;
}
}
/// <summary>
/// �õ��˵��ڵ�
/// </summary>
/// <param name="NodeID"></param>
/// <returns></returns>
public Hch.iDisk.Model.SysNode GetNode(int NodeID)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select * from S_Tree ");
strSql.Append(" where NodeID="+NodeID);
Hch.iDisk.Model.SysNode node = new Hch.iDisk.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;
}
}
