int GetFirstGraphNext(string tableName, QueryReq req, int id)
{
int index = 0;
SqlAddArrowRecord.Append("SELECT*FROM");
SqlAddArrowRecord.Append(tableName);
SqlAddArrowRecord.Append("WHERE Time >= \'" + req.timeFrom.Year);
SqlAddArrowRecord.Append("-" + req.timeFrom.Month + "-");
SqlAddArrowRecord.Append(req.timeFrom.Day + " ");
SqlAddArrowRecord.Append(req.timeFrom.Hour + ":");
SqlAddArrowRecord.Append(req.timeFrom.Minute + ":");
SqlAddArrowRecord.Append(req.timeFrom.Second + "\' ");
SqlAddArrowRecord.Append("AND Time < \'");
SqlAddArrowRecord.Append(req.timeFrom.Year);
SqlAddArrowRecord.Append("-" + req.timeFrom.Month + "-");
SqlAddArrowRecord.Append(req.timeFrom.Day + " ");
SqlAddArrowRecord.Append(req.timeFrom.Hour + ":");
SqlAddArrowRecord.Append(req.timeFrom.Minute + ":");
SqlAddArrowRecord.Append(req.timeFrom.Second + "\' ");
SqlAddArrowRecord.Append(" AND id >= " + id);
SqlAddArrowRecord.Append("AND SYMBOL=\'" + req.symbol + "\'");
SqlAddArrowRecord.Append("AND Lv1=1 ORDER BY id LIMIT 1");
//if (SqlAddArrowRecord.Length > InsertLength)
//{
// index = SqlAddArrowRecord.Length;
// queue.Enqueue(SqlAddArrowRecord.ToString());
// SqlAddArrowRecord.Clear();
//}
return(index);
}
IList <BidInfo> PlatformService.queryBids(QueryReq req)
{
//依据req 去查询数据库
IList <BidInfo> list = new List <BidInfo>();
BidInfo info = new BidInfo();
info.title = "test_bid1";
info.id = "12345";
info.originalRate = 12;
info.rewardRate = 1;
info.desc = "test_bid2";
list.Add(info);
return(list);
}
IList <UserInfo> PlatformService.queryUser(QueryReq req)
{
return(null);
}
IList <RepayInfo> PlatformService.queryRepays(QueryReq req)
{
return(null);
}
IList <InvestInfo> PlatformService.queryInvests(QueryReq req)
{
return(null);
}
public void LoadParam(QueryReq data)
{
}
