bindstaff.aspx.cs

除了具有传统OA的邮件、工作流、文档等功能外

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 UDS.Components;
using System.Data.SqlClient;

namespace UDS.SubModule.UnitiveDocument.DocumentFlow
{
	/// <summary>
	/// BangdingRole 的摘要说明。
	/// </summary>
	public partial class BindStaff : System.Web.UI.Page
	{
		public int FlowID;
		public int StepID;
	
		protected void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			FlowID = Request.QueryString["FlowID"]==""?0:Int32.Parse(Request.QueryString["FlowID"].ToString());
			StepID = Request.QueryString["StepID"]==""?0:Int32.Parse(Request.QueryString["StepID"].ToString());
			if(!Page.IsPostBack)
			{				
				Bangding();
			}
		}
		private void InitCurRole()
		{
			SqlDataReader dr; //存放人物的数据
			Database mySQL = new Database();

			SqlParameter[] parameters = {
											mySQL.MakeInParam("@FlowID",SqlDbType.Int ,4,FlowID),
											mySQL.MakeInParam("@StepID",SqlDbType.Int ,4,StepID)
										};
			
			mySQL.RunProc("sp_Flow_GetBangdingRole",parameters,out dr);
			lstCurRole.Items.Clear(); 
			while(dr.Read())
			{
				ListItem item = new ListItem();
				lstCurRole.Items.Add(new ListItem(dr["role_name"].ToString(),dr["role_id"].ToString()));				
				
			}
			dr.Close();
			dr = null;
			
		}
		private void InitAllRole()
		{
			SqlDataReader dr; //存放人物的数据
			Database mySQL = new Database();

			SqlParameter[] parameters = {
											mySQL.MakeInParam("@FlowID",SqlDbType.Int ,4,FlowID),
											mySQL.MakeInParam("@StepID",SqlDbType.Int ,4,StepID)

										};
			
			mySQL.RunProc("sp_Flow_GetNotBangdingRole",parameters,out dr);
			lstAllRole.Items.Clear();
			while(dr.Read())
			{
				lstAllRole.Items.Add(new ListItem(dr["role_name"].ToString(),dr["role_id"].ToString()));								
			}
			dr.Close();
			dr = null;
		}
		private void InitCurPosition()
		{
			SqlDataReader dr; //存放人物的数据
			Database mySQL = new Database();

			SqlParameter[] parameters = {
											mySQL.MakeInParam("@FlowID",SqlDbType.Int ,4,FlowID),
											mySQL.MakeInParam("@StepID",SqlDbType.Int ,4,StepID)

										};
			
			mySQL.RunProc("sp_Flow_GetBangdingPosition",parameters,out dr);
			lstCurPosition.Items.Clear(); 
			while(dr.Read())
			{
				ListItem item = new ListItem();
				lstCurPosition.Items.Add(new ListItem(dr["Position_name"].ToString(),dr["Position_id"].ToString()));				
				
			}
			dr.Close();
			dr = null;

		}
		private void InitAllPosition()
		{
			SqlDataReader dr; //存放人物的数据
			Database mySQL = new Database();

			SqlParameter[] parameters = {
											mySQL.MakeInParam("@FlowID",SqlDbType.Int ,4,FlowID),
											mySQL.MakeInParam("@StepID",SqlDbType.Int ,4,StepID)

										};
			
			mySQL.RunProc("sp_Flow_GetNotBangdingPosition",parameters,out dr);
			lstAllPosition.Items.Clear();
			while(dr.Read())
			{
				lstAllPosition.Items.Add(new ListItem(dr["Position_name"].ToString(),dr["Position_id"].ToString()));								
			}
			dr.Close();
			dr = null;

		}		
		private void InitCurTeam()
		{
			SqlDataReader dr; //存放人物的数据
			Database mySQL = new Database();

			SqlParameter[] parameters = {
											mySQL.MakeInParam("@FlowID",SqlDbType.Int ,4,FlowID),
											mySQL.MakeInParam("@StepID",SqlDbType.Int ,4,StepID)

										};
	
			mySQL.RunProc("sp_Flow_GetBangdingTeam",parameters,out dr);
			lstCurTeam.Items.Clear(); 
			while(dr.Read())
			{
				ListItem item = new ListItem();
				lstCurTeam.Items.Add(new ListItem(dr["Team_name"].ToString(),dr["Team_id"].ToString()));				
		
			}
			dr.Close();
			dr = null;

		}
		private void InitAllTeam()
		{
			SqlDataReader dr; //存放人物的数据
			Database mySQL = new Database();

			SqlParameter[] parameters = {
											mySQL.MakeInParam("@FlowID",SqlDbType.Int ,4,FlowID),
											mySQL.MakeInParam("@StepID",SqlDbType.Int ,4,StepID)

										};
			
			mySQL.RunProc("sp_Flow_GetNotBangdingTeam",parameters,out dr);
			lstAllTeam.Items.Clear();
			while(dr.Read())
			{
				lstAllTeam.Items.Add(new ListItem(dr["Team_name"].ToString(),dr["Team_id"].ToString()));								
			}

			dr.Close();
			dr = null;

		}		

