JW/EMIS.Web/Scripts/Business/ScoreManage/StudentScore.js

var url = CMS_SystemConfig.VirtualDirectoryPath + "/StudentScore/Edit";
var urlAdd = CMS_SystemConfig.VirtualDirectoryPath + "/StudentScore/Add";
var mnu = "";
//加载
$(function () {
    mnu = $.SystemGeneral.getUrlParam("MNU");
    SystemBatchModifyControl.OnComplete = function (columnName, modifyValue, batch) {
        $.postWithLoading(CMS_SystemConfig.VirtualDirectoryPath + "/StudentScore/RefreshFinallyScoreForBatchUpdate", {
            submitedScoreIDString: batch.join(',')
        });
    };
})

//新增
function StudentScore_Add() {

    var d = validChoose();
    var SchoolyearID = "";
    var CoursematerialID = "";
    var UserID = "";
    var StarttermID = "";

    if (d.length > 0) {
        if (d.length > 1) {
            $.messager.alert("系统提示", "只能选择单个记录进行复制。");
            return;
        }
        var redirectTo = CMS_SystemConfig.VirtualDirectoryPath + "/PersonalScore/Edit?SubmitedScoreID=" + d + "&SchoolyearID=" + SchoolyearID + "&CoursematerialID=" + CoursematerialID + "&UserID=" + UserID + "&StarttermID=" + StarttermID + "&atype=1&MNU=" + mnu + "&SaveType=Add";
        $.popupTopWindow('学生成绩复制新增', redirectTo, 800, 480, null, null);

    } else {
        var redirectTo = CMS_SystemConfig.VirtualDirectoryPath + "/PersonalScore/Edit?SubmitedScoreID=" + d + "&SchoolyearID=" + SchoolyearID + "&CoursematerialID=" + CoursematerialID + "&UserID=" + UserID + "&StarttermID=" + StarttermID + "&atype=1&MNU=" + mnu;
        $.popupTopWindow('学生成绩新增', redirectTo, 800, 480, null, null);
    }
}
function reload() {
    $("#dgStudentScoreList").cmsXDataTable("load", $.getDataGridParams("dgStudentScoreList"));
}
//获取选中的数据
function validChoose() {
    var d = [];
    $.each($("#dgStudentScoreList").cmsXDataTable("getSelections"), function (index) {
        d.push(this.SubmitedScoreID);
    });
    return d;
}
//获取列表字段查询对应比较符
function GetDynamicCondition() {
    var reg = "/(^/s*)|(/s*$)/g";
    var attribute = eval('(' + $("[name='Attribute']").val() + ')').Value;
    var conditionString = $("[name='Condition']").val();
    var value = $("[name='Condition']").parent().parent().next().find("[name^=" + attribute + "]").val();
    value = $.trim(value);
    var sql = "";
    if (conditionString == "=" || conditionString == ">" || conditionString == "<" || conditionString == "<>") {
        sql = attribute + conditionString + value;
    } else if (conditionString == "左") {
        sql = attribute + " like '" + value + "%'";
    } else if (conditionString == "右") {
        sql = attribute + " like '%" + value + "'";
    } else if (conditionString == "中") {
        sql = attribute + " like '%" + value + "%'";
    }
    return sql;
}
function StudentScore_Report() {
    var d = [];
    $.each($("#dgStudentScoreList").cmsXDataTable("getSelections"), function (index) {
        d.push(this.UserID);
    });
    var ReportName = $(CMS_SystemConfig.GetConfig()).find("configuration>reportServer>customReportName[name='StudentScoreView']").attr("customName");
    if (ReportName == "GzzyStudentScoreReport")
    {
        var sql = GetDynamicCondition();
        var schoolYearID = $("#SchoolyearDropdown").combobox("getValue");
        var collegeID = $("#CollegeComboGrid").combogridX("getValue");
        var yearID = $("#DictionaryGrade").combobox("getValue");
        var standardID = $("#StandardID").combogridX("getValue");
        var education = $("#DictionaryEducation").combobox("getValue");
        var learningFormID = $("#LearningformDictionaryDropDown").combobox("getValue");
        var learnSystem = $("#DictionaryLearnSystem").combogridX("getValue");
        var classmajorID = $("#ClassmajorDropdown").combogridX("getValue");
        var coursematerialID = $("#CoursematerialComboGrid").combogridX("getValue");
        var courseType = $("#DictionaryCourseType").combobox("getValue");
        var examsCategory = $("#DictionaryExamsCategory").combobox("getValue");
        var starttermBegin = $("#DictionaryStarttermBegin").combobox("getValue");
        var starttermEnd = $("#DictionaryStarttermEnd").combobox("getValue");
        var conditionString = sql;
        var ids = d.join(',');
        var redirectTo = CMS_SystemConfig.VirtualDirectoryPath + '/StudentScore/GzzyStudentScoreReport?MNU=' + mnu;
        $.popupTopWindow('学生成绩报表', redirectTo, 1100, 550, null, {
            CollegeID: collegeID,
            YearID: yearID,
            ClassmajorID: classmajorID,
            SchoolYearID: schoolYearID,
            StandardID: standardID,
            Education: education,
            LearningFormID: learningFormID,
            LearnSystem: learnSystem,
            CoursematerialID: coursematerialID,
            CourseTypeID: courseType,
            ExamsCategoryID: examsCategory,
            StarttermBegin: starttermBegin,
            StarttermEnd: starttermEnd,
            ConditionString: conditionString,
            Ids: ids
        });
    }
    else if (ReportName == "HBKDStudentFinallyScoreView") 
    {
        var sql = GetDynamicCondition();
        var schoolYearID = $("#SchoolyearDropdown").combobox("getValue");
        var collegeID = $("#CollegeComboGrid").combogridX("getValue");
        var yearID = $("#DictionaryGrade").combobox("getValue");
        var standardID = $("#StandardID").combogridX("getValue");
        var education = $("#DictionaryEducation").combobox("getValue");
        var learningFormID = $("#LearningformDictionaryDropDown").combobox("getValue");
        var learnSystem = $("#DictionaryLearnSystem").combogridX("getValue");
        var classmajorID = $("#ClassmajorDropdown").combogridX("getValue");
        var coursematerialID = $("#CoursematerialComboGrid").combogridX("getValue");
        var courseType = $("#DictionaryCourseType").combobox("getValue");
        var examsCategory = $("#DictionaryExamsCategory").combobox("getValue");
        var starttermBegin = $("#DictionaryStarttermBegin").combobox("getValue");
        var starttermEnd = $("#DictionaryStarttermEnd").combobox("getValue");
        var conditionString = sql;
        var ids = d.join(',');
        var redirectTo = CMS_SystemConfig.VirtualDirectoryPath + '/StudentScore/HBKDStudentScoreReport?MNU=' + mnu;
        $.popupTopWindow('学生成绩报表', redirectTo, 1100, 550, null, {
            CollegeID: collegeID,
            YearID: yearID,
            ClassmajorID: classmajorID,
            SchoolYearID: schoolYearID,
            StandardID: standardID,
            Education: education,
            LearningFormID: learningFormID,
            LearnSystem: learnSystem,
            CoursematerialID: coursematerialID,
            CourseTypeID: courseType,
            ExamsCategoryID: examsCategory,
            StarttermBegin: starttermBegin,
            StarttermEnd: starttermEnd,
            ConditionString: conditionString,
            Ids: ids
        });
    }
    else {
        var Attribute = document.getElementsByName("Attribute")[0].value.split("\"Value\":\"")[1].split("\"")[0];   //获取当前的字段
        var redirectTo = CMS_SystemConfig.VirtualDirectoryPath + '/StudentScore/StudentScoreReport?MNU=' + mnu;
        if (d.length > 0) {
            redirectTo = redirectTo + "&UserIDs=" + d.join(",");
        }
        else {
            redirectTo = redirectTo + "&CollegeID=" + $("#CollegeComboGrid").combogridX("getValue")
            + "&Years=" + $("#DictionaryGrade").combobox("getValue")
                    //+ "&GrademajorID=" + $("#GrademajorComboGrid").combogridX("getValue")
            + "&ClassmajorID=" + $("#ClassmajorDropdown").combogridX("getValue")
            + "&CoursematerialID=" + $("#CoursematerialComboGrid").combogridX("getValue")
            + "&CourseTypeID=" + $("#DictionaryCourseType").combobox("getValue")
            + "&SchoolYearID=" + $("#SchoolyearDropdown").combobox("getValue")
            + "&ExamsCategoryID=" + $("#DictionaryExamsCategory").combobox("getValue")

            + "&StandardID=" + $("#StandardID").combogridX("getValue")
            + "&EducationID=" + $("#DictionaryEducation").combobox("getValue")
            + "&LearningformID=" + $("#LearningformDictionaryDropDown").combobox("getValue")
            + "&LearnSystem=" + $("#DictionaryLearnSystem").combogridX("getValue")
            + "&StarttermBegin=" + $("#DictionaryStarttermBegin").combobox("getValue")
            + "&StarttermEnd=" + $("#DictionaryStarttermEnd").combobox("getValue")
            + "&UserIDs="
            + "&Attribute=" + Attribute
            + "&Condition=" + document.getElementsByName("Condition")[0].value + "&Value=" + document.getElementsByName(Attribute + "_QueryTextBox")[0].value;
        }
        $.popupTopWindow('学生成绩表', redirectTo, 1100, 550, null, null);
    }
    
}

