برنامج الاكسس والفاتورة الإلكترونية لهيئة الزكاة والدخل ، وامثالها (معدل)

[العارف بالله]

ا

On 6/8/2021 at 1:21 AM, SEMO.Pa3x said:

لا حاجة لـ AscW دعنا نستخدم الفنكشنات التي تم طرحها في موضوع الترجمة هنا:

'فنكشن فك التشفير
Function DecodeQP2(s As String) As String
    Dim i As Long
    Dim p1 As Long
    Dim p2 As Long
    Dim r As String
    i = 2
    Do While i < Len(s)
        Select Case Mid(s, i, 1)
            Case "0" To "7"
            r = r & Chr(CLng("&H" & Mid(s, i, 2)))
            Case "C", "D"
            p1 = CLng("&H" & Mid(s, i, 2)) - 192
            i = i + 3
            p2 = CLng("&H" & Mid(s, i, 2)) - 128
            r = r & ChrW(64 * p1 + p2)
            Case Else
            ' Not handled
        End Select
        i = i + 3
    Loop
    DecodeQP2 = r
End Function

'فنكشن التشفير
Function EncodeQP2(s As String) As String
    Dim i As Long
    Dim p1 As Long
    Dim p2 As Long
    Dim r As String
    Dim n As Long
    For i = 1 To Len(s)
        n = AscW(Mid(s, i, 1))
        If n < 128 Then
            r = r & "%" & Hex(n)
        ElseIf n < 2048 Then
            p1 = n \ 64
            r = r & "%" & Hex(p1 + 192)
            p2 = n Mod 64
            r = r & "%" & Hex(p2 + 128)
        Else
            
        End If
    Next i
    EncodeQP2 = r
End Function

 

الـ Module في الأكسس:

Option Compare Database
Option Explicit

'--------------------------------------------------------
'c0ded bY  : SEMO.Pa3x
'telegram  : semo_pa4x
'facebook  : https://www.facebook.com/Nisr.Aln3jaf
'last edit : 26/4/2019
'--------------------------------------------------------

Private Type SECURITY_ATTRIBUTES
    nLength    As Long
    lpSecurityDescriptor As Long
    bInheritHandle As Long
End Type

Private Type PROCESS_INFORMATION
    hProcess   As Long
    hThread    As Long
    dwProcessId As Long
    dwThreadId As Long
End Type

Private Type STARTUPINFO
    cb         As Long
    lpReserved As Long
    lpDesktop  As Long
    lpTitle    As Long
    dwX        As Long
    dwY        As Long
    dwXSize    As Long
    dwYSize    As Long
    dwXCountChars As Long
    dwYCountChars As Long
    dwFillAttribute As Long
    dwFlags    As Long
    wShowWindow As Integer
    cbReserved2 As Integer
    lpReserved2 As Byte
    hStdInput  As Long
    hStdOutput As Long
    hStdError  As Long
End Type

Private Const WAIT_INFINITE         As Long = (-1&)
Private Const STARTF_USESHOWWINDOW  As Long = &H1
Private Const STARTF_USESTDHANDLES  As Long = &H100
Private Const SW_HIDE               As Long = 0&

Private Declare Function CreatePipe Lib "kernel32" (phReadPipe As Long, phWritePipe As Long, lpPipeAttributes As SECURITY_ATTRIBUTES, ByVal nSize As Long) As Long
Private Declare Function CreateProcess Lib "kernel32" Alias "CreateProcessA" (ByVal lpApplicationName As Long, ByVal lpCommandLine As String, lpProcessAttributes As Any, lpThreadAttributes As Any, ByVal bInheritHandles As Long, ByVal dwCreationFlags As Long, lpEnvironment As Any, ByVal lpCurrentDriectory As String, lpStartupInfo As STARTUPINFO, lpProcessInformation As PROCESS_INFORMATION) As Long
Private Declare Function ReadFile Lib "kernel32" (ByVal hFile As Long, lpBuffer As Any, ByVal nNumberOfBytesToRead As Long, lpNumberOfBytesRead As Long, lpOverlapped As Any) As Long
Private Declare Function CloseHandle Lib "kernel32" (ByVal hObject As Long) As Long
Private Declare Function WaitForSingleObject Lib "kernel32" (ByVal hHandle As Long, ByVal dwMilliseconds As Long) As Long
Private Declare Function GetExitCodeProcess Lib "kernel32" (ByVal hProcess As Long, lpExitCode As Long) As Long
Private Declare Sub GetStartupInfo Lib "kernel32" Alias "GetStartupInfoA" (lpStartupInfo As STARTUPINFO)
Private Declare Function GetFileSize Lib "kernel32" (ByVal hFile As Long, lpFileSizeHigh As Long) As Long

