private void InsertZyJsmx(ZyBrry zyBrry)
{
var query = zyBrry.ZyFymxs.GroupBy(p => new { p.Zyh, p.Jscs, p.Fyks, p.Fyxm, p })
.Select(t => new
{
t.Key,
Zjje = t.Sum(p => p.Zjje),
Zfje = t.Sum(p => p.Zfje),
Zlje = t.Sum(p => p.Zlje)
}).ToList();
if (query.Any())
{
foreach (var item in query)
{
var zyJsmx = new ZyJsmx()
{
Zyh = zyBrry.Zyh,
Jscs = item.Key.Jscs,
Ksdm = item.Key.Fyks,
Fyxm = item.Key.Fyxm,
Zjje = item.Zjje,
Zfje = item.Zfje,
Zlje = item.Zlje
};
Ctx.ZyJsmxSet.Add(zyJsmx);
}
}
Ctx.SaveChanges();
}
/// <summary>
///
/// </summary>
/// <param name="zyBrry"></param>
private void UpdateZyBrry(ZyBrry zyBrry)
{
zyBrry.Jsrq = DateTime.Now;
zyBrry.Jscs = InPara.OtherPara.Jscs;
zyBrry.Cypb = 8;
zyBrry.Xgpb = 0;
Ctx.SaveChanges();
}
private void UpdateZyTbkk(ZyBrry zyBrry)
{
var zyTbkk = zyBrry.ZyTbkks.Where(p => p.Jscs == 0);
foreach (var item in zyTbkk)
{
item.Jscs = InPara.OtherPara.Jscs;
}
Ctx.SaveChanges();
}
private void InsertZyTbkk(ZyBrry zyBrry)
{
var zyTbkk = new ZyTbkk()
{
Jkxh = InPara.OtherPara.ZyTbkk_Jkxh,
Zyh = zyBrry.Zyh,
Jkrq = DateTime.Now,
Jkje = InPara.PayJsxx.Zfje,
Jkfs = 3,
Sjhm = InPara.OtherPara.Sjhm,
Jscs = (int)zyBrry.Jscs + 1,
Czgh = Config.YDJS_CZGH,
Zfpb = 0
};
Ctx.ZyTbkkSet.Add(zyTbkk);
Ctx.SaveChanges();
}
private void InsertZyZyjs(ZyBrry zyBrry)
{
var fyhj = zyBrry.ZyFymxs.Where(p => p.Jscs == 0).Sum(p => p.Zjje);
var yef = zyBrry.ZyFymxs.Where(p => p.Jscs == 0 && p.Yefbz == 1).Sum(p => p.Zjje);
var zyZyjs = new ZyZyjs()
{
Zyh = zyBrry.Zyh,
Jscs = InPara.OtherPara.Jscs,
Jslx = 5,
Ksrq = zyBrry.Ryrq,
Zzrq = zyBrry.Cyrq,
Jsrq = DateTime.Now,
Fyhj = fyhj,
Zfhj = fyhj - InPara.PayJsxx.Bxje,
Jkhj = InPara.PayJsxx.yjje + InPara.PayJsxx.Zfje,
Xjje = 0,
Fphm = InPara.OtherPara.Fphm,
Czgh = Config.YDJS_CZGH,
Zfpb = 0,
Qtje = 0,
Qtfs = null,
Jsjk = InPara.OtherPara.Jsjk,
Srje = 0,
Brxz = zyBrry.Brxz,
Jrzf = 0,
Cjbz = 0,
Yef = yef,
Jkda = 0,
Jmje = 0,
Paylsh = InPara.PayLSH,
Dzpj = InPara.ElectronicInvoiceNumber,
Jsjkxh = InPara.OtherPara.ZyTbkk_Jkxh
};
Ctx.ZyZyjsSet.Add(zyZyjs);
Ctx.SaveChanges();
}
