using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Text;
using System.Data;
using System.Data.SqlClient;
namespace Mtxfw.VipSite
{
    public partial class Admin_Member_editjdr_log : Mtxfw.Utility.MemberBase
    {
        public Mtxfw.DAL.user_Results_jl4 daojl = new Mtxfw.DAL.user_Results_jl4();
        public Mtxfw.DAL.user_info daoUser = new Mtxfw.DAL.user_info();
        public Mtxfw.Utility.Config config = new Mtxfw.Utility.Config("");
        Mtxfw.DAL.user_bank daoBank = new Mtxfw.DAL.user_bank();
        protected String pid, cid, qid;
        public int gtype = 0;
        protected override void OnLoad(EventArgs e)
        {
            base.OnLoad(e);
            string hostname = Request.Url.Host;
            
            if (!IsPostBack)
            {
                if (Session["IFPassword"] == null)
                {
                    Response.Redirect("/Member_IFPassword.aspx?Url=/Admin_Member_editjdr_log.aspx");
                }
                if (IFStores != 1)
                {
                    Mtxfw.Utility.Tools.Message("您没有权限!", "/gl.aspx");
                }
                if (MemberJS.IndexOf("修改原推荐人") == -1)
                {
                    Mtxfw.Utility.Tools.Message("您没有权限!", "/gl.aspx");
                }
                Page.Title = "修改原推荐人记录 - " + config.webName;
               

                Data_Bind();

            }
            AspNetPager1.PageChanged += delegate(object s, EventArgs ex)
            {
                Data_Bind();
            };
           
        }
        protected void Data_Bind()
        {
            System.Text.StringBuilder sb = new System.Text.StringBuilder();
            String key = HttpUtility.UrlDecode(Request.QueryString["key"]);
            String Province = Request.QueryString["Province"];
            String strOrder = " Order By addtime desc";
            if (gtype == 0)
            {
                if (Memberttype != -1)
                {
                    sb.Append(" And gtype=" + Memberttype);
                }
            }
            else
            {
                sb.Append(" And gtype=" + gtype);
            }
            if (!String.IsNullOrEmpty(key))
            {
                sb.Append(" And ((select UserName from user_info b where b.ID=a.MemberId) like '%" + key.Trim() + "%') Or ((select UserName from user_info b where b.ID=a.MemberId1) like '%" + key.Trim() + "%') Or ((select UserName from user_info b where b.ID=a.MemberId2) like '%" + key.Trim() + "%')");
            }

            AspNetPager1.PageSize = 100;
            AspNetPager1.RecordCount = daojl.GetCount("gtype=" + gtype + " and utype=0" + sb.ToString());
            DataView dv = daojl.GetPager(AspNetPager1, "(select UserName from user_info b where b.ID=a.MemberId) as UserName,(select UserName from user_info b where b.ID=a.MemberId1) as UserName1,(select UserName from user_info b where b.ID=a.MemberId2) as UserName2,", "gtype=" + gtype + " and utype=0" + sb.ToString() + strOrder).Tables[0].DefaultView;
            Mtxfw.Utility.Tools.ToBind(Repeater1, dv);

        }
       
    }
}