adminsort.aspx.cs

来自「基于Asp.net、MS sql sever 2000、C# 汽车交易系统源码」· CS 代码 · 共 361 行

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 WebDataAccess;

using System.Data.SqlClient;


namespace Market.Admin
{
	/// <summary>
	/// adminsort 的摘要说明。
	/// </summary>
	public class adminsort : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Label Label1;
		protected System.Web.UI.WebControls.Label Label2;
		protected System.Web.UI.WebControls.TextBox TextBox1;
		protected System.Web.UI.WebControls.Panel Panel1;
		protected System.Web.UI.WebControls.Button SaveBut;
		protected System.Web.UI.WebControls.Button CanelBut;
		protected System.Web.UI.WebControls.Label Label3;

		public DataTable Dt_Sort=new DataTable();
		protected System.Web.UI.WebControls.DropDownList SortDp1;
		protected System.Web.UI.WebControls.DropDownList SortDp2;


		public int State;



		public int CheckFlag;
		protected System.Web.UI.WebControls.Label Label4;
		protected System.Web.UI.WebControls.DropDownList Dp2Mod;
		protected System.Web.UI.WebControls.Button ModSort2;
		protected System.Web.UI.WebControls.Button SavSort2;
		protected System.Web.UI.WebControls.TextBox ModSortTxt;
		protected System.Web.UI.WebControls.Button DelSort;
		protected System.Web.UI.WebControls.Button Button1;

