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));
}
}
