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