///<summary> ///查询部门任务 ///</summary> private void ClassProject(string ProjectId) { DataTable dt = new DataTable(); //通过ID查询部门状态是0并且不等于21 dt = TaskBll.GetList(5, "delflag='0' and Status <> 2 and id='" + ProjectId + "'", "StartTime asc").Tables[0]; GridView_ClassProject.DataSource = dt; GridView_ClassProject.DataBind(); }
/// <summary> /// 显示部门任务 /// </summary> /// <param name="strRealName"></param> /// <param name="strUserName"></param> /// <param name="strDateTime"></param> protected void ShowClassProject(string strRealName, string strUserName, string strDateTime) { try { DataTable dt = new DataTable(); string strsql = "select top 5 * from vProject_Task where Pro_DELFLAG='0' and Pro_Status=1 and '" + strDateTime + "' between StartTime and endTime and delflag = '0' and Status <> 2 and userInfo Like '%" + strRealName + "(" + strUserName + ")" + "%' order by StartTime asc"; dt = pagedosql.doSql(strsql).Tables[0]; if (dt != null) { GridView_ClassProject.DataSource = dt; GridView_ClassProject.DataBind(); } } catch (Exception) { } }
/// <summary> /// 获取当前用户在选定的月份中的部门任务列表 /// </summary> /// <param name="strRealName"></param> /// <param name="strUserName"></param> /// <param name="strDateTime"></param> protected void ShowClassProject_month(string strRealName, string strUserName, string months) { try { DataTable dt = new DataTable(); DateTime selectTime = DateTime.Parse(months); DateTime nexttime = selectTime.AddMonths(1); string strsql = "select top 5 * from vProject_Task where Pro_DELFLAG='0' and Pro_Status=1 and StartTime>'" + selectTime.ToString() + "' and endTime<'" + nexttime.ToString() + "' and delflag = '0' and Status <> 2 and userInfo Like '%" + strRealName + "(" + strUserName + ")" + "%' order by StartTime asc"; dt = pagedosql.doSql(strsql).Tables[0]; if (dt != null) { GridView_ClassProject.DataSource = dt; GridView_ClassProject.DataBind(); } } catch (Exception) { } }