private void BtnCountry_Click(object sender, EventArgs e)
{
List <WebApi.DataModel.CustomModel.SAP.BpCountry> _BpCountryList = GetCountryList();
XSLXHelper helper = new XSLXHelper();
var xlsx = helper.Export(_BpCountryList);
xlsx.SaveAs(filepathNoExt + "_Country" + ".xlsx");
MessageBox.Show("done");
}
private void BtnBpAddress_Click(object sender, EventArgs e)
{
List <WebApi.DataModel.CustomModel.SAP.BpAddress> _BpAddressList = GetBpAddressList();
XSLXHelper helper = new XSLXHelper();
var xlsx = helper.Export(_BpAddressList);
xlsx.SaveAs(filepath);
MessageBox.Show("done");
}
private void BtnBpXY_Click(object sender, EventArgs e)
{
Stopwatch sw = new Stopwatch();
sw.Reset();
sw.Start();
List <WebApi.DataModel.CustomModel.SAP.BpXY> _BpXYList = GetBpXYList();
XSLXHelper helper = new XSLXHelper();
var xlsx = helper.Export(_BpXYList);
xlsx.SaveAs(filepathNoExt + "_XY" + ".xlsx");
MessageBox.Show("done");
sw.Stop();
MessageBox.Show(sw.ElapsedMilliseconds.ToString() + "毫秒");
}
private string saveExcel(List <Edi_Pos> edi_PosList, string fileName)
{
XSLXHelper helper = new XSLXHelper();
var xlsx = helper.Export(edi_PosList, false);
string pathString = HttpContext.Current.Server.MapPath("~/Success/PosExport");
if (!Directory.Exists(pathString))
{
Directory.CreateDirectory(pathString);
}
string _FilePath = pathString + "/" + fileName;
xlsx.SaveAs(pathString + "/" + fileName);
return(_FilePath);
}
private void BtnMoqOrder_Click(object sender, EventArgs e)
{
string _Tag = ((Button)sender).Tag.ToString();
Stopwatch sw = new Stopwatch();
sw.Reset();
sw.Start();
List <WebApi.DataModel.CustomModel.SAP.SapLessMoqOrder> _SapLessMoqOrderList = GetSapLessMoqOrderList(_Tag);
XSLXHelper helper = new XSLXHelper();
var xlsx = helper.Export(_SapLessMoqOrderList);
xlsx.SaveAs(filepathNoExt + "_MoqOrder" + ".xlsx");
MessageBox.Show("done");
sw.Stop();
MessageBox.Show(sw.ElapsedMilliseconds.ToString() + "毫秒");
}
private void BtnExcel_Click(object sender, EventArgs e)
{
Stopwatch sw = new Stopwatch();
sw.Reset();
sw.Start();
txtDate.Text = "";
SapMiddleData _SapMiddleData = initSapMiddleData();
//建立 xlxs 轉換物件
XSLXHelper helper = new XSLXHelper();
List <SapPriceListExcel> _SapPriceListExcelList = SetSapPriceListExcel(_SapMiddleData.PriceList);
var xlsx = helper.Export(_SapPriceListExcelList);
xlsx.SaveAs(filepathNoExt + "_SapPrice" + ".xlsx");
sw.Stop();
MessageBox.Show(sw.ElapsedMilliseconds.ToString() + "毫秒");
}
