/// <summary> /// 获取列表 /// </summary> /// <param name="pageIndex">页下标</param> /// <param name="rentalType">租售类型</param> /// <param name="ssjd">所属街道</param> /// <param name="zmj">总面积</param> /// <param name="rentalMoney">租售价格</param> /// <param name="name">楼宇名称</param> /// <returns></returns> public JsonResult GetJsonList(int pageIndex, string rentalType, string ssjd, string zmj, string rentalMoney, string name, Guid isImportant, Guid jsjd) { StringBuilder html = new StringBuilder(); IQueryable <BuildingModel> list = db.BuildingsAndBuildingMonthInfo.Where(p => p.IsImportant == isImportant && p.JSJD == jsjd && p.Status == Status.Normal).Include(p => p.SWZJ).Include(p => p.SYZJ); #region where //所属街道 if (!string.IsNullOrWhiteSpace(ssjd)) { Guid ssjdGuid = Guid.Parse(ssjd); list = list.Where(p => p.SSJD == ssjdGuid); } //总面积 if (!string.IsNullOrWhiteSpace(zmj)) { int begin = zmj.Split(',')[0].Convert <int>(0); if (begin != 0) { list = list.Where(p => p.ZJZMJ > begin); } int end = zmj.Split(',')[1].Convert <int>(0); if (end != 0) { list = list.Where(p => p.ZJZMJ < end); } } //租售金额 if (!string.IsNullOrWhiteSpace(rentalMoney)) { //出租 string zjStr = ControllersExtentstions.GetAreaIds(rentalMoney); if (string.IsNullOrWhiteSpace(zjStr)) { List <Guid> ids = new List <Guid>(); foreach (var item in zjStr.Split(',')) { ids.Add(Guid.Parse(item)); } list = list.Where(t => ids.Contains(t.SY_ZJ.Value) || ids.Contains(t.SW_ZJ.Value)); } //出售 int begin = rentalMoney.Split(',')[0].Convert <int>(0); if (begin != 0) { list = list.Where(p => p.SY_XSJJ > begin || p.SW_XSJJ > begin); } int end = rentalMoney.Split(',')[1].Convert <int>(0); if (end != 0) { list = list.Where(p => p.SY_XSJJ < end || p.SW_XSJJ < end); } } //楼宇名称 if (!string.IsNullOrWhiteSpace(name)) { list = list.Where(p => p.Name.Contains(name)); } #endregion int totalCount = list.Count(); string pager = RoadFlow.Utility.New.Tools.GetPagingHtml(totalCount, pageSize, pageIndex); list = list.OrderByDescending(p => p.CreateTime).Skip(pageSize * (pageIndex - 1)).Take(pageSize); return(Json(new { success = true, html = GetHtml(list, rentalType).ToString(), pager = pager, totalCount = totalCount, }, JsonRequestBehavior.AllowGet)); }
/// <summary> /// json 异步加载 /// </summary> /// <param name="pageIndex">页下标</param> /// <param name="jsjd">建设阶段</param> /// <param name="typeid">是否重点楼宇</param> /// <param name="ssjd">所属街道</param> /// <param name="zmj">总面积</param> /// <param name="name">楼宇名称</param> /// <returns></returns> public JsonResult GetList(int pageIndex, Guid jsjd, Guid typeid, string ssjd, string zmj, string name) { StringBuilder html = new StringBuilder(); IQueryable <BuildingModel> list = db.BuildingsAndBuildingMonthInfo.Where(p => p.IsImportant == typeid && p.JSJD == jsjd); if (!string.IsNullOrWhiteSpace(ssjd)) { Guid ssjdGuid = Guid.Parse(ssjd); list = list.Where(p => p.SSJD == ssjdGuid); } if (!string.IsNullOrWhiteSpace(zmj)) { int begin = zmj.Split(',')[0].Convert <int>(0); if (begin != 0) { list = list.Where(p => p.ZJZMJ > begin); } int end = zmj.Split(',')[1].Convert <int>(0); if (end != 0) { list = list.Where(p => p.ZJZMJ < end); } } if (!string.IsNullOrWhiteSpace(name)) { list = list.Where(p => p.Name.Contains(name)); } int totalCount = list.Count(); string pager = RoadFlow.Utility.New.Tools.GetPagingHtml(totalCount, pageSize, pageIndex); list = list.OrderByDescending(p => p.CreateTime).Skip(pageSize * (pageIndex - 1)).Take(pageSize); int count = 0; foreach (var item in list) { count++; if (count % 3 == 0) { html.Append(" <li class=\"fl\" style=\"margin-right:0;\"><div>"); } else { html.Append(" <li class=\"fl\"><div>"); } html.AppendFormat(" <a href=\"{0}\"><img src=\"{1}\"></a>", Url.Action("Details", new { id = item.ID }), ControllersExtentstions.GetFullPath(string.IsNullOrWhiteSpace(item.XGT) ? "" : item.XGT.Split('|')[0])); html.AppendFormat(" <h5>{0}</h5>", item.Name); html.AppendFormat(" <p>面积:{0}<span>平方米</span></p>", item.ZJZMJ); html.AppendFormat("<p>开发商:{0}</p> </div>", item.LYGLYYF); html.Append("</li>"); } return(Json(new { success = true, html = html.ToString(), pager = pager, totalCount = totalCount }, JsonRequestBehavior.AllowGet)); }
public StringBuilder GetHtml(IQueryable <BuildingModel> list, string rentalType) { StringBuilder html = new StringBuilder(); int count = 0; foreach (var item in list) { count++; if (count % 2 == 1) { html.Append(" <li class=\"clearfix\">"); html.Append("<div class=\"fl clearfix pr\">"); // html.Append(" <li class=\"fl clearfix pr\" style=\"margin-right:0;float:right;\">"); } else { html.Append("<div class=\"fr clearfix pr\">"); } html.AppendFormat(" <a href=\"{0}\"><img class=\"fl\" src=\"{1}\">", Url.Action("Details", new { id = item.ID }), ControllersExtentstions.GetFullPath(string.IsNullOrWhiteSpace(item.XGT) ? "" : item.XGT.Split('|')[0]));//左侧图 //中间部分 html.Append(" <div class=\"fl\">"); html.AppendFormat(" <h4>{0}</h4>", item.Name); html.AppendFormat("<div>地址:<span>{0}</span> </div>", item.LYXXDZ); html.AppendFormat(" <div>招商电话:<span>{0}</span></div>", item.ChinaMerchantsTel); html.AppendFormat("<div>面积:<span>{0}㎡</span> </div>", item.ZJZMJ); html.AppendFormat(" <div>发布日期:<span>{0}</span></div>", ((DateTime)item.CreateTime).ToString("yyyy-MM-dd")); html.Append("</div>"); //右侧部分 if (!string.IsNullOrWhiteSpace(rentalType)) { if (rentalType == "出租") { html.AppendFormat(" <div class=\"pa pa1\"> <span class=\"txt1\">商业租金</span><span class=\"money\">{0}</span>元/㎡ · 月</div>", item.SYZJ == null?"": item.SYZJ.Title); html.AppendFormat(" <div class=\"pa pa2\"><span class=\"txt1\">商务租金</span><span class=\"money\">{0}</span>元/㎡ · 月 </div>", item.SWZJ == null ? "" : item.SWZJ.Title); } else if (rentalType == "出售") { html.AppendFormat(" <div class=\"pa pa3\"><span class=\"txt1\">商业价格</span><span class=\"money\">{0}</span>元/㎡ · 月</div>", item.SY_XSJJ == null ? 0 : item.SY_XSJJ); html.AppendFormat("<div class=\"pa pa4\"><span class=\"txt1\">商务价格</span><span class=\"money\">{0}</span>元/㎡ · 月</div>", item.SW_XSJJ == null ? 0 : item.SW_XSJJ); } else //全部 { html.AppendFormat(" <div class=\"pa pa1\"> <span class=\"txt1\">商业租金</span><span class=\"money\">{0}</span>元/㎡ · 月</div>", item.SYZJ == null ? "" : item.SYZJ.Title); html.AppendFormat(" <div class=\"pa pa2\"><span class=\"txt1\">商务租金</span><span class=\"money\">{0}</span>元/㎡ · 月 </div>", item.SWZJ == null ? "" : item.SWZJ.Title); html.AppendFormat(" <div class=\"pa pa3\"><span class=\"txt1\">商业价格</span><span class=\"money\">{0}</span>元/㎡ · 月</div>", item.SY_XSJJ == null ? 0 : item.SY_XSJJ); html.AppendFormat("<div class=\"pa pa4\"><span class=\"txt1\">商务价格</span><span class=\"money\">{0}</span>元/㎡ · 月</div>", item.SW_XSJJ == null ? 0 : item.SW_XSJJ); } } html.Append(" </a>"); html.Append("</div>"); if (count % 2 == 0) { html.Append("</li>"); } } return(html); }