/// <summary>
/// 按部门将所有的用户呈现，并且将已经选择的用户selectUser在列表上显示出来
/// </summary>
/// <param name="selectUser"></param>
public void showDepartment(DataTable selectUser)
{
try
{
//获取到所有的用户的列表
string sql = "SELECT ID, USERNAME, REALNAME, DepartMentID, DELFLAG,DepartMentName FROM USER_Users WHERE (DELFLAG = '0') ORDER BY DepartMentID";
DataTable dt2 = pagedosql.doSql(sql).Tables[0];
Session["temp_userall_session"] = dt2;
Session["temp_userSelect_session"] = selectUser;
//
DataTable dt = new DataTable();
dt = bug.GetList(" TAGS='部门' and DELFLAG='0' order by NAME").Tables[0];
if (dt.Rows.Count > 0)
{
GridView_grouplist.DataSource = dt;
GridView_grouplist.DataBind();
GridView_grouplist.Visible = true;
}
else
{
GridView_grouplist.Visible = false;
}
}
catch
{
}
}
/// <summary>
/// 按部门将所有的用户呈现，并且将已经选择的用户selectUser在列表上显示出来
/// </summary>
/// <param name="selectUser"></param>
public void showDepartment(string selectRoles)
{
try
{
//获取到所有的用户按钮权限
string sql = "SELECT ID, NAME, ROLES,TYPES,UPID FROM USER_Role WHERE (DELFLAG = '0' and Types='按钮权限') ORDER BY UPID,name";
DataTable dt2 = pagedosql.doSql(sql).Tables[0];
Session["temp_Roles_session"] = dt2;
Session["temp_rolesSelect_session"] = selectRoles;
//
DataTable dt = new DataTable();
dt = buRole.GetList(" Types<>'按钮权限' and DELFLAG='0' order by NAME").Tables[0];
if (dt.Rows.Count > 0)
{
GridView_grouplist.DataSource = dt;
GridView_grouplist.DataBind();
GridView_grouplist.Visible = true;
}
else
{
GridView_grouplist.Visible = false;
}
}
catch
{
}
}
/// <summary>
/// 按部门将所有的用户呈现，并且将已经选择的用户selectUser在列表上显示出来
/// </summary>
/// <param name="selectUser"></param>
public void showDepartment(DataTable selectUser, DataTable Alluser, DataTable tags)
{
try
{
Session["temp_userall_session"] = Alluser;
Session["temp_userSelect_session"] = selectUser;
if (tags.Rows.Count > 0)
{
GridView_grouplist.DataSource = tags;
GridView_grouplist.DataBind();
GridView_grouplist.Visible = true;
}
else
{
GridView_grouplist.Visible = false;
}
}
catch
{
}
}
/// <summary>
/// 按部门将所有的用户呈现，并且将已经选择的用户selectUser在列表上显示出来
/// </summary>
/// <param name="selectUser"></param>
public void showDepartment(string projectId)
{
try
{
//获取到部门ID
mProjects = bProjects.GetModel(int.Parse(projectId));
//通过方法 用逗号把部门ID分开
string strdepartmentId = commonId.makeSqlIn(mProjects.DepartmentID, ',');
//查询出部门中status =1 并且delflag=0 的用户
string sql = "SELECT * FROM vProject_UserList WHERE (DELFLAG = '0') and status='1'and ProjectID='" + projectId + "' ORDER BY DepartMentID";
DataTable dt1 = pagedosql.doSql(sql).Tables[0];
if (dt1.Rows.Count > 0)
{
Label_tongji.Text = "此项目中共有参与人员 " + dt1.Rows.Count.ToString() + " 人";
}
else
{
Label_tongji.Text = "此项目中没有参与人员";
}
//通过部门ID 查看部门里有多少人员
string[] strdepartmentId_arr = mProjects.DepartmentID.Split(',');
string strsql = "";
for (int i = 0; i < strdepartmentId_arr.Length; i++)
{
if (strsql == "")
{
strsql = "select id,realName,userName,'" + strdepartmentId_arr[i] + "' departmentid from USER_Users where departmentid like '%" + strdepartmentId_arr[i] + "%'";
}
else
{
strsql += " union select id,realName,userName,'" + strdepartmentId_arr[i] + "'departmentid from USER_Users where departmentid like '%" + strdepartmentId_arr[i] + "%'";
}
}
//string strsql = "select id,realName,userName,departmentid from USER_Users where departmentid in " + strdepartmentId;
DataTable dt = pagedosql.doSql(strsql).Tables[0];
Session["temp_UserAllUser_session"] = dt;
Session["temp_SelectUser_session"] = dt1;
//查询出传进来的部门ID
DataTable dt2 = new DataTable();
dt2 = bug.GetList(" TAGS='部门' and DELFLAG='0' and id in " + strdepartmentId + " order by ISMOREN").Tables[0];
if (dt.Rows.Count > 0)
{
GridView_grouplist.DataSource = dt2;
GridView_grouplist.DataBind();
GridView_grouplist.Visible = true;
}
else
{
GridView_grouplist.Visible = false;
}
}
catch
{
}
}
