/// <summary> /// 增加一条数据 /// </summary> public void Add(SeoWebSite.Model.ScheduleAnalysis model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into ScheduleAnalysis("); strSql.Append("scheduleid,oddswin,oddsdraw,oddslost,perwin,perdraw,perlost,time)"); strSql.Append(" values ("); strSql.Append("@scheduleid,@oddswin,@oddsdraw,@oddslost,@perwin,@perdraw,@perlost,@time)"); SqlParameter[] parameters = { new SqlParameter("@scheduleid", SqlDbType.Int, 4), new SqlParameter("@oddswin", SqlDbType.Float, 8), new SqlParameter("@oddsdraw", SqlDbType.Float, 8), new SqlParameter("@oddslost", SqlDbType.Float, 8), new SqlParameter("@perwin", SqlDbType.Float, 8), new SqlParameter("@perdraw", SqlDbType.Float, 8), new SqlParameter("@perlost", SqlDbType.Float, 8), new SqlParameter("@time", SqlDbType.DateTime) }; parameters[0].Value = model.scheduleid; parameters[1].Value = model.oddswin; parameters[2].Value = model.oddsdraw; parameters[3].Value = model.oddslost; parameters[4].Value = model.perwin; parameters[5].Value = model.perdraw; parameters[6].Value = model.perlost; parameters[7].Value = model.time; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 获得数据列表 /// </summary> public List <SeoWebSite.Model.ScheduleAnalysis> DataTableToList(DataTable dt) { List <SeoWebSite.Model.ScheduleAnalysis> modelList = new List <SeoWebSite.Model.ScheduleAnalysis>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { SeoWebSite.Model.ScheduleAnalysis model; for (int n = 0; n < rowsCount; n++) { model = new SeoWebSite.Model.ScheduleAnalysis(); if (dt.Rows[n]["id"] != null && dt.Rows[n]["id"].ToString() != "") { model.id = int.Parse(dt.Rows[n]["id"].ToString()); } if (dt.Rows[n]["scheduleid"] != null && dt.Rows[n]["scheduleid"].ToString() != "") { model.scheduleid = int.Parse(dt.Rows[n]["scheduleid"].ToString()); } if (dt.Rows[n]["oddswin"] != null && dt.Rows[n]["oddswin"].ToString() != "") { model.oddswin = decimal.Parse(dt.Rows[n]["oddswin"].ToString()); } if (dt.Rows[n]["oddsdraw"] != null && dt.Rows[n]["oddsdraw"].ToString() != "") { model.oddsdraw = decimal.Parse(dt.Rows[n]["oddsdraw"].ToString()); } if (dt.Rows[n]["oddslost"] != null && dt.Rows[n]["oddslost"].ToString() != "") { model.oddslost = decimal.Parse(dt.Rows[n]["oddslost"].ToString()); } if (dt.Rows[n]["perwin"] != null && dt.Rows[n]["perwin"].ToString() != "") { model.perwin = decimal.Parse(dt.Rows[n]["perwin"].ToString()); } if (dt.Rows[n]["perdraw"] != null && dt.Rows[n]["perdraw"].ToString() != "") { model.perdraw = decimal.Parse(dt.Rows[n]["perdraw"].ToString()); } if (dt.Rows[n]["perlost"] != null && dt.Rows[n]["perlost"].ToString() != "") { model.perlost = decimal.Parse(dt.Rows[n]["perlost"].ToString()); } if (dt.Rows[n]["totalCount"] != null && dt.Rows[n]["totalCount"].ToString() != "") { model.totalCount = int.Parse(dt.Rows[n]["totalCount"].ToString()); } if (dt.Rows[n]["time"] != null && dt.Rows[n]["time"].ToString() != "") { model.time = DateTime.Parse(dt.Rows[n]["time"].ToString()); } modelList.Add(model); } } return(modelList); }
/// <summary> /// 获得数据列表 /// </summary> public List<SeoWebSite.Model.ScheduleAnalysis> DataTableToList(DataTable dt) { List<SeoWebSite.Model.ScheduleAnalysis> modelList = new List<SeoWebSite.Model.ScheduleAnalysis>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { SeoWebSite.Model.ScheduleAnalysis model; for (int n = 0; n < rowsCount; n++) { model = new SeoWebSite.Model.ScheduleAnalysis(); if (dt.Rows[n]["id"] != null && dt.Rows[n]["id"].ToString() != "") { model.id = int.Parse(dt.Rows[n]["id"].ToString()); } if (dt.Rows[n]["scheduleid"] != null && dt.Rows[n]["scheduleid"].ToString() != "") { model.scheduleid = int.Parse(dt.Rows[n]["scheduleid"].ToString()); } if (dt.Rows[n]["oddswin"] != null && dt.Rows[n]["oddswin"].ToString() != "") { model.oddswin = decimal.Parse(dt.Rows[n]["oddswin"].ToString()); } if (dt.Rows[n]["oddsdraw"] != null && dt.Rows[n]["oddsdraw"].ToString() != "") { model.oddsdraw = decimal.Parse(dt.Rows[n]["oddsdraw"].ToString()); } if (dt.Rows[n]["oddslost"] != null && dt.Rows[n]["oddslost"].ToString() != "") { model.oddslost = decimal.Parse(dt.Rows[n]["oddslost"].ToString()); } if (dt.Rows[n]["perwin"] != null && dt.Rows[n]["perwin"].ToString() != "") { model.perwin = decimal.Parse(dt.Rows[n]["perwin"].ToString()); } if (dt.Rows[n]["perdraw"] != null && dt.Rows[n]["perdraw"].ToString() != "") { model.perdraw = decimal.Parse(dt.Rows[n]["perdraw"].ToString()); } if (dt.Rows[n]["perlost"] != null && dt.Rows[n]["perlost"].ToString() != "") { model.perlost = decimal.Parse(dt.Rows[n]["perlost"].ToString()); } if (dt.Rows[n]["totalCount"] != null && dt.Rows[n]["totalCount"].ToString() != "") { model.totalCount = int.Parse(dt.Rows[n]["totalCount"].ToString()); } if (dt.Rows[n]["time"] != null && dt.Rows[n]["time"].ToString() != "") { model.time = DateTime.Parse(dt.Rows[n]["time"].ToString()); } modelList.Add(model); } } return modelList; }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(SeoWebSite.Model.ScheduleAnalysis model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ScheduleAnalysis set "); strSql.Append("scheduleid=@scheduleid,"); strSql.Append("oddswin=@oddswin,"); strSql.Append("oddsdraw=@oddsdraw,"); strSql.Append("oddslost=@oddslost,"); strSql.Append("perwin=@perwin,"); strSql.Append("perdraw=@perdraw,"); strSql.Append("perlost=@perlost,"); strSql.Append("totalCount=@totalCount,"); strSql.Append("time=@time"); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@scheduleid", SqlDbType.Int, 4), new SqlParameter("@oddswin", SqlDbType.Float, 8), new SqlParameter("@oddsdraw", SqlDbType.Float, 8), new SqlParameter("@oddslost", SqlDbType.Float, 8), new SqlParameter("@perwin", SqlDbType.Float, 8), new SqlParameter("@perdraw", SqlDbType.Float, 8), new SqlParameter("@perlost", SqlDbType.Float, 8), new SqlParameter("@totalCount", SqlDbType.Int, 4), new SqlParameter("@time", SqlDbType.DateTime), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.scheduleid; parameters[1].Value = model.oddswin; parameters[2].Value = model.oddsdraw; parameters[3].Value = model.oddslost; parameters[4].Value = model.perwin; parameters[5].Value = model.perdraw; parameters[6].Value = model.perlost; parameters[7].Value = model.totalCount; parameters[8].Value = model.time; parameters[9].Value = model.id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public SeoWebSite.Model.ScheduleAnalysis GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,scheduleid,oddswin,oddsdraw,oddslost,perwin,perdraw,perlost,totalCount,time from ScheduleAnalysis "); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int,4)}; parameters[0].Value = id; SeoWebSite.Model.ScheduleAnalysis model = new SeoWebSite.Model.ScheduleAnalysis(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["id"] != null && ds.Tables[0].Rows[0]["id"].ToString() != "") { model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString()); } if (ds.Tables[0].Rows[0]["scheduleid"] != null && ds.Tables[0].Rows[0]["scheduleid"].ToString() != "") { model.scheduleid = int.Parse(ds.Tables[0].Rows[0]["scheduleid"].ToString()); } if (ds.Tables[0].Rows[0]["oddswin"] != null && ds.Tables[0].Rows[0]["oddswin"].ToString() != "") { model.oddswin = decimal.Parse(ds.Tables[0].Rows[0]["oddswin"].ToString()); } if (ds.Tables[0].Rows[0]["oddsdraw"] != null && ds.Tables[0].Rows[0]["oddsdraw"].ToString() != "") { model.oddsdraw = decimal.Parse(ds.Tables[0].Rows[0]["oddsdraw"].ToString()); } if (ds.Tables[0].Rows[0]["oddslost"] != null && ds.Tables[0].Rows[0]["oddslost"].ToString() != "") { model.oddslost = decimal.Parse(ds.Tables[0].Rows[0]["oddslost"].ToString()); } if (ds.Tables[0].Rows[0]["perwin"] != null && ds.Tables[0].Rows[0]["perwin"].ToString() != "") { model.perwin = decimal.Parse(ds.Tables[0].Rows[0]["perwin"].ToString()); } if (ds.Tables[0].Rows[0]["perdraw"] != null && ds.Tables[0].Rows[0]["perdraw"].ToString() != "") { model.perdraw = decimal.Parse(ds.Tables[0].Rows[0]["perdraw"].ToString()); } if (ds.Tables[0].Rows[0]["perlost"] != null && ds.Tables[0].Rows[0]["perlost"].ToString() != "") { model.perlost = decimal.Parse(ds.Tables[0].Rows[0]["perlost"].ToString()); } if (ds.Tables[0].Rows[0]["totalCount"] != null && ds.Tables[0].Rows[0]["totalCount"].ToString() != "") { model.totalCount = int.Parse(ds.Tables[0].Rows[0]["totalCount"].ToString()); } if (ds.Tables[0].Rows[0]["time"] != null && ds.Tables[0].Rows[0]["time"].ToString() != "") { model.time = DateTime.Parse(ds.Tables[0].Rows[0]["time"].ToString()); } return model; } else { return null; } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(SeoWebSite.Model.ScheduleAnalysis model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public void Add(SeoWebSite.Model.ScheduleAnalysis model) { dal.Add(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public SeoWebSite.Model.ScheduleAnalysis GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,scheduleid,oddswin,oddsdraw,oddslost,perwin,perdraw,perlost,totalCount,time from ScheduleAnalysis "); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; SeoWebSite.Model.ScheduleAnalysis model = new SeoWebSite.Model.ScheduleAnalysis(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["id"] != null && ds.Tables[0].Rows[0]["id"].ToString() != "") { model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString()); } if (ds.Tables[0].Rows[0]["scheduleid"] != null && ds.Tables[0].Rows[0]["scheduleid"].ToString() != "") { model.scheduleid = int.Parse(ds.Tables[0].Rows[0]["scheduleid"].ToString()); } if (ds.Tables[0].Rows[0]["oddswin"] != null && ds.Tables[0].Rows[0]["oddswin"].ToString() != "") { model.oddswin = decimal.Parse(ds.Tables[0].Rows[0]["oddswin"].ToString()); } if (ds.Tables[0].Rows[0]["oddsdraw"] != null && ds.Tables[0].Rows[0]["oddsdraw"].ToString() != "") { model.oddsdraw = decimal.Parse(ds.Tables[0].Rows[0]["oddsdraw"].ToString()); } if (ds.Tables[0].Rows[0]["oddslost"] != null && ds.Tables[0].Rows[0]["oddslost"].ToString() != "") { model.oddslost = decimal.Parse(ds.Tables[0].Rows[0]["oddslost"].ToString()); } if (ds.Tables[0].Rows[0]["perwin"] != null && ds.Tables[0].Rows[0]["perwin"].ToString() != "") { model.perwin = decimal.Parse(ds.Tables[0].Rows[0]["perwin"].ToString()); } if (ds.Tables[0].Rows[0]["perdraw"] != null && ds.Tables[0].Rows[0]["perdraw"].ToString() != "") { model.perdraw = decimal.Parse(ds.Tables[0].Rows[0]["perdraw"].ToString()); } if (ds.Tables[0].Rows[0]["perlost"] != null && ds.Tables[0].Rows[0]["perlost"].ToString() != "") { model.perlost = decimal.Parse(ds.Tables[0].Rows[0]["perlost"].ToString()); } if (ds.Tables[0].Rows[0]["totalCount"] != null && ds.Tables[0].Rows[0]["totalCount"].ToString() != "") { model.totalCount = int.Parse(ds.Tables[0].Rows[0]["totalCount"].ToString()); } if (ds.Tables[0].Rows[0]["time"] != null && ds.Tables[0].Rows[0]["time"].ToString() != "") { model.time = DateTime.Parse(ds.Tables[0].Rows[0]["time"].ToString()); } return(model); } else { return(null); } }