public void UploadAndExtractFreeCountryExcel([FromUri] int id)
{
//从httpRequest中获取文件并写入磁盘系统
var filesGetter = new FilesGetter();
var fileSavePath = filesGetter.GetAndSaveFileFromHttpRequest(@"D:\TempFiles\");
if (fileSavePath == "")
{
throw new HttpResponseException(HttpStatusCode.BadRequest);
}
//var excel = new ExcelExtracter(fileSavePath);
//excel.ExtractFCPurchaseOrderSummary(id);
//excel.ExtractFCPurchaseOrderDetail(id);
var parser = new ExcelParser(fileSavePath);
parser.ParseFreeCountryPackingListV2(id);
//强行关闭进程
var killer = new ExcelKiller();
killer.Dispose();
}
public IHttpActionResult UploadTemplate([FromUri] int shipOrderId, [FromUri] string operation)
{
var fileGetter = new FilesGetter();
var path = fileGetter.GetAndSaveFileFromHttpRequest(@"D:\TempFiles\");
if (path == "")
{
throw new HttpResponseException(HttpStatusCode.BadRequest);
}
var extracter = new FBAExcelExtracter(path);
if (operation == FBAOperation.UploadBOL)
{
var bolDetailList = extracter.ExtractBOLTemplate();
var generator = new PDFGenerator();
var fileName = generator.GenerateFBABOL(shipOrderId, bolDetailList);
return(Ok(fileName));
}
else if (operation == FBAOperation.UploadShipOrder)
{
extracter.ExtractFBAPickingListTemplate(shipOrderId);
return(Ok("Create success!"));
}
return(Ok());
}
public void CreateNewGeneralLocationSummaryAndDetail([FromUri] string vendor, [FromUri] string inboundDate, [FromUri] int preId)
{
var fileSavePath = "";
var filesGetter = new FilesGetter();
fileSavePath = filesGetter.GetAndSaveFileFromHttpRequest(@"D:\TempFiles\");
if (fileSavePath == "")
{
throw new HttpResponseException(HttpStatusCode.BadRequest);
}
var excel = new ExcelExtracter(fileSavePath);
excel.UploadReplenishimentLocationDetail(preId, vendor, inboundDate, fileSavePath.Split('\\').Last().Split('.').First());
}
public void UploadFBATemplate([FromUri] string grandNumber)
{
//从httpRequest中获取文件并写入磁盘系统
var filesGetter = new FilesGetter();
var fileSavePath = filesGetter.GetAndSaveFileFromHttpRequest(@"D:\TempFiles\");
if (fileSavePath == "")
{
throw new HttpResponseException(HttpStatusCode.BadRequest);
}
var excel = new FBAExcelExtracter(fileSavePath);
var killer = new ExcelKiller();
excel.ExtractFBAPackingListTemplate(grandNumber);
killer.Dispose();
}
public void ExtractPullSheetExcel([FromUri] int id)
{
var fileSavePath = "";
//方法1：写入磁盘系统
//从httpRequest中获取文件并写入磁盘系统
var filesGetter = new FilesGetter();
fileSavePath = filesGetter.GetAndSaveFileFromHttpRequest(@"D:\TempFiles\");
if (fileSavePath == "")
{
throw new HttpResponseException(HttpStatusCode.BadRequest);
}
var excel = new ExcelExtracter(fileSavePath);
excel.ExtractPullSheet(id);
}
public void CreateReplenishmentPickDetailFormLoadPlan([FromUri] int shipOrderId)
{
var fileSavePath = "";
var filesGetter = new FilesGetter();
var shipOrderInDb = _context.ShipOrders.Find(shipOrderId);
fileSavePath = filesGetter.GetAndSaveFileFromHttpRequest(@"D:\TempFiles\");
if (fileSavePath == "")
{
throw new HttpResponseException(HttpStatusCode.BadRequest);
}
var extractor = new LoadPlanExtracter(fileSavePath);
extractor.PickReplenishmentLoadPlan(shipOrderId);
shipOrderInDb.Status = Status.Picking;
_context.SaveChanges();
}
public IHttpActionResult UploadFiles([FromUri] string reference, [FromUri] string orderType, [FromUri] string fileName, [FromUri] string version)
{
var fileGetter = new FilesGetter();
var path = fileGetter.GetAndSaveFileFromHttpRequest(@"D:\eFolder\");
var newFileRecord = new EFile();
if (version == "V1")
{
newFileRecord.CustomizedFileName = fileName + "-" + DateTime.Now.ToString("hhmmss");
newFileRecord.FileName = path.Split('\\').Last();
newFileRecord.RootPath = @"D:\eFolder\";
newFileRecord.UploadBy = _userName;
newFileRecord.UploadDate = DateTime.Now;
}
else
{
throw new Exception("The system does not support version:" + version + ".");
}
if (orderType == FBAOrderType.MasterOrder)
{
var masterOrderInDb = _context.FBAMasterOrders.SingleOrDefault(x => x.Container == reference);
newFileRecord.FBAMasterOrder = masterOrderInDb;
}
else if (orderType == FBAOrderType.ShipOrder)
{
var shipOrderInDb = _context.FBAShipOrders.SingleOrDefault(x => x.ShipOrderNumber == reference);
newFileRecord.FBAShipOrder = shipOrderInDb;
}
else
{
throw new Exception("The system does not support order type:" + orderType + ".");
}
_context.EFiles.Add(newFileRecord);
_context.SaveChanges();
return(Ok("File has been uploaded successfully."));
}
public void UploadRegularPackingList([FromUri] int preId, [FromUri] string vendor)
{
var fileSavePath = "";
var filesGetter = new FilesGetter();
fileSavePath = filesGetter.GetAndSaveFileFromHttpRequest(@"D:\TempFiles\");
if (fileSavePath == "")
{
throw new HttpResponseException(HttpStatusCode.BadRequest);
}
var excel = new ExcelExtracter(fileSavePath);
excel.ExtractPOSummaryAndCartonDetail(preId, vendor);
var killer = new ExcelKiller();
killer.Dispose();
}
public void SaveUploadedFileAndExtractExcel([FromUri] int id, [FromUri] string vendor)
{
var fileSavePath = "";
//写入磁盘系统
var filesGetter = new FilesGetter();
fileSavePath = filesGetter.GetAndSaveFileFromHttpRequest(@"D:\TempFiles\");
if (fileSavePath == "")
{
throw new HttpResponseException(HttpStatusCode.BadRequest);
}
var excel = new ExcelExtracter(fileSavePath);
excel.ExtractPOSummaryAndCartonDetail(id, vendor);
//强行关闭进程
var killer = new ExcelKiller();
killer.Dispose();
}
