rentsell.cs

本系统是二手房交易系统 采用asp.net技术 开发环境是vs2003+sqlServer2000

using System;
using System.Data;
using HouseSystem.SQLDAL;
using HouseSystem.Modal;

namespace HouseSystem.Components
{
	/// <summary>
	/// RentSell 的摘要说明。
	/// </summary>
	public class RentSell
	{
		public static int Add(HouseInfo entity)
		{
			int num2;
			object[] objArray1 = new object[0x2f] { 
													  "INSERT INTO RentSell(Type ,User_ID ,Area_ID ,Ht_ID ,IsAgency ,Addr ,Square ,Price ,Direction ,floor1 ,floor2 ,FYHX ,ZXQK ,JCSS ,PTSS ,JTQK ,Other ,LinkMan ,Tel1 ,Tel2 ,Email ,Expire ,IpAddr) VALUES (", entity.Type, " ,", entity.UserID, ",", entity.AreaID, " ,", entity.HtID, " ,", entity.IsAgency, " ,'", entity.Addr, "' ,", entity.Square, " ,", entity.Price, 
													  " ,'", entity.Direction, "' ,", entity.Floor1, " ,", entity.Floor2, " ,'", entity.FYHX, "' ,'", entity.ZXQK, "' ,'", entity.JCSS, "' ,'", entity.PTSS, "' ,'", entity.JTQK, 
													  "' ,'", entity.Other, "' ,'", entity.LinkMan, "' ,'", entity.Tel1, "' ,'", entity.Tel2, "' ,'", entity.Email, "' ,", entity.Expire, ",'", entity.IpAddr, "')"
												  } ;
			string text1 = string.Concat(objArray1);
			try
			{
				int num1 = SQLHelper.ExecuteNonQuery(text1);
				num2 = num1;
			}
			catch (Exception exception1)
			{
				num2 = -99;
			}
			return num2;
		}
 
		public static int Del(int ID)
		{
			string text1 = "DELETE FROM RentSell WHERE ID=" + ID;
			return SQLHelper.ExecuteNonQuery(text1);
		}
 
		public static int Del(int ID, int UserId)
		{
			object[] objArray1 = new object[5] { "DELETE FROM RentSell WHERE ID=", ID, " AND User_ID = ", UserId, "" } ;
			string text1 = string.Concat(objArray1);
			return SQLHelper.ExecuteNonQuery(text1);
		}
 
		public static DataTable GetAllHouseList()
		{
			string text1 = "SELECT ID, Type ,Area_ID ,Ht_ID ,IsAgency ,Addr ,Square ,Price , FYHX ,AddTime FROM RentSell WHERE State=1 ORDER BY ID DESC";
			return SQLHelper.ExecuteDataTable(text1);
		}
 
		public static DataRow GetHouseDetail(int ID)
		{
			string text1 = "SELECT * FROM RentSell WHERE ID=" + ID;
			return SQLHelper.ExecuteDataRow(text1);
		}
 
		public static DataRow GetHouseDetail(int ID, int UserId)
		{
			object[] objArray1 = new object[5] { "SELECT * FROM RentSell WHERE ID=", ID, " AND User_ID = ", UserId, "" } ;
			string text1 = string.Concat(objArray1);
			return SQLHelper.ExecuteDataRow(text1);
		}
 
		public static DataTable GetHouseList(byte Type)
		{
			string text1 = "SELECT ID, Type ,User_ID ,Area_ID ,Ht_ID ,IsAgency ,Addr ,Square ,Price , FYHX ,AddTime FROM RentSell WHERE State=1 AND Type = " + Type + " ORDER BY ID DESC";
			return SQLHelper.ExecuteDataTable(text1);
		}
 
		public static DataTable GetHouseList(byte Type, byte Top)
		{
			object[] objArray1 = new object[5] { "SELECT TOP ", Top, " ID, Type ,User_ID ,Area_ID ,Ht_ID ,IsAgency ,Addr ,Square ,Price , FYHX ,AddTime FROM RentSell WHERE State=1 AND Type = ", Type, " ORDER BY ID DESC" } ;
			string text1 = string.Concat(objArray1);
			return SQLHelper.ExecuteDataTable(text1);
		}
 
		public static DataTable GetHouseList(byte Type, byte Top, int City_ID)
		{
			object[] objArray1 = new object[7] { "SELECT TOP ", Top, " ID, Type ,User_ID ,Area_ID ,Ht_ID ,IsAgency ,Addr ,Square ,Price , FYHX ,AddTime FROM RentSell WHERE State=1 AND Type = ", Type, " AND City_ID = ", City_ID, " ORDER BY ID DESC" } ;
			string text1 = string.Concat(objArray1);
			return SQLHelper.ExecuteDataTable(text1);
		}
 
