public int update(subju m)
{
string sql = "update JudgementSubject set Title=@title,Subjects=@subs,result=@result,SubjectClassID=@sid,mender=@mender,mendTime=GETDATE(),explain=@explain,inputState=@instate where ID=@id";
SqlParameter[] pars =
{
new SqlParameter("@id", m.id),
new SqlParameter("@sid", m.sid),
new SqlParameter("@title ", m.title),
new SqlParameter("@subs ", m.subs),
new SqlParameter("@explain ", SqlDbType.NVarChar),
new SqlParameter("@result ", m.result),
new SqlParameter("@instate ", m.instate),
new SqlParameter("@mender ", m.creator)
};
if (m.explain != "" && m.explain != null)
{
pars[4].Value = m.explain;
}
else
{
pars[4].Value = DBNull.Value;
}
return(SqlHelper.ExcuteNonQuery(sql, pars));
}
public static int save(subju m)
{
using (DAL.root.subjuDAL dal = new DAL.root.subjuDAL())
{
if (m.id > 0)
{
return(dal.update(m));
}
else
{
return(dal.save(m));
}
}
}
public int save(subju m)
{
SqlParameter[] pars =
{
new SqlParameter("@sid", m.sid),
new SqlParameter("@title ", m.title),
new SqlParameter("@subs ", m.subs),
new SqlParameter("@explain ", m.explain),
new SqlParameter("@result ", m.result),
new SqlParameter("@instate ", m.instate),
new SqlParameter("@creator ", m.creator),
new SqlParameter("@retu", SqlDbType.Int)
};
pars[7].Direction = ParameterDirection.ReturnValue;
SqlHelper.RunProcedure("[root_instJu]", pars);
return(Convert.ToInt16(pars[7].Value));
}
