public HttpResponseBase ProductCommentLogExport()
{
string newCsvName = string.Empty;
string json = string.Empty;
_proCommentImpl = new ProductCommentMgr(mySqlConnectionString);
ProductCommentQuery query = new ProductCommentQuery();
query.change_table = Request.Params["table_name"].ToString();
if (!string.IsNullOrEmpty(Request.Params["comment_id"]))
{
query.comment_id = Convert.ToInt32(Request.Params["comment_id"].ToString());
}
if (!string.IsNullOrEmpty(Request.Params["start_time"]))
{
//query.start_time = Convert.ToDateTime(Request.Params["start_time"]);
query.start_time = Convert.ToDateTime(Convert.ToDateTime(Request.Params["start_time"]).ToString("yyyy-MM-dd HH:mm:ss"));
}
if (!string.IsNullOrEmpty(Request.Params["end_time"]))
{
//query.end_time = Convert.ToDateTime(Request.Params["end_time"]);
query.end_time = Convert.ToDateTime(Convert.ToDateTime(Request.Params["end_time"]).ToString("yyyy-MM-dd HH:mm:ss"));
}
try
{
DataTable _dt = _proCommentImpl.ProductCommentLogExport(query);
string filename = "評價管理異動記錄_" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".csv";
if (!System.IO.Directory.Exists(Server.MapPath(excelPath)))
{
System.IO.Directory.CreateDirectory(Server.MapPath(excelPath));
}
newCsvName = Server.MapPath(excelPath) + filename;
if (System.IO.File.Exists(newCsvName))
{
//設置文件的屬性，以防刪除文件的時候因為文件的屬性造成無法刪除
System.IO.File.SetAttributes(newCsvName, FileAttributes.Normal);
System.IO.File.Delete(newCsvName);
}
string[] colname = { "評價編號", "評價內容", "修改人", "修改時間", "變動欄位", "欄位中文名", "修改前值", "修改后值" };
CsvHelper.ExportDataTableToCsv(_dt, newCsvName, colname, true);
json = "true," + filename + "," + excelPath;
}
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);
json = "false, ";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