		public static DataTable GetHouseListByArea(byte Type, byte areaId)
		{
			object[] objArray1 = new object[5] { "SELECT ID, Type ,Area_ID ,Ht_ID ,IsAgency ,Addr ,Square ,Price , FYHX ,AddTime FROM RentSell WHERE State=1 AND Type = ", Type, " AND Area_ID = ", areaId, " ORDER BY ID DESC" } ;
			string text1 = string.Concat(objArray1);
			return SQLHelper.ExecuteDataTable(text1);
		}
 
		public static DataTable GetHouseListByUserID(int UserId)
		{
			string text1 = "SELECT ID, Type ,Area_ID ,Ht_ID ,IsAgency ,Addr ,Square ,Price , FYHX ,AddTime FROM RentSell WHERE State=1 AND User_ID = " + UserId + " ORDER BY ID DESC";
			return SQLHelper.ExecuteDataTable(text1);
		}
 
		public static int Hits(int ID)
		{
			string text1 = "UPDATE RentSell SET Hits = Hits + 1 WHERE ID=" + ID;
			return SQLHelper.ExecuteNonQuery(text1);
		}
 
		public static bool IsExist(string addr, string ipAddr)
		{
			bool flag1;
			string[] textArray1 = new string[5] { "SELECT ipAddr FROM RentSell WHERE Addr = '", addr, "' AND IpAddr = '", ipAddr, "'" } ;
			string text1 = string.Concat(textArray1);
			try
			{
				object obj1 = SQLHelper.ExecuteScalar(text1);
				if (obj1 != null)
				{
					return true;
				}
				flag1 = false;
			}
			catch (Exception exception1)
			{
				flag1 = false;
			}
			return flag1;
		}
 
		public static int Update(HouseInfo entity)
		{
			int num2;
			object[] objArray1 = new object[0x2f] { 
													  "UPDATE RentSell SET Type=", entity.Type, " ,Area_ID=", entity.AreaID, " ,Ht_ID=", entity.HtID, " ,IsAgency=", entity.IsAgency, " ,Addr='", entity.Addr, "' ,Square=", entity.Square, " ,Price=", entity.Price, " ,Direction='", entity.Direction, 
													  "' ,floor1=", entity.Floor1, " ,floor2=", entity.Floor2, " ,FYHX='", entity.FYHX, "' ,ZXQK='", entity.ZXQK, "' ,JCSS='", entity.JCSS, "' ,PTSS='", entity.PTSS, "' ,JTQK='", entity.JTQK, "' ,Other='", entity.Other, 
													  "' ,LinkMan='", entity.LinkMan, "' ,Tel1='", entity.Tel1, "' ,Tel2='", entity.Tel2, "' ,Email='", entity.Email, "' ,Expire=", entity.Expire, "  WHERE ID = ", entity.ID, " AND User_ID=", entity.UserID, ""
												  } ;
			string text1 = string.Concat(objArray1);
			try
			{
				int num1 = SQLHelper.ExecuteNonQuery(text1);
				num2 = num1;
			}
			catch (Exception exception1)
			{
				num2 = -99;
			}
			return num2;
		}
 
		public static int UpdateAdmin(HouseInfo entity)
		{
			object[] objArray1 = new object[0x2d] { 
													  "UPDATE RentSell SET Type=", entity.Type, " ,Area_ID=", entity.AreaID, " ,Ht_ID=", entity.HtID, " ,IsAgency=", entity.IsAgency, " ,Addr='", entity.Addr, "' ,Square=", entity.Square, " ,Price=", entity.Price, " ,Direction='", entity.Direction, 
													  "' ,floor1=", entity.Floor1, " ,floor2=", entity.Floor2, " ,FYHX='", entity.FYHX, "' ,ZXQK='", entity.ZXQK, "' ,JCSS='", entity.JCSS, "' ,PTSS='", entity.PTSS, "' ,JTQK='", entity.JTQK, "' ,Other='", entity.Other, 
													  "' ,LinkMan='", entity.LinkMan, "' ,Tel1='", entity.Tel1, "' ,Tel2='", entity.Tel2, "' ,Email='", entity.Email, "' ,Expire=", entity.Expire, "  WHERE ID = ", entity.ID, ""
												  } ;
			string text1 = string.Concat(objArray1);
			return SQLHelper.ExecuteNonQuery(text1);
		}
 

	}
}