StusdentStatisticalList.cshtml 9.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184
  1. @using Bowin.Web.Controls.Mvc;
  2. @using EMIS.Web.Controls;
  3. @{
  4. ViewBag.Title = "StusdentStatistical";
  5. ComboGridOptions Psop = new ComboGridOptions
  6. {
  7. TextField = "UnitName",
  8. ValueField = "PublishID",
  9. ID = "PublishDropdown",
  10. Name = "PublishDropdown",
  11. OnSelect = "QueryPublishDropdownList",
  12. GridOptions = new DataGridOptions
  13. {
  14. Columns = new List<DataGridColumn>()
  15. {
  16. // new BoundFieldColumn { FieldName="UnitCode", HeaderText="单位编号", Align=AlignStyle.Center },
  17. new BoundFieldColumn { FieldName="UnitName", HeaderText="出版单位", Align=AlignStyle.Center }
  18. },
  19. IsCheckOnSelect = true,
  20. DataSourceUrl = Url.Content("~/Publisher/List"),
  21. IsPagination = true,
  22. IsShowRowNumbers = true,
  23. IsSingleSelect = false
  24. }
  25. };
  26. ComboGridOptions Csop = new ComboGridOptions
  27. {
  28. TextField = "CourseName",
  29. ValueField = "CoursematerialID",
  30. ID = "CourseDropdown",
  31. Name = "CourseDropdown",
  32. OnSelect = "QueryCourseDropdownList",
  33. GridOptions = new DataGridOptions
  34. {
  35. Columns = new List<DataGridColumn>()
  36. {
  37. // new LinkButtonColumn { FieldName="CourseCode", HeaderText="课程代码", Align=AlignStyle.Center },
  38. new BoundFieldColumn { FieldName="CourseName", HeaderText="课程名称", Align=AlignStyle.Center }
  39. },
  40. IsCheckOnSelect = true,
  41. DataSourceUrl = Url.Content("~/Coursematerial/ListForDropdown"),
  42. IsPagination = true,
  43. IsShowRowNumbers = true,
  44. IsSingleSelect = false
  45. }
  46. };
  47. ComboGridOptions MaterialCode = new ComboGridOptions
  48. {
  49. TextField = "TeachingMaterialName",
  50. ValueField = "TeachingMaterialPoolID",
  51. ID = "TeachingMaterialDropdown",
  52. Name = "TeachingMaterialDropdown",
  53. OnSelect = "QueryTeachingMaterialDropdownList",
  54. GridOptions = new DataGridOptions
  55. {
  56. Columns = new List<DataGridColumn>()
  57. {
  58. // new BoundFieldColumn { FieldName="TeachingMaterialCode", HeaderText="教材编号", Align=AlignStyle.Center },
  59. new BoundFieldColumn { FieldName="TeachingMaterialName", HeaderText="教材名称", Align=AlignStyle.Center }
  60. },
  61. IsCheckOnSelect = true,
  62. DataSourceUrl = Url.Content("~/TeachingMaterialPool/List"),
  63. IsPagination = true,
  64. IsShowRowNumbers = true,
  65. IsSingleSelect = false
  66. }
  67. };
  68. ComboGridOptions cgop = new ComboGridOptions
  69. {
  70. TextField = "Name",
  71. ValueField = "GrademajorID",
  72. OnSelect = "QueryGrademajorDropdownList",
  73. ID = "GrademajorDropdown",
  74. Name = "GrademajorDropdown",
  75. GridOptions = new DataGridOptions
  76. {
  77. Columns = new List<DataGridColumn>()
  78. {
  79. //new BoundFieldColumn { FieldName="Code", HeaderText="年级专业代码", Align=AlignStyle.Center },
  80. new BoundFieldColumn { FieldName="Name", HeaderText="年级专业名称", Align=AlignStyle.Center }
  81. },
  82. IsCheckOnSelect = true,
  83. DataSourceUrl = Url.Content("~/Grademajor/List"),
  84. IsPagination = true,
  85. IsShowRowNumbers = true,
  86. IsSingleSelect = false,
  87. }
  88. };
  89. }
  90. @section scripts{
  91. <script src="../../Scripts/Business/TeachingMaterial/StusdentStatistical.js" type="text/javascript"></script>
  92. }
  93. <div class="easyui-panel" data-options="border:false,fit:true" style="position: relative;">
  94. @Html.Position()
  95. <div class="p_SearchTitle">
  96. <div style="float: left; margin-left: 10px; font-size: 12px; line-height: 30px;">
  97. 查询条件</div>
  98. </div>
  99. <form id="formStatisticalQuery" method="post" action="@Url.Content("~/StudentsOrder/StatisticalExcel")">
  100. @Html.PositionCondition("StusdentStatisticalList")
  101. <div class="search_keyword">
  102. <div class="search_input">
  103. <ul>
  104. <li class="sn" style="padding-left: 5px;">学年学期:</li>
  105. <li class="sv">
  106. @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" } })
  107. </li>
  108. @* <li class="sn" style="padding-left: 5px;">@EMIS.Utility.RSL.Get("Campus"):</li>
  109. <li class="sv">
  110. @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" } })
  111. </li>*@
  112. <li class="sn" style="padding-left: 5px;">@EMIS.Utility.RSL.Get("College"):</li>
  113. <li class="sv">
  114. @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" } })
  115. </li>
  116. <li class="sn" style="padding-left: 5px;">年级专业:</li>
  117. <li class="sv">
  118. @Html.ComboGrid(cgop, new Dictionary<string, string> { { "data-condition", "dgStusdentStatistical" } })
  119. </li>
  120. </ul>
  121. <ul>
  122. <li class="sn" style="padding-left: 5px;">教材名称:</li>
  123. <li class="sv">
  124. @Html.ComboGrid(MaterialCode, new Dictionary<string, string> { { "data-condition", "dgStusdentStatistical" } })
  125. </li>
  126. <li class="sn" style="padding-left: 5px;">课程名称:</li>
  127. <li class="sv">
  128. @Html.ComboGrid(Csop, new Dictionary<string, string> { { "data-condition", "dgStusdentStatistical" } })
  129. </li>
  130. <li class="sn" style="padding-left: 5px;">出版单位:</li>
  131. <li class="sv">
  132. @Html.ComboGrid(Psop, new Dictionary<string, string> { { "data-condition", "dgStusdentStatistical" } })
  133. </li>
  134. </ul>
  135. </div>
  136. </div>
  137. </form>
  138. <div class="p_title">
  139. <div style="float: left; margin-left: 10px; line-height: 30px; font-size: 12px;">
  140. 学生征订统计列表</div>
  141. <div style="margin-right: 10px; line-height: 30px; font-size: 12px;">@Html.ContextMenuBar("StusdentStatisticalList")</div>
  142. </div>
  143. <div class="search_list">
  144. @Html.DataGrid(new DataGridOptions
  145. {
  146. Columns = new List<DataGridColumn>()
  147. {
  148. new BoundFieldColumn { FieldName="SchoolyearCode", HeaderText="学年学期", Align=AlignStyle.Center,Width=0.06 },
  149. new BoundFieldColumn { FieldName="CollegeName", HeaderText=@EMIS.Utility.RSL.Get("College"), Align=AlignStyle.Center,Width=0.08 },
  150. new BoundFieldColumn { FieldName="GrademajorName", HeaderText="年级专业", Align=AlignStyle.Center, Width=0.1 },
  151. new BoundFieldColumn { FieldName="TeachingMaterialCode", HeaderText="教材编号", Align=AlignStyle.Center, Width=0.06},
  152. new BoundFieldColumn { FieldName="TeachingMaterialName", HeaderText="教材名称", Align=AlignStyle.Center, Width=0.1 },
  153. new BoundFieldColumn { FieldName="CourseCode", HeaderText="课程代码", Align=AlignStyle.Center, Width=0.06 },
  154. new BoundFieldColumn { FieldName="CourseName", HeaderText="课程名称", Align=AlignStyle.Center, Width=0.1 },
  155. //new BoundFieldColumn { FieldName="ISBN", HeaderText="ISBN", Align=AlignStyle.Center, Width=0.08 },
  156. //new BoundFieldColumn { FieldName="PublishTime", HeaderText="版本时间",Width=0.06},
  157. //new BoundFieldColumn { FieldName="PublishName", HeaderText="出版单位", Align=AlignStyle.Center,Width=0.08 },
  158. //new BoundFieldColumn { FieldName="Author", HeaderText="作者", Align=AlignStyle.Center, Width=0.03, OverflowLength=4 },
  159. new BoundFieldColumn { FieldName="Price", HeaderText="单价(¥)", Align=AlignStyle.Center,Width=0.03 },
  160. new BoundFieldColumn { FieldName="ClassNum", HeaderText="人数", Align=AlignStyle.Center ,Width=0.02},
  161. new BoundFieldColumn { FieldName="OrderQty", HeaderText="征订数量", Align=AlignStyle.Center,Width=0.04 },
  162. new BoundFieldColumn { FieldName="PreIncreaseQty", HeaderText="增加数量", Align=AlignStyle.Center,Width=0.04 },
  163. new BoundFieldColumn { FieldName="Count", HeaderText="总数量", Align=AlignStyle.Center, Width=0.03 }
  164. },
  165. IsCheckOnSelect = true,
  166. DataSourceUrl = Url.Content("~/StudentsOrder/StusdentStatisticalList"),
  167. ID = "dgStusdentStatistical",
  168. IsPagination = true,
  169. IsShowRowNumbers = true,
  170. IsSingleSelect = false
  171. })
  172. </div>
  173. </div>