/// <summary>
/// 更新赛事
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateMatchs(Model.BQCList model)
{
if (dal.UpdateMatchs(model) != 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新赛事
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int UpdateMatchs(Model.BQCList model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_BQCList 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));
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(Model.BQCList model)
{
dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(Model.BQCList model)
{
dal.Add(model);
}
/// <summary>
/// 根据期号得到一个对象实体
/// </summary>
public Model.BQCList GetBQCListByCID(int CID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,CID,Match,Team_Home,Team_Away,Start_time,Score,Result,State,PayCent,PayCount,EndTime,other,Sale_StartTime,nowprize,nextprize,sysprize,sysprizestatue,sysdayprize from tb_BQCList ");
strSql.Append(" where CID=@CID ");
SqlParameter[] parameters =
{
new SqlParameter("@CID", SqlDbType.Int, 4)
};
parameters[0].Value = CID;
Model.BQCList model = new Model.BQCList();
using (SqlDataReader reader = SqlHelper.ExecuteReader(strSql.ToString(), parameters))
{
if (reader.HasRows)
{
reader.Read();
model.id = reader.GetInt32(0);
model.CID = reader.GetInt32(1);
model.Match = reader.GetString(2);
model.Team_Home = reader.GetString(3);
model.Team_Away = reader.GetString(4);
model.Start_time = reader.GetString(5);
if (!reader.IsDBNull(6))
{
model.Score = reader.GetString(6);
}
model.Result = reader.GetString(7);
model.State = reader.GetInt32(8);
if (!reader.IsDBNull(9))
{
model.PayCent = reader.GetInt64(9);
}
if (!reader.IsDBNull(10))
{
model.PayCount = reader.GetInt32(10);
}
model.EndTime = reader.GetDateTime(11);
if (!reader.IsDBNull(12))
{
model.other = reader.GetString(12);
}
if (!reader.IsDBNull(13))
{
model.Sale_StartTime = reader.GetDateTime(13);
}
if (!reader.IsDBNull(14))
{
model.nowprize = reader.GetInt64(14);
}
model.nextprize = reader.GetInt64(15);
model.sysprize = reader.GetInt64(16);
model.sysprizestatue = reader.GetInt32(17);
model.sysdayprize = reader.GetInt64(18);
return(model);
}
else
{
return(null);
}
}
}
