win32gui 获取相同类名edit编辑框 获取窗口标题 遍历子窗口

最新推荐文章于 2024-07-18 16:28:43 发布
最新推荐文章于 2024-07-18 16:28:43 发布
阅读量3.3k 收藏 11
点赞数 3
分类专栏： python windows 文章标签： win32gui
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/nongcunqq/article/details/122359342
版权
python 同时被 2 个专栏收录
338 篇文章 0 订阅
订阅专栏
windows
153 篇文章 4 订阅
订阅专栏

python操作SAP登录时，遇到一个奇怪问题，在其它server运行正常的程序，换了一台server不能通过搜索框，搜索。

经过排查发现有三个相同类名的编辑框，类名为“Edit”，第二个为正确的，加入列表取中间值，搞定。

官方文档

win32gui.GetClassName(hwnd) #获取类名
win32gui.IsWindowEnabled(hwnd) #窗口是否可用，1,0
win32gui.IsWindowVisible(hwnd) #窗口是否可见 1,0
win32gui.GetWindowText(hwnd) #获取窗口标题

在这里插入图片描述

edit_list = []
def all_ok(hwnd, param):

    text = win32gui.GetClassName(hwnd)
    if text == 'Edit':
        print(hwnd,text, win32gui.IsWindowEnabled(hwnd), win32gui.IsWindowVisible(hwnd))
        edit_list.append(hwnd)
        return True

重点部分

 flt = 0
    while flt == 0:

        try:
            hwnd = win32gui.FindWindow(None, sap_version)
            flt = win32gui.FindWindowEx(hwnd, None, "Edit", None)


            print('hwnd', hwnd)
            print('flt', flt)
            win32gui.EnumChildWindows(hwnd, all_ok, None)
            flt = edit_list[1]
            print('flt', flt)
            time.sleep(3)
            print('---------------->')
        except:
            print('except============>')
            time.sleep(0.5)
    print('search_name', search_name)
    win32gui.SendMessage(flt, win32con.WM_SETTEXT, None, search_name)
    win32gui.SendMessage(flt, win32con.WM_KEYDOWN, win32con.VK_RIGHT, 0)
    win32gui.SendMessage(flt, win32con.WM_KEYUP, win32con.VK_RIGHT, 0)
    time.sleep(3)
    # 登录GUI界面

参考代码

 
import win32gui
hwnd_title = dict()
def get_all_hwnd(hwnd,mouse):
    if win32gui.IsWindow(hwnd) and win32gui.IsWindowEnabled(hwnd) and win32gui.IsWindowVisible(hwnd):
        hwnd_title.update({hwnd:win32gui.GetWindowText(hwnd)})
win32gui.EnumWindows(get_all_hwnd, 0)
 
for h,t in hwnd_title.items():
    if t is not "":
        print(h, t)

https://blog.csdn.net/gamers/article/details/82423128

完整代码

import win32com.client, wmi, os, json, arrow, re
import win32gui, win32con, time, subprocess
import sqlite3, xlrd, os
from config import current_day, current_week_num, sunday, saturday, download_directory
from models import *
from models import session as sql_session
from write_to_excel_isp import isp_to_excel

from datetime import datetime


today = datetime.today().strftime('%Y%m%d')

edit_list = []
def all_ok(hwnd, param):

    text = win32gui.GetClassName(hwnd)
    if text == 'Edit':
        print(hwnd,text, win32gui.IsWindowEnabled(hwnd), win32gui.IsWindowVisible(hwnd))
        edit_list.append(hwnd)
        return True


# 从excel获取SAP登录信息
def get_params(filename):
    data = xlrd.open_workbook(filename)
    sheet_name = 'Sheet1'
    table = data.sheet_by_name(sheet_name)
    # print('sheet1', table.nrows)
    path = table.cell(1, 0).value
    version = table.cell(1, 1).value
    search_name = table.cell(1, 2).value
    username = table.cell(1, 3).value
    password = table.cell(1, 4).value
    username2 = table.cell(1, 5).value
    password2 = table.cell(1, 6).value
    query_date = table.cell(1, 7).value
    wait_time = table.cell(1, 8).value
    # print('path', path)
    # print('version', version)
    # print('search_name', search_name)
    # print('username', username)
    # print('password', password)
    # print('username2', username2)
    # print('password2', password2)
    # print('query_date', query_date)
    # print('wait_time', wait_time)
    # return path, version, search_name, username, password, username2, password2, wait_time
    return path, version, search_name, username, password, username2, password2, query_date, wait_time


# 杀掉sap进程
def kill_sap():
    c = wmi.WMI()

    for process in c.Win32_Process(name="saplogon.exe"):
        print(process.ProcessId, process.Name)
        process.Terminate()
    for process in c.Win32_Process(name="guixt.exe"):
        print(process.ProcessId, process.Name)
        process.Terminate()


# sap_path, sap_version, search_name, username, password, username2, password2, query_date, wait_time = get_params()


