admin/imgmana.aspx.cs

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.IO;

public partial class admin_imgmana : System.Web.UI.Page
{
    DBhelper db = new DBhelper();
    protected void Page_Load(object sender, EventArgs e)
    {
        //if (!IsPostBack)
        //{
        //    if (Session["Name"] == null)
        //    {
        //        Response.Redirect("../main.aspx");
        //    }

        //}
        dlBind();
    }
    protected void dlBind()
    {     
        //获取数据源的数据表
        string strSql = "select * from Album";
        DataTable dsTable = db.GetDataSet(strSql, "Album");
        PagedDataSource ps = new PagedDataSource();
        ps.DataSource = dsTable.DefaultView;
        this.DtAlbum.DataSource = ps;
        this.DtAlbum.DataKeyField = "AlbumId";
        this.DtAlbum.DataBind();
    }

    protected void BtSave_Click(object sender, EventArgs e)
    {
        string name = TextAname.Text.Trim();
        string path = Server.MapPath("~\\images\\" + name);//images目录新建相册目录
        string savepath = "..\\images\\" + name;//保存在数据库的相对地址
        string dis = albumdes.InnerText.Trim();
        DateTime dt = DateTime.Now;
        if (Directory.Exists(path))
        {
            Common.ShowMsgBox("服务器已经存在这个相册目录，请手动删除或者重新命名",this.Page);
        }
        else if (!Directory.Exists(path))
        {
            Directory.CreateDirectory(path);
            string dosql = "insert into Album (AlbumName,AlbumDis,AlbumPath,AlbumDate) values('" + name + "','" + dis + "','" + savepath + "','" + dt + "')";
            DBhelper.DoSql(dosql);
            Common.ShowMsgAndRedirect("添加成功", this.Page, "imgmana.aspx");
        } 
    }
}