//
// GET: /Adv/Edit/5
public ActionResult Edit(int id)
{
adv_machine_product_list adv_machine_product_list = db.adv_machine_product_list.Single(a => a.id == id);
List <string> tl = new List <string>();
var types = db.tbl_product_type.ToList();
foreach (tbl_product_type tpt in types)
{
tl.Add(tpt.name);
}
List <List <tbl_product> > pl = new List <List <tbl_product> >();
foreach (string type in tl)
{
Dictionary <string, int> p = new Dictionary <string, int>();
int type_id = db.tbl_product_type.Single(t => t.name == type).id;
List <tbl_product> products = (from t in db.tbl_product
where t.product_type == type_id
select t).ToList();
pl.Add(products);
}
int pt_id = (int)db.tbl_product.Single(p => p.product_id == adv_machine_product_list.product_id).product_type;
ViewBag.type = db.tbl_product_type.Single(p => p.id == pt_id).name;
ViewBag.product_id = adv_machine_product_list.product_id;
ViewBag.typeList = tl;
ViewBag.productList = pl;
return(View(adv_machine_product_list));
}
public ActionResult Edit(adv_machine_product_list adv_machine_product_list)
{
if (ModelState.IsValid)
{
db.adv_machine_product_list.Attach(adv_machine_product_list);
db.ObjectStateManager.ChangeObjectState(adv_machine_product_list, EntityState.Modified);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(adv_machine_product_list));
}
public JsonResult AdvMachineInfo(string machineName)
{
List <ProductInfo>[] pl = new List <ProductInfo> [6];
pl[0] = new List <ProductInfo>();
for (int i = 1; i < 4; i++)
{
adv_machine_product_list amp = (from adv in db.adv_machine_product_list
where adv.machine_name == machineName && adv.location == i
select adv).Single();
tbl_product temp = db.tbl_product.Single(m => m.product_id == amp.product_id);
pl[0].Add(new ProductInfo
{
product_id = temp.product_id,
product_name = temp.product_name,
short_url = temp.short_url,
ticket_url = temp.short_url,
pic_url = 微信活动管理.Config.ConfigManager.getConfig("pic-url") + temp.pic_url
});
}
for (int i = 1; i < 6; i++)
{
pl[i] = new List <ProductInfo>();
int type = i;
List <tbl_product> products = (from pro in db.tbl_product
where (pro.product_type == type && pro.push_level != 0)
orderby pro.product_id descending
select pro).ToList();
foreach (tbl_product item in products)
{
ProductInfo pi = new ProductInfo();
pi.product_id = item.product_id;
pi.product_name = item.product_name;
pi.short_url = item.short_url;
pi.ticket_url = item.ticket_url;
pi.pic_url = 微信活动管理.Config.ConfigManager.getConfig("pic-url") + item.pic_url;
pl[i].Add(pi);
}
}
JsonResult res = Json(new
{
daping = pl[0],
ziyouyizu = pl[1],
youyisi = pl[2],
youleyouxuan = pl[3],
liangyouyou = pl[4],
guoyouyou = pl[5]
});
res.JsonRequestBehavior = JsonRequestBehavior.AllowGet;
return(res);
}
//
// GET: /Adv/Details/5
public ViewResult Details(int id)
{
adv_machine_product_list adv_machine_product_list = db.adv_machine_product_list.Single(a => a.id == id);
tbl_product t = db.tbl_product.Single(a => a.product_id == adv_machine_product_list.product_id);
string type = db.tbl_product_type.Single(name => name.id == t.product_type).name;
ProductModel pm = new ProductModel
{
product_id = t.product_id,
product_name = t.product_name,
create_time = t.create_time,
description = t.description,
pic_url = t.pic_url,
product_type = type,
content_url = t.content_url,
push_level = PushLevelModel.GetPushName(t.push_level),
ticket_url = t.ticket_url,
short_url = t.short_url
};
return(View(pm));
}
