Web应用程序系统的多用户权限控制设计及实现-页面模块【9】
Published on 2015-10-18 11:34 in 暂未分类 with null

Web应用程序系统的多用户权限控制设计及实现-页面模块【9】

    前五章均是从整体上讲述了Web应用程序的多用户权限控制实现流程，本章讲述Web权限管理系统的基本模块-页面模块。页面模块涉及到的数据表为页面表。

    1.1页面域

    为了更规范和方便后期系统的二次开发和维护，对应特定的业务模块采用Area(域)的方式开发，页面模块的开发域如下图所示：

    由于在Areas下还建立了一个新的目录SystemManage,故需要改变原来的路由。页面模块的路由文件名称为pageManageAreaRegistration。改变路由代码的文件名称为如下：

    using System.Web.Mvc;
    namespace CodeForMvcTest.Areas.PageManage
    {
        public class PageManageAreaRegistration : AreaRegistration
        {
            public override string AreaName
            {
                get
                {
                    return "SystemManage/PageManage";
                }
            }
            public override void RegisterArea(AreaRegistrationContext context)
            {
                context.MapRoute(
                    "SystemManage_PageManage_default",
                    "SystemManage/PageManage/{controller}/{action}/{id}",
                    new { action = "Index", id = UrlParameter.Optional }
                );
            }
        }
    }

     1.2Model

    页面模块的Model可参看第三章项目架构的系统共有类，对应model为Page.cs。文件路径为Areas/SystemManage/Models。

     1.3视图

    页面模块的视图包含在页面域中，文件路径为Areas/SystemManage/OperatorManage/Views/PageManage，视图名称为PageMange.cshtml。视图的完整代码如下：

    复制代码
      1 @{
  2     ViewBag.Title = "页面管理";
  3     Layout = "~/Views/Shared/_BaseLayout.cshtml";
  4 }
  5 
  6 
  7 
  8 <div class="easyui-layout" data-options="fit:true">
  9 
 10     <div data-options="region:'north',split:true" style="height: 50px;">
 11         <form id="searchForm" method="POST" action="@Url.Action("PageManage", "PageManage")">
 12             <!--属性组筛选栏-->
 13             <table style="margin-left: 5px; margin-top: 5px;">
 14                 <tr>
 15                     <td><span>栏目:</span></td>
 16                     <td>
 17                         <select class="easyui-combotree" name="categoryId" id="categoryId" style="width: 180px;"
 18                             data-options="url:'/SystemManage/PageManage/PageManage/InitCatalog'">
 19                         </select>
 20                     </td>
 21                     <td><span style="margin-left: 10px;">状态:</span></td>
 22                     <td>
 23                         <select class="easyui-combobox" name="isAvailable" id="isAvailable" style="width: 150px;"
 24                             data-options="editable:false">
 25                             <option value="-1">全部</option>
 26                             <option value="1">启用</option>
 27                             <option value="0">不启用</option>
 28                         </select>
 29                     </td>
 30                     <td><span style="margin-left: 10px;">页面名称:</span></td>
 31                     <td>
 32                         <input class="easyui-validatebox" id="pageName" name="pageName" />
 33                     </td>
 34                     <td>
 35                         <input type="submit" value="查找" id="btn_submit" style="margin-left: 10px; margin-right: 10px;" />
 36                     </td>
 37                 </tr>
 38             </table>
 39         </form>
 40     </div>
 41 
 42     <div data-options="region:'center',split:true" style="padding-bottom: 10px;" id="centerDiv">
 43         <table id="dataGrid">
 44             <thead>
 45                 <tr>
 46                     <th data-options="field:'CategoryName',align:'left'">所属栏目</th>
 47                     <th data-options="field:'PageIndex',align:'left'">页面ID</th>
 48                     <th data-options="field:'PageName',align:'left'">页面名称</th>
 49                     <th data-options="field:'PageUrl',align:'left'">页面访问地址</th>
 50                     <th data-options="field:'Title',align:'left'">报表标题</th>
 51                     <th data-options="field:'Subtitle',align:'left'">副标题</th>
 52                     <th data-options="field:'ShowNum',align:'left'">排序值</th>
 53                     <th data-options="field:'IsAvailable',align:'center',formatter:statusformater">状态</th>
 54                     <th data-options="field:'Operate',align:'center',formatter:operateFormater">操作</th>
 55                 </tr>
 56             </thead>
 57             <tbody>
 58             </tbody>
 59         </table>
 60         <br />
 61     </div>
 62 
 63 </div>
 64 
 65 <!--属性组工具栏-->
 66 <div id="page_tb" style="height: auto">
 67     <a href="javascript:void(0)" class="easyui-linkbutton" data-options="iconCls:'icon-add',plain:true" onclick="openAddWindow();">添加页面</a>
 68 </div>
 69 
 70 
 71 <!--页面信息编辑窗体-->
 72 <div id="pageEditWin" title="修改页面信息" style="width: 450px; height: 460px; padding: 20px; text-align: center;">
 73     <form id="pageEditForm" method="POST" action="@Url.Action("UpdatePage", "PageManage")">
 74         <table style="margin: auto;">
 75             <tr>
 76                 <td style="text-align: right;"><span>栏目:</span></td>
 77                 <td>
 78                     <select class="easyui-combotree" name="CategoryId" id="e_categoryId" style="width: 200px;"
 79                         data-options="url:'/SystemManage/PageManage/PageManage/InitCatalogWithoutRoot'">
 80                     </select>
 81                 </td>
 82             </tr>
 83             <tr style="height: 30px;">
 84                 <td style="text-align: right;"><span>名称:</span></td>
 85                 <td>
 86                     <input class="easyui-validatebox" id="e_pageName" name="PageName" style="width: 200px;" />
 87                 </td>
 88             </tr>
 89             <tr style="height: 30px;">
 90                 <td style="text-align: right;"><span>访问路径:</span></td>
 91                 <td>
 92                     <input class="easyui-validatebox" id="e_pageUrl" name="PageUrl" style="width: 200px;" />
 93                 </td>
 94             </tr>
 95             <tr style="height: 30px;">
 96                 <td style="text-align: right;"><span>标题:</span></td>
 97                 <td>
 98                     <input class="easyui-validatebox" id="e_title" name="Title" style="width: 200px;" />
 99                 </td>
