protected void cmdExport_Click(object sender, EventArgs e)
{
try
{
string Checkbox_Value = WebHelper.GetStringParam(Request, "Checkbox", "");
string[] Checkbox_Value_Array = Checkbox_Value.Split(',');
Int32 IDX = 0;
List <DNNGo_PowerForms_Content> DataList = new List <DNNGo_PowerForms_Content>();
for (int i = 0; i < Checkbox_Value_Array.Length; i++)
{
if (Int32.TryParse(Checkbox_Value_Array[i], out IDX))
{
DNNGo_PowerForms_Content ContentItem = DNNGo_PowerForms_Content.FindByKeyForEdit(IDX);
if (ContentItem != null && ContentItem.ID > 0 && !String.IsNullOrEmpty(ContentItem.ContentValue))
{
//DataList.Add( Common.Deserialize<List<DNNGo_PowerForms_ContentItem>>(ContentItem.ContentValue));
DataList.Add(ContentItem);
}
}
}
if (DataList.Count > 0)
{
try
{
String FullName = String.Empty;
if (CsvHelper.SaveAsToFile(FieldList, DataList, out FullName, this))
{
FileSystemUtils.DownloadFile(FullName, Path.GetFileName(FullName));
//Response.Write(FullName);
}
else
{
mTips.LoadMessage("SaveExportRecordsError", EnumTips.Error, this, new String[] { FullName });
}
}
catch (Exception ex)
{
DotNetNuke.Services.Exceptions.Exceptions.ProcessModuleLoadException(this, ex);
}
}
}
catch (Exception ex)
{
DotNetNuke.Services.Exceptions.Exceptions.ProcessModuleLoadException(this, ex);
}
}
protected void cmdExportAll_Click(object sender, EventArgs e)
{
try
{
QueryParam qp = new QueryParam();
qp.OrderType = 1;
qp.Orderfld = DNNGo_PowerForms_Content._.ID;
qp.PageSize = int.MaxValue;
qp.Where = BindSearch();
Int32 RecordCount = 0;
List <DNNGo_PowerForms_Content> DataList = DNNGo_PowerForms_Content.FindAll(qp, out RecordCount);
if (DataList != null && DataList.Count > 0)
{
try
{
String FullName = String.Empty;
if (CsvHelper.SaveAsToFile(FieldList, DataList, out FullName, this))
{
FileSystemUtils.DownloadFile(FullName, Path.GetFileName(FullName));
//Response.Write(FullName);
}
else
{
//导出记录失败
mTips.IsPostBack = true;
mTips.LoadMessage("SaveExportRecordsError", EnumTips.Error, this, new String[] { FullName });
}
}
catch (Exception ex)
{
DotNetNuke.Services.Exceptions.Exceptions.ProcessModuleLoadException(this, ex);
}
}
}
catch (Exception ex)
{
DotNetNuke.Services.Exceptions.Exceptions.ProcessModuleLoadException(this, ex);
}
}
/// <summary>
/// 导出表格
/// </summary>
/// <param name="SchedulerItem"></param>
/// <returns></returns>
public String ExportExcel(DNNGo_PowerForms_Scheduler SchedulerItem, Int32 index)
{
String Attachment = String.Empty;
List <DNNGo_PowerForms_Content> DataList = DNNGo_PowerForms_Content.FindAllByModuleId(SchedulerItem.ModuleId);
List <DNNGo_PowerForms_Field> FieldList = DNNGo_PowerForms_Field.FindAllByModuleId(SchedulerItem.ModuleId);
if (DataList != null && DataList.Count > 0)
{
if (FieldList != null && FieldList.Count > 0)
{
String FileName = SchedulerItem.ExcelName;
FileName = Common.ReplaceNoCase(FileName, "{yyyy}", DateTime.Now.ToString("yyyy"));
FileName = Common.ReplaceNoCase(FileName, "{mm}", DateTime.Now.ToString("MM"));
FileName = Common.ReplaceNoCase(FileName, "{dd}", DateTime.Now.ToString("dd"));
FileName = Common.ReplaceNoCase(FileName, "{time}", DateTime.Now.ToString("HHmmss"));
FileName = Common.ReplaceNoCase(FileName, "{ModuleID}", SchedulerItem.ModuleId.ToString());
Attachment = String.Format("{0}temp\\PowerForms\\{1}.xls", HttpRuntime.AppDomainAppPath, FileName);
try
{
CsvHelper.SaveAsToFile(FieldList, DataList, Attachment, false);
}
catch (Exception exc)
{
this.ScheduleHistoryItem.AddLogNote(exc.Source);
}
}
else
{
this.ScheduleHistoryItem.AddLogNote(String.Format("task {0},field list is empty,Has ignored. time:{1}<br />", index, DateTime.Now.ToString()));
}
}
else
{
this.ScheduleHistoryItem.AddLogNote(String.Format("task {0},History records is empty,Has ignored. time:{1}<br />", index, DateTime.Now.ToString()));
}
return(Attachment);
}
