StrataFrame Forum » StrataFrame Application Framework - V1 » WinForms (How do I?) » Browse Dialog does not show Custom Property in ListView

Browse Dialog does not show Custom Property in ListView

Luiz Lima — Thu, 11 Feb 2010 10:16:58 GMT

Hi,

I´ve read in the post below that Ed says about configure a CFP to shows.

http://forum.strataframe.net/Topic17056-7-1.aspx

I configured my CFP and implemented this code below, but BD does not show my field on list.

''' <summary>

''' NOME DO VENDEDOR CUSTOM PROPERTY

''' </summary>

''' <remarks></remarks>

<Browsable(False), _

BusinessFieldDisplayInEditor(), _

Description("Nome do Vendedor"), _

DesignerSerializationVisibility(DesignerSerializationVisibility.Hidden)> _

Public ReadOnly Property [GET_ven_nome]() As System.String

Get

Dim loCommand As New SqlClient.SqlCommand()

'-- Build the command

loCommand.CommandText = "SELECT ven_nome from tb_vendedor where ven_cod = @ven_cod"

'-- Create and set the parameters

loCommand.Parameters.Add("@ven_cod", SqlDbType.Int)

loCommand.Parameters("@ven_cod").Value = Me.ven_cod

'-- Execute the query and return the value

Return CType(Me.ExecuteScalar(loCommand), String)

End Get

End Property

Some help?

RE: Browse Dialog does not show Custom Property in ListView

Luiz Lima — Thu, 11 Feb 2010 10:16:58 GMT

Trent,

I will try to test the new version and see how the project works.

Tks a lot again

RE: Browse Dialog does not show Custom Property in ListView

Trent L. Taylor — Thu, 11 Feb 2010 08:05:34 GMT

Really the best option is to move forward. There is not any way for us to make a change on your existing version. The only other option is to try and implement something outside of the framework or possibly in a BrowseDialog information panel, which may meet your needs.

RE: Browse Dialog does not show Custom Property in ListView

Luiz Lima — Thu, 11 Feb 2010 07:00:13 GMT

Guys,

I wanna move to the new version, but I´m afraid.
Is there a possibility to get problems in some code implemented in my project?

We don´t use ChildForm, we use devexpress to edit on grid.
We have almost 80 forms.
We work with a lot of BD.

I hope some advise from you,

Tks

RE: Browse Dialog does not show Custom Property in ListView

Luiz Lima — Mon, 08 Feb 2010 15:53:39 GMT

Ivan and Trent,

I should to move to new version but I have a lot of work to do in this moment, and also we use a USB NIC to share the same license :blush:
Sincerly, I´m afraid to change to new version, if my project stop it? (please don´t laught... but in other framework, this is a reallity).

PS: Sorry again by my english... rs

See ya

RE: Browse Dialog does not show Custom Property in ListView

Trent L. Taylor — Mon, 08 Feb 2010 13:31:28 GMT

I will have to go back and look to see what version that was implemented, but I would strongly suggest moving to 1.7.0.6. There have been many new features and fixes since 1.6.6!

RE: Browse Dialog does not show Custom Property in ListView

Ivan George Borges — Mon, 08 Feb 2010 12:56:26 GMT

Hi Luiz!

You are sticking to an older version?

RE: Browse Dialog does not show Custom Property in ListView

Luiz Lima — Mon, 08 Feb 2010 12:36:09 GMT

Trent,

The overidetable property are available on version 1.6.6.0?

Tks

RE: Browse Dialog does not show Custom Property in ListView

Trent L. Taylor — Fri, 05 Feb 2010 08:13:45 GMT

Luiz,

The BrowseDialog control has two properties that allow you to override the table (or view in this case) that will be used to retrieve the records. They are the OverrideSearchTableName and OverrideSearchTableSchema (I think :D). Anyway, these two properties allow you to query a view or another table. This feature gives you the ultimate flexibility in what to query server side including joining in tables, etc. I have posted a link below on the forum to a thread I think you should read as well as a sample that may help.

http://forum.strataframe.net/FindPost24299.aspx

RE: Browse Dialog does not show Custom Property in ListView

Luiz Lima — Fri, 05 Feb 2010 07:07:06 GMT

Ed,

Tks a lot again... surprise? no man, i´m ecstically:w00t:
I came from Cobol, Delphi, Centura... but now.. SF... o GOSH!!!!! (Tks Trent!!!!!! :cool:)

