/// <summary> /// 得到一个对象实体 /// </summary> public Entity.BASE_EVENT GetEntity(int EventID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select EventID, EventName, Summary, Score, EventIDParent, Enable, Sort "); strSql.Append(" from Base_Event "); strSql.Append(" where EventID=@EventID"); SqlParameter[] parameters = { new SqlParameter("@EventID", SqlDbType.Int, 4) }; parameters[0].Value = EventID; Entity.BASE_EVENT entity = new Entity.BASE_EVENT(); DataSet ds = SqlServerHelper.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["EventID"].ToString() != "") { entity.EventID = int.Parse(ds.Tables[0].Rows[0]["EventID"].ToString()); } entity.EventName = ds.Tables[0].Rows[0]["EventName"].ToString(); entity.Summary = ds.Tables[0].Rows[0]["Summary"].ToString(); if (ds.Tables[0].Rows[0]["Score"].ToString() != "") { entity.Score = int.Parse(ds.Tables[0].Rows[0]["Score"].ToString()); } if (ds.Tables[0].Rows[0]["EventIDParent"].ToString() != "") { entity.EventIDParent = int.Parse(ds.Tables[0].Rows[0]["EventIDParent"].ToString()); } if (ds.Tables[0].Rows[0]["Enable"].ToString() != "") { entity.Enable = int.Parse(ds.Tables[0].Rows[0]["Enable"].ToString()); } if (ds.Tables[0].Rows[0]["Sort"].ToString() != "") { entity.Sort = int.Parse(ds.Tables[0].Rows[0]["Sort"].ToString()); } return(entity); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Entity.BASE_EVENT entity) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Base_Event set "); strSql.Append(" EventName = @EventName , "); strSql.Append(" Summary = @Summary , "); strSql.Append(" Score = @Score , "); strSql.Append(" EventIDParent = @EventIDParent , "); strSql.Append(" Enable = @Enable , "); strSql.Append(" Sort = @Sort "); strSql.Append(" where EventID=@EventID "); SqlParameter[] parameters = { new SqlParameter("@EventID", SqlDbType.Int, 4), new SqlParameter("@EventName", SqlDbType.VarChar, 50), new SqlParameter("@Summary", SqlDbType.VarChar, 50), new SqlParameter("@Score", SqlDbType.Int, 4), new SqlParameter("@EventIDParent", SqlDbType.Int, 4), new SqlParameter("@Enable", SqlDbType.Int, 4), new SqlParameter("@Sort", SqlDbType.Int, 4) }; parameters[6].Value = entity.EventID; parameters[7].Value = entity.EventName; parameters[8].Value = entity.Summary; parameters[9].Value = entity.Score; parameters[10].Value = entity.EventIDParent; parameters[11].Value = entity.Enable; parameters[12].Value = entity.Sort; int rows = SqlServerHelper.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Entity.BASE_EVENT entity) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Base_Event("); strSql.Append("EventName,Summary,Score,EventIDParent,Enable,Sort"); strSql.Append(") values ("); strSql.Append("@EventName,@Summary,@Score,@EventIDParent,@Enable,@Sort"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@EventName", SqlDbType.VarChar, 50), new SqlParameter("@Summary", SqlDbType.VarChar, 50), new SqlParameter("@Score", SqlDbType.Int, 4), new SqlParameter("@EventIDParent", SqlDbType.Int, 4), new SqlParameter("@Enable", SqlDbType.Int, 4), new SqlParameter("@Sort", SqlDbType.Int, 4) }; parameters[0].Value = entity.EventName; parameters[1].Value = entity.Summary; parameters[2].Value = entity.Score; parameters[3].Value = entity.EventIDParent; parameters[4].Value = entity.Enable; parameters[5].Value = entity.Sort; object obj = SqlServerHelper.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }