/// <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("未知错误");
}
}
}
