/// <summary> /// 保存表单(新增、修改) /// </summary> /// <param name="keyValue">主键值</param> /// <param name="entity">实体对象</param> /// <returns></returns> public void SaveForm(string keyValue, TrainingPlanEntity entity) { try { service.SaveForm(conEntity.DbConnection, keyValue, entity); } catch (Exception) { throw; } }
public TrainingPlanDTO(TrainingPlanEntity trainingPlanEntity) { this.Id = trainingPlanEntity.Id.ToString(); this.FkMemberId = trainingPlanEntity.Fk_member_id.ToString(); this.MemberId = trainingPlanEntity.Member_id; this.Title = trainingPlanEntity.Title; this.StartDate = trainingPlanEntity.Start_date.ToString().Replace("/", "-"); this.TrainingTarget = trainingPlanEntity.Training_target; this.IsDeleted = trainingPlanEntity.Is_deleted.ToString(); this.GmtCreate = trainingPlanEntity.Gmt_create.ToString().Replace("/", "-"); this.GmtModified = trainingPlanEntity.Gmt_modified.ToString().Replace("/", "-"); }
/// <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> /// 自动创建模板训练计划 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(); } }
/// <summary> /// 添加新的训练计划,需要先删除旧的训练计划 /// </summary> /// <param name="trainingPlan"></param> /// <returns></returns> public void SaveNewTrainingPlan(TrainingPlanEntity trainingPlan) { //使整个代码块成为事务性代码 using (TransactionScope ts = new TransactionScope()) { UploadManagementDAO uploadManagementDao = new UploadManagementDAO(); //会员卡号ID string memberId = CommUtil.GetSettingString("memberId"); //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"); //判断登陆用户,是教练自己锻炼。还是教练为用户进行设置。决定传哪个主键设置 string currentMemberPK = CommUtil.GetSettingString("memberPrimarykey"); string currentCoachId = CommUtil.GetSettingString("coachId"); if ((currentMemberPK == null || currentMemberPK == "") && (currentCoachId != null && currentCoachId != "")) { //无用户登陆。教练单独登陆时 // 从app.config中取id,转成int赋值 trainingPlan.Fk_member_id = ParseIntegerUtil.ParseInt(currentCoachId); } else { //只要用户登录,就是为用户进行设置 // 从app.config中取id,转成int赋值 trainingPlan.Fk_member_id = ParseIntegerUtil.ParseInt(currentMemberPK); } // 设置会员卡号 trainingPlan.Member_id = CommUtil.GetSettingString("memberId"); // 设置状态为未删除 trainingPlan.Is_deleted = false; // 创建时间 trainingPlan.Gmt_create = System.DateTime.Now; // 插入新训练计划 trainingPlanDAO.Insert(trainingPlan); //插入至上传表 uploadManagementDao.Insert(new UploadManagement(trainingPlan.Id, "bdl_training_plan", 0)); //5.更新App.config中训练计划id CommUtil.UpdateSettingString("trainingPlanId", (trainingPlan.Id).ToString()); //插入默认训练课程 课程开始时间 = 训练计划开始时间 trainingCourseService.SaveTrainingCourse(trainingPlan.Start_date); ts.Complete(); } }
/// <summary> /// 1.该方法可用于登陆后,根据传入卡号更新App.config。 /// 2.允许教练单独登陆,那么这些设置都是教练的,可以和普通用户一样查看图表。教练、用户同时登陆则保留用户的信息,两个主键位都有值 /// 3.参roleId 1代表用户 0代表教练 /// 4.登陆成功的情况更新数据库最近登陆时间 /// </summary> /// <param name="memberId"></param> /// <param name="roleId"></param> private Enum UpdateSetting(string memberId, string roleId) { try { //系统允许至多一位教练和一位用户同时登录,存一个用户主键和一系列ID,存一个教练id string currentMemberPK = CommUtil.GetSettingString("memberPrimarykey"); string currentCoachId = CommUtil.GetSettingString("coachId"); if ((currentMemberPK == null || currentMemberPK == "") && (currentCoachId == null || currentCoachId == "")) { //同时为空 无人登陆 //判断登陆者角色 if ("1".Equals(roleId))//用户 { //1.更新会员卡号ID CommUtil.UpdateSettingString("memberId", memberId); //3.更新当前登陆用户的训练计划id TrainingPlanEntity trainingPlanEntity = trainingPlanDAO.GetTrainingPlanByMumberId(memberId); if (trainingPlanEntity != null) { CommUtil.UpdateSettingString("trainingPlanId", (trainingPlanEntity.Id).ToString()); } //4.更新当前登陆用户的训练课程id TrainingCourseEntity trainingCourseEntity = trainingCourseDAO.GetCourseByMemberId(memberId); if (trainingCourseEntity != null) { CommUtil.UpdateSettingString("trainingCourseId", (trainingCourseEntity.Id).ToString()); //5.更新当前登陆用户的当前课程记录id current_course_count CommUtil.UpdateSettingString("currentCourseCount", (trainingCourseEntity.Current_course_count).ToString()); //5.更新当前登陆用户的目标课程记录id CommUtil.UpdateSettingString("targetCourseCount", (trainingCourseEntity.Target_course_count).ToString()); } //6.更新当前登陆会员的主键 //根据卡号查询会员 MemberEntity member = memberDAO.GetMember(memberId); if (member != null) { CommUtil.UpdateSettingString("memberPrimarykey", (member.Id).ToString()); //7.更新会员最近登录时间 member.Last_login_date = System.DateTime.Now; UpdateLastLoginDate(member); } logger.Debug("状态:无教练无用户登录。用户登录,返回用户页 ID:" + memberId); //需要返回的页面类型 return(LoginPageStatus.UserPage); } else if ("0".Equals(roleId))//教练登陆 { //1.更新会员卡号ID CommUtil.UpdateSettingString("memberId", memberId); //3.更新当前登陆用户的训练计划id TrainingPlanEntity trainingPlanEntity = trainingPlanDAO.GetTrainingPlanByMumberId(memberId); if (trainingPlanEntity != null) { CommUtil.UpdateSettingString("trainingPlanId", (trainingPlanEntity.Id).ToString()); } //4.更新当前登陆用户的训练课程id TrainingCourseEntity trainingCourseEntity = trainingCourseDAO.GetCourseByMemberId(memberId); if (trainingCourseEntity != null) { CommUtil.UpdateSettingString("trainingCourseId", (trainingCourseEntity.Id).ToString()); //5.更新当前登陆用户的当前课程记录id current_course_count CommUtil.UpdateSettingString("currentCourseCount", (trainingCourseEntity.Current_course_count).ToString()); //5.更新当前登陆用户的目标课程记录id CommUtil.UpdateSettingString("targetCourseCount", (trainingCourseEntity.Target_course_count).ToString()); } //6.更新当前登陆用户的主键 //根据卡号查询用户 MemberEntity member = memberDAO.GetMember(memberId); if (member != null) { //7.更新教练最近登录时间 member.Last_login_date = System.DateTime.Now; UpdateLastLoginDate(member); //8.更新教练ID CommUtil.UpdateSettingString("coachId", (member.Id).ToString()); } logger.Debug("状态:无教练无用户登录。教练登录,返回教练页面。ID:" + memberId); //需要返回的页面类型 return(LoginPageStatus.CoachPage); } } else if ((currentMemberPK == null || currentMemberPK == "") && (currentCoachId != null && currentCoachId != "")) { //教练已经登陆 会员未登陆 //判断登陆者角色 if ("1".Equals(roleId))//此时用户登陆还是在教练页面 { //1.更新会员卡号ID CommUtil.UpdateSettingString("memberId", memberId); //3.更新当前登陆用户的训练计划id TrainingPlanEntity trainingPlanEntity = trainingPlanDAO.GetTrainingPlanByMumberId(memberId); if (trainingPlanEntity != null) { CommUtil.UpdateSettingString("trainingPlanId", (trainingPlanEntity.Id).ToString()); } //4.更新当前登陆用户的训练课程id TrainingCourseEntity trainingCourseEntity = trainingCourseDAO.GetCourseByMemberId(memberId); if (trainingCourseEntity != null) { CommUtil.UpdateSettingString("trainingCourseId", (trainingCourseEntity.Id).ToString()); //5.更新当前登陆用户的当前课程记录id current_course_count CommUtil.UpdateSettingString("currentCourseCount", (trainingCourseEntity.Current_course_count).ToString()); //5.更新当前登陆用户的目标课程记录id CommUtil.UpdateSettingString("targetCourseCount", (trainingCourseEntity.Target_course_count).ToString()); } //6.更新当前登陆会员的主键 //根据卡号查询会员 MemberEntity member = memberDAO.GetMember(memberId); if (member != null) { CommUtil.UpdateSettingString("memberPrimarykey", (member.Id).ToString()); //7.更新会员最近登录时间 member.Last_login_date = System.DateTime.Now; UpdateLastLoginDate(member); } logger.Debug("状态:教练已经登陆 会员未登陆。用户登录,返回教练页面。ID:" + memberId); return(LoginPageStatus.CoachPage); } else if ("0".Equals(roleId))//教练重复登陆 { logger.Debug("状态:教练已经登陆 会员未登陆。其他教练重复登录,已拦截,ID:" + memberId); return(LoginPageStatus.RepeatLogins); } } else if ((currentMemberPK != null && currentMemberPK != "") && (currentCoachId == null || currentCoachId == "")) { //会员已登陆 教练未登录 //判断登陆者角色 if ("1".Equals(roleId))//用户 { logger.Debug("状态:会员已登陆 教练未登录。其他用户重复登录,已拦截,ID:" + memberId); return(LoginPageStatus.RepeatLogins); } else if ("0".Equals(roleId))//教练登陆 原用户的设置不动 只增加教练ID { //8.更新教练ID MemberEntity member = memberDAO.GetMember(memberId); if (member != null) { CommUtil.UpdateSettingString("coachId", (member.Id).ToString()); //更新教练最近登录时间 member.Last_login_date = System.DateTime.Now; UpdateLastLoginDate(member); } logger.Debug("状态:会员已登陆 教练未登录。教练登录,ID:" + memberId); //需要返回的页面类型 return(LoginPageStatus.CoachPage); } } else if ((currentMemberPK != null && currentMemberPK != "") && (currentCoachId != null && currentCoachId != "")) { //会员已登录 教练已登录 logger.Debug("状态:会员已登录 教练已登录。已有登陆会员和教练。重复登录,ID:" + memberId); return(LoginPageStatus.RepeatLogins); } else { return(LoginPageStatus.UnknownID); } } catch (Exception ex) { logger.Warn("用户登录更新配置类出现异常"); throw new Exception("用户登录更新配置类出现异常", ex); } return(LoginPageStatus.UnknownID); }