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