JW/EMIS.Web/Views/AdultSpecialtyPlan/PlanStudentList.cshtml

@using EMIS.Web.Controls;
@using Bowin.Web.Controls.Mvc;
@{
    ViewBag.Title = "PlanStudentList";
    Guid? specialtyPlanID = new Guid(Request["specialtyPlanID"]);

    //院系所
    ComboGridOptions cgopCollege = new ComboGridOptions
    {
        TextField = "Name",
        ValueField = "CollegeID",
        ID = "CollegeDropdown",
        Name = "CollegeDropdown",
        OnSelect = "queryCollege",
        GridOptions = new DataGridOptions
        {
            Columns = new List<DataGridColumn>() 
            { 
                //new LinkButtonColumn { FieldName="No", HeaderText=@EMIS.Utility.RSL.Get("CollegeCode"), Align=AlignStyle.Center, Width=0.1 },
                new BoundFieldColumn { FieldName="Name", HeaderText=@EMIS.Utility.RSL.Get("CollegeName"), Align=AlignStyle.Center, Width=0.2 }
            },
            PageSize = 5,
            IsCheckOnSelect = true,
            DataSourceUrl = Url.Content("~/College/ListOnlyCollege"),
            IsPagination = true,
            IsShowRowNumbers = true,
            IsSingleSelect = false,
        }
    };
    
    //班级信息
    ComboGridOptions cgopClassmajor = new ComboGridOptions
    {
        TextField = "Name",
        ValueField = "ClassmajorID",
        Name = "ClassmajorDropdown",
        ID = "ClassmajorDropdown",
        OnSelect = "reload",
        GridOptions = new DataGridOptions
        {
            Columns = new List<DataGridColumn>()
            {
                //new LinkButtonColumn { FieldName="No", HeaderText="班级编号", Align=AlignStyle.Center, Width=0.2 },
                new BoundFieldColumn { FieldName="Name", HeaderText="班级名称", Align=AlignStyle.Center, Width=0.3 }
            },
            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() {
            $("#dgAdultSpecialtyPlanStudentList").cmsXDataTable("load", $.getDataGridParams("dgAdultSpecialtyPlanStudentList"));
        }
        //设置列颜色为红色
        function SetRedColumn(index, row, value) {
            return " <span style=\"color: red;\">" + value + "</span>";
        }
        //Excel导出
        function SpecialtyPlanStudent_Export() {
            $("#formQuery").submit();
        }

        //联动查询
        function queryCollege() {
            var collegeID = $("#CollegeDropdown").combogridX("getValue");
            if (collegeID != nonSelect) {
                var jsonString = "({'QueryParamsDatas':'CollegeDropdown|*|" + collegeID + "|@@|'})";
                $("#ClassmajorDropdown").combogridX("reload", eval(jsonString));
            }
            else {
                $("#ClassmajorDropdown").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("~/AdultSpecialtyPlan/PlanStudentListExcel?specialtyPlanID=" + specialtyPlanID)">
     @Html.PositionCondition("AdultSpecialtyPlanStudent")
    <div class="search_keyword">
        <div class="search_input">
            <ul>
                <li class="sn" style="padding-left: 5px;">@EMIS.Utility.RSL.Get("College")：</li>
                <li class="sv">
                    @Html.ComboGrid(cgopCollege, new Dictionary<string, string> { { "data-condition", "dgAdultSpecialtyPlanStudentList" } })
                </li>
                <li class="sn" style="padding-left: 5px;">班级名称：</li>
                <li class="sv">
                    @Html.ComboGrid(cgopClassmajor, new Dictionary<string, string> { { "data-condition", "dgAdultSpecialtyPlanStudentList" } })
                </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)EMIS.ViewModel.CF_INOrOutSchoolStatus.Yes,
                        OnSelect = "reload"
                    }, new Dictionary<string, string> { { "data-condition", "dgAdultSpecialtyPlanStudentList" } })
                </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("PlanStudent")</div>
    </div>
    </form>
    <div class="search_list">
        @Html.DataGrid(new DataGridOptions
           {
               Columns = new List<DataGridColumn>()
               {
                    new CheckBoxFieldColumn{ HeaderText="", FieldName="UserID" },
                    new BoundFieldColumn { FieldName="LoginID", HeaderText="学号", Align=AlignStyle.Center, Width=0.08 },
                    new BoundFieldColumn { FieldName="UserName", HeaderText="姓名", Align=AlignStyle.Center, Width=0.04 },
                    new BoundFieldColumn { FieldName="SexName", HeaderText="性别", Align=AlignStyle.Center, OrderFieldName="Sex", Width=0.02 },
                    new BoundFieldColumn { FieldName="SchoolyearID", HeaderText="年级", Align=AlignStyle.Center, Width=0.03, CustomFormatFun="SetRedColumn" },
                    //new BoundFieldColumn { FieldName="GrademajorName", HeaderText="年级专业名称", Align=AlignStyle.Center, Width=0.1, OverflowLength=8 },
                    new BoundFieldColumn { FieldName="ClassmajorName", HeaderText="班级名称", Align=AlignStyle.Center, Width=0.1 },
                    new BoundFieldColumn { FieldName="CollegeName", HeaderText=@EMIS.Utility.RSL.Get("College"), Align=AlignStyle.Center, Width=0.04, OverflowLength=5 },
                    new BoundFieldColumn { FieldName="InSchoolStatusName", HeaderText="在校状态", Align=AlignStyle.Center, OrderFieldName="InSchoolStatusID", Width=0.04, CustomFormatFun="SetRedColumn" },
                    new BoundFieldColumn { FieldName="StudentStatusName", HeaderText="学籍状态", Align=AlignStyle.Center, OrderFieldName="StudentStatus", Width=0.04 }
               },
               IsPostBack = true,
               IsCheckOnSelect = true,
               DataSourceUrl = Url.Content("~/AdultSpecialtyPlan/PlanStudentList?specialtyPlanID=" + specialtyPlanID),
               ID = "dgAdultSpecialtyPlanStudentList",
               IsPagination = true,
               IsShowRowNumbers = true,
               IsSingleSelect = false
           })
    </div>
</div>