public IActionResult GetActivityList()
{
ActivityDAO activityDAO = new ActivityDAO();
List <Activity> list = new List <Activity>();
list = activityDAO.GetAll().Where(e => e.status == 1).Include(e => e.goods).ToList();
return(Json(list));
}
public void ActivityDaoDeleteWorking()
{
var activity = new ActivityDAO();
var activity1 = new Activity
{
Date = new DateTime(2019, 01, 20),
ActivityVal = "Work",
Reward = "Candy"
};
activity.DeleteActivity(activity1);
ReferenceEquals(1, activity.GetAll().Count);
}
private void Get(int i)
{
try {
string appPath = AppContext.BaseDirectory;
if (Directory.Exists(appPath))
{
DirectoryInfo directoryInfo = new DirectoryInfo(appPath);
//directoryInfo = directoryInfo.Parent.Parent.Parent;
appPath = directoryInfo.ToString() + "\\wwwroot\\images\\";
}
List <GoodsInfo> list = new List <GoodsInfo>();
int start = 15 * i;
string json = HttpGet("https://store.steampowered.com/contenthub/querypaginated/specials/TopSellers/render/?query=&start=" + start + "&count=15&cc=CN&l=schinese&v=4&tag=", "");
json = Regex.Match(json, "\"results_html\":\"[\\S\\s]*\",").Value;
int startIndex = "\"results_html\":\"".Count();
json = json.Substring(startIndex, json.Count() - startIndex - 2);
json = Regex.Unescape(json);
string pageHtml = json;
//初始化网络请求客户端
HtmlWeb webClient = new HtmlWeb();
//初始化文档
//HtmlDocument doc = webClient.Load("https://store.steampowered.com/specials?p=4&tab=TopSellers");
HtmlDocument doc = new HtmlDocument();
doc.LoadHtml(pageHtml);
//查找节点
HtmlNodeCollection itemNodes = doc.DocumentNode.SelectNodes(".//a[@class='tab_item ']");
if (itemNodes != null)
{
Regex priceRegex = new Regex("\\d+(\\.\\d+)?");
foreach (var item in itemNodes)
{
GoodsInfo g = new GoodsInfo();
g.name = item.SelectNodes(".//div[@class='tab_item_name']")[0].InnerText;
g.originalPrice = priceRegex.Match(item.SelectNodes(".//div[@class='discount_original_price']")[0].InnerText).Value;
g.finalPrice = priceRegex.Match(item.SelectNodes(".//div[@class='discount_final_price']")[0].InnerText).Value;
g.pct = priceRegex.Match(item.SelectNodes(".//div[@class='discount_pct']")[0].InnerText).Value;
g.img = item.SelectNodes(".//img[@class='tab_item_cap_img']")[0].Attributes["src"].Value;
g.img = FileDownSave(g.img, appPath);
foreach (var t in item.SelectNodes(".//span[@class='top_tag']"))
{
g.tag += t.InnerText;
}
list.Add(g);
}
}
int rank = 1 + 15 * (i - 1);
List <int> arr = new List <int>();
for (int j = 0; j < 15; j++)
{
arr.Add(rank + j);
}
ActivityDAO activityDAO = new ActivityDAO();
List <Activity> activityList = activityDAO.GetAll().Where(e => e.status == 1 && arr.Contains(e.rank)).ToList();
int alc = activityList.Count();
for (int j = 0; j < alc; j++)
{
activityList[j].endTime = DateTime.Now;
activityList[j].status = 0;
}
int batch = 0;
if (alc != 0)
{
activityDAO.BatchUpdate(activityList);
batch = activityList[0].batch;
}
GoodsDAO goodsDAO = new GoodsDAO();
List <Activity> newActivityList = new List <Activity>();
foreach (var g in list)
{
Goods goods = goodsDAO.GetAll().Where(e => e.name == g.name).FirstOrDefault();
if (goods == null)
{
goods = new Goods()
{
name = g.name,
price = decimal.Parse(g.originalPrice),
tag = g.tag,
imgURI = g.img,
createTime = DateTime.Now,
status = 1
};
goodsDAO.Add(goods);
}
else
{
if (File.Exists(goods.imgURI))
{
FileInfo fileInfo = new FileInfo(goods.imgURI);
fileInfo.Delete();
}
goods.imgURI = g.img;
goods.price = decimal.Parse(g.originalPrice);
goods.tag = g.tag;
goods.createTime = DateTime.Now;
goods.status = 1;
goodsDAO.Update(goods);
}
Activity activity = new Activity()
{
goodsId = goods.id,
finalPrice = decimal.Parse(g.finalPrice),
pct = int.Parse(g.pct),
status = 1,
createTime = DateTime.Now,
rank = rank++,
batch = batch + 1
};
newActivityList.Add(activity);
}
activityDAO.SaveList(newActivityList);
} catch (Exception ex)
{
throw ex;
}
}
public List <Activity> GetAllPlaces()
{
ActivityDAO dao = new ActivityDAO();
return(dao.GetAll());
}