type_manage.aspx.cs

资源大小： 116.59KB 资源类型： application 自己写个采集器 采集起来更灵活

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 MySql.Data.MySqlClient;
public partial class type_manage : System.Web.UI.Page
{
    SqlConnection con;
    SqlDataAdapter da;
    SqlCommand com;
    DataTable ds;
    DataTable dt;
    MySqlConnection mysqlcon;
    MySqlDataAdapter mysqlda;
    MySqlCommand mysqlcom;
    DataSet getdata;
    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");
        }

        if (!IsPostBack)
        {
            dt = new DataTable();
            dt = Getdata("select * from collection_type");
            addNode(this.TreeView1, dt);
            this.TreeView1.ExpandAll();
        }
    }

    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 (Exception ex)
        {
            this.Label2.Text = ex.Message.ToString();
        }
        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 void addNode(TreeView tv, DataTable dt)
    {
        try
        {
            TreeNode tn = new TreeNode();
            tn.Text = dt.Rows[0][1].ToString();
            tn.Target = dt.Rows[0][0].ToString().Trim();
            foreach (DataRow dr in dt.Rows)
            {
                if ((int)dr[0] == 0)
                {
                    continue;
                }
                aaa(dr, tv.Nodes);
            }

        }
        catch
        { }
    }

    void aaa(DataRow dr, TreeNodeCollection tnc)
    {
        foreach (TreeNode tn in tnc)
        {
            if (tn.Target.ToString() == dr[2].ToString().Trim())
            {
                TreeNode tn1 = new TreeNode();
                tn1.Text = dr[1].ToString().Trim();
                tn1.Target = dr[0].ToString().Trim();
                tn.ChildNodes.Add(tn1);
                return;
            }
            aaa(dr, tn.ChildNodes);
        }
    }

    public bool opendb()
    {
        try
        {
            con = new SqlConnection("server=192.168.1.18;database=catch;uid=zhaojie;pwd=zhaojie123");
            con.Open();
            return true;
        }
        catch
        {
        }
        return false;
    }

    //public DataTable Getdata(string sql)
    //{
    //    if (opendb())
    //    {
    //        da = new SqlDataAdapter();
    //        da.SelectCommand = new SqlCommand();
    //        da.SelectCommand.Connection = con;
    //        da.SelectCommand.CommandText = sql;
    //        ds = new DataTable();
    //        da.Fill(ds);
    //        return ds;
    //    }
    //    return null;
    //}
    public DataTable Getdata(string sql)
    {
        if (openmysqldb())
        {
            mysqlda = new MySqlDataAdapter();
            mysqlda.SelectCommand = new MySqlCommand();
            mysqlda.SelectCommand.Connection = mysqlcon; ;
            mysqlda.SelectCommand.CommandText = sql;
            ds = new DataTable();
            mysqlda.Fill(ds);
            return ds;
        }
        return null;
    }

    public DataTable openmysqldb(string sql) //mysql
    {
        if (opendb())
        {
            mysqlda = new MySqlDataAdapter();
            mysqlda.SelectCommand = new MySqlCommand();
            mysqlda.SelectCommand.Connection = mysqlcon;
            mysqlda.SelectCommand.CommandText = sql;
            ds = new DataTable();
            da.Fill(ds);
            return ds;
        }
        return null;
    }



    //public void insertdata(string sql)
    //{
    //    if (opendb())
    //    {
    //        com = new SqlCommand();
    //        com.Connection = con;
    //        com.CommandText = sql;
    //        com.ExecuteNonQuery();
    //    }
    //}
    public void insertdata(string sql) //mysql
    {
        if (openmysqldb())
        {
            mysqlcom = new MySqlCommand();
            mysqlcom.Connection = mysqlcon;
            mysqlcom.CommandText = sql;
            mysqlcom.ExecuteNonQuery();
        }
    }

    //public void deletedata(string sql)
    //{
    //    if (opendb())
    //    {
    //        com = new SqlCommand();
    //        com.Connection = con;
    //        com.CommandText = sql;
    //        com.ExecuteNonQuery();
    //    }
    //}
    public void deletedata(string sql)  //mysql
    {
        if (openmysqldb())
        {
            mysqlcom = new MySqlCommand();
            mysqlcom.Connection = mysqlcon;
            mysqlcom.CommandText = sql;
            mysqlcom.ExecuteNonQuery();
        }
    }

    //public void updatedata(string sql)
    //{
    //    if (opendb())
    //    {
    //        com = new SqlCommand();
    //        com.Connection = con;
    //        com.CommandText = sql;
    //        com.ExecuteNonQuery();
    //    }
    //}
    public void updatedata(string sql)  //mysql
    {
        if (openmysqldb())
        {
            mysqlcom = new MySqlCommand();
            mysqlcom.Connection = mysqlcon;
            mysqlcom.CommandText = sql;
            mysqlcom.ExecuteNonQuery();
        }
    }

    protected void TreeView1_SelectedNodeChanged(object sender, EventArgs e)
    {
        this.Label3.Text = this.TreeView1.SelectedNode.Text;
        this.Label3.ToolTip = this.TreeView1.SelectedNode.Target;
        this.TextBox2.Text = TreeView1.SelectedNode.Text;
        this.TextBox2.ToolTip = TreeView1.SelectedNode.Target;
        this.Label9.Text = TreeView1.SelectedNode.Text;
        this.Label9.ToolTip = TreeView1.SelectedNode.Target;
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        if (this.TextBox1.Text != "" && TreeView1.SelectedNode.Text != "")
        {
            string sql = string.Format("insert into collection_type (type_name,paternal_id) values ('{0}',{1})", this.TextBox1.Text, TreeView1.SelectedNode.Target);
            insertdata(sql);
            this.TreeView1.Nodes[0].ChildNodes.Clear();
            dt = new DataTable();
            dt = Getdata("select * from collection_type");
            addNode(this.TreeView1, dt);
            this.TreeView1.ExpandAll();
            this.Label3.Text = "请从树型菜单中选择";
            this.Label3.ToolTip = "";
            this.Label9.Text = "请从树型菜单中选择";
            this.Label9.ToolTip = "";
            this.TextBox1.Text = "";
            this.TextBox2.Text = "";
        }
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        if (this.TextBox2.Text != "")
        {
            string sql = string.Format("update collection_type set type_name='{0}' where type_id={1}", this.TextBox2.Text, this.TextBox2.ToolTip);
            updatedata(sql);
            this.TreeView1.Nodes[0].ChildNodes.Clear();
            dt = new DataTable();
            dt = Getdata("select * from collection_type");
            addNode(this.TreeView1, dt);
            this.TreeView1.ExpandAll();
            this.TextBox1.Text = "";
            this.TextBox2.Text = "";
        }
    }
    protected void Button3_Click(object sender, EventArgs e)
    {
        if (this.Label9.ToolTip != "")
        {
            this.TextBox1.Text = "";
            this.TextBox2.Text = "";
            string sql = string.Format("delete from collection_type where type_id>={0}", this.Label9.ToolTip);
            deletedata(sql);
            this.TreeView1.Nodes[0].ChildNodes.Clear();
            dt = new DataTable();
            dt = Getdata("select * from collection_type");
            addNode(this.TreeView1, dt);
            this.TreeView1.ExpandAll();
            this.Label9.Text = "请从树型菜单中选择";
            this.Label9.ToolTip = "";
            this.Label3.Text = "请从树型菜单中选择";
            this.Label3.ToolTip = "";
            this.TextBox1.Text = "";
            this.TextBox2.Text = "";
        }
    }
}