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()); } }