def sap_login(sap_path, sap_version, search_name, username, password, username2, password2, query_date, wait_time, client='807'):
    '''
    登录SAP， 输入T-code, 返回获取的session
    :return: session
    '''

    kill_sap()

    sap_app = sap_path  # 您的saplogon程序本地完整路径
    subprocess.Popen(sap_app)

    time.sleep(int(wait_time))

    flt = 0
    while flt == 0:

        try:
            hwnd = win32gui.FindWindow(None, sap_version)
            flt = win32gui.FindWindowEx(hwnd, None, "Edit", None)


            print('hwnd', hwnd)
            print('flt', flt)
            win32gui.EnumChildWindows(hwnd, all_ok, None)
            flt = edit_list[1]
            print('flt', flt)
            time.sleep(3)
            print('---------------->')
        except:
            print('except============>')
            time.sleep(0.5)
    print('search_name', search_name)
    win32gui.SendMessage(flt, win32con.WM_SETTEXT, None, search_name)
    win32gui.SendMessage(flt, win32con.WM_KEYDOWN, win32con.VK_RIGHT, 0)
    win32gui.SendMessage(flt, win32con.WM_KEYUP, win32con.VK_RIGHT, 0)
    time.sleep(3)
    # 登录GUI界面

    time.sleep(0.3)
    dlg = win32gui.FindWindowEx(hwnd, None, "Button", None)
    win32gui.SendMessage(dlg, win32con.WM_LBUTTONDOWN, 0)
    win32gui.SendMessage(dlg, win32con.WM_LBUTTONUP, 0)


    time.sleep(2)
    SapGuiAuto = win32com.client.GetObject("SAPGUI")

    print(SapGuiAuto)
    print(type(SapGuiAuto))

    if not type(SapGuiAuto) == win32com.client.CDispatch:
        return
    application = SapGuiAuto.GetScriptingEngine
    print('application', application)
    print('count', application.Children.Count)

    while not application.Children.Count:
        time.sleep(0.5)
        win32gui.SendMessage(dlg, win32con.WM_LBUTTONDOWN, 0)
        win32gui.SendMessage(dlg, win32con.WM_LBUTTONUP, 0)
        print('count 0 sleep 0.5')
        SapGuiAuto = win32com.client.GetObject("SAPGUI")
        application = SapGuiAuto.GetScriptingEngine
        print('sleep 3')
    print('hello')


    if not type(application) == win32com.client.CDispatch:
        SapGuiAuto = None
        print('return')
        return
    connection = application.Children(0)
    if not type(connection) == win32com.client.CDispatch:
        application = None
        SapGuiAuto = None
        print('return2')
        return
    time.sleep(2)
    # session = connection.Children(0)
    flag = 0
    while flag == 0:
        try:
            connection = application.Children(0)
            session = connection.Children(0)
            print(session)
            flag = 1
        except:

            print('time sleep 0.5',application.Children.Count)
            time.sleep(0.5)
    # print('type session', type(session))
    if not type(session) == win32com.client.CDispatch:
        connection = None
        application = None
        SapGuiAuto = None

        return
    print('client--->', client)
    session.findById("wnd[0]").maximize()
    session.findById("wnd[0]/usr/txtRSYST-MANDT").text = client
    session.findById("wnd[0]/usr/txtRSYST-LANGU").text = "EN"
    session.findById("wnd[0]/usr/txtRSYST-BNAME").text = username
    session.findById("wnd[0]/usr/pwdRSYST-BCODE").text = password
    session.findById("wnd[0]/usr/pwdRSYST-BCODE").setFocus()
    session.findById("wnd[0]/usr/pwdRSYST-BCODE").caretPosition = 8
    session.findById("wnd[0]").sendVKey(0)

    # 出现多用户登录
    # License Information for Multiple Logon

    multi_logon_text = session.findById("wnd[1]").text

    if 'License Information' in multi_logon_text:
        session.findById("wnd[1]/usr/radMULTI_LOGON_OPT2").select()
        session.findById("wnd[1]/usr/radMULTI_LOGON_OPT2").setFocus()
        session.findById("wnd[1]/tbar[0]/btn[0]").press()

    # 出现版权点击确定，没有版权提示直接进行下一步
    try:
        x = session.findById("wnd[1]").text
        # print(x)
        if 'Copyright' in x:
            session.findById("wnd[1]/tbar[0]/btn[0]").press()
    except:
        pass

    # 出现二级密码登录，不出现跳过
    try:
        session.findById("wnd[1]/usr/txtGS_OUT-ID").text = username2
        session.findById("wnd[1]/usr/pwdGS_OUT-PW").text = password2
        session.findById("wnd[1]/usr/pwdGS_OUT-PW").setFocus()
        session.findById("wnd[1]/usr/pwdGS_OUT-PW").caretPosition = 10
        session.findById("wnd[1]/usr/btnLOGIN").press()
    except:
        print('no second user')


    return session

def get_ubj9(session,current_day, sunday, saturday, name):
    filename = download_directory + name + "_week_" + current_day +".xls"
    if not os.path.exists(filename):
        session.findById("wnd[0]").maximize()
        session.findById("wnd[0]/tbar[0]/okcd").text = "/nmb51"
        session.findById("wnd[0]").sendVKey(0)
        session.findById("wnd[0]/usr/ctxtWERKS-LOW").text = name
        session.findById("wnd[0]/usr/ctxtBWART-LOW").text = "Z01"
        session.findById("wnd[0]/usr/ctxtBWART-LOW").setFocus()
        session.findById("wnd[0]/usr/ctxtBWART-LOW").caretPosition = 3
        session.findById("wnd[0]/usr/btn%_BWART_%_APP_%-VALU_PUSH").press()
        session.findById(
            "wnd[1]/usr/tabsTAB_STRIP/tabpSIVA/ssubSCREEN_HEADER:SAPLALDB:3010/tblSAPLALDBSINGLE/ctxtRSCSEL-SLOW_I[1,1]").text = "Z02"
        session.findById(
            "wnd[1]/usr/tabsTAB_STRIP/tabpSIVA/ssubSCREEN_HEADER:SAPLALDB:3010/tblSAPLALDBSINGLE/ctxtRSCSEL-SLOW_I[1,2]").text = "601"
        session.findById(
            "wnd[1]/usr/tabsTAB_STRIP/tabpSIVA/ssubSCREEN_HEADER:SAPLALDB:3010/tblSAPLALDBSINGLE/ctxtRSCSEL-SLOW_I[1,3]").text = "602"
        # session.findById(
        #     "wnd[1]/usr/tabsTAB_STRIP/tabpSIVA/ssubSCREEN_HEADER:SAPLALDB:3010/tblSAPLALDBSINGLE/ctxtRSCSEL-SLOW_I[1,4]").text = "Z61"
        # session.findById(
        #     "wnd[1]/usr/tabsTAB_STRIP/tabpSIVA/ssubSCREEN_HEADER:SAPLALDB:3010/tblSAPLALDBSINGLE/ctxtRSCSEL-SLOW_I[1,5]").text = "Z62"

        session.findById(
            "wnd[1]/usr/tabsTAB_STRIP/tabpSIVA/ssubSCREEN_HEADER:SAPLALDB:3010/tblSAPLALDBSINGLE/ctxtRSCSEL-SLOW_I[1,3]").setFocus()
        session.findById(
            "wnd[1]/usr/tabsTAB_STRIP/tabpSIVA/ssubSCREEN_HEADER:SAPLALDB:3010/tblSAPLALDBSINGLE/ctxtRSCSEL-SLOW_I[1,3]").caretPosition = 3
        session.findById("wnd[1]/tbar[0]/btn[8]").press()
        session.findById("wnd[0]/usr/ctxtBUDAT-LOW").text = sunday
        session.findById("wnd[0]/usr/ctxtBUDAT-HIGH").text = saturday
        session.findById("wnd[0]/usr/ctxtBUDAT-HIGH").setFocus()
        session.findById("wnd[0]/usr/ctxtBUDAT-HIGH").caretPosition = 10
        session.findById("wnd[0]/tbar[1]/btn[8]").press()

        session.findById("wnd[0]/tbar[1]/btn[48]").press()
        session.findById("wnd[0]/mbar/menu[0]/menu[1]/menu[2]").select()
        session.findById("wnd[1]/usr/sub:SAPLSPO5:0101/radSPOPLI-SELFLAG[1,0]").select()
        session.findById("wnd[1]/usr/sub:SAPLSPO5:0101/radSPOPLI-SELFLAG[1,0]").setFocus()
        session.findById("wnd[1]/tbar[0]/btn[0]").press()
        session.findById("wnd[1]/usr/ctxtRLGRAP-FILENAME").text = download_directory + name + "_week_" + current_day +".xls"
        session.findById("wnd[1]/usr/ctxtRLGRAP-FILENAME").caretPosition = 45
        session.findById("wnd[1]").sendVKey(0)
    else:
        print('have this file')

