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