adminusers.aspx.cs

本程序基于 asp.net 2.0 +sql server 2

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 System.Data.SqlClient;
using System.IO;

public partial class admin_adminUsers : System.Web.UI.Page
{
    SqlDataReader dr;
    int pagesize = 10;
    string action="";
    int userid;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["admin"] == null)
            Response.Redirect("adminLogin.aspx");

        if (Request.QueryString["action"] != null)
        {
            this.userid = Convert.ToInt32(Request.QueryString["userid"]);
            this.action = Server.HtmlEncode(Request.QueryString["action"]);
        }

        if (action == "edit")
            editUser();
        if (action == "delete")
            deleteUser();
        if (!IsPostBack)
        {
            pageNavigate();
            readUser(1);
            ViewState["currentPage"] = 1;
        }
    }

    private void editUser()
    {         
        String path = Server.MapPath("~/user/face/");
        path = path + userid + ".jpg";
        if (File.Exists(path))
        {
            Image1.Visible = true;
            Image1.ImageUrl = "~/user/face/" + userid + ".jpg";
        }
        else
            Image1.Visible = false;
    }


    private void deleteUser()
    {

        string strconn = ConfigurationManager.ConnectionStrings["dsn"].ToString();
        SqlConnection cn = new SqlConnection(strconn);
        cn.Open();

        string sql = "delete from users where userid=" + userid;
        sql += " ; delete from blog where userid=" + userid;
        sql += " ; delete from reply where userid=" + userid;
        sql += " ;delete from friendlink where userid=" + userid;
        sql += " ;delete from subject where userid=" + userid;
        SqlCommand cm = new SqlCommand(sql, cn);
        cm.ExecuteNonQuery();
        cn.Close();
    }


    //根据用户的userid，和当前状态视图中存储的页码 读取指定条数的数据记录并显示
    private string readUser(int pageindex)
    {
        string strconn = ConfigurationManager.ConnectionStrings["dsn"].ToString();

        SqlConnection cn = new SqlConnection(strconn);
        cn.Open();
        SqlCommand cm = new SqlCommand("pageUser", cn);
        cm.CommandType = CommandType.StoredProcedure;

        cm.Parameters.Add("@PageSize", SqlDbType.Int);
        cm.Parameters.Add("@PageIndex", SqlDbType.Int);

        cm.Parameters["@PageSize"].Value = pagesize;
        cm.Parameters["@PageIndex"].Value = pageindex;

        try
        {
            this.dr = cm.ExecuteReader();
            displayData();
            ViewState["currentPage"] = pageindex;
            lb_current_page.Text = pageindex.ToString();

            /*显示用户图片*/
            return "success";

        }
        catch (SqlException ex)
        {
            return ex.Message;
        }
        finally
        {
            cn.Close();
        }
    }
    //输出html文本，输出的是一个表格，输出到了预先定义的span （message） 中
    private void displayData()
    {
        string head, data = "";
        head = "<table><tr class=firstrow>";
        head += "<td class=col1>用户名</td>";
        head += "<td class=col4>注册日期</td>";
        head += "<td class=col3>登陆IP</td>";
        head += "<td class=col1>编辑</td>";
        head += "<td class=col1>删除</td></tr>";

        while (this.dr.Read())
        {
            int userid;
            string username,logindate,loginip;
            userid = Convert.ToInt32(dr["userid"].ToString());  
            username  = dr["username"].ToString();
            logindate = dr["logindate"].ToString();
            loginip = dr["loginip"].ToString();

            data += "<tr class=datarow>";
            data += "<td>" +username + "</td>";
            data += "<td>"+logindate+"</td>";
            data += "<td>" + loginip  + "</td>";
            data += "<td><a href=adminUsers.aspx?action=edit&userid=" + userid;
            data += ">查看</a></td>";
            data += "<td><a href=adminUsers.aspx?action=delete&userid="+userid ;
            data += ">删除</a></td>";
            data += "</tr>";
        }
        string all = head + data + "</table>";
        message.InnerHtml = all;
    }

    //生成总页数，根据每页显示多少条记录得出页数
    private void pageNavigate()
    {
        string strconn = ConfigurationManager.ConnectionStrings["dsn"].ToString();
        SqlConnection cn = new SqlConnection(strconn);
        cn.Open();

        string mysql = "select count(userid) from users ";
        SqlCommand cm = new SqlCommand(mysql, cn);

        SqlDataReader sumdr = cm.ExecuteReader();
        if (sumdr.Read())
            ViewState["sumPage"] = Convert.ToInt32(sumdr[0].ToString()) / pagesize + 1;
        lb_sum_page.Text = ViewState["sumPage"].ToString();
        cn.Close();
    }

    //页面直接跳转
    protected void tb_goPage_TextChanged(object sender, EventArgs e)
    {
        int x = Convert.ToInt32(tb_goPage.Text);
        if (x < 1) x = 1;
        int sumpage = Convert.ToInt32(ViewState["sumPage"].ToString());
        if (x > sumpage) x = sumpage;
        readUser(x);
    }

    //上一页
    protected void lb_previous_Click(object sender, EventArgs e)
    {
        int x = Convert.ToInt32(ViewState["currentPage"].ToString()) - 1;
        if (x < 1) x = 1;
        readUser(x);
    }

    //下一页
    protected void lb_next_Click(object sender, EventArgs e)
    {
        int x = Convert.ToInt32(ViewState["currentPage"].ToString()) + 1;
        int sumpage = Convert.ToInt32(ViewState["sumPage"].ToString());
        if (x > sumpage) x = sumpage;
        readUser(x);
    }


    protected void Button1_Click(object sender, EventArgs e)
    {
        string strconn = ConfigurationManager.ConnectionStrings["dsn"].ToString();
        SqlConnection cn = new SqlConnection(strconn);
        cn.Open();

        string sql = " select userid,username,nickname,loginip,logindate,email from users";

        if (dropSearch.SelectedValue == "userid")
            sql += " where userid=" + Convert.ToInt32(tbSearch.Text);
        else if (dropSearch.SelectedValue == "username")
            sql += " where username like '%" + Server.HtmlEncode(tbSearch.Text) + "%'";
        else if(dropSearch .SelectedValue=="nickname")
            sql += " where nickname like '%" + Server.HtmlEncode(tbSearch.Text) + "%'";

        SqlCommand cm = new SqlCommand(sql, cn);

        try
        {
            this.dr = cm.ExecuteReader();
            displayData();
            navigator.InnerHtml = "";
        }
        catch (SqlException ex)
        {
            ;
        }
        finally
        {
            cn.Close();
        }
    }
}