		private void InitCurTeamLeader()
		{
			SqlDataReader dr; //存放人物的数据
			Database mySQL = new Database();

			SqlParameter[] parameters = {
											mySQL.MakeInParam("@FlowID",SqlDbType.Int ,4,FlowID),
											mySQL.MakeInParam("@StepID",SqlDbType.Int ,4,StepID)

										};
	
			mySQL.RunProc("sp_Flow_GetBangdingTeamLeader",parameters,out dr);
			lstCurTeamLeader.Items.Clear(); 
			while(dr.Read())
			{
				ListItem item = new ListItem();
				lstCurTeamLeader.Items.Add(new ListItem(dr["Team_name"].ToString(),dr["Team_id"].ToString()));				
		
			}
			dr.Close();
			dr = null;

		}
		private void InitAllTeamLeader()
		{
			SqlDataReader dr; //存放人物的数据
			Database mySQL = new Database();

			SqlParameter[] parameters = {
											mySQL.MakeInParam("@FlowID",SqlDbType.Int ,4,FlowID),
											mySQL.MakeInParam("@StepID",SqlDbType.Int ,4,StepID)

										};
			
			mySQL.RunProc("sp_Flow_GetNotBangdingTeamLeader",parameters,out dr);
			lstAllTeamLeader.Items.Clear();
			while(dr.Read())
			{
				lstAllTeamLeader.Items.Add(new ListItem(dr["Team_name"].ToString(),dr["Team_id"].ToString()));								
			}

			dr.Close();
			dr = null;

		}		
		private void InitCurStaff()
		{
			SqlDataReader dr; //存放人物的数据
			Database mySQL = new Database();

			SqlParameter[] parameters = {
											mySQL.MakeInParam("@FlowID",SqlDbType.Int ,4,FlowID),
											mySQL.MakeInParam("@StepID",SqlDbType.Int ,4,StepID)

										};

			mySQL.RunProc("sp_Flow_GetBangdingStaff",parameters,out dr);
			lstCurStaff.Items.Clear(); 
			while(dr.Read())
			{
				ListItem item = new ListItem();
				lstCurStaff.Items.Add(new ListItem(dr["Staff_name"].ToString(),dr["Staff_id"].ToString()));				

			}
			dr.Close();

			dr = null;
		}
		private void InitAllStaff()
		{
			SqlDataReader dr; //存放人物的数据
			Database mySQL = new Database();

			SqlParameter[] parameters = {
											mySQL.MakeInParam("@FlowID",SqlDbType.Int ,4,FlowID),
											mySQL.MakeInParam("@StepID",SqlDbType.Int ,4,StepID)

										};
			
			mySQL.RunProc("sp_Flow_GetNotBangdingStaff",parameters,out dr);
			lstAllStaff.Items.Clear();
			while(dr.Read())
			{
				lstAllStaff.Items.Add(new ListItem(dr["Staff_name"].ToString(),dr["Staff_id"].ToString()));								
			}
			dr.Close();
			dr = null;

		}

		private void InitAllMember()
		{
			SqlDataReader dr; //存放人物的数据
			Database mySQL = new Database();

			SqlParameter[] parameters = {
											mySQL.MakeInParam("@FlowID",SqlDbType.Int ,4,FlowID),
											mySQL.MakeInParam("@StepID",SqlDbType.Int ,4,StepID)

										};
			
			mySQL.RunProc("sp_Flow_GetAllBindMember",parameters,out dr);
			lstAllMember.Items.Clear();
			while(dr.Read())
			{
				lstAllMember.Items.Add(new ListItem(dr["RealName"].ToString(),dr["Staff_id"].ToString()));								
			}
			dr.Close();
			dr = null;

		}
		

		#region Web Form Designer generated code
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN：该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    

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