*** Settings ***
Test Teardown     Run Keyword If Test Failed    Fatal Error
Library           DateTime
Library           ExcelLibrary

*** Test Cases ***
current_datetime
    ${current_time}    Get Current Date
    ${current_date}    Convert Date    ${current_time}    result_format=%Y-%m-%d
    Set Global Variable    ${current_date}
    ${current_date_month}    Convert Date    ${current_time}    result_format=%Y-%m
    Set Global Variable    ${current_date_month}
    ${current_date_second}    Convert Date    ${current_time}    result_format=%Y-%m-%d %H:%M:%S
    Set Global Variable    ${current_date_second}

base_url_header
    Open Excel    ./datas/000_base.xls
    ${uecops}    Read Cell Data By Name    url    B1
    ${yytops}    Read Cell Data By Name    url    B2
    ${pscops}    Read Cell Data By Name    url    B3
    ${pscclient}    Read Cell Data By Name    url    B4
    ${yytclient}    Read Cell Data By Name    url    B5
    ${uecclient}    Read Cell Data By Name    url    B6
    Set Global Variable    ${uecops}
    Set Global Variable    ${yytops}
    Set Global Variable    ${pscops}
    Set Global Variable    ${pscclient}
    Set Global Variable    ${yytclient}
    Set Global Variable    ${uecclient}
    ${cloud_factory_customer_header}    Read Cell Data By Name    header    B1
    ${cloud_factory_supplier_header}    Read Cell Data By Name    header    B2
    ${cloud_factory_supplierfocus_header}    Read Cell Data By Name    header    B3
    ${operation_backend_header}    Read Cell Data By Name    header    B4
    ${operation_psc_header}    Read Cell Data By Name    header    B5
    Set Global Variable    ${cloud_factory_customer_header}
    Set Global Variable    ${cloud_factory_supplier_header}
    Set Global Variable    ${cloud_factory_supplierfocus_header}
    Set Global Variable    ${operation_backend_header}
    Set Global Variable    ${operation_psc_header}
    #${cloudfactory_customer_header}    Read Cell Data By Name    header_token    B1
    #${cloudfactory_supplier_header}    Read Cell Data By Name    header_token    B2
    #${cloudfactory_supplierfocus_header}    Read Cell Data By Name    header_token    B3
    #${operationbackend_header}    Read Cell Data By Name    header_token    B4
    #${operationpsc_header}    Read Cell Data By Name    header_token    B5
    #Set Global Variable    ${cloudfactory_customer_header}
    #Set Global Variable    ${cloudfactory_supplier_header}
    #Set Global Variable    ${cloudfactory_supplierfocus_header}
    #Set Global Variable    ${operationbackend_header}
    #Set Global Variable    ${operationpsc_header}

get_login_datas
    #Open Excel    ./datas/001_login.xls
    #${rows}    Get Row Count    customer_phone
    #FOR    ${row}    IN RANGE    1    ${rows}
    #    ${accounttype}    Read Cell Data By Coordinates    customer_phone    0    ${row}
    #    ${account}    Read Cell Data By Coordinates    customer_phone    1    ${row}
    #    ${captcha}    Read Cell Data By Coordinates    customer_phone    2    ${row}
    #END
    Open Excel    ./datas/001_login.xls
    ${accounttype_customer}    Read Cell Data By Name    customer_phone    A2
    ${account_customer}    Read Cell Data By Name    customer_phone    B2
    ${captcha_customer}    Read Cell Data By Name    customer_phone    C2
    Set Global Variable    ${accounttype_customer}
    Set Global Variable    ${account_customer}
    Set Global Variable    ${captcha_customer}
    ${accounttype_supplier}    Read Cell Data By Name    supplier_phone    A2
    ${account_supplier}    Read Cell Data By Name    supplier_phone    B2
    ${captcha_supplier}    Read Cell Data By Name    supplier_phone    C2
    Set Global Variable    ${accounttype_supplier}
    Set Global Variable    ${account_supplier}
    Set Global Variable    ${captcha_supplier}
    ${accounttype_supplierfocus}    Read Cell Data By Name    supplier_focus_phone    A2
    ${account_supplierfocus}    Read Cell Data By Name    supplier_focus_phone    B2
    ${captcha_supplierfocus}    Read Cell Data By Name    supplier_focus_phone    C2
    Set Global Variable    ${accounttype_supplierfocus}
    Set Global Variable    ${account_supplierfocus}
    Set Global Variable    ${captcha_supplierfocus}
    ${username_operate}    Read Cell Data By Name    operate_mail    A2
    ${password_operate}    Read Cell Data By Name    operate_mail    B2
    Set Global Variable    ${username_operate}
    Set Global Variable    ${password_operate}
    ${username_operatepsc}    Read Cell Data By Name    operate_psc_mail    A2
    ${password_operatepsc}    Read Cell Data By Name    operate_psc_mail    B2
    Set Global Variable    ${username_operatepsc}
    Set Global Variable    ${password_operatepsc}