def get_ubj9_isp(session,current_day, sunday, saturday, name):
    filename = download_directory + name + "_isp_week_" + current_day +".xls"
    if not os.path.exists(filename):
        session.findById("wnd[0]").maximize()
        session.findById("wnd[0]/tbar[0]/okcd").text = "/nmb51"
        session.findById("wnd[0]").sendVKey(0)
        session.findById("wnd[0]/usr/ctxtWERKS-LOW").text = name
        session.findById("wnd[0]/usr/ctxtBWART-LOW").text = "Z01"
        session.findById("wnd[0]/usr/ctxtBWART-LOW").setFocus()
        session.findById("wnd[0]/usr/ctxtBWART-LOW").caretPosition = 3
        session.findById("wnd[0]/usr/btn%_BWART_%_APP_%-VALU_PUSH").press()
        session.findById(
            "wnd[1]/usr/tabsTAB_STRIP/tabpSIVA/ssubSCREEN_HEADER:SAPLALDB:3010/tblSAPLALDBSINGLE/ctxtRSCSEL-SLOW_I[1,1]").text = "Z02"
        session.findById(
            "wnd[1]/usr/tabsTAB_STRIP/tabpSIVA/ssubSCREEN_HEADER:SAPLALDB:3010/tblSAPLALDBSINGLE/ctxtRSCSEL-SLOW_I[1,2]").text = "601"
        session.findById(
            "wnd[1]/usr/tabsTAB_STRIP/tabpSIVA/ssubSCREEN_HEADER:SAPLALDB:3010/tblSAPLALDBSINGLE/ctxtRSCSEL-SLOW_I[1,3]").text = "602"
        session.findById(
            "wnd[1]/usr/tabsTAB_STRIP/tabpSIVA/ssubSCREEN_HEADER:SAPLALDB:3010/tblSAPLALDBSINGLE/ctxtRSCSEL-SLOW_I[1,4]").text = "Z61"
        session.findById(
            "wnd[1]/usr/tabsTAB_STRIP/tabpSIVA/ssubSCREEN_HEADER:SAPLALDB:3010/tblSAPLALDBSINGLE/ctxtRSCSEL-SLOW_I[1,5]").text = "Z62"

        session.findById(
            "wnd[1]/usr/tabsTAB_STRIP/tabpSIVA/ssubSCREEN_HEADER:SAPLALDB:3010/tblSAPLALDBSINGLE/ctxtRSCSEL-SLOW_I[1,3]").setFocus()
        session.findById(
            "wnd[1]/usr/tabsTAB_STRIP/tabpSIVA/ssubSCREEN_HEADER:SAPLALDB:3010/tblSAPLALDBSINGLE/ctxtRSCSEL-SLOW_I[1,3]").caretPosition = 3
        session.findById("wnd[1]/tbar[0]/btn[8]").press()
        session.findById("wnd[0]/usr/ctxtBUDAT-LOW").text = sunday
        session.findById("wnd[0]/usr/ctxtBUDAT-HIGH").text = saturday
        session.findById("wnd[0]/usr/ctxtBUDAT-HIGH").setFocus()
        session.findById("wnd[0]/usr/ctxtBUDAT-HIGH").caretPosition = 10
        session.findById("wnd[0]/tbar[1]/btn[8]").press()

        session.findById("wnd[0]/tbar[1]/btn[48]").press()
        session.findById("wnd[0]/mbar/menu[0]/menu[1]/menu[2]").select()
        session.findById("wnd[1]/usr/sub:SAPLSPO5:0101/radSPOPLI-SELFLAG[1,0]").select()
        session.findById("wnd[1]/usr/sub:SAPLSPO5:0101/radSPOPLI-SELFLAG[1,0]").setFocus()
        session.findById("wnd[1]/tbar[0]/btn[0]").press()
        session.findById("wnd[1]/usr/ctxtRLGRAP-FILENAME").text = download_directory + name + "_isp_week_" + current_day +".xls"
        session.findById("wnd[1]/usr/ctxtRLGRAP-FILENAME").caretPosition = 45
        session.findById("wnd[1]").sendVKey(0)
    else:
        print('have this file')



def get_hbj9(session,current_day, sunday, saturday, name):
    filename = download_directory + name + "_week_" + current_day +".xls"
    if not os.path.exists(filename):
        session.findById("wnd[0]").maximize()
        session.findById("wnd[0]/tbar[0]/okcd").text = "/nmb51"
        session.findById("wnd[0]").sendVKey(0)
        session.findById("wnd[0]/usr/ctxtWERKS-LOW").text = name
        session.findById("wnd[0]/usr/ctxtBWART-LOW").text = "Z01"
        session.findById("wnd[0]/usr/ctxtBWART-LOW").setFocus()
        session.findById("wnd[0]/usr/ctxtBWART-LOW").caretPosition = 3
        session.findById("wnd[0]/usr/btn%_BWART_%_APP_%-VALU_PUSH").press()
        session.findById(
            "wnd[1]/usr/tabsTAB_STRIP/tabpSIVA/ssubSCREEN_HEADER:SAPLALDB:3010/tblSAPLALDBSINGLE/ctxtRSCSEL-SLOW_I[1,1]").text = "Z02"
        # session.findById(
            # "wnd[1]/usr/tabsTAB_STRIP/tabpSIVA/ssubSCREEN_HEADER:SAPLALDB:3010/tblSAPLALDBSINGLE/ctxtRSCSEL-SLOW_I[1,1]").text = "11"

        session.findById(
            "wnd[1]/usr/tabsTAB_STRIP/tabpSIVA/ssubSCREEN_HEADER:SAPLALDB:3010/tblSAPLALDBSINGLE/ctxtRSCSEL-SLOW_I[1,2]").text = "601"
        session.findById(
            "wnd[1]/usr/tabsTAB_STRIP/tabpSIVA/ssubSCREEN_HEADER:SAPLALDB:3010/tblSAPLALDBSINGLE/ctxtRSCSEL-SLOW_I[1,3]").text = "602"
        # session.findById(
        #     "wnd[1]/usr/tabsTAB_STRIP/tabpSIVA/ssubSCREEN_HEADER:SAPLALDB:3010/tblSAPLALDBSINGLE/ctxtRSCSEL_255-SLOW_I[1,4]").text = "Z61"
        # session.findById(
        #     "wnd[1]/usr/tabsTAB_STRIP/tabpSIVA/ssubSCREEN_HEADER:SAPLALDB:3010/tblSAPLALDBSINGLE/ctxtRSCSEL_255-SLOW_I[1,5]").text = "Z62"

        # time.sleep(1000)
        session.findById(
            "wnd[1]/usr/tabsTAB_STRIP/tabpSIVA/ssubSCREEN_HEADER:SAPLALDB:3010/tblSAPLALDBSINGLE/ctxtRSCSEL-SLOW_I[1,3]").setFocus()
        session.findById(
            "wnd[1]/usr/tabsTAB_STRIP/tabpSIVA/ssubSCREEN_HEADER:SAPLALDB:3010/tblSAPLALDBSINGLE/ctxtRSCSEL-SLOW_I[1,3]").caretPosition = 3
        session.findById("wnd[1]/tbar[0]/btn[8]").press()
        session.findById("wnd[0]/usr/ctxtBUDAT-LOW").text = sunday
        session.findById("wnd[0]/usr/ctxtBUDAT-HIGH").text = saturday
        session.findById("wnd[0]/usr/ctxtBUDAT-HIGH").setFocus()
        session.findById("wnd[0]/usr/ctxtBUDAT-HIGH").caretPosition = 10
        session.findById("wnd[0]/tbar[1]/btn[8]").press()


        session.findById("wnd[0]/tbar[1]/btn[48]").press()
        session.findById("wnd[0]/mbar/menu[0]/menu[1]/menu[2]").select()
        #20220105
        # session.findById(
        #     "wnd[1]/usr/subSUBSCREEN_STEPLOOP:SAPLSPO5:0150/sub:SAPLSPO5:0150/radSPOPLI-SELFLAG[1,0]").select()

        session.findById("wnd[1]/usr/sub:SAPLSPO5:0101/radSPOPLI-SELFLAG[1,0]").select()

        # session.findById(
        #     "wnd[1]/usr/subSUBSCREEN_STEPLOOP:SAPLSPO5:0150/sub:SAPLSPO5:0150/radSPOPLI-SELFLAG[1,0]").setFocus()
        session.findById("wnd[1]/tbar[0]/btn[0]").press()
        session.findById("wnd[1]/usr/ctxtRLGRAP-FILENAME").text = download_directory + name + "_week_" + current_day +".xls"
        # session.findById("wnd[1]/usr/ctxtDY_FILENAME").text = download_directory + name + "_week_" + current_day +".xls"
        # session.findById("wnd[1]/usr/ctxtDY_PATH").text = download_directory
        # session.findById("wnd[1]/usr/ctxtDY_FILENAME").text = name + "_week_" + current_day +".xls"

        session.findById("wnd[1]/tbar[0]/btn[0]").press()
        # session.findById("wnd[1]/tbar[0]/btn[0]").press()
        # session.findById("wnd[1]").sendVKey(0)
    else:
        print('have this file')
