memberadmin.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.FSO;
	using Seaskyer.Strings;
	using Seaskyer.WebApp.Utility;

	/// <summary>
	///		MemberAdmin : 管理会员。
	/// </summary>
	public class MemberAdmin : basePage
	{
		protected Panel AdminPanel, ModiPanel;
		protected Label label1, pageLabel;
		protected DropDownList ModiGroup, usergroup, userstatus;
		protected DataGrid DataGrid1;
		protected Button Modi, DelBtn, MultiModiBtn;
		protected TextBox uid, username, psw1, psw2;
		protected HtmlInputButton Back;

		private void Page_Load(object sender, System.EventArgs e)
		{
			if( Page.IsPostBack ) return;
			this.initPage();

			string Action = Request.QueryString["Action"];
			
			// 添加用户组到列表框
			DataTable dt = new DataTable();
			dp.CommandText = cmd["UserGroup", "SELECT"];
			dt = dp.DataTableSQL();
			for( int i = 0; i < dt.Rows.Count; i++ )
			{
				ListItem list	= new ListItem(dt.Rows[i]["GroupName"].ToString(), dt.Rows[i]["GroupID"].ToString());
				ModiGroup.Items.Add(list);
				usergroup.Items.Add(list);
			}
			dt.Clear();
			//绑定数据
			if ( Object.Equals(Action, null) || Object.Equals(Action, "") )
			{
				this.BindMember();
			}
			else
			{
				this.BindModi();
			}
			
		}

		#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

		void initPage()
		{
			AdminPanel.Visible	= false;
			ModiPanel.Visible	= false;
			Modi.Visible	= false;
			DelBtn.Visible  = false;
			Back.Visible	= false;
		}


		#region 响应修改信息事件
		protected void Modi_OnClick(object sender, EventArgs e)
		{
			if( !user.CheckValiable(Request.Form["uid"]))
			{
				int modinum = 0;
				if( Object.Equals(Request.Form["psw1"], null) || Object.Equals(Request.Form["psw1"], ""))
				{
					dp.CommandText = cmd["UserInfo", "UPDATE_INDEX"];
					// 开始为参数赋值
					dp.Parameter.Add( "uid",		uid.Text);
					dp.Parameter.Add("userid",		username.Text);
					dp.Parameter.Add("groupid",		int.Parse(usergroup.SelectedValue));
					dp.Parameter.Add("userstatus",	int.Parse(userstatus.SelectedValue));

					modinum=dp.NonQuerySQL();
					
				}
				else
				{/*
					if ( Object.Equals(Request.Form["psw1"], Request.Form["psw2"]))
					{
						dp.CommandText = cmd["UserInfo", "UPDATE"];
						// 开始为参数赋值
						dp.Parameter.Add( "uid",		uid.Text);
						dp.Parameter.Add("userid",		username.Text);
						dp.Parameter.Add("userpsw",		psw1.Text);
						dp.Parameter.Add("groupid",		int.Parse(usergroup.SelectedValue));
						dp.Parameter.Add("userstatus",	int.Parse(userstatus.SelectedValue));

						modinum=dp.NonQuerySQL();
					}
					else
					{
						modinum = -1;
					}
					*/
				}
				
				if( modinum > 0)
				{
					label1.Text = "用户信息修改成功！";
					label1.ForeColor = Color.BlueViolet;
				}
				else if( modinum == -1)
				{
					label1.Text = "密码不正确，请重新输入。";
					label1.ForeColor = Color.Red;
				}
				else
				{
					label1.Text = "用户信息修改失败 ...";
					label1.ForeColor = Color.Red;
				}
				label1.Visible = true;
			}
		}
		#endregion

		#region 响应删除事件
		protected void DelBtn_OnClick(object sender, EventArgs e)
		{
			if( Object.Equals(Request.Form["chk"], null) || Object.Equals(Request.Form["chk"], "") )
			{
				label1.Text = "请先选中要删除的记录(可多选)"; label1.ForeColor = Color.Red;
				DataGrid1.Visible		= true;
			}
			else
			{
				dp.CommandText = String.Format(cmd["UserInfo", "DELETE"], Request.Form["chk"].ToString());
				int delNum = dp.NonQuerySQL();
				if( delNum > 0)
				{
					label1.Text = delNum + "个会员删除成功！"; label1.ForeColor = Color.BlueViolet;
					this.BindMember();
				}
				else
				{
					label1.Text = "删除失败 ..."; label1.ForeColor = Color.Red;
					DataGrid1.Visible		= true;
				}
			}
			label1.Visible = true;
		}
		#endregion

		#region 响应批量修改事件
		protected void MultiModiBtn_OnClick(object sender, EventArgs e)
		{
			if( Object.Equals(Request.Form["chk"], null) || Object.Equals(Request.Form["chk"], "") )
			{
				label1.Text = "请先选中要修改的记录(可多选)"; label1.ForeColor = Color.Red;
				DataGrid1.Visible		= true;
			}
			else
			{
				dp.CommandText = String.Format(cmd["UserInfo", "UPDATE_Group"], Request.Form["chk"].ToString());
				
				dp.Parameter.Add("groupid",		int.Parse(ModiGroup.SelectedValue));

				int delNum = dp.NonQuerySQL();
				if( delNum > 0)
				{
					label1.Text = delNum + " 个会员信息修改成功！"; label1.ForeColor = Color.BlueViolet;
					ModiGroup.SelectedIndex  =  0  ;
					this.BindMember();
				}
				else
				{
					label1.Text = "修改失败 ..."; label1.ForeColor = Color.Red;
					ModiGroup.SelectedIndex  =  0  ;
					DataGrid1.Visible		= true;
				}
			}
			label1.Visible = true;
		}
		#endregion

		#region 初始化DataGrid中子控件的属性
		protected void DataGrid1_ItemCreated(object sender, DataGridItemEventArgs e)
		{
			if(e.Item.ItemIndex >= 0)
			{
				e.Item.Attributes.Add("onmouseover","this.className='tdbg-dark';");
				e.Item.Attributes.Add("onmouseout","this.className='tdbg';");
			}

			switch(e.Item.ItemType)
			{
				case ListItemType.Item				:
				case ListItemType.AlternatingItem	:
				case ListItemType.EditItem			:
					break;
			}

		}
		#endregion

		#region 数据绑定
		void BindMember()
		{
			
			dp.CommandText = cmd["UserInfo", "COUNT"];
			bind.totalRecord = dp.ScalarSQL();
			
			if( bind.totalRecord == 0 )
			{
				label1.Text = "还没有添加任何会员"; label1.ForeColor = Color.Red;
				label1.Visible = true;
			}
			else
			{
				dp.CommandText = cmd["UserInfo", "SELECT"];
				DataTable dt = dp.DataTableSQL();
				
				//添加用户组信息和状态信息
				dt.Columns.Add("GroupName", System.Type.GetType("System.String"));
				dt.Columns.Add("Users", System.Type.GetType("System.String"));

				dp.CommandText = cmd["UserGroup","SELECT"];
				DataTable gdt = dp.DataTableSQL();
				
				for ( int i=0; i<dt.Rows.Count; i++)
				{
					for (int j=0; j<gdt.Rows.Count; j++)
					{
						if (Object.Equals(gdt.Rows[j]["GroupID"].ToString(), dt.Rows[i]["GroupID"].ToString()))
						{
							dt.Rows[i]["GroupName"] = gdt.Rows[j]["GroupName"];
						}
					}
					switch ( dt.Rows[i]["UserStatus"].ToString() )
					{
						case "1" :
							dt.Rows[i]["Users"] = "锁定";
							break;
						case "0" :
							dt.Rows[i]["Users"] = "正常";
							break;
						case "-1" :
							dt.Rows[i]["Users"] = "未开通";
							break;
					
					}
				}
				dt.AcceptChanges();

				bind.BindInfo_SplitPageDataGrid(DataGrid1, dt, "");

				pageLabel.Text	=  base.GetSplitPageString("/skyNews/AdminMSC/ArtcleAdmin.aspx?");
				AdminPanel.Visible	= true;
				DelBtn.Visible	= true;
			}		
		}

		void BindModi()
		{
			ModiPanel.Visible		= true;
			Modi.Visible			= true;
			Back.Visible			= true;
			MultiModiBtn.Visible    = false;
			ModiGroup.Visible		= false;
			if( !Page.IsPostBack )
			{
				string userid = Request.QueryString["UID"];
				dp.CommandText = cmd["UserInfo","SELECT_INDEX"];
				dp.Parameter.Add("uid",		userid);
				DataTable dt = dp.DataTableSQL();
				
				if(dt.Rows.Count <= 0)
				{
					base.strError.Add("您所操作的记录不存在！");
					return;
				}
				else
				{
					//开始赋值
					uid.Text		= dt.Rows[0]["UID"].ToString();
					username.Text	= dt.Rows[0]["UserID"].ToString();
					//选择用户组信息
					for( int i = 0; i < usergroup.Items.Count; i++ )
					{
						if( Object.Equals(usergroup.Items[i].Value, dt.Rows[0]["GroupID"].ToString()))
						{
							usergroup.Items[i].Selected = true;
						}
						else
							usergroup.Items[i].Selected = false;
					}
					//选择用户状态信息
					for( int i = 0; i < userstatus.Items.Count; i++ )
					{
						if( Object.Equals(userstatus.Items[i].Value, dt.Rows[0]["UserStatus"].ToString()))
						{
							userstatus.Items[i].Selected = true;
						}
						else
							userstatus.Items[i].Selected = false;
					}
				}
			}
			
			

			Back.Attributes.Add("onclick", "location.href='/skyNews/Admin/MemberAdmin.aspx';");

		}
		#endregion




	}
}