groupadd.ascx.cs

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

namespace Seaskyer.WebApp.skyNews.Pages.AdminMSC
{
	using System;
	using System.Data;
	using System.Drawing;
	using System.Web;
	using System.Web.UI.WebControls;
	using System.Web.UI.HtmlControls;

	/// <summary>
	///		GroupAdd : 添加组。
	/// </summary>
	public class GroupAdd : basePage
	{
		protected TextBox GroupID, GroupName, Description, GroupPic;
		protected RadioButtonList SystemGroup;
		protected Label label;
		protected System.Web.UI.WebControls.RequiredFieldValidator Requiredfieldvalidator1;
		protected System.Web.UI.WebControls.RegularExpressionValidator Regularexpressionvalidator3;
		protected System.Web.UI.WebControls.RequiredFieldValidator Requiredfieldvalidator2;
		protected System.Web.UI.WebControls.RegularExpressionValidator Regularexpressionvalidator2;
		protected System.Web.UI.WebControls.DropDownList GroupCss;
		protected System.Web.UI.WebControls.RequiredFieldValidator Requiredfieldvalidator3;
		protected System.Web.UI.WebControls.RegularExpressionValidator Regularexpressionvalidator1;
		protected System.Web.UI.WebControls.Button Submit;

		protected string submitStr = "";

		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			label.Visible = false;

			if( !Page.IsPostBack )
			{
				DataTable dt = new DataTable();

				#region 加载
				// 标题样式
				dp.CommandText = cmd["TitleCss", "SELECT"];
				dt = dp.DataTableSQL();
				for( int i = 0; i < dt.Rows.Count; i++ )
				{
					GroupCss.Items.Add( new ListItem(dt.Rows[i]["CssName"].ToString(), dt.Rows[i]["CssContent"].ToString()) );
				}
				dt.Clear();
				#endregion

				if( !user.CheckValiable(Request.QueryString["groupid"]) )
				{
					#region 添加页面加载
					submitStr = lang["buttonValue","button2"];

					#endregion
				}
				else
				{
					#region 修改页面加载
					submitStr = lang["buttonValue","button3"];

					string groupid	= Request.QueryString["groupid"];

					dp.CommandText = "SELECT * FROM [UserGroup] WHERE GroupID = " + groupid;
					dt	= dp.DataTableSQL();

					if( dt.Rows[0]["SystemGroup"].ToString() == "1" ) GroupID.ReadOnly = true;

					GroupID.Text	= dt.Rows[0]["GroupID"].ToString();
					GroupName.Text	= dt.Rows[0]["GroupName"].ToString();

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

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

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

		}
		#endregion

		protected void Submit_OnClick(object sender, EventArgs e)
		{
			if( !user.CheckValiable(Request.QueryString["groupid"]) )
			{
				if( !power.GPB("Add") && !user.IsAdmin )
				{
					base.strError.Add("您无权执行 “" + lang.AppName + "” 操作，详情请与管理员联系！");
					return;
				}

				#region 开始添加组
				submitStr = lang["buttonValue","button2"];

				// 检测该ID是否已经存在
				dp.CommandText = "SELECT COUNT(GroupID) FROM [UserGroup] WHERE GroupID = " + GroupID.Text;

				if( dp.ScalarSQL() == 0  )
				{
					// 添加组
					dp.CommandText = "INSERT INTO [UserGroup] (GroupID, GroupName, GroupCss, SystemGroup, Description, GroupPic) VALUES (@GroupID, @GroupName, @GroupCss, @SystemGroup, @Description, @GroupPic)";
					dp.Parameter.Add("GroupID",		GroupID.Text);
					dp.Parameter.Add("GroupName",	GroupName.Text);
					dp.Parameter.Add("GroupCss",	GroupCss.SelectedValue);
					dp.Parameter.Add("SystemGroup",	SystemGroup.SelectedValue);
					dp.Parameter.Add("Description",	Description.Text);
					dp.Parameter.Add("GroupPic",	GroupPic.Text);


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

					dp.Parameter.Clear();
				}
				else
				{
					label.Text		= "组ID “" + GroupID.Text + "” 已经存在！";	label.ForeColor = Color.Red;
				}
				label.Visible	= true;

				#endregion
			}
			else
			{
				if( !power.GPB("Change") && !user.IsAdmin )
				{
					base.strError.Add("您无权执行 “" + lang.AppName + "” 操作，详情请与管理员联系！");
					return;
				}

				#region 开始修改组
				submitStr = lang["buttonValue","button3"];

				string groupid = Request.QueryString["groupid"];

				// 检测要修改的组ID是否存在
				dp.CommandText = "SELECT COUNT(GroupID) FROM [UserGroup] WHERE GroupID = " + GroupID.Text + " AND GroupID <> " + groupid;

				if( dp.ScalarSQL() > 0 )
				{
					label.Text		= "组ID “" + GroupID.Text + "” 已经存在，你不能修改成这个ID！";	label.ForeColor = Color.Red;
				}
				else
				{
					dp.CommandText = "UPDATE [UserGroup] SET GroupID = @GroupID, GroupName = @GroupName, GroupCss = @GroupCss, SystemGroup = @SystemGroup, Description = @Description, GroupPic = @GroupPic WHERE GroupID = " + groupid;
					dp.Parameter.Add("GroupID",		GroupID.Text);
					dp.Parameter.Add("GroupName",	GroupName.Text);
					dp.Parameter.Add("GroupCss",	GroupCss.SelectedValue);
					dp.Parameter.Add("SystemGroup",	SystemGroup.SelectedValue);
					dp.Parameter.Add("Description",	Description.Text);
					dp.Parameter.Add("GroupPic",	GroupPic.Text);

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

					dp.Parameter.Clear();
				}

				label.Visible	= true;

				#endregion
			}		
		}
	}
}