Esempio n. 1
0
        //加载所有任务
        #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>");
            }
        }