  CREATE VIEW  [vw_aspnet_Profiles]
  AS SELECT  [aspnet_Profile].[UserId],  [aspnet_Profile].[LastUpdatedDate],
      [DataSize]=  DATALENGTH( [aspnet_Profile].[PropertyNames])
                 + DATALENGTH( [aspnet_Profile].[PropertyValuesString])
                 + DATALENGTH( [aspnet_Profile].[PropertyValuesBinary])
  FROM  [aspnet_Profile]
~

CREATE view YX_DQCZ as 
SELECT  a.*,b.Area_Name,c.TP_Name FROM YX_ChuZu AS A
inner join YX_QuYu AS B on A.Area_ID=B.Area_ID
inner join YX_TuPian C on a.HR_BianHao=c.TP_BianHao
WHERE A.HR_HouseShortHireTime='1' or A.HR_HouseShortHireTime=''  and  A.HR_IsCheck=1 and A.HR_PublishPeriod>0 and c.tp_isdefault=1
~

CREATE view YX_DQQZ as 
SELECT  a.* ,b.area_name FROM YX_QiuZu AS A 
 inner join YX_QuYu AS B on A.Area_ID=B.Area_ID
 WHERE  A.TE_HireMinNum='1' or A.TE_HireMinNum='3'  and A.TE_Check=1 and A.TE_Validity>0 
~

CREATE VIEW YX_DefaultTuPian 
AS
SELECT DISTINCT TP_BianHao,TP_Name from YX_TuPian
~

CREATE view YX_GRCS as
select a.*,c.area_name,e.tp_name from yx_chushou a
inner join yx_GeRenYH b on a.u_id=b.u_id
inner join yx_quyu c on a.area_id=c.area_id 
inner join yx_tupian e on a.house_bianhao=e.tp_bianhao
where a.House_Type='˳' and a.House_ReleaseDay>0 and a.House_IsCheck=1 and e.tp_isdefault=1
~

CREATE view YX_GRCZ as 
SELECT  a.*,b.Area_Name,c.TP_Name FROM YX_ChuZu AS A
inner join YX_QuYu AS B on A.Area_ID=B.Area_ID
inner join YX_TuPian C on a.HR_BianHao=c.TP_BianHao
WHERE A.HR_Type='˳' and  A.HR_IsCheck=1 and A.HR_PublishPeriod>0 and c.tp_isdefault=1
~

CREATE view YX_JingPinXQCS
as 
SELECT a.*,c.area_name,e.tp_name FROM
 yx_chushou a   
INNER JOIN yx_quyu c ON a.area_id=c.area_id 
 INNER JOIN yx_tupian e ON a.house_bianhao=e.tp_bianhao
 WHERE a.House_ReleaseDay>0 AND a.House_IsCheck=1 AND e.tp_isdefault=1

~
CREATE view YX_JingPinXQCZ
as
select a.*,c.area_name,
f.tp_name from yx_chuzu a 
inner join yx_quyu c on a.area_id=c.area_id inner join yx_tupian f
on a.HR_BianHao=f.TP_BianHao
 where  a.HR_PublishPeriod>0 and a.HR_IsCheck=1 and f.tp_isdefault=1

~
CREATE VIEW YX_SYCS AS SELECT a.*,c.area_name,e.tp_name FROM yx_chushou a 
INNER JOIN yx_jingjiren b ON a.u_id=b.u_id 
INNER JOIN yx_quyu c ON a.area_id=c.area_id 
INNER JOIN yx_tupian e ON a.house_bianhao=e.tp_bianhao 
WHERE a.House_ReleaseDay>0 AND a.House_IsCheck=1 AND e.tp_isdefault=1
~


create view YX_SYCZ as 
SELECT  a.*,b.Area_Name,c.TP_Name FROM YX_ChuZu AS A
inner join YX_QuYu AS B on A.Area_ID=B.Area_ID
inner join YX_TuPian C on a.HR_BianHao=c.TP_BianHao
WHERE A.HR_IsCheck=1 and A.HR_PublishPeriod>0
~

CREATE view YX_TuiJianCS as
select a.*,c.area_name,e.tp_name from yx_chushou a
inner join yx_jingjiren b on a.u_id=b.u_id
inner join yx_quyu c on a.area_id=c.area_id 
inner join yx_tupian e on a.house_bianhao=e.tp_bianhao
where a.House_ReleaseDay>0 and a.House_IsCheck=1 and e.tp_isdefault=1 and a.house_iscommend=1

