public void TestInsertVideo()
{
for (int i = 0; i < 20; i++)
{
self_video video = new self_video()
{
title = "测试视频" + i,
courseid = 2,
teacher = 1,
m_price = 10,
fullpath = "test.mp4",
grade = 1,
subject = 1,
abstracts = "文言文讲解",
press = 1,
thumbnail = "hx0001.jpg",
createdtime = DateTime.Now,
downloads = 100,
status = 4
};
string ermsg = "";
videoDAL.Add(video, out ermsg);
Equals(ermsg != null);
}
}
public object GetCourssDetail(int videoid)
{
string errmsg = null;
int total = 0;
if (ConfigurationManager.AppSettings["createdata"].ToString().Equals("yes"))
{
return(new { video = new self_video()
{
title = "易混淆动词解析",
time = "1h:10min",
teacher = 1, courseid = 2,
abstracts = "英语中有些动词的过去式(通常也是过去分词)与另一些动词的现在式相同,因此学生常常会把它们搞错。现 将这些常见的容易使学生搞混的词汇编在一起,用练习形式供学生对比。",
source = "img/video/1.webm"
},
teacher = new self_teacher()
{
title = "王老师",
abstracts = "北京四中物理老师",
subject = "物理",
grade = "高二",
},
msg = errmsg, coursetotal = total });
}
self_video videoinfo = videoDAL.GetInfo(videoid, out errmsg);
return(new { video = videoinfo, teacher = videoinfo.teacherobject, msg = errmsg });
}
public void TestGetVideoDetail()
{
videoDAL.SetSqlConnectionString();
string errmsg = "";
int total = 0;
self_video videos = videoDAL.GetInfo(21, out errmsg);
Equals(errmsg != null);
}
/// <summary>
/// 订单管理 删除
/// </summary>
public static bool Delete(string id, out string errmsg)
{
self_video course = new self_video()
{
seqid = Convert.ToInt32(id)
};
return(OrmClass.AutoSqlExecute(course, "delete", out errmsg));
}
/// <summary>
/// 视频管理 详情查询
/// </summary>
public static self_video GetInfo(int seqid, out string errmsg)
{
List <DataParameter> pars = new List <DataParameter>();
string sqlstr = "select * from self_video where seqid=@seqid";
pars.Add(new DataParameter("seqid", seqid));
self_video video = MySqlHelper.GetDataInfo <self_video>(sqlstr, out errmsg, pars.ToArray());
if (video == null)
{
return(new self_video());
}
video.courseobject = courseDAl.GetInfo(video.courseid, out errmsg);
video.teacherobject = teacherDAL.GetInfo(video.teacher, out errmsg);
return(video);
}
/// <summary>
/// 订单管理 更新数据
/// </summary>
/// <param name="self_course">要更新的订单管理对象</param>
/// <param name="errmsg">错误信息</param>
/// <returns>返回对象</returns>
public static bool Update(self_video info, out string errmsg)
{
return(OrmClass.AutoSqlExecute(info, "update", out errmsg));
}
public static bool Add(self_video info, out string errmsg)
{
return(OrmClass.AutoSqlExecute(info, "insert", out errmsg));
}
