//加载所有任务 #region private void LoadData() { S_UserInFo user = null; try { user = (S_UserInFo)Session["User"]; user.ToString(); } catch { Response.Redirect("Login.aspx"); } List <string> listWhere = new List <string>(); string superviseSearch = SuperviseSearch.Text; string superviseMxSearch = SuperviseMxSearch.Text; string deptSearch = DeptSearch.SelectedItem.ToString(); int urgencySerach = int.Parse(UrgencySerach.SelectedValue); int superviseTypeSearch = int.Parse(SuperviseTypeSearch.SelectedValue.ToString()); int bSateSearch = int.Parse(BSateSearch.SelectedValue.ToString()); if (superviseSearch.Length != 0) { listWhere.Add("BigTitle like '" + '%' + superviseSearch + "'"); } if (superviseMxSearch.Length != 0) { listWhere.Add("SmallTitle like '" + '%' + superviseMxSearch + "'"); } Boolean a = deptSearch.Equals("全部"); if (a == false) { listWhere.Add("DeptName= '" + deptSearch + "'"); } if (urgencySerach != 999) { listWhere.Add("Urgency= '" + urgencySerach + "'"); } if (superviseTypeSearch != 999) { listWhere.Add("SuperviseType= '" + superviseTypeSearch + "'"); } if (bSateSearch != 999) { listWhere.Add("bSate= '" + bSateSearch + "'"); } //办公室员工 if (user.Memo == "办公室" && user.Power != 0) { listWhere.Add("DeptName= '" + user.Memo + "'"); } //科部主管 if (user.Memo != "办公室" && user.Power == 0) { listWhere.Add("DeptName= '" + user.Memo + "'"); } //科部员工 if (user.Memo != "办公室" && user.Power != 0) { listWhere.Add("AssignNo= '" + user.UserID + "'"); } SuperviseAssignBLL superviseAssignBLL = new SuperviseAssignBLL(); DataSet ds = new DataSet(); try { ds = superviseAssignBLL.FindSuperviseAssignByMore(listWhere); DataView dv = ds.Tables[0].DefaultView; gridView.DataSource = dv; gridView.DataBind(); } catch (Exception ex) { Response.Write("<script language='javascript'>alert('当前无任务!')</script>"); } }