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