/// <summary>
/// 输出模板到文件
/// </summary>
/// <param name="type"></param>
/// <param name="filename"></param>
/// <returns></returns>
public static bool GetTemplate(string type, string filename)
{
var dt = GetTemplate(type);
//new Thread(() => { CsvHelper.dt2csv(filename, dt); }).Start();
return(CsvHelper.dt2csv(filename, dt));
}
/// <summary>
/// 获取UUID列表
/// </summary>
/// <param name="type">类型:class,dept,major</param>
/// <param name="filename">文件名</param>
public static bool GetUUID(string type, string filename)
{
var dt = new DataTable();
dt.Columns.Add("名称");
dt.Columns.Add("UUID");
switch (type)
{
case "class": //班级UUID
var bll_class = new BLL.t_class();
var c_dt = bll_class.GetAllList().Tables[0];
if (c_dt == null)
{
break;
}
foreach (DataRow item in c_dt.Rows)
{
var dr = dt.NewRow();
dr["名称"] = item["class_name"];
dr["UUID"] = item["class_id"];
dt.Rows.Add(dr);
}
break;
case "dept": //系别UUID
var bll_dept = new BLL.t_dept();
var d_dt = bll_dept.GetAllList().Tables[0];
if (d_dt == null)
{
break;
}
foreach (DataRow item in d_dt.Rows)
{
var dr = dt.NewRow();
dr["名称"] = item["dept_name"];
dr["UUID"] = item["dept_id"];
dt.Rows.Add(dr);
}
break;
case "major": //专业UUID
var bll_major = new BLL.t_major();
var m_dt = bll_major.GetAllList().Tables[0];
if (m_dt == null)
{
break;
}
foreach (DataRow item in m_dt.Rows)
{
var dr = dt.NewRow();
dr["名称"] = item["major_name"];
dr["UUID"] = item["major_id"];
dt.Rows.Add(dr);
}
break;
}
//new Thread(() => { CsvHelper.dt2csv(filename, dt); }).Start();
return(CsvHelper.dt2csv(filename, dt));
}
/// <summary>
/// 导出选题结果
/// </summary>
/// <param name="type">按条件导出:dept,major,class,teacher,select</param>
/// <param name="parms">*id</param>
/// <param name="filename">文件路径</param>
public static bool ExportSelectResult(string type, string parms, string filename)
{
var bll = new BLL.v_select();
var dt = new DataTable();
/// 获取数据
switch (type)
{
case "dept":
#region 系别导出
dt.Columns.Add(new DataColumn("专业"));
dt.Columns.Add(new DataColumn("班级"));
dt.Columns.Add(new DataColumn("姓名"));
dt.Columns.Add(new DataColumn("学号"));
dt.Columns.Add(new DataColumn("导师"));
dt.Columns.Add(new DataColumn("导师工号"));
dt.Columns.Add(new DataColumn("所选题目"));
var list_dept = bll.GetModelList(" select_stat=5 AND dept_id='" + parms + "'");
if (list_dept.Count == 0)
{
break;
}
foreach (var item in list_dept)
{
var dr = dt.NewRow();
dr["专业"] = item.major_name;
dr["班级"] = item.class_name;
dr["姓名"] = item.student_name;
dr["学号"] = item.select_student_xh;
dr["导师"] = item.teacher_name;
dr["导师工号"] = item.topic_teacher_gh;
dr["所选题目"] = item.topic_name;
dt.Rows.Add(dr);
}
#endregion 系别导出
break;
case "major":
#region 专业导出
dt.Columns.Add(new DataColumn("班级"));
dt.Columns.Add(new DataColumn("姓名"));
dt.Columns.Add(new DataColumn("学号"));
dt.Columns.Add(new DataColumn("导师"));
dt.Columns.Add(new DataColumn("导师工号"));
dt.Columns.Add(new DataColumn("所选题目"));
var list_major = bll.GetModelList(" select_stat=5 AND class_major_id='" + parms + "'");
if (list_major.Count == 0)
{
break;
}
foreach (var item in list_major)
{
var dr = dt.NewRow();
dr["班级"] = item.class_name;
dr["姓名"] = item.student_name;
dr["学号"] = item.select_student_xh;
dr["导师"] = item.teacher_name;
dr["导师工号"] = item.topic_teacher_gh;
dr["所选题目"] = item.topic_name;
dt.Rows.Add(dr);
}
#endregion 专业导出
break;
case "class":
#region 班级
dt.Columns.Add(new DataColumn("姓名"));
dt.Columns.Add(new DataColumn("学号"));
dt.Columns.Add(new DataColumn("导师"));
dt.Columns.Add(new DataColumn("导师工号"));
dt.Columns.Add(new DataColumn("所选题目"));
var list_class = bll.GetModelList(" select_stat=5 AND class_id='" + parms + "'");
if (list_class.Count == 0)
{
break;
}
foreach (var item in list_class)
{
var dr = dt.NewRow();
dr["姓名"] = item.student_name;
dr["学号"] = item.select_student_xh;
dr["导师"] = item.teacher_name;
dr["导师工号"] = item.topic_teacher_gh;
dr["所选题目"] = item.topic_name;
dt.Rows.Add(dr);
}
#endregion 班级
break;
case "teacher":
#region 导师
dt.Columns.Add(new DataColumn("专业"));
dt.Columns.Add(new DataColumn("班级"));
dt.Columns.Add(new DataColumn("姓名"));
dt.Columns.Add(new DataColumn("学号"));
dt.Columns.Add(new DataColumn("所选题目"));
var list_teacher = bll.GetModelList(" select_stat=5 AND topic_teacher_gh='" + parms + "'");
if (list_teacher.Count == 0)
{
break;
}
foreach (var item in list_teacher)
{
var dr = dt.NewRow();
dr["专业"] = item.major_name;
dr["班级"] = item.class_name;
dr["姓名"] = item.student_name;
dr["学号"] = item.select_student_xh;
dr["所选题目"] = item.topic_name;
dt.Rows.Add(dr);
}
#endregion 导师
break;
case "select":
#region 题导出
dt.Columns.Add(new DataColumn("专业"));
dt.Columns.Add(new DataColumn("班级"));
dt.Columns.Add(new DataColumn("姓名"));
dt.Columns.Add(new DataColumn("学号"));
var list_topic = bll.GetModelList(" select_stat=5 AND select_topic_id='" + parms + "'");
if (list_topic.Count == 0)
{
break;
}
foreach (var item in list_topic)
{
var dr = dt.NewRow();
dr["专业"] = item.major_name;
dr["班级"] = item.class_name;
dr["姓名"] = item.student_name;
dr["学号"] = item.select_student_xh;
dt.Rows.Add(dr);
}
#endregion 题导出
break;
}
/// 没有数据,添加提示信息
if (dt.Rows.Count == 0)
{
var dr = dt.NewRow();
dr[0] = "没有相关数据！";
dt.Rows.Add(dr);
}
/// 写入文件
return(CsvHelper.dt2csv(filename, dt));
}