/// <summary> /// 从IDataReader创建TopicInfo /// </summary> public static TopicInfo BuildTopicFromReader(IDataReader reader) { TopicInfo topicInfo = new TopicInfo(); topicInfo.TopicId = TypeHelper.ObjectToInt(reader["topicid"]); topicInfo.StartTime = TypeHelper.ObjectToDateTime(reader["starttime"]); topicInfo.EndTime = TypeHelper.ObjectToDateTime(reader["endtime"]); topicInfo.IsShow = TypeHelper.ObjectToInt(reader["isshow"]); topicInfo.SN = reader["sn"].ToString(); topicInfo.Title = reader["title"].ToString(); topicInfo.HeadHtml = reader["headhtml"].ToString(); topicInfo.BodyHtml = reader["bodyhtml"].ToString(); return topicInfo; }
public ActionResult Add(TopicModel model) { if (ModelState.IsValid) { string sn = AdminTopic.GenerateTopicSN(); TopicInfo topicInfo = new TopicInfo() { StartTime = model.StartTime, EndTime = model.EndTime, SN = sn, Title = model.Title, HeadHtml = model.HeadHtml ?? "", BodyHtml = model.BodyHtml ?? "", IsShow = model.IsShow }; AdminTopic.CreateTopic(topicInfo); AddMallAdminLog("添加活动专题", "添加活动专题,活动专题为:" + model.Title); return PromptView("活动专题添加成功"); } ViewData["referer"] = MallUtils.GetMallAdminRefererCookie(); return View(model); }
/// <summary> /// 更新活动专题 /// </summary> /// <param name="topicInfo">活动专题信息</param> public static void UpdateTopic(TopicInfo topicInfo) { BrnMall.Data.Topics.UpdateTopic(topicInfo); BrnMall.Core.BMACache.Remove(CacheKeys.MALL_TOPIC_INFO + topicInfo.TopicId); BrnMall.Core.BMACache.Remove(CacheKeys.MALL_TOPIC_INFO + topicInfo.SN); }
/// <summary> /// 创建活动专题 /// </summary> /// <param name="topicInfo">活动专题信息</param> public static void CreateTopic(TopicInfo topicInfo) { BrnMall.Data.Topics.CreateTopic(topicInfo); }
/// <summary> /// 更新活动专题 /// </summary> /// <param name="topicInfo">活动专题信息</param> public void UpdateTopic(TopicInfo topicInfo) { DbParameter[] parms = { GenerateInParam("@starttime", SqlDbType.DateTime, 8, topicInfo.StartTime), GenerateInParam("@endtime", SqlDbType.DateTime,8,topicInfo.EndTime), GenerateInParam("@isshow", SqlDbType.TinyInt,1,topicInfo.IsShow), GenerateInParam("@sn", SqlDbType.Char,16,topicInfo.SN), GenerateInParam("@title", SqlDbType.NVarChar,100,topicInfo.Title), GenerateInParam("@headhtml", SqlDbType.NText,0,topicInfo.HeadHtml), GenerateInParam("@bodyhtml", SqlDbType.NText,0,topicInfo.BodyHtml), GenerateInParam("@topicid", SqlDbType.Int,4,topicInfo.TopicId) }; string commandText = string.Format("UPDATE [{0}topics] SET [starttime]=@starttime,[endtime]=@endtime,[isshow]=@isshow,[sn]=@sn,[title]=@title,[headhtml]=@headhtml,[bodyhtml]=@bodyhtml WHERE [topicid]=@topicid", RDBSHelper.RDBSTablePre); RDBSHelper.ExecuteNonQuery(CommandType.Text, commandText, parms); }
/// <summary> /// 创建活动专题 /// </summary> /// <param name="topicInfo">活动专题信息</param> public void CreateTopic(TopicInfo topicInfo) { DbParameter[] parms = { GenerateInParam("@starttime", SqlDbType.DateTime, 8, topicInfo.StartTime), GenerateInParam("@endtime", SqlDbType.DateTime,8,topicInfo.EndTime), GenerateInParam("@isshow", SqlDbType.TinyInt,1,topicInfo.IsShow), GenerateInParam("@sn", SqlDbType.Char,16,topicInfo.SN), GenerateInParam("@title", SqlDbType.NVarChar,100,topicInfo.Title), GenerateInParam("@headhtml", SqlDbType.NText,0,topicInfo.HeadHtml), GenerateInParam("@bodyhtml", SqlDbType.NText,0,topicInfo.BodyHtml) }; string commandText = string.Format("INSERT INTO [{0}topics]([starttime],[endtime],[isshow],[sn],[title],[headhtml],[bodyhtml]) VALUES(@starttime,@endtime,@isshow,@sn,@title,@headhtml,@bodyhtml)", RDBSHelper.RDBSTablePre); RDBSHelper.ExecuteNonQuery(CommandType.Text, commandText, parms); }
/// <summary> /// 更新活动专题 /// </summary> /// <param name="topicInfo">活动专题信息</param> public static void UpdateTopic(TopicInfo topicInfo) { BrnMall.Core.BMAData.RDBS.UpdateTopic(topicInfo); }