/// <summary>
/// 查询网课对应的单元数据 包含单元下课次
/// </summary>
/// <param name="Model"></param>
/// <returns></returns>
public List <Course_UnitModel> GetCourse_UnitNodeList(W_Course_Unit Model, int System_Station_ID)
{
List <Course_UnitModel> UnitList = SqlMapper.QueryForList <Course_UnitModel>("GetCourse_UnitList", new { Valid = Model.Valid, System_Station_ID = System_Station_ID, Course_ID = Model.Course_ID }).ToList();
Model.System_Station_ID = System_Station_ID;
if (UnitList != null && UnitList.Count > 0)
{
//单元课次
List <W_Course_Unit_ClassTime> UnitClassTimeList = new List <W_Course_Unit_ClassTime>();
string UnitIDS = string.Join(",", UnitList.Select(x => x.ID));
//对应单元集合
UnitClassTimeList = GetCourseUnitClassTimeList(Model, UnitIDS);
if (UnitClassTimeList != null && UnitClassTimeList.Count > 0)
{ //给单元赋 对应的课次
UnitList.ForEach(F =>
{
F.UnitClassTimeList = UnitClassTimeList.FindAll(X => X.Unit_ID == F.ID);
});
}
}
else
{
throw new ApiException("未找到对应单元数据");
}
return(UnitList);
}
/// <summary>
/// 添加修改网课单元
/// </summary>
/// <param name="Model"></param>
/// <returns></returns>
public dynamic SaveCourse_Unit(W_Course_Unit Model, int System_Station_ID, int AccountID)
{
if (Model.ID > 0)
{
W_Course_Unit model = Orm.Single <W_Course_Unit>(x => x.ID == Model.ID && x.System_Station_ID == System_Station_ID);
if (model == null)
{
throw new ApiException("找不到对应数据，请重试");
}
Model.System_Station_ID = model.System_Station_ID;
Model.AddPerson = model.AddPerson;
Model.AddTime = model.AddTime;
Model.Valid = model.Valid;
Model.Orders = model.Orders;
if (Orm.Update(Model) <= 0)
{
throw new ApiException("修改失败");
}
Course_UnitModel m = SqlMapper.QueryForObject <Course_UnitModel>("SelectCourse_Unit", new { ID = model.ID, System_Station_ID = System_Station_ID });
if (m != null)
{
//单元课次
List <W_Course_Unit_ClassTime> UnitClassTimeList = new List <W_Course_Unit_ClassTime>();
//对应单元集合
UnitClassTimeList = GetCourseUnitClassTimeList(Model, m.ID.ToString());
if (UnitClassTimeList != null && UnitClassTimeList.Count > 0)
{
m.UnitClassTimeList = UnitClassTimeList.FindAll(X => X.Unit_ID == m.ID);
}
}
return(m);
}
else
{
Model.AddPerson = AccountID;
Model.System_Station_ID = System_Station_ID;
Model.AddTime = DateTime.Now;
Model.Valid = 1;
int Orders = SqlMapper.QueryForObject <int>("GetMaxCourseUnit", new { Course_ID = Model.Course_ID, System_Station_ID = System_Station_ID });
Model.Orders = Orders + 1;
int modelid = (int)Orm.Insert(Model, true);
if (modelid <= 0)
{
throw new ApiException("添加失败");
}
return(Orm.Single <W_Course_Unit>(x => x.ID == modelid && x.System_Station_ID == System_Station_ID));
}
}
/// <summary>
/// 删除单元及对应的关系表
/// </summary>
/// <param name="Model"></param>
/// <returns></returns>
public dynamic DeleteCourseUnit(W_Course_Unit Model, int System_Station_ID)
{
SqlMapper.BeginTransaction();
try
{
W_Course_Unit model = Orm.Single <W_Course_Unit>(x => x.ID == Model.ID && x.System_Station_ID == System_Station_ID);
if (model == null)
{
throw new ApiException("找不到对应数据，请重试");
}
Orm.Delete <W_Course_Unit_ClassTime>(x => x.Unit_ID == Model.ID);
Orm.Delete <W_Course_Unit>(x => x.ID == Model.ID);
Orm.Delete <W_DataInfo>(x => x.BusID == Model.ID && x.BusType == 2);
SqlMapper.CommitTransaction();
return(true);
}
catch (Exception ex)
{
SqlMapper.RollBackTransaction();
throw ex;
}
}
public dynamic SaveCourse_Unit(W_Course_Unit Model)
{
return(Success(mapper.SaveCourse_Unit(Model, this.System_Station_ID, this.AccountID)));
}
public dynamic DeleteCourseUnit(W_Course_Unit Model)
{
return(Success(mapper.DeleteCourseUnit(Model, this.System_Station_ID)));
}
public dynamic GetCourse_UnitNodeList([FromUri] W_Course_Unit Model)
{
return(Success(mapper.GetCourse_UnitNodeList(Model, this.System_Station_ID)));
}
/// <summary>
///
/// </summary>
/// <param name="Model"></param>
/// <param name="UnitIDS"></param>
/// <returns></returns>
public List <W_Course_Unit_ClassTime> GetCourseUnitClassTimeList(W_Course_Unit Model, string UnitIDS)
{
List <W_Course_Unit_ClassTime> model = SqlMapper.QueryForList <W_Course_Unit_ClassTime>("GetCourseUnitClassTimeList", new { UnitIDS = UnitIDS, ID = Model.ID, System_Station_ID = Model.System_Station_ID, Valid = Model.Valid }).ToList();
return(model);
}
