misc.cs

一阵子

using System;
using System.Data.OleDb;
using System.Data;
using System.Data.SqlClient;

namespace PSP
{
	/// <summary>
	/// Summary description for MISC.
	/// </summary>
	public class MISC
	{
		public static string GetTodayPosts()
		{
			string sql = "";

			if(Framework.isSQL)
			{
				sql = "select count(*) from PSP_Item WHERE DATEADD(day, 1, PSP_Item.CreatedDate) >= getdate() " ;
				return SqlHelper.ExecuteDataTable(Framework.SqlConnStr, CommandType.Text, sql).Rows[0][0].ToString();
			}
			else
			{
				sql = "select count(*) from PSP_Item WHERE DATEADD('d', 1, PSP_Item.CreatedDate) >= now() " ;
				return SqlHelper.ExecuteDataTable(Framework.ConnStr,sql).Rows[0][0].ToString();
			}
		}

		public static string GetTotalUsers()
		{
			string sql = "select count(*) from PSP_User";
			if(Framework.isSQL)
			{
				return SqlHelper.ExecuteDataTable(Framework.SqlConnStr, CommandType.Text,sql).Rows[0][0].ToString();
			}
			else
			{
				return SqlHelper.ExecuteDataTable(Framework.ConnStr,sql).Rows[0][0].ToString();
			}
		}

		public static string GetTotalItems()
		{
			string sql = "select count(*) from PSP_Item";
			if(Framework.isSQL)
			{
				return SqlHelper.ExecuteDataTable(Framework.SqlConnStr, CommandType.Text,sql).Rows[0][0].ToString();
			}
			else
			{
				return SqlHelper.ExecuteDataTable(Framework.ConnStr,sql).Rows[0][0].ToString();
			}
		}

		public static string GetTotalComments()
		{
			string sql = "select count(*) from PSP_Comment";
			if(Framework.isSQL)
			{
				return SqlHelper.ExecuteDataTable(Framework.SqlConnStr, CommandType.Text,sql).Rows[0][0].ToString();
			}
			else
			{
				return SqlHelper.ExecuteDataTable(Framework.ConnStr,sql).Rows[0][0].ToString();
			}
		}

		//For Admin
		public static void Stat_AddItem(string url, string refer)
		{
			string sql = "Stat_AddItem";
			SqlParameter[] p = 
				{
					SqlHelper.MakeInParam("@url",SqlDbType.VarChar,300, url),
					SqlHelper.MakeInParam("@refer",SqlDbType.VarChar,300, refer)
				};
			SqlHelper.ExecuteNonQuery(Framework.SqlConnStr, CommandType.StoredProcedure, sql,p);
		}

	}
}