|
|
明明知道语法和构成有错 却不会改...囧......只好麻烦你们了...
var userid=getItemValueAsString("userID");
var dates=getItemValueAsString("dates");
var totime=getItemValueAsString("totime");
var tostates=getItemValueAsString("tostates");
var toresult = getItemValueAsString("toresult");
var longtime="";
if(toresult=="3" && tostates=="3"){
longtime=totime -"9:00:00";
var doc = getCurrentDocument();
var sql = "insert into tlk_旷工表(userID,dates,totime,tostates,longtime,) ";
sql +=" values(‘"+doc.getItemValue("userID")+"’,’ ";
sql +=doc.getItemValue("dates")+"’, ";
sql +=doc.getItemValue("totime")+"’, ";
sql +=doc.getItemValue("tostates")+"’, ";
sql +=longtime+")";
insertByDSName("旷工表",sql);
} |
|