Example #1
0
 public void UpdatePlatAccount(PlatAccountInfo model)
 {
     //Context.PlatAccountInfo.Attach(model);
     //Context.Entry(model).State = System.Data.Entity.EntityState.Modified;
     //Context.SaveChanges();
     DbFactory.Default.Update(model);
 }
Example #2
0
        /// <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();
 }