/// <summary> /// 查询出个人任务 /// </summary> private void PersonProjectShow(string PersonId) { DataTable dt = new DataTable(); //通过ID查询出状态是0并且不等于的2 dt = PlanPersonalBll.GetList(5, "Delflag = '0' and Status <> 2 and id = '" + PersonId + "'", "StartTime asc").Tables[0]; GridView_PresonProject.DataSource = dt; GridView_PresonProject.DataBind(); }
protected void Calendar1_SelectionChanged(object sender, EventArgs e) { //获得传进来的用户ID string strId = Session["User_users"].ToString(); DataTable dt = new DataTable(); //获得选中的时间 string strdateTime = Calendar1.SelectedDate.ToString(); //通过ID获得用户在这个时间内的任务 string strsql = "select top 5 * from Personal_plan where '" + strdateTime + "' between StartTime and endTime and delflag ='0' and Status <> 2 and UserId = '" + strId + "' order by StartTime asc "; dt = pageControl.doSql(strsql).Tables[0]; GridView_PresonProject.DataSource = dt; GridView_PresonProject.DataBind(); }
///// <summary> ///// 查看自己的便签条 ///// </summary> ///// <param name="strId"></param> //protected void ShowNote(string strId) //{ // try // { // DataTable dt = new DataTable(); // dt = bNotepad.GetList(2, "delflag = '0' and UserId='" + strId + "'", "ID DESC").Tables[0]; // if (dt != null) // { // GridVie_NoteDetial.DataSource = dt; // GridVie_NoteDetial.DataBind(); // } // else // { // } // } // catch (Exception) // { // } //} /// <summary> /// 通过ID获得自己个人计划 /// </summary> /// <param name="PersonId"></param> protected void ShowPersonProject(string PersonId, string strDateTime) { try { DataTable dt = new DataTable(); //通过ID查询出状态是0并且不等于的2 string strDateTimeStart = DateTime.Parse(strDateTime).ToString("yyyy-MM-dd") + " 23:59:00"; string strDateTimeEnd = DateTime.Parse(strDateTime).ToString("yyyy-MM-dd") + " 00:00:00"; dt = bPlan.GetList(5, "Delflag = '0' and Status <> 2 and UserID = '" + PersonId + "' and '" + strDateTimeStart + "' > StartTime and '" + strDateTimeEnd + "'< endTime", "StartTime asc").Tables[0]; if (dt != null) { GridView_PresonProject.DataSource = dt; GridView_PresonProject.DataBind(); } } catch (Exception) { } }
/// <summary> /// 获取当前用户在选定的月份中的个人计划列表 /// </summary> /// <param name="PersonId"></param> protected void ShowPersonProject_month(string PersonId, string months) { try { DataTable dt = new DataTable(); DateTime selectTime = DateTime.Parse(months); DateTime nexttime = selectTime.AddMonths(1); //通过ID查询出状态是0并且不等于的2 dt = bPlan.GetList("Delflag = '0' and Status <> 2 and UserID = '" + PersonId + "' and StartTime>'" + selectTime.ToString() + "' and endTime<'" + nexttime.ToString() + "' order by StartTime asc").Tables[0]; if (dt != null) { GridView_PresonProject.DataSource = dt; GridView_PresonProject.DataBind(); } } catch (Exception) { } }