ASP.NET MVC 2 学习笔记一: 两个表的连接的信息显示

最新推荐文章于 2021-06-07 19:51:44 发布

dedhq45156

最新推荐文章于 2021-06-07 19:51:44 发布

阅读量235

点赞数

文章标签：测试 javascript c# ViewUI

原文链接：http://www.cnblogs.com/MarkRao/archive/2012/02/16/Mark_Rao.html

版权

ASP.NET MVC 2 学习笔记一: 两个表的连接的信息显示

　　最近在写一个关于公司内部的请假系统,要用到ASP.NET MVC,于是乎一边学习,一边写代码.下面写写在学习的时候遇到的问题,以及解决办法,留作学习沉淀.

　　关于模型类的创建就不说了,下面是我用Entity Framework创建的,取名StaffDataModel.edmx,如下图:

　　上图中有三个表,当做到经理角色时,要显示所有未批准的请假信息,其中所需信息大部分在LeavingInformaion这个表中,但是申请人的英文名字信息在StaffList中,两个表关系是一对多,通过员工Id连接.现在,需要在View视图中显示这些信息,用的是ViewData.Model传的值.这样,仅用ADO.NET Entity Data Model生成的模型类是不够的.

　　所以,考虑在Models层创建了一个模型类LeavingInfoModel.cs,代码如下:

 1 using System;
 2 using System.Collections.Generic;
 3 using System.Linq;
 4 using System.Web;
 5 using System.Web.Mvc;
 6 using System.ComponentModel;
 7 
 8 namespace MvcLeavingApp.Models
 9 {
10     /// <summary>
11 /// 请假信息
12 /// </summary>
13     public class LeavingInfoModel
14     {
15         public int infoid;
16         public string enname;
17         public DateTime starttime;
18         public DateTime requesttime;
19         public int relativetime;
20         public DateTime endtime;
21 
22         public LeavingInfoModel()
23         {
24             infoid = 0;
25             enname = null;
26             starttime = DateTime.Now;
27             requesttime = DateTime.Now;
28             relativetime = 0;
29             endtime = DateTime.Now;
30         }
31     }
32 }

　　在LeavingInfoModel这个模型类中,定义了所需要显示的所有字段,并在构造函数中为所有字段赋初值.

　　那么在Controllers层,对LeavingInformaion和StaffList两个表左连接后,用linq中的Lambda表达式获得符合筛选条件的结果集合,在创建一个对象数组,赋予结果集合,最后传给ViewData.Model.其中 ManagerController.cs的代码如下:

 1 using System;
 2 using System.Collections.Generic;
 3 using System.Linq;
 4 using System.Web;
 5 using System.Web.Mvc;
 6 using MvcLeavingApp.Models;
 7 
 8 namespace MvcLeavingApp.Controllers
 9 {
10     [HandleError]
11     public class ManagerController : Controller
12     {
13         StaffDataEntities _Staffdb;
14 
15         public ManagerController()
16         {
17             _Staffdb = new StaffDataEntities();
18         }
19 　　　　　/// <summary>
20 　　　　　/// 查看带审批的请假单
21 　　　　　/// </summary>
22 　　　　　/// <returns></returns>
23         public ActionResult ApproveLeave()
24         {
25             var approveInfor = from stafflist in _Staffdb.StaffList
26                                from leavinginfo in stafflist.LeavingInformation
27                                where leavinginfo.IfApprove == 0
28                                select new
29                                {
30                                    infoid = leavinginfo.InfoId,
31                                    starttime = leavinginfo.StartTime,
32                                    endtime = leavinginfo.EndTime,
33                                    relativetime = leavinginfo.RelativeTime,
34                                    requesttime = leavinginfo.RequestTime,
35                                    requestname = stafflist.EnName
36                                };
37 
38             LeavingInfoModel[] leaveinfomodel = new LeavingInfoModel[approveInfor.Count()];
39             int itemindex = 0;
40 
41             foreach (var info in approveInfor)
42             {
43                 leaveinfomodel[itemindex] = new LeavingInfoModel();
44                 leaveinfomodel[itemindex].infoid = info.infoid;
45                 leaveinfomodel[itemindex].enname = info.requestname;
46                 leaveinfomodel[itemindex].starttime = info.starttime;
47                 leaveinfomodel[itemindex].endtime = info.endtime;
48                 leaveinfomodel[itemindex].relativetime = info.relativetime;
49                 leaveinfomodel[itemindex].requesttime = info.requesttime;
50                 itemindex++;
51             }
52 
53             ViewData.Model = leaveinfomodel.ToList();
54             return View();
55         }
56 }

　　可以看到,在ViewData.Model 中已经有了我们所需要的符合条件的结果集.

　　所以,在View视图中我们可以这样写:

 1 <%@ Page Title="" Language="C#" MasterPageFile="~/Views/Shared/SiteManager.Master" Inherits="System.Web.Mvc.ViewPage<List<MvcLeavingApp.Models.LeavingInfoModel>>" %>
 2 
 3 <asp:Content ID="Content1" ContentPlaceHolderID="TitleContent" runat="server">
 4     ApprovingLeave
 5 </asp:Content>
 6 
 7 <asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
 8     <script src="http://www.cnblogs.com/Scripts/jquery-1.4.1.js" type="text/javascript"></script>
 9     <script type="text/javascript">
10         $(function () {
11             $("tr:even").css ({ "background-color": "#CEDBE8" });
12         });
13     </script>
14 
15     <h2>Required to Approve Leave</h2>
16     <form method="post" action="/Manager/ApproveLeave">
17     <div>
18         <fieldset>
19             <legend>
20                 Require to Approve Absence Form</legend>
21             <table>
22                 <thead>
23                     <tr>
24                         <td align="center">
25                             If/Not Approved
26                         </td>
27                         <td align="center">
28                             Start Time
29                         </td>
30                         <td align="center">
31                             End Time
32                         </td>
33                         <td align="center">
34                             Relative Time
35                         </td>
36                         <td align="center">
37                             Request Time
38                         </td>
39                         <td align="center">
40                             Request Staff
41                         </td>
42                         <td align="center">
43                             Details
44                         </td>
45                     </tr>
46                 </thead>
47                 <tbody>
48                     <% foreach (var m in ViewData.Model)
49                        { %>
50                     <tr>
51                         <td align="center">
52                             <%=Html.CheckBox(""+m.infoid) %>
53                         </td>
54                         <td align="center">
55                             <%=m.starttime.ToShortDateString() %>
56                         </td>
57                         <td align="center">
58                             <%=m.endtime.ToShortDateString() %>
59                         </td>
60                         <td align="center">
61                             <%=m.relativetime %>
62                             days
63                         </td>
64                         <td align="center">
65                             <%=m.requesttime.ToShortDateString() %>
66                         </td>
67                         <td align="center">
68                             <%=m.enname %>
69                         </td>
70                         <td align="center">
71                             <%= Html.ActionLink("Details", "LeavingDetails", new { infoid = m.infoid })%>
72                         </td>
73                     </tr>
74                     <% } %>
75                 </tbody>
76             </table>
77             <p>
78                 <input type="submit" value="Approved" />
79             </p>
80         </fieldset>
81     </div>
82     </form>
83 </asp:Content>