protected void btnExcel_Click(object sender, System.EventArgs e)
{
DataTable incometPayoutConInfo = formBLL.GetIncometPayoutConInfo(this.prjId, this.txtContractCode.Text.Trim(), this.txtContractName.Text.Trim(), this.txtConType.Text.Trim(), 0, 0);
if (incometPayoutConInfo.Rows.Count > 0)
{
DataRow dataRow = incometPayoutConInfo.NewRow();
dataRow["Num"] = "合计";
dataRow["ContractPrice"] = incometPayoutConInfo.Compute("sum(ContractPrice)", "1>0");
dataRow["InCometContractMoney"] = incometPayoutConInfo.Compute("sum(InCometContractMoney)", "1>0");
dataRow["IncometBalanceMoney"] = incometPayoutConInfo.Compute("sum(IncometBalanceMoney)", "1>0");
dataRow["IncometPaymentMoney"] = incometPayoutConInfo.Compute("sum(IncometPaymentMoney)", "1>0");
dataRow["IncometApplyMoney"] = incometPayoutConInfo.Compute("sum(IncometApplyMoney)", "1>0");
dataRow["PayoutModifiedMoney"] = incometPayoutConInfo.Compute("sum(PayoutModifiedMoney)", "1>0");
dataRow["PayoutBalanceMoney"] = incometPayoutConInfo.Compute("sum(PayoutBalanceMoney)", "1>0");
dataRow["PayoutPaymentMoney"] = incometPayoutConInfo.Compute("sum(PayoutPaymentMoney)", "1>0");
dataRow["SpreadConMoney"] = incometPayoutConInfo.Compute("sum(SpreadConMoney)", "1>0");
dataRow["SpreadBalanceMoney"] = incometPayoutConInfo.Compute("sum(SpreadBalanceMoney)", "1>0");
dataRow["SpreadPaymentMoney"] = incometPayoutConInfo.Compute("sum(SpreadPaymentMoney)", "1>0");
incometPayoutConInfo.Rows.Add(dataRow);
}
IExportable exporter = new ExcelExporter();
FileExport fileExport = new FileExport(exporter, this.FormatData(incometPayoutConInfo), "收入合同明细.xls");
fileExport.Export(base.Request.Browser.Browser);
}
/// <summary>
/// 导出
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void tsBtnExport_Click(object sender, EventArgs e)
{
if (FileExport.fileExport(fpGasConcentrationProbeDataInfo, true))
{
Alert.alert(Const.EXPORT_SUCCESS_MSG);
}
}
void OnWizardCreate()
{
tex = new List <TransformExportData> ();
mex = new Hashtable();
mtx = new Hashtable();
for (var i = 0; i < transforms.Length; i++)
{
RecurseTransform(transforms[i]);
}
string meshesPath = EditorUtility.SaveFilePanel("Save meshes", FileExport.lastExportPath, "", "js");
string scenePath = meshesPath.Substring(0, meshesPath.Length - 3) + "Scene.js";
StringTemplate mt = FileExport.LoadTemplate("model");
mt.SetAttribute("prefix", prefix + "Meshes");
mt.SetAttribute("meshes", mex.Values);
FileExport.SaveContentsAsFile(mt.ToString(), meshesPath);
StringTemplate st = FileExport.LoadTemplate("scene");
st.SetAttribute("prefix", prefix + "Scene");
st.SetAttribute("meshPrefix", prefix + "Meshes");
st.SetAttribute("transforms", tex);
st.SetAttribute("root", tex[0]);
st.SetAttribute("meshes", mex.Values);
st.SetAttribute("materials", mtx.Values);
FileExport.SaveContentsAsFile(st.ToString(), scenePath);
FileExport.lastExportPath = meshesPath;
}
/// <summary>
/// 导出
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void tsBtnExport_Click(object sender, EventArgs e)
{
if (FileExport.fileExport(_fpTunelInfo, false))
{
Alert.alert(Const.EXPORT_SUCCESS_MSG);
}
}
/// <summary>
/// 导出
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void tsBtnExport_Click(object sender, EventArgs e)
{
if (FileExport.fileExport(fpUserInformationDetails, true))
{
Alert.alert(Const.EXPORT_SUCCESS_MSG);
}
}
static void Export(List <Info> infoList)
{
if (infoList == default(List <Info>))
{
throw new ArgumentNullException("The infoList connot be null.");
}
var path = string.Format(
"{0}{1}_{2}.csv",
Constants.PathWrite,
Constants.FileNameExport,
DateTime.Now.ToString("yyyyMMddHHmmssfff")
);
string.Concat(Constants.PathWrite, Constants.FileNameExport);
var file1 = new FileExport(Enumerators.ExporType.Csv);
file1.Export(infoList, path);
path = string.Format(
"{0}{1}_{2}.txt",
Constants.PathWrite,
Constants.FileNameExport,
DateTime.Now.ToString("yyyyMMddHHmmssfff")
);
var file2 = new FileExport(Enumerators.ExporType.Text);
file2.Export(infoList, path);
}
/// <summary>
/// 导出
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void tsBtnExport_Click(object sender, EventArgs e)
{
if (FileExport.fileExport(_fpDepartmentInfo, true))
{
Alert.alert(Const.EXPORT_SUCCESS_MSG);
}
}
protected void btnExportExcel_Click(object sender, EventArgs e)
{
DataTable dt = GetProjectTable();
dt.TableName = "Project";
DataRow dr = dt.NewRow();
dr[1] = "Total";
dr[2] = dt.Rows.Count;
decimal phdHrs = 0.0m, msHrs = 0.0m;
foreach (DataRow row in dt.Rows)
{
phdHrs += Convert.ToDecimal(row["PhdHrs"].ToString());
msHrs += Convert.ToDecimal(row["MsHrs"].ToString());
}
dr[16] = phdHrs;
dr[17] = msHrs;
dt.Rows.Add(dr);
FileExport fileExport = new FileExport(this.Response);
fileExport.ExcelExport(dt, "Project");
}
/// <summary>
/// 导出
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void tsBtnExport_Click(object sender, EventArgs e)
{
if (FileExport.fileExport(_fpPreWaringLastedValue, false))
{
Alert.alert(Const.EXPORT_SUCCESS_MSG);
}
}
private void tsBtnExport_Click(object sender, EventArgs e)
{
if (FileExport.fileExport(fpDayReportHChuan, true))
{
Alert.alert(Const.EXPORT_SUCCESS_MSG);
}
}
/// <summary>
/// 导出
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void tsBtnExport_Click(object sender, EventArgs e)
{
if (FileExport.fileExport(_fpPreWarningResultDetials, false))
{
Alert.alert(Const.EXPORT_SUCCESS_MSG);
}
}
protected void btnExcel_Click(object sender, System.EventArgs e)
{
DataTable data = this.GetData();
IExportable exporter = new ExcelExporter();
FileExport fileExport = new FileExport(exporter, data, "项目成本分析报表.xls");
fileExport.Export(base.Request.Browser.Browser);
}
protected void btnExcel_Click(object sender, EventArgs e)
{
DataTable dateSouce = this.getDateSouce();
IExportable exporter = new ExcelExporter();
FileExport fileExport = new FileExport(exporter, dateSouce, "周计划报表.xls");
fileExport.Export(base.Request.Browser.Browser);
}
/// <summary>
/// Creates an excel file of the list of grants (based on the available, optional parameters of Principal Investigator,
/// QHS Faculty/Staff, Fund Status, and/or Internal/External grants) that have been displayed on the Tracking > Grant main page.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnExportExcel_Click(object sender, EventArgs e)
{
DataTable dt = GetGrantTable();
FileExport fileExport = new FileExport(this.Response);
fileExport.ExcelExport(dt, "Grant.xlsx");
}
private void ExportDaliyReport()
{
if (_PathReport.Length <= 0)
{
SetMsg("匯出報表至伺服器失敗，沒有設定[每日報表匯出路徑]。");
Thread.Sleep(300);
return;
}
//先判斷今天是否有測試紀錄;//
string DateFrom = DateTime.Today.ToString("yyyy-MM-dd") + " 00:00:00";
string DateTo = DateTime.Today.ToString("yyyy-MM-dd") + " 23:59:59";
DataTable dtTest = DaoSQL.Instance.GetTestHistory(DateFrom, DateTo);
if (dtTest.Rows.Count <= 0)
{
return;
}
//客戶要求取得全部的測試資料;//
dtTest = DaoSQL.Instance.GetTestHistory();
dtTest.TableName = DateTime.Today.ToString("yyyy-MM-dd");
//先取得所有資料集;//
DataSet Ds = new DataSet();
Ds.Tables.Add(dtTest);
//String TimeForFileName = DateTime.Now.ToString("yyyy-MM-dd");
//string FileName = string.Format("./{0}-{1}_{2}.xls", m_Machine.機台代碼, m_Machine.描述, TimeForFileName);
//客戶要求每次上傳報告都是上傳全部，所以不須加上時間;//
string FileName = string.Format("./{0}-{1}.xls", m_Machine.機台代碼, m_Machine.描述);
//輸出檔案成Excel檔;//
try
{
FileExport.ExportDataSetToExcel(Ds, FileName);
}
catch (Exception ex)
{
Logger.Error(string.Format("匯出報表檔案失敗!\r\n資訊:{0}", ex.Message));
}
//將這檔案上傳到指定路徑;//
try
{
NetTranslate.Transport(FileName, _PathReport, Path.GetFileName(FileName));
}
catch (Exception Ex)
{
Logger.Error(string.Format("傳送報表資訊失敗!\r\n資訊:{0}", Ex.Message));
}
//刪除報表檔案;//
File.Delete(FileName);
}
protected void btnExportExcel_Click(object sender, EventArgs e)
{
DataTable dt = CreateInvoiceTable(-1, true);
string fileValue = String.Format("Invoice-{0}.xlsx", txtInvoiceId.Value);
FileExport fileExport = new FileExport(this.Response);
fileExport.ExcelExport(dt, fileValue);
}
protected void btnExcel_Click(object sender, EventArgs e)
{
DataTable reportData = this.GetReportData();
IExportable exportable = new ExcelExporter();
FileExport fileExport = new FileExport(exportable, reportData, "支出合同发票台帐.xls");
exportable.PercentColumns = new int[]
{
10
};
fileExport.Export(base.Request.Browser.Browser);
}
protected void btnExcel_Click(object sender, System.EventArgs e)
{
DataTable reportData = this.GetReportData();
FileExport fileExport = new FileExport(new ExcelExporter
{
PercentColumns = new int[]
{
8
}
}, reportData, "支出合同结算报表.xls");
fileExport.Export(base.Request.Browser.Browser);
}
public IActionResult Post([FromBody] FileExport file)
{
byte[] fileContents = _IExportExcel.ToBytes(file.List);
if (fileContents == null || fileContents.Length == 0)
{
return(NotFound());
}
return(File(
fileContents: fileContents,
contentType: "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
fileDownloadName: file.FileName
));
}
protected void btnExcel_Click(object sender, System.EventArgs e)
{
DataTable reportData = this.GetReportData();
FileExport fileExport = new FileExport(new ExcelExporter
{
PercentColumns = new int[]
{
11
}
}, reportData, ContractManage_ContractReport_ContractSumReport.CorpName + "明细表.xls");
fileExport.Export(base.Request.Browser.Browser);
}
protected void btnExcel_Click(object sender, EventArgs e)
{
DataTable reportData = this.GetReportData();
FileExport fileExport = new FileExport(new ExcelExporter
{
PercentColumns = new int[]
{
5
}
}, reportData, this.labTitle.Text.ToString() + ".xls");
fileExport.Export(base.Request.Browser.Browser);
}
public string ExportExcelFile([FromBody] FileExport fileExport)
{
_logger.LogInformation("Export file");
var obj = new JObject();
string filePath = Path.Combine(Environment.CurrentDirectory, $"wwwroot/exportfiles/");
if (!Directory.Exists(filePath))
{
Directory.CreateDirectory(filePath);
}
string fileName = $"{DateTime.Now:yyyyMMddHHmmssffff}.xlsx";
string fileFullName = Path.Combine(filePath, fileName);
FileInfo file = new FileInfo(fileFullName);
try
{
using (ExcelPackage ep = new ExcelPackage(file))
{
ExcelWorksheet worksheet = ep.Workbook.Worksheets.Add("export");
for (int i = 1; i <= fileExport.lable.Count; i++)
{
worksheet.Cells[1, i].Value = fileExport.lable[i - 1];
}
for (int i = 1; i <= fileExport.data.Count; i++)
{
worksheet.Cells[i + 1, 1].Value = fileExport.data[i - 1].clock;
worksheet.Cells[i + 1, 2].Value = fileExport.data[i - 1].errorObject;
worksheet.Cells[i + 1, 3].Value = fileExport.data[i - 1].desc;
worksheet.Cells[i + 1, 4].Value = fileExport.data[i - 1].severity;
}
ep.Save();
}
}
catch (InvalidOperationException ex)
{
_logger.LogError("Export Error", ex);
}
var data = new JObject();
data["url"] = $"/exportfiles/{fileName}";
data["localpath"] = fileFullName;
obj["data"] = data;
obj["success"] = true;
return(obj + "");
}
protected void btnExcel_Click(object sender, System.EventArgs e)
{
DataTable reportData = this.GetReportData();
IExportable exportable = new ExcelExporter();
exportable.PercentColumns = new int[]
{
8
};
string fileName = this.GetPrjName() + "的" + BudgetManage_Report_IndirectCostDetail.cBSName + "明细表.xls";
FileExport fileExport = new FileExport(exportable, reportData, fileName);
fileExport.Export(base.Request.Browser.Browser);
}
/// <summary>
/// Exports the report in CSV format in which can be imported back
/// into REDCap for RMATRIX's records (Point person: Ms. Grace Matsuura, GDO Data Coordinator).
/// </summary>
private void ExportCsv()
{
DateTime fromDate, toDate;
if (DateTime.TryParse(txtFromDate.Text, out fromDate) && DateTime.TryParse(txtToDate.Text, out toDate))
{
string constr = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
SqlConnection con = new SqlConnection(constr);
string reportGrant = ddlGrantType.SelectedItem.Text;
var cmdText = reportGrant == "RMATRIX" ? "Rpt_RMATRIX_Monthly" : "Rpt_Ola_HAWAII_Monthly";
try
{
DataTable dt = ddlGrantType.SelectedItem.Text == "RMATRIX" ? new DataTable("tblRmatrix") : new DataTable("tblOlaHawaii");
using (SqlConnection sqlcon = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand(cmdText, sqlcon))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@StartDate", fromDate);
cmd.Parameters.AddWithValue("@EndDate", toDate);
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(dt);
}
}
}
FileExport fileExport = new FileExport(this.Response);
fileExport.CsvExport(dt, fromDate, download_token.Value, reportGrant);
}
catch (Exception ex)
{
//Response.Write(ex.ToString());
throw ex;
}
finally
{
if (con.State != ConnectionState.Closed)
{
con.Close();
}
}
}
}
/// <summary>
/// Saves the output file.
/// </summary>
/// <param name="outputFilePath">Path of the output file.</param>
/// <exception cref="System.InvalidOperationException">Output file not saved, file name required.</exception>
public void SaveOutputFile(string outputFilePath)
{
if (MatchSaved)
{
throw new InvalidOperationException(
"Call AddAllLocationCodes before saving");
}
if (string.IsNullOrEmpty(outputFilePath.Trim()))
{
throw new ArgumentException(
"Output file not saved, file name required.");
}
FileExport.SaveToCsvFile(outputFilePath.Trim(), InputData);
inputData.Data.AcceptChanges();
}
protected void btnExportExcel_Click(object sender, EventArgs e)
{
DataTable dt = CreateAgreementDataTable(false);
int collabId = 0;
Int32.TryParse(ddlCollab.SelectedValue, out collabId);
string strCollab = collabId > 0 ? (ddlCollab.SelectedItem.Text.Split('|')[0]).Trim() : "all";
string fileValue = String.Format("Agreement-{0}.xlsx", strCollab);
FileExport fileExport = new FileExport(this.Response);
fileExport.ExcelExport(dt, fileValue);
}
public void Should_use_a_specially_configured_type_default()
{
var exportSpecification = new FileExport <SimpleObject>();
exportSpecification.AddDefault <int>(value => value + "_ASDF");
var fileExportSpecification = exportSpecification.CreateSpec();
var simpleObject = new SimpleObject {
Id = 2, StringValue1 = "HELLO"
};
// Should use the "globally" configured formatter
fileExportSpecification.GetPropertiesForType <SimpleObject>()["Id"].GetFormattedValue(simpleObject).ShouldEqual("2_ASDF");
// Should not do any special formatting
fileExportSpecification.GetPropertiesForType <SimpleObject>()["StringValue1"].GetFormattedValue(simpleObject).ShouldEqual("HELLO");
}
public HttpResponseMessage ExportEntriesForNavision([FromBody] EntryFilter filter)
{
using (MemoryStream stream = new FileExport().GetExportFile(filter, User, new TimeEntryAccess()))
{
var result = new HttpResponseMessage(HttpStatusCode.OK)
{
Content = new ByteArrayContent(stream.GetBuffer())
};
result.Content.Headers.ContentDisposition =
new ContentDispositionHeaderValue("attachment")
{
FileName = "Test.csv"
};
result.Content.Headers.ContentType =
new MediaTypeHeaderValue("application/octet-stream");
return(result);
}
}
public string ExportFile([FromBody] FileExport fileExport)
{
_logger.LogInformation("Export file");
var ret = new JObject();
string filePath = Path.Combine(Environment.CurrentDirectory, $"wwwroot/exportfiles/");
if (!Directory.Exists(filePath))
{
Directory.CreateDirectory(filePath);
}
string fileName = $"{DateTime.Now:yyyyMMddHHmmssffff}.txt";
string fileFullName = Path.Combine(filePath, fileName);
var sb = new StringBuilder();
try
{
foreach (var column in fileExport.lable)
{
sb.Append(column).Append('\t');
}
sb.AppendLine();
sb.AppendLine("---------------------------------------------");
foreach (var data in fileExport.data)
{
sb.Append(data.clock).Append('\t').Append(data.errorObject).Append('\t').Append(data.desc).Append('\t').Append(data.severity).Append('\t');
sb.AppendLine();
}
System.IO.File.WriteAllText(fileFullName, sb.ToString(), Encoding.UTF8);
}
catch (InvalidOperationException ex)
{
_logger.LogError("Export Error", ex);
}
var retData = new JObject();
retData["url"] = $"/exportfiles/{fileName}";
retData["localpath"] = fileFullName;
ret["data"] = retData;
ret["success"] = true;
return(ret + "");
}
//[HttpPost]
public byte[] FileExport(string ReportType)
//public FileResult FileExport(string ReportType)
{
//ReportType = null;
string url = ConfigurationManager.AppSettings["mTaka_server"] + "/api/FundIn/DailyFundIn";
dynamic json = DataManipulation.SetObject(url, ReportType);
List <FileExport> _FileExport = Newtonsoft.Json.JsonConvert.DeserializeObject <List <FileExport> >(json.ToString());
FileExport fileExport = new FileExport();
LocalReport localReport = new LocalReport();
localReport.ReportPath = Server.MapPath("~/Reports/PerformanceReport.rdlc");
ReportDataSource reportDataSource = new ReportDataSource();
reportDataSource.Name = "PerformanceDataSet";
reportDataSource.Value = _FileExport;
localReport.DataSources.Add(reportDataSource);
string reportType = "PDF";
string mimeType;
string encoding;
string fileNameExtension = (ReportType == "003") ? "xlsx" : (ReportType == "002" ? "doc" : "pdf");
Warning[] warnings;
string[] streams;
byte[] renderedBytes;
renderedBytes = localReport.Render(reportType, "", out mimeType, out encoding,
out reportType, out streams, out warnings);
Response.AddHeader("content-disposition", "attachment; filename=Performance." + reportType);
Response.ContentType = "application/octectstream";
Response.BinaryWrite(renderedBytes);
Response.End();
//return File(renderedBytes, reportType);
return(renderedBytes);
//Response.Write(string.Format("<script>window.open('{0}','_blank');</script>", "~/Reports/Print.html?file= Performance.pdf"));
}
