public JsonResult getDataDic(string pageSize, string page,
string dkey, string dvalue, string dvalue2, string dvalue3
)
{
List <DataDictionary> datas = DataDictionaryService.LoadEntities(d => true).ToList();
int pageInt = Convert.ToInt32(page);
int pageSizeInt = Convert.ToInt32(pageSize);
if (!string.IsNullOrWhiteSpace(dkey))
{
datas = datas.Where(d => d.dkey.Contains(dkey)).ToList();
}
if (!string.IsNullOrWhiteSpace(dvalue))
{
datas = datas.Where(d => d.dvalue.Contains(dvalue)).ToList();
}
if (!string.IsNullOrWhiteSpace(dvalue2))
{
datas = datas.Where(d => d.dvalue2.Contains(dvalue2)).ToList();
}
if (!string.IsNullOrWhiteSpace(dvalue3))
{
datas = datas.Where(d => d.dvalue3.Contains(dvalue3)).ToList();
}
int count = datas.Count;
datas = datas.Skip((pageInt - 1) * pageSizeInt).Take(pageSizeInt).ToList();
return(Json(new { datas = datas, count = count }, JsonRequestBehavior.AllowGet));
}
//
// GET: /DataDictionary/Details/5
public ViewResult Details(int id)
{
DataDictionaryService service = new DataDictionaryService();
DataDictionary model = service.GetDataDictionaryByID(new DataDictionary() { Id = id });
model.ActionOperationType = EActionOperationType.Details;
return View("Create",model);
}
public JsonResult addDataDic(DataDictionary dataDic)
{
if (string.IsNullOrEmpty(dataDic.dvalue))
{
dataDic.dvalue = " ";
}
if (string.IsNullOrEmpty(dataDic.dvalue2))
{
dataDic.dvalue2 = " ";
}
if (string.IsNullOrEmpty(dataDic.dvalue3))
{
dataDic.dvalue3 = " ";
}
if (string.IsNullOrEmpty(dataDic.remark))
{
dataDic.remark = " ";
}
DataDictionary res = DataDictionaryService.AddEntity(dataDic);
return(Json(res, JsonRequestBehavior.AllowGet));
}
public ActionResult partialRentHouse()
{
if (Session["houseDic"] != null)
{
ViewBag.houseDic = Session["houseDic"];
Session["houseDic"] = null;
return(View());
}
string city = Session["rentCity"].ToString();
Dictionary <string, List <HousePicture> > houseDic = new Dictionary <string, List <HousePicture> >();
// 出租房 type = 1 出租 state = 0 未出售 audit 房屋审核通过允许上架
List <House> houseList = HouseService.LoadEntities(t => t.type == "1" && t.state == "0" && t.audit == "1" && t.city == city).ToList();
List <HousePicture> hps = newHousePicture(houseList);
//Console.WriteLine(houseList);
houseDic.Add("rent", hps);
List <DataDictionary> datas = DataDictionaryService.LoadEntities(t => t.dkey == "region").ToList();
ViewBag.houseDic = houseDic;
ViewBag.dataDic = datas;
return(View());
}
//
// GET: /House/
public ActionResult Index()
{
List <DataDictionary> regions = DataDictionaryService.LoadEntities(t => t.dkey == "region").ToList();
List <string> province = new List <string>();
foreach (DataDictionary item in regions)
{
if (!province.Contains(item.dvalue3))
{
province.Add(item.dvalue3);
}
}
List <string> region = new List <string>();
regions = DataDictionaryService.LoadEntities(t => t.dkey == "region" && t.dvalue2 == "北京市").ToList();
foreach (DataDictionary item in regions)
{
if (!region.Contains(item.dvalue))
{
region.Add(item.dvalue);
}
}
ViewBag.province = province;
ViewBag.region = region;
return(View());
}
public ActionResult DeleteConfirmed(int id)
{
DataDictionaryService service = new DataDictionaryService();
DataDictionary model = service.GetDataDictionaryByID(new DataDictionary() { Id = id });
service.Remove(model);
return RedirectToAction("Index");
}
//
// GET: /DataDictionary/Edit/5
public ActionResult Edit(int id)
{
DataDictionaryService service = new DataDictionaryService();
DataDictionary model = service.GetDataDictionaryByID(new DataDictionary() { Id = id });
model.ActionOperationType = EActionOperationType.Edit;
this.LoadEditViewBag(model);
return View("Create",model);
}
static void Main(string[] args)
{
var dataDictionaryService = new DataDictionaryService();
dataDictionaryService.CreateHtml();
Console.ReadKey();
}
public JsonResult removeDataDic(string did)
{
int didInt = Convert.ToInt32(did);
DataDictionary data = DataDictionaryService.LoadEntities(d => d.did == didInt).FirstOrDefault();
bool res = DataDictionaryService.DeleteEntity(data);
return(Json(res, JsonRequestBehavior.AllowGet));
}
public ActionResult Create(DataDictionary model)
{
model.ActionOperationType = EActionOperationType.Create;
if (ModelState.IsValid)
{
DataDictionaryService service = new DataDictionaryService();
service.Add(model);
return RedirectToAction("Index");
}
this.LoadEditViewBag(model);
return View("Create",model);
}
public JsonResult getRegion(string city)
{
List <string> region = new List <string>();
List <DataDictionary> datas = DataDictionaryService.LoadEntities(d => d.dkey == "region" && d.dvalue2 == city).ToList();
foreach (var item in datas)
{
if (!region.Contains(item.dvalue))
{
region.Add(item.dvalue);
}
}
return(Json(region, JsonRequestBehavior.AllowGet));
}
public JsonResult getCity(string province)
{
List <string> city = new List <string>();
List <DataDictionary> datas = DataDictionaryService.LoadEntities(d => d.dkey == "region" && d.dvalue3 == province).ToList();
foreach (var item in datas)
{
if (!city.Contains(item.dvalue2))
{
city.Add(item.dvalue2);
}
}
return(Json(city, JsonRequestBehavior.AllowGet));
}
public JsonResult getProvince()
{
List <string> province = new List <string>();
List <DataDictionary> datas = DataDictionaryService.LoadEntities(d => d.dkey == "region").ToList();
foreach (var item in datas)
{
if (!province.Contains(item.dvalue3))
{
province.Add(item.dvalue3);
}
}
return(Json(province, JsonRequestBehavior.AllowGet));
}
public JsonResult PlaceOrder(string id, string duration)
{
int hid = Convert.ToInt32(id);
House house = HouseService.LoadEntities(h => h.hid == hid).FirstOrDefault();
// 服务费
DataDictionary servicePrice = DataDictionaryService.LoadEntities(t => t.dkey == "service").FirstOrDefault();
int rent = Convert.ToInt32(duration) * house.price + Convert.ToInt32(servicePrice.dvalue);
DateTime df = DateTime.Now;
string now = df.ToString();
Orders newOrder = OrdersService.AddEntity(new Orders {
duration = Convert.ToInt32(duration),
rent = rent,
state = "0",
time = now
});
User user = Session["user"] as My.RentingSystem.Model.User;
//
OrdersUserHouse newOrderUserHouse = OrdersUserHouseService.AddEntity(new OrdersUserHouse {
oid = newOrder.oid,
uid = user.uid,
hid = hid,
pubTime = df.ToString("yyyyMMdd")
});
// 更新房屋状态state=1
house.state = "1";
HouseService.EditEntity(house);
Session["city"] = Session["rentCity"];
if (newOrder == null || newOrderUserHouse == null)
{
return(Json("error", JsonRequestBehavior.AllowGet));
}
else
{
return(Json("success", JsonRequestBehavior.AllowGet));
}
}
public ActionResult getCity(string province)
{
List <string> regions = new List <string>();
//if (province == "北京市" || province == "上海市" || province == "重庆市" || province == "深圳市")
//{
// List<DataDictionary> region = DataDictionaryService.LoadEntities(d => d.dkey == "region" && d.dvalue2 == province).ToList();
// foreach (DataDictionary item in region)
// {
// if (!regions.Contains(item.dvalue))
// {
// regions.Add(item.dvalue);
// }
// }
//}
List <DataDictionary> datas = DataDictionaryService.LoadEntities(d => d.dkey == "region" && d.dvalue3 == province).ToList();
List <string> city = new List <string>();
//city.Add()
foreach (DataDictionary item in datas)
{
if (!city.Contains(item.dvalue2))
{
city.Add(item.dvalue2);
}
}
string firstCity = city[0];
List <DataDictionary> region = DataDictionaryService.LoadEntities(d => d.dkey == "region" && d.dvalue2 == firstCity).ToList();
foreach (DataDictionary item in region)
{
if (!regions.Contains(item.dvalue))
{
regions.Add(item.dvalue);
}
}
return(Json(new { province = province, city = city, region = regions }, JsonRequestBehavior.AllowGet));
}
public JsonResult editOrder(string ouhid,
string oid,
string community,
string area,
string unitType,
string duration,
string rent,
string floor,
string state
)
{
int oidInt = Convert.ToInt32(oid);
Orders order = OrdersService.LoadEntities(o => o.oid == oidInt).FirstOrDefault();
int ouhidInt = Convert.ToInt32(ouhid);
int hid = OrdersUserHouseService.LoadEntities(o => o.ouhid == ouhidInt).FirstOrDefault().hid;
House house = HouseService.LoadEntities(h => h.hid == hid).FirstOrDefault();
// 如果时长不变 只变价格
if (Convert.ToInt32(duration) == order.duration)
{
order.rent = Convert.ToInt32(rent);
order.state = state;
}
else
{
// 改变时长 重新计算价格
order.state = state;
order.duration = Convert.ToInt32(duration);
string service = DataDictionaryService.LoadEntities(d => d.remark == "服务费").FirstOrDefault().dvalue;
order.rent = (Convert.ToInt32(duration) * house.price) + Convert.ToInt32(service);
}
bool res = OrdersService.EditEntity(order);
return(Json(res, JsonRequestBehavior.AllowGet));
}
public JsonResult getProvince()
{
DataDictionaryService.LoadEntities(d => d.dkey == "region").ToList();
return(Json(null, JsonRequestBehavior.AllowGet));
}
public JsonResult getRegion(string city)
{
DataDictionaryService.LoadEntities(d => d.dkey == "region" && d.dvalue2 == city).ToList();
return(Json(null, JsonRequestBehavior.AllowGet));
}
public virtual IList <DataDictionaryInfo> DataDictionarys() => DataDictionaryService.Query().Data;
public DataDictionaryController()
{
dataDictionaryService = new DataDictionaryService();
}
public virtual IList <DataDictionaryInfo> DataDictionarys() => DataDictionaryService.Query(HttpContext.CreateCommonUseData(ComUseDataFactory, menuCode: MenuCode(), functionCodes: FunCodeDefine.QUERY_CODE)).Data;
public JsonResult editDataDic(DataDictionary dataDic)
{
bool res = DataDictionaryService.EditEntity(dataDic);
return(Json(res, JsonRequestBehavior.AllowGet));
}
private void LoadSearchViewBag(ProjectPlanCollectionSearch searchModel)
{
#region sort
ViewBag.IsAsc = !searchModel.IsAsc;
ViewBag.SortBy = searchModel.SortBy;
#endregion
var projectplanService = new ProjectPlanService();
if (!searchModel.ProjectPlanId.HasValue)
{
ViewBag.ProjectPlanId = new SelectList(projectplanService.Query(p => p.IsActive=="1"), "Id", "Name");
}
else
{
ViewBag.ProjectPlanId = new SelectList(projectplanService.Query(p => p.IsActive=="1"), "Id", "Name", searchModel.ProjectPlanId);
}
var contractService = new ContractService();
if (!searchModel.ContractId.HasValue)
{
ViewBag.ContractId = new SelectList(contractService.Query(p => p.IsActive=="1"), "Id", "Name");
}
else
{
ViewBag.ContractId = new SelectList(contractService.Query(p => p.IsActive=="1"), "Id", "Name", searchModel.ContractId);
}
var orgchartService = new OrgChartService();
if (!searchModel.OrgChartId.HasValue)
{
ViewBag.OrgChartId = new SelectList(orgchartService.Query(p => p.IsActive=="1"), "Id", "Name");
}
else
{
ViewBag.OrgChartId = new SelectList(orgchartService.Query(p => p.IsActive=="1"), "Id", "Name", searchModel.OrgChartId);
}
var datadictionaryService = new DataDictionaryService();
if (!searchModel.BidTypeId.HasValue)
{
ViewBag.BidTypeId = new SelectList(datadictionaryService.Query(p => p.IsActive=="1"), "Id", "Name");
}
else
{
ViewBag.BidTypeId = new SelectList(datadictionaryService.Query(p => p.IsActive=="1"), "Id", "Name", searchModel.BidTypeId);
}
var departmentService = new DepartmentService();
if (!searchModel.DepartmentId.HasValue)
{
ViewBag.DepartmentId = new SelectList(departmentService.Query(p => p.IsActive=="1"), "Id", "Name");
}
else
{
ViewBag.DepartmentId = new SelectList(departmentService.Query(p => p.IsActive=="1"), "Id", "Name", searchModel.DepartmentId);
}
var employeeService = new EmployeeService();
if (!searchModel.ResearchOwnerEmployeeId.HasValue)
{
ViewBag.ResearchOwnerEmployeeId = new SelectList(employeeService.Query(p => p.IsActive=="1"), "Id", "Name");
}
else
{
ViewBag.ResearchOwnerEmployeeId = new SelectList(employeeService.Query(p => p.IsActive=="1"), "Id", "Name", searchModel.ResearchOwnerEmployeeId);
}
if (!searchModel.EngeerEmployeeId.HasValue)
{
ViewBag.EngeerEmployeeId = new SelectList(employeeService.Query(p => p.IsActive=="1"), "Id", "Name");
}
else
{
ViewBag.EngeerEmployeeId = new SelectList(employeeService.Query(p => p.IsActive=="1"), "Id", "Name", searchModel.EngeerEmployeeId);
}
if (!searchModel.CostOwnerEmployeeId.HasValue)
{
ViewBag.CostOwnerEmployeeId = new SelectList(employeeService.Query(p => p.IsActive=="1"), "Id", "Name");
}
else
{
ViewBag.CostOwnerEmployeeId = new SelectList(employeeService.Query(p => p.IsActive=="1"), "Id", "Name", searchModel.CostOwnerEmployeeId);
}
if (!searchModel.AuthorEmployeeId.HasValue)
{
ViewBag.AuthorEmployeeId = new SelectList(employeeService.Query(p => p.IsActive=="1"), "Id", "Name");
}
else
{
ViewBag.AuthorEmployeeId = new SelectList(employeeService.Query(p => p.IsActive=="1"), "Id", "Name", searchModel.AuthorEmployeeId);
}
if (!searchModel.OrganizerEmployeeId.HasValue)
{
ViewBag.OrganizerEmployeeId = new SelectList(employeeService.Query(p => p.IsActive=="1"), "Id", "Name");
}
else
{
ViewBag.OrganizerEmployeeId = new SelectList(employeeService.Query(p => p.IsActive=="1"), "Id", "Name", searchModel.OrganizerEmployeeId);
}
}
private void LoadEditViewBag(ProjectPlanCollection model)
{
ProjectPlanService projectplanService = new ProjectPlanService();
ViewBag.ProjectPlanId = new SelectList(projectplanService.Query(p => p.IsActive=="1"), "Id", "Name",model.ProjectPlanId);
ContractService contractService = new ContractService();
ViewBag.ContractId = new SelectList(contractService.Query(p => p.IsActive=="1"), "Id", "Name",model.ContractId);
OrgChartService orgchartService = new OrgChartService();
ViewBag.OrgChartId = new SelectList(orgchartService.Query(p => p.IsActive=="1"), "Id", "Name",model.OrgChartId);
DataDictionaryService datadictionaryService = new DataDictionaryService();
ViewBag.BidTypeId = new SelectList(datadictionaryService.Query(p => p.IsActive=="1"), "Id", "Name",model.BidTypeId);
DepartmentService departmentService = new DepartmentService();
ViewBag.DepartmentId = new SelectList(departmentService.Query(p => p.IsActive=="1"), "Id", "Name",model.DepartmentId);
EmployeeService employeeService = new EmployeeService();
ViewBag.ResearchOwnerEmployeeId = new SelectList(employeeService.Query(p => p.IsActive=="1"), "Id", "Name",model.ResearchOwnerEmployeeId);
ViewBag.EngeerEmployeeId = new SelectList(employeeService.Query(p => p.IsActive=="1"), "Id", "Name",model.EngeerEmployeeId);
ViewBag.CostOwnerEmployeeId = new SelectList(employeeService.Query(p => p.IsActive=="1"), "Id", "Name",model.CostOwnerEmployeeId);
ViewBag.AuthorEmployeeId = new SelectList(employeeService.Query(p => p.IsActive=="1"), "Id", "Name",model.AuthorEmployeeId);
ViewBag.OrganizerEmployeeId = new SelectList(employeeService.Query(p => p.IsActive=="1"), "Id", "Name",model.OrganizerEmployeeId);
}
private void LoadSearchViewBag(ContractSearch searchModel)
{
#region sort
ViewBag.IsAsc = !searchModel.IsAsc;
ViewBag.SortBy = searchModel.SortBy;
#endregion
var datadictionaryService = new DataDictionaryService();
if (!searchModel.ContractTypeId.HasValue)
{
ViewBag.ContractTypeId = new SelectList(datadictionaryService.Query(p => p.IsActive=="1"), "Id", "Name");
}
else
{
ViewBag.ContractTypeId = new SelectList(datadictionaryService.Query(p => p.IsActive=="1"), "Id", "Name", searchModel.ContractTypeId);
}
if (!searchModel.AgreementTypeId.HasValue)
{
ViewBag.AgreementTypeId = new SelectList(datadictionaryService.Query(p => p.IsActive=="1"), "Id", "Name");
}
else
{
ViewBag.AgreementTypeId = new SelectList(datadictionaryService.Query(p => p.IsActive=="1"), "Id", "Name", searchModel.AgreementTypeId);
}
if (!searchModel.ContractRelationId.HasValue)
{
ViewBag.ContractRelationId = new SelectList(datadictionaryService.Query(p => p.IsActive=="1"), "Id", "Name");
}
else
{
ViewBag.ContractRelationId = new SelectList(datadictionaryService.Query(p => p.IsActive=="1"), "Id", "Name", searchModel.ContractRelationId);
}
}
private void LoadEditViewBag(Contract model)
{
DataDictionaryService datadictionaryService = new DataDictionaryService();
ViewBag.ContractTypeId = new SelectList(datadictionaryService.Query(p => p.IsActive=="1"), "Id", "Name",model.ContractTypeId);
ViewBag.AgreementTypeId = new SelectList(datadictionaryService.Query(p => p.IsActive=="1"), "Id", "Name",model.AgreementTypeId);
ViewBag.ContractRelationId = new SelectList(datadictionaryService.Query(p => p.IsActive=="1"), "Id", "Name",model.ContractRelationId);
}
public JsonResult getMainData(string province)
{
int userToday = 0;
int userMonth = 0;
int userHis = 0;
DateTime dt = DateTime.Now;
string now = dt.ToString("yyyyMMdd");
// 用户
List <UserUserInfo> userList = UserUserInfoService.LoadEntities(u => true).ToList();
userToday = userList.Where(u => u.pubTime == now).ToList().Count;
foreach (UserUserInfo item in userList)
{
DateTime itemDate = DateTime.ParseExact(item.pubTime, "yyyyMMdd", System.Globalization.CultureInfo.CurrentCulture);
//DateTime _itemDate = itemDate.ToShortDateString();
DateTime startMonth = DateTime.ParseExact(dt.AddDays(1 - dt.Day).ToString("yyyyMMdd"), "yyyyMMdd", System.Globalization.CultureInfo.CurrentCulture);
//本月月初 带分钟
//DateTime _startMonth = DateTime.ParseExact(startMonth.ToShortDateString(), "yyyyMMdd", System.Globalization.CultureInfo.CurrentCulture);
//DateTime endMonth = startMonth.AddMonths(1).AddDays(-1); //本月月末
DateTime endMonth = DateTime.ParseExact(dt.AddDays(1 - dt.Day).AddMonths(1).AddDays(-1).ToString("yyyyMMdd"), "yyyyMMdd", System.Globalization.CultureInfo.CurrentCulture);
//DateTime _endMonth = DateTime.ParseExact(startMonth.ToShortDateString(), "yyyyMMdd", System.Globalization.CultureInfo.CurrentCulture);
if (itemDate >= startMonth && itemDate <= endMonth)
{
userMonth++;
}
}
userHis = userList.Count;
// 订单
int orderToday = 0;
int orderMonth = 0;
int orderHis = 0;
int waitOrder = 0;
int placedOrder = 0;
List <OrdersUserHouse> ouhList = OrdersUserHouseService.LoadEntities(o => true).ToList();
orderToday = ouhList.Where(o => o.pubTime == now).ToList().Count;
foreach (OrdersUserHouse ouh in ouhList)
{
Orders order = OrdersService.LoadEntities(o => o.oid == ouh.oid).FirstOrDefault();
DateTime itemDate = DateTime.ParseExact(ouh.pubTime, "yyyyMMdd", System.Globalization.CultureInfo.CurrentCulture);
DateTime startMonth = dt.AddDays(1 - dt.Day); //本月月初
DateTime endMonth = startMonth.AddMonths(1).AddDays(-1); //本月月末
if (itemDate >= startMonth && itemDate <= endMonth)
{
orderMonth++;
}
if (order.state == "0")
{
waitOrder++;
}
if (order.state == "1")
{
placedOrder++;
}
}
orderHis = ouhList.Count;
// 房屋
int houseToday = 0;
int houseMonth = 0;
int houseHis = 0;
List <House> houseList = HouseService.LoadEntities(h => true).ToList();
houseToday = houseList.Where(h => h.time == now).ToList().Count;
foreach (House item in houseList)
{
DateTime itemDate = DateTime.ParseExact(item.time, "yyyyMMdd", System.Globalization.CultureInfo.CurrentCulture);
DateTime startMonth = dt.AddDays(1 - dt.Day); //本月月初
DateTime endMonth = startMonth.AddMonths(1).AddDays(-1); //本月月末
if (itemDate >= startMonth && itemDate <= endMonth)
{
houseMonth++;
}
}
houseHis = houseList.Count;
Dictionary <string, int> userChart = new Dictionary <string, int>();
Dictionary <string, int> houseChart = new Dictionary <string, int>();
DateTime last7Day = DateTime.Now.AddDays(-6);
for (int i = 0; i <= 6; i++)
{
string date = last7Day.ToString("yyyyMMdd");
//DateTime itemDate = DateTime.ParseExact(date, "yyyyMMdd", System.Globalization.CultureInfo.CurrentCulture);
int count = UserUserInfoService.LoadEntities(u => u.pubTime == date).ToList().Count;
int countHouse = HouseService.LoadEntities(h => h.time == date).ToList().Count;
userChart.Add(date, count);
houseChart.Add(date, countHouse);
last7Day = last7Day.AddDays(1);
}
houseList = HouseService.LoadEntities(h => h.province == province).ToList();
Dictionary <string, int> houseDic = new Dictionary <string, int>();
foreach (House item in houseList)
{
if (!houseDic.ContainsKey(item.city))
{
houseDic.Add(item.city, 1);
}
else
{
int count = houseDic[item.city] += 1;
houseDic[item.city] = count;
}
}
List <string> userChartX = userChart.Keys.ToList();
List <int> userChartY = userChart.Values.ToList();
//List<string> houseDicX = houseDic.Keys.ToList();
List <int> houseDicY = houseDic.Values.ToList();
List <HousePie> housePie = new List <HousePie>();
foreach (var item in houseDic)
{
housePie.Add(new HousePie {
name = item.Key, value = item.Value.ToString()
});
}
List <string> provinces = new List <string>();
List <DataDictionary> datas = DataDictionaryService.LoadEntities(d => d.dkey == "region").ToList();
foreach (var item in datas)
{
if (!provinces.Contains(item.dvalue3))
{
provinces.Add(item.dvalue3);
}
}
AdminMainEntity entity = new AdminMainEntity
{
userToday = userToday,
userMonth = userMonth,
userHis = userHis,
orderToday = orderToday,
orderMonth = orderMonth,
orderHis = orderHis,
waitOrder = waitOrder,
placedOrder = placedOrder,
houseToday = houseToday,
houseMonth = houseMonth,
houseHis = houseHis,
userChartX = userChartX,
userChartY = userChartY,
//houseDicX = houseDicX,
houseDicY = houseChart.Values.ToList(),
housePie = housePie,
provinces = provinces
};
return(Json(entity, JsonRequestBehavior.AllowGet));
}
private PagedList<DataDictionary> QueryListData(DataDictionarySearch searchModel)
{
int recordCount = 0;
int pageSize = ConstantManager.PageSize;
DataDictionaryService service = new DataDictionaryService();
string Group = searchModel.IsAsc ? searchModel.SortBy : searchModel.SortBy + " Descending";
IList<DataDictionary> allEntities = service.QueryByPage(this.GetSearchFilter(searchModel), Group, pageSize, searchModel.PageIndex + 1, out recordCount);
var formCondition = "var condition=" + JsonConvert.SerializeObject(searchModel);
return new PagedList<DataDictionary>(allEntities, searchModel.PageIndex, pageSize, recordCount, "Id", "Id", formCondition);
}
//
// GET: /Home/
public ActionResult Index(string city = "洛阳市")
{
Session["nav"] = 0;
List <string> provinces = new List <string>();
if (Session["user"] != null)
{
ViewBag.user = Session["user"];
}
List <string> citys = new List <string>();
if (Session["city"] != null)
{
city = Session["city"].ToString();
// 通过城市反查询省
string thisProvince = DataDictionaryService.LoadEntities(d => d.dkey == "region" && d.dvalue2 == city).FirstOrDefault().dvalue3;
provinces.Add(thisProvince);
List <DataDictionary> dataDic = DataDictionaryService.LoadEntities(d => d.dkey == "region").ToList();
foreach (DataDictionary data in dataDic)
{
if (!provinces.Contains(data.dvalue3))
{
provinces.Add(data.dvalue3);
}
}
// 同理需要查询市
citys.Add(city);
dataDic = DataDictionaryService.LoadEntities(d => d.dkey == "region" && d.dvalue3 == thisProvince).ToList();
foreach (DataDictionary data in dataDic)
{
if (!citys.Contains(data.dvalue2))
{
citys.Add(data.dvalue2);
}
}
//ViewBag.citys = citys;
Session["selectCity"] = citys;
// 给租房列表使用
Session["rentCity"] = city;
//Session["city"] = null;
}
else
{
// 查询所有
List <DataDictionary> dataDic = DataDictionaryService.LoadEntities(d => d.dkey == "region").ToList();
provinces.Add("河南省");
foreach (DataDictionary data in dataDic)
{
if (!provinces.Contains(data.dvalue3))
{
provinces.Add(data.dvalue3);
}
}
dataDic = DataDictionaryService.LoadEntities(d => d.dkey == "region" && d.dvalue3 == "河南省").ToList();
citys.Add("洛阳市");
foreach (DataDictionary data in dataDic)
{
if (!citys.Contains(data.dvalue2))
{
citys.Add(data.dvalue2);
}
}
Session["city"] = Session["rentCity"];
Session["defaultCity"] = citys;
Session["rentCity"] = city;
}
Dictionary <string, List <HousePicture> > houseDic = new Dictionary <string, List <HousePicture> >();
// 出租房
List <House> houseList = HouseService.LoadEntities(t => t.type == "1" && t.state == "0" && t.audit == "1" && t.city == city).ToList();
List <HousePicture> hps = newHousePicture(houseList);
//Console.WriteLine(houseList);
houseDic.Add("rent", hps);
// 新房
houseList = HouseService.LoadEntities(t => t.type == "2" && t.state == "0" && t.audit == "1" && t.city == city).ToList();
hps = newHousePicture(houseList);
houseDic.Add("new", hps);
houseList = HouseService.LoadEntities(t => t.type == "3" && t.state == "0" && t.audit == "1" && t.city == city).ToList();
// houseList.Capacity
// 二手房
hps = newHousePicture(houseList);
houseDic.Add("second", hps);
// 数据字典区域划分 提取session
List <DataDictionary> datas = DataDictionaryService.LoadEntities(t => t.dvalue2 == city).ToList();
Session["region"] = datas;
// 推荐房源
List <House> recommendhouseList = HouseService.LoadEntities(t => t.isRecommend == "1" && t.audit == "1").ToList();
List <HousePicture> rhp = newHousePicture(recommendhouseList);
Session["recommendHouse"] = rhp;
Session["provinces"] = provinces;
ViewBag.houseDic = houseDic;
return(View());
}
