public JsonResult Inserting(string ddxxczxx_id, string ddxxcjsj, string ddxxcjr, string ddxxremark, string ddxxjdsj, string ddxxjdr, string ddxxjd_remark, string ddxxfksj, string ddxxfkr, string ddxxyxfk, string ddxxsjfk, string ddxxzd_id, string ddxxpj) { using (MainDb db = new MainDb()) { zzdc_ddxx ddxx = new zzdc_ddxx(); ddxx.czxx_id = Convert.ToInt32(ddxxczxx_id); ddxx.cjsj = Convert.ToDateTime(ddxxcjsj); ddxx.cjr = ddxxcjr; ddxx.remark = ddxxremark; ddxx.jdsj = Convert.ToDateTime(ddxxjdsj); ddxx.jdr = ddxxjdr; ddxx.jd_remark = ddxxjd_remark; ddxx.fksj = Convert.ToDateTime(ddxxfksj); ddxx.fkr = ddxxfkr; ddxx.yxfk = Convert.ToInt32(ddxxyxfk); ddxx.sjfk = Convert.ToInt32(ddxxsjfk); ddxx.zd_id = Convert.ToInt32(ddxxzd_id); ddxx.pj = ddxxpj; db.zzdc_ddxx.Add(ddxx); int count = db.SaveChanges(); if (count > 0) { return(Json(new { result = "success" })); } else { return(Json(new { result = "fail" })); } } }
// GET: Mobiel/Home public ActionResult Index() { using (MainDb db = new MainDb()) { int dinlingTableId = Int32.Parse(Request["dinlingTableId"] ?? "1"); var orderList = db.zzdc_ddxx.Where(p => p.czxx_id == dinlingTableId && p.zd_id < 2).ToList(); if (orderList.Count > 0) { OrderID = orderList[0].id; } else { zzdc_ddxx newOrder = new zzdc_ddxx(); newOrder.cjsj = DateTime.Now; newOrder.cjr = "test"; newOrder.remark = ""; newOrder.yxfk = 0; newOrder.zd_id = 0; newOrder.czxx_id = dinlingTableId; db.zzdc_ddxx.Add(newOrder); int count = db.SaveChanges(); newOrder = db.zzdc_ddxx.Where(p => p.czxx_id == dinlingTableId && p.zd_id < 2).First(); OrderID = newOrder.id; //增加订单 } var typeList = db.zzdc_cplx.Take(10).ToList(); var idlist = typeList.Select(p1 => p1.id).ToList(); var itemList = db.zzdc_cpxx.Where(p => idlist.Contains(p.cplx_id) && p.sfsj == 1).Take(100).ToList(); var result = new List <Menu>(); foreach (var type in typeList) { var tmp = new List <MenuItem>(); foreach (var item in itemList.Where(p => p.cplx_id == type.id)) { tmp.Add(new MenuItem { id = item.id, name = item.name, summary = item.remark, imgUrl = item.img, price = item.price, count = 0 }); } result.Add(new Menu { tagID = type.id, tagName = type.name, items = tmp }); } return(View(result)); } }