public IHttpActionResult CreateNewPrereceiveOrder([FromUri] string orderType, [FromUri] string vendor)
{
var extractor = new ExcelExtracter();
extractor.CreatePreReceiveOrder(orderType, vendor);
var sample = _context.PreReceiveOrders.OrderByDescending(x => x.Id).First();
var sampleDto = Mapper.Map <PreReceiveOrder, PreReceiveOrdersDto>(sample);
return(Created(Request.RequestUri + "/" + sample.Id, sampleDto));
}
public void CreateNewGeneralLocationSummaryAndDetail([FromUri] string vendor, [FromUri] string inboundDate, [FromUri] int preId)
{
var fileSavePath = "";
var filesGetter = new FilesGetter();
fileSavePath = filesGetter.GetAndSaveSingleFileFromHttpRequest(@"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 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 UploadRegularPackingList([FromUri] int preId, [FromUri] string vendor)
{
var fileSavePath = "";
var filesGetter = new FilesGetter();
fileSavePath = filesGetter.GetAndSaveSingleFileFromHttpRequest(@"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.GetAndSaveSingleFileFromHttpRequest(@"D:\TempFiles\");
if (fileSavePath == "")
{
throw new HttpResponseException(HttpStatusCode.BadRequest);
}
var excel = new ExcelExtracter(fileSavePath);
excel.ExtractPOSummaryAndCartonDetail(id, vendor);
//强行关闭进程
var killer = new ExcelKiller();
killer.Dispose();
}
