public ActionResult Personal(string id) { int uid = Convert.ToInt32(id); UserUserInfo userUserInfo = UserUserInfoService.LoadEntities(u => u.uid == uid).FirstOrDefault(); User user = UserService.LoadEntities(u => u.uid == userUserInfo.uid).FirstOrDefault(); UserInfo userInfo = UserInfoService.LoadEntities(u => u.uiid == userUserInfo.uiid).FirstOrDefault(); ViewBag.user = user; ViewBag.userInfo = userInfo; return(View()); }
public JsonResult deleteUser(string uid, string uiid) { //Console.WriteLine(); int uidInt = Convert.ToInt32(uid); int uiidInt = Convert.ToInt32(uiid); UserUserInfo uui = UserUserInfoService.LoadEntities(u => u.uid == uidInt && u.uiid == uiidInt).FirstOrDefault(); UserUserInfoService.DeleteEntity(uui); UserAuth userAuth = UserAuthService.LoadEntities(u => u.uid == uidInt).FirstOrDefault(); UserAuthService.DeleteEntity(userAuth); //UserService.DeleteEntity(user); return(Json("success", JsonRequestBehavior.AllowGet)); }
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)); }
public JsonResult getOrders(string pageSize, string page, string name, string oid, string community, string area, string unitType, string duration, string rent, string floor, string time, string state ) { List <OrdersUserHouse> ouhList = OrdersUserHouseService.LoadEntities(o => true).ToList(); List <OrdersUserHouseEntity> entity = new List <OrdersUserHouseEntity>(); foreach (OrdersUserHouse item in ouhList) { Orders orders = OrdersService.LoadEntities(o => o.oid == item.oid).FirstOrDefault(); User user = UserService.LoadEntities(o => o.uid == item.uid).FirstOrDefault(); int uiid = UserUserInfoService.LoadEntities(u => u.uid == user.uid).FirstOrDefault().uiid; UserInfo userInfo = UserInfoService.LoadEntities(u => u.uiid == uiid).FirstOrDefault(); House house = HouseService.LoadEntities(h => h.hid == item.hid).FirstOrDefault(); entity.Add(new OrdersUserHouseEntity() { name = userInfo.name, phone = userInfo.phone, duration = orders.duration, rent = orders.rent, state = orders.state, time = orders.time, ouhid = item.ouhid, hid = house.hid, community = house.community, unitType = house.unitType, area = house.area, oid = orders.oid, floor = house.floor }); } int pageInt = Convert.ToInt32(page); int pageSizeInt = Convert.ToInt32(pageSize); if (!string.IsNullOrWhiteSpace(state)) { //int oidInt = Convert.ToInt32(oid); entity = entity.Where(u => u.state == state).ToList(); } //time = time.Replace("-",""); // 20210326 if (!string.IsNullOrWhiteSpace(time)) { time = time.Substring(0, 10).Replace("-", ""); DateTime itemDate = DateTime.ParseExact(time, "yyyyMMdd", System.Globalization.CultureInfo.CurrentCulture); itemDate = itemDate.AddDays(1); string formatDate = itemDate.ToString("yyyyMMdd"); //int oidInt = Convert.ToInt32(oid); entity = entity.Where(u => u.time == formatDate).ToList(); } if (!string.IsNullOrWhiteSpace(oid)) { int oidInt = Convert.ToInt32(oid); entity = entity.Where(u => u.oid == oidInt).ToList(); } if (!string.IsNullOrWhiteSpace(area)) { int areaInt = Convert.ToInt32(area); entity = entity.Where(u => u.area == areaInt).ToList(); } if (!string.IsNullOrWhiteSpace(duration)) { int durationInt = Convert.ToInt32(duration); entity = entity.Where(u => u.duration == durationInt).ToList(); } if (!string.IsNullOrWhiteSpace(rent)) { int rentInt = Convert.ToInt32(rent); entity = entity.Where(u => u.rent == rentInt).ToList(); } if (!string.IsNullOrWhiteSpace(name)) { entity = entity.Where(u => u.name.Contains(name)).ToList(); } if (!string.IsNullOrWhiteSpace(community)) { entity = entity.Where(u => u.community.Contains(community)).ToList(); } if (!string.IsNullOrWhiteSpace(unitType)) { entity = entity.Where(u => u.unitType.Contains(unitType)).ToList(); } if (!string.IsNullOrWhiteSpace(floor)) { entity = entity.Where(u => u.floor.Contains(floor)).ToList(); } int total = entity.Count; entity = entity.Skip((pageInt - 1) * pageSizeInt).Take(pageSizeInt).ToList(); return(Json(new { entity = entity, total = total }, JsonRequestBehavior.AllowGet)); }
public JsonResult getUser( string pageSize, string name, string page, string username, string password, string phone, string sex, string isSys) { List <UserUserInfo> uuiList = UserUserInfoService.LoadEntities(t => true).ToList(); List <UserUserInfoEntity> entity = new List <UserUserInfoEntity>(); foreach (UserUserInfo item in uuiList) { User user = UserService.LoadEntities(u => u.uid == item.uid).FirstOrDefault(); UserInfo userInfo = UserInfoService.LoadEntities(u => u.uiid == item.uiid).FirstOrDefault(); entity.Add(new UserUserInfoEntity { uid = user.uid, uiid = userInfo.uiid, username = user.username, password = user.password, name = userInfo.name, sex = userInfo.sex, phone = userInfo.phone, isSys = user.isSys }); } int pageInt = Convert.ToInt32(page); int pageSizeInt = Convert.ToInt32(pageSize); if (!string.IsNullOrEmpty(name)) { entity = entity.Where(u => u.name.Contains(name)).ToList(); } if (!string.IsNullOrWhiteSpace(username)) { entity = entity.Where(u => u.username.Contains(username)).ToList(); } if (!string.IsNullOrWhiteSpace(isSys)) { entity = entity.Where(u => u.isSys == isSys).ToList(); } if (!string.IsNullOrWhiteSpace(password)) { entity = entity.Where(u => u.password.Contains(password)).ToList(); } if (!string.IsNullOrWhiteSpace(sex)) { entity = entity.Where(u => u.sex == sex).ToList(); } if (!string.IsNullOrWhiteSpace(phone)) { entity = entity.Where(u => u.phone.Contains(phone)).ToList(); } int total = entity.Count; entity = entity.Skip((pageInt - 1) * pageSizeInt).Take(pageSizeInt).ToList(); return(Json(new { entity = entity, total = total }, JsonRequestBehavior.AllowGet)); }