Shulou(Shulou.com)06/03 Report--

1. Obtain or modify the field data of the interface EpiDataView (Get EpiDataView data)

C#

EpiDataView edv = (EpiDataView) oTrans.EpiDataViews ["ViewName"]

If (edv.dataView.Count > 0)

{

String someValue = (string) edv.dataView [edv.Row] ["FieldName"]

Edv.dataView [edv.Row] ["FieldName"] = someValue

}

- -

VB

Dim edv As EpiDataView = CType (oTrans.EpiDataViews ("ViewName"), EpiDataView)

If edv.DataView.Count > 0 then

Dim someValue as string = [edv] .dataView ([edv] .Row) ("FieldName")

[edv] .dataView ([edv] .Row) ("FieldName") = someValue

End if

If you have multiple rows of data in EpiDataView, such as incoming po suggestion or purchase suggestion, you can get the value by specifying the line number in the following format

Count rows: edv.DataView.Count

Take the value of line 100: [edv] .dataView (99) ("FieldName")

2. Obtain Session field data (Get Session data)

C#

Add reference Epicor.Mfg.Core.Session.dll

Using Epicor.Mfg.Core

String UserID = (Epicor.Mfg.Core.Session) this.oTrans.Session) .UserID

String CompanyID = (Epicor.Mfg.Core.Session) this.oTrans.Session) .CompanyID

E10

Ice.Core.Session.dll

Using Ice.Core

String UserID = (Ice.Core.Session) this.oTrans.Session) .UserID

3. Call adapter calls the GetByID method of adapter to obtain or update the data in adapter. The corresponding Adapter must be referenced before using it.

C#

Note that E10 plus Adapter needs to add using Erp.Adapters at the beginning

PartAdapter adpPart = new PartAdapter (this.oTrans)

AdpPart.BOConnect ()

AdpPart.GetByID ("PART0001")

String PartDescription = adpPart.PartData.Tables ["Part"] .Rows [0] ["PartDescription"]

AdpPart.PartData.Tables ["Part"] .Rows [0] ["PartDescription"] = "PART0001 xxxxxx"

AdpPart.Update ()

AdpPart.Dispose ()

VB

Dim adpPart As PartAdapter = New PartAdapter (oTrans)

AdpPart.BOConnect ()

AdpPart.GetByID ("PART0001")

String PartDescription = adpPart.PartData.Tables ("Part") .Rows (0) ("PartDescription")

AdpPart.PartData.Tables ("Part") .Rows (0) ("PartDescription") = "PART0001 xxxxxx"

AdpPart.Update ()

AdpPart.Dispose ()

4. Search Data by Adapter uses adapter to query data, and the corresponding Adapter must be referenced before use.

C#

PartAdapter adpPart = new PartAdapter (this.oTrans)

AdpPart.BOConnect ()

Bool MorePages

String whereClause = "PartNum='PART0001'"

SearchOptions opts = new SearchOptions (SearchMode.AutoSearch)

Opts.NamedSearch.WhereClauses.Add ("Part", whereClause)

DataSet dsPart = adpPart.GetRows (opts, out MorePages)

Note that E10 plus Adapter needs to add using Erp.Adapters at the beginning

VB

Dim adpPart As PartAdapter = New PartAdapter (oTrans)

AdpPart.BOConnect ()

Dim MorePages As Boolean

Dim whereClause As String = "PartNum='PART0001'"

Dim opts As SearchOptions = New SearchOptions (SearchMode.AutoSearch)

Opts.NamedSearch.WhereClauses.Add ("Part", whereClause)

Dim dsPart As Data.DataSet = adpPart.GetRows (opts, MorePages)

5. Search Data by Epicor.Mfg.UI.FormFunctions.SearchFunctions uses the interface query function to query the data and return the value to the current interface EpiDataView, but the data column is only partial, similar to the query function on the standard interface, which is suitable for quickly querying basic data.

-- generate the following code using the Simple Search wizard

C#

Bool recSelected

String whereClause = string.Empty

/ / "StartDate

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.