/// <summary>
/// 获得商城管理员组列表
/// </summary>
/// <returns></returns>
public static MallAdminGroupInfo[] GetMallAdminGroupList()
{
DataTable dt = BrnMall.Core.BMAData.RDBS.GetMallAdminGroupList();
MallAdminGroupInfo[] mallAdminGroupList = new MallAdminGroupInfo[dt.Rows.Count];
int index = 0;
foreach (DataRow dr in dt.Rows)
{
MallAdminGroupInfo mallAdminGroupInfo = new MallAdminGroupInfo();
mallAdminGroupInfo.MallAGid = TypeHelper.ObjectToInt(dr["mallagid"]);
mallAdminGroupInfo.Title = dr["title"].ToString();
mallAdminGroupInfo.ActionList = dr["actionlist"].ToString();
mallAdminGroupList[index] = mallAdminGroupInfo;
index++;
}
return mallAdminGroupList;
}
public ActionResult Add(MallAdminGroupModel model)
{
if (MallAdminGroups.GetMallAdminGroupIdByTitle(model.AdminGroupTitle) > 0)
ModelState.AddModelError("AdminGroupTitle", "名称已经存在");
if (ModelState.IsValid)
{
MallAdminGroupInfo mallAdminGroupInfo = new MallAdminGroupInfo()
{
Title = model.AdminGroupTitle,
ActionList = CommonHelper.StringArrayToString(model.ActionList).ToLower()
};
MallAdminGroups.CreateMallAdminGroup(mallAdminGroupInfo);
AddMallAdminLog("添加商城管理员组", "添加商城管理员组,商城管理员组为:" + model.AdminGroupTitle);
return PromptView("商城管理员组添加成功");
}
Load();
return View(model);
}
/// <summary>
/// 更新商城管理员组
/// </summary>
public void UpdateMallAdminGroup(MallAdminGroupInfo mallAdminGroupInfo)
{
DbParameter[] parms = {
GenerateInParam("@title", SqlDbType.NChar,50,mallAdminGroupInfo.Title),
GenerateInParam("@actionlist", SqlDbType.Text, 0, mallAdminGroupInfo.ActionList),
GenerateInParam("@mallagid", SqlDbType.SmallInt, 2, mallAdminGroupInfo.MallAGid)
};
string commandText = string.Format("UPDATE [{0}malladmingroups] SET [title]=@title,[actionlist]=@actionlist WHERE [mallagid]=@mallagid",
RDBSHelper.RDBSTablePre);
RDBSHelper.ExecuteNonQuery(CommandType.Text, commandText, parms);
}
/// <summary>
/// 创建商城管理员组
/// </summary>
/// <param name="mallAdminGroupInfo">商城管理员组信息</param>
/// <returns></returns>
public int CreateMallAdminGroup(MallAdminGroupInfo mallAdminGroupInfo)
{
DbParameter[] parms = {
GenerateInParam("@title", SqlDbType.NChar,50,mallAdminGroupInfo.Title),
GenerateInParam("@actionlist", SqlDbType.Text, 0, mallAdminGroupInfo.ActionList)
};
string commandText = string.Format("INSERT INTO [{0}malladmingroups]([title],[actionlist]) VALUES(@title,@actionlist);SELECT SCOPE_IDENTITY();",
RDBSHelper.RDBSTablePre);
return TypeHelper.ObjectToInt(RDBSHelper.ExecuteScalar(CommandType.Text, commandText, parms));
}
/// <summary>
/// 更新商城管理员组
/// </summary>
public static void UpdateMallAdminGroup(MallAdminGroupInfo mallAdminGroupInfo)
{
BrnMall.Core.BMAData.RDBS.UpdateMallAdminGroup(mallAdminGroupInfo);
}
/// <summary>
/// 创建商城管理员组
/// </summary>
/// <param name="mallAdminGroupInfo">商城管理员组信息</param>
/// <returns></returns>
public static int CreateMallAdminGroup(MallAdminGroupInfo mallAdminGroupInfo)
{
return BrnMall.Core.BMAData.RDBS.CreateMallAdminGroup(mallAdminGroupInfo);
}
/// <summary>
/// 获得用户级商城管理员组列表
/// </summary>
/// <returns></returns>
public static MallAdminGroupInfo[] GetCustomerMallAdminGroupList()
{
MallAdminGroupInfo[] mallAdminGroupList = GetMallAdminGroupList();
MallAdminGroupInfo[] customerMallAdminGroupList = new MallAdminGroupInfo[mallAdminGroupList.Length - 2];
int i = 0;
foreach (MallAdminGroupInfo mallAdminGroupInfo in mallAdminGroupList)
{
if (mallAdminGroupInfo.MallAGid > 2)
{
customerMallAdminGroupList[i] = mallAdminGroupInfo;
i++;
}
}
return customerMallAdminGroupList;
}
/// <summary>
/// 将商城管理员组的导航菜单栏缓存写入到文件中
/// </summary>
private static void WriteMallAdminNavMenuCache(MallAdminGroupInfo mallAdminGroupInfo)
{
HashSet<string> mallAdminGroupActionHashSet = new HashSet<string>();
string[] actionList = StringHelper.SplitString(mallAdminGroupInfo.ActionList);//将后台操作列表字符串分隔成后台操作列表
foreach (string action in actionList)
{
mallAdminGroupActionHashSet.Add(action);
}
bool flag = false;
StringBuilder menu = new StringBuilder();
StringBuilder menuList = new StringBuilder("var menuList = [");
#region 商品管理
menu.AppendFormat("{0}\"title\":\"商品管理\",\"subMenuList\":[", "{");
if (mallAdminGroupActionHashSet.Contains("product"))
{
menu.AppendFormat("{0}\"title\":\"添加商品\",\"url\":\"/malladmin/product/addproduct\"{1},", "{", "}");
menu.AppendFormat("{0}\"title\":\"添加SKU\",\"url\":\"/malladmin/product/addsku\"{1},", "{", "}");
menu.AppendFormat("{0}\"title\":\"在售商品\",\"url\":\"/malladmin/product/onsaleproductlist\"{1},", "{", "}");
menu.AppendFormat("{0}\"title\":\"下架商品\",\"url\":\"/malladmin/product/outsaleproductlist\"{1},", "{", "}");
menu.AppendFormat("{0}\"title\":\"定时商品\",\"url\":\"/malladmin/product/timeproductlist\"{1},", "{", "}");
menu.AppendFormat("{0}\"title\":\"回收站\",\"url\":\"/malladmin/product/recyclebinproductlist\"{1},", "{", "}");
flag = true;
}
if (flag)
{
menu.Remove(menu.Length - 1, 1);
menu.Append("]},");
menuList.Append(menu.ToString());
}
#endregion
#region 促销活动
flag = false;
menu = menu.Clear();
menu.AppendFormat("{0}\"title\":\"促销活动\",\"subMenuList\":[", "{");
if (mallAdminGroupActionHashSet.Contains("promotion"))
{
menu.AppendFormat("{0}\"title\":\"单品促销\",\"url\":\"/malladmin/promotion/singlepromotionlist\"{1},", "{", "}");
menu.AppendFormat("{0}\"title\":\"买送促销\",\"url\":\"/malladmin/promotion/buysendpromotionlist\"{1},", "{", "}");
menu.AppendFormat("{0}\"title\":\"赠品促销\",\"url\":\"/malladmin/promotion/giftpromotionlist\"{1},", "{", "}");
menu.AppendFormat("{0}\"title\":\"套装促销\",\"url\":\"/malladmin/promotion/suitpromotionlist\"{1},", "{", "}");
menu.AppendFormat("{0}\"title\":\"满赠促销\",\"url\":\"/malladmin/promotion/fullsendpromotionlist\"{1},", "{", "}");
menu.AppendFormat("{0}\"title\":\"满减促销\",\"url\":\"/malladmin/promotion/fullcutpromotionlist\"{1},", "{", "}");
flag = true;
}
if (mallAdminGroupActionHashSet.Contains("topic"))
{
menu.AppendFormat("{0}\"title\":\"专题管理\",\"url\":\"/malladmin/topic/list\"{1},", "{", "}");
flag = true;
}
if (mallAdminGroupActionHashSet.Contains("coupon"))
{
menu.AppendFormat("{0}\"title\":\"优惠劵\",\"url\":\"/malladmin/coupon/coupontypelist\"{1},", "{", "}");
flag = true;
}
if (flag)
{
menu.Remove(menu.Length - 1, 1);
menu.Append("]},");
menuList.Append(menu.ToString());
}
#endregion
#region 订单管理
flag = false;
menu = menu.Clear();
menu.AppendFormat("{0}\"title\":\"订单管理\",\"subMenuList\":[", "{");
if (mallAdminGroupActionHashSet.Contains("order"))
{
menu.AppendFormat("{0}\"title\":\"订单列表\",\"url\":\"/malladmin/order/orderlist\"{1},", "{", "}");
menu.AppendFormat("{0}\"title\":\"退款列表\",\"url\":\"/malladmin/order/refundlist\"{1},", "{", "}");
flag = true;
}
if (flag)
{
menu.Remove(menu.Length - 1, 1);
menu.Append("]},");
menuList.Append(menu.ToString());
}
#endregion
#region 咨询评价
flag = false;
menu = menu.Clear();
menu.AppendFormat("{0}\"title\":\"咨询评价\",\"subMenuList\":[", "{");
if (mallAdminGroupActionHashSet.Contains("productreview"))
{
menu.AppendFormat("{0}\"title\":\"商品评价\",\"url\":\"/malladmin/productreview/productreviewlist\"{1},", "{", "}");
flag = true;
}
if (mallAdminGroupActionHashSet.Contains("productconsult"))
{
menu.AppendFormat("{0}\"title\":\"商品咨询\",\"url\":\"/malladmin/productconsult/productconsultlist\"{1},", "{", "}");
menu.AppendFormat("{0}\"title\":\"咨询类型\",\"url\":\"/malladmin/productconsult/productconsulttypelist\"{1},", "{", "}");
flag = true;
}
if (flag)
{
menu.Remove(menu.Length - 1, 1);
menu.Append("]},");
menuList.Append(menu.ToString());
}
#endregion
#region 用户管理
flag = false;
menu = menu.Clear();
menu.AppendFormat("{0}\"title\":\"用户管理\",\"subMenuList\":[", "{");
if (mallAdminGroupActionHashSet.Contains("user"))
{
menu.AppendFormat("{0}\"title\":\"用户列表\",\"url\":\"/malladmin/user/list\"{1},", "{", "}");
flag = true;
}
if (mallAdminGroupActionHashSet.Contains("userrank"))
{
menu.AppendFormat("{0}\"title\":\"会员等级\",\"url\":\"/malladmin/userrank/list\"{1},", "{", "}");
flag = true;
}
if (mallAdminGroupActionHashSet.Contains("malladmingroup"))
{
menu.AppendFormat("{0}\"title\":\"管理员组\",\"url\":\"/malladmin/malladmingroup/list\"{1},", "{", "}");
flag = true;
}
if (flag)
{
menu.Remove(menu.Length - 1, 1);
menu.Append("]},");
menuList.Append(menu.ToString());
}
#endregion
#region 店铺管理
flag = false;
menu = menu.Clear();
menu.AppendFormat("{0}\"title\":\"店铺管理\",\"subMenuList\":[", "{");
if (mallAdminGroupActionHashSet.Contains("store"))
{
menu.AppendFormat("{0}\"title\":\"店铺列表\",\"url\":\"/malladmin/store/storelist\"{1},", "{", "}");
flag = true;
}
if (mallAdminGroupActionHashSet.Contains("storeindustry"))
{
menu.AppendFormat("{0}\"title\":\"店铺行业\",\"url\":\"/malladmin/storeindustry/list\"{1},", "{", "}");
flag = true;
}
if (mallAdminGroupActionHashSet.Contains("storerank"))
{
menu.AppendFormat("{0}\"title\":\"店铺等级\",\"url\":\"/malladmin/storerank/list\"{1},", "{", "}");
flag = true;
}
if (flag)
{
menu.Remove(menu.Length - 1, 1);
menu.Append("]},");
menuList.Append(menu.ToString());
}
#endregion
#region 新闻管理
flag = false;
menu = menu.Clear();
menu.AppendFormat("{0}\"title\":\"新闻管理\",\"subMenuList\":[", "{");
if (mallAdminGroupActionHashSet.Contains("news"))
{
menu.AppendFormat("{0}\"title\":\"新闻类型\",\"url\":\"/malladmin/news/newstypelist\"{1},", "{", "}");
menu.AppendFormat("{0}\"title\":\"新闻列表\",\"url\":\"/malladmin/news/newslist\"{1},", "{", "}");
flag = true;
}
if (flag)
{
menu.Remove(menu.Length - 1, 1);
menu.Append("]},");
menuList.Append(menu.ToString());
}
#endregion
#region 广告管理
flag = false;
menu = menu.Clear();
menu.AppendFormat("{0}\"title\":\"广告管理\",\"subMenuList\":[", "{");
if (mallAdminGroupActionHashSet.Contains("advert"))
{
menu.AppendFormat("{0}\"title\":\"广告位置\",\"url\":\"/malladmin/advert/advertpositionlist\"{1},", "{", "}");
menu.AppendFormat("{0}\"title\":\"广告列表\",\"url\":\"/malladmin/advert/advertlist\"{1},", "{", "}");
flag = true;
}
if (flag)
{
menu.Remove(menu.Length - 1, 1);
menu.Append("]},");
menuList.Append(menu.ToString());
}
#endregion
#region 商城内容
flag = false;
menu = menu.Clear();
menu.AppendFormat("{0}\"title\":\"商城内容\",\"subMenuList\":[", "{");
if (mallAdminGroupActionHashSet.Contains("nav"))
{
menu.AppendFormat("{0}\"title\":\"导航菜单\",\"url\":\"/malladmin/nav/list\"{1},", "{", "}");
flag = true;
}
if (mallAdminGroupActionHashSet.Contains("help"))
{
menu.AppendFormat("{0}\"title\":\"商城帮助\",\"url\":\"/malladmin/help/list\"{1},", "{", "}");
flag = true;
}
if (mallAdminGroupActionHashSet.Contains("friendlink"))
{
menu.AppendFormat("{0}\"title\":\"友情链接\",\"url\":\"/malladmin/friendlink/list\"{1},", "{", "}");
flag = true;
}
if (mallAdminGroupActionHashSet.Contains("banner"))
{
menu.AppendFormat("{0}\"title\":\"Banner\",\"url\":\"/malladmin/banner/list\"{1},", "{", "}");
flag = true;
}
if (flag)
{
menu.Remove(menu.Length - 1, 1);
menu.Append("]},");
menuList.Append(menu.ToString());
}
#endregion
#region 商品性质
flag = false;
menu = menu.Clear();
menu.AppendFormat("{0}\"title\":\"商品性质\",\"subMenuList\":[", "{");
if (mallAdminGroupActionHashSet.Contains("brand"))
{
menu.AppendFormat("{0}\"title\":\"商品品牌\",\"url\":\"/malladmin/brand/list\"{1},", "{", "}");
flag = true;
}
if (mallAdminGroupActionHashSet.Contains("category"))
{
menu.AppendFormat("{0}\"title\":\"分类管理\",\"url\":\"/malladmin/category/categorylist\"{1},", "{", "}");
flag = true;
}
if (flag)
{
menu.Remove(menu.Length - 1, 1);
menu.Append("]},");
menuList.Append(menu.ToString());
}
#endregion
#region 报表统计
flag = false;
menu = menu.Clear();
menu.AppendFormat("{0}\"title\":\"报表统计\",\"subMenuList\":[", "{");
if (mallAdminGroupActionHashSet.Contains("stat"))
{
menu.AppendFormat("{0}\"title\":\"在线用户\",\"url\":\"/malladmin/stat/onlineuserlist\"{1},", "{", "}");
menu.AppendFormat("{0}\"title\":\"搜索分析\",\"url\":\"/malladmin/stat/searchwordstatlist\"{1},", "{", "}");
menu.AppendFormat("{0}\"title\":\"商品统计\",\"url\":\"/malladmin/stat/productstat\"{1},", "{", "}");
menu.AppendFormat("{0}\"title\":\"销售明细\",\"url\":\"/malladmin/stat/salelist\"{1},", "{", "}");
menu.AppendFormat("{0}\"title\":\"销售趋势\",\"url\":\"/malladmin/stat/saletrend\"{1},", "{", "}");
menu.AppendFormat("{0}\"title\":\"地区统计\",\"url\":\"/malladmin/stat/regionstat\"{1},", "{", "}");
menu.AppendFormat("{0}\"title\":\"客户端统计\",\"url\":\"/malladmin/stat/clientstat\"{1},", "{", "}");
flag = true;
}
if (flag)
{
menu.Remove(menu.Length - 1, 1);
menu.Append("]},");
menuList.Append(menu.ToString());
}
#endregion
#region 系统设置
flag = false;
menu = menu.Clear();
menu.AppendFormat("{0}\"title\":\"系统设置\",\"subMenuList\":[", "{");
if (mallAdminGroupActionHashSet.Contains("brand"))
{
menu.AppendFormat("{0}\"title\":\"站点信息\",\"url\":\"/malladmin/set/site\"{1},", "{", "}");
menu.AppendFormat("{0}\"title\":\"商城设置\",\"url\":\"/malladmin/set/mall\"{1},", "{", "}");
menu.AppendFormat("{0}\"title\":\"账号设置\",\"url\":\"/malladmin/set/account\"{1},", "{", "}");
menu.AppendFormat("{0}\"title\":\"上传设置\",\"url\":\"/malladmin/set/upload\"{1},", "{", "}");
menu.AppendFormat("{0}\"title\":\"性能设置\",\"url\":\"/malladmin/set/performance\"{1},", "{", "}");
menu.AppendFormat("{0}\"title\":\"访问控制\",\"url\":\"/malladmin/set/access\"{1},", "{", "}");
menu.AppendFormat("{0}\"title\":\"邮箱设置\",\"url\":\"/malladmin/set/email\"{1},", "{", "}");
menu.AppendFormat("{0}\"title\":\"短信设置\",\"url\":\"/malladmin/set/sms\"{1},", "{", "}");
menu.AppendFormat("{0}\"title\":\"积分设置\",\"url\":\"/malladmin/set/credit\"{1},", "{", "}");
menu.AppendFormat("{0}\"title\":\"打印订单\",\"url\":\"/malladmin/set/printorder\"{1},", "{", "}");
flag = true;
}
if (mallAdminGroupActionHashSet.Contains("shipcompany"))
{
menu.AppendFormat("{0}\"title\":\"配送公司\",\"url\":\"/malladmin/shipcompany/list\"{1},", "{", "}");
flag = true;
}
if (mallAdminGroupActionHashSet.Contains("bannedip"))
{
menu.AppendFormat("{0}\"title\":\"禁止IP\",\"url\":\"/malladmin/bannedip/list\"{1},", "{", "}");
flag = true;
}
if (mallAdminGroupActionHashSet.Contains("filterword"))
{
menu.AppendFormat("{0}\"title\":\"筛选词\",\"url\":\"/malladmin/filterword/list\"{1},", "{", "}");
flag = true;
}
if (flag)
{
menu.Remove(menu.Length - 1, 1);
menu.Append("]},");
menuList.Append(menu.ToString());
}
#endregion
#region 商城插件
flag = false;
menu = menu.Clear();
menu.AppendFormat("{0}\"title\":\"商城插件\",\"subMenuList\":[", "{");
if (mallAdminGroupActionHashSet.Contains("plugin"))
{
menu.AppendFormat("{0}\"title\":\"授权插件\",\"url\":\"/malladmin/plugin/list?type=0\"{1},", "{", "}");
menu.AppendFormat("{0}\"title\":\"支付插件\",\"url\":\"/malladmin/plugin/list?type=1\"{1},", "{", "}");
flag = true;
}
if (flag)
{
menu.Remove(menu.Length - 1, 1);
menu.Append("]},");
menuList.Append(menu.ToString());
}
#endregion
#region 日志管理
flag = false;
menu = menu.Clear();
menu.AppendFormat("{0}\"title\":\"日志管理\",\"subMenuList\":[", "{");
if (mallAdminGroupActionHashSet.Contains("log"))
{
menu.AppendFormat("{0}\"title\":\"商城日志\",\"url\":\"/malladmin/log/malladminloglist\"{1},", "{", "}");
menu.AppendFormat("{0}\"title\":\"店铺日志\",\"url\":\"/malladmin/log/storeadminloglist\"{1},", "{", "}");
menu.AppendFormat("{0}\"title\":\"积分日志\",\"url\":\"/malladmin/log/creditloglist\"{1},", "{", "}");
flag = true;
}
if (flag)
{
menu.Remove(menu.Length - 1, 1);
menu.Append("]},");
menuList.Append(menu.ToString());
}
#endregion
#region 开发人员
flag = false;
menu = menu.Clear();
menu.AppendFormat("{0}\"title\":\"开发人员\",\"subMenuList\":[", "{");
if (mallAdminGroupActionHashSet.Contains("event"))
{
menu.AppendFormat("{0}\"title\":\"事件管理\",\"url\":\"/malladmin/event/list\"{1},", "{", "}");
flag = true;
}
if (mallAdminGroupActionHashSet.Contains("database"))
{
menu.AppendFormat("{0}\"title\":\"数据库管理\",\"url\":\"/malladmin/database/manage\"{1},", "{", "}");
flag = true;
}
if (flag)
{
menu.Remove(menu.Length - 1, 1);
menu.Append("]},");
menuList.Append(menu.ToString());
}
#endregion
if (menuList.Length > 16)
menuList.Remove(menuList.Length - 1, 1);
menuList.Append("]");
try
{
string fileName = IOHelper.GetMapPath(MallAdminNavMeunCacheFolder + "/" + mallAdminGroupInfo.MallAGid + ".js");
using (FileStream fs = new FileStream(fileName, FileMode.Create, FileAccess.ReadWrite, FileShare.ReadWrite))
{
Byte[] info = System.Text.Encoding.UTF8.GetBytes(menuList.ToString());
fs.Write(info, 0, info.Length);
fs.Flush();
fs.Close();
}
}
catch
{ }
}
/// <summary>
/// 更新商城管理员组
/// </summary>
public static void UpdateMallAdminGroup(MallAdminGroupInfo mallAdminGroupInfo)
{
mallAdminGroupInfo.ActionList = mallAdminGroupInfo.ActionList.ToLower();
BrnMall.Data.MallAdminGroups.UpdateMallAdminGroup(mallAdminGroupInfo);
BrnMall.Core.BMACache.Remove(CacheKeys.MALL_MALLADMINGROUP_ACTIONHASHSET + mallAdminGroupInfo.MallAGid);
BrnMall.Core.BMACache.Remove(CacheKeys.MALL_MALLADMINGROUP_LIST);
WriteMallAdminNavMenuCache(mallAdminGroupInfo);
}
/// <summary>
/// 创建管理员组
/// </summary>
/// <param name="mallAdminGroupInfo">管理员组信息</param>
public static void CreateMallAdminGroup(MallAdminGroupInfo mallAdminGroupInfo)
{
mallAdminGroupInfo.ActionList = mallAdminGroupInfo.ActionList.ToLower();
int mallAGid = BrnMall.Data.MallAdminGroups.CreateMallAdminGroup(mallAdminGroupInfo);
if (mallAGid > 0)
{
BrnMall.Core.BMACache.Remove(CacheKeys.MALL_MALLADMINGROUP_LIST);
mallAdminGroupInfo.MallAGid = mallAGid;
WriteMallAdminNavMenuCache(mallAdminGroupInfo);
}
}