get_user_register_datas
    Open Excel    ./datas/002_user_register.xls
    ${customer_companyname}    Read Cell Data By Name    customerclue_customer    A2
    ${customer_enterprisetype}    Read Cell Data By Name    customerclue_customer    B2
    ${customer_job}    Read Cell Data By Name    customerclue_customer    C2
    ${customer_name}    Read Cell Data By Name    customerclue_customer    D2
    Set Global Variable    ${customer_companyname}
    Set Global Variable    ${customer_enterprisetype}
    Set Global Variable    ${customer_job}
    Set Global Variable    ${customer_name}
    ${customer_businesslicense}    Read Cell Data By Name    uploadpictures_customer    A2
    ${customer_idcardback}    Read Cell Data By Name    uploadpictures_customer    B2
    ${customer_idcardfront}    Read Cell Data By Name    uploadpictures_customer    C2
    ${customerclue_type}    Read Cell Data By Name    uploadpictures_customer    D2
    Set Global Variable    ${customer_businesslicense}
    Set Global Variable    ${customer_idcardback}
    Set Global Variable    ${customer_idcardfront}
    Set Global Variable    ${customerclue_type}
    ${supplier_companyname}    Read Cell Data By Name    customerclue_supplier    A2
    ${supplier_enterprisetype}    Read Cell Data By Name    customerclue_supplier    B2
    ${supplier_job}    Read Cell Data By Name    customerclue_supplier    C2
    ${supplier_name}    Read Cell Data By Name    customerclue_supplier    D2
    Set Global Variable    ${supplier_companyname}
    Set Global Variable    ${supplier_enterprisetype}
    Set Global Variable    ${supplier_job}
    Set Global Variable    ${supplier_name}
    ${supplier_businesslicense}    Read Cell Data By Name    uploadpictures_supplier    A2
    ${supplier_idcardback}    Read Cell Data By Name    uploadpictures_supplier    B2
    ${supplier_idcardfront}    Read Cell Data By Name    uploadpictures_supplier    C2
    ${customerclue_type}    Read Cell Data By Name    uploadpictures_supplier    D2
    Set Global Variable    ${supplier_businesslicense}
    Set Global Variable    ${supplier_idcardback}
    Set Global Variable    ${supplier_idcardfront}
    Set Global Variable    ${customerclue_type}