Let´s come back to my problem..:P

1-) CFP was so slowly (I will implement view)
2-) There´s no way to search by CFP (the error is: The given key was not present in the dictionary), normal because the field does not exist in Sql table.
3-) I will implement a view to obtain performance, but I have problems with copy from BoView to FormBo because views has more columns than the original BO (boForm)

Can you help me?

Tks

RE: Browse Dialog does not show Custom Property in ListView

Edhy Rijo — Thu, 04 Feb 2010 22:13:14 GMT

Hi Luiz,

Glad you are moving forward, you will be surprise how nice this is handle by SF :hehe:

RE: Browse Dialog does not show Custom Property in ListView

Trent L. Taylor — Thu, 04 Feb 2010 18:57:21 GMT

Good to hear! :)

RE: Browse Dialog does not show Custom Property in ListView

Luiz Lima — Thu, 04 Feb 2010 18:56:40 GMT

Ed,

Now it´s working, CFP appears on BD Editor.
Tomorrow I will test the performance and I tell you ok?

The problem was solved with these imports inside BO file.

Imports MicroFour.StrataFrame.UI.Windows.Forms
Imports System.ComponentModel

Tks a lot!

RE: Browse Dialog does not show Custom Property in ListView

Edhy Rijo — Mon, 01 Feb 2010 11:17:13 GMT

Hi Luiz,

Look again in the SF help on how to create a Custom Field Property, somewhere you have it wrong.

Here is a sample of several CFPs I have in one of my BO:

[codesnippet]
Protected Overrides Function GetCustomBindablePropertyDescriptors() As FieldPropertyDescriptor()
' Create and return a new array of FieldPropertyDescriptor objects that contains
' the ReflectionPropertyDescriptor for the Custom Fields.
Return New FieldPropertyDescriptor() _
{New ReflectionPropertyDescriptor("cfp_CardName", GetType(bizTransactionItems)), _
New ReflectionPropertyDescriptor("cfp_CardLotNumberWithPrefix", GetType(bizTransactionItems)), _
New ReflectionPropertyDescriptor("cfp_CardEndSerialNumber", GetType(bizTransactionItems)), _
New ReflectionPropertyDescriptor("cfp_CardDescription_ForListView", GetType(bizTransactionItems)), _
New ReflectionPropertyDescriptor("cfp_CardEndSerialNumber_ForListView", GetType(bizTransactionItems)), _
New ReflectionPropertyDescriptor("cfp_CardLotNumberWithPrefix_ForListView", GetType(bizTransactionItems))}
End Function

'''

''' Combines the CardLotNoPrefix with the CardLotNumber.
'''

'''
''' The Lot Number formatted with a prefix if not empty.
'''
BusinessFieldDisplayInEditor(), _
Description("Combines the CardLotNoPrefix with the CardLotNumber."), _
DesignerSerializationVisibility(DesignerSerializationVisibility.Hidden)> _
Public Overridable ReadOnly Property [cfp_CardLotNumberWithPrefix_ForListView]() As String
Get
If _CardBOLookup.Count = 0 Then
_CardBOLookup.FillByActiveRecordsAndITemType(BusinessEditingState.Idle, bizItems.bizItemsFieldNames.ItemIsInactive.ToString, Enumerations.ItemType.CallingCard)
End If

If _CardBOLookup.Count > 0 AndAlso _CardBOLookup.SeekToPrimaryKey(Me.FK_Items) Then
If Not String.IsNullOrEmpty(_CardBOLookup.CardLotNoPrefix) Then
Return String.Format("{0}-{1}", _CardBOLookup.CardLotNoPrefix, Me.CardLotNo.Trim)
Else
Return Me.CardLotNo
End If
Else
Return Me.CardLotNo
End If
End Get
End Property

BusinessFieldDisplayInEditor(), _
Description("Card Lot Number with any Prefix if exist."), _
DesignerSerializationVisibility(DesignerSerializationVisibility.Hidden)> _
Public Overridable ReadOnly Property [cfp_CardLotNumberWithPrefix]() As String
Get
Return CType(Me.CurrentRow.Item("cfp_CardLotNumberWithPrefix"), System.String)
End Get
End Property

[/codesnippet]

