/// <summary> /// 增加方法,委托:OperModule类型 /// </summary> /// <param name="module">要新增的层次类型对象</param> /// <param name="yunEntities"></param> /// <returns>信息集对象</returns> private ResultInfo AddOper(HttpRequestBase request, YD_Edu_TeachPlan module, IYunEntities yunEntities) { var yearStr = request["year"]; var majorIdStr = request["majorId"]; var teaPlanTypeStr = request["y_teaPlanType"]; if (string.IsNullOrEmpty(yearStr) || string.IsNullOrEmpty(majorIdStr) || string.IsNullOrEmpty(teaPlanTypeStr)) { return(new ResultInfo { Success = false, Info = PowerInfo.Unknow, Message = "未知错误" }); } var year = Convert.ToInt32(yearStr); var majorId = Convert.ToInt32(majorIdStr); var teaPlanType = Convert.ToInt32(teaPlanTypeStr); var resultInfo = BaseAddEntity(module, "/Edu/TeachPlan", yunEntities); if (resultInfo.Success) { var entity = new YD_Edu_MajorTeachPlan() { y_majorId = majorId, y_teachPlanId = module.id, y_year = year, y_teaPlanType = teaPlanType }; yunEntities.Entry(entity).State = EntityState.Added; yunEntities.SaveChanges(); LogHelper.DbLog(Convert.ToInt32(HttpContext.Current.Session[KeyValue.Admin_id]), HttpContext.Current.Session[KeyValue.Admin_Name].ToString(), (int)LogType.Insert, "添加教学计划,教学计划名为" + module.y_teaPlanName + ",id:" + module.id); } return(resultInfo); }
/// <summary> /// 师范大学的添加课程 /// </summary> /// <param name="request"></param> /// <returns></returns> public string CreateTeachPlanSd(HttpRequestBase request) { using (var yunEntities = new IYunEntities()) { //获取所有提交过来的数据 var year = Convert.ToInt32(request["year"]); var y_term = Convert.ToInt32(request["term"]); var majorId = Convert.ToInt32(request["majorlihidden2"]); var teachplantype = 2; var y_courseId = Convert.ToInt32(request["coursehidden"]); var y_courseTypeId = Convert.ToInt32(request["y_courseTypeId"]); var y_stuTime = Convert.ToInt32(request["y_stuTime"]); var y_score = Convert.ToDecimal(request["y_score"]); //查询出teachPlanID var teachplanid = yunEntities.VW_MajorTeachPlan.FirstOrDefault( u => u.y_teaPlanType == teachplantype && u.y_majorId == majorId && u.y_term == y_term && u.y_year == year); if (teachplanid == null) { var majorlist = yunEntities.YD_Edu_Major.Where(u => u.id == majorId).ToList(); foreach (var m in majorlist) { //添加教学计划 var teachplan = new YD_Edu_TeachPlan() { y_teaPlanName = m.y_name + "第" + y_term + "学期" + teachplantype + "类型" + year + "年" + DateTime.Now.ToString("yyyy/MM/dd"), y_term = y_term }; yunEntities.Entry(teachplan).State = EntityState.Added; yunEntities.SaveChanges(); //添加专业教学计划 var majorthachplan = new YD_Edu_MajorTeachPlan() { y_year = year, y_majorId = majorId, y_teachPlanId = teachplan.id, y_teaPlanType = teachplantype }; yunEntities.Entry(majorthachplan).State = EntityState.Added; yunEntities.SaveChanges(); } //查询专业教学计划视图得到添加的教学计划id teachplanid = yunEntities.VW_MajorTeachPlan.FirstOrDefault( u => u.y_teaPlanType == teachplantype && u.y_majorId == majorId && u.y_term == y_term && u.y_year == year); } //插入数据 var TeachplanDes = new YD_Edu_TeachplanDes() { y_teaPlanId = teachplanid.y_teachPlanId, y_courseId = y_courseId, y_courseTypeId = y_courseTypeId, y_stuTime = y_stuTime, y_score = y_score }; yunEntities.Entry(TeachplanDes).State = EntityState.Added; int r = yunEntities.SaveChanges(); if (r > 0) { return("ok"); } else { return("未知错误"); } } }