admin.cs

一阵子

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

namespace PSP
{
	/// <summary>
	/// Summary description for Admin.
	/// </summary>
	public class AdminClass
	{
		public static DataTable GetAllShowItems()
		{
			string sql = "SELECT * FROM PSP_Item WHERE isHide=0";
			DataTable dt = null;

			if(Framework.isSQL)
			{				
				dt = SqlHelper.ExecuteDataTable(Framework.SqlConnStr, CommandType.Text, sql);
			}
			else
			{
				dt = SqlHelper.ExecuteDataTable(Framework.ConnStr, sql);
			}

			return dt;
		}

		public static void SetHide(string itemID)
		{
			string sql = "UPDATE PSP_Item SET isHide=1 WHERE ItemID=" + itemID;

			if(Framework.isSQL)
			{
				SqlHelper.ExecuteNonQuery(Framework.SqlConnStr, CommandType.Text, sql);
			}
			else
			{
				SqlHelper.ExecuteNonQuery(Framework.ConnStr, sql);
			}

		}
	}
}