//<reference path = "../../../Scripts/jQuery-1.4.1.js"/>
var sqlExpression = "";
var reloadNum = 0;
var rownum = 10;
var curcode = "";
var sign = "";
var semesterSelText = "";
var semesterSelValue = "";
var dkTypeSelText = "";
var dkTypeSelValue = "";
var admissionBatchs = ""; //招生批次
var educationLevel = ""; //学历层次
var professionalNature = ""; //专业类别
var semester = ""; //学期
var admissionPrefessional = ""; //招生专业
var lastsel;
var curriculumsInfo = JSON.stringify({
admissionBatchs: admissionBatchs,
rowNum: rownum,
page: 1,
sqlWhere: ""
});
var courseSelId = ""; //选择行的课程安排ID
var currId = JSON.stringify({
courseSelId: curcode,
sign: sign
});
$(function () {
$("#Curr_admission_prefessional_name").focus(function () {
if ($("#Curr_admission_prefessional_name").val() == "请输入拼音码") {
$("#Curr_admission_prefessional_name").val("").css("color", "");
}
});
$("#Curr_admission_prefessional_name").blur(function () {
if ($("#Curr_admission_prefessional_name").val() == "") {
$("#Curr_admission_prefessional_name").css("color", "#ccc").val("请输入拼音码");
}
});
$("#TeacherChoose").focus(function () {
if ($("#TeacherChoose").val() == "请输入拼音码") {
$("#TeacherChoose").val("").css("color", "");
}
});
$("#TeacherChoose").blur(function () {
if ($("#TeacherChoose").val() == "") {
$("#TeacherChoose").css("color", "#ccc").val("请输入拼音码");
}
});
$("#teachingChoose").focus(function () {
if ($("#teachingChoose").val() == "请输入拼音码") {
$("#teachingChoose").val("").css("color", "");
}
});
$("#teachingChoose").blur(function () {
if ($("#teachingChoose").val() == "") {
$("#teachingChoose").css("color", "#ccc").val("请输入拼音码");
}
});
$(".radioItem").change(
function () {
var $selectedvalue = $("input[name='isSel']:checked").val();
if ($selectedvalue == 0) {
$("#TeacherChoose").attr("disabled", true);
}
else {
$("#TeacherChoose").show().attr("disabled", false);
}
});
$(".ItemTeaching").change(
function () {
var $TeachingValue = $("input[name='teachingSel']:checked").val();
if ($TeachingValue == 0) {
$("#teachingChoose").attr("disabled", true);
}
else {
$("#teachingChoose").show().attr("disabled", false);
}
});
});
$(function () {
$("#Curr_admission_prefessional_name").focus(function () {
if ($("#Curr_admission_prefessional_name").val() == "请输入拼音码") {
$("#Curr_admission_prefessional_name").val("").css("color", "");
}
});
$("#Curr_admission_prefessional_name").blur(function () {
if ($("#Curr_admission_prefessional_name").val() == "") {
$("#Curr_admission_prefessional_name").css("color", "#ccc").val("请输入拼音码");
}
});
$("#TeacherChoose").focus(function () {
if ($("#TeacherChoose").val() == "请输入拼音码") {
$("#TeacherChoose").val("").css("color", "");
}
});
$("#TeacherChoose").blur(function () {
if ($("#TeacherChoose").val() == "") {
$("#TeacherChoose").css("color", "#ccc").val("请输入拼音码");
}
});
$("#teachingChoose").focus(function () {
if ($("#teachingChoose").val() == "请输入拼音码") {
$("#teachingChoose").val("").css("color", "");
}
});
$("#teachingChoose").blur(function () {
if ($("#teachingChoose").val() == "") {
$("#teachingChoose").css("color", "#ccc").val("请输入拼音码");
}
});
});
//定义表格
$(document).ready(function () {
$.ajaxSetup({
cache: false //设置为 false 将不会从浏览器缓存中加载请求信息
});
// 设置表格属性
$("#CurriculumsGird").jqGrid({
url: "",
datatype: "local", //返回数据的类型
mtype: 'post',
height: 240, //设置高度
rowNum: 10,
pager: "#CurriculumsPager",
pgtext: "第{0}页 共{1}页",
viewrecords: true, //是否显示总记录数
recordpos: "left", //记录数显示位置
pginput: true, //是否允许输入翻页的页数
autowidth: true, //自动设置宽度
pgbuttons: true,
scrollrows: true,
multiselect: true, //显示多选
subGrid: true, //设置专业课程子表格
subGridRowExpanded: function (subgrid_id, row_id) {
var currId = JSON.stringify({
courseSelId: row_id,
sign: "subGrid"
});
var subgrid_table_id;
subgrid_table_id = subgrid_id + "_t";
jQuery("#" + subgrid_id).html("<table id='" + subgrid_table_id
+ "' class='scroll'></table>");
jQuery("#" + subgrid_table_id).jqGrid({
url: "", //获取老师有关信息以及对应的课程安排
datatype: "json",
height: "100%",
postData: {
strJson: currId
},
colNames: ['老师姓名', '代课类型', '学期', ''],
colModel: [
{
name: "teacherName",
index: "teacherName",
width: 100
}, {
name: "dk_type",
index: "dk_type",
width: 100
}, {
name: "sub_semester",
index: "sub_semester",
width: 100
}, {
name: "courseplanid",
index: "courseplanid",
hidden: true
}
],
sortname: 'teacherName',
sortorder: "asc",
jsonReader: {
root: "rows",
repeatitems: false,
id: "courseplanid"
}
});
},
//分页代码
onPaging: function (pgButton) {
//上一页
if (pgButton == "prev") {
curriculumsInfo = JSON.stringify({
rowNum: 10,
page: jQuery("#CurriculumsGird").jqGrid("getGridParam", "page")
});
}
//下一页
if (pgButton == "next") {
curriculumsInfo = JSON.stringify({
rowNum: 10,
page: jQuery("#CurriculumsGird").jqGrid("getGridParam", "page")
});
}
//首 页
if (pgButton == "first") {
curriculumsInfo = JSON.stringify({
rowNum: 10,
page: 1
});
}
// 尾 页
if (pgButton == "last") {
curriculumsInfo = JSON.stringify({
rowNum: 10,
page: 0
});
}
jQuery("#CurriculumsGird").jqGrid("setGridParam", {
postData: {
strJson: curriculumsInfo
}
});
},
onSortCol: function () {
var cilId = JSON.stringify({
rowNum: rownum,
page: 1,
sqlWhere: sqlExpression
});
jQuery("#CourseNostudyApplicationGrid").jqGrid("setGridParam", { postData: { strJson: cilId} });
jQuery("#CourseNostudyApplicationGrid").trigger("reloadGrid");
},
ondblClickRow: function (editRowId) {
curcode = $('#CurriculumsGird').jqGrid("getCell", editRowId, "course_plan_id");
textbookIds = $('#CurriculumsGird').jqGrid("getCell", editRowId, "book_no");
},
//设置每列列名
colNames: ['编号', '课程名称', '课程类别', '考核方式', '学期', '主讲教师', '学分', '学时', '教材', ''],
colModel: [{
name: 'course_plan_id',
index: 'course_plan_id',
width: 130,
align: "left",
editable: true
}, {
name: 'course_name',
index: 'course_name',
width: 150,
align: "left",
editable: true
}, {
name: 'course_type',
index: 'course_type',
width: 130,
align: "left",
editable: true
}, {
name: 'examine_way',
index: 'examine_way',
width: 100,
align: "left",
editable: true
}, {
name: 'semester',
index: 'semester',
width: 120,
align: "center",
editable: true
}, {
name: 'principal_teach',
index: 'principal_teach',
width: 100,
align: "left",
editable: true
}, {
name: 'credithour',
index: 'credithour',
width: 80,
align: "center",
editable: true
}, {
name: 'study_hours',
index: 'study_hours',
width: 80,
align: "center",
editable: true
}, {
name: 'name',
index: 'name',
width: 130,
align: "center",
editable: true
}, {
name: 'book_no',
index: 'book_no',
hidden: true
}
],
jsonReader: { //读取数据
root: "rows",
repeatitems: false,
id: "course_plan_id"
},
gridComplete: function () {
var graduateIds = jQuery("#CurriculumsGird").jqGrid('getDataIDs');
for (var i = 0; i < graduateIds.length; i++) {
var cl = graduateIds[i];
var link = "<a href=''><font color='blue'>xxxxx</font></a>";
jQuery("#CurriculumsGird").jqGrid('setRowData', cl, { name: link }); //给grid添加下拉列表
}
var currIds = jQuery("#CurriculumsGird").jqGrid('getDataIDs');
for (var i = 0; i < currIds.length; i++) {
var cl_curr = currIds[i];
var link_curr = "<a href=''><font color='blue'>xxxxx</font></a>";
jQuery("#CurriculumsGird").jqGrid('setRowData', cl_curr, { principal_teach: link_curr }); //给grid添加下拉列表
}
}
});
//添加测试数据
var mydata = [
{ course_plan_id: "001", course_name: "医学", course_type: "中医药学", examine_way: "通过", semester: "第一学期", principal_teach: "", credithour: "120", study_hours: "63", book_no: "" },
{ course_plan_id: "002", course_name: "生物", course_type: "生物化学", examine_way: "不通过", semester: "第二学期", principal_teach: "", credithour: "89", study_hours: "56", book_no: "" },
{ course_plan_id: "003", course_name: "计算机科学与技术", course_type: "地球科学", examine_way: "通过", semester: "第三学期", principal_teach: "", credithour: "30", study_hours: "10", book_no: "" }
];
for (var i = 0; i <= mydata.length; i++) jQuery("#CurriculumsGird").jqGrid('addRowData', i + 1, mydata[i]);
jQuery("#CurriculumsGird").jqGrid("navGrid", "#CurriculumsPager", { // jqGrid 默认的功能按钮
refresh: false, //刷新
edit: false, //修改 是否可用
add: false, //增加
del: false, //删除
search: false, //在当前列表搜索
position: "right" //水平位置
});
$("#AppointSemester").click(function () {
var course_plan_id = $("#CurriculumsGird").jqGrid('getGridParam', 'selarrrow');
if (course_plan_id != null && course_plan_id != "") {
curriculumsInfo = JSON.stringify({
course_plan_id: course_plan_id
});
showSemester();
}
else {
jAlert("请选择需要指定学期的记录!", "提示信息");
}
});
//指定学期的确定按钮
$("#Curr_btnSubmit").click(function () {
$("#clm_semester").change(function () {
if ($("#clm_semester").val() == "") {
jAlert("请选择要指定的学期!", "提示信息");
return;
}
$("#clm_semester").prepend("<option value='0'>请选择</option>");
var checkText = $("#clm_semester").find("option:selected").text(); //获取Select选择的Text
var checkValue = $("#clm_semester").val(); //获取Select选择的Value
});
$.ajax({
url: "",
dataType: 'json',
type: "POST",
data: {
strJson: JSON.stringify({
course_plan_id: course_plan_id,
checkText: semesterSelText,
checkValue: semesterSelValue
})
},
clearForm: true,
success: function (data) {
var json = eval("(" + data + ")");
jAlert(json.msg, "提示信息");
$("#CurriculumsGird").trigger("reloadGrid");
$("#clm_semester").val("");
}
});
});
//取消按钮
$("#Curr_btnCancel").click(function () {
$("#CurriculumsSemester,#CurriculumsMark").hide();
});
$("#AppointTeacher").click(function () {
var course_plan_id = $("#CurriculumsGird").jqGrid('getGridParam', 'selarrrow');
if (course_plan_id != null && course_plan_id != "") {
curriculumsInfo = JSON.stringify({
course_plan_id: course_plan_id
});
$("#CourseTeacherGrid").jqGrid('GridUnload'); //卸载第一次加载的数据
showCourseTeacherChoose();
ShowCourseTeacher();
}
else {
jAlert("请选择需要指定教师的记录!", "提示信息");
}
});
//指定教师的保存按钮
$("#curr_btnSave").click(function () {
$("#clm_dk_type").change(function () {
if ($("#clm_dk_type").val() == "") {
jAlert("请选择要指定的代课类型!", "提示信息");
return;
}
$("#clm_dk_type").prepend("<option value='0'>请选择</option>");
var checkText = $("#clm_dk_type").find("option:selected").text(); //获取Select选择的Text
var checkValue = $("#clm_dk_type").val(); //获取Select选择的Value
$.ajax({
url: "",
dataType: 'json',
type: "POST",
data: {
strJson: JSON.stringify({
checkText: dkTypeSelText,
checkValue: dkTypeSelValue
})
},
clearForm: true,
success: function (data) {
var json = eval("(" + data + ")");
jAlert(json.msg, "提示信息");
$('.inner').append('<input type="checkbox" id="ck_before_record"/><a href="">xxxx</a>');
}
});
});
//新指定教师
if ($("#TeacherChoose").val() == "") {
jAlert("请选择要指定的教师!", "提示信息");
return;
}
$.ajax({
url: "",
dataType: 'json',
type: "POST",
data: {
strJson: JSON.stringify({
course_plan_id: course_plan_id,
teacher_id: $("#teacherSelId").val()
})
},
clearForm: true,
success: function (data) {
var json = eval("(" + data + ")");
jAlert(json.msg, "提示信息");
$("#CourseTeacherGrid").trigger("reloadGrid");
$("#TeacherChoose").val("");
}
});
});
//增加教师信息
$("#curr_btnAdd").click(function () {
//jQuery("#CourseTeacherGrid").jqGrid('editGridRow', "new", { height: 200, reloadAfterSubmit: false });
var rowdata = {
name: "",
sex: "",
tel: "",
dk_type: "",
state: ""
}
var arrIds = jQuery("#CourseTeacherGrid").jqGrid('getDataIDs');
var i = arrIds.length + 1;
$('#CourseTeacherGrid').jqGrid('addRowData', i, rowdata);
});
//教师取消页面
$("#curr_btnAbolish").click(function () {
$("#CourseTeacherChoose,#CurriculumsMark").hide();
});
//删除
$("#curr_btnDelete").click(function () {
var gr = $("#CourseTeacherGrid").jqGrid("getGridParam", "selarrrow");
if (gr != null && gr != "") {
jConfirm("确认删除所选记录", "提示信息", function (r) {
if (r == true) {
var strTemp = gr.join("&");
$.ajax({
url: "",
type: "POST",
data: {
gr: strTemp
},
success: function (data) {
var json = eval("(" + data + ")");
jAlert(json.msg, "提示信息");
$("#CourseTeacherGrid").trigger("reloadGrid");
}
});
}
});
}
else {
jAlert("请选择需要删除的记录?", "提示信息");
}
});
$("#Appointteaching").click(function () {
var course_plan_id = $("#CurriculumsGird").jqGrid('getGridParam', 'selarrrow');
if (course_plan_id != null && course_plan_id != "") {
curriculumsInfo = JSON.stringify({
course_plan_id: course_plan_id
});
$("#UseTeachingGrid").jqGrid('GridUnload'); //卸载第一次加载的数据
showUseTeachering();
ShowUseTeachingDialog();
}
else {
jAlert("请选择需要指定教材的记录!", "提示信息");
}
});
//指定教材的确定按钮
$("#curr_btnEnsure").click(function () {
if ($("#teachingChoose").val() == "") {
jAlert("请选择要指定的教材!", "提示信息");
return;
}
$.ajax({
url: "",
dataType: 'json',
type: "POST",
data: {
strJson: JSON.stringify({
course_plan_id: course_plan_id,
book_no: $("#teaching_bookno").val()
})
},
clearForm: true,
success: function (data) {
var json = eval("(" + data + ")");
jAlert(json.msg, "提示信息");
$("#UseTeachingGrid").trigger("reloadGrid");
$("#teachingChoose").val("");
}
});
});
//指定教材取消按钮
$("#curr_btnAbrogate").click(function () {
$("#UseTeachingChose,#CurriculumsMark").hide();
});
//报表输出
$("#JournalingOutput").click(function () {
});
//教师
function ShowCourseTeacher() {
$("#CurriculumsForm div.message").remove();
jQuery("#CourseTeacherGrid").jqGrid({
datatype: "json",
url: "",
postData: {
strJson: courseSelId
},
height: 150,
width: 450,
scrollrows: true,
rowNum: 10,
viewrecords: true,
multiselect: true,
recordpos: "left",
colNames: ['教师姓名', '性别', '电话', '教师类型', '代课类型', '教师状态', ''],
colModel: [{
name: 'name',
index: 'name',
width: 200,
sortable: true,
editable: true,
align: 'left'
}, {
name: 'sex',
index: 'sex',
width: 200,
sortable: true,
editable: true,
edittype: 'select',
editoptions:{value:"1:男;2:女"},
align: 'left'
}, {
name: 'tel',
index: 'tel',
width: 200,
sortable: true,
editable: true,
align: 'left'
}, {
name: 'type',
index: 'type',
width: 200,
sortable: true,
editable: true,
align: 'left'
}, {
name: 'dk_type',
index: 'dk_type',
width: 200,
sortable: true,
editable: true,
align: 'left'
}, {
name: 'state',
index: 'state',
width: 200,
sortable: true,
editable: true,
align: 'left'
}, {
name: 'id',
index: 'id',
width: 200,
hidden: true
}],
jsonReader: { //读取服务器端数据
root: "rows",
repeatitems: false,
id: "book_no"
},
ondblClickRow: function (id) {
if (id && id != lastsel) {
if (typeof lastsel != "undefined") {
$('#CourseTeacherGrid').jqGrid('saveRow', lastsel, null, "clientArray");
$('#CourseTeacherGrid').jqGrid('restoreRow', lastsel); //恢复行的状态
}
}
$('#CourseTeacherGrid').jqGrid('editRow', id, false);
lastsel = id;
}
});
};
//获取教材信息
function ShowUseTeachingDialog() {
jQuery("#UseTeachingGrid").jqGrid({
url: "",
datatype: "json",
postData: {
strJson: currId
},
height: 120,
width: 300,
scrollrows: true,
rowNum: 10,
viewrecords: true,
multiselect: true,
recordpos: "left",
colNames: ['教材名称'],
colModel: [{
name: 'name',
index: 'name',
width: 200,
sortable: true,
editable: true,
align: 'left'
}],
jsonReader: { //读取服务器端数据
root: "rows",
repeatitems: false,
id: "book_no"
}
});
};
//报表输出
$("#teachingInfo").click(function () {
if ($("#teachingChoose").val == null && $("#teachingChoose").val == "") {
jAlert("请选择教材!", "提示信息");
return;
} else {
location.href = "/TeachingMaterials/Index/";
}
});
//学期
function showSemester() {
var id = $("#CurriculumsSemester");
var maskHeight = $("#tabs").height();
var maskWidth = $("#tabs").width();
$('#CurriculumsMark').css({ 'width': maskWidth,
'height': maskHeight
});
$('#CurriculumsMark').fadeIn(100).fadeTo("slow", 0.8);
$(id).css('top', maskHeight / 2 - $(id).height() / 2);
$(id).css('left', maskWidth / 2 - $(id).width() / 2);
$(id).css("display", "block");
};
//教材
function showUseTeachering() {
var id = $("#UseTeachingChose");
var maskHeight = $("#tabs").height();
var maskWidth = $("#tabs").width();
$('#CurriculumsMark').css({ 'width': maskWidth,
'height': maskHeight
});
$('#CurriculumsMark').fadeIn(100).fadeTo("slow", 0.8);
$(id).css('top', maskHeight / 2 - $(id).height() / 2);
$(id).css('left', maskWidth / 2 - $(id).width() / 2);
$(id).css("display", "block");
};
//教师
function showCourseTeacherChoose() {
var id = $("#CourseTeacherChoose");
var maskHeight = $("#tabs").height();
var maskWidth = $("#tabs").width();
$('#CurriculumsMark').css({ 'width': maskWidth,
'height': maskHeight
});
$('#CurriculumsMark').fadeIn(100).fadeTo("slow", 0.8);
$(id).css('top', maskHeight / 2 - $(id).height() / 2);
$(id).css('left', maskWidth / 2 - $(id).width() / 2);
$(id).css("display", "block");
};
//选择开课的学期的关闭按钮
$("#imgCloseSemester").click(function () {
$("#CurriculumsSemester,#CurriculumsMark").hide();
});
//选择课程教师的关闭按钮
$("#imgCourseTeacher").click(function () {
$("#CurCourseTeacher,#CurriculumsMark").hide();
});
//选择使用的教材
$("#imgUseTeachingChose").click(function () {
$("#UseTeachingChose,#CurriculumsMark").hide();
});
//选择课程教师
$("#imgCourseTeacher").click(function () {
$("#CourseTeacherChoose,#CurriculumsMark").hide();
});
// 查询按钮
$("#btnQuery").click(function () {
sqlExpression = "";
var Curr_recruitBatch = $("#Curr_recruitBatch").val(); //招生批次
var Curr_educatioLevel = $("#Curr_educatioLevel").val(); //学历层次
var Curr_professionCategory = $("#Curr_professionCategory").val(); //专业性质
var Curr_semester = $("#Curr_semester").val(); //学期
var Curr_admission_prefessional_name = $("#name").val(); //招生专业
if (Curr_admission_prefessional_name == "请输入拼音码") {
Curr_admission_prefessional_name = "";
}
//文本框判断结束
var curriclumsQuery = JSON.stringify({
rowNum: rownum,
page: 1,
sqlWhere: sqlExpression,
Curr_recruitBatch: Curr_recruitBatch,
Curr_educatioLevel: Curr_educatioLevel,
Curr_professionCategory: Curr_professionCategory,
Curr_semester: Curr_semester,
Curr_admission_prefessional_name: Curr_admission_prefessional_name
});
jQuery("#CurriculumsGird").jqGrid("setGridParam", {
postData: { strJson: curriclumsQuery }
});
$("#CurriculumsGird").trigger("reloadGrid");
});
});
//招生专业拼音码
jQuery("#Curr_admission_prefessional_name").autocomplete("", {
minChars: 0,
max: 12,
autoFill: false,
delay: 400,
matchContains: true,
scrollHeight: 220,
dataType: 'json',
selectFirst: false,
parse: function (data) {
var rows = [];
for (var i = 0; i < data.length; i++) {
rows[rows.length] = {
data: data[i].name,
value: data[i].admission_prefessional_id,
result: data[i].name
};
}
return rows;
},
formatItem: function (row, i, max) {
return row;
},
formatMatch: function (row, i, max) {
return row;
},
formatResult: function (row) {
return row;
}
})
.result(function (event, data, formatted) {
if (formatted == "") {
$("#Curr_admission_prefessional_name").val("");
$("#Curr_admission_prefessional_Id").val("");
$("#Curr_admission_prefessional_name").focus();
jAlert("请准确选择", "提示信息");
}
else {
$("#Curr_admission_prefessional_Id").val(formatted);
}
});
//请选择教师拼音码
jQuery("#TeacherChoose").autocomplete("", {
minChars: 0,
max: 12,
autoFill: false,
delay: 400,
matchContains: true,
scrollHeight: 220,
dataType: 'json',
selectFirst: false,
parse: function (data) {
var rows = [];
for (var i = 0; i < data.length; i++) {
rows[rows.length] = {
data: data[i].name,
value: data[i].teacher_id,
result: data[i].name
};
}
return rows;
},
formatItem: function (row, i, max) {
return row;
},
formatMatch: function (row, i, max) {
return row;
},
formatResult: function (row) {
return row;
}
})
.result(function (event, data, formatted) {
if (formatted == "") {
$("#TeacherChoose").val("");
$("#teacherSelId").val("");
$("#TeacherChoose").focus();
jAlert("请准确选择", "提示信息");
}
else {
$("#teacherSelId").val(formatted);
}
});
//请选择教材拼音码
jQuery("#teachingChoose").autocomplete("", {
minChars: 0,
max: 12,
autoFill: false,
delay: 400,
matchContains: true,
scrollHeight: 220,
dataType: 'json',
selectFirst: false,
parse: function (data) {
var rows = [];
for (var i = 0; i < data.length; i++) {
rows[rows.length] = {
data: data[i].name,
value: data[i].book_no,
result: data[i].name
};
}
return rows;
},
formatItem: function (row, i, max) {
return row;
},
formatMatch: function (row, i, max) {
return row;
},
formatResult: function (row) {
return row;
}
})
.result(function (event, data, formatted) {
if (formatted == "") {
$("#teachingChoose").val("");
$("#teaching_bookno").val("");
$("#teachingChoose").focus();
jAlert("请准确选择", "提示信息");
}
else {
$("#teaching_bookno").val(formatted);
}
});
jquery 前台页面,jqGrid
最新推荐文章于 2024-09-13 17:32:25 发布