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); }