public static WorkReportResourceList GetByEmployeeList(List <long> oidEmployees, int year, int month, bool clustered, bool childs = true)
{
QueryConditions conditions = new QueryConditions
{
OidList = oidEmployees,
Orders = new OrderList(),
FechaIni = (year == 0)
? DateTime.MinValue
: (month == 0) ? DateAndTime.FirstDay(year) : DateAndTime.FirstDay(month, year),
FechaFin = (year == 0)
? DateTime.MaxValue
: (month == 0) ? DateAndTime.LastDay(year) : DateAndTime.LastDay(month, year),
};
if (clustered)
{
conditions.Groups = new GroupList();
conditions.Groups.NewGroup("OidResource", typeof(WorkReportResource));
conditions.Groups.NewGroup("Year", typeof(WorkReportResource));
conditions.Groups.NewGroup("Month", typeof(WorkReportResource));
conditions.Orders.NewOrder("Year", ListSortDirection.Descending, typeof(WorkReportResource));
conditions.Orders.NewOrder("Month", ListSortDirection.Descending, typeof(WorkReportResource));
}
else
{
conditions.Orders.NewOrder("From", ListSortDirection.Descending, typeof(WorkReportResource));
conditions.Orders.NewOrder("WorkReportID", ListSortDirection.Descending, typeof(WorkReportResource));
}
return(GetList(WorkReportResource.SELECT_BY_EMPLOYEES(conditions, false), childs));
}
protected void UpdateFechas()
{
switch (_periodo)
{
case EPeriodo.Anual:
FInicial_DTP.Value = DateAndTime.FirstDay(AnoActivo_DTP.Value.Year);
FFinal_DTP.Value = DateAndTime.LastDay(AnoActivo_DTP.Value.Year);
break;
case EPeriodo.Periodo1T:
FInicial_DTP.Value = DateAndTime.FirstDay(1, AnoActivo_DTP.Value.Year);
FFinal_DTP.Value = DateAndTime.LastDay(3, AnoActivo_DTP.Value.Year);
break;
case EPeriodo.Periodo2T:
FInicial_DTP.Value = DateAndTime.FirstDay(4, AnoActivo_DTP.Value.Year);
FFinal_DTP.Value = DateAndTime.LastDay(6, AnoActivo_DTP.Value.Year);
break;
case EPeriodo.Periodo3T:
FInicial_DTP.Value = DateAndTime.FirstDay(7, AnoActivo_DTP.Value.Year);
FFinal_DTP.Value = DateAndTime.LastDay(9, AnoActivo_DTP.Value.Year);
break;
case EPeriodo.Periodo4T:
FInicial_DTP.Value = DateAndTime.FirstDay(10, AnoActivo_DTP.Value.Year);
FFinal_DTP.Value = DateAndTime.LastDay(12, AnoActivo_DTP.Value.Year);
break;
}
}
public static ChargeSummaryList GetDudosoCobroList(int year)
{
QueryConditions conditions = new QueryConditions
{
FechaIni = DateAndTime.FirstDay(year),
FechaFin = DateAndTime.LastDay(year),
};
return(GetList(SELECT_DUDOSO_COBRO(conditions)));
}
public static ChargeSummaryList GetPendientesList(int year)
{
QueryConditions conditions = new QueryConditions
{
FechaIni = DateAndTime.FirstDay(year),
FechaFin = DateAndTime.LastDay(year),
};
return(GetList(SELECT_PENDIENTES(new QueryConditions())));
}
public static BankLineList GetList(int year, bool childs)
{
QueryConditions conditions = new QueryConditions
{
FechaIni = DateAndTime.FirstDay(year),
FechaFin = DateAndTime.LastDay(year)
};
return(GetList(conditions, childs));
}
public static OutputDeliveryList GetListBySerie(bool childs, long oidSerie, int year, ETipoAlbaranes tipo, ETipoFactura invoiceType)
{
QueryConditions conditions = new QueryConditions
{
Serie = SerieInfo.New(oidSerie),
TipoAlbaranes = tipo,
TipoFactura = invoiceType,
FechaIni = DateAndTime.FirstDay(year),
FechaFin = DateAndTime.LastDay(year)
};
return(GetList(childs, SELECT(conditions)));
}
public static BankLineList GetByCuentaList(BankAccountInfo cuenta, int year, bool childs)
{
QueryConditions conditions = new QueryConditions
{
FechaIni = DateAndTime.FirstDay(year),
FechaFin = DateAndTime.LastDay(year),
CuentaBancaria = cuenta
};
BankLineList list = GetByCuentaList(cuenta, childs);
BankLineList filtered_list = GetList(conditions, childs);
filtered_list.UpdateSaldos(list);
return(filtered_list);
}
public static TicketList GetBySerieAndYearList(long oid_serie, int year, ETipoFactura tipo)
{
CriteriaEx criteria = Ticket.GetCriteria(Ticket.OpenSession());
criteria.Childs = false;
QueryConditions conditions = new QueryConditions
{
Serie = Serie.New().GetInfo(false),
TipoFactura = tipo,
FechaIni = DateAndTime.FirstDay(year),
FechaFin = DateAndTime.LastDay(year),
};
conditions.Serie.Oid = oid_serie;
return(GetList(TicketList.SELECT(conditions), false));
}
public static void RellenaAlbaranesEnFacturas()
{
Library.Store.QueryConditions conditions = new Library.Store.QueryConditions
{
FechaIni = DateAndTime.FirstDay(2010),
FechaFin = DateAndTime.LastDay(2010)
};
InputInvoices list_p = InputInvoices.GetList(conditions, false);
foreach (InputInvoice item in list_p)
{
item.LoadChilds(typeof(AlbaranFacturaProveedor), false);
item.SetAlbaranes();
}
list_p.Save();
list_p.CloseSession();
}
public override void RefreshSecondaryData()
{
EModelo[] list = { EModelo.Modelo347, EModelo.Modelo420, EModelo.Modelo111 };
Datos_Modelos.DataSource = Library.Common.EnumText <EModelo> .GetList(list);
Modelo_CB.SelectedValue = (long)EModelo.Modelo347;
_modelo = (EModelo)((long)Modelo_CB.SelectedValue);
PgMng.Grow();
Datos_Periodo.DataSource = Library.Common.EnumText <EPeriodo> .GetList(false);
Periodo_CB.SelectedValue = (long)EPeriodo.Anual;
FInicial_DTP.Checked = true;
FFinal_DTP.Checked = true;
FInicial_DTP.Value = DateAndTime.FirstDay(DateTime.Today.Year);
FFinal_DTP.Value = DateAndTime.LastDay(DateTime.Today.Year);
AnoActivo_DTP.Value = DateTime.Today;
}
public static BudgetList GetList(bool childs, int year)
{
return(GetList(childs, DateAndTime.FirstDay(year), DateAndTime.LastDay(year)));
}
public static InputInvoiceList GetPagadasList(ETipoAcreedor tipo, int year, bool childs)
{
return(GetPagadasList(tipo, DateAndTime.FirstDay(year), DateAndTime.LastDay(year), childs));
}
public static InputInvoiceList GetPendientesList(ETipoAcreedor providerType, int year, bool childs)
{
return(GetPendientesList(providerType, DateAndTime.FirstDay(year), DateAndTime.LastDay(year), childs));
}
public static LoanList GetList(ELoanType loanType, int year, bool childs)
{
return(GetList(loanType, DateAndTime.FirstDay(year), DateAndTime.LastDay(year), childs));
}
public static OutputDeliveryList GetList(bool childs, long oidHolder, ETipoEntidad holderType, long oidSerie, ETipoAlbaranes deliveryType, ETipoFactura invoiceType, int year)
{
return(GetList(childs, oidHolder, holderType, oidSerie, deliveryType, invoiceType, DateAndTime.FirstDay(year), DateAndTime.LastDay(year)));
}
public static TicketList GetList(int year, EEstado estado, bool childs)
{
return(GetList(DateAndTime.FirstDay(year), DateAndTime.LastDay(year), estado, childs));
}
public static PaymentList GetList(ETipoPago tipo, int year, bool childs)
{
return(GetList(tipo, DateAndTime.FirstDay(year), DateAndTime.LastDay(year), childs));
}
public static OutputInvoiceLineList GetList(int year, bool childs)
{
return(GetList(DateAndTime.FirstDay(year), DateAndTime.LastDay(year), childs));
}
public static InputDeliveryList GetNoFacturados(bool childs, ETipoAcreedor tipo, long oid_acreedor, long oid_serie, int year)
{
return(GetList(childs, tipo, oid_acreedor, oid_serie, ETipoAlbaranes.NoFacturados, ETipoFactura.Todas, DateAndTime.FirstDay(year), DateAndTime.LastDay(year)));
}
public static OutputDeliveryList GetList(bool childs, ETipoEntidad holderType, int year)
{
return(GetList(childs, holderType, DateAndTime.FirstDay(year), DateAndTime.LastDay(year)));
}
public static OutputDeliveryList GetAgrupados(bool childs, int year)
{
return(GetList(childs, 0, ETipoEntidad.Cliente, 0, ETipoAlbaranes.Agrupados, ETipoFactura.Todas, DateAndTime.FirstDay(year), DateAndTime.LastDay(year)));
}
public static OutputDeliveryList GetWorkList(bool childs, int year)
{
return(GetWorkList(childs, DateAndTime.FirstDay(year), DateAndTime.LastDay(year)));
}
public static OutputDeliveryList GetNoFacturados(bool childs, long oidClient, long oidSerie, int year)
{
return(GetNoFacturados(childs, oidClient, oidSerie, DateAndTime.FirstDay(year), DateAndTime.LastDay(year)));
}
public static InputDeliveryList GetFacturados(bool childs, ETipoAcreedor tipo, int year)
{
return(GetFacturados(childs, tipo, DateAndTime.FirstDay(year), DateAndTime.LastDay(year)));
}
public static PaymentList GetList(int year, bool childs)
{
return(GetList(DateAndTime.FirstDay(year), DateAndTime.LastDay(year), childs));
}
public override void RefreshSecondaryData()
{
ETipoAcreedor[] providers =
{
ETipoAcreedor.Acreedor,
ETipoAcreedor.Despachante,
ETipoAcreedor.Empleado,
ETipoAcreedor.Naviera,
ETipoAcreedor.Proveedor,
ETipoAcreedor.TransportistaDestino,
ETipoAcreedor.TransportistaOrigen,
ETipoAcreedor.Todos
};
Datos_TiposAcreedor.DataSource = Library.Common.EnumText <ETipoAcreedor> .GetList(providers);
TipoAcreedor_CB.SelectedItem = (long)ETipoAcreedor.Todos;
PgMng.Grow();
Datos_MedioPago.DataSource = Library.Common.EnumText <EMedioPago> .GetList(false, false);
//MedioPago_CB.SelectedValue = (long)EMedioPago.Todos;
MedioPago_CLB.Items.Clear();
foreach (ComboBoxSource combo in Datos_MedioPago.DataSource as ComboBoxList <EMedioPago> )
{
MedioPago_CLB.Items.Add(combo.Texto, true);
}
PgMng.Grow();
EEstado[] list = { EEstado.Abierto, EEstado.Emitido, EEstado.Charged, EEstado.Solicitado, EEstado.Contabilizado, EEstado.Exportado, EEstado.NoAnulado };
Datos_Estado.DataSource = Library.Common.EnumText <EEstado> .GetList(list);
Estado_CB.SelectedValue = (long)EEstado.Abierto;
PgMng.Grow();
Datos_TipoPago.DataSource = Library.Store.EnumText <ETipoPago> .GetList(false);
TipoPago_CB.SelectedItem = (long)ETipoPago.Todos;
PgMng.Grow();
Datos_TipoCobro.DataSource = Library.Invoice.EnumText <ETipoCobro> .GetList(false);
TipoCobro_CB.SelectedItem = (long)ETipoCobro.Todos;
PgMng.Grow();
Datos_TipoAyuda.DataSource = Library.Invoice.EnumText <ETipoAyudaContabilidad> .GetList(false);
TipoAyuda_CB.SelectedItem = (long)ETipoAyudaContabilidad.Todas;
RutaSalida_TB.Text = Library.Invoice.ModulePrincipal.GetContabilidadFolder();
CW_Diario_TB.Text = Library.Invoice.ModulePrincipal.GetJournalSetting();
CW_AsientoInicial_TB.Text = Library.Invoice.ModulePrincipal.GetLastAsientoSetting();
TF_Diario_TB.Text = Library.Invoice.ModulePrincipal.GetJournalTinforSetting();
TF_AsientoInicial_TB.Text = Library.Invoice.ModulePrincipal.GetLastAsientoTinforSetting();
TF_Centro_TB.Text = Library.Invoice.ModulePrincipal.GetCentroTrabajoTinforSetting();
TF_Empresa_TB.Text = Library.Invoice.ModulePrincipal.GetEmpresaTinforSetting();
CodigoEmpresaA3_TB.Text = Library.Invoice.ModulePrincipal.GetEmpresaA3Setting();
ETipoExportacion tipo = Library.Invoice.ModulePrincipal.GetDefaultTipoExportacionSetting();
switch (tipo)
{
case ETipoExportacion.ContaWin:
ContaWin_RB.Checked = true;
break;
case ETipoExportacion.A3:
A3_RB.Checked = true;
break;
case ETipoExportacion.Tinfor:
Tinfor_RB.Checked = true;
break;
}
FInicial_DTP.Checked = true;
FFinal_DTP.Checked = true;
FInicial_DTP.Value = DateAndTime.FirstDay(DateTime.Today.Month, DateTime.Today.Year);
FFinal_DTP.Value = DateTime.Today;
}
public static Payments GetList(ETipoPago paymentType, int year, bool childs)
{
return(GetList(paymentType, DateAndTime.FirstDay(year), DateAndTime.LastDay(year), childs));
}
public static FinancialCashList GetList(int year, bool childs)
{
return(GetList(DateAndTime.FirstDay(year), DateAndTime.LastDay(year), childs));
}
public static LineaRegistroList GetList(ETipoRegistro tipo, int year, bool childs)
{
return(GetList(tipo, DateAndTime.FirstDay(year), DateAndTime.LastDay(year), childs));
}
public static PedidoProveedorList GetList(ETipoAcreedor tipo, int year, bool childs)
{
return(GetList(tipo, DateAndTime.FirstDay(year), DateAndTime.LastDay(year), childs));
}
