list.aspx.cs

基于Web的图片管理功能模块,使用SQL SERVER和VS2005

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class List : System.Web.UI.Page
{
    SQLHelper helper = new SQLHelper();

    // 页面装载
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            BindListView(treeList);
        }
    }
    // 上传图片
    protected void btnUpload_Click(object sender, EventArgs e)
    {
        if (treeList.SelectedNode == null)
        {
            //显示提示信息
            Response.Write("<script>window.alert('请选择合适的目录上传')</script>");
            return;
        }
        else if (! helper.CheckDir(treeList.SelectedValue))
        {
            //显示提示信息
            Response.Write("<script>window.alert('请选择合适的目录上传')</script>");
            return;
        }
        Response.Redirect("~/Upload.aspx?ImgID=" + treeList.SelectedValue);
    }
    // 新建目录
    protected void btnAdd_Click(object sender, EventArgs e)
    {
        if (treeList.SelectedNode == null)
        {
            ///显示提示信息
            Response.Write("<script>window.alert('请选择合适的目录添加')</script>");
            return;
        }
        else if (! helper.CheckDir(treeList.SelectedValue))
        {
            //显示提示信息
            Response.Write("<script>window.alert('请选择合适的目录添加')</script>");
            return;
        }
        Response.Redirect("~/Build.aspx?ImgID=" + treeList.SelectedValue);
    }
    // 修改项目名称
    protected void btnEdit_Click(object sender, EventArgs e)
    {
        if (treeList.SelectedNode == null)
        {
            ///显示提示信息
            Response.Write("<script>window.alert('请选择合适的修改项目')</script>");
            return;
        }
        else if (treeList.SelectedValue == "1")
        {
            //显示提示信息
            Response.Write("<script>window.alert('根目录不能修改名称')</script>");
            return;
        }

        Response.Redirect("~/Edit.aspx?" + 
                          "ImgID=" + treeList.SelectedValue + "&" +
                          "ImgName=" + Server.HtmlEncode(treeList.SelectedNode.Text));
    }
    // 删除项目
    protected void btnDelete_Click(object sender, EventArgs e)
    {
        if (treeList.SelectedNode == null)
        {
            ///显示提示信息
            Response.Write("<script>window.alert('请选择合适的删除对象')</script>");
            return;
        }
        else if (treeList.SelectedValue == "1")
        {
            //显示提示信息
            Response.Write("<script>window.alert('根目录不能删除')</script>");
            return;
        }
        else if (helper.CheckChild(treeList.SelectedValue))
        {
            //显示提示信息
            Response.Write("<script>window.alert('请先删除目录下的文件和子目录')</script>");
            return;
        }
        // 删除节点
        helper.DeleteItem(treeList.SelectedValue);
        // 显示提示信息
        Response.Write("<script>window.alert('删除成功！')</script>");
        BindListView(treeList);
        imgPicture.Visible = false;
    }

    // 查看图片
    protected void tvPictureList_SelectedNodeChanged(object sender, EventArgs e)
    {
        if (treeList.SelectedNode.ImageToolTip != "")
        {
            imgPicture.ImageUrl = treeList.SelectedNode.ImageToolTip;
            imgPicture.Visible = true;
        }
    }

    // 绑定树形控件
    public void BindListView(TreeView treeView)
    {
        //清空树的所有节点
        treeView.Nodes.Clear();

        //创建根节点
        TreeNode rootNode = new TreeNode();
        rootNode.Text = "图片目录";
        rootNode.Value = "1";
        rootNode.ImageUrl = "~/Image/Root.gif";
        rootNode.Expanded = true;
        rootNode.Selected = true;

        //添加根节点
        treeView.Nodes.Add(rootNode);

        // 获取所有节点信息
        DataTable dataTable = helper.GetPictureDetails();
        //创建其他节点
        CreateChildNode(rootNode, dataTable);
    }
    // 添加子节点
    private void CreateChildNode(TreeNode parentNode, DataTable dataTable)
    {
        DataRow[] rowList = dataTable.Select("ParentID='" + parentNode.Value + "'");
        foreach (DataRow row in rowList)
        {   ///创建新节点
            TreeNode node = new TreeNode();
            ///设置节点的属性
            node.Text = row["ImgName"].ToString();
            node.Value = row["ImgID"].ToString();
            if (row["isDir"].ToString() == "True")
            {
                node.Expanded = true;
                node.Target = "_self";
                node.ImageUrl = "~/Image/Dir.gif";
            }
            else
            {
                node.Target = "_blank";
                node.ImageUrl = "~/Image/Picture.gif";
            }
            node.ImageToolTip = row["ImgUrl"].ToString();
            parentNode.ChildNodes.Add(node);
            ///递归调用，创建其他节点
            CreateChildNode(node, dataTable);
        }
    }
}