public static object GetPersonsRange(ListEditItemsRequestedByFilterConditionEventArgs args) { var skip = args.BeginIndex; var take = args.EndIndex - args.BeginIndex + 1; return (from person in DB.IsEmri where (person.IsEmriId + " " + person.IsNo+ " " + person.Adi).StartsWith(args.Filter) orderby person.IsEmriId select person ).Skip(skip).Take(take); }
public List <ba_TipoFlujo_Info> get_list_bajo_demandaFlujo(ListEditItemsRequestedByFilterConditionEventArgs args) { return(bus_tipo.get_list_bajo_demanda(args, Convert.ToInt32(SessionFixed.IdEmpresa), cl_enumeradores.eTipoIngEgr.ING.ToString())); }
public List <ct_plancta_Info> get_list_bajo_demanda(ListEditItemsRequestedByFilterConditionEventArgs args) { return(bus_plancta.get_list_bajo_demanda(args, Convert.ToInt32(SessionFixed.IdEmpresa), false)); }
public List <tb_sucursal_Info> get_list_bajo_demanda_sucursal(ListEditItemsRequestedByFilterConditionEventArgs args) { return(bus_sucursal.get_list_bajo_demanda(args, Convert.ToInt32(SessionFixed.IdEmpresa))); }
public List <tb_banco_Info> get_list_bajo_demanda(ListEditItemsRequestedByFilterConditionEventArgs args) { return(bus_banco.get_list_bajo_demanda(args)); }
public object FiltrirajDobavljace(ListEditItemsRequestedByFilterConditionEventArgs args) { return(fRepository.VratiDobavljace(args.Filter, args.BeginIndex, args.EndIndex)); }
public List <ct_punto_cargo_grupo_Info> get_list_bajo_demanda_grupo(ListEditItemsRequestedByFilterConditionEventArgs args) { return(bus_grupo.get_list_bajo_demanda(args, Convert.ToInt32(SessionFixed.IdEmpresa))); }
protected void dxcboVesselID_ItemsRequestedByFilterCondition(object source, ListEditItemsRequestedByFilterConditionEventArgs e) { DevExpress.Web.ASPxEditors.ASPxComboBox _combo = (DevExpress.Web.ASPxEditors.ASPxComboBox)source; string _filter = !string.IsNullOrEmpty(e.Filter) ? e.Filter : ""; //use datareaders - much faster than loading into collections string[] _cols = { "VesselID", "VesselName" }; string[] _sort = { "VesselName" }; //SubSonic.SqlQuery _query = DAL.Logistics.DB.Select(_cols).From(DAL.Logistics.Tables.NameAndAddressBook).Paged(e.BeginIndex + 1, e.EndIndex + 1, "CompanyID").WhereExpression("CompanyName").Like(string.Format("%{0}%", e.Filter.ToString())); SubSonic.SqlQuery _query = DAL.Logistics.DB.Select(_cols).From(DAL.Logistics.Tables.VesselTable).Paged(e.BeginIndex + 1, e.EndIndex + 1).Where("VesselName").StartsWith(string.Format("{0}%", _filter)); IDataReader _rd = _query.ExecuteReader(); _combo.DataSource = _rd; _combo.ValueField = "VesselID"; _combo.TextField = "VesselName"; _combo.DataBindItems(); }
public List <Proveedor_Info> get_list_bajo_demanda(ListEditItemsRequestedByFilterConditionEventArgs args) { return(data_proveedor.get_list_bajo_demanda(args)); }
public List <in_Producto_Info> get_list_bajo_demanda_productos(ListEditItemsRequestedByFilterConditionEventArgs args) { return(bus_producto.get_list_bajo_demanda(args, Convert.ToInt32(SessionFixed.IdEmpresa), cl_enumeradores.eTipoBusquedaProducto.PORMODULO, cl_enumeradores.eModulo.COM, 0, 0)); }
protected void colBillActorTypeItemsRequestedByFilterCondition(object source, ListEditItemsRequestedByFilterConditionEventArgs e) { ASPxComboBox comboItemUnit = source as ASPxComboBox; XPCollection <BillActorType> collection = new XPCollection <BillActorType>(session); collection.SkipReturnedObjects = e.BeginIndex; collection.TopReturnedObjects = e.EndIndex - e.BeginIndex + 1; CriteriaOperator criteria = CriteriaOperator.And( new BinaryOperator("Name", String.Format("%{0}%", e.Filter), BinaryOperatorType.Equal), new BinaryOperator("RowStatus", 1, BinaryOperatorType.GreaterOrEqual)); collection.Criteria = criteria; collection.Sorting.Add(new SortProperty("Name", DevExpress.Xpo.DB.SortingDirection.Ascending)); comboItemUnit.DataSource = collection; comboItemUnit.DataBindItems(); }
public List <ba_tipo_nota_Info> get_list_bajo_demanda(ListEditItemsRequestedByFilterConditionEventArgs args, int IdEmpresa, string Tipo) { return(odata.get_list_bajo_demanda(args, IdEmpresa, Tipo)); }
public List <tb_persona_Info> get_list_bajo_demanda_cliente_x_tipo(ListEditItemsRequestedByFilterConditionEventArgs args, int IdEmpresa, int Idtipo_cliente) { return(odata.get_list_bajo_demanda_cliente_x_tipo(args, IdEmpresa, Idtipo_cliente)); }
//end incremental filtering of voyage name /// incremental filtering and partial loading of name and address book for speed /// both ItemsRequestedByFilterCondition and ItemRequestedByValue must be set up for this to work /// for devan warehouse the company list is limted to company typeid = 5 /// </summary> /// <param name="source"></param> /// <param name="e"></param> protected void dxcbocompany_ItemsRequestedByFilterCondition(object source, ListEditItemsRequestedByFilterConditionEventArgs e) { DevExpress.Web.ASPxEditors.ASPxComboBox _combo = (DevExpress.Web.ASPxEditors.ASPxComboBox)source; //if (Page.Session["user"] != null) //if publiship user allow filter to be used otherwise filter null //{ // Int32 _companyid = wwi_func.vint(((UserClass)Page.Session["user"]).CompanyId.ToString()); // if (_companyid == -1) // { string _filter = !string.IsNullOrEmpty(e.Filter) ? e.Filter : ""; //use datareaders - much faster than loading into collections string[] _cols = { "CompanyID, CompanyName", "Address1", "Address2", "Address3", "CountryName", "TelNo", "Customer" }; //SubSonic.SqlQuery _query = DAL.Logistics.DB.Select(_cols).From(DAL.Logistics.Tables.NameAndAddressBook).Paged(e.BeginIndex + 1, e.EndIndex + 1, "CompanyID").WhereExpression("CompanyName").Like(string.Format("%{0}%", e.Filter.ToString())); SubSonic.SqlQuery _query = DAL.Logistics.DB.Select(_cols).From("view_delivery_address").Paged(e.BeginIndex + 1, e.EndIndex + 1, "CompanyID").WhereExpression("CompanyName").Like(string.Format("{0}%", e.Filter.ToString())); switch (_combo.ID) { case "dxcboAgentAtDestinationID": { int[] _vals = { 3, 6 }; _query.And("TypeID").In(_vals); break; } case "dxcboConsigneeID": { _query.And("Consignee").IsEqualTo(1); break; } default: { break; } } IDataReader _rd = _query.ExecuteReader(); _combo.DataSource = _rd; _combo.ValueField = "CompanyID"; _combo.ValueType = typeof(int); _combo.TextField = "CompanyName"; _combo.DataBindItems(); // } //} }
public List <in_Producto_Info> get_list_ProductoHijo_bajo_demanda(ListEditItemsRequestedByFilterConditionEventArgs args) { return(bus_producto.get_list_bajo_demanda(args, Convert.ToInt32(SessionFixed.IdEmpresa), cl_enumeradores.eTipoBusquedaProducto.PORSUCURSAL, cl_enumeradores.eModulo.INV, Convert.ToInt32(SessionFixed.IdSucursal))); }
public List <tb_persona_Info> get_list_bajo_demanda(ListEditItemsRequestedByFilterConditionEventArgs args) { return(bus_persona.get_list_bajo_demanda(args, Convert.ToInt32(SessionFixed.IdEmpresa), cl_enumeradores.eTipoPersona.EMPLEA.ToString())); }
protected void CBUserPermissionType_ItemsRequestedByFilterCondition(object source, ListEditItemsRequestedByFilterConditionEventArgs e) { if (!string.IsNullOrEmpty(e.Filter)) { SqlDataSourceUserPermissionType.SelectParameters.Clear(); // force query to server SqlDataSourceUserPermissionType.SelectParameters.Add( new Parameter { Name = "search", DbType = DbType.AnsiString, Size = 60, DefaultValue = e.Filter.ToString().Replace("*", "%") } ); (source as ASPxComboBox).DataBindItems(); } }
protected void dxcboVesselID_ItemsRequestedByFilterCondition(object source, ListEditItemsRequestedByFilterConditionEventArgs e) { DevExpress.Web.ASPxEditors.ASPxComboBox _combo = (DevExpress.Web.ASPxEditors.ASPxComboBox)source; string _filter = !string.IsNullOrEmpty(e.Filter) ? e.Filter : ""; //use datareaders - much faster than loading into collections string[] _cols = { "VoyageID", "Joined", "ETS", "ETA", "DestinationPortID", "OriginPortID" }; string[] _sort = { "Joined" }; //additional filters on this dll string _originportid = ""; //get_token("pstart").ToString(); string _destportid = "";//get_token("pend").ToString(); ASPxComboBox _cbo = (ASPxComboBox)this.fmvBol.FindControl("dxcboOriginPort"); if(_cbo != null && _cbo.SelectedItem != null){ _originportid = _cbo.SelectedItem.Value.ToString(); } _cbo = (ASPxComboBox)this.fmvBol.FindControl("dxcboDestinationPort"); if(_cbo != null && _cbo.SelectedItem != null){ _destportid = _cbo.SelectedItem.Value.ToString(); } // //SubSonic.SqlQuery _query = DAL.Logistics.DB.Select(_cols).From(DAL.Logistics.Tables.NameAndAddressBook).Paged(e.BeginIndex + 1, e.EndIndex + 1, "CompanyID").WhereExpression("CompanyName").Like(string.Format("%{0}%", e.Filter.ToString())); SubSonic.SqlQuery _query = DAL.Logistics.DB.Select(_cols).From("Page2VesselView").Paged(e.BeginIndex + 1, e.EndIndex + 1, "VoyageID").Where("Joined").Like(string.Format("{0}%", e.Filter.ToString())); if(_originportid != "" && _destportid != ""){ _query.And("DestinationPortID").IsEqualTo(_destportid).And("OriginPortID").IsEqualTo(_originportid).OrderAsc(_sort); } string test = _query.ToString(); IDataReader _rd = _query.ExecuteReader(); _combo.DataSource = _rd; _combo.ValueField = "VoyageID"; _combo.TextField = "Joined"; _combo.DataBindItems(); }
protected void comboOrganization_ItemsRequestedByFilterCondition(object source, ListEditItemsRequestedByFilterConditionEventArgs e) { ASPxComboBox combo = source as ASPxComboBox; XPCollection <Organization> collection = new XPCollection <Organization>(session); collection.SkipReturnedObjects = e.BeginIndex; collection.TopReturnedObjects = e.EndIndex - e.BeginIndex + 1; //Get SUPPLIER trading type TradingCategory supplierTradingCategory = session.FindObject <TradingCategory>(new BinaryOperator("Code", "SUPPLIER")); CriteriaOperator criteria = CriteriaOperator.And( //row status is active new BinaryOperator("RowStatus", Utility.Constant.ROWSTATUS_ACTIVE), CriteriaOperator.Or( //find code contains the filter new BinaryOperator("Code", String.Format("%{0}%", e.Filter), BinaryOperatorType.Like), //find name contains the filter new BinaryOperator("Name", String.Format("%{0}%", e.Filter), BinaryOperatorType.Like) ), //find customer and supplier new ContainsOperator("OrganizationCategories", CriteriaOperator.And( new BinaryOperator("TradingCategoryId", supplierTradingCategory), new BinaryOperator("RowStatus", Utility.Constant.ROWSTATUS_ACTIVE) ) ) ); collection.Criteria = criteria; collection.Sorting.Add(new SortProperty("Code", DevExpress.Xpo.DB.SortingDirection.Ascending)); combo.DataSource = collection; combo.DataBindItems(); }
public List <Af_Activo_fijo_Info> get_list_bajo_demanda_af(ListEditItemsRequestedByFilterConditionEventArgs args) { return(bus_activo.get_list_bajo_demanda(args, Convert.ToInt32(SessionFixed.IdEmpresa))); }
public List <cp_proveedor_Info> get_list_bajo_demanda(ListEditItemsRequestedByFilterConditionEventArgs args) { return(bus_proveedor.get_list_bajo_demanda(args, Convert.ToInt32(SessionFixed.IdEmpresa))); }
public List <cp_proveedor_Info> get_list_bajo_demanda(ListEditItemsRequestedByFilterConditionEventArgs args, int IdEmpresa) { return(odata.get_list_bajo_demanda(args, IdEmpresa)); }
public List <in_Producto_Info> get_list_ProductoPadre_bajo_demanda(ListEditItemsRequestedByFilterConditionEventArgs args) { return(bus_producto.get_list_bajo_demanda(args, Convert.ToInt32(SessionFixed.IdEmpresa), cl_enumeradores.eTipoBusquedaProducto.SOLOPADRES, cl_enumeradores.eModulo.INV, 0)); }
public List <ct_plancta_Info> get_list_bajo_demanda_ctacble_cxp(ListEditItemsRequestedByFilterConditionEventArgs args) { var IdEmpresa = Convert.ToInt32(SessionFixed.IdEmpresa); return(bus_cuenta.get_list_bajo_demanda(args, IdEmpresa, false)); }
public List <in_Producto_Info> get_list_bajo_demanda(ListEditItemsRequestedByFilterConditionEventArgs args, int IdEmpresa, cl_enumeradores.eTipoBusquedaProducto Busqueda, cl_enumeradores.eModulo Modulo, int IdSucursal, int IdBodega = 0) { return(odata.get_list_bajo_demanda(args, IdEmpresa, Busqueda, Modulo, IdSucursal, IdBodega)); }
public List <in_Producto_Info> get_list_bajo_demandaProducto(ListEditItemsRequestedByFilterConditionEventArgs args) { List <in_Producto_Info> Lista = bus_producto.get_list_bajo_demanda(args, Convert.ToInt32(SessionFixed.IdEmpresa), cl_enumeradores.eTipoBusquedaProducto.SOLOSERVICIOS, cl_enumeradores.eModulo.FAC, Convert.ToInt32(SessionFixed.IdSucursal)); return(Lista); }
public List <ba_tipo_nota_Info> get_list_bajo_TipoNota(ListEditItemsRequestedByFilterConditionEventArgs args) { return(bus_tipo_nota.get_list_bajo_demanda(args, Convert.ToInt32(SessionFixed.IdEmpresa), cl_enumeradores.eTipoCbteBancario.NDBA.ToString())); }
public List <ct_CentroCosto_Info> get_list_bajo_demandaCC(ListEditItemsRequestedByFilterConditionEventArgs args) { List <ct_CentroCosto_Info> Lista = bus_cc.get_list_bajo_demanda(args, Convert.ToInt32(SessionFixed.IdEmpresa), false); return(Lista); }
public List <ct_CentroCosto_Info> get_list_bajo_demanda(ListEditItemsRequestedByFilterConditionEventArgs args) { return(bus_centrocosto.get_list_bajo_demanda(args, Convert.ToInt32(SessionFixed.IdEmpresa), true)); }
void dropDown_ItemsRequestedByFilterCondition(object source, ListEditItemsRequestedByFilterConditionEventArgs e) { if (String.IsNullOrEmpty(e.Filter) || e.Filter.Length < NUMBER_CHAR_SEARCH) return; var editor = ((ASPxComboBox)source); editor.DataSource = GetLookupSource(e.Filter); editor.DataBind(); }
/// <summary> /// new vessel selection /// </summary> /// <param name="source"></param> /// <param name="e"></param> protected void dxcboNewVessel_ItemsRequestedByFilterCondition(object source, ListEditItemsRequestedByFilterConditionEventArgs e) { DevExpress.Web.ASPxEditors.ASPxComboBox _combo = (DevExpress.Web.ASPxEditors.ASPxComboBox)source; string _filter = !string.IsNullOrEmpty(e.Filter) ? e.Filter : ""; //if (_filter != "") //{ //use datareaders - much faster than loading into collections string[] _cols = { "VoyageID", "Joined", "ETS", "ETA", "DestinationPortID", "OriginPortID" }; string[] _sort = { "Joined" }; //additional filters on this dll string _originportid = this.dxhfContainer.Contains("ptstart") ? this.dxhfContainer.Get("ptstart").ToString() : "0"; string _destportid = this.dxhfContainer.Contains("ptend") ? this.dxhfContainer.Get("ptend").ToString() : "0"; // SubSonic.SqlQuery _query = DAL.Logistics.DB.Select(_cols).From("Page2VesselView"). Paged(e.BeginIndex + 1, e.EndIndex + 1, "VoyageID").Where("Joined").Like(string.Format("{0}%", e.Filter.ToString())).And("DestinationPortID").IsEqualTo(_destportid).And("OriginPortID").IsEqualTo(_originportid).OrderAsc(_sort); IDataReader _rd = _query.ExecuteReader(); _combo.DataSource = _rd; _combo.ValueField = "VoyageID"; _combo.TextField = "Joined"; _combo.DataBindItems(); //} //endif }
public List <ro_rubro_tipo_Info> get_list_bajo_demanda_rubro(ListEditItemsRequestedByFilterConditionEventArgs args) { return(bus_rubro.get_list_bajo_demanda(args, Convert.ToInt32(SessionFixed.IdEmpresa))); }
public List <ct_grupo_x_Tipo_Gasto_Info> get_list_bajo_demanda(ListEditItemsRequestedByFilterConditionEventArgs args) { return(bus_GrupoPorTipoGasto.get_list_bajo_demanda(args, Convert.ToInt32(SessionFixed.IdEmpresa))); }
public List <tb_persona_Info> get_list_bajo_demanda(ListEditItemsRequestedByFilterConditionEventArgs args) { return(bus_persona.get_list_bajo_demanda(args, Convert.ToInt32(SessionFixed.IdEmpresa), SessionFixed.TipoPersona)); }
public List <caj_Caja_Movimiento_Tipo_Info> get_list_bajo_demanda_TipoMovimiento_Egreso(ListEditItemsRequestedByFilterConditionEventArgs args) { return(bus_tipo.get_list_bajo_demanda(args, Convert.ToInt32(SessionFixed.IdEmpresa), "-")); }
protected void dxcboDestControl_ItemsRequestedByFilterCondition(object source, ListEditItemsRequestedByFilterConditionEventArgs e) { ASPxComboBox _combo = (ASPxComboBox)source; if (_combo != null) { string[] _cols = { "EmployeesTable.EmployeeID, EmployeesTable.Name", "EmployeesTable.DepartmentID", "OfficeTable.OfficeID", " NameAndAddressBook.CompanyID" }; string[] _order = { "Name" }; SqlQuery _qry = new Select(_cols).From(DAL.Logistics.Tables.EmployeesTable). InnerJoin(DAL.Logistics.OfficeTable.OfficeIDColumn, DAL.Logistics.EmployeesTable.OfficeIDColumn). InnerJoin(DAL.Logistics.NameAndAddressBook.CountryIDColumn, DAL.Logistics.OfficeTable.CountryIDColumn); _qry.And(DAL.Logistics.EmployeesTable.LiveColumn).IsEqualTo(true).OrderAsc(_order); IDataReader _rd1 = _qry.ExecuteReader(); _combo.DataSource = _rd1; _combo.ValueField = "EmployeeID"; _combo.ValueType = typeof(int); _combo.TextField = "Name"; _combo.DataBindItems(); } }
public List <ba_TipoFlujo_Info> get_list_bajo_demanda_tipoflujo(ListEditItemsRequestedByFilterConditionEventArgs args) { var TipoFlujo_GetList = bus_TipoFlujo.get_list_bajo_demanda(args, Convert.ToInt32(SessionFixed.IdEmpresa)); return(TipoFlujo_GetList); }