public void DeleteTuijian(int tjkey)
{
DianDianEntities db = new DianDianEntities();
var delList = db.dd_tuijian_link.Where(p => p.sid == tjkey).ToList();
foreach (var delid in delList)
{
var delbean = db.dd_tuijian_link.Find(delid);
db.dd_tuijian_link.Attach(delbean);
db.dd_tuijian_link.Remove(delbean);
db.SaveChanges();
}
dd_tuijian tj = new dd_tuijian();
tj.tjid = tjkey;
db.dd_tuijian.Attach(tj);
db.dd_tuijian.Remove(tj);
db.SaveChanges();
}
public void SaveTuijian(int tjkey, string items, int afternum, string liyou, List <itemTuijian> tuijianList)
{
try
{
int shopkey = Properties.Settings.Default.shopkey;
DianDianEntities db = new DianDianEntities();
var tjbean = db.dd_tuijian.Find(tjkey);
if (tjbean != null)
{
tjbean.afternum = afternum;
tjbean.items = items;
tjbean.liyou = liyou;
db.dd_tuijian.Attach(tjbean);
var stateEntity = ((IObjectContextAdapter)db).ObjectContext.ObjectStateManager.GetObjectStateEntry(tjbean);
stateEntity.SetModifiedProperty("afternum");
stateEntity.SetModifiedProperty("items");
stateEntity.SetModifiedProperty("liyou");
db.SaveChanges();
List <int> keepList = new List <int>();
foreach (var tuijian in tuijianList)
{
var tjLink = db.dd_tuijian_link.Where(p => p.itemkey == tuijian.itemkey && p.guigeid == tuijian.guigeid && p.tuijianid == tjbean.tjid).FirstOrDefault();
if (tjLink == null)
{
tjLink = new dd_tuijian_link();
tjLink.guigeid = tuijian.guigeid;
tjLink.itemkey = tuijian.itemkey;
tjLink.name = tuijian.name;
tjLink.num = tuijian.num;
tjLink.price = tuijian.price;
tjLink.thumb = tuijian.thumb;
tjLink.tuijianid = tjbean.tjid;
db.dd_tuijian_link.Add(tjLink);
}
else
{
tjLink.name = tuijian.name;
tjLink.num = tuijian.num;
tjLink.price = tuijian.price;
tjLink.thumb = tuijian.thumb;
db.dd_tuijian_link.Attach(tjLink);
var stateEntity2 = ((IObjectContextAdapter)db).ObjectContext.ObjectStateManager.GetObjectStateEntry(tjLink);
stateEntity.SetModifiedProperty("name");
stateEntity.SetModifiedProperty("num");
stateEntity.SetModifiedProperty("price");
stateEntity.SetModifiedProperty("thumb");
db.SaveChanges();
keepList.Add(tjLink.sid);
}
}
var delList = db.dd_tuijian_link.Where(p => !keepList.Contains(p.sid)).ToList();
foreach (var delid in delList)
{
var delbean = db.dd_tuijian_link.Find(delid.sid);
db.dd_tuijian_link.Attach(delbean);
db.dd_tuijian_link.Remove(delbean);
db.SaveChanges();
}
}
else
{
tjbean = new dd_tuijian();
tjbean.afternum = afternum;
tjbean.createdate = DateTime.Now;
tjbean.items = items;
tjbean.liyou = liyou;
tjbean.peoplenum = 1;
tjbean.timesbyday = -1;
tjbean.shopkey = shopkey;
tjbean.operater = BizLoginController.userid;
db.dd_tuijian.Add(tjbean);
db.SaveChanges();
foreach (var tuijian in tuijianList)
{
dd_tuijian_link tdl = new dd_tuijian_link();
tdl.guigeid = tuijian.guigeid;
tdl.itemkey = tuijian.itemkey;
tdl.name = tuijian.name;
tdl.num = tuijian.num;
tdl.price = tuijian.price;
tdl.thumb = tuijian.thumb;
tdl.tuijianid = tjbean.tjid;
db.dd_tuijian_link.Add(tdl);
}
db.SaveChanges();
}
}
catch (Exception e)
{
log.Error("SaveTuijian error. msg=" + e.Message);
throw;
}
}