In the CFP definition you can have any code you want to return the proper value, or like in the case of "cfp_CardLotNumberWithPrefix" here you can simply return the column from the CurrentRow which is what I do when using a SELECT statement with a JOIN table to return the FK field description I need, so in reality you DO NOT NEED A VIEW, you can use a stored procedure to get the data for any BO and have any JOIN condition in your SP and then use a CFP like "cfp_CardLotNumberWithPrefix" and when the BO is filled, its data table will have that column "cfp_CardLotNumberWithPrefix" available which the CFP will read.

I know this could be confusing at first, but at the end is very simple and it works.

RE: Browse Dialog does not show Custom Property in ListView

Luiz Lima — Mon, 01 Feb 2010 10:28:36 GMT

Edhy,

First of all, I can´t see CFP in BD (Design Mode), it only shows fields from database table.
I made a test with BD RowPopulate Event, gosh.. so slow.. I thought if CFP would work like that.
If performance working almost like a Subquery. Ok... I will continue trying to use CFP.

What do you tell me?

Tks a lot

RE: Browse Dialog does not show Custom Property in ListView

Edhy Rijo — Sun, 31 Jan 2010 20:08:39 GMT

Hi Luiz,

Let's clear one thing, are you able to see the CFP in the BD type editor? that would be the first thing to fix, then if so let see how to incorporate the data using a view or something else, but first let me know if you can see the CFP?

RE: Browse Dialog does not show Custom Property in ListView

Luiz Lima — Sun, 31 Jan 2010 19:42:45 GMT

Trent,

I read your post today before post my replies here, in a future I will implement incremental search with thread on my system, but at this point my problem is the time that I will spend to implement the change.
Maybe BO View will be the solution, not simple to implement but faster than another.

PS: Sorry by my english

Tks

RE: Browse Dialog does not show Custom Property in ListView

Trent L. Taylor — Sun, 31 Jan 2010 19:15:53 GMT

Luiz,

I am not sure what you are trying to accomplish at this point. But I know that the custom property will work if there is data to back it up. Also, is this a scenario where an incremental search could work for you? I posted a sample of how to perform a threaded incremental search today. You can find it here:

http://forum.strataframe.net/FindPost25669.aspx

RE: Browse Dialog does not show Custom Property in ListView

Luiz Lima — Sun, 31 Jan 2010 19:08:35 GMT

Edhy

I´m still with the problem, but I was thinking.... it will be slow because the tables sometimes have thousand of records.
Using view for me it´s a very hard work, imagine that I have 20 bd to handle?
The whole process is:

- create a view with DDT
- generate the BOs with BOM
- make changes on BD after close event to copy the whole content of a view (not only one record) to PrimaryBo of the Form.

Very hard, insn´t it?
I´ve tried to use copydatafrom() but it return errors because my View has more fields than BO
Is there another way?

Tks

RE: Browse Dialog does not show Custom Property in ListView

Trent L. Taylor — Sat, 30 Jan 2010 09:27:45 GMT

Luiz,

Did you override the GetCustomBindablePropertyDescriptors and add your new property to the array returned there? If you have not done that, it will not show up within any binding segment of the code.

RE: Browse Dialog does not show Custom Property in ListView

Edhy Rijo — Fri, 29 Jan 2010 12:36:38 GMT

Hi Luiz,

I don't see any problem with your code.

Now keep in mind that CFP could be an slow solution when you are returning many records because of the Scalar method being called per each record/row.

In case of many records, a view will be easier to manage and much more faster. If you use the SF DDT you can create your view definition in DDT and use the BO with the view to get the table structure correct.

There are many other approaches you can use. Do a search in the forum using the word "slow" and you will find many threads.

RE: Browse Dialog does not show Custom Property in ListView

Luiz Lima — Fri, 29 Jan 2010 12:05:36 GMT

Edhy,

I will check my project.
Tel me.... Is my code correct?
I don´t wanna work with view, this is very hard work to manage.. :)
And about the performance and we work with CFP?

I made a test with BD populate event, oh Gosh... so slow.....

tks

RE: Browse Dialog does not show Custom Property in ListView

Edhy Rijo — Fri, 29 Jan 2010 11:46:45 GMT

[quote][b]Luiz Lima (01/29/2010)[/b][hr]I configured my CFP and implemented this code below, but BD does not show my field on list.[/quote]

Hi Luiz,

Make sure you build your project or solution whenever making changes that will be use in a type editor like BD, or the property window.