~
create view YX_TuiJianCZ as 
SELECT  a.*,b.Area_Name,c.TP_Name FROM YX_ChuZu AS A
inner join YX_QuYu AS B on A.Area_ID=B.Area_ID
inner join YX_TuPian C on a.HR_BianHao=c.TP_BianHao
WHERE  A.HR_IsCheck=1 and A.HR_PublishPeriod>0 and a.HR_IsCommend=1
~

CREATE VIEW YX_ZJCS
AS 
select a.*,c.area_name,
e.ac_shopname,f.tp_name from yx_chushou a inner join yx_jingjiren b on a.u_id=b.u_id
inner join yx_quyu c on a.area_id=c.area_id inner join 
yx_agencycompanyshop d on b.shopID=d.acs_id inner join yx_agencycompanyreginfo e
on d.acs_agencyid=e.ac_acid inner join yx_tupian f on a.house_bianhao=f.tp_bianhao
 where a.House_Type='˳' and a.House_ReleaseDay>0 and a.House_IsCheck=1 and f.tp_isdefault=1
~

CREATE view YX_ZJCZ
as
select a.*,c.area_name,
e.ac_shopname,f.tp_name from yx_chuzu a inner join yx_jingjiren b on a.u_id=b.u_id
inner join yx_quyu c on a.area_id=c.area_id inner join 
yx_agencycompanyshop d on b.shopID=d.acs_id inner join yx_agencycompanyreginfo e
on d.acs_agencyid=e.ac_acid inner join yx_tupian f
on a.HR_BianHao=f.TP_BianHao
 where a.HR_Type='˳' and a.HR_PublishPeriod>0 and a.HR_IsCheck=1 and f.tp_isdefault=1
~

CREATE view YX_ZhongJieCS
as
select a.House_BianHao,a.House_Addrinfo,a.House_Size1,a.House_InputPrice,
a.House_PublishDate,a.House_Hit,a.House_CommentNum,a.House_YuYueNum,a.House_IsCommend,
a.House_ReleaseDay,c.area_name,
e.ac_shopname from yx_chushou a inner join yx_jingjiren b on a.u_id=b.u_id
inner join yx_quyu c on a.area_id=c.area_id inner join 
yx_agencycompanyshop d on b.shopID=d.acs_id inner join yx_agencycompanyreginfo e
on d.acs_agencyid=e.ac_acid where a.House_Type='˳'  and a.House_ReleaseDay>0 and a.House_IsCheck=1
~

CREATE view YX_ZhongJieCZ
as
select a.HR_BianHao,a.HR_XiaoQuDZ,a.HR_HouseHold,a.HR_HouseOffice,a.HR_HouseSize,a.HR_HouseHirePrice,a.HR_HouseHirePriceUnit,
a.HR_PublishDate,a.HR_Hit,a.HR_CommentNum,a.HR_IsCommend,a.HR_PublishPeriod,c.area_name,
e.ac_shopname from yx_chuzu a inner join yx_jingjiren b on a.u_id=b.u_id
inner join yx_quyu c on a.area_id=c.area_id inner join 
yx_agencycompanyshop d on b.shopID=d.acs_id inner join yx_agencycompanyreginfo e
on d.acs_agencyid=e.ac_acid where a.HR_Type='˳' and a.HR_PublishPeriod>0 and a.HR_IsCheck=1
~

CREATE view YX_ZhongJieQG
as
select a.CS_BianHao,a.CS_XiaoQuDZ,a.CS_RoomNum1,a.CS_RoomOffice1,A.CS_RoomNum2,a.CS_RoomOffice2,
a.CS_SizeMin,a.CS_SizeMax,a.CS_PriceMin,a.CS_PriceMax,a.CS_FloorMin,a.CS_FloorMax,
a.CS_PublishDate,a.CS_Hit,a.CS_YuYueNum,a.CS_IsCommend,a.CS_PublishDay,c.area_name,
e.ac_shopname from yx_qiugou a inner join yx_jingjiren b on a.u_id=b.u_id
inner join yx_quyu c on a.area_id=c.area_id inner join 
yx_agencycompanyshop d on b.shopID=d.acs_id inner join yx_agencycompanyreginfo e
on d.acs_agencyid=e.ac_acid where a.CS_Type='' and a.CS_PublishDay>0 and a.CS_IsCheck=1
~

