public int save(keJian objkeJian)
{
objkeJian.cont = DirFile.WriteInFileStream(objkeJian.cont, objkeJian.curl);
int result = new BLL.root.keJianBLL().save(objkeJian);
//if (result != 0 && objkeJian.curl != "0")
// DirFile.DeleteFile(objkeJian.curl);
return(result);
}
/// <summary>
/// 添加课件
/// </summary>
/// <param name="objkeJian"></param>
/// <returns></returns>
public int save(keJian objkeJian)
{
using (DAL.root.keJianDAL dal = new DAL.root.keJianDAL())
{
if (objkeJian.id != 0)
{
return(dal.UpdateKeJian(objkeJian));
}
else
{
return(dal.AddKeJian(objkeJian));
}
}
}
/// <summary>
/// 添加课件
/// </summary>
/// <param name="objkeJian"></param>
/// <returns></returns>
public int AddKeJian(keJian objkeJian)
{
string sql = "insert into keJian(levelID, sid, title, cont, cont_typ, typ, xueshi, xueshi_minute)";
sql += "values(@levelID, @sid, @title, @cont, @cont_typ, @typ, @xueshi, @xueshi_minute)";
SqlParameter[] para = new SqlParameter[] {
new SqlParameter("@levelID", objkeJian.levelID),
new SqlParameter("@sid", objkeJian.sid),
new SqlParameter("@title", objkeJian.title),
new SqlParameter("@cont", objkeJian.cont),
new SqlParameter("@cont_typ", objkeJian.cont_typ),
new SqlParameter("@typ", objkeJian.typ),
new SqlParameter("@xueshi", objkeJian.xueshi),
new SqlParameter("@xueshi_minute", objkeJian.xueshi_minute)
};
return(SqlHelper.ExcuteNonQuery(sql, para));
}
/// <summary>
/// 修改
/// </summary>
/// <param name="objkeJian"></param>
/// <returns></returns>
public int UpdateKeJian(keJian objkeJian)
{
string sql = "update keJian set levelID=@levelID, sid=@sid, title=@title, cont=@cont,";
sql += " cont_typ=@cont_typ, typ=@typ, xueshi=@xueshi, xueshi_minute=@xueshi_minute where id=@id";
SqlParameter[] para = new SqlParameter[] {
new SqlParameter("@levelID", objkeJian.levelID),
new SqlParameter("@sid", objkeJian.sid),
new SqlParameter("@title", objkeJian.title),
new SqlParameter("@cont", objkeJian.cont),
new SqlParameter("@cont_typ", objkeJian.cont_typ),
new SqlParameter("@typ", objkeJian.typ),
new SqlParameter("@xueshi", objkeJian.xueshi),
new SqlParameter("@xueshi_minute", objkeJian.xueshi_minute),
new SqlParameter("@id", objkeJian.id)
};
return(SqlHelper.ExcuteNonQuery(sql, para));
}
