Oracle&C# 导出多Sheet Excel ,使用Oracle Package代码,C#代码库,德仔网

代码语言
代码分类
【C#】 Oracle&C# 导出多Sheet Excel ,使用Oracle Package
作者:Hobart / 发布于2016/1/25/ 618
string dateFlag = DateTime.Now.ToString("yyyyMMddHHmmss");
DataSet dataSet = loader.GetExportData(ID);
MemoryStream memory = Export_ExamData(dataSet);
TranDataToClient("Infor_" + dateFlag + ".xls", memory.ToArray());




private System.IO.MemoryStream Export_ExamData(DataSet dt)
{
   System.IO.MemoryStream ms = new System.IO.MemoryStream();
   IO.DataSet2Excel(dt, ms);
   return ms;
}




/// <summary>
/// 导出Excel模板
/// </summary>
/// <param name="strfilename"></param>
/// <param name="templateValue"></param>
private void TranDataToClient(string strfilename, byte[] templateValue)
{
   string path = strfilename;
   int count = templateValue.Length;


   // 从缓冲区中清除当前输出内容
   Response.Clear();


   // 添加头信息，为"文件下载/另存为"对话框指定默认文件名
   Response.AddHeader("Content-Disposition", "attachment; filename=" + HttpUtility.UrlEncode(path));


   // 添加头信息，指定文件大小，让浏览器能够显示下载进度
   Response.AddHeader("Content-Length", count.ToString());


   // 指定返回的是一个不能被客户端读取的流，必须被下载
   Response.ContentType = "octet-stream";


   // 把文件流发送到客户端
   Response.OutputStream.Write(templateValue, 0, count);


   // 停止页面的执行
   Response.End();
}




public DataSet GetExportData(string ID)
{
OracleParameter[] parameters = new OracleParameter[18];


#region Parameters Define.
int i = 0;
parameters[i] = new OracleParameter("p_exammarrange_id", OracleType.NVarChar);
parameters[i].Value = ID;


i++;
parameters[i] = new OracleParameter("o_exammarrange", OracleType.Cursor);
parameters[i].Direction = ParameterDirection.Output;


i++;
parameters[i] = new OracleParameter("o_examarrangeemployee", OracleType.Cursor);
parameters[i].Direction = ParameterDirection.Output;


i++;
parameters[i] = new OracleParameter("o_exampaper", OracleType.Cursor);
parameters[i].Direction = ParameterDirection.Output;


i++;
parameters[i] = new OracleParameter("o_exampaperemployee", OracleType.Cursor);
parameters[i].Direction = ParameterDirection.Output;


i++;
parameters[i] = new OracleParameter("o_exampapermanagerrights", OracleType.Cursor);
parameters[i].Direction = ParameterDirection.Output;


i++;
parameters[i] = new OracleParameter("o_examresultruler", OracleType.Cursor);
parameters[i].Direction = ParameterDirection.Output;


i++;
parameters[i] = new OracleParameter("o_examresultrulerdetail", OracleType.Cursor);
parameters[i].Direction = ParameterDirection.Output;


i++;
parameters[i] = new OracleParameter("o_exampaperquestiontype", OracleType.Cursor);
parameters[i].Direction = ParameterDirection.Output;


i++;
parameters[i] = new OracleParameter("o_exampaperknowledge", OracleType.Cursor);
parameters[i].Direction = ParameterDirection.Output;


i++;
parameters[i] = new OracleParameter("o_examknowledge", OracleType.Cursor);
parameters[i].Direction = ParameterDirection.Output;


i++;
parameters[i] = new OracleParameter("o_examquestionbank", OracleType.Cursor);
parameters[i].Direction = ParameterDirection.Output;


i++;
parameters[i] = new OracleParameter("o_examquestion", OracleType.Cursor);
parameters[i].Direction = ParameterDirection.Output;


i++;
parameters[i] = new OracleParameter("o_examquestionchoice", OracleType.Cursor);
parameters[i].Direction = ParameterDirection.Output;


i++;
parameters[i] = new OracleParameter("o_exampaperinstance", OracleType.Cursor);
parameters[i].Direction = ParameterDirection.Output;


i++;
parameters[i] = new OracleParameter("o_exampubliccodetype", OracleType.Cursor);
parameters[i].Direction = ParameterDirection.Output;


i++;
parameters[i] = new OracleParameter("o_exampubliccodeitem", OracleType.Cursor);
parameters[i].Direction = ParameterDirection.Output;


i++;
parameters[i] = new OracleParameter("o_examstringresources", OracleType.Cursor);
parameters[i].Direction = ParameterDirection.Output;
  
       /*p_exammarrange_id                       VARCHAR2,
o_exammarrange                  OUT     type_refcursor,--考评安排
o_examarrangeemployee           OUT     type_refcursor,--考评安排人员
o_exampaper                     OUT     type_refcursor,--试卷模板
o_exampaperemployee             OUT     type_refcursor,--每人的试卷
o_exampapermanagerrights        OUT     type_refcursor,--试卷模板管理权归属人
o_examresultruler               OUT     type_refcursor,--应用结果规则
o_examresultrulerdetail         OUT     type_refcursor,--应用规则详细区间
o_exampaperquestiontype         OUT     type_refcursor,--试卷模版题型
o_exampaperknowledge            OUT     type_refcursor,--试卷模版题型知识
o_examknowledge                 OUT     type_refcursor,--知识点
o_examquestionbank              OUT     type_refcursor,--题库类型
o_examquestion                  OUT     type_refcursor,--试题
o_examquestionchoice            OUT     type_refcursor,--试题选项
o_exampaperinstance             OUT     type_refcursor,--每个人的试卷实例
o_exampubliccodetype            OUT     type_refcursor,--公用代码类型
o_exampubliccodeitem            OUT     type_refcursor,--公用代码值
o_examstringresources           OUT     type_refcursor --公用代码多语言*/


#endregion


try
{
DataSet dataSet = RunProcedure("exam_package.exam_infor_import", parameters);
if (dataSet != null)
{
dataSet.Tables[0].TableName = "EXAMARRANGE";
dataSet.Tables[1].TableName = "EXAMARRANGEEMPLOYEE";
dataSet.Tables[2].TableName = "EXAMPAPER";
dataSet.Tables[3].TableName = "EXAMPAPEREMPLOYEE";
dataSet.Tables[4].TableName = "EXAMPAPERMANAGERRIGHTS";
dataSet.Tables[5].TableName = "EXAMRESULTRULER";
dataSet.Tables[6].TableName = "EXAMRESULTRULERDETAIL";
dataSet.Tables[7].TableName = "EXAMPAPERQUESTIONTYPE";
dataSet.Tables[8].TableName = "EXAMPAPERKNOWLEDGE";
dataSet.Tables[9].TableName = "EXAMKNOWLEDGE";
dataSet.Tables[10].TableName = "EXAMQUESTIONBANK";
dataSet.Tables[11].TableName = "EXAMQUESTION";
dataSet.Tables[12].TableName = "EXAMQUESTIONCHOICE";
dataSet.Tables[13].TableName = "EXAMPAPERINSTANCE";
dataSet.Tables[14].TableName = "EXAMPUBLICCODETYPE";
dataSet.Tables[15].TableName = "EXAMPUBLICCODEITEM";
dataSet.Tables[16].TableName = "EXAMSTRINGRESOURCES";
}
return dataSet;
}
catch (Exception e)
{
throw e;
}
}
试试其它关键字
同语言下
可能有用的
Hobart贡献的其它代码(3)