(function(){
var msg="";
var flag = true;
var WebUser = getWebUser();
var Userid = WebUser.getId();
var doc = getCurrentDocument();
var dept = WebUser.getDefaultDepartment();
var docid = doc.getId();
var starttime = format(getToday(),"yyyy-MM-dd HH:mm:ss");
var number = doc.getItemValueAsString("会议编号");
var sql = "select * from tlk_会议室签到s where item_会议编号 = '"+number+"' and item_用户 = '"+Userid+"'";
var t_count = countBySQL(sql);
if(t_count>0){
msg = "签到失败,你已经签到了";
}else{
var process = getDocumentProcess();
var formProcess = getFormProcess(); //申明表单业务处理类
var newForm = formProcess.doViewByFormName("会议室签到s",getApplication());
var doc1 = process.doNew(newForm,WebUser,createParamsTable());//创建记录
doc1.addStringItem("用户",Userid );
doc1.addStringItem("签到时间",starttime);
doc1.addStringItem("会议编号",number);
process.doCreate(doc1);
msg = "签到成功!";
}
return msg;
})()
|