/// <summary>
/// 查询用户租赁信息
/// </summary>
/// <param name="Row"></param>
/// <returns></returns>
public string RentalHistoryList(DataRow Row)
{
string backstr = "";
DataTable dt = null;
try
{
string ConnStr = ConnectionDb.GetUnifiedConnectionString();
string UserId = Row["UserId"].ToString();
IDbConnection com = new SqlConnection(ConnStr);
//Tb_User User = com.Query<Tb_User>("select * from Tb_User where Id=@Id", new { Id = UserId }).ToList<Tb_User>().SingleOrDefault();
//if (User==null)
//{
// return JSONHelper.FromString(false, "该用户不存在");
//}
int page = AppGlobal.StrToInt(Row["Page"].ToString());
int row = AppGlobal.StrToInt(Row["PageSize"].ToString());
dt = BaseGetData.GetList(ConnStr, " and UserId='" + UserId + "'", page, row, "RegisterDate", 0, "View_Tb_Rental", "Id").Tables[0];
}
catch (Exception ex)
{
backstr = ex.Message;
}
if (backstr == "")
{
return(JSONHelper.FromString(dt));
}
else
{
return(JSONHelper.FromString(false, backstr));
}
}
private string GetRentalTop(DataRow Row)
{
string backstr = "";
DataTable dt = null;
try
{
string ConnStr = ConnectionDb.GetUnifiedConnectionString();
StringBuilder sb = new StringBuilder();
if (Row.Table.Columns.Contains("AppleBundleID") && Row["AppleBundleID"].ToString() != "")//苹果包名
{
sb.AppendFormat(" AND CommunityId in(select Id from Tb_Community where AppleBundleID = '{0}') ", Row["AppleBundleID"]);
}
if (Row.Table.Columns.Contains("AndroidPackageName") && Row["AndroidPackageName"].ToString() != "")//安桌包名
{
sb.AppendFormat(" AND CommunityId in(select Id from Tb_Community where AndroidPackageName = '{0}') ", Row["AndroidPackageName"]);
}
sb.AppendFormat(" AND ProcessState='发布' AND BussType='{0}'", Row["BussType"].ToString());
if (Row["BussType"].ToString() == "租售")
{
sb.AppendFormat(@" AND (convert(NVARCHAR(20),Rent) <> '面议' OR (convert(DECIMAL(18,2), replace(rent, '面议', '0'))>=0
AND convert(DECIMAL(18,2), replace(rent, '面议', '0'))<=99999999) OR Rent IS NULL)");
}
if (Row["BussType"].ToString() == "转让")
{
sb.AppendFormat(" AND ((Amount>=0 AND Amount<=99999999) OR Amount IS NULL)");
}
int page = 1;
int row = 5;
dt = BaseGetData.GetList(ConnStr, sb.ToString(), page, row, "RegisterDate", 1, "View_Tb_Rental", "Id").Tables[0];
}
catch (Exception ex)
{
backstr = ex.Message;
}
if (backstr == "")
{
return(JSONHelper.FromString(dt));
}
else
{
return(JSONHelper.FromString(false, backstr));
}
}
//房屋租赁列表
public string RentalList(DataRow Row)
{
string backstr = "";
DataTable dt = null;
try
{
string ConnStr = ConnectionDb.GetUnifiedConnectionString();
StringBuilder sb = new StringBuilder();
if (Row.Table.Columns.Contains("CommunityId") && Row["CommunityId"].ToString() != "")
{
sb.AppendFormat(" AND CommunityId='{0}'", Row["CommunityId"].ToString());
}
else
{
if (string.IsNullOrEmpty(Row["City"].ToString()) == false)
{
sb.AppendFormat(" AND (City LIKE '%{0}%' OR Province LIKE '%{0}%')", Row["City"].ToString().Replace("市", ""));
}
if (Row.Table.Columns.Contains("AppleBundleID") && Row["AppleBundleID"].ToString() != "")//苹果包名
{
sb.AppendFormat(" AND CommunityId in(select Id from Tb_Community where AppleBundleID = '{0}') ", Row["AppleBundleID"]);
}
if (Row.Table.Columns.Contains("AndroidPackageName") && Row["AndroidPackageName"].ToString() != "")//安桌包名
{
sb.AppendFormat(" AND CommunityId in(select Id from Tb_Community where AndroidPackageName = '{0}') ", Row["AndroidPackageName"]);
}
}
sb.AppendFormat(" AND ProcessState='发布' AND BussType='{0}'", Row["BussType"].ToString());
if (string.IsNullOrEmpty(Row["HouseType"].ToString()) == false)
{
sb.AppendFormat(" AND HouseType LIKE '%{0}%'", Row["HouseType"].ToString());
}
if (Row["BussType"].ToString() == "租售")
{
sb.AppendFormat(@" AND (convert(NVARCHAR(20),Rent) <> '面议' AND (convert(DECIMAL(18,2), replace(rent, '面议', '0'))>={0}
AND convert(DECIMAL(18,2), replace(rent, '面议', '0'))<={1}) OR Rent IS NULL)",
Row["StartAmount"].ToString(), Row["EndAmount"].ToString());
}
if (Row["BussType"].ToString() == "转让")
{
sb.AppendFormat(" AND ((Amount>={0} AND Amount<={1}) OR Amount IS NULL)", Row["StartAmount"].ToString(), Row["EndAmount"].ToString());
}
int page = AppGlobal.StrToInt(Row["Page"].ToString());
int row = AppGlobal.StrToInt(Row["PageSize"].ToString());
dt = BaseGetData.GetList(ConnStr, sb.ToString(), page, row, "RegisterDate", 1, "View_Tb_Rental", "Id").Tables[0];
}
catch (Exception ex)
{
backstr = ex.Message;
}
if (backstr == "")
{
return(JSONHelper.FromString(dt));
}
else
{
return(JSONHelper.FromString(false, backstr));
}
}