Private Function Redirect(szBinaryPath As String, szCommandLn As String) As String
    
    Dim tSA_CreatePipe              As SECURITY_ATTRIBUTES
    Dim tSA_CreateProcessPrc        As SECURITY_ATTRIBUTES
    Dim tSA_CreateProcessThrd       As SECURITY_ATTRIBUTES
    Dim tSA_CreateProcessPrcInfo    As PROCESS_INFORMATION
    Dim tStartupInfo                As STARTUPINFO
    Dim hRead                       As Long
    Dim hWrite                      As Long
    Dim bRead                       As Long
    Dim abytBuff()                  As Byte
    Dim lngResult                   As Long
    Dim szFullCommand               As String
    Dim lngExitCode                 As Long
    Dim lngSizeOf                   As Long
    
    tSA_CreatePipe.nLength = Len(tSA_CreatePipe)
    tSA_CreatePipe.lpSecurityDescriptor = 0&
    tSA_CreatePipe.bInheritHandle = True
    
    tSA_CreateProcessPrc.nLength = Len(tSA_CreateProcessPrc)
    tSA_CreateProcessThrd.nLength = Len(tSA_CreateProcessThrd)
    
    If (CreatePipe(hRead, hWrite, tSA_CreatePipe, 0&) <> 0&) Then
        tStartupInfo.cb = Len(tStartupInfo)
        GetStartupInfo tStartupInfo
        
        With tStartupInfo
            .hStdOutput = hWrite
            .hStdError = hWrite
            .dwFlags = STARTF_USESHOWWINDOW Or STARTF_USESTDHANDLES
            .wShowWindow = SW_HIDE
        End With
        
        szFullCommand = """" & szBinaryPath & """" & " " & szCommandLn
        lngResult = CreateProcess(0&, szFullCommand, tSA_CreateProcessPrc, tSA_CreateProcessThrd, True, 0&, 0&, vbNullString, tStartupInfo, tSA_CreateProcessPrcInfo)
        
        If (lngResult <> 0&) Then
            lngResult = WaitForSingleObject(tSA_CreateProcessPrcInfo.hProcess, WAIT_INFINITE)
            lngSizeOf = GetFileSize(hRead, 0&)
            If (lngSizeOf > 0) Then
                ReDim abytBuff(lngSizeOf - 1)
                If ReadFile(hRead, abytBuff(0), UBound(abytBuff) + 1, bRead, ByVal 0&) Then
                    Redirect = StrConv(abytBuff, vbUnicode)
                End If
            End If
            Call GetExitCodeProcess(tSA_CreateProcessPrcInfo.hProcess, lngExitCode)
            CloseHandle tSA_CreateProcessPrcInfo.hThread
            CloseHandle tSA_CreateProcessPrcInfo.hProcess
            
            If (lngExitCode <> 0&) Then Err.Raise vbObject + 1235&, "GetExitCodeProcess", "Non-zero Application exist code"
            
            CloseHandle hWrite
            CloseHandle hRead
        Else
            Err.Raise vbObject + 1236&, "CreateProcess", "CreateProcess Failed, Code: " & Err.LastDllError
        End If
    End If
End Function

