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);
}