def get_hbj9_isp(session,current_day, sunday, saturday, name):
    filename = download_directory + name + "_isp_week_" + current_day +".xls"
    if not os.path.exists(filename):
        session.findById("wnd[0]").maximize()
        session.findById("wnd[0]/tbar[0]/okcd").text = "/nmb51"
        session.findById("wnd[0]").sendVKey(0)
        session.findById("wnd[0]/usr/ctxtWERKS-LOW").text = name
        session.findById("wnd[0]/usr/ctxtBWART-LOW").text = "Z01"
        session.findById("wnd[0]/usr/ctxtBWART-LOW").setFocus()
        session.findById("wnd[0]/usr/ctxtBWART-LOW").caretPosition = 3
        session.findById("wnd[0]/usr/btn%_BWART_%_APP_%-VALU_PUSH").press()
        session.findById(
            "wnd[1]/usr/tabsTAB_STRIP/tabpSIVA/ssubSCREEN_HEADER:SAPLALDB:3010/tblSAPLALDBSINGLE/ctxtRSCSEL-SLOW_I[1,1]").text = "Z02"
        
        session.findById(
            "wnd[1]/usr/tabsTAB_STRIP/tabpSIVA/ssubSCREEN_HEADER:SAPLALDB:3010/tblSAPLALDBSINGLE/ctxtRSCSEL-SLOW_I[1,2]").text = "601"
        session.findById(
            "wnd[1]/usr/tabsTAB_STRIP/tabpSIVA/ssubSCREEN_HEADER:SAPLALDB:3010/tblSAPLALDBSINGLE/ctxtRSCSEL-SLOW_I[1,3]").text = "602"
        session.findById(
            "wnd[1]/usr/tabsTAB_STRIP/tabpSIVA/ssubSCREEN_HEADER:SAPLALDB:3010/tblSAPLALDBSINGLE/ctxtRSCSEL-SLOW_I[1,4]").text = "Z61"
        session.findById(
            "wnd[1]/usr/tabsTAB_STRIP/tabpSIVA/ssubSCREEN_HEADER:SAPLALDB:3010/tblSAPLALDBSINGLE/ctxtRSCSEL-SLOW_I[1,5]").text = "Z62"

        # time.sleep(1000)
        session.findById(
            "wnd[1]/usr/tabsTAB_STRIP/tabpSIVA/ssubSCREEN_HEADER:SAPLALDB:3010/tblSAPLALDBSINGLE/ctxtRSCSEL-SLOW_I[1,3]").setFocus()
        session.findById(
            "wnd[1]/usr/tabsTAB_STRIP/tabpSIVA/ssubSCREEN_HEADER:SAPLALDB:3010/tblSAPLALDBSINGLE/ctxtRSCSEL-SLOW_I[1,3]").caretPosition = 3
        session.findById("wnd[1]/tbar[0]/btn[8]").press()
        session.findById("wnd[0]/usr/ctxtBUDAT-LOW").text = sunday
        session.findById("wnd[0]/usr/ctxtBUDAT-HIGH").text = saturday
        session.findById("wnd[0]/usr/ctxtBUDAT-HIGH").setFocus()
        session.findById("wnd[0]/usr/ctxtBUDAT-HIGH").caretPosition = 10
        session.findById("wnd[0]/tbar[1]/btn[8]").press()


        session.findById("wnd[0]/tbar[1]/btn[48]").press()
        session.findById("wnd[0]/mbar/menu[0]/menu[1]/menu[2]").select()
        # session.findById(
        #     "wnd[1]/usr/subSUBSCREEN_STEPLOOP:SAPLSPO5:0150/sub:SAPLSPO5:0150/radSPOPLI-SELFLAG[1,0]").select()

        session.findById("wnd[1]/usr/sub:SAPLSPO5:0101/radSPOPLI-SELFLAG[1,0]").select()
        session.findById("wnd[1]/usr/sub:SAPLSPO5:0101/radSPOPLI-SELFLAG[1,0]").setFocus()
        session.findById("wnd[1]/tbar[0]/btn[0]").press()

        # session.findById(
        #     "wnd[1]/usr/subSUBSCREEN_STEPLOOP:SAPLSPO5:0150/sub:SAPLSPO5:0150/radSPOPLI-SELFLAG[1,0]").setFocus()
        # session.findById("wnd[1]/tbar[0]/btn[0]").press()
        # session.findById("wnd[1]/usr/ctxtDY_FILENAME").text = download_directory + name + "_week_" + current_day +".xls"
        # session.findById("wnd[1]/usr/ctxtDY_PATH").text = download_directory
        # session.findById("wnd[1]/usr/ctxtDY_FILENAME").text = name + "_isp_week_" + current_day +".xls"

        session.findById("wnd[1]/usr/ctxtRLGRAP-FILENAME").text = download_directory + name + "_isp_week_" + current_day +".xls"
        session.findById("wnd[1]/usr/ctxtRLGRAP-FILENAME").caretPosition = 44


        session.findById("wnd[1]/tbar[0]/btn[0]").press()
        # session.findById("wnd[1]/tbar[0]/btn[0]").press()
        # session.findById("wnd[1]").sendVKey(0)
    else:
        print('have this file')


