public ActionResult Edit(StoreIndustryModel model, int storeIid = -1)
{
StoreIndustryInfo storeIndustryInfo = AdminStoreIndustries.GetStoreIndustryById(storeIid);
if (storeIndustryInfo == null)
{
return(PromptView("店铺行业不存在"));
}
int storeIid2 = AdminStoreIndustries.GetStoreIidByTitle(model.IndustryTitle);
if (storeIid2 > 0 && storeIid2 != storeIid)
{
ModelState.AddModelError("IndustryTitle", "行业标题已经存在");
}
if (ModelState.IsValid)
{
storeIndustryInfo.Title = model.IndustryTitle;
storeIndustryInfo.DisplayOrder = model.DisplayOrder;
AdminStoreIndustries.UpdateStoreIndustry(storeIndustryInfo);
AddMallAdminLog("修改店铺行业", "修改店铺行业,店铺行业ID为:" + storeIid);
return(PromptView("店铺行业修改成功"));
}
ViewData["referer"] = MallUtils.GetMallAdminRefererCookie();
return(View(model));
}
/// <summary>
/// 创建店铺行业
/// </summary>
public void CreateStoreIndustry(StoreIndustryInfo storeIndustryInfo)
{
DbParameter[] param =
{
GenerateInParam("@title", SqlDbType.NChar, 150, storeIndustryInfo.Title),
GenerateInParam("@displayorder", SqlDbType.Int, 4, storeIndustryInfo.DisplayOrder)
};
string commandText = String.Format("INSERT INTO [{0}storeindustries] ([title],[displayorder]) VALUES(@title,@displayorder)",
RDBSHelper.RDBSTablePre);
RDBSHelper.ExecuteNonQuery(CommandType.Text, commandText, param);
}
/// <summary>
/// 更新店铺行业
/// </summary>
public void UpdateStoreIndustry(StoreIndustryInfo storeIndustryInfo)
{
DbParameter[] param =
{
GenerateInParam("@title", SqlDbType.NChar, 150, storeIndustryInfo.Title),
GenerateInParam("@displayorder", SqlDbType.Int, 4, storeIndustryInfo.DisplayOrder),
GenerateInParam("@storeiid", SqlDbType.SmallInt, 2, storeIndustryInfo.StoreIid)
};
string commandText = String.Format("UPDATE [{0}storeindustries] SET [title]=@title,[displayorder]=@displayorder WHERE [storeiid]=@storeiid",
RDBSHelper.RDBSTablePre);
RDBSHelper.ExecuteNonQuery(CommandType.Text, commandText, param);
}
public ActionResult Edit(int storeIid = -1)
{
StoreIndustryInfo storeIndustryInfo = AdminStoreIndustries.GetStoreIndustryById(storeIid);
if (storeIndustryInfo == null)
{
return(PromptView("店铺行业不存在"));
}
StoreIndustryModel model = new StoreIndustryModel();
model.IndustryTitle = storeIndustryInfo.Title;
model.DisplayOrder = storeIndustryInfo.DisplayOrder;
ViewData["referer"] = MallUtils.GetMallAdminRefererCookie();
return(View(model));
}
/// <summary>
/// 删除店铺行业
/// </summary>
/// <param name="storeIid">店铺行业id</param>
/// <returns>-1代表此店铺行业下还有店铺未删除，0代表此店铺行业不存在，1代表删除成功</returns>
public static int DeleteStoreIndustryById(int storeIid)
{
StoreIndustryInfo storeIndustryInfo = GetStoreIndustryById(storeIid);
if (storeIndustryInfo != null)
{
if (AdminStores.GetStoreCountByStoreIid(storeIid) > 0)
{
return(-1);
}
BrnMall.Data.StoreIndustries.DeleteStoreIndustryById(storeIid);
BrnMall.Core.BMACache.Remove(CacheKeys.MALL_STORE_INDUSTRYLIST);
return(1);
}
return(0);
}
/// <summary>
/// 获得店铺行业列表
/// </summary>
public static List <StoreIndustryInfo> GetStoreIndustryList()
{
List <StoreIndustryInfo> storeIndustrylist = new List <StoreIndustryInfo>();
IDataReader reader = NStore.Core.BMAData.RDBS.GetStoreIndustryList();
while (reader.Read())
{
StoreIndustryInfo storeIndustryInfo = new StoreIndustryInfo();
storeIndustryInfo.StoreIid = TypeHelper.ObjectToInt(reader["storeiid"]);
storeIndustryInfo.Title = reader["title"].ToString();
storeIndustryInfo.DisplayOrder = TypeHelper.ObjectToInt(reader["displayorder"]);
storeIndustrylist.Add(storeIndustryInfo);
}
reader.Close();
return(storeIndustrylist);
}
public ActionResult Add(StoreIndustryModel model)
{
if (AdminStoreIndustries.GetStoreIidByTitle(model.IndustryTitle) > 0)
{
ModelState.AddModelError("IndustryTitle", "行业标题已经存在");
}
if (ModelState.IsValid)
{
StoreIndustryInfo storeIndustryInfo = new StoreIndustryInfo()
{
Title = model.IndustryTitle,
DisplayOrder = model.DisplayOrder
};
AdminStoreIndustries.CreateStoreIndustry(storeIndustryInfo);
AddMallAdminLog("添加店铺行业", "添加店铺行业,店铺行业为:" + model.IndustryTitle);
return(PromptView("店铺行业添加成功"));
}
ViewData["referer"] = MallUtils.GetMallAdminRefererCookie();
return(View(model));
}
/// <summary>
/// 更新店铺行业
/// </summary>
public static void UpdateStoreIndustry(StoreIndustryInfo storeIndustryInfo)
{
NStore.Core.BMAData.RDBS.UpdateStoreIndustry(storeIndustryInfo);
}
/// <summary>
/// 更新店铺行业
/// </summary>
public static void UpdateStoreIndustry(StoreIndustryInfo storeIndustryInfo)
{
BrnMall.Data.StoreIndustries.UpdateStoreIndustry(storeIndustryInfo);
BrnMall.Core.BMACache.Remove(CacheKeys.MALL_STORE_INDUSTRYLIST);
}
/// <summary>
/// 创建店铺行业
/// </summary>
public static void CreateStoreIndustry(StoreIndustryInfo storeIndustryInfo)
{
NStore.Data.StoreIndustries.CreateStoreIndustry(storeIndustryInfo);
NStore.Core.BMACache.Remove(CacheKeys.MALL_STORE_INDUSTRYLIST);
}
/// <summary>
/// 创建店铺行业
/// </summary>
public static void CreateStoreIndustry(StoreIndustryInfo storeIndustryInfo)
{
BrnMall.Core.BMAData.RDBS.CreateStoreIndustry(storeIndustryInfo);
}
