@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>