catemanage.aspx.cs

用C#事先的简单相册,带有FLASH功能,使用了AJAX

using System;
using System.Data;
using System.Data.OleDb;
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 cateManage : System.Web.UI.Page
{
    /// <summary>
    /// 页面加载过程
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void Page_Load(object sender, EventArgs e)
    {
        // 创建数据连接实例
        DataAccess db = new DataAccess();
        SqlDataSource1.ConnectionString = db.getConnstr();

        // 为列表传递存储过程参数
        SqlDataSource1.SelectParameters.Clear();
        SqlDataSource1.SelectParameters.Add("@UserID", Session["UserID"].ToString());

        // 创建SQL命令
        OleDbCommand oleComm = new OleDbCommand();
        oleComm.Connection = db.getConn();

        // 设置OleDbCommand SQL语句
        oleComm.CommandText = string.Format("SELECT CateID,CateName FROM Categorys WHERE UserID={0}", Session["UserID"]);

        // 获取数据
        OleDbDataReader da = oleComm.ExecuteReader();

        ListItem litem;
        listType.Items.Clear();

        // 将类别添加到父类别下拉框控件中
        while (da.Read())
        {
            litem = new ListItem(da.GetValue(1).ToString(), da.GetValue(0).ToString());
            listType.Items.Add(litem);
        }

        // 初始化下拉框选择列
        listType.SelectedIndex = 0;
    }

    protected void btnSave_Click(object sender, EventArgs e)
    {
        plEdit.Visible = false;

        // 创建数据连接
        DataAccess db = new DataAccess();

        // 创建 SQL 命令对象
        OleDbCommand oleComm = new OleDbCommand();
        oleComm.Connection = db.getConn();

        try
        {
            if (CateID.Value != "")
            {
                // 设置存储过程参数
                oleComm.CommandText = "UpdateCategory";
                oleComm.CommandType = CommandType.StoredProcedure;
                oleComm.Parameters.Add("@CateID", OleDbType.Integer, 4);
                oleComm.Parameters.Add("@CateName", OleDbType.VarChar, 40);
                oleComm.Parameters.Add("@ParentCateID", OleDbType.Integer, 4);
                oleComm.Parameters.Add("@UserID", OleDbType.Integer, 4);

                oleComm.Parameters["@CateID"].Value = CateID.Value;
                oleComm.Parameters["@CateName"].Value = txtUName.Text;
                oleComm.Parameters["@ParentCateID"].Value = listType.SelectedValue;
                oleComm.Parameters["@UserID"].Value = Session["UserID"].ToString(); ;
            }
            else
            {

                // 设置存储过程参数
                oleComm.CommandText = "AddCategory";
                oleComm.CommandType = CommandType.StoredProcedure;
                oleComm.Parameters.Add("@CateName", OleDbType.VarChar, 40);
                oleComm.Parameters.Add("@ParentCateID", OleDbType.Integer, 4);
                oleComm.Parameters.Add("@UserID", OleDbType.Integer, 4);

                oleComm.Parameters["@CateName"].Value = txtUName.Text;
                oleComm.Parameters["@ParentCateID"].Value = listType.SelectedValue;
                oleComm.Parameters["@UserID"].Value = Session["UserID"].ToString();
            }

            // 添加数据
            oleComm.ExecuteNonQuery();
        }
        catch { }
        finally
        {
            // 关闭数据连接
            db.Close();
        }
        gvCate.DataBind();
    }
    protected void gvCate_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        gvCate.PageIndex = e.NewPageIndex;
        gvCate.DataBind();
    }
    protected void gvCate_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        if (e.CommandName == "Select")
        {
            plEdit.Visible = true;
        }
        if (e.CommandName == "New")
        {
            txtUName.Text = "";
            CateID.Value = "";
            plEdit.Visible = true;
        }
    }
    protected void gvCate_SelectedIndexChanged(object sender, EventArgs e)
    {
        int key = Convert.ToInt32(gvCate.DataKeys[gvCate.SelectedIndex].Value.ToString());

        // 创建数据连接
        DataAccess db = new DataAccess();

        // 创建 SQL 命令对象
        OleDbCommand oleComm = new OleDbCommand();
        oleComm.Connection = db.getConn();

        try
        {
            // 设置存储过程参数
            oleComm.CommandText = "GetCategoryInfo";
            oleComm.CommandType = CommandType.StoredProcedure;
            oleComm.Parameters.Add("@CateID", OleDbType.Integer, 4);
            oleComm.Parameters["@CateID"].Value = key;

            // 创建适配器
            OleDbDataReader da = oleComm.ExecuteReader();

            da.Read();
            CateID.Value = da.GetValue(0).ToString();
            txtUName.Text = da.GetValue(1).ToString();
            listType.SelectedValue = da.GetValue(2).ToString();
        }
        catch { }
        finally
        {
            // 关闭数据连接
            db.Close();
        }
    }
}