int count = 0;
int pageNumber=1;
ProductPriceLevelToExtension ext=new ProductPriceLevelToExtension (MyCrmService );
bool bEof=false ;
RetrieveMultipleRequest request=new RetrieveMultipleRequest ();
RetrieveMultipleResponse response=null;
QueryExpressionHelper query = new QueryExpressionHelper(EntityName.productpricelevel.ToString());
query.Columns.AddColumns(new string[] {"productid", "pricelevelid", "productpricelevelid"});
query.EntityName =EntityName.productpricelevel.ToString();
PagingInfo page=new PagingInfo ();
page.Count =20;
while (!bEof )
{
page.PageNumber =pageNumber;
query.PageInfo = page;
request.Query = query.Query;
request.ReturnDynamicEntities = true;
response=(RetrieveMultipleResponse)_service.Execute (request );
bEof =(response.BusinessEntityCollection.BusinessEntities.Length ==20?false:true);
if (response.BusinessEntityCollection.BusinessEntities.Length>0)
{
foreach(DynamicEntity dy in response.BusinessEntityCollection.BusinessEntities )
{
if (!dy.Contains("productid"))
throw new Exception("productid not exists in productpricelevel");
Lookup lookupProductId = dy["productid"] as Lookup;
if (!dy.Contains("pricelevelid"))
throw new Exception("pricelevelid not exists in productpricelevel");
Lookup lookupPriceLevelId = dy["pricelevelid"] as Lookup;
ext.PriceLevelId =lookupPriceLevelId.Value.ToString();
ext.ProductId =lookupProductId.Value.ToString ();
ext.Execute ();
Console.WriteLine("Number:{0}, pricelevelname:{1},product:{2}", ++count, lookupPriceLevelId.name , lookupProductId.name );
}
}
pageNumber+=1;
}
}
這是我的部份代碼如果取總頁數我覺得應該是用count一下
韓建興 http://jamson.cnblogs.com
