internal static string JOIN_RESOURCE(ETipoEntidad entityType, QueryConditions conditions)
{
string query = string.Empty;
switch (entityType)
{
case ETipoEntidad.OutputDelivery:
{
string rs = nHManager.Instance.GetSQLTable(typeof(OutputDeliveryRecord));
query += @"
INNER JOIN " + rs + @" AS RS ON RS.""OID"" = WO.""OID_RESOURCE"" AND WO.""ENTITY_TYPE"" = " + (long)entityType;
}
break;
case ETipoEntidad.Empleado:
{
string rs = nHManager.Instance.GetSQLTable(typeof(EmployeeRecord));
query += @"
INNER JOIN " + rs + @" AS RS ON RS.""OID"" = WO.""OID_RESOURCE"" AND WO.""ENTITY_TYPE"" = " + (long)entityType;
}
break;
case ETipoEntidad.Tool:
{
string rs = nHManager.Instance.GetSQLTable(typeof(ToolRecord));
query += @"
INNER JOIN " + rs + @" AS RS ON RS.""OID"" = WO.""OID_RESOURCE"" AND WO.""ENTITY_TYPE"" = " + (long)entityType;
}
break;
}
return(query);
}
protected override void GetFormSourceData(long oid, object[] parameters)
{
ETipoEntidad holder_type = (ETipoEntidad)parameters[0];
_entity = OutputDelivery.Get(oid, holder_type);
_entity.BeginEdit();
}
public static OutputDeliveryList GetList(bool childs,
long oidHolder,
ETipoEntidad holderType,
long oidSerie,
ETipoAlbaranes deliveryType,
ETipoFactura invoiceType,
DateTime from,
DateTime till)
{
QueryConditions conditions = new QueryConditions
{
Serie = (oidSerie != 0) ? SerieInfo.New(oidSerie) : null,
TipoEntidad = holderType,
TipoAlbaranes = deliveryType,
TipoFactura = invoiceType,
FechaIni = from,
FechaFin = till,
};
switch (holderType)
{
case ETipoEntidad.Cliente:
conditions.Cliente = (oidHolder != 0) ? ClienteInfo.New(oidHolder) : null;
break;
case ETipoEntidad.WorkReport:
conditions.WorkReport = (oidHolder != 0) ? WorkReportInfo.New(oidHolder) : null;
break;
}
return(GetList(childs, SELECT(conditions)));
}
public DeliverySelectForm(Form parent, ETipoEntidad holderType, OutputDeliveryList list)
: base(true, parent, holderType, ETipoAlbaranes.Todos, list)
{
InitializeComponent();
_view_mode = molView.Select;
_action_result = DialogResult.Cancel;
}
protected override void GetFormSourceData(object[] parameters)
{
if (parameters[0] == null)
{
ETipoEntidad holder_type = (ETipoEntidad)parameters[1];
_entity = OutputDelivery.New(holder_type);
_entity.BeginEdit();
switch (holder_type)
{
case ETipoEntidad.Cliente:
{
if (parameters.Length >= 3)
{
_delivery_type = (ETipoAlbaranes)parameters[2];
if (_delivery_type == ETipoAlbaranes.Agrupados)
{
_entity.Contado = true;
_entity.GetNewCode(ETipoEntidad.Cliente, ETipoAlbaranes.Agrupados);
_entity.EMedioPago = EMedioPago.Efectivo;
}
}
}
break;
case ETipoEntidad.WorkReport:
{
//Se ha pasado como parametro en el constructor
if (parameters.Length >= 3)
{
_work_report = (WorkReportInfo)parameters[2];
}
//Venimos de un parte de trabajo y esta en cache
else if (Cache.Instance.Contains(typeof(WorkReport)))
{
_work_report = (Cache.Instance.Get(typeof(WorkReport)) as WorkReport).GetInfo();
}
_entity.OidHolder = (_work_report != null) ? _work_report.Oid : 0;
_entity.EMedioPago = EMedioPago.Efectivo;
SerieInfo serie = SerieInfo.Get(Library.Invoice.ModulePrincipal.GetWorkDeliverySerieSetting(), false);
_entity.OidSerie = (serie != null) ? serie.Oid : 0;
}
break;
}
}
else
{
_entity = (OutputDelivery)parameters[0];
_entity.BeginEdit();
SerieInfo serie = SerieInfo.Get(_entity.OidSerie, false);
_entity.OidSerie = (serie != null) ? serie.Oid : 0;
}
}
public DeliveryViewForm(long oid, ETipoEntidad holderType, Form parent)
: base(oid, new object[1] {
holderType
}, true, parent)
{
InitializeComponent();
SetView(molView.ReadOnly);
SetFormData();
_mf_type = ManagerFormType.MFView;
}
public void ActivateEntidad(ETipoEntidad tipo, string table, Type type, Type list_type)
{
TEntidadRegistroBase entidad = new TEntidadRegistroBase();
entidad.Table = table;
entidad.ETipoEntidad = tipo;
entidad.Type = type;
entidad.ListType = list_type;
_active_entidades.Add(tipo, entidad);
}
public NotifyEntity(ETipoNotificacion tipo, ETipoEntidad tipoEntidad, int count, decimal total, string title, object list, bool checkedItem, bool setTotal)
{
ETipoNotificacion = tipo;
ETipoEntidad = tipoEntidad;
Count = count;
Total = total;
Title = title;
List = list;
Checked = checkedItem;
SetTotal = setTotal;
}
public DeliverySelectForm(Form parent, ETipoEntidad holderType, ETipoAlbaranes deliveryType, long oidSerie, long oidHolder)
: base(true, parent, holderType, deliveryType)
{
InitializeComponent();
_view_mode = molView.Select;
_oid_client = oidHolder;
_oid_serie = oidSerie;
_action_result = DialogResult.Cancel;
}
public DeliveryEditForm(long oid, ETipoEntidad holderType, Form parent)
: base(oid, new object[1] {
holderType
}, true, parent)
{
InitializeComponent();
if (_entity != null)
{
SetFormData();
}
_mf_type = ManagerFormType.MFEdit;
}
public TEntidadRegistroBase GetEntidad(ETipoEntidad tipo)
{
foreach (KeyValuePair <ETipoEntidad, TEntidadRegistroBase> item in _active_entidades)
{
if (item.Value.ETipoEntidad == tipo)
{
return(item.Value);
}
}
return(default(TEntidadRegistroBase));
}
public static Transaction GetByTransactionID(string transactionID, ETipoEntidad entityType, ETransactionType transType, EEstado[] status, bool childs)
{
QueryConditions conditions = new QueryConditions
{
EntityType = entityType,
Transaction = TransactionInfo.New(),
Status = status
};
conditions.Transaction.TransactionID = transactionID;
conditions.Transaction.ETransactionType = transType;
return(Get(SELECT(conditions), childs));
}
private void OpenForm(ETipoEntidad entityType, long oid)
{
switch (entityType)
{
case ETipoEntidad.Producto:
{
ProductEditForm form = new ProductEditForm(oid, this);
form.ShowDialog();
} break;
case ETipoEntidad.CurrencyExchange:
{
CurrencyExchangeUIForm form = new CurrencyExchangeUIForm(this);
form.ShowDialog();
} break;
}
}
public static WorkReportResourceList GetList(List <long> oidExpedients, ETipoEntidad entityType, bool clustered, bool childs = true)
{
QueryConditions conditions = new QueryConditions
{
OidList = oidExpedients,
EntityType = entityType
};
if (clustered)
{
conditions.Groups = new GroupList();
conditions.Groups.NewGroup("OidResource", typeof(WorkReportResource));
conditions.Groups.NewGroup("EntityType", typeof(WorkReportResource));
}
return(GetList(WorkReportResource.SELECT_BY_EXPEDIENTS(conditions, false), childs));
}
public static WorkReportResourceList GetList(long oidExpedient, ETipoEntidad entityType, bool clustered, bool childs = true)
{
QueryConditions conditions = new QueryConditions
{
Expedient = ExpedientInfo.New(oidExpedient),
EntityType = entityType
};
if (clustered)
{
conditions.Groups = new GroupList();
conditions.Groups.NewGroup("OidResource", typeof(WorkReportResource));
conditions.Groups.NewGroup("EntityType", typeof(WorkReportResource));
}
return(GetList(SELECT(conditions), childs));
}
public DeliveryMngForm(bool isModal, Form parent, ETipoEntidad holderType, ETipoAlbaranes tipo, OutputDeliveryList lista)
: base(isModal, parent, lista)
{
InitializeComponent();
SetView(molView.Normal);
// Parche para poder abrir el formulario en modo diseño y no perder la configuracion de columnas
DatosLocal_BS = Datos;
Tabla.DataSource = DatosLocal_BS;
SetMainDataGridView(Tabla);
Datos.DataSource = OutputDeliveryList.NewList().GetSortedList();
SortProperty = Fecha.DataPropertyName;
SortDirection = ListSortDirection.Descending;
_holder_type = holderType;
_delivery_type = tipo;
}
protected string GetCreditCardAccount(PaymentInfo payment, ETipoEntidad accountType)
{
string cuenta = string.Empty;
string info = string.Empty;
CreditCardInfo credit_card = null;
try
{
credit_card = CreditCardInfo.Get(payment.OidTarjetaCredito);
if (accountType == ETipoEntidad.CuentaBancaria)
{
BankAccountInfo cb = _bank_accounts.GetItem(credit_card.OidCuentaBancaria);
cuenta = cb.CuentaContable;
info = String.Format(Resources.Messages.BANK_ACCOUNT_BOOK_ACCOUNT_NOT_FOUND, cb.Valor, cb.Entidad);
}
else
{
cuenta = credit_card.CuentaContable;
info = String.Format(Resources.Messages.CREDIT_CARD_BOOK_ACCOUNT_NOT_FOUND, credit_card.Numeracion, credit_card.Nombre);
}
}
catch (Exception ex)
{
if (ex is iQException)
{
throw ex;
}
else
{
throw new iQException("La tarjeta nº " + credit_card.Nombre + " no tiene cuenta bancaria asociada");
}
}
if (cuenta == string.Empty)
{
throw new iQException(info);
}
return(cuenta);
}
public static WorkReport GetByResource(long oidResource, ETipoEntidad entityType, bool childs = true)
{
QueryConditions conditions = new QueryConditions();
switch (entityType)
{
case moleQule.Common.Structs.ETipoEntidad.Empleado:
conditions.Acreedor = ProviderBaseInfo.New(oidResource, ETipoAcreedor.Empleado);
break;
case moleQule.Common.Structs.ETipoEntidad.OutputDelivery:
conditions.Add(oidResource, ETipoEntidad.OutputDelivery);
break;
case moleQule.Common.Structs.ETipoEntidad.Tool:
conditions.Tool = ToolInfo.New(oidResource);
break;
}
return(Get(SELECT(conditions, true), childs));
}
internal static string SELECT_BASE(QueryConditions conditions, ETipoEntidad tipo)
{
string lr = nHManager.Instance.GetSQLTable(typeof(RegistryLineRecord));
string rg = nHManager.Instance.GetSQLTable(typeof(RegistryRecord));
EEstado estado = conditions.Estado;
conditions.Estado = EEstado.Todos;
string query;
switch (conditions.TipoRegistro)
{
case ETipoRegistro.Fomento:
Assembly assembly = Assembly.Load("moleQule.Library.Store");
Type type = assembly.GetType("moleQule.Library.Store.LineaFomento");
query = (string)type.InvokeMember("SELECT_LINEAS_FOMENTO", BindingFlags.Static | BindingFlags.InvokeMethod | BindingFlags.Public, null, null, new object[2] {
conditions, tipo
});
break;
default:
query =
SELECT_FIELDS() +
" FROM "+ lr + " AS LR" +
" INNER JOIN "+ rg + " AS RG ON RG.\"OID\" = LR.\"OID_REGISTRO\"" +
" INNER JOIN "+ TABLE(tipo) + " AS EN ON EN.\"OID\" = LR.\"OID_ENTIDAD\" AND LR.\"TIPO_ENTIDAD\" = " + (long)tipo +
WHERE(conditions);
break;
}
//if (lock_table) query += " FOR UPDATE OF L NOWAIT";
return(query);
}
public static ETipoAcreedor ToETipoAcreedor(ETipoEntidad source)
{
switch (source)
{
case moleQule.Common.Structs.ETipoEntidad.Acreedor: return(ETipoAcreedor.Acreedor);
case moleQule.Common.Structs.ETipoEntidad.Partner: return(ETipoAcreedor.Partner);
case moleQule.Common.Structs.ETipoEntidad.Proveedor: return(ETipoAcreedor.Proveedor);
case moleQule.Common.Structs.ETipoEntidad.Naviera: return(ETipoAcreedor.Naviera);
case moleQule.Common.Structs.ETipoEntidad.TransportistaOrigen: return(ETipoAcreedor.TransportistaOrigen);
case moleQule.Common.Structs.ETipoEntidad.TransportistaDestino: return(ETipoAcreedor.TransportistaDestino);
case moleQule.Common.Structs.ETipoEntidad.Despachante: return(ETipoAcreedor.Despachante);
case moleQule.Common.Structs.ETipoEntidad.Instructor: return(ETipoAcreedor.Instructor);
}
return(ETipoAcreedor.Todos);
}
public NotifyEntity(ETipoNotificacion tipo, ETipoEntidad tipoEntidad, int count, decimal total, string title, object list, bool checkedItem)
: this(tipo, tipoEntidad, count, total, title, list, checkedItem, true)
{
}
public NotifyEntity(ETipoNotificacion tipo, ETipoEntidad tipoEntidad, string title)
: this(tipo, tipoEntidad, 0, 0, title, null, true)
{
}
public NotifyEntity(ETipoNotificacion tipo, ETipoEntidad tipoEntidad, int count, decimal total, string title)
: this(tipo, tipoEntidad, count, total, title, null)
{
}
public NotifyEntity(ETipoNotificacion tipo, ETipoEntidad tipoEntidad, int count, decimal total)
: this(tipo, tipoEntidad, count, total, string.Empty)
{
}
public string Encode(QREncodeVersion version, ETipoEntidad tipo, object source)
{
String txtEncodeData = string.Empty;
txtEncodeData = "<l v=" + ((long)version).ToString() + " t=" + ((long)tipo).ToString() + " oid=OID_ITEM>";
switch (tipo)
{
case ETipoEntidad.FacturaEmitida:
{
OutputInvoicePrint item = (OutputInvoicePrint)source;
txtEncodeData = txtEncodeData.Replace("OID_ITEM", item.Oid.ToString());
txtEncodeData += "<p>"
+ item.NumeroSerie + "|"
+ item.Fecha.ToShortDateString() + "|"
+ item.VatNumber + "|"
+ item.Codigo + "|"
+ item.Cliente + "|"
+ item.BaseImponible.ToString() + "|"
+ item.Impuestos.ToString() + "|"
+ item.Total.ToString() + "|"
+ "</p>";
}
break;
case ETipoEntidad.Cobro:
{
CobroPrint item = (CobroPrint)source;
txtEncodeData = txtEncodeData.Replace("OID_ITEM", item.Oid.ToString());
txtEncodeData += "<p>"
+ item.Codigo + "|"
+ item.Fecha.ToShortDateString() + "|"
+ item.IDCobroS + "|"
+ item.EMedioPagoPrintLabel + "|"
+ item.NCliente + "|"
+ item.Cliente + "|"
+ item.Importe + "|"
+ item.CuentaBancaria + "|"
+ "</p>";
if (item.CobroFacturas != null)
{
txtEncodeData += "<sl t=" + ((long)ETipoEntidad.CobroFactura).ToString() + ">";
foreach (CobroFacturaInfo cf in item.CobroFacturas)
{
txtEncodeData += "<p>"
+ cf.CodigoFactura + "|"
+ cf.Cantidad + "|"
+ "</p>";
}
txtEncodeData += "</sl>";
}
}
break;
}
txtEncodeData += "</l>";
return(txtEncodeData);
}
public static OutputDeliveryList GetList(bool childs, ETipoEntidad holderType)
{
return(GetList(childs, holderType, DateTime.MinValue, DateTime.MaxValue));
}
public DeliveryAddForm(ETipoEntidad tipo, Form parent)
: this(new object[2] {
null, tipo
}, parent)
{
}
public string Encode(QREncodeVersion version, ETipoEntidad tipo, object source)
{
String txtEncodeData = string.Empty;
txtEncodeData = "<l v=" + ((long)version).ToString() + " t=" + ((long)tipo).ToString() + " oid=OID_ITEM>";
switch (tipo)
{
case moleQule.Common.Structs.ETipoEntidad.FacturaRecibida:
{
InputInvoicePrint item = (InputInvoicePrint)source;
txtEncodeData = txtEncodeData.Replace("OID_ITEM", item.Oid.ToString());
txtEncodeData += "<p>"
+ item.Codigo + "|"
+ item.NSerie + "|"
+ item.Fecha.ToShortDateString() + "|"
+ item.VatNumber + "|"
+ item.NumeroAcreedor + "|"
+ item.Acreedor + "|"
+ item.BaseImponible.ToString() + "|"
+ item.ImporteIgic.ToString() + "|"
+ item.Total.ToString() + "|"
+ "</p>";
}
break;
case moleQule.Common.Structs.ETipoEntidad.Pago:
{
PaymentPrint item = (PaymentPrint)source;
txtEncodeData = txtEncodeData.Replace("OID_ITEM", item.Oid.ToString());
txtEncodeData += "<p>"
+ item.Codigo + "|"
+ item.Fecha.ToShortDateString() + "|"
+ item.IDPagoS + "|"
+ item.EMedioPagoPrintLabel + "|"
+ item.CodigoAgente + "|"
+ item.Agente + "|"
+ item.Importe + "|"
+ item.CuentaBancaria + "|"
+ "</p>";
if (item.Operations != null)
{
txtEncodeData += "<sl t=" + ((long)moleQule.Common.Structs.ETipoEntidad.PagoFactura).ToString() + ">";
foreach (TransactionPaymentInfo cf in item.Operations)
{
txtEncodeData += "<p>"
+ cf.CodigoFactura + "|"
+ cf.Cantidad + "|"
+ "</p>";
}
txtEncodeData += "</sl>";
}
}
break;
}
txtEncodeData += "</l>";
return(txtEncodeData);
}
private void OpenForm(ETipoEntidad entityType, long oid)
{
switch (entityType)
{
case ETipoEntidad.Cliente:
{
ClientEditForm form = new ClientEditForm(oid, this);
form.ShowDialog();
} break;
case ETipoEntidad.CuentaBancaria:
{
BankAccountEditForm form = new BankAccountEditForm(oid, this);
form.ShowDialog();
} break;
case ETipoEntidad.Despachante:
{
DespachanteEditForm form = new DespachanteEditForm(oid, this);
form.ShowDialog();
} break;
case ETipoEntidad.Empleado:
{
EmployeeEditForm form = new EmployeeEditForm(oid, this);
form.ShowDialog();
} break;
case ETipoEntidad.Familia:
{
FamiliaEditForm form = new FamiliaEditForm(oid, this);
form.ShowDialog();
} break;
case ETipoEntidad.Impuesto:
{
ImpuestoUIForm form = new ImpuestoUIForm(this);
form.ShowDialog();
} break;
case ETipoEntidad.Naviera:
{
NavieraEditForm form = new NavieraEditForm(oid, this);
form.ShowDialog();
} break;
case ETipoEntidad.Acreedor:
case ETipoEntidad.Proveedor:
{
ProveedorEditForm form = new ProveedorEditForm(oid, moleQule.Library.Store.EnumConvert.ToETipoAcreedor(entityType), this);
form.ShowDialog();
} break;
case ETipoEntidad.TipoGasto:
{
TipoGastoEditForm form = new TipoGastoEditForm(oid);
form.ShowDialog();
} break;
case ETipoEntidad.TransportistaDestino:
case ETipoEntidad.TransportistaOrigen:
{
TransporterEditForm form = new TransporterEditForm(oid, moleQule.Library.Store.EnumConvert.ToETipoAcreedor(entityType), this);
form.ShowDialog();
} break;
case ETipoEntidad.Prestamo:
{
LoanEditForm form = new LoanEditForm(oid, this);
form.ShowDialog();
} break;
}
}
public static OutputDeliveryList GetList(bool childs, ETipoEntidad holderType, int year)
{
return(GetList(childs, holderType, DateAndTime.FirstDay(year), DateAndTime.LastDay(year)));
}