/// <summary>
/// 更新数据
/// </summary>
/// <param name="sc">模型类</param>
/// <returns>受影响的行数</returns>
public int Update(SC_Mapping sc)
{
string sql = "UPDATE SC_Mapping SET sid = @sid,cid = @cid,score = @score WHERE scid = @scid;";
SqlParameter[] param =
{
new SqlParameter("@scid", SqlDbType.Int)
{
Value = sc.scid
},
new SqlParameter("@sid", SqlDbType.Int)
{
Value = sc.sid
},
new SqlParameter("@cid", SqlDbType.Int)
{
Value = sc.cid
},
new SqlParameter("@score", SqlDbType.Int)
{
Value = sc.score
}
};
return(ADOTools.ExecuteNonQuery(sql, param));
}
/// <summary>
/// 插入数据
/// </summary>
/// <param name="sc">模型类</param>
/// <returns>受影响的行数</returns>
public int Add(SC_Mapping sc)
{
string sql = "INSERT INTO SC_Mapping(sid,cid,score) VALUES(@sid,@cid,@score);";
SqlParameter[] param =
{
new SqlParameter("@sid", SqlDbType.Int)
{
Value = sc.sid
},
new SqlParameter("@cid", SqlDbType.Int)
{
Value = sc.cid
},
new SqlParameter("@score", SqlDbType.Int)
{
Value = sc.score
}
};
return(ADOTools.ExecuteNonQuery(sql, param));
}
//更新数据
public int Update(SC_Mapping sc)
{
return(scdal.Update(sc));
}
//插入数据
public int Add(SC_Mapping sc)
{
return(scdal.Add(sc));
}
