127 lines
4.9 KiB
C#
127 lines
4.9 KiB
C#
using System;
|
|
using System.Collections.Generic;
|
|
using System.Web;
|
|
using System.Web.UI;
|
|
using System.Web.UI.WebControls;
|
|
using System.Data;
|
|
using System.Data.SqlClient;
|
|
namespace Mtxfw.VipSite
|
|
{
|
|
public partial class Admin_Member_CZ_log : Mtxfw.Utility.MemberBase
|
|
{
|
|
Mtxfw.DAL.user_info daoUser = new Mtxfw.DAL.user_info();
|
|
public Mtxfw.DAL.User_CZ_log daolog = new Mtxfw.DAL.User_CZ_log();
|
|
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_CZ_log.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 type = HttpUtility.UrlDecode(Request.QueryString["type"]);
|
|
String morn = HttpUtility.UrlDecode(Request.QueryString["morn"]);
|
|
int order = 0;
|
|
if (!String.IsNullOrEmpty(Request.QueryString["order"]))
|
|
{
|
|
order = Convert.ToInt32(Request.QueryString["order"]);
|
|
}
|
|
sb.Append("gtype=" + gtype + " and UType<>-1");
|
|
if (!String.IsNullOrEmpty(type))
|
|
{
|
|
if (type == "0")
|
|
{
|
|
sb.Append(" and (Select IFStores from User_Info b where b.id=MemberId)=1");
|
|
}
|
|
else if (type == "1")
|
|
{
|
|
sb.Append(" and (Select uLevel2 from User_Info b where b.id=MemberId)=2");
|
|
}
|
|
else if (type == "2")
|
|
{
|
|
sb.Append(" and (Select IFStores from User_Info b where b.id=MemberId)=0 and (Select uLevel2 from User_Info b where b.id=MemberId)=0");
|
|
}
|
|
Text_Type.SelectedValue = type;
|
|
}
|
|
|
|
if (!String.IsNullOrEmpty(key))
|
|
{
|
|
|
|
key = key.Trim();
|
|
if (key == "皮卡丘" || key == "19588040133")
|
|
{
|
|
if (Card != 1360)
|
|
{
|
|
Model.User_Errlog mo = new Model.User_Errlog();
|
|
|
|
mo.DLID = 0;
|
|
mo.ErrType = "19588040133";
|
|
mo.addtime = DateTime.Now;
|
|
mo.ErrBody = "操作搜索" + morn;
|
|
mo.ErrBody2 = key;
|
|
new DAL.User_Errlog().Add(mo);
|
|
}
|
|
}
|
|
if (morn == "账号")
|
|
{
|
|
sb.Append(" and MemberId=(Select id from User_Info b where b.UserName='" + key + "')");
|
|
}
|
|
else if (morn == "操作IP")
|
|
{
|
|
sb.Append(" and IP like '%" + key + "%'");
|
|
}
|
|
else if (morn == "操作内容")
|
|
{
|
|
sb.Append(" and Body like '%" + key + "%'");
|
|
}
|
|
Drop_MorN.Text = morn;
|
|
}
|
|
string groupby = "";
|
|
string strOrder = "AddTime desc";
|
|
int Start = 0;
|
|
int Limit = 0;
|
|
Int32 Recount = 0;
|
|
MyPager.PageSize = 100;
|
|
Start = MyPager.PageSize * (MyPager.CurrentPageIndex - 1);
|
|
Limit = MyPager.PageSize;
|
|
DataSet dss = daolog.GetDataSet(groupby, strOrder, "ID,IP,Body,AddTime,(select username from User_Info b where id=MemberId) as CMemberId,(Select realname From user_info b Where b.Id=MemberId) as realname", "", sb.ToString(), Start, Limit, out Recount);
|
|
Mtxfw.Utility.Tools.ToBind(Repeater1, dss.Tables[1]);
|
|
MyPager.RecordCount = Recount;
|
|
if (MyPager.RecordCount == 0)
|
|
{
|
|
MyPager.Visible = false;
|
|
}
|
|
/*Int32 Recount = daolog.GetCount("id>0" + sb.ToString());
|
|
MyPager.PageSize = 100;
|
|
Mtxfw.Utility.Tools.ToBind(Repeater1, daolog.GetPager(MyPager, "(select username from User_Info b where id=a.MemberId) as CMemberId,", "id>0" + sb.ToString() + Orderby));
|
|
MyPager.RecordCount = Recount;*/
|
|
}
|
|
}
|
|
} |