JW/EMIS.Web/Views/StudentsOrder/List.cshtml

@using Bowin.Web.Controls.Mvc;
@using EMIS.Entities;
@using EMIS.Web.Controls;
@{
    ViewBag.Title = "List";

    //ComboGridOptions cgopCampus = new ComboGridOptions
    //{
    //    TextField = "Name",
    //    ValueField = "CampusID",
    //    OnSelect = "QueryCampusComboGridList",
    //    Name = "CampusDropdown",
    //    ID = "CampusDropdown",
    //    GridOptions = new DataGridOptions
    //    {
    //        Columns = new List<DataGridColumn>() 
    //            { 
    //                //new LinkButtonColumn { FieldName="No", HeaderText=@EMIS.Utility.RSL.Get("CampusCode"), Align=AlignStyle.Center },
    //                new BoundFieldColumn { FieldName="Name", HeaderText=@EMIS.Utility.RSL.Get("CampusName"), Align=AlignStyle.Center }
    //            },
            
    //        IsCheckOnSelect = true,
    //        DataSourceUrl = Url.Content("~/Campus/List"),
    //        IsPagination = true,
    //        IsShowRowNumbers = true,
    //        IsSingleSelect = false,
    //    }
    //};
    ComboGridOptions cgopCollege = new ComboGridOptions
    {
        TextField = "Name",
        ValueField = "CollegeID",
        OnSelect = "QueryCollegeComboGridList",
        Name = "CollegeDropdown",
        ID = "CollegeDropdown",
        GridOptions = new DataGridOptions
        {
            Columns = new List<DataGridColumn>() 
                { 
                  //  new LinkButtonColumn { FieldName="No", HeaderText=@EMIS.Utility.RSL.Get("CollegeCode"), Align=AlignStyle.Center },
                    new BoundFieldColumn { FieldName="Name", HeaderText=@EMIS.Utility.RSL.Get("CollegeName"), Align=AlignStyle.Center }
                },

            IsCheckOnSelect = true,
            DataSourceUrl = Url.Content("~/College/ListOnlyCollege"),
            IsPagination = true,
            IsShowRowNumbers = true,
            IsSingleSelect = false,
        }
    };
    ComboGridOptions cgop = new ComboGridOptions
    {
        TextField = "Name",
        ValueField = "GrademajorID",
        OnSelect = "QueryComboGridList",
        Name = "ComboGridGrademajor",
        ID = "ComboGridGrademajor",
        GridOptions = new DataGridOptions
        {
            Columns = new List<DataGridColumn>() 
                { 
                  //  new LinkButtonColumn { FieldName="Code", HeaderText="年级专业代码", Align=AlignStyle.Center },
                    new BoundFieldColumn { FieldName="Name", HeaderText="年级专业名称", Align=AlignStyle.Center }
                },

            IsCheckOnSelect = true,
            DataSourceUrl = Url.Content("~/Grademajor/List"),
            IsPagination = true,
            IsShowRowNumbers = true,
            IsSingleSelect = false,
        }
    };
    ComboGridOptions Csop = new ComboGridOptions
    {
        TextField = "CourseName",
        ValueField = "CoursematerialID",
        ID = "CourseDropdown",
        Name = "CourseDropdown",
        OnSelect = "QueryCourseDropdownList",
        GridOptions = new DataGridOptions
        {
            Columns = new List<DataGridColumn>() 
                { 
                    // new LinkButtonColumn { FieldName="CourseCode", HeaderText="课程代码", Align=AlignStyle.Center },
                    new BoundFieldColumn { FieldName="CourseName", HeaderText="课程名称", Align=AlignStyle.Center }
                },

            IsCheckOnSelect = true,
            DataSourceUrl = Url.Content("~/Coursematerial/ListForDropdown"),
            IsPagination = true,
            IsShowRowNumbers = true,
            IsSingleSelect = false
        }
    };

    ComboGridOptions TMName = new ComboGridOptions
    {
        TextField = "TeachingMaterialName",
        ValueField = "TeachingMaterialPoolID",
        ID = "TeachingMaterialDropdown",
        Name = "TeachingMaterialDropdown",
        OnSelect = "reload",
        GridOptions = new DataGridOptions
        {
            Columns = new List<DataGridColumn>() 
                { 
                  new BoundFieldColumn { FieldName="TeachingMaterialName",HeaderText="教材名称", Align=AlignStyle.Center },
                     // new BoundFieldColumn { FieldName="TeachingMaterialCode",HeaderText="教材编号", Align=AlignStyle.Center }
                },

            IsCheckOnSelect = true,
            DataSourceUrl = Url.Content("~/TeachingMaterialPool/List"),
            IsPagination = true,
            IsShowRowNumbers = true,
            IsSingleSelect = false
        }
    };
    
}
<div class="easyui-panel" data-options="border:false,fit:true" style="position: relative;">
    @Html.Position()
    <div class="p_SearchTitle">
        <div style="float: left; margin-left: 10px; font-size: 12px; line-height: 30px;">
            查询条件
        </div>
    </div>
    <form id="formQuery" method="post" action="@Url.Content("~/StudentsOrder/Excel")">
        @Html.Hidden("ExcelType")
        @Html.PositionCondition()
        <div class="search_keyword">
            <div class="search_input">
                <ul>
                    @*<li class="sn" style="padding-left: 5px;">@EMIS.Utility.RSL.Get("Campus")：</li>
                    <li class="sv">
                        @Html.ComboGrid(cgopCampus, new Dictionary<string, string> { { "data-condition", "dgStudentsOrderList" } })
                    </li>*@

                    <li class="sn" style="padding-left: 5px;">学年学期：</li>
                    <li class="sv">
                        @Html.DropdownList(new DropdownListOptions { BindType = DropdownListBindType.SelectAll, ItemSourceUrl = Url.Content("~/SchoolYear/YearsDropdownListBanid"), OnSelect = "QuerySchoolyearDropdownList", Name = "SchoolyearDropdown", SelectedValue =@ViewBag.SchoolYearID }, new Dictionary<string, string> { { "data-condition", "dgStudentsOrderList" } })
                    </li>
                    <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", "dgStudentsOrderList" } })
                    </li>
                    <li class="sn" style="padding-left: 5px;">年级：</li>
                    <li class="sv">
                        @Html.SchoolYearDropDownList(new DropdownListOptions { BindType = DropdownListBindType.SelectAll, ID = "DictionarySchoolyear", Name = "DictionarySchoolyear", OnSelect = "QuerySchoolyearDictionaryList" }, new Dictionary<string, string> { { "data-condition", "dgStudentsOrderList" } })
                    </li>
                    @*<li class="sn" style="padding-left: 5px;">年级：</li>
                    <li class="sv">
                        @Html.DictionaryDropDownList(EMIS.ViewModel.DictionaryItem.CF_Grade, new DropdownListOptions { Name = "DictionarySchoolyear", BindType = DropdownListBindType.SelectAll, OnSelect = "QuerySchoolyearDictionaryList" }, new Dictionary<string, string> { { "data-condition", "dgStudentsOrderList" } })
                    </li>*@
                    <li class="sn" style="padding-left: 5px;">年级专业：</li>
                    <li class="sv">
                        @Html.ComboGrid(cgop, new Dictionary<string, string> { { "data-condition", "dgStudentsOrderList" } })
                    </li>
                </ul>
                <ul>
                    <li class="sn" style="padding-left: 5px;">教材名称：</li>
                    <li class="sv">
                        @Html.ComboGrid(TMName, new Dictionary<string, string> { { "data-condition", "dgStudentsOrderList" } })
                    </li>
                    <li class="sn" style="padding-left: 5px;">课程名称：</li>
                    <li class="sv">
                        @Html.ComboGrid(Csop, new Dictionary<string, string> { { "data-condition", "dgStudentsOrderList" } })
                    </li>
                    <li class="sn" style="padding-left: 5px;">课程类型：</li>
                    <li class="sv">
                        @Html.DictionaryDropDownList(EMIS.ViewModel.DictionaryItem.CF_CourseType, new DropdownListOptions { BindType = DropdownListBindType.SelectAll, Name = "CourseTypeDropdown", ID = "CourseTypeDropdown", OnSelect = "QueryCourseTypeDropdownList" }, new Dictionary<string, string> { { "data-condition", "dgStudentsOrderList" } })
                    </li>
                    <li class="sn" style="padding-left: 5px;">是否征订：</li>
                    <li class="sv">
                        @Html.DictionaryDropDownList(EMIS.ViewModel.DictionaryItem.CF_GeneralPurpose, new DropdownListOptions { BindType = DropdownListBindType.SelectAll, Name = "OrderedDropdown", ID = "OrderedDropdown", OnSelect = "QueryOrderedDropdownList", SelectedValue = 0 }, new Dictionary<string, string> { { "data-condition", "dgStudentsOrderList" } })
                    </li>
                    
                </ul>
            </div>
        </div>
    </form>
    <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("List")</div>
    </div>
    @Html.PositionBatchModify()
    <div class="search_list">
        @Html.DataGrid(new DataGridOptions
        {
            Columns = new List<DataGridColumn>() 
            { 
                    new CheckBoxFieldColumn{ HeaderText="",Align=AlignStyle.Center, FieldName="SpecialtyPlanID" },
                    new BoundFieldColumn { FieldName="SchoolyearCode", HeaderText="学年学期", Align=AlignStyle.Center ,CustomFormatFun="CodeSetColors",Width=0.06},
                    new BoundFieldColumn { FieldName="CollegeName", HeaderText=@EMIS.Utility.RSL.Get("College"), Align=AlignStyle.Center ,CustomFormatFun="CollegeSetColors",Width=0.06},
                    //new BoundFieldColumn { FieldName="Years", HeaderText="年级", Align=AlignStyle.Center,CustomFormatFun="YearsSetColors",Width=0.03},
                    //new BoundFieldColumn { FieldName="StandardName", HeaderText="专业名称", Align=AlignStyle.Center },
                    //new BoundFieldColumn { FieldName="GrademajorCode", HeaderText="年级专业代码", Align=AlignStyle.Center },
                    new BoundFieldColumn { FieldName="GrademajorName", HeaderText="年级专业名称", Align=AlignStyle.Center ,CustomFormatFun="GrademajorSetColors", Width=0.1 },
                    new BoundFieldColumn { FieldName="CourseCode", HeaderText="课程代码", Align=AlignStyle.Center,CustomFormatFun="CourseCodeSetColors" ,Width=0.05},         
                    new BoundFieldColumn { FieldName="CourseName", HeaderText="课程名称", Align=AlignStyle.Center,CustomFormatFun="CourseSetColors", Width=0.1, OverflowLength=15},
                    //new BoundFieldColumn { FieldName="CourseCategoryName", HeaderText="课程属性", Align=AlignStyle.Center },
                    //new BoundFieldColumn { FieldName="CourseTypeName", HeaderText="课程类型", Align=AlignStyle.Center },
                    //new BoundFieldColumn { FieldName="CourseQualityName", HeaderText="课程性质", Align=AlignStyle.Center },
                    new BoundFieldColumn { FieldName="ClassNum", HeaderText="人数", Align=AlignStyle.Center,CustomFormatFun="ClassSetColors",Width=0.02 },
                    new BoundFieldColumn { FieldName="OrderQty", HeaderText="征订数量", Align=AlignStyle.Center ,CustomFormatFun="QtySetColors",Width=0.04 },
                    new BoundFieldColumn { FieldName="PreIncreaseQty", HeaderText="增加数量", Align=AlignStyle.Center, Width=0.04 },
                    new BoundFieldColumn { FieldName="Count", HeaderText="总数量", Align=AlignStyle.Center, Width=0.03 },
                    //new BoundFieldColumn { FieldName="TeachingMaterialCode", HeaderText="教材编号", Align=AlignStyle.Center,CustomFormatFun="MaterialCodeSetColors", Width=0.04 },
                    new BoundFieldColumn { FieldName="TeachingMaterialName", HeaderText="教材名称", Align=AlignStyle.Center,CustomFormatFun="MaterialNameSetColors", Width=0.1, OverflowLength=15 },
                    new BoundFieldColumn { FieldName="IsOrderedName", HeaderText="是否征订", Align=AlignStyle.Center,CustomFormatFun="IsOrderedSetColors",Width=0.04 },
                    new BoundFieldColumn { FieldName="CoursematerialID", HeaderText="课程ID", IsHidden=true, Align=AlignStyle.Center }, 
                    new BoundFieldColumn { FieldName="IsOrdered", HeaderText="是否征订", IsHidden=true, Align=AlignStyle.Center }, 
                   // new BoundFieldColumn { FieldName="SpecialtyPlanID", HeaderText="专业计划ID",IsHidden=true, Align=AlignStyle.Center},
                    //new BoundFieldColumn { FieldName="CreateTime", HeaderText="创建时间", Align=AlignStyle.Center,Formatter= Formatter.LongDate },
            },

            IsCheckOnSelect = true,
            DataSourceUrl = Url.Content("~/StudentsOrder/List"),
            ID = "dgStudentsOrderList",
            IsPagination = true,
            IsShowRowNumbers = true,
            IsSingleSelect = false
        })
    </div>
