导入导出

后台导出

控制器：

public void Exportexcel()
{
List<Questionnaire> paperList = nairebll.SearchQuestionnaire();
nairebll.ExportResult(paperList, "../CourseFile/新建Excel.xls");
}

DAL：
public void ExportResult(List<Questionnaire> paperList, string excelName)
{
HttpContext.Current.Response.Clear();
//HttpContext.Current.Response.Charset = "UTF-8";
Response.ContentEncoding = System.Text.Encoding.UTF8;
HttpContext.Current.Response.ContentType = "application/vnd.ms-xls";
StringWriter stringWrite = new StringWriter(); //导出的数据只能是字符串
HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);

DataGrid dg = new DataGrid();
dg.DataSource = paperList;
dg.DataBind();
dg.RenderControl(htmlWrite);
HttpContext.Current.Response.AddHeader
("content-disposition", "attachment;filename=" + HttpUtility.UrlEncode(excelName));
HttpContext.Current.Response.Write(stringWrite.ToString());
HttpContext.Current.Response.End();
}
BLL： public void ExportResult(List<Questionnaire> paperList, string excelName)
{
nairedal.ExportResult(paperList,excelName);
}

 

导出到word

Random rd = new Random();
string fileName = DateTime.Now.ToString("yyyyMMddhhmm") + rd.Next() + ".doc";
if (useid == 2)
{
fileName = "学习试卷" + fileName;
}
if (useid == 3)
{
fileName = "考试试卷" + fileName;
}
//存储路径
string path = Server.MapPath("../uploads/Questions/" + fileName);
//创建字符输出流
StreamWriter sw = new StreamWriter(path, true, System.Text.UnicodeEncoding.UTF8);
sw.Write(html);//保存数据 HTML是数据
sw.Close();
Response.Clear();
Response.Buffer = true;
this.EnableViewState = false;
string strFileName = HttpUtility.UrlEncode(Path.GetFileName(path));
//Response.Charset = "utf-8";
Response.ContentType = "application/octet-stream";
Response.AppendHeader("Content-Disposition", "attachment;filename=" + strFileName);
Response.Flush();//向客户端发送当前所有缓冲的输出；
Response.WriteFile(path, false);
Response.End();

 

导入

网址：http://www.cnblogs.com/bianlan/archive/2012/05/14/2500705.html

控制器：

public ActionResult ImportSelectQuestion(int tid, string tname)
{
try
{
HttpPostedFileBase file = Request.Files["files"];
string FileName;
string savePath;
string FileType;
string fileEx;
if (file == null || file.ContentLength <= 0)
{
ViewBag.error = "文件不能为空";
return Content("<script>alert('文件不能为空！');history.go(-1);</script>");
}
else
{
string filename = Path.GetFileName(file.FileName);
int filesize = file.ContentLength;//获取上传文件的大小单位为字节byte
fileEx = System.IO.Path.GetExtension(filename);//获取上传文件的扩展名
string NoFileName = System.IO.Path.GetFileNameWithoutExtension(filename);//获取无扩展名的文件名
int Maxsize = 4000 * 1024;//定义上传文件的最大空间大小为4M
FileType = ".xls,.xlsx";//定义上传文件的类型字符串

FileName = NoFileName + DateTime.Now.ToString("yyyyMMddhhmmss") + fileEx;
if (!FileType.Contains(fileEx))
{
ViewBag.error = "文件类型不对，只能导入xls和xlsx格式的文件";
return Content("<script>alert('文件类型不对，只能导入xls和xlsx格式的文件！');history.go(-1);</script>");
}
if (filesize >= Maxsize)
{
ViewBag.error = "上传文件超过4M，不能上传";
return Content("<script>alert('上传文件超过4M，不能上传！');history.go(-1);</script>");
}
string path = AppDomain.CurrentDomain.BaseDirectory + "CourseFile";
savePath = Path.Combine(path, FileName);
file.SaveAs(savePath);
}
string strConn = "";
if (fileEx.Equals(".xlsx"))
{
strConn = "Provider=Microsoft.Ace.OleDb.12.0;Data Source=" + savePath + ";Extended Properties='Excel 12.0 Xml; HDR=YES; IMEX=1'";
}
else if (fileEx.Equals(".xls"))
{
strConn = "Provider=Microsoft.Jet.OleDb.4.0;" + "data source=" + savePath + ";Extended Properties='Excel 8.0; HDR=YES; IMEX=1'";
}
OleDbConnection conn = new OleDbConnection(strConn);
conn.Open();
OleDbDataAdapter myCommand = new OleDbDataAdapter("select * from [Sheet1$]", strConn);
DataSet myDataSet = new DataSet();
try
{
myCommand.Fill(myDataSet, "ExcelInfo");
}
catch (Exception ex)
{
ViewBag.error = ex.Message;
return Content("<script>alert('导入失败！');history.go(-1);</script>");
}
DataTable table = myDataSet.Tables["ExcelInfo"].DefaultView.ToTable();
var result = selectbll.ImportSelectQuestion(table, tid, tname); 
else
{
ViewBag.error = "导入成功";
System.Threading.Thread.Sleep(2000);
return Content("<script>alert('导入成功！');history.go(-2);</script>");
}

}
catch (Exception)
{

ViewBag.error = "导入失败";
return Content("<script>alert('导入失败！');history.go(-1);</script>");
}
}

 


DAL：
public int ImportSelectQuestion(DataTable table, int tid, string tname)
{
var userID = int.Parse(HttpContext.Current.Request.Cookies["UserID"].Value);
if (table.Columns.Count != 8)
{
return 1;
}
else
{
using (TransactionScope transaction = new TransactionScope())
{
for (int i = 0; i < table.Rows.Count; i++)
{

Exam_SelectQuestion quesinfo = new Exam_SelectQuestion();
quesinfo.question_info = table.Rows[i][0].ToString().Trim();
quesinfo.option_A = table.Rows[i][1].ToString().Trim();
quesinfo.option_B = table.Rows[i][2].ToString().Trim();
quesinfo.option_C = table.Rows[i][3].ToString().Trim();
quesinfo.option_D = table.Rows[i][4].ToString().Trim();
quesinfo.option_E = table.Rows[i][5].ToString().Trim();
quesinfo.option_F = table.Rows[i][6].ToString().Trim();
quesinfo.option_G = "";
quesinfo.option_H = "";
quesinfo.option_I = "";
quesinfo.option_J = "";
quesinfo.option_count = 6;
quesinfo.question_type = "单选";
quesinfo.answer_info = table.Rows[i][7].ToString().Trim();
//用三元运算符来设置分值
//quesinfo.score = Convert.ToDecimal(table.Rows[i][8] != DBNull.Value ? table.Rows[i][8] : 0);
quesinfo.question_answer = "";
quesinfo.difficulty_level = "";
quesinfo.score = 0;
quesinfo.state = 1;
quesinfo.type_id = tid;
quesinfo.type_name = tname;
quesinfo.create_id = userID;
if (table.Rows[i][0].ToString().Trim() == "")
{
return 2;
} 
else
{
ZKQIEntities db = new ZKQIEntities();
db.Exam_SelectQuestion.AddObject(quesinfo);
db.SaveChanges();
}
}
transaction.Complete();
}
return 6;

}

 

文件下载

public FileResult GetFile()
{
string path = AppDomain.CurrentDomain.BaseDirectory + "uploads/excel/";
string fileName = "基站信息Excel模版.xls";
return File(path + fileName, "text/plain", fileName);
}