public void GetTotalSeconds() { var a = ConvertDate.TotalSeconds(DateTime.Today); var b2 = (decimal)32344729; var c2 = ConvertDate.DecimalToDate(b2); //IAuthContainerModel model = new JWTContainerModel() //{ // Claims = new Claim[] // { // new Claim(ClaimTypes.Name, "abc"), // new Claim("ID", "93"), // } //}; //IAuthService authService = new JWTService(); //var token = authService.GenerateToken(model); //var b = authService.IsTokenValid("eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ1bmlxdWVfbmFtZSI6IjAyOTQyMzkzIiwiSUQiOiI5MyIsIm5iZiI6MTU4OTc3MDg5OSwiZXhwIjoxNTkwMzc1Njk5LCJpYXQiOjE1ODk3NzA4OTl9.uQ4mIkacmm2JAGnZWSUGtf8iI352q6dyagrxu8dOMZI"); //var c = authService.GetTokenClaims(token); //var id = c.Where(m => m.Type == "ID").FirstOrDefault().Value; }
public virtual void ExportProductsExcel(string filePath, List <StorageWarehousingItem> lstStorageProduct) { var newFile = new FileInfo(filePath); // ok, we can run the real code of the sample now int dem = 0; using (var xlPackage = new ExcelPackage(newFile)) { // uncomment this line if you want the XML written out to the outputDir //xlPackage.DebugMode = true; // get handle to the existing worksheet var worksheet = xlPackage.Workbook.Worksheets.Add("Phiếu nhập kho"); xlPackage.Workbook.CalcMode = ExcelCalcMode.Manual; //Create Headers and format them var properties = new string[] { "STT", "Mã phiếu", "Ngày nhập", "Tổng tiền", "Ghi chú" }; for (var i = 0; i < properties.Length; i++) { worksheet.Cells[1, i + 1].Value = properties[i]; worksheet.Cells[1, i + 1].Style.Fill.PatternType = ExcelFillStyle.Solid; worksheet.Cells[1, i + 1].Style.Fill.BackgroundColor.SetColor(Color.FromArgb(184, 204, 228)); worksheet.Cells[1, i + 1].Style.Font.Bold = true; } var row = 2; foreach (var item in lstStorageProduct) { dem++; int col = 1; worksheet.Cells[row, col].Value = dem; col++; worksheet.Cells[row, col].Value = item.Code; col++; // email worksheet.Cells[row, col].Value = ConvertDate.DecimalToDate(item.DateCreated).ToString("dd/MM/yyyy"); col++; // điện thoại worksheet.Cells[row, col].Value = item.TotalPrice.Money(); col++; // địa chỉ worksheet.Cells[row, col].Value = item.Note; row++; } // we had better add some document properties to the spreadsheet // set some core property values var nameexcel = "Danh sách nhập kho" + DateTime.Now.ToString("yyyy-MM-ddTHH:mm:ss.fff"); xlPackage.Workbook.Properties.Title = string.Format("{0} reports", nameexcel); xlPackage.Workbook.Properties.Author = "FDI-IT"; xlPackage.Workbook.Properties.Subject = string.Format("{0} reports", ""); //xlPackage.Workbook.Properties.Keywords = string.Format("{0} orders", _storeInformationSettings.StoreName); xlPackage.Workbook.Properties.Category = "Report"; //xlPackage.Workbook.Properties.Comments = string.Format("{0} orders", _storeInformationSettings.StoreName); // set some extended property values xlPackage.Workbook.Properties.Company = "FDI "; //xlPackage.Workbook.Properties.HyperlinkBase = new Uri(_storeInformationSettings.StoreUrl); // save the new spreadsheet xlPackage.Save(); } }