private void ExportStuInfo(HttpContext context)
{
var exXls = new ExportXls();
var fieldsNames = new List<string>();
fieldsNames.Add("姓名");
fieldsNames.Add("性别");
fieldsNames.Add("身份证号");
fieldsNames.Add("所在单位");
fieldsNames.Add("职务");
fieldsNames.Add("联系电话");
fieldsNames.Add("出生日期");
fieldsNames.Add("民族");
fieldsNames.Add("全日制学历");
fieldsNames.Add("全日制学校");
fieldsNames.Add("在职学历");
fieldsNames.Add("在职学校");
fieldsNames.Add("政治面貌");
fieldsNames.Add("职称");
fieldsNames.Add("现任级别");
fieldsNames.Add("任现任级别时间");
fieldsNames.Add("现任职务");
fieldsNames.Add("任职时间");
fieldsNames.Add("手机号");
fieldsNames.Add("学时");
fieldsNames.Add("描述");
fieldsNames.Add("继教号");
var ds = QueryDataResultForExp(context);
var filename =DateTime.Now.ToString("yyyy-MM-dd")+ "-学员信息.xls";
if (ds != null && ds.Tables.Count > 0)
{
exXls.ExportToXls(context.Response, fieldsNames, ds.Tables[0], filename);
}
}
private void ExportCourseInfo(HttpContext context)
{
var exXls = new ExportXls();
var fieldsNames = new List<string>();
fieldsNames.Add("课程名称");
fieldsNames.Add("授课教师");
fieldsNames.Add("授课地点");
fieldsNames.Add("授课时间");
var ds = QueryDataResultForExp(context);
var filename = DateTime.Now.ToString("yyyy-MM-dd") + "-课程信息.xls";
if (ds != null && ds.Tables.Count > 0)
{
exXls.ExportToXls(context.Response, fieldsNames, ds.Tables[0], filename);
}
}
private void ExportTeacherInfo(HttpContext context)
{
var exXls = new ExportXls();
var fieldsNames = new List<string>();
fieldsNames.Add("姓名");
fieldsNames.Add("性别");
fieldsNames.Add("身份证号");
fieldsNames.Add("所在单位");
fieldsNames.Add("职称");
fieldsNames.Add("职务");
fieldsNames.Add("研究方向");
fieldsNames.Add("手机号");
fieldsNames.Add("描述");
var ds = QueryDataResultForExp(context);
var filename = DateTime.Now.ToString("yyyy-MM-dd") + "-教师信息.xls";
if (ds != null && ds.Tables.Count > 0)
{
exXls.ExportToXls(context.Response, fieldsNames, ds.Tables[0], filename);
}
}
/// <summary>
/// 导出意见
/// </summary>
private void ExportSuggestionInfo(HttpContext context, string id)
{
var exXls = new ExportXls();
var fieldsNames = new List<string>();
fieldsNames.Add("学员姓名");
fieldsNames.Add("建议");
var quesBll = new BLL.Questionnaire();
var ds = quesBll.GetSuggestion(id);
var courseBll = new BLL.Course();
var courseModel = courseBll.GetModel(new Guid(id));
var filename = courseModel.CourseName + "--学员建议.xls";
if (ds != null && ds.Tables.Count > 0)
{
exXls.ExportToXls(context.Response, fieldsNames, ds.Tables[0], filename);
}
}
private void ExportStuNoFinish(HttpContext context, string id)
{
var exXls = new ExportXls();
var fieldsNames = new List<string>();
fieldsNames.Add("学员姓名");
fieldsNames.Add("所在学校");
fieldsNames.Add("联系电话");
var quesBll = new BLL.Questionnaire();
var ds = quesBll.GetNofinishedStu(id);
var courseBll = new BLL.Course();
var courseModel = courseBll.GetModel(new Guid(id));
var filename = courseModel.CourseName + "--未完成学员.xls";
if (ds != null && ds.Tables.Count > 0)
{
exXls.ExportToXls(context.Response, fieldsNames, ds.Tables[0], filename);
}
}
private void ExportStuInfo(HttpContext context, string id)
{
var exXls = new ExportXls();
var fieldsNames = new List<string>();
fieldsNames.Add("学员姓名");
fieldsNames.Add("登录名");
fieldsNames.Add("密码");
fieldsNames.Add("所属学校");
var quesBll = new BLL.Questionnaire();
var dt = quesBll.GetStuInfoofCourse(id);
var courseBll = new BLL.Course();
var courseModel = courseBll.GetModel(new Guid(id));
var filename = courseModel.CourseName + "--学员信息.xls";
exXls.ExportToXls(context.Response, fieldsNames, dt, filename);
}