area.cs

房产房产中介网站系统源码 前台板块有：会员中心 | 出租信息 | 出售信息 | 求租信息 | 求购信息 | 信息查询 可以进行用户注册并进行租售房屋的信息发布

using System;
using System.Data;
using System.Data.SqlClient;
using HouseSystem.SQLDAL;

namespace HouseSystem.Components
{
	/// <summary>
	/// Area 的摘要说明。
	/// </summary>
	public class Area
	{
		public static int AddArea(string Area_Name, int Area_OrderID)
		{
			if (Area_Name.Trim() == string.Empty)
			{
				throw new Exception("名称读取发生错误！");
			}
			if (Area.IsExistArea(Area_Name))
			{
				return -1;
			}
			object[] objArray1 = new object[5] { "INSERT INTO [Area] ([Area_Name],[Area_OrderID]) VALUES ('", Tools.CheckStrInput(Area_Name), "',", Area_OrderID, ")" } ;
			string text1 = string.Concat(objArray1);
			return SQLHelper.ExecuteNonQuery(text1);
		}
 
		public static int DeleteArea(int Area_ID)
		{
			string text1 = "";
			if (Config.GetDbType == DbType.Access)
			{
				text1 = "DELETE * FROM [Area] WHERE Area_ID=" + Area_ID;
			}
			else
			{
				text1 = "DELETE FROM [Area] WHERE Area_ID=" + Area_ID;
			}
			return SQLHelper.ExecuteNonQuery(text1);
		}
 
		public static DataTable GetAllAreaList()
		{
			string text1 = "SELECT Area_ID, Area_Name, Area_OrderID FROM Area ORDER BY Area_OrderID;";
			string text2 = Config.GetConnectionString();
			DataSet set1 = SQLHelper.ExecuteDataset(text2, CommandType.Text, text1, new SqlParameter[0]);
			if (set1.Tables.Count > 0)
			{
				return set1.Tables[0];
			}
			return null;
		}
 
		public static string GetAreaNameByID(int Area_ID)
		{
			string text1 = "SELECT Area_Name FROM Area WHERE Area_ID=" + Area_ID + "";
			object obj1 = SQLHelper.ExecuteScalar(text1);
			if (obj1 != null)
			{
				return obj1.ToString();
			}
			return "";
		}
 
		public static bool IsExistArea(string Area_Name)
		{
			string text1 = Config.GetConnectionString();
			string text2 = "SELECT COUNT(*) AS T FROM Area WHERE Area_Name= '" + Area_Name + "';";
			int num1 = (int) SQLHelper.ExecuteScalar(text1, CommandType.Text, text2, new SqlParameter[0]);
			if (num1 > 0)
			{
				return true;
			}
			return false;
		}
 
		public static bool IsExistArea(string Area_Name, int Area_ID)
		{
			string text1 = Config.GetConnectionString();
			object[] objArray1 = new object[5] { "SELECT COUNT(*) AS T FROM Area WHERE Area_ID <> ", Area_ID, " AND Area_Name= '", Area_Name, "';" } ;
			string text2 = string.Concat(objArray1);
			int num1 = (int) SQLHelper.ExecuteScalar(text1, CommandType.Text, text2, new SqlParameter[0]);
			if (num1 > 0)
			{
				return true;
			}
			return false;
		}
 
		public static int UpdateArea(string Area_Name, int Area_OrderID, int Area_ID)
		{
			object[] objArray1 = new object[6] { "UPDATE [Area] SET [Area_Name] = '", Tools.CheckStrInput(Area_Name), "',[Area_OrderID] = ", Area_OrderID, " WHERE Area_ID=", Area_ID } ;
			string text1 = string.Concat(objArray1);
			return SQLHelper.ExecuteNonQuery(text1);
		}
 	}
}