/// <summary> /// 获取所有房间状态 /// </summary> /// <returns></returns> public List <SexViewModel> GetStateTxt() { using (HotelManageDBEntities db = new HotelManageDBEntities()) { var data = from r in db.Room_State where r.RoomId == null select new { r.Id, r.StateTxt }; List <SexViewModel> list = new List <SexViewModel>(); SexViewModel sex = new SexViewModel(); sex.Id = 0; sex.Sex = "全部类型"; list.Add(sex); foreach (var item in data) { SexViewModel s = new SexViewModel(); s.Id = item.Id; s.Sex = item.StateTxt; list.Add(s); } return(list); } }
/// <summary> /// 获取所有的楼层 /// </summary> /// <returns></returns> public JsonResult GetFloorNum() { List <SexViewModel> listStaffId = new List <SexViewModel>(); string[] list = { "全部楼层", "一 楼", "二 楼", "三 楼", "四 楼", "五 楼" }; for (int i = 0; i < 6; i++) { SexViewModel sexViewModel = new SexViewModel(); sexViewModel.Id = i; sexViewModel.Sex = list[i]; listStaffId.Add(sexViewModel); } return(Json(listStaffId, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 获取性别列表 /// </summary> /// <returns></returns> public ActionResult GetSex() { List <SexViewModel> list = new List <SexViewModel>(); string[] st = { "女", "男" }; for (int i = 0; i < 2; i++) { SexViewModel s = new SexViewModel(); s.Id = i; s.Sex = st[i]; list.Add(s); } return(Json(list, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 获取所有商品名称 /// </summary> /// <returns></returns> public List <SexViewModel> GetAllCommodityName() { using (HotelManageDBEntities db = new HotelManageDBEntities()) { var data = from c in db.Commodity select new { c.Id, c.Name }; List <SexViewModel> list = new List <SexViewModel>(); foreach (var item in data) { SexViewModel s = new SexViewModel(); s.Id = item.Id; s.Sex = item.Name; list.Add(s); } return(list); } }