LIOT/EMIS.Web/Views/StudentFee/ClassStatisticList.cshtml

@using Bowin.Web.Controls.Mvc;
@using EMIS.Entities;
@using EMIS.Web.Controls;
@{
    ViewBag.Title = "ClassStatisticList";

    ComboGridOptions cgopExaminationBatch = new ComboGridOptions
    {
        TextField = "Name",
        ValueField = "ExaminationBatchID",
        ID = "cgExaminationBatch",
        Name = "cgExaminationBatch",
        OnSelect = "queryBatch",
        //IsEnabled = false,
        GridOptions = new DataGridOptions
        {
            Columns = new List<DataGridColumn>()
            {
                new BoundFieldColumn { FieldName="Name", HeaderText="考试批次", Align=AlignStyle.Center, Width = 0.3 }
            },
            IsCheckOnSelect = true,
            DataSourceUrl = Url.Content("~/ExaminationApplayStudentList/GetExaminationBatchViewGrid"),
            IsPagination = true,
            IsShowRowNumbers = true,
            IsSingleSelect = false,
            //OnLoadSuccessFun = "queryBatch",
        }
    };

    ComboGridOptions cgopExaminationType = new ComboGridOptions
    {
        TextField = "Name",
        ValueField = "ExaminationTypeID",
        Name = "cgExaminationType",
        ID = "cgExaminationType",
        OnSelect = "queryType",
        //IsEnabled = false,
        GridOptions = new DataGridOptions
        {
            Columns = new List<DataGridColumn>()
            {
                new BoundFieldColumn { FieldName="Name", HeaderText="考试类型", Align=AlignStyle.Center, Width = 0.3 }
            },

            IsCheckOnSelect = true,
            DataSourceUrl = Url.Content("~/ExaminationApplayStudentList/GetExaminationTypeViewGrid"),
            IsPagination = true,
            IsShowRowNumbers = true,
            IsSingleSelect = false,
            //OnLoadSuccessFun = "queryType",
        }
    };

    ComboGridOptions cgopExaminationProject = new ComboGridOptions
    {
        TextField = "Name",
        ValueField = "ExaminationProjectID",
        Name = "cgExaminationProject",
        ID = "cgExaminationProject",
        //OnSelect = "reload",
        //IsEnabled = false,
        GridOptions = new DataGridOptions
        {
            Columns = new List<DataGridColumn>()
            {
                new BoundFieldColumn { FieldName="Name", HeaderText="项目名称", Align=AlignStyle.Center, Width = 0.3 }
            },

            IsCheckOnSelect = true,
            DataSourceUrl = Url.Content("~/ExaminationApplayStudentList/GetProjectListViewGrid"),
            IsPagination = true,
            IsShowRowNumbers = true,
            IsSingleSelect = false,
            //OnLoadSuccessFun = "queryProject",
        }
    };
}
@section scripts{
    <script src="~/Scripts/Business/StudentFeeManage/ClassStatistic.js" type="text/javascript"></script>
    <script type="text/javascript">
        var nonSelect = "@DropdownList.SELECT_ALL";
    </script>
}
<div class="easyui-panel" data-options="border:false,fit:true" style="position: relative;">
    @Html.Position()
    <form id="formQuery" method="post" action="@Url.Content("~/StudentFee/ClassStatisticExcel")">
        <div class="search_keyword">
            <div class="search_input">
                <ul>
                    <li class="sn" style="padding-left: 5px;">学年学期：</li>
                    <li class="sv">
                        @Html.DropdownList(new DropdownListOptions { BindType = DropdownListBindType.SelectAll, ItemSourceUrl = Url.Content("~/SchoolYear/DropDown"), ID = "ddlSchoolyear", Name = "ddlSchoolyear", OnSelect = "querySchoolYear", SelectedValue = BaseExtensions.GetCurrentSchoolYearID() }, new Dictionary<string, string> { { "data-condition", "dgStudentFeeClassStatisticList" } })
                    </li>
                    <li class="sn" style="padding-left: 5px;">考试批次：</li>
                    <li class="sv">
                        @Html.ComboGrid(cgopExaminationBatch, new Dictionary<string, string> { { "data-condition", "dgStudentFeeClassStatisticList" } })
                    </li>
                    <li class="sn" style="padding-left: 5px;">考试类型：</li>
                    <li class="sv">
                        @Html.ComboGrid(cgopExaminationType, new Dictionary<string, string> { { "data-condition", "dgStudentFeeClassStatisticList" } })
                    </li>
                    <li class="sn" style="padding-left: 5px;">项目名称：</li>
                    <li class="sv">
                        @Html.ComboGrid(cgopExaminationProject, new Dictionary<string, string> { { "data-condition", "dgStudentFeeClassStatisticList" } })
                    </li>
                </ul>
                @*<ul>
                    <li class="sn" style="padding-left: 5px;">学年学期：</li>
                    <li class="sv">
                        @Html.DropdownList(new DropdownListOptions
                   {
                       BindType = DropdownListBindType.SelectAll,
                       ItemSourceUrl = Url.Content("~/SchoolYear/DropDown"),
                       ID = "ddlSchoolyear",
                       Name = "ddlSchoolyear",
                       OnSelect = "schoolyearChange",
                       SelectedValue = BaseExtensions.GetCurrentSchoolYearID(),
                       OnLoadSuccess = "schoolyearChange"
                   },
                            new Dictionary<string, string> { { "data-condition", "dgStudentFeeClassStatisticList" } })
                    </li>
                    <li class="sn" style="padding-left: 5px;">考试批次：</li>
                    <li class="sv">
                        @Html.DropdownList(new DropdownListOptions
                   {
                       BindType = DropdownListBindType.SelectAll,
                       ID = "ddlExaminationBatch",
                       Name = "ddlExaminationBatch",
                       OnSelect = "examinationBatchChange",
                       OnLoadSuccess = "examinationBatchChange"
                   },
                            new Dictionary<string, string> { { "data-condition", "dgStudentFeeClassStatisticList" } })
                    </li>
                    <li class="sn" style="padding-left: 5px;">考试类型：</li>
                    <li class="sv">
                        @Html.DropdownList(new DropdownListOptions
                   {
                       BindType = DropdownListBindType.SelectAll,
                       ID = "ddlExaminationType",
                       Name = "ddlExaminationType",
                       OnSelect = "examinationTypeChange",
                       OnLoadSuccess = "examinationTypeChange"
                   },
                            new Dictionary<string, string> { { "data-condition", "dgStudentFeeClassStatisticList" } })
                    </li>
                    <li class="sn" style="padding-left: 5px;">项目名称：</li>
                    <li class="sv">
                        @Html.DropdownList(new DropdownListOptions
                   {
                       BindType = DropdownListBindType.SelectAll,
                       ID = "ddlExaminationProject",
                       Name = "ddlExaminationProject",
                       OnSelect = "reload",
                       OnLoadSuccess = "examinationProjectLoaded"
                   },
                            new Dictionary<string, string> { { "data-condition", "dgStudentFeeClassStatisticList" } })
                    </li>
                </ul>*@
                <ul>
                    <li class="sn" style="padding-left: 5px;">@EMIS.Utility.RSL.Get("College")：</li>
                    <li class="sv">
                        @Html.DropdownList(new DropdownListOptions
                   {
                       BindType = DropdownListBindType.SelectAll,
                       ID = "ddlCollege",
                       Name = "ddlCollege",
                       OnSelect = "collegeSelect",
                       OnLoadSuccess = "collegeChange"
                   },
                            new Dictionary<string, string> { { "data-condition", "dgStudentFeeClassStatisticList" } })
                    </li>
                    <li class="sn" style="padding-left: 5px;">年级：</li>
                    <li class="sv">
                        @Html.SchoolYearDropDownList(new DropdownListOptions { BindType = DropdownListBindType.SelectAll, ID = "ddlYear", Name = "ddlYear", OnSelect = "collegeSelect" }, new Dictionary<string, string> { { "data-condition", "dgStudentFeeClassStatisticList" } })
                    </li>
                    <li class="sn" style="padding-left: 5px;">专业：</li>
                    <li class="sv">
                        @Html.ComboGrid(new ComboGridOptions
                   {
                       GridOptions = new DataGridOptions
                       {
                           Columns = new List<DataGridColumn>()
                                {
                                    new BoundFieldColumn { FieldName="StandardName", HeaderText="专业", Align=AlignStyle.Center }
                                },
                           //OnLoadSuccessFun = "standardChange",
                           IsAutoLoad = true,
                           DataSourceUrl = Url.Content("~/Grademajor/StandardList"),
                           IsPagination = true
                       },
                       TextField = "StandardName",
                       ValueField = "StandardID",
                       Name = "cgbStandard",
                       ID = "cgbStandard",
                       OnSelect = "standardSelect"
                   },
                        new Dictionary<string, string> { { "data-condition", "dgStudentFeeClassStatisticList" } })
                    </li>
                    <li class="sn" style="padding-left: 5px;">班级：</li>
                    <li class="sv">
                        @Html.ComboGrid(new ComboGridOptions
                   {
                       TextField = "Name",
                       ValueField = "ClassmajorID",
                       Name = "cgbClassmajor",
                       ID = "cgbClassmajor",
                       OnSelect = "reload",
                       GridOptions = new DataGridOptions
                       {
                           Columns = new List<DataGridColumn>()
                                {
                                    new BoundFieldColumn { FieldName="Name", HeaderText="班级名称", Align=AlignStyle.Center }
                                },
                           IsAutoLoad = true,
                           DataSourceUrl = Url.Content("~/Classmajor/List"),
                           IsPagination = true
                       }
                   },
                        new Dictionary<string, string> { { "data-condition", "dgStudentFeeClassStatisticList" } })
                    </li>
                    <li class="sv">
                        <a class="easyui-linkbutton  l-btn" onclick="reload()" href="#;" data-options="iconCls:'icon-search'">
                            查询
                        </a>
                    </li>
                </ul>
            </div>
        </div>
        <div class="p_title">
            <div style="float: left; margin-left: 10px; line-height: 30px; font-size: 12px;">
                查看项目报名汇总
            </div>
            <div style="margin-right: 10px; line-height: 30px; font-size: 12px;">@Html.ContextMenuBar("List")</div>
        </div>
    </form>
    <div class="search_list">
        @Html.DataGrid(new DataGridOptions
   {
       Columns = new List<DataGridColumn>()
            {
                new BoundFieldColumn { FieldName="Year", HeaderText="年级", Align=AlignStyle.Center },
                new BoundFieldColumn { FieldName="CollegeName", HeaderText="院/系/部", Align=AlignStyle.Center },
                new BoundFieldColumn { FieldName="ClassmajorName", HeaderText="班级", Align=AlignStyle.Center },
                new BoundFieldColumn { FieldName="ExaminationTypeName", HeaderText="考试类型", Align=AlignStyle.Center },
                new BoundFieldColumn { FieldName="ExaminationProjectName", HeaderText="考试项目", Align=AlignStyle.Center },
                new BoundFieldColumn { FieldName="FeeTypeName", HeaderText="报名项目（费用）", Align=AlignStyle.Center },
                new BoundFieldColumn { FieldName="TotalRegistCount", HeaderText="报名人数", Align=AlignStyle.Center },
                new BoundFieldColumn { FieldName="TotalRegistAmount", HeaderText="总金额", Align=AlignStyle.Center, CustomFormatFun="CMSFunction.DataTableFormatter.TwoDigit" },
                new BoundFieldColumn { FieldName="TotalPaidCount", HeaderText="已交费人数", Align=AlignStyle.Center },
                new BoundFieldColumn { FieldName="TotalPaidAmount", HeaderText="已交费金额", Align=AlignStyle.Center, CustomFormatFun="CMSFunction.DataTableFormatter.TwoDigit" },
                new BoundFieldColumn { FieldName="TotalRefundCount", HeaderText="已退费人数", Align=AlignStyle.Center },
                new BoundFieldColumn { FieldName="TotalRefundAmount", HeaderText="已退费金额", Align=AlignStyle.Center, CustomFormatFun="CMSFunction.DataTableFormatter.TwoDigit" },
                new BoundFieldColumn { FieldName="TotalRefundApplyCount", HeaderText="退费申请人数", Align=AlignStyle.Center },
                new BoundFieldColumn { FieldName="TotalRefundApplyAmount", HeaderText="退费申请金额", Align=AlignStyle.Center, CustomFormatFun="CMSFunction.DataTableFormatter.TwoDigit" },
                new BoundFieldColumn { FieldName="TotalRefundingCount", HeaderText="待退费人数", Align=AlignStyle.Center },
                new BoundFieldColumn { FieldName="TotalRefundingAmount", HeaderText="待退费金额", Align=AlignStyle.Center, CustomFormatFun="CMSFunction.DataTableFormatter.TwoDigit" },
            },
       IsAutoLoad = false,
       DataSourceUrl = Url.Content("~/StudentFee/ClassStatisticList"),
       OnLoadSuccessFun = "gridLoaded",
       ID = "dgStudentFeeClassStatisticList",
       IsPagination = false
   })
    </div>
</div>