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