badwords.aspx.cs

基于Asp.net、MS sql sever 2000、C# 汽车交易系统源码

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 System.Data.SqlClient;
using WebDataAccess;


namespace Market.Admin
{
	/// <summary>
	/// yangyun
	/// 2004-1-7
	/// </summary>
	public class BadWords : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.TextBox BadWord;
		protected System.Web.UI.WebControls.Button SavBut;
		protected System.Web.UI.WebControls.Button ModBut;
		protected System.Web.UI.WebControls.Label timelb;

		public DataTable GetMarketDt=new DataTable();
		protected System.Web.UI.WebControls.Label Label1;
		protected System.Web.UI.WebControls.Panel Panel1;
		protected System.Web.UI.WebControls.Label Label2;
		protected System.Web.UI.WebControls.Label Label3;

		public int CheckFlag;

		private void Page_Load(object sender, System.EventArgs e)
		{
			
			if(!IsPostBack)
			{
			
			SavBut.Enabled=false;

			CheckInfo CheckBase=new CheckInfo();

			CheckFlag=CheckBase.LoginFlag();

			

			/*if(CheckFlag==0)

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

					Server.Transfer("index.aspx");

				}*/

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

				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();


					GetMarketDt=MarketBase.DisPLayList_Dt("select * from keywords",conn);

				
					BadWord.Text=GetMarketDt.Rows[0]["keywords"].ToString();

					timelb.Text=GetMarketDt.Rows[0]["mdtime"].ToString();


					//MarketPager.RecordCount=GetMarketDt.Rows.Count;


					//MarketPagerTwo.RecordCount=GetMarketDt.Rows.Count;

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

					//}

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


					//MarketDg.DataBind();	

					//this.bin_Msg();

					//bin_Msg_2();

				}

			}
		
		}

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

		}
		#endregion

		private void ModBut_Click(object sender, System.EventArgs e)
		{
		   SavBut.Enabled=true;

		}

		private void SavBut_Click(object sender, System.EventArgs e)
		{
			DataAccess MarketBase=new DataAccess();

			int State;

			string Time=System.DateTime.Now.ToString("yyyy-MM-dd-HH:mm");

			SqlConnection conn=new SqlConnection(MarketBase.SqlBase);

			try
			{

				conn.Open();

				BadWord.Text=BadWord.Text.TrimEnd();

				State=MarketBase.AddInfo("update keywords set keywords='"+BadWord.Text.Trim()+" ',mdtime='"+Time+"'",conn);

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

					Server.Transfer("index.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("index.aspx");

				}

			}

			catch(SqlException err)
			{
		           
				Response.Write("<script language='javascript'>alert('"+err.Message +"')</script>");
	          
			}
		}
	}
}