public void ImportKXMD() { try { if (!string.IsNullOrEmpty(Request.Params["content_id"])) { if (!string.IsNullOrEmpty(Request.Params["log_id"])) { int log_id = Convert.ToInt32(Request.Params["log_id"]); _edmContentNewMgr = new EdmContentNewMgr(mySqlConnectionString); DataTable _dt = _edmContentNewMgr.KXMD(Convert.ToInt32(Request.Params["content_id"]), log_id); DataTable _newDt = new DataTable(); _newDt.Columns.Add("發信狀態", typeof(string)); _newDt.Columns.Add("姓名", typeof(string)); _newDt.Columns.Add("信箱", typeof(string)); _newDt.Columns.Add("信箱編號", typeof(string)); _newDt.Columns.Add("開信次數", typeof(string)); _newDt.Columns.Add("寄信時間", typeof(string)); _newDt.Columns.Add("首次開信時間", typeof(string)); _newDt.Columns.Add("最近開信時間", typeof(string)); for (int i = 0; i < _dt.Rows.Count; i++) { #region 轉換dt DataRow newRow = _newDt.NewRow(); newRow[0] = "success"; if (_dt.Rows[i]["name"] == "") { newRow[1] = ""; } else { newRow[1] = _dt.Rows[i]["name"].ToString().Substring(0, 1) + "**"; ; } if (_dt.Rows[i]["email"] == "") { newRow[2] = ""; } else { newRow[2] = _dt.Rows[i]["email"].ToString().Split('@')[0] + "@***"; } newRow[3] = (_dt.Rows[i]["email_id"]).ToString(); if (_dt.Rows[i]["count"] == "") { newRow[4] = "0"; } else { newRow[4] = Convert.ToInt32(_dt.Rows[i]["count"]); } if (_dt.Rows[i]["send_date"] == "") { newRow[5] = ""; } else { DateTime request_createdate; if (DateTime.TryParse(_dt.Rows[i]["send_date"].ToString(), out request_createdate)) { newRow[5] = Convert.ToDateTime(_dt.Rows[i]["send_date"].ToString()).ToString("yyyy-MM-dd HH:mm:ss"); } else { newRow[5] = ""; } } if (_dt.Rows[i]["first_traceback"] == "") { newRow[6] = ""; } else { DateTime first_traceabck; if (DateTime.TryParse(_dt.Rows[i]["first_traceback"].ToString(), out first_traceabck)) { newRow[6] = Convert.ToDateTime(_dt.Rows[i]["first_traceback"].ToString()).ToString("yyyy-MM-dd HH:mm:ss"); } else { newRow[6] = ""; } } if (_dt.Rows[i]["last_traceback"] == "") { newRow[7] = ""; } else { DateTime first_traceabck; if (DateTime.TryParse(_dt.Rows[i]["last_traceback"].ToString(), out first_traceabck)) { newRow[7] = Convert.ToDateTime(_dt.Rows[i]["last_traceback"].ToString()).ToString("yyyy-MM-dd HH:mm:ss"); } else { newRow[7] = ""; } } _newDt.Rows.Add(newRow); #endregion } string fileName = "開信名單" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls"; MemoryStream ms = ExcelHelperXhf.ExportDT(_newDt, ""); Response.AddHeader("Content-Disposition", "attachment; filename=" + fileName); Response.BinaryWrite(ms.ToArray()); } } } catch (Exception ex) { Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message); logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); } }