SlideShowManage.aspx.cs

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

using MyWeb.DBUtility;
using MyWeb.WebUtility;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace MyWeb
{
    public partial class SlideShowManage : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {

        }
        [WebMethod]
        public static string loadSlideShowManage(string pi, string ps)
        {
            DBHelper db = new DBHelper();
            //分页sql查询列表数据
            string sql = "select top " + ((Convert.ToInt32(pi) - 1) * Convert.ToInt32(ps) + Convert.ToInt32(ps)) + " * from SlideShow_Tbl where del=0  and id not in (select top " + ((Convert.ToInt32(pi) - 1) * Convert.ToInt32(ps)) + " id from SlideShow_Tbl where del=0 order by addDate desc) order by addDate desc";
            DataSet ds = db.Query(sql);
            string html = "";
            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                //得到列表数据
                html += "<tr><td><img style='width:20px;height:20px;' src='" + ds.Tables[0].Rows[i]["SlideUrl"].ToString() + "' /></td><td>" + ds.Tables[0].Rows[i]["addDate"] + "</td><td><input type='button' value='删除' class='btn' id='" + ds.Tables[0].Rows[i]["id"] + "'/></td></tr>";
            }
            return html;
        }
        //删除列表信息
        [WebMethod]
        public static int RemoveSlideShowManage(string id)
        {
            DBHelper db = new DBHelper();
            WebHelper wb = new WebHelper();
            string sql = "update SlideShow_Tbl set del=1 where id='" + id + "'";
            int renum = db.ExecuteSql(sql);
            if (renum == 1)
            {
                return 1;
            }
            else
            {
                return 0;
            }

        }
        protected void Button1_Click(object sender, EventArgs e)
        {
            Response.Redirect("AddSlideShow.aspx");
        }
    }
}