/// <summary>
/// 保存笔记
/// </summary>
/// <param name="m"></param>
/// <returns></returns>
public static void save(Models.learnNotes m)
{
using (DAL.learn.learnNotesDAL dal = new DAL.learn.learnNotesDAL())
{
dal.save(m);
}
}
/// <summary>
/// 保存错题反馈
/// </summary>
/// <param name="m"></param>
/// <returns></returns>
public void save(Models.learnNotes m)
{
string sql = "if exists(select id from learnNotes where lid=@lid and [sid]=@sid and stype=@stype and kid=@kid)";
sql += " begin update learnNotes set content=@content,createTime=GETDATE() where lid=@lid and [sid]=@sid and stype=@stype and kid=@kid end";
sql += " else begin insert into learnNotes(lid,[sid],stype,kid,content)values(@lid,@sid,@stype,@kid,@content) end";
SqlParameter[] pars =
{
new SqlParameter("@lid", m.lid),
new SqlParameter("@sid", m.sid),
new SqlParameter("@stype", m.stype),
new SqlParameter("@kid", m.kid),
new SqlParameter("@content", m.content)
};
SqlHelper.ExcuteNonQuery(sql, pars);
}
/// <summary>
/// 保存笔记 /learnpublic/savenotes
/// </summary>
/// <param name="m"></param>
/// <returns></returns>
public int saveNotes(Models.learnNotes m)
{
BLL.learn.learnNotesBLL.save(m);
return(1);
}
