private void simpleActionRprtCntbl_Execute(object sender, DevExpress.ExpressApp.Actions.SimpleActionExecuteEventArgs e)
{
if (View != null)
{
NegocioAdmin.ReporteContable(View.ObjectSpace);
}
}
private void actionShowMemory_Execute(object sender, DevExpress.ExpressApp.Actions.SimpleActionExecuteEventArgs e)
{
GC.Collect();
GC.GetTotalMemory(true);
initialUsedMemory = GC.GetTotalMemory(true);
throw new Exception(initialUsedMemory.ToString());
}
////protected override void OnActivated()
////{
//// this.TargetObjectType = typeof(IWorkCalendarEvent);
//// base.OnActivated();
////}
protected override void ExecuteEdit(DevExpress.ExpressApp.Actions.SimpleActionExecuteEventArgs args)
{
if (typeof(IWorkCalendarEvent).IsAssignableFrom(View.CurrentObject.GetType()))
{
WorkCalendarEvent workCalendarEvent = this.View.CurrentObject as WorkCalendarEvent;
if (workCalendarEvent.JobCard != null)
{
this.LoadDetailView(args, workCalendarEvent.JobCard);
}
else if (workCalendarEvent.Project != null)
{
this.LoadDetailView(args, workCalendarEvent.Project);
}
else if (workCalendarEvent.WorkFlowTask != null)
{
this.LoadDetailView(args, workCalendarEvent.WorkFlowTask);
}
else if (workCalendarEvent.Task != null)
{
this.LoadDetailView(args, workCalendarEvent.Task);
}
else if (workCalendarEvent.Booking != null)
{
this.LoadDetailView(args, workCalendarEvent.Booking);
}
return;
}
base.ExecuteEdit(args);
}
private void SimpleAction_EditDashboard_Execute(object sender, DevExpress.ExpressApp.Actions.SimpleActionExecuteEventArgs e)
{
using (var uow = new UnitOfWork(XpoDefault.DataLayer))
{
var query = $"Delete From {nameof(DoSoExceptionLog)}";
uow.ExecuteNonQuery(query);
ObjectSpace.Refresh();
}
}
private void simpleActionCncilr_Execute(object sender, DevExpress.ExpressApp.Actions.SimpleActionExecuteEventArgs e)
{
if (View != null && View.ObjectSpace != null)
{
IObjectSpace objectSpace = Application.CreateObjectSpace();
CriteriaOperator[] operands = new CriteriaOperator[1];
operands[0] = new BinaryOperator("Concilia", true, BinaryOperatorType.NotEqual);
SortProperty[] sortCollection = new SortProperty[1];
sortCollection[0] = new SortProperty("FechaDoc", SortingDirection.Ascending);
IList arr = objectSpace.CreateCollection(typeof(DocumentoSalida),
new GroupOperator(operands), sortCollection);
Ventas vta = objectSpace.FindObject <Ventas>(null);
foreach (string file in Directory.GetFiles(Directory.GetCurrentDirectory(), "*.xml"))
{
XmlDocument xml = new XmlDocument();
xml.Load(file);
XmlNodeList nl = xml.GetElementsByTagName("tfd:TimbreFiscalDigital");
if (nl != null && nl.Count > 0)
{
XmlNode se = nl[0].Attributes.GetNamedItem("UUID");
XmlNode fe = nl[0].Attributes.GetNamedItem("FechaTimbrado");
if (se != null)
{
foreach (DocumentoSalida fac in arr)
{
if (!string.IsNullOrEmpty(fac.Uuid))
{
if (se.Value == fac.Uuid)
{
string aux;
/*
* string aux = Directory.GetCurrentDirectory();
* aux = Path.Combine(aux, "Pdfs");*/
aux = Path.Combine(vta.VntCfdi.RutaPdfVnts, fac.Tipo.ToString());
aux = NegocioAdmin.CreaDirs(aux, fac.FechaDoc);
aux = Path.Combine(aux, Path.GetFileName(file));
// string.Format("{0}-{1}.xml", it.ReciboN, it.Uuid));
File.Move(file, aux);
// CreaPdfImprime(false, true, objectSpace);
// NegocioNom.ImprFto("ReciboItem", false, true, NegocioNom.NamePdf(it), it, objectSpace);
fac.Concilia = true;
}
}
}
}
}
}
objectSpace.CommitChanges();
}
}
private void simpleActionCncilr_Execute(object sender, DevExpress.ExpressApp.Actions.SimpleActionExecuteEventArgs e)
{
if (View != null && View.ObjectSpace != null)
{
IObjectSpace objectSpace = Application.CreateObjectSpace();
NegocioAdmin.Concilia(objectSpace);
objectSpace.CommitChanges();
}
}
private void simpleActionTestCadnOrgnl_Execute(object sender, DevExpress.ExpressApp.Actions.SimpleActionExecuteEventArgs e)
{
Certificado cert = View.CurrentObject as Certificado;
FacturaE fac = new FacturaE();
NegocioAdmin.VaciaStructCert(fac, cert, View.ObjectSpace);
fac.LeeInfoCFD(/*cert*/);
if (fac.TestKy("Prueba de Genera Sello" /*, null*/))
{
// FacturaE.GeneraSello("||3.2|2014-01-13T15:39:40|ingreso|PAGO EN UNA SOLA EXHIBICION|10.00|0.00|1.00000|MXN|11.60|NO IDENTIFICADO|Uaxaca,|No Identificado|AAA010101AAA|EMPRESA INVALIDA|Calle empresa|Numero|Colonia|Delegacion|Uaxaca|MÉXICO|codig|Calle empresa|MÉXICO|Regimen de la empresa|XAXX010101000|Cliente de mostrador nacional|DISTRITO FEDERAL|MÉXICO|1|Kilogramo|SRVC|SERVICIO CON IMPUESTO|10.00|10.00|IVA|16|1.60|1.60||");
XtraMessageBox.Show("Todo Bien !", "Certificado", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Information);
}
}
void todayFilterAction_Execute(object sender, DevExpress.ExpressApp.Actions.SimpleActionExecuteEventArgs e)
{
bool applyFilter = ((CheckableSimpleAction)sender).Checked;
if (applyFilter)
{
View.CollectionSource.Criteria["IsToday"] = new FunctionOperator(FunctionOperatorType.IsOutlookIntervalToday, new OperandProperty("Date"));
}
else
{
View.CollectionSource.Criteria.Remove("IsToday");
}
}
void activeFilterAction_Execute(object sender, DevExpress.ExpressApp.Actions.SimpleActionExecuteEventArgs e)
{
bool applyFilter = ((CheckableSimpleAction)sender).Checked;
if (applyFilter)
{
View.CollectionSource.Criteria["IsActive"] = new OperandProperty("Active");
}
else
{
View.CollectionSource.Criteria.Remove("IsActive");
}
}
private void SalesOrderMarkAsResolvedAction_Execute(object sender, DevExpress.ExpressApp.Actions.SimpleActionExecuteEventArgs e)
{
// Set Resolved flag on selected records.
foreach (SalesOrder salesOrder in View.SelectedObjects.OfType <SalesOrder>())
{
salesOrder.Resolved = true;
}
// Save Changes only if the view is List View. On Detail View, we want to let user decide if changes should be saved or reverted.
if (this.View is ListView)
{
this.ObjectSpace.CommitChanges();
}
}
void endTrackMemoryAction_Execute(object sender, DevExpress.ExpressApp.Actions.SimpleActionExecuteEventArgs e)
{
DevExpress.Data.Helpers.LohPooled.PoolBase.FlushPools();
GC.GetTotalMemory(true);
long usedMemory = GC.GetTotalMemory(true);
long memoryGrow = (usedMemory - initialUsedMemory) / (1024 * usedKB);
if (memoryGrow > maxUsedMemory)
{
throw new Exception(memoryGrow.ToString());
}
else
{
throw new Exception(maxUsedMemory.ToString());
}
}
private void LoadDetailView(DevExpress.ExpressApp.Actions.SimpleActionExecuteEventArgs args, object Workflow)
{
IObjectSpace objectSpace = Application.CreateObjectSpace();
Session session = ((XPObjectSpace)objectSpace).Session;
object currentObject = session.FindObject(Workflow.GetType(), CriteriaOperator.Parse("Oid == ?", (Workflow as BaseObject).Oid));
DetailView view = Application.CreateDetailView(objectSpace, currentObject, true);
view.ViewEditMode = DevExpress.ExpressApp.Editors.ViewEditMode.Edit;
view.Closed += View_Closed;
args.ShowViewParameters.CreatedView = view;
args.ShowViewParameters.CreatedView.Tag = objectSpace.GetKeyValue(currentObject);
args.ShowViewParameters.TargetWindow = TargetWindow.NewModalWindow;
args.ShowViewParameters.Context = TemplateContext.PopupWindow;
}
private void simpleAction1_Execute(object sender, DevExpress.ExpressApp.Actions.SimpleActionExecuteEventArgs e)
{
var lv = View as ListView;
if (lv != null)
{
foreach (ProtocolRecordType recordType in lv.SelectedObjects)
{
if (recordType.Code == null)
{
recordType.Code = recordType.GetDefaultCode();
recordType.Save();
ObjectSpace.CommitChanges();
}
}
}
}
private void simpleActionACrs_Execute(object sender, DevExpress.ExpressApp.Actions.SimpleActionExecuteEventArgs e)
{
if (View != null && View.CurrentObject != null)
{
Presupuesto prsu = View.CurrentObject as Presupuesto;
if (prsu != null)
{
foreach (ConceptoP cp in prsu.Partidas)
{
cp.MntRl = 0;
}
View.ObjectSpace.CommitChanges();
View.Refresh(true);
}
}
}
private void Bestfit_Execute(object sender, DevExpress.ExpressApp.Actions.SimpleActionExecuteEventArgs e)
{
ASPxGridListEditor gridListEditor = View.Editor as ASPxGridListEditor;
if (gridListEditor != null)
{
ASPxGridView gridView = gridListEditor.Grid;
gridView.Settings.UseFixedTableLayout = true;
gridView.Settings.HorizontalScrollBarMode = ScrollBarMode.Auto;
gridView.Width = Unit.Percentage(100);
foreach (WebColumnBase column in gridView.Columns)
{
IColumnInfo columnInfo = ((IDataItemTemplateInfoProvider)gridListEditor).GetColumnInfo(column);
if (columnInfo != null)
{
IModelColumn modelColumn = (IModelColumn)columnInfo.Model;
column.Width = Unit.Pixel(200);
}
}
}
}
private void MarkSalesOrderAsInvalidAction_Execute(object sender, DevExpress.ExpressApp.Actions.SimpleActionExecuteEventArgs e)
{
int selectedRecordsCount = View.SelectedObjects.Count;
if (selectedRecordsCount > 0)
{
// Get current employee
Employee employee = SecuritySystem.CurrentUser as Employee;
// Create a new builder to create message
StringBuilder builder = new StringBuilder();
if (selectedRecordsCount == 1)
{
builder.AppendLine($"Following Sales Order record has been marked as Invalid by the '{employee}' employee:");
}
else
{
builder.AppendLine($"Following Sales Order records have been marked as Invalid by the '{employee}' employee:");
}
// Set Invalid flag on selected records.
foreach (SalesOrder salesOrder in View.SelectedObjects.OfType <SalesOrder>())
{
salesOrder.Invalid = true;
builder.AppendLine($"- {salesOrder.OrderCode}");
}
// Send email message to the employee set in the Program Options as SalesOrder notification receiver.
ProgramOptions programOptions = ProgramOptions.GetInstance(this.ObjectSpace.Session());
if (programOptions != null)
{
try
{
if (programOptions.SalesOrderNotificationAdministrator == null)
{
throw new Exception("Sales Order Notification Administrator is not set in the Program Options.\r\nPlease contact the administrator.");
}
if (string.IsNullOrEmpty(programOptions.SenderEmailAddress) || string.IsNullOrEmpty(programOptions.SenderEmailPassword) || programOptions.SMTPPort == 0 || string.IsNullOrEmpty(programOptions.SmtpClientName))
{
throw new Exception("Email configuration in the Program Options is missing. Please contact the administrator.");
}
MimeMessage message = new MimeMessage();
message.From.Add(new MailboxAddress($"{Application.ApplicationName} - Notification Service", programOptions.SenderEmailAddress));
message.To.Add(new MailboxAddress(programOptions.SalesOrderNotificationAdministrator.FullName, programOptions.SalesOrderNotificationAdministrator.Email));
message.Subject = $"{Application.ApplicationName} - Invalid Sales Orders";
message.Body = new TextPart("plain")
{
Text = builder.ToString()
};
// Send the email
if (EmailHelper.SendEmail(this.ObjectSpace.Session(), message, out string errorMessage))
{
//TODO: Show confirmation message
ShowMessageService.Strategy.ShowDialog("The email has been successfully sent.", "Success", CustomMessageBoxButtons.OK, CutomMessageBoxIcon.Information);
}
else
{
//Show error information. Logging has been done in the SendEmail method.
throw new Exception($"An error occurred while sending the Email message to the '{programOptions.SalesOrderNotificationAdministrator.Email}':\n{errorMessage}");
}
}
catch (Exception ex)
{
this.ObjectSpace.Rollback(false);
throw;
}
}
// Save Changes
this.ObjectSpace.CommitChanges();
}
}
private void NextObjectAction_Execute(object sender, DevExpress.ExpressApp.Actions.SimpleActionExecuteEventArgs e)
{
Debug.Print("Next");
}
private void action_Execute(object sender, DevExpress.ExpressApp.Actions.SimpleActionExecuteEventArgs e)
{
GC.GetTotalMemory(true);
initialUsedMemory = GC.GetTotalMemory(true);
}
private void simpleActionGetXml_Execute(object sender, DevExpress.ExpressApp.Actions.SimpleActionExecuteEventArgs e)
{
}
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"));*/
}
private void simpleActionGetXml_Execute(object sender, DevExpress.ExpressApp.Actions.SimpleActionExecuteEventArgs e)
{
/*
* NegocioAdmin.ObtenXmlsVnts(View.ObjectSpace);*/
}
private void RecursiveFilterPopLookUpTreeSelectionSimpleAction_Execute(object sender, DevExpress.ExpressApp.Actions.SimpleActionExecuteEventArgs e)
{
recursive = true;
Frame.GetController <ListViewProcessCurrentObjectController>().ProcessCurrentObjectAction.DoExecute();
}