def get_epdv_isp(session, current_day, sunday, saturday, name):
    filename = download_directory + name + "_isp_week_" + current_day + ".xls"
    if not os.path.exists(filename):
        session.findById("wnd[0]").maximize()
        session.findById("wnd[0]/tbar[0]/okcd").text = "/nmb51"
        session.findById("wnd[0]").sendVKey(0)
        session.findById("wnd[0]/usr/ctxtWERKS-LOW").text = name
        session.findById("wnd[0]/usr/ctxtBWART-LOW").text = "Z01"
        session.findById("wnd[0]/usr/ctxtBWART-LOW").setFocus()
        session.findById("wnd[0]/usr/ctxtBWART-LOW").caretPosition = 3
        session.findById("wnd[0]/usr/btn%_BWART_%_APP_%-VALU_PUSH").press()
        session.findById(
            "wnd[1]/usr/tabsTAB_STRIP/tabpSIVA/ssubSCREEN_HEADER:SAPLALDB:3010/tblSAPLALDBSINGLE/ctxtRSCSEL-SLOW_I[1,1]").text = "Z02"

        session.findById(
            "wnd[1]/usr/tabsTAB_STRIP/tabpSIVA/ssubSCREEN_HEADER:SAPLALDB:3010/tblSAPLALDBSINGLE/ctxtRSCSEL-SLOW_I[1,2]").text = "601"
        session.findById(
            "wnd[1]/usr/tabsTAB_STRIP/tabpSIVA/ssubSCREEN_HEADER:SAPLALDB:3010/tblSAPLALDBSINGLE/ctxtRSCSEL-SLOW_I[1,3]").text = "602"
        session.findById(
            "wnd[1]/usr/tabsTAB_STRIP/tabpSIVA/ssubSCREEN_HEADER:SAPLALDB:3010/tblSAPLALDBSINGLE/ctxtRSCSEL-SLOW_I[1,4]").text = "Z61"
        session.findById(
            "wnd[1]/usr/tabsTAB_STRIP/tabpSIVA/ssubSCREEN_HEADER:SAPLALDB:3010/tblSAPLALDBSINGLE/ctxtRSCSEL-SLOW_I[1,5]").text = "Z62"

        # time.sleep(1000)

        session.findById("wnd[1]/tbar[0]/btn[8]").press()
        session.findById("wnd[0]/usr/ctxtBUDAT-LOW").text = sunday
        session.findById("wnd[0]/usr/ctxtBUDAT-HIGH").text = saturday
        session.findById("wnd[0]/usr/ctxtBUDAT-HIGH").setFocus()
        session.findById("wnd[0]/usr/ctxtBUDAT-HIGH").caretPosition = 10
        session.findById("wnd[0]/tbar[1]/btn[8]").press()

        session.findById("wnd[0]/tbar[1]/btn[48]").press()
        session.findById("wnd[0]/mbar/menu[0]/menu[1]/menu[2]").select()
        session.findById(
            "wnd[1]/usr/sub:SAPLSPO5:0101/radSPOPLI-SELFLAG[1,0]").select()
        session.findById(
            "wnd[1]/usr/sub:SAPLSPO5:0101/radSPOPLI-SELFLAG[1,0]").setFocus()
        session.findById("wnd[1]/tbar[0]/btn[0]").press()
        # session.findById("wnd[1]/usr/ctxtDY_FILENAME").text = download_directory + name + "_week_" + current_day +".xls"
        session.findById("wnd[1]/usr/ctxtRLGRAP-FILENAME").text = download_directory + name + "_isp_week_" + current_day + ".xls"

        # session.findById("wnd[1]/tbar[0]/btn[0]").press()
        session.findById("wnd[1]").sendVKey(0)

    else:
        print('have this file')





def read_excel(name):

    file_path = download_directory + name + "_week_" + current_day +".xls"
    # 读取RFC中物料价格
    xlApp = win32com.client.DispatchEx("Excel.Application")
    xlApp.Visible = True
    xlApp.DisplayAlerts = 0
    # 宏所在的xls
    xlApp.Workbooks.Open(file_path, False)
    worksheet = xlApp.ActiveSheet

    # 获取总行数
    row_count = worksheet.UsedRange.Rows.Count
    print('row count', row_count)

    m = 5
    while m < row_count:
        if 'UBJ' in file_path:
            material = worksheet.Range("h" + str(m)).Value
            plant = worksheet.Range("d" + str(m)).Value
            quantity = worksheet.Range("i" + str(m)).Value
            customer = worksheet.Range("ab" + str(m)).Value
        elif 'HBJ' in file_path:
            material = worksheet.Range("e" + str(m)).Value
            plant = worksheet.Range("c" + str(m)).Value
            quantity = worksheet.Range("j" + str(m)).Value
            customer = worksheet.Range("y" + str(m)).Value
        elif 'EPDV' in file_path:
            material = worksheet.Range("c" + str(m)).Value
            plant = worksheet.Range("e" + str(m)).Value
            quantity = worksheet.Range("k" + str(m)).Value
            customer = worksheet.Range("s" + str(m)).Value
        print('material', material)
        print('plant', plant)
        print('quantity', quantity)
        if plant and 'BIT451' not in str(customer):
            item_dict = {
               'plant': plant,
               'quantity': quantity,
               'material': material,
               'customer': customer
            }
            item = Sap_material(**item_dict)
            sql_session.add(item)
            sql_session.commit()

        m = m + 1
        print(m)
    site = 'TJ Direct ship'
    items = sql_session.query(Week_data.pn, Week_data.fox_pn).filter(Week_data.site==site).distinct(Week_data.pn, Week_data.fox_pn).all()
    print('len------->',len(items))
    items = list(set(items))
    print(len(items))
    for item in items:
        pn = item['pn']
        fox_pn = item['fox_pn']
        if fox_pn:
            print('pn', pn)
            print('fox_pn', fox_pn)
        # time.sleep(15)
        if fox_pn:
            total = sql_session.query(func.sum(Sap_material.quantity)).filter(Sap_material.material == fox_pn).scalar()
            if total:
                total = int(total)


            else:
                total = 0
            if total > 0:
                total = 0

            # 20211129 add 如果total是负数，total = -total
            # 将total转为正数，存入数据库
            total = -total

            item_dict = {
                'site': site,
                'day': current_day,
                'week': current_week_num,
                'pn': pn,
                'fox_pn':fox_pn,
                'total': total
            }
            try:
                if fox_pn:
                    try:
                        # 如果有SAP当周物料信息就更新，否则就直接插入数据
                        i = sql_session.query(Week_data).filter(Week_data.day==current_day,
                                                                      Week_data.site==site,
                                                                      Week_data.pn==pn,
                                                                      Week_data.fox_pn==fox_pn).first()
                        print(i)
                        if i:
                            i.total = total
                            sql_session.commit()
                            print('update success')
                        else:
                            sql_session.add(Week_data(**item_dict))
                            sql_session.commit()
                            print('insert sap week data success')
                    except:
                        print('update failed')
                        # sql_session.rollback()
                # if fox_pn:
                #     sql_session.add(Week_data(**item_dict))
                #     sql_session.commit()
            except:
                print('have this item')
                print(item_dict)
                sql_session.rollback()
    xlApp.quit()

