public ActionResult ListArticulos(StArticulos model)
{
using (var service = FService.Instance.GetService(typeof(ArticulosModel), ContextService, MarfilEntities.ConnectToSqlServer(ContextService.BaseDatos)) as ArticulosService)
{
var registrosTotales = 0;
var list = service.GetArticulosBusquedasMobile(model, out registrosTotales);
var result = new ResultBusquedasPaginados <ArticulosBusqueda>()
{
values = list,
columns = new[]
{
new ColumnDefinition()
{
field = "Id", displayName = "Artículo", visible = true
},
new ColumnDefinition()
{
field = "Descripcion", displayName = "Descripción", visible = true
}
},
RegistrosTotales = registrosTotales,
PaginaActual = Funciones.Qint(model.Pagina) ?? 1,
};
return(Json(result));
}
}
public ActionResult Buscar(StCuentas model)
{
using (var service = FService.Instance.GetService(typeof(CuentasModel), ContextService, MarfilEntities.ConnectToSqlServer(ContextService.BaseDatos)) as CuentasService)
{
int registrosTotales = 0;
IEnumerable <CuentasBusqueda> items = null;
try
{
items = service.GetCuentas(model, out registrosTotales);
}
catch (Exception ex)
{
return(Json(new ErrorJson(ex.Message)));
}
var result = new ResultBusquedasPaginados <CuentasBusqueda>()
{
values = items,
columns = new[]
{
new ColumnDefinition()
{
field = "Fkcuentas", displayName = "Cuentas", visible = true
},
new ColumnDefinition()
{
field = "Descripcion", displayName = "Descripción", visible = true
},
new ColumnDefinition()
{
field = "Razonsocial", displayName = "Razón", visible = true
},
new ColumnDefinition()
{
field = "Nif", displayName = "Nif", visible = true
},
new ColumnDefinition()
{
field = "Pais", displayName = "País", visible = true
},
new ColumnDefinition()
{
field = "Provincia", displayName = "Provincia", visible = true
},
new ColumnDefinition()
{
field = "Poblacion", displayName = "Población", visible = true
},
},
RegistrosTotales = registrosTotales,
PaginaActual = Funciones.Qint(model.Pagina) ?? 1,
};
return(Json(result));
}
}
public ActionResult Buscar(StDocumentos model)
{
using (var service = GetService(model.Tipodocumento))
{
int registrosTotales = 0;
IEnumerable <DocumentosBusqueda> items = null;
try
{
items = service.Buscar(model, out registrosTotales);
}
catch (Exception ex)
{
return(Json(new ErrorJson(ex.Message)));
}
var result = new ResultBusquedasPaginados <DocumentosBusqueda>()
{
values = items,
columns = new[]
{
new ColumnDefinition()
{
field = "Referencia", displayName = "Referencia", visible = true
},
new ColumnDefinition()
{
field = "Fecha", displayName = "Fecha", visible = true
},
new ColumnDefinition()
{
field = "Fkclientes", displayName = "Cliente", visible = true
},
new ColumnDefinition()
{
field = "Nombrecliente", displayName = "Nombre", visible = true
},
new ColumnDefinition()
{
field = "Estado", displayName = "Estado", visible = true
},
new ColumnDefinition()
{
field = "Basecadena", displayName = "Base", visible = true
}
},
RegistrosTotales = registrosTotales,
PaginaActual = Funciones.Qint(model.Pagina) ?? 1,
};
return(Json(result));
}
}
public ActionResult ListLotes(StListadoStock model)
{
var service = new StockactualService(ContextService, MarfilEntities.ConnectToSqlServer(ContextService.BaseDatos));
var list = service.GetArticulosLotesAgrupados(model.Fkalmacen, ContextService.Empresa, model.IdArticulo);
var result = new ResultBusquedasPaginados <StockActualMobileModel>()
{
values = list,
columns = new[]
{
new ColumnDefinition()
{
field = "Fkarticulos", displayName = "Artículo", visible = true
},
new ColumnDefinition()
{
field = "Articulo", displayName = "Descripción", visible = true
},
new ColumnDefinition()
{
field = "Lote", displayName = "Lote", visible = true
},
new ColumnDefinition()
{
field = "Cantidaddisponible", displayName = "Cantidad", visible = true
},
new ColumnDefinition()
{
field = "SMetros", displayName = "Metros", visible = true
},
new ColumnDefinition()
{
field = "UM", displayName = "UM", visible = true
},
},
RegistrosTotales = list.Count(),
PaginaActual = 1
};
return(Json(result));
}
