public ActionResult Add(StoreRankModel model) { if (AdminStoreRanks.GetStoreRidByTitle(model.RankTitle) > 0) { ModelState.AddModelError("RankTitle", "名称已经存在"); } if (ModelState.IsValid) { StoreRankInfo storeRankInfo = new StoreRankInfo() { Title = model.RankTitle, Avatar = model.Avatar ?? "", HonestiesLower = model.HonestiesLower, HonestiesUpper = model.HonestiesUpper, ProductCount = model.ProductCount }; AdminStoreRanks.CreateStoreRank(storeRankInfo); AddMallAdminLog("添加店铺等级", "添加店铺等级,店铺等级为:" + model.RankTitle); return(PromptView("店铺等级添加成功")); } Load(); return(View(model)); }
public ActionResult Edit(StoreRankModel model, int storeRid = -1) { StoreRankInfo storeRankInfo = AdminStoreRanks.GetStoreRankById(storeRid); if (storeRankInfo == null) { return(PromptView("店铺等级不存在")); } int storeRid2 = AdminStoreRanks.GetStoreRidByTitle(model.RankTitle); if (storeRid2 > 0 && storeRid2 != storeRid) { ModelState.AddModelError("RankTitle", "名称已经存在"); } if (ModelState.IsValid) { storeRankInfo.Title = model.RankTitle; storeRankInfo.Avatar = model.Avatar ?? ""; storeRankInfo.HonestiesLower = model.HonestiesLower; storeRankInfo.HonestiesUpper = model.HonestiesUpper; storeRankInfo.ProductCount = model.ProductCount; AdminStoreRanks.UpdateStoreRank(storeRankInfo); AddMallAdminLog("修改店铺等级", "修改店铺等级,店铺等级ID为:" + storeRid); return(PromptView("店铺等级修改成功")); } Load(); return(View(model)); }
/// <summary> /// 创建店铺等级 /// </summary> public void CreateStoreRank(StoreRankInfo storeRankInfo) { DbParameter[] parms = { GenerateInParam("@title", SqlDbType.NChar, 50, storeRankInfo.Title), GenerateInParam("@avatar", SqlDbType.Char, 50, storeRankInfo.Avatar), GenerateInParam("@honestieslower", SqlDbType.Int, 4, storeRankInfo.HonestiesLower), GenerateInParam("@honestiesupper", SqlDbType.Int, 4, storeRankInfo.HonestiesUpper), GenerateInParam("@productcount", SqlDbType.Int, 4, storeRankInfo.ProductCount) }; string commandText = string.Format("INSERT INTO [{0}storeranks]([title],[avatar],[honestieslower],[honestiesupper],[productcount]) VALUES(@title,@avatar,@honestieslower,@honestiesupper,@productcount)", RDBSHelper.RDBSTablePre); RDBSHelper.ExecuteNonQuery(CommandType.Text, commandText, parms); }
/// <summary> /// 更新店铺等级 /// </summary> public void UpdateStoreRank(StoreRankInfo storeRankInfo) { DbParameter[] parms = { GenerateInParam("@title", SqlDbType.NChar, 50, storeRankInfo.Title), GenerateInParam("@avatar", SqlDbType.Char, 50, storeRankInfo.Avatar), GenerateInParam("@honestieslower", SqlDbType.Int, 4, storeRankInfo.HonestiesLower), GenerateInParam("@honestiesupper", SqlDbType.Int, 4, storeRankInfo.HonestiesUpper), GenerateInParam("@productcount", SqlDbType.Int, 4, storeRankInfo.ProductCount), GenerateInParam("@storerid", SqlDbType.SmallInt, 2, storeRankInfo.StoreRid) }; string commandText = string.Format("UPDATE [{0}storeranks] SET [title]=@title,[avatar]=@avatar,[honestieslower]=@honestieslower,[honestiesupper]=@honestiesupper,[productcount]=@productcount WHERE [storerid]=@storerid", RDBSHelper.RDBSTablePre); RDBSHelper.ExecuteNonQuery(CommandType.Text, commandText, parms); }
/// <summary> /// 删除店铺等级 /// </summary> /// <param name="storeRid">店铺等级id</param> /// <returns>-1代表此等级下还有店铺未删除,0代表此店铺等级不存在,1代表删除成功</returns> public static int DeleteStoreRankById(int storeRid) { StoreRankInfo storeRankInfo = GetStoreRankById(storeRid); if (storeRankInfo != null) { if (AdminStores.GetStoreCountByStoreRid(storeRid) > 0) { return(-1); } NStore.Data.StoreRanks.DeleteStoreRankById(storeRid); NStore.Core.BMACache.Remove(CacheKeys.MALL_STORE_RANKLIST); return(1); } return(0); }
/// <summary> /// 获得店铺等级列表 /// </summary> /// <returns></returns> public static List <StoreRankInfo> GetStoreRankList() { List <StoreRankInfo> storeRankList = new List <StoreRankInfo>(); IDataReader reader = NStore.Core.BMAData.RDBS.GetStoreRankList(); while (reader.Read()) { StoreRankInfo storeRankInfo = new StoreRankInfo(); storeRankInfo.StoreRid = TypeHelper.ObjectToInt(reader["storerid"]); storeRankInfo.Title = reader["title"].ToString(); storeRankInfo.Avatar = reader["avatar"].ToString(); storeRankInfo.HonestiesLower = TypeHelper.ObjectToInt(reader["honestieslower"]); storeRankInfo.HonestiesUpper = TypeHelper.ObjectToInt(reader["honestiesupper"]); storeRankInfo.ProductCount = TypeHelper.ObjectToInt(reader["productcount"]); storeRankList.Add(storeRankInfo); } reader.Close(); return(storeRankList); }
public ActionResult Edit(int storeRid = -1) { StoreRankInfo storeRankInfo = AdminStoreRanks.GetStoreRankById(storeRid); if (storeRankInfo == null) { return(PromptView("店铺等级不存在")); } StoreRankModel model = new StoreRankModel(); model.RankTitle = storeRankInfo.Title; model.Avatar = storeRankInfo.Avatar; model.HonestiesLower = storeRankInfo.HonestiesLower; model.HonestiesUpper = storeRankInfo.HonestiesUpper; model.ProductCount = storeRankInfo.ProductCount; Load(); return(View(model)); }
/// <summary> /// 更新店铺等级 /// </summary> public static void UpdateStoreRank(StoreRankInfo storeRankInfo) { NStore.Data.StoreRanks.UpdateStoreRank(storeRankInfo); NStore.Core.BMACache.Remove(CacheKeys.MALL_STORE_RANKLIST); }
/// <summary> /// 更新店铺等级 /// </summary> public static void UpdateStoreRank(StoreRankInfo storeRankInfo) { NStore.Core.BMAData.RDBS.UpdateStoreRank(storeRankInfo); }
/// <summary> /// 创建店铺等级 /// </summary> public static void CreateStoreRank(StoreRankInfo storeRankInfo) { BrnMall.Data.StoreRanks.CreateStoreRank(storeRankInfo); BrnMall.Core.BMACache.Remove(CacheKeys.MALL_STORE_RANKLIST); }
/// <summary> /// 创建店铺等级 /// </summary> public static void CreateStoreRank(StoreRankInfo storeRankInfo) { BrnMall.Core.BMAData.RDBS.CreateStoreRank(storeRankInfo); }