Exemplo n.º 1
0
 protected void selecteurozone_Load(object sender, EventArgs e)
 {
     if (ddlprovince.Value.Equals("0"))
     {
         List <tb_LocationEntity> tlist  = new List <tb_LocationEntity>();
         tb_LocationEntity        tmodel = new tb_LocationEntity();
         tmodel.LocationName = "县/区";
         tmodel.LocationId   = 0;
         tlist.Add(tmodel);
         ddleurozone.DataSource     = tlist;
         ddleurozone.DataTextField  = "LocationName";
         ddleurozone.DataValueField = "LocationId";
         ddleurozone.DataBind();
     }
     if (!string.IsNullOrEmpty(selecteurozone.Text) && !selecteurozone.Text.Equals("0"))
     {
         Exam.Entity.tb_LocationEntity         model = Exam.BLL.tb_LocationBLL.GetInstance().GetAdminSingle(int.Parse(ddlcity.Value));
         IList <Exam.Entity.tb_LocationEntity> ds    = Exam.BLL.tb_LocationBLL.GetInstance().GetLocationInfo(model.LocationPath, 2);
         if (ds != null)
         {
             ddleurozone.DataSource     = ds;
             ddleurozone.DataTextField  = "LocationName";
             ddleurozone.DataValueField = "LocationId";
             ddleurozone.DataBind();
             for (int i = 0; i < ddleurozone.Items.Count; i++)
             {
                 if (ddleurozone.Items[i].Value == selecteurozone.Text)
                 {
                     ddleurozone.Items[i].Selected = true;
                 }
             }
         }
     }
 }
Exemplo n.º 2
0
    private void BindData()
    {
        string where = "";
        if (!string.IsNullOrEmpty(selecteurozone.Text) && !selecteurozone.Text.Equals("0"))
        {
            where = "and LocationId=" + selecteurozone.Text.Trim();
        }
        else if (!string.IsNullOrEmpty(selectcity.Text) && !selectcity.Text.Equals("0"))
        {
            Exam.Entity.tb_LocationEntity model = Exam.BLL.tb_LocationBLL.GetInstance().GetAdminSingle(int.Parse(ddlcity.Value));
            where = " and locationpath like '" + model.LocationPath + "%'";
        }
        else if (!string.IsNullOrEmpty(ddlprovince.Value))
        {
            if (ddlprovince.Value.Equals("0"))
            {
                where = " and 1=1";
            }
            else
            {
                Exam.Entity.tb_LocationEntity model = Exam.BLL.tb_LocationBLL.GetInstance().GetAdminSingle(int.Parse(ddlprovince.Value));
                where = " and locationpath like '" + model.LocationPath + "%'";
            }
        }
        if (identity != null)
        {
            //超级管理员
            if (identity._roleID == 4)
            {
                if (!string.IsNullOrEmpty(ddlstatus.SelectedValue))
                {
                    where += " and status=" + ddlstatus.SelectedValue;
                }
            }
            //代理商
            else if (identity._roleID == 5)
            {
                where += " and agent=" + identity.UserID;
                int schoolid = int.Parse(Jnwf.Utils.Config.ConfigurationUtil.GetAppSettingValue("agentid"));
                if (!string.IsNullOrEmpty(ddlstatus.SelectedValue))
                {
                    where += " and status=" + ddlstatus.SelectedValue;
                }
            }

            int allCount;
            int CurrentPage = 0;
            CurrentPage = this.pager1.CurrentPageIndex;
            DataSet ds = Exam.BLL.tb_SchoolBLL.GetInstance().GetList(pager1.PageSize, CurrentPage, " 1=1 " + where, out allCount);
            if (ds != null && ds.Tables.Count > 0 && ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
            {
                rptResultsList.DataSource = ds;
                rptResultsList.DataBind();
                i = 2;
            }
            else
            {
                rptResultsList.DataSource = string.Empty;
                rptResultsList.DataBind();
            }
        }
    }