userinfo.aspx.cs

本系统主要内容是围绕图书销售管理系统而展开讨论的

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;
public partial class ZDWH_Userinfo : System.Web.UI.Page
{
    SqlCommand cmd=null;
    SqlConnection conn=new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["connection"]);
    protected void Page_Load(object sender, EventArgs e)
    {
       
        if(!IsPostBack)
        {
           
            if (Session["DispUser"] == null)
            {
                Session["DispUser"] = "";
                Session["logintime"] = "";
            }
            //Page.RegisterStartupScript("", getSessionInfo(Session["DispUser"].ToString(), Session["logintime"].ToString()));
            string url = Request.RawUrl.ToString();
            if (Session["CurrUser"] == null)
                Response.Redirect("../Index.aspx?handle=" + url);   
        }
        BindGrid();
    }
    //public string getSessionInfo(string DispUser, string LoginTime)
    //{
    //    string _DisUser;
    //    _DisUser = "<script language='javascript'>window.status='登陆用户:" + DispUser;
    //    _DisUser += "  登陆时间:" + LoginTime + "'</script>";
    //    return _DisUser;
    //}
    public string getalertinfo(string str1)
    {
        string str;
        str = "<script language='javascript'>alert('" + str1 + "')</script>";
        return str.Trim();
    }
    public void BindGrid()
    {
        SqlDataAdapter dtcmd =null;
        SqlDataReader dataR =null;
        DataTable dt =new DataTable();
        string str2 = "select count(*) as nums from userinfosheet";
        cmd = new SqlCommand(str2, conn);
        conn.Open();
        dataR = cmd.ExecuteReader();
        if (dataR.Read())
        {
            if (dataR["nums"].ToString() == "0")
                Msg.Text = "";
            else
                Msg.Text = "合计：记录数 " + dataR["nums"].ToString();
        }
        conn.Close();
        string str1 = "select * from userinfosheet order by code";
        dtcmd = new SqlDataAdapter(str1, conn);
        dtcmd.Fill(dt);
        #region 用来判断当前删除是否为当前页的最后一条记录
        if ((this.DataGrid1.CurrentPageIndex == this.DataGrid1.PageCount - 1) && this.DataGrid1.Items.Count == 1)
        {
            if (this.DataGrid1.CurrentPageIndex - 1 > 1)
            {
                this.DataGrid1.CurrentPageIndex = this.DataGrid1.CurrentPageIndex - 1;
            }
            else
            {
                this.DataGrid1.CurrentPageIndex = 0;
            }
        }
        #endregion
        DataGrid1.DataSource = dt;
        DataGrid1.DataBind();
    }
    protected void Save_Click(object sender, EventArgs e)
    {
        string CodeStr = code.Text;
        string NameStr = dispname.Text;
        string DlNameStr = dlname.Text;
        string PwdStr = password.Text;
        string sql;
        SqlDataReader dataR = null;
        conn = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["connection"]);
        conn.Open();
        sql = "select * from userinfosheet where code='" +CodeStr + "'";
        cmd = new SqlCommand(sql, conn);
        dataR = cmd.ExecuteReader();
        if (dataR.Read())
            Page.RegisterStartupScript("", getalertinfo("该用户编码已经存在，无法保存！"));
        else
        {
            dataR.Close();
            sql = "insert into userinfosheet(code,userdispname,username,password,fpassword) values('" + CodeStr + "','" + NameStr + "','" + DlNameStr + "','" + PwdStr + "','******')";
            cmd = new SqlCommand(sql, conn);
            cmd.ExecuteNonQuery();
            conn.Close();
            BindGrid();
            dlname.Text = "";
            dispname.Text = "";
            password.Text = "";
            code.Text = "";
            Page.RegisterStartupScript("", getalertinfo("数据保存成功！"));
        }
    }
    protected void Grid1_PageIndexChanged(object source, DataGridPageChangedEventArgs e)
    {
        DataGrid1.CurrentPageIndex = e.NewPageIndex;
        BindGrid();
    }
    protected void Grid1_Mod(object source, DataGridCommandEventArgs e)
    {
        string CodeStr = e.Item.Cells[0].Text;
        string sql;
        if (e.CommandName.ToString()== "modipwd")
            Response.Redirect("ModiPwd.aspx?UserID=" + CodeStr);
        else
        {
            if (e.CommandName.ToString() == "delete")
            {
                if (CodeStr == Session["CurrUser"])
                    Page.RegisterStartupScript("", getalertinfo("无法删除当前登录用户！"));
                else
                {
                    conn.Open();
                    sql = "delete from userinfosheet where code='" + CodeStr + "'";
                    cmd = new SqlCommand(sql, conn);
                    cmd.ExecuteNonQuery();
                    conn.Close();
                    BindGrid();
                }
            }
        }
    }
    protected void Grid1_Cancel(object source, DataGridCommandEventArgs e)
    {
        Requiredfieldvalidator1.Enabled = true;
        Requiredfieldvalidator2.Enabled = true;
        Requiredfieldvalidator3.Enabled = true;
        Requiredfieldvalidator4.Enabled = true;
        DataGrid1.EditItemIndex = -1;
        BindGrid();
    }
    protected void Grid1_Edit(object source, DataGridCommandEventArgs e)
    {
         Requiredfieldvalidator1.Enabled=false;
         Requiredfieldvalidator2.Enabled=false;
         Requiredfieldvalidator3.Enabled=false;
         Requiredfieldvalidator4.Enabled=false;
         DataGrid1.EditItemIndex = e.Item.ItemIndex;
         BindGrid();
    }
    protected void Grid1_Update(object source, DataGridCommandEventArgs e)
    {
        string NameStr = ((TextBox)(e.Item.Cells[1].Controls[0])).Text;
        string DlNameStr = ((TextBox)(e.Item.Cells[2].Controls[0])).Text;
        string CodeStr = e.Item.Cells[0].Text;
        conn.Open();
        string sql = "update userinfosheet set userdispname='"+NameStr+"',username='"+DlNameStr+"' where code='"+CodeStr+"'";
        cmd = new SqlCommand(sql, conn);
        cmd.ExecuteNonQuery();
        conn.Close();
        Requiredfieldvalidator1.Enabled = true;
        Requiredfieldvalidator2.Enabled = true;
        Requiredfieldvalidator3.Enabled = true;
        Requiredfieldvalidator4.Enabled = true;
        DataGrid1.EditItemIndex = -1;
        BindGrid();
    }

    protected void DataGrid1_ItemDataBound(object sender, DataGridItemEventArgs e)
    {
        switch (e.Item.ItemType)
        {
            case (ListItemType.Item):
            case (ListItemType.AlternatingItem):
                {
                    LinkButton btn = (LinkButton)e.Item.Cells[6].Controls[0];
                    btn.Attributes.Add("OnClick", "return window.confirm('确定要删除该用户？')");
                    break;
                }
        }
    }
    protected void DataGrid1_DeleteCommand(object source, DataGridCommandEventArgs e)
    {
        string CodeStr = e.Item.Cells[0].Text;       
        string sql = "delete userinfosheet where code='"+CodeStr+"'";
        conn.Open();
        cmd = new SqlCommand(sql, conn);
        cmd.ExecuteNonQuery();
        conn.Close();
        Requiredfieldvalidator1.Enabled = true;
        Requiredfieldvalidator2.Enabled = true;
        Requiredfieldvalidator3.Enabled = true;
        Requiredfieldvalidator4.Enabled = true;
        DataGrid1.EditItemIndex = -1;
        BindGrid();
    }
}