get_customer_open_account_datas
    Open Excel    ./datas/003_open_account_customer.xls
    ${printing_packaging_factory_name}    Read Cell Data By Name    open_account    A2
    ${printing_packaging_factory_type}    Read Cell Data By Name    open_account    B2
    ${printing_packaging_factory_shortname}    Read Cell Data By Name    open_account    C2
    ${printing_packaging_factory_uniformsocialcreditcode}    Read Cell Data By Name    open_account    D2
    ${printing_packaging_factory_locdetail}    Read Cell Data By Name    open_account    E2
    ${printing_packaging_factory_legalpersonname}    Read Cell Data By Name    open_account    F2
    ${printing_packaging_factory_legalpersonidcardno}    Read Cell Data By Name    open_account    G2
    ${printing_packaging_factory_locprovinceid}    Read Cell Data By Name    open_account    H2
    ${printing_packaging_factory_loccityid}    Read Cell Data By Name    open_account    I2
    ${printing_packaging_factory_locdistrictid}    Read Cell Data By Name    open_account    J2
    ${printing_packaging_factory_locstreetid}    Read Cell Data By Name    open_account    K2
    ${printing_packaging_factory_locprovincename}    Read Cell Data By Name    open_account    L2
    ${printing_packaging_factory_loccityname}    Read Cell Data By Name    open_account    M2
    ${printing_packaging_factory_locdistrictname}    Read Cell Data By Name    open_account    N2
    ${printing_packaging_factory_locstreetname}    Read Cell Data By Name    open_account    O2
    Set Global Variable    ${printing_packaging_factory_name}
    Set Global Variable    ${printing_packaging_factory_type}
    Set Global Variable    ${printing_packaging_factory_shortname}
    Set Global Variable    ${printing_packaging_factory_uniformsocialcreditcode}
    Set Global Variable    ${printing_packaging_factory_locdetail}
    Set Global Variable    ${printing_packaging_factory_legalpersonname}
    Set Global Variable    ${printing_packaging_factory_legalpersonidcardno}
    Set Global Variable    ${printing_packaging_factory_locprovinceid}
    Set Global Variable    ${printing_packaging_factory_loccityid}
    Set Global Variable    ${printing_packaging_factory_locdistrictid}
    Set Global Variable    ${printing_packaging_factory_locstreetid}
    Set Global Variable    ${printing_packaging_factory_locprovincename}
    Set Global Variable    ${printing_packaging_factory_loccityname}
    Set Global Variable    ${printing_packaging_factory_locdistrictname}
    Set Global Variable    ${printing_packaging_factory_locstreetname}
    ${printing_packaging_factory_base_info_name}    Read Cell Data By Name    base_info    A2
    ${printing_packaging_factory_base_info_type}    Read Cell Data By Name    base_info    B2
    ${printing_packaging_factory_base_info_shortname}    Read Cell Data By Name    base_info    C2
    ${printing_packaging_factory_base_info_uniformsocialcreditcode}    Read Cell Data By Name    base_info    D2
    ${printing_packaging_factory_base_info_locdetail}    Read Cell Data By Name    base_info    E2
    ${printing_packaging_factory_base_info_legalpersonname}    Read Cell Data By Name    base_info    F2
    ${printing_packaging_factory_base_info_legalpersonidcardno}    Read Cell Data By Name    base_info    G2
    ${printing_packaging_factory_base_info_locprovinceid}    Read Cell Data By Name    base_info    H2
    ${printing_packaging_factory_base_info_loccityid}    Read Cell Data By Name    base_info    I2
    ${printing_packaging_factory_base_info_locdistrictid}    Read Cell Data By Name    base_info    J2
    ${printing_packaging_factory_base_info_locstreetid}    Read Cell Data By Name    base_info    K2
    ${printing_packaging_factory_base_info_locprovincename}    Read Cell Data By Name    base_info    L2
    ${printing_packaging_factory_base_info_loccityname}    Read Cell Data By Name    base_info    M2
    ${printing_packaging_factory_base_info_locdistrictname}    Read Cell Data By Name    base_info    N2
    ${printing_packaging_factory_base_info_locstreetname}    Read Cell Data By Name    base_info    O2
    ${printing_packaging_factory_base_info_legalpersonmobile}    Read Cell Data By Name    base_info    P2
    ${printing_packaging_factory_base_info_businessLicense}    Read Cell Data By Name    base_info    Q2
    ${printing_packaging_factory_base_info_legalPersonIdCardBack}    Read Cell Data By Name    base_info    R2
    ${printing_packaging_factory_base_info_legalPersonIdCardFront}    Read Cell Data By Name    base_info    S2
    Set Global Variable    ${printing_packaging_factory_base_info_name}
    Set Global Variable    ${printing_packaging_factory_base_info_type}
    Set Global Variable    ${printing_packaging_factory_base_info_shortname}
    Set Global Variable    ${printing_packaging_factory_base_info_uniformsocialcreditcode}
    Set Global Variable    ${printing_packaging_factory_base_info_locdetail}
    Set Global Variable    ${printing_packaging_factory_base_info_legalpersonname}
    Set Global Variable    ${printing_packaging_factory_base_info_legalpersonidcardno}
    Set Global Variable    ${printing_packaging_factory_base_info_locprovinceid}
    Set Global Variable    ${printing_packaging_factory_base_info_loccityid}
    Set Global Variable    ${printing_packaging_factory_base_info_locdistrictid}
    Set Global Variable    ${printing_packaging_factory_base_info_locstreetid}
    Set Global Variable    ${printing_packaging_factory_base_info_locprovincename}
    Set Global Variable    ${printing_packaging_factory_base_info_loccityname}
    Set Global Variable    ${printing_packaging_factory_base_info_locdistrictname}
    Set Global Variable    ${printing_packaging_factory_base_info_locstreetname}
    Set Global Variable    ${printing_packaging_factory_base_info_legalpersonmobile}
    Set Global Variable    ${printing_packaging_factory_base_info_businessLicense}
    Set Global Variable    ${printing_packaging_factory_base_info_legalPersonIdCardBack}
    Set Global Variable    ${printing_packaging_factory_base_info_legalPersonIdCardFront}
    ${printing_packaging_factory_factory_locdetail}    Read Cell Data By Name    factory_info    A2
    ${printing_packaging_factory_factory_locprovinceid}    Read Cell Data By Name    factory_info    B2
    ${printing_packaging_factory_factory_loccityid}    Read Cell Data By Name    factory_info    C2
    ${printing_packaging_factory_factory_locdistrictid}    Read Cell Data By Name    factory_info    D2
    ${printing_packaging_factory_factory_locstreetid}    Read Cell Data By Name    factory_info    E2
    ${printing_packaging_factory_factory_locprovincename}    Read Cell Data By Name    factory_info    F2
    ${printing_packaging_factory_factory_loccityname}    Read Cell Data By Name    factory_info    G2
    ${printing_packaging_factory_factory_locdistrictname}    Read Cell Data By Name    factory_info    H2
    ${printing_packaging_factory_factory_locstreetname}    Read Cell Data By Name    factory_info    I2
    ${printing_packaging_factory_factory_factoryphotos}    Read Cell Data By Name    factory_info    J2
    ${printing_packaging_factory_factory_leasecontract}    Read Cell Data By Name    factory_info    K2
    ${printing_packaging_factory_factory_mainproducts}    Read Cell Data By Name    factory_info    L2
    Set Global Variable    ${printing_packaging_factory_factory_locdetail}
    Set Global Variable    ${printing_packaging_factory_factory_locprovinceid}
    Set Global Variable    ${printing_packaging_factory_factory_loccityid}
    Set Global Variable    ${printing_packaging_factory_factory_locdistrictid}
    Set Global Variable    ${printing_packaging_factory_factory_locstreetid}
    Set Global Variable    ${printing_packaging_factory_factory_locprovincename}
    Set Global Variable    ${printing_packaging_factory_factory_loccityname}
    Set Global Variable    ${printing_packaging_factory_factory_locdistrictname}
    Set Global Variable    ${printing_packaging_factory_factory_locstreetname}
    Set Global Variable    ${printing_packaging_factory_factory_factoryphotos}
    Set Global Variable    ${printing_packaging_factory_factory_leasecontract}
    Set Global Variable    ${printing_packaging_factory_factory_mainproducts}
    ${printing_packaging_factory_shipping_addresses_detail}    Read Cell Data By Name    shipping_addresses    A2
    ${printing_packaging_factory_shipping_addresses_provinceid}    Read Cell Data By Name    shipping_addresses    B2
    ${printing_packaging_factory_shipping_addresses_cityid}    Read Cell Data By Name    shipping_addresses    C2
    ${printing_packaging_factory_shipping_addresses_districtid}    Read Cell Data By Name    shipping_addresses    D2
    ${printing_packaging_factory_shipping_addresses_streetid}    Read Cell Data By Name    shipping_addresses    E2
    ${printing_packaging_factory_shipping_addresses_provincename}    Read Cell Data By Name    shipping_addresses    F2
    ${printing_packaging_factory_shipping_addresses_cityname}    Read Cell Data By Name    shipping_addresses    G2
    ${printing_packaging_factory_shipping_addresses_districtname}    Read Cell Data By Name    shipping_addresses    H2
    ${printing_packaging_factory_shipping_addresses_streetname}    Read Cell Data By Name    shipping_addresses    I2
    ${printing_packaging_factory_shipping_addresses_receiver}    Read Cell Data By Name    shipping_addresses    J2
    ${printing_packaging_factory_shipping_addresses_receivermobile}    Read Cell Data By Name    shipping_addresses    K2
    Set Global Variable    ${printing_packaging_factory_shipping_addresses_detail}
    Set Global Variable    ${printing_packaging_factory_shipping_addresses_provinceid}
    Set Global Variable    ${printing_packaging_factory_shipping_addresses_cityid}
    Set Global Variable    ${printing_packaging_factory_shipping_addresses_districtid}
    Set Global Variable    ${printing_packaging_factory_shipping_addresses_streetid}
    Set Global Variable    ${printing_packaging_factory_shipping_addresses_provincename}
    Set Global Variable    ${printing_packaging_factory_shipping_addresses_cityname}
    Set Global Variable    ${printing_packaging_factory_shipping_addresses_districtname}
    Set Global Variable    ${printing_packaging_factory_shipping_addresses_streetname}
    Set Global Variable    ${printing_packaging_factory_shipping_addresses_receiver}
    Set Global Variable    ${printing_packaging_factory_shipping_addresses_receivermobile}
    ${printing_packaging_factory_scrappaper_credit_deposit}    Read Cell Data By Name    scrap_paper_credit    A2
    ${printing_packaging_factory_scrappaper_credit_earnest}    Read Cell Data By Name    scrap_paper_credit    B2
    ${printing_packaging_factory_scrappaper_credit_totalUsed}    Read Cell Data By Name    scrap_paper_credit    C2
    Set Global Variable    ${printing_packaging_factory_scrappaper_credit_deposit}
    Set Global Variable    ${printing_packaging_factory_scrappaper_credit_earnest}
    Set Global Variable    ${printing_packaging_factory_scrappaper_credit_totalUsed}
    ${printing_packaging_factory_private_account_cardholdername}    Read Cell Data By Name    private_account    A2
    ${printing_packaging_factory_private_account_bankcardnumber}    Read Cell Data By Name    private_account    B2
    ${printing_packaging_factory_private_account_openingbank}    Read Cell Data By Name    private_account    C2
    Set Global Variable    ${printing_packaging_factory_private_account_cardholdername}
    Set Global Variable    ${printing_packaging_factory_private_account_bankcardnumber}
    Set Global Variable    ${printing_packaging_factory_private_account_openingbank}
    ${printing_packaging_factory_administrator_realname}    Read Cell Data By Name    administrator    A2
    ${printing_packaging_factory_administrator_title}    Read Cell Data By Name    administrator    B2
    ${printing_packaging_factory_administrator_mobile}    Read Cell Data By Name    administrator    C2
    Set Global Variable    ${printing_packaging_factory_administrator_realname}
    Set Global Variable    ${printing_packaging_factory_administrator_title}
    Set Global Variable    ${printing_packaging_factory_administrator_mobile}
    ${printing_packaging_factory_employee_position}    Read Cell Data By Name    add_employee    A2
    ${printing_packaging_factory_employee_realname}    Read Cell Data By Name    add_employee    B2
    Set Global Variable    ${printing_packaging_factory_employee_position}
    Set Global Variable    ${printing_packaging_factory_employee_realname}

