Repeater 实现批量,删除.全选.分页

分页用别人的.
js代码
<script language="javascript" type="text/javascript">
function selectall(chkcontrol)
        {
         var chkall=chkcontrol;
          State=chkall.checked;
          elem=chkall.form.elements;
           for (i=0;i<elem.length;i++)
           {
               if(elem[i].type=="checkbox" && elem[i]!=chkall.id)
              {
                if(elem[i].checked!=State)
                {
                   elem[i].click();
                }
            }
           }
        }
        </script>

int intmusicId = 0;
    protected void Page_Load(object sender, EventArgs e)
    {
        //intmusicId = int.Parse(Request.QueryString["id"].ToString());
        if (!IsPostBack)
        {
            info_show();
        }
    }
    protected void info_show()
    {
        //string strSql = "SELECT musicId,Name FROM [music] where sortId=2";
        //DataTable dt = DAL.SqlServer2000.RunSelect(strSql);
        //Repeater1.DataSource = dt;
        //Repeater1.DataBind();

int pagesize = AspNetPager1.PageSize;//分页数.每页多少条数据
int pageindex = AspNetPager1.CurrentPageIndex;//第几页

string str1 = "SELECT * FROM music where sortId=2 ORDER BY musicId desc";//返回记录总数

        string str2 = " SELECT TOP " + pagesize + " * FROM music WHERE sortId=2 and musicId NOT IN ( SELECT TOP " + pagesize * (pageindex - 1) + " musicId FROM music ORDER BY musicId ) ORDER BY musicId desc";
        DataTable dt = DAL.SqlServer2000.RunSelect(str1);
        int count = dt.Rows.Count;//记录总数
        AspNetPager1.RecordCount = count;//记录总数
        AspNetPager1.DataBind();
        dt = DAL.SqlServer2000.RunSelect(str2);
        Repeater1.DataSource = dt;
        Repeater1.DataBind();
    }
    //分页
    protected void AspNetPager1_PageChanged(object sender, EventArgs e)
    {
        info_show();
    }
    protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
    {
        int id = Convert.ToInt32(e.CommandArgument);
        if (e.CommandName == "Delete")
        {
            //string strsql = "update music set where musicId=" + id;//放入回收站
            string strsql = "delete FROM [music] where musicId=" + id;//这句是直接删除.删除语句
            //Response.Write(strsql);
            DAL.SqlServer2000.RunSql(strsql);

ClassMessage.ShowAndRedirect(this.Page, "删除成功!", "T_music_sort.aspx");
}

        if (e.CommandName == "del")
        {
            string a = e.CommandArgument.ToString();
            Response.Write(a);
        }

    }
    protected void LinkButton3_Click(object sender, EventArgs e)
    {

            foreach (RepeaterItem Item in Repeater1.Items)
            {
                CheckBox chk = (CheckBox)Item.FindControl("ckbIndex");
                if (chk.Checked)
                {
                    //Page.ClientScript.RegisterStartupScript(GetType(), "111", "<script>alert('要批量删除的记录ID号："+chk.Text+"');</script>");
                    //Response.Write("要批量删除的记录ID号：" + chk.Text + "<br/>");
                    string strsql = "delete FROM music where musicId=" + chk.Text;//这句是直接删除.删除语句
                    //Response.Write(strsql);
                    //Response.Write(strsql);
                    DAL.SqlServer2000.RunSql(strsql);

ClassMessage.ShowAndRedirect(this.Page, "删除成功!", "T_music_sort.aspx");

}

}
}

    protected void lbdelete_Click(object sender, EventArgs e)
    {
        foreach (RepeaterItem Item in Repeater1.Items)
        {
            CheckBox chk = (CheckBox)Item.FindControl("ckbIndex");
            if (chk.Checked)
            {
                //Page.ClientScript.RegisterStartupScript(GetType(), "111", "<script>alert('要批量删除的记录ID号："+chk.Text+"');</script>");
                //Response.Write("要批量删除的记录ID号：" + chk.Text + "<br/>");
                string strsql = "delete FROM music where musicId=" + chk.Text;//这句是直接删除.删除语句
                //Response.Write(strsql);
                //Response.Write(strsql);
                DAL.SqlServer2000.RunSql(strsql);

                ClassMessage.ShowAndRedirect(this.Page, "删除成功!", "T_music_sort.aspx");
            }
        }
    }

posted on 2009-08-31 11:38 周奇阅读(664) 评论(6) 编辑收藏举报