100             </tr>
101             <tr style="height: 30px;">
102                 <td style="text-align: right;"><span>副标题:</span></td>
103                 <td>
104                     <input class="easyui-validatebox" id="e_subtitle" name="Subtitle" style="width: 200px;" />
105                 </td>
106             </tr>
107             <tr style="height: 30px;">
108                 <td style="text-align: right;"><span>显示顺序:</span></td>
109                 <td>
110                     <input class="easyui-numberbox" id="e_showNum" name="ShowNum" style="width: 205px;" />
111                 </td>
112             </tr>
113             <tr style="height: 40px;">
114                 <td style="text-align: right;"><span>状态:</span></td>
115                 <td>
116                     <select class="easyui-combobox" name="IsAvailable" id="e_isAvailable" style="width: 205px;"
117                         data-options="editable:false,required:true">
118                         <option value="0">不可用</option>
119                         <option value="1">可用</option>
120                     </select>
121                 </td>
122             </tr>
123             <tr style="height: 50px;">
124                 <td colspan="2" style="text-align: right;">
125                     <input type="hidden" id="e_pageIndex" name="PageIndex" />
126                     <input type="reset" style="display: none;" />
127                     <input type="submit" value="提交" id="btn_editsubmit" style="margin-left: 10px; margin-right: 10px;" />
128                     <input type="button" value="取消" id="btn_editCancel" onclick="javascript: return $('#pageEditWin').window('close');"
129                         style="margin-left: 10px; margin-right: 10px;" />
130                 </td>
131             </tr>
132         </table>
133     </form>
134 </div>
135 
136 
137 
138 
139 
140 @section scripts
141 {
142     <script type="text/javascript"  src="/Areas/SystemManage/SystemJS/pageManage.js"></script>
143 }
    PageMange.cshtml
    复制代码

     1.4JS文件

    页面模块相关的JS文件路径为Areas/SystemManage/SystemJS，JS文件名称为pageManage.js。JS的完整代码如下：

    复制代码
      1 //状态显示格式化
  2 function statusformater(value, row, index) {
  3     if (value == "0") {
  4         return "不可用";
  5     } else {
  6         return "可用";
  7     }
  8 };
  9 
 10 //属性组操作显示格式化
 11 function operateFormater(value, row, index) {
 12     var operationStr = "<a href='#' onclick=\"openEditWindow(" + row.CategoryId + "," + row.PageIndex + ",'" + row.PageName
 13         + "','" + row.PageUrl + "','" + row.Title + "','" + row.Subtitle + "'," + row.ShowNum + "," + row.IsAvailable
 14         + ");\" style='margin-right:10px;'>编辑</a>";
 15     return operationStr;
 16 };
 17 
 18 
 19 //开启编辑窗体
 20 function openEditWindow(categoryId, pageIndex,
 21     pageName, pageUrl, title, subtitle, showNum, isAvailable) {
 22     $("#e_categoryId").combotree('setValue', categoryId);
 23     $("#e_pageName").val(pageName);
 24     $("#e_pageUrl").val(pageUrl);
 25     $("#e_title").val(title);
 26     $("#e_subtitle").val(subtitle);
 27     $("#e_showNum").numberbox('setValue', showNum);
 28     $("#e_isAvailable").combobox('select', isAvailable);
 29     $("#e_pageIndex").val(pageIndex);
 30 
 31     $('#pageEditWin').window({
 32         title: '修改页面',
 33     });
 34     $('#pageEditWin').window('open');
 35 };
 36 
 37 
 38 //“点击添加按钮时，打开添加用户窗体”
 39 function openAddWindow() {
 40     $("#e_pageName").val("");
 41     $("#e_pageUrl").val("");
 42     $("#e_title").val("");
 43     $("#e_subtitle").val("");
 44     $('#e_categoryId').combotree('setValue', 0); //重新加载数据 
 45     $("#e_isAvailable").combobox('setValue', 0);
 46     $("#e_pageIndex").val("-1");
 47     $('#pageEditWin').window({
 48         title: '新增页面',
 49     });
 50     $('#pageEditWin').window('open');
 51 };
 52 
 53 
 54 //删除用户
 55 function deletePage(pageId) {
 56     startDatagridLoading("dataGrid", "btn_submit");
 57     $.ajax({
 58         url: '/SystemManage/PageManage/PageManage/DeletePage',
 59         type: 'POST',
 60         dataType: 'text',
 61         data: { pageId: pageId },
 62         success: function (data) {
 63             if (data.indexOf("/Login/Login") >= 0) {
 64                 window.parent.location.href = '/Login/Login';
 65             }
 66             var groupId = $("#groupId").combobox('getValue');
 67             var pageName = $("#pageName").val();
 68             var url = "/SystemManage/PageManage/PageManage/PageManage?groupId=" + groupId
 69                 + "&pageName=" + pageName;
 70 
 71             alert(data);
 72 
 73             reloadDatagrid(url, "dataGrid", "btn_submit", "无页面数据返回！", "查询页面数据出错！");
 74         },
 75         error: function (data) {
 76             commErrorHandle(data, true, 'dataGrid', 'btn_submit', "操作出错！");
 77         }
 78     });
 79 };
 80 
 81 
 82 $(function () {
 83     //设置DataGrid基本属性
 84     var centerHeight = $("#centerDiv").height();
 85     $("#dataGrid").datagrid({
 86         height: centerHeight - 15,
 87         rownumbers: false,
 88         singleSelect: true,
 89         autoRowHeight: false,
 90         fitColumns: true,
 91         pagination: true,
 92         pageSize: 20,
 93         loadMsg: 'Loading... ...',
 94         url: '/SystemManage/PageManage/PageManage/PageManage?categoryId=0&isAvailable=-1&pageName=',
 95         toolbar: '#page_tb',
 96         title: "页面列表",
 97         remoteSort: false,
 98         onLoadSuccess: function (data) {
 99             //设置查询按钮可用
100             $("#btn_submit").attr("disabled", false);
101             if (data.total <= 0)
102                 alert("无数据返回！");
103             $(".datagrid-wrap.panel-body").css("width", '100%');
104             $(".datagrid-wrap.panel-body .datagrid-view").css("width", '100%');
105         },
106         onLoadError: function (data) {
107             //判断是否是首次加载，不是首次加载再判断错误原因
108             var isFirstLoad = $("#firstLoadFlag").val();
109             if (isFirstLoad == "false") {
110                 //设置查询按钮可用
111                 $("#btn_submit").attr("disabled", false);
112                 if (data.responseText.indexOf("/Login/Login") >= 0) {
113                     window.parent.location.href = '/Login/Login';
114                 } else {
115                     $("#btn_submit").attr("disabled", false);
116                     //隐藏加载状态
117                     $('#dataGrid').datagrid('loaded');
118                     alert("对不起，查询失败！");
119                 }
120             }
121         }
122     });
123 
124     $('#pageEditWin').window({
125         modal: true,
126         collapsible: false,
127         minimizable: false,
128         maximizable: false,
129         draggable: true,
130         resizable: false,
131         closable: false,
132         closed: true
133     });
134 
135     $("#searchForm").submit(function (event) {
136         //中断当前的提交事件
137         event.preventDefault();
138         //将首次加载标志设置为false
139         $("#firstLoadFlag").val("false");
140         //清空数据
141         $("#dataGrid").datagrid('loadData', { total: 1, rows: [] });
142         //查询条件
143         var categoryId = $("#categoryId").combotree("getValue");
144         if (categoryId == "") {
145             categoryId = "0";
146         }
147         var isAvailable = $("#isAvailable").combobox("getValue");
148         var pageName = $("#pageName").val();
149 
150         $("#btn_submit").attr("disabled", true);
151         $("#dataGrid").datagrid('load', {
152             categoryId: categoryId,
153             isAvailable: isAvailable,
154             pageName: pageName
155         });
156     });
157 
158 
159 
160     //修改页面信息
161     $("#pageEditForm").submit(function (event) {
162         //中断当前的提交事件
163         event.preventDefault();
164         //提交的URL,默认为属性组修改或添加路径
165         var url = "/SystemManage/PageManage/PageManage/UpdatePage";
166         //路径
167         var pageUrl = $("#e_pageUrl").val();
168         if (pageUrl == "") {
169             alert("路径不能为空！");
170             return false;
171         }
172         //名称
173         var pageName = $("#e_pageName").val();
174         if (pageName == "") {
175             alert("名称不能为空！");
176             return false;
177         }
178 
179         //排序值
180         var orderNum = $("#e_showNum").numberbox('getValue');
181         if (orderNum == "") {
182             alert("排序值不能为空！");
183             return false;
184         }
185 
186         //判断是增加页面还是修改页面信息
187         var pageIndex = $("#e_pageIndex").val();
188         if (pageIndex == "-1") {
189             url = "/SystemManage/PageManage/PageManage/AddPage";
190         }
191 
192         $('#pageEditWin').window('close');
193 
194         $("#dataGrid").datagrid("loading");
195         $("#btn_submit").attr("disabled", true);
196 
197         //startDatagridLoading('dataGrid', 'btn_submit');
198 
199         //表单序列化
200         var formData = $("#pageEditForm").serializeJson();
201         var categoryId = $("#e_categoryId").combotree("getValue");
202         formData.CategoryId = categoryId;
203 
204         //完整路径
205         //url = url + "?" + formData;
206 
207         $.ajax({
208             url: url,
209             type: 'POST',
210             data: { pageStr: JSON.stringify(formData) },
211             dataType: 'text',
212             traditional: true,
213             success: function (data) {
214                 if (data.indexOf("/Login/Login") >= 0) {
215                     window.parent.location.href = '/Login/Login';
216                 }
217                 categoryId = $("#categoryId").combotree('getValue');
218                 if (categoryId == "") {
219                     categoryId = "0";
220                 }
221                 var isAvailable = $("#isAvailable").combobox("getValue");
222                 pageName = $("#pageName").val();
223 
224                 $("#btn_submit").attr("disabled", false);
225                 $("#dataGrid").datagrid('load', {
226                     categoryId: categoryId,
227                     isAvailable: isAvailable,
228                     pageName: pageName
229                 });
230 
231                 alert(data);
232 
233                 // reloadDatagrid(url, "dataGrid", "btn_submit", "无页面数据返回！", "查询页面数据出错！");
234             },
235             error: function (data) {
236                 commErrorHandle(data, true, 'dataGrid', 'btn_submit', "操作出错！");
237             }
238         });
239     });
240 
241 
242 });
    pageManage.js
    复制代码

    1.5控制器

    页面模块的控制器包含在页面域中，文件路径为Areas/SystemManage/PageMange/Controllers，控制器名称为PageManageController.cs。控制器的完整代码如下：

    复制代码
      1 using System;
  2 using System.Collections.Generic;
  3 using System.Linq;
  4 using System.Web;
  5 using System.Web.Mvc;
  6 using Session;
  7 using OdbcDbAccess;
  8 using System.Data;
  9 using Models;
 10 using Controllers;
 11 using System.Data.SqlClient;
 12 using Newtonsoft.Json;
 13 using LogInfo;
 14 
 15 
 16 namespace CodeForMvcTest.Areas.PageManage.Controllers
 17 {
 18     //|++++++++++++++++++++++++++++++
 19     /// 功能：页面信息类
 20     /// 作者：Author
 21     /// 时间：2015-7-17
 22     /// 邮箱：1129137758@qq.com
 23     //|+++++++++++++++++++++++++++++
 24     public class PageManageController : BaseController
 25     {
 26         public ActionResult PageManage()
 27         {
 28             return View();
 29         }
 30 
 31 
 32         //初始化栏目树
 33         public ActionResult InitCatalog()
 34         {
 35             IList<TreeModel> resultList = new List<TreeModel>();
 36             try
 37             {
 38                 //获取栏目信息
 39                 string strSql = "select * from catalog order by catalogid,showno";
 40                 DataSet categoryDt = SqlHelper.ExecuteQuery(SqlSeverConnectionName , strSql);
 41                 if (categoryDt != null && categoryDt.Tables.Count > 0)
 42                 {
 43                     DataTable table = categoryDt.Tables[0];
 44                     resultList = TreeModel.BuildTreeNodeListIncludeAll(table.Rows, "catalogid", "catalogname",
 45                         "parentid");
 46                 }
 47             }
 48             catch (Exception)
 49             {
 50             }
 51 
 52             return Json(resultList, JsonRequestBehavior.AllowGet);
 53         }
 54 
 55 
 56 
 57 
 58         //初始化栏目树
 59         public ActionResult InitCatalogWithoutRoot()
 60         {
 61             IList<TreeModel> resultList = new List<TreeModel>();
 62             try
 63             {
 64                 //获取栏目信息
 65                 string strSql = "select * from catalog order by catalogid,showno";
 66                 DataSet categoryDt = SqlHelper.ExecuteQuery(SqlSeverConnectionName, strSql);
 67                 if (categoryDt != null && categoryDt.Tables.Count > 0)
 68                 {
 69                     DataTable table = categoryDt.Tables[0];
 70                     resultList = TreeModel.BuildTreeNodeList(table.Rows, "catalogid", "catalogname",
 71                         "parentid", false);
 72                 }
 73             }
 74             catch (Exception)
 75             {
 76             }
 77 
 78             return Json(resultList, JsonRequestBehavior.AllowGet);
 79         }
 80 
 81 
 82 
 83         /// <summary>
 84         /// 通过分类以及页面名称，返回页面数据列表
 85         /// </summary>
 86         /// <param name="categoryId">一级分类</param>
 87         /// <param name="subcategoryId">二级分类</param>
 88         /// <param name="isAvailable">页面启用状态</param>
 89         /// <param name="pageName">页面名称</param>
 90         /// <param name="page">当前页</param>
 91         /// <param name="rows">每页显示条数</param>
 92         /// <returns></returns>
 93         [HttpPost]
 94         public ActionResult PageManage(int categoryId, int isAvailable, string pageName, int page, int rows)
 95         {
 96             int totalCount = 0;
 97             IList<Page> pageList = GetPageList(categoryId, isAvailable, pageName, page, rows, out totalCount);
 98             //封装数据
 99             object result = new
100             {
101                 total = totalCount,
102                 rows = pageList
103             };
104             return Json(result);
105         }
106 
107 
108 
109 
110         /// <summary>
111         /// 修改页面信息
112         /// </summary>
113         /// <param name="pageStr">修改页面后的信息</param>
114         /// <returns></returns>
115         [HttpPost]
116         public ActionResult UpdatePage(string pageStr)
117         {
118             Page page = JsonConvert.DeserializeObject<Page>(pageStr);
119 
120             string sql = "update pageinfo set showno=" + page.ShowNum + ",title='" + page.Title + "',"
121                 + "subtitle='" + page.Subtitle + "',isavailable=" + page.IsAvailable + ",pageurl='" + page.PageUrl +
122                 "',pagename='" + page.PageName + "',catalogid=" + page.CategoryId + " where pageid=" + page.PageIndex;
123 
124             try
125             {
126                
127                 SqlHelper.ExecuteNonQuery(SqlSeverConnectionName ,sql);
128 
129                 Log.SaveOperatorLog(sql, 1, "修改页面信息");
130                 return Content("修改成功！");
131             }
132             catch (Exception ex)
133             {
134                 Log.SaveErrorLog(ex.ToString(), "修改页面信息出错！");
135                 return Content("修改页面信息失败！");
136             }
137         }
138 
139 
140 
141 
142         /// <summary>
143         /// 添加页面
144         /// </summary>
145         /// <param name="pageStr">页面信息对应的json字符串</param>
146         /// <returns></returns>
147         [HttpPost]
148         public ActionResult AddPage(string pageStr)
149         {
150             Page page = JsonConvert.DeserializeObject<Page>(pageStr);
151             string sql = "select count(*) from pageinfo where catalogid='" + page.CategoryId + "' and pagename='" + page.PageName + "'";
152             try
153             {
154                 int count = SqlHelper.ExecuteScalar<int>(SqlSeverConnectionName, sql);
155                 if (count > 0)
156                 {
157                     Log.SaveOperatorLog("", 0, "由于页面名称重复，添加页面失败");
158                     return Content("在同一类别下，已经存在相同名称的页面！");
159                 }
160                 sql = "insert into pageinfo (catalogid,showno,title,subtitle,isavailable,pageurl,pagename) values('" + page.CategoryId + "','" + page.ShowNum + "','" + page.Title + "','" + page.Subtitle + "','" + page.IsAvailable + "','" + page.PageUrl + "', '"+page.PageName+"')";
161                 SqlHelper.ExecuteNonQuery(SqlSeverConnectionName, sql);
162                 Log.SaveOperatorLog(sql, 1, "添加页面");
163                 return Content("添加成功！");
164             }
165             catch (Exception ex)
166             {
167                 Log.SaveErrorLog(ex.ToString(), "添加页面信息出错！");
168                 return Content("添加页面失败！");
169             }
170         }
171 
172 
173 
174 
175         /// <summary>
176         /// 删除页面
177         /// </summary>
178         /// <param name="pageId">页面ID</param>
179         /// <returns></returns>
180         [HttpPost]
181         public ActionResult DeletePage(int pageId)
182         {
183             string sql = "delete from pageinfo where pageid='" + pageId + "'";
184             try
185             {
186                 SqlHelper.ExecuteNonQuery(SqlSeverConnectionName ,sql);
187                 Log.SaveOperatorLog(sql, 1, "删除页面");
188                 return Content("删除成功！");
189             }
190             catch (Exception ex)
191             {
192                 Log.SaveErrorLog(ex.ToString(), "删除页面出错！");
193                 return Content("删除页面失败！");
194             }
195         }
196 
197 
198 
199         /// <summary>
200         /// 查找页面信息
201         /// </summary>
202         /// <param name="categoryId">一级分类ID</param>
203         /// <param name="isAvailable">页面启用状态</param>
204         /// <param name="pageName">页面名称</param>
205         /// <param name="pageIndex"></param>
206         /// <param name="pageSize"></param>
207         /// <param name="totalCount"></param>
208         /// <returns></returns>
209         private IList<Page> GetPageList(int categoryId, int isAvailable, string pageName,
210             int pageIndex, int pageSize, out int totalCount)
211         {
212             IList<Page> pageList = new List<Page>();
213             totalCount = 0;
214 
215             #region 封装Sql
216 
217             string sql = "select * from (select pageinfo.*,catalogname ,ROW_NUMBER() over(order by pageinfo.pageid) as rows from pageinfo left join catalog on pageinfo.catalogid=catalog.catalogid where 1=1 ";
218           
219             string totalSql = "select count(*) from pageinfo where 1=1 ";
220             if (categoryId != 0)
221             {
222                 sql += " and pageinfo.catalogid in (select catalogid from catalog where catalogid=" + categoryId + " or parentid=" + categoryId + ")";
223                 totalSql += " and catalogid in (select catalogid from catalog where catalogid=" + categoryId + " or parentid=" + categoryId + ")";
224             }
225             if (isAvailable != -1)
226             {
227                 sql += " and pageinfo.isavailable=" + isAvailable;
228                 totalSql += " and isavailable=" + isAvailable;
229             }
230             if (!string.IsNullOrEmpty(pageName))
231             {
232                 sql += " and pageinfo.pagename like '%" + pageName + "%'";
233                 totalSql += " and pagename like '%" + pageName + "%'";
234             }
235             sql += " ) as temptable where rows between " + (pageIndex - 1) * pageSize + " and " + pageSize * pageIndex + " ";
236 
237             #endregion
238 
239             try
240             {
241                 totalCount = SqlHelper.ExecuteScalar<int>(SqlSeverConnectionName , totalSql);
242 
243                 if (totalCount > 0)
244                 {
245                     DataSet dataSet = SqlHelper.ExecuteQuery(SqlSeverConnectionName, sql);
246                     if (dataSet != null && dataSet.Tables.Count > 0)
247                     {
248                         //获取页面分类
249                         var table = dataSet.Tables[0];
250                         foreach (DataRow dr in table.Rows)
251                         {
252                             #region 封装数据列表
253 
254                             int class1Id = DBNull.Value.Equals(dr["catalogid"]) ? -1 : Convert.ToInt32(dr["catalogid"]);
255 
256                             var item = new Page
257                             {
258                                 CategoryId = class1Id,
259                                 CategoryName = DBNull.Value.Equals(dr["catalogname"]) ? "" : Convert.ToString(dr["catalogname"]),
260                                 PageIndex = DBNull.Value.Equals(dr["pageid"]) ? -1 : Convert.ToInt32(dr["pageid"]),
261                                 PageName = DBNull.Value.Equals(dr["pagename"]) ? "" : Convert.ToString(dr["pagename"]),
262                                 PageUrl = DBNull.Value.Equals(dr["pageurl"]) ? "" : Convert.ToString(dr["pageurl"]),
263                                 Title = DBNull.Value.Equals(dr["title"]) ? "" : Convert.ToString(dr["title"]),
264                                 Subtitle = DBNull.Value.Equals(dr["subtitle"]) ? "" : Convert.ToString(dr["subtitle"]),
265                                 ShowNum = DBNull.Value.Equals(dr["showno"]) ? -1 : Convert.ToInt32(dr["showno"]),
266                                 IsAvailable = DBNull.Value.Equals(dr["isavailable"]) ? 0 : Convert.ToInt32(dr["isavailable"])
267                             };
268 
269                             pageList.Add(item);
270 
271                             #endregion
272                         }
273                     }
274                 }
275             }
276             catch (Exception ex)
277             {
278                 Log.SaveErrorLog(ex.ToString(), "查询页面出错");
279             }
280             return pageList;
281         }
282 
283 
284     }
285 }
    pageGroupMange.cs
    复制代码

     

    1.6界面运行截图

    页面管理主界面如下图所示：

    页面访问地址由Areas下的返回路控制器由+控制器名称+Action名称。

    编辑页面界面如下图所示：

    添加页面界面如下图所示:

     

    posted @   无涯Ⅱ  阅读(1800)  评论(1)  编辑  收藏  举报
    编辑推荐：
    · 如何编写易于单元测试的代码
    · 10年+ .NET Coder 心语，封装的思维：从隐藏、稳定开始理解其本质意义
    · .NET Core 中如何实现缓存的预热？
    · 从 HTTP 原因短语缺失研究 HTTP/2 和 HTTP/3 的设计差异
    · AI与.NET技术实操系列：向量存储与相似性搜索在 .NET 中的实现
    阅读排行：
    · 周边上新：园子的第一款马克杯温暖上架
    · Open-Sora 2.0 重磅开源！
    · 分享 3 个 .NET 开源的文件压缩处理库，助力快速实现文件压缩解压功能！
    · Ollama——大语言模型本地部署的极速利器
    · DeepSeek如何颠覆传统软件测试？测试工程师会被淘汰吗？
    前一篇 后一篇 底部 回到顶部
    点击右上角即可分享
    微信分享提示
    AI IDE Trae