public ActionResult EditNewsType(NewsTypeModel model, int newsTypeId = -1)
{
NewsTypeInfo newsTypeInfo = AdminNews.GetNewsTypeById(newsTypeId);
if (newsTypeInfo == null)
{
return(PromptView("新闻类型不存在"));
}
NewsTypeInfo newsTypeInfo2 = AdminNews.GetNewsTypeByName(model.NewsTypeName);
if (newsTypeInfo2 != null && newsTypeInfo2.NewsTypeId != newsTypeId)
{
ModelState.AddModelError("NewsTypeName", "名称已经存在");
}
if (ModelState.IsValid)
{
newsTypeInfo.Name = model.NewsTypeName;
newsTypeInfo.DisplayOrder = model.DisplayOrder;
AdminNews.UpdateNewsType(newsTypeInfo);
AddMallAdminLog("修改新闻类型", "修改新闻类型,新闻类型ID为:" + newsTypeId);
return(PromptView("新闻类型修改成功"));
}
ViewData["referer"] = MallUtils.GetMallAdminRefererCookie();
return(View(model));
}
public List <NewsTypeInfo> GetAll(out int total)
{
List <NewsTypeInfo> list = null;
var t = 0;
SqlParameter[] param =
{
new SqlParameter("@totalrow", DbType.Int32)
{
Direction = ParameterDirection.Output
}
};
SqlCommand comx;
var r = DataHelper.ExecuteReader(Config.ConnectString, "usp_newsType_GetAll", param, out comx);
if (r != null)
{
list = new List <NewsTypeInfo>();
while (r.Read())
{
var info = new NewsTypeInfo();
info.id = Int32.Parse(r["id"].ToString());
info.name = r["name"].ToString();
info.link = r["link"].ToString();
info.sort = int.Parse(r["source"].ToString());
list.Add(info);
}
r.Close();
r.Dispose();
t = int.Parse(comx.Parameters[0].Value.ToString());
}
total = t;
return(list);
}
/// <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 int Add(NewsTypeInfo info)
{
SqlParameter[] param =
{
new SqlParameter("@name", info.name),
new SqlParameter("@link", info.link),
new SqlParameter("@sort", info.sort),
new SqlParameter("@description", info.description),
new SqlParameter("@keyword", info.keyword)
};
return(int.Parse(DataHelper.ExecuteScalar(Config.ConnectString, "usp_newsType_Add", param).ToString()));
}
public int Update(NewsTypeInfo info)
{
SqlParameter[] param =
{
new SqlParameter("@id", info.id),
new SqlParameter("@name", info.name),
new SqlParameter("@link", info.link),
new SqlParameter("@sort", info.sort),
new SqlParameter("@description", info.description),
new SqlParameter("@keyword", info.keyword)
};
return(DataHelper.ExecuteNonQuery(Config.ConnectString, "usp_newsType_Update", param));
}
/// <summary>
/// 获得新闻类型列表
/// </summary>
/// <returns></returns>
public static List <NewsTypeInfo> GetNewsTypeList()
{
List <NewsTypeInfo> newsTypeList = new List <NewsTypeInfo>();
IDataReader reader = BrnMall.Core.BMAData.RDBS.GetNewsTypeList();
while (reader.Read())
{
NewsTypeInfo newsTypeInfo = BuildNewsTypeFromReader(reader);
newsTypeList.Add(newsTypeInfo);
}
reader.Close();
return(newsTypeList);
}
public static List <NewsTypeInfo> GetNewsType()
{
string sql = "select * from newsTypeInfo";
SqlDataReader reader = SQLHelper.ExectueReader(sql, false);
List <NewsTypeInfo> list = new List <NewsTypeInfo>();
while (reader.Read())
{
NewsTypeInfo type = new NewsTypeInfo();
type.typeId = (int)reader["typeId"];
type.typeName = reader["typeName"].ToString();
list.Add(type);
}
return(list);
}
public ActionResult EditNewsType(int newsTypeId = -1)
{
NewsTypeInfo newsTypeInfo = AdminNews.GetNewsTypeById(newsTypeId);
if (newsTypeInfo == null)
{
return(PromptView("新闻类型不存在"));
}
NewsTypeModel model = new NewsTypeModel();
model.NewsTypeName = newsTypeInfo.Name;
model.DisplayOrder = newsTypeInfo.DisplayOrder;
ViewData["referer"] = MallUtils.GetMallAdminRefererCookie();
return(View(model));
}
public NewsTypeInfo GetInfo(int id)
{
NewsTypeInfo info = null;
SqlParameter[] param =
{
new SqlParameter("@id", id)
};
var r = DataHelper.ExecuteReader(Config.ConnectString, "usp_newsType_GetById", param);
if (r != null)
{
info = new NewsTypeInfo();
while (r.Read())
{
if (r["id"] != null && !r["id"].ToString().Equals(""))
{
info.id = Int32.Parse(r["id"].ToString());
}
if (r["name"] != null && !r["name"].ToString().Equals(""))
{
info.name = r["name"].ToString();
}
if (r["link"] != null && !r["link"].ToString().Equals(""))
{
info.link = r["link"].ToString();
}
if (r["sort"] != null && !r["sort"].ToString().Equals(""))
{
info.sort = Convert.ToInt16(r["sort"].ToString());
}
if (r["description"] != null && !r["description"].ToString().Equals(""))
{
info.description = r["description"].ToString();
}
if (r["keyword"] != null && !r["keyword"].ToString().Equals(""))
{
info.keyword = r["keyword"].ToString();
}
}
r.Close();
r.Dispose();
}
return(info);
}
private bool AddNewCate()
{
if (string.IsNullOrEmpty(txtCategoryname.Text) || string.IsNullOrEmpty(txtSort.Text))
{
ltrThongbao.Text = "Cần nhập đủ các trường!";
return(false);
}
var info = new NewsTypeInfo();
info.name = txtCategoryname.Text;
var nextId = UntilityFunction.nextId("tbl_newsType");
info.link = Rewrite.GenCate(info.name, nextId, Rewrite.News);
info.sort = int.Parse(txtSort.Text);
info.description = txtMota.Text;
info.keyword = txtTukhoa.Text;
ServiceFactory.GetInstanceNewsType().Add(info);
return(true);
}
public List <NewsTypeInfo> GetAll()
{
List <NewsTypeInfo> list = null;
var r = DataHelper.ExecuteReader(Config.ConnectString, "tuan_newsType_GetAll", null);
if (r != null)
{
list = new List <NewsTypeInfo>();
while (r.Read())
{
var info = new NewsTypeInfo();
info.id = Int32.Parse(r["id"].ToString());
info.name = r["name"].ToString();
info.link = r["link"].ToString();
info.sort = int.Parse(r["sort"].ToString());
list.Add(info);
}
r.Close();
r.Dispose();
}
return(list);
}
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));
}
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);
AddAdminOperateLog("添加新闻类型", "添加新闻类型,新闻类型为:" + model.NewsTypeName);
return PromptView("新闻类型添加成功");
}
ViewData["referer"] = ShopUtils.GetAdminRefererCookie();
return View(model);
}
/// <summary>
/// 创建新闻类型
/// </summary>
public static void CreateNewsType(NewsTypeInfo newsTypeInfo)
{
OWZX.Data.News.CreateNewsType(newsTypeInfo);
OWZX.Core.BSPCache.Remove(CacheKeys.SHOP_NEWSTYPE_LIST);
OWZX.Core.BSPCache.Remove(CacheKeys.SHOP_NEWS_HOMELIST + "\\d+");
}
/// <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;
}
/// <summary>
/// 创建新闻类型
/// </summary>
public static void CreateNewsType(NewsTypeInfo newsTypeInfo)
{
BrnShop.Data.News.CreateNewsType(newsTypeInfo);
BrnShop.Core.BSPCache.Remove(CacheKeys.SHOP_NEWSTYPE_LIST);
BrnShop.Core.BSPCache.Remove(CacheKeys.SHOP_NEWS_HOMELIST + "\\d+");
}
/// <summary>
/// 更新新闻类型
/// </summary>
public static void UpdateNewsType(NewsTypeInfo newsTypeInfo)
{
BrnShop.Core.BSPData.RDBS.UpdateNewsType(newsTypeInfo);
}
/// <summary>
/// 更新新闻类型
/// </summary>
public static void UpdateNewsType(NewsTypeInfo newsTypeInfo)
{
BrnMall.Core.BMAData.RDBS.UpdateNewsType(newsTypeInfo);
}
/// <summary>
/// 更新新闻类型
/// </summary>
public static void UpdateNewsType(NewsTypeInfo newsTypeInfo)
{
BrnShop.Data.News.UpdateNewsType(newsTypeInfo);
BrnShop.Core.BSPCache.Remove(CacheKeys.SHOP_NEWSTYPE_LIST);
BrnShop.Core.BSPCache.Remove(CacheKeys.SHOP_NEWS_HOMELIST + "\\d+");
}
/// <summary>
/// 创建新闻类型
/// </summary>
public static void CreateNewsType(NewsTypeInfo newsTypeInfo)
{
BrnShop.Core.BSPData.RDBS.CreateNewsType(newsTypeInfo);
}
/// <summary>
/// 创建新闻类型
/// </summary>
public static void CreateNewsType(NewsTypeInfo newsTypeInfo)
{
NStore.Core.BMAData.RDBS.CreateNewsType(newsTypeInfo);
}
/// <summary>
/// 更新新闻类型
/// </summary>
public static void UpdateNewsType(NewsTypeInfo newsTypeInfo)
{
OWZX.Core.BSPData.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+");
}
/// <summary>
/// 创建新闻类型
/// </summary>
public static void CreateNewsType(NewsTypeInfo newsTypeInfo)
{
NStore.Data.News.CreateNewsType(newsTypeInfo);
NStore.Core.BMACache.Remove(CacheKeys.MALL_NEWSTYPE_LIST);
NStore.Core.BMACache.Remove(CacheKeys.MALL_NEWS_HOMELIST + "\\d+");
}
/// <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);
}
