templateadd.ascx.cs

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

namespace Seaskyer.WebApp.skyNews.Pages.AdminMSC
{
	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 Seaskyer.AdoProvider;
	using Seaskyer.Strings;
	using Seaskyer.WebApp.skyNews.Custom;

	/// <summary>
	///		TemplateAdd : 添加模板。
	/// </summary>
	public class TemplateAdd : basePage
	{
		protected System.Web.UI.HtmlControls.HtmlInputHidden id;
		protected TextBox tName, tFile, tPic;
		protected Label label1;
		protected DropDownList tSort;
		protected System.Web.UI.WebControls.ValidationSummary ValidationSummary1;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
		protected System.Web.UI.WebControls.RegularExpressionValidator RegularExpressionValidator1;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator2;
		protected System.Web.UI.WebControls.Button Submit;
		protected System.Web.UI.HtmlControls.HtmlInputHidden templateID;
		protected System.Web.UI.WebControls.TextBox tRemark;
		protected System.Web.UI.WebControls.TextBox newSort;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator3;
		protected System.Web.UI.WebControls.RadioButtonList tEnable;

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

			TemplateInfo ti = new TemplateInfo(mp);

			if( !Page.IsPostBack )
			{
				DataTable dt = ti.TemplateTypeList();
				for( int i = 0; i < dt.Rows.Count; i++ )
				{
					tSort.Items.Add( new ListItem(dt.Rows[i]["type"].ToString(), dt.Rows[i]["type"].ToString()) );
				}
				dt.Clear();


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

					#region 添加页面加载
					Submit.Text = " 添 加 ";
					tFile.Text = UserControlBase1.Modules;
					newSort.Visible = true;


					#endregion
				}
				else
				{

					#region 修改页面加载
					Submit.Text = " 修 改 ";
					templateID.Value = Request.QueryString["templateID"];
					dt = ti.TemplateDataRow(templateID.Value);

					if( dt.Rows.Count == 1 )
					{
						tName.Text		= dt.Rows[0]["Name"].ToString();
						tFile.Text		= dt.Rows[0]["Path"].ToString();
						tPic.Text		= dt.Rows[0]["Pic"].ToString();
						tRemark.Text	= dt.Rows[0]["Remark"].ToString();

						for( int i = 0; i < tSort.Items.Count; i++ )
						{
							if( tSort.Items[i].Value == dt.Rows[0]["type"].ToString() )
								tSort.Items[i].Selected = true;
							else
								tSort.Items[i].Selected = false;
						}

						for( int i = 0; i < tEnable.Items.Count; i++ )
						{
							if( tEnable.Items[i].Value == dt.Rows[0]["Enable"].ToString() )
								tEnable.Items[i].Selected = true;
							else
								tEnable.Items[i].Selected = false;
						}
					}

					#endregion
				}
			}

		}


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

		}

		private void CustomSelected()
		{
			if( tSort.SelectedValue == "" )
				newSort.Visible = true;
			else
				newSort.Visible = false;
		}
		#endregion

		protected void Submit_OnClick(object sender, EventArgs e)
		{
			#region 合法性数据检测
			string type = tSort.SelectedValue;
			if( !user.CheckValiable(type) ) type = newSort.Text;

			if( !user.CheckValiable(type) ) base.strError.Add("请指定模板的类型");

			if( base.strError.Count > 0 ) return;



			if( tEnable.SelectedValue == "1" )
			{
				dp.CommandText = "UPDATE [Template] SET Enable = 0 WHERE type = @type";
				dp.Parameter.Add("type", type);
				dp.NonQuerySQL();
			}

			#endregion

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

				#region "添加模板"
				dp.CommandText = cmd["Template", "INSERT"];
				dp.Parameter.Add("type",	type);
				dp.Parameter.Add("Name",	tName.Text);
				dp.Parameter.Add("Path",	tFile.Text);
				dp.Parameter.Add("Pic",		tPic.Text);
				dp.Parameter.Add("Enable",	tEnable.SelectedValue);
				dp.Parameter.Add("Remark",	tRemark.Text);

				if( dp.NonQuerySQL() == 1 )
				{
					label1.Text = "模板“" + tName.Text + "”添加成功！";label1.ForeColor = Color.BlueViolet;
				}
				else
				{
					label1.Text = "模板“" + tName.Text + "”添加失败！";label1.ForeColor = Color.Red;
				}


				#endregion
			}
			else
			{

				#region "修改模板"
				dp.CommandText = cmd["Template", "UPDATE"];
				dp.Parameter.Add("type",	type);
				dp.Parameter.Add("Name",	tName.Text);
				dp.Parameter.Add("Path",	tFile.Text);
				dp.Parameter.Add("Pic",		tPic.Text);
				dp.Parameter.Add("Enable",	tEnable.SelectedValue);
				dp.Parameter.Add("Remark",	tRemark.Text);
				dp.Parameter.Add("ID",		templateID.Value);

				if( dp.NonQuerySQL() == 1 )
				{
					label1.Text = "模板“" + tName.Text + "”修改成功！";label1.ForeColor = Color.BlueViolet;
				}
				else
				{
					label1.Text = "模板“" + tName.Text + "”修改失败！";label1.ForeColor = Color.Red;
				}


				#endregion
			}

			//Globals.TemplateCollection = null;
			Cache.Remove("templateCache");
			label1.Visible = true;
		}

		private void tSort_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			this.CustomSelected();
		}
	}
}