JW/EMIS.Web/Views/StudentReportStatistics/CollegeReportDetail.cshtml

@using EMIS.Web.Controls;
@using Bowin.Web.Controls.Mvc;
@{
    ViewBag.Title = "CollegeReportDetail";
    Guid? schoolyearID = new Guid(Request["schoolyearID"]);
    Guid? collegeID = new Guid(Request["collegeID"]);
    int? reportStatus = Convert.ToInt32(Request["reportStatus"] == null ? "-1" : Request["reportStatus"]);
    int? inschoolstatus = Convert.ToInt32(Request["inschoolstatus"] == null ? "-1" : Request["inschoolstatus"]);

    //年级
    ComboGridOptions cgopGrade = new ComboGridOptions
    {
        TextField = "GradeID",
        ValueField = "GradeID",
        ID = "DictionaryGrade",
        Name = "DictionaryGrade",
        OnSelect = "queryGrade",
        GridOptions = new DataGridOptions
        {
            Columns = new List<DataGridColumn>() 
            { 
                new BoundFieldColumn { FieldName="GradeID", HeaderText="年级", Align=AlignStyle.Center, Width=0.1 }
            },
            IsCheckOnSelect = true,
            DataSourceUrl = Url.Content("~/Grademajor/GradeBindComboGridOptions"),
            IsPagination = true,
            IsShowRowNumbers = true,
            IsSingleSelect = false,
        }
    };

    //班级信息
    ComboGridOptions cgopClassmajor = new ComboGridOptions
    {
        TextField = "Name",
        ValueField = "ClassmajorID",
        Name = "ClassmajorComboGrid",
        ID = "ClassmajorComboGrid",
        OnSelect = "reload",
        GridOptions = new DataGridOptions
        {
            Columns = new List<DataGridColumn>()
            {
                new LinkButtonColumn { FieldName="No", HeaderText="班级编号", Width=0.12, Align=AlignStyle.Center },
                new BoundFieldColumn { FieldName="Name", HeaderText="班级名称", Width=0.3, Align=AlignStyle.Center }
            },
            PageSize = 5,
            IsCheckOnSelect = true,
            DataSourceUrl = Url.Content("~/Classmajor/List"),
            IsPagination = true,
            IsShowRowNumbers = true,
            IsSingleSelect = false
        }
    };
    
}
@section scripts{
    <script type="text/javascript">
        var nonSelect = "@DropdownList.SELECT_ALL";
        //刷新
        function reload() {
            $("#dgStudentReportList").cmsXDataTable("load", $.getDataGridParams("dgStudentReportList"));
        }
        //设置列颜色为红色
        function SetRedColumn(index, row, value) {
            return " <span style=\"color: red;\">" + value + "</span>";
        }
        //Excel导出
        function StuRSColDetail_Export() {
            $("#formQuery").submit();
        }

        //联动查询
        function queryGrade(data) {
            queryClass();
        }

        function queryClass() {
            var jsonString = "";
            var parameterString = "";
            var collegeID = $("#CollegeID").val();
            var gradeID = $("#DictionaryGrade").combogridX("getValue");
            if (collegeID != nonSelect) parameterString += "CollegeDropdown|*|" + collegeID + "|@@|";
            if (gradeID != nonSelect) parameterString += "DictionaryGrade|*|" + gradeID + "|@@|";
            if (parameterString != "") {
                jsonString = "({'QueryParamsDatas':'" + parameterString + "'})";
                $("#ClassmajorComboGrid").combogridX("reload", eval(jsonString));
            }
            else {
                $("#ClassmajorComboGrid").combogridX("reload");
            }
            reload();
        }
    </script>
}
<div class="easyui-panel" data-options="border:false,fit:true" style="position: relative;">
    <form id="formQuery" method="post" action="@Url.Content("~/StudentReportStatistics/CollegeReportDetailExcel?schoolyearID=" + schoolyearID + "&collegeID=" + collegeID)">
     @Html.PositionCondition("CollegeReport")
    <div class="search_keyword">
        <div class="search_input">
            <ul>
                <li class="sn" style="padding-left: 5px;">年级：</li>
                <li class="sv">
                    @*@Html.ComboGrid(cgopGrade, new Dictionary<string, string> { { "data-condition", "dgStudentReportList" } })*@
                    @Html.DictionaryComboGrid(EMIS.ViewModel.DictionaryItem.CF_Grade, DropdownListBindType.SelectAll, 
                        new ComboGridOptions 
                        { 
                            ID = "DictionaryGrade", 
                            Name = "DictionaryGrade", 
                            OnSelect = "queryGrade" 
                        }, new Dictionary<string, string> { { "data-condition", "dgStudentReportList" } })
                </li>
                <li class="sn" style="padding-left: 5px;">班级信息：</li>
                <li class="sv">
                    @Html.ComboGrid(cgopClassmajor, new Dictionary<string, string> { { "data-condition", "dgStudentReportList" } })
                </li>
                @if (reportStatus == -1)
                {
                    <li class="sn" style="padding-left: 5px;color: red;">注册状态：</li>
                    <li class="sv">
                        @Html.DictionaryDropDownList(EMIS.ViewModel.DictionaryItem.CF_ReportStatus, new DropdownListOptions 
                        { 
                            ID = "DictionaryReportStatus", 
                            Name = "DictionaryReportStatus",
                            BindType = DropdownListBindType.SelectAll, 
                            SelectedValue = (int)reportStatus,
                            OnSelect = "reload"
                        }, new Dictionary<string, string> { { "data-condition", "dgStudentReportList" } })
                    </li>
                }
                else
                {
                    <li class="sn" style="padding-left: 5px;color: red;display: none;">注册状态：</li>
                    <li class="sv" style="display: none;">
                        @Html.DictionaryDropDownList(EMIS.ViewModel.DictionaryItem.CF_ReportStatus, new DropdownListOptions 
                        { 
                            ID = "DictionaryReportStatus", 
                            Name = "DictionaryReportStatus",
                            BindType = DropdownListBindType.SelectAll, 
                            SelectedValue = (int)reportStatus,
                            OnSelect = "reload"
                        }, new Dictionary<string, string> { { "data-condition", "dgStudentReportList" } })
                    </li>
                }
                <li class="sn" style="padding-left: 5px;color: red;">在校状态：</li>
                <li class="sv">
                    @Html.DictionaryDropDownList(EMIS.ViewModel.DictionaryItem.CF_INOrOutSchoolStatus, new DropdownListOptions 
                    { 
                        ID = "DictionaryInschoolStatus", 
                        Name = "DictionaryInschoolStatus",
                        BindType = DropdownListBindType.SelectAll, 
                        SelectedValue = (int)inschoolstatus,
                        OnSelect = "reload"
                    }, new Dictionary<string, string> { { "data-condition", "dgStudentReportList" } })
                </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("Detail")</div>
    </div>
    </form>
    @Html.Hidden("CollegeID", collegeID)
    <div class="search_list">
        @Html.DataGrid(new DataGridOptions
           {
               Columns = new List<DataGridColumn>()
               {
                    new CheckBoxFieldColumn{ HeaderText="", FieldName="StudentReportID" },
                    new BoundFieldColumn { FieldName="StudentNo", HeaderText="学号", Align=AlignStyle.Center, Width=0.08 },
                    new BoundFieldColumn { FieldName="Name", HeaderText="姓名", Align=AlignStyle.Center, Width=0.04 },
                    new BoundFieldColumn { FieldName="SexName", HeaderText="性别", Align=AlignStyle.Center, OrderFieldName="SexID", Width=0.02 },
                    //new BoundFieldColumn { FieldName="BirthDate", HeaderText="出生日期", Align=AlignStyle.Center, Width=0.06, Formatter = Formatter.OnlyYearMonthDay },
                    //new BoundFieldColumn { FieldName="NationName", HeaderText="民族", Align=AlignStyle.Center, OrderFieldName="NationID", Width=0.03 },
                    //new BoundFieldColumn { FieldName="PoliticsName", HeaderText="政治面貌", Align=AlignStyle.Center, OrderFieldName="PoliticsID", Width=0.04 },
                    new BoundFieldColumn { FieldName="GradeID", HeaderText="年级", Align=AlignStyle.Center, OrderFieldName="GradeID", Width=0.03 },
                    //new BoundFieldColumn { FieldName="ClassmajorNo", HeaderText="班级编号", Align=AlignStyle.Center, Width=0.08 },
                    new BoundFieldColumn { FieldName="ClassmajorName", HeaderText="班级名称", Align=AlignStyle.Center, Width=0.12 },
                    //new BoundFieldColumn { FieldName="StandardCode", HeaderText="专业代码", Align=AlignStyle.Center, OrderFieldName="StandardID", Width=0.06 },
                    //new BoundFieldColumn { FieldName="StandardName", HeaderText="专业名称", Align=AlignStyle.Center, OrderFieldName="StandardID", Width=0.08 },
                    //new BoundFieldColumn { FieldName="EducationName", HeaderText=EMIS.Utility.RSL.Get("EducationID"), Align=AlignStyle.Center, OrderFieldName="EducationID", Width=0.04 },
                    //new BoundFieldColumn { FieldName="LearningformName", HeaderText="学习形式", Align=AlignStyle.Center, OrderFieldName="LearningformID", Width=0.06 },
                    //new BoundFieldColumn { FieldName="LearnSystem", HeaderText="学制", Align=AlignStyle.Center, Width=0.03 },
                    //new BoundFieldColumn { FieldName="SemesterName", HeaderText="入学学期", Align=AlignStyle.Center, OrderFieldName="SemesterID", Width=0.04 },
                    //new BoundFieldColumn { FieldName="StartSchoolyearCode", HeaderText="入学学年学期", Align=AlignStyle.Center, Width=0.06 },
                    //new BoundFieldColumn { FieldName="GraduateSchoolyearCode", HeaderText="毕业学期", Align=AlignStyle.Center, Width=0.06 },
                    //new BoundFieldColumn { FieldName="CampusCode", HeaderText=@EMIS.Utility.RSL.Get("CampusCode"), Align=AlignStyle.Center, Width=0.05 },
                    //new BoundFieldColumn { FieldName="CampusName", HeaderText=@EMIS.Utility.RSL.Get("Campus"), Align=AlignStyle.Center, Width=0.06, OverflowLength=8 },
                    //new BoundFieldColumn { FieldName="CollegeNo", HeaderText=@EMIS.Utility.RSL.Get("CollegeCode"), Align=AlignStyle.Center, Width=0.05 },
                    //new BoundFieldColumn { FieldName="CollegeName", HeaderText=@EMIS.Utility.RSL.Get("College"), Align=AlignStyle.Center, Width=0.08, OverflowLength=10 },
                    new BoundFieldColumn { FieldName="InSchoolStatusName", HeaderText="在校状态", Align=AlignStyle.Center, OrderFieldName="InSchoolStatusID", Width=0.04 },
                    //new BoundFieldColumn { FieldName="StudentStatusName", HeaderText="学籍状态", Align=AlignStyle.Center, OrderFieldName="StudentStatus", Width=0.04 },
                    new BoundFieldColumn { FieldName="YearID", HeaderText="学年", Align=AlignStyle.Center, OrderFieldName="YearID", Width=0.03, CustomFormatFun="SetRedColumn" },
                    new BoundFieldColumn { FieldName="SchoolyearCode", HeaderText="学年学期", Align=AlignStyle.Center, Width=0.06, CustomFormatFun="SetRedColumn" },
                    new BoundFieldColumn { FieldName="ReportStatusName", HeaderText="注册状态", Align=AlignStyle.Center, OrderFieldName="ReportStatus", Width=0.04, CustomFormatFun="SetRedColumn" },
                    new BoundFieldColumn { FieldName="ModifyUserName", HeaderText="操作人", Align=AlignStyle.Center, Width=0.04 },
                    new BoundFieldColumn { FieldName="ReportDate", HeaderText="注册日期", Align=AlignStyle.Center, Width=0.06, Formatter = Formatter.OnlyYearMonthDay },
                    new BoundFieldColumn { FieldName="Remark", HeaderText="备注", Align=AlignStyle.Center, Width=0.02, OverflowLength=5 }
               },
               IsPostBack = true,
               IsCheckOnSelect = true,
               DataSourceUrl = Url.Content("~/StudentReportStatistics/CollegeReportDetail?schoolyearID=" + schoolyearID + "&collegeID=" + collegeID),
               ID = "dgStudentReportList",
               IsPagination = true,
               IsShowRowNumbers = true,
               IsSingleSelect = false
           })
    </div>
</div>