📄 bindstaff.aspx.cs
字号:
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 class BindStaff : System.Web.UI.Page
{
protected System.Web.UI.WebControls.Button cmdAdd;
protected System.Web.UI.WebControls.Button cmdDelete;
protected System.Web.UI.WebControls.Label Label1;
protected System.Web.UI.WebControls.ListBox lstCurRole;
protected System.Web.UI.WebControls.ListBox lstAllRole;
protected System.Web.UI.WebControls.Label Label2;
protected System.Web.UI.WebControls.Label Label3;
protected System.Web.UI.WebControls.Label Label4;
protected System.Web.UI.WebControls.Label Label5;
protected System.Web.UI.WebControls.Label Label6;
protected System.Web.UI.WebControls.Label Label7;
protected System.Web.UI.WebControls.Label Label8;
protected System.Web.UI.WebControls.Button cmdAddPositon;
protected System.Web.UI.WebControls.Button cmdDeletePosition;
protected System.Web.UI.WebControls.ListBox lstCurPosition;
protected System.Web.UI.WebControls.ListBox lstAllPosition;
protected System.Web.UI.WebControls.Button cmdAddStaff;
protected System.Web.UI.WebControls.Button cmdDeleteStaff;
protected System.Web.UI.WebControls.Button cmdDeleteTeam;
protected System.Web.UI.WebControls.Button cmdAddTeam;
protected System.Web.UI.WebControls.ListBox lstCurTeam;
protected System.Web.UI.WebControls.ListBox lstAllTeam;
protected System.Web.UI.WebControls.ListBox lstCurStaff;
protected System.Web.UI.WebControls.ListBox lstAllStaff;
public int FlowID;
protected System.Web.UI.WebControls.Label labTitle;
protected System.Web.UI.WebControls.Label Label9;
protected System.Web.UI.WebControls.Label Label10;
protected System.Web.UI.WebControls.ListBox lstAllTeamLeader;
protected System.Web.UI.WebControls.Button cmdDeleteTeamLeader;
protected System.Web.UI.WebControls.Button cmdAddTeamLeader;
protected System.Web.UI.WebControls.ListBox lstCurTeamLeader;
protected System.Web.UI.WebControls.Button cmdReturn;
protected System.Web.UI.WebControls.ListBox lstAllMember;
public int StepID;
private 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>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -