/// <summary> /// Inserts the activity pro. /// </summary> /// <param name="activityID">The activity identifier.</param> /// <param name="procode">The procode.</param> /// <param name="proid">The proid.</param> /// <param name="buytime">The buytime.</param> /// <param name="num">The number.</param> /// <param name="imagepath">The imagepath.</param> /// <returns></returns> /// 创建人:李允智 /// 创建时间:2015/9/11 /// 描述:插入活动商品 public static bool InsertActivityPro(Guid activityID, string procode, Guid proid, string buytime, string num, string imagepath, string desimgpath) { using (Model.BestCherryEntities entitys = new Model.BestCherryEntities()) { try { ActivityPro att = new ActivityPro(); att.ID = Guid.NewGuid(); att.ACTIVITYID = activityID; att.PROCODE = procode; att.PROID = proid; att.BUYTIME = buytime; att.NUM = int.Parse(num); att.IMAGEPATH = imagepath; att.DESIMGPATH = desimgpath; entitys.ActivityProes.Add(att); entitys.SaveChanges(); return(true); } catch (Exception) { return(false); throw; } } }
public static bool UpdateActivityPro(Guid id, string buytime, string num, string imagepath, string desimgpath) { using (Model.BestCherryEntities entitys = new Model.BestCherryEntities()) { try { List <ActivityPro> list = entitys.ActivityProes.Where(a => a.ID == id).ToList(); if (list.Count > 0) { ActivityPro att = list[0]; att.BUYTIME = buytime; att.NUM = int.Parse(num); att.IMAGEPATH = imagepath; att.DESIMGPATH = desimgpath; //将实体对象加入EF对象容器中,并获取伪包装类对象 DbEntityEntry <ActivityPro> entry = entitys.Entry <ActivityPro>(att); entry.State = System.Data.Entity.EntityState.Modified; entitys.SaveChanges(); } return(true); } catch (Exception) { return(false); throw; } } }
/// <summary> /// Deletes the activity pro. /// </summary> /// <param name="ID">The identifier.</param> /// <returns></returns> /// 创建人:李允智 /// 创建时间:2015/9/14 /// 描述:删除活动商品 public static bool DeleteActivityPro(Guid ID) { using (Model.BestCherryEntities entitys = new Model.BestCherryEntities()) { List <ActivityPro> activityProList = (from a in entitys.ActivityProes select a).Where(a => a.ID == ID).ToList(); try { if (activityProList.Count >= 1) { ActivityPro deleteActivityProes = activityProList[0]; entitys.ActivityProes.Attach(deleteActivityProes); entitys.ActivityProes.Remove(deleteActivityProes); entitys.SaveChanges(); } return(true); } catch (Exception) { return(false); throw; } } }