private PdfPTable ProductsTable()
{
PdfPTable table = FormatConfig.Table(9, new float[] { 0.5f, 1.3f, 2.5f, 0.7f, 1f, 1f, 1f, 1f, 1f });
table.AddCell(FormatConfig.TableCellHeader("STT"));
table.AddCell(FormatConfig.TableCellHeader("Mã SP"));
table.AddCell(FormatConfig.TableCellHeader("Tên và qui cách"));
table.AddCell(FormatConfig.TableCellHeader("Jampo"));
table.AddCell(FormatConfig.TableCellHeader("ĐVT"));
table.AddCell(FormatConfig.TableCellHeader("Đầu kì"));
table.AddCell(FormatConfig.TableCellHeader("Nhập"));
table.AddCell(FormatConfig.TableCellHeader("Xuất"));
table.AddCell(FormatConfig.TableCellHeader("Cuối kì"));
foreach (ProductsReport item in productsReports)
{
if (string.IsNullOrEmpty(item.Index))
{
table.AddCell(FormatConfig.TableCellBoldBody(item.ProductName, PdfPCell.ALIGN_LEFT, 9));
}
else
{
table.AddCell(FormatConfig.TableCellBody(item.Index, PdfPCell.ALIGN_CENTER));
table.AddCell(FormatConfig.TableCellBody(item.ProductCode, PdfPCell.ALIGN_CENTER));
table.AddCell(FormatConfig.TableCellBody(item.ProductName, PdfPCell.ALIGN_CENTER));
table.AddCell(FormatConfig.TableCellBody(item.Jampo, PdfPCell.ALIGN_CENTER));
table.AddCell(FormatConfig.TableCellBody(item.UnitName, PdfPCell.ALIGN_CENTER));
table.AddCell(FormatConfig.TableCellBody(item.FirstNumber, PdfPCell.ALIGN_RIGHT));
table.AddCell(FormatConfig.TableCellBody(item.ImportNumber, PdfPCell.ALIGN_RIGHT));
table.AddCell(FormatConfig.TableCellBody(item.ExportNumber, PdfPCell.ALIGN_RIGHT));
table.AddCell(FormatConfig.TableCellBody(item.LastNumber, PdfPCell.ALIGN_RIGHT));
}
}
return(table);
}
private PdfPTable CustomerDetailTable()
{
PdfPTable table = FormatConfig.Table(7, new float[] { 0.5f, 1.5f, 2f, 2f, 1.2f, 1.3f, 1.5f });
table.AddCell(FormatConfig.TableCellHeader("STT"));
table.AddCell(FormatConfig.TableCellHeader("Ngày"));
table.AddCell(FormatConfig.TableCellHeader("Mặt hàng"));
table.AddCell(FormatConfig.TableCellHeader("Quy cách"));
table.AddCell(FormatConfig.TableCellHeader("Số lượng"));
table.AddCell(FormatConfig.TableCellHeader("ĐVT"));
table.AddCell(FormatConfig.TableCellHeader("Tổng giá"));
foreach (CustomerReport item in customerReports)
{
if (string.IsNullOrEmpty(item.Index))
{
table.AddCell(FormatConfig.TableCellBoldBody(item.Date, PdfPCell.ALIGN_LEFT, 7));
}
else
{
table.AddCell(FormatConfig.TableCellBody(item.Index, PdfPCell.ALIGN_CENTER));
table.AddCell(FormatConfig.TableCellBody(item.Date, PdfPCell.ALIGN_CENTER));
table.AddCell(FormatConfig.TableCellBody(item.ProductName, PdfPCell.ALIGN_CENTER));
table.AddCell(FormatConfig.TableCellBody(item.AttrName, PdfPCell.ALIGN_CENTER));
table.AddCell(FormatConfig.TableCellBody(item.Number, PdfPCell.ALIGN_RIGHT));
table.AddCell(FormatConfig.TableCellBody(item.Unit, PdfPCell.ALIGN_CENTER));
table.AddCell(FormatConfig.TableCellBody(item.Cost, PdfPCell.ALIGN_RIGHT));
}
}
table.AddCell(FormatConfig.TableCellBoldBody("Tổng", PdfPCell.ALIGN_RIGHT, 6));
table.AddCell(FormatConfig.TableCellBody(lbTotal.Text.Split(' ')[2], PdfPCell.ALIGN_RIGHT));
return(table);
}
public Formatter(FormatConfig config)
{
mFormatConfig = config;
if (mFormatConfig.mEndOfLineCommentDelimiter == null)
{
mFormatConfig.mEndOfLineCommentDelimiter = string.Empty;
}
if (mFormatConfig.mFullLineCommentDelimiterBase == null)
{
mFormatConfig.mFullLineCommentDelimiterBase = string.Empty;
}
if (mFormatConfig.mBoxLineCommentDelimiter == null)
{
mFormatConfig.mBoxLineCommentDelimiter = string.Empty;
}
if (mFormatConfig.mAddSpaceLongComment)
{
mFullLineCommentDelimiterPlus = mFormatConfig.mFullLineCommentDelimiterBase + " ";
}
else
{
mFullLineCommentDelimiterPlus = mFormatConfig.mFullLineCommentDelimiterBase;
}
Reset();
// Prep the static parts of the hex dump buffer.
mHexDumpBuffer = new char[73];
for (int i = 0; i < mHexDumpBuffer.Length; i++)
{
mHexDumpBuffer[i] = ' ';
}
mHexDumpBuffer[6] = ':';
}
private void ExportFile()
{
Global.checkDirSaveFile();
var doc = new Document(PageSize.A4, 20, 20, 10, 10);
PdfWriter docWriter = PdfWriter.GetInstance(doc, new FileStream(BHConstant.SAVE_IN_DIRECTORY + @"\Kho.pdf", FileMode.Create));
PdfWriterEvents writerEvent;
Image watermarkImage = Image.GetInstance(AppDomain.CurrentDomain.BaseDirectory + @"logo.png");
watermarkImage.SetAbsolutePosition(doc.PageSize.Width / 2 - 70, 600);
writerEvent = new PdfWriterEvents(watermarkImage);
docWriter.PageEvent = writerEvent;
doc.Open();
doc.Add(FormatConfig.ParaRightBeforeHeader("In ngày : " + BaoHienRepository.GetBaoHienDBDataContext().GetSystemDate().ToString(BHConstant.DATETIME_FORMAT)));
doc.Add(FormatConfig.ParaHeader("BÁO CÁO KHO VÀ THÀNH PHẨM"));
doc.Add(FormatConfig.ParaRightBelowHeader("(" + textForPrint + ")"));
if (modeReport != 1)
{
doc.Add(ProductsTable());
}
else
{
doc.Add(FormatConfig.ParaCommonInfo("Sản phẩm : ", textInfo));
doc.Add(ProductDetailTable());
}
doc.Add(FormatConfig.ParaCommonInfo("Ghi chú : ", String.Concat(Enumerable.Repeat("...", 96))));
doc.Close();
}
protected void Application_Start()
{
AreaRegistration.RegisterAllAreas();
WebApiConfig.Register(GlobalConfiguration.Configuration);
FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters);
RouteConfig.RegisterRoutes(RouteTable.Routes);
BundleConfig.RegisterBundles(BundleTable.Bundles);
FormatConfig.RegisterFormats(GlobalConfiguration.Configuration.Formatters);
}
/// <summary>
/// The application start method.
/// </summary>
protected void Application_Start()
{
AreaRegistration.RegisterAllAreas();
FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters);
RouteConfig.RegisterRoutes(RouteTable.Routes);
TraceConfig.RegisterListener(GlobalConfiguration.Configuration);
FormatConfig.ConfigureFormats(GlobalConfiguration.Configuration);
DependencyConfig.ResolveDependencies(GlobalConfiguration.Configuration);
DocumentationConfig.Configure(GlobalConfiguration.Configuration);
// Ensure that your Web API is only accessed via HTTPS
// GlobalConfiguration.Configuration.Filters.Add(new MyEvents.Api.Authentication.OnlyHttpsAttribute());
}
public static void Register(HttpConfiguration config)
{
// Web API configuration and services
var cors = new EnableCorsAttribute("*", "*", "*");
config.EnableCors(cors);
// Web API routes
config.MapHttpAttributeRoutes();
FormatConfig.Formatters(config);
config.Routes.MapHttpRoute(
name: "DefaultApi",
routeTemplate: "api/{controller}/{id}",
defaults: new { id = RouteParameter.Optional }
);
}
private void ExportFile()
{
Global.checkDirSaveFile();
var doc = new Document(PageSize.A4, 20, 20, 10, 10);
PdfWriter docWriter = PdfWriter.GetInstance(doc, new FileStream(BHConstant.SAVE_IN_DIRECTORY + @"\KHang.pdf", FileMode.Create));
PdfWriterEvents writerEvent;
Image watermarkImage = Image.GetInstance(AppDomain.CurrentDomain.BaseDirectory + @"logo.png");
watermarkImage.SetAbsolutePosition(doc.PageSize.Width / 2 - 70, 550);
writerEvent = new PdfWriterEvents(watermarkImage);
docWriter.PageEvent = writerEvent;
doc.Open();
doc.Add(FormatConfig.ParaRightBeforeHeader("In ngày : " + BaoHienRepository.GetBaoHienDBDataContext().GetSystemDate().ToString(BHConstant.DATETIME_FORMAT)));
doc.Add(FormatConfig.ParaHeader("DANH SÁCH KHÁCH HÀNG"));
PdfPTable table = FormatConfig.Table(7, new float[] { 0.5f, 2f, 1.3f, 1.3f, 2f, 1.6f, 1.3f });
table.AddCell(FormatConfig.TableCellHeader("STT"));
table.AddCell(FormatConfig.TableCellHeader("Tên khách hàng"));
table.AddCell(FormatConfig.TableCellHeader("Mã KH"));
table.AddCell(FormatConfig.TableCellHeader("SĐT Cty"));
table.AddCell(FormatConfig.TableCellHeader("Địa chỉ"));
table.AddCell(FormatConfig.TableCellHeader("Người liên lạc"));
table.AddCell(FormatConfig.TableCellHeader("SĐT"));
for (int i = 0; i < customers.Count; i++)
{
table.AddCell(FormatConfig.TableCellBody((i + 1).ToString(), PdfPCell.ALIGN_CENTER));
table.AddCell(FormatConfig.TableCellBody(customers[i].CustomerName, PdfPCell.ALIGN_LEFT));
table.AddCell(FormatConfig.TableCellBody(customers[i].CustCode, PdfPCell.ALIGN_LEFT));
table.AddCell(FormatConfig.TableCellBody(customers[i].Phone, PdfPCell.ALIGN_LEFT));
table.AddCell(FormatConfig.TableCellBody(customers[i].Address, PdfPCell.ALIGN_LEFT));
table.AddCell(FormatConfig.TableCellBody(customers[i].ContactPerson, PdfPCell.ALIGN_LEFT));
table.AddCell(FormatConfig.TableCellBody(customers[i].ContactPersonPhone, PdfPCell.ALIGN_LEFT));
}
doc.Add(table);
doc.Add(FormatConfig.ParaCommonInfo("Ghi chú : ", String.Concat(Enumerable.Repeat("...", 96))));
doc.Close();
}
private void ExportFile()
{
Global.checkDirSaveFile();
var doc = new Document(PageSize.A4, 20, 20, 10, 10);
PdfWriter docWriter = PdfWriter.GetInstance(doc, new FileStream(BHConstant.SAVE_IN_DIRECTORY + @"\CongNo.pdf", FileMode.Create));
PdfWriterEvents writerEvent;
Image watermarkImage = Image.GetInstance(AppDomain.CurrentDomain.BaseDirectory + @"logo.png");
watermarkImage.SetAbsolutePosition(doc.PageSize.Width / 2 - 70, 500);
writerEvent = new PdfWriterEvents(watermarkImage);
docWriter.PageEvent = writerEvent;
doc.Open();
if (modeReport == 1)
{
doc.Add(FormatConfig.ParaRightBeforeHeaderRight(BHConstant.COMPANY_NAME));
doc.Add(FormatConfig.ParaRightBeforeHeaderRight(BHConstant.COMPANY_ADDRESS));
doc.Add(FormatConfig.ParaRightBeforeHeaderRight("ĐT: " + BHConstant.COMPANY_PHONE + " Fax: " + BHConstant.COMPANY_FAX));
}
doc.Add(FormatConfig.ParaRightBeforeHeader("In ngày : " + BaoHienRepository.GetBaoHienDBDataContext().GetSystemDate().ToString(BHConstant.DATETIME_FORMAT)));
doc.Add(FormatConfig.ParaHeader("BÁO CÁO CÔNG NỢ"));
doc.Add(FormatConfig.ParaRightBelowHeader("(" + textForPrint + ")"));
if (modeReport != 1)
{
doc.Add(CustomersTable());
}
else
{
doc.Add(FormatConfig.ParaCommonInfo("Kính gửi : ", customerPrint.CustomerName));
doc.Add(FormatConfig.ParaCommonInfo("Địa chỉ : ", customerPrint.Address));
doc.Add(FormatConfig.ParaCommonInfo("ĐT : ", customerPrint.Phone + " Fax: " + customerPrint.Fax));
doc.Add(CustomerDetailTable());
}
doc.Add(FormatConfig.ParaCommonInfo("", "Quý khách hàng kiểm tra và đối chiếu, nếu có thắc mắc vui lòng liên hệ số điện thoại trên."));
doc.Add(FormatConfig.ParaCommonInfo("", "Chân thành cảm ơn sự hợp tác của quí khách."));
doc.Add(FormatConfig.ParaCommonInfo("Ghi chú : ", String.Concat(Enumerable.Repeat("...", 96))));
doc.Close();
}
private PdfPTable ProductDetailTable()
{
PdfPTable table = FormatConfig.Table(4, new float[] { 1f, 2.5f, 3.5f, 3f });
table.AddCell(FormatConfig.TableCellHeader("STT"));
table.AddCell(FormatConfig.TableCellHeader("Ngày"));
table.AddCell(FormatConfig.TableCellHeader("Mã phiếu"));
table.AddCell(FormatConfig.TableCellHeader("Số lượng"));
int index = 0;
foreach (ProductReport item in productReports)
{
table.AddCell(FormatConfig.TableCellBody((++index).ToString(), PdfPCell.ALIGN_CENTER));
table.AddCell(FormatConfig.TableCellBody(item.UpdatedDateString, PdfPCell.ALIGN_CENTER));
table.AddCell(FormatConfig.TableCellBody(item.RecordCode, PdfPCell.ALIGN_CENTER));
table.AddCell(FormatConfig.TableCellBody(item.Amount, PdfPCell.ALIGN_RIGHT));
}
return(table);
}
private PdfPTable EmployeesTable()
{
PdfPTable table = FormatConfig.Table(5, new float[] { 1f, 2f, 2.5f, 2.5f, 2f });
table.AddCell(FormatConfig.TableCellHeader("STT"));
table.AddCell(FormatConfig.TableCellHeader("Ngày"));
table.AddCell(FormatConfig.TableCellHeader("Nhân viên"));
table.AddCell(FormatConfig.TableCellHeader("Mã phiếu"));
table.AddCell(FormatConfig.TableCellHeader("Số tiền"));
foreach (EmployeesReport item in employees_reports)
{
table.AddCell(FormatConfig.TableCellBody(item.Index.ToString(), PdfPCell.ALIGN_CENTER));
table.AddCell(FormatConfig.TableCellBody(item.CreatedDate, PdfPCell.ALIGN_CENTER));
table.AddCell(FormatConfig.TableCellBody(item.EmployeeName, PdfPCell.ALIGN_CENTER));
table.AddCell(FormatConfig.TableCellBody(item.RecordCode, PdfPCell.ALIGN_CENTER));
table.AddCell(FormatConfig.TableCellBody(item.Amount, PdfPCell.ALIGN_RIGHT));
}
return(table);
}
private PdfPTable CustomersTable()
{
PdfPTable table = FormatConfig.Table(6, new float[] { 0.5f, 1.5f, 2.5f, 2.5f, 2f, 1f });
table.AddCell(FormatConfig.TableCellHeader("STT"));
table.AddCell(FormatConfig.TableCellHeader("Ngày"));
table.AddCell(FormatConfig.TableCellHeader("Tên khách hàng"));
table.AddCell(FormatConfig.TableCellHeader("Mã khách hàng"));
table.AddCell(FormatConfig.TableCellHeader("Mã phiếu"));
table.AddCell(FormatConfig.TableCellHeader("Số tiền"));
foreach (CustomersReport item in customersReports)
{
table.AddCell(FormatConfig.TableCellBody(item.Index.ToString(), PdfPCell.ALIGN_CENTER));
table.AddCell(FormatConfig.TableCellBody(item.Date, PdfPCell.ALIGN_CENTER));
table.AddCell(FormatConfig.TableCellBody(item.CustomerName, PdfPCell.ALIGN_CENTER));
table.AddCell(FormatConfig.TableCellBody(item.CustomerCode, PdfPCell.ALIGN_CENTER));
table.AddCell(FormatConfig.TableCellBody(item.RecordCode, PdfPCell.ALIGN_CENTER));
table.AddCell(FormatConfig.TableCellBody(item.Amount, PdfPCell.ALIGN_RIGHT));
}
table.AddCell(FormatConfig.TableCellBoldBody("Tổng", PdfPCell.ALIGN_RIGHT, 5));
table.AddCell(FormatConfig.TableCellBody(lbTotal.Text.Split(' ')[2], PdfPCell.ALIGN_RIGHT));
return(table);
}
private PdfPTable EmployeeDetailTable()
{
PdfPTable table = FormatConfig.Table(9, new float[] { 0.5f, 1.3f, 1.5f, 1.3f, 1.4f, 1f, 1f, 1f, 1f });
table.AddCell(FormatConfig.TableCellHeader("STT"));
table.AddCell(FormatConfig.TableCellHeader("Ngày"));
table.AddCell(FormatConfig.TableCellHeader("Tên khách hàng"));
table.AddCell(FormatConfig.TableCellHeader("Mặt hàng"));
table.AddCell(FormatConfig.TableCellHeader("Quy cách"));
table.AddCell(FormatConfig.TableCellHeader("Số lượng"));
table.AddCell(FormatConfig.TableCellHeader("ĐVT"));
table.AddCell(FormatConfig.TableCellHeader("Đơn giá"));
table.AddCell(FormatConfig.TableCellHeader("Hoa hồng"));
foreach (EmployeeReport item in employee_reports)
{
if (string.IsNullOrEmpty(item.Index))
{
table.AddCell(FormatConfig.TableCellBoldBody(item.CustomerName, PdfPCell.ALIGN_LEFT, 9));
}
else
{
table.AddCell(FormatConfig.TableCellBody(item.Index, PdfPCell.ALIGN_CENTER));
table.AddCell(FormatConfig.TableCellBody(item.Date, PdfPCell.ALIGN_CENTER));
table.AddCell(FormatConfig.TableCellBody(item.CustomerName, PdfPCell.ALIGN_CENTER));
table.AddCell(FormatConfig.TableCellBody(item.ProductName, PdfPCell.ALIGN_CENTER));
table.AddCell(FormatConfig.TableCellBody(item.AttrName, PdfPCell.ALIGN_CENTER));
table.AddCell(FormatConfig.TableCellBody(item.Number, PdfPCell.ALIGN_RIGHT));
table.AddCell(FormatConfig.TableCellBody(item.Unit, PdfPCell.ALIGN_CENTER));
table.AddCell(FormatConfig.TableCellBody(item.Price, PdfPCell.ALIGN_RIGHT));
table.AddCell(FormatConfig.TableCellBody(item.Commission, PdfPCell.ALIGN_RIGHT));
}
}
return(table);
}
/// <summary>
/// Constructor. Initializes various fields based on the configuration. We want to
/// do as much work as possible here.
/// </summary>
public Formatter(FormatConfig config)
{
mFormatConfig = config; // copy struct
if (mFormatConfig.mEndOfLineCommentDelimiter == null)
{
mFormatConfig.mEndOfLineCommentDelimiter = string.Empty;
}
if (mFormatConfig.mFullLineCommentDelimiterBase == null)
{
mFormatConfig.mFullLineCommentDelimiterBase = string.Empty;
}
if (mFormatConfig.mBoxLineCommentDelimiter == null)
{
mFormatConfig.mBoxLineCommentDelimiter = string.Empty;
}
if (string.IsNullOrEmpty(mFormatConfig.mNonUniqueLabelPrefix))
{
mFormatConfig.mNonUniqueLabelPrefix = "@";
}
if (mFormatConfig.mAddSpaceLongComment)
{
mFullLineCommentDelimiterPlus = mFormatConfig.mFullLineCommentDelimiterBase + " ";
}
else
{
mFullLineCommentDelimiterPlus = mFormatConfig.mFullLineCommentDelimiterBase;
}
// Prep the static parts of the hex dump buffer.
mHexDumpBuffer = new char[73];
for (int i = 0; i < mHexDumpBuffer.Length; i++)
{
mHexDumpBuffer[i] = ' ';
}
mHexDumpBuffer[6] = ':';
// Resolve boolean flags to character or string values.
if (mFormatConfig.mUpperHexDigits)
{
mHexFmtChar = 'X';
}
else
{
mHexFmtChar = 'x';
}
if (mFormatConfig.mSuppressHexNotation)
{
mHexPrefix = "";
}
else
{
mHexPrefix = "$";
}
if (mFormatConfig.mSuppressImpliedAcc)
{
mAccChar = "";
}
else if (mFormatConfig.mUpperOperandA)
{
mAccChar = "A";
}
else
{
mAccChar = "a";
}
if (mFormatConfig.mUpperOperandXY)
{
mXregChar = 'X';
mYregChar = 'Y';
}
else
{
mXregChar = 'x';
mYregChar = 'y';
}
if (mFormatConfig.mUpperOperandS)
{
mSregChar = 'S';
}
else
{
mSregChar = 's';
}
// process the delimiter patterns
DelimiterSet chrDelim = mFormatConfig.mCharDelimiters;
if (chrDelim == null)
{
Debug.WriteLine("NOTE: char delimiters not set");
chrDelim = DelimiterSet.GetDefaultCharDelimiters();
}
switch (mFormatConfig.mHexDumpCharConvMode)
{
case FormatConfig.CharConvMode.Ascii:
mHexDumpCharConv = CharEncoding.ConvertAscii;
break;
case FormatConfig.CharConvMode.LowHighAscii:
mHexDumpCharConv = CharEncoding.ConvertLowAndHighAscii;
break;
case FormatConfig.CharConvMode.C64Petscii:
mHexDumpCharConv = CharEncoding.ConvertC64Petscii;
break;
case FormatConfig.CharConvMode.C64ScreenCode:
mHexDumpCharConv = CharEncoding.ConvertC64ScreenCode;
break;
default:
// most some things don't configure the hex dump; this is fine
mHexDumpCharConv = CharEncoding.ConvertLowAndHighAscii;
break;
}
}
private static string FormatDouble(string formatCode, double dv, out string color)
{
color = null;
var trimmed = formatCode.Trim();
if (trimmed.StartsWith("[") &&
trimmed.Contains("]"))
{
var colorLen = trimmed.IndexOf(']');
color = trimmed.Substring(1, colorLen - 1);
if (ValidColors.Contains(color) ||
color.StartsWith("Color"))
{
if (color.StartsWith("Color"))
{
var idxStr = color.Substring(5);
int colorIdx;
if (int.TryParse(idxStr, out colorIdx))
{
if (colorIdx < SmlDataRetriever.IndexedColors.Length)
{
color = SmlDataRetriever.IndexedColors[colorIdx];
}
else
{
color = null;
}
}
}
formatCode = trimmed.Substring(colorLen + 1);
}
else
{
color = null;
}
}
if (formatCode == "General")
{
return(dv.ToString(CultureInfo.InvariantCulture));
}
bool isDate = IsFormatCodeForDate(formatCode);
var cfc = ConvertFormatCode(formatCode);
if (isDate)
{
DateTime thisDate;
try
{
thisDate = DateTime.FromOADate(dv);
}
catch (ArgumentException)
{
return(dv.ToString(CultureInfo.InvariantCulture));
}
if (cfc.StartsWith("[h]"))
{
DateTime zeroHour = new DateTime(1899, 12, 30, 0, 0, 0);
int deltaInHours = (int)((thisDate - zeroHour).TotalHours);
var newCfc = cfc.Substring(3);
var s = (deltaInHours.ToString() + thisDate.ToString(newCfc)).Trim();
return(s);
}
if (cfc.EndsWith(".0"))
{
var cfc2 = cfc.Replace(".0", ":fff");
var s4 = thisDate.ToString(cfc2).Trim();
return(s4);
}
var s2 = thisDate.ToString(cfc, CultureInfo.InvariantCulture).Trim();
return(s2);
}
if (ExcelFormatCodeToNetFormatCodeExceptionMap.ContainsKey(formatCode))
{
FormatConfig fc = ExcelFormatCodeToNetFormatCodeExceptionMap[formatCode];
var s = dv.ToString(fc.FormatCode, CultureInfo.InvariantCulture).Trim();
return(s);
}
if ((cfc.Contains('(') && cfc.Contains(')')) || cfc.Contains('-'))
{
var s3 = (-dv).ToString(cfc, CultureInfo.InvariantCulture).Trim();
return(s3);
}
else
{
var s4 = dv.ToString(cfc, CultureInfo.InvariantCulture).Trim();
return(s4);
}
}
