Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Private Sub addReceiveCommand(ByVal pBranchCode As String _
- , ByVal pReceiveNo As String _
- , ByVal pSupplierName As String _
- , ByVal pRemarks As String _
- , ByVal pDNORM_Subtotal As Double _
- , ByVal pGSTPercent As Double _
- , ByVal pDNORM_GSTAmount As Double _
- , ByVal pDNORM_GrandTotal As Double _
- , ByVal pOrderNo As String _
- , ByVal pIsDiscount01 As Boolean _
- , ByVal pIsDiscountByPercent01 As Boolean _
- , ByVal pIsDiscountByAmount01 As Boolean _
- , ByVal pDiscountedPercent01 As Double _
- , ByVal pDiscountedAmount01 As Double _
- , ByVal pIsDiscount02 As Boolean _
- , ByVal pIsDiscountByPercent02 As Boolean _
- , ByVal pIsDiscountByAmount02 As Boolean _
- , ByVal pDiscountedPercent02 As Double _
- , ByVal pDiscountedAmount02 As Double _
- , ByVal pIsPaid As Boolean _
- , ByVal pPaidRemarks As String _
- , ByVal pIsIssuesPending As Boolean _
- , ByVal pIssuesPendingRemarks As String _
- , ByVal pIsReceiveOrderForPendingCostPrice As Boolean _
- , ByVal pOtherCostPrice As Double _
- , ByVal pActualDate As DateTime _
- , ByVal pCreatedBy As String _
- , ByVal pCreatedDate As DateTime _
- , ByVal pUpdatedBy As String _
- , ByVal pUpdatedDate As DateTime _
- , ByVal pGSTInclusive As Boolean _
- , ByVal pTaxCode As String _
- , ByVal pBranchSysId As String _
- , ByVal pConnection As SqlConnection _
- , ByVal pTransaction As SqlTransaction)
- '--------------------
- Dim sSql As String _
- = "INSERT INTO T_ReceiveBranch (SysId,ReceiveNo,BranchCode,SupplierName,Remarks,DNORM_Subtotal,GSTPercent,DNORM_GSTAmount,DNORM_GrandTotal,OrderNo,IsDiscount01,IsDiscountByPercent01,IsDiscountByAmount01,DiscountedPercent01,DiscountedAmount01,IsDiscount02,IsDiscountByPercent02,IsDiscountByAmount02,DiscountedPercent02,DiscountedAmount02,IsPaid,PaidRemarks,IsIssuesPending,IssuesPendingRemarks,IsReceiveOrderForPendingCostPrice,OtherCostPrice,ActualDate,CreatedDate,CreatedBy,UpdatedDate,UpdatedBy,BranchSysId,IsCSV_Add,GSTInclusive,TaxCode)" _
- & " VALUES (newid(),@0,@1,@2,@3,@4,@5,@6,@7,@8,@9,@10,@11,@12,@13,@14,@15,@16,@17,@18,@19,@20,@21,@22,@23,@24,@25,@26,@27,@28,@29,@30,0,@31,@32)"
- Dim cmdSQL As New SqlCommand
- '--------------------
- With cmdSQL
- .CommandType = CommandType.Text
- .CommandText = sSql
- '--------------------
- .Parameters.Add(New SqlParameter("@0", SqlDbType.NVarChar))
- .Parameters.Item(0).Value = pReceiveNo
- '--------------------
- .Parameters.Add(New SqlParameter("@1", SqlDbType.NVarChar))
- .Parameters.Item(1).Value = pBranchCode
- '--------------------
- .Parameters.Add(New SqlParameter("@2", SqlDbType.NVarChar))
- .Parameters.Item(2).Value = pSupplierName
- '--------------------
- .Parameters.Add(New SqlParameter("@3", SqlDbType.NVarChar))
- .Parameters.Item(3).Value = pRemarks
- '--------------------
- .Parameters.Add(New SqlParameter("@4", SqlDbType.Decimal))
- .Parameters.Item(4).Value = pDNORM_Subtotal
- '--------------------
- .Parameters.Add(New SqlParameter("@5", SqlDbType.Decimal))
- .Parameters.Item(5).Value = pGSTPercent
- '--------------------
- .Parameters.Add(New SqlParameter("@6", SqlDbType.Decimal))
- .Parameters.Item(6).Value = pDNORM_GSTAmount
- '--------------------
- .Parameters.Add(New SqlParameter("@7", SqlDbType.Decimal))
- .Parameters.Item(7).Value = pDNORM_GrandTotal
- '--------------------
- .Parameters.Add(New SqlParameter("@8", SqlDbType.NVarChar))
- .Parameters.Item(8).Value = pOrderNo
- '--------------------
- .Parameters.Add(New SqlParameter("@9", SqlDbType.Bit))
- .Parameters.Item(9).Value = pIsDiscount01
- '--------------------
- .Parameters.Add(New SqlParameter("@10", SqlDbType.Bit))
- .Parameters.Item(10).Value = pIsDiscountByPercent01
- '--------------------
- .Parameters.Add(New SqlParameter("@11", SqlDbType.Bit))
- .Parameters.Item(11).Value = pIsDiscountByAmount01
- '--------------------
- .Parameters.Add(New SqlParameter("@12", SqlDbType.Decimal))
- .Parameters.Item(12).Value = pDiscountedPercent01
- '--------------------
- .Parameters.Add(New SqlParameter("@13", SqlDbType.Decimal))
- .Parameters.Item(13).Value = pDiscountedAmount01
- '--------------------
- .Parameters.Add(New SqlParameter("@14", SqlDbType.Bit))
- .Parameters.Item(14).Value = pIsDiscount02
- '--------------------
- .Parameters.Add(New SqlParameter("@15", SqlDbType.Bit))
- .Parameters.Item(15).Value = pIsDiscountByPercent02
- '--------------------
- .Parameters.Add(New SqlParameter("@16", SqlDbType.Bit))
- .Parameters.Item(16).Value = pIsDiscountByAmount02
- '--------------------
- .Parameters.Add(New SqlParameter("@17", SqlDbType.Decimal))
- .Parameters.Item(17).Value = pDiscountedPercent02
- '--------------------
- .Parameters.Add(New SqlParameter("@18", SqlDbType.Decimal))
- .Parameters.Item(18).Value = pDiscountedAmount02
- '--------------------
- .Parameters.Add(New SqlParameter("@19", SqlDbType.Bit))
- .Parameters.Item(19).Value = pIsPaid
- '--------------------
- .Parameters.Add(New SqlParameter("@20", SqlDbType.NVarChar))
- .Parameters.Item(20).Value = pPaidRemarks
- '--------------------
- .Parameters.Add(New SqlParameter("@21", SqlDbType.Bit))
- .Parameters.Item(21).Value = pIsIssuesPending
- '--------------------
- .Parameters.Add(New SqlParameter("@22", SqlDbType.NVarChar))
- .Parameters.Item(22).Value = pIssuesPendingRemarks
- '--------------------
- .Parameters.Add(New SqlParameter("@23", SqlDbType.Bit))
- .Parameters.Item(23).Value = pIsReceiveOrderForPendingCostPrice
- '--------------------
- .Parameters.Add(New SqlParameter("@24", SqlDbType.Decimal))
- .Parameters.Item(24).Value = pOtherCostPrice
- '--------------------
- .Parameters.Add(New SqlParameter("@25", SqlDbType.DateTime))
- .Parameters.Item(25).Value = pActualDate
- '--------------------
- .Parameters.Add(New SqlParameter("@26", SqlDbType.DateTime))
- .Parameters.Item(26).Value = pCreatedDate
- '--------------------
- .Parameters.Add(New SqlParameter("@27", SqlDbType.NVarChar))
- .Parameters.Item(27).Value = pCreatedBy
- '--------------------
- .Parameters.Add(New SqlParameter("@28", SqlDbType.DateTime))
- .Parameters.Item(28).Value = pUpdatedDate
- '--------------------
- .Parameters.Add(New SqlParameter("@29", SqlDbType.NVarChar))
- .Parameters.Item(29).Value = pUpdatedBy
- '--------------------
- .Parameters.Add(New SqlParameter("@30", SqlDbType.NVarChar))
- .Parameters.Item(30).Value = pBranchSysId
- '--------------------
- .Parameters.Add(New SqlParameter("@31", SqlDbType.Bit))
- .Parameters.Item(31).Value = pGSTInclusive
- '--------------------
- .Parameters.Add(New SqlParameter("@32", SqlDbType.NVarChar))
- .Parameters.Item(32).Value = pTaxCode
- '--------------------
- End With
- '--------------------
- executeTransactions(cmdSQL, pConnection, pTransaction)
- '--------------------
- End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement