JW/EMIS.Web/Views/GraduationList/FinallyScoreList.cshtml

@using EMIS.Web.Controls;
@using Bowin.Web.Controls.Mvc;
@{
    ViewBag.Title = "FinallyScoreList";
    Guid? graduationApplyID = new Guid(Request["graduationApplyID"]);
}
@section scripts{
    <script type="text/javascript">
        var nonSelect = "@DropdownList.SELECT_ALL";
        //未提交
        var notSubmited = "@((int)EMIS.ViewModel.EM_ExecuteStatus.NotSubmited)";

        //刷新
        function reload() {
            $("#dgGraduationFinallyScoreList").cmsXDataTable("load", $.getDataGridParams("dgGraduationFinallyScoreList"));
        }
        //设置列颜色为红色
        function SetRedColumn(index, row, value) {
            return " <span style=\"color: red;\">" + value + "</span>";
        }
        //设置相应的行颜色为红色
        function SetRedGrid(rowIndex, rowData) {
            var setValue = "background-color:" + rowData.CourseTypeColour + ";";
            if (rowData.ExecutablePlanStatus == notSubmited || rowData.ExecutablePlanStatus == null
                || rowData.IsExecutablePlan == false || rowData.TotalScore <= 0) {
                return setValue + "color: red;";
            }
            else {
                return setValue;
            }
        }
        //Excel导出
        function FinallyScoreListExcel() {
            $("#formQuery").submit();
        }
    </script>
}
<div class="easyui-panel" data-options="border:false,fit:true" style="position: relative;">
    <form id="formQuery" method="post" action="@Url.Content("~/GraduationList/FinallyScoreListExcel?graduationApplyID=" + graduationApplyID)">
    @Html.PositionCondition("GraduationFinallyScoreSelect")
    <div class="search_keyword">
        <div class="search_input">
            <ul>
                <li class="sn" style="padding-left: 5px;">学年学期：</li>
                <li class="sv">
                   @Html.DropdownList(new DropdownListOptions 
                    { 
                        ID = "SchoolyearDropdown", 
                        Name = "SchoolyearDropdown", 
                        BindType = DropdownListBindType.SelectAll, 
                        ItemSourceUrl = Url.Content("~/SchoolYear/YearsDropdownListBanid"),
                        OnSelect = "reload" 
                    }, new Dictionary<string, string> { { "data-condition", "dgGraduationFinallyScoreList" } })
                </li>
                <li class="sn" style="padding-left: 5px;">课程类型：</li>
                <li class="sv">
                    @Html.DictionaryComboGrid(EMIS.ViewModel.DictionaryItem.CF_CourseType, DropdownListBindType.SelectAll, 
                    new ComboGridOptions 
                    { 
                        ID = "DictionaryCourseType", 
                        Name = "DictionaryCourseType", 
                        OnSelect = "reload" 
                    }, new Dictionary<string, string> { { "data-condition", "dgGraduationFinallyScoreList" } })
                </li>
                <li class="sn" style="padding-left: 5px;color:red;">选修类别：</li>
                <li class="sv">
                    @Html.DictionaryComboGrid(EMIS.ViewModel.DictionaryItem.CF_CourseSelectType, DropdownListBindType.SelectAll, 
                    new ComboGridOptions 
                    { 
                        ID = "DictionaryCourseSelectType", 
                        Name = "DictionaryCourseSelectType", 
                        OnSelect = "reload" 
                    }, new Dictionary<string, string> { { "data-condition", "dgGraduationFinallyScoreList" } })
                </li>
                <li class="sn" style="padding-left: 5px;">考试性质：</li>
                <li class="sv">
                    @Html.DictionaryComboGrid(EMIS.ViewModel.DictionaryItem.CF_ExamsCategory, DropdownListBindType.SelectAll, 
                    new ComboGridOptions 
                    { 
                        ID = "DictionaryExamsCategory", 
                        Name = "DictionaryExamsCategory", 
                        OnSelect = "reload" 
                    }, new Dictionary<string, string> { { "data-condition", "dgGraduationFinallyScoreList" } })
                </li>
            </ul>
            <ul>
                <li class="sn" style="padding-left: 5px;">开课学期：</li>
                <li class="sv">
                    @Html.DictionaryComboGrid(EMIS.ViewModel.DictionaryItem.CF_Startterm, DropdownListBindType.SelectAll, 
                    new ComboGridOptions 
                    { 
                        ID = "DictionaryStartterm", 
                        Name = "DictionaryStartterm", 
                        OnSelect = "reload" 
                    }, new Dictionary<string, string> { { "data-condition", "dgGraduationFinallyScoreList" } })
                </li>
                <li class="sn" style="padding-left: 5px;color:red;">学位课程：</li>
                <li class="sv">
                    @Html.DictionaryDropDownList(EMIS.ViewModel.DictionaryItem.CF_GeneralPurpose, new DropdownListOptions() 
                    { 
                        BindType = DropdownListBindType.SelectAll,
                        ID =  "DictionaryIsMainCourse", 
                        Name = "DictionaryIsMainCourse", 
                        //SelectedValue = (int)EMIS.ViewModel.CF_GeneralPurpose.IsYes,
                        OnSelect = "reload" 
                    }, new Dictionary<string, string> { { "data-condition", "dgGraduationFinallyScoreList" } })
                </li>
                <li class="sn" style="padding-left: 5px;color:red;">处理方式：</li>
                <li class="sv">
                    @Html.DictionaryDropDownList(EMIS.ViewModel.DictionaryItem.CF_HandleMode, new DropdownListOptions() 
                    { 
                        BindType = DropdownListBindType.SelectAll,
                        ID =  "DictionaryHandleMode", 
                        Name = "DictionaryHandleMode", 
                        //SelectedValue = (int)EMIS.ViewModel.CF_HandleMode.RequiredCourse,
                        OnSelect = "reload" 
                    }, new Dictionary<string, string> { { "data-condition", "dgGraduationFinallyScoreList" } })
                </li>
                <li class="sn" style="padding-left: 5px;color:red;">是否计划：</li>
                <li class="sv">
                    @Html.DictionaryComboGrid(EMIS.ViewModel.DictionaryItem.CF_GeneralPurpose, DropdownListBindType.SelectAll, 
                    new ComboGridOptions 
                    { 
                        ID = "DictionaryIsExecutablePlan", 
                        Name = "DictionaryIsExecutablePlan", 
                        OnSelect = "reload" 
                    }, new Dictionary<string, string> { { "data-condition", "dgGraduationFinallyScoreList" } })
                </li>
                <li class="sn" style="padding-left: 5px;color:red;">计划状态：</li>
                <li class="sv">
                    @Html.DictionaryDropDownList(EMIS.ViewModel.DictionaryItem.EM_ExecuteStatus, new DropdownListOptions() 
                    { 
                        ID =  "DictionaryExecutablePlanStatus", 
                        Name = "DictionaryExecutablePlanStatus",
                        BindType = DropdownListBindType.SelectAll,
                        //SelectedValue = (int)EMIS.ViewModel.EM_ExecuteStatus.Submited,
                        OnSelect = "reload" 
                    }, new Dictionary<string, string> { { "data-condition", "dgGraduationFinallyScoreList" } })
                </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("ScoreDetail")</div>
    </div>
    </form>
    <div class="search_list">
        @Html.DataGrid(new DataGridOptions
           {
               Columns = new List<DataGridColumn>()
               {
                    new CheckBoxFieldColumn{ HeaderText="", FieldName="FinallyScoreID" },
                    new BoundFieldColumn { FieldName="SchoolyearCode", HeaderText="学年学期", Align=AlignStyle.Center, Width=0.08 },
                    new BoundFieldColumn { FieldName="LoginID", HeaderText="学号", Align=AlignStyle.Center, Width=0.1 },
                    new BoundFieldColumn { FieldName="UserName", HeaderText="姓名", Align=AlignStyle.Center, Width=0.04 },
                    new BoundFieldColumn { FieldName="CourseCode", HeaderText="课程代码", Align=AlignStyle.Center, Width=0.06 },
                    new BoundFieldColumn { FieldName="CourseName", HeaderText="课程名称", Align=AlignStyle.Center, Width=0.1, OverflowLength=12 },
                    new BoundFieldColumn { FieldName="CourseTypeName", HeaderText="课程类型", OrderFieldName="CourseTypeID", Align=AlignStyle.Center, Width=0.05 },
                    new BoundFieldColumn { FieldName="Credit", HeaderText="课程学分", Align=AlignStyle.Center, Width=0.04 },
                    new BoundFieldColumn { FieldName="IsMainCourseName", HeaderText="学位课程", OrderFieldName="IsMainCourse", Align=AlignStyle.Center, Width=0.04 },
                    new BoundFieldColumn { FieldName="StarttermName", HeaderText="开课学期", OrderFieldName="StarttermID", Align=AlignStyle. Center, Width=0.04 },
                    new BoundFieldColumn { FieldName="CourseSelectTypeName", HeaderText="选修类别", OrderFieldName="CourseSelectTypeID", Align=AlignStyle.Center, Width=0.04, CustomFormatFun="SetRedColumn" },
                    new BoundFieldColumn { FieldName="IsExecutablePlanName", HeaderText="是否计划", OrderFieldName="IsExecutablePlan", Align=AlignStyle.Center, Width=0.04, CustomFormatFun="SetRedColumn" },
                    new BoundFieldColumn { FieldName="ExecutablePlanStatusName", HeaderText="计划状态", OrderFieldName="ExecutablePlanStatus", Align=AlignStyle.Center, Width=0.04, CustomFormatFun="SetRedColumn" },
                    //new BoundFieldColumn { FieldName="TotalHours", HeaderText="总学时", Align=AlignStyle.Center, Width=0.03 },
                    new BoundFieldColumn { FieldName="HandleModeName", HeaderText="处理方式", OrderFieldName="HandleModeID", Align=AlignStyle.Center, Width=0.04, CustomFormatFun="SetRedColumn" },
                    new BoundFieldColumn { FieldName="ExamsCategoryName", HeaderText="考试性质", OrderFieldName="ExamsCategoryID", Align=AlignStyle.Center, Width=0.04 },
                    //new BoundFieldColumn { FieldName="ExamsStateName", HeaderText="考试状态", OrderFieldName="ExamsStateID", Align=AlignStyle. Center, Width=0.04 },
                    new BoundFieldColumn { FieldName="TotalScore", HeaderText="总成绩", Align=AlignStyle.Center, Width=0.03 },
                    new BoundFieldColumn { FieldName="ScoreCredit", HeaderText="学分", Align=AlignStyle.Center, Width=0.02 }
                    //new BoundFieldColumn { FieldName="GradePoint", HeaderText="绩点", Align=AlignStyle.Center, Width=0.02 } 
              },
              CustomerRowStyleFun = "SetRedGrid",
              IsPostBack = true,
              IsCheckOnSelect = true,
              DataSourceUrl = Url.Content("~/GraduationList/FinallyScoreList?graduationApplyID=" + graduationApplyID),
              ID = "dgGraduationFinallyScoreList",
              IsPagination = true,
              IsShowRowNumbers = true,
              IsSingleSelect = false
           })
    </div>
</div>