accounts_users.aspx.cs

用vs2005写的一个生产任务管理系统。数据的统计和综合查询是主要功能

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 RWSB.DatabaseOper ;
using System.Diagnostics ;
using System.Data.SqlClient;
using ZHENGYI;



namespace RWSB.Manage
{
	/// <summary>
	/// Accounts_Users 的摘要说明。
	/// </summary>
	public partial class Accounts_Users :RWSB.PageBase 
	{
		protected System.Web.UI.WebControls.Button Button1;
		private DatabaseConnect dc; 
		
	
		protected void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
            if (Session["UserGrade"].ToString().Trim() != "管理员")
            {
                Response.Write("<script>alert('对不起，您不具有权限');</script>");
                Response.End();
                 
            }

			dc=new DatabaseConnect();
			SetDivePage();
			if(!Page.IsPostBack)
			{
				
				this.Bind();
			}
		}
		
		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			//this.ImageButton1.Click += new System.Web.UI.ImageClickEventHandler(this.ImageButton1_Click);
			this.DataGridAccounts_Users.ItemCreated += new System.Web.UI.WebControls.DataGridItemEventHandler(this.DataGridAccounts_Users_ItemCreated);
			this.DataGridAccounts_Users.DeleteCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGridAccounts_Users_Delete);
			this.DataGridAccounts_Users.ItemDataBound += new System.Web.UI.WebControls.DataGridItemEventHandler(this.DataGridAccounts_Users_ItemDataBound);
			this.ImageButtonSave.Click += new System.Web.UI.ImageClickEventHandler(this.ImageButtonSave_Click);

		}
		#endregion
		
		/// <summary>
		/// 链接到增加页面
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		private void SetDivePage()
		{
			DataGridAccounts_Users.AllowPaging =true; 
			
			
			ZHENGYI.BindDataDelegate f =new ZHENGYI.BindDataDelegate (Bind);//修改这个dataBind,让f 指向你的方法。 
			divepage.SetTarget(DataGridAccounts_Users,f,15);
		}
		
	
		private ArrayList al=new ArrayList();//保存部门节点的和其子节点的所有departmentid值
		
		
	
		private void Bind()
		{
			
			dc=new DatabaseConnect();
			
            string strUser = "select id,displayorder,username,cjmc  from  Users order by displayorder asc ";
               
			DataSet ds=new DataSet();
			try
			{
				ds=dc.getBinding(strUser,"Users");
			}
			catch(System.Data.SqlClient.SqlException ex)
			{
				throw new AppException("此语句发生错误:"+strUser,ex);
			}
			
			
			DataGridAccounts_Users.DataSource =ds.Tables ["Users"].DefaultView ;
			DataGridAccounts_Users.DataBind();
			
		}
		
		/// <summary>
		/// 删除对应信息
		/// </summary>
		/// <param name="source"></param>
		/// <param name="e"></param>
		private void DataGridAccounts_Users_Delete(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			dc=new DatabaseConnect ();
			int userID=Convert.ToInt32 (e.Item .Cells [0].Text );
			object o=dc.GetObjectBySql ("select DisplayOrder from Users where id="+userID);
			int DisplayOrder=int.Parse (o.ToString ());
			string Sql="DELETE FROM Users WHERE  id='"+userID+"'";		
			int nType=dc.dataOperater1(Sql);
			
			if(nType!=0)
			{
				this.RegisterClientScriptBlock("","<script language=javascript>alert('不能对该成员进行删除 ');</script>");
				return;
			}
			//删除一用户后，将后面的用户排序号前移一位。
            dc.ExecuteSQL ("update Users set DisplayOrder=DisplayOrder-1 where DisplayOrder>" +DisplayOrder.ToString ()) ;
			
			Bind ();
		
		}

		protected void DataGridAccounts_Users_SelectedIndexChanged(object sender, System.EventArgs e)
		{
		
		}


		private void ImageButtonSave_Click(object sender, System.Web.UI.ImageClickEventArgs e)
		{
		 Response.Redirect("Accounts_UserAdd.aspx");
		}

		private void DataGridAccounts_Users_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
		{
			if (e.Item .ItemType ==ListItemType.Item  ||e.Item .ItemType ==ListItemType.AlternatingItem )
			{
					//e.Item .Cells[6].Text ="<a href=\"#\" onclick=role("+e.Item .Cells[0].Text +")><img alt='用户角色' src=../images/szqx.gif border=0></a> ";
				ImageButton imgBtnUserMove =(ImageButton) e.Item .FindControl ("imgBtnUserMove");
				if (imgBtnUserMove !=null)
				{
					string position=e.Item .Cells[1].Text ;
					string username=e.Item .Cells[2].Text ; 
					
					imgBtnUserMove.Attributes["onclick"] ="return imgBtnUserMoveOnClick('"+position+"','"+username+"')";
				}
				e.Item .Cells [2].Text ="<a href=accounts_user.aspx?id="+e.Item .Cells[0].Text+">"+e.Item .Cells[2].Text +"</a>";   
			}
		}

		private void DataGridAccounts_Users_ItemCreated(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
		{
			if (e.Item.ItemType ==ListItemType.Item ||e.Item.ItemType ==ListItemType.AlternatingItem  )
			{
				
                ImageButton changeLoginPassword=(ImageButton) e.Item .FindControl ("clearLoginPassword");
				if(changeLoginPassword !=null)
				{
					changeLoginPassword.Attributes ["onclick"]="return confirm('是否将该用户的登录密码设为初始值？');";
					changeLoginPassword.Click +=new ImageClickEventHandler(changeLoginPassword_Click);
				}
			  
			}
			
		}
		
		private void changeLoginPassword_Click(object sender,System.Web.UI.ImageClickEventArgs  e)
		{
			dc=new DatabaseConnect ();
			ImageButton changePersonSign=(ImageButton) sender;
			DataGridItem dgitem=(DataGridItem)changePersonSign.Parent .Parent ;
	
			try
			{ 
				int userid= int.Parse (dgitem.Cells[0].Text .Trim ()); 
				string sql="update users set Password=1111 where id="+userid.ToString ();
				dc.ExecuteSQL (sql);
				
			}
			catch(Exception er)
			{
				Response.Write (er);
				Response.End ();
			}
		}

		protected void btnmove_ServerClick(object sender, System.EventArgs e)
		{
			
			int moveTo=0,source=0;
			try
			{
				moveTo=int.Parse (movingto.Value );
				source=int.Parse (position.Value );
			}
			catch
			{
				Page.RegisterStartupScript ("","<script>alert('移位序号不能为空！')<script>");
			}
		
			if (moveTo <source) //前移
			{
			　 forwardMoving(moveTo,source);
			
			}
			else
			{
				if(moveTo > source) //后移
				{
					backMoving(moveTo,source);
				}
			}
            Bind();
				
		}
		private void forwardMoving(int moveTo,int source)
		{
			
			string [] sqls=new string [2];
			string userid=dc.GetObjectBySql ("select id from users where displayorder="+source.ToString ()).ToString ();
			sqls[0]=" update users set  displayorder=displayorder+1 where displayorder >="+moveTo.ToString () +" and displayorder < "+source.ToString (); 
		    sqls[1]=" update users  set displayorder="+moveTo.ToString ()+" where id="+userid ;
			dc.ExcuteSqls (sqls);

		}
		private void backMoving (int moveTo,int source)
		{
			--moveTo;
			string [] sqls=new string [2];
			string userid=dc.GetObjectBySql ("select id from users where displayorder="+source.ToString ()).ToString ();
			sqls[0]=" update users set  displayorder=displayorder-1 where displayorder <="+moveTo.ToString () +" and displayorder >"+source.ToString (); 
			sqls[1]=" update users  set displayorder="+moveTo.ToString ()+" where id="+userid ;
			dc.ExcuteSqls (sqls);

		}

	}
}