public int update(subks m, string table)
{
string sql = "update " + table + " 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(subks m, string style)
{
using (DAL.root.subksDAL dal = new DAL.root.subksDAL())
{
if (m.id > 0)
{
return(dal.update(m, getTable(style)));
}
else
{
return(dal.save(m, style));
}
}
}
public int save(subks m, string stype)
{
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("@stype ", stype),
new SqlParameter("@retu", SqlDbType.Int)
};
pars[8].Direction = ParameterDirection.ReturnValue;
SqlHelper.RunProcedure("[root_instKs]", pars);
return(Convert.ToInt16(pars[8].Value));
}
