public void UpdatePlatAccount(PlatAccountInfo model) { //Context.PlatAccountInfo.Attach(model); //Context.Entry(model).State = System.Data.Entity.EntityState.Modified; //Context.SaveChanges(); DbFactory.Default.Update(model); }
/// <summary> /// 获取平台帐户信息 /// </summary> /// <returns></returns> public PlatAccountInfo GetPlatAccount() { //var model = Context.PlatAccountInfo.FirstOrDefault(); var model = DbFactory.Default.Get <PlatAccountInfo>().FirstOrDefault(); #region 当新状态没值时,初始一个(因为之前代码有好些地方要用到PlatAccount但它没初始值报错,这里数据库里初始一条数) if (model == null) { model = new PlatAccountInfo(); model.Balance = 0; model.PendingSettlement = 0; model.Settled = 0; DbFactory.Default.Add(model); } #endregion //待结算金额总在变化改为实时查询吧20160709 //var PendingSettlementAmount = Context.PendingSettlementOrdersInfo.Sum(a => (decimal?)a.SettlementAmount).GetValueOrDefault(); var PendingSettlementAmount = DbFactory.Default.Get <PendingSettlementOrderInfo>().Sum <decimal>(a => a.SettlementAmount); model.PendingSettlement = PendingSettlementAmount; return(model); }
public void UpdatePlatAccount(PlatAccountInfo model) { Context.PlatAccountInfo.Attach(model); Context.Entry(model).State = System.Data.Entity.EntityState.Modified; Context.SaveChanges(); }