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(); }