public static object GetPersonByID(ListEditItemRequestedByValueEventArgs args) { int id; if (args.Value == null || !int.TryParse(args.Value.ToString(), out id)) return null; return DB.IsEmri.Where(p => p.IsEmriId == id).Take(1); }
public ro_rubro_tipo_Info get_info_bajo_demanda_rubro(ListEditItemRequestedByValueEventArgs args) { return(bus_rubro.get_info_bajo_demanda(Convert.ToInt32(SessionFixed.IdEmpresa), args)); }
public in_Motivo_Inven_Info get_info_bajo_demanda_motivo(ListEditItemRequestedByValueEventArgs args) { return(bus_motivo.get_info_bajo_demanda(args, Convert.ToInt32(SessionFixed.IdEmpresa))); }
public tb_TarjetaCredito_Info get_info_bajo_demanda(ListEditItemRequestedByValueEventArgs args) { return(odata.get_info_bajo_demanda(args)); }
public tb_parroquia_Info get_info_bajo_demanda_parroquia(ListEditItemRequestedByValueEventArgs args) { return(bus_parroquia.get_info_bajo_demanda(args, Convert.ToString(SessionFixed.IdCiudad))); }
public tb_parroquia_Info get_info_bajo_demanda(ListEditItemRequestedByValueEventArgs args, string IdCiudad) { return(get_info(args.Value == null ? "" : (string)args.Value, IdCiudad)); }
public tb_bodega_Info get_info_bajo_demanda(ListEditItemRequestedByValueEventArgs args, int IdEmpresa, int IdSucursal) { return(get_info(IdEmpresa, args.Value == null ? 0 : (int)args.Value, IdSucursal)); }
protected void cboLegalInvoiceArtifactType_ItemRequestedByValue(object source, ListEditItemRequestedByValueEventArgs e) { ASPxComboBox comboItemUnit = source as ASPxComboBox; try { NAS.DAL.Accounting.LegalInvoice.LegalInvoiceArtifactType obj = session.GetObjectByKey <NAS.DAL.Accounting.LegalInvoice.LegalInvoiceArtifactType>(Guid.Parse(e.Value.ToString())); if (obj != null) { comboItemUnit.DataSource = new NAS.DAL.Accounting.LegalInvoice.LegalInvoiceArtifactType[] { obj }; comboItemUnit.DataBindItems(); } } catch { } }
public tb_persona_Info get_info_bajo_demanda_cliente_x_tipo(ListEditItemRequestedByValueEventArgs args) { return(bus_persona.get_info_bajo_demanda_cliente_x_tipo(args, Convert.ToInt32(SessionFixed.IdEmpresa), Convert.ToInt32(SessionFixed.Idtipo_cliente))); }
void dropDown_ItemRequestedByValue(object source, ListEditItemRequestedByValueEventArgs e) { }
public tb_bodega_Info get_info_bajo_demanda(ListEditItemRequestedByValueEventArgs args, int IdEmpresa) { return(get_info_demanda(IdEmpresa, args.Value == null ? "" : args.Value.ToString())); }
public cp_proveedor_Info get_info_bajo_demanda(ListEditItemRequestedByValueEventArgs args, int IdEmpresa) { return(odata.get_info_bajo_demanda(args, IdEmpresa)); }
protected void dxcboNewVessel_ItemRequestedByValue(object source, ListEditItemRequestedByValueEventArgs e) { DevExpress.Web.ASPxEditors.ASPxComboBox _combo = (DevExpress.Web.ASPxEditors.ASPxComboBox)source; Int32 _id = 0; if (e.Value != null) { _id = wwi_func.vint(e.Value.ToString()); } //use datareaders - much faster than loading into collections string[] _cols = { "VoyageID", "Joined", "ETS", "ETA", "DestinationPortID", "OriginPortID" }; SubSonic.SqlQuery _query = DAL.Logistics.DB.Select(_cols).From("Page2VesselView").WhereExpression("VoyageID").IsEqualTo(_id); IDataReader _rd = _query.ExecuteReader(); _combo.DataSource = _rd; _combo.ValueField = "VoyageID"; _combo.TextField = "Joined"; _combo.DataBindItems(); }
//14/07/14 dxcboVesselID_ItemRequestedByValue and dxcboVesselID_ItemsRequestedByFilterCondition DEPRECATED //can't use OnItemsRequestedByFilterCondition and OnItemRequestedByValue on this combo as server-side filtring makes the search case sensitive //incremental filtering for large datasets on combos /// <summary> /// incremental filtering and partial loading of name and address book for speed /// both ItemsRequestedByFilterCondition and ItemRequestedByValue must be set up for this to work /// company name is only available to publiship users /// </summary> /// <param name="source"></param> /// <param name="e"></param> protected void dxcboCountry_ItemRequestedByValue(object source, ListEditItemRequestedByValueEventArgs e) { DevExpress.Web.ASPxEditors.ASPxComboBox _combo = (DevExpress.Web.ASPxEditors.ASPxComboBox)source; Int32 _id = 0; if (e.Value != null) { _id = wwi_func.vint(e.Value.ToString()); } string[] _cols = { "CountryID, CountryName" }; string[] _order = { "CountryName" }; SubSonic.SqlQuery _query = DAL.Logistics.DB.Select(_cols).From(DAL.Logistics.Tables.CountryTable).WhereExpression("CountryID").IsEqualTo(_id); IDataReader _rd = _query.ExecuteReader(); _combo.ValueField = "CountryID"; _combo.ValueType = typeof(int); _combo.TextField = "CountryName"; _combo.DataBindItems(); }
public Af_Activo_fijo_Info get_info_bajo_demanda_af(ListEditItemRequestedByValueEventArgs args) { return(bus_activo.get_info_bajo_demanda(Convert.ToInt32(SessionFixed.IdEmpresa), args)); }
public tb_persona_Info get_info_bajo_demanda(ListEditItemRequestedByValueEventArgs args) { return(Bus_persona.get_info_bajo_demanda(args, Convert.ToInt32(SessionFixed.IdEmpresa), cl_enumeradores.eTipoPersona.EMPLEA.ToString())); }
public caj_Caja_Movimiento_Tipo_Info get_info_bajo_demanda_TipoMovimiento_Egreso(ListEditItemRequestedByValueEventArgs args) { return(bus_tipo.get_info_bajo_demanda(args, Convert.ToInt32(SessionFixed.IdEmpresa))); }
protected void dxcbocompany_ItemRequestedByValue(object source, ListEditItemRequestedByValueEventArgs e) { DevExpress.Web.ASPxEditors.ASPxComboBox _combo = (DevExpress.Web.ASPxEditors.ASPxComboBox)source; Int32 _id = 0; //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) // { if (e.Value != null) { _id = wwi_func.vint(e.Value.ToString()); } //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).WhereExpression("CompanyID").IsEqualTo(_id); SubSonic.SqlQuery _query = DAL.Logistics.DB.Select(_cols).From("view_delivery_address").WhereExpression("CompanyID").IsEqualTo(_id); IDataReader _rd = _query.ExecuteReader(); _combo.DataSource = _rd; _combo.ValueField = "CompanyID"; _combo.ValueType = typeof(int); _combo.TextField = "CompanyName"; _combo.DataBindItems(); // } //} }
public static MonitorOperators GetEehMonitorOperatorsByOperator(this ICoreDataSource db, ListEditItemRequestedByValueEventArgs args) { if (args.Value == null) { return((MonitorOperators)null); } // db must be CorePortalEntities: var dbCPE = (CorePortalEntities)db; var tranDT = new ObjectParameter("tranDT", typeof(DateTime?)); var result = new ObjectParameter("result", typeof(int?)); var debugMsg = new ObjectParameter("debugMsg", typeof(string)); return(dbCPE.GetEehMonitorOperator(args.Value.ToString(), tranDT, result, 0, debugMsg) .SingleOrDefault()); }
//14/07/14 dxcboVesselID_ItemRequestedByValue and dxcboVesselID_ItemsRequestedByFilterCondition DEPRECATED //can't use OnItemsRequestedByFilterCondition and OnItemRequestedByValue on this combo as server-side filtring makes the search case sensitive //incremental filtering for large datasets on combos /// <summary> /// incremental filtering and partial loading of name and address book for speed /// both ItemsRequestedByFilterCondition and ItemRequestedByValue must be set up for this to work /// company name is only available to publiship users /// </summary> /// <param name="source"></param> /// <param name="e"></param> protected void dxcboVesselID_ItemRequestedByValue(object source, ListEditItemRequestedByValueEventArgs e) { DevExpress.Web.ASPxEditors.ASPxComboBox _combo = (DevExpress.Web.ASPxEditors.ASPxComboBox)source; Int32 _id = 0; if (e.Value != null) { _id = wwi_func.vint(e.Value.ToString()); } //use datareaders - much faster than loading into collections string[] _cols = { "VesselID", "VesselName" }; //SubSonic.SqlQuery _query = DAL.Logistics.DB.Select(_cols).From(DAL.Logistics.Tables.NameAndAddressBook).WhereExpression("CompanyID").IsEqualTo(_id); SubSonic.SqlQuery _query = DAL.Logistics.DB.Select(_cols).From(DAL.Logistics.Tables.VesselTable).WhereExpression("VesselID").IsEqualTo(_id); IDataReader _rd = _query.ExecuteReader(); _combo.DataSource = _rd; _combo.ValueField = "VesselID"; _combo.TextField = "VesselName"; _combo.DataBindItems(); }
public ro_area_Info get_info_bajo_demanda_individual(ListEditItemRequestedByValueEventArgs args, int IdEmpresa) { return(get_info(IdEmpresa, args.Value == null ? 0 : (int)args.Value)); }
public tb_ciudad_Info get_info_bajo_demanda_ciudad(ListEditItemRequestedByValueEventArgs args) { return(bus_ciudad.get_info_bajo_demanda(args)); }
public ct_punto_cargo_Info get_info_bajo_demanda(ListEditItemRequestedByValueEventArgs args, int IdEmpresa) { //La variable args del devexpress ya trae el ID seleccionado en la propiedad Value, se pasa el IdEmpresa porque es un filtro que no tiene return(GetInfo(IdEmpresa, args.Value == null ? 0 : Convert.ToInt32(args.Value.ToString()))); }
public Producto_Info GetInfo(ListEditItemRequestedByValueEventArgs args) { return(odata.GetInfo(args)); }
public tb_sucursal_Info get_info_bajo_demanda(int IdEmpresa, ListEditItemRequestedByValueEventArgs args) { return(odata.get_info_bajo_demanda(IdEmpresa, args)); }
public ct_CentroCosto_Info get_info_bajo_demandaEg(ListEditItemRequestedByValueEventArgs args) { return(bus_cc.get_info_bajo_demanda(args, Convert.ToInt32(SessionFixed.IdEmpresa))); }
public seg_usuario_Info get_info_bajo_demanda(ListEditItemRequestedByValueEventArgs args) { return(bus_usuario.get_info_bajo_demanda(args)); }
public tb_persona_Info get_info_bajo_demanda_persona(ListEditItemRequestedByValueEventArgs args) { return(bus_persona.get_info_bajo_demanda(args, Convert.ToInt32(SessionFixed.IdEmpresa), "PERSONA")); }
protected void cboProductManufacturer_OnItemRequestedByValue_SQL(object source, ListEditItemRequestedByValueEventArgs e) { ASPxComboBox comboBox = (ASPxComboBox)source; try { NAS.DAL.Nomenclature.Organization.ManufacturerOrg obj = session.GetObjectByKey <NAS.DAL.Nomenclature.Organization.ManufacturerOrg>(Guid.Parse(e.Value.ToString())); if (obj != null) { comboBox.DataSource = new NAS.DAL.Nomenclature.Organization.ManufacturerOrg[] { obj }; comboBox.DataBindItems(); } } catch { } }
public tb_sucursal_Info get_info_bajo_demanda_sucursal(ListEditItemRequestedByValueEventArgs args) { return(bus_sucursal.get_info_bajo_demanda(Convert.ToInt32(SessionFixed.IdEmpresa), args)); }
public Proveedor_Info get_info_bajo_demanda(ListEditItemRequestedByValueEventArgs args, string Tipo) { //La variable args del devexpress ya trae el ID seleccionado en la propiedad Value, se pasa el IdEmpresa porque es un filtro que no tiene return(get_info(Tipo, args.Value == null ? "" : args.Value.ToString())); }
//end incremental filtering agentarorigin /// <summary> /// destinatiobn controller /// </summary> /// <param name="source"></param> /// <param name="e"></param> protected void dxcboDestControl_ItemRequestedByValue(object source, ListEditItemRequestedByValueEventArgs e) { ASPxComboBox _combo = (ASPxComboBox)source; ASPxComboBox _destinationagent = (ASPxComboBox)this.fmvTemplate.FindControl("dxcboAgentAtDestinationIDEdit"); 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); if (_destinationagent != null && _destinationagent.SelectedItem != null && _destinationagent.Value != null) { int _filter = wwi_func.vint(_destinationagent.SelectedItem.GetValue("CountryID").ToString()); if (_filter > 0) { _qry.Where("CountryID").IsEqualTo(_filter); } } _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(); } }
protected void ASPxComboBox_OnItemRequestedByValue_SQL(object source, ListEditItemRequestedByValueEventArgs e) { }
public ba_TipoFlujo_Info get_info_bajo_demandaFlujo(ListEditItemRequestedByValueEventArgs args) { return(bus_tipo.get_info_bajo_demanda(args, Convert.ToInt32(SessionFixed.IdEmpresa))); }
public ct_plancta_Info get_info_bajo_demanda_ctacble_Anticipo(ListEditItemRequestedByValueEventArgs args) { var IdEmpresa = Convert.ToInt32(SessionFixed.IdEmpresa); return(bus_plancta.get_info_bajo_demanda(args, IdEmpresa)); }
public ct_plancta_Info get_info_bajo_demanda(ListEditItemRequestedByValueEventArgs args) { return(bus_plancta.get_info_bajo_demanda(args, Convert.ToInt32(SessionFixed.IdEmpresa))); }
public tb_empresa_Info get_info_bajo_demanda(ListEditItemRequestedByValueEventArgs args) { return(bus_empresa.get_info_bajo_demanda(args)); }