在做OA表单,如图所示,新增表单时默认带出当前用户信息至前两行栏位,可以点击请假人这边的按钮开窗选择人员,现在无法开窗选择。还有末尾时间计算代码不会写(即用户填写的两段时间间隔几小时?


),求教大神。以下为目前代码:
document.write('<script type="text/javascript" src="../../CustomJsLib/EFGPShareMethod.js"></script>');//for 开窗
//数据库链接
var tDbConn_EFGP = new DataSource("QJD_JIN","SQL0");//表單名;SQL name
var databaseCfgId = "EFGP"; //系統管理員資料來源(DataAccessDefinition)代號
var tDbConn_EFGP = new DataSource("QJD_JIN","SQL0");//表單名;SQL name
function formCreate(){
document.getElementById("txt_tdrq").value = systemDateTime;//申请日期
document.getElementById("txt_tdr0").value = userId;//申请人ID
document.getElementById("txt_tdr1").value = userName;//申请人姓名
document.getElementById("txt_qjr1").value = userId;//申请人ID
document.getElementById("txt_qjr2").value = userName;//申请人姓名
document.getElementById("txt_qjr3").value = mainOrgUnitIds;//申请部门ID
document.getElementById("txt_qjr4").value = mainOrgUnitNames;//申请部门
return true;
}
function formOpen(){
return true;
}
function formSave(){
return true;
}
function formClose(){
return true;
}
//单选开窗
function bt_qjr_onclick(){
var FileName = "SingleOpenWin";
var sql = " select U.id,U.userName,OU.id,OU.organizationUnitName "+
" from Users U left join Functions F on F.occupantOID = U.OID "+
" left join OrganizationUnit OU on OU.OID = F.organizationUnitOID "+
" inner join Organization O on O.OID = OU.organizationOID "+
" where U.leaveDate is null and F.isMain = 1 and OU.organizationUnitType = 0 ORDER BY U.id";
var SQLClaused = new Array(sql);
var SQLLabel = new Array("申请人代号","申请人姓名","部门代号","部门名称");//客制开窗的Grid Label
var QBEField = new Array("U.id","U.userName","OU.id","OU.organizationUnitName");//模糊查询,須和DB Table栏位名称相同
var QBELabel = new Array("申请人代号","申请人姓名","部门代号","部门名称");//模糊查询的Label
var ReturnId = new Array("txt_qjr1","txt_qjr2","txt_qjr3","txt_qjr4");//表单上的栏位代号
SingleOpenWin(FileName,databaseCfgId, SQLClaused, SQLLabel, QBEField, QBELabel, ReturnId, 720, 430);
}
//$-----Auto generated script block, Please do not edit or modify script below this line.-----$//