internal static IRepository <MenuInfo> GetRepo(string connectionString, string providerName) { Solution.DataAccess.DataModel.SolutionDataBase_standardDB db; if (String.IsNullOrEmpty(connectionString)) { db = new Solution.DataAccess.DataModel.SolutionDataBase_standardDB(); } else { db = new Solution.DataAccess.DataModel.SolutionDataBase_standardDB(connectionString, providerName); } IRepository <MenuInfo> _repo; if (db.TestMode) { MenuInfo.SetTestRepo(); _repo = _testRepo; } else { _repo = new SubSonicRepository <MenuInfo>(db); } return(_repo); }
/// <summary> /// 取得MenuInfo全表内容——使用菜单地址做为KEY /// </summary> /// <returns>返回Hashtable</returns> public Hashtable GetHashtable() { //读取记录 object obj = CacheHelper.GetCache(const_CacheKey_Model); //如果记录不存在,则重新加载 if (obj == null) { //初始化全局菜单内容缓存 var ht = new Hashtable(); //获取菜单表全部内容 var all = MenuInfo.All(); //遍历读取 foreach (var model in all) { //创建菜单实体 var menuinfo = new MenuInfo(); menuinfo.Id = model.Id; menuinfo.Name = model.Name; menuinfo.Url = model.Url; menuinfo.ParentId = model.ParentId; menuinfo.Depth = model.Depth; try { //将菜单实体存入容器中 //使用页面地址做为KEY ht.Add(Encrypt.Md5(menuinfo.Url), menuinfo); } catch (Exception) { } } if (ht.Count > 0) { CacheHelper.SetCache(const_CacheKey_Model, ht); } return ht; } else { return (Hashtable)obj; } }
/// <summary> /// 更新IIS缓存中指定Id记录 /// </summary> /// <param name="model">记录实体</param> public void SetModelForCache(MenuInfo model) { SetModelForCache(Transform(model)); }
/// <summary> /// 添加与编辑MenuInfo记录 /// </summary> /// <param name="page">当前页面指针</param> /// <param name="model">MenuInfo表实体</param> /// <param name="content">更新说明</param> /// <param name="isCache">是否更新缓存</param> /// <param name="isAddUseLog">是否添加用户操作日志</param> public void Save(Page page, MenuInfo model, string content = null, bool isCache = true, bool isAddUseLog = true) { try { //保存 model.Save(); //判断是否启用缓存 if (CommonBll.IsUseCache() && isCache) { SetModelForCache(model); } if (isAddUseLog) { if (string.IsNullOrEmpty(content)) { content = "{0}" + (model.Id == 0 ? "添加" : "编辑") + "MenuInfo记录成功,ID为【" + model.Id + "】"; } //添加用户访问记录 UseLogBll.GetInstence().Save(page, content); } } catch (Exception e) { var result = "执行MenuInfoBll.Save()函数出错!"; //出现异常,保存出错日志信息 CommonBll.WriteLog(result, e); } }
/// <summary> /// 将MenuInfo记录实体(SubSonic实体)转换为普通的实体(DataAccess.Model.MenuInfo) /// </summary> /// <param name="model">SubSonic插件生成的实体</param> /// <returns>DataAccess.Model.MenuInfo</returns> public DataAccess.Model.MenuInfo Transform(MenuInfo model) { if (model == null) return null; return new DataAccess.Model.MenuInfo { Id = model.Id, Name = model.Name, Url = model.Url, ParentId = model.ParentId, Sort = model.Sort, Depth = model.Depth, IsDisplay = model.IsDisplay, IsMenu = model.IsMenu, }; }
public static void Setup(int testItems) { SetTestRepo(); for(int i=0;i<testItems;i++){ MenuInfo item=new MenuInfo(); _testRepo._items.Add(item); } }
public static void Setup(MenuInfo item) { SetTestRepo(); _testRepo._items.Add(item); }
public static void Setup(MenuInfo item) { SetTestRepo(); _testRepo._items.Add(item); }
/// <summary> /// 数据保存 /// </summary> /// <returns></returns> public override string Save() { string result = string.Empty; int id = ConvertHelper.Cint0(hidId.Text); try { #region 数据验证 if (string.IsNullOrEmpty(txtName.Text.Trim())) { return txtName.Label + "不能为空!"; } var sName = StringHelper.Left(txtName.Text, 50); if (MenuInfoBll.GetInstence().Exist(x => x.Name == sName && x.Id != id)) { return txtName.Label + "已存在!请重新输入!"; } if (string.IsNullOrEmpty(txtUrl.Text.Trim())) { return txtUrl.Label + "不能为空!"; } var sUrl = StringHelper.Left(txtUrl.Text, 250, true, false); if (MenuInfoBll.GetInstence().Exist(x => x.Url == sUrl && x.Id != id)) { return txtUrl.Label + "已存在!请重新输入!"; } #endregion #region 赋值 //获取实体 var model = new MenuInfo(x => x.Id == id); //设置名称 model.Name = sName; //连接地址 model.Url = sUrl; //对应的父类id model.ParentId = ConvertHelper.Cint0(txtParent.Text); //由于限制了编辑时不能修改父节点,所以这里只对新建记录时处理 if (id == 0) { //设定当前的深度与设定当前的层数级 if (model.ParentId == 0) { //设定当前的层数级 model.Depth = 0; } else { //设定当前的层数 model.Depth = ConvertHelper.Cint0(MenuInfoBll.GetInstence().GetFieldValue(ConvertHelper.Cint0(ddlParentId.SelectedValue), MenuInfoTable.Depth)) + 1; } } //设置排序 if (txtSort.Text == "0") { model.Sort = MenuInfoBll.GetInstence().GetSortMax(model.ParentId) + 1; } else { model.Sort = ConvertHelper.Cint0(txtSort.Text); } //设定当前项属于菜单还是页面 model.IsMenu = ConvertHelper.StringToByte(rblIsMenu.SelectedValue); //设定当前项是否显示 model.IsDisplay = ConvertHelper.StringToByte(rblIsDisplay.SelectedValue); #endregion //---------------------------------------------------------- //存储到数据库 MenuInfoBll.GetInstence().Save(this, model); } catch (Exception e) { result = "保存失败!"; //出现异常,保存出错日志信息 CommonBll.WriteLog(result, e); } return result; }