//删除原料 public void DelCrude(int crudeid) { try { DianDianEntities db = new DianDianEntities(); storage_crude crude = db.storage_crude.Find(crudeid); crude.state = 1; db.storage_crude.Attach(crude); var stateEntity = ((IObjectContextAdapter)db).ObjectContext.ObjectStateManager.GetObjectStateEntry(crude); stateEntity.SetModifiedProperty("state"); db.SaveChanges(); } catch (Exception e) { log.Error("DelCrude error. msg=" + e.Message); throw; } }
//保存原料 public void SaveCrude(int crudeid, int genreid, string crudename, string unit) { try { DianDianEntities db = new DianDianEntities(); storage_crude crude = db.storage_crude.Find(crudeid); if (crude == null) { crude = new storage_crude(); crude.createdate = DateTime.Now; crude.genreid = genreid; crude.crudename = crudename; crude.unit = unit; crude.shopkey = Properties.Settings.Default.shopkey; crude.state = 0; db.storage_crude.Add(crude); } else { crude.genreid = genreid; crude.crudename = crudename; crude.unit = unit; db.storage_crude.Attach(crude); var stateEntity = ((IObjectContextAdapter)db).ObjectContext.ObjectStateManager.GetObjectStateEntry(crude); stateEntity.SetModifiedProperty("genreid"); stateEntity.SetModifiedProperty("crudename"); stateEntity.SetModifiedProperty("unit"); } db.SaveChanges(); } catch (Exception e) { log.Error("SaveCrude error. msg=" + e.Message); throw; } }