private void ShowMemberList(string Type, string UserID, string ProjectID)
{
try
{
string Tsql = "";
if (ProjectID != string.Empty)
{
string GetMissionLeaderTsql = "SELECT UserID FROM PMMMember WHERE (Alive = '1') AND (ProjectID = '" + ProjectID + "') AND (Responsible = '1')";
GetMissionLeaderTsql += "SELECT UserID FROM PMPMember WHERE (ProjectID = '" + ProjectID + "') AND (Alive = '1') AND (Permission = '1')";
DataSet GetMissionLeader = SS.GetSqlTable(GetMissionLeaderTsql);
Tsql = "SELECT UserID, Name FROM PMAccount WHERE (Permission = '0') AND (UserID <> '" + UserID + "'";
for (int i = 0; i < GetMissionLeader.Tables[0].Rows.Count; i++)
{
if (UserID != GetMissionLeader.Tables[0].Rows[i]["UserID"].ToString())
{
Tsql += " AND UserID <> '" + GetMissionLeader.Tables[0].Rows[i]["UserID"].ToString() + "'";
}
}
for (int i = 0; i < GetMissionLeader.Tables[1].Rows.Count; i++)
{
if (UserID != GetMissionLeader.Tables[1].Rows[i]["UserID"].ToString())
{
Tsql += " AND UserID <> '" + GetMissionLeader.Tables[1].Rows[i]["UserID"].ToString() + "'";
}
}
Tsql += " ) ORDER BY Name;";
}
else
{
Tsql = "SELECT UserID, Name FROM PMAccount WHERE (Permission = '0') AND (UserID <> '" + UserID + "') ORDER BY Name;";
}
DataSet ds = new DataSet();
if (Type == "Creat") //創建專案
{
ds = SS.GetSqlTable(Tsql);
if (ds.Tables[0].Rows.Count > 0)
{
CheckBoxList_PMember.DataSource = ds;
CheckBoxList_PMember.DataBind();
}
else
{
Label_PStatus.Text = "目前無會員可加入專案";
}
}
else //編集專案
{
Tsql += "SELECT UserID, MemberName FROM PMPMember WHERE (Alive = '1') AND (ProjectID = '" + Session["EditIndex"].ToString() + "') AND (Permission = '0') ORDER BY MemberName";
ds = SS.GetSqlTable(Tsql);
if (ds.Tables[0].Rows.Count > 0)
{
Button_ESend.Enabled = true;
Button_EClean.Enabled = true;
CheckBoxList_EMember.DataSource = ds.Tables[0];
CheckBoxList_EMember.DataBind();
for (int i = 0; i < ds.Tables[1].Rows.Count; i++) //將已加入該專案的會員打勾
{
if (CheckBoxList_EMember.Items.FindByValue(ds.Tables[1].Rows[i]["UserID"].ToString()) != null)
{
CheckBoxList_EMember.Items.FindByValue(ds.Tables[1].Rows[i]["UserID"].ToString()).Selected = true;
}
}
}
else
{
Button_ESend.Enabled = false;
Button_EClean.Enabled = false;
Label_EStatus.Text = "目前無會員可加入專案";
}
}
}
catch
{
Response.Write("<script> alert('系統錯誤(8)');</script>");
}
}
protected void Button_EClean_Click(object sender, EventArgs e)
{
TextBox_ETitel.Text = "";
TextBox_EText.Text = "";
CheckBoxList_EMember.ClearSelection();
}