get_supplier_open_account_datas
    Open Excel    ./datas/004_open_account_supplier_paper.xls
    ${virtual_supplier_name}    Read Cell Data By Name    virtual_supplier    A2
    ${virtual_supplier_shortName}    Read Cell Data By Name    virtual_supplier    B2
    ${virtual_supplier_details}    Read Cell Data By Name    virtual_supplier    C2
    ${virtual_supplier_contactname}    Read Cell Data By Name    virtual_supplier    D2
    ${virtual_supplier_contactmoblie}    Read Cell Data By Name    virtual_supplier    E2
    ${virtual_supplier_provinceid}    Read Cell Data By Name    virtual_supplier    F2
    ${virtual_supplier_cityid}    Read Cell Data By Name    virtual_supplier    G2
    ${virtual_supplier_districtid}    Read Cell Data By Name    virtual_supplier    H2
    ${virtual_supplier_streetid}    Read Cell Data By Name    virtual_supplier    I2
    ${virtual_supplier_provincename}    Read Cell Data By Name    virtual_supplier    J2
    ${virtual_supplier_cityname}    Read Cell Data By Name    virtual_supplier    K2
    ${virtual_supplier_districtname}    Read Cell Data By Name    virtual_supplier    L2
    ${virtual_supplier_streetname}    Read Cell Data By Name    virtual_supplier    M2
    Set Global Variable    ${virtual_supplier_name}
    Set Global Variable    ${virtual_supplier_shortName}
    Set Global Variable    ${virtual_supplier_details}
    Set Global Variable    ${virtual_supplier_contactname}
    Set Global Variable    ${virtual_supplier_contactmoblie}
    Set Global Variable    ${virtual_supplier_provinceid}
    Set Global Variable    ${virtual_supplier_cityid}
    Set Global Variable    ${virtual_supplier_districtid}
    Set Global Variable    ${virtual_supplier_streetid}
    Set Global Variable    ${virtual_supplier_provincename}
    Set Global Variable    ${virtual_supplier_cityname}
    Set Global Variable    ${virtual_supplier_districtname}
    Set Global Variable    ${virtual_supplier_streetname}
    ${supplier_paper_name}    Read Cell Data By Name    open_account    A2
    ${supplier_paper_type}    Read Cell Data By Name    open_account    B2
    ${supplier_paper_uniformSocialCreditCode}    Read Cell Data By Name    open_account    C2
    ${supplier_paper_legalPersonName}    Read Cell Data By Name    open_account    D2
    ${supplier_paper_legalPersonIdCardNo}    Read Cell Data By Name    open_account    E2
    ${supplier_paper_paperSettlementIntervalTypeId}    Read Cell Data By Name    open_account    F2
    ${supplier_paper_locProvinceId}    Read Cell Data By Name    open_account    G2
    ${supplier_paper_locCityId}    Read Cell Data By Name    open_account    H2
    ${supplier_paper_locDistrictId}    Read Cell Data By Name    open_account    I2
    ${supplier_paper_locStreetId}    Read Cell Data By Name    open_account    J2
    ${supplier_paper_locDetail}    Read Cell Data By Name    open_account    K2
    ${supplier_paper_legalPersonIdCardFrontImg}    Read Cell Data By Name    open_account    L2
    ${supplier_paper_legalPersonIdCardBackImg}    Read Cell Data By Name    open_account    M2
    ${supplier_paper_businessLicenseImg}    Read Cell Data By Name    open_account    N2
    ${supplier_paper_contactsname}    Read Cell Data By Name    open_account    O2
    ${supplier_paper_mobilePhone}    Read Cell Data By Name    open_account    P2
    ${supplier_paper_telephone}    Read Cell Data By Name    open_account    Q2
    ${supplier_paper_email}    Read Cell Data By Name    open_account    R2
    ${supplier_paper_wechatAccount}    Read Cell Data By Name    open_account    S2
    ${supplier_paper_remark}    Read Cell Data By Name    open_account    T2
    ${supplier_paper_bankAccountName}    Read Cell Data By Name    open_account    U2
    ${supplier_paper_bankAccount}    Read Cell Data By Name    open_account    V2
    ${supplier_paper_bankName}    Read Cell Data By Name    open_account    W2
    ${supplier_paper_accountOpeningBranch}    Read Cell Data By Name    open_account    X2
    ${supplier_paper_locationBank}    Read Cell Data By Name    open_account    Y2
    Set Global Variable    ${supplier_paper_name}
    Set Global Variable    ${supplier_paper_type}
    Set Global Variable    ${supplier_paper_uniformSocialCreditCode}
    Set Global Variable    ${supplier_paper_legalPersonName}
    Set Global Variable    ${supplier_paper_legalPersonIdCardNo}
    Set Global Variable    ${supplier_paper_paperSettlementIntervalTypeId}
    Set Global Variable    ${supplier_paper_locProvinceId}
    Set Global Variable    ${supplier_paper_locCityId}
    Set Global Variable    ${supplier_paper_locDistrictId}
    Set Global Variable    ${supplier_paper_locStreetId}
    Set Global Variable    ${supplier_paper_locDetail}
    Set Global Variable    ${supplier_paper_legalPersonIdCardFrontImg}
    Set Global Variable    ${supplier_paper_legalPersonIdCardBackImg}
    Set Global Variable    ${supplier_paper_businessLicenseImg}
    Set Global Variable    ${supplier_paper_contactsname}
    Set Global Variable    ${supplier_paper_mobilePhone}
    Set Global Variable    ${supplier_paper_telephone}
    Set Global Variable    ${supplier_paper_email}
    Set Global Variable    ${supplier_paper_wechatAccount}
    Set Global Variable    ${supplier_paper_remark}
    Set Global Variable    ${supplier_paper_bankAccountName}
    Set Global Variable    ${supplier_paper_bankAccount}
    Set Global Variable    ${supplier_paper_bankName}
    Set Global Variable    ${supplier_paper_accountOpeningBranch}
    Set Global Variable    ${supplier_paper_locationBank}
    ${supplier_paper_base_info_name}    Read Cell Data By Name    base_info    A2
    ${supplier_paper_base_info_shortName}    Read Cell Data By Name    base_info    B2
    ${supplier_paper_base_info_type}    Read Cell Data By Name    base_info    C2
    ${supplier_paper_base_info_uniformSocialCreditCode}    Read Cell Data By Name    base_info    D2
    ${supplier_paper_base_info_legalPersonName}    Read Cell Data By Name    base_info    E2
    ${supplier_paper_base_info_legalPersonIdCardNo}    Read Cell Data By Name    base_info    F2
    ${supplier_paper_base_info_legalPersonMobile}    Read Cell Data By Name    base_info    G2
    ${supplier_paper_base_info_paperSettlementIntervalTypeId}    Read Cell Data By Name    base_info    H2
    ${supplier_paper_base_info_locProvinceId}    Read Cell Data By Name    base_info    I2
    ${supplier_paper_base_info_locCityId}    Read Cell Data By Name    base_info    J2
    ${supplier_paper_base_info_locDistrictId}    Read Cell Data By Name    base_info    K2
    ${supplier_paper_base_info_locStreetId}    Read Cell Data By Name    base_info    L2
    ${supplier_paper_base_info_locprovincename}    Read Cell Data By Name    base_info    M2
    ${supplier_paper_base_info_loccityname}    Read Cell Data By Name    base_info    N2
    ${supplier_paper_base_info_locdistrictname}    Read Cell Data By Name    base_info    O2
    ${supplier_paper_base_info_locstreetname}    Read Cell Data By Name    base_info    P2
    ${supplier_paper_base_info_locDetail}    Read Cell Data By Name    base_info    Q2
    ${supplier_paper_base_info_legalPersonIdCardFrontImg}    Read Cell Data By Name    base_info    R2
    ${supplier_paper_base_info_legalPersonIdCardBackImg}    Read Cell Data By Name    base_info    S2
    ${supplier_paper_base_info_businessLicenseImg}    Read Cell Data By Name    base_info    T2
    Set Global Variable    ${supplier_paper_base_info_name}
    Set Global Variable    ${supplier_paper_base_info_shortName}
    Set Global Variable    ${supplier_paper_base_info_type}
    Set Global Variable    ${supplier_paper_base_info_uniformSocialCreditCode}
    Set Global Variable    ${supplier_paper_base_info_legalPersonName}
    Set Global Variable    ${supplier_paper_base_info_legalPersonIdCardNo}
    Set Global Variable    ${supplier_paper_base_info_legalPersonMobile}
    Set Global Variable    ${supplier_paper_base_info_paperSettlementIntervalTypeId}
    Set Global Variable    ${supplier_paper_base_info_locProvinceId}
    Set Global Variable    ${supplier_paper_base_info_locCityId}
    Set Global Variable    ${supplier_paper_base_info_locDistrictId}
    Set Global Variable    ${supplier_paper_base_info_locStreetId}
    Set Global Variable    ${supplier_paper_base_info_locprovincename}
    Set Global Variable    ${supplier_paper_base_info_loccityname}
    Set Global Variable    ${supplier_paper_base_info_locdistrictname}
    Set Global Variable    ${supplier_paper_base_info_locstreetname}
    Set Global Variable    ${supplier_paper_base_info_locDetail}
    Set Global Variable    ${supplier_paper_base_info_legalPersonIdCardFrontImg}
    Set Global Variable    ${supplier_paper_base_info_legalPersonIdCardBackImg}
    Set Global Variable    ${supplier_paper_base_info_businessLicenseImg}
    ${supplier_factory_locProvinceId}    Read Cell Data By Name    factory_info    A2
    ${supplier_factory_locCityId}    Read Cell Data By Name    factory_info    B2
    ${supplier_factory_locDistrictId}    Read Cell Data By Name    factory_info    C2
    ${supplier_factory_locStreetId}    Read Cell Data By Name    factory_info    D2
    ${supplier_factory_locprovincename}    Read Cell Data By Name    factory_info    E2
    ${supplier_factory_loccityname}    Read Cell Data By Name    factory_info    F2
    ${supplier_factory_locdistrictname}    Read Cell Data By Name    factory_info    G2
    ${supplier_factory_locstreetname}    Read Cell Data By Name    factory_info    H2
    ${supplier_factory_locDetail}    Read Cell Data By Name    factory_info    I2
    ${supplier_factory_leaseContractImg}    Read Cell Data By Name    factory_info    J2
    ${supplier_factory_factoryPhotos}    Read Cell Data By Name    factory_info    K2
    Set Global Variable    ${supplier_factory_locProvinceId}
    Set Global Variable    ${supplier_factory_locCityId}
    Set Global Variable    ${supplier_factory_locDistrictId}
    Set Global Variable    ${supplier_factory_locStreetId}
    Set Global Variable    ${supplier_factory_locprovincename}
    Set Global Variable    ${supplier_factory_loccityname}
    Set Global Variable    ${supplier_factory_locdistrictname}
    Set Global Variable    ${supplier_factory_locstreetname}
    Set Global Variable    ${supplier_factory_locDetail}
    Set Global Variable    ${supplier_factory_leaseContractImg}
    Set Global Variable    ${supplier_factory_factoryPhotos}
    ${supplier_private_account_cardholderName}    Read Cell Data By Name    private_account    A2
    ${supplier_private_account_bankCardNumber}    Read Cell Data By Name    private_account    B2
    ${supplier_private_account_openingBank}    Read Cell Data By Name    private_account    C2
    Set Global Variable    ${supplier_private_account_cardholderName}
    Set Global Variable    ${supplier_private_account_bankCardNumber}
    Set Global Variable    ${supplier_private_account_openingBank}
    ${supplier_machine_name}    Read Cell Data By Name    add_pc_machine    A2
    ${supplier_machineType}    Read Cell Data By Name    add_pc_machine    B2
    Set Global Variable    ${supplier_machine_name}
    Set Global Variable    ${supplier_machineType}
    ${supplier_enterprise_administrator_realname}    Read Cell Data By Name    administrator    A2
    ${supplier_enterprise_administrator_mobile}    Read Cell Data By Name    administrator    B2
    ${supplier_enterprise_administrator_position}    Read Cell Data By Name    administrator    C2
    Set Global Variable    ${supplier_enterprise_administrator_realname}
    Set Global Variable    ${supplier_enterprise_administrator_mobile}
    Set Global Variable    ${supplier_enterprise_administrator_position}

