private ISyncDataObject GetVersion(Guid syncid, int companyId, string storeId, LocalCeDbContext db) { var result = db.Database.SqlQuery <SyncDataObject>(@"select 'SalePackage' as EntityType, SyncItemId,max (SyncItemVersion) as SyncItemVersion from ( select s.syncitemid,s.SyncItemVersion from saleorders s where s.syncitemid = @p0 union all select s.syncitemid,d.SyncItemVersion from saleorders s,SaleDetail d where s.paysn = d.paysn and s.syncitemid = @p0 union all select s.syncitemid,b.SyncItemVersion from saleorders s,ConsumptionPayment b where s.paysn = b.paysn and s.syncitemid = @p0 union all select s.syncitemid,w.SyncItemVersion from saleorders s,WipeZero w where s.paysn =w.paysn and s.syncitemid = @p0) as t group by SyncItemId ", syncid).ToList(); return(result.FirstOrDefault()); }
private ISyncDataObject GetVersion(Guid syncId, int companyId, string storeId, LocalCeDbContext db) { var result = db.Database.SqlQuery <SyncDataObject>(@" select 'CommodityBlendPackage' as EntityType, SyncItemId,max (SyncItemVersion) as SyncItemVersion from ( select s.syncitemid,s.SyncItemVersion from [CommodityPromotion] s where s.syncitemid=@p0 union all select s.syncitemid,d.SyncItemVersion from [CommodityPromotion] s,[PromotionBlend] d where s.Id = d.CommodityId and s.syncitemid=@p0 union all select s.syncitemid,b.SyncItemVersion from [CommodityPromotion] s,[PromotionBlendList] b where s.Id = b.CommodityId and s.syncitemid=@p0 ) as t group by SyncItemId ", syncId).ToList(); return(result.FirstOrDefault()); }
private ISyncDataObject GetVersion(Guid syncId, int companyId, string storeId, LocalCeDbContext db) { var result = db.Database.SqlQuery <SyncDataObject>(@" select 'MemberIntegralSetPackage' as EntityType, SyncItemId,max (SyncItemVersion) as SyncItemVersion from ( select s.syncitemid,s.SyncItemVersion from [MemberIntegralSet] s where s.syncitemid=@p0 union all select s.syncitemid,d.SyncItemVersion from [MemberIntegralSet] s,[MemberIntegralSetList] d where s.Id = d.IntegralId and s.syncitemid=@p0 ) as t group by SyncItemId", syncId).ToList(); return(result.FirstOrDefault()); }