• 客车网上售票系统(分解十一)


    1、今日完成任务:
    (1)订单统计

    2、核心源码:

    (1)订单统计前台页面效果

     (2)订单统计前台页面代码

    <!DOCTYPE html>
    <html>
    <head>
        <meta charset="utf-8" />
        <meta name="viewport" content="width=device-width,initial-scale=1.0,maximum-scale=1.0,user-scalable=0">
        <meta http-equiv="X-UA-Compatible" content="ie=edge" />
        <link href="../css/reset.css" rel="stylesheet" />
        <link href="../css/iconfont.css" rel="stylesheet" />
        <link href="../css/aa.css" rel="stylesheet" />
        <script src="../js/jquery-1.9.1.min.js"></script>
        <script src="../js/f.js"></script>
        <script src="../js/laydate/laydate.js"></script>
        <script>
            //执行一个laydate实例
            laydate.render({
                elem: '#test1' //指定元素
            });
        </script>
        <style type="text/css">
            .icon-weibiaoti1:before {
                content: "e695";
            }
    
            .icon-xinxiliulan:before {
                content: "e614";
            }
    
            #test1 {
                clear: both;
                border: 1px solid #ccc;
                height: 25px;
                position: relative;
                left: 50px;
                bottom: 20px;
            }
    
            .InputDiv {
                border: none;
            }
    
            #txtCfd, #txtMdd {
                border: 1px solid #ccc;
                height: 25px;
            }
    
            #btnSelect {
                color: #fff;
            }
    
            .auto-style1 {
                background: #fff;
                margin-left: 40px;
            }
    
            .headboxtext {
                height: 30px;
                line-height: 30px;
            }
    
            #GridView1 {
                text-align: center;
            }
    
            table {
                 800px;
                border-collapse: collapse;
                text-align: center;
            }
    
                table tr td {
                    border: 1px solid #000;
                }
    
            .auto-style2 {
                 812px;
                height: 134px;
            }
            .auto-style3 {
                 810px;
                height: 80px;
            }
            #ts{
                border:1px solid #000;
            }
            #ts tr td{
                border:1px solid #808080;
            }
            .auto-style4 {
                height: 35px;
            }
            #btnSubmit{
                color: #fff;
                background-color:#fd4c4c;
                height:30px;
                100px;
                margin-left:710px;
                margin-top:50px;
            }
            #btnGQ{
                 color: #fff;
                background-color:#fd4c4c;
                height:30px;
                100px;
                margin-left:710px;
            }
        </style>
        <title>产品管理</title>
    </head>
    <body>
        <form id="form1" runat="server">
            <div class="PublicHead clearfix">
                <div class="leftBox clearfix">
                    <!--<div class="companyLogo">
                    <img src="images/logo.jpg" />
                </div>-->
                    <!--<i class="iconfont icon-caidan"></i>-->
    
                    <div class="companyText">
                        客车网上售票系统
                    </div>
                </div>
                <div class="RightBox clearfix">
                    <div class="UserPhotoBox">
                        <div class="UserPic">
                            <img src="../Images/user.jpg" />
                        </div>
                        <div class="UserName">
                            用户
                        </div>
                    </div>
                    <a href="Login.aspx">
                        <div class="dropOutBox">
                            <i class="iconfont icon-app_icons--"></i>
                            <span>退出</span>
                        </div>
                    </a>
                </div>
            </div>
    
            <div class="PublicDownWhole clearfix">
                <!--左侧-->
                <div class="leftBox">
                    <ul>
                        <a href="UserManagement.html">
                            <li class=""><i class="iconfont icon-yonghuguanli"></i><span>用户管理</span></li>
                        </a>
                        <a href="SelectTicket.aspx">
                            <li class="Select"><i class="iconfont icon-tubiao_dingdan"></i><span>票务查询</span></li>
                        </a>
                        <a href="MyOrder.aspx">
                            <li><i class="iconfont icon-fenlei"></i><span>我的订单</span></li>
                        </a>
                        <a href="ProductManagement.html">
                            <li><i class="iconfont icon-weibiaoti1"></i><span>留言板</span></li>
                        </a>
                        <a href="ProductManagement.html">
                            <li><i class="iconfont icon-xinxiliulan"></i><span>信息浏览</span></li>
                        </a>
                    </ul>
                </div>
                <!--右侧-->
                <div class="RightBox">
                    <div class="PublicContentBox">
                        <!--公用指向页面名字-->
                        <div class="PublicPointToAgeText">
                            <span class="span1">客车网上售票系统  </span><span class="span2">票务查询</span>
                        </div>
                        <!--表修改-->
                        <div class="auto-style1" style="margin-left: 0px; height: 700px;">
    
                            <!--查询到的表格-->
                            <div style="810px;margin-left:10px; ">
                                <table class="auto-style3" id="ts">
                                    <tr style="background-color: #fe7844; height: 30px; color: #fff; text-align: left;">
                                        <td colspan="6">&nbsp;&nbsp;订单统计</td>
                                    </tr>
                                    <tr style="font-weight:bolder;">
                                        <td class="auto-style4">
                                            车次名称
                                        </td>
                                        <td class="auto-style4">
                                            出发地
                                        </td>
                                        <td class="auto-style4">
                                            目的地
                                        </td>
                                        <td class="auto-style4">
                                            出发日期
                                        </td>
                                        <td class="auto-style4">
                                            出发时间
                                        </td>
                                        <td class="auto-style4">
                                            订单数
                                        </td>
                                    </tr>
                                    <tr>
                                        <td class="auto-style4">
                                            <asp:Label ID="lblTname" runat="server" Text="Label"></asp:Label>
                                        </td>
                                        <td class="auto-style4">
                                            <asp:Label ID="lblBegin_sta" runat="server" Text="Label"></asp:Label>
                                        <td class="auto-style4">
                                            <asp:Label ID="lblEnd_sta" runat="server" Text="Label"></asp:Label>
                                        </td>
                                        <td class="auto-style4">
                                            <asp:Label ID="lblStart_date" runat="server" Text="Label"></asp:Label>
                                        </td>
                                         <td class="auto-style4">
                                            <asp:Label ID="lblStart_time" runat="server" Text="Label"></asp:Label>
                                        </td>
                                         <td class="auto-style4">
                                            <asp:Label ID="lblCount" runat="server" Text="Label"></asp:Label>
                                        </td>
                                    </tr>
                                </table>                          
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </form>
    </body>
    </html>

    (3)订单统计后台页面代码

    public partial class OrderStatistics : System.Web.UI.Page
        {
            OrderinfoManager bll = new OrderinfoManager();
            protected void Page_Load(object sender, EventArgs e)
            {
                if (!IsPostBack)
                {
                    DataSet ds = bll.GetData();
                    for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                    {
                        this.lblTname.Text = ds.Tables[0].Rows[0]["Tname"].ToString();
                        this.lblBegin_sta.Text = ds.Tables[0].Rows[0]["Begin_sta"].ToString();
                        this.lblEnd_sta.Text = ds.Tables[0].Rows[0]["End_sta"].ToString();
                        this.lblStart_date.Text = ds.Tables[0].Rows[0]["Start_date"].ToString();
                        this.lblStart_time.Text = ds.Tables[0].Rows[0]["Start_time"].ToString();
                        this.lblCount.Text = ds.Tables[0].Rows[0][5].ToString();
                    }               
                }
            }
        }
    DAL层:
      public DataSet GetData()
            {
                string sql = $"select Tname,Begin_sta,End_sta,Start_date,Start_time, COUNT(*) from Traininfo inner join Carinfo on Traininfo.Tid=Carinfo.Tid inner join Orderinfo on Carinfo.Cid=Orderinfo.Cid group by Tname,Begin_sta,End_sta,Start_date,Start_time";
                return dbHelper.GetData(sql);
            }

    3、遇到的问题:
    (1)涉及到多表联查
    (2)很多想实现的效果因为能力有限没办法实现,需要前端技术
    4、解决的方法:
    (2)技术能力方面需要利用这个暑假做提升
    5、项目燃尽图更新(此内容一周已更新)

  • 相关阅读:
    《怎樣面對2016?》
    Linux文件系统与磁盘管理
    Linux 引用
    Linux—read
    MySQL 多表查询
    Linux Shell_test
    Linux_C——动态库,静态库
    Linux 文本编辑
    Linux —— 查找与替换
    Linux 正则表达式
  • 原文地址:https://www.cnblogs.com/hpjy/p/13462197.html
Copyright © 2020-2023  润新知