예제 #1
0
    /// <summary>
    /// 页面数据绑定
    /// </summary>
    public void PageBind()
    {
        PageBase pb = new PageBase();

        pb.TblName       = "Tunnel_Vote";
        pb.FldName       = "vote_Id";
        pb.ProcedureName = "pagination";
        pb.PageSize      = pageSize;
        if (cuttentPage == 0)
        {
            cuttentPage = pb.PageIndex;
        }
        pb.PageIndex = cuttentPage;
        Tunnel.BLL.UserLogin ul = new Tunnel.BLL.UserLogin();
        if (ul.LoginID == 1)
        {
            pb.StrWhere = "";
        }
        else
        {
            Tunnel.BLL.Tunnel_menber   tm  = new Tunnel.BLL.Tunnel_menber();
            Tunnel.Model.Tunnel_menber tmm = new Tunnel_menber();
            tmm = tm.GetModel(Convert.ToInt64(ul.LoginID));
            if (!string.IsNullOrEmpty(Convert.ToString(tmm.m_bum)))
            {
                pb.StrWhere = "(vote_bumGroup like '%" + tmm.m_bum + "%' or vote_bumgroup = '|' or vote_bumgroup ='') and (getdate()>vote_startDate and getdate()<vote_endDate) and vote_state=0";
            }
            else
            {
                pb.StrWhere = "(vote_bumGroup like '%adfadfadfadfadfa%' or vote_bumgroup = '|' or vote_bumgroup ='') and (getdate()>vote_startDate and getdate()<vote_endDate) and vote_state=0";
            }
        }
        int count = 0;
        List <Tunnel.Model.Tunnel_Vote> modelList = new List <Tunnel.Model.Tunnel_Vote>();

        modelList  = tbll.GetList(pb, ref count); //获取分页结果
        pb.DoCount = 1;
        tbll.GetList(pb, ref count);              //获取总条数


        //数据绑定
        Repeater1.DataSource = modelList;
        Repeater1.DataBind();

        //数据分页
        MTCPager1.PageSize    = pageSize;
        MTCPager1.RecordCount = count;
        MTCPager1.PageIndex   = cuttentPage;
        if (count <= pb.PageSize)
        {
            MTCPager1.Visible = false;
        }
        else
        {
            MTCPager1.Visible = true;
        }
    }
예제 #2
0
    public string GetBum(object o)
    {
        Tunnel.BLL.Tunnel_menber   tm  = new Tunnel.BLL.Tunnel_menber();
        Tunnel.Model.Tunnel_menber tmm = new Tunnel_menber();
        tmm = tm.GetModel(Convert.ToInt64(o.ToString()));
        string strTemp = string.Empty;

        if (tmm != null)
        {
            Tunnel_bum            tbb = new Tunnel_bum();
            Tunnel.BLL.Tunnel_bum tb  = new Tunnel.BLL.Tunnel_bum();
            tbb = tb.GetModel(Convert.ToInt64(tmm.m_bum.ToString()));
            if (tbb != null)
            {
                strTemp = tbb.b_name;
            }
        }
        return(strTemp);
    }
예제 #3
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            if (!string.IsNullOrEmpty(Request.QueryString["delid"]))
            {
                uid = Request.QueryString["delid"].ToString();
                if (uid != "1")
                {
                    if (ul.LoginID.ToString() != uid)
                    {
                        if (tm.Exists(Convert.ToInt32(uid)))
                        {
                            tm.Delete(Convert.ToInt64(uid));
                            if (tu.GetModelList("uy_uid='" + uid + "'").Count != 0)
                            {
                                tu.Delete(tu.GetModelList("uy_uid='" + uid + "'")[0].uy_id);
                            }
                            Tunnel.Common.Message.Show("删除成功", "tunnel_userlist.aspx");
                        }
                        else
                        {
                            Tunnel.Common.Message.Show("该用户有过重要操作记录!请勿删除!");
                        }
                    }
                    else
                    {
                        Tunnel.Common.Message.Show("不能删除自己!");
                    }
                }
                else
                {
                    Tunnel.Common.Message.Show("不能删除初始管理员");
                }
            }
            //if (ul.LoginID != 1)
            if ("系统管理员" != ul.JiaoSe(ul.LoginID))
            {
                Tunnel.Model.Tunnel_menber tmm = new Tunnel_menber();
                tmm = tbll.GetModel(ul.LoginID);
                if (!string.IsNullOrEmpty(tmm.m_bum.ToString()))
                {
                    BumID = tmm.m_bum;
                }

                TextBox1.Text = word;
                SearchWhere   = "  (m_birth like '%" + word + "%' or " +
                                "  m_idcard like '%" + word + "%' or " +
                                "  m_login like '%" + word + "%' or " +
                                "  m_mail like '%" + word + "%' or " +
                                "  m_mobile like '%" + word + "%' or " +
                                "  m_name like '%" + word + "%') and m_bum = " + BumID + " ";
                PageBind();
            }
            else
            {
                TextBox1.Text = word;
                SearchWhere   = "  m_birth like '%" + word + "%' or " +
                                "  m_idcard like '%" + word + "%' or " +
                                "  m_login like '%" + word + "%' or " +
                                "  m_mail like '%" + word + "%' or " +
                                "  m_mobile like '%" + word + "%' or " +
                                "  m_name like '%" + word + "%'";
                PageBind();
            }
        }
    }