";
echo "";
echo "| ";
echo "Template > Log Management > Log Source";
echo " | ";
echo "";
//showHelp($helpId);
echo " | ";
echo "
";
echo "";
adjust_title_tail();
adjust_content_head();
echo "
";
$DEBUG = 0;
$keyId = isset($keyId)?$keyId:1;
$dbName = 'OMC_PUB';
$tableName = 'sysLogSourceConf';
$maxLevelNum = 5;
//选择语言版本
if($selectedLanguage == 'eng'){
$nameField=name_2; //语种2
}else{
$nameField=name_1; //语种1(默认语种)
}
//keyId sysTypeNo sysNo subSysNo dataTypeNo isEnable isIncremental preObjId maxRecNumOfBuf maxRecNumOfDay dataDefineTable dataStoreTable menuName
/**************************************删除一条记录***********************************************/
if($delete){
$delSql = "DELETE FROM $tableName WHERE keyId = '$keyId'";
$delResult = mysqli_query($pubConn ,$delSql);
echo mysqli_error($pubConn);
if($delResult){
echo $strDeleteSuccess;
}else{
echo $strDeleteFailure;
}
//插入日志
//缺！！
} //end if($delete)
/*****************************添加,修改记录*******************************************/
if($save){
if($keyId == 'new'){//add
$addSql = "REPLACE INTO $tableName
(keyId,sysTypeNo,sysNo,subSysNo,dataTypeNo,isEnable,isIncremental,
preObjId,maxSizeOfRec,maxRecNumOfBuf,maxRecNumOfDay,dataStoreTable,menuName)
VALUES
('$keyId','$sysTypeNo','$sysNo','$subSysNo','$dataTypeNo','$isEnable','$isIncremental',
'$preObjId','$maxSizeOfRec','$maxRecNumOfBuf','$maxRecNumOfDay','$dataStoreTable','$menuName')
";
if($DEBUG) echo "
$addSql";
$result = mysqli_query($pubConn ,$addSql);
echo mysqli_error($pubConn);
if($result > 0){
$getKeyIdSql =" SELECT keyId FROM $tableName
WHERE sysTypeNo = '$sysTypeNo'
AND sysNo = '$sysNo' AND subSysNo = '$subSysNo'
AND dataTypeNo='$dataTypeNo'
AND isEnable='$isEnable'
";
if($DEBUG) echo "
$getKeyIdSql";
$result = mysqli_query($pubConn,$getKeyIdSql);
echo mysqli_error($pubConn);
$rows = mysqli_fetch_array($result);
$keyId = $rows[keyId];
echo "
ADD OK";
}else{
echo "
ADD Failed";
}
}else{//update
$updateSql = "UPDATE $tableName SET
sysTypeNo='$sysTypeNo',sysNo = '$sysNo',subSysNo = '$subSysNo',
dataTypeNo='$dataTypeNo',isEnable='$isEnable',preObjId='$preObjId',
maxSizeOfRec = '$maxSizeOfRec',
maxRecNumOfBuf='$maxRecNumOfBuf',maxRecNumOfDay='$maxRecNumOfDay',
dataStoreTable='$dataStoreTable',menuName='$menuName'
WHERE keyId = '$keyId'";
if($DEBUG) echo "
updateSql = $updateSql";
$updateResult = mysqli_query($pubConn,$updateSql);
echo mysqli_error($pubConn);
if($updateResult){
echo "
UPDATE OK";
}else{
echo "
UPDATE Failed";
}
}
}
/*****************************显示一个菜单的定义*****************************/
?>