public static async Task <List <Quote> > GetStockSearchQueryData(string queryCheck, string region, string language, int quotescount, int newscount, bool enableFuzzyQuery)
{
List <Quote> chartCollection = new List <Quote>();
var url = StockSearch.generateStockSearchQueryURL(queryCheck, region, language, quotescount, newscount, enableFuzzyQuery);
Console.WriteLine($"Accessing URL: {url}");
try
{
using (HttpClient client = new HttpClient())
{
var response = await client.GetAsync(url);
var json = await response.Content.ReadAsStringAsync();
var stockSearchData = JsonConvert.DeserializeObject <StockSearch>(json);
chartCollection = stockSearchData.quotes as List <Quote>; //chartData.chart.result as List<Result>;
}
}
catch (Exception ex)
{
var x = ex.Message;
Console.WriteLine(ex.Message);
}
return(chartCollection);
}
public ActionResult GetAgentStockByUserNamePage(StockSearch condition)
{
string where = string.Empty;
if (!string.IsNullOrWhiteSpace(condition.keyword))
{
where += " and Consignee='" + condition.keyword + "'";
}
return(NewMethod(condition, where));
}
public ActionResult GetAgentStockPage(StockSearch condition)
{
string where = string.Empty;
if (!string.IsNullOrWhiteSpace(condition.keyword))
{
where += " and Consignee+Name+ProductNumber+ProductName like '%" + Common.Filter(condition.keyword) + "%'";
}
return(NewMethod(condition, where));
}
private ActionResult NewMethod(StockSearch condition, string where)
{
PageJsonModel <Stock> page = new PageJsonModel <Stock>();
page.pageIndex = condition.pageIndex;
page.pageSize = condition.pageSize;
page.strForm = " (select COUNT(*) count,s.Consignee Consignee, p.ProductName ProductName,p.ProductImg ProductImgUrl,c.Name Name,ProductNumber " +
" from ScaleOutStoke s left join Product p on s.ProductNo=p.ProductNumber left join C_User c on s.Consignee=c.UserName " +
" where s.State='启用' and s.Shipper='" + CurrentUser.UserName + "' group by s.Consignee,s.ProductNo,p.ProductName,p.ProductImg,c.Name,ProductNumber) as Detail";
page.strSelect = "* ";
page.strWhere = where;
page.strOrder = "Consignee asc";
page.LoadList();
return(Json(page.pageResponse, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 我的库存
/// </summary>
/// <param name="condition"></param>
/// <returns></returns>
public ActionResult MyStockPage(StockSearch condition)
{
string where = string.Empty;
PageJsonModel <Stock> page = new PageJsonModel <Stock>();
page.pageIndex = condition.pageIndex;
page.pageSize = condition.pageSize;
page.strForm = "(select p.ProductName,p.ProductImg as ProductImgUrl,s.Consignee,p.ProductNumber,Count(SmallCode) count " +
" from Product as p left join ScaleOutStoke as s on s.ProductNo=p.ProductNumber and s.State<>'禁用' and s.Consignee='" + CurrentUser.UserName + "' " +
" group by s.Consignee,p.ProductNumber,p.ProductName,p.ProductImg)def";
page.strSelect = "* ";
page.strOrder = "count desc";
page.LoadList();
return(Json(page.pageResponse, JsonRequestBehavior.AllowGet));
}
