/// <summary>
/// 新增
/// </summary>
/// <param name="su"></param>
/// <returns></returns>
public int FootAdd(Super su)
{
string sql = @"INSERT INTO scheduleinfo
(
count,
hostteamid,
awayteamid,
competitiontime,
competitionposition,
score,
entryperson,
entrytime)
VALUES(
@count,
@hostteamid,
@awayteamid,
@competitiontime,
@competitionposition,
@score,
@entryperson,
@entrytime)";
SqlParameter[] sqlps = new SqlParameter[8];
sqlps[0] = new SqlParameter("@count", su.count);
sqlps[1] = new SqlParameter("@hostteamid", su.hostteamid);
sqlps[2] = new SqlParameter("@awayteamid", su.awayteamid);
sqlps[3] = new SqlParameter("@competitiontime", su.competitiontime);
sqlps[4] = new SqlParameter("@competitionposition", su.competitionposition);
sqlps[5] = new SqlParameter("@score", su.score);
sqlps[6] = new SqlParameter("@entryperson", su.entryperson);
sqlps[7] = new SqlParameter("@entrytime", su.entrytime);
return(DBHelper.ExcuteNonQuery(sql, sqlps));
}
//删除
public int Delete(string count)
{
string sql = "delete dbo.scheduleinfo where COUNT=@count";
SqlParameter [] sqlps = new SqlParameter[1];
sqlps[0] = new SqlParameter("@count", count);
return(DBHelper.ExcuteNonQuery(sql, sqlps));
}
//修改
public int update(Super su)
{
string sql = @"update scheduleinfo set competitiontime=@competitiontime,competitionposition=@competitionposition,score=@score,entryperson=@entryperson
,hostteamid=@hostteamid,awayteamid=@awayteamid
where count=@count";
SqlParameter[] sqlps = new SqlParameter[7];
sqlps[0] = new SqlParameter("@competitiontime", su.competitiontime.ToString());
sqlps[1] = new SqlParameter("@competitionposition", su.competitionposition);
sqlps[2] = new SqlParameter("@score", su.score);
sqlps[3] = new SqlParameter("@entryperson", su.entryperson);
sqlps[4] = new SqlParameter("@count", su.count);
sqlps[5] = new SqlParameter("@hostteamid", su.hostteamid);
sqlps[6] = new SqlParameter("@awayteamid", su.awayteamid);
return(DBHelper.ExcuteNonQuery(sql, sqlps));
}
