user_list.aspx.cs

网博Fms在线直播系统 本程序基于fms2.0为核心的实时直播系统

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;

public partial class admin_user_list : Sp.baseadmin
{
    public string sers = "";
    protected override void Page_Load(object sender, EventArgs e)
    { 　
        base.Page_Load(sender,e);

        url_name = "会员管理";
        if (!IsPostBack)
        {
            binddr();
        }
    }

    string cid = "";
    void binddr()
    {

        string sql = "select * from Sp_user ";
        if (sers != "")
        { sql += " where idname like '%" + sers +"%'"; }
        sql += " order by id desc";
        DataSet ds= Sp.SQLServerDAL.DbHelperSQL.Query(sql);
        DataView dv = ds.Tables[0].DefaultView;
        PagedDataSource pds = new PagedDataSource();

        AspNetPager1.RecordCount = dv.Count;
        pds.DataSource = dv;
        pds.AllowPaging = true;
        pds.CurrentPageIndex = AspNetPager1.CurrentPageIndex - 1;
        pds.PageSize = AspNetPager1.PageSize;

        this.GridView1.DataSource = pds;
        this.GridView1.DataBind();
        Response.Write(33);
    }
    protected void dellall(System.Object sender, System.EventArgs e)
    {
        int i;
        string sql = "";
        string myKeyid;
        CheckBox mycheck = new CheckBox();
        for (i = 0; i < GridView1.Rows.Count; i++)
        {
            mycheck = (CheckBox)GridView1.Rows[i].FindControl("mycheck");
            if (mycheck.Checked == true)
            {

                myKeyid = GridView1.DataKeys[i].Value.ToString();

                sql = "DELETE FROM Sp_user where id=" + myKeyid;
                Sp.SQLServerDAL.DbHelperSQL.Query(sql);
            }
        }
        binddr();
    }

   
    protected void chanel(Object sender, GridViewCancelEditEventArgs e)//取消
    {
        GridView1.EditIndex = -1;
        binddr();
    }
    protected void update(Object sender, DataGridCommandEventArgs e)
    {

        //TextBox B = (TextBox)e.Item.Cells[2].Controls[0];
        //string str = "UPDATE PlayTv_sort SET Sort='" + A.Text + "',paixu='" + B.Text + "' where id='" + id + "'";
        //Spcs.Base.ExecuteSql(str);
        //Webabc_Sort.EditItemIndex = -1;
        //bindlist();// 在此处放置用户代码以初始化页面
    }
    protected void AspNetPager1_PageChanged(object src, EventArgs e)
    {
        binddr();
    }


    protected void editcomman(object sender, GridViewEditEventArgs e)
    {
        GridView1.EditIndex = e.NewEditIndex;
        binddr();
    }
    protected void update(object sender, GridViewUpdateEventArgs e)
    {
        string strid = GridView1.DataKeys[e.RowIndex].Values[0].ToString();
        DropDownList ddlstate = (DropDownList)GridView1.Rows[e.RowIndex].FindControl("DropDownList1");
        string strstate = ddlstate.SelectedItem.Value;

        string sql = "update Sp_user set jibie='" + strstate + "' where id='" + strid + "'";
        Sp.SQLServerDAL.DbHelperSQL.ExecuteSql(sql);

        //Response.Write(strid);
        GridView1.EditIndex = -1;
        binddr();
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        sers = TextBox1.Text;
        binddr();
    }
}