public int UpdateSiteDynamic(SiteDynamicInfo siteDynamic) { SqlHelper objSqlHelper = new SqlHelper(); SqlParameter[] objParams = new SqlParameter[4]; objParams[0] = new SqlParameter("@dynamicID", siteDynamic.DynamicID); objParams[1] = new SqlParameter("@dynamicTitle", siteDynamic.DynamicTitle); objParams[2] = new SqlParameter("@titleCss", siteDynamic.DynamicCss); objParams[3] = new SqlParameter("@dynamicContent", siteDynamic.DynamicContent); return objSqlHelper.ExecuteNonQuery("je_Dy_UpdateSiteDynamic", objParams); }
public void InsertSiteDynamic(SiteDynamicInfo siteDynamic) { SqlHelper objSqlHelper = new SqlHelper(); SqlParameter[] objParams = new SqlParameter[4]; objParams[0] = new SqlParameter("@dynamicTitle", siteDynamic.DynamicTitle); objParams[1] = new SqlParameter("@titleCss", siteDynamic.DynamicCss); objParams[2] = new SqlParameter("@dynamicContent", siteDynamic.DynamicContent); objParams[3] = new SqlParameter("@addDate", DateTime.Now); objSqlHelper.ExecuteNonQuery("je_Dy_InsertSiteDynamic", objParams); }
public SiteDynamicInfo GetSiteDynamicByID(int siteDynamicID) { SqlHelper objSqlHelper = new SqlHelper(); SqlParameter[] objParams = new SqlParameter[1]; objParams[0] = new SqlParameter("@dynamicID", SqlDbType.Int, 4); objParams[0].Value = siteDynamicID; SqlDataReader reader = objSqlHelper.ExecuteReader("je_Dy_GetSiteDynamicByID", objParams); SiteDynamicInfo item = new SiteDynamicInfo(); while (reader.Read()) { item.DynamicID = reader.GetInt32(reader.GetOrdinal("dynamicID")); item.DynamicTitle = reader.GetString(reader.GetOrdinal("dynamicTitle")); item.DynamicContent = reader.GetString(reader.GetOrdinal("dynamicContent")); item.ReadCount = reader.GetInt32(reader.GetOrdinal("ReadCount")); item.DynamicCss = reader.GetString(reader.GetOrdinal("titleCss")); item.AddDate = reader.GetDateTime(reader.GetOrdinal("addDate")); } reader.Close(); return item; }
public IList<SiteDynamicInfo> GetSiteDynamic(SiteDynamicType sdType) { SqlHelper objSqlHelper = new SqlHelper(); List<SiteDynamicInfo> dynamics = new List<SiteDynamicInfo>(); SqlParameter[] objParams = new SqlParameter[1]; objParams[0] = new SqlParameter("@sdType", SqlDbType.Int, 4); objParams[0].Value = (int)sdType; SqlDataReader reader = objSqlHelper.ExecuteReader("je_Dy_GetSiteDynamic", objParams); while (reader.Read()) { SiteDynamicInfo item = new SiteDynamicInfo(); item.DynamicID = reader.GetInt32(reader.GetOrdinal("dynamicID")); item.DynamicTitle = reader.GetString(reader.GetOrdinal("dynamicTitle")); item.DynamicContent = reader.GetString(reader.GetOrdinal("dynamicContent")); item.DynamicCss = reader.GetString(reader.GetOrdinal("titleCss")); item.AddDate = reader.GetDateTime(reader.GetOrdinal("addDate")); dynamics.Add(item); } reader.Close(); return dynamics; }
/// <summary> /// 更新标题样式信息 /// </summary> /// <param name="link"></param> /// <returns></returns> public static int UpdateSiteDynamic(SiteDynamicInfo siteDynamic) { return sd.UpdateSiteDynamic(siteDynamic); }
/// <summary> /// 添加标题样式信息 /// </summary> /// <param name="link"></param> public static void InsertSiteDynamic(SiteDynamicInfo siteDynamic) { sd.InsertSiteDynamic(siteDynamic); }