//点击列表更新
function edit(rowindex, rowdata) {
    var redirectTo = CMS_SystemConfig.VirtualDirectoryPath + "/PersonalScore/Edit" + "?submitedScoreID=" + rowdata.SubmitedScoreID + "&MNU=" + mnu + '&isView=1';
    $.popupTopWindow('学生成绩信息详情', redirectTo, 800, 420, null, null);
}
//修改按钮
function StudentScore_Update() {
//    var d = validChoose();
//    if (d == "") {
//        $.messager.alert("系统提示", "请选择您要修改的学生成绩信息。");
//        return;
//    }
//    if (d.length > 1) {
//        $.messager.alert("系统提示", "只能选择单个记录进行修改。");
//        return;
//    }
//    var redirectTo = url + "?submitedScoreID=" + d + "&MNU=" + mnu;
    //    $.popupTopWindow('学生成绩信息修改', redirectTo, 800, 420, null, null);
    var d = validChoose();
    var SchoolyearID = $("#hid_SchoolyearID").val();
    var CoursematerialID = $("#hid_CoursematerialID").val();
    var UserID = $("#hid_UserID").val();
    var StarttermID = $("#hid_StarttermID").val();
    if (d == "") {
        $.messager.alert("系统提示", "请选择您要修改的成绩基本信息。");
        return;
    }
    if (d.length > 1) {
        $.messager.alert("系统提示", "只能选择单个记录进行修改。");
        return;
    }
    var redirectTo = CMS_SystemConfig.VirtualDirectoryPath + "/PersonalScore/Edit?SubmitedScoreID=" + d + "&SchoolyearID=" + SchoolyearID + "&CoursematerialID=" + CoursematerialID + "&UserID=" + UserID + "&StarttermID=" + StarttermID + "&atype=2&MNU=" + mnu;
    $.popupTopWindow('学生成绩修改', redirectTo, 800, 480, null, null);
}
//删除
function StudentScore_Delete() {
    var d = validChoose().join(',');
    if (d == "") {
        $.messager.alert("系统提示", "请选择您要删除的学生成绩信息！");
        return;
    }
    $.messager.confirm("系统提示", "您确定要删除该学生成绩信息？", function (r) {
        if (r) {
            $.postWithLoading(CMS_SystemConfig.VirtualDirectoryPath + '/StudentScore/Delete', { submitedScoreIDs: d }, function (data) {
                if (data == "删除成功") {
                    $.messager.alert("系统提示", "删除成功!");
                    $("#dgStudentScoreList").cmsXDataTable('load');
                } else {
                    $.messager.alert("系统提示", data);
                }
            });
        }
    });
}

