public ISyncDataObject GetItem(Guid guid, int companyId, string storeId)
{
using (var db = SyncDbContextFactory.Factory <EFDbContext>())
{
var entity = db.SysStoreUserInfos.Where(o => o.SyncItemId == guid && o.CompanyId == companyId).FirstOrDefault();
return(new SysStoreUserInfo().InitEntity(entity));
}
}
public void DeleteItem(Guid syncItemId, int companyId, string storeId)
{
using (var db = SyncDbContextFactory.Factory <LocalCeDbContext>())
{
var dbEntity = db.Areas.FirstOrDefault(o => o.SyncItemId == syncItemId);
db.Areas.Remove(dbEntity);
db.SaveChanges();
}
}
public ISyncDataObject GetItem(Guid guid, int companyId, string storeId)
{
using (var db = SyncDbContextFactory.Factory <EFDbContext>())
{
return(db.Database.SqlQuery <ProductCategory>(@"EXEC [dbo].[SyncStoreProductCategory]
@companyId = @p0,
@storeId = @p1,
@syncId =@p2" , companyId, storeId, guid).FirstOrDefault());
}
}
public IDictionary <Microsoft.Synchronization.SyncId, ISyncDataObject> GetItems(IEnumerable <Microsoft.Synchronization.SyncId> ids, int companyId, string storeId)
{
using (var db = SyncDbContextFactory.Factory <EFDbContext>())
{
var syncidsdict = ids.ToDictionary(o => o.GetGuidId(), o => o);
var syncids = syncidsdict.Keys;
var datas = db.Database.SqlQuery <ProductRecord>("EXEC [dbo].[SyncProductRecord] @p0,@p1,@p2", storeId, companyId, syncids.SyncIdsToString()).ToList();
return(datas.ToDictionary(o => syncidsdict[o.SyncItemId], o => { o.EntityType = o.GetType().ToString(); return (ISyncDataObject)o; }));
}
}
public ISyncDataObject GetItem(Guid guid, int companyId, string storeId)
{
using (var db = SyncDbContextFactory.Factory <EFDbContext>())
{
// var entity = db.ApiLibrarys.Where(o => o.SyncItemId == guid && o.CompanyId == companyId).FirstOrDefault();
var entity = db.Database.SqlQuery <ProductRecord>("EXEC [dbo].[SyncProductRecord] @p0,@p1,@p2", storeId, companyId, guid).FirstOrDefault();
entity.EntityType = entity.GetType().ToString();
return(entity);
}
}
public void DeleteItem(Guid syncItemId, int companyId, string storeId)
{
using (var db = SyncDbContextFactory.Factory <LocalCeDbContext>())
{
var integralSet = db.MemberIntegralSets.FirstOrDefault(o => o.SyncItemId == syncItemId);
db.MemberIntegralSets.Remove(integralSet);
db.MemberIntegralSetLists.RemoveRange(db.MemberIntegralSetLists.Where(o => o.IntegralId == integralSet.Id).ToList());
db.SaveChanges();
}
}
public IDictionary <Microsoft.Synchronization.SyncId, ISyncDataObject> GetItems(IEnumerable <Microsoft.Synchronization.SyncId> ids, int companyId, string StoreId)
{
using (var db = SyncDbContextFactory.Factory <LocalCeDbContext>())
{
var syncidsdict = ids.ToDictionary(o => o.GetGuidId(), o => o);
var syncids = syncidsdict.Keys;
var datas = db.Areas.Where(o => syncids.Contains(o.SyncItemId)).ToList();
return(datas.ToDictionary(o => syncidsdict[o.SyncItemId], o => (ISyncDataObject) new Pharos.SyncService.SyncEntities.Area().InitEntity(o)));
}
}
public void DeleteItem(Guid syncItemId, int companyId, string storeId)
{
using (var db = SyncDbContextFactory.Factory <LocalCeDbContext>())
{
var promotions = db.CommodityPromotions.FirstOrDefault(o => o.SyncItemId == syncItemId);
db.CommodityPromotions.Remove(promotions);
db.CommodityDiscounts.RemoveRange(db.CommodityDiscounts.Where(o => o.CommodityId == promotions.Id).ToList());
db.SaveChanges();
StoreManager.PubEvent("MarketingRefresh", new { StoreId = storeId, CompanyId = companyId });
}
}
public ISyncDataObject GetItem(Guid guid, int companyId, string storeId)
{
using (var db = SyncDbContextFactory.Factory <EFDbContext>())
{
var entity = db.Notices.Where(o => o.SyncItemId == guid && o.CompanyId == companyId && (("," + o.StoreId + ",").Contains("," + storeId + ",") || ("," + o.StoreId + ",").Contains(",-1,"))).FirstOrDefault();
if (entity != null)
{
return(new Pharos.SyncService.SyncEntities.Notice().InitEntity(entity));
}
return(null);
}
}
public void DeleteItem(Guid syncItemId, int companyId, string storeId)
{
using (var db = SyncDbContextFactory.Factory <LocalCeDbContext>())
{
var order = db.SaleOrders.FirstOrDefault(o => o.SyncItemId == syncItemId);
db.SaleOrders.Remove(order);
db.SaleDetails.RemoveRange(db.SaleDetails.Where(o => o.PaySN == order.PaySN).ToList());
db.ConsumptionPayments.RemoveRange(db.ConsumptionPayments.Where(o => o.PaySN == order.PaySN).ToList());
db.WipeZeros.RemoveRange(db.WipeZeros.Where(o => o.PaySN == order.PaySN).ToList());
db.SaveChanges();
}
}
public ISyncDataObject GetItem(Guid guid, int companyId, string storeId)
{
using (var db = SyncDbContextFactory.Factory <LocalCeDbContext>())
{
var entity = db.Areas.Where(o => o.SyncItemId == guid).FirstOrDefault();
if (entity != null)
{
return(new Pharos.SyncService.SyncEntities.Area().InitEntity(entity));
}
return(null);
}
}
public byte[] UpdateItem(Guid guid, ISyncDataObject mergedData, int companyId, string storeId)
{
var temp = mergedData as Pharos.SyncService.SyncEntities.MemberIntegral;
using (var db = SyncDbContextFactory.Factory <LocalCeDbContext>())
{
var dbEntity = db.MemberIntegrals.FirstOrDefault(o => o.SyncItemId == guid);
dbEntity.InitEntity(temp);
db.SaveChanges();
return(dbEntity.SyncItemVersion);
}
}
public byte[] UpdateItem(Guid guid, ISyncDataObject mergedData, int companyId, string storeId)
{
var temp = mergedData as SysStoreUserInfo;
using (var db = SyncDbContextFactory.Factory <LocalCeDbContext>())
{
var dbEntity = db.SysStoreUserInfos.FirstOrDefault(o => o.SyncItemId == guid && o.CompanyId == companyId);
dbEntity.InitEntity(temp);
db.SaveChanges();
var newEntity = db.SysStoreUserInfos.FirstOrDefault(o => o.SyncItemId == guid);
return(newEntity.SyncItemVersion);
}
}
public byte[] CreateItem(ISyncDataObject data, Guid guid, int companyId, string storeId)
{
var temp = data as Pharos.SyncService.SyncEntities.Area;
using (var db = SyncDbContextFactory.Factory <LocalCeDbContext>())
{
var entity = new Pharos.Logic.ApiData.Pos.Entity.LocalCeEntity.Area();
entity.InitEntity(temp);
db.Areas.Add(entity);
db.SaveChanges();
return(entity.SyncItemVersion);
}
}
public IEnumerable <ISyncDataObject> GetSyncObjects(int companyId, string storeId)
{
try
{
using (var db = SyncDbContextFactory.Factory <EFDbContext>())
{
var result = db.Database.SqlQuery <SyncDataObject>("EXEC SyncStoreProductCategoryVersion @p0,@p1", companyId, storeId).ToList();
return(result);
}
}
catch
{
return(new List <ISyncDataObject>());
}
}
public ISyncDataObject GetItem(Guid guid, int companyId, string storeId)
{
using (var db = SyncDbContextFactory.Factory <EFDbContext>())
{
var memIntSets = db.MemberIntegralSets.Where(o => o.SyncItemId == guid).ToList();
var memIntSet = memIntSets.FirstOrDefault();
var memIntSetLists = db.MemberIntegralSetLists.Where(o => o.IntegralId == memIntSet.Id).ToList();
var package = new Package()
{
SyncItemId = guid, EntityType = "MemberIntegralSetPackage"
};
package.Init(memIntSets.Select(o => new MemberIntegralSet().InitEntity(o)).ToList());
package.Init(memIntSetLists.Select(o => new MemberIntegralSetList().InitEntity(o)).ToList());
return(package);
}
}
public ISyncDataObject GetItem(Guid guid, int companyId, string storeId)
{
using (var db = SyncDbContextFactory.Factory <LocalCeDbContext>())
{
var memberIntegralSet = db.MemberIntegralSets.FirstOrDefault(o => o.SyncItemId == guid);
var package = new Package()
{
SyncItemId = guid, EntityType = "MemberIntegralSetPackage"
};
var orderItem = new List <MemberIntegralSet>();
orderItem.Add(new MemberIntegralSet().InitEntity(memberIntegralSet));
package.Init(orderItem);
package.Init(db.MemberIntegralSetLists.Where(o => o.CompanyId == companyId).ToList().Select(o => new MemberIntegralSetList().InitEntity(o, true)));
return(package);
}
}
public ISyncDataObject GetItem(Guid guid, int companyId, string storeId)
{
using (var db = SyncDbContextFactory.Factory <LocalCeDbContext>())
{
var promotions = db.CommodityPromotions.FirstOrDefault(o => o.SyncItemId == guid);
var package = new Package()
{
SyncItemId = guid, EntityType = "CommodityDiscountPackage"
};
var orderItem = new List <CommodityPromotion>();
orderItem.Add(new CommodityPromotion().InitEntity(promotions));
package.Init(orderItem);
package.Init(db.CommodityDiscounts.Where(o => o.CommodityId == promotions.Id).ToList().Select(o => new CommodityDiscount().InitEntity(o, true)));
return(package);
}
}
public IEnumerable <ISyncDataObject> GetSyncObjects(int companyId, string storeId)
{
try
{
using (var db = SyncDbContextFactory.Factory <EFDbContext>())
{
//var result = db.ApiLibrarys.Where(o => o.CompanyId == companyId).Select(o => new SyncDataObject() { SyncItemId = o.SyncItemId, SyncItemVersion = o.SyncItemVersion }).ToList();
var result = db.Database.SqlQuery <SyncDataObject>("EXEC [dbo].[SyncProductRecordVersion] @p0, @p1", storeId, companyId).ToList();
return(result);
}
}
catch
{
return(new List <ISyncDataObject>());
}
}
public ISyncDataObject GetItem(Guid guid, int companyId, string storeId)
{
using (var db = SyncDbContextFactory.Factory <EFDbContext>())
{
var commodits = db.CommodityPromotions.Where(o => o.SyncItemId == guid).ToList();
var commodit = commodits.FirstOrDefault();
var discounts = db.CommodityDiscounts.Where(o => o.CommodityId == commodit.Id).ToList();
var package = new Package()
{
SyncItemId = guid, EntityType = "CommodityDiscountPackage"
};
package.Init(commodits.Select(o => new CommodityPromotion().InitEntity(o)).ToList());
package.Init(discounts.Select(o => new CommodityDiscount().InitEntity(o)).ToList());
return(package);
}
}
public byte[] UpdateItem(Guid guid, ISyncDataObject mergedData, int companyId, string storeId)
{
var temp = mergedData as Pharos.SyncService.SyncEntities.SalesRecord;
using (var db = SyncDbContextFactory.Factory <EFDbContext>())
{
var dbEntity = db.SalesRecords.FirstOrDefault(o => o.SyncItemId == guid);
if (dbEntity == null)
{
throw new SyncService.Exceptions.SyncException("未能找到更新的项！");
}
dbEntity.InitEntity(temp);
db.SaveChanges();
var newEntity = db.SalesRecords.FirstOrDefault(o => o.SyncItemId == guid);
return(newEntity.SyncItemVersion);
}
}
public byte[] UpdateItem(Guid guid, ISyncDataObject mergedData, int companyId, string storeId)
{
var temp = mergedData as SysStoreUserInfo;
using (var db = SyncDbContextFactory.Factory <EFDbContext>())
{
var dbEntity = db.SysStoreUserInfos.FirstOrDefault(o => o.SyncItemId == guid && o.CompanyId == companyId);
if (dbEntity == null)
{
throw new SyncService.Exceptions.SyncException("未能找到更新的项！");
}
dbEntity.LoginDT = temp.LoginDT;
db.SaveChanges();
var newEntity = db.SysStoreUserInfos.FirstOrDefault(o => o.SyncItemId == guid);
return(newEntity.SyncItemVersion);
}
}
public IEnumerable <ISyncDataObject> GetSyncObjects(int companyId, string storeId)
{
try
{
using (var db = SyncDbContextFactory.Factory <LocalCeDbContext>())
{
var result = db.Areas.Select(o => new SyncDataObject()
{
SyncItemId = o.SyncItemId, SyncItemVersion = o.SyncItemVersion
}).ToList();
return(result);
}
}
catch
{
return(new List <ISyncDataObject>());
}
}
public IEnumerable <ISyncDataObject> GetSyncObjects(int companyId, string storeId)
{
try
{
using (var db = SyncDbContextFactory.Factory <EFDbContext>())
{
var result = db.SalesRecords.Where(o => o.CompanyId == companyId && o.StoreId == storeId).Select(o => new SyncDataObject()
{
SyncItemId = o.SyncItemId, SyncItemVersion = o.SyncItemVersion
}).ToList();
return(result);
}
}
catch
{
return(new List <ISyncDataObject>());
}
}
public ISyncDataObject GetItem(Guid guid, int companyId, string storeId)
{
using (var db = SyncDbContextFactory.Factory <LocalCeDbContext>())
{
var order = db.SaleOrders.FirstOrDefault(o => o.SyncItemId == guid);
var package = new Package()
{
SyncItemId = guid, EntityType = "SalePackage"
};
var orderItem = new List <SaleOrders>();
orderItem.Add(new SaleOrders().InitEntity(order));
package.Init(orderItem);
package.Init(db.SaleDetails.Where(o => o.PaySN == order.PaySN && o.CompanyId == companyId).ToList().Select(o => new SaleDetail().InitEntity(o, true)));
package.Init(db.ConsumptionPayments.Where(o => o.PaySN == order.PaySN && o.CompanyId == companyId).ToList().Select(o => new ConsumptionPayment().InitEntity(o, true)));
package.Init(db.WipeZeros.Where(o => o.PaySN == order.PaySN && o.CompanyId == companyId).ToList().Select(o => new WipeZero().InitEntity(o, true)));
return(package);
}
}
public IEnumerable <ISyncDataObject> GetSyncObjects(int companyId, string storeId)
{
try
{
using (var db = SyncDbContextFactory.Factory <EFDbContext>())
{
var result = db.Notices.Where(o => o.CompanyId == companyId && (("," + o.StoreId + ",").Contains("," + storeId + ",") || ("," + o.StoreId + ",").Contains(",-1,"))).Select(o => new SyncDataObject()
{
SyncItemId = o.SyncItemId, SyncItemVersion = o.SyncItemVersion
}).ToList();
return(result);
}
}
catch
{
return(new List <ISyncDataObject>());
}
}
public IEnumerable <ISyncDataObject> GetSyncObjects(int companyId, string storeId)
{
try
{
using (var db = SyncDbContextFactory.Factory <EFDbContext>())
{
var result = db.Database.SqlQuery <SyncDataObject>(@" select 'MemberIntegralSetPackage' as EntityType, SyncItemId,max(SyncItemVersion) SyncItemVersion from (
select s.syncitemid,s.SyncItemVersion from [MemberIntegralSet] s where s.CompanyId=@p0
union all
select s.syncitemid,d.SyncItemVersion from [MemberIntegralSet] s,[MemberIntegralSetList] d where s.Id = d.IntegralId and s.CompanyId=@p0
) as t group by SyncItemId", companyId).ToList();
return(result);
}
}
catch
{
return(new List <ISyncDataObject>());
}
}
public byte[] UpdateItem(Guid guid, ISyncDataObject mergedData, int companyId, string storeId)
{
var temp = mergedData as Package;
using (var db = SyncDbContextFactory.Factory <LocalCeDbContext>())
{
var integralSets = temp.GetEntities <MemberIntegralSet>();
var integralSetsSyncIds = integralSets.Select(o => o.SyncItemId).ToList();
var integralSetLists = temp.GetEntities <MemberIntegralSetList>();
var integralSetListsSyncIds = integralSetLists.Select(o => o.SyncItemId).ToList();
db.MemberIntegralSets.Where(o => integralSetsSyncIds.Contains(o.SyncItemId)).ToList().ForEach(o => o.InitEntity(integralSets.FirstOrDefault(p => o.SyncItemId == p.SyncItemId)));
db.MemberIntegralSetLists.Where(o => integralSetListsSyncIds.Contains(o.SyncItemId)).ToList().ForEach(o => o.InitEntity(integralSetLists.FirstOrDefault(p => o.SyncItemId == p.SyncItemId)));
db.SaveChanges();
var version = GetVersion(guid, companyId, storeId, db);
return(version.SyncItemVersion);
}
}
public IDictionary <Microsoft.Synchronization.SyncId, ISyncDataObject> GetItems(IEnumerable <Microsoft.Synchronization.SyncId> ids, int companyId, string StoreId)
{
using (var db = SyncDbContextFactory.Factory <LocalCeDbContext>())
{
var syncidsdict = ids.ToDictionary(o => o.GetGuidId(), o => o);
var syncids = syncidsdict.Keys;
var query = db.CommodityPromotions.Where(o => syncids.Contains(o.SyncItemId)).Include(o => o.CommodityDiscounts).ToList();
return(query.ToDictionary(o => syncidsdict[o.SyncItemId], o =>
{
var package = new Package()
{
SyncItemId = o.SyncItemId, EntityType = "CommodityDiscountPackage"
};
package.Init(new CommodityPromotion[] { new CommodityPromotion().InitEntity(o) });
package.Init(o.CommodityDiscounts.Select(p => new CommodityDiscount().InitEntity(p)).ToList());
return package as ISyncDataObject;
}));
}
}
public ISyncDataObject GetItem(Guid guid, int companyId, string storeId)
{
using (var db = SyncDbContextFactory.Factory <EFDbContext>())
{
var commodits = db.CommodityPromotions.Where(o => o.SyncItemId == guid).ToList();
var commodit = commodits.FirstOrDefault();
var promotionFreeGiftPurchase = db.FreeGiftPurchases.Where(o => o.CommodityId == commodit.Id).ToList();
var giftIds = promotionFreeGiftPurchase.Select(o => o.GiftId);
var promotionFreeGiftPurchaseList = db.FreeGiftPurchaseLists.Where(o => giftIds.Contains(o.GiftId)).ToList();
var package = new Package()
{
SyncItemId = guid, EntityType = "CommodityFreeGiftPackage"
};
package.Init(commodits.Select(o => new CommodityPromotion().InitEntity(o)).ToList());
package.Init(promotionFreeGiftPurchase.Select(o => new FreeGiftPurchase().InitEntity(o)).ToList());
package.Init(promotionFreeGiftPurchaseList.Select(o => new FreeGiftPurchaseList().InitEntity(o)).ToList());
return(package);
}
}
