/// <summary>
/// 更新赛事
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateMatchs(Model.SfList model)
{
if (dal.UpdateMatchs(model) != 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新赛事
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int UpdateMatchs(Model.SfList model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_SfList set ");
strSql.Append("Score=@Score,");
strSql.Append("Result=@Result,");
strSql.Append("EndTime=@EndTime,");
strSql.Append("Sale_StartTime=@Sale_StartTime,");
strSql.Append("Match=@Match,");
strSql.Append("Team_Home=@Team_Home,");
strSql.Append("Team_Away=@Team_Away,");
strSql.Append("Start_time=@Start_time");
strSql.Append(" where CID=@CID ");
SqlParameter[] parameters =
{
new SqlParameter("@CID", SqlDbType.Int, 4),
new SqlParameter("@Score", SqlDbType.NVarChar, 300),
new SqlParameter("@Result", SqlDbType.NVarChar, 100),
new SqlParameter("@EndTime", SqlDbType.DateTime),
new SqlParameter("@Sale_StartTime", SqlDbType.DateTime),
new SqlParameter("@Match", SqlDbType.NVarChar, 300),
new SqlParameter("@Team_Home", SqlDbType.NVarChar, 300),
new SqlParameter("@Team_Away", SqlDbType.NVarChar, 300),
new SqlParameter("@Start_time", SqlDbType.NVarChar, 300)
};
parameters[0].Value = model.CID;
parameters[1].Value = model.Score;
parameters[2].Value = model.Result;
parameters[3].Value = model.EndTime;
parameters[4].Value = model.Sale_StartTime;
parameters[5].Value = model.Match;
parameters[6].Value = model.Team_Home;
parameters[7].Value = model.Team_Away;
parameters[8].Value = model.Start_time;
return(SqlHelper.ExecuteSql(strSql.ToString(), parameters));
}