get_credit_qniao_customer_datas
    Open Excel    ./datas/005_credit_qniao_customer.xls
    ${printing_packaging_factory_credit_qniao_save_type}    Read Cell Data By Name    credit_qniao_save    A2
    ${printing_packaging_factory_credit_qniao_save_purpose}    Read Cell Data By Name    credit_qniao_save    B2
    ${printing_packaging_factory_credit_qniao_save_creditLine}    Read Cell Data By Name    credit_qniao_save    C2
    ${printing_packaging_factory_credit_qniao_save_paperSettlementIntervalTypeId}    Read Cell Data By Name    credit_qniao_save    D2
    ${printing_packaging_factory_credit_qniao_save_remark}    Read Cell Data By Name    credit_qniao_save    E2
    Set Global Variable    ${printing_packaging_factory_credit_qniao_save_type}
    Set Global Variable    ${printing_packaging_factory_credit_qniao_save_purpose}
    Set Global Variable    ${printing_packaging_factory_credit_qniao_save_creditLine}
    Set Global Variable    ${printing_packaging_factory_credit_qniao_save_paperSettlementIntervalTypeId}
    Set Global Variable    ${printing_packaging_factory_credit_qniao_save_remark}
    ${printing_packaging_factory_credit_qniao_edit_type}    Read Cell Data By Name    credit_qniao_edit    A2
    ${printing_packaging_factory_credit_qniao_edit_purpose}    Read Cell Data By Name    credit_qniao_edit    B2
    ${printing_packaging_factory_credit_qniao_edit_creditLine}    Read Cell Data By Name    credit_qniao_edit    C2
    ${printing_packaging_factory_credit_qniao_edit_paperSettlementIntervalTypeId}    Read Cell Data By Name    credit_qniao_edit    D2
    ${printing_packaging_factory_credit_qniao_edit_remark}    Read Cell Data By Name    credit_qniao_edit    E2
    Set Global Variable    ${printing_packaging_factory_credit_qniao_edit_type}
    Set Global Variable    ${printing_packaging_factory_credit_qniao_edit_purpose}
    Set Global Variable    ${printing_packaging_factory_credit_qniao_edit_creditLine}
    Set Global Variable    ${printing_packaging_factory_credit_qniao_edit_paperSettlementIntervalTypeId}
    Set Global Variable    ${printing_packaging_factory_credit_qniao_edit_remark}

