bindstaff.aspx.cs

协同办公系统.含权限短信项目,适合咨询服务性企业

		/// </summary>
		private void InitializeComponent()
		{    
			this.lstCurRole.SelectedIndexChanged += new System.EventHandler(this.lstCurRole_SelectedIndexChanged);
			this.cmdAdd.Click += new System.EventHandler(this.cmdAdd_Click);
			this.cmdDelete.Click += new System.EventHandler(this.cmdDelete_Click);
			this.lstAllRole.SelectedIndexChanged += new System.EventHandler(this.lstAllRole_SelectedIndexChanged);
			this.cmdAddPositon.Click += new System.EventHandler(this.cmdAddPositon_Click);
			this.cmdDeletePosition.Click += new System.EventHandler(this.cmdDeletePosition_Click);
			this.cmdAddTeam.Click += new System.EventHandler(this.cmdAddTeam_Click);
			this.cmdDeleteTeam.Click += new System.EventHandler(this.cmdDeleteTeam_Click);
			this.cmdAddTeamLeader.Click += new System.EventHandler(this.cmdAddTeamLeader_Click);
			this.cmdDeleteTeamLeader.Click += new System.EventHandler(this.cmdDeleteTeamLeader_Click);
			this.cmdAddStaff.Click += new System.EventHandler(this.cmdAddStaff_Click);
			this.cmdDeleteStaff.Click += new System.EventHandler(this.cmdDeleteStaff_Click);
			this.cmdReturn.Click += new System.EventHandler(this.cmdReturn_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion
		#region 绑定数据库
		private void Bangding()
		{		
			InitHeadLine();
			InitCurRole();
			InitAllRole();

			InitCurPosition();
			InitAllPosition();

			InitCurTeam();
			InitAllTeam();

			InitCurTeamLeader();
			InitAllTeamLeader();


			InitCurStaff();
			InitAllStaff();

			InitAllMember();

		}
		#endregion
		private void InitHeadLine()
		{
			UDS.Components.DocumentFlow df = new UDS.Components.DocumentFlow();
			labTitle.Text = df.GetFlowTitle(FlowID) + "->" +  df.GetStepTitle(FlowID,StepID);
			df = null;
		}
		private void cmdAdd_Click(object sender, System.EventArgs e)
		{
			if(lstAllRole.SelectedIndex >=0)
			{
				Database mySQL = new Database();
				foreach(ListItem li in lstAllRole.Items)
				{
					if(li.Selected ==true)
					{
						SqlParameter[] parameters = {
														mySQL.MakeInParam("@FlowID",SqlDbType.Int ,4,FlowID),
														mySQL.MakeInParam("@StepID",SqlDbType.Int ,4,StepID),
														mySQL.MakeInParam("@RoleID",SqlDbType.Int ,4,Int32.Parse (li.Value)  )
													};
			
						mySQL.RunProc("sp_Flow_AddBangdingRole",parameters);
					}
				}
				mySQL.Close();
				mySQL = null;
				//Response.Write("<script language='javascript'>alert('绑定成功！');</script>");
				Bangding();

			}
		}

		private void cmdDelete_Click(object sender, System.EventArgs e)
		{
			if(lstCurRole.SelectedIndex>=0)
			{
				Database mySQL = new Database();				
				foreach(ListItem li in lstCurRole.Items)
				{
					if(li.Selected ==true)
					{
						SqlParameter[] parameters = {
														mySQL.MakeInParam("@FlowID",SqlDbType.Int ,4,FlowID),
														mySQL.MakeInParam("@StepID",SqlDbType.Int ,4,StepID),
														//mySQL.MakeInParam("@RoleID",SqlDbType.Int ,4,Int32.Parse(lstCurRole.Items[lstCurRole.SelectedIndex].Value)  )
														mySQL.MakeInParam("@RoleID",SqlDbType.Int ,4,Int32.Parse(li.Value)  )
													};
			
						mySQL.RunProc("sp_Flow_DeleteBangdingRole",parameters);
					}
				}
				mySQL.Close();
				mySQL = null;
				//Response.Write("<script language='javascript'>alert('取消绑定成功！');</script>");		
				Bangding();
			}
		}

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

		private void cmdReturn_Click(object sender, System.EventArgs e)
		{
			Server.Transfer("ManageFlow.aspx?FlowID=" + FlowID.ToString());
		}

		private void cmdAddPositon_Click(object sender, System.EventArgs e)
		{
			if(lstAllPosition.SelectedIndex >=0)
			{
				Database mySQL = new Database();
				foreach(ListItem li in lstAllPosition.Items )
				{
					if(li.Selected ==true)
					{
						SqlParameter[] parameters = {
														mySQL.MakeInParam("@FlowID",SqlDbType.Int ,4,FlowID),
														mySQL.MakeInParam("@StepID",SqlDbType.Int ,4,StepID),
														mySQL.MakeInParam("@PositionID",SqlDbType.Int ,4,Int32.Parse (li.Value)  )
													};
			
						mySQL.RunProc("sp_Flow_AddBangdingPosition",parameters);
					}
				}
				mySQL.Close();
				mySQL = null;
				Bangding();

			}		
		}

		private void cmdDeletePosition_Click(object sender, System.EventArgs e)
		{
			if(lstCurPosition.SelectedIndex>=0)
			{
				Database mySQL = new Database();
				foreach(ListItem li in lstCurPosition.Items )
				{
					if(li.Selected ==true)
					{
						SqlParameter[] parameters = {
														mySQL.MakeInParam("@FlowID",SqlDbType.Int ,4,FlowID),
														mySQL.MakeInParam("@StepID",SqlDbType.Int ,4,StepID),
														mySQL.MakeInParam("@PositionID",SqlDbType.Int ,4,Int32.Parse (li.Value)  )
													};
			
						mySQL.RunProc("sp_Flow_DeleteBangdingPosition",parameters);
					}
				}
				mySQL.Close();
				mySQL = null;
				//Response.Write("<script language='javascript'>alert('取消绑定成功！');</script>");		
				Bangding();
			}
		
		}

		private void cmdDeleteTeam_Click(object sender, System.EventArgs e)
		{
			if(lstCurTeam.SelectedIndex>=0)
			{
				Database mySQL = new Database();
				foreach(ListItem li in lstCurTeam.Items )
				{
					if(li.Selected==true)
					{
						SqlParameter[] parameters = {
														mySQL.MakeInParam("@FlowID",SqlDbType.Int ,4,FlowID),
														mySQL.MakeInParam("@StepID",SqlDbType.Int ,4,StepID),
														mySQL.MakeInParam("@TeamID",SqlDbType.Int ,4,Int32.Parse (li.Value)  )
													};
			
						mySQL.RunProc("sp_Flow_DeleteBangdingTeam",parameters);
					}
				}
				mySQL.Close();
				mySQL = null;
				//Response.Write("<script language='javascript'>alert('取消绑定成功！');</script>");		
				Bangding();
			}
		
		}

		private void cmdDeleteStaff_Click(object sender, System.EventArgs e)
		{
			if(lstCurStaff.SelectedIndex>=0)
			{
				Database mySQL = new Database();
				foreach(ListItem li in lstCurStaff.Items)
				{
					if(li.Selected ==true)
					{
						SqlParameter[] parameters = {
														mySQL.MakeInParam("@FlowID",SqlDbType.Int ,4,FlowID),
														mySQL.MakeInParam("@StepID",SqlDbType.Int ,4,StepID),
														mySQL.MakeInParam("@StaffID",SqlDbType.Int ,4,Int32.Parse (li.Value)  )
													};
			
						mySQL.RunProc("sp_Flow_DeleteBangdingStaff",parameters);
					}
				}
				mySQL.Close();
				mySQL = null;
				//Response.Write("<script language='javascript'>alert('取消绑定成功！');</script>");		
				Bangding();
			}
		
		}

		private void cmdAddTeam_Click(object sender, System.EventArgs e)
		{
			if(lstAllTeam.SelectedIndex >=0)
			{
				Database mySQL = new Database();
				foreach(ListItem li in lstAllTeam.Items)
				{
					if(li.Selected ==true)
					{
						SqlParameter[] parameters = {
														mySQL.MakeInParam("@FlowID",SqlDbType.Int ,4,FlowID),
														mySQL.MakeInParam("@StepID",SqlDbType.Int ,4,StepID),
														mySQL.MakeInParam("@TeamID",SqlDbType.Int ,4,Int32.Parse (li.Value)  )
													};
			
						mySQL.RunProc("sp_Flow_AddBangdingTeam",parameters);
					}
				}
				mySQL.Close();
				mySQL = null;
				Bangding();

			}		
		
		}

		private void cmdAddStaff_Click(object sender, System.EventArgs e)
		{
			if(lstAllStaff.SelectedIndex >=0)
			{
				Database mySQL = new Database();
				foreach(ListItem li in lstAllStaff.Items)
				{
					if(li.Selected ==true)
					{
						SqlParameter[] parameters = {
														mySQL.MakeInParam("@FlowID",SqlDbType.Int ,4,FlowID),
														mySQL.MakeInParam("@StepID",SqlDbType.Int ,4,StepID),
														mySQL.MakeInParam("@StaffID",SqlDbType.Int ,4,Int32.Parse (li.Value)  )
													};
			
						mySQL.RunProc("sp_Flow_AddBangdingStaff",parameters);
					}
				}
				mySQL.Close();
				mySQL = null;
				Bangding();

			}		
		
		}

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

		private void cmdAddTeamLeader_Click(object sender, System.EventArgs e)
		{
			if(lstAllTeamLeader.SelectedIndex >=0)
			{
				Database mySQL = new Database();
				foreach(ListItem li in lstAllTeamLeader.Items)
				{
					if(li.Selected ==true)
					{
						SqlParameter[] parameters = {
														mySQL.MakeInParam("@FlowID",SqlDbType.Int ,4,FlowID),
														mySQL.MakeInParam("@StepID",SqlDbType.Int ,4,StepID),
														mySQL.MakeInParam("@TeamID",SqlDbType.Int ,4,Int32.Parse (li.Value)  )
													};
			
						mySQL.RunProc("sp_Flow_AddBangdingTeamLeader",parameters);
					}
				}
				mySQL.Close();
				mySQL = null;
				Bangding();

			}				
		}

		private void cmdDeleteTeamLeader_Click(object sender, System.EventArgs e)
		{
			if(lstCurTeamLeader.SelectedIndex>=0)
			{
				Database mySQL = new Database();
				foreach(ListItem li in lstCurTeamLeader.Items )
				{
					if(li.Selected==true)
					{
						SqlParameter[] parameters = {
														mySQL.MakeInParam("@FlowID",SqlDbType.Int ,4,FlowID),
														mySQL.MakeInParam("@StepID",SqlDbType.Int ,4,StepID),
														mySQL.MakeInParam("@TeamID",SqlDbType.Int ,4,Int32.Parse (li.Value)  )
													};
			
						mySQL.RunProc("sp_Flow_DeleteBangdingTeamLeader",parameters);
					}
				}
				mySQL.Close();
				mySQL = null;
				//Response.Write("<script language='javascript'>alert('取消绑定成功！');</script>");		
				Bangding();
			}		
		}
	}
}