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 ActivityDaoInsertWorking()
{
var activity = new ActivityDAO();
var activity1 = new Activity
{
Date = new DateTime(2019, 01, 20),
ActivityVal = "Work",
Reward = "Candy"
};
activity.InsertActivity(activity1);
Assert.Equals(activity, activity1);
}
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);
}
public int UpdateOne(int id)
{
ActivityDAO dao = new ActivityDAO();
return(dao.UpdateActivity(this, id));
}
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 int DeleteOne(int id)
{
ActivityDAO dao = new ActivityDAO();
return(dao.DeleteActivity(id));
}
public Activity RetrieveOne(int id)
{
ActivityDAO dao = new ActivityDAO();
return(dao.getOne(id));
}
public List <Activity> GetAllPlaces()
{
ActivityDAO dao = new ActivityDAO();
return(dao.GetAll());
}
public int AddActivity()
{
ActivityDAO dao = new ActivityDAO();
return(dao.Insert(this));
}
public List <Activity> GetAllActivityByCategory(int catId)
{
ActivityDAO dao = new ActivityDAO();
return(dao.SelectByCat(catId));
}
/// <summary>
///
/// </summary>
/// <param name="uploadManagement">传入上传管理者实体</param>
/// <returns>返回可以用来上传的json对象</returns>
public ServiceResult GetServiceResult(UploadManagement uploadManagement)
{
//service返回结果对象
ServiceResult serviceResult = new ServiceResult();
//bdl_activity表
if (uploadManagement.UM_DataTable == "bdl_activity")
{
//uploadManagement.Pk_UM_Type = "ActivityEntity";
ActivityDAO activityDAO = new ActivityDAO();
var result = activityDAO.Load(uploadManagement.UM_DataId);
if (result == null)
{
return(null);
}
ActivityDTO activityDTO = new ActivityDTO(result);
serviceResult.Data = JsonTools.Obj2JSONStrNew <ActivityDTO>(activityDTO);
}
//bdl_member表
else if (uploadManagement.UM_DataTable == "bdl_member")
{
MemberDAO memberDAO = new MemberDAO();
var result = memberDAO.Load(uploadManagement.UM_DataId);
if (result == null)
{
return(null);
}
MemberDTO memberDTO = new MemberDTO(result);
serviceResult.Data = JsonTools.Obj2JSONStrNew <MemberDTO>(memberDTO);
}
//bdl_personal_setting表
else if (uploadManagement.UM_DataTable == "bdl_personal_setting")
{
PersonalSettingDAO personalSettingDAO = new PersonalSettingDAO();
//Tr devicePrescriptionDAO = new DevicePrescriptionDAO();
var result = personalSettingDAO.Load(uploadManagement.UM_DataId);
if (result == null)
{
return(null);
}
PersonalSettingDTO personalSettingDTO = new PersonalSettingDTO(result);
serviceResult.Data = JsonTools.Obj2JSONStrNew <PersonalSettingDTO>(personalSettingDTO);
}
//bdl_skeleton_length表
else if (uploadManagement.UM_DataTable == "bdl_skeleton_length")
{
SkeletonLengthDAO skeletonLengthDAO = new SkeletonLengthDAO();
//Tr devicePrescriptionDAO = new DevicePrescriptionDAO();
var result = skeletonLengthDAO.Load(uploadManagement.UM_DataId);
if (result == null)
{
return(null);
}
SkeletonLengthDTO skeletonLengthDTO = new SkeletonLengthDTO(result);
serviceResult.Data = JsonTools.Obj2JSONStrNew <SkeletonLengthDTO>(skeletonLengthDTO);
}
//bdl_system_setting表
else if (uploadManagement.UM_DataTable == "bdl_system_setting")
{
SystemSettingDAO systemSettingDAO = new SystemSettingDAO();
//Tr devicePrescriptionDAO = new DevicePrescriptionDAO();
var result = systemSettingDAO.Load(uploadManagement.UM_DataId);
if (result == null)
{
return(null);
}
SystemSettingDTO systemSettingDTO = new SystemSettingDTO(result);
serviceResult.Data = JsonTools.Obj2JSONStrNew <SystemSettingDTO>(systemSettingDTO);
}
//bdl_training_activity_record表
else if (uploadManagement.UM_DataTable == "bdl_training_activity_record")
{
TrainingActivityRecordDAO trainingActivityRecordDAO = new TrainingActivityRecordDAO();
//Tr devicePrescriptionDAO = new DevicePrescriptionDAO();
var result = trainingActivityRecordDAO.Load(uploadManagement.UM_DataId);
if (result == null)
{
return(null);
}
TrainingActivityRecordDTO trainingActivityRecordDTO = new TrainingActivityRecordDTO(result);
serviceResult.Data = JsonTools.Obj2JSONStrNew <TrainingActivityRecordDTO>(trainingActivityRecordDTO);
}
//bdl_training_course表
else if (uploadManagement.UM_DataTable == "bdl_training_course")
{
TrainingCourseDAO trainingCourseDAO = new TrainingCourseDAO();
//Tr devicePrescriptionDAO = new DevicePrescriptionDAO();
var result = trainingCourseDAO.Load(uploadManagement.UM_DataId);
if (result == null)
{
return(null);
}
TrainingCourseDTO trainingCourseDTO = new TrainingCourseDTO(result);
serviceResult.Data = JsonTools.Obj2JSONStrNew <TrainingCourseDTO>(trainingCourseDTO);
}
//bdl_training_device_record表
else if (uploadManagement.UM_DataTable == "bdl_training_device_record")
{
TrainingDeviceRecordDAO trainingDeviceRecordDAO = new TrainingDeviceRecordDAO();
//Tr devicePrescriptionDAO = new DevicePrescriptionDAO();
var result = trainingDeviceRecordDAO.Load(uploadManagement.UM_DataId);
if (result == null)
{
return(null);
}
TrainingDeviceRecordDTO trainingDeviceRecordDTO = new TrainingDeviceRecordDTO(result);
serviceResult.Data = JsonTools.Obj2JSONStrNew <TrainingDeviceRecordDTO>(trainingDeviceRecordDTO);
}
//bdl_training_plan表
else if (uploadManagement.UM_DataTable == "bdl_training_plan")
{
TrainingPlanDAO trainingPlanDAO = new TrainingPlanDAO();
//Tr devicePrescriptionDAO = new DevicePrescriptionDAO();
var result = trainingPlanDAO.Load(uploadManagement.UM_DataId);
if (result == null)
{
return(null);
}
TrainingPlanDTO trainingPlanDTO = new TrainingPlanDTO(result);
serviceResult.Data = JsonTools.Obj2JSONStrNew <TrainingPlanDTO>(trainingPlanDTO);
}
return(serviceResult);
}
public void TestMethod1()
{
var product = new ActivityDAO();
}