CREATE view YX_ZhongJieQZ
as
select a.TE_BianHao,a.TE_SmallArea,a.TE_HouseHoldA,a.TE_HouseOfficeA,A.TE_HouseHoldB,a.TE_HouseOfficeB,
a.TE_SizeMin,a.TE_SizeMax,a.TE_HireMin,a.TE_HireMax,a.TE_FloorMin,a.TE_FloorMax,
a.TE_PublishDate,a.TE_Hit,a.TE_YuYueNum,a.TE_IsCommend,a.TE_Validity,c.area_name,
e.ac_shopname from yx_qiuzu a inner join yx_jingjiren b on a.u_id=b.u_id
inner join yx_quyu c on a.area_id=c.area_id inner join 
yx_agencycompanyshop d on b.shopID=d.acs_id inner join yx_agencycompanyreginfo e
on d.acs_agencyid=e.ac_acid where a.TE_Type='' and a.TE_Validity>0 and a.TE_Check=1
~

  CREATE VIEW  [vw_aspnet_Applications]
  AS SELECT  [aspnet_Applications].[ApplicationName],  [aspnet_Applications].[LoweredApplicationName],  [aspnet_Applications].[ApplicationId],  [aspnet_Applications].[Description]
  FROM  [aspnet_Applications]
  
~
  CREATE VIEW  [vw_aspnet_Roles]
  AS SELECT  [aspnet_Roles].[ApplicationId],  [aspnet_Roles].[RoleId],  [aspnet_Roles].[RoleName],  [aspnet_Roles].[LoweredRoleName],  [aspnet_Roles].[Description]
  FROM  [aspnet_Roles]
  
~
  CREATE VIEW  [vw_aspnet_Users]
  AS SELECT  [aspnet_Users].[ApplicationId],  [aspnet_Users].[UserId],  [aspnet_Users].[UserName],  [aspnet_Users].[LoweredUserName],  [aspnet_Users].[MobileAlias],  [aspnet_Users].[IsAnonymous],  [aspnet_Users].[LastActivityDate]
  FROM  [aspnet_Users]
  ~

  CREATE VIEW  [vw_aspnet_WebPartState_Paths]
  AS SELECT  [aspnet_Paths].[ApplicationId],  [aspnet_Paths].[PathId],  [aspnet_Paths].[Path],  [aspnet_Paths].[LoweredPath]
  FROM  [aspnet_Paths]
  ~
  CREATE VIEW  [vw_aspnet_MembershipUsers]
  AS SELECT  [aspnet_Membership].[UserId],
             [aspnet_Membership].[PasswordFormat],
             [aspnet_Membership].[MobilePIN],
             [aspnet_Membership].[Email],
             [aspnet_Membership].[LoweredEmail],
             [aspnet_Membership].[PasswordQuestion],
             [aspnet_Membership].[PasswordAnswer],
             [aspnet_Membership].[IsApproved],
             [aspnet_Membership].[IsLockedOut],
             [aspnet_Membership].[CreateDate],
             [aspnet_Membership].[LastLoginDate],
             [aspnet_Membership].[LastPasswordChangedDate],
             [aspnet_Membership].[LastLockoutDate],
             [aspnet_Membership].[FailedPasswordAttemptCount],
             [aspnet_Membership].[FailedPasswordAttemptWindowStart],
             [aspnet_Membership].[FailedPasswordAnswerAttemptCount],
             [aspnet_Membership].[FailedPasswordAnswerAttemptWindowStart],
             [aspnet_Membership].[Comment],
             [aspnet_Users].[ApplicationId],
             [aspnet_Users].[UserName],
             [aspnet_Users].[MobileAlias],
             [aspnet_Users].[IsAnonymous],
             [aspnet_Users].[LastActivityDate]
  FROM  [aspnet_Membership] INNER JOIN  [aspnet_Users]
      ON  [aspnet_Membership].[UserId] =  [aspnet_Users].[UserId]
  ~

  CREATE VIEW  [vw_aspnet_UsersInRoles]
  AS SELECT  [aspnet_UsersInRoles].[UserId],  [aspnet_UsersInRoles].[RoleId]
  FROM  [aspnet_UsersInRoles]
  ~

  CREATE VIEW  [vw_aspnet_WebPartState_Shared]
  AS SELECT  [aspnet_PersonalizationAllUsers].[PathId], [DataSize]=DATALENGTH( [aspnet_PersonalizationAllUsers].[PageSettings]),  [aspnet_PersonalizationAllUsers].[LastUpdatedDate]
  FROM  [aspnet_PersonalizationAllUsers]
  ~

  CREATE VIEW  [vw_aspnet_WebPartState_User]
  AS SELECT  [aspnet_PersonalizationPerUser].[PathId],  [aspnet_PersonalizationPerUser].[UserId], [DataSize]=DATALENGTH( [aspnet_PersonalizationPerUser].[PageSettings]),  [aspnet_PersonalizationPerUser].[LastUpdatedDate]
  FROM  [aspnet_PersonalizationPerUser]
  
