public ActionResult AdministratePlansSave(PlanTemplateModel model, HttpPostedFileBase file) { if (file != null) { if (HasImageExtension(file.FileName)) { if (file.ContentLength > 0) { using (var binaryReader = new BinaryReader(file.InputStream)) { byte[] imageData = null; imageData = binaryReader.ReadBytes(file.ContentLength); model.ImgContent = imageData; } } } } var planTemplate = new PlanTemplate(); var savedPlan = planTemplate.PutPlanTemplate(model); if (savedPlan != null) { return(RedirectToAction("AdministratePlans", "Administration")); } return(RedirectToAction("AdministratePlans", "Administration")); }
public ActionResult EditPlanSelected(int id) { var planTemplate = new PlanTemplate(); var plan = planTemplate.GetPlanTemplateById(id); return(View(plan)); }
public ActionResult AdministratePlansDelete(int id) { var planTemplate = new PlanTemplate(); planTemplate.DeletePlanTemplate(id); return(RedirectToAction("AdministratePlans", "Administration")); }
public ActionResult AdministratePlans() { var plans = new AdministrationModel(); var plansLogic = new PlanTemplate(); plans.Plans = plansLogic.GetPlanTemplate(); return(View(plans)); }
/// <summary> /// 自动创建模板训练课程 /// </summary> /// <param name="trainingCourseEntity"></param> /// <returns></returns> public void AutoSaveNewTemplateCourse(TrainingPlanEntity trainingPlan, PlanTemplate planTemplate) { //使整个代码块成为事务性代码 using (TransactionScope ts = new TransactionScope()) { TrainingCourseEntity trainingCourseEntity = new TrainingCourseEntity(); //主键id trainingCourseEntity.Id = KeyGenerator.GetNextKeyValueLong("bdl_training_course"); //设置外键训练计划id trainingCourseEntity.Fk_training_plan_id = trainingPlan.Id; //设置会员卡号 trainingCourseEntity.Member_id = trainingPlan.Member_id; //当前创建时间 trainingCourseEntity.Gmt_create = System.DateTime.Now; //6.创建一个默认的训练课程 // 课程开始时间 = 训练计划的开始时间 trainingCourseEntity.Start_date = trainingPlan.Start_date; // 默认暂停时间是2天 trainingCourseEntity.Rest_days = 2; // 默认课程天数是16天 trainingCourseEntity.Target_course_count = 16; // 当前计数默认0 trainingCourseEntity.Current_course_count = 0; // 默认结束日期 = 开始日期 + (暂停时间*(课程天数 - 1)) 减一是因为当天算第一天 trainingCourseEntity.End_date = trainingCourseEntity.Start_date.Value.AddDays(trainingCourseEntity.Rest_days.Value * (trainingCourseEntity.Target_course_count.Value - 1)); // 状态未完成 trainingCourseEntity.Is_complete = false; // 保存课程 //这个插入基类有BUG 明明插入进入了 但是返回的结果为0,所以不要返回值了。反正如果插入失败也报异常,返回值也没啥用 trainingCourseDAO.Insert(trainingCourseEntity); //插入至上传表 UploadManagementDAO uploadManagementDao = new UploadManagementDAO(); uploadManagementDao.Insert(new UploadManagement((int)trainingCourseEntity.Id, "bdl_training_course", 0)); //更新配置中的课程id CommUtil.UpdateSettingString("trainingCourseId", (trainingCourseEntity.Id).ToString()); //训练课程目标天数 CommUtil.UpdateSettingString("targetCourseCount", (trainingCourseEntity.Target_course_count).ToString()); //调用创建模板训练活动 trainingActivityService.AutoSaveActivityTemplate(trainingCourseEntity, trainingPlan.Fk_member_id.Value, planTemplate); ts.Complete(); } }
/// <summary> /// 根据模板自动创建训练活动 传入的是用户的数据库主键id /// </summary> /// <param name="trainingCourseEntity"></param> /// <param name="memberPkId"></param> /// <param name="planTemplate"></param> /// <returns></returns> public long AutoSaveActivityTemplate(TrainingCourseEntity trainingCourseEntity, long memberPkId, PlanTemplate planTemplate) { using (TransactionScope ts = new TransactionScope()) { long result = 0; List <ActivityEntity> activities = new List <ActivityEntity>(); //力量循环活动 ActivityEntity strengthActivity = new ActivityEntity(); //耐力循环活动 ActivityEntity enduranceActivity = new ActivityEntity(); //上传表 UploadManagementDAO uploadManagementDao = new UploadManagementDAO(); //根据不同模板创建不同的活动 switch (planTemplate) { case PlanTemplate.StrengthCycle: //力量循环 strengthActivity.Id = KeyGenerator.GetNextKeyValueLong("bdl_activity"); strengthActivity.Member_id = trainingCourseEntity.Member_id; strengthActivity.Fk_member_id = memberPkId; strengthActivity.Fk_training_course_id = trainingCourseEntity.Id; strengthActivity.Gmt_create = System.DateTime.Now; strengthActivity.Is_complete = false; //模板创建默认两轮 strengthActivity.Target_turn_number = 2; strengthActivity.current_turn_number = 0; //0:力量循环 strengthActivity.Activity_type = "0"; activities.Add(strengthActivity); // 插入至上传表 uploadManagementDao.Insert(new UploadManagement(strengthActivity.Id, "bdl_activity", 0)); break; case PlanTemplate.EnduranceCycle: //耐力循环 enduranceActivity.Id = KeyGenerator.GetNextKeyValueLong("bdl_activity"); enduranceActivity.Member_id = trainingCourseEntity.Member_id; enduranceActivity.Fk_member_id = memberPkId; enduranceActivity.Fk_training_course_id = trainingCourseEntity.Id; enduranceActivity.Gmt_create = System.DateTime.Now; enduranceActivity.Is_complete = false; //模板创建默认两轮 enduranceActivity.Target_turn_number = 2; enduranceActivity.current_turn_number = 0; //1:耐力循环 enduranceActivity.Activity_type = "1"; activities.Add(enduranceActivity); //插入至上传表 uploadManagementDao.Insert(new UploadManagement(enduranceActivity.Id, "bdl_activity", 0)); break; case PlanTemplate.StrengthEnduranceCycle: //创建力量循环活动 strengthActivity.Id = KeyGenerator.GetNextKeyValueLong("bdl_activity"); strengthActivity.Member_id = trainingCourseEntity.Member_id; strengthActivity.Fk_member_id = memberPkId; strengthActivity.Fk_training_course_id = trainingCourseEntity.Id; strengthActivity.Gmt_create = System.DateTime.Now; strengthActivity.Is_complete = false; //模板创建默认两轮 strengthActivity.Target_turn_number = 2; strengthActivity.current_turn_number = 0; //0:力量循环 strengthActivity.Activity_type = "0"; activities.Add(strengthActivity); //插入至上传表 uploadManagementDao.Insert(new UploadManagement(strengthActivity.Id, "bdl_activity", 0)); //创建耐力循环活动 enduranceActivity.Id = KeyGenerator.GetNextKeyValueLong("bdl_activity"); enduranceActivity.Member_id = trainingCourseEntity.Member_id; enduranceActivity.Fk_member_id = memberPkId; enduranceActivity.Fk_training_course_id = trainingCourseEntity.Id; enduranceActivity.Gmt_create = System.DateTime.Now; enduranceActivity.Is_complete = false; //模板创建默认两轮 enduranceActivity.Target_turn_number = 2; enduranceActivity.current_turn_number = 0; //1:耐力循环 enduranceActivity.Activity_type = "1"; activities.Add(enduranceActivity); //插入至上传表 uploadManagementDao.Insert(new UploadManagement(enduranceActivity.Id, "bdl_activity", 0)); break; default: break; } //批量插入训练活动 result = activityDAO.BatchInsert(activities); //根据训练活动批量插入个人设置记录 传入用户主键id personalSettingService.AutoSavePersonalSettings(memberPkId, trainingCourseEntity.Id, trainingCourseEntity.Member_id); ts.Complete(); return(result); } }
/// <summary> /// 自动创建模板训练计划 2019.3.27 /// </summary> /// <param name="memberId"></param> public void AutoSaveNewPlan(MemberEntity memberEntity, PlanTemplate planTemplate) { //插入至上传表 UploadManagementDAO uploadManagementDao = new UploadManagementDAO(); //使整个代码块成为事务性代码 using (TransactionScope ts = new TransactionScope()) { TrainingPlanEntity trainingPlan = new TrainingPlanEntity(); //会员卡号ID string memberId = memberEntity.Member_id; //1.删除旧的训练计划 trainingPlanDAO.DeletePlanByMemberId(memberId); //2.完成旧的训练课程 trainingCourseDAO.UpdateCompleteState(memberId, true); List <long> listId1 = new List <long>(); listId1 = trainingCourseDAO.ListIdByMemeberId(memberId); foreach (var id in listId1) { //数据上传 uploadManagementDao.Insert(new UploadManagement(id, "bdl_training_course", 1)); } //3.完成旧的训练活动 activityDAO.UpdateCompleteState(memberId, true); List <long> listId = new List <long>(); //通过memberId获取主键id listId = activityDAO.ListIdByMemeberId(memberId); foreach (var id in listId) { //数据上传 uploadManagementDao.Insert(new UploadManagement(id, "bdl_activity", 1)); } //4.新增训练计划 trainingPlan.Id = KeyGenerator.GetNextKeyValueLong("bdl_training_plan"); //外键用户主键id trainingPlan.Fk_member_id = memberEntity.Id; // 设置会员卡号 trainingPlan.Member_id = memberEntity.Member_id; // 开始时间 trainingPlan.Start_date = System.DateTime.Now; // 设置状态为未删除 trainingPlan.Is_deleted = false; // 创建时间 trainingPlan.Gmt_create = System.DateTime.Now; //训练计划标题 switch (planTemplate) { case PlanTemplate.StrengthCycle: trainingPlan.Title = "力量循环"; break; case PlanTemplate.EnduranceCycle: trainingPlan.Title = "力量耐力循环"; break; case PlanTemplate.StrengthEnduranceCycle: trainingPlan.Title = "力量循环与力量耐力循环"; break; default: break; } trainingPlan.Training_target = "塑形"; // 插入新训练计划 trainingPlanDAO.Insert(trainingPlan); uploadManagementDao.Insert(new UploadManagement(trainingPlan.Id, "bdl_training_plan", 0)); //5.更新App.config中训练计划id CommUtil.UpdateSettingString("trainingPlanId", (trainingPlan.Id).ToString()); //自动创建模板课程 trainingCourseService.AutoSaveNewTemplateCourse(trainingPlan, planTemplate); ts.Complete(); } }