accounts_users.aspx.cs

很不错的公文流转系统

		
		/// <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  Accounts_Users where userid="+userID);
			int DisplayOrder=int.Parse (o.ToString ());
			string Sql="DELETE FROM Accounts_Users WHERE  UserID='"+userID+"'";
//			string Sql1="SELECT COUNT(*) AS itemCount FROM Accounts_Users ";
//			
				int nType=dc.dataOperater1(Sql);
			
//			catch(System.Data.SqlClient.SqlException ee)
//			{
//				switch(ee.Number)
//				{
//					case 547:
//						this.RegisterClientScriptBlock("","<script language=javascript>alert('不能对该成员进行删除 ');</script>");
//						break;
//					default:
//						throw new AppException("执行下列sql语句出错\n\r"+Sql,ee);
//						
//				}
//				 
//			}
			if(nType!=0)
			{
				this.RegisterClientScriptBlock("","<script language=javascript>alert('不能对该成员进行删除 ');</script>");
				return;
			}
			//删除一用户后，将后面的用户排序号前移一位。
            dc.ExecuteSQL ("update  Accounts_Users set DisplayOrder=DisplayOrder-1 where DisplayOrder>" +DisplayOrder.ToString ()) ;
			
//			int itemCount=Convert.ToInt32(dc.GetObjectBySql(Sql1));
//			if(itemCount%DataGridAccounts_Users.PageSize==0)
//			{
//				if(DataGridAccounts_Users.CurrentPageIndex!=0)
//				{
//					DataGridAccounts_Users.CurrentPageIndex=DataGridAccounts_Users.CurrentPageIndex-1;
//
//				}
//				else
//				{
//					DataGridAccounts_Users.CurrentPageIndex=DataGridAccounts_Users.CurrentPageIndex+1;
//				}
//			}
			Bind ();
		
		}

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

		/// <summary>
		/// 查询
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		private void ImageButton1_Click(object sender, System.Web.UI.ImageClickEventArgs e)
		{
			if  (DropDownListSelect.SelectedValue .Trim ()   =="请选择")
			{
				Page.RegisterStartupScript("","<script>alert('请选择查询项');</script>"); 
				return;
			}
			else
			{   DataGridAccounts_Users.CurrentPageIndex=0;
				Bind();
			}
//			string con="";
//			if(DropDownListSelect.SelectedValue .Trim ()=="请选择")
//				con=" UserName LIKE %";
//			else if(DropDownListSelect.SelectedValue .Trim ()=="姓名")
//				con=" UserName LIKE '%"+TextBoxSelect.Text .Trim ()+"%'";
//			else if(DropDownListSelect.SelectedValue .Trim ()=="性别")
//				con=" Sex LIKE '%"+TextBoxSelect.Text .Trim ()+"%'";
//			else if(DropDownListSelect.SelectedValue .Trim ()=="电话")
//				con=" Telephone LIKE '%"+TextBoxSelect.Text .Trim ()+"%'";
//			else if(DropDownListSelect.SelectedValue .Trim ()=="移动电话")
//				con=" Mobile LIKE '%"+TextBoxSelect.Text .Trim ()+"%'";
//			else if(DropDownListSelect.SelectedValue .Trim ()=="Email")
//				con=" Email LIKE '%"+TextBoxSelect.Text .Trim ()+"%'";
//			this.bindDuty (con);
//			DataGridAccounts_Users.Visible =true;
		}

		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[7].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 changePersonSign=(ImageButton) e.Item.FindControl ("changePersonSign");
				if(changePersonSign !=null)
				{
					changePersonSign.Attributes ["onclick"]="return confirm('你是否将该用户的私章密码设为初始值？');";
					changePersonSign.Click +=new ImageClickEventHandler(changePersonSign_Click);
					
				}
                ImageButton changeLoginPassword=(ImageButton) e.Item .FindControl ("clearLoginPassword");
				if(changeLoginPassword !=null)
				{
					changeLoginPassword.Attributes ["onclick"]="return confirm('你是否将该用户的登录密码设为初始值？');";
					changeLoginPassword.Click +=new ImageClickEventHandler(changeLoginPassword_Click);
				}
			  
			}
			
		}
		private void changePersonSign_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 str ="select count(*) from personalSign where userid="+userid;
				int i=int.Parse (dc.GetValueBySql (str));
				if (i <1)
				{
					Page.RegisterStartupScript ("js","<script>alert('当前用户不存在个人私章！')</script>");

				}
				else
				{
					OI.cs.personalSign sign=new OI.cs.personalSign ();
					sign.UserID =userid;
					sign.recoveryPassword ();
				}
			}
			catch(Exception er)
			{
				Response.Write (er.Message );
				Response.End ();
			}
		}
		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  accounts_users set Password=1111 where userid="+userid.ToString ();
				dc.ExecuteSQL (sql);
				
			}
			catch(Exception er)
			{
				Response.Write (er);
				Response.End ();
			}
		}

		private 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 userid from accounts_users where displayorder="+source.ToString ()).ToString ();
			sqls[0]=" update accounts_users set  displayorder=displayorder+1 where displayorder >="+moveTo.ToString () +" and displayorder < "+source.ToString (); 
		    sqls[1]=" update accounts_users  set displayorder="+moveTo.ToString ()+" where userid="+userid ;
			dc.ExcuteSqls (sqls);

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

		}

	}
}