?using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Text;
using System.IO;
using System.Data.SqlClient;
using System.Net;
using System.Text.RegularExpressions;
using MySql.Data.MySqlClient;

public partial class start_catch : System.Web.UI.Page
{
    SqlConnection con;
    SqlDataAdapter da;
    SqlCommand com;
    DataSet ds;
    //public static DataSet myds;
    //public static string guize2;
    //public static string guize3;
    //ArrayList link;
    //ArrayList title;
    //public static ArrayList acrtil1;
    savedata fds = new savedata();
    DataSet useds = new DataSet();
    MySqlConnection mysqlcon;
    MySqlDataAdapter mysqlda;
    MySqlCommand mysqlcom;
    DataSet getdata;
    DataSet myds1;
    MySqlConnection mysqlcon1;
    MySqlDataAdapter mysqlda1;
    DataSet getdata1;

    Regex regexzj;
    Regex regexwl;
    Regex regexlo;


    ArrayList link;
    ArrayList title;
    ArrayList endtitle;
    ArrayList endlink;
    static string selecturl;
    static string code;
    static string rule0;
    static string rule1;
    static string rule2;
    static string rule3;
    static string rule4;
    static string rule5;
    static string rule6;
    static string rule7;
    protected void Page_Load(object sender, EventArgs e)
    {
        HttpCookieCollection cookie = Request.Cookies;
        if (cookie.Count != 0)
        {
            for (int i = 0; i < cookie.Keys.Count; i++)
            {
                if (cookie[i].Name == "ECSCP_ID")
                {
                    DateTime DateTime1970 = new DateTime(1970, 1, 1);
                    TimeSpan t = DateTime.Now.AddHours(-8) - DateTime1970;
                    string id = cookie[i].Value.Substring(0, 32);
                    string sql = string.Format("select data from ecs_sessions where sesskey='{0}' and ip='{1}' and adminid>0", id, Request.UserHostAddress.ToString());
                    DataSet thisds = setmysqldata(sql);

                    if (thisds.Tables[0].Rows.Count != 0)
                    {
                        string mystring = thisds.Tables[0].Rows[0][0].ToString();

                        //string myadminid = mystring.Substring(mystring.IndexOf("admin_id\"") + "admin_id\"".Length);
                        //string endadminid = myadminid.Substring(myadminid.IndexOf('"') + "\"".Length);
                        //string adminid = endadminid.Substring(0, endadminid.IndexOf('"'));    //admin_id

                        //string myname = mystring.Substring(mystring.IndexOf("admin_name\"") + "admin_name\"".Length);
                        //string endname = myname.Substring(myname.IndexOf('"') + "\"".Length);
                        //string adminname = endname.Substring(0, endname.IndexOf('"'));    //admin_name

                        string mylist = mystring.Substring(mystring.IndexOf("action_list\"") + "action_list\"".Length);
                        string endlist = mylist.Substring(mylist.IndexOf('"') + "\"".Length);
                        string list = endlist.Substring(0, endlist.IndexOf('"')); //list
                        if (list.IndexOf("all") == -1)
                        {
                            if (list.IndexOf("ad_manage") == -1)
                            {
                                Response.Redirect("error.aspx");
                            }
                        }
                    }
                    else
                    {
   //                     Response.Redirect("http://test1.maodao.com:8080/admin/privilege.php?act=login");
                    }

                }
            }
        }
        else
        {
  //          Response.Redirect("http://test1.maodao.com:8080/admin/privilege.php?act=login");
        }
    }
    public bool opensql() //sql
    {
        try
        {
            string constring = string.Format("server={0};database={1};uid={2};pwd={3}", this.TextBox15.Text.Trim(), this.TextBox13.Text.Trim(), this.TextBox11.Text.Trim(), this.TextBox12.Text.Trim());
            con = new SqlConnection(constring);
            con.Open();
            return true;
        }
        catch
        { }
        return false;
    }

    public void setsqlserver(string sql)
    {
        if (opensql())
        {
            com = new SqlCommand();
            com.Connection = con;
            com.CommandText = sql;
            com.ExecuteNonQuery();
        }
    }

    public DataSet getsqldata(string sql) //sql
    {
        if (opensql())
        {
            da = new SqlDataAdapter();
            da.SelectCommand = new SqlCommand();
            da.SelectCommand.Connection = con;
            da.SelectCommand.CommandText = sql;
            ds = new DataSet();
            da.Fill(ds);
            return ds;
        }
        return null;
    }

    public DataSet getnum(string sql)  //sql
    {
        if (opensql())
        {
            da = new SqlDataAdapter();
            da.SelectCommand = new SqlCommand();
            da.SelectCommand.Connection = con;
            da.SelectCommand.CommandText = sql;
            ds = new DataSet();
            da.Fill(ds);
            return ds;
        }
        return null;
    }

    public bool openmysqldb()  //mysql
    {
        try
        {
            string constring = string.Format("server=192.168.1.18; user id=xudengke; password=xudengke123; database=shichuangshop; pooling=false;charset=gbk;");
            mysqlcon = new MySqlConnection(constring);
            mysqlcon.Open();
            return true;
        }
        catch
        {

        }
        return false;
    }