get_credit_password_datas
    Open Excel    ./datas/006_credit_password.xls
    ${customer_credit_password}    Read Cell Data By Name    credit_password_save    A2
    ${save_creditpassword_type}    Read Cell Data By Name    credit_password_save    B2
    Set Global Variable    ${customer_credit_password}
    Set Global Variable    ${save_creditpassword_type}
    ${customer_credit_password_new}    Read Cell Data By Name    credit_password_edit    A2
    ${save_creditpassword_type_new}    Read Cell Data By Name    credit_password_edit    B2
    Set Global Variable    ${customer_credit_password_new}
    Set Global Variable    ${save_creditpassword_type_new}

get_paper_variety_management_datas
    Open Excel    ./datas/007_paper_variety_management.xls
    ${paper_categoryid}    Read Cell Data By Name    paper_brand    A2
    ${paper_Manufacturerid}    Read Cell Data By Name    paper_brand    B2
    ${paper_brand_name}    Read Cell Data By Name    paper_brand    C2
    ${paper_name}    Read Cell Data By Name    paper_brand    D2
    ${paper_characteristic}    Read Cell Data By Name    paper_brand    E2
    ${paper_description}    Read Cell Data By Name    paper_brand    F2
    ${paper_brand_img}    Read Cell Data By Name    paper_brand    G2
    Set Global Variable    ${paper_categoryid}
    Set Global Variable    ${paper_Manufacturerid}
    Set Global Variable    ${paper_brand_name}
    Set Global Variable    ${paper_name}
    Set Global Variable    ${paper_characteristic}
    Set Global Variable    ${paper_description}
    Set Global Variable    ${paper_brand_img}
    ${paper_category_name}    Read Cell Data By Name    paper_category    A2
    Set Global Variable    ${paper_category_name}
    ${paper_manufacturer_name}    Read Cell Data By Name    paper_manufacturer    A2
    ${paper_manufacturer_shortName}    Read Cell Data By Name    paper_manufacturer    B2
    ${paper_manufacturer_description}    Read Cell Data By Name    paper_manufacturer    C2
    ${paper_manufacturer_logoImg}    Read Cell Data By Name    paper_manufacturer    D2
    Set Global Variable    ${paper_manufacturer_name}
    Set Global Variable    ${paper_manufacturer_shortName}
    Set Global Variable    ${paper_manufacturer_description}
    Set Global Variable    ${paper_manufacturer_logoImg}

