public void UpdateUserInfo(UserInfo userInfo) { var user = EconomicalleagueEntity.UserInfo.FirstOrDefault(x => x.openid == userInfo.openid); user.adzoneid = userInfo.adzoneid; EconomicalleagueEntity.SaveChangesAsync(); }
/// <summary> /// 添加用户 /// </summary> /// <param name="customer">用户信息</param> public long AddCustomerInfo(CustomerInfo customer) { CustomerInfo addCustomer = JsonHelper.ObjectToObject <CustomerInfo>(customer); var insertInfo = EconomicalleagueEntity.GetInsertSql(addCustomer, nameof(CustomerInfo.CustomerId)); StringBuilder sqlSb = new StringBuilder(); sqlSb.Append(" IF EXISTS(SELECT 1 FROM dbo.CustomerInfo WHERE CustomerName='" + addCustomer.CustomerName + "' AND IsDeleted=0 ) "); sqlSb.Append(" SELECT CAST(0 AS BIGINT); ELSE BEGIN"); sqlSb.Append(insertInfo.Item1); sqlSb.Append("SELECT CAST(@@IDENTITY AS BIGINT); END"); var ds = EconomicalleagueEntity.MultipleResults(sqlSb.ToString(), insertInfo.Item2.ToArray(), System.Data.CommandType.Text) .AddResult <long>() .Execute(); long[] customerIDs = ds.Count > 0 ? ds.First().Value as long[] : new long[0]; if (customerIDs != null && customerIDs.Length > 0 && customerIDs[0] != 0) { return(customerIDs[0]); } else { throw new ResponseContextException(ErrCode.customerNameAlreadyExist); } }
/// <summary> /// 保存平台分享的订单信息到本地数据库 /// </summary> /// <param name="order"></param> /// <returns></returns> public bool PlatformOrderAdd(List <TBrebateOrders> order) { EconomicalleagueEntity.TBrebateOrders.AddRange(order); return(EconomicalleagueEntity.SaveChanges() > 0); }
public void AddUserInfo(UserInfo userInfo) { EconomicalleagueEntity.UserInfo.Add(userInfo); EconomicalleagueEntity.SaveChangesAsync(); }
public bool AddFavorites(List <Favorites> item) { EconomicalleagueEntity.Favorites.AddRange(item); EconomicalleagueEntity.SaveChanges(); return(true); }
public bool UpdateFavorites(Favorites item) { EconomicalleagueEntity.Favorites.AddOrUpdate(item); EconomicalleagueEntity.SaveChanges(); return(true); }
public bool UpdateItem(UatmFavoritItems item) { EconomicalleagueEntity.UatmFavoritItems.AddOrUpdate(item); EconomicalleagueEntity.SaveChanges(); return(true); }
/// <summary> /// 把淘宝客选品库信息保存到数据库 /// </summary> /// <param name="info"></param> /// <returns></returns> public bool AddTbItemsList(List <UatmFavoritItems> info) { EconomicalleagueEntity.UatmFavoritItems.AddRange(info); EconomicalleagueEntity.SaveChanges(); return(true); }