Method 1:
var I=1;
O_parameter. Fobject.each (
Function (v) {
var empId = v.get ("Femployee");
Lb_logger ("Debug", EmpId);
Lb_sqlexecute ("INSERT into T_zkx_testuser (Id,femployee) VALUES (?,?)", [I,empid]);
i++;
}
);
<%@ Livebos language= ' JavaScript '%>
var fun = Abs_loadbean ("Com.plug.FunctionHelper");
O_parameter. Fobject.each (
Function (v) {
var vid = Fun.utilHelper.getNextID ("T_hr_trainfile");
var empId = v.get ("Femployee");
var OrgID;
var funit;
var rs = lb_sqlresultset ("Select A.orgid orgid,b.funit funit from TUser A, lborganization b where b.id = A.orgid and A.fem p =? ", [EmpId]);
while (Rs.next ()) {
OrgID = rs.getstring ("OrgID");
Funit = rs.getstring ("Funit");
}
Lb_logger ("Debug", "------------------------------------------empid=" +empid);
Lb_sqlexecute ("INSERT into T_hr_trainfile (id,femployee,fdept,funit,ftrainproject) VALUES (?,?)", [Vid,empid,orgid, Funit,v_1.id]);
}
);
Method 2:
Name of the table field: Fobject
var ho = o_parameter.getcolumn ("Fobject");
var temp = Ho.getrecord ();
Temp.beforefirst ();
var i = 1;
while (Temp.next ()) {
var empId = temp.getint ("Femployee");
Lb_sqlexecute ("INSERT into T_zkx_testuser (Id,femployee) VALUES (?,?)", [I,empid]);
i++;
}
33. Table object Record Value method