protected void Button3_Click(object sender, EventArgs e) { StringBuilder sb = new StringBuilder();// strWhere = "1=1"; sb.Append("1=1"); string browser = Request.Browser.Browser; if (!string.IsNullOrEmpty(Request["code"])) { sb.AppendFormat(" and CWB_Code like '%{0}%'", Request["code"].ToString().Trim());//;;//存 客户名称 } if (!string.IsNullOrEmpty(Request["cname"])) { sb.AppendFormat(" and b.CC_Name like '%{0}%'", Request["cname"].ToString().Trim());//存 客户名称 } if (!string.IsNullOrEmpty(Request["uname"])) { sb.AppendFormat(" and d.UserName like '%{0}%'", Request["uname"].ToString().Trim());//存 用户名称 } if (!string.IsNullOrEmpty(Request["stime"])) { DateTime dtStime = Convert.ToDateTime("1980-01-01"); DateTime.TryParse(Request["stime"].ToString().Trim(), out dtStime); sb.AppendFormat(" and CWB_CreateTime > '{0}'", dtStime.AddDays(-1));//保存操作开始时间 } if (!string.IsNullOrEmpty(Request["etime"])) { DateTime dtEtime = Convert.ToDateTime("2250-01-01"); DateTime.TryParse(Request["etime"].ToString().Trim(), out dtEtime); sb.AppendFormat(" and CWB_CreateTime < '{0}'", dtEtime.AddDays(1)); //保存操作结束时间 } if (!string.IsNullOrEmpty(Request["Owner"])) //存 客户所属工程师 { sb.AppendFormat(" and CWB_Description = '{0}'", Request["Owner"].ToString().Trim()); } if (!string.IsNullOrEmpty(Request["sltType"]) && Request["sltType"].ToString().Trim() != "0") { sb.AppendFormat(" and CWB_Type = '{0}'", Convert.ToInt16(Request["sltType"].ToString().Trim())); } if (!string.IsNullOrEmpty(Request["status"])) { int intStatus = 0; int.TryParse(Request["status"].ToString().Trim(), out intStatus); int intStatus1 = 27; int.TryParse(ConfigurationManager.AppSettings["workbillStatusAll"].ToString(), out intStatus1); if (intStatus1 == intStatus) { } else { sb.AppendFormat(" and CWB_Status = '{0}'", intStatus); } } DataTable dt = new DataTable(); HYTD.BLL.Call_WorkBillBLL bll = new HYTD.BLL.Call_WorkBillBLL(); dt = bll.ImportExcelCustomerWorkBill(sb.ToString()).Tables[0]; NPOI.SS.UserModel.IWorkbook book1 = new ImportExcel().ImportCustomerWorkBill(dt, "客户服务记录"); string strFile = string.Empty; string filename = string.Empty; string strPath = HttpContext.Current.Server.MapPath("/" + System.Configuration.ConfigurationManager.AppSettings["CustomerFiles"].ToString().Replace("\\", "/") + "/") + "\\" + DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString().PadLeft(2, '0') + "\\"; if (dt.Rows.Count > 0) { strFile = dt.Rows[0]["客户名称"].ToString(); filename = strPath + dt.Rows[0]["客户名称"].ToString() + ".xls"; if (!System.IO.Directory.Exists(System.IO.Path.GetDirectoryName(filename))) { System.IO.Directory.CreateDirectory(System.IO.Path.GetDirectoryName(filename)); } try { System.IO.FileStream file1 = new System.IO.FileStream(filename, System.IO.FileMode.Create); book1.Write(file1); file1.Dispose(); } catch (Exception ex) { throw ex; } } Response.Clear(); Response.BufferOutput = false; Response.ContentEncoding = System.Text.Encoding.UTF8; if (browser.ToLower() != "firefox") { Response.AddHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(strFile) + ".xls"); } else { Response.AddHeader("Content-Disposition", "attachment;filename=" + strFile + ".xls"); } Response.ContentType = "application/ms-excel"; book1.Write(Response.OutputStream); book1.Dispose(); }