photoclass.aspx.cs

小E单班同学录系统

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 Admin_PhotoClass : MyPage
{
    protected void Page_Load(object sender, EventArgs e)
    {
        WebFunction.AdminLogin();
        this.divA.Visible = false;
        this.divM.Visible = false;
        switch (Request.QueryString["Op"])
        {
            case "Add":
                Add();
                break;
            case "Del":
                Del();
                break;
            case "Modify":
                Modify();
                break;
            default:
                ShowClass();
                break;
        }
    }

    void Add()
    {
        this.divA.Visible = true;
    }
    void Del()
    {
        dbh.Reset();
        dbh.tableName = "PhotoClass";
        dbh.conditionExpress = "ID=@ID";
        dbh.AddConditionParameters("ID", Request.QueryString["ID"]);

        if (dbh.DataDelete() > -1)
        {
            dbh.Reset();
            dbh.sqlCommand = ("select ThePath from Photo where ClassID=@ClassID");
            dbh.AddSqlCmdParameters("ClassID", Request.QueryString["ID"]);
            dbh.GetDataReader();
            while (dbh.dr.Read())
            {
                new LeeHom.Web.File.Delete("~/" + dbh.dr[0].ToString());
                new LeeHom.Web.File.Delete("~/Thumbs/" + dbh.dr[0].ToString());
            }

            dbh.Reset();
            dbh.tableName = "RePhoto";
            dbh.conditionExpress = "PhotoID in (select ID from Photo where ClassID=@ClassID)";
            dbh.AddConditionParameters("ClassID", Request.QueryString["ID"]);
            dbh.DataDelete();
            dbh.Reset();
            dbh.tableName = "Photo";
            dbh.conditionExpress = "ClassID=@ClassID";
            dbh.AddConditionParameters("ClassID", Request.QueryString["ID"]);
            dbh.DataDelete();
            ShowClass();
        }
        else
        {
            Alert(this.ltlMessage, "添加失败！请查看系统错误记录！");
        }
    }

    void Modify()
    {
        if (!IsPostBack)
        {
            this.divM.Visible = true;
            ShowClass();
            dbh.Reset();
            dbh.tableName = "PhotoClass";
            dbh.AddConditionParameters("ID", Request.QueryString["ID"]);
            if (!dbh.DataExists())
            {
                Alert(this.ltlMessage, "对不起！该数据已不存在！可能已被删除！");
                this.divM.Visible = false;
                return;
            }
            dbh.Reset();
            dbh.sqlCommand = "select * from PhotoClass where ID=@ID";
            dbh.AddSqlCmdParameters("ID", Request.QueryString["ID"]);
            dbh.GetDataReader();
            if (dbh.dr.Read())
            {
                this.txtEditC.Text = dbh.dr["ClassName"].ToString();
                this.txtEditCD.Text = dbh.dr["TheDesc"].ToString(); ;
            }
        }
    }
    void ShowClass()
    {
        this.divC.Visible = true;
        dbh.Reset();
        dbh.sqlCommand="select * from PhotoClass order by TheDesc";
        LeeHom.Web.Data.BinderRepeater br = new LeeHom.Web.Data.BinderRepeater();
        br.repeater = rptPhotoC;
        br.datatable=dbh.GetDataTable();
        br.Bind();
    }
    protected void btnNewT_Click(object sender, EventArgs e)
    {
        dbh.Reset();
        dbh.tableName = "PhotoClass";
        dbh.AddFieldParameters("ClassName", LeeHom.Web.Text.HtmlEncode(this.txtNewC.Text));
        dbh.AddFieldParameters("TheDesc", this.txtNewCD.Text);
        if (dbh.DataInsert())
        {
            this.txtNewC.Text = this.txtNewCD.Text = null;
            ShowClass();
        }
        else
        {
            Alert(this.ltlMessage, "添加失败！请查看系统错误记录！");
        }
    }
    protected void btnEditC_Click(object sender, EventArgs e)
    {
        string cName = LeeHom.Web.Text.HtmlEncode(this.txtEditC.Text);
        dbh.Reset();
        dbh.tableName = "PhotoClass";
        dbh.AddFieldParameters("ClassName", cName);
        dbh.AddFieldParameters("TheDesc", this.txtEditCD.Text);
        dbh.conditionExpress = "ID=@ID";
        dbh.AddConditionParameters("ID", Request.QueryString["ID"]);
        if (dbh.DataUpdate()>-1)
        {
            dbh.Reset();
            dbh.sqlCommand = "select * from Photo where ClassID=@ClassID";
            dbh.AddSqlCmdParameters("ClassID", Request.QueryString["ID"]);
            dbh.GetDataReader();
            while (dbh.dr.Read())
            {
                MyPage a = new MyPage();
                a.dbh.Reset();
                a.dbh.tableName = "Photo";
                a.dbh.AddFieldParameters("ClassName", cName);
                a.dbh.conditionExpress = "ID=@ID";
                a.dbh.AddSqlCmdParameters("ClassID", dbh.dr[0]);
                a.dbh.DataUpdate();
                a.Dispose();
            }
            ShowClass();
            this.divM.Visible = false;
        }
        else
        {
            Alert(this.ltlMessage, "修改失败！请查看系统错误记录！");
        }
    }
}