def read_excel_isp(name):

    file_path = download_directory + name + "_isp_week_" + current_day +".xls"
    # 读取RFC中物料价格
    xlApp = win32com.client.DispatchEx("Excel.Application")
    xlApp.Visible = False
    xlApp.DisplayAlerts = 0
    # 宏所在的xls
    xlApp.Workbooks.Open(file_path, False)
    worksheet = xlApp.ActiveSheet

    # 获取总行数
    row_count = worksheet.UsedRange.Rows.Count
    print('row count', row_count)

    m = 5
    while m < row_count + 1:
        if 'UBJ' in file_path:
            material = worksheet.Range("h" + str(m)).Value
            mvt = worksheet.Range("g" + str(m)).Value
            plant = worksheet.Range("d" + str(m)).Value
            quantity = worksheet.Range("i" + str(m)).Value
            customer = worksheet.Range("ab" + str(m)).Value
        elif 'HBJ' in file_path:
            material = worksheet.Range("e" + str(m)).Value
            mvt = worksheet.Range("f" + str(m)).Value
            plant = worksheet.Range("c" + str(m)).Value
            quantity = worksheet.Range("j" + str(m)).Value
            customer = worksheet.Range("y" + str(m)).Value
        elif 'EPDV' in file_path:
            material = worksheet.Range("c" + str(m)).Value
            mvt = worksheet.Range("g" + str(m)).Value
            plant = worksheet.Range("e" + str(m)).Value
            quantity = worksheet.Range("k" + str(m)).Value
            customer = worksheet.Range("s" + str(m)).Value
        print('material', material)
        print('plant', plant)
        print('quantity', quantity)
        if plant and 'BIT451' not in str(customer) and 'BIN001' not in str(customer) and '4730600001' not in str(customer) :
            item_dict = {
               'plant': plant,
               'quantity': quantity,
               'material': material,
               'customer': customer,
                'mvt': mvt
            }
            item = Isp_sap_material(**item_dict)
            sql_session.add(item)
            sql_session.commit()

        m = m + 1
        print(m)
    # site = 'TJ Direct ship'
    # items = sql_session.query(Isp_week_data.site, Isp_week_data.fox_pn).filter(Isp_week_data.site==site).distinct(Isp_week_data.site, Isp_week_data.fox_pn).all()
    # print('len------->',len(items))
    # items = list(set(items))
    # print(len(items))
    # for item in items:
    #     site = item['site']
    #     fox_pn = item['fox_pn']
    #     if fox_pn:
    #         print('site', site)
    #         print('fox_pn', fox_pn)
    #     # time.sleep(15)
    #     if fox_pn and mvt not in ['Z61', 'Z62']:
    #         #料号结果相加，负数为正，正数为0
    #         total = sql_session.query(func.sum(Isp_sap_material.quantity)).filter(Isp_sap_material.material == fox_pn).scalar()
    #         if total:
    #             total = int(total)
    #
    #
    #         else:
    #             total = 0
    #         if total > 0:
    #             total = 0
    #         if total < 0:
    #             total = -total
    #         item_dict = {
    #             'site': site,
    #             'mvt': mvt,
    #             'week': 'WK' + current_week_num,
    #             'fox_pn':fox_pn,
    #             'total': total
    #         }
    #         try:
    #             if fox_pn:
    #                 try:
    #                     i = sql_session.query(Isp_week_data).filter(Isp_week_data.week=='WK' + current_week_num,
    #                                                                 Isp_week_data.site==site,
    #                                                                 Isp_week_data.fox_pn==fox_pn).first()
    #                     print('i ---> ', i)
    #                     if i:
    #                         i.total = total
    #                         sql_session.commit()
    #                         print('update success')
    #                     else:
    #                         sql_session.add(Isp_week_data(**item_dict))
    #                         sql_session.commit()
    #                         print('insert sap week data success')
    #                 except:
    #                     print('update failed')
    #                     sql_session.rollback()
    #
    #         except:
    #             print('have this item')
    #             print(item_dict)
    #             sql_session.rollback()
    #
    # site = 'Facebook'
    # items = sql_session.query(Isp_week_data.site, Isp_week_data.fox_pn).filter(Isp_week_data.site == site).distinct(
    #     Isp_week_data.site, Isp_week_data.fox_pn).all()
    # print('len------->', len(items))
    # items = list(set(items))
    # print(len(items))
    # for item in items:
    #     site = item['site']
    #     fox_pn = item['fox_pn']
    #     if fox_pn:
    #         print('site', site)
    #         print('fox_pn', fox_pn)
    #     # time.sleep(15)
    #     if fox_pn and mvt in ['Z61', 'Z62']:
    #         # 料号结果相加，负数为正，正数为0
    #         total = sql_session.query(func.sum(Isp_sap_material.quantity)).filter(
    #             Isp_sap_material.material == fox_pn).scalar()
    #         if total:
    #             total = int(total)
    #
    #
    #         else:
    #             total = 0
    #         if total > 0:
    #             total = 0
    #         if total < 0:
    #             total = -total
    #         item_dict = {
    #             'site': site,
    #             'mvt': mvt,
    #             'week': 'WK' + current_week_num,
    #             'fox_pn': fox_pn,
    #             'total': total
    #         }
    #         try:
    #             if fox_pn:
    #                 try:
    #                     i = sql_session.query(Isp_week_data).filter(Isp_week_data.week == 'WK' + current_week_num,
    #                                                                 Isp_week_data.site == site,
    #                                                                 Isp_week_data.fox_pn == fox_pn).first()
    #                     print('i ---> ', i)
    #                     if i:
    #                         i.total = total
    #                         sql_session.commit()
    #                         print('update success')
    #                     else:
    #                         sql_session.add(Isp_week_data(**item_dict))
    #                         sql_session.commit()
    #                         print('insert sap week data success')
    #                 except:
    #                     print('update failed')
    #                     sql_session.rollback()
    #
    #         except:
    #             print('have this item')
    #             print(item_dict)
    #             sql_session.rollback()
    xlApp.quit()

