install.aspx.cs

尚都shangdu新闻后台管理程序,可做各种网站新闻发布

using System;
using System.IO;
using System.Text.RegularExpressions;
using System.Data;
using System.Runtime;
using System.Data.SqlClient;
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;

public partial class install_install : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        Label1.Text = "";
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
                if (TextBox1.Text == "")
        {
            Label1.Text = "管理员用户名不能为空";
        }
        else if (TextBox2.Text == "")
        {
            Label1.Text = "管理员密码不能为空";
        }
        else
        {
            SqlConnection con = db.CreateConnection();
            con.Open();
            SqlCommand create = new SqlCommand("create table admin (bh int primary key not null identity,name varchar(50),password varchar(100),aleave varchar(50),quanxian varchar(50),safepass varchar(50))", con);
            create.ExecuteNonQuery();
            con.Close();

            SqlConnection con1 = db.CreateConnection();
            con1.Open();
            SqlCommand create1 = new SqlCommand("create table bigclass (bh int primary key not null identity,bigclassname varchar(50),admin varchar(50),admin_name varchar(50),admin_pic varchar(50),admin_infor varchar(200),admin_website varchar(100))", con1);
            create1.ExecuteNonQuery();
            con1.Close();

            SqlConnection con2 = db.CreateConnection();
            con2.Open();
            SqlCommand create2 = new SqlCommand("create table download_class (bh int primary key not null identity,classname varchar(100))", con2);
            create2.ExecuteNonQuery();
            con2.Close();

            SqlConnection con3 = db.CreateConnection();
            con3.Open();
            SqlCommand create3 = new SqlCommand("create table downloads (bh int primary key not null identity,name varchar(50),pic varchar(200),infor text,banquan varchar(50),kaifa varchar(50),time datetime,leixing varchar(50),dengji varchar(50),admin varchar(50),place varchar(100),bigclassname varchar(50),tag varchar(50),xiangguan varchar(50),hits int)", con3);
            create3.ExecuteNonQuery();
            con3.Close();

            SqlConnection con4 = db.CreateConnection();
            con4.Open();
            SqlCommand create4 = new SqlCommand("create table example (bh int primary key not null identity,example text,name varchar(50),place varchar(200))", con4);
            create4.ExecuteNonQuery();
            con4.Close();

            SqlConnection con5 = db.CreateConnection();
            con5.Open();
            SqlCommand create5 = new SqlCommand("create table friends (bh int primary key not null identity,lianjie_name varchar(50),lianjie_infor varchar(300),lianjie_url varchar(100),lianjie_pic varchar(100))", con5);
            create5.ExecuteNonQuery();
            con5.Close();

            SqlConnection con6 = db.CreateConnection();
            con6.Open();
            SqlCommand create6 = new SqlCommand("create table gbook (bh int primary key not null identity,name varchar(50),title varchar(50),e_mail varchar(50),content varchar(1000),id int,time datetime,user_title varchar(50))", con6);
            create6.ExecuteNonQuery();
            con6.Close();

            SqlConnection con7 = db.CreateConnection();
            con7.Open();
            SqlCommand create7 = new SqlCommand("create table gonggao (bh int primary key not null identity,title varchar(50),content varchar(500))", con7);
            create7.ExecuteNonQuery();
            con7.Close();

            SqlConnection con8 = db.CreateConnection();
            con8.Open();
            SqlCommand create8 = new SqlCommand("create table news (bh int primary key not null identity,title varchar(50),time datetime,bigclassname varchar(50),smallclassname varchar(50),content text,hits int,author varchar(50),url varchar(100),xiangguan varchar(50),tag varchar(50),infor varchar(50),color varchar(50),hide varchar(50),good int,middle int,bad int,user_tete varchar(50))", con8);
            create8.ExecuteNonQuery();
            con8.Close();

            SqlConnection con9 = db.CreateConnection();
            con9.Open();
            SqlCommand create9 = new SqlCommand("create table shop_class (bh int primary key not null identity,classname varchar(50))", con9);
            create9.ExecuteNonQuery();
            con9.Close();

            SqlConnection con10 = db.CreateConnection();
            con10.Open();
            SqlCommand create10 = new SqlCommand("create table shops (bh int primary key not null identity,shop_name varchar(50),shop_infor varchar(50),shop_pic varchar(200),shop_money int,shop_place varchar(200),sell_time datetime,sell_end_time datetime,seller_name varchar(50),seller_qq varchar(50),seller_phone varchar(50),seller_email varchar(50),seller_first_money int,easy_infor varchar(50),tag varchar(50),xiangguan varchar(50),hot varchar(50),hits int,bigclassname varchar(50))", con10);
            create10.ExecuteNonQuery();
            con10.Close();

            SqlConnection con11 = db.CreateConnection();
            con11.Open();
            SqlCommand create11 = new SqlCommand("create table tag (bh int primary key not null identity,tag varchar(50))", con11);
            create11.ExecuteNonQuery();
            con11.Close();

            SqlConnection con12 = db.CreateConnection();
            con12.Open();
            SqlCommand create12 = new SqlCommand("create table usertete (bh int primary key not null identity,name varchar(50),password varchar(50),admin varchar(50),money int,qq varchar(50),email varchar(50),age int,last_login_time datetime)", con12);
            create12.ExecuteNonQuery();
            con12.Close();

            SqlConnection contete = db.CreateConnection();
            contete.Open();
            string password = FormsAuthentication.HashPasswordForStoringInConfigFile(TextBox2.Text, "MD5");
            string strsql = "insert into admin (name,password) values ('" + TextBox1.Text + "','" + password + "')";
            SqlCommand cmdtete = new SqlCommand(strsql, contete);
            cmdtete.ExecuteNonQuery();
            contete.Close();

            SqlConnection contete1 = db.CreateConnection();
            contete1.Open();
            string strsql1 = "insert into example (example) values ('欢迎使用shangducms NT 正式版,我们希望您能先编写好模板,然后再导入此文本框内,刷新新闻.')";
            SqlCommand cmdtete1 = new SqlCommand(strsql1, contete1);
            cmdtete1.ExecuteNonQuery();
            contete1.Close();

            SqlConnection contete2 = db.CreateConnection();
            contete2.Open();
            string strsql2 = "insert into example (example) values ('欢迎使用shangducms NT 正式版,我们希望您能先编写好模板,然后再导入此文本框内')";
            SqlCommand cmdtete2 = new SqlCommand(strsql2, contete2);
            cmdtete2.ExecuteNonQuery();
            contete2.Close();

            SqlConnection contete3 = db.CreateConnection();
            contete3.Open();
            string strsql3 = "insert into example (example) values ('欢迎使用shangducms NT 正式版,我们希望您能先编写好模板,然后再导入此文本框内')";
            SqlCommand cmdtete3 = new SqlCommand(strsql3, contete3);
            cmdtete3.ExecuteNonQuery();
            contete3.Close();

            Label1.Text = "安装成功:请删除install文件夹以保障您的网站安全!管理员登录路径admin/get_your_passport.aspx.";
        }
    }
}