public async Task <ResponseObject <string> > ExportBomTemplate() { try { CurrentUser currentUser = TokenManager.GetCurentUserbyToken(HttpContext.Request.Headers); var result = await _service.ExportBomTemplate(359, currentUser); //return result; ExportTemplateVM <TMMBOMDetailQueryExcelModel> model = new ExportTemplateVM <TMMBOMDetailQueryExcelModel>(); model.Entitys = result.Data.TMMBOMDetailQueryExcelList == null ? new List <TMMBOMDetailQueryExcelModel>() : result.Data.TMMBOMDetailQueryExcelList; model.Columns = new List <string>() { "ItemName", "MaterialName", "PartName", "LengthValue", "WidthValue", "NumValue", "WideValue", "LossValue", "SingleValue" }; model.Titles = new List <string>() { "ItemName", "MaterialName", "PartName", "LengthValue", "WidthValue", "NumValue", "WideValue", "LossValue", "SingleValue" }; model.HeaderText = "BOM模板"; model.TableName = "BOM模板"; model.FillRow = 6; model.Path = Path.Combine(AppContext.BaseDirectory, "Template", "ExportBomTemplate.xlsx"); Stream stream = ExcelHelp.ExportExcelByTemplate <TMMBOMDetailQueryExcelModel>(model); string fileName = "生产单模板-有配色方案.xlsx"; Dictionary <string, string> headsSend = new Dictionary <string, string>(); headsSend.Add(TokenConfig.Instace.TokenKey, Request.Headers[TokenConfig.Instace.TokenKey]); var filePath = RestfulApiClient.UploadFile(RestfulApiClient.UplaodUrl, "api/files/upload", headsSend, stream, fileName); return(ResponseUtil <string> .SuccessResult(filePath.ToString())); } catch (Exception ex) { return(ResponseUtil <string> .FailResult(null, ex.ToString())); } }
public async Task <ResponseObject <string> > ExportStaReport(string requestObject) { try { var request = JsonConvert.DeserializeObject <RequestGet>(requestObject); CurrentUser currentUser = TokenManager.GetCurentUserbyToken(HttpContext.Request.Headers); var result = await _inventoryReportService.LoadReport(request, currentUser); ExportTemplateVM <InventoryResultModel> model = new ExportTemplateVM <InventoryResultModel>(); model.Entitys = result.Data == null ? new List <InventoryResultModel>() : result.Data; model.Columns = new List <string>() { "MaterialCode", "MaterialName", "Spec", "ColorName", "BatchNo", "WarehouseCode", "WarehouseName", "BaseUnitName", "BaseUnitNumber", "WarehouseUnitName", "WarehouseAmount", "WarehouseRate", "InDate", "ShelfLife", "ValidDate", "Remark", }; model.Titles = new List <string>() { "MaterialCode", "MaterialName", "Spec", "ColorName", "BatchNo", "WarehouseCode", "WarehouseName", "BaseUnitName", "BaseUnitNumber", "WarehouseUnitName", "WarehouseAmount", "WarehouseRate", "InDate", "ShelfLife", "ValidDate", "Remark", }; model.HeaderText = "库存统计"; model.TableName = "库存统计"; model.FillRow = 3; model.Path = Path.Combine(AppContext.BaseDirectory, "Template", "InventoryReport.xlsx"); Stream stream = ExcelHelp.ExportExcelByTemplate <InventoryResultModel>(model); string fileName = "库存统计.xlsx"; Dictionary <string, string> headsSend = new Dictionary <string, string>(); headsSend.Add(TokenConfig.Instace.TokenKey, Request.Headers[TokenConfig.Instace.TokenKey]); var filePath = RestfulApiClient.UploadFile(RestfulApiClient.UplaodUrl, "api/files/upload", headsSend, stream, fileName); return(ResponseUtil <string> .SuccessResult(filePath.ToString())); } catch (Exception ex) { return(ResponseUtil <string> .FailResult(null, ex.ToString())); } }
public static List <TBMMaterialFileCacheModel> GetMaterial(CurrentUser currentUser) { string key = string.Format(CacheKeyString.Material, currentUser.CompanyID); List <TBMMaterialFileCacheModel> result = new List <TBMMaterialFileCacheModel>(); var redis = CacheFactory.Instance(CacheType.Redis); if (redis.ContainsKey(key)) { result = redis.GetValueByKey <List <TBMMaterialFileCacheModel> >(key); } else { bool postresult = RestfulApiClient.Post <bool>(RestfulApiClient.CacheUrl, "api/Cache/PostMaterial", BuildToken(currentUser), null); if (postresult) { result = redis.GetValueByKey <List <TBMMaterialFileCacheModel> >(key); } } return(result); }
public static List <TBMDomainQueryModel> GetDomains(CurrentUser currentUser) { string key = CacheKeyString.Domain; List <TBMDomainQueryModel> result = new List <TBMDomainQueryModel>(); var redis = CacheFactory.Instance(CacheType.Redis); if (redis.ContainsKey(key)) { result = redis.GetValueByKey <List <TBMDomainQueryModel> >(key); } else { bool postresult = RestfulApiClient.Post <bool>(RestfulApiClient.CacheUrl, "api/Cache/PostDomain", BuildToken(currentUser), null); if (postresult) { result = redis.GetValueByKey <List <TBMDomainQueryModel> >(key); } } return(result); }
public static List <ChinaAreaRecord> GetChinaArea(CurrentUser currentUser) { string key = CacheKeyString.ChinaArea; List <ChinaAreaRecord> result = new List <ChinaAreaRecord>(); var redis = CacheFactory.Instance(CacheType.Redis); if (redis.ContainsKey(key)) { result = redis.GetValueByKey <List <ChinaAreaRecord> >(key); } else { bool postresult = RestfulApiClient.Post <bool>(RestfulApiClient.CacheUrl, "api/Cache/PostArea", BuildToken(currentUser), null); if (postresult) { result = redis.GetValueByKey <List <ChinaAreaRecord> >(key); } } return(result); }
public async Task <ResponseObject <string> > ExportOpeningTemplate() { try { CurrentUser currentUser = TokenManager.GetCurentUserbyToken(HttpContext.Request.Headers); var result = await _inventoryReportService.ExportOpeningTemplate(currentUser); ExportOpeningTemplateVM <MaterialFileTemplate> model = new ExportOpeningTemplateVM <MaterialFileTemplate>(); model.Entitys = result.Data.List == null ? new List <MaterialFileTemplate>() : result.Data.List; model.Columns = new List <string>() { "MaterialCode", "MaterialName", "Spec", "WareName", "WareUnitName" }; model.Titles = new List <string>() { "MaterialCode", "MaterialName", "Spec", "WareName", "WareUnitName" }; model.HeaderText = "期初模板"; model.TableName = "期初模板"; model.FillRow = 1; model.DropDownEntitys = result.Data.WarehouseName; model.DropDownFillStartCell = 3; model.DropDownFillEndCell = 3; model.Path = Path.Combine(AppContext.BaseDirectory, "Template", "ExportOpeningTemplate.xlsx"); Stream stream = ExcelHelp.ExportOpeningTemplate <MaterialFileTemplate>(model); string fileName = "期初模板.xlsx"; Dictionary <string, string> headsSend = new Dictionary <string, string>(); headsSend.Add(TokenConfig.Instace.TokenKey, Request.Headers[TokenConfig.Instace.TokenKey]); var filePath = RestfulApiClient.UploadFile(RestfulApiClient.UplaodUrl, "api/files/upload", headsSend, stream, fileName); return(ResponseUtil <string> .SuccessResult(filePath.ToString())); } catch (Exception ex) { return(ResponseUtil <string> .FailResult(null, ex.ToString())); } }