/**
* @desc 对象类具备的增加的基本功能,作为到数据库的转换接口
*
* @param String $TableName 表格名称
* @param Array $res N1/N2
* @return BOOLEAN
*/
function copyRow($TableName, $res)
{
// echo "app_add";
// var_dump($res);
// if (isset($_SESSION['user']['company_data']['company_name']))
// {
// $system_gongsi = $_SESSION['user']['company_data']['company_name'];
// } else
// {
// $system_gongsi = SYSTEM_GONGSI;
// }
if ($TableName == null) {
return false;
} else {
$sql = 'INSERT INTO ' . $TableName;
}
if (is_array($res)) {
$sqlKeys = null;
$sqlVals = null;
foreach ($res as $key => $val) {
if (is_array($val)) {
foreach ($val as $key2 => $val2) {
$sqlKeys .= $key . ',';
$sqlVals .= $val . ',';
}
$sqlKeys = BaseOption::subStringByDescCount($sqlKeys);
$sqlVals = BaseOption::subStringByDescCount($sqlVals);
$sqls = $sql . " (" . $sqlKeys . ") VALUES (" . $sqlVals . ")";
if ($this->_query($sqls)) {
unset($sqlKeys);
unset($sqlVals);
unset($sqls);
}
} else {
$sqlKeys .= $key . ',';
$sqlVals .= "'" . $val . "',";
}
}
if ($sqlKeys != null && $sqlVals != null) {
$sqlKeys = BaseOption::subStringByDescCount($sqlKeys);
$sqlVals = BaseOption::subStringByDescCount($sqlVals);
/**
* 添加默认值
*/
/*if (!array_key_exists('system_gongsi', $res))
{
$sqlKeys .= ',system_gongsi';
$sqlVals .= ",'".$system_gongsi . "'";
}*/
$sqls = $sql . " (" . $sqlKeys . ") VALUES (" . $sqlVals . ")";
if ($this->execute($sqls)) {
return true;
} else {
return false;
}
} else {
return false;
}
} else {
return false;
}
}