function queryStandard(data) {
    queryClass();
    reload();
}
function queryCollege(data) {
    var campusID = $("#CampusDropdown").combogridX("getValue");
    var collegeID = $("#CollegeComboGrid").combogridX("getValue");
    var jsonString = "({'QueryParamsDatas':'CampusDropdown|*|" + campusID + "|@|";
    jsonString += "CollegeDropdown|*|" + collegeID + "|@|'})";
    //        if (campusID != nonSelect) {
    //            var jsonString = "({'QueryParamsDatas':'CampusDropdown|*|" + campusID + "|@|'})";
    //            $("#CollegeDropdown").combogridX("reload", eval(jsonString));
    //        }
    queryClass();
    reload();
}
function queryClass() {
    var jsonString = "";
    var parameterString = "";
    var campusID = $("#CampusDropdown").combogridX("getValue");
    var collegeID = $("#CollegeComboGrid").combogridX("getValue");
    var schoolYearID = $("#DictionaryGrade").combobox("getValue");
    var standardID = $("#StandardID").combogridX("getValue");
    var educationID = $("#DictionaryEducation").combobox("getValue");
    var LearnSystem = $("#DictionaryLearnSystem").combogridX("getValue");
    var learningFormID = $("#LearningformDictionaryDropDown").combobox("getValue");
    if (campusID != nonSelect) parameterString += "CampusDropdown|*|" + campusID + "|@|";
    if (collegeID != nonSelect) parameterString += "CollegeDropdown|*|" + collegeID + "|@|";
    if (schoolYearID != nonSelect) parameterString += "DictionaryGrade|*|" + schoolYearID + "|@|";
    if (standardID != nonSelect) parameterString += "DictionaryStandard|*|" + standardID + "|@|";
    if (educationID != nonSelect) parameterString += "DictionaryEducation|*|" + educationID + "|@|";
    if (learningFormID != nonSelect) parameterString += "DictionaryLearningform|*|" + learningFormID + "|@|";
    if (LearnSystem != nonSelect) parameterString += "DictionaryLearnSystem|*|" + LearnSystem + "|@|";
    if (parameterString != "") {
        jsonString = "({'QueryParamsDatas':'" + parameterString + "'})";
        $("#StandardID").combogridX("reload", eval(jsonString));
        $("#ClassmajorDropdown").combogridX("reload", eval(jsonString));
    } else {
        $("#StandardID").combogridX("reload", eval(jsonString));
        $("#ClassmajorDropdown").combogridX("reload");
    }
    reload();
}


