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(); }