private void btnDownload_Click(object sender, EventArgs e) { DataTable table = (DataTable)dgvMouldDetail.DataSource; //ExportCsvUtil.ExportCsv(table, "", "Model Detail"); if (table.Rows.Count > 0) ExportExcelUtil.ExportExcel(table); }
private void tsbtnTemplate_Click(object sender, EventArgs e) { DataTable template = new DataTable(); string[] headers = { "Chase No.", "Mould No.", "Part No.", "Rev", "Div", "Vendor", "Vendor Name", "Request No.", "PO" }; foreach (string header in headers) { template.Columns.Add(header); } ExportExcelUtil.ExportExcel(template); }
private void tsbtnTemplate_Click(object sender, EventArgs e) { DataTable template = new DataTable(); string[] headers = { "Code", "Content", "Account Code", "Cost Centre", "Remarks" }; foreach (string header in headers) { template.Columns.Add(header); } ExportExcelUtil.ExportExcel(template); }
private void tsbtnTemplate_Click(object sender, EventArgs e) { DataTable template = new DataTable(); string[] headers = { "Vendor", "Name", "Pur.G", "Currency", "Pay Terms", "Region", "Request", "EDI", "Remarks" }; foreach (string header in headers) { template.Columns.Add(header); } ExportExcelUtil.ExportExcel(template); }
private void tsbtnTemplate_Click(object sender, EventArgs e) { DataTable template = new DataTable(); string[] headers = { "Mould Code", "Type", "Content (Jp)", "Content (Eng)", "Content (Chin)", "Item Group" }; foreach (string header in headers) { template.Columns.Add(header); } ExportExcelUtil.ExportExcel(template); }
private void btnDownload_Click(object sender, EventArgs e) { string text = _status == "會計處理中" ? string.Format("select o_invoice, o_vendor, o_vendorname, o_inputdate, o_paymentdate, o_currency, o_createdby, o_created" + ", od_accountcode, od_accountname, od_costcentre, od_costcentrename, od_amount, od_display from TB_ACC_OUTSTANDING, TB_ACC_OUTSTANDING_DETAIL" + " where o_id = od_o_id and o_status = N'會計處理中' and o_staff = N'{0}'", GlobalService.User) : string.Format("select o_invoice, o_vendor, o_vendorname, o_inputdate, o_paymentdate, o_currency, o_createdby, o_created, od_accountcode, od_accountname" + ", od_costcentre, od_costcentrename, od_amount, od_display from TB_ACC_OUTSTANDING, TB_ACC_OUTSTANDING_DETAIL where o_id = od_o_id and o_status = N'會計承認中' and o_div = N'{0}'", GlobalService.User); DataTable table = new DataTable(); string[] headers = { "Invoice", "Vendor", "VendorName", "AccountCode", "AccountName", "CostCentre", "CostCentreName", "InputDate", "PaymentDate", "Currency", "Amount", "Description", "CreatedBy", "Created", "Approval" }; foreach (string header in headers) { table.Columns.Add(header); } using (IDataReader reader = DataServiceCM.GetInstance().ExecuteReader(text)) { while (reader.Read()) { string invoice = reader.GetString(0).Trim(); string vendor = reader.GetString(1).Trim(); string vendorname = reader.GetString(2).Trim(); string inputdate = reader.GetString(3).Trim(); string paydate = reader.GetString(4).Trim(); string currency = reader.GetString(5).Trim(); string createdby = reader.GetString(6).Trim(); string created = reader.GetString(7).Trim(); string acccode = reader.GetString(8).Trim(); string accname = reader.GetString(9).Trim(); string costcentre = reader.GetString(10).Trim(); string costcentrename = reader.GetString(11).Trim(); string amount = reader.GetString(12).Trim(); string display = reader.GetString(13).Trim(); table.Rows.Add(invoice, vendor, vendorname, acccode, accname, costcentre, costcentrename, inputdate, paydate, currency, amount, display, createdby, created, "-"); } } ExportExcelUtil.ExportExcel(table); }
private void tsbtnDownload_Click(object sender, EventArgs e) { DataTable table = new DataTable(); string[] headers = { "Education", "Company", "Name", "Marks" }; foreach (string header in headers) { table.Columns.Add(header); } foreach (DataGridViewRow row in dgvRecord.Rows) { string education = row.Cells[0].Value.ToString(); string related = row.Cells[1].Value.ToString(); string name = row.Cells[2].Value.ToString(); string score = row.Cells[3].Value.ToString(); table.Rows.Add(new object[] { education, related, name, score }); } ExportExcelUtil.ExportExcel(table); }