/// <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 { } }