protected void btnImportTeachers_Click(object sender, EventArgs e)//导入教师基本信息按钮 { Clear(); string identity = ""; if (rdoOthers.Checked == false && rdoTeachers.Checked == false)//选择教师类型 { lblMessage1.Text = "请先选择导入的数据是“本校教师”或者“外聘教师”"; } else//选择完了教师类型 { if (rdoTeachers.Checked)//本校教师单选 { identity = "TabTeachers"; } else//外聘教师单选 { identity = "TabOtherTeachers"; } if (fileexcel.FileName != string.Empty) { string AllFileName = UpLoad("Teachers\\", fileexcel); lblMessage1.Text = ExcelToDatabase.CheckFile(AllFileName, identity);//获取完整路径 } else { lblMessage1.Text = "导入的Excel文件不能为空!"; } } }
protected void BtnImportTeachers_Click(object sender, EventArgs e) { // Clear(); string identity = ""; if (rdoTeacher.Checked | rdoOther.Checked) { if (rdoTeacher.Checked) { identity = "TabTeachers"; } else { identity = "TabOtherTeachers"; } if (UpLoad(FileUploadTeacher)) { lblMessage1.Text = ExcelToDatabase.CheckFile(currFilePath, identity); } } else { Response.Write("<script>alert('请选择导入的数据是本地教师或外聘教师!')</script>"); } }
/// <summary> /// 导入教师基本信息 /// 将Excel的数据导入到数据库 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnImportTeachers_Click(object sender, EventArgs e) { Clear(); string identity = ""; if (rdoOthers.Checked || rdoTeachers.Checked) { identity = rdoTeachers.Checked ? "TabTeachers" : "TabOtherTeachers"; //todo... lbMessage1.Text = "正在对数据进行初始化处理..."; string filePath = Upload(FileUpload1); if (filePath != null && filePath.Length != 0) { lbMessage1.Text = ExcelToDatabase.CheckFile(filePath, identity); } else { lbMessage1.Text = "您选择的文件不符合规范"; } } else { lbMessage1.Text = "请先选择导入数据的类型!"; } }
//导入校历 protected void BtnImportCalendar_Click(object sender, EventArgs e) { Clear(); // AddSQLStringToDAL.DelectTabTeachers("TabCalendar"); if (UpLoad(FileUploadCalendar)) { lblMessage5.Text = ExcelToDatabase.CheckFile(currFilePath, "TabCalendar"); } }
protected void BtnImportCourse_Click(object sender, EventArgs e) { Clear(); string department = ""; department = ddlDepartmentName.SelectedItem.ToString(); if (UpLoad(FileUploadCourse)) { lblMessage2.Text = ExcelToDatabase.CheckFile(currFilePath, department); } }
protected void btnClear_Click(object sender, EventArgs e) { if (true) { if (ExcelToDatabase.ClearExcel()) { lblMessage7.Text = "清除完成"; } else { lblMessage7.Text = "清除失败"; } } }
/// <summary> /// 导入校历信息 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void BtnImportCalendar_Click(object sender, EventArgs e) { AddSQLStringToDAL.DeleteTab("TabCalendar"); lbMessage3.Text = "正在对数据进行初始化处理..."; string filePath = Upload(FileUpload2); if (filePath != null && filePath.Length != 0) { lbMessage3.Text = ExcelToDatabase.CheckFile(filePath, "TabCalendar"); } else { lbMessage3.Text = "您选择的文件不符合规范"; } }
/// <summary> /// 导入教师授课信息 /// 从Excel导入到数据库 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnImportCourse_Click(object sender, EventArgs e) { Clear(); string department = ""; //系部 department = ddlDepartmentName.SelectedValue; //todo... string filePath = Upload(filecourse); if (filePath != null && filePath.Length != 0) { lbMessage2.Text = ExcelToDatabase.CheckFile(filePath, department); } else { lbMessage2.Text = "您选择的文件不符合规范"; } }