</div>
@section scripts{
    <script src="../../Scripts/Business/TeachingMaterial/StudentsOrder.js" type="text/javascript"></script>
    <script type="text/javascript">
        var nonSelect = "@DropdownList.SELECT_ALL";
    </script>
    <script type="text/javascript">
        //设置单元格颜色
        function CollegeSetColors(index, row, value) {
            if (row.TeachingMaterialCode == null || row.TeachingMaterialCode == undefined || row.TeachingMaterialCode == "") {

                return " <span  style=\"color:red;\">" + value + "</span>";
            }
            else {
                return value
            }
        }

        function IsOrderedSetColors(index, row, value) {
            if (row.TeachingMaterialCode == null || row.TeachingMaterialCode == undefined || row.TeachingMaterialCode == "") {

                return " <span  style=\"color:red;\">" + value + "</span>";
            }
            else {
                return value
            }
        }

        function MaterialNameSetColors(index, row, value) {
            if (row.TeachingMaterialCode == null || row.TeachingMaterialCode == undefined || row.TeachingMaterialCode == "") {

                return " <span  style=\"color:red;\">" + value + "</span>";
            }
            else {
                return value
            }
        }

        function MaterialCodeSetColors(index, row, value) {
            if (row.TeachingMaterialCode == null || row.TeachingMaterialCode == undefined || row.TeachingMaterialCode == "") {

                return " <span  style=\"color:red;\">" + value + "</span>";
            }
            else {
                return value
            }
        }

        function CourseSetColors(index, row, value) {
            if (row.TeachingMaterialCode == null || row.TeachingMaterialCode == undefined || row.TeachingMaterialCode == "") {

                return " <span  style=\"color:red;\">" + value + "</span>";
            }
            else {
                return value
            }
        }



        function CodeSetColors(index, row, value) {
            if (row.TeachingMaterialCode == null || row.TeachingMaterialCode == undefined || row.TeachingMaterialCode == "") {

                return " <span  style=\"color:red;\">" + value + "</span>";
            }
            else {
                return value
            }
        }
        function YearsSetColors(index, row, value) {
            if (row.TeachingMaterialCode == null || row.TeachingMaterialCode == undefined || row.TeachingMaterialCode == "") {

                return " <span  style=\"color:red;\">" + value + "</span>";
            }
            else {
                return value
            }
        }
        function GrademajorSetColors(index, row, value) {
            if (row.TeachingMaterialCode == null || row.TeachingMaterialCode == undefined || row.TeachingMaterialCode == "") {

                return " <span  style=\"color:red;\">" + value + "</span>";
            }
            else {
                return value
            }
        }

        function CourseCodeSetColors(index, row, value) {
            if (row.TeachingMaterialCode == null || row.TeachingMaterialCode == undefined || row.TeachingMaterialCode == "") {

                return " <span  style=\"color:red;\">" + value + "</span>";
            }
            else {
                return value
            }
        }
        function ClassSetColors(index, row, value) {
            if (row.TeachingMaterialCode == null || row.TeachingMaterialCode == undefined || row.TeachingMaterialCode == "") {

                return " <span  style=\"color:red;\">" + value + "</span>";
            }
            else {
                return value
            }
        }

        function QtySetColors(index, row, value) {
            if (row.TeachingMaterialCode == null || row.TeachingMaterialCode == undefined || row.TeachingMaterialCode == "") {

                return " <span  style=\"color:red;\">" + value + "</span>";
            }
            else {
                return value
            }
        }
    </script>}