79 lines
3.2 KiB
C#
79 lines
3.2 KiB
C#
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_edittjr_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_edittjr_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=1" + 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=1" + sb.ToString() + strOrder).Tables[0].DefaultView;
|
|
Mtxfw.Utility.Tools.ToBind(Repeater1, dv);
|
|
|
|
}
|
|
|
|
}
|
|
} |