List.cshtml 18 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337
  1. @using Bowin.Web.Controls.Mvc;
  2. @using EMIS.Web.Controls;
  3. @{
  4. ViewBag.Title = "List";
  5. //校区
  6. ComboGridOptions cgopCampus = new ComboGridOptions
  7. {
  8. TextField = "Name",
  9. ValueField = "CampusID",
  10. ID = "CampusDropdown",
  11. Name = "CampusDropdown",
  12. OnSelect = "queryCampus",
  13. GridOptions = new DataGridOptions
  14. {
  15. Columns = new List<DataGridColumn>()
  16. {
  17. //new LinkButtonColumn { FieldName="No", HeaderText=@EMIS.Utility.RSL.Get("CampusCode"), Align=AlignStyle.Center, Width=0.1 },
  18. new BoundFieldColumn { FieldName="Name", HeaderText=@EMIS.Utility.RSL.Get("CampusName"), Align=AlignStyle.Center, Width=0.12 }
  19. },
  20. IsCheckOnSelect = true,
  21. DataSourceUrl = Url.Content("~/Campus/List"),
  22. IsPagination = true,
  23. IsShowRowNumbers = true,
  24. IsSingleSelect = false,
  25. }
  26. };
  27. //院系所
  28. ComboGridOptions cgopCollege = new ComboGridOptions
  29. {
  30. TextField = "Name",
  31. ValueField = "CollegeID",
  32. ID = "CollegeDropdown",
  33. Name = "CollegeDropdown",
  34. OnSelect = "queryCollege",
  35. GridOptions = new DataGridOptions
  36. {
  37. Columns = new List<DataGridColumn>()
  38. {
  39. //new LinkButtonColumn { FieldName="No", HeaderText=@EMIS.Utility.RSL.Get("CollegeCode"), Align=AlignStyle.Center, Width=0.1 },
  40. new BoundFieldColumn { FieldName="Name", HeaderText=@EMIS.Utility.RSL.Get("CollegeName"), Align=AlignStyle.Center, Width=0.2 }
  41. },
  42. IsCheckOnSelect = true,
  43. DataSourceUrl = Url.Content("~/College/ListOnlyCollege"),
  44. IsPagination = true,
  45. IsShowRowNumbers = true,
  46. IsSingleSelect = false,
  47. }
  48. };
  49. //年级
  50. ComboGridOptions cgopGrade = new ComboGridOptions
  51. {
  52. TextField = "GradeID",
  53. ValueField = "GradeID",
  54. ID = "DictionaryGrade",
  55. Name = "DictionaryGrade",
  56. OnSelect = "queryGrade",
  57. GridOptions = new DataGridOptions
  58. {
  59. Columns = new List<DataGridColumn>()
  60. {
  61. new BoundFieldColumn { FieldName="GradeID", HeaderText="年级", Align=AlignStyle.Center, Width=0.1 }
  62. },
  63. IsCheckOnSelect = true,
  64. DataSourceUrl = Url.Content("~/Grademajor/GradeBindComboGridOptions"),
  65. IsPagination = true,
  66. IsShowRowNumbers = true,
  67. IsSingleSelect = false,
  68. }
  69. };
  70. //专业名称
  71. ComboGridOptions cgopStandard = new ComboGridOptions
  72. {
  73. TextField = "StandardName",
  74. ValueField = "StandardID",
  75. ID = "DictionaryStandard",
  76. Name = "DictionaryStandard",
  77. OnSelect = "queryStandard",
  78. GridOptions = new DataGridOptions
  79. {
  80. Columns = new List<DataGridColumn>()
  81. {
  82. new BoundFieldColumn { FieldName="StandardCode", HeaderText="专业代码", Align=AlignStyle.Center, Width=0.06 },
  83. new BoundFieldColumn { FieldName="StandardName", HeaderText="专业名称", Align=AlignStyle.Center, Width=0.1 }
  84. },
  85. IsCheckOnSelect = true,
  86. DataSourceUrl = Url.Content("~/Grademajor/StandardBindComboGridOptions"),
  87. IsPagination = true,
  88. IsShowRowNumbers = true,
  89. IsSingleSelect = false,
  90. }
  91. };
  92. //学制
  93. ComboGridOptions cgopLearnSystem = new ComboGridOptions
  94. {
  95. TextField = "LearnSystem",
  96. ValueField = "LearnSystem",
  97. ID = "DictionaryLearnSystem",
  98. Name = "DictionaryLearnSystem",
  99. OnSelect = "queryLearnSystem",
  100. GridOptions = new DataGridOptions
  101. {
  102. Columns = new List<DataGridColumn>()
  103. {
  104. new BoundFieldColumn { FieldName="LearnSystem", HeaderText="学制", Align=AlignStyle.Center }
  105. },
  106. IsCheckOnSelect = true,
  107. DataSourceUrl = Url.Content("~/Facultymajor/LearnSystem"),
  108. IsPagination = true,
  109. IsShowRowNumbers = true,
  110. IsSingleSelect = false,
  111. IsShowHeader = false
  112. }
  113. };
  114. //班级信息
  115. ComboGridOptions cgopClassmajor = new ComboGridOptions
  116. {
  117. TextField = "Name",
  118. ValueField = "ClassmajorID",
  119. Name = "ClassmajorComboGrid",
  120. ID = "ClassmajorComboGrid",
  121. OnSelect = "reload",
  122. GridOptions = new DataGridOptions
  123. {
  124. Columns = new List<DataGridColumn>()
  125. {
  126. new LinkButtonColumn { FieldName="No", HeaderText="班级编号", Width=0.12, Align=AlignStyle.Center },
  127. new BoundFieldColumn { FieldName="Name", HeaderText="班级名称", Width=0.3, Align=AlignStyle.Center }
  128. },
  129. PageSize = 5,
  130. IsCheckOnSelect = true,
  131. DataSourceUrl = Url.Content("~/Classmajor/List"),
  132. IsPagination = true,
  133. IsShowRowNumbers = true,
  134. IsSingleSelect = false
  135. }
  136. };
  137. //考试科目
  138. ComboGridOptions cgopExaminationSubject = new ComboGridOptions
  139. {
  140. TextField = "Name",
  141. ValueField = "ExaminationSubjectID",
  142. Name = "ExaminationSubjectComboGrid",
  143. ID = "ExaminationSubjectComboGrid",
  144. OnSelect = "reload",
  145. GridOptions = new DataGridOptions
  146. {
  147. Columns = new List<DataGridColumn>()
  148. {
  149. new LinkButtonColumn { FieldName="Name", HeaderText="考试科目", Width=0.25, Align=AlignStyle.Center }
  150. },
  151. PageSize = 5,
  152. IsCheckOnSelect = true,
  153. DataSourceUrl = Url.Content("~/ExaminationSubject/List"),
  154. IsPagination = true,
  155. IsShowRowNumbers = true,
  156. IsSingleSelect = false
  157. }
  158. };
  159. }
  160. @section scripts{
  161. <script src="~/Scripts/Business/ScoreManage/LevelScoreManage/LevelScore.js" type="text/javascript"></script>
  162. <script type="text/javascript">
  163. var nonSelect = "@DropdownList.SELECT_ALL";
  164. //开始环节状态
  165. var startStatusID = "@BaseExtensions.GetStartFlowStatus("ER_LevelScore")";
  166. //已退回环节状态
  167. var sendBackStatusID = "@BaseExtensions.GetSendBackFlowStatus("ER_LevelScore")";
  168. //结束环节状态
  169. var endStatusID = "@BaseExtensions.GetEndFlowStatus("ER_LevelScore")";
  170. </script>
  171. }
  172. <div class="easyui-panel" data-options="border:false,fit:true" style="position:relative;">
  173. @Html.Position()
  174. <div class="p_SearchTitle">
  175. <div style="float: left; margin-left: 10px; font-size: 12px; line-height: 30px;">查询条件</div>
  176. </div>
  177. <form id="formQuery" method="post" action="@Url.Content("~/LevelScore/Excel")">
  178. @Html.PositionCondition()
  179. <div class="search_keyword">
  180. <div class="search_input">
  181. <ul>
  182. <li class="sn" style="padding-left: 5px;">@EMIS.Utility.RSL.Get("Campus"):</li>
  183. <li class="sv">
  184. @Html.ComboGrid(cgopCampus, new Dictionary<string, string> { { "data-condition", "dgLevelScoreList" } })
  185. </li>
  186. <li class="sn" style="padding-left: 5px;">@EMIS.Utility.RSL.Get("College"):</li>
  187. <li class="sv">
  188. @Html.ComboGrid(cgopCollege, new Dictionary<string, string> { { "data-condition", "dgLevelScoreList" } })
  189. </li>
  190. <li class="sn" style="padding-left: 5px;">年级:</li>
  191. <li class="sv">
  192. @*@Html.ComboGrid(cgopGrade, new Dictionary<string, string> { { "data-condition", "dgLevelScoreList" } })*@
  193. @Html.DictionaryComboGrid(EMIS.ViewModel.DictionaryItem.CF_Grade, DropdownListBindType.SelectAll,
  194. new ComboGridOptions
  195. {
  196. ID = "DictionaryGrade",
  197. Name = "DictionaryGrade",
  198. OnSelect = "queryGrade"
  199. }, new Dictionary<string, string> { { "data-condition", "dgLevelScoreList" } })
  200. </li>
  201. <li class="sn" style="padding-left: 5px;">专业名称:</li>
  202. <li class="sv">
  203. @Html.ComboGrid(cgopStandard, new Dictionary<string, string> { { "data-condition", "dgLevelScoreList" } })
  204. </li>
  205. </ul>
  206. <ul>
  207. <li class="sn" style="padding-left: 5px;">@Html.RSLabel("EducationID"):</li>
  208. <li class="sv">
  209. @Html.DictionaryComboGrid(EMIS.ViewModel.DictionaryItem.CF_Education, DropdownListBindType.SelectAll,
  210. new ComboGridOptions
  211. {
  212. ID = "DictionaryEducation",
  213. Name = "DictionaryEducation",
  214. OnSelect = "reload"
  215. }, new Dictionary<string, string> { { "data-condition", "dgLevelScoreList" } })
  216. </li>
  217. <li class="sn" style="padding-left: 5px;">学习形式:</li>
  218. <li class="sv">
  219. @Html.DictionaryComboGrid(EMIS.ViewModel.DictionaryItem.CF_Learningform, DropdownListBindType.SelectAll,
  220. new ComboGridOptions
  221. {
  222. ID = "DictionaryLearningform",
  223. Name = "DictionaryLearningform",
  224. OnSelect = "reload"
  225. }, new Dictionary<string, string> { { "data-condition", "dgLevelScoreList" } })
  226. </li>
  227. <li class="sn" style="padding-left: 5px;">学制:</li>
  228. <li class="sv">
  229. @Html.ComboGrid(cgopLearnSystem, new Dictionary<string, string> { { "data-condition", "dgLevelScoreList" } })
  230. </li>
  231. <li class="sn" style="padding-left: 5px;">班级信息:</li>
  232. <li class="sv">
  233. @Html.ComboGrid(cgopClassmajor, new Dictionary<string, string> { { "data-condition", "dgLevelScoreList" } })
  234. </li>
  235. </ul>
  236. <ul>
  237. <li class="sn" style="padding-left: 5px;">学年学期:</li>
  238. <li class="sv">
  239. @Html.DropdownList(new DropdownListOptions
  240. {
  241. ID = "SchoolyearDropdown",
  242. Name = "SchoolyearDropdown",
  243. BindType = DropdownListBindType.SelectAll,
  244. ItemSourceUrl = Url.Content("~/SchoolYear/YearsDropdownListBanid"),
  245. SelectedValue = BaseExtensions.GetCurrentSchoolYearID(),
  246. OnSelect = "reload"
  247. }, new Dictionary<string, string> { { "data-condition", "dgLevelScoreList" } })
  248. </li>
  249. <li class="sn" style="padding-left: 5px;">考试科目:</li>
  250. <li class="sv">
  251. @Html.ComboGrid(cgopExaminationSubject, new Dictionary<string, string> { { "data-condition", "dgLevelScoreList" } })
  252. </li>
  253. <li class="sn" style="padding-left: 5px;color:red;">在校状态:</li>
  254. <li class="sv">
  255. @Html.DictionaryDropDownList(EMIS.ViewModel.DictionaryItem.CF_INOrOutSchoolStatus, new DropdownListOptions
  256. {
  257. ID = "DictionaryInschoolStatus",
  258. Name = "DictionaryInschoolStatus",
  259. BindType = DropdownListBindType.SelectAll,
  260. //SelectedValue = (int)EMIS.ViewModel.CF_INOrOutSchoolStatus.No,
  261. OnSelect = "reload"
  262. }, new Dictionary<string, string> { { "data-condition", "dgLevelScoreList" } })
  263. </li>
  264. <li class="sn" style="padding-left: 5px; color: red;">状态:</li>
  265. <li class="sv">
  266. @Html.DropdownList(new DropdownListOptions
  267. {
  268. ID = "DictionaryApprovalStatus",
  269. Name = "DictionaryApprovalStatus",
  270. BindType = DropdownListBindType.SelectAll,
  271. //SelectedValue = BaseExtensions.GetStartFlowStatus(typeof(EMIS.Entities.ER_LevelScore).Name),
  272. ItemSourceUrl = Url.Content("~/Common/ApproveStatusDropDown?tableName=" + typeof(EMIS.Entities.ER_LevelScore).Name),
  273. OnSelect = "reload"
  274. }, new Dictionary<string, string> { { "data-condition", "dgLevelScoreList" } })
  275. </li>
  276. </ul>
  277. </div>
  278. </div>
  279. </form>
  280. <div class="p_title">
  281. <div style="float: left; margin-left: 10px; line-height: 30px; font-size: 12px;">科目成绩列表</div>
  282. <div style="margin-right: 10px; line-height: 30px; font-size: 12px;">@Html.ContextMenuBar("List")</div>
  283. </div>
  284. @Html.PositionBatchModify()
  285. <div class="search_list">
  286. @Html.DataGrid(new DataGridOptions
  287. {
  288. Columns = new List<DataGridColumn>()
  289. {
  290. new CheckBoxFieldColumn{ HeaderText="", FieldName="LevelScoreID" },
  291. new LinkButtonColumn { FieldName="StudentNo", HeaderText="学号", Align=AlignStyle.Center, Handle="edit", Width=0.08 },
  292. new BoundFieldColumn { FieldName="Name", HeaderText="姓名", Align=AlignStyle.Center, Width=0.04 },
  293. new BoundFieldColumn { FieldName="SexName", HeaderText="性别", Align=AlignStyle.Center, OrderFieldName="SexID", Width=0.02 },
  294. //new BoundFieldColumn { FieldName="BirthDate", HeaderText="出生日期", Align=AlignStyle.Center, Width=0.05, Formatter = Formatter.OnlyYearMonthDay },
  295. //new BoundFieldColumn { FieldName="NationName", HeaderText="民族", Align=AlignStyle.Center, OrderFieldName="NationID", Width=0.03 },
  296. //new BoundFieldColumn { FieldName="PoliticsName", HeaderText="政治面貌", Align=AlignStyle.Center, OrderFieldName="PoliticsID", Width=0.04 },
  297. //new BoundFieldColumn { FieldName="GradeID", HeaderText="年级", Align=AlignStyle.Center, OrderFieldName="GradeID", Width=0.03 },
  298. //new BoundFieldColumn { FieldName="ClassNum", HeaderText="班序", Align=AlignStyle.Center, Width=0.02 },
  299. //new BoundFieldColumn { FieldName="ClassmajorNo", HeaderText="班级编号", Align=AlignStyle.Center, Width=0.06 },
  300. new BoundFieldColumn { FieldName="ClassmajorName", HeaderText="班级名称", Align=AlignStyle.Center, Width=0.08, OverflowLength=12 },
  301. //new BoundFieldColumn { FieldName="StandardCode", HeaderText="专业代码", Align=AlignStyle.Center, OrderFieldName="StandardID", Width=0.06 },
  302. //new BoundFieldColumn { FieldName="StandardName", HeaderText="专业名称", Align=AlignStyle.Center, OrderFieldName="StandardID", Width=0.08 },
  303. //new BoundFieldColumn { FieldName="EducationName", HeaderText=EMIS.Utility.RSL.Get("EducationID"), Align=AlignStyle.Center, OrderFieldName="EducationID", Width=0.04 },
  304. //new BoundFieldColumn { FieldName="LearningformName", HeaderText="学习形式", Align=AlignStyle.Center, OrderFieldName="LearningformID", Width=0.06 },
  305. //new BoundFieldColumn { FieldName="LearnSystem", HeaderText="学制", Align=AlignStyle.Center, Width=0.03 },
  306. new BoundFieldColumn { FieldName="InSchoolStatusName", HeaderText="在校状态", Align=AlignStyle.Center, OrderFieldName="InSchoolStatusID", Width=0.04, CustomFormatFun="SetRedColumn" },
  307. //new BoundFieldColumn { FieldName="StudentStatusName", HeaderText="学籍状态", Align=AlignStyle.Center, OrderFieldName="StudentStatus", Width=0.04, CustomFormatFun="SetRedColumn" },
  308. //new BoundFieldColumn { FieldName="CollegeNo", HeaderText=@EMIS.Utility.RSL.Get("CollegeCode"), Align=AlignStyle.Center, Width=0.05 },
  309. new BoundFieldColumn { FieldName="CollegeName", HeaderText=@EMIS.Utility.RSL.Get("College"), Align=AlignStyle.Center, Width=0.08, OverflowLength=12 },
  310. //new BoundFieldColumn { FieldName="CampusCode", HeaderText=@EMIS.Utility.RSL.Get("CampusCode"), Align=AlignStyle.Center, Width=0.05 },
  311. //new BoundFieldColumn { FieldName="CampusName", HeaderText=@EMIS.Utility.RSL.Get("Campus"), Align=AlignStyle.Center, Width=0.06, OverflowLength=10 },
  312. new BoundFieldColumn { FieldName="ExaminationSubjectName", HeaderText="考试科目", Align=AlignStyle.Center, Width=0.08, OverflowLength=12 },
  313. new BoundFieldColumn { FieldName="SchoolyearCode", HeaderText="学年学期", Align=AlignStyle.Center, Width=0.06 },
  314. new BoundFieldColumn { FieldName="ExaminationDate", HeaderText="考试日期", Align=AlignStyle.Center, Width=0.05, Formatter = Formatter.OnlyYearMonth },
  315. new BoundFieldColumn { FieldName="ScoreNo", HeaderText="成绩单编号", Align=AlignStyle.Center, Width=0.06, OverflowLength=10 },
  316. new BoundFieldColumn { FieldName="TotalScore", HeaderText="总成绩", Align=AlignStyle.Center, Width=0.03, CustomFormatFun="SetRedColumn" },
  317. new BoundFieldColumn { FieldName="LevelName", HeaderText="成绩等级", Align=AlignStyle.Center, Width=0.04, CustomFormatFun="SetRedColumn" },
  318. new BoundFieldColumn { FieldName="Remark", HeaderText="备注", Align=AlignStyle.Center, Width=0.03, OverflowLength=5 },
  319. new BoundFieldColumn { FieldName="CreateUserName", HeaderText="创建人", Align=AlignStyle.Center, Width=0.04 },
  320. new ApproveStatusColumn { FieldName="ApprovalStatusName", TableName=typeof(EMIS.Entities.ER_LevelScore).Name, IDFieldName="LevelScoreID", HeaderText="状态", Align=AlignStyle.Center, Width=0.03 }
  321. },
  322. IsCheckOnSelect = true,
  323. DataSourceUrl = Url.Content("~/LevelScore/List"),
  324. ID = "dgLevelScoreList",
  325. IsPagination = true,
  326. IsShowRowNumbers = true,
  327. IsSingleSelect = false
  328. })
  329. </div>
  330. </div>