//function SelectCollegeComboGrid(data) {
//    if (data != null) {
//        reloadStandard();
//    }
//}
//function SelectDictionaryGrade(data) {
//    if (data.Value != "-1") {
//        selectClass();
//    }
//}
//function reloadStandard() {
//    var url = CMS_SystemConfig.VirtualDirectoryPath + "/Facultymajor/BindStandardDropDownList?bindType=0";
//    var collegeID = $("#CollegeComboGrid").combogridX("getValue");
//    if (collegeID != nonSelect) url += "&collegeID=" + collegeID;
//    $("#StandardID").combobox("reload", url);
//}
//function SelectStandard(data) {
//    if (data != null) {
//        selectClass();
//    }
//    reload();
//}
function selectClass() {
    var collegeID = $("#CollegeComboGrid").combogridX("getValue");
    var year = $("#DictionaryGrade").combobox("getValue");
    var standard = $("#StandardID").combobox("getValue");

    var jsonString = "({'QueryParamsDatas':'CollegeDropdown|*|" + collegeID + "|@|DictionaryGrade|*|" + year 
        + "|@|DictionaryStandard|*|" + standard + "|@|'})";
    $("#ClassmajorDropdown").combogridX("reload", eval(jsonString));
    reload();
}

//导出Excel
function StudentScore_Excel() {
    var d = validChoose().join(',')
    if (d != "") {
        document.getElementById("SubmitedScoreID").value = d;
    }
    else {
        document.getElementById("SubmitedScoreID").value = "";
    }
    $("#formQuery").submit();
}