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 = "您选择的文件不符合规范";
}
}
