private void SaveExcel()
{
label5.Text = "任务完成！正在保存EXCEL";
bool finderr = false;
string title = DateTime.Now.ToFileTime().ToString();
string filefullname = System.Environment.CurrentDirectory + @"\" + title + ".xlsx";
MessageBox.Show(filefullname);
if (System.IO.File.Exists(filefullname))
{
try
{
System.IO.File.Delete(filefullname);
}
catch
{
finderr = true;
MessageBox.Show("文件占用中无法删除！");
}
}
try
{
MakeExcelModel MEM = new MakeExcelModel();
MEM.Filename = filefullname;
MEM.TitleName = title;
MEM.PassWord = "";
//MEM.HeaderText = new List<string>();
MEM.dataTable = ToDataTable(studentchengjidan);
var l = new List <string>();
foreach (var VARIABLE in studentchengjidan[0].GetType().GetProperties())
{
l.Add(VARIABLE.Name);
}
MEM.HeaderText = l;
ExcelHelper.SaveToExcel(MEM);
}
catch (Exception ef)
{
finderr = true;
MessageBox.Show("文件占用中无法生成！" + ef.ToString());
}
if (System.IO.File.Exists(filefullname) & finderr == false)
{
try
{
System.Diagnostics.Process.Start(filefullname);
}
catch
{
MessageBox.Show("当前系统没有安装EXCEL,或者EXCEL注册信息不全，无法自动打开生成的EXCEL，请手工打开！");
}
}
}
private void buttonKCB2Excel_Click(object sender, EventArgs e)
{
if (comboBox_Activeyear.Items.Count > 0)
{
bool finderr = false;
ActiveYear_BLL A_BLL = new ActiveYear_BLL();
int atyid = A_BLL.GetNowActvieYearID();
try
{
atyid = ConvertHelper.ConvertStringToInt(comboBox_Activeyear.SelectedValue.ToString());
}
catch
{
MessageBox.Show("错误");
}
string title = "大连科技学院" + A_BLL.GetAllEntityFromDAL().Find(d => d.ATID == atyid).ATName + "课程表";
string filefullname = System.Environment.CurrentDirectory + @"\" + title + ".xlsx";
MessageBox.Show(filefullname);
if (System.IO.File.Exists(filefullname))
{
try
{
System.IO.File.Delete(filefullname);
}
catch
{
finderr = true;
MessageBox.Show("文件占用中无法删除！");
}
}
Cschedule_BLL C_BLL = new Cschedule_BLL();
try
{
MakeExcelModel MEM = new MakeExcelModel();
MEM.Filename = filefullname;
MEM.TitleName = title;
MEM.PassWord = "";
MEM.dataTable = C_BLL.GetKCBFormvw_Cschedule_ForAtyID(atyid);
MEM.HeaderText = new List <string>
{
"课程代码",
"课程名称",
"教学班级名称",
"人数",
"任课教师",
"起始周",
"结束周",
"单双周",
"星期",
"节数",
"教学楼",
"教室",
"教室容纳人数",
"学分",
"考核方式",
"学时",
"课程类型"
};
ExcelHelper.SaveToExcel(MEM);
}
catch
{
finderr = true;
MessageBox.Show("文件占用中无法生成！");
}
if (System.IO.File.Exists(filefullname) & finderr == false)
{
try
{
System.Diagnostics.Process.Start(filefullname);
}
catch
{
MessageBox.Show("当前系统没有安装EXCEL,或者EXCEL注册信息不全，无法自动打开生成的EXCEL，请手工打开！");
}
}
}
}
