/// <summary>
/// Myxls导出Excel，保存在客户端
/// </summary>
private void DataTableExportToExcel(long applyId, string xlsName, string sheetName)
{
//表头
//决定Datatable显示哪些内容
DataSet ds = new DataSet();
DataTable dt = ds.Tables.Add("Sheet1");
DataRow dr;
DataColumn column;
//1---序号
column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "序号";
ds.Tables["Sheet1"].Columns.Add(column);
//2---准考证号
column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "准考证号";
ds.Tables["Sheet1"].Columns.Add(column);
//3---姓名
column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "姓名";
ds.Tables["Sheet1"].Columns.Add(column);
//4---专业
column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "专业";
ds.Tables["Sheet1"].Columns.Add(column);
var ml = new BLL.CCOM.Examination_arrangement_detail().GetModelList(" Ea_id='" + applyId + "' order by newid()");
for (int row = 0; row < ml.Count; row++)
{
var m = ml[row];
//申请人基本信息
//学生用户
try
{
Model.CCOM.View_UserAgency model = new BLL.CCOM.View_UserAgency().GetModel(" User_id='" + m.User_id + "'");
dr = ds.Tables["Sheet1"].NewRow();
dr[0] = row + 1;
dr[1] = model.UP_CCOM_number;
dr[2] = model.User_realname;
dr[3] = model.Agency_name;
ds.Tables["Sheet1"].Rows.Add(dr);
}
catch
{
continue;
}
}
//导出EXCEL，速度有点慢
DataToExcel.ExportToExcel(ds, Server.MapPath("/upload/excel/"), xlsName + ".xlsx", this.Page);
}
/// <summary>
/// Myxls导出Excel，保存在客户端
/// </summary>
private void DataTableExportToExcel(string xlsName, string sheetName)
{
//表头
//决定Datatable显示哪些内容
DataSet ds = new DataSet();
DataTable dt = ds.Tables.Add("Sheet1");
DataRow dr;
DataColumn column;
//1---序号
column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "序号";
ds.Tables["Sheet1"].Columns.Add(column);
//2---姓名
column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "姓名";
ds.Tables["Sheet1"].Columns.Add(column);
//3---学号/工号
column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "联系电话";
ds.Tables["Sheet1"].Columns.Add(column);
//4---性别
column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "性别";
ds.Tables["Sheet1"].Columns.Add(column);
////5---省份
//column = new DataColumn();
//column.DataType = System.Type.GetType("System.String");
//column.ColumnName = "省份";
//ds.Tables["Sheet1"].Columns.Add(column);
//6---政治面貌
column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "政治面貌";
ds.Tables["Sheet1"].Columns.Add(column);
//7---机构
column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "报考方向";
ds.Tables["Sheet1"].Columns.Add(column);
var ml = new BLL.CCOM.View_UserAgency().GetModelList(" User_type !=6 " + CombSqlTxt(this.uo_id, this.provence, this.keywords));
for (int row = 0; row < ml.Count; row++)
{
var m = ml[row];
dr = ds.Tables["Sheet1"].NewRow();
dr[0] = row + 1;
dr[1] = m.User_realname;
dr[2] = ((Boolean)m.User_gender) == false ? "男" : "女";
dr[3] = GetProvince(Utils.ObjectToStr(m.User_id));
dr[4] = m.User_number;
dr[5] = GetNationality(Utils.ObjectToStr(m.User_id));
dr[6] = m.Agency_name;
ds.Tables["Sheet1"].Rows.Add(dr);
}
//导出EXCEL，速度有点慢
DataToExcel.ExportToExcel(ds, Server.MapPath("/upload/excel/"), xlsName + ".xlsx", this.Page);
}
