//前台ajax返回成功的数据
$.ajax({
url: "地址?r=" + Math.random,
type: "post",
async: false,
//传的搜索条件
data: { key: data},
cache: false,
success: function (obj) {
if (obj.split('|')[0] == "true") {
//alert(obj.split('|')[1]);
window.open(obj.split('|')[1], '_parent');
}
else
alert("导出失败!");
}
});
//后台代码
#region 合并列导出 DevStatusExport()
/// <summary>///
/// </summary>
/// <returns></returns>
public string DevStatusExport()
{
StringBuilder key = new StringBuilder();
//前台查询条件
string key_data= Request["key"] == null ? "" : Request["key"].ToString().Trim();//key.Append("1=1");
if (!string.IsNullOrEmpty(key_data))
{
key.AppendFormat(" AND 条件 LIKE '%{0}%'", key_data);
}
//导出子母表数据及明细
DataSet ds = DevDemandBLL.GetExportList(key.ToString());
//母表的条数
DataSet dss = DevDemandBLL.GetExportLists(key.ToString());//生成随机数
Random objRand = new Random();
string fileName = "合并行单元格导出" + DateTime.Now.ToString("yyyyMMdd") + Convert.ToString(objRand.Next(9) * 7 + 10) + ".xls";
try
{
WriteExcels(ds, dss, Server.MapPath("/ExportPath/" + fileName));
}
catch (Exception ex)
{
return "false|" + ex.Message;
}
return "true|/ExportPath/" + fileName;
}
public void WriteExcels(DataSet ds,DataSet dss, string path)
{
try
{
DataTable data = ds.Tables[0];
DataTable dt = dss.Tables[0];
//创建EXCEL表
Workbook book = new Workbook();Worksheet sheet = book.Worksheets[0];
Cells cells = sheet.Cells;
if (dt.Rows.Count > 0)
{
int Colnum = data.Columns.Count;//表格列数
int Rownum = data.Rows.Count;//表格行数
//生成标题行
cells[0, 0].PutValue("第一列");
cells[0, 1].PutValue("第二列");
cells[0, 2].PutValue("第三列");
//生成数据行
for (int i = 0; i < Rownum; i++)
{
for (int k = 0; k < Colnum; k++)
{
cells[1 + i, k].PutValue(data.Rows[i][k].ToString());
}
}
//合并单元格
int q = 0;
int RowOrder = 0;
//循环母表数据
foreach (DataRow item in dt.Rows){
//查询母表下子表的条数
RowOrder = DevDemandBLL.GetRowsOrder(item["字段"].ToString());cells.Merge(1 + q, 0, RowOrder, 1);
cells.Merge(1 + q, 1, RowOrder, 1);
cells.Merge(1 + q, 2, RowOrder, 1);
//(1+q:第几行开始;第几列;合并行数;)
q = q + RowOrder;}
}
book.Save(path);
GC.Collect();
}
catch (Exception ex)
{
//MessageBox.Show(ex.Message);
}
}
#endregion