Public Function MainRedirect(param As String)
    Dim resp As String
    resp = Redirect(CurrentProject.Path & "\" & "app.exe", EncodeQP2(param))
    MainRedirect = DecodeQP2(resp)
End Function

Function DecodeQP2(s As String) As String
    Dim i As Long
    Dim p1 As Long
    Dim p2 As Long
    Dim r As String
    i = 2
    Do While i < Len(s)
        Select Case Mid(s, i, 1)
            Case "0" To "7"
            r = r & Chr(CLng("&H" & Mid(s, i, 2)))
            Case "C", "D"
            p1 = CLng("&H" & Mid(s, i, 2)) - 192
            i = i + 3
            p2 = CLng("&H" & Mid(s, i, 2)) - 128
            r = r & ChrW(64 * p1 + p2)
            Case Else
            ' Not handled
        End Select
        i = i + 3
    Loop
    DecodeQP2 = r
End Function

Function EncodeQP2(s As String) As String
    Dim i As Long
    Dim p1 As Long
    Dim p2 As Long
    Dim r As String
    Dim n As Long
    For i = 1 To Len(s)
        n = AscW(Mid(s, i, 1))
        If n < 128 Then
            r = r & "%" & Hex(n)
        ElseIf n < 2048 Then
            p1 = n \ 64
            r = r & "%" & Hex(p1 + 192)
            p2 = n Mod 64
            r = r & "%" & Hex(p2 + 128)
        Else
            
        End If
    Next i
    EncodeQP2 = r
End Function

 

الإستدعاء:

Private Sub cmd_send_Click()
    MsgBox MainRedirect("السلام عليكم")
End Sub

 

لاحظ ان النص تم تشفيره وفكه في الـ Module وليس في الإستدعاء..

 

التطبيق المساعد بلغة NET.

Module Module1

    Sub Main()

        For Each arg As String In My.Application.CommandLineArgs
            Select Case DecodeQP2(arg)
                Case "السلام عليكم"
                    Console.WriteLine(EncodeQP2("عليكم السلام ورحمة الله وبركاته"))
                Case "كيف حالك"
                    Console.WriteLine(EncodeQP2("الحمدلله"))
                Case Else
                    Console.WriteLine(EncodeQP2("لم تقم بإرسال سؤال"))
            End Select
        Next
    End Sub

    Function DecodeQP2(s As String) As String
        Dim i As Long
        Dim p1 As Long
        Dim p2 As Long
        Dim r As String
        i = 2
        Do While i < Len(s)
            Select Case Mid(s, i, 1)
                Case "0" To "7"
                    r = r & Chr(CLng("&H" & Mid(s, i, 2)))
                Case "C", "D"
                    p1 = CLng("&H" & Mid(s, i, 2)) - 192
                    i = i + 3
                    p2 = CLng("&H" & Mid(s, i, 2)) - 128
                    r = r & ChrW(64 * p1 + p2)
                Case Else
                    ' Not handled
            End Select
            i = i + 3
        Loop
        DecodeQP2 = r
    End Function

    Function EncodeQP2(s As String) As String
        Dim i As Long
        Dim p1 As Long
        Dim p2 As Long
        Dim r As String
        Dim n As Long
        For i = 1 To Len(s)
            n = AscW(Mid(s, i, 1))
            If n < 128 Then
                r = r & "%" & Hex(n)
            ElseIf n < 2048 Then
                p1 = n \ 64
                r = r & "%" & Hex(p1 + 192)
                p2 = n Mod 64
                r = r & "%" & Hex(p2 + 128)
            Else

            End If
        Next i
        EncodeQP2 = r
    End Function

End Module

 

النتيجة:

تغلبنا على مشكلة اللغة العربية في الكونسول..

ملاحظة مهمة:

أغلق الأنتي فايروس قبل التجربة لإن الدالة ( CreateProcessA ) يصنفها الأنتي فايروس كدالة مشبوهة لإنها تقوم بإنشاء عملية في النظام

لمن يريد التجربة ارفقت لكم ملفات المشروع كاملة..

تحياتي لكم..

 

app.rar 42.21 kB · 43 downloads

تظهر لي هذه المشكلة

كما في الصورة المرفقة

[jjafferr]

12 ساعات مضت, العارف بالله said:

تظهر لي هذه المشكلة

 

هنا الحل

 

جعفر

[سعيد محمد1]

لدينا حل ربط نظام بالاكسس MS Access مايكروسوفت مع هيئة الزكاة والضريبة والجمارك للتواصل 0546710242  او على الايميل said.solution1@gamil.com

 

فواتير إلكترونية (Electronic Invoices)

الهيئة الزكوية والضريبية (Zakat and Tax Authority)

ربط الأنظمة (System Integration)

إدارة الفواتير (Invoice Management)

تحول رقمي (Digital Transformation)

تكامل الأنظمة (System Integration)

تقارير ضريبية (Tax Reports)

الامتثال الضريبي (Tax Compliance)

تقنيات الذكاء الاصطناعي (AI Technologies)

إصدار الفواتير (Invoice Issuance)

 

Electronic Invoicing

ZATCA Integration

Tax Compliance

System Integration

Invoice Management

Digital Transformation

Tax Reports

AI Technologies

Invoice Issuance

Tax Authority

ZATCA Integration

Electronic Invoices Saudi Arabia

Tax Compliance Software

Digital Transformation in Tax

Zakat and Tax Authority Integration

AI in Tax Reporting

Invoice Management Solutions

Saudi Arabia Tax Invoicing

System Integration for ZATCA

Compliance with ZATCA Regulations