resetdata.ascx.cs

这是我编的一小软件。请等级等待指教。呵呵。ASP的

namespace Seaskyer.WebApp.skyNews.Pages.AdminMSC
{
	using System;
	using System.Collections;
	using System.Data;
	using System.Drawing;
	using System.Web;
	using System.Web.UI.WebControls;
	using System.Web.UI.HtmlControls;
	using Seaskyer.Strings;

	/// <summary>
	///		ResetDate : 重新统计新闻数据。
	/// </summary>
	public class ResetData : basePage
	{

		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面

			if( !user.IsAdmin )
			{
				base.strError.Add("您无权执行 “" + lang.AppName + "” 操作，详情请与管理员联系！");
				return;
			}

			Response.End();
		}

		#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

		// 响应新闻总体数据统计事件
		protected void Reset_OnClick(object sender, System.EventArgs e)
		{
			dp.CommandText = "SELECT COUNT(articleID) FROM [Article]";
			int articleNum		= dp.ScalarSQL();

			dp.CommandText = "SELECT COUNT(articleID) FROM [Article] WHERE imgNews = 1";
			int imgNewsNum		= dp.ScalarSQL();

			dp.CommandText = "SELECT COUNT(articleid) FROM [Article_nc]";
			int ncarticleNum	= dp.ScalarSQL();

			dp.CommandText = "SELECT COUNT(id) FROM [Member] WHERE passed = 1";
			int memberNum		= dp.ScalarSQL();

			dp.CommandText = "SELECT COUNT(id) FROM [Member] WHERE passed = 0";
			int ncMemberNum		= dp.ScalarSQL();

			dp.CommandText = "SELECT COUNT(topicid) FROM [Atopic]";
			int topicNum		= dp.ScalarSQL();

			Hashtable ht = new Hashtable();

			ht.Add("articleNum",	articleNum);
			ht.Add("imgNewsNum",	imgNewsNum);
			ht.Add("ncarticleNum",	ncarticleNum);
			ht.Add("memberNum",		memberNum);
			ht.Add("ncMemberNum",	ncMemberNum);
			ht.Add("topicNum",		topicNum);

			//user.UpdateSiteConst(ht);
			ht.Clear();
		}

		// 响应专题数据统计事件
		protected void ResetTopic_OnClick(object sender, System.EventArgs e)
		{
			dp.CommandText = cmd["aTopic", "SELECT_ALL"];

			DataTable dt = dp.DataTableSQL();
			for( int i = 0; i < dt.Rows.Count; i++ )
			{
				dp.CommandText = "SELECT COUNT(articleID) FROM [Article] WHERE topicid = " + dt.Rows[i]["topicid"].ToString() + "";
				int newsNum = dp.ScalarSQL();

				dp.CommandText = "UPDATE [aTopic] SET newsnum = " + newsNum + " WHERE topicid = " + dt.Rows[i]["topicid"].ToString();
				dp.NonQuerySQL();
			}
			dt.Clear();
			dt.Dispose();
		}
	
		// 响应分类信息处理事件
		protected void ResetClass_OnClick(object sender, System.EventArgs e)
		{
			//this.ResetClass();
			Cache.Remove("classCache");
		}

		// 响应新闻信息处理事件
		protected void BuildNews_OnClick(object sender, System.EventArgs e)
		{
			dp.CommandText = "SELECT Article.*, aClass.pPath FROM [Article], [aClass] WHERE (Article.classid = aClass.classID)";

			DataTable Dt = dp.DataTableSQL();

			for( int i = 0; i < Dt.Rows.Count; i++ )
			{

			}

		}
	}
}