keywordadd.ascx.cs

这是我编的一小软件。请等级等待指教。呵呵。ASP的

namespace Seaskyer.WebApp.skyNews.Pages.UserMSC
{
	using System;
	using System.Collections;
	using System.Data;
	using System.Drawing;
	using System.Web;
	using System.Web.UI.WebControls;
	using System.Web.UI.HtmlControls;
	using System.Timers;
	using Seaskyer.Strings;

	/// <summary>
	///		KeywordAdd : 添加站内关键词。
	/// </summary>
	public class KeywordAdd : basePage
	{
		protected System.Web.UI.HtmlControls.HtmlInputHidden id;
		protected TextBox name, url, alt;
		protected Label label1;
		protected System.Web.UI.WebControls.Button Button1;

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

			if( Page.IsPostBack ) return;

			if( !user.CheckValiable(Request.QueryString["keyid"]) )
			{
				if( !power.GPB("Add") )
				{
					base.strError.Add(lang["sharePage", "denyViewErrorInfo"]);
					return;
				}

				#region 添加页面加载
				Button1.Text	= " 添 加 ";
				
				#endregion
			}
			else
			{
				if( !power.GPB("Change") )
				{
					base.strError.Add(lang["sharePage", "denyViewErrorInfo"]);
					return;
				}

				#region 修改页面加载
				Button1.Text	= " 修 改 ";

				dp.CommandText = cmd["aKey", "SELECT_INDEX"];
				dp.Parameter.Add("id", Request.QueryString["keyid"]);
				DataTable dt = dp.DataTableSQL();

				if(dt.Rows.Count == 0)
				{
					base.strError.Add("您所操作的记录不存在！");
					return;
				}
				else
				{
					//开始赋值
					id.Value	= dt.Rows[0]["id"].ToString();
					name.Text	= dt.Rows[0]["name"].ToString();
					url.Text	= dt.Rows[0]["url"].ToString();
					alt.Text	= dt.Rows[0]["alt"].ToString();
				}

				dt.Clear();
				dt.Dispose();
				#endregion
			}
		}


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

		/// <summary>
		/// 页面起始时的初始化操作
		/// </summary>
		private void InitPage()
		{
			label1.Visible			= false;
		}
		#endregion

		protected void Button1_OnClick(object sender, EventArgs e)
		{


			if( !user.CheckValiable(Request.QueryString["keyid"]) )
			{

				#region "检测关键字是否存在"
				dp.CommandText = "SELECT COUNT(id) FROM [aKey] WHERE name = '" + name.Text + "'";
				if(dp.ScalarSQL() == 1)
				{
					label1.Text = "关键字“" + name.Text + "”已经存在，操作失败！";label1.ForeColor = Color.Red;
					label1.Visible = true;
					return;
				}
				#endregion

				#region "开始添加关键字"
				dp.CommandText = cmd["aKey", "INSERT"];
				dp.Parameter.Add("name",	name.Text);
				dp.Parameter.Add("url",		url.Text);
				dp.Parameter.Add("alt",		alt.Text);
			
				if(dp.NonQuerySQL() == 1)
				{
					label1.Text = "关键字添加成功！";label1.ForeColor = Color.BlueViolet;
				}
				else
				{
					label1.Text = "添加失败 ...";label1.ForeColor = Color.Red;
				}
				label1.Visible = true;
				#endregion
			}
			else
			{

				#region "检测关键字是否存在"
				dp.CommandText = "SELECT COUNT(id) FROM [aKey] WHERE name = '" + name.Text + "' AND id <> " + id.Value;
				if(dp.ScalarSQL() == 1)
				{
					label1.Text = "关键字“" + name.Text + "”已经存在，操作失败！";label1.ForeColor = Color.Red;
					label1.Visible = true;
					return;
				}
				#endregion

				#region "开始修改关键字"
				dp.CommandText = cmd["aKey", "UPDATE"];
				dp.Parameter.Add("name",	name.Text);
				dp.Parameter.Add("url",		url.Text);
				dp.Parameter.Add("alt",		alt.Text);
				dp.Parameter.Add("id",		id.Value);

				if(dp.NonQuerySQL() == 1)
				{
					label1.Text = "关键字修改成功！";label1.ForeColor = Color.BlueViolet;
				}
				else
				{
					label1.Text = "修改失败 ...";label1.ForeColor = Color.Red;
				}
				label1.Visible = true;
				#endregion
			}
		}
	}
}