private void downloadInventory()
{
String warehouse = ApiUtil.GetConfigCont("QUERYINVENTORY_WAREHOUSE");
try
{
//先查询EAS库存的行数
JObject joCli = ApiClientService.queryInventoryByPage(warehouse, 0, 1);
int countRow = 0;
if ("success".Equals(joCli.Value <String>("result")))
{
try
{
countRow = Convert.ToInt32(joCli.Value <String>("data"));
}
catch
{ }
}
//清除库存临时表
DbHelperOra.ExecuteSql("delete from EAS_STOCK_COMPARE ");
int pageNum = 100;
int sumPage = countRow % pageNum > 0 ? countRow / pageNum + 1 : countRow / pageNum;
for (int i = 1; i <= sumPage; i++)
{
joCli = ApiClientService.queryInventoryByPage(warehouse, pageNum, i);
JObject jo = new JObject();
if ("success".Equals(joCli.Value <String>("result")))
{
foreach (JToken jt in joCli.Value <JArray>("data"))
{
insertInventory(jt);
}
}
}
}
catch (Exception ex)
{
Alert.Show("下载EAS库存失败！");
}
}