public JsonResult deleteOrder(string ouhid)
        {
            int             ouhidInt = Convert.ToInt32(ouhid);
            OrdersUserHouse ouh      = OrdersUserHouseService.LoadEntities(o => o.ouhid == ouhidInt).FirstOrDefault();

            bool res = OrdersUserHouseService.DeleteEntity(ouh);

            return(Json(res, JsonRequestBehavior.AllowGet));
        }
Exemple #2
0
        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));
            }
        }
Exemple #3
0
        public ActionResult CancelOrder(string oid, string hid)
        {
            int oidInt = Convert.ToInt32(oid);
            int hidInt = Convert.ToInt32(hid);

            Orders order = OrdersService.LoadEntities(o => o.oid == oidInt).FirstOrDefault();
            House  house = HouseService.LoadEntities(h => h.hid == hidInt).FirstOrDefault();

            house.state = "0";
            OrdersUserHouse ordersUserHouse = OrdersUserHouseService.LoadEntities(o => o.oid == oidInt).FirstOrDefault();

            OrdersService.DeleteEntity(order);
            HouseService.EditEntity(house);
            OrdersUserHouseService.DeleteEntity(ordersUserHouse);

            My.RentingSystem.Model.User user = Session["user"] as My.RentingSystem.Model.User;
            @ViewBag.uid = user.uid;
            return(View("MyOrder", new { id = user.uid }));
        }
        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));
        }
Exemple #5
0
        /// <summary>
        /// 个人订单
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public ActionResult MyOrderPartial(string id)
        {
            // userid = id
            int uid = Convert.ToInt32(id);

            //My.RentingSystem.Model.User user = Session["user"] as My.RentingSystem.Model.User;

            List <OrdersUserHouse> ouhList    = OrdersUserHouseService.LoadEntities(o => o.uid == uid).ToList();
            List <House>           houseList  = new List <House>();
            List <Orders>          ordersList = new List <Orders>();

            foreach (OrdersUserHouse ouh in ouhList)
            {
                houseList.Add(HouseService.LoadEntities(h => h.hid == ouh.hid).FirstOrDefault());
                ordersList.Add(OrdersService.LoadEntities(o => o.oid == ouh.oid).FirstOrDefault());
            }

            List <HousePicture> hps = newHousePicture(houseList);

            ViewBag.hps    = hps;
            ViewBag.orders = ordersList;

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