123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184 |
- @using Bowin.Web.Controls.Mvc;
- @using EMIS.Web.Controls;
- @{
- ViewBag.Title = "StusdentStatistical";
- ComboGridOptions Psop = new ComboGridOptions
- {
- TextField = "UnitName",
- ValueField = "PublishID",
- ID = "PublishDropdown",
- Name = "PublishDropdown",
- OnSelect = "QueryPublishDropdownList",
- GridOptions = new DataGridOptions
- {
- Columns = new List<DataGridColumn>()
- {
- // new BoundFieldColumn { FieldName="UnitCode", HeaderText="单位编号", Align=AlignStyle.Center },
- new BoundFieldColumn { FieldName="UnitName", HeaderText="出版单位", Align=AlignStyle.Center }
- },
- IsCheckOnSelect = true,
- DataSourceUrl = Url.Content("~/Publisher/List"),
- IsPagination = true,
- IsShowRowNumbers = true,
- IsSingleSelect = false
- }
- };
- ComboGridOptions Csop = new ComboGridOptions
- {
- TextField = "CourseName",
- ValueField = "CoursematerialID",
- ID = "CourseDropdown",
- Name = "CourseDropdown",
- OnSelect = "QueryCourseDropdownList",
- GridOptions = new DataGridOptions
- {
- Columns = new List<DataGridColumn>()
- {
- // new LinkButtonColumn { FieldName="CourseCode", HeaderText="课程代码", Align=AlignStyle.Center },
- new BoundFieldColumn { FieldName="CourseName", HeaderText="课程名称", Align=AlignStyle.Center }
- },
- IsCheckOnSelect = true,
- DataSourceUrl = Url.Content("~/Coursematerial/ListForDropdown"),
- IsPagination = true,
- IsShowRowNumbers = true,
- IsSingleSelect = false
- }
- };
- ComboGridOptions MaterialCode = new ComboGridOptions
- {
- TextField = "TeachingMaterialName",
- ValueField = "TeachingMaterialPoolID",
- ID = "TeachingMaterialDropdown",
- Name = "TeachingMaterialDropdown",
- OnSelect = "QueryTeachingMaterialDropdownList",
- GridOptions = new DataGridOptions
- {
- Columns = new List<DataGridColumn>()
- {
- // new BoundFieldColumn { FieldName="TeachingMaterialCode", HeaderText="教材编号", Align=AlignStyle.Center },
- new BoundFieldColumn { FieldName="TeachingMaterialName", HeaderText="教材名称", Align=AlignStyle.Center }
- },
- IsCheckOnSelect = true,
- DataSourceUrl = Url.Content("~/TeachingMaterialPool/List"),
- IsPagination = true,
- IsShowRowNumbers = true,
- IsSingleSelect = false
- }
- };
- ComboGridOptions cgop = new ComboGridOptions
- {
- TextField = "Name",
- ValueField = "GrademajorID",
- OnSelect = "QueryGrademajorDropdownList",
- ID = "GrademajorDropdown",
- Name = "GrademajorDropdown",
- GridOptions = new DataGridOptions
- {
- Columns = new List<DataGridColumn>()
- {
- //new BoundFieldColumn { FieldName="Code", HeaderText="年级专业代码", Align=AlignStyle.Center },
- new BoundFieldColumn { FieldName="Name", HeaderText="年级专业名称", Align=AlignStyle.Center }
- },
- IsCheckOnSelect = true,
- DataSourceUrl = Url.Content("~/Grademajor/List"),
- IsPagination = true,
- IsShowRowNumbers = true,
- IsSingleSelect = false,
- }
- };
- }
- @section scripts{
- <script src="../../Scripts/Business/TeachingMaterial/StusdentStatistical.js" type="text/javascript"></script>
- }
- <div class="easyui-panel" data-options="border:false,fit:true" style="position: relative;">
- @Html.Position()
- <div class="p_SearchTitle">
- <div style="float: left; margin-left: 10px; font-size: 12px; line-height: 30px;">
- 查询条件</div>
- </div>
- <form id="formStatisticalQuery" method="post" action="@Url.Content("~/StudentsOrder/StatisticalExcel")">
- @Html.PositionCondition("StusdentStatisticalList")
- <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 = "SchoolYearDropdown", Name = "SchoolYearDropdown", SelectedValue = BaseExtensions.GetCurrentSchoolYearID(), OnSelect = "QuerySchoolYearDropdownList" }, new Dictionary<string, string> { { "data-condition", "dgStusdentStatistical" } })
- </li>
- @* <li class="sn" style="padding-left: 5px;">@EMIS.Utility.RSL.Get("Campus"):</li>
- <li class="sv">
- @Html.DropdownList(new DropdownListOptions { BindType = DropdownListBindType.SelectAll, ItemSourceUrl = Url.Content("~/Campus/CampusDropdownListBanid"), ID = "CampusDropdown", Name = "CampusDropdown", OnSelect = "QueryCampusDropdownList" }, new Dictionary<string, string> { { "data-condition", "dgStusdentStatistical" } })
- </li>*@
- <li class="sn" style="padding-left: 5px;">@EMIS.Utility.RSL.Get("College"):</li>
- <li class="sv">
- @Html.DropdownList(new DropdownListOptions { BindType = DropdownListBindType.SelectAll, ItemSourceUrl = Url.Content("~/College/CollegeDropdownListOnlyCollege"), ID = "CollegeDropdown", Name = "CollegeDropdown", OnSelect = "QueryCollegeDropdownList" }, new Dictionary<string, string> { { "data-condition", "dgStusdentStatistical" } })
- </li>
- <li class="sn" style="padding-left: 5px;">年级专业:</li>
- <li class="sv">
- @Html.ComboGrid(cgop, new Dictionary<string, string> { { "data-condition", "dgStusdentStatistical" } })
- </li>
- </ul>
- <ul>
- <li class="sn" style="padding-left: 5px;">教材名称:</li>
- <li class="sv">
- @Html.ComboGrid(MaterialCode, new Dictionary<string, string> { { "data-condition", "dgStusdentStatistical" } })
- </li>
- <li class="sn" style="padding-left: 5px;">课程名称:</li>
- <li class="sv">
- @Html.ComboGrid(Csop, new Dictionary<string, string> { { "data-condition", "dgStusdentStatistical" } })
- </li>
- <li class="sn" style="padding-left: 5px;">出版单位:</li>
- <li class="sv">
- @Html.ComboGrid(Psop, new Dictionary<string, string> { { "data-condition", "dgStusdentStatistical" } })
- </li>
- </ul>
- </div>
- </div>
- </form>
- <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("StusdentStatisticalList")</div>
- </div>
- <div class="search_list">
- @Html.DataGrid(new DataGridOptions
- {
- Columns = new List<DataGridColumn>()
- {
- new BoundFieldColumn { FieldName="SchoolyearCode", HeaderText="学年学期", Align=AlignStyle.Center,Width=0.06 },
- new BoundFieldColumn { FieldName="CollegeName", HeaderText=@EMIS.Utility.RSL.Get("College"), Align=AlignStyle.Center,Width=0.08 },
- new BoundFieldColumn { FieldName="GrademajorName", HeaderText="年级专业", Align=AlignStyle.Center, Width=0.1 },
- new BoundFieldColumn { FieldName="TeachingMaterialCode", HeaderText="教材编号", Align=AlignStyle.Center, Width=0.06},
- new BoundFieldColumn { FieldName="TeachingMaterialName", HeaderText="教材名称", Align=AlignStyle.Center, Width=0.1 },
- new BoundFieldColumn { FieldName="CourseCode", HeaderText="课程代码", Align=AlignStyle.Center, Width=0.06 },
- new BoundFieldColumn { FieldName="CourseName", HeaderText="课程名称", Align=AlignStyle.Center, Width=0.1 },
- //new BoundFieldColumn { FieldName="ISBN", HeaderText="ISBN", Align=AlignStyle.Center, Width=0.08 },
- //new BoundFieldColumn { FieldName="PublishTime", HeaderText="版本时间",Width=0.06},
- //new BoundFieldColumn { FieldName="PublishName", HeaderText="出版单位", Align=AlignStyle.Center,Width=0.08 },
- //new BoundFieldColumn { FieldName="Author", HeaderText="作者", Align=AlignStyle.Center, Width=0.03, OverflowLength=4 },
- new BoundFieldColumn { FieldName="Price", HeaderText="单价(¥)", Align=AlignStyle.Center,Width=0.03 },
- new BoundFieldColumn { FieldName="ClassNum", HeaderText="人数", Align=AlignStyle.Center ,Width=0.02},
- new BoundFieldColumn { FieldName="OrderQty", HeaderText="征订数量", Align=AlignStyle.Center,Width=0.04 },
- new BoundFieldColumn { FieldName="PreIncreaseQty", HeaderText="增加数量", Align=AlignStyle.Center,Width=0.04 },
- new BoundFieldColumn { FieldName="Count", HeaderText="总数量", Align=AlignStyle.Center, Width=0.03 }
- },
- IsCheckOnSelect = true,
- DataSourceUrl = Url.Content("~/StudentsOrder/StusdentStatisticalList"),
- ID = "dgStusdentStatistical",
- IsPagination = true,
- IsShowRowNumbers = true,
- IsSingleSelect = false
- })
- </div>
- </div>
|