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