def excel_to_weekdata_isp():

    #添加TJ Direct总数
    site = 'TJ Direct ship'
    items = sql_session.query(Isp_week_data.site, Isp_week_data.fox_pn, Isp_week_data.customer).filter(Isp_week_data.site==site).distinct(Isp_week_data.site, Isp_week_data.fox_pn).all()
    print('len------->',len(items))
    items = list(set(items))
    print(len(items))
    for item in items:
        site = item['site']
        fox_pn = item['fox_pn']
        cusomter = item['customer']

        if fox_pn:
            print('site', site)
            print('fox_pn', fox_pn)
        # time.sleep(15)
        if fox_pn:
            #料号结果相加，负数为正，正数为0
            total = sql_session.query(func.sum(Isp_sap_material.quantity)).filter(Isp_sap_material.material == fox_pn,
                                                                                  Isp_sap_material.mvt !='Z61', Isp_sap_material.mvt !='Z62').scalar()


            if total:
                total = int(total)


            else:
                total = 0
            if total > 0:
                total = 0
            if total < 0:
                total = -total
            item_dict = {
                'site': site,
                'customer': cusomter,
                'week': 'WK' + current_week_num,
                'fox_pn':fox_pn,
                'total': total
            }

            try:
                if fox_pn:
                    try:
                        i = sql_session.query(Isp_week_data).filter(Isp_week_data.week=='WK' + current_week_num,
                                                                    Isp_week_data.site==site,
                                                                    Isp_week_data.fox_pn==fox_pn).first()
                        print('i ---> ', i)
                        if i:
                            i.total = total
                            sql_session.commit()
                            print('update success')
                        else:
                            sql_session.add(Isp_week_data(**item_dict))
                            sql_session.commit()
                            print('insert sap week data success')
                    except Exception as e:
                        print('update failed')
                        print(e)
                        sql_session.rollback()

            except:
                print('have this item')
                print(item_dict)
                sql_session.rollback()



    #添加Facebook总数
    customer = 'Facebook'
    items = sql_session.query(Isp_week_data.site, Isp_week_data.fox_pn, Isp_week_data.customer).filter(Isp_week_data.customer == customer).distinct(
        Isp_week_data.site, Isp_week_data.fox_pn).all()
    print('Facebook len------->', len(items))
    items = list(set(items))
    print(len(items))
    for item in items:
        site = item['site']
        fox_pn = item['fox_pn']
        customer = item['customer']
        if fox_pn:
            print('site', site)
            print('fox_pn', fox_pn)
        # time.sleep(15)
        if fox_pn :
            # 料号结果相加，负数为正，正数为0
            total = sql_session.query(func.sum(Isp_sap_material.quantity)).filter(
                Isp_sap_material.material == fox_pn,
                Isp_sap_material.mvt.in_(['Z61', 'Z62'])).scalar()
            if total:
                total = int(total)


            else:
                total = 0
            if total > 0:
                total = 0
            if total < 0:
                total = -total
            item_dict = {
                'site': site,
                'customer': customer,
                'week': 'WK' + current_week_num,
                'fox_pn': fox_pn,
                'total': total
            }
            try:
                if fox_pn:
                    try:
                        i = sql_session.query(Isp_week_data).filter(Isp_week_data.week == 'WK' + current_week_num,
                                                                    Isp_week_data.site == site,
                                                                    Isp_week_data.fox_pn == fox_pn).first()
                        print('i ---> ', i)
                        if i:
                            i.total = total
                            sql_session.commit()
                            print('update success')
                        else:
                            sql_session.add(Isp_week_data(**item_dict))
                            sql_session.commit()
                            print('insert sap week data success')
                    except:
                        print('update failed')
                        sql_session.rollback()

            except:
                print('have this item')
                print(item_dict)
                sql_session.rollback()
        # 添加HUB总数
    site = 'HUB'
    customer = 'Facebook'

    items = sql_session.query(Isp_week_data.site, Isp_week_data.fox_pn, Isp_week_data.customer).filter(
        Isp_week_data.customer != customer, Isp_week_data.site == site ).distinct(
        Isp_week_data.site, Isp_week_data.fox_pn).all()
    print('HUB len------->', len(items))
    items = list(set(items))
    print(len(items))
    for item in items:
        site = item['site']
        fox_pn = item['fox_pn']
        customer = item['customer']
        if fox_pn:
            print('site', site)
            print('fox_pn', fox_pn)
        # time.sleep(15)
        if fox_pn:
            # 直接从AWS shipping weekdata表中取total

            aws_sku_list = sql_session.query(Ww.pn).filter(Ww.fox_pn.contains(fox_pn)).all()
            aws_sku_list = [x[0] for x in aws_sku_list]
            print(aws_sku_list)
            print(len(aws_sku_list))
            # time.sleep(2)
            total = sql_session.query(func.sum(Web_week_data_filtered.total)).filter(
                Web_week_data_filtered.pn.in_(aws_sku_list),
                Web_week_data_filtered.week == current_week_num,
                ).scalar()
            print('total', total)
            time.sleep(0.3)
            if total:
                pass
            else:
                total = 0

            item_dict = {
                'site': site,
                'customer': customer,
                'week': 'WK' + current_week_num,
                'fox_pn': fox_pn,
                'total': total
            }
            try:
                if fox_pn:
                    try:
                        i = sql_session.query(Isp_week_data).filter(Isp_week_data.week == 'WK' + current_week_num,
                                                                    Isp_week_data.site == site,
                                                                    Isp_week_data.fox_pn == fox_pn).first()
                        print('i ---> ', i)
                        if i:
                            i.total = total
                            sql_session.commit()
                            print('update success')
                        else:
                            sql_session.add(Isp_week_data(**item_dict))
                            sql_session.commit()
                            print('insert sap week data success')
                    except:
                        print('update failed')
                        sql_session.rollback()

            except:
                print('have this item')
                print(item_dict)
                sql_session.rollback()



def export_sap_xls():
    '''
    从SAP中导出UBJ9、HBJ9报表
    :return:
    '''
    cwd = r'D:\code\hongmei\sap_data'
    lh_sap = os.path.join(cwd,'lh_config.xls' )
    tw_sap = os.path.join(cwd, 'tw_config.xls' )
    sap_path, sap_version, search_name, username, password, username2, password2, query_date, wait_time = get_params(
        lh_sap)
    session = sap_login(sap_path, sap_version, search_name, username, password, username2, password2, query_date, wait_time)
    get_ubj9(session,current_day,sunday, saturday, 'UBJ9')
    kill_sap()

    sap_path, sap_version, search_name, username, password, username2, password2, query_date, wait_time = get_params(
        tw_sap)
    session = sap_login(sap_path, sap_version, search_name, username, password, username2, password2, query_date, wait_time)
    get_hbj9(session, current_day, sunday, saturday, 'HBJ9')
    kill_sap()

def export_sap_xls_isp():
    '''
    从SAP中导出UBJ9、HBJ9报表
    :return:
    '''
    cwd = r'D:\code\hongmei\sap_data'
    lh_sap = os.path.join(cwd,'lh_config.xls' )
    epdv_sap = os.path.join(cwd,'epdv_config.xls' )
    tw_sap = os.path.join(cwd, 'tw_config.xls' )
    sap_path, sap_version, search_name, username, password, username2, password2, query_date, wait_time = get_params(
        lh_sap)
    session = sap_login(sap_path, sap_version, search_name, username, password, username2, password2, query_date, wait_time)
    get_ubj9_isp(session,current_day,sunday, saturday, 'UBJ9')
    kill_sap()

    sap_path, sap_version, search_name, username, password, username2, password2, query_date, wait_time = get_params(
        epdv_sap)
    session = sap_login(sap_path, sap_version, search_name, username, password, username2, password2, query_date,
                        wait_time, client='801')
    get_ubj9_isp(session, current_day, sunday, saturday, 'EPDV')
    kill_sap()

    sap_path, sap_version, search_name, username, password, username2, password2, query_date, wait_time = get_params(
        tw_sap)
    session = sap_login(sap_path, sap_version, search_name, username, password, username2, password2, query_date, wait_time)
    get_hbj9_isp(session, current_day, sunday, saturday, 'HBJ9')
    kill_sap()


def add_isp_weekname():
    try:
        item = Isp_week_name(week='WK' + current_week_num)
        session.add(item)
        session.commit()
    except:
        print('have this week')
        session.rollback()
        # time.sleep(3)



def sap_xls_to_mysql():
    '''
    将导出的excel文档写入数据库
    :return:
    '''
    name_list = ['UBJ9', 'HBJ9']
    del_list = [Sap_material.__table__]
    Base.metadata.drop_all(tables=del_list)
    Base.metadata.create_all(tables=del_list)
    for name in name_list:
        read_excel(name)


def data_to_excel_isp():
    add_isp_weekname()
    name_list = ['UBJ9', 'EPDV', 'HBJ9']
    del_list = [Isp_sap_material.__table__]
    Base.metadata.drop_all(tables=del_list)
    Base.metadata.create_all(tables=del_list)
    for name in name_list:
        read_excel_isp(name)
    excel_to_weekdata_isp()
    isp_to_excel()

if __name__ == '__main__':
    # data_to_excel_isp()
    pass
    cwd = r'D:\code\hongmei\sap_data'
    lh_sap = os.path.join(cwd, 'lh_config.xls')
    epdv_sap = os.path.join(cwd, 'epdv_config.xls')
    tw_sap = os.path.join(cwd, 'tw_config.xls')







    sap_path, sap_version, search_name, username, password, username2, password2, query_date, wait_time = get_params(
        lh_sap)
    session = sap_login(sap_path, sap_version, search_name, username, password, username2, password2, query_date,
                        wait_time,client='904')
    # get_ubj9_isp(session, current_day, sunday, saturday, 'UBJ9')
    kill_sap()
