/// <summary>
/// 根据条件查看物价分页
/// </summary>
/// <param name="category">物品分类</param>
/// <param name="foodname">物品名称</param>
/// <param name="site">监控点</param>
/// <param name="pageSize"></param>
/// <param name="pageNo"></param>
/// <returns></returns>
public string GetFoodMonitorsByPage(string category, string foodname, string site, int pageSize, int pageNo)
{
try
{
FoodMonitor entity = new FoodMonitor {
Category = category, FoodName = foodname, SiteName = site
};
var result = _priceQueryService.QueryFoodMonitorsByPage(entity, pageSize, pageNo);
var foods = from it in result
select new
{
it.AutoID,
Category = it.Category ?? "",
FoodName = it.FoodName ?? "",
Metrics = it.Metrics ?? "",
Price = it.Price == null ? "" : it.Price.Value.ToString(),
SiteName = it.SiteName ?? "",
Spec = it.Spec ?? "",
TableName = it.TableName ?? "",
Unit = it.Unit ?? "",
Uploadtime = it.Uploadtime != null?it.Uploadtime.Value.ToString("yyyy-MM-dd") : ""
};
return(new ResultFormat(1, foods).ToString());
}
catch (Exception ex)
{
LogHelper.GetInstance().Error(ex.ToString());
return(new ResultFormat(0, ex.Message).ToString());
}
}
public int QueryMonitorsCountBy(FoodMonitor entity)
{
PriceService.PriceClient client = new PriceClient();
var count = client.GetFoodMonitorsCounts(entity);
return(count);
}
public IEnumerable <FoodMonitor> QueryFoodMonitorsByPage(FoodMonitor condition, int pageSize, int pageNo)
{
PriceService.PriceClient client = new PriceClient();
var result = client.FindFoodMonitors(condition, "FoodName", true, pageSize, Math.Max(0, pageNo - 1));
return(result);
}
/// <summary>
/// 根据条件查看物价条数
/// </summary>
/// <param name="category">物品分类</param>
/// <param name="foodname">物品名称</param>
/// <param name="site">监控点</param>
/// <returns></returns>
public string GetFoodMonitorCount(string category, string foodname, string site)
{
try
{
FoodMonitor entity = new FoodMonitor {
Category = category, FoodName = foodname, SiteName = site
};
var count = _priceQueryService.QueryMonitorsCountBy(entity);
return(new ResultFormat(1, count).ToString());
}
catch (Exception ex)
{
LogHelper.GetInstance().Error(ex.ToString());
return(new ResultFormat(0, ex.Message).ToString());
}
}
public void Query()
{
try
{
PriceService.PriceClient client = new PriceClient();
var foods = client.GetFoods();
var rfoods = foods.Where(it => !string.IsNullOrEmpty(it.Value)).ToList();
var foodNames = client.GetFoodName();
var categ = client.GetCategorys();
var tables = client.GetTableNames();
var dd = client.GetMonitorSites();
PriceService.FoodMonitor monitor = new FoodMonitor();
monitor.FoodID = foods[0].Key;
monitor.FoodName = foods[0].Value;
var result = client.FindFoodMonitors(null, null, true, 50, 0);
}
catch (Exception ex)
{
LogHelper.GetInstance().Error(ex.ToString());
return;
}
}