/// <summary>
/// 保存题库类型
/// </summary>
/// <param name="m"></param>
public static void save(Models.subject m)
{
using (DAL.subjectClassDAL dal = new DAL.subjectClassDAL())
{
if (m.id > 0)
{
dal.update(m);
}
else
{
dal.save(m);
}
}
}
public void update(Models.subject m)
{
string sql = "update subjectClass set name=@sname,introduce=@introduce,valid=@valid where id=@id";
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@id", m.id),
new SqlParameter("@sname", m.sname),
new SqlParameter("@valid", m.valid),
new SqlParameter("@introduce", SqlDbType.NVarChar, 2000)
};
if (m.introduce != "" && m.introduce != null)
{
param[3].Value = m.introduce;
}
else
{
param[3].Value = DBNull.Value;
}
SqlHelper.ExcuteNonQuery(sql, param);
}
public void save(Models.subject m)
{
string sql = "declare @leved int,@id int";
sql += " select @leved=leved+1 from subjectClass where ID=@pid";
sql += " select top(1) @id=ID+1 from subjectClass order by ID desc";
sql += " insert into subjectClass(ID,name,pId,leved,valid,levelID,introduce) values(@id,@sname,@pid,@leved,@valid,@levelID,@introduce)";
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@sname", m.sname),
new SqlParameter("@pid", m.pid),
new SqlParameter("@valid", m.valid),
new SqlParameter("@levelID", m.levelID),
new SqlParameter("@introduce", SqlDbType.NVarChar, 2000)
};
if (m.introduce != "" && m.introduce != null)
{
param[4].Value = m.introduce;
}
else
{
param[4].Value = DBNull.Value;
}
SqlHelper.ExcuteNonQuery(sql, param);
}
public int save(Models.subject m)
{
BLL.subjectClassBLL.save(m);
return(1);
}
