/// <summary>
/// 通过IDataReader创建NewsTypeInfo
/// </summary>
public static NewsTypeInfo BuildNewsTypeFromReader(IDataReader reader)
{
NewsTypeInfo newsTypeInfo = new NewsTypeInfo();
newsTypeInfo.NewsTypeId = TypeHelper.ObjectToInt(reader["newstypeid"]);
newsTypeInfo.Name = reader["name"].ToString();
newsTypeInfo.DisplayOrder = TypeHelper.ObjectToInt(reader["displayorder"]);
return newsTypeInfo;
}
public ActionResult AddNewsType(NewsTypeModel model)
{
if (AdminNews.GetNewsTypeByName(model.NewsTypeName) != null)
ModelState.AddModelError("NewsTypeName", "名称已经存在");
if (ModelState.IsValid)
{
NewsTypeInfo newsTypeInfo = new NewsTypeInfo()
{
Name = model.NewsTypeName,
DisplayOrder = model.DisplayOrder
};
AdminNews.CreateNewsType(newsTypeInfo);
AddMallAdminLog("添加新闻类型", "添加新闻类型,新闻类型为:" + model.NewsTypeName);
return PromptView("新闻类型添加成功");
}
ViewData["referer"] = MallUtils.GetMallAdminRefererCookie();
return View(model);
}
/// <summary>
/// 更新新闻类型
/// </summary>
public void UpdateNewsType(NewsTypeInfo newsTypeInfo)
{
DbParameter[] parms = {
GenerateInParam("@name", SqlDbType.NChar, 60, newsTypeInfo.Name),
GenerateInParam("@displayorder", SqlDbType.Int,4,newsTypeInfo.DisplayOrder),
GenerateInParam("@newstypeid", SqlDbType.SmallInt,2,newsTypeInfo.NewsTypeId)
};
string commandText = string.Format("UPDATE [{0}newstypes] SET [name]=@name,[displayorder]=@displayorder WHERE [newstypeid]=@newstypeid",
RDBSHelper.RDBSTablePre);
RDBSHelper.ExecuteNonQuery(CommandType.Text, commandText, parms);
}
/// <summary>
/// 创建新闻类型
/// </summary>
public void CreateNewsType(NewsTypeInfo newsTypeInfo)
{
DbParameter[] parms = {
GenerateInParam("@name", SqlDbType.NChar, 60, newsTypeInfo.Name),
GenerateInParam("@displayorder", SqlDbType.Int,4,newsTypeInfo.DisplayOrder)
};
string commandText = string.Format("INSERT INTO [{0}newstypes]([name],[displayorder]) VALUES(@name,@displayorder)",
RDBSHelper.RDBSTablePre);
RDBSHelper.ExecuteNonQuery(CommandType.Text, commandText, parms);
}
/// <summary>
/// 更新新闻类型
/// </summary>
public static void UpdateNewsType(NewsTypeInfo newsTypeInfo)
{
BrnMall.Core.BMAData.RDBS.UpdateNewsType(newsTypeInfo);
}
/// <summary>
/// 更新新闻类型
/// </summary>
public static void UpdateNewsType(NewsTypeInfo newsTypeInfo)
{
BrnMall.Data.News.UpdateNewsType(newsTypeInfo);
BrnMall.Core.BMACache.Remove(CacheKeys.MALL_NEWSTYPE_LIST);
BrnMall.Core.BMACache.Remove(CacheKeys.MALL_NEWS_HOMELIST + "\\d+");
}