		public DataTable Dt_Sort2=new DataTable();

	
		private void Page_Load(object sender, System.EventArgs e)
		{
			

			CheckInfo CheckBase=new CheckInfo();

			CheckFlag=CheckBase.LoginFlag();

			

			/*if(CheckFlag==0)

				{
                  
					Response.Write("<script>alert('请你先登陆')<script>");

					Server.Transfer("index.aspx");

				}*/

			/*********************************1 表示SUCCESS 0表示failure***********************************/

			if(!IsPostBack)

			{
			
				if(CheckFlag==0)

				{
					Response.Write("<script language='javascript'>alert('你不是系统管理员，要管理系统请先登陆！')</script>"); 

					Server.Transfer("index.aspx");

				}

				else if(CheckFlag==1)
				{
					DataAccess MarketBase=new DataAccess();
	
		  
					SqlConnection conn=new SqlConnection(MarketBase.SqlBase);


					conn.Open();


					Dt_Sort=MarketBase.DisPLayList_Dt("select * from GoodType",conn);


					conn.Open();

					//Dt_Sort2=MarketBase.DisPLayList_Dt("select * from GoodType2 where GoodTypeID='"+SortDp1.SelectedValue+"'",conn);


					SortDp1.DataTextField="TypeName";


					SortDp1.DataValueField="GoodTypeID";



					SortDp1.DataSource=Dt_Sort;


					SortDp1.DataBind();


					//SortDp2.DataTextField="GoodType2Name";



					//SortDp2.DataValueField="GoodType2ID";

					//SortDp2.DataSource=Dt_Sort2;


					//SortDp2.DataBind();

					/**************************************************************************************************************************************/
					//if(GetMarketDt.Rows.Count<this.CheckPage)
                   
					//{                                         
					//	MarketDg.PageSize=this.CheckPage;          

					//}
					/**************************************************************************************************************************************/
            
					//MarketDg.DataSource=GetMarketDt.DefaultView;


					//MarketDg.DataBind();	

					//this.bin_Msg();

					//bin_Msg_2();


				}
				else
				{

					Response.Write("<script language='javascript'>alert('系统出现未知的错误，请与系统管理员联系！')</script>"); 

				}
			}
			
		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.ModSort2.Click += new System.EventHandler(this.ModSort2_Click);
			this.SavSort2.Click += new System.EventHandler(this.SavSort2_Click);
			this.DelSort.Click += new System.EventHandler(this.DelSort_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void SaveBut_Click(object sender, System.EventArgs e)
		{
		
			DataAccess MarketBase=new DataAccess();
	
		  
			SqlConnection conn=new SqlConnection(MarketBase.SqlBase);


			conn.Open();

			State=MarketBase.AddInfo("insert into goodtype2(GoodTypeID,GoodType2Name) values('"+SortDp1.SelectedValue+"','"+TextBox1.Text+"')",conn);
          
			if(State==1)
			{
				Response.Write("<script language='javascript'>alert('操作成功')</script>");

				Server.Transfer("adminsort.aspx");


			}

				//typConn.Open();
				//typComm.ExecuteNonQuery();
				//typConn.Close();
				//upApplicatio();
				//Dats();				
				//Response.Write(sSql11);

				//Response.Write("<script language='javascript'>alert('操作成功')</script>");]
			else
			{
				Response.Write("<script language='javascript'>alert('操作 失败！请与数据管理员联系！')</script>");

				Server.Transfer("adminsort.aspx");

			}


		}

		private void SortDp1_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			DataAccess MarketBase=new DataAccess();
	
		  
			SqlConnection conn=new SqlConnection(MarketBase.SqlBase);


			conn.Open();



			Dt_Sort2=MarketBase.DisPLayList_Dt("select * from GoodType2 where GoodTypeID='"+SortDp1.SelectedValue+"'",conn);


			
			SortDp2.DataTextField="GoodType2Name";



			SortDp2.DataValueField="GoodType2ID";

			SortDp2.DataSource=Dt_Sort2;


			SortDp2.DataBind();


			Dp2Mod.DataTextField="GoodType2Name";



			Dp2Mod.DataValueField="GoodType2ID";

			Dp2Mod.DataSource=Dt_Sort2;


			Dp2Mod.DataBind();
		}

		private void ModSort2_Click(object sender, System.EventArgs e)
		{
			ModSortTxt.Visible=true;

			SavSort2.Visible=true;

			Button1.Visible=true;
		}

		private void SavSort2_Click(object sender, System.EventArgs e)
		{

			DataAccess MarketBase=new DataAccess();
	
		  
			SqlConnection conn=new SqlConnection(MarketBase.SqlBase);


			conn.Open();

			
			State=MarketBase.AddInfo("update goodtype2 set GoodType2Name='"+ModSortTxt.Text+"' where GoodType2ID='"+Dp2Mod.SelectedValue+"'",conn);

			if(State==1)
			{
				Response.Write("<script language='javascript'>alert('操作成功')</script>");

			}

				//typConn.Open();
				//typComm.ExecuteNonQuery();
				//typConn.Close();
				//upApplicatio();
				//Dats();				
				//Response.Write(sSql11);

				//Response.Write("<script language='javascript'>alert('操作成功')</script>");]
			else
			{
				Response.Write("<script language='javascript'>alert('操作 失败！请与数据管理员联系！')</script>");

			}
		
		}

		private void DelSort_Click(object sender, System.EventArgs e)
		{
		
			DataAccess MarketBase=new DataAccess();
	
		  
			SqlConnection conn=new SqlConnection(MarketBase.SqlBase);


			conn.Open();

			
			State=MarketBase.DelInfo("delete  from GoodType2 where GoodType2ID='"+Dp2Mod.SelectedValue+"'",conn);

			if(State==1)
			{
				Response.Write("<script language='javascript'>alert('操作成功')</script>");


			}

				//typConn.Open();
				//typComm.ExecuteNonQuery();
				//typConn.Close();
				//upApplicatio();
				//Dats();				
				//Response.Write(sSql11);

				//Response.Write("<script language='javascript'>alert('操作成功')</script>");]
			else
			{
				Response.Write("<script language='javascript'>alert('操作 失败！请与数据管理员联系！')</script>");

			}
		
		}

		private void Button1_Click(object sender, System.EventArgs e)
		{
		
			ModSortTxt.Visible=false;

			SavSort2.Visible=false;

			Button1.Visible=false;



		}
	}
}