/// <summary>
/// 初始化复选框参与人员信息
/// </summary>
protected void ShowCheckBoxList()
{
try
{
//显示可供参与的人员信息 。
DataTable dt_dep = new DataTable();
// project_model = project_bll.GetModel(Convert.ToInt16(Session["Work_ProjectId"]));
// string departID =commons.makeSqlIn(project_model.DepartmentID.ToString(),',');
//string sql1 = " SELECT ID, USERNAME, REALNAME,REALNAME + '（' + USERNAME +'）' AS NEWNAME FROM USER_Users WHERE (DELFLAG = 0) AND (DepartMentID IN " + departID + ")";
string sql1 = " SELECT ID, USERNAME, REALNAME,REALNAME + '（' + USERNAME +'）' AS NEWNAME FROM USER_Users WHERE (DELFLAG = 0) AND (ID IN (SELECT UserID FROM Project_UserList WHERE (ProjectID = " + Convert.ToInt16(Session["Work_ProjectId"]) + ") AND (Status = 1)))";
dt_dep = pagecontrol.doSql(sql1).Tables[0];
if (dt_dep.Rows.Count > 0)
{
CB_usersID.DataSource = dt_dep.DefaultView;
CB_usersID.DataTextField = "NEWNAME";
CB_usersID.DataValueField = "ID";
CB_usersID.DataBind();
}
else
{
CB_usersID.Enabled = false;
LB_notice.Visible = true;
Button_sumbit.Enabled = false;
}
//显示父任务
DataTable DT_task = new DataTable();
string sql2 = "SELECT ID,NAMES FROM Project_Task WHERE (DELFLAG = 0) AND ProjectID = " + Convert.ToInt16(Session["Work_ProjectId"]) + " AND IsFather = 1 ";
DT_task = pagecontrol.doSql(sql2).Tables[0];
ListItem li = new ListItem("--无--", "0");
DDL_UpID.Items.Add(li);
if (DT_task.Rows.Count > 0)
{
for (int i = 0; i < DT_task.Rows.Count; i++)
{
string name = DT_task.Rows[i]["NAMES"].ToString();
string id = DT_task.Rows[i]["ID"].ToString();
ListItem li1 = new ListItem(name, id);
DDL_UpID.Items.Add(li1);
}
}
//状态
RadioButtonList_status.SelectedValue = "0";
//有无子任务
RadioButtonList_IsFather.SelectedValue = "0";
//上传文档
RadioButtonList_doc.SelectedValue = "0";
}
catch
{
CB_usersID.Enabled = false;
LB_notice.Visible = true;
}
}
protected void ShowTaskInfo(string taskid)
{
try
{
//获取到任务的基本信息
task_model = task_bll.GetModel(int.Parse(taskid));
//任务标题
NAME.Text = task_model.NAMES;
//开始时间
TB_StartTime.Value = Convert.ToDateTime(task_model.StartTime.ToString()).ToString("yyyy-MM-dd");
//结束时间
TB_EndTime.Value = Convert.ToDateTime(task_model.EndTime.ToString()).ToString("yyyy-MM-dd");
//任务描述
Overviews.Text = task_model.Overviews.ToString();
//任务状态
for (int i = 0; i < RadioButtonList_status.Items.Count; i++)
{
if (RadioButtonList_status.Items[i].Value.Equals(task_model.Status.ToString()))
{
RadioButtonList_status.Items[i].Selected = true;
}
}
//显示可供参与的人员信息 。
DataTable dt_dep = new DataTable();
//project_model = project_bll.GetModel(Convert.ToInt16(Session["Work_ProjectId"]));
//string departID = commons.makeSqlIn(project_model.DepartmentID.ToString(), ',');
//string sql1 = " SELECT ID, USERNAME, REALNAME,REALNAME + '（' + USERNAME +'）' AS NEWNAME FROM USER_Users WHERE (DELFLAG = 0) AND (DepartMentID IN " + departID + ")";
string sql1 = " SELECT ID, USERNAME, REALNAME,REALNAME + '（' + USERNAME +'）' AS NEWNAME FROM USER_Users WHERE (DELFLAG = 0) AND (ID IN (SELECT UserID FROM Project_UserList WHERE (ProjectID = " + Convert.ToInt16(Session["Work_ProjectId"]) + ") AND (Status = 1)))";
dt_dep = pagecontrol.doSql(sql1).Tables[0];
if (dt_dep.Rows.Count > 0)
{
CB_usersID.DataSource = dt_dep.DefaultView;
CB_usersID.DataTextField = "NEWNAME";
CB_usersID.DataValueField = "ID";
CB_usersID.DataBind();
//在任务表中的参与人员字段
string UserIDs = task_model.UserIDs.ToString();
int checknum = 0;
//因为在任务表中部门以‘;’分开。故以‘;’将其分割,切割后的格式为: "用户ID号"+","+"0"
string[] UserIDsInfo = UserIDs.Split(';');
for (int i = 0; i < dt_dep.Rows.Count; i++)
{
for (int j = 0; j < UserIDsInfo.Length; j++)
{
string[] uid = UserIDsInfo[j].Split(',');
if (uid[0].ToString().Equals(CB_usersID.Items[i].Value.ToString()))
{
CB_usersID.Items[i].Selected = true;
checknum = checknum + 1;
}
}
}
//如果所有的参与人员都选中了，则将“全部”的复选框选中
if (checknum == dt_dep.Rows.Count)
{
CheckBox_choose.Checked = true;
}
}
else//因为参与部门是非空项，所以如果没有可供参与的部门的话，是不可以进行项目的申请的。
{
CB_usersID.Enabled = false;
LB_notice.Visible = true;
Button_sumbit.Enabled = false;
}
//显示父任务
DataTable DT_task = new DataTable();
string sql2 = "SELECT ID,NAMES FROM Project_Task WHERE (DELFLAG = 0) AND ProjectID = " + Convert.ToInt16(Session["Work_ProjectId"]) + " AND IsFather = 1 ";
DT_task = pagecontrol.doSql(sql2).Tables[0];
ListItem li = new ListItem("--无--", "0");
DDL_UpID.Items.Add(li);
if (DT_task.Rows.Count > 0)
{
for (int i = 0; i < DT_task.Rows.Count; i++)
{
string name = DT_task.Rows[i]["NAMES"].ToString();
string id = DT_task.Rows[i]["ID"].ToString();
ListItem li1 = new ListItem(name, id);
DDL_UpID.Items.Add(li1);
}
}
//父任务
DDL_UpID.SelectedValue = task_model.UpID.ToString();
//有无子任务
RadioButtonList_IsFather.SelectedValue = task_model.IsFather.ToString();
//是否上传文档
RadioButtonList_doc.SelectedValue = task_model.CompleteType.ToString();
DDL_UpID.Enabled = false;
}
catch
{
}
}
