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;*/
        }
    }
}