/// <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)); }