4. 添加这段脚本,把它放在保存脚本里面运行,这样在保存单据的时候就会给当前星期天的列添加黄色背景色 int xq7jc() { //提取表头的年份和月份计算出当月的星期7的号数并将符合条件的列填充黄色背景 string ny,nian,yue,x1,x2,x3,x4,x5,x6,x7,x8,x9,x10,x11,x12,x13,x14,x15,x16,x17,x18,x19,x20,x21,x22,x23,x24,x25,x26,x27,x28,x29,x30,x31,mm; nian = gui_get_val("ext_nianfen"); yue = gui_get_val("ext_yuefen"); ny = nian+yue x1 = get_week_id(ny+'01') x2 = get_week_id(ny+'02') x3 = get_week_id(ny+'03') x4 = get_week_id(ny+'04') x5 = get_week_id(ny+'05') x6 = get_week_id(ny+'06') x7 = get_week_id(ny+'07') x8 = get_week_id(ny+'08') x9 = get_week_id(ny+'09') x10 = get_week_id(ny+'10') x11 = get_week_id(ny+'11') x12 = get_week_id(ny+'12') x13 = get_week_id(ny+'13') x14 = get_week_id(ny+'14') x15 = get_week_id(ny+'15') x16 = get_week_id(ny+'16') x17 = get_week_id(ny+'17') x18 = get_week_id(ny+'18') x19 = get_week_id(ny+'19') x20 = get_week_id(ny+'20') x21= get_week_id(ny+'21') x22= get_week_id(ny+'22') x23= get_week_id(ny+'23') x24= get_week_id(ny+'24') x25= get_week_id(ny+'25') x26= get_week_id(ny+'26') x27= get_week_id(ny+'27') x28= get_week_id(ny+'28') x29= get_week_id(ny+'29') x30= get_week_id(ny+'30') x31= get_week_id(ny+'31') if(x1 == '7'){ mm ="rq"+01; grid_set_col_bgcolor("MG_Item",mm,8454143);}; if(x2 == '7'){ mm ="rq"+02; grid_set_col_bgcolor("MG_Item",mm,8454143);}; if(x3 == '7'){ mm ="rq"+03; grid_set_col_bgcolor("MG_Item",mm,8454143);}; if(x4 == '7'){ mm ="rq"+04; grid_set_col_bgcolor("MG_Item",mm,8454143);}; if(x5 == '7'){ mm ="rq"+05; grid_set_col_bgcolor("MG_Item",mm,8454143);}; if(x6 == '7'){ mm ="rq"+06; grid_set_col_bgcolor("MG_Item",mm,8454143);}; if(x7 == '7'){ mm ="rq"+07; grid_set_col_bgcolor("MG_Item",mm,8454143);}; if(x8 == '7'){ mm ="rq"+08; grid_set_col_bgcolor("MG_Item",mm,8454143);}; if(x9 == '7'){ mm ="rq"+09; grid_set_col_bgcolor("MG_Item",mm,8454143);}; if(x10 == '7'){ mm ="rq"+10; grid_set_col_bgcolor("MG_Item",mm,8454143);}; if(x11 == '7'){ mm ="rq"+11; grid_set_col_bgcolor("MG_Item",mm,8454143);}; if(x12 == '7'){ mm ="rq"+12; grid_set_col_bgcolor("MG_Item",mm,8454143);}; if(x13 == '7'){ mm ="rq"+13; grid_set_col_bgcolor("MG_Item",mm,8454143);}; if(x14 == '7'){ mm ="rq"+14; grid_set_col_bgcolor("MG_Item",mm,8454143);}; if(x15 == '7'){ mm ="rq"+15; grid_set_col_bgcolor("MG_Item",mm,8454143);}; if(x16 == '7'){ mm ="rq"+16; grid_set_col_bgcolor("MG_Item",mm,8454143);}; if(x17 == '7'){ mm ="rq"+17; grid_set_col_bgcolor("MG_Item",mm,8454143);}; if(x18 == '7'){ mm ="rq"+18; grid_set_col_bgcolor("MG_Item",mm,8454143);}; if(x19 == '7'){ mm ="rq"+19; grid_set_col_bgcolor("MG_Item",mm,8454143);}; if(x20 == '7'){ mm ="rq"+20; grid_set_col_bgcolor("MG_Item",mm,8454143);}; if(x21 == '7'){ mm ="rq"+21; grid_set_col_bgcolor("MG_Item",mm,8454143);}; if(x22 == '7'){ mm ="rq"+22; grid_set_col_bgcolor("MG_Item",mm,8454143);}; if(x23 == '7'){ mm ="rq"+23; grid_set_col_bgcolor("MG_Item",mm,8454143);}; if(x24 == '7'){ mm ="rq"+24; grid_set_col_bgcolor("MG_Item",mm,8454143);}; if(x25 == '7'){ mm ="rq"+25; grid_set_col_bgcolor("MG_Item",mm,8454143);}; if(x26 == '7'){ mm ="rq"+26; grid_set_col_bgcolor("MG_Item",mm,8454143);}; if(x27 == '7'){ mm ="rq"+27; grid_set_col_bgcolor("MG_Item",mm,8454143);}; if(x28 == '7'){ mm ="rq"+28; grid_set_col_bgcolor("MG_Item",mm,8454143);}; if(x29 == '7'){ mm ="rq"+29; grid_set_col_bgcolor("MG_Item",mm,8454143);}; if(x30 == '7'){ mm ="rq"+30; grid_set_col_bgcolor("MG_Item",mm,8454143);}; if(x31 == '7'){ mm ="rq"+31; grid_set_col_bgcolor("MG_Item",mm,8454143);}; return1; }; |