public async Task <IActionResult> Move(int?id)
{
var now = "-(" + TimeZoneInfo.ConvertTime(DateTime.Now, TimeZoneInfo.FindSystemTimeZoneById("China Standard Time")).ToString("yyyy-MM-dd HH:mm") + ")-";
_context.BrhImprestRecord.Include(b => b.BrhImprestAccounts).Where(x => x.ImprestAccountsId == id && x.IsFinance && !x.IsMove).ToList().ForEach(x =>
{
x.IsMove = true;
_context.Update(x);
var expendRecord = new BrhExpendRecord();
expendRecord.EnteringDate = x.EnteringDate;
expendRecord.ExpendType = x.ExpendType;
expendRecord.Purpose = x.Purpose;
expendRecord.Amount = x.Amount;
expendRecord.PaymentType = x.PaymentType;
expendRecord.ConnectNumber = x.ConnectNumber;
expendRecord.Branch = x.Branch;
expendRecord.EnteringStaff = x.EnteringStaff;
expendRecord.IsFinance = x.IsFinance;
expendRecord.Note = "备用金转入" + now + x.Note;
_context.Add(expendRecord);
});
_context.SaveChanges();
var total = _context.BrhImprestRecord.Where(x => x.ImprestAccountsId == id && !x.IsMove).Sum(x => x.Amount);
var brhImprestAccount = _context.BrhImprestAccounts.SingleOrDefault(x => x.ImprestAccountsId == id);
brhImprestAccount.Equity = brhImprestAccount.Balance - total;
_context.Update(brhImprestAccount);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index), new { id = id }));
}
public async Task <IActionResult> Edit(int id, [Bind("ExpendRecordId,EnteringDate,ExpendType,Purpose,Amount,PaymentType,ConnectNumber,EnteringStaff,Branch,Note")] BrhExpendRecord brhExpendRecord)
{
if (id != brhExpendRecord.ExpendRecordId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
//brhExpendRecord.EnteringDate = TimeZoneInfo.ConvertTime(brhExpendRecord.EnteringDate, TimeZoneInfo.FindSystemTimeZoneById("China Standard Time"));
_context.Update(brhExpendRecord);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!BrhExpendRecordExists(brhExpendRecord.ExpendRecordId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(PartialView("~/Areas/Branch/Views/BrhExpendRecord/CreateEdit.cshtml", brhExpendRecord));
}
public async Task <IActionResult> Create([Bind("ExpendRecordId,EnteringDate,ExpendType,Purpose,Amount,PaymentType,ConnectNumber,EnteringStaff,Branch,Note")] BrhExpendRecord brhExpendRecord)
{
if (ModelState.IsValid)
{
brhExpendRecord.EnteringDate = TimeZoneInfo.ConvertTime(brhExpendRecord.EnteringDate, TimeZoneInfo.FindSystemTimeZoneById("China Standard Time"));
_context.Add(brhExpendRecord);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(PartialView("~/Areas/Branch/Views/BrhExpendRecord/CreateEdit.cshtml", brhExpendRecord));
}
public async Task <IActionResult> Create([Bind("ExpendRecordId,EnteringDate,ExpendType,Purpose,Amount,PaymentType,ConnectNumber,EnteringStaff,Branch,Note")] BrhExpendRecord brhExpendRecord)
{
if (ModelState.IsValid)
{
brhExpendRecord.EnteringDate = TimeZoneInfo.ConvertTime(brhExpendRecord.EnteringDate, TimeZoneInfo.FindSystemTimeZoneById("China Standard Time"));
_context.Add(brhExpendRecord);
await _context.SaveChangesAsync();
var temp = _context.FncBranch.SingleOrDefault(x => x.BranchName == brhExpendRecord.Branch);
return(RedirectToAction(nameof(Index), new { branchName = temp.BranchName, branchId = temp.BranchId, count = temp.Count }));
}
return(PartialView("~/Areas/Finance/Views/FncExpendRecord/CreateEdit.cshtml", brhExpendRecord));
}
//[HttpPost]
//[ValidateAntiForgeryToken]
public async Task <IActionResult> Move(int?id)
{
//var brhScalp = _context.BrhScalp.Where(x => x.ImprestAccountsId == id&&x.IsFinance&&!x.IsMove).ToList();
//foreach(var b in brhScalp)
//{
// b.IsMove = true;
//}
//_context.UpdateRange(brhScalp);
//await _context.SaveChangesAsync();
var now = "-(" + TimeZoneInfo.ConvertTime(DateTime.Now, TimeZoneInfo.FindSystemTimeZoneById("China Standard Time")).ToString("yyyy-MM-dd HH:mm") + ")-";
_context.BrhScalp.Where(x => x.ImprestAccountsId == id && x.IsFinance && !x.IsMove).ToList().ForEach(x =>
{
x.IsMove = true;
_context.Update(x);
var expendRecord = new BrhExpendRecord();
expendRecord.EnteringDate = x.EnteringDate;
expendRecord.ExpendType = "线上推广";
expendRecord.Purpose = "刷单";
expendRecord.Amount = x.Commission;
expendRecord.PaymentType = "推广备用金";
expendRecord.ConnectNumber = "";
expendRecord.Branch = x.Branch;
expendRecord.EnteringStaff = x.EnteringStaff;
expendRecord.IsFinance = x.IsFinance;
expendRecord.Note = "备用金转入" + now + x.Note;
if (expendRecord.Amount > 0)
{
_context.Add(expendRecord);
}
});
_context.SaveChanges();
var total = _context.BrhScalp.Where(x => x.ImprestAccountsId == id && !x.IsMove).Sum(x => x.TotalPrice);
var brhImprestAccount = _context.BrhImprestAccounts.SingleOrDefault(x => x.ImprestAccountsId == id);
brhImprestAccount.Equity = brhImprestAccount.Balance - total;
_context.Update(brhImprestAccount);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