    public DataSet setmysqldata(string sql) //mysql
    {
        if (openmysqldb())
        {
            mysqlda = new MySqlDataAdapter();
            mysqlda.SelectCommand = new MySqlCommand();
            mysqlda.SelectCommand.Connection = mysqlcon;
            mysqlda.SelectCommand.CommandText = sql;
            getdata = new DataSet();
            mysqlda.Fill(getdata);
            return getdata;
        }
        return null;
    }

    public bool openmysqldbdata()  //mysql
    {
        try
        {
            string constring = string.Format("server={0}; user id={1}; password={2}; database={3}; pooling=false;charset=gbk;", this.TextBox15.Text.Trim(), this.TextBox11.Text.Trim(), this.TextBox12.Text.Trim(), this.TextBox13.Text.Trim());
            mysqlcon1 = new MySqlConnection(constring);
            mysqlcon1.Open();
            return true;
        }
        catch(Exception ex)
        {
            Response.Write(ex.Message);
        }
        return false;
    }

    public void setinsertdata(string sql) //mysql
    {
        if (openmysqldbdata())
        {
            mysqlcom = new MySqlCommand();
            mysqlcom.Connection = mysqlcon1;
            mysqlcom.CommandText = sql;
            mysqlcom.ExecuteNonQuery();
        }
    }

    public DataSet getmysqldata(string sql) //mysql
    {
        if (openmysqldbdata())
        {
            mysqlda1 = new MySqlDataAdapter();
            mysqlda1.SelectCommand = new MySqlCommand();
            mysqlda1.SelectCommand.Connection = mysqlcon1;
            mysqlda1.SelectCommand.CommandText = sql;
            getdata1 = new DataSet();
            mysqlda1.Fill(getdata1);
            return getdata1;
        }
        return null;
    }

    public DataSet getmysqlnum(string sql)  //mysql
    {
        if (openmysqldbdata())
        {
            mysqlda1 = new MySqlDataAdapter();
            mysqlda1.SelectCommand = new MySqlCommand();
            mysqlda1.SelectCommand.Connection = mysqlcon1;
            mysqlda1.SelectCommand.CommandText = sql;
            myds1 = new DataSet();
            mysqlda1.Fill(myds1);
            return myds1;
        }
        return null;
    }

   

    protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        if (e.CommandName.ToString() == "Select")
        {
            this.Panel1.Visible = true;
            this.Label2.Text = ((Label)(this.GridView1.Rows[int.Parse(e.CommandArgument.ToString())].FindControl("Label2"))).Text;
            selecturl = ((Label)(this.GridView1.Rows[int.Parse(e.CommandArgument.ToString())].FindControl("Label4"))).Text;
            code = ((Label)(this.GridView1.Rows[int.Parse(e.CommandArgument.ToString())].FindControl("Label5"))).Text;
            rule0 = ((Label)(this.GridView1.Rows[int.Parse(e.CommandArgument.ToString())].FindControl("Label6"))).Text;
            rule1 = ((Label)(this.GridView1.Rows[int.Parse(e.CommandArgument.ToString())].FindControl("Label7"))).Text;
            rule2 = ((Label)(this.GridView1.Rows[int.Parse(e.CommandArgument.ToString())].FindControl("Label8"))).Text;
            rule3 = ((Label)(this.GridView1.Rows[int.Parse(e.CommandArgument.ToString())].FindControl("Label9"))).Text;
            rule4 = ((Label)(this.GridView1.Rows[int.Parse(e.CommandArgument.ToString())].FindControl("Label10"))).Text;
            rule5 = ((Label)(this.GridView1.Rows[int.Parse(e.CommandArgument.ToString())].FindControl("Label11"))).Text;
            rule6 = ((Label)(this.GridView1.Rows[int.Parse(e.CommandArgument.ToString())].FindControl("Label12"))).Text;
            rule7 = ((Label)(this.GridView1.Rows[int.Parse(e.CommandArgument.ToString())].FindControl("Label13"))).Text;
            this.Panel2.Visible = false;
            this.Panel3.Visible = false;
            this.Panel4.Visible = false;
            this.TextBox3.Text = "";
            this.TextBox4.Text = "";
        }
      //  {
      //      if (((Label)(GridView1.Rows[int.Parse(e.CommandArgument.ToString())].FindControl("Label2"))).Text == "交友")
     //       {
     //           Response.Redirect("jiaoyou.aspx");
     //       }
     //       else
    //       {
    //            string sql = string.Format("select * from collection_rule where rule_id={0}", ((Label)(GridView1.Rows[int.Parse(e.CommandArgument.ToString())].FindControl("Label1"))).Text);
                //myds = new DataSet();
                //myds = Getdata(sql);
                //this.ListBox1.Items.Clear();
                //savedata.arctitle.Clear();
                //savedata.linkstor.Clear();
                //string[] usemyurl = myds.Tables[0].Rows[0][5].ToString().Split(' ');
                //this.Label4.Visible = true;
                //this.Label5.Visible = true;
                //guize2 = myds.Tables[0].Rows[0][7].ToString().Trim();
                //guize3 = myds.Tables[0].Rows[0][8].ToString().Trim();
                //this.Label5.Text = ((Label)(GridView1.Rows[int.Parse(e.CommandArgument.ToString())].FindControl("Label2"))).Text;
                //try
                //{