各单据列表经常要用来查询不同日期段的数据,每次查询都要手工设置日期段,官方暂时没有设置类似报表类的日期段选择控件,所以临时用脚本来添加,希望官方能更新这个日期段选择控件(或请哪位大神指导添加二级控件,这样就不用横排所有日期段控件了)。 F3打开单据列表,打开脚本定义添加脚本: int init_win() { call_str('call_prog.date period');//打开单据列表时执行date period脚本自动添加日期段控件 return 1; }; 把下列脚本另存为 date period 或把附件脚本下载后导入到系统 (每个单据列表都可以在脚本定义里添加 call_str('call_prog.date period');来调用) int JinTian() { gui_set_val("DateTimePicker_Voucher_Date_Beg",get_cur_date_std()); gui_set_val("DateTimePicker_Voucher_Date_End",get_cur_date_std()); gui_trigger_click("SpeedButton_Refresh"); return 1; }; int ZuoTian() { gui_set_val("DateTimePicker_Voucher_Date_Beg",get_last_date(get_cur_date_std())); gui_set_val("DateTimePicker_Voucher_Date_End",get_last_date(get_cur_date_std())); gui_trigger_click("SpeedButton_Refresh"); return 1; }; int Zjz() { gui_set_val("DateTimePicker_Voucher_Date_Beg",get_last_date(date_add(get_cur_date_std(),-6))); gui_set_val("DateTimePicker_Voucher_Date_End",get_cur_date_std()); gui_trigger_click("SpeedButton_Refresh"); return 1; }; int Zj30t() { gui_set_val("DateTimePicker_Voucher_Date_Beg",get_last_date(date_add(get_cur_date_std(),-29))); gui_set_val("DateTimePicker_Voucher_Date_End",get_cur_date_std()); gui_trigger_click("SpeedButton_Refresh"); return 1; }; int Zj60t() { gui_set_val("DateTimePicker_Voucher_Date_Beg",get_last_date(date_add(get_cur_date_std(),-59))); gui_set_val("DateTimePicker_Voucher_Date_End",get_cur_date_std()); gui_trigger_click("SpeedButton_Refresh"); return 1; }; int Zj90t() { gui_set_val("DateTimePicker_Voucher_Date_Beg",get_last_date(date_add(get_cur_date_std(),-89))); gui_set_val("DateTimePicker_Voucher_Date_End",get_cur_date_std()); gui_trigger_click("SpeedButton_Refresh"); return 1; }; int Zjn() { gui_set_val("DateTimePicker_Voucher_Date_Beg",get_last_date(date_add(get_cur_date_std(),-364))); gui_set_val("DateTimePicker_Voucher_Date_End",get_cur_date_std()); gui_trigger_click("SpeedButton_Refresh"); return 1; }; int BenYue() { string byc,bym, byc = get_cur_month()+'01' bym = get_cur_month()+get_month_days(get_cur_month()) gui_set_val("DateTimePicker_Voucher_Date_Beg",byc); gui_set_val("DateTimePicker_Voucher_Date_End",bym); gui_trigger_click("SpeedButton_Refresh"); return 1; }; int ShangYue() { num byc,bym, byc = get_cur_month()-1+'01' bym = get_cur_month()-1+get_month_days(get_cur_month()-1) gui_set_val("DateTimePicker_Voucher_Date_Beg",byc); gui_set_val("DateTimePicker_Voucher_Date_End",bym); gui_trigger_click("SpeedButton_Refresh"); return 1; }; int BenNian() { string bnc,bnm, bnc = get_cur_year()+'0101' bnm = get_cur_year()+'1231' gui_set_val("DateTimePicker_Voucher_Date_Beg",bnc); gui_set_val("DateTimePicker_Voucher_Date_End",bnm); gui_trigger_click("SpeedButton_Refresh"); return 1; }; int ShangNian() { num snc,snm, snc = get_cur_year()-1+'0101' snm = get_cur_year()-1+'1231' gui_set_val("DateTimePicker_Voucher_Date_Beg",snc); gui_set_val("DateTimePicker_Voucher_Date_End",snm); gui_trigger_click("SpeedButton_Refresh"); return 1; }; int ZuiZao() { gui_set_val("DateTimePicker_Voucher_Date_Beg",19000101); gui_set_val("DateTimePicker_Voucher_Date_End",get_cur_date_std()); gui_trigger_click("SpeedButton_Refresh"); return 1; }; int main() { gui_create_speedbutton("Panel_Func","JinTian",760,0,25,30,"今天","call_prog.date period.JinTian"); gui_create_speedbutton("Panel_Func","ZuoTian",790,0,25,30,"昨天","call_prog.date period.ZuoTian"); gui_create_speedbutton("Panel_Func","Zjz",820,0,50,30,"最近一周","call_prog.date period.Zjz"); gui_create_speedbutton("Panel_Func","Zj30t",875,0,50,30,"最近30天","call_prog.date period.Zj30t"); gui_create_speedbutton("Panel_Func","Zj60t",930,0,50,30,"最近60天","call_prog.date period.Zj60t"); gui_create_speedbutton("Panel_Func","Zj90t",985,0,50,30,"最近90天","call_prog.date period.Zj90t"); gui_create_speedbutton("Panel_Func","Zjn",1040,0,50,30,"最近一年","call_prog.date period.Zjn"); gui_create_speedbutton("Panel_Func","BenYue",1095,0,25,30,"本月","call_prog.date period.BenYue"); gui_create_speedbutton("Panel_Func","ShangYue",1125,0,25,30,"上月","call_prog.date period.ShangYue"); gui_create_speedbutton("Panel_Func","BenNian",1155,0,40,30,"本年度","call_prog.date period.BenNian"); gui_create_speedbutton("Panel_Func","ShangNian",1200,0,50,30,"上一年度","call_prog.date period.ShangNian"); gui_create_speedbutton("Panel_Func","ZuiZao",1255,0,50,30,"最早日期","call_prog.date period.ZuiZao"); return 1; }; |