admin/type/type_sql.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

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

using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.OleDb;
using System.Data;

namespace web.admin.type
{
    public partial class type_sql1 : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                #region 第一个类上移
                if (Request.QueryString["type_one_s"] != null)
                {
                    int uid = Convert.ToInt32(Request.QueryString["type_one_s"]);//原来的id

                    int y_px = Convert.ToInt32(new AcsHelper().ExecuteScalar("select px from type_one where id=" + uid.ToString()));//原来的px

                    int y_type = Convert.ToInt32(new AcsHelper().ExecuteScalar("select tid from type_one where id=" + uid.ToString()));//原来的px

                    int x_id = 0;//要替换的id
                    int x_px = 0;//要替换的px

                    Boolean bol = true;

                    using (DataTable dt = new AcsHelper().ExecuteDataTable("select top 1 * From type_one where px<" + y_px.ToString() + " and tid="+y_type+" order by px desc"))
                    {
                        int i=0;
                        foreach (DataRow r in dt.Rows)
                        {
                            i++;
                            x_id = Convert.ToInt32(r["id"]);
                            x_px = Convert.ToInt32(r["px"]);
                        }
                        if(i==0)
                        {
                            bol = false;
                        }
                    }

                    if (bol)
                    {
                        string sql1 = "update type_one set px=" + x_px.ToString() + " where id=" + uid.ToString();
                        string sql2 = "update type_one set px=" + y_px.ToString() + " where id=" + x_id.ToString();
                        new AcsHelper().ExecuteNonQuery(sql1);
                        new AcsHelper().ExecuteNonQuery(sql2);

                        Response.Redirect("type.aspx#type_1_"+uid.ToString());

                    }
                    else
                    {
                        Response.Write("<script>alert('操作失败！');location.href='type.aspx';</script>");
                    }