public async Task <MyfundPageView> GetPageList(MyfundParm parm)
{
return(await WithConnection(async c =>
{
StringBuilder sql = new StringBuilder();
sql.Append($@" SELECT
id,
code,
name,
balance,
costavg,
networth,
totalworth,
worthdate,expectgrowth,
daygrowth,updatetime FROM myfund
");
StringBuilder whereSql = new StringBuilder();
sql.Append(whereSql);
var data = await c.QueryAsync <Myfund>(sql.ToString());
var total = data.ToList().Count;
sql.Append(" order by " + parm.sort + " " + parm.order)
.Append(" limit " + (parm.page - 1) * parm.rows + "," + parm.rows);
var ets = await c.QueryAsync <Myfund>(sql.ToString());
MyfundPageView ret = new MyfundPageView();
ret.rows = ets.ToList();
ret.total = total;
return ret;
}));
}
public Task Execute(IJobExecutionContext context)
{
return(Task.Run(() =>
{
Console.WriteLine(DateTime.Now);
string codes = string.Empty;
MyfundParm parm = new MyfundParm()
{
page = 1, rows = 1000, sort = "id", order = "asc"
};
var data = _repo.GetPageList(parm).Result;
//foreach (var d in data.rows)
//{
// codes += d.Code + ",";
//}
//string url = "https://api.doctorxiong.club/v1/fund?code=" + codes;
//FundRetComm response = HttpClientHelper.GetResponse<FundRetComm>(url);
foreach (var d in data.rows)
{
try
{
//string url = "https://api.doctorxiong.club/v1/fund?code=" + d.Code;
//FundRetComm response = HttpClientHelper.GetResponse<FundRetComm>(url);
string url = $@"https://fundmobapi.eastmoney.com/FundMApi/FundValuationDetail.ashx?FCODE=" + d.Code + "&deviceid=Wap&plat=Wap&product=EFund&version=2.0.0&Uid=9572315881384690&_=" + MathHelper.GetTimeStamp();
Root2 response = HttpClientHelper.GetResponse <Root2>(url);
if (response.ErrCode == 0)
{
var cur = response.Datas[0];
if (cur != null)
{
if (!string.IsNullOrEmpty(cur.gszzl))
{
_repo.UpdateExpectGrowth(new Myfund()
{
Id = d.Id, ExpectGrowth = decimal.Parse(cur.gszzl)
});
}
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
}
}));
}
public async Task <ActionResult <ApiResult> > GetPageList([FromQuery] MyfundParm parm)
{
ApiResult ret = new ApiResult {
code = Code.Failure
};
try
{
ret = await _service.GetPageList(parm);
}
catch (System.Exception ex)
{
ret.msg = string.Format(
"获取分页数据Myfund失败, 异常信息:{0}",
ex.Message);
}
return(ret);
}