get_market_information_link_datas
    Open Excel    ./datas/008_market_information_link.xls
    ${market_information_link}    Read Cell Data By Name    link    A2
    Set Global Variable    ${market_information_link}

get_product_manage_datas
    Open Excel    ./datas/009_product_manage.xls
    ${gramweight}    Read Cell Data By Name    product_save    A2
    ${purchasePrice}    Read Cell Data By Name    product_save    B2
    Set Global Variable    ${gramweight}
    Set Global Variable    ${purchasePrice}

get_product_price_datas
    Open Excel    ./datas/012_product_price.xls
    ${product_price_sku_alterType}    Read Cell Data By Name    product_price_update    A2
    ${product_price_sku_new}    Read Cell Data By Name    product_price_update    B2
    Set Global Variable    ${product_price_sku_alterType}
    Set Global Variable    ${product_price_sku_new}

get_customer_shipping_address_datas
    Open Excel    ./datas/014_customer_shipping_address.xls
    ${customer_enterprise_shipping_address_isDefault}    Read Cell Data By Name    shipping_address_save    A2
    ${customer_enterprise_shipping_address_receiver}    Read Cell Data By Name    shipping_address_save    B2
    ${customer_enterprise_shipping_address_receiverMobile}    Read Cell Data By Name    shipping_address_save    C2
    ${customer_enterprise_shipping_address_detail}    Read Cell Data By Name    shipping_address_save    D2
    ${customer_enterprise_shipping_address_provinceid}    Read Cell Data By Name    shipping_address_save    E2
    ${customer_enterprise_shipping_address_cityid}    Read Cell Data By Name    shipping_address_save    F2
    ${customer_enterprise_shipping_address_districtid}    Read Cell Data By Name    shipping_address_save    G2
    ${customer_enterprise_shipping_address_streetid}    Read Cell Data By Name    shipping_address_save    H2
    ${customer_enterprise_shipping_address_provincename}    Read Cell Data By Name    shipping_address_save    I2
    ${customer_enterprise_shipping_address_cityname}    Read Cell Data By Name    shipping_address_save    J2
    ${customer_enterprise_shipping_address_districtname}    Read Cell Data By Name    shipping_address_save    K2
    ${customer_enterprise_shipping_address_streetname}    Read Cell Data By Name    shipping_address_save    L2
    Set Global Variable    ${customer_enterprise_shipping_address_isDefault}
    Set Global Variable    ${customer_enterprise_shipping_address_receiver}
    Set Global Variable    ${customer_enterprise_shipping_address_receiverMobile}
    Set Global Variable    ${customer_enterprise_shipping_address_detail}
    Set Global Variable    ${customer_enterprise_shipping_address_provinceid}
    Set Global Variable    ${customer_enterprise_shipping_address_cityid}
    Set Global Variable    ${customer_enterprise_shipping_address_districtid}
    Set Global Variable    ${customer_enterprise_shipping_address_streetid}
    Set Global Variable    ${customer_enterprise_shipping_address_provincename}
    Set Global Variable    ${customer_enterprise_shipping_address_cityname}
    Set Global Variable    ${customer_enterprise_shipping_address_districtname}
    Set Global Variable    ${customer_enterprise_shipping_address_streetname}

get_customer_create_order_datas
    Open Excel    ./datas/015_customer_create_order.xls
    ${customer_create_order_paymentMethod}    Read Cell Data By Name    create_order    A2
    ${customer_create_order_width}    Read Cell Data By Name    create_order    B2
    ${customer_create_order_length}    Read Cell Data By Name    create_order    C2
    ${customer_create_order_quantity}    Read Cell Data By Name    create_order    D2
    ${customer_create_order_bootFee}    Read Cell Data By Name    create_order    E2
    ${customer_create_order_cuttingFee}    Read Cell Data By Name    create_order    F2
    ${customer_create_order_freightFee}    Read Cell Data By Name    create_order    G2
    ${customer_create_order_serviceFee}    Read Cell Data By Name    create_order    H2
    ${customer_create_order_otherFee}    Read Cell Data By Name    create_order    I2
    Set Global Variable    ${customer_create_order_paymentMethod}
    Set Global Variable    ${customer_create_order_width}
    Set Global Variable    ${customer_create_order_length}
    Set Global Variable    ${customer_create_order_quantity}
    Set Global Variable    ${customer_create_order_bootFee}
    Set Global Variable    ${customer_create_order_cuttingFee}
    Set Global Variable    ${customer_create_order_freightFee}
    Set Global Variable    ${customer_create_order_serviceFee}
    Set Global Variable    ${customer_create_order_otherFee}

