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);
}