nongcunqq
关注
专栏目录
Python win32gui exe自动化点击捞取报表
Alfie的博客
09-14 789
打开应用使用到win32api import win32con import win32gui import time from time import sleep import win32api import win32com.client win32api.ShellExecute(1, 'open', '%s'%app_path, '', '', win32con.SW_SHOW) 首先获取应用的句柄 win32gui.FindWindow(None, "Main") #类名，标题 #...
python 获取窗口句柄_Python基础系列讲解-自动控制windows桌面
weixin_39691055的博客
11-20 3139
在使用PC时与PC交互的主要途径是看屏幕显示、听声音，点击鼠标和敲键盘等等。在自动化办公的趋势下，繁琐的工作可以让程序自动完成。比如自动化测试、自动下单交易等。很多软件除了可以GUI方式操作外还可以用CLI接口操作，不过当一些软件未提供CLI接口时，我们应该怎么办呢？我们还可以用程序控制桌面上的窗口、模拟点击鼠标或按下键盘等动作来释放自己。pywin32是一个Python库，它为Python提供访...
python 获取窗口位置等信息
weixin_42582611的博客
03-19 1503
hwnd = win32gui.FindWindow(None, '命令提示符')# 获取窗口的位置和大小。# 获取窗口文本内容。
获取windows窗口标题，id等
08-19
自己写的获取当前系统所有窗口信息的代码，delphi的，用的getwindowlong getwindowtext等
python使用win32gui操作窗口
最新发布
cnblogs_user的博客
07-18 336
【代码】python使用win32gui操作窗口。
WinAPI: GetWindowText - 获取窗口标题
weixin_34209406的博客
02-07 1232
//声明: GetWindowText( hWnd: HWND; {窗口句柄} lpString: PChar; {接收文本的缓冲区的指针} nMaxCount: Integer {指定缓冲区大小, 其中包含NULL字符; 如果文本超出，会被被截断} ): Integer; {返回字符个数, 不包括中断的空字符; 如果标题为空或句柄无效...
pythonwin-win32gui 窗口查找和遍历
热门推荐
davidsu33的专栏
05-06 1万+
#coding=utf-8 __author__ = 'Administrator' __doc__ = ''' pythonwin中win32gui的用法 本文件演如何使用win32gui来遍历系统中所有的顶层窗口， 并遍历所有顶层窗口中的子窗口 ''' import win32gui from pprint import pprint def gbk2utf8(s): retu
win32中获得 文本框edit内容
az44yao的专栏
08-14 1万+
/*wchar_t *szName; int iLength; iLength=GetWindowTextLength(hedit); szName =(wchar_t*)malloc(iLength+6); GetWindowText(hedit,szName,iLength+1); wcscat(szName,L"--New"); SetWindowText
【转载】win32gui 窗口查找和遍历
weixin_30414635的博客
07-25 717
#coding=utf-8 __author__ = 'Administrator' __doc__ = ''' pythonwin中win32gui的用法 本文件演如何使用win32gui来遍历系统中所有的顶层窗口， 并遍历所有顶层窗口中的子窗口 ''' import win32gui from pprint import pprint d...
python 遍历指定窗口的所有子窗口和孙窗口，并返回符合条件的窗口句柄和屏幕位置 并点击
06-09
好的，以下是使用 Python 实现遍历指定窗口的所有子窗口和孙窗口，并返回符合条件的窗口句柄和屏幕位置，并点击的示例代码： ```python import win32gui import win32api def find_child_windows(hwnd, class_name...
python 遍历指定窗口的所有子窗口和孙窗口，并返回符合条件的窗口句柄和屏幕位置 并点击 所在位置的中间
06-09
好的，以下是使用 Python 实现遍历指定窗口的所有子窗口和孙窗口，并返回符合条件的窗口句柄和屏幕位置，并点击所在位置的中间的示例代码： ```python import win32gui import win32api def find_child_windows...
VC获得指定窗口中的内容显示在标题栏
03-15
例如，如果我们知道目标窗口的类名和标题，我们可以这样获取句柄： ```cpp HWND hWnd = FindWindow(NULL, L"窗口标题"); ``` 如果只需要根据窗口标题获取句柄，可以将类名参数设为NULL。 获取到窗口句柄后，我们...
译：如何使用win32 api中的edit控件
初涉职场
04-25 2771
译：如何使用win32 api中的edit控件――――利用Edit类进行windows gui编程的方法和技巧© Guy Lecky-Thompson   Jun 14, 2007 Article describing the Win32 edit class and how to use it as a child window control in a Windows ap
python pywin32 获取窗体edit内容_pywin32
weixin_39970064的博客
11-30 3421
# 获取所有活动窗口的标题 # ! /usr/bin/env python # -*- coding: utf-8 -*- import time import win32gui import win32api import win32con """ 该类实现了:查找(定位)句柄信息，菜单信息 """ class HandleMenu(object): def __init__(se...
Python 获取class_name win32gui
qh0526wy的博客
06-20 675
win32gui是 Python 的一个扩展库，它提供了对 Windows GUI API 的访问，允许你编写脚本来与 Windows 桌面应用程序进行交互。以下是win32gui。
Win32汇编获取和设置文本框的内容
bcbobo21cn的专栏
10-03 1264
看一下Win32汇编如何获取和设置文本框的内容； 资源文件如下； #include <resource.h> #define ICO_MAIN 0x1000 //图标 #define DLG_MAIN 1 #define IDC_TXT1 2001 #define IDC_TXT2 2002 ICO_MAIN ICON "Main.ico" DLG_MAIN DIALOG 350, 250, 120, 150 STYLE DS_MODALFRAME | WS_POP
Win32学习笔记(17)子窗口
wzprabbit的博客
03-05 2008
1.子窗口控件： <1>WINDOWS 提供了几个预定义的窗口类以方便我们的使用，我们一般就它们叫做子窗口控件，简称控件 <2>控件会自己处理消息，并在自己状态发生改变时通知父窗口。 <3>预定义的控件有： 按钮、复选框、编辑框、静态字符串标签和滚动条等 1.那么什么是预定好的呢？在之前我们创建窗口时候我们必须自己定义窗口是什么样的。不过我们把 CreateWindow中第一个参数写成Button 或者 Edit就意味着我么使用了Windows预定义好的子.
python怎么区别同名窗口,win32gui选择两个同名窗口
weixin_39714191的博客
03-26 1355
我正在使用pywinauto创建python代码,以自动将两个Minecraft客户端设置为splitscreen。准备好之后,最后一步是让Minecraft的一个实例为0x0x1920x540,另一个实例为0x540x1920x540。但由于两个实例的名称完全相同,我只能选择和移动一个实例,是否有办法同时选择两个实例并在上面和下面排列?from pywinauto.application imp...
pywin32 获取 windows 的窗体内文本框的内容
baoda0398的博客
08-26 3976
用 spy++去确认找到了文本框的句柄了。 用函数 win32gui.SendMessage 获取不了文本框的文本内容，用 str 类型的参数接收获取的内容的话没有获取到东西，而用 PyBuffer 类型去获取则得到类似于 16 进制的东西。 希望能找到解决方案。 以下是代码： 1 from win32gui import * 2 from win32api import...
评论 2
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值