jay16

=Navigating=
    visit('/projects')
    visit(post_comments_path(post))

=Clicking links and buttons=
    click_link('id-of-link')
    click_link('Link Text')
    click_button('Save')
    click('Link Text') # Click either a link or a button
    click('Button Value')

jay16

@echo off

@rem set login=wss
@rem set password=123456
@rem set reldb_server="192.168.0.168"


@rem commom parameter
set reportdb="Report_DB_Name"
set contentdb_server="DB_Server"

jay16

require 'goto'


def test
  frame_start

  label(:start) { goto :b }
  label(:a) { print "world!\n"; goto :c }
  label(:b) { print "hello "; goto :a }

jay16

#!/usr/bin/env bash
set -e
# 
# filename prefix
#     fs_|ft_ : function return string or table
#     p_      : procedure
#     t_      : table
#     dt_     : table data
#     check_  : check create sql data with selct
#     task_   : timing task

jay16

    declare @tableName nvarchar(max)
    set @tableName = 'project';

    -- 递归遍历出@tableName外键链

    with
       cte_fk (fk_name, referenced, parent, fk_level)
     as (
       select
        name as fk_name,

jay16

    declare @tableName nvarchar(max)
    set @tableName = 'project';

    -- 递归遍历出@tableName外键链
    with 
        cte_fk (fk_name, referenced, parent, referenced_item, parent_item, fk_level)
    as (
        select 
            fk.name as fk_name
            ,object_name(fk.referenced_object_id) as referenced

jay16

 WITH CTE_FKCols
    AS (
        SELECT FK.NAME
            ,'[' + STUFF((
                    SELECT ','
                        ,object_name(Col.object_id) + '.' + col.NAME
                    FROM sys.foreign_key_columns C
                    INNER JOIN sys.columns Col ON Col.object_id = c.referenced_object_id
                        AND col.column_id = c.referenced_column_id

jay16

Sub ExcelPrint
	Call exportToExcel_ALL()
End Sub 
Public Function exportToExcel_ALL()
Dim aryExport(14,3)

aryExport(0,0) = "CH57"
aryExport(0,1) = "直营业绩周报表"
aryExport(0,2) = "A1" 				
aryExport(0,3) = "data"

jay16

Sub JiuZheng
  set chart = ActiveDocument.GetSheetObject("CH86")
  set notify = ActiveDocument.GetSheetObject("TX06")
  'notify.setLabel = "hello"
  Call chart.GetSheet().Activate()
 
  ''chart.Maximize
  ActiveDocument.GetApplication.WaitForIdle
			
 

jay16

histogram = new Highcharts.Chart( {
    chart: { 
      renderTo: 'histogram', defaultSeriesType: 'bar',
           backgroundColor:'rgba(255, 255, 255, 0.1)'
})