/// <summary> /// databind origins list /// </summary> protected void bind_cbo_origin() { Query _qry = new Query(DAL.Pricer.Tables.PricerOriginPoint, "pricerprov").AddWhere("origin_point_id", Comparison.GreaterThan, 0).ORDER_BY("origin_point", "asc"); PricerOriginPointCollection _origins = new PricerOriginPointCollection(); _origins.LoadAndCloseReader(_qry.ExecuteReader()); DataTable _dt = (DataTable)_origins.ToDataTable(); this.dxcborigin.DataSource = _dt; this.dxcborigin.ValueField = "origin_point_id"; this.dxcborigin.TextField = "origin_point"; this.dxcborigin.DataBind(); }
/// <summary> /// databind origins list /// this is called when country changed /// or /// cbfinal has focus AND no data items /// </summary> protected void bind_cbo_origin() { //get company group or default to 0 Int32 _cg = check_group(); //wwi_func.get_company_group(); Query _qry = new Query(DAL.Pricer.Tables.PricerOriginPoint, "pricerprov").AddWhere("origin_point_id", Comparison.GreaterThan, 0).AND("company_group", Comparison.Equals, _cg).ORDER_BY("origin_point", "asc"); PricerOriginPointCollection _origins = new PricerOriginPointCollection(); _origins.LoadAndCloseReader(_qry.ExecuteReader()); DataTable _dt = (DataTable)_origins.ToDataTable(); this.dxcborigin.DataSource = _dt; this.dxcborigin.ValueField = "origin_point_id"; this.dxcborigin.TextField = "origin_point"; this.dxcborigin.DataBind(); }