protected void PatientListGridView_CellEditorInitialize(object sender, DevExpress.Web.ASPxGridViewEditorEventArgs e) { try { e.Editor.ReadOnly = false; if (e.Column.Name == "colPrimaryPhysician") { ASPxComboBox cmb = e.Editor as ASPxComboBox; if (Session["PhysicianDS"] != null) { cmb.DataSource = Session["PhysicianDS"]; cmb.DataBindItems(); } else { GetPhysicianList(); cmb.DataSource = Session["PhysicianDS"]; cmb.DataBindItems(); } } } catch (Exception ex) { CommonHelpers.writeLogToFile("PatientListGridView_CellEditorInitialize: PatientList.aspx", ex.Message); } }
protected void gvAssignedQuestionnaire_CellEditorInitialize(object sender, ASPxGridViewEditorEventArgs e) { try { e.Editor.ReadOnly = false; if (e.Column.Name == "colQuestionnaireName") { ASPxComboBox cmb = e.Editor as ASPxComboBox; if (Session["QuestionnaireDS"] != null) { cmb.DataSource = Session["QuestionnaireDS"]; cmb.DataBindItems(); } else { GetQuestionnaireList(); cmb.DataSource = Session["QuestionnaireDS"]; cmb.DataBindItems(); } } } catch (Exception ex) { CommonHelpers.writeLogToFile("gvAssignedQuestionnaire_CellEditorInitialize: PatientList.aspx", ex.Message); } }
protected void dxcbocompany_ItemRequestedByValue(object source, DevExpress.Web.ASPxEditors.ListEditItemRequestedByValueEventArgs e) { ASPxComboBox _combo = (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", "CountryID" }; //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(); // } //} }
protected void bind_destination_controller(int countryId) { ASPxComboBox _combo = (ASPxComboBox)this.fmvAddresses.FindControl("dxcboDestinationPortControllerIDEdit"); if (_combo != null) { string[] _cols = { "EmployeesTable.EmployeeID, EmployeesTable.Name", "EmployeesTable.DepartmentID", "OfficeTable.OfficeID" }; string[] _order = { "Name" }; //don't need nameandaddressbook as get countryid from officetable //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); SqlQuery _qry = new Select(_cols).From(DAL.Logistics.Tables.EmployeesTable). InnerJoin(DAL.Logistics.OfficeTable.OfficeIDColumn, DAL.Logistics.EmployeesTable.OfficeIDColumn); if (countryId > 0) { _qry.Where("CountryID").IsEqualTo(countryId); } _qry.And(DAL.Logistics.EmployeesTable.LiveColumn).IsEqualTo(1).OrderAsc(_order); //string _q = _qry.ToString(); //fo testing //DataTable _dt = _qry.ExecuteDataSet().Tables[0]; //for testing IDataReader _rd1 = _qry.ExecuteReader(); _combo.DataSource = _rd1; _combo.ValueField = "EmployeeID"; _combo.ValueType = typeof(int); _combo.TextField = "Name"; _combo.DataBindItems(); } }
protected void comboPerson_ItemsRequestedByFilterCondition(object source, ListEditItemsRequestedByFilterConditionEventArgs e) { ASPxComboBox combo = source as ASPxComboBox; XPCollection <Person> collection = new XPCollection <Person>(session); collection.SkipReturnedObjects = e.BeginIndex; collection.TopReturnedObjects = e.EndIndex - e.BeginIndex + 1; 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) ) ); collection.Criteria = criteria; collection.Sorting.Add(new SortProperty("Code", DevExpress.Xpo.DB.SortingDirection.Ascending)); combo.DataSource = collection; combo.DataBindItems(); }
protected void Comuna(ASPxComboBox combo, int IdProvincia) { combo.DataSourceID = "dsComunaPor"; dsComunaPor.SelectParameters["IdCiudad"].DefaultValue = IdProvincia.ToString(); combo.DataBindItems(); combo.Items.Insert(0, new ListEditItem("", null)); }
protected void cboLot_ItemsRequestedByFilterCondition(object source, ListEditItemsRequestedByFilterConditionEventArgs e) { int editRowIndex = grdSalesInvoice.EditingRowVisibleIndex; if (editRowIndex >= 0) { editItemUnitId = Guid.Parse(grdSalesInvoice.GetRowValues(editRowIndex, "ItemUnitId!Key").ToString()); } ASPxComboBox comboItemUnit = source as ASPxComboBox; XPCollection <Lot> collection = new XPCollection <Lot>(session); collection.SkipReturnedObjects = e.BeginIndex; collection.TopReturnedObjects = e.EndIndex - e.BeginIndex + 1; CriteriaOperator criteria = new GroupOperator(GroupOperatorType.Or, new CriteriaOperator[] { new GroupOperator(GroupOperatorType.And, new CriteriaOperator[] { new BinaryOperator("Code", String.Format("%{0}%", e.Filter), BinaryOperatorType.Like), new BinaryOperator("RowStatus", -1, BinaryOperatorType.Greater) }), new BinaryOperator("ItemUnitId.ItemUnitId", editItemUnitId, BinaryOperatorType.Equal) }); collection.Criteria = criteria; collection.Sorting.Add(new SortProperty("Code", DevExpress.Xpo.DB.SortingDirection.Ascending)); comboItemUnit.DataSource = collection; comboItemUnit.DataBindItems(); }
void AccountItemsRequestedByFilterCondition(object source, ListEditItemsRequestedByFilterConditionEventArgs e) { ASPxComboBox comboItemUnit = source as ASPxComboBox; CriteriaOperator filter = new BinaryOperator("Code", "0", BinaryOperatorType.Equal); XPCollection <NAS.DAL.Accounting.AccountChart.Account> collection = new XPCollection <NAS.DAL.Accounting.AccountChart.Account>(session, filter); foreach (NAS.DAL.Accounting.AccountChart.Account account in AccountingBO.getNotParentAccountList(session)) { collection.Add(account); } //collection.SkipReturnedObjects = e.BeginIndex; //collection.TopReturnedObjects = e.EndIndex - e.BeginIndex + 1; //CriteriaOperator criteria = // CriteriaOperator.Or( // new BinaryOperator("Code", String.Format("%{0}%", e.Filter), BinaryOperatorType.Like), // new BinaryOperator("Name", String.Format("%{0}%", e.Filter), BinaryOperatorType.Like) //); //collection.Criteria = criteria; //collection.Sorting.Add(new SortProperty("Code", DevExpress.Xpo.DB.SortingDirection.Ascending)); comboItemUnit.DataSource = collection; comboItemUnit.DataBindItems(); }
//end bind fcl lcl dll protected void bind_package_type() { try { string[] _cols = { "PackageTypeID, PackageType" }; string[] _order = { "PackageType" }; SqlQuery _qry = new Select(_cols).From(DAL.Logistics.Tables.PackageTypeTable).OrderAsc(_order); //order controller ASPxComboBox _cb = (ASPxComboBox)this.fmvShipment.FindControl("dxcboPackageTypeID"); if (_cb != null) { IDataReader _rd1 = _qry.ExecuteReader(); _cb.DataSource = _rd1; _cb.ValueType = typeof(int); _cb.ValueField = "PackageTypeID"; _cb.TextField = "PackageType"; _cb.DataBindItems(); } } catch (Exception ex) { string _err = ex.Message.ToString(); this.dxlblErr.Text = _err; this.dxpnlErr.ClientVisible = true; } }
/// <summary> /// make sure VALUETYPE is defined for all dll's or they will display value rather than text /// </summary> protected void bind_fcl_lcl() { string _path = AppDomain.CurrentDomain.BaseDirectory; _path += "xml\\ddl_items.xml"; // pass _qryFilter to have keyword-filter RSS Feed // i.e. _qryFilter = XML -> entries with XML will be returned DataSet _ds = new DataSet(); _ds.ReadXml(_path); DataView _dv = _ds.Tables[0].DefaultView; _dv.RowFilter = "ddls ='FCLLCL'"; //Run time population of GridViewDataComboBoxColumn column with data ASPxComboBox _cb = (ASPxComboBox)this.fmvShipment.FindControl("dxcboFCLLCL"); if (_cb != null) { _cb.DataSource = _dv; _cb.ValueType = typeof(int); _cb.TextField = "name"; _cb.ValueField = "value"; _cb.DataBindItems(); } }
protected void FillCombo_OLD_SYSTEM(ASPxComboBox cmb, string SYS_CODE) { try { if (string.IsNullOrEmpty(SYS_CODE)) return; string SQL = ""; SQL = " SELECT CTLT_SYS_USER_RIGHT.USER_RIGHT ROLE_ID"; SQL += " ,SYS_CODE"; SQL += " ,CTLT_USER_RIGHT.USER_RIGHT_DESC ROLE_NAME"; SQL += " FROM CTLT_SYS_USER_RIGHT "; SQL += " LEFT JOIN CTLT_USER_RIGHT ON CTLT_USER_RIGHT.USER_RIGHT = CTLT_SYS_USER_RIGHT.USER_RIGHT"; SQL += " WHERE SYS_CODE='" + SYS_CODE + "'"; //string SQL = string.Format("select ROLE_ID,ROLE_NAME from ODS_SYSTEM_ROLE WHERE SYS_CODE='{0}' ORDER BY [ROLE_NAME]", SYS_CODE); SqlDataAdapter DA = new SqlDataAdapter(SQL, OPM_BL.DefaultConnectionString); DataTable DTRole = new DataTable(); DA.Fill(DTRole); cmb.DataSource = DTRole; cmb.ValueField = "ROLE_ID"; cmb.TextField = "ROLE_NAME"; cmb.DataBindItems(); //AccessDataSource2.FilterExpression = " SYS_CODE='" + SYS_CODE + "'"; //DataView dv = (DataView)AccessDataSource2.Select(DataSourceSelectArguments.Empty); //DataTable DT = dv.ToTable(); } catch (Exception ex) { } }
public override void ItemsRequestedByFilterCondition(DevExpress.Xpo.Session session, object source, DevExpress.Web.ASPxEditors.ListEditItemsRequestedByFilterConditionEventArgs e) { ASPxComboBox combo = source as ASPxComboBox; XPCollection <InventoryCommand> collection = new XPCollection <InventoryCommand>(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 //CriteriaOperator.Or( new BinaryOperator("RowStatus", Utility.Constant.ROWSTATUS_ACTIVE), // new BinaryOperator("RowStatus", Utility.Constant.ROWSTATUS_BOOKED_ENTRY) //), 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) ), new BinaryOperator("CommandType", 'I', BinaryOperatorType.Equal) ); collection.Criteria = criteria; collection.Sorting.Add(new SortProperty("Code", DevExpress.Xpo.DB.SortingDirection.Ascending)); combo.DataSource = collection; combo.DataBindItems(); }
void comboItem_ItemsRequestedByFilterCondition(object source, ListEditItemsRequestedByFilterConditionEventArgs e) { UnitOfWork uow = XpoHelper.GetNewUnitOfWork(); ASPxComboBox comboItem = source as ASPxComboBox; XPCollection <Item> collection = new XPCollection <Item>(uow); collection.SkipReturnedObjects = e.BeginIndex; collection.TopReturnedObjects = e.EndIndex - e.BeginIndex + 1; CriteriaOperator criteria = null; criteria = CriteriaOperator.And( new ContainsOperator("ItemCustomTypes", new BinaryOperator("ObjectTypeId.Name", "PRODUCT")), new BinaryOperator("RowStatus", 0, BinaryOperatorType.Greater), CriteriaOperator.Or( new BinaryOperator("Code", String.Format("%{0}%", e.Filter), BinaryOperatorType.Like), new BinaryOperator("Name", String.Format("%{0}%", e.Filter), BinaryOperatorType.Like))); collection.Criteria = criteria; collection.Sorting.Add(new SortProperty("Code", DevExpress.Xpo.DB.SortingDirection.Ascending)); comboItem.DataSource = collection; comboItem.DataBindItems(); }
protected void dxGridColaborador_CellEditorInitialize(object sender, DevExpress.Web.ASPxGridViewEditorEventArgs e) { DataTable dt = new DataTable(); dt.Columns.Add("idCargo"); dt.Columns.Add("cargo"); ServicioColaborador.ServicioColaboradorClient sercivio_colaborador = new ServicioColaborador.ServicioColaboradorClient(); DataTable dt2 = new DataTable(); dt2.Columns.Add("idCargo"); dt2.Columns.Add("cargo"); if (e.Column.FieldName == "idCargo") { ASPxComboBox request = e.Editor as ASPxComboBox; request.ValueField = "idCargo"; request.TextField = "cargo"; request.ValueType = typeof(System.Int32); request.DataSource = sercivio_colaborador.ObtenerCargos(); request.DataBindItems(); } }
protected void FillCombo(ASPxComboBox cmb, string SYS_CODE) { try { if (string.IsNullOrEmpty(SYS_CODE)) return; //AccessDataSource2.SelectParameters.Clear(); ////string SQL = AccessDataSource2.SelectCommand; //AccessDataSource2.SelectCommand = " select SYS_CODE ,ROLE_ID,ROLE_NAME from ODS_SYSTEM_ROLE "; //AccessDataSource2.SelectCommand = SQL; string SQL = string.Format("select ROLE_ID,ROLE_NAME from ODS_SYSTEM_ROLE WHERE SYS_CODE='{0}' ORDER BY [ROLE_NAME]", SYS_CODE); SqlDataAdapter DA = new SqlDataAdapter(SQL, OPM_BL.DefaultConnectionString); DataTable DTRole = new DataTable(); DA.Fill(DTRole); cmb.DataSource = DTRole; cmb.ValueField = "ROLE_ID"; cmb.TextField = "ROLE_NAME"; cmb.DataBindItems(); //AccessDataSource2.FilterExpression = " SYS_CODE='" + SYS_CODE + "'"; //DataView dv = (DataView)AccessDataSource2.Select(DataSourceSelectArguments.Empty); //DataTable DT = dv.ToTable(); } catch (Exception ex) { } }
/// <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.fmvAddresses.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); DataTable _dt = _qry.ExecuteDataSet().Tables[0]; IDataReader _rd1 = _qry.ExecuteReader(); _combo.DataSource = _rd1; _combo.ValueField = "EmployeeID"; _combo.ValueType = typeof(int); _combo.TextField = "Name"; _combo.DataBindItems(); } }
protected void cboLegalInvoiceArtifactType_ItemsRequestedByFilterCondition(object source, ListEditItemsRequestedByFilterConditionEventArgs e) { try { ASPxComboBox comboItemUnit = source as ASPxComboBox; XPCollection <NAS.DAL.Accounting.LegalInvoice.LegalInvoiceArtifactType> collection = new XPCollection <NAS.DAL.Accounting.LegalInvoice.LegalInvoiceArtifactType>(session); collection.SkipReturnedObjects = e.BeginIndex; collection.TopReturnedObjects = e.EndIndex - e.BeginIndex + 1; CriteriaOperator criteria = CriteriaOperator.And( CriteriaOperator.Or( new BinaryOperator("Code", String.Format("%{0}%", e.Filter), BinaryOperatorType.Like), new BinaryOperator("Name", String.Format("%{0}%", e.Filter), BinaryOperatorType.Like) ), new BinaryOperator("Description", "F", BinaryOperatorType.NotEqual), new BinaryOperator("RowStatus", 1, BinaryOperatorType.GreaterOrEqual), new BinaryOperator("Category", m_VatType, BinaryOperatorType.Equal)); collection.Criteria = criteria; collection.Sorting.Add(new SortProperty("Code", DevExpress.Xpo.DB.SortingDirection.Ascending)); comboItemUnit.DataSource = collection; comboItemUnit.DataBindItems(); } catch { } }
public void ItemsRequestedByFilterCondition(Session session, object source, DevExpress.Web.ASPxEditors.ListEditItemsRequestedByFilterConditionEventArgs e) { ASPxComboBox combo = source as ASPxComboBox; XPCollection <Department> collection = new XPCollection <Department>(session); collection.SkipReturnedObjects = e.BeginIndex; collection.TopReturnedObjects = e.EndIndex - e.BeginIndex + 1; CriteriaOperator criteria = CriteriaOperator.And( //row status is active new BinaryOperator("OrganizationId.OrganizationId", Utility.CurrentSession.Instance.AccessingOrganizationId), 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) ) ); collection.Criteria = criteria; collection.Sorting.Add(new SortProperty("Code", DevExpress.Xpo.DB.SortingDirection.Ascending)); combo.DataSource = collection; combo.DataBindItems(); }
/// <summary> /// rebind contact list when company is changed /// </summary> /// <param name="companyID">passed from comapny combo</param> protected void bind_client_contact(string companyID) { //must have a filter or display nothing if (!string.IsNullOrEmpty(companyID)) { ASPxComboBox _dxcboContact = (ASPxComboBox)this.dxgrdCourier.FindEditFormTemplateControl("dxcboClientContact"); if (_dxcboContact != null) { string[] _cols = { "ContactID, ContactName", "Email" }; string[] _order = { "ContactName" }; SqlQuery _qry = new Select(_cols).From(DAL.Logistics.Tables.ContactTable).OrderAsc(_order); int _filter = -1; if (!string.IsNullOrEmpty(companyID)) { _filter = wwi_func.vint(companyID); if (_filter > 0) { _qry.Where("CompanyID").IsEqualTo(_filter); } } IDataReader _rd1 = _qry.ExecuteReader(); _dxcboContact.DataSource = _rd1; _dxcboContact.ValueField = "ContactID"; _dxcboContact.TextField = "ContactName"; _dxcboContact.DataBindItems(); } } }
protected void cboItem_ItemsRequestedByFilterCondition(object source, DevExpress.Web.ASPxEditors.ListEditItemsRequestedByFilterConditionEventArgs e) { try { ASPxComboBox comboItemUnit = source as ASPxComboBox; XPCollection <BillItem> collection = new XPCollection <BillItem>(session); collection.SkipReturnedObjects = e.BeginIndex; collection.TopReturnedObjects = e.EndIndex - e.BeginIndex + 1; CriteriaOperator criteria = CriteriaOperator.And( CriteriaOperator.Or( new BinaryOperator("ItemUnitId.ItemId.Code", String.Format("%{0}%", e.Filter), BinaryOperatorType.Like), new BinaryOperator("ItemUnitId.ItemId.Name", String.Format("%{0}%", e.Filter), BinaryOperatorType.Like) ), new BinaryOperator("BillId.BillId", bill.BillId, BinaryOperatorType.Equal)); collection.Criteria = criteria; collection.Sorting.Add(new SortProperty("ItemUnitId.ItemId.Code", DevExpress.Xpo.DB.SortingDirection.Ascending)); comboItemUnit.DataSource = collection; comboItemUnit.DataBindItems(); } catch { } }
protected void Concepto(ASPxComboBox combo, int DescDetalle) { combo.DataSourceID = "dsConceptoPagoPor"; dsConceptoPagoPor.SelectParameters["IdDetalle"].DefaultValue = DescDetalle.ToString(); combo.DataBindItems(); combo.Items.Insert(0, new ListEditItem("", null)); }
public override void ComboBoxItem_ItemsRequestedByFilterCondition(DevExpress.Xpo.Session session, object source, DevExpress.Web.ASPxEditors.ListEditItemsRequestedByFilterConditionEventArgs e) { ASPxComboBox combo = source as ASPxComboBox; XPCollection <Item> collection = new XPCollection <Item>(session); collection.SkipReturnedObjects = e.BeginIndex; collection.TopReturnedObjects = e.EndIndex - e.BeginIndex + 1; 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) ), new ContainsOperator("ItemCustomTypes", new BinaryOperator("ObjectTypeId", ObjectType.GetDefault(session, ObjectTypeEnum.FIXED_ASSETS))) ); collection.Criteria = criteria; collection.Sorting.Add(new SortProperty("Code", DevExpress.Xpo.DB.SortingDirection.Ascending)); combo.DataSource = collection; combo.DataBindItems(); }
protected void cboAccountPeriod_ItemsRequestedByFilterCondition(object source, ListEditItemsRequestedByFilterConditionEventArgs e) { ASPxComboBox combo = source as ASPxComboBox; XPCollection <AccountingPeriod> collection = new XPCollection <AccountingPeriod>(session); collection.SkipReturnedObjects = e.BeginIndex; collection.TopReturnedObjects = e.EndIndex - e.BeginIndex + 1; AccountingPeriodTypeBO typeBO = new AccountingPeriodTypeBO(); AccountingPeriodType minAccountingPeriodType = typeBO.GetMinAccountingPeriodType(session); CriteriaOperator criteria_RowStatus = new BinaryOperator("RowStatus", Constant.ROWSTATUS_ACTIVE, BinaryOperatorType.GreaterOrEqual); CriteriaOperator criteria_IsActive = new BinaryOperator("IsActive", true, BinaryOperatorType.Equal); CriteriaOperator criteria_Type = new BinaryOperator("AccountingPeriodTypeId", minAccountingPeriodType, BinaryOperatorType.Equal); CriteriaOperator criteria = CriteriaOperator.And(criteria_IsActive, criteria_RowStatus, criteria_Type); XPCollection <AccountingPeriod> AccountingPeriodCol = new XPCollection <AccountingPeriod>(session, criteria); criteria = CriteriaOperator.And( CriteriaOperator.Or( new BinaryOperator("Code", String.Format("%{0}%", e.Filter), BinaryOperatorType.Like), new BinaryOperator("Description", String.Format("%{0}%", e.Filter), BinaryOperatorType.Like) ), new BinaryOperator("RowStatus", 1, BinaryOperatorType.GreaterOrEqual), new InOperator("this", AccountingPeriodCol) ); collection.Criteria = criteria; collection.Sorting.Add(new SortProperty("Code", DevExpress.Xpo.DB.SortingDirection.Ascending)); combo.DataSource = collection; combo.DataBindItems(); }
protected void cboBalanceInitAccount_ItemsRequestedByFilterCondition(object source, DevExpress.Web.ASPxEditors.ListEditItemsRequestedByFilterConditionEventArgs e) { ASPxComboBox comboItemUnit = source as ASPxComboBox; XPCollection <Account> collection = new XPCollection <Account>(session); collection.SkipReturnedObjects = e.BeginIndex; collection.TopReturnedObjects = e.EndIndex - e.BeginIndex + 1; XPCollection <Account> _childAccount = AccountingBO.getNotParentAccountCollection(session); CriteriaOperator _filter = CriteriaOperator.Or( new BinaryOperator("AccountTypeId.AccountCategoryId.AccountCategoryId", Guid.Parse("A5FD76BB-F0D8-40F5-ADF8-6648804BDC62"), BinaryOperatorType.Equal), new BinaryOperator("AccountTypeId.AccountCategoryId.AccountCategoryId", Guid.Parse("387208A7-8D9E-49DA-8131-A83BA97B9D6B"), BinaryOperatorType.Equal), new BinaryOperator("AccountTypeId.AccountCategoryId.AccountCategoryId", Guid.Parse("FF561A7E-00D8-4596-B46A-29064BCB09D2"), BinaryOperatorType.Equal), new BinaryOperator("AccountTypeId.AccountCategoryId.AccountCategoryId", Guid.Parse("C1EC8F33-C4F6-4312-AE4A-6F8FD3A1F5DB"), BinaryOperatorType.Equal)); _childAccount.Filter = _filter; CriteriaOperator criteria = CriteriaOperator.And( CriteriaOperator.Or( new BinaryOperator("Code", String.Format("%{0}%", e.Filter), BinaryOperatorType.Like), new BinaryOperator("Name", String.Format("%{0}%", e.Filter), BinaryOperatorType.Like) ), new BinaryOperator("RowStatus", 1, BinaryOperatorType.GreaterOrEqual), new InOperator("this", _childAccount) ); collection.Criteria = criteria; collection.Sorting.Add(new SortProperty("Code", DevExpress.Xpo.DB.SortingDirection.Ascending)); comboItemUnit.DataSource = collection; comboItemUnit.DataBindItems(); }
/// <summary> /// destination port combo filtered by VoyageID /// </summary> /// <param name="voyageid">from voyage combobox int</param> protected void bind_destination_port(int voyageId) { ASPxComboBox _combo = (ASPxComboBox)this.fmvBol.FindControl("dxcboDestinationPort"); if (_combo != null) { IDataReader _rd = null; if (voyageId > 0) { string[] _cols = { "PortTable.PortID", "PortTable.PortName", "VoyageETASubTable.ETA" }; string[] _order = { "PortName" }; SqlQuery _qry = new Select(_cols).From(DAL.Logistics.Tables.VoyageTable). InnerJoin(DAL.Logistics.VoyageETASubTable.VoyageIDColumn, DAL.Logistics.VoyageTable.VoyageIDColumn). InnerJoin(DAL.Logistics.PortTable.PortIDColumn, DAL.Logistics.VoyageETASubTable.DestinationPortIDColumn); _qry.Where(DAL.Logistics.VoyageTable.VoyageIDColumn).IsEqualTo(voyageId); _rd = _qry.ExecuteReader(); } //rebind dest ports _combo.DataSource = _rd; _combo.ValueField = "PortID"; _combo.ValueType = typeof(int); _combo.TextField = "PortName"; _combo.DataBindItems(); } }
protected void grdGeneralJournal_CellEditorInitialize(object sender, ASPxGridViewEditorEventArgs e) { if (e.Column.FieldName.Equals("Description")) { e.Editor.Focus(); } else if (e.Column.FieldName.Equals("AccountId!Key")) { ASPxComboBox accountComboBox = (ASPxComboBox)e.Editor; if (accountComboBox != null) { var accountList = AccountingBO.getNotParentAccountList(session); accountComboBox.DataSource = accountList; accountComboBox.DataBindItems(); } } //if (e.Column.FieldName.Equals("AccountId!Key")) //{ // try // { // ASPxComboBox accountCombobox = e.Editor as ASPxComboBox; // if (accountCombobox != null) // { // accountCombobox.ItemsRequestedByFilterCondition += new ListEditItemsRequestedByFilterConditionEventHandler(accountCombobox_ItemsRequestedByFilterCondition); // accountCombobox.ItemRequestedByValue += new ListEditItemRequestedByValueEventHandler(accountCombobox_ItemRequestedByValue); // } // } // catch (Exception ex) // { // } //} }
protected void bind_permission_levels() { string _path = AppDomain.CurrentDomain.BaseDirectory; _path += "xml\\ddl_items.xml"; // pass _qryFilter to have keyword-filter RSS Feed // i.e. _qryFilter = XML -> entries with XML will be returned DataSet _ds = new DataSet(); _ds.ReadXml(_path); DataView _dv = _ds.Tables[0].DefaultView; _dv.RowFilter = "ddls ='contact_permission'"; ASPxComboBox _cbo = (ASPxComboBox)this.fmvContact.FindControl("dxcboPermission"); if (_cbo != null) { _cbo.DataSource = _dv; _cbo.ValueType = typeof(int); _cbo.TextField = "name"; _cbo.ValueField = "value"; _cbo.DataBindItems(); //use datbibditems rather than databind when binding to dataview } }
public static ASPxComboBox ApplyDataSource(this ASPxComboBox source, IEnumerable dataSource) { source.DataSource = dataSource; source.DataBindItems(); return(source); }
public static ASPxComboBox ApplyCBDataSource <T>(this ASPxComboBox source, IEnumerable <T> dataSource) where T : class { source.SetComboBoxDataSource(dataSource); source.DataBindItems(); return(source); }
protected void FillSectionCombo(ASPxComboBox cmb, string SiteID) { if (SiteID == "0") return; cmb.DataSourceID = "ObjectDataSourceSection"; ObjectDataSourceSection.SelectParameters[0].DefaultValue = SiteID; cmb.DataBindItems(); cmb.Items.Insert(0, new ListEditItem("", null)); // Null Item }
void cmbChild_Callback(object sender, DevExpress.Web.ASPxClasses.CallbackEventArgsBase e) { ASPxComboBox cmbChild = (ASPxComboBox)sender; AccessDataSource cmbChildAccessDataSource = (AccessDataSource)cmbChild.NamingContainer.FindControl("asdChild"); cmbChildAccessDataSource.SelectParameters[0].DefaultValue = e.Parameter; cmbChild.DataBindItems(); }
protected void FillCitiesComboBox(ASPxComboBox combo, int countryID) { combo.DataSourceID = "Cities"; Cities.SelectParameters["CountryID"].DefaultValue = countryID.ToString(); combo.DataBindItems(); combo.Items.Insert(0, new ListEditItem("", null)); // Null Item }
private void comboboxAllocation_DataBind(ASPxComboBox combobox) { if (AllocationGetter == null) { throw new Exception("Please use SetAllocationGetter method to set AllocationGetter"); } combobox.DataSource = AllocationGetter.GetAllocationCollection(session); combobox.DataBindItems(); }
/// <summary> /// Binds the DataTable to ComboBox list with given value and text fields /// </summary> /// <param name="cmbBox">Name of the ComboBox list to process</param> /// <param name="dt">DataTable to Bind</param> /// <param name="strValue">Value field name as string</param> /// <param name="strText">Text fiels name as string</param> public static void BindDropDown(ASPxComboBox cmbBox, DataTable dt, string strValue, string strText) { // clsDataFunctionsBAL objFunctions = null; try { if (DataTableHasRows(dt)) { cmbBox.DataSource = dt; cmbBox.ValueField = strValue; cmbBox.TextField = strText; cmbBox.DataBindItems(); } } catch (Exception ex) { //objFunctions = new clsDataFunctionsBAL(); //objFunctions.SaveErrorLog(ex.Message, m_strModule, MethodBase.GetCurrentMethod().Name); } finally { // objFunctions = null; } }