listuser.aspx.cs

内容管理 内容管理 内容管理 内容管理 内容管理

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using eInfo.data;

namespace eInfo.sys
{
	/// <summary>
	/// ListUser 的摘要说明。
	/// </summary>
	public partial class ListUser : System.Web.UI.Page
	{
		string GetDSquery;
	
		protected void Page_Load(object sender, System.EventArgs e)
		{
			try
			{
				string filter=Request.Params["keyword"];
				string type=Request.Params["where"];
				string filterQuery="";

				if((filter!=null)&&(filter!=""))
				{
                 
					if(type=="userid")
					{
						filterQuery ="where userid like '%"+filter+"%'";
					}
					if(type=="name")
					{
						filterQuery ="where name like '%"+filter+"%'";
					}
					
					
				}
				GetDSquery="select userid,name,password,case admin when 1 then '普通用户' when 0 then '管理员'end as admin"+
					       " from tuser  "+filterQuery+" order by userid";

				if (!(this.IsPostBack))
				{
					try
					{
						ViewState["Sort"]="";
						ViewState["Page"]="0";
						GridBind();
					}
					catch (Exception ex)
					{
					    string error=ex.Message;
						Response.Redirect("../ErrorPage.aspx");
					
					}
				}	
			}
			catch 
			{
			
				Response.Redirect("../ErrorPage.aspx");
			
			}
				
		
		}
		
		private void GridBind()
		{
			DataView MyDv;
			DB myDB=new DB();
			MyDv=myDB.SearchDV(GetDSquery);
			
			if(!object.Equals(ViewState["Sort"],null))
				MyDv.Sort =ViewState["Sort"].ToString() ;
			
			//MyDataGrid.DataSource=MyDv; 	
			
            this.GridView1.DataSource = MyDv;
            try
            {
                GridView1.DataBind();
            }
            catch
            {
                GridView1.PageIndex = GridView1.PageCount - 1;
                GridView1.DataBind();
            }
		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.imagebutton1.Click += new System.Web.UI.ImageClickEventHandler(this.imagebutton1_Click);
            //this.MyDataGrid.ItemCreated += new System.Web.UI.WebControls.DataGridItemEventHandler(this.MyDataGrid_ItemCreated);
            //this.MyDataGrid.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.MyDataGrid_PageIndexChanged);
            //this.MyDataGrid.EditCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.MyDataGrid_EditCommand);
            //this.MyDataGrid.SortCommand += new System.Web.UI.WebControls.DataGridSortCommandEventHandler(this.MyDataGrid_SortCommand);
            //this.MyDataGrid.DeleteCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.MyDataGrid_DeleteCommand);

		}
		#endregion


		private void imagebutton1_Click(object sender, System.Web.UI.ImageClickEventArgs e)
		{
			Response.Redirect("AddUser.aspx");
		}

		private void MyDataGrid_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
		{
			ViewState["Page"]=e.NewPageIndex.ToString();
			GridBind();
		}

		private void MyDataGrid_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			string userid=e.Item.Cells[0].Text.Trim();
			string url="EditUser.aspx?userid="+userid;
			Response.Redirect(url);
		}

		private void MyDataGrid_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			string userid=System.Convert.ToString(e.Item.Cells[0].Text.Trim());
			
			DB myDB=new DB();
			if(myDB.DelUserInfo(userid))
			{
				GridBind();

			}
			else
			{
				
				String scriptString = "<script language=JavaScript> ";
				scriptString += "alert('删除失败！')</script>";
				ClientScript.RegisterStartupScript(GetType(),"Script", scriptString);
			
			}
		}

		private void MyDataGrid_SortCommand(object source, System.Web.UI.WebControls.DataGridSortCommandEventArgs e)
		{
			if (ViewState["Sort"].ToString()==e.SortExpression)
				ViewState["Sort"]=e.SortExpression + " desc";
			else
				ViewState["Sort"]=e.SortExpression ;
			GridBind();
		}

		private void MyDataGrid_ItemCreated(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
		{
			System.Web.UI.WebControls.Image    TempImg;
			TempImg=(System.Web.UI.WebControls.Image)e.Item.FindControl("ib_delete") ;
			
			if(object.Equals(TempImg,null)==false)
			{				
				TempImg.Attributes.Add("onClick","return confirm('确实要删除当前行记录吗?')"); 
			}
		}
        protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {
            string userid = GridView1.DataKeys[e.RowIndex].Values[0].ToString();

            DB myDB = new DB();
            if (myDB.DelUserInfo(userid))
            {
                GridBind();

            }
            else
            {

                String scriptString = "<script language=JavaScript> ";
                scriptString += "alert('删除失败！')</script>";
                ClientScript.RegisterStartupScript(GetType(), "Script", scriptString);

            }
        }
        protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
        {
            GridView1.EditIndex = -1;

            GridBind();
        }
        protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
        {
          GridView1.EditIndex=e.NewEditIndex;

                       GridBind();

            //string strUser = ((TextBox)GridView1.Rows[e.NewEditIndex].Cells[0].Controls[0]).Text;
            //string url = "EditUser.aspx?userid=" + strUser;
            //Response.Redirect(url);

        }
        protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {
            
               // string id = ((TextBox)GridView1.Rows[e.RowIndex].Cells[0].Controls[0]).Text;
                //string strName = ((TextBox)GridView1.Rows[e.RowIndex].Cells[1].Controls[0]).Text;

            String olduserid = "";
           // String logText = "";
           //// olduserid = e.Keys[e.RowIndex].ToString();// +e.OldValues["userid"].ToString() + e.NewValues["userid"].ToString();
           // logText=e.NewValues.Count+"";
           // logText=e.OldValues.Count+"";
           // foreach (DictionaryEntry keyEntry in e.Keys)
           // {

           //     logText += keyEntry.Key + "=" + keyEntry.Value + ";";
           //     if (keyEntry.Key.Equals("userid"))
           //         olduserid = keyEntry.Value.ToString();
           // }


            
                string strUser = GridView1.Rows[e.RowIndex].Cells[0].Text;
                string strName = ((TextBox)GridView1.Rows[e.RowIndex].Cells[1].Controls[0]).Text;
                string strPassword = ((TextBox)GridView1.Rows[e.RowIndex].Cells[2].Controls[0]).Text;
                string strAdmin = ((TextBox)GridView1.Rows[e.RowIndex].Cells[3].Controls[0]).Text;
                if (strAdmin.Equals("管理员"))
                {
                    strAdmin = "0";//管理员
                }
                else
                {
                    strAdmin = "1";
                }

                DB myDB = new DB();
                //if (strUser != null)
                //{
                //    if (myDB.checkUserExist(strUser))
                //    {
                //        String scriptString = "<script language=JavaScript> ";
                //        scriptString += "alert('用户名已存在，请选择其他用户名！')</script>";
                //        ClientScript.RegisterStartupScript(this.GetType(), "Script", scriptString);

                //        return;
                //    }

                //}
                if (myDB.UpdateUserInfo(strUser, strName, strPassword, strAdmin, strName))
                {
                    Response.Redirect("ListUser.aspx");
                }
                else
                {
                    String scriptString = "<script language=JavaScript> ";
                    scriptString += "alert('修改用户失败，请于管理员联系！')</script>";
                    scriptString += "alert('用户名已存在，请选择其他用户名！')</script>";
                    ClientScript.RegisterStartupScript(this.GetType(), "Script", scriptString);



                }
             

        }
        protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
        {
            GridView1.PageIndex = e.NewPageIndex;

            GridBind();
        }
}
}