get_customer_enquiry_create_order_datas
    Open Excel    ./datas/016_customer_enquiry_create_order.xls
    ${customer_enquiryContent}    Read Cell Data By Name    enquiry_add    A2
    ${customer_enquiry_deliveryDay}    Read Cell Data By Name    enquiry_add    B2
    ${customer_enquiry_deliveryArea}    Read Cell Data By Name    enquiry_add    C2
    Set Global Variable    ${customer_enquiryContent}
    Set Global Variable    ${customer_enquiry_deliveryDay}
    Set Global Variable    ${customer_enquiry_deliveryArea}
    ${enquiry_gramWeight1}    Read Cell Data By Name    enquiry_edit    A2
    ${enquiry_width1}    Read Cell Data By Name    enquiry_edit    B2
    ${enquiry_length1}    Read Cell Data By Name    enquiry_edit    C2
    ${enquiry_quantity1}    Read Cell Data By Name    enquiry_edit    D2
    ${enquiry_gramWeight2}    Read Cell Data By Name    enquiry_edit    E2
    ${enquiry_width2}    Read Cell Data By Name    enquiry_edit    F2
    ${enquiry_length2}    Read Cell Data By Name    enquiry_edit    G2
    ${enquiry_quantity2}    Read Cell Data By Name    enquiry_edit    H2
    ${customer_enquiry_remark}    Read Cell Data By Name    enquiry_edit    I2
    Set Global Variable    ${enquiry_gramWeight1}
    Set Global Variable    ${enquiry_width1}
    Set Global Variable    ${enquiry_length1}
    Set Global Variable    ${enquiry_quantity1}
    Set Global Variable    ${enquiry_gramWeight2}
    Set Global Variable    ${enquiry_width2}
    Set Global Variable    ${enquiry_length2}
    Set Global Variable    ${enquiry_quantity2}
    Set Global Variable    ${customer_enquiry_remark}
    ${paper_quotation_gramWeight1}    Read Cell Data By Name    submit_paper_quotation    A2
    ${paper_quotation_width1}    Read Cell Data By Name    submit_paper_quotation    B2
    ${paper_quotation_length1}    Read Cell Data By Name    submit_paper_quotation    C2
    ${paper_quotation_quantity1}    Read Cell Data By Name    submit_paper_quotation    D2
    ${paper_quotation_otherFee}    Read Cell Data By Name    submit_paper_quotation    E2
    ${paper_quotation_gramWeight2}    Read Cell Data By Name    submit_paper_quotation    F2
    ${paper_quotation_width2}    Read Cell Data By Name    submit_paper_quotation    G2
    ${paper_quotation_length2}    Read Cell Data By Name    submit_paper_quotation    H2
    ${paper_quotation_quantity2}    Read Cell Data By Name    submit_paper_quotation    I2
    ${supplierfocus_paper_quotation_remark}    Read Cell Data By Name    submit_paper_quotation    J2
    Set Global Variable    ${paper_quotation_gramWeight1}
    Set Global Variable    ${paper_quotation_width1}
    Set Global Variable    ${paper_quotation_length1}
    Set Global Variable    ${paper_quotation_quantity1}
    Set Global Variable    ${paper_quotation_otherFee}
    Set Global Variable    ${paper_quotation_gramWeight2}
    Set Global Variable    ${paper_quotation_width2}
    Set Global Variable    ${paper_quotation_length2}
    Set Global Variable    ${paper_quotation_quantity2}
    Set Global Variable    ${supplierfocus_paper_quotation_remark}
    ${customer_create_order_paymentMethod}    Read Cell Data By Name    enquiry_create_order    A2
    ${customer_create_order_bootFee1}    Read Cell Data By Name    enquiry_create_order    B2
    ${customer_create_order_cuttingFee1}    Read Cell Data By Name    enquiry_create_order    C2
    ${customer_create_order_freightFee1}    Read Cell Data By Name    enquiry_create_order    D2
    ${customer_create_order_serviceFee1}    Read Cell Data By Name    enquiry_create_order    E2
    ${customer_create_order_bootFee2}    Read Cell Data By Name    enquiry_create_order    F2
    ${customer_create_order_cuttingFee2}    Read Cell Data By Name    enquiry_create_order    G2
    ${customer_create_order_freightFee2}    Read Cell Data By Name    enquiry_create_order    H2
    ${customer_create_order_serviceFee2}    Read Cell Data By Name    enquiry_create_order    I2
    Set Global Variable    ${customer_create_order_paymentMethod}
    Set Global Variable    ${customer_create_order_bootFee1}
    Set Global Variable    ${customer_create_order_cuttingFee1}
    Set Global Variable    ${customer_create_order_freightFee1}
    Set Global Variable    ${customer_create_order_serviceFee1}
    Set Global Variable    ${customer_create_order_bootFee2}
    Set Global Variable    ${customer_create_order_cuttingFee2}
    Set Global Variable    ${customer_create_order_freightFee2}
    Set Global Variable    ${customer_create_order_serviceFee2}

get_create_supplier_order_batch_datas
    Open Excel    ./datas/017_create_supplier_order_batch.xls
    ${supplier_order_remark}    Read Cell Data By Name    create_supplier_order    A2
    Set Global Variable    ${supplier_order_remark}

get_payable_receivable_datas
    Open Excel    ./datas/018_payable_receivable.xls
    ${payable_fundProvider}    Read Cell Data By Name    confirm_payable    A2
    ${payable_remark}    Read Cell Data By Name    confirm_payable    B2
    Set Global Variable    ${payable_fundProvider}
    Set Global Variable    ${payable_remark}
    ${receivable_remark}    Read Cell Data By Name    confirm_receivable    A2
    Set Global Variable    ${receivable_remark}