473 lines
25 KiB
C#
473 lines
25 KiB
C#
using System;
|
||
using System.Collections.Generic;
|
||
using System.Web;
|
||
using System.Web.UI;
|
||
using System.Web.UI.WebControls;
|
||
using System.Globalization;
|
||
using System.Data;
|
||
using System.Data.SqlClient;
|
||
namespace Mtxfw.VipSite
|
||
{
|
||
public partial class Admin_Member_List0 : Mtxfw.Utility.MemberBase
|
||
{
|
||
Mtxfw.DAL.user_info daoUser = new Mtxfw.DAL.user_info();
|
||
Mtxfw.DAL.user_Results daoResults = new Mtxfw.DAL.user_Results();
|
||
Mtxfw.DAL.user_Results_jl2 daojl2 = new Mtxfw.DAL.user_Results_jl2();
|
||
public Mtxfw.Utility.Config config = new Mtxfw.Utility.Config("");
|
||
Mtxfw.DAL.user_proxy daoproxy = new Mtxfw.DAL.user_proxy();
|
||
Mtxfw.DAL.duihuanma daodhm = new Mtxfw.DAL.duihuanma();
|
||
Mtxfw.DAL.user_info_fenghao daofenghao = new Mtxfw.DAL.user_info_fenghao();
|
||
DAL.P_Product daoProduct = new DAL.P_Product();
|
||
DAL.P_Guige daoGuige = new DAL.P_Guige();
|
||
DAL.order_info daoorder = new DAL.order_info();
|
||
protected int IFShowXFJF = 0;
|
||
protected string strIFKD = "", strIFNoKD = "";
|
||
public int gtype = 0;
|
||
#region 判断页面是否刷新
|
||
private bool _refreshState;
|
||
private bool _isRefresh;
|
||
|
||
/// <summary>
|
||
/// 判断页面是否刷新
|
||
/// </summary>
|
||
public bool IsRefresh
|
||
{
|
||
get
|
||
{
|
||
return _isRefresh;
|
||
}
|
||
}
|
||
protected override void LoadViewState(object savedState)
|
||
{
|
||
object[] allStates = (object[])savedState;
|
||
base.LoadViewState(allStates[0]);
|
||
_refreshState = (bool)allStates[1];
|
||
_isRefresh = _refreshState == (bool)Session["__ISREFRESH"];
|
||
}
|
||
protected override object SaveViewState()
|
||
{
|
||
Session["__ISREFRESH"] = _refreshState;
|
||
object[] allStates = new object[2];
|
||
allStates[0] = base.SaveViewState();
|
||
allStates[1] = !_refreshState;
|
||
return allStates;
|
||
}
|
||
#endregion
|
||
protected override void OnLoad(EventArgs e)
|
||
{
|
||
base.OnLoad(e);
|
||
string hostname = Request.Url.Host;
|
||
|
||
seclect_Drop.Attributes.Add("onchange", "onyxq()");
|
||
if (!IsPostBack)
|
||
{
|
||
if (Session["IFPassword"] == null)
|
||
{
|
||
Response.Redirect("/Member_IFPassword.aspx?Url=/Admin_Member_List0.aspx");
|
||
}
|
||
if (IFStores != 1)
|
||
{
|
||
Mtxfw.Utility.Tools.Message("您没有权限!", "/gl.aspx");
|
||
}
|
||
if (MemberJS.IndexOf("联盟部管理") == -1)
|
||
{
|
||
Mtxfw.Utility.Tools.Message("您没有权限!", "/gl.aspx");
|
||
}
|
||
|
||
Data_Bind();
|
||
Page.Title = "联盟部列表 - " + GetWebName;
|
||
}
|
||
|
||
MyPager.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 regtime = HttpUtility.UrlDecode(Request.QueryString["regtime"]);
|
||
|
||
sb.Append("gtype=" + gtype + " And userstate='正常' And IFStores=0 and uLevel30=2");
|
||
if (gtype == 0)
|
||
{
|
||
if (Memberttype != -1)
|
||
{
|
||
sb.Append(" And gtype=" + Memberttype);
|
||
}
|
||
}
|
||
else
|
||
{
|
||
sb.Append(" And gtype=" + gtype);
|
||
}
|
||
|
||
|
||
if (!String.IsNullOrEmpty(key))
|
||
{
|
||
key = key.Trim();
|
||
sb.Append(" and UserName like '%" + key + "%' or RealName like '%" + key + "%'");
|
||
|
||
}
|
||
string strOrder = " RegTime desc";
|
||
string groupby = "";
|
||
|
||
int Start = 0;
|
||
int Limit = 0;
|
||
Int32 Recount = 0;
|
||
MyPager.PageSize = 100;
|
||
Start = MyPager.PageSize * (MyPager.CurrentPageIndex - 1);
|
||
Limit = MyPager.PageSize;
|
||
DataSet dss = daoUser.GetDataSet(groupby, strOrder, "ID,UserName,RealName,uLevel,uLevel2,uLevel4,uLevel5,uLevel6,uLevel7,uLevel8,uLevel9,uLevel10,uLevel14,uLevel15,uLevel18,uLevel21,uLevel24,uLevel25,uLevel26,uLevel30,uLevel31,uLevel32,ContactID,SuperiorsID,SJRememberID,IFBecomeBusiness,IFWCLFCPJL,umoney,umoney17,umoney18,umoney19,umoney20,umoney21,umoney22,umoney23,umoney26,umoney27,umoney28,umoney29,umoney30,umoney31,umoney32,umoney33,umoney34,umoney35,umoney36,umoney37,umoney39,umoney40,umoney41,RegTime,RegTime1,UserState,PhoneNumber,tjcount,temcount,(select UserName from user_info b where b.Id=tbl.SuperiorsID) as UserName2,(select Count(b.id) from duihuanma b where b.MemberId=tbl.ID) as dhmcount,(select UserName from user_info b where b.Id=tbl.ContactID) as UserName3,(select RealName from user_info b where b.Id=tbl.ContactID) as RealName3", "", sb.ToString(), Start, Limit, out Recount);//,(select sum(b0) from user_Results b where b.utype=0 and IFDelete=0 and seef=0 and b.MemberId=tbl.id)as dsymoney
|
||
Mtxfw.Utility.Tools.ToBind(Repeater1, dss.Tables[1]);
|
||
MyPager.RecordCount = Recount;
|
||
if (MyPager.RecordCount == 0)
|
||
{
|
||
MyPager.Visible = false;
|
||
}
|
||
/*DataSet ds = daoUser.GetList1("sum(umoney20) as umoney,(sum(umoney)-sum(umoney17)) as umoney0,sum(umoney32) as umoney1,sum(umoney30) as umoney2,sum(umoney29) as umoney3,sum(umoney31) as umoney4,sum(umoney34) as umoney5,sum(umoney36) as umoney6,sum(umoney37) as umoney7,sum(umoney33) as umoney8,sum(umoney19) as umoney9", sb.ToString());
|
||
if (ds.Tables[0].Rows.Count >0)
|
||
{
|
||
if (ds.Tables[0].Rows[0]["umoney"].ToString() != "")
|
||
{
|
||
Label_b1.Text = Convert.ToDouble(ds.Tables[0].Rows[0]["umoney"]).ToString("0.###");
|
||
Label_b2.Text = Convert.ToDouble(ds.Tables[0].Rows[0]["umoney0"]).ToString("0.###");
|
||
Label_b3.Text = Convert.ToDouble(ds.Tables[0].Rows[0]["umoney1"]).ToString("0.###");
|
||
Label_b4.Text = Convert.ToDouble(ds.Tables[0].Rows[0]["umoney2"]).ToString("0.###");
|
||
Label_b5.Text = Convert.ToDouble(ds.Tables[0].Rows[0]["umoney3"]).ToString("0.###");
|
||
Label_b6.Text = Convert.ToDouble(ds.Tables[0].Rows[0]["umoney4"]).ToString("0.###");
|
||
Label_b7.Text = Convert.ToDouble(ds.Tables[0].Rows[0]["umoney5"]).ToString("0.###");
|
||
Label_b8.Text = Convert.ToDouble(ds.Tables[0].Rows[0]["umoney6"]).ToString("0.###");
|
||
Label_b9.Text = Convert.ToDouble(ds.Tables[0].Rows[0]["umoney7"]).ToString("0.###");
|
||
Label_b10.Text = Convert.ToDouble(ds.Tables[0].Rows[0]["umoney8"]).ToString("0.###");
|
||
Label_b11.Text = Convert.ToDouble(ds.Tables[0].Rows[0]["umoney9"]).ToString("0.###");
|
||
}
|
||
else
|
||
{
|
||
Label_b1.Text = "0";
|
||
Label_b2.Text = "0";
|
||
Label_b3.Text = "0";
|
||
Label_b4.Text = "0";
|
||
Label_b5.Text = "0";
|
||
Label_b6.Text = "0";
|
||
Label_b7.Text = "0";
|
||
Label_b8.Text = "0";
|
||
Label_b9.Text = "0";
|
||
Label_b10.Text = "0";
|
||
Label_b11.Text = "0";
|
||
}
|
||
}
|
||
else
|
||
{
|
||
Label_b1.Text = "0";
|
||
Label_b2.Text = "0";
|
||
Label_b3.Text = "0";
|
||
Label_b4.Text = "0";
|
||
Label_b5.Text = "0";
|
||
Label_b6.Text = "0";
|
||
Label_b7.Text = "0";
|
||
Label_b8.Text = "0";
|
||
Label_b9.Text = "0";
|
||
Label_b10.Text = "0";
|
||
Label_b11.Text = "0";
|
||
}
|
||
ds.Clear();*/
|
||
|
||
}
|
||
protected void Run_Click(object s, System.EventArgs e)
|
||
{
|
||
if (IsRefresh == false)
|
||
{
|
||
string sidss = ",";
|
||
CheckBox Check = new CheckBox();
|
||
string strs = seclect_Drop.SelectedItem.Value;
|
||
foreach (RepeaterItem Item in Repeater1.Items)
|
||
{
|
||
//在行中查找到该单选框
|
||
Check = (CheckBox)Item.FindControl("checka");
|
||
int strID = int.Parse(Check.CssClass);
|
||
string sids = "";
|
||
if (Check.Checked == true)
|
||
{
|
||
TextBox Seef = new TextBox();
|
||
Seef = (TextBox)Item.FindControl("TextBox_Seef");
|
||
Mtxfw.Model.user_info umodel = daoUser.GetModel(strID);
|
||
if (umodel != null)
|
||
{
|
||
if (strs == "0")
|
||
{
|
||
daoUser.UpdateuLevel("IFBecomeBusiness", 1, strID);
|
||
Model.User_CZ_log logmodel = new Model.User_CZ_log();
|
||
logmodel.MemberId = Card;
|
||
logmodel.AddTime = DateTime.Now;
|
||
logmodel.IP = Mtxfw.Utility.Common.GetIP;
|
||
logmodel.Body = "把会员设为不能登录，用户名：" + umodel.UserName;
|
||
logmodel.UType = 0;
|
||
logmodel.gtype = gtype;
|
||
new DAL.User_CZ_log().Add(logmodel);
|
||
}
|
||
else if (strs == "1")
|
||
{
|
||
daoUser.UpdateuLevel("IFBecomeBusiness", 0, strID);
|
||
Model.User_CZ_log logmodel = new Model.User_CZ_log();
|
||
logmodel.MemberId = Card;
|
||
logmodel.AddTime = DateTime.Now;
|
||
logmodel.IP = Mtxfw.Utility.Common.GetIP;
|
||
logmodel.Body = "取消会员不能登录，用户名：" + umodel.UserName;
|
||
logmodel.UType = 0;
|
||
logmodel.gtype = gtype;
|
||
new DAL.User_CZ_log().Add(logmodel);
|
||
}
|
||
else if (strs == "2")
|
||
{
|
||
daoUser.UpdateuLevel("uLevel9", 1, strID);
|
||
Model.User_CZ_log logmodel = new Model.User_CZ_log();
|
||
logmodel.MemberId = Card;
|
||
logmodel.AddTime = DateTime.Now;
|
||
logmodel.IP = Mtxfw.Utility.Common.GetIP;
|
||
logmodel.Body = "把会员设为不能提现，用户名：" + umodel.UserName;
|
||
logmodel.UType = 0;
|
||
logmodel.gtype = gtype;
|
||
new DAL.User_CZ_log().Add(logmodel);
|
||
}
|
||
else if (strs == "3")
|
||
{
|
||
daoUser.UpdateuLevel("uLevel9", 0, strID);
|
||
Model.User_CZ_log logmodel = new Model.User_CZ_log();
|
||
logmodel.MemberId = Card;
|
||
logmodel.AddTime = DateTime.Now;
|
||
logmodel.IP = Mtxfw.Utility.Common.GetIP;
|
||
logmodel.Body = "取消会员不能提现，用户名：" + umodel.UserName;
|
||
logmodel.UType = 0;
|
||
logmodel.gtype = gtype;
|
||
new DAL.User_CZ_log().Add(logmodel);
|
||
}
|
||
else if (strs == "4")
|
||
{
|
||
daoUser.UpdateuLevel("uLevel10", 1, strID);
|
||
Model.User_CZ_log logmodel = new Model.User_CZ_log();
|
||
logmodel.MemberId = Card;
|
||
logmodel.AddTime = DateTime.Now;
|
||
logmodel.IP = Mtxfw.Utility.Common.GetIP;
|
||
logmodel.Body = "把会员设为不能转账，用户名：" + umodel.UserName;
|
||
logmodel.UType = 0;
|
||
logmodel.gtype = gtype;
|
||
new DAL.User_CZ_log().Add(logmodel);
|
||
}
|
||
else if (strs == "5")
|
||
{
|
||
daoUser.UpdateuLevel("uLevel10", 0, strID);
|
||
Model.User_CZ_log logmodel = new Model.User_CZ_log();
|
||
logmodel.MemberId = Card;
|
||
logmodel.AddTime = DateTime.Now;
|
||
logmodel.IP = Mtxfw.Utility.Common.GetIP;
|
||
logmodel.Body = "取消会员不能转账，用户名：" + umodel.UserName;
|
||
logmodel.UType = 0;
|
||
logmodel.gtype = gtype;
|
||
new DAL.User_CZ_log().Add(logmodel);
|
||
}
|
||
else if (strs == "6")
|
||
{
|
||
daoUser.UpdateuLevel("IFWCLFCPJL", 1, strID);
|
||
Model.User_CZ_log logmodel = new Model.User_CZ_log();
|
||
logmodel.MemberId = Card;
|
||
logmodel.AddTime = DateTime.Now;
|
||
logmodel.IP = Mtxfw.Utility.Common.GetIP;
|
||
logmodel.Body = "把会员设为不能分红，用户名：" + umodel.UserName;
|
||
logmodel.UType = 0;
|
||
logmodel.gtype = gtype;
|
||
new DAL.User_CZ_log().Add(logmodel);
|
||
}
|
||
else if (strs == "7")
|
||
{
|
||
daoUser.UpdateuLevel("IFWCLFCPJL", 0, strID);
|
||
Model.User_CZ_log logmodel = new Model.User_CZ_log();
|
||
logmodel.MemberId = Card;
|
||
logmodel.AddTime = DateTime.Now;
|
||
logmodel.IP = Mtxfw.Utility.Common.GetIP;
|
||
logmodel.Body = "取消会员不能分红，用户名：" + umodel.UserName;
|
||
logmodel.UType = 0;
|
||
logmodel.gtype = gtype;
|
||
new DAL.User_CZ_log().Add(logmodel);
|
||
}
|
||
else if (strs == "8")
|
||
{
|
||
Model.user_info_fenghao fmodel = new Model.user_info_fenghao();
|
||
fmodel.MemberId = umodel.Id;
|
||
fmodel.MemberId2 = 0;
|
||
fmodel.yuanyin = "管理员封号";
|
||
fmodel.ResultId = 0;
|
||
fmodel.addtime = DateTime.Now;
|
||
fmodel.ttype = 0;
|
||
daofenghao.Add(fmodel);
|
||
daoUser.UpdateuLevel("uLevel8", 1, strID);
|
||
daoUser.UpdatePassword("LoginId", "", strID);
|
||
daoUser.UpdatePassword("LoginId2", "", strID);
|
||
Model.User_CZ_log logmodel = new Model.User_CZ_log();
|
||
logmodel.MemberId = Card;
|
||
logmodel.AddTime = DateTime.Now;
|
||
logmodel.IP = Mtxfw.Utility.Common.GetIP;
|
||
logmodel.Body = "封号，用户名：" + umodel.UserName;
|
||
logmodel.UType = 0;
|
||
logmodel.gtype = gtype;
|
||
new DAL.User_CZ_log().Add(logmodel);
|
||
}
|
||
else if (strs == "9")
|
||
{
|
||
Model.user_info_fenghao fmodel = new Model.user_info_fenghao();
|
||
fmodel.MemberId = umodel.Id;
|
||
fmodel.MemberId2 = 0;
|
||
fmodel.yuanyin = "管理员封号";
|
||
fmodel.ResultId = 0;
|
||
fmodel.addtime = DateTime.Now;
|
||
fmodel.ttype = 0;
|
||
daofenghao.Add(fmodel);
|
||
daoUser.UpdateuLevel("uLevel8", 0, strID);
|
||
Model.User_CZ_log logmodel = new Model.User_CZ_log();
|
||
logmodel.MemberId = Card;
|
||
logmodel.AddTime = DateTime.Now;
|
||
logmodel.IP = Mtxfw.Utility.Common.GetIP;
|
||
logmodel.Body = "解封，用户名：" + umodel.UserName;
|
||
logmodel.UType = 0;
|
||
logmodel.gtype = gtype;
|
||
new DAL.User_CZ_log().Add(logmodel);
|
||
}
|
||
else if (strs == "10")
|
||
{
|
||
daoUser.UpdateuLevel("uLevel2", 1, strID);
|
||
if (daoproxy.GetCount("gtype="+ gtype + " and TType=1 and MemberId=" + umodel.Id) == 0)
|
||
{
|
||
Mtxfw.Model.user_proxy pmodel = new Model.user_proxy();
|
||
pmodel.MemberId = umodel.Id;
|
||
pmodel.AgenLevel = 2;
|
||
pmodel.AgenCost = 0;
|
||
pmodel.Agenprovince = umodel.Province;
|
||
pmodel.Agencity = umodel.City;
|
||
pmodel.Agencounty = umodel.County;
|
||
pmodel.AAddress = umodel.MailingAddress;
|
||
pmodel.IFFill = 0;
|
||
pmodel.Agentrading = "";
|
||
pmodel.ATel = umodel.Phone;
|
||
pmodel.IFJS = 1;
|
||
pmodel.TType = 1;
|
||
pmodel.gtype = gtype;
|
||
pmodel.Id = daoproxy.Add(pmodel);
|
||
//pmodel.seef = 1;
|
||
//daoproxy.Updateseef(pmodel);
|
||
Model.User_CZ_log logmodel = new Model.User_CZ_log();
|
||
logmodel.MemberId = Card;
|
||
logmodel.AddTime = DateTime.Now;
|
||
logmodel.IP = Mtxfw.Utility.Common.GetIP;
|
||
logmodel.Body = "设为代理，用户名：" + umodel.UserName;
|
||
logmodel.UType = 0;
|
||
logmodel.gtype = gtype;
|
||
new DAL.User_CZ_log().Add(logmodel);
|
||
}
|
||
}
|
||
else if (strs == "11")
|
||
{
|
||
daoUser.UpdateuLevel("uLevel26", 1, strID);
|
||
Model.User_CZ_log logmodel = new Model.User_CZ_log();
|
||
logmodel.MemberId = Card;
|
||
logmodel.AddTime = DateTime.Now;
|
||
logmodel.IP = Mtxfw.Utility.Common.GetIP;
|
||
logmodel.Body = "设为创客，用户名：" + umodel.UserName;
|
||
logmodel.UType = 0;
|
||
logmodel.gtype = gtype;
|
||
new DAL.User_CZ_log().Add(logmodel);
|
||
}
|
||
else if (strs == "12")
|
||
{
|
||
daoUser.UpdateuLevel("uLevel26", 0, strID);
|
||
Model.User_CZ_log logmodel = new Model.User_CZ_log();
|
||
logmodel.MemberId = Card;
|
||
logmodel.AddTime = DateTime.Now;
|
||
logmodel.IP = Mtxfw.Utility.Common.GetIP;
|
||
logmodel.Body = "取消创客，用户名：" + umodel.UserName;
|
||
logmodel.UType = 0;
|
||
logmodel.gtype = gtype;
|
||
new DAL.User_CZ_log().Add(logmodel);
|
||
}
|
||
else if (strs == "13")
|
||
{
|
||
daoUser.UpdateuLevel("uLevel30", 2, strID);
|
||
Model.User_CZ_log logmodel = new Model.User_CZ_log();
|
||
logmodel.MemberId = Card;
|
||
logmodel.AddTime = DateTime.Now;
|
||
logmodel.IP = Mtxfw.Utility.Common.GetIP;
|
||
logmodel.Body = "设为联盟部，用户名：" + umodel.UserName;
|
||
logmodel.UType = 0;
|
||
logmodel.gtype = gtype;
|
||
new DAL.User_CZ_log().Add(logmodel);
|
||
}
|
||
else if (strs == "14")
|
||
{
|
||
daoUser.UpdateuLevel("uLevel30", 0, strID);
|
||
Model.User_CZ_log logmodel = new Model.User_CZ_log();
|
||
logmodel.MemberId = Card;
|
||
logmodel.AddTime = DateTime.Now;
|
||
logmodel.IP = Mtxfw.Utility.Common.GetIP;
|
||
logmodel.Body = "取消联盟部，用户名：" + umodel.UserName;
|
||
logmodel.UType = 0;
|
||
logmodel.gtype = gtype;
|
||
new DAL.User_CZ_log().Add(logmodel);
|
||
}
|
||
else if (strs == "15")
|
||
{
|
||
daoUser.UpdateuLevel("uLevel31", 1, strID);
|
||
Model.User_CZ_log logmodel = new Model.User_CZ_log();
|
||
logmodel.MemberId = Card;
|
||
logmodel.AddTime = DateTime.Now;
|
||
logmodel.IP = Mtxfw.Utility.Common.GetIP;
|
||
logmodel.Body = "设为不能兑换流量积分，用户名：" + umodel.UserName;
|
||
logmodel.UType = 0;
|
||
logmodel.gtype = gtype;
|
||
new DAL.User_CZ_log().Add(logmodel);
|
||
}
|
||
else if (strs == "16")
|
||
{
|
||
daoUser.UpdateuLevel("uLevel31", 0, strID);
|
||
Model.User_CZ_log logmodel = new Model.User_CZ_log();
|
||
logmodel.MemberId = Card;
|
||
logmodel.AddTime = DateTime.Now;
|
||
logmodel.IP = Mtxfw.Utility.Common.GetIP;
|
||
logmodel.Body = "取消不能兑换流量积分，用户名：" + umodel.UserName;
|
||
logmodel.UType = 0;
|
||
logmodel.gtype = gtype;
|
||
new DAL.User_CZ_log().Add(logmodel);
|
||
}
|
||
else if (strs == "17")
|
||
{
|
||
daoUser.UpdateuLevel("uLevel32", 1, strID);
|
||
Model.User_CZ_log logmodel = new Model.User_CZ_log();
|
||
logmodel.MemberId = Card;
|
||
logmodel.AddTime = DateTime.Now;
|
||
logmodel.IP = Mtxfw.Utility.Common.GetIP;
|
||
logmodel.Body = "设为不能兑换KSD，用户名：" + umodel.UserName;
|
||
logmodel.UType = 0;
|
||
logmodel.gtype = gtype;
|
||
new DAL.User_CZ_log().Add(logmodel);
|
||
}
|
||
else if (strs == "18")
|
||
{
|
||
daoUser.UpdateuLevel("uLevel32", 0, strID);
|
||
Model.User_CZ_log logmodel = new Model.User_CZ_log();
|
||
logmodel.MemberId = Card;
|
||
logmodel.AddTime = DateTime.Now;
|
||
logmodel.IP = Mtxfw.Utility.Common.GetIP;
|
||
logmodel.Body = "取消不能兑换KSD，用户名：" + umodel.UserName;
|
||
logmodel.UType = 0;
|
||
logmodel.gtype = gtype;
|
||
new DAL.User_CZ_log().Add(logmodel);
|
||
}
|
||
}
|
||
}
|
||
}
|
||
|
||
Data_Bind();
|
||
}
|
||
}
|
||
}
|
||
} |