PB 数据窗口通用双击复制代码

最新推荐文章于 2024-08-15 09:51:27 发布

原创最新推荐文章于 2024-08-15 09:51:27 发布 · 1.5k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#date

本文介绍了一种用于在表格中批量填充不同类型数据（如字符串、数值、日期等）的脚本实现方法。该脚本通过判断列的数据类型来决定如何进行填充操作。

string ls_dwo,ls_value
double ldb_value
integer li_i,li_count
datetime ld_value
if pos(upper(this.describe( dwo.name +".Coltype")) ,"CHAR") > 0   then
this.accepttext()
ls_dwo = dwo.name
li_count = this.rowcount()
ls_value = this.getitemstring(row,ls_dwo)
for li_i = row to li_count
  this.setitem(li_i,ls_dwo,ls_value)
next
this.accepttext()
END IF
if pos(upper(this.describe( dwo.name +".Coltype")) ,"NUMBER") > 0 or pos(upper(this.describe( dwo.name +".Coltype")) ,"DECIMAL") > 0 then
this.accepttext()
ls_dwo = dwo.name
li_count = this.rowcount()
ldb_value = this.getitemnumber(row,ls_dwo)
for li_i = row to li_count
  this.setitem(li_i,ls_dwo,ldb_value)
next
this.accepttext()
end if
if pos(upper(this.describe( dwo.name +".Coltype")) ,"DATE") > 0   then
this.accepttext()
ls_dwo = dwo.name
li_count = this.rowcount()
ld_value = this.getitemdatetime (row,ls_dwo)
for li_i = row to li_count
  this.setitem(li_i,ls_dwo,ld_value)
next
this.accepttext()
end if