话不多说,请看代码:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
|
public FileResult GetExcelFile() { if (Session[ "beginDate" ] != null ) { string bdate = Session[ "beginDate" ].ToString(); DateTime ld = Convert.ToDateTime(Session[ "lastDate" ].ToString()); DateTime ldate = ld.AddDays(1); string lldate = ldate.ToString( "yyyy-MM-dd" ); int ptkey = Convert.ToInt32(Session[ "Process_PTR" ]); string proceSql = "select * from Assay_Process where RKEY=" +ptkey; DataTable proceDt = SqlHelper.QueryTable(proceSql); IDataParameter[] iDataTitle = new SqlParameter[3]; iDataTitle[0] = new SqlParameter( "@BeginDate" , bdate); iDataTitle[1] = new SqlParameter( "@LastDate" , lldate); iDataTitle[2] = new SqlParameter( "@RKEY" , ptkey); DataSet dtTitle = SqlHelper.RunProceduresByParameter( "pro_GetAssalyInfoByExportPrint" , iDataTitle); DataTable dt = dtTitle.Tables[0]; string outStr = ExcelExport.outExcel(dt); byte [] fileContents = Encoding.UTF8.GetBytes(outStr.ToString()); return File(fileContents, "application/ms-excel" , "" + proceDt.Rows[0][ "ProcessName" ].ToString().Trim() + "化验单据(" + bdate.Trim() + "-" + lldate.Trim() + ").xls" ); } else { string qua_no = Session[ "quano" ].ToString(); IDataParameter[] iDataTitle = new SqlParameter[1]; iDataTitle[0] = new SqlParameter( "@Qua_no" , qua_no); DataSet dtTitle = SqlHelper.RunProceduresByParameter( "pro_GetAssalyInfoByQua_No" , iDataTitle); DataTable dt = dtTitle.Tables[0]; string outStr = ExcelExport.outExcel(dt); byte [] fileContents = Encoding.UTF8.GetBytes(outStr.ToString()); return File(fileContents, "application/ms-excel" , "化验单据(" + qua_no.Trim()+ ").xls" ); } } |
以上就是本文的全部内容,希望本文的内容对大家的学习或者工作能带来一定的帮助,同时也希望多多支持服务器之家!
原文链接:http://www.cnblogs.com/Resources-blogs/p/6600913.html