ICOSO部分代码 DB2数据库

2009-10-23 09:38:39 TEST Select UserID,UserName,UserPassword,deptrelationList from sysusertbl where UserAccount ='chendanni' and XMLEXISTS('$DEPTRELATIONLIST/ArrayOfDepartmentRelation/DepartmentRelation[DepartmentID=8]') 2009-10-23 09:38:51 TEST SELECT "COMPANYBRIEF","COMPANYID","COMPANYNAME","CREATETIME","LOGO","MODIFYTIME","OPERATOR","OPERATORID" FROM "COMPANYTBL" WHERE COMPANYID = @COMPANYID Parameters: @COMPANYID[Int32] = 1 2009-10-23 09:42:44 TEST SELECT "COMPANYBRIEF","COMPANYID","COMPANYNAME","CREATETIME","LOGO","MODIFYTIME","OPERATOR","OPERATORID" FROM "COMPANYTBL" WHERE COMPANYID = @COMPANYID Parameters: @COMPANYID[Int32] = 1 2009-10-23 09:43:11 TEST SELECT "COMPANYBRIEF","COMPANYID","COMPANYNAME","CREATETIME","LOGO","MODIFYTIME","OPERATOR","OPERATORID" FROM "COMPANYTBL" WHERE COMPANYID = @COMPANYID Parameters: @COMPANYID[Int32] = 1 2009-10-23 09:52:34 TEST SELECT "COMPANYBRIEF","COMPANYID","COMPANYNAME","CREATETIME","LOGO","MODIFYTIME","OPERATOR","OPERATORID" FROM "COMPANYTBL" WHERE COMPANYID = @COMPANYID Parameters: @COMPANYID[Int32] = 1 2009-10-23 09:53:08 TEST SELECT "COMPANYBRIEF","COMPANYID","COMPANYNAME","CREATETIME","LOGO","MODIFYTIME","OPERATOR","OPERATORID" FROM "COMPANYTBL" WHERE COMPANYID = @COMPANYID Parameters: @COMPANYID[Int32] = 1 2009-10-23 09:53:09 TEST SELECT "COMPANYBRIEF","COMPANYID","COMPANYNAME","CREATETIME","LOGO","MODIFYTIME","OPERATOR","OPERATORID" FROM "COMPANYTBL" WHERE COMPANYID = @COMPANYID Parameters: @COMPANYID[Int32] = 1 2009-10-23 09:53:10 TEST SELECT "COMPANYBRIEF","COMPANYID","COMPANYNAME","CREATETIME","LOGO","MODIFYTIME","OPERATOR","OPERATORID" FROM "COMPANYTBL" WHERE COMPANYID = @COMPANYID Parameters: @COMPANYID[Int32] = 1 2009-10-23 10:03:49 TEST SELECT "ID","PID","TITLE","CMDID","OPTTYPEID","FIELDS","HELP","EXAMPLE","TEMPLATEID","CREATETIME","MODIFYTIME","STATE" FROM "TB_COMMAND" WHERE OptTypeID=196608 and STATE>0 and pid in (select id from tb_command where (OptTypeID!=196608 and STATE>0) or pid=-1) 2009-10-23 10:03:51 TEST SELECT "ID","PID","TITLE","CMDID","OPTTYPEID","FIELDS","HELP","EXAMPLE","TEMPLATEID","CREATETIME","MODIFYTIME","STATE" FROM "TB_COMMAND" WHERE STATE>0 and PID=36 2009-10-23 10:03:51 TEST SELECT "ID","PID","TITLE","CMDID","OPTTYPEID","FIELDS","HELP","EXAMPLE","TEMPLATEID","CREATETIME","MODIFYTIME","STATE" FROM "TB_COMMAND" WHERE STATE>0 and PID=37 2009-10-23 10:03:52 TEST SELECT "ID","PID","TITLE","CMDID","OPTTYPEID","FIELDS","HELP","EXAMPLE","TEMPLATEID","CREATETIME","MODIFYTIME","STATE" FROM "TB_COMMAND" WHERE OptTypeID=131072 and STATE>0 and pid in (select id from tb_command where (OptTypeID!=131072 and STATE>0) or pid=-1) 2009-10-23 10:03:53 TEST SELECT "ID","PID","TITLE","CMDID","OPTTYPEID","FIELDS","HELP","EXAMPLE","TEMPLATEID","CREATETIME","MODIFYTIME","STATE" FROM "TB_COMMAND" WHERE STATE>0 and PID=1532 2009-10-23 10:03:54 TEST SELECT "ID","PID","TITLE","CMDID","OPTTYPEID","FIELDS","HELP","EXAMPLE","TEMPLATEID","CREATETIME","MODIFYTIME","STATE" FROM "TB_COMMAND" WHERE STATE>0 and PID=1533 2009-10-23 10:03:54 TEST select ParamName,ValueInt from TB_GLOBALINFO where ParamName='OperationOfMaxCode' 2009-10-23 10:03:54 TEST UPDATE "TB_GLOBALINFO" SET "PARAMDESC" = @PARAMDESC, "PARAMNAME" = @PARAMNAME, "PARAMTYPE" = @PARAMTYPE, "VALUEDATE" = @VALUEDATE, "VALUEINT" = @VALUEINT, "VALUESTRING" = @VALUESTRING, "VALUEXML" = @VALUEXML WHERE GLOBALID = @GLOBALID Parameters: @PARAMDESC[String] = @PARAMNAME[String] = OperationOfMaxCode @PARAMTYPE[String] = @VALUEDATE[String] = @VALUEINT[Int32] = 557 @VALUESTRING[String] = @VALUEXML[String] = @GLOBALID[Int32] = 0 2009-10-23 10:03:54 TEST SELECT "ID","PID","TITLE","CMDID","OPTTYPEID","FIELDS","HELP","EXAMPLE","TEMPLATEID","CREATETIME","MODIFYTIME","STATE" FROM "TB_COMMAND" WHERE cmdid=50462723 2009-10-23 10:03:54 TEST SELECT "ID","PID","TITLE","CMDID","OPTTYPEID","FIELDS","HELP","EXAMPLE","TEMPLATEID","CREATETIME","MODIFYTIME","STATE" FROM "TB_COMMAND" WHERE id=1532 2009-10-23 10:03:54 TEST SELECT "ID","PID","TITLE","CMDID","OPTTYPEID","FIELDS","HELP","EXAMPLE","TEMPLATEID","CREATETIME","MODIFYTIME","STATE" FROM "TB_COMMAND" WHERE id=1531 2009-10-23 10:03:54 TEST SELECT "ID","PID","TITLE","CMDID","OPTTYPEID","FIELDS","HELP","EXAMPLE","TEMPLATEID","CREATETIME","MODIFYTIME","STATE" FROM "TB_COMMAND" WHERE id=-1 2009-10-23 10:03:55 TEST SELECT "ID","PID","TITLE","CMDID","OPTTYPEID","FIELDS","HELP","EXAMPLE","TEMPLATEID","CREATETIME","MODIFYTIME","STATE" FROM "TB_COMMAND" WHERE CmdID=50462723 2009-10-23 10:03:55 TEST SELECT "TEMPLATEID","TYPEID","TEMPLATENAME","TEMPLATECONTENT","DESCRIPTION","CREATOR","CREATETIME","MODIFYTIME","KEYWORDS" FROM "TEMPLATETBL" WHERE TemplateID = @TemplateID Parameters: @TemplateID[Int32] = 1 2009-10-23 10:13:43 TEST SELECT "COMPANYBRIEF","COMPANYID","COMPANYNAME","CREATETIME","LOGO","MODIFYTIME","OPERATOR","OPERATORID" FROM "COMPANYTBL" WHERE COMPANYID = @COMPANYID Parameters: @COMPANYID[Int32] = 1 2009-10-23 10:14:11 TEST SELECT "COMPANYBRIEF","COMPANYID","COMPANYNAME","CREATETIME","LOGO","MODIFYTIME","OPERATOR","OPERATORID" FROM "COMPANYTBL" WHERE COMPANYID = @COMPANYID Parameters: @COMPANYID[Int32] = 1 2009-10-23 10:14:46 TEST SELECT "COMPANYBRIEF","COMPANYID","COMPANYNAME","CREATETIME","LOGO","MODIFYTIME","OPERATOR","OPERATORID" FROM "COMPANYTBL" WHERE COMPANYID = @COMPANYID Parameters: @COMPANYID[Int32] = 1 2009-10-23 10:18:13 TEST SELECT "COMPANYBRIEF","COMPANYID","COMPANYNAME","CREATETIME","LOGO","MODIFYTIME","OPERATOR","OPERATORID" FROM "COMPANYTBL" WHERE COMPANYID = @COMPANYID Parameters: @COMPANYID[Int32] = 1 2009-10-23 10:18:59 TEST SELECT "COMPANYBRIEF","COMPANYID","COMPANYNAME","CREATETIME","LOGO","MODIFYTIME","OPERATOR","OPERATORID" FROM "COMPANYTBL" WHERE COMPANYID = @COMPANYID Parameters: @COMPANYID[Int32] = 1 2009-10-23 10:19:49 TEST SELECT "COMPANYBRIEF","COMPANYID","COMPANYNAME","CREATETIME","LOGO","MODIFYTIME","OPERATOR","OPERATORID" FROM "COMPANYTBL" WHERE COMPANYID = @COMPANYID Parameters: @COMPANYID[Int32] = 1 2009-10-23 10:20:41 TEST SELECT "COMPANYBRIEF","COMPANYID","COMPANYNAME","CREATETIME","LOGO","MODIFYTIME","OPERATOR","OPERATORID" FROM "COMPANYTBL" WHERE COMPANYID = @COMPANYID Parameters: @COMPANYID[Int32] = 1 2009-10-23 10:21:20 TEST SELECT "ID","PID","TITLE","CMDID","OPTTYPEID","FIELDS","HELP","EXAMPLE","TEMPLATEID","CREATETIME","MODIFYTIME","STATE" FROM "TB_COMMAND" WHERE OptTypeID=196608 and STATE>0 and pid in (select id from tb_command where (OptTypeID!=196608 and STATE>0) or pid=-1) 2009-10-23 10:21:22 TEST select ID,title from tb_command where OptTypeID=196608 and STATE>0 and pid in (select id from tb_command where (OptTypeID!=196608 and STATE>0) or pid=-1) 2009-10-23 10:21:22 select ID,PID,TITLE,CMDID,ShowOrder,OptTypeID from tb_command where OptTypeID=196608 and STATE>0 order by ShowOrder 2009-10-23 10:21:24 TEST select ID,title from tb_command where OptTypeID=131072 and STATE>0 and pid in (select id from tb_command where (OptTypeID!=131072 and STATE>0) or pid=-1) 2009-10-23 10:21:24 select ID,PID,TITLE,CMDID,ShowOrder,OptTypeID from tb_command where OptTypeID=131072 and STATE>0 order by ShowOrder 2009-10-23 10:21:25 TEST select ParamName,ValueInt from TB_GLOBALINFO where ParamName='OperationOfMaxCode' 2009-10-23 10:21:26 TEST UPDATE "TB_GLOBALINFO" SET "PARAMDESC" = @PARAMDESC, "PARAMNAME" = @PARAMNAME, "PARAMTYPE" = @PARAMTYPE, "VALUEDATE" = @VALUEDATE, "VALUEINT" = @VALUEINT, "VALUESTRING" = @VALUESTRING, "VALUEXML" = @VALUEXML WHERE GLOBALID = @GLOBALID Parameters: @PARAMDESC[String] = @PARAMNAME[String] = OperationOfMaxCode @PARAMTYPE[String] = @VALUEDATE[String] = @VALUEINT[Int32] = 558 @VALUESTRING[String] = @VALUEXML[String] = @GLOBALID[Int32] = 0 2009-10-23 10:21:26 TEST SELECT "ID","PID","TITLE","CMDID","OPTTYPEID","FIELDS","HELP","EXAMPLE","TEMPLATEID","CREATETIME","M