public HouseInfo GetHouseID(long houseID, string source)
{
using (IDbConnection dbConnection = GetConnection())
{
dbConnection.Open();
return(dbConnection.Query <HouseInfo>($"SELECT * FROM {ConstConfigName.GetTableName(source)} where ID = @ID",
new
{
ID = houseID
}).FirstOrDefault());
}
}
private List <HouseInfo> SearchUserCollections(long userID, string city, string source)
{
using (IDbConnection dbConnection = GetConnection())
{
var tableName = ConstConfigName.GetTableName(source);
string sqlText = GetSQLText(city, tableName);
var list = dbConnection.Query <HouseInfo>(sqlText,
new
{
UserID = userID,
HouseCity = city,
Source = source
}).ToList();
return(list);
}
}
public List <Models.HouseDashboard> GetHouseDashboard()
{
using (IDbConnection dbConnection = GetConnection())
{
dbConnection.Open();
var list = new List <Models.HouseDashboard>();
foreach (var key in ConstConfigName.HouseTableNameDic.Keys)
{
var tableName = ConstConfigName.GetTableName(key);
var dashboards = dbConnection.Query <HouseDashboard>(@"SELECT
LocationCityName AS CityName,
Source, COUNT(id) AS HouseSum,
MAX(PubTime) AS LastRecordPubTime
FROM
" + tableName + $" GROUP BY LocationCityName, Source ORDER BY HouseSum desc;");
list.AddRange(dashboards);
}
return(list.Where(dash => dash.LastRecordPubTime.CompareTo(DateTime.Now.AddDays(-30)) > 0 && dash.HouseSum > 100)
.ToList());
}
}
