fbenoist68
/
mobileportal
1
0
Fork 0
Code Issues 739 Pull Requests Packages Projects Releases Wiki Activity

[FogBugz #285] Avoirs doublés #348

New Issue
Open
opened 2023-07-04 07:13:53 +02:00 by fbenoist68 · 7 comments
fbenoist68 commented 2023-07-04 07:13:53 +02:00
Owner

Assigned To: CLOSED
Project: CAISSE
Area: awcaisse
Category: Bogue
Priority: A fixer impérativement

Assigned To: CLOSED Project: CAISSE Area: awcaisse Category: Bogue Priority: A fixer impérativement
fbenoist68 commented 2023-07-04 07:13:56 +02:00
Poster
Owner

Event ID: 1254
Date: 2014-02-14T15:42:32Z
Person: Frederik Benoist
Description: Fermé par Frederik Benoist

Event ID: 1254 Date: 2014-02-14T15:42:32Z Person: Frederik Benoist Description: Fermé par Frederik Benoist
fbenoist68 commented 2023-07-04 07:14:01 +02:00
Poster
Owner

Event ID: 1253
Date: 2014-02-14T15:42:32Z
Person: Frederik Benoist
Description: Resolved (Fixed) and assigned to Frederik Benoist by Frederik Benoist

Event ID: 1253 Date: 2014-02-14T15:42:32Z Person: Frederik Benoist Description: Resolved (Fixed) and assigned to Frederik Benoist by Frederik Benoist
fbenoist68 commented 2023-07-04 07:14:05 +02:00
Poster
Owner

Event ID: 1252
Date: 2014-02-14T15:42:21Z
Person: Frederik Benoist
Description: Modifié par Frederik Benoist

INC 247161

Event ID: 1252 Date: 2014-02-14T15:42:21Z Person: Frederik Benoist Description: Modifié par Frederik Benoist <p> INC 247161</p>
fbenoist68 commented 2023-07-04 07:14:07 +02:00
Poster
Owner

Event ID: 1251
Date: 2014-02-14T15:33:41Z
Person: Frederik Benoist
Description: Modifié par Frederik Benoist

Il fallait mettre la commande en transaction ...

Event ID: 1251 Date: 2014-02-14T15:33:41Z Person: Frederik Benoist Description: Modifié par Frederik Benoist <p> Il fallait mettre la commande en transaction ...</p>
fbenoist68 commented 2023-07-04 07:14:12 +02:00
Poster
Owner

Event ID: 1250
Date: 2014-02-14T15:32:29Z
Person: Frederik Benoist
Description: Modifié par Frederik Benoist

C:\projets\DotSoft\CaisseAuto\bSqlDao\DAO\cEcommerceBASqlDAO.vb

 

Public Overrides Sub mCreer(ByRef entite As cEcommerceBa, Optional ByVal transac As IDbTransaction = Nothing)

Dim builder As New cInsertQueryBuilder(vNomTableSource)

builder.mInsert("code", entite.pCode)

builder.mInsert("date_debut", entite.pDateDebut)

builder.mInsert("date_fin", entite.pDateFin)

builder.mInsert("fdate", entite.pFDate)

builder.mInsert("id_client", entite.pIdClient)

builder.mInsert("id_devise", entite.pIdDevise)

builder.mInsert("id_distrib", entite.pIdDistrib)

builder.mInsert("id_employe", entite.pIdEmploye)

builder.mInsert("id_facturec", entite.pIdFactureC)

builder.mInsert("id_structure", entite.pIdStructure)

builder.mInsert("montant_BA_encours", entite.pMontantBonAchatEncours)

builder.mInsert("montant_BA_initial", entite.pMontantBonAchatInitial)

builder.mInsert("type_ba", entite.pTypeBa)

builder.mInsert("validite_ba_mois", entite.pValiditeBAMois)

 

Using commande As DbCommand = builder.mCreerCommande("id_ba")

'Me.pBdd.mExecuteNonQuery(commande)

mExecuteNonQuery(commande, transac) ' FB 14/02/2014

entite.pIdBa = CInt(commande.Parameters(14).Value)

End Using

If (transac IsNot Nothing) Then mAddRollback(mInsertRollback(entite), transac)

End Sub

Event ID: 1250 Date: 2014-02-14T15:32:29Z Person: Frederik Benoist Description: Modifié par Frederik Benoist <p> C:\projets\DotSoft\CaisseAuto\bSqlDao\DAO\cEcommerceBASqlDAO.vb</p> <p> &nbsp;</p> <p> Public Overrides Sub mCreer(ByRef entite As cEcommerceBa, Optional ByVal transac As IDbTransaction = Nothing)</p> <p> Dim builder As New cInsertQueryBuilder(vNomTableSource)</p> <p> builder.mInsert(&quot;code&quot;, entite.pCode)</p> <p> builder.mInsert(&quot;date_debut&quot;, entite.pDateDebut)</p> <p> builder.mInsert(&quot;date_fin&quot;, entite.pDateFin)</p> <p> builder.mInsert(&quot;fdate&quot;, entite.pFDate)</p> <p> builder.mInsert(&quot;id_client&quot;, entite.pIdClient)</p> <p> builder.mInsert(&quot;id_devise&quot;, entite.pIdDevise)</p> <p> builder.mInsert(&quot;id_distrib&quot;, entite.pIdDistrib)</p> <p> builder.mInsert(&quot;id_employe&quot;, entite.pIdEmploye)</p> <p> builder.mInsert(&quot;id_facturec&quot;, entite.pIdFactureC)</p> <p> builder.mInsert(&quot;id_structure&quot;, entite.pIdStructure)</p> <p> builder.mInsert(&quot;montant_BA_encours&quot;, entite.pMontantBonAchatEncours)</p> <p> builder.mInsert(&quot;montant_BA_initial&quot;, entite.pMontantBonAchatInitial)</p> <p> builder.mInsert(&quot;type_ba&quot;, entite.pTypeBa)</p> <p> builder.mInsert(&quot;validite_ba_mois&quot;, entite.pValiditeBAMois)</p> <p> &nbsp;</p> <p> Using commande As DbCommand = builder.mCreerCommande(&quot;id_ba&quot;)</p> <p> &#39;Me.pBdd.mExecuteNonQuery(commande)</p> <p> mExecuteNonQuery(commande, transac) &#39; FB 14/02/2014</p> <p> entite.pIdBa = CInt(commande.Parameters(14).Value)</p> <p> End Using</p> <p> If (transac IsNot Nothing) Then mAddRollback(mInsertRollback(entite), transac)</p> <p> End Sub</p>
fbenoist68 commented 2023-07-04 07:14:19 +02:00
Poster
Owner

Event ID: 1249
Date: 2014-02-14T15:31:42Z
Person: Frederik Benoist
Description: Attribué à Frederik Benoist par Frederik Benoist

Event ID: 1249 Date: 2014-02-14T15:31:42Z Person: Frederik Benoist Description: Attribué à Frederik Benoist par Frederik Benoist
fbenoist68 commented 2023-07-04 07:14:26 +02:00
Poster
Owner

Event ID: 1248
Date: 2014-02-14T15:31:42Z
Person: Frederik Benoist
Description: Ouvert par Frederik Benoist

Event ID: 1248 Date: 2014-02-14T15:31:42Z Person: Frederik Benoist Description: Ouvert par Frederik Benoist
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
main
Labels
Clear labels
No items
No Label
Milestone
Clear milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
No Assignees
1 Participants
Notifications
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: fbenoist68/mobileportal#348
There is no content yet.
Delete Branch "%!s(<nil>)"

Deleting a branch is permanent. Although the deleted branch may exist for a short time before cleaning up, in most cases it CANNOT be undone. Continue?