*** Settings ***
Library           ExcelLibrary
Library           DateTime
Library           String
Library           Collections
Library           RequestsLibrary
Library           urllib3
Library           DatabaseLibrary

*** Test Cases ***
ztbsc
    #数据驱动
    Open Excel    D:\\LYL\\Study\\Robot_framework\\New_Trading\\数据驱动.xls
    ${uecops}    Read Cell Data By Name    ztbsc    B10    #uec系统域名
    ${pscops}    Read Cell Data By Name    ztbsc    B15    #psc系统域名
    ${ztbops}    Read Cell Data By Name    ztbsc    B11    #ztb域名
    ${ztbscops}    Read Cell Data By Name    ztbsc    B13    #ztbsc域名
    ${uecclient}    Read Cell Data By Name    ztbsc    B2    #uec客户端域名
    ${ztbclient}    Read Cell Data By Name    ztbsc    B4    #client域名
    Set Global Variable    ${uecops}
    Set Global Variable    ${pscops}
    Set Global Variable    ${ztbops}
    Set Global Variable    ${ztbscops}
    Set Global Variable    ${uecclient}
    Set Global Variable    ${ztbclient}
    ${ztbsc_header}    Read Cell Data By Name    ztbsc    D10    #平台header
    ${client_header}    Read Cell Data By Name    ztbsc    D2    #客户端header
    ${client_login_header}    Read Cell Data By Name    ztbsc    D7    #客户端登录header
    ${ztbsc_traders_header}    Read Cell Data By Name    ztbsc    D18    #代理商端header
    ${ztbsc_papermill_header}    Read Cell Data By Name    ztbsc    D21    #纸厂端header
    ${ztbsc_factoring_header}    Read Cell Data By Name    ztbsc    D25    #保理商端header
    ${ztbsc_ops_login_header}    Read Cell Data By Name    ztbsc    D10    #平台登录header
    ${client_firstlogin_header}    Read Cell Data By Name    ztbsc    D8    #客户端首次登录header
    ${ztbsc_traders_login_header}    Read Cell Data By Name    ztbsc    D16    #代理商端登录header
    ${ztbsc_papermill_login_header}    Read Cell Data By Name    ztbsc    D20    #纸厂端登录header
    ${ztbsc_factoring_login_header}    Read Cell Data By Name    ztbsc    D23    #保理商端登录header
    Set Global Variable    ${ztbsc_header}
    Set Global Variable    ${client_header}
    Set Global Variable    ${client_login_header}
    Set Global Variable    ${ztbsc_traders_header}
    Set Global Variable    ${ztbsc_papermill_header}
    Set Global Variable    ${ztbsc_factoring_header}
    Set Global Variable    ${ztbsc_ops_login_header}
    Set Global Variable    ${client_firstlogin_header}
    Set Global Variable    ${ztbsc_traders_login_header}
    Set Global Variable    ${ztbsc_papermill_login_header}
    Set Global Variable    ${ztbsc_factoring_login_header}
    ${ztbsc_account}    Read Cell Data By Name    Account password    A4    #平台登录账号
    ${client_account}    Read Cell Data By Name    Account password    A3    #移动端登录账号
    ${ztbsc_password}    Read Cell Data By Name    Account password    B4    #平台登录密码
    ${client_password}    Read Cell Data By Name    Account password    B2    #移动端登录密码
    ${traders_account}    Read Cell Data By Name    Account password    A2    #代理商端登录账号
    ${traders_password}    Read Cell Data By Name    Account password    B2    #代理商端登录密码
    ${papermill_account}    Read Cell Data By Name    Account password    A2    #纸厂端登录账号
    ${factoring_account}    Read Cell Data By Name    Account password    A2    #保理商端登录账号
    ${papermill_password}    Read Cell Data By Name    Account password    B2    #纸厂端登录密码
    ${factoring_password}    Read Cell Data By Name    Account password    B2    #保理商端登录密码
    Set Global Variable    ${ztbsc_account}
    Set Global Variable    ${client_account}
    Set Global Variable    ${ztbsc_password}
    Set Global Variable    ${client_password}
    Set Global Variable    ${traders_account}
    Set Global Variable    ${traders_password}
    Set Global Variable    ${papermill_account}
    Set Global Variable    ${factoring_account}
    Set Global Variable    ${papermill_password}
    Set Global Variable    ${factoring_password}
    ${start_time}    get current date    result_format=%Y-%m-%d
    ${str_end_time}    Add Time To Date    ${start_time}    30 days
    ${end_time}    Get Substring    ${str_end_time}    0    10
    ${time}    Get Time
    Set Global Variable    ${start_time}
    Set Global Variable    ${end_time}
    Set Global Variable    ${time}