static void FormatCell(IWorkbook workbook)
{
#region #CellFormatting
Worksheet firstSheet = workbook.Worksheets[0];
firstSheet.Cells["B2"].Value = "Test";
Cell cell = firstSheet.Cells["B2"];
cell.Font.Name = "MV Boli";
cell.Font.Color = Color.Blue;
cell.Font.Size = 14;
cell.Font.FontStyle = DevExpress.Spreadsheet.SpreadsheetFontStyle.Bold;
cell.Fill.BackgroundColor = Color.LightSkyBlue;
cell.Alignment.Vertical = SpreadsheetVerticalAlignment.Center;
cell.Alignment.Horizontal = DevExpress.Spreadsheet.SpreadsheetHorizontalAlignment.Center;
#endregion #CellFormatting
#region #RangeFormatting
Worksheet worksheet = workbook.Worksheets[0];
worksheet.Range["C3:E6"].Value = "Test";
Range rangeC3E6 = worksheet.Range["C3:E6"];
Formatting rangeC3E6Formatting = rangeC3E6.BeginUpdateFormatting();
rangeC3E6Formatting.Font.Name = "MV Boli";
rangeC3E6Formatting.Font.Color = Color.Blue;
rangeC3E6Formatting.Font.Size = 14;
rangeC3E6Formatting.Font.FontStyle = DevExpress.Spreadsheet.SpreadsheetFontStyle.Bold;
rangeC3E6Formatting.Fill.BackgroundColor = Color.LightSkyBlue;
rangeC3E6Formatting.Alignment.Vertical = SpreadsheetVerticalAlignment.Center;
rangeC3E6Formatting.Alignment.Horizontal = DevExpress.Spreadsheet.SpreadsheetHorizontalAlignment.Center;
rangeC3E6.EndUpdateFormatting(rangeC3E6Formatting);
#endregion #RangeFormatting
}
static void AddCellBorders(IWorkbook workbook)
{
#region #CellRangeBorders
Worksheet firstSheet = workbook.Worksheets[0];
Range rangeB8F13 = firstSheet.Range["B8:F13"];
rangeB8F13.Borders.SetAllBorders(Color.Green, BorderLineStyle.Double);
Range rangeC15F18 = firstSheet.Range["C15:F18"];
rangeC15F18.SetInsideBorders(Color.SkyBlue, BorderLineStyle.MediumDashed);
rangeC15F18.Borders.SetOutsideBorders(Color.DeepSkyBlue, BorderLineStyle.Medium);
Range rangeD21F23 = firstSheet.Range["B2:D4"];
Formatting rangeD21F23Formatting = rangeD21F23.BeginUpdateFormatting();
Borders rangeD21F23Borders = rangeD21F23Formatting.Borders;
rangeD21F23Borders.InsideHorizontalBorders.LineStyle = BorderLineStyle.MediumDashDot;
rangeD21F23Borders.InsideHorizontalBorders.Color = Color.DarkBlue;
rangeD21F23Borders.InsideVerticalBorders.LineStyle = BorderLineStyle.MediumDashDotDot;
rangeD21F23Borders.InsideVerticalBorders.Color = Color.Blue;
rangeD21F23.EndUpdateFormatting(rangeD21F23Formatting);
Range rangeE25F26 = firstSheet.Range["E2:F6"];
Formatting rangeE25F26Formatting = rangeE25F26.BeginUpdateFormatting();
Borders rangeE25F26Borders = rangeE25F26Formatting.Borders;
rangeE25F26Borders.SetOutsideBorders(Color.Black, BorderLineStyle.Thick);
rangeE25F26Borders.LeftBorder.Color = Color.Violet;
rangeE25F26Borders.TopBorder.Color = Color.Violet;
rangeE25F26Borders.RightBorder.Color = Color.DarkViolet;
rangeE25F26Borders.BottomBorder.Color = Color.DarkViolet;
rangeE25F26Borders.DiagonalBorderType = DiagonalBorderType.UpAndDown;
rangeE25F26Borders.DiagonalBorderLineStyle = BorderLineStyle.MediumDashed;
rangeE25F26Borders.DiagonalBorderColor = Color.BlueViolet;
rangeE25F26.EndUpdateFormatting(rangeE25F26Formatting);
#endregion #CellRangeBorders
}
private void simpleActionRprtCntbl_Execute(object sender, DevExpress.ExpressApp.Actions.SimpleActionExecuteEventArgs e)
{
if (View != null)
{
int i = 5;
Empresa emp = View.ObjectSpace.FindObject <Empresa>(null);
// Servicios Profesionales
Workbook book = new Workbook();
var sheet = book.Worksheets.ActiveWorksheet;
sheet.Cells[0, 0].Value = emp.Compania.Nombre;
sheet.Cells[0, 3].Value = emp.Compania.Rfc;
sheet.Cells[1, 0].Value =
(emp.Regimenes != null && emp.Regimenes.Count > 0)
? (emp.Regimenes[0] as RegimenEmpresa).Rgmn.Dscrpcn
: string.Empty;
// emp.Regimen; TIT Sep 2018
int ano = DateTime.Today.Month == 1 ? DateTime.Today.Year - 1 : DateTime.Today.Year;
sheet.Cells["A4"].Value = string.Format("Ejercicio {0}.", ano);
sheet.Cells[i++, 0].Value = "ENERO";
sheet.Cells[i++, 0].Value = "FEBRERO";
sheet.Cells[i++, 0].Value = "Acumulado";
sheet.Cells[i++, 0].Value = "MARZO";
sheet.Cells[i++, 0].Value = "Acumulado";
sheet.Cells[i++, 0].Value = "ABRIL";
sheet.Cells[i++, 0].Value = "Acumulado";
sheet.Cells[i++, 0].Value = "MAYO";
sheet.Cells[i++, 0].Value = "Acumulado";
sheet.Cells[i++, 0].Value = "JUNIO";
sheet.Cells[i++, 0].Value = "Acumulado";
sheet.Cells[i++, 0].Value = "JULIO";
sheet.Cells[i++, 0].Value = "Acumulado";
sheet.Cells[i++, 0].Value = "AGOSTO";
sheet.Cells[i++, 0].Value = "Acumulado";
sheet.Cells[i++, 0].Value = "SEPTIEMBRE";
sheet.Cells[i++, 0].Value = "Acumulado";
sheet.Cells[i++, 0].Value = "OCTUBRE";
sheet.Cells[i++, 0].Value = "Acumulado";
sheet.Cells[i++, 0].Value = "NOVIEMBRE";
sheet.Cells[i++, 0].Value = "Acumulado";
sheet.Cells[i++, 0].Value = "DICIEMBRE";
sheet.Cells[i++, 0].Value = "Tota Acumulado";
sheet.Cells["c3"].Value = "ISR";
sheet.Cells["c3"].Font.FontStyle = SpreadsheetFontStyle.Bold;
// Access the range of cells to be formatted.
CellRange range = sheet.Range["C4:G4"];
// Begin updating of the range formatting.
DevExpress.Spreadsheet.Formatting rangeFormatting = range.BeginUpdateFormatting();
// Specify font settings (font name, color, size and style).
rangeFormatting.Font.Name = "Arial";
// rangeFormatting.Font.Color = Color.Blue;
rangeFormatting.Font.Size = 8;
// rangeFormatting.Font.FontStyle = SpreadsheetFontStyle.Bold;
// Specify cell background color.
rangeFormatting.Fill.BackgroundColor = Color.LightGray;
// Specify text alignment in cells.
rangeFormatting.Alignment.Vertical = SpreadsheetVerticalAlignment.Center;
rangeFormatting.Alignment.Horizontal = SpreadsheetHorizontalAlignment.Center;
rangeFormatting.Alignment.WrapText = true;
// End updating of the range formatting.
range.EndUpdateFormatting(rangeFormatting);
range = sheet.Range["G3:K3"];
// Begin updating of the range formatting.
rangeFormatting = range.BeginUpdateFormatting();
// Specify font settings (font name, color, size and style).
rangeFormatting.Font.Name = "Arial";
// rangeFormatting.Font.Color = Color.Blue;
rangeFormatting.Font.Size = 8;
// rangeFormatting.Font.FontStyle = SpreadsheetFontStyle.Bold;
// Specify cell background color.
rangeFormatting.Fill.BackgroundColor = Color.LightGray;
// Specify text alignment in cells.
rangeFormatting.Alignment.Vertical = SpreadsheetVerticalAlignment.Center;
rangeFormatting.Alignment.Horizontal = SpreadsheetHorizontalAlignment.Center;
rangeFormatting.Alignment.WrapText = true;
// End updating of the range formatting.
range.EndUpdateFormatting(rangeFormatting);
sheet.Cells["c4"].Value = string.Format("INGRESOS{0}(Cobrados por sus{0}ventas o servicios){0}Sin incluir IVA",
Environment.NewLine);
/*
* sheet.Cells["c4"].Alignment.Vertical = SpreadsheetVerticalAlignment.Justify;
* sheet.Cells["c4"].Alignment.Horizontal = SpreadsheetHorizontalAlignment.Center;
* sheet.Cells["c4"].Alignment.ShrinkToFit = true;
* sheet.Cells["c4"].Alignment.WrapText = true;*/
sheet.Columns[2].Width = 350;
sheet.Columns[3].Width = 340;
sheet.Columns[4].Width = 340;
sheet.Columns[6].Width = 330;
sheet.Columns[7].Width = 330;
sheet.Columns[8].Width = 330;
sheet.Columns[9].Width = 330;
sheet.Columns[10].Width = 330;
sheet.Cells["d4"].Value = string.Format("DEDUCCIONES{0}(Compras y/o{0}gastos, sin incluir{0}IVA",
Environment.NewLine);
sheet.Cells["e4"].Value = string.Format("INGRESOS ACUMULABLES -{0}DEDUCCIONES ACUMULABLES ={0}BASE",
Environment.NewLine);
sheet.Cells["f4"].Value = "ISR RETENIDO";
sheet.Cells["g3"].Value = "PAGOS (Provisionales)";
sheet.Cells["g4"].Value = "ISR";
sheet.Rows[3].Height = 260;
sheet.Cells["h3"].Value = string.Format("IVA{0}(Causado por{0}sus ventas o{0}servicios)",
Environment.NewLine);
sheet.Cells["i3"].Value = string.Format("IVA{0}(Acreditable por{0}sus compras y/o{0}gastos)",
Environment.NewLine);
sheet.Cells["j3"].Value = string.Format("IVA{0}RETENIDO", Environment.NewLine);
sheet.Cells["k3"].Value = string.Format("IVA PAGADO (+){0}O{0}A FAVOR (-)", Environment.NewLine);
sheet.Cells["l3"].Value = "DIOT";
sheet.Rows[2].Height = 240;
decimal[] total = new decimal[12];
decimal[] reten = new decimal[12];
decimal[] ivaTras = new decimal[12];
decimal[] ivaRet = new decimal[12];
decimal[] ivaAcr = new decimal[12];
decimal[] totAcm = new decimal[12];
decimal[] retAcm = new decimal[12];
decimal[] totalDdc = new decimal[12];
decimal[] totAcmDdc = new decimal[12];
CriteriaOperator[] operands = new CriteriaOperator[2];
i = 5;
operands[1] = new BinaryOperator("Status", DocumentoStatus.Sellada, BinaryOperatorType.Equal);
for (int mesini = 1; mesini < 13; mesini++)
{
DateTime mFechaIni = apl.Log.Fecha.FechaInicial(mesini, ano);
DateTime mFechaFin = apl.Log.Fecha.FechaFinal(mesini, ano);
operands[0] = GroupOperator.And(
new BinaryOperator("FechaDoc", mFechaIni, BinaryOperatorType.GreaterOrEqual),
new BinaryOperator("FechaDoc", mFechaFin, BinaryOperatorType.LessOrEqual));
operands[1] = new BinaryOperator("Status", DocumentoStatus.Sellada, BinaryOperatorType.Equal);
IList arr = ((XPObjectSpace)View.ObjectSpace).CreateCollection(typeof(DocumentoSalida), new GroupOperator(operands), null);
total[mesini - 1] = 0;
totAcm[mesini - 1] = 0;
reten[mesini - 1] = 0;
retAcm[mesini - 1] = 0;
ivaTras[mesini - 1] = 0;
ivaRet[mesini - 1] = 0;
ivaAcr[mesini - 1] = 0;
totalDdc[mesini - 1] = 0;
totAcmDdc[mesini - 1] = 0;
if (arr.Count > 0)
{
foreach (DocumentoSalida doc in arr)
{
total[mesini - 1] += doc.SubTotal;
reten[mesini - 1] += doc.RetenISR;
ivaTras[mesini - 1] += doc.Impuesto04;
ivaRet[mesini - 1] += doc.RetenIVA;
}
}
operands[0] = GroupOperator.And(
new BinaryOperator("FechaDoc", mFechaIni, BinaryOperatorType.GreaterOrEqual),
new BinaryOperator("FechaDoc", mFechaFin, BinaryOperatorType.LessOrEqual));
operands[1] = null;
arr = ((XPObjectSpace)View.ObjectSpace).CreateCollection(typeof(Recepcion), new GroupOperator(operands), null);
if (arr.Count > 0)
{
foreach (Recepcion doc in arr)
{
totalDdc[mesini - 1] += doc.SubTotal;
ivaAcr[mesini - 1] += doc.Impuesto04;
}
}
if ((mesini - 1) > 0)
{
// 1, 2, ...,11 0, 1, ...,10 1, 2, ...,11
totAcm[mesini - 1] += totAcm[mesini - 2] + total[mesini - 1];
retAcm[mesini - 1] += retAcm[mesini - 2] + reten[mesini - 1];
totAcmDdc[mesini - 1] += totAcmDdc[mesini - 2] + totalDdc[mesini - 1];
}
else
{
// 0 0
totAcm[mesini - 1] = total[mesini - 1];
retAcm[mesini - 1] = reten[mesini - 1];
totAcmDdc[mesini - 1] = totalDdc[mesini - 1];
}
if (total[mesini - 1] != 0)
{
sheet.Cells[i, 2].SetValue(total[mesini - 1]);
sheet.Cells[i, 2].NumberFormat = "$#,##0.00;[Red]$#,##0.00";
}
if (totalDdc[mesini - 1] != 0)
{
sheet.Cells[i, 3].SetValue(totalDdc[mesini - 1]);
sheet.Cells[i, 3].NumberFormat = "$#,##0.00;[Red]$#,##0.00";
}
if (reten[mesini - 1] != 0)
{
sheet.Cells[i, 5].SetValue(reten[mesini - 1]);
sheet.Cells[i, 5].NumberFormat = "$#,##0.00;[Red]$#,##0.00";
}
if (ivaTras[mesini - 1] != 0)
{
sheet.Cells[i, 7].SetValue(ivaTras[mesini - 1]);
sheet.Cells[i, 7].NumberFormat = "$#,##0.00;[Red]$#,##0.00";
}
if (ivaAcr[mesini - 1] != 0)
{
sheet.Cells[i, 8].SetValue(ivaAcr[mesini - 1]);
sheet.Cells[i, 8].NumberFormat = "$#,##0.00;[Red]$#,##0.00";
}
if (ivaRet[mesini - 1] != 0)
{
sheet.Cells[i, 9].SetValue(ivaRet[mesini - 1]);
sheet.Cells[i, 9].NumberFormat = "$#,##0.00;[Red]$#,##0.00";
}
sheet.Cells[i, 10].Formula = string.Format("=h{0}-i{0}-j{0}", i + 1);
sheet.Cells[i++, 10].NumberFormat = "$#,##0.00;[Red]$#,##0.00";
if (mesini > 1)
{
sheet.Rows[i].FillColor = Color.FromName("BurlyWood");
//Beige"); // AntiqueWhite"); Bisque BlanchedAlmond
if (totAcm[mesini - 1] != 0)
{
sheet.Cells[i, 2].SetValue(totAcm[mesini - 1]);
sheet.Cells[i, 2].NumberFormat = "$#,##0.00;[Red]$#,##0.00";
}
if (totAcmDdc[mesini - 1] != 0)
{
sheet.Cells[i, 3].SetValue(totAcmDdc[mesini - 1]);
sheet.Cells[i, 3].NumberFormat = "$#,##0.00;[Red]$#,##0.00";
}
sheet.Cells[i, 4].Formula = string.Format("=c{0}-d{0}", i + 1);
sheet.Cells[i, 4].NumberFormat = "$#,##0.00;[Red]$#,##0.00";
if (retAcm[mesini - 1] != 0)
{
sheet.Cells[i, 5].SetValue(retAcm[mesini - 1]);
sheet.Cells[i++, 5].NumberFormat = "$#,##0.00;[Red]$#,##0.00";
}
else
{
i++;
}
}
}
book.SaveDocument(string.Format("Contable.xls"));
}
/*
* Workbook book = new Workbook();
* var sheet = book.Worksheets.ActiveWorksheet;
* sheet.Cells[0, 0].Value = "Carlos Javier Lopez Cruz";
* sheet.Cells[1, 0].Value = "LOCC670416JI8";
* // sheet.Cells[1, 1].Value = "litros67";
* int ano = DateTime.Today.Month == 1 ? DateTime.Today.Year-1 : DateTime.Today.Year;
* // DateTime.Today.Year;
*
* sheet.Cells["A4"].Value = string.Format("Determinación del ISR provisional del Ejercicio {0}.",
* ano);
*
* sheet.Cells[5, 1].Value = "ENERO";
* sheet.Cells[5, 4].Value = "FEBRERO";
* sheet.Cells[5, 7].Value = "MARZO";
* sheet.Cells[5, 10].Value = "ABRIL";
* sheet.Cells[5, 13].Value = "MAYO";
* sheet.Cells[5, 16].Value = "JUNIO";
* sheet.Cells[5, 19].Value = "JULIO";
* sheet.Cells[5, 22].Value = "AGOSTO";
* sheet.Cells[5, 25].Value = "SEPTIEMBRE";
* sheet.Cells[5, 28].Value = "OCTUBRE";
* sheet.Cells[5, 31].Value = "NOVIEMBRE";
* sheet.Cells[5, 34].Value = "DICIEMBRE";
*
*
* XPObjectSpace objectSpace = (XPObjectSpace)View.ObjectSpace;
* Empresa emp = objectSpace.FindObject<Empresa>(null);
*
* CriteriaOperator[] operands = new CriteriaOperator[2];
* decimal[] total = new decimal[12];
* decimal[] totAcm = new decimal[12];
* decimal[] compr = new decimal[12];
* decimal[] reten = new decimal[12];
* decimal[] retAcm = new decimal[12];
* decimal[] ivaTras = new decimal[12];
* decimal[] ivaRet = new decimal[12];
* decimal[] ivaAcr = new decimal[12];
*
* operands[1] = new BinaryOperator("Status", DocumentoStatus.Cancelado, BinaryOperatorType.NotEqual);
*
* sheet.Cells["A1"].Value = emp.Compania.Nombre;
* sheet.Cells["B1"].Value = emp.Compania.Rfc;
*
* for (int mesini = 1; mesini < 13; mesini++)
* {
* DateTime mFechaIni = Fecha.FechaInicial(mesini, ano);
* DateTime mFechaFin = Fecha.FechaFinal(mesini, ano);
*
* operands[0] = GroupOperator.And(new BinaryOperator("FechaDoc", mFechaIni, BinaryOperatorType.GreaterOrEqual),
* new BinaryOperator("FechaDoc", mFechaFin, BinaryOperatorType.LessOrEqual));
*
* IList arr = objectSpace.CreateCollection(typeof(DocumentoSalida), new GroupOperator(operands), null);
*
* total[mesini - 1] = 0;
* totAcm[mesini - 1] = 0;
* reten[mesini - 1] = 0;
* retAcm[mesini - 1] = 0;
* ivaTras[mesini - 1] = 0;
* ivaRet[mesini - 1] = 0;
* ivaAcr[mesini - 1] = 0;
* if (arr.Count > 0)
* {
* foreach (DocumentoSalida doc in arr)
* {
* total[mesini - 1] += doc.SubTotal;
* reten[mesini - 1] += doc.RetenISR;
* ivaTras[mesini - 1] += doc.Impuesto04;
* ivaRet[mesini - 1] += doc.RetenIVA;
* }
*
* if ((mesini - 1) > 0)
* {
* totAcm[mesini - 1] += totAcm[mesini - 2] + total[mesini - 2];
* retAcm[mesini - 1] += retAcm[mesini - 2] + reten[mesini - 2];
* }
* }
* }
*
* sheet.Cells[6, 0].ColumnWidth = 470;
* sheet.Cells["A7"].Value = "Ingresos Acumulados:";
* sheet.Cells[6, 1].Value = 0;
* sheet.Cells[6, 4].Value = total[0].ToString("n2");
* sheet.Cells[6, 7].Value = (total[0] + total[1]).ToString("n2");
* sheet.Cells[6, 10].Value = (total[0] + total[1] + total[2]).ToString("n2");
* sheet.Cells[6, 13].Value = (total[0] + total[1] + total[2]
+ total[3]).ToString("n2");
+ sheet.Cells[6, 16].Value = (total[0] + total[1] + total[2]
+ total[3] + total[4]).ToString("n2");
+ sheet.Cells[6, 19].Value = (total[0] + total[1] + total[2]
+ total[3] + total[4] + total[5]).ToString("n2");
+ sheet.Cells[6, 22].Value = (total[0] + total[1] + total[2]
+ total[3] + total[4] + total[5] + total[6]).ToString("n2");
+ sheet.Cells[6, 25].Value = (total[0] + total[1] + total[2]
+ total[3] + total[4] + total[5] + total[6] + total[7]).ToString("n2");
+ sheet.Cells[6, 28].Value = (total[0] + total[1] + total[2]
+ total[3] + total[4] + total[5] + total[6] + total[7]
+ total[8]).ToString("n2");
+ sheet.Cells[6, 31].Value = (total[0] + total[1] + total[2]
+ total[3] + total[4] + total[5] + total[6] + total[7]
+ total[8] + total[9]).ToString("n2");
+ sheet.Cells[6, 34].Value = (total[0] + total[1] + total[2]
+ total[3] + total[4] + total[5] + total[6] + total[7]
+ total[8] + total[9] + total[10]).ToString("n2");
+
+ sheet.Cells["A8"].Value = "Ingresos:";
+ sheet.Cells[7, 1].Value = total[0].ToString("n2");
+ sheet.Cells[7, 4].Value = total[1].ToString("n2");
+ sheet.Cells[7, 7].Value = total[2].ToString("n2");
+ sheet.Cells[7, 10].Value = total[3].ToString("n2");
+ sheet.Cells[7, 13].Value = total[4].ToString("n2");
+ sheet.Cells[7, 16].Value = total[5].ToString("n2");
+ sheet.Cells[7, 19].Value = total[6].ToString("n2");
+ sheet.Cells[7, 22].Value = total[7].ToString("n2");
+ sheet.Cells[7, 25].Value = total[8].ToString("n2");
+ sheet.Cells[7, 28].Value = total[9].ToString("n2");
+ sheet.Cells[7, 31].Value = total[10].ToString("n2");
+ sheet.Cells[7, 34].Value = total[11].ToString("n2");
+
+ sheet.Cells["A9"].Value = "Total de Ingresos:";
+ sheet.Cells[8, 2].Value = (total[0] + totAcm[0]).ToString("n2");
+ sheet.Cells[8, 5].Value = (total[1] + totAcm[1]).ToString("n2");
+ sheet.Cells[8, 8].Value = (total[2] + totAcm[2]).ToString("n2");
+ sheet.Cells[8, 11].Value = (total[3] + totAcm[3]).ToString("n2");
+ sheet.Cells[8, 14].Value = (total[4] + totAcm[4]).ToString("n2");
+ sheet.Cells[8, 17].Value = (total[5] + totAcm[5]).ToString("n2");
+ sheet.Cells[8, 20].Value = (total[6] + totAcm[6]).ToString("n2");
+ sheet.Cells[8, 23].Value = (total[7] + totAcm[7]).ToString("n2");
+ sheet.Cells[8, 26].Value = (total[8] + totAcm[8]).ToString("n2");
+ sheet.Cells[8, 29].Value = (total[9] + totAcm[9]).ToString("n2");
+ sheet.Cells[8, 32].Value = (total[10] + totAcm[10]).ToString("n2");
+ sheet.Cells[8, 35].Value = (total[11] + totAcm[11]).ToString("n2");
+
+
+
+ decimal[] totalDdc = new decimal[12];
+ decimal[] totAcmDdc = new decimal[12];
+ for (int mesini = 1; mesini < 13; mesini++)
+ {
+ DateTime mFechaIni = Fecha.FechaInicial(mesini, ano);
+ DateTime mFechaFin = Fecha.FechaFinal(mesini, ano);
+
+ operands[0] = GroupOperator.And(new BinaryOperator("FechaDoc", mFechaIni, BinaryOperatorType.GreaterOrEqual),
+ new BinaryOperator("FechaDoc", mFechaFin, BinaryOperatorType.LessOrEqual));
+
+ IList arr = objectSpace.CreateCollection(typeof(Recepcion), new GroupOperator(operands), null);
+
+ totalDdc[mesini - 1] = 0;
+ totAcmDdc[mesini - 1] = 0;
+ ivaAcr[mesini - 1] = 0;
+ if (arr.Count > 0)
+ {
+ foreach (Recepcion doc in arr)
+ {
+ totalDdc[mesini - 1] += doc.SubTotal;
+ ivaAcr[mesini - 1] += doc.Impuesto04;
+ }
+
+ if ((mesini - 1) > 0)
+ totAcmDdc[mesini - 1] += totAcmDdc[mesini - 2] + totalDdc[mesini - 2];
+ }
+ }
+
+ sheet.Cells[9, 0].Value = "Deducciones Acumuladas:";
+ sheet.Cells[9, 1].Value = totAcmDdc[0].ToString("n2");
+ sheet.Cells[9, 4].Value = totAcmDdc[1].ToString("n2");
+ sheet.Cells[9, 7].Value = totAcmDdc[2].ToString("n2");
+ sheet.Cells[9, 10].Value = totAcmDdc[3].ToString("n2");
+ sheet.Cells[9, 13].Value = totAcmDdc[4].ToString("n2");
+ sheet.Cells[9, 16].Value = totAcmDdc[5].ToString("n2");
+ sheet.Cells[9, 19].Value = totAcmDdc[6].ToString("n2");
+ sheet.Cells[9, 22].Value = totAcmDdc[7].ToString("n2");
+ sheet.Cells[9, 25].Value = totAcmDdc[8].ToString("n2");
+ sheet.Cells[9, 28].Value = totAcmDdc[9].ToString("n2");
+ sheet.Cells[9, 31].Value = totAcmDdc[10].ToString("n2");
+ sheet.Cells[9, 34].Value = totAcmDdc[11].ToString("n2");
+
+ int ren = 10;
+ sheet.Cells[ren, 0].Value = "Deducciones:";
+ for (int i = 0; i < 12; i++)
+ sheet.Cells[ren, 1+3*i].Value = totalDdc[i].ToString("n2");
+
+ ren = 11;
+ sheet.Cells[ren, 0].Value = "Total de Deducciones:";
+ for (int i = 0; i < 12; i++)
+ sheet.Cells[ren, 2+3*i].Value = (totalDdc[i] + totAcmDdc[i]).ToString("n2");
+
+ ren++;
+ sheet.Cells[++ren, 0].Value = "Base ISR:";
+ for (int i = 0; i < 12; i++)
+ {
+ sheet[ren, 2+3*i].Value = (total[i] + totAcm[i]- (totalDdc[i] + totAcmDdc[i])) > 0
+ ? (total[i] + totAcm[i] - (totalDdc[i] + totAcmDdc[i])).ToString("n2") : "-";
+ }
+
+ sheet.Cells[++ren, 0].Value = "Límite Inferior:";
+ sheet.Cells[++ren, 0].Value = "Excedente L.I.:";
+ sheet.Cells[++ren, 0].Value = "% Marginal:";
+ sheet.Cells[++ren, 0].Value = "Impuesto Marginal:";
+ sheet.Cells[++ren, 0].Value = "Cuotra fija:";
+ sheet.Cells[++ren, 0].Value = "ISR Causado:";
+
+ ren++;
+ ren++;
+ sheet.Cells[ren, 0].Value = "Retenciones Acumuladas:";
+ for (int i = 0; i < 12; i++)
+ sheet.Cells[ren, 1+3*i].Value = retAcm[i].ToString("n2");
+
+ ren++;
+ sheet.Cells[ren, 0].Value = "Retención ISR:";
+ for (int i = 0; i < 12; i++)
+ sheet.Cells[ren, 1 + 3 * i].Value = reten[i].ToString("n2");
+
+ ren++;
+ sheet.Cells[ren, 0].Value = "Total de Retenciones:";
+ for (int i = 0; i < 12; i++)
+ sheet.Cells[ren, 2 + 3 * i].Value = (reten[i] + retAcm[i]).ToString("n2");
+
+ ren++;
+ sheet.Cells[++ren, 0].Value = "Determinacion del Impuesto al Valor Agregado Mensual del Ejercicio 2014";
+
+ ren++;
+ ren++;
+ sheet.Cells[ren, 0].Value = "IVA trasladado:";
+ for (int i = 0; i < 12; i++)
+ sheet.Cells[ren, 1 + 3 * i].Value = ivaTras[i].ToString("n2");
+
+ ren++;
+ sheet.Cells[ren, 0].Value = "Retención IVA:";
+ for (int i = 0; i < 12; i++)
+ sheet.Cells[ren, 1 + 3 * i].Value = ivaRet[i].ToString("n2");
+
+ ren++;
+ sheet.Cells[ren, 0].Value = "IVA Acreditable:";
+ for (int i = 0; i < 12; i++)
+ sheet.Cells[ren, 1 + 3 * i].Value = ivaAcr[i].ToString("n2");
+
+ ren++;
+ sheet.Cells[ren, 0].Value = "Saldo a favor de IVA:";
+ for (int i = 0; i < 12; i++)
+ sheet.Cells[ren, 1 + 3 * i].Value = ivaTras[i] - ivaRet[i]-ivaAcr[i] > 0 ? "0" :
+ Math.Round(ivaAcr[i] + ivaRet[i] - ivaTras[i]).ToString("n2");
+
+ ren++;
+ sheet.Cells[ren, 0].Value = "Saldo a pagar de IVA:";
+ for (int i = 0; i < 12; i++)
+ sheet.Cells[ren, 1 + 3 * i].Value = ivaTras[i] - ivaRet[i] - ivaAcr[i] > 0 ?
+ Math.Round(ivaTras[i] - ivaRet[i] - ivaAcr[i]).ToString("n2") : "0";
+
+ book.SaveDocument(string.Format("Contable.xls"));*/
}