public async Task <IActionResult> OnPostAsync() { if (!ModelState.IsValid) { return(Page()); } _context.Attach(tb_收付表).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!tb_收付表Exists(tb_收付表.RecordId)) { return(NotFound()); } else { throw; } } return(RedirectToPage("./Index")); }
public async Task <IActionResult> OnPostAsync(int?id) { if (id == null) { return(NotFound()); } var tb_订单表 = await _context.tb_订单表.FindAsync(id); if (tb_订单表 != null) { var tb_订单表D = _context.tb_订单表D.Where(p => p.RecordId == tb_订单表.RecordId); foreach (var localD in tb_订单表D) { foreach (var remoteD in _context.tb_报价表D.Where(p => p.子单号 == localD.子单号)) { remoteD.状态 = ""; } } _context.tb_订单表.Remove(tb_订单表); _context.tb_订单表D.RemoveRange(tb_订单表D); await _context.SaveChangesAsync(); } return(RedirectToPage("./Index")); }
public async Task <IActionResult> OnPostAsync() { if (!ModelState.IsValid) { return(Page()); } //var tb_商品 = _context.tb_商品表.FirstOrDefault(m => m.RecordId == vm_地板.RecordId); //_mapper.Map<vm_商品_地板, tb_商品表>(vm_地板, tb_商品); //Common.ModelHelper.CompleteMainOnEdit(tb_商品); _context.funcEditRecord <vm_商品_地板, tb_商品表>(vm_地板); try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!sys商品表Exists(vm_地板.RecordId)) { return(NotFound()); } else { throw; } } return(RedirectToPage("./Index")); }
public async Task <IActionResult> OnPostAsync() { if (!ModelState.IsValid) { return(Page()); } var remote = _context.tb_报价表.FirstOrDefault(m => m.RecordId == vm_Main.RecordId); if (remote == null) { return(NotFound()); } // 非空字段赋值给跟踪实体 vm_Main.往来 = _context.tb_往来表.AsNoTracking().FirstOrDefault(p => p.往来号 == vm_Main.往来号)?.简称; // 修改时间 vm_Main.LastEditTime = DateTime.Now; vm_Main.LastEditUser = vm_Main.LastEditUser ?? "张凯译"; _mapper.Map <vm_销售报价, tb_报价表>(vm_Main, remote); var remoteDetails = _context.tb_报价表D.Where(d => d.RecordId == remote.RecordId); // 数据库中的子单号与新明细中没有相同的,则从数据库中删除 foreach (var remoteD in remoteDetails) { if (!vm_Details.Where(p => !string.IsNullOrEmpty(p.子单号)).Any(p => p.子单号 == remoteD.子单号)) { _context.tb_报价表D.Remove(remoteD); } } // 新明细中的子单号为空,则添加 foreach (var localD in vm_Details.Where(p => string.IsNullOrEmpty(p.子单号))) { Common.ModelHelper.CompleteDetailOnUpdate(remote, localD); localD.子单号 = _context.funcAutoCode("子单号"); _context.tb_报价表D.Add(_mapper.Map <tb_报价表D>(localD)); } // 子单号相同,则赋值 foreach (var localD in vm_Details.Where(p => !string.IsNullOrEmpty(p.子单号))) { foreach (var remoteD in remoteDetails) { if (remoteD.子单号 == localD.子单号) { _mapper.Map <vm_销售报价D, tb_报价表D>(localD, remoteD); break; } } } //_context.tb_报价表D.AddRange(_mapper.Map<IList<tb_报价表D>>(vm_销售报价D列表)); await _context.SaveChangesAsync(); return(RedirectToPage("./Index")); }
public async Task <IActionResult> OnPostAsync() { if (!ModelState.IsValid) { return(Page()); } _context.tb_收付表.Add(tb_收付表); await _context.SaveChangesAsync(); return(RedirectToPage("./Index")); }
public async Task <IActionResult> OnPostAsync() { if (!ModelState.IsValid) { return(Page()); } var remote = _context.funcEditRecord <vm_销售出库, tb_IO>(vm_Main, BeforeNew: before => { // 非空字段赋值给跟踪实体 before.类型 = "销售出库"; before.往来 = _context.Set <tb_往来表>().FirstOrDefault(p => p.往来号 == vm_Main.往来号)?.简称; }); _context.funcEditDetails <vm_销售出库, vm_销售出库D, tb_IO, tb_IOD>(vm_Main, vm_Details, creatingD => { if (string.IsNullOrEmpty(creatingD.子单号)) // 子单号为空的,表示新插入 { creatingD.子单号 = _context.funcAutoCode("子单号"); } else if (!string.IsNullOrEmpty(creatingD.子单号)) // 子单号不为空,表示从报价单引入,插入 { var baojiaD = _context.Set <tb_订单表D>().FirstOrDefault(d => d.子单号 == creatingD.子单号); if (baojiaD != null) { baojiaD.状态 = "已出库"; } } }, updatingD => { var baojiaD = _context.Set <tb_订单表D>().FirstOrDefault(d => d.子单号 == updatingD.子单号); if (baojiaD != null) { baojiaD.状态 = "已出库"; } }, deletingD => { var tb_报价D = _context.Set <tb_订单表D>().FirstOrDefault(d => d.子单号 == deletingD.子单号); if (tb_报价D != null) { tb_报价D.状态 = ""; } }); await _context.SaveChangesAsync(); return(RedirectToPage("./Index")); }
public async Task <IActionResult> OnPostAsync(int?id) { if (id == null) { return(NotFound()); } var tb_商品 = await _context.tb_商品表.FindAsync(id); if (tb_商品 != null) { _context.tb_商品表.Remove(tb_商品); await _context.SaveChangesAsync(); } return(RedirectToPage("./Index")); }
public async Task <IActionResult> OnPostAsync(int?id) { if (id == null) { return(NotFound()); } var tb_报价表 = await _context.tb_报价表.FindAsync(id); if (tb_报价表 != null) { var tb_报价表D = _context.tb_报价表D.Where(p => p.RecordId == tb_报价表.RecordId); _context.tb_报价表.Remove(tb_报价表); _context.tb_报价表D.RemoveRange(tb_报价表D); await _context.SaveChangesAsync(); } return(RedirectToPage("./Index")); }
public async Task <IActionResult> OnPost2Async() { if (!ModelState.IsValid) { return(Page()); } var remote = _context.Set <tb_订单表>().FirstOrDefault(m => m.RecordId == vm_Main.RecordId); if (remote == null) { return(NotFound()); } // 非空字段赋值给跟踪实体 vm_Main.往来 = _context.Set <tb_往来表>().AsNoTracking().FirstOrDefault(p => p.往来号 == vm_Main.往来号)?.简称; _mapper.Map <vm_销售订单, tb_订单表>(vm_Main, remote); var remoteDetails = _context.Set <tb_订单表D>().Where(d => d.RecordId == remote.RecordId).ToList(); // 数据库中的子单号与新明细中没有相同的,则从数据库中删除 foreach (var remoteD in remoteDetails) { if (!vm_Details.Any(p => p.子单号 == remoteD.子单号)) { var tb_报价D = _context.Set <tb_报价表D>().FirstOrDefault(d => d.子单号 == remoteD.子单号); if (tb_报价D != null) { tb_报价D.状态 = ""; } _context.Remove <tb_订单表D>(remoteD); } } foreach (var localD in vm_Details) { Common.ModelHelper.CompleteDetailOnUpdate(remote, localD); if (remoteDetails.Any(d => d.子单号 == localD.子单号)) // 子单号相同的,表示修改 { var remoteD = _context.Set <tb_订单表D>().FirstOrDefault(m => m.子单号 == localD.子单号); _mapper.Map(localD, remoteD); } if (!remoteDetails.Any(d => d.子单号 == localD.子单号)) { if (string.IsNullOrEmpty(localD.子单号)) // 子单号为空的,表示新插入 { localD.子单号 = _context.funcAutoCode("子单号"); _context.Attach <tb_订单表D>(_mapper.Map <tb_订单表D>(localD)).State = EntityState.Added; } else if (!string.IsNullOrEmpty(localD.子单号)) // 子单号不为空,表示从报价单引入,插入 { var baojiaD = _context.Set <tb_报价表D>().FirstOrDefault(d => d.子单号 == localD.子单号); if (baojiaD != null) { baojiaD.状态 = "已下单"; } _context.Attach <tb_订单表D>(_mapper.Map <tb_订单表D>(localD)).State = EntityState.Added; } } } // 数据库中的子单号与新明细中没有相同的,则从数据库中删除 // 新明细中的子单号为空,则添加 // 子单号相同,则赋值 await _context.SaveChangesAsync(); return(RedirectToPage("./Index")); }