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