data_setup.aspx.cs

阿江酷站统计系统ASP.Net版,可以直接使用。和现有的网站合并就可以了。提供详细的IP分析。

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.OleDb;
using System.Data.SqlClient;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;

namespace counter
{
	/// <summary>
	/// data_setup 的摘要说明。
	/// </summary>
	public class data_setup : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Panel setupprocess;
		protected System.Web.UI.WebControls.Panel startsetup;
		public string strSql="";
		public DataSet myds1;
		public DataView dv1;
	
		private void Page_Load(object sender, System.EventArgs e)
		{			
			myds1=new DataSet();
			dv1=new DataView();

			if(Page.IsPostBack)
			{
				startsetup.Visible=false;
				setupprocess.Visible=true;

				CreatTable();
			}
			else
			{
				startsetup.Visible=true;
				setupprocess.Visible=false;
			}

		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void CreatTable()
		{
			//删除CountContent表
			strSql="if exists (select * from sysobjects where id = object_id(N'[CountContent]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [CountContent]";
			counter.SQLConn.ExecuteSql(strSql);

			//创建CountContent表
			strSql="CREATE TABLE [CountContent] (";
			strSql+="[today] [bigint] NULL ,";
			strSql+="[yesterday] [bigint] NULL ,";
			strSql+="[vdate] [datetime] NULL ,";
			strSql+="[vtop] [bigint] NULL ,";
			strSql+="[starttime] [smalldatetime] NULL ,";
			strSql+="[vhigh] [bigint] NULL ,";
			strSql+="[vhightime] [datetime] NULL ";
			strSql+=") ON [PRIMARY]";
			counter.SQLConn.ExecuteSql(strSql);

			//删除CounterView.sql表
			strSql="if exists (select * from sysobjects where id = object_id(N'[CounterView]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [CounterView]";
			counter.SQLConn.ExecuteSql(strSql);

			//创建CounterView.sql表
			strSql="CREATE TABLE [CounterView] (";
			strSql+="[id] [bigint] IDENTITY (1, 1) NOT NULL ,";
			strSql+="[vyear] [int] NULL ,";
			strSql+="[vmonth] [int] NULL ,";
			strSql+="[vday] [int] NULL ,";
			strSql+="[vhour] [int] NULL ,";
			strSql+="[vtime] [smalldatetime] NULL ,";
			strSql+="[vweek] [int] NULL ,";
			strSql+="[vip] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,";
			strSql+="[vwhere] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,";
			strSql+="[vwheref] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,";
			strSql+="[vcome] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,";
			strSql+="[vpage] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,";
			strSql+="[vsoft] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,";
			strSql+="[vOS] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,";
			strSql+="[vwidth] [smallint] NULL ,";
			strSql+="[bakdays] [bit] NOT NULL ,";
			strSql+="[bakstats] [bit] NOT NULL ,";
			strSql+="[bakpage] [bit] NOT NULL ,";
			strSql+="PRIMARY KEY (id)) ON [PRIMARY]";
			counter.SQLConn.ExecuteSql(strSql);

			//删除CounterInfo表
			strSql="if exists (select * from sysobjects where id = object_id(N'[CounterInfo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [CounterInfo]";
			counter.SQLConn.ExecuteSql(strSql);

			//创建CounterInfo表
			strSql="CREATE TABLE [CounterInfo] (";
			strSql+="[programname] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,";
			strSql+="[yesleft] [bit] NOT NULL ,";
			strSql+="[yestop] [int] NULL ,";
			strSql+="[yesto] [bit] NOT NULL ,";
			strSql+="[whatcan] [int] NULL ,";
			strSql+="[CookieExpires] [int] NULL ,";
			strSql+="[adjtime] [int] NULL ,";
			strSql+="[old_count] [int] NULL ,";
			strSql+="[is_ipcheck] [bit] NOT NULL ,";
			strSql+="[is_online] [bit] NOT NULL ,";
			strSql+="[onlythesite1] [nvarchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,";
			strSql+="[onlythesite2] [nvarchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,";
			strSql+="[FlashWidth] [int] NULL ,";
			strSql+="[FlashHeight] [int] NULL ,";
			strSql+="[mPageSize] [int] NULL ,";
			strSql+="[mPrecision] [int] NULL ,";
			strSql+="[myURL] [nvarchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,";
			strSql+="[myName] [nvarchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,";
			strSql+="[myNameEn] [nvarchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,";
			strSql+="[adminName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,";
			strSql+="[adminPass] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,";
			strSql+="[masterEmail] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,";
			strSql+="[SiteBrief] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,";
			strSql+="[copyright] [nvarchar] (150) COLLATE Chinese_PRC_CI_AS NULL ";
			strSql+=") ON [PRIMARY]";
			counter.SQLConn.ExecuteSql(strSql);

			//添加数据到CounterInfo表
			strSql="insert into CounterInfo values(N'阿江酷站统计系统 ASP.Net 版',";
			strSql+="1,";
			strSql+="0,";
			strSql+="0,";
			strSql+="4,";
			strSql+="100,";
			strSql+="0,";
			strSql+="0,";
			strSql+="0,";
			strSql+="1,";
			strSql+="N'',";
			strSql+="N'',";
			strSql+="130,";
			strSql+="58,";
			strSql+="15,";
			strSql+="5,";
			strSql+="N'',";
			strSql+="N'阿江酷站统计系统 ASP.Net 版',";
			strSql+="N'The Cool Site',";
			strSql+="N'1',";
			strSql+="N'1',";
			strSql+="N'[e-mail]',";
			strSql+="N'访问统计系统',";
			strSql+="N'Copyright 2004-2005 小浪头')";
			counter.SQLConn.ExecuteSql(strSql);

			//删除mysave表
			strSql="if exists (select * from sysobjects where id = object_id(N'[mysave]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [mysave]";
			counter.SQLConn.ExecuteSql(strSql);
			
			//创建mysave表
			strSql="CREATE TABLE [mysave] (";
			strSql+="[id] [bigint] IDENTITY (1, 1) NOT NULL ,";
			strSql+="[name] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,";
			strSql+="[content] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,";
			strSql+="[wherestr] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,";
			strSql+="[outtype] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,";
			strSql+="PRIMARY KEY (id)) ON [PRIMARY]";
			counter.SQLConn.ExecuteSql(strSql);

			//删除ip表
			strSql="if exists (select * from sysobjects where id = object_id(N'[ip]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [ip]";
			counter.SQLConn.ExecuteSql(strSql);

			//创建ip表
			strSql="CREATE TABLE [ip] (";
			strSql+="[ID] [bigint] NOT NULL ,";
			strSql+="[onip] [bigint] NULL ,";
			strSql+="[offip] [bigint] NULL ,";
			strSql+="[addj] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,";
			strSql+="[addf] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,";
			strSql+="PRIMARY KEY (ID)) ON [PRIMARY]";
			counter.SQLConn.ExecuteSql(strSql);

			string strMdbSql="select * from ip";
			//读取ip.mdb数据库中的ip归属地信息==start
			string strMdbConnString=System.Web.HttpContext.Current.Server.MapPath(".");
			strMdbConnString="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + strMdbConnString + "\\ip.mdb;";
			OleDbConnection MyMdbConn = new OleDbConnection(strMdbConnString);
			MyMdbConn.Open();
			OleDbDataAdapter MyMdbAdapter = new OleDbDataAdapter(strMdbSql,MyMdbConn);
			MyMdbAdapter.Fill(myds1);
			MyMdbConn.Close();
			dv1=myds1.Tables[0].DefaultView;
			dv1.Table.AcceptChanges();
			//读取ip.mdb数据库中的ip归属地信息==end

			for(int i=0;i<dv1.Count;i++)
			{
				long lgreadipid=long.Parse(dv1[i].Row["ID"].ToString());
				long lgreadonip=long.Parse(dv1[i].Row["onip"].ToString());
				long lgreadoffip=long.Parse(dv1[i].Row["offip"].ToString());
				string strreadaddj=dv1[i].Row["addj"].ToString();
				string strreadaddf=dv1[i].Row["addf"].ToString();

				//写入ip信息到服务器数据库ip表

				strSql="insert into ip values("+lgreadipid+",";
				strSql+=lgreadonip+",";
				strSql+=lgreadoffip+",";
				strSql+="N'"+strreadaddj+"',";
				strSql+="N'"+strreadaddf+"')";
				counter.SQLConn.ExecuteSql(strSql);
				
			}

			dv1.Dispose();
		}
	}
}