/// <summary> /// 增加一条数据 /// </summary> public int Add(SeoWebSite.Model.Schedule1 model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Schedule("); strSql.Append("ScheduleID,Data,Date)"); strSql.Append(" values ("); strSql.Append("@ScheduleID,@Data,@Date)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@ScheduleID", SqlDbType.Int, 4), new SqlParameter("@Data", SqlDbType.VarChar, 1000), new SqlParameter("@Date", SqlDbType.Date, 3) }; parameters[0].Value = model.ScheduleID; parameters[1].Value = model.Data; parameters[2].Value = model.Date; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(1); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个有数据未分析对象实体 /// </summary> public SeoWebSite.Model.Schedule1 GetTopOne_NoExp() { StringBuilder strSql = new StringBuilder(); strSql.Append("select top(1) s.* from Schedule s where s.ScheduleID in (select o.scheduleid from odds1x2history o where o.scheduleid=s.ScheduleID) and not exists (select b.id from BetExp b where b.id=s.ScheduleID)"); SeoWebSite.Model.Schedule1 model = new SeoWebSite.Model.Schedule1(); DataSet ds = DbHelperSQL.Query(strSql.ToString()); if (ds.Tables[0].Rows.Count > 0) { if (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"].ToString() != "") { model.ScheduleID = int.Parse(ds.Tables[0].Rows[0]["ScheduleID"].ToString()); } model.Data = ds.Tables[0].Rows[0]["Data"].ToString(); if (ds.Tables[0].Rows[0]["Date"].ToString() != "") { model.Date = DateTime.Parse(ds.Tables[0].Rows[0]["Date"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public void Update(SeoWebSite.Model.Schedule1 model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Schedule set "); strSql.Append("ScheduleID=@ScheduleID,"); strSql.Append("Data=@Data,"); strSql.Append("Date=@Date"); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4), new SqlParameter("@ScheduleID", SqlDbType.Int, 4), new SqlParameter("@Data", SqlDbType.VarChar, 1000), new SqlParameter("@Date", SqlDbType.Date, 3) }; parameters[0].Value = model.id; parameters[1].Value = model.ScheduleID; parameters[2].Value = model.Data; parameters[3].Value = model.Date; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 得到一个对象实体 /// </summary> public SeoWebSite.Model.Schedule1 GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,ScheduleID,Data,Date from Schedule "); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; SeoWebSite.Model.Schedule1 model = new SeoWebSite.Model.Schedule1(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (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"].ToString() != "") { model.ScheduleID = int.Parse(ds.Tables[0].Rows[0]["ScheduleID"].ToString()); } model.Data = ds.Tables[0].Rows[0]["Data"].ToString(); if (ds.Tables[0].Rows[0]["Date"].ToString() != "") { model.Date = DateTime.Parse(ds.Tables[0].Rows[0]["Date"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// �õ�һ��������δ��������ʵ�� /// </summary> public SeoWebSite.Model.Schedule1 GetTopOne_NoExp() { StringBuilder strSql = new StringBuilder(); strSql.Append("select top(1) s.* from Schedule s where s.ScheduleID in (select o.scheduleid from odds1x2history o where o.scheduleid=s.ScheduleID) and not exists (select b.id from BetExp b where b.id=s.ScheduleID)"); SeoWebSite.Model.Schedule1 model = new SeoWebSite.Model.Schedule1(); DataSet ds = DbHelperSQL.Query(strSql.ToString()); if (ds.Tables[0].Rows.Count > 0) { if (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"].ToString() != "") { model.ScheduleID = int.Parse(ds.Tables[0].Rows[0]["ScheduleID"].ToString()); } model.Data = ds.Tables[0].Rows[0]["Data"].ToString(); if (ds.Tables[0].Rows[0]["Date"].ToString() != "") { model.Date = DateTime.Parse(ds.Tables[0].Rows[0]["Date"].ToString()); } return model; } else { return null; } }
/// <summary> /// �õ�һ������ʵ�� /// </summary> public SeoWebSite.Model.Schedule1 GetModel(int id) { StringBuilder strSql=new StringBuilder(); strSql.Append("select top 1 id,ScheduleID,Data,Date from Schedule "); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int,4)}; parameters[0].Value = id; SeoWebSite.Model.Schedule1 model=new SeoWebSite.Model.Schedule1(); DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { if(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"].ToString()!="") { model.ScheduleID=int.Parse(ds.Tables[0].Rows[0]["ScheduleID"].ToString()); } model.Data=ds.Tables[0].Rows[0]["Data"].ToString(); if(ds.Tables[0].Rows[0]["Date"].ToString()!="") { model.Date=DateTime.Parse(ds.Tables[0].Rows[0]["Date"].ToString()); } return model; } else { return null; } }