listinfotype.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>
	/// ListInfoType 的摘要说明。
	/// </summary>
	public partial class ListInfoType : System.Web.UI.Page
	{
	
		string GetDSquery;
		protected void Page_Load(object sender, System.EventArgs e)
		{
			
			string filter=Request.Params["keyword"];
			string filterQuery="";

			if((filter!=null)&&(filter!=""))
			{
				filterQuery =" where  name like '%"+filter+"%'";
			}
		
			GetDSquery="select id ,name from Infotype "+filterQuery+" order by id";
			
			if (!(this.IsPostBack))
			{
					
				ViewState["Sort"]="";
				ViewState["Page"]="0";
				GridBind();
					
			}	
			
			
		}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; 	
             //if(!object.Equals(ViewState["Page"],null))
             //    MyDataGrid.CurrentPageIndex  =int.Parse(ViewState["Page"].ToString()) ;
             //try
             //{
             //    MyDataGrid.DataBind();
             //}
             //catch
             //{
             //    MyDataGrid.CurrentPageIndex =MyDataGrid.PageCount -1;
             //    MyDataGrid.DataBind ();
             //}

             try
             {
                 this.GridView1.DataSource = MyDv;
                 this.GridView1.DataBind();
             }
             catch
             {
                 GridView1.PageIndex = GridView1.PageCount - 1;
                 GridView1.DataBind();
             }


		 }

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

		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_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 id=e.Item.Cells[0].Text.Trim();
			string url="EditInfoType.aspx?id="+id;
			Response.Redirect(url);
		}

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

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

		}

		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('确实要删除当前行记录吗?')"); 
			}
		}
		#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
        protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
        {

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

    
        protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {
            string id=GridView1.DataKeys[e.RowIndex].Values[0].ToString();
			
			DB myDB=new DB();
			if(myDB.DelInfoTypeInfo(id))
			{
				GridBind();

			}
			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();
        }
        protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {

            try
            {
                string id = ((TextBox)GridView1.Rows[e.RowIndex].Cells[0].Controls[0]).Text;
                string strName = ((TextBox)GridView1.Rows[e.RowIndex].Cells[1].Controls[0]).Text;
                DB myDB = new DB();

                if (myDB.UpdateInfoTypeInfo(strName, id))
                {
                    Response.Redirect("listinfotype.aspx");
                }
                else
                {
                    String scriptString = "<script language=JavaScript> ";
                    scriptString += "alert('添加失败！')</script>";
                    scriptString += "alert('用户名已存在，请选择其他用户名！')</script>";
                    ClientScript.RegisterStartupScript(this.GetType(), "Script", scriptString);

                }
            }
            catch (Exception ee)
            {
                Console.WriteLine(ee.ToString());
            }
        }
       
        protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
        {
            GridView1.EditIndex = -1;

            GridBind();

        }
}
}