movesection.aspx.cs

来自「《征服Ajax》原书的例题源码」· CS 代码 · 共 37 行

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;
using Microsoft.Practices.EnterpriseLibrary.Data;
using Microsoft.Practices.EnterpriseLibrary.Data.Sql;
using System.Data.Common;

public partial class MoveSection : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if ((Request.Params["oid"] != null) &&
            (Request.Params["noid"] != null))
        {
            int iOrder = Convert.ToInt32(Request.Params["oid"]);
            int iNewOrder = Convert.ToInt32(Request.Params["noid"]);

            Database db = DatabaseFactory.CreateDatabase("DatabaseConnectionString");

            string sqlCommand = "MoveSection";
            DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);

            db.AddInParameter(dbCommand, "order", DbType.Int32, iOrder);
            db.AddInParameter(dbCommand, "new_order", DbType.Int32, iNewOrder);

            db.ExecuteNonQuery(dbCommand);
        }
    }
}