public ActionResult PostEdit(ProductModel parm)
{
using (LoveBankDBContext db = new LoveBankDBContext())
{
var t_m = db.T_Product;
var t_a = db.T_LoveBank_Ad;
var t_s = db.T_SourceFile;
#region 初始化参数
Product model = t_m.Find(parm.Id);
model.Name = parm.Name;
model.Price = parm.Price;
model.CostScore = parm.CostScore;
model.Count = parm.Count;
model.EndTime = parm.EndTime;
model.StartTime = parm.StartTime;
model.BarCode = parm.BarCode;
model.Desc = parm.Desc;
model.Type = parm.Type;
model.Sponsors = parm.Sponsors;
//foreach (var item in parm.SourceFileList)
//{
// item.Guid = model.Guid;
// item.AddTime = DateTime.Now;
//}
///删除原来的,彻底以新增方式进行（修改通过删除在新增实现）
var delSourceFile = from s in t_s
where (!string.IsNullOrEmpty(model.Guid) && s.Guid == model.Guid)
|| (!string.IsNullOrEmpty(model.LogoGuid) && s.Guid == model.LogoGuid) ||
(!string.IsNullOrEmpty(model.AdGuid) && s.Guid == model.AdGuid)
select s;
db.T_SourceFile.RemoveRange(delSourceFile);
db.SaveChanges();
#endregion
db.Update<Product>(model);
db.SaveChanges();
foreach (var item in parm.SourceFileList)
{
if (string.IsNullOrEmpty(model.Guid))
{
model.Guid = Guid.NewGuid().ToString();
}
item.AddTime = DateTime.Now;
item.Guid = model.Guid;
}
foreach (var item in parm.SourceFileListLogo)
{
if (string.IsNullOrEmpty(model.LogoGuid))
{
model.LogoGuid = Guid.NewGuid().ToString();
}
item.AddTime = DateTime.Now;
item.Guid = model.LogoGuid;
}
foreach (var item in parm.SourceFileListAd)
{
if (string.IsNullOrEmpty(model.AdGuid))
{
model.AdGuid = Guid.NewGuid().ToString();
}
item.AddTime = DateTime.Now;
item.Guid = model.AdGuid;
}
db.T_SourceFile.AddRange(parm.SourceFileList);//重新绑定
if (parm.SourceFileListLogo != null &&parm.SourceFileListLogo.Count > 0)
{
db.T_SourceFile.AddRange(parm.SourceFileListLogo);
}
if (parm.SourceFileListAd!=null&&parm.SourceFileListAd.Count>0)
{
db.T_SourceFile.AddRange(parm.SourceFileListAd);
}
//db.T_SourceFile.AddRange(parm.SourceFileList);
db.SaveChanges();
return Success("修改成功");
}
}
public ActionResult PostAdd(ProductModel parm)
{
#region 初始化参数
Product model = new Product();
model.AddTime = DateTime.Now;
model.AddUserId = AdminUser.ID;
model.State = RowState.有效;
//model.Guid = Guid.NewGuid().ToString();
IdWorker workId = new IdWorker();
model.Guid = workId.nextId().ToString();
model.DeptId = AdminUser.DeptId;
model.Desc = parm.Desc;
model.Name = parm.Name;
model.CostScore = parm.CostScore;
model.Count = parm.Count;
model.EndTime = parm.EndTime;
model.StartTime = parm.StartTime;
model.Price = parm.Price;
model.BarCode = parm.BarCode;
model.Type = parm.Type;
model.Sponsors = parm.Sponsors;
foreach (var item in parm.SourceFileList)
{
item.Guid = model.Guid;
item.AddTime = DateTime.Now;
}
model.LogoGuid = Guid.NewGuid().ToString();
foreach (var item in parm.SourceFileListLogo)
{
item.Guid = model.LogoGuid;
item.AddTime = DateTime.Now;
}
model.AdGuid = Guid.NewGuid().ToString();
foreach (var item in parm.SourceFileListAd)
{
item.Guid = model.AdGuid;
item.AddTime = DateTime.Now;
}
#endregion
using (LoveBankDBContext db = new LoveBankDBContext())
{
db.Add(model);
db.SaveChanges();
db.T_SourceFile.AddRange(parm.SourceFileList);
db.T_SourceFile.AddRange(parm.SourceFileListLogo);
db.T_SourceFile.AddRange(parm.SourceFileListAd);
db.SaveChanges();
return Success("添加成功");
}
}
