userlist.aspx.cs

2007年华中科技大学数据库课程设计参考程序[图书销售系统]+报告

using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Collections;
using System.Collections.Generic;
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 OnlineBookSell.BLLFactory;
using OnlineBookSell.Model;
using OnlineBookSell.IBLL;
using OnlineBookSell.DBUtility;

public partial class ljian_admin_user_userlist : System.Web.UI.Page
{

    public IUserBLL iuserdll = BLLFactory.getInstance().createUserBLL();

    private static int pageindex = 1;
    private static int pagesize = 15;
    private static int totalpages = 0;
    private static int pagecount = 0;
    protected override void OnInit(EventArgs e)
    {
        base.OnInit(e);
        rep.ItemCommand += new RepeaterCommandEventHandler(sale_ItemCommand);

    }

    protected void sale_ItemCommand(object source, RepeaterCommandEventArgs e)
    {
        String id = ((LinkButton)e.CommandSource).ToolTip;

        if (iuserdll.DeleteUser(Convert.ToInt32(id)))
        {
            LinkButton1_Click(source, e);
            shang.Enabled = false;
            shouye.Enabled = false;
            if (totalpages == 1)
            {
                xia.Enabled = false;
                weiye.Enabled = false;
            }
           // System.Web.UI.ScriptManager.RegisterClientScriptBlock(this.LinkButton1, this.LinkButton1.GetType(), "success", "alert('删除成功');", true);

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

        shang.Enabled = true;
        shouye.Enabled = true;
        xia.Enabled = true;
        weiye.Enabled = true;
        if (!IsPostBack)
        {
            usertype.Items.Add(new ListItem("所有类别", "-1"));
            using (SqlDataReader r = SQLHelper.ExecuteReader(SQLHelper.ConnectionStringLocalTransaction, CommandType.Text, "select * from usertype"))
            {
                while (r.Read())
                {
                    usertype.Items.Add(new ListItem(r["usertype_name"].ToString(), r["usertype_id"].ToString()));
                }
            }

            userstatus.Items.Add(new ListItem("所有状态", "-1"));
            using (SqlDataReader r = SQLHelper.ExecuteReader(SQLHelper.ConnectionStringLocalTransaction, CommandType.Text, "select * from userstatus"))
            {
                while (r.Read())
                {
                    userstatus.Items.Add(new ListItem(r["userstatus"].ToString(), r["id"].ToString()));
                }
            }


            SqlDataSource1.SelectParameters["pagesize"].DefaultValue = pagesize.ToString();
            SqlDataSource1.SelectParameters["pageindex"].DefaultValue = pageindex.ToString();
            
            
        }
        
    }
    public void SqlDataSource1_Selected(object sender, SqlDataSourceStatusEventArgs e)
    {
        pagecount = Convert.ToInt32(e.Command.Parameters["@mycount"].Value);
        ye.Text = "总共 " + pagecount + " 用户";


        //计算多少页
        if (pagecount <= pagesize)
            totalpages = 1;
        else
        {
            if (pagecount % pagesize != 0)
                totalpages = pagecount / pagesize + 1;
            else
                totalpages = pagecount / pagesize;
        }
        yeci.Text = "页次:&nbsp;" + pageindex + "/" + totalpages;
        if (!IsPostBack)
        {
            shang.Enabled = false;
            shouye.Enabled = false;
            if (totalpages == 1)
            {
                xia.Enabled = false;
                weiye.Enabled = false;
            }
        }

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

        SqlDataSource1.SelectParameters["username"].DefaultValue = username.Text.Trim()!=""?username.Text.Trim():"-1";
        SqlDataSource1.SelectParameters["idcard"].DefaultValue = idcard.Text.Trim() != "" ? idcard.Text.Trim() : "-1";
        SqlDataSource1.SelectParameters["serialnumber"].DefaultValue = sn.Text.Trim() != "" ? sn.Text.Trim() : "-1";
        SqlDataSource1.SelectParameters["usertype"].DefaultValue = usertype.SelectedValue;
        SqlDataSource1.SelectParameters["userstatus"].DefaultValue = userstatus.SelectedValue;
        SqlDataSource1.SelectParameters["addtime1"].DefaultValue = date1.Text.Trim()!=""?date1.Text .Trim ():"-1";
        SqlDataSource1.SelectParameters["addtime2"].DefaultValue = date2.Text.Trim() != "" ? date2.Text.Trim() : "-1";
        SqlDataSource1.SelectParameters["pageindex"].DefaultValue = "1"; pageindex = 1;
        SqlDataSource1.DataBind();
        
    }
    void binddata()
    {
        SqlDataSource1.SelectParameters["username"].DefaultValue = username.Text.Trim() != "" ? username.Text.Trim() : "-1";
        SqlDataSource1.SelectParameters["idcard"].DefaultValue = idcard.Text.Trim() != "" ? idcard.Text.Trim() : "-1";
        SqlDataSource1.SelectParameters["serialnumber"].DefaultValue = sn.Text.Trim() != "" ? sn.Text.Trim() : "-1";
        SqlDataSource1.SelectParameters["usertype"].DefaultValue = usertype.SelectedValue;
        SqlDataSource1.SelectParameters["userstatus"].DefaultValue = userstatus.SelectedValue;
        SqlDataSource1.SelectParameters["addtime1"].DefaultValue = date1.Text.Trim() != "" ? date1.Text.Trim() : "-1";
        SqlDataSource1.SelectParameters["addtime2"].DefaultValue = date2.Text.Trim() != "" ? date2.Text.Trim() : "-1";
        SqlDataSource1.SelectParameters["pageindex"].DefaultValue = pageindex.ToString();
        SqlDataSource1.DataBind();
    }
    protected void shouye_Click(object sender, EventArgs e)
    {
        pageindex = 1;
        shang.Enabled = false;
        shouye.Enabled = false;
        xia.Enabled = true;
        weiye.Enabled = true;
        yeci.Text = "页次:&nbsp;" + pageindex + "/" + totalpages;
        binddata();
    }

    protected void shang_Click(object sender, EventArgs e)
    {
        xia.Enabled = true;
        weiye.Enabled = true;
        pageindex -= 1;



        binddata();

        yeci.Text = "页次:&nbsp;" + pageindex + "/" + totalpages;
        if (pageindex == 1)
        {
            shang.Enabled = false;
            shouye.Enabled = false;
        }
        else
        {
            shang.Enabled = true;
            shouye.Enabled = true;
        }
    }
    protected void xia_Click(object sender, EventArgs e)
    {
        shang.Enabled = true;
        shouye.Enabled = true;
        pageindex += 1;
        yeci.Text = "页次:&nbsp;" + pageindex + "/" + totalpages;


        binddata();


        if (totalpages == pageindex)
        {
            xia.Enabled = false;
            weiye.Enabled = false;
        }
        else
        {
            xia.Enabled = true;
            weiye.Enabled = true;
        }
    }
    protected void weiye_Click(object sender, EventArgs e)
    {
        pageindex = totalpages;
        xia.Enabled = false;
        weiye.Enabled = false;
        shang.Enabled = true;
        shouye.Enabled = true;
        binddata();
        yeci.Text = "页次:&nbsp;" + pageindex + "/" + totalpages;
    }

    protected void go_Click(object sender, EventArgs e)
    {
        if (jiye.Text.Trim() != pageindex.ToString() && Convert.ToInt32(jiye.Text.Trim()) <= totalpages)
        {
            shang.Enabled = true;
            shouye.Enabled = true;
            xia.Enabled = true;
            weiye.Enabled = true;
            if (jiye.Text.Trim() != "")
            {
                pageindex = Convert.ToInt32(jiye.Text.Trim());
                binddata();
                yeci.Text = "页次:&nbsp;" + pageindex + "/" + totalpages;
                if (pageindex == 1)
                {
                    shang.Enabled = false;
                    shouye.Enabled = false;
                    xia.Enabled = true;
                    weiye.Enabled = true;
                }
                if (pageindex == totalpages)
                {
                    xia.Enabled = false;
                    weiye.Enabled = false;
                    shang.Enabled = true;
                    shouye.Enabled = true;
                }
            }
        }
    }
}