xgcounter.aspx.cs

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

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
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>
	/// xgcounter 的摘要说明。
	/// </summary>
	public class xgcounter : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.DataList counterinfo;
		protected System.Web.UI.HtmlControls.HtmlForm Form1;
		public static DataView dv;
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if(Session["master"]==null) Session["master"]="";
			if(Session["master"].ToString() != "master") Response.Redirect("help.aspx?error=你不是管理员，无权进入本页面。。");

			if(!Page.IsPostBack)
			{
				ListBind();
			}
		}

		public void ListBind()
		{
			DataSet myds = new DataSet();
			myds = counter.SQLConn.ExecuteSqlForDataSet("select * from CounterInfo");
			dv=myds.Tables[0].DefaultView;
			counterinfo.DataSource = dv;
			counterinfo.DataBind();
		}
		
		public void DataList_ItemDataBound(Object sender,DataListItemEventArgs e)
		{
			if(e.Item.ItemType == ListItemType.EditItem )
			{
				string [] myflag={"True","False"};
				string [] myflag1={"1","0"};

				//左侧显示
				for(int i=0;i<2;i++)
				{
					if(myflag[i] == dv[0].Row["yesleft"].ToString())
					{
						((DropDownList)e.Item.FindControl("dlyesleft")).Items.FindByValue(myflag1[i]).Selected=true;
					}
					else
					{
						((DropDownList)e.Item.FindControl("dlyesleft")).Items.FindByValue(myflag1[i]).Selected=false;
					}
				}

				//导航栏位置
				for(int i=0;i<3;i++)
				{
					if(i == int.Parse(dv[0].Row["yestop"].ToString()))
					{
						((DropDownList)e.Item.FindControl("dlyestop")).Items.FindByValue(i.ToString()).Selected=true;
					}
					else
					{
						((DropDownList)e.Item.FindControl("dlyestop")).Items.FindByValue(i.ToString()).Selected=false;
					}
				}

				//授权显示
				for(int i=0;i<2;i++)
				{
					if(myflag[i] == dv[0].Row["yesto"].ToString())
					{
						((DropDownList)e.Item.FindControl("dlyesto")).Items.FindByValue(myflag1[i]).Selected=true;
					}
					else
					{
						((DropDownList)e.Item.FindControl("dlyesto")).Items.FindByValue(myflag1[i]).Selected=false;
					}
				}

				//IP防刷新
				for(int i=0;i<2;i++)
				{
					if(myflag[i] == dv[0].Row["is_ipcheck"].ToString())
					{
						((DropDownList)e.Item.FindControl("dlis_ipcheck")).Items.FindByValue(myflag1[i]).Selected=true;
					}
					else
					{
						((DropDownList)e.Item.FindControl("dlis_ipcheck")).Items.FindByValue(myflag1[i]).Selected=false;
					}
				}

				//在线统计
				for(int i=0;i<2;i++)
				{
					if(myflag[i] == dv[0].Row["is_online"].ToString())
					{
						((DropDownList)e.Item.FindControl("dlis_online")).Items.FindByValue(myflag1[i]).Selected=true;
					}
					else
					{
						((DropDownList)e.Item.FindControl("dlis_online")).Items.FindByValue(myflag1[i]).Selected=false;
					}
				}
			}
		}


		public void DataList_EditCommand(Object sender,DataListCommandEventArgs e)
		{
			counterinfo.EditItemIndex = (int)e.Item.ItemIndex;
			ListBind();
		}

		public void DataList_CancelCommand(Object sender,DataListCommandEventArgs e)
		{
			counterinfo.EditItemIndex = -1;
			ListBind();
		}

		public void DataList_UpdateCommand(Object sender,DataListCommandEventArgs e)
		{
			string newprogramname =((TextBox)e.Item.FindControl("tbprogramname")).Text;
			int newyesleft =int.Parse(((DropDownList)e.Item.FindControl("dlyesleft")).SelectedValue);
			int newyestop =int.Parse(((DropDownList)e.Item.FindControl("dlyestop")).SelectedValue);
			int newyesto =int.Parse(((DropDownList)e.Item.FindControl("dlyesto")).SelectedValue);
			int newwhatcan=int.Parse(((TextBox)e.Item.FindControl("tbwhatcan")).Text);
			int newCookieExpires=int.Parse(((TextBox)e.Item.FindControl("tbCookieExpires")).Text);
			int newadjtime=int.Parse(((TextBox)e.Item.FindControl("tbadjtime")).Text);
			int newold_count=int.Parse(((TextBox)e.Item.FindControl("tbold_count")).Text);			
			int newis_ipcheck =int.Parse(((DropDownList)e.Item.FindControl("dlis_ipcheck")).SelectedValue);
			int newis_online =int.Parse(((DropDownList)e.Item.FindControl("dlis_online")).SelectedValue);
			string newonlythesite1=((TextBox)e.Item.FindControl("tbonlythesite1")).Text;
			string newonlythesite2=((TextBox)e.Item.FindControl("tbonlythesite2")).Text;
			int newFlashWidth=int.Parse(((TextBox)e.Item.FindControl("tbFlashWidth")).Text);
			int newFlashHeight=int.Parse(((TextBox)e.Item.FindControl("tbFlashHeight")).Text);
			int newmPageSize=int.Parse(((TextBox)e.Item.FindControl("tbmPageSize")).Text);
			int newmPrecision=int.Parse(((TextBox)e.Item.FindControl("tbmPrecision")).Text);
			string newmyURL=((TextBox)e.Item.FindControl("tbmyURL")).Text;
			string newmyName=((TextBox)e.Item.FindControl("tbmyName")).Text;
			string newmyNameEn=((TextBox)e.Item.FindControl("tbmyNameEn")).Text;
			string newadminName=((TextBox)e.Item.FindControl("tbadminName")).Text;
			string newadminPass=((TextBox)e.Item.FindControl("tbadminPass")).Text;
			string newmasterEmail=((TextBox)e.Item.FindControl("tbmasterEmail")).Text;
			string newSiteBrief=((TextBox)e.Item.FindControl("tbSiteBrief")).Text;
			string newcopyright=((TextBox)e.Item.FindControl("tbcopyright")).Text;

			//更新数据库中的数据
			string strUpdate = "Update CounterInfo Set programname=N'" + newprogramname +"',";
			strUpdate+="yesleft=" + newyesleft + ",";
			strUpdate+="yestop=" + newyestop + ",";
			strUpdate+="yesto=" + newyesto + ",";
			strUpdate+="whatcan=" + newwhatcan + ",";
			strUpdate+="CookieExpires=" + newCookieExpires + ",";
			strUpdate+="adjtime=" + newadjtime + ",";
			strUpdate+="old_count=" + newold_count + ",";
			strUpdate+="is_ipcheck=" + newis_ipcheck + ",";
			strUpdate+="is_online=" + newis_online + ",";
			strUpdate+="onlythesite1=N'" + newonlythesite1 + "',";
			strUpdate+="onlythesite2=N'" + newonlythesite2 + "',";
			strUpdate+="FlashWidth=" + newFlashWidth + ",";
			strUpdate+="FlashHeight=" + newFlashHeight + ",";
			strUpdate+="mPageSize=" + newmPageSize + ",";
			strUpdate+="mPrecision=" + newmPrecision + ",";
			strUpdate+="myURL=N'" + newmyURL + "',";
			strUpdate+="myName=N'" + newmyName + "',";
			strUpdate+="myNameEn=N'" + newmyNameEn + "',";
			strUpdate+="adminName=N'" + newadminName + "',";
			strUpdate+="adminPass=N'" + newadminPass + "',";
			strUpdate+="masterEmail=N'" + newmasterEmail + "',";
			strUpdate+="SiteBrief=N'" + newSiteBrief + "',";
			strUpdate+="copyright=N'" + newcopyright + "'";
			
			counter.SQLConn.ExecuteSql(strUpdate);
	
			counterinfo.EditItemIndex = -1;
			ListBind();
		}




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

		}
		#endregion

		private void counterinfo_SelectedIndexChanged(object sender, System.EventArgs e)